B03B0112
F03B21 - Write Notification Detail from Cache
Functional Description
Purpose
To write the A/R Notification History Detail (F03B21) record , and update the Date Last Sent Reminder
(RDDJ) and the Total Sent Reminders (RMDS) on the corresponding record in the Customer Ledger
(F03B11) table.
Setup Notes and Prerequisites
When the Process Mode is a "1" this function will write the Cache Table record create in B03B0111.
When the Process Mode is a "2" this function will read the Cache Table created in B03B0111, insert a
record into the F03B21. If the Proof or Final Flag is a "1", this function will update the Date Last
Sent Reminder and the Total Sent Reminders on the corresponding F03B11.
When the Process Mode is a "3" this function will read the cache, and look for a policy. If no
policy is found or if it is not offended, then the cache record is deleted. This will produce only
delinquent invoices on the delinquency notice.
Special Logic
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
EV01Process ModeIYes
UKIDUnique KeyI Yes
AN8Customer NumberIYes
COCompanyIYes
DOCDoc NumberIYes
DCTDocument TypeIYes
KCODocument CompanyIYes
SFXPay ItemIYes
DDJDue DateIYes
DGJG/L DateIYes
DIVJInvoice DateIYes
NOTJNotification DateIYes
RMKRemarksINo
RMDSTotal Sent RemindersINo
CRCDTrans Currency CodeINo
AAPOpen AmountIYes
FADForeign Open AmountINo
AABAffected Aging BucketIYes
RDDJDate Last Sent ReminderINo
BCRCBase Currency CodeINo
CRRMCurrency ModeINo
EV01Proof or Final ModeIYes
DAGDate Age As OfIYes
Related Tables
F03B11Customer Ledger File
F03B21A/R Notification History Detail
Related Business Functions
B9800100Get Audit Information
Processing
If the Process Mode is a 1,
Set up the cached index.
Move the input fields to the cache record.
Write the record to cache.
If the Process Mode is a 2,
While (jdeCacheCode == JDECM_PASSED) from the F03B21 cache record.
Get audit information.
If Proof or Final Mode is a 1,
Move date and number of sent reminders to F03B11.
Update the F03B11.
Fetch the next record from the F03B21 cache records.
If the Process Mode is a 3
Reset Cache Curser.
Fetch Cache.
While Fetch Cache passes.
If Create Notification Flag from B03B049 not = 1.
Fetch Cache.
Close the F03B11, and the F03B21 tables.
D03B0112 - F03B21 - Write Notification Detail from Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnUniqueKey | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
cProcessMode | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
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
| ||||
mnDocNumber | 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
| ||||
jdDateDue | DDJ | JDEDATE | NONE | NONE |
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount
| ||||
jdGLDate | 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
| ||||
jdDateInvoice | DIVJ | JDEDATE | NONE | NONE |
The date that either you or the system assigns to an invoice or voucher. This can be either the date of the supplier's invoice to you or the
| ||||
jdDateNotification | NOTJ | JDEDATE | NONE | NONE |
The date that a statement, delinquency notice, or delinquency fee was generated for the customer. | ||||
szRemark | RMK | char | NONE | NONE |
A generic field that you use for a remark, description, name, or address. | ||||
mnTotalSentReminders | RMDS | MATH_NUMERIC | NONE | NONE |
This field specifies the number of delinquency notices that have been generated for an invoice pay item. | ||||
szTransCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
mnOpenAmount | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
mnForeignOpenAmount | FAD | MATH_NUMERIC | NONE | NONE |
The total amount of open foreign currency invoices that appeared on the previous statement after payments and discounts were applied. | ||||
cAffectedAgingBucket | AAB | char | NONE | NONE |
A number that specifies the aging category. The system updates this field with the value of the aging category to which the invoice is
| ||||
jdDateLastSentReminder | RDDJ | JDEDATE | NONE | NONE |
The date of the most recent past-due notice to the customer. | ||||
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
| ||||
cProofOrFinal | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
mnAmountGross | AG | MATH_NUMERIC | OPT | 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 | OPT | NONE |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
jdPayByDate | DTPB | JDEDATE | OPT | NONE |
The due date for the past-due invoices that print on the delinquency notice when you are using the Tiered Delinquency Notice Print
| ||||
jdDateLastFeeCalculated | LFCJ | JDEDATE | OPT | NONE |
The most recent date on which the fees were calculated. The system uses this date for further fee calculations, by determining the number
| ||||
mnPolicyNumberA | PLY | MATH_NUMERIC | OPT | NONE |
A number that the system assigns to each policy record to identify it. | ||||
cCreateNoticesFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSeverityFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnAmtAgingCategories1 | AG1 | MATH_NUMERIC | OPT | NONE |
The total open invoice amount that is in the first category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories2 | AG2 | MATH_NUMERIC | OPT | NONE |
The total open invoice amount that is in the second category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmtAgingCategories3 | AG3 | MATH_NUMERIC | OPT | NONE |
The total open invoice amount that is in the third category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories4 | AG4 | MATH_NUMERIC | OPT | NONE |
The total open invoice amount that is in the fourth category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmtAgingCategories5 | AG5 | MATH_NUMERIC | OPT | NONE |
The total open invoice amount that is in the fifth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories6 | AG6 | MATH_NUMERIC | OPT | NONE |
The total open invoice amount that is in the sixth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories7 | AG7 | MATH_NUMERIC | OPT | NONE |
The total open invoice amount that is in the seventh category as defined in either the Accounts Receivable constants or the processing
| ||||
cLetterType | LTTY | char | OPT | NONE |
A code that is used to identify and organize the text that prints on statements or delinquency notices. The value that you specify must exist in
| ||||
szLetterName | LTNA | char | OPT | NONE |
A field that identifies a predefined letter in the Letter Text table (F03B28). This field is case sensitive, so you must enter the letter name as it
| ||||
mnLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
cCollectionManagerApprovalReq | CMAR | char | OPT | NONE |
An option in Fee Instructions and Notification Instructions that specifies the status that the system assigns to a delinquency fee or notice.
|
B03B0190 F03B11Z2 Invoice Outbound Interoperability | ||||
B9800100 Get Audit Information |
F03B11 Customer Ledger | ||||
F03B21 A/R Notification History Detail |