CommitReceiptHeader

F03B13 Maintain Receipt Header

Major Business Rule

Object Name: B03B0138

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function is used to maintain the Receipt Header (F03B13) table for the Standard Receipts Entry
(P03B102) and Draft Entry (P03B602) applications. The function performs adds and updates to the
database. Deletes, voids, and NSFs are handled through the F03B13 Void/NSF Receipt (B03B0019) function.

Setup Notes and Prerequisites
The Edit Receipt Header (B03B0138) function must be called to validate the transaction before calling
this function to perform the actual database operation.

Special Logic
If currency is on, only one side of the transaction needs to be passed. The function will perform
currency conversion for the other side of the transaction. For example, if the receipt is entered in
foreign mode, only pass the foreign receipt and unapplied amounts.

Technical Specification




Parameters


ItemDescriptionI/OReq?Notes


EV01cTransactionModeIY'A' for add, 'C' for update.


PYIDmnPaymentIDIYMust pass the Payment ID from next 


    numbers for add, the existing Payment 


    ID for update.


CKNUszReceiptNumberIYCustomers check number - reference only


AN8mnCustomerNumberIYCustomer Number


    Required unless a General Ledger 


    receipt.


ALKYszCustomerNumberEdit  Not used in this function.


PYRmnPayorNumberIYRequired unless a General Ledger 


    receipt.


ALKYszPayorNumberEdit  Not used in this function.


DMTJjdDateReceiptIYReceipt Date


DGJjdDateGLIYReceipt G/L Date


VLDTjdDateValueIYReceipt Value Date


ISTRcJEMethodINBlank will be used unless a '1' is 


    passed.


GLCszUnappliedGLOffsetIYUnapplied G/L Offset


AIDszUnappliedAccountIDIYUnapplied G/L account short ID number. 


    Required if amount unapplied is not 


    zero.


CTRYmnCenturyINWill default from the G/L date if not 


    passed.


FYmnFiscalYearINWill default from the G/L date if not 


    passed.


PNmnPeriodNumberINWill default from the G/L date if not 


    passed.


COszCompanyIY


ICUTszBatchTypeIY


ICUmnBatchNumberIY


DICJjdDateBatchIY


PA8mnParentNumberINWill be retrieved from Address Book if 


    not passed.


CKAMmnAmountReceiptIYRequired if currency is off or currency 


    mode is domestic.


AAPmnAmountUnappliedIYRequired if currency is off or currency 


    mode is domestic.


BCRCszBaseCurrencyIYCurrency of the Receipt's Company.


    Required if currency is on.


CRRMcCurrencyModeIY'D' for domestic, 'F' for foreign.


    Required if currency is on.


CRCDszTransactionCurrencyIYReceipt's Currency.


    Required if currency is on.


CRRmnExchangeRateIYReceipt to Base Company Currency 


    exchange rate.


    Required if currency mode is foreign.


FCAMmnAmountForeignReceiptIYRequired if currency mode is foreign.


FAPmnAmountForeignUnappliedIYRequired if currency mode is foreign.


GLBAszBankAccountIDIYBank Account G/L account short ID 


    number.Required if receipt amount is 


    not zero and receipt is not a Draft.


ANIszBankAccountEdit  Not used in this function.


AMcBankAccountModeIYRequired if receipt amount is not zero 


    and receipt is not a Draft.


TYINcReceiptTypeCodeIY


EXRszRemarkIN


RYINcPaymentInstrumentIN


ALPHszCustomerNameINWill be retrieved from Address Book if 


    not passed.


DOCGmnJEDocumentNumberIN


DCTGszJEDocumentTypeIN


KCOGszJEDocumentCompanyIN


CBNKszCustomerBankAccountIN


TNSTszCustomerBankTransitNumbeIN


DDSTcDraftStatusIYRequired if receipt is a Draft.


PIDszProgramIDIY


CRRmnTriangulationRate1RecIY Required if currency mode is foreign &


    rate is triangulated


CRRmnTriangulationRate2RecIYRequired if currency mode is foreign &


    rate is triangulated


CRCMcCurrencyConversionMethdIYRequired if currency mode is foreign & 


    uses the No Inverse Rule


EFTjdTransactionDateRecIYRequired if currency mode is foreign & 


    rate uses the No Inverse or 


    Triangulation rules.


RREFszReceiptReferenceIN





Related Tables


F03B13Receipts Header File





Related Business Functions


B0000027Currency Conversion, Calculate


B0100002F0150 Get Parent Address


B0100039F0101 Get Address Book Description Trigger


B9800100Get Audit Information


X0903F0008 Get Fiscal Year Period Number





Processing


Retrieve currency constant.


If cJEMethod is not equal to '1',


 Set cJEMethod to blank.


If mnCentury, mnFiscalYear, or mnPeriodNumber is equal to zero,


 Call the X0903 function using jdDateGL to load mnCentury,


 mnFiscalYear, and mnPeriodNumber.


If cReceiptTypeCode is not equal to 'G' (General Ledger),


 If mnParentNumber is equal to zero,


  Call the B0100002 function to load mnParentNumber.


  If mnParentNumber is equal to zero,


   Set mnParentNumber equal to mnCustomerNumber.


 If szCustomerName is blank,


  Call the B0100039 function to load szCustomerName.


Open the F03B13 table.


If cTransactionMode is equal to 'C' (update),


 Retrieve existing F03B13 record.


If cTransactionMode is equal to 'A' (add) or the receipt has not


been posted,


 If currency is on and cCurrencyMode is equal to 'F' (foreign),


  If cTransactionMode is equal to 'A' (add),


   Call the B0000027 function to calculate the domestic


   currency amounts.


  Else,


   If the foreign receipt amount has changed,


    Call the B0000027 function to calculate the domestic


    adjustment amount.


    Adjust the domestic currency amounts.


 Else,


  If cTransactionMode is equal to 'C' (update),


   If the domestic receipt amount has changed,


    Adjust the domestic currency amounts.


Load F03B13 fields.


Call the B9800100 function to load audit information.


If cTransactionMode is equal to 'A' (add),


 Insert F03B13 record.


Else,


 Update F03B13 record.


Close F03B13 table.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cTransactionMode	EV01	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes EV01ab cTransactionModeab Iab Yab 'A' for add, 'C' for update. ^
mnPaymentID	PYID	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes PYIDab mnPaymentIDab Iab Yab Must pass the Payment ID from next ab ab ab ab numbers for add, the existing Payment ab ab ab ab ID for update. ^
szReceiptNumber	CKNU	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes CKNUab szReceiptNumberab Iab Yab Customers check number reference only. ^
mnCustomerNumber	AN8	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes AN8ab mnCustomerNumberab Iab Yab Customer Number ab ab ab ab Required unless a General Ledger ab ab ab ab receipt. ^
szCustomerNumberEdit	ALKY	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ALKYab szCustomerNumberEditab Oab ab Used in Edit function. ^
mnPayorNumber	PYR	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes PYRab mnPayorNumberab Iab Yab Required unless a General Ledger ab ab ab ab receipt. ^
szPayorNumberEdit	ALKY	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ALKYab szPayorNumberEditab Oab ab Used in Edit function. ^
jdDateReceipt	DMTJ	JDEDATE	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes DMTJab jdDateReceiptab Iab Yab Receipt Date ^
jdDateGL	DGJ	JDEDATE	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes DGJab jdDateGLab Iab Yab Receipt G/L Date ^
jdDateValue	VLDT	JDEDATE	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes VLDTab jdDateValueab Iab Yab Receipt Value Date ^
cJEMethod	ISTR	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ISTRab cJEMethodab Iab Nab Blank will be used unless a '1' is ab ab ab ab passed. ^
szUnappliedGLOffset	GLC	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes GLCab szUnappliedGLOffsetab Iab Yab Unapplied G/L Offset ^
szUnappliedAccountID	AID	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes AIDab szUnappliedAccountIDab Iab Yab Unapplied G/L account short ID number. ab ab ab ab Required if amount unapplied is not zero. ^
mnCentury	CTRY	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes CTRYab mnCenturyab Iab Nab Will default from the G/L date if not passed. ^
mnFiscalYear	FY	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes FYab mnFiscalYearab Iab Nab Will default from the G/L date if not passed. ^
mnPeriodNumber	PN	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes PNab mnPeriodNumberab Iab Nab Will default from the G/L date if not passed. ^
szCompany	CO	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
szBatchType	ICUT	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
mnBatchNumber	ICU	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
jdDateBatch	DICJ	JDEDATE	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
mnParentNumber	PA8	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes PA8ab mnParentNumberab Iab Nab Will be retrieved from Address Book if not passed. ^
mnAmountReceipt	CKAM	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes CKAMab mnAmountReceiptab Iab Yab Required if currency is off or currency mode is domestic. ^
mnAmountUnapplied	AAP	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes AAPab mnAmountUnappliedab Iab Yab Required if currency is off or currency mode is domestic. ^
szBaseCurrency	BCRC	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes BCRCab szBaseCurrencyab Iab Yab Currency of the Receipt's Company. ab ab ab ab Required if currency is on. ^
cCurrencyMode	CRRM	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes CRRMab cCurrencyModeab Iab Yab 'D' for domestic, 'F' for foreign. ab ab ab ab Required if currency is on. ^
szTransactionCurrency	CRCD	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes CRCDab szTransactionCurrencyab Iab Yab Receipt's Currency. ab ab ab ab Required if currency is on. ^
mnExchangeRate	CRR	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes CRRab mnExchangeRateab Iab Yab Receipt to Base Company Currency ab ab ab ab exchange rate. ab ab ab ab Required if currency mode is foreign. ^
mnAmountForeignReceipt	FCAM	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes FCAMab mnAmountForeignReceiptab Iab Yab Required if currency mode is foreign. ab ^
mnAmountForeignUnapplied	FAP	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes FAPab mnAmountForeignUnappliedab Iab Yab Required if currency mode is foreign. ^
szBankAccountID	GLBA	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes GLBAab szBankAccountIDab Iab Yab Bank Account G/L account short ID ab ab ab ab number.Required if receipt amount is not zero and receipt is not a Draft. ^
szBankAccountEdit	ANI	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ANIab szBankAccountEditab Oab ab Used in Edit function. ^
cBankAccountMode	AM	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes AMab cBankAccountModeab Iab Yab Required if receipt amount is not zero and receipt is not a Draft. ^
cReceiptTypeCode	TYIN	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
szRemark	EXR	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
cPaymentInstrument	RYIN	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
szCustomerName	ALPH	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ALPHab szCustomerNameab Iab Nab Will be retrieved from Address Book if not passed. ^
mnJEDocumentNumber	DOCG	MATH_NUMERIC	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
szJEDocumentType	DCTG	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
szJEDocumentCompany	KCOG	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
szCustomerBankAccount	CBNK	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
szCustomerBankTransitNumber	TNST	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
cDraftStatus	DDST	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes DDSTab cDraftStatusab Iab Yab Required if receipt is a Draft. ^
szProgramID	PID	char	NONE	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
mnTriangulationRate1Rec	CRR	MATH_NUMERIC	OPT	NONE
Itemab Descriptionab I/Oab Req?ab Notes CRRab mnTriangulationRate1Recab Iab Y ab Required if currency mode is foreign & rate is triangulated ^
mnTriangulationRate2Rec	CRR	MATH_NUMERIC	OPT	NONE
Itemab Descriptionab I/Oab Req?ab Notes CRRab mnTriangulationRate2Recab Iab Yab Required if currency mode is foreign & rate is triangulated ^
cCurrencyConversionMethodRec	CRCM	char	OPT	NONE
Itemab Descriptionab I/Oab Req?ab Notes CRCMab cCurrencyConversionMethdab Iab Yab Required if currency mode is foreign & uses the No Inverse Rule ^
jdTransactionDateRec	EFT	JDEDATE	OPT	NONE
Itemab Descriptionab I/Oab Req?ab Notes EFTab jdTransactionDateRecab Iab Yab Required if currency mode is foreign & rate uses the No Inverse or Triangulation rules. ^
szReceiptReference	RREF	char	OPT	NONE
Itemab Descriptionab I/Oab Req?ab Notes ^
cAutoCash	ATCS	char	OPT	NONE
An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the automatic receipt processing programs. On Receipts can be processed automatically for the customer or company. Off Receipts cannot be processed automatically for the customer or company. The option must be activated for both the customer and the company in the Accounts Receivable constants for the system to process automatic receipts.
cUploadedFromTapeBatchEntry	EUFB	char	OPT	NONE
A code that specifies which algorithm to use based on the information provided on the electronic receipt and the execution list specified. Valid values are: 1 The system assigns this value when the electronic receipt will be applied to invoices using the Invoice Selection Match algorithm (R03B50A), the Balance Forward Match algorithm (R03B50B), or the Combination Invoice Match algorithm (R03B50F). 2 The system assigns this value when the electronic receipt will be applied to invoices using the Known Invoice Match Without Amount algorithm (R03B50E). 3 The system assigns this value when the electronic receipt will be applied to invoices using the Known Invoice Match With Amount algorithm (R03B50D).
szClerk	ECLK	char	OPT	NONE
The user ID of the person who ran the Update Receipts Header program (R03B551) or the Draft Remittance program (R03B672].
cAutoReceiptStatusFlag	ASTA	char	OPT	NONE
A code that indicates whether the receipt has been processed successfully. Valid values are: Blank The receipt has not been processed. You can apply the receipt to invoices manually or automatically using the auto receipts process. 1 The receipt has not been processed. You can apply the receipt to invoices only using the auto receipt process. 2 The receipt has been processed unsuccessfully using the auto receipt process. 3 The receipt has been processed successfully using the auto receipt process.
cAllowNegativeReceipt	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnNetTransactionID	NETTCID	MATH_NUMERIC	OPT	NONE
A number that identifies a netting transaction. The system assigns it using the Next Numbers program (P0002). A netting transaction could contain one or more netting documents.
mnNetDocNumber	NETDOC	MATH_NUMERIC	OPT	NONE
A number that the system uses to cross reference netting source documents from which netting transfer and netting result documents are generated. The system assigns it using the Next Numbers program (P0002). Examples of netting source documents are: Accounts Payable o Voucher o Debit Memo Accounts Receivable o Invoice o Credit Memo o Chargeback o Unapplied Cash
cReconciledROrBlank	RCND	char	OPT	INPUT
A code that indicates whether a transaction in the Account Ledger table (F0911) is reconciled. The codes are defined in User Defined Code table under system 09 and code RC. A blank character is defined to be the un-reconciled character. To set up a valid reconciled code make sure the following is done in the User Defined Code table: 1. The special handling code in fold area of the UDC screen must contain a 01. 2. The reconciled code must be only one character long and can be a numeric or alpha character.
szReference3AccountReconci	R3	char	OPT	INPUT
Number that provides an audit trail for specific transactions. Used primarily in the G/L Account Reconciliation program (P09131).

Data Structure

D03B0138 - F03B13 Maintain Receipt Header

ItemDescriptionI/OReq?Notes
EV01cTransactionModeIY'A' for add, 'C' for update.
PYIDmnPaymentIDIYMust pass the Payment ID from next
numbers for add, the existing
                                                Payment
ID for update.
CKNUszReceiptNumberIYCustomers check number  reference
                                                only.
AN8mnCustomerNumberIYCustomer Number
Required unless a General Ledger
receipt.
ALKYszCustomerNumberEditO Used in Edit function.
PYRmnPayorNumberIYRequired unless a General Ledger
receipt.
ALKYszPayorNumberEditO Used in Edit function.
DMTJjdDateReceiptIYReceipt Date
DGJjdDateGLIYReceipt G/L Date
VLDTjdDateValueIYReceipt Value Date
ISTRcJEMethodINBlank will be used unless a '1' is
passed.
GLCszUnappliedGLOffsetIYUnapplied G/L Offset
AIDszUnappliedAccountIDIYUnapplied G/L account short ID
                                                number.
Required if amount unapplied is
                                                not zero.
CTRYmnCenturyINWill default from the G/L date if
                                                not passed.
FYmnFiscalYearINWill default from the G/L date if
                                                not passed.
PNmnPeriodNumberINWill default from the G/L date if
                                                not passed.
COszCompanyIY
ICUTszBatchTypeIY
ICUmnBatchNumberIY
DICJjdDateBatchIY
PA8mnParentNumberINWill be retrieved from Address
                                                Book if not passed.
CKAMmnAmountReceiptIYRequired if currency is off or
                                                currency mode is domestic.
AAPmnAmountUnappliedIYRequired if currency is off or
                                                currency mode is domestic.
BCRCszBaseCurrencyIYCurrency of the Receipt's Company.
Required if currency is on.
CRRMcCurrencyModeIY'D' for domestic, 'F' for foreign.
Required if currency is on.
CRCDszTransactionCurrencyIYReceipt's Currency.
Required if currency is on.
CRRmnExchangeRateIYReceipt to Base Company Currency
exchange rate.
Required if currency mode is
                                                foreign.
FCAMmnAmountForeignReceiptIYRequired if currency mode is
                                                foreign.
FAPmnAmountForeignUnappliedIYRequired if currency mode is
                                                foreign.
GLBAszBankAccountIDIYBank Account G/L account short ID
number.Required if receipt amount
                                                is not zero and receipt is not a
                                                Draft.
ANIszBankAccountEditO Used in Edit function.
AMcBankAccountModeIYRequired if receipt amount is not
                                                zero and receipt is not a Draft.
TYINcReceiptTypeCodeIY
EXRszRemarkIN
RYINcPaymentInstrumentIN
ALPHszCustomerNameINWill be retrieved from Address
                                                Book if not passed.
DOCGmnJEDocumentNumberIN
DCTGszJEDocumentTypeIN
KCOGszJEDocumentCompanyIN
CBNKszCustomerBankAccountIN
TNSTszCustomerBankTransitNumbeIN
DDSTcDraftStatusIYRequired if receipt is a Draft.
PIDszProgramIDIY
CRRmnTriangulationRate1RecIY Required if currency mode is
                                                foreign & rate is triangulated
CRRmnTriangulationRate2RecIYRequired if currency mode is
                                                foreign & rate is triangulated
CRCMcCurrencyConversionMethdIYRequired if currency mode is
                                                foreign & uses the No Inverse Rule
EFTjdTransactionDateRecIYRequired if currency mode is
                                                foreign & rate uses the No Inverse
                                                or Triangulation rules.
RREFszReceiptReference         I    N
ATCS     cAutoCash                  I     N     Pass in the value from the customer master
                                                if the customer can be processed through
                                                Auto Cash.
EUFB     cUploadFromTapeBatchEntry  I     N     Code that indicates how a receipt,
                             uploaded by the Batch


                                 Receipts Upload program, will be
                                                           applied to invoices.
1   Unapplied Receipt
2   Invoices Without Remittance
3   Invoices With Remittance
4   Statements
5   Invoices and Statements
ECLK    szClerk                    I     N      Clerk ID
ASTA    cAutoReceiptStatusFlag     I     N      A code that indicates the status of
                                                                              a receipt. Valid values
are:
                                                Blank   May be applied by either
                                                                                Manual Rweceipts or
Auto Cash
                                                1 May only be applied by Auto

                           Match program
                                                2  Unsuccessfully matched by Auto
                                Match program
                                                3  Successfully matched by Auto
                                                                                  Match program

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

cTransactionMode EV01 char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
EV01ab cTransactionModeab Iab Yab 'A' for add, 'C' for update.

^

mnPaymentID PYID MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PYIDab mnPaymentIDab Iab Yab Must pass the Payment ID from next
ab ab ab ab numbers for add, the existing
                                                Payment
ab ab ab ab ID for update.

^

szReceiptNumber CKNU char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CKNUab szReceiptNumberab Iab Yab Customers check number  reference
                                                only.

^

mnCustomerNumber AN8 MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AN8ab mnCustomerNumberab Iab Yab Customer Number
ab ab ab ab Required unless a General Ledger
ab ab ab ab receipt.

^

szCustomerNumberEdit ALKY char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ALKYab szCustomerNumberEditab Oab ab Used in Edit function.

^

mnPayorNumber PYR MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PYRab mnPayorNumberab Iab Yab Required unless a General Ledger
ab ab ab ab receipt.

^

szPayorNumberEdit ALKY char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ALKYab szPayorNumberEditab Oab ab Used in Edit function.

^

jdDateReceipt DMTJ JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
DMTJab jdDateReceiptab Iab Yab Receipt Date

^

jdDateGL DGJ JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
DGJab jdDateGLab Iab Yab Receipt G/L Date

^

jdDateValue VLDT JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
VLDTab jdDateValueab Iab Yab Receipt Value Date

^

cJEMethod ISTR char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ISTRab cJEMethodab Iab Nab Blank will be used unless a '1' is
ab ab ab ab passed.

^

szUnappliedGLOffset GLC char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
GLCab szUnappliedGLOffsetab Iab Yab Unapplied G/L Offset

^

szUnappliedAccountID AID char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AIDab szUnappliedAccountIDab Iab Yab Unapplied G/L account short ID
                                                number.
ab ab ab ab Required if amount unapplied is
                                                not zero.

^

mnCentury CTRY MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CTRYab mnCenturyab Iab Nab Will default from the G/L date if
                                                not passed.

^

mnFiscalYear FY MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
FYab mnFiscalYearab Iab Nab Will default from the G/L date if
                                                not passed.

^

mnPeriodNumber PN MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PNab mnPeriodNumberab Iab Nab Will default from the G/L date if
                                                not passed.

^

szCompany CO char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szBatchType ICUT char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

mnBatchNumber ICU MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

jdDateBatch DICJ JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

mnParentNumber PA8 MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PA8ab mnParentNumberab Iab Nab Will be retrieved from Address
                                                Book if not passed.

^

mnAmountReceipt CKAM MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CKAMab mnAmountReceiptab Iab Yab Required if currency is off or
                                                currency mode is domestic.

^

mnAmountUnapplied AAP MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AAPab mnAmountUnappliedab Iab Yab Required if currency is off or
                                                currency mode is domestic.

^

szBaseCurrency BCRC char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
BCRCab szBaseCurrencyab Iab Yab Currency of the Receipt's Company.
ab ab ab ab Required if currency is on.

^

cCurrencyMode CRRM char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CRRMab cCurrencyModeab Iab Yab 'D' for domestic, 'F' for foreign.
ab ab ab ab Required if currency is on.

^

szTransactionCurrency CRCD char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CRCDab szTransactionCurrencyab Iab Yab Receipt's Currency.
ab ab ab ab Required if currency is on.

^

mnExchangeRate CRR MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CRRab mnExchangeRateab Iab Yab Receipt to Base Company Currency
ab ab ab ab exchange rate.
ab ab ab ab Required if currency mode is
                                                foreign.

^

mnAmountForeignReceipt FCAM MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
FCAMab mnAmountForeignReceiptab Iab Yab Required if currency mode is
                                                foreign.

ab
^

mnAmountForeignUnapplied FAP MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
FAPab mnAmountForeignUnappliedab Iab Yab Required if currency mode is
                                                foreign.

^

szBankAccountID GLBA char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
GLBAab szBankAccountIDab Iab Yab Bank Account G/L account short ID
ab ab ab ab number.Required if receipt amount
                                                is not zero and receipt is not a
                                                Draft.

^

szBankAccountEdit ANI char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ANIab szBankAccountEditab Oab ab Used in Edit function.

^

cBankAccountMode AM char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AMab cBankAccountModeab Iab Yab Required if receipt amount is not
                                                zero and receipt is not a Draft.

^

cReceiptTypeCode TYIN char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szRemark EXR char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

cPaymentInstrument RYIN char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szCustomerName ALPH char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ALPHab szCustomerNameab Iab Nab Will be retrieved from Address
                                                Book if not passed.

^

mnJEDocumentNumber DOCG MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szJEDocumentType DCTG char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szJEDocumentCompany KCOG char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szCustomerBankAccount CBNK char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szCustomerBankTransitNumber TNST char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

cDraftStatus DDST char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
DDSTab cDraftStatusab Iab Yab Required if receipt is a Draft.

^

szProgramID PID char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

mnTriangulationRate1Rec CRR MATH_NUMERIC OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

CRRab mnTriangulationRate1Recab Iab Y ab Required if currency mode is
                                                foreign & rate is triangulated

^

mnTriangulationRate2Rec CRR MATH_NUMERIC OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

CRRab mnTriangulationRate2Recab Iab Yab Required if currency mode is
                                                foreign & rate is triangulated

^

cCurrencyConversionMethodRec CRCM char OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

CRCMab cCurrencyConversionMethdab Iab Yab Required if currency mode is
                                                foreign & uses the No Inverse Rule

^

jdTransactionDateRec EFT JDEDATE OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes
EFTab jdTransactionDateRecab Iab Yab Required if currency mode is
                                                foreign & rate uses the No Inverse
                                                or Triangulation rules.

^

szReceiptReference RREF char OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

cAutoCash ATCS char OPT NONE

An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the
automatic receipt processing programs. On Receipts can be processed automatically for the customer or company. Off Receipts cannot be
processed automatically for the customer or company. The option must be activated for both the customer and the company in the Accounts
Receivable constants for the system to process automatic receipts.

cUploadedFromTapeBatchEntry EUFB char OPT NONE

A code that specifies which algorithm to use based on the information provided on the electronic receipt and the execution list specified.
Valid values are: 1 The system assigns this value when the electronic receipt will be applied to invoices using the Invoice Selection Match
algorithm (R03B50A), the Balance Forward Match algorithm (R03B50B), or the Combination Invoice Match algorithm (R03B50F). 2 The system
assigns this value when the electronic receipt will be applied to invoices using the Known Invoice Match Without Amount algorithm
(R03B50E). 3 The system assigns this value when the electronic receipt will be applied to invoices using the Known Invoice Match With Amount algorithm
(R03B50D).

szClerk ECLK char OPT NONE

The user ID of the person who ran the Update Receipts Header program (R03B551) or the Draft Remittance program (R03B672].

cAutoReceiptStatusFlag ASTA char OPT NONE

A code that indicates whether the receipt has been processed successfully. Valid values are: Blank The receipt has not been processed.
You can apply the receipt to invoices manually or automatically using the auto receipts process. 1 The receipt has not been processed. You
can apply the receipt to invoices only using the auto receipt process. 2 The receipt has been processed unsuccessfully using the auto receipt
process. 3 The receipt has been processed successfully using the auto receipt process.

cAllowNegativeReceipt EV01 char OPT NONE

An option that specifies the type of processing for an event.

mnNetTransactionID NETTCID MATH_NUMERIC OPT NONE

A number that identifies a netting transaction. The system assigns it using the Next Numbers program (P0002). A netting transaction could
contain one or more netting documents.

mnNetDocNumber NETDOC MATH_NUMERIC OPT NONE

A number that the system uses to cross reference netting source documents from which netting transfer and netting result documents are
generated. The system assigns it using the Next Numbers program (P0002). Examples of  netting source documents are: Accounts Payable   o
Voucher o Debit Memo    Accounts Receivable   o Invoice   o Credit Memo o Chargeback o Unapplied Cash

cReconciledROrBlank RCND char OPT INPUT

A code that indicates whether a transaction in the Account Ledger table (F0911) is reconciled. The codes are defined in User Defined Code
table under system 09 and code RC. A blank character is defined to be the un-reconciled character.  To set up a valid reconciled code
make sure the following is done in the User Defined Code table:    1.   The special handling code in fold area of the UDC screen must contain a
01.    2.   The reconciled code must be only one character long and can be a numeric or alpha character.

szReference3AccountReconci R3 char OPT INPUT

Number that provides an audit trail for specific transactions.  Used primarily in the G/L Account Reconciliation program (P09131).

Related Functions

B0000027 CurrencyConvForAndDom

B0100002 A/B - Get Parent Address

B0100039 Is Address Number in Address Book Master Table

B9800100 Get Audit Information

X0903 Fiscal Date Edits +

Related Tables

F03B13 Receipts Header

EditReceiptHeader
EditReceiptHeader

F03B13 Maintain Receipt Header

Major Business Rule

Object Name: B03B0138

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function is used to edit the receipt header for the Standard Receipts Entry (P03B102) and Draft
Entry (P03B602) applications. If no errors are returned, the receipt is valid. The function does not
perform any database operations. Call the Commit Receipt Header (B03B0138) function to perform adds and
updates to the F03B13 table.

Setup Notes and Prerequisites
None.

Special Logic
None.

Technical Specification

Parameters
ItemDescriptionI/OReq?Notes
EV01cTransactionModeIY'A' for add, 'C' for update.
PYIDmnPaymentIDIYMust pass the Payment ID from next numbers for add,
the existing Payment ID for update.
CKNUszReceiptNumberIY
AN8mnCustomerNumberIYRequired unless a General Ledger receipt.
ALKYszCustomerNumberEditIYIf there is an error on mnCustomerNumber, this field
will be set with that error.
PYRmnPayorNumberIYRequired unless a General Ledger receipt.
ALKYszPayorNumberEditIYIf there is an error on mnPayorNumber, this field
will be set with that error.
DMTJjdDateReceiptIY
DGJjdDateGLIY
VLDTjdDateValueIY
ISTRcJEMethodIN
GLCszUnappliedGLOffsetIY
AIDszUnappliedAccountIDIYRequired if amount unapplied is not zero.
CTRYmnCenturyIN
FYmnFiscalYearIN
PNmnPeriodNumberIN
COszCompanyIY
ICUTszBatchTypeIY
ICUmnBatchNumberIY
DICJjdDateBatchIY
PA8mnParentNumberIN
CKAMmnAmountReceiptIYRequired if currency is off or currency mode is
domestic.
AAPmnAmountUnappliedIYRequired if currency is off or currency mode is
domestic.
BCRCszBaseCurrencyIYRequired if currency is on.
CRRMcCurrencyModeIYRequired if currency is on. 'D' for domestic, 'F'
for foreign.
CRCDszTransactionCurrencyIYRequired if currency is on.
CRRmnExchangeRateIYRequired if currency mode is foreign.
FCAMmnAmountForeignReceiptIYRequired if currency mode is foreign.
FAPmnAmountForeignUnappliedIYRequired if currency mode is foreign.
GLBAszBankAccountIDIYRequired if receipt amount is not zero and receipt
is not a Draft.
ANIszBankAccountEditIYIf there is an error on szBankAccountID, this field
will be set with that error.
AMcBankAccountModeIYRequired if receipt amount is not zero and receipt
is not a Draft.
TYINcReceiptTypeCodeIY
EXRszRemarkIN
RYINcPaymentInstrumentIN
ALPHszCustomerNameIN
DOCGmnJEDocumentNumberIN
DCTGszJEDocumentTypeIN
KCOGszJEDocumentCompanyIN
CBNKszCustomerBankAccountIN
TNSTszCustomerBankTransitNumberIN
DDSTcDraftStatusIYRequired if receipt is a Draft.
PIDszProgramIDIY
CRRmnTriangulationRate1RecIY Required if currency mode is foreign & rate is
triangulated
CRRmnTriangulationRate2RecIY Required if currency mode is foreign & rate is
triangulated
CRCMcCurrencyConversionMethodIYRequired if currency mode is foreign & rate uses the
No Inverse Rule
EFTjdTransactionDateRecIYRequired if currency mode is foreign & rate uses the
No Inverse or Triangulation rules.
RREFszReceiptReferenceIN

Related Tables
None.

Related Business Functions
None.

Processing
Retrieve currency constant.
Perform editing on all required parameters.
If currency is on and cTransactionMode is 'F' (foreign),
Set error on mnAmountForeignUnapplied if it is less than zero.
Else,
Set error on mnAmountUnapplied if it is less than zero.

Data Structure

D03B0138 - F03B13 Maintain Receipt Header

ItemDescriptionI/OReq?Notes
EV01cTransactionModeIY'A' for add, 'C' for update.
PYIDmnPaymentIDIYMust pass the Payment ID from next
numbers for add, the existing
                                                Payment
ID for update.
CKNUszReceiptNumberIYCustomers check number  reference
                                                only.
AN8mnCustomerNumberIYCustomer Number
Required unless a General Ledger
receipt.
ALKYszCustomerNumberEditO Used in Edit function.
PYRmnPayorNumberIYRequired unless a General Ledger
receipt.
ALKYszPayorNumberEditO Used in Edit function.
DMTJjdDateReceiptIYReceipt Date
DGJjdDateGLIYReceipt G/L Date
VLDTjdDateValueIYReceipt Value Date
ISTRcJEMethodINBlank will be used unless a '1' is
passed.
GLCszUnappliedGLOffsetIYUnapplied G/L Offset
AIDszUnappliedAccountIDIYUnapplied G/L account short ID
                                                number.
Required if amount unapplied is
                                                not zero.
CTRYmnCenturyINWill default from the G/L date if
                                                not passed.
FYmnFiscalYearINWill default from the G/L date if
                                                not passed.
PNmnPeriodNumberINWill default from the G/L date if
                                                not passed.
COszCompanyIY
ICUTszBatchTypeIY
ICUmnBatchNumberIY
DICJjdDateBatchIY
PA8mnParentNumberINWill be retrieved from Address
                                                Book if not passed.
CKAMmnAmountReceiptIYRequired if currency is off or
                                                currency mode is domestic.
AAPmnAmountUnappliedIYRequired if currency is off or
                                                currency mode is domestic.
BCRCszBaseCurrencyIYCurrency of the Receipt's Company.
Required if currency is on.
CRRMcCurrencyModeIY'D' for domestic, 'F' for foreign.
Required if currency is on.
CRCDszTransactionCurrencyIYReceipt's Currency.
Required if currency is on.
CRRmnExchangeRateIYReceipt to Base Company Currency
exchange rate.
Required if currency mode is
                                                foreign.
FCAMmnAmountForeignReceiptIYRequired if currency mode is
                                                foreign.
FAPmnAmountForeignUnappliedIYRequired if currency mode is
                                                foreign.
GLBAszBankAccountIDIYBank Account G/L account short ID
number.Required if receipt amount
                                                is not zero and receipt is not a
                                                Draft.
ANIszBankAccountEditO Used in Edit function.
AMcBankAccountModeIYRequired if receipt amount is not
                                                zero and receipt is not a Draft.
TYINcReceiptTypeCodeIY
EXRszRemarkIN
RYINcPaymentInstrumentIN
ALPHszCustomerNameINWill be retrieved from Address
                                                Book if not passed.
DOCGmnJEDocumentNumberIN
DCTGszJEDocumentTypeIN
KCOGszJEDocumentCompanyIN
CBNKszCustomerBankAccountIN
TNSTszCustomerBankTransitNumbeIN
DDSTcDraftStatusIYRequired if receipt is a Draft.
PIDszProgramIDIY
CRRmnTriangulationRate1RecIY Required if currency mode is
                                                foreign & rate is triangulated
CRRmnTriangulationRate2RecIYRequired if currency mode is
                                                foreign & rate is triangulated
CRCMcCurrencyConversionMethdIYRequired if currency mode is
                                                foreign & uses the No Inverse Rule
EFTjdTransactionDateRecIYRequired if currency mode is
                                                foreign & rate uses the No Inverse
                                                or Triangulation rules.
RREFszReceiptReference         I    N
ATCS     cAutoCash                  I     N     Pass in the value from the customer master
                                                if the customer can be processed through
                                                Auto Cash.
EUFB     cUploadFromTapeBatchEntry  I     N     Code that indicates how a receipt,
                             uploaded by the Batch


                                 Receipts Upload program, will be
                                                           applied to invoices.
1   Unapplied Receipt
2   Invoices Without Remittance
3   Invoices With Remittance
4   Statements
5   Invoices and Statements
ECLK    szClerk                    I     N      Clerk ID
ASTA    cAutoReceiptStatusFlag     I     N      A code that indicates the status of
                                                                              a receipt. Valid values
are:
                                                Blank   May be applied by either
                                                                                Manual Rweceipts or
Auto Cash
                                                1 May only be applied by Auto

                           Match program
                                                2  Unsuccessfully matched by Auto
                                Match program
                                                3  Successfully matched by Auto
                                                                                  Match program

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

cTransactionMode EV01 char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
EV01ab cTransactionModeab Iab Yab 'A' for add, 'C' for update.

^

mnPaymentID PYID MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PYIDab mnPaymentIDab Iab Yab Must pass the Payment ID from next
ab ab ab ab numbers for add, the existing
                                                Payment
ab ab ab ab ID for update.

^

szReceiptNumber CKNU char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CKNUab szReceiptNumberab Iab Yab Customers check number  reference
                                                only.

^

mnCustomerNumber AN8 MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AN8ab mnCustomerNumberab Iab Yab Customer Number
ab ab ab ab Required unless a General Ledger
ab ab ab ab receipt.

^

szCustomerNumberEdit ALKY char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ALKYab szCustomerNumberEditab Oab ab Used in Edit function.

^

mnPayorNumber PYR MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PYRab mnPayorNumberab Iab Yab Required unless a General Ledger
ab ab ab ab receipt.

^

szPayorNumberEdit ALKY char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ALKYab szPayorNumberEditab Oab ab Used in Edit function.

^

jdDateReceipt DMTJ JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
DMTJab jdDateReceiptab Iab Yab Receipt Date

^

jdDateGL DGJ JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
DGJab jdDateGLab Iab Yab Receipt G/L Date

^

jdDateValue VLDT JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
VLDTab jdDateValueab Iab Yab Receipt Value Date

^

cJEMethod ISTR char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ISTRab cJEMethodab Iab Nab Blank will be used unless a '1' is
ab ab ab ab passed.

^

szUnappliedGLOffset GLC char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
GLCab szUnappliedGLOffsetab Iab Yab Unapplied G/L Offset

^

szUnappliedAccountID AID char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AIDab szUnappliedAccountIDab Iab Yab Unapplied G/L account short ID
                                                number.
ab ab ab ab Required if amount unapplied is
                                                not zero.

^

mnCentury CTRY MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CTRYab mnCenturyab Iab Nab Will default from the G/L date if
                                                not passed.

^

mnFiscalYear FY MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
FYab mnFiscalYearab Iab Nab Will default from the G/L date if
                                                not passed.

^

mnPeriodNumber PN MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PNab mnPeriodNumberab Iab Nab Will default from the G/L date if
                                                not passed.

^

szCompany CO char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szBatchType ICUT char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

mnBatchNumber ICU MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

jdDateBatch DICJ JDEDATE NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

mnParentNumber PA8 MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
PA8ab mnParentNumberab Iab Nab Will be retrieved from Address
                                                Book if not passed.

^

mnAmountReceipt CKAM MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CKAMab mnAmountReceiptab Iab Yab Required if currency is off or
                                                currency mode is domestic.

^

mnAmountUnapplied AAP MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AAPab mnAmountUnappliedab Iab Yab Required if currency is off or
                                                currency mode is domestic.

^

szBaseCurrency BCRC char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
BCRCab szBaseCurrencyab Iab Yab Currency of the Receipt's Company.
ab ab ab ab Required if currency is on.

^

cCurrencyMode CRRM char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CRRMab cCurrencyModeab Iab Yab 'D' for domestic, 'F' for foreign.
ab ab ab ab Required if currency is on.

^

szTransactionCurrency CRCD char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CRCDab szTransactionCurrencyab Iab Yab Receipt's Currency.
ab ab ab ab Required if currency is on.

^

mnExchangeRate CRR MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
CRRab mnExchangeRateab Iab Yab Receipt to Base Company Currency
ab ab ab ab exchange rate.
ab ab ab ab Required if currency mode is
                                                foreign.

^

mnAmountForeignReceipt FCAM MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
FCAMab mnAmountForeignReceiptab Iab Yab Required if currency mode is
                                                foreign.

ab
^

mnAmountForeignUnapplied FAP MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
FAPab mnAmountForeignUnappliedab Iab Yab Required if currency mode is
                                                foreign.

^

szBankAccountID GLBA char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
GLBAab szBankAccountIDab Iab Yab Bank Account G/L account short ID
ab ab ab ab number.Required if receipt amount
                                                is not zero and receipt is not a
                                                Draft.

^

szBankAccountEdit ANI char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ANIab szBankAccountEditab Oab ab Used in Edit function.

^

cBankAccountMode AM char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
AMab cBankAccountModeab Iab Yab Required if receipt amount is not
                                                zero and receipt is not a Draft.

^

cReceiptTypeCode TYIN char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szRemark EXR char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

cPaymentInstrument RYIN char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szCustomerName ALPH char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
ALPHab szCustomerNameab Iab Nab Will be retrieved from Address
                                                Book if not passed.

^

mnJEDocumentNumber DOCG MATH_NUMERIC NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szJEDocumentType DCTG char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szJEDocumentCompany KCOG char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szCustomerBankAccount CBNK char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

szCustomerBankTransitNumber TNST char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

cDraftStatus DDST char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes
DDSTab cDraftStatusab Iab Yab Required if receipt is a Draft.

^

szProgramID PID char NONE NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

mnTriangulationRate1Rec CRR MATH_NUMERIC OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

CRRab mnTriangulationRate1Recab Iab Y ab Required if currency mode is
                                                foreign & rate is triangulated

^

mnTriangulationRate2Rec CRR MATH_NUMERIC OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

CRRab mnTriangulationRate2Recab Iab Yab Required if currency mode is
                                                foreign & rate is triangulated

^

cCurrencyConversionMethodRec CRCM char OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

CRCMab cCurrencyConversionMethdab Iab Yab Required if currency mode is
                                                foreign & uses the No Inverse Rule

^

jdTransactionDateRec EFT JDEDATE OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes
EFTab jdTransactionDateRecab Iab Yab Required if currency mode is
                                                foreign & rate uses the No Inverse
                                                or Triangulation rules.

^

szReceiptReference RREF char OPT NONE

Itemab Descriptionab I/Oab Req?ab Notes

^

cAutoCash ATCS char OPT NONE

An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the
automatic receipt processing programs. On Receipts can be processed automatically for the customer or company. Off Receipts cannot be
processed automatically for the customer or company. The option must be activated for both the customer and the company in the Accounts
Receivable constants for the system to process automatic receipts.

cUploadedFromTapeBatchEntry EUFB char OPT NONE

A code that specifies which algorithm to use based on the information provided on the electronic receipt and the execution list specified.
Valid values are: 1 The system assigns this value when the electronic receipt will be applied to invoices using the Invoice Selection Match
algorithm (R03B50A), the Balance Forward Match algorithm (R03B50B), or the Combination Invoice Match algorithm (R03B50F). 2 The system
assigns this value when the electronic receipt will be applied to invoices using the Known Invoice Match Without Amount algorithm
(R03B50E). 3 The system assigns this value when the electronic receipt will be applied to invoices using the Known Invoice Match With Amount algorithm
(R03B50D).

szClerk ECLK char OPT NONE

The user ID of the person who ran the Update Receipts Header program (R03B551) or the Draft Remittance program (R03B672].

cAutoReceiptStatusFlag ASTA char OPT NONE

A code that indicates whether the receipt has been processed successfully. Valid values are: Blank The receipt has not been processed.
You can apply the receipt to invoices manually or automatically using the auto receipts process. 1 The receipt has not been processed. You
can apply the receipt to invoices only using the auto receipt process. 2 The receipt has been processed unsuccessfully using the auto receipt
process. 3 The receipt has been processed successfully using the auto receipt process.

cAllowNegativeReceipt EV01 char OPT NONE

An option that specifies the type of processing for an event.

mnNetTransactionID NETTCID MATH_NUMERIC OPT NONE

A number that identifies a netting transaction. The system assigns it using the Next Numbers program (P0002). A netting transaction could
contain one or more netting documents.

mnNetDocNumber NETDOC MATH_NUMERIC OPT NONE

A number that the system uses to cross reference netting source documents from which netting transfer and netting result documents are
generated. The system assigns it using the Next Numbers program (P0002). Examples of  netting source documents are: Accounts Payable   o
Voucher o Debit Memo    Accounts Receivable   o Invoice   o Credit Memo o Chargeback o Unapplied Cash

cReconciledROrBlank RCND char OPT INPUT

A code that indicates whether a transaction in the Account Ledger table (F0911) is reconciled. The codes are defined in User Defined Code
table under system 09 and code RC. A blank character is defined to be the un-reconciled character.  To set up a valid reconciled code
make sure the following is done in the User Defined Code table:    1.   The special handling code in fold area of the UDC screen must contain a
01.    2.   The reconciled code must be only one character long and can be a numeric or alpha character.

szReference3AccountReconci R3 char OPT INPUT

Number that provides an audit trail for specific transactions.  Used primarily in the G/L Account Reconciliation program (P09131).

Related Functions

B0000027 CurrencyConvForAndDom

B0100002 A/B - Get Parent Address

B0100039 Is Address Number in Address Book Master Table

B9800100 Get Audit Information

X0903 Fiscal Date Edits +

Related Tables

F03B13 Receipts Header

B0000027 CurrencyConvForAndDom
B0100002 A/B - Get Parent Address
B0100039 Is Address Number in Address Book Master Table
B9800100 Get Audit Information
X0903 Fiscal Date Edits +