B03B0116
F03B23 - BF Write Fee Journal History Detail
Functional Description
Purpose
This function will write a Fee Journal History Detail (F03B23) record. It will then update the Date
Last Fee Calculated field (LFCJ) with the Date Age As Of passed in. The update is applied to the
Customer Ledger Table (F03B11), and the A/R Check Detail Table (F03B14).
Setup Notes and Prerequisites
Only when the processing mode is a "1" (final mode), this program will update the Date Last Fee
Calculated in F03B11 or F03B14.
Special Logic
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
UKIDUnique KeyI Yes
RC5File Line IdentifierIYes
DOCDoc NumberIYes
DCTDocument TypeIYes
KCODocument CompanyIYes
SFXPay ItemIYes
DFEEAmount Delinquency FeeOYes
ASLCAmount Subject to Fin ChargeIYes
FFEEFor Amt Delinquency FeeONo
FSLCFor Amt Subject to Fin ChargeINo
CRRCurrency Convertion RateINo
CRRMCurrency ModeINo
AN8Customer NumberIYes
BCRCBase Currency CodeIYes
CRCDCurrency Code FromI No
PLYPolicy NumberIYes
LINDLine NumberIYes
ALPHAlpha NameIYes
COCompanyIYes
USERUser IDINoIf not passed in, the audit info will be left blank.
PIDProgram IDINoIf not passed in, the audit info will be left blank.
UPMJDate UpdatedINoIf not passed in, the audit info will be left blank.
UPMTTime Last UpdatedINoIf not passed in, the audit info will be left blank.
JOBNWorkstation IDINoIf not passed in, the audit info will be left blank.
MODEProcessing ModeINo
PYIDPayment IDIYesIf calculating the fee for the late payment.
RC5File Line IDIYesIf calculating the fee for the late payment.
DAGDate Age As OfIYes
Related Tables
F03B23A/R Fee Journal History Detail
F03B11Customer Ledger Table
F03B14A/R Check Detail Table
Related Business Functions
Processing
Open the F03B23 table.
If the Payment ID > 0
Insert Record into the F03B23 Table.
If the Payment ID > 0
Close tables.
D03B0116 - F03b23 - Write Fee Journal History Detail
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnUniqueKeyidInternal | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnFileLineIdentifier | RC5 | MATH_NUMERIC | NONE | NONE |
This field is used to create a unique key within a file and should be used with a next number approach. | ||||
mnDocumentNumber | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szDocumentCompany | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
szPayItem | SFX | char | NONE | NONE |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
| ||||
mnAddressNumber | 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
| ||||
szBaseCurrentcy | 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
| ||||
mnPolicyNumber | PLY | MATH_NUMERIC | NONE | NONE |
A number that the system assigns to each policy record to identify it. | ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szNameAlpha | 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
| ||||
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
| ||||
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. | ||||
mnTimeLastUpdated | 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. | ||||
cProcessingMode | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
mnPaymentID | PYID | MATH_NUMERIC | NONE | NONE |
A number that the system assigns from Next Numbers to identify and track payment records. | ||||
mnFileLineIdentifier50 | RC5 | MATH_NUMERIC | NONE | NONE |
This field is used to create a unique key within a file and should be used with a next number approach. | ||||
jdDateageasof | DAG | JDEDATE | NONE | NONE |
A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the
| ||||
mnAmountDelinquencyFees | DFEE | MATH_NUMERIC | NONE | NONE |
The total amount of the delinquency fee invoice records (RF). The system displays this information from either the A/R Statistical Summary
| ||||
mnAmntSubjectToFinC | ASLC | MATH_NUMERIC | NONE | NONE |
The sum of the open amount of the invoices on which the delinquency fee is based. | ||||
mnFrgnAmountDelinquencyFees | FFEE | MATH_NUMERIC | NONE | NONE |
The foreign currency amount of a delinquency fee. | ||||
mnFrgnAmntSubjectToFinC | FSLC | MATH_NUMERIC | NONE | NONE |
The sum of the past-due open invoices in the currency specified in the Currency Code field. This amount does not include invoices with
| ||||
mnCurrencyConverRateOv | 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
| ||||
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
| ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. |
B03B0190 F03B11Z2 Invoice Outbound Interoperability | ||||
B03B0191 F03B13Z2/F03B14Z2 Receipt Outbound Interoperability | ||||
B9800100 Get Audit Information |
F03B11 Customer Ledger | ||||
F03B14 Receipts Detail | ||||
F03B23 A/R Fee Journal History Detail |