B03B0136
F03B14 As Of Aging Server
Functional Description
Purpose
The purpose of this business function is to accumulate payment amounts prior to the As of Date.
Setup Notes and Prerequisites
If cPaymentFlag is returned as a 0, then no as of processing was done.
If cPaymentFlag is returned as a 1, then as of processing was done.
Special Logic
Special Logic For Drafts (R1 Documents)
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
DGJ eForGLandVoucherJULIAI/O
DAG jdDateAgeAsOfI
JCL jdDateInvoiceClosedNU
DOC mnDocVoucherInvoiceEI
DCT szDocumentTypeI
KCO szCompanyKeyI
SFX szDocumentPayItemI
AG mnAmountGrossI
ACR mnAmountCurrencyI
AAP mnAmountOpenO
FAP mnAmountForeignOpenO
EV01 cPaymentFlagO
ADSC nAmtDiscountAvailableO
CDS nForeignDiscountAvailO
ISTC RPostToCashManagementI
DDSTcDraftStatusO
AIDszAccountIdO
Related Tables
F03B14A/R Check Detail File
F03B11Customer Ledger
F03B112Invoice Revisions
Related Business Functions
Processing
Process for Drafts
Set Selection Parameters - F03B14
JDB_SetSelection - F03B14
JDB_SelectKeyed - F03B14
While Loop
JDB_Fetch - F03B14
Accumulate payment amounts prior to As of Date
Assign amount open with the difference of original amount and total payments made before As Of
Date and send back the G/L Date, Draft Status and Draft Account ID.
JDB_SetSelection - F03B14
JDB_SelectKeyed - F03B14
While Loop
Accumulate payment amounts prior to As of Date
Assign amount open with the difference of original amount and total payments made before As Of
Date
Special logic for RU Documents
D03B0136 - F03B14 As Of Aging Server
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
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
| ||||
jdDateInvoiceClosed | JCL | JDEDATE | NONE | NONE |
The date on which the invoice pay item is fully-paid. The system uses this date in As Of processing. | ||||
mnDocVoucherInvoiceE | 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
| ||||
szCompanyKey | 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,
| ||||
szDocumentPayItem | 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
| ||||
mnAmountGross | AG | MATH_NUMERIC | NONE | NONE |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
mnAmountCurrency | ACR | MATH_NUMERIC | NONE | NONE |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
mnAmountOpen | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
mnAmountForeignOpen | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. | ||||
cPaymentFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnAmtDiscountAvailable | ADSC | MATH_NUMERIC | NONE | NONE |
The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The
| ||||
mnForeignDiscountAvail | CDS | MATH_NUMERIC | NONE | NONE |
The foreign amount of the discount available as opposed to the amount of the discount actually taken. | ||||
cARPostToCashManagement | ISTC | char | OPT | NONE |
A code that specifies whether the transaction is included in the the A/R Statistical History table (F03B16). Valid values are:
Blank
The
| ||||
cDraftStatus | DDST | char | OPT | NONE |
A code that the system assigns to draft records (F03B13 and F03B14) to indicate their progress during the collection process. Valid values
| ||||
szAccountId | AID | char | OPT | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. |
None |
F03B11 Customer Ledger | ||||
F03B112 Invoice Revisions | ||||
F03B13 Receipts Header | ||||
F03B14 Receipts Detail |