Functional Description
Purpose
This business function is to create the GL side of F03B14 record. These records are used by the post
program to make the GL entry. This is used to write the draft (D type record).
Setup Notes and Prerequisites
This function is used in P03B602, R03B671, R03B672 and R03B680.
Special Logic
Technical Specification
Parameters:
Data ItemData Structure DescriptionI/OReqNotes
PYID mnPaymentIDIYESPart of key to F03B14 File.
CKNUszDraftNumberIYES Draft Number
DMTJjdDateMatchingChecOrIYESDraft Date
COszCompanyIYESCompany
DGJjdDateForGLandVoucherJULIAIYESDraft GL Date
ICUmnBatchNumberIYESBatch Number
ICUTszBatchTypeIYESBatch Type
DICJjdBatchJulian IYESBatch Date
AIDszFromAccountIdIYESAccount Id from
DDSTcfromDraftStatusIYESDraft Status from
AAmnFrom AmountIYESDraft Amount from
AIDszToAccountIdIYESAccount Id to
DDSTctoDraftStatusIYESDraft Status to
AAmnToAmountIYESDraft Amount To
MCUszCostCenterIYESCost Center
BCRCszCurrencyCodeBaseIYESBase Currency Code
AM2cCurrencyModeIYESCurrency Mode
PIDszProgram IdIYESProgram Id
TAAPmnTransactionPaymntAmountIYESTransaction Payment Amount
TCRCszTransactionCurrencyCodeIYESTransactionCurrencyCode
CRR1mnTriangulationLeg1IYESTriangulation Leg 1
CRR2mnTriangulationLeg2IYESTriangulation Leg 2
CRCMcCurrencyConversionMethodIYESCurrency Conversion Method
CRRmnCurrencyConverRateOvIYESCurrency Conversion Rate
Related Tables
F03B14Receipts Detail File.
Related Business Functions
B03B0147F03B14GetNextFileLineIdentifier
B9800100Get Audit Information
X0903Fiscal Date Edits
B0000027Currency Conversion Foreign and Domestic
Processing
Copy all the passed in parameters to the F03B14 file structure.
Retrieve fiscal period century and year.
Retrieve the audit information.
Get the Next File Line Identifier.
Populate the appropriate F03B14 fields.
Insert the F03B14 record.
If the from account id, from draft status and from amount are given create the reversing entry for
the previous draft status.
If there is an error inserting records set an error and close table.
Close table.
D03B0146 - F03B014 - Create F03B14 Record - GL Entry
Parameters:
Data ItemData Structure DescriptionI/OReqNotes
PYID mnPaymentIDIYESPart of key to F03B14
File.
CKNUszDraftNumberIYES Draft Number
DMTJjdDateMatchingChecOrIYESDraft Date
COszCompanyIYESCompany
DGJjdDateForGLandVoucherJULIAIYESDraft GL Date
ICUmnBatchNumberIYESBatch Number
ICUTszBatchTypeIYESBatch Type
DICJjdBatchJulian IYESBatch Date
AIDszFromAccountIdIYESAccount Id from
DDSTcfromDraftStatusIYESDraft Status from
AAmnFrom AmountIYESDraft Amount from
AIDszToAccountIdIYESAccount Id to
DDSTctoDraftStatusIYESDraft Status to
AAmnToAmountIYESDraft Amount To
MCUszCostCenterIYESCost Center
BCRCszCurrencyCodeBaseIYESBase Currency Code
AM2cCurrencyModeIYESCurrency Mode
PIDszProgram IdIYESProgram Id
TAAPmnTransactionPaymntAmountIYESTransaction Payment
Amount
TCRCszTransactionCurrencyCodeIYESTransactionCurrencyCode
CRR1mnTriangulationLeg1IYESTriangulation Leg 1
CRR2mnTriangulationLeg2IYESTriangulation Leg 2
CRCMcCurrencyConversionMethodIYESCurrency Conversion
Method
CRRmnCurrencyConverRateOvIYESCurrency Conversion
Rate
^
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. | ||||
szDraftNumber | CKNU | char | NONE | NONE |
For Auto Bank Statement, this code identifies the payment/receipt or reference number.
NOTE:
Bank Statement Detail section: The
| ||||
jdDateMatchingCheckOr | 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
| ||||
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
| ||||
jdDateForGLandVoucherJULIA | 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
| ||||
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
| ||||
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.
| ||||
jdDateBatchJulian | DICJ | JDEDATE | NONE | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
szFromAccountId | 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. | ||||
cFromDraftStatus | DDST | char | NONE | NONE |
A code that the system assigns to draft records (F03B13 and F03B14) to indicate their progress during the collection process. Valid values
| ||||
mnFromAmount | AA | MATH_NUMERIC | NONE | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
szToAccountId | 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. | ||||
cToDraftStatus | DDST | char | NONE | NONE |
A code that the system assigns to draft records (F03B13 and F03B14) to indicate their progress during the collection process. Valid values
| ||||
mnToAmount | AA | MATH_NUMERIC | NONE | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
szCostCenter | 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
| ||||
szCurrencyCodeBase | 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
| ||||
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
| ||||
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
| ||||
mnTransactionPaymntAmount | TAAP | MATH_NUMERIC | OPT | NONE |
The amount of the receipt expressed in the transaction (foreign) currency. | ||||
szTransactionCurrencyCode | TCRC | char | OPT | NONE |
A code that represents the currency of a receipt when it is different from the base currency of the company for which the receipt was entered. | ||||
mnTriangulationLeg1 | CRR1 | MATH_NUMERIC | OPT | NONE |
The exchange rate from the foreign currency of the invoice to the triangulation currency (leg 1). This rate applies when you use triangulation
| ||||
mnTriangulationLeg2 | CRR2 | MATH_NUMERIC | OPT | NONE |
The exchange rate from the triangulation currency to the domestic currency (leg 2). This rate applies when you use triangulation to calculate
| ||||
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
| ||||
mnCurrencyConverRateOv | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
|
B0000027 CurrencyConvForAndDom |
None |