Functional Description
Purpose
Function is used to add and update receipts for the Speed Receipts Entry application. The function
will test for the existence of the passed Payment ID in the Receipts Header table to determine whether
to add or update the record.
Setup Notes and Prerequisites
This function writes and updates both the F03B13 and F03B14 records for Logged, General Ledger, and
Unapplied receipts. Balance Forward receipts need to call the B03B0030 function after calling this
function.
Special Logic
None.
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
PYIDmnPaymentIDIY
CKNUszReceiptNumberIY
AN8mnCustomerNumberIY
PYRmnPayorNumberIY
CKAMmnReceiptAmountIY
DMTJjdDateReceiptIY
DGJjdDateGLIY
PNmnPeriodNumberIY
ISTRcJEMethodIY
GLCszGLOffsetIY
AIDszAccountIDIY
FYmnFiscalYearIY
CTRYmnCenturyIY
COszCompanyIY
ICUTszBatchTypeIY
ICUmnBatchNumberIY
DICJjdDateBatchIY
PA8mnParentNumberIY
AAPmnAmountUnappliedIY
CRRMcCurrencyModeIY
CRCDszTransactionCurrencyIY
CRRmnExchangeRateIY
FCAMmnForeignReceiptAmntIY
FAPmnForeignAmountUnappdIY
GLBAszBankAccountIDIY
AMcBankAccountModeIY
TYINcReceiptTypeCodeIY
VLDTjdDateClearedIY
EXRszRemarkIY
RYINcPaymentInstrumentIY
ALPHszPayorNameIY
TORGszTransactionOrigintrIY
USERszUserIDIY
PIDszProgramIDIY
UPMJjdDateUpdatedIY
UPMTmnTimeUpdatedIY
JOBNszWorkstationIDIY
ATCScAutoCashIY
AID2szGLAccountIDIY
AM2cGLAccountModeIY
MCUszBusinessUnitIY
SBLTcSubLedgerTypeIY
SBLszSubLedgerIY
NUMBmnAssetNumberIY
BCRCszBaseCurrencyIY
Related Tables
F03B13Receipts Header File
F03B14A/R Check Detail File
Related Functions
B03B0069Create Maintain RU Detail
Processing
Set Action Code to 'A'.
Open F03B13 table.
Open F03B14 table.
Retrieve F03B13 record using mnPaymentID.
If record was found,
If a General Ledger or Logged receipt,
If a General Ledger or Logged receipt,
If a General Ledger or Logged receipt,
If a General Ledger or Logged receipt,
Close F03B14 table.
D03B0001 - Receipt Header Server
ItemDescriptionI/OReq?Notes
PYIDmnPaymentIDIY
CKNUszReceiptNumberIY
AN8mnCustomerNumberIY
PYRmnPayorNumberIY
CKAMmnReceiptAmountIY
DMTJjdDateReceiptIY
DGJjdDateGLIY
PNmnPeriodNumberIY
ISTRcJEMethodIY
GLCszGLOffsetIY
AIDszAccountIDIY
FYmnFiscalYearIY
CTRYmnCenturyIY
COszCompanyIY
ICUTszBatchTypeIY
ICUmnBatchNumberIY
DICJjdDateBatchIY
PA8mnParentNumberIY
AAPmnAmountUnappliedIY
CRRMcCurrencyModeIY
CRCDszTransactionCurrencyIY
CRRmnExchangeRateIY
FCAMmnForeignReceiptAmntIY
FAPmnForeignAmountUnappdIY
GLBAszBankAccountIDIY
AMcBankAccountModeIY
TYINcReceiptTypeCodeIY
VLDTjdDateClearedIY
EXRszRemarkIY
RYINcPaymentInstrumentIY
ALPHszPayorNameIY
TORGszTransactionOrigintrIY
USERszUserIDIY
PIDszProgramIDIY
UPMJjdDateUpdatedIY
UPMTmnTimeUpdatedIY
JOBNszWorkstationIDIY
ATCScAutoCashIY
AID2szGLAccountIDIY
AM2cGLAccountModeIY
MCUszBusinessUnitIY
SBLTcSubLedgerTypeIY
SBLszSubLedgerIY
NUMBmnAssetNumberIY
BCRCszBaseCurrencyIY
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnPaymentID | PYID | MATH_NUMERIC | NONE | NONE |
A number that the system assigns from Next Numbers to identify and track payment records. | ||||
szReceiptNumber | CKNU | char | NONE | NONE |
For Auto Bank Statement, this code identifies the payment/receipt or reference number.
NOTE:
Bank Statement Detail section: The
| ||||
mnCustomerNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnPayorNumber | PYR | MATH_NUMERIC | NONE | NONE |
The address book number of the person or company that sends the payment. | ||||
mnReceiptAmount | CKAM | MATH_NUMERIC | NONE | NONE |
The actual amount of the receipt or payment. | ||||
jdDateReceipt | DMTJ | JDEDATE | NONE | NONE |
The date on a payment or the date on which a receipt was entered.
In Accounts Payable, the manual payment date and the general ledger
| ||||
jdDateGL | DGJ | JDEDATE | NONE | NONE |
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
| ||||
mnPeriodNumber | PN | MATH_NUMERIC | NONE | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
cJEMethod | ISTR | char | NONE | NONE |
In the Customer Ledger table (F03B11), a code that specifies whether revision records exist for an invoice. Valid values are:
Blank
No
| ||||
szGLOffset | GLC | char | NONE | NONE |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
szAccountID | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szBatchType | ICUT | char | NONE | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
jdDateBatch | DICJ | JDEDATE | NONE | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
mnParentNumber | PA8 | MATH_NUMERIC | NONE | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
mnAmountUnapplied | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
cCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
szTransactionCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
mnExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnForeignReceiptAmount | FCAM | MATH_NUMERIC | NONE | NONE |
The amount of a foreign currency receipt. | ||||
mnForeignAmountUnapplied | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. | ||||
szBankAccountID | GLBA | char | NONE | NONE |
The number of the bank account (general ledger account) to be updated automatically when receipts or disbursements are entered. The
| ||||
cBankAccountMode | AM | char | NONE | NONE |
A code that indicates which of the three general ledger account numbers is being used for data entry. Valid codes are:
1 The short
| ||||
cReceiptTypeCode | TYIN | char | NONE | NONE |
A user defined code (03B/TI) that indicates the type of receipt record in the Receipts Header (F03B13) and Receipts Detail (F03B14)
| ||||
jdDateCleared | VLDT | JDEDATE | NONE | NONE |
The date that the payment amount was debited or credited to the bank account. The value date is not the date the bank reconciled the
| ||||
szRemark | EXR | char | NONE | NONE |
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
| ||||
cPaymentInstrument | RYIN | char | NONE | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
szPayorName | ALPH | char | NONE | NONE |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
szTransactionOriginator | TORG | char | NONE | NONE |
The person who originally entered the transaction. | ||||
szUserID | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
szProgramID | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeUpdated | UPMT | MATH_NUMERIC | NONE | NONE |
The time that specifies when the program executed the last update to this record. | ||||
szWorkstationID | JOBN | char | NONE | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
cAutoCash | ATCS | char | NONE | NONE |
An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the
| ||||
szGLAccountID | AID2 | char | NONE | NONE |
This account number is used specifically in the Receipts and Adjustments program to record non-Accounts Receivable (General Ledger)
| ||||
cGLAccountMode | AM2 | char | NONE | NONE |
A code that indicates which of the three general ledger account numbers is being used for data entry. Valid codes are:
1 The short ID
| ||||
szBusinessUnit | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
cSubLedgerType | SBLT | char | NONE | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szSubLedger | SBL | char | NONE | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
mnAssetNumber | NUMB | MATH_NUMERIC | NONE | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
szBaseCurrency | BCRC | char | NONE | NONE |
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
| ||||
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
cReceiptSplitFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
B03B0069 F03B14 Maintain Unapplied Cash |
F03B13 Receipts Header | ||||
F03B14 Receipts Detail |