N03B0150
F03B20 Write Statement Summary Record
Functional Description
Purpose
Since there is more that one place that the F03B20 record is processed, and written in the Statement
Build process this function was written.
Setup Notes and Prerequisites
Special Logic
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
STMA mnStatementAddressIYes
CO szCompanyIYes
DAG jdDateAgeAsOfIYes
AAP mnAmountOpenIYes
ADSA mnAmountDiscountTakenI
ADJ mnAmountAdjustmentsI
AD mnAmountDueIYes
PAD mnAmountPreviouslyDueIYes
FTR mnAmountFutureI
CURR mnCurrentAmountDueI
AG1 mnAmtAgingCategories1I
AG2 mnAmtAgingCategories2I
AG3 mnAmtAgingCategories3I
AG4 mnAmtAgingCategories4I
AG5 mnAmtAgingCategories5I
AG6 mnAmtAgingCategories6I
AG7 mnAmtAgingCategories7I
NOT szNotificationTypeIYes
NAPR cNotificationApprovalIYes
UKID mnUniqueKeyIDInternalIYes
AGEM cAgingMethodIYes
CRDY mnAgingDaysARCurrentI
AGR1 mnAgingDaysAR001I
AGR2 mnAgingDaysAR002I
AGR3 mnAgingDaysAR003I
AGR4 mnAgingDaysAR004I
AGR5 mnAgingDaysAR005I
AGR6 mnAgingDaysAR006I
AGR7 mnAgingDaysAR007I
CRCD szCurrencyCodeFromI
DDJ jdDateDueJulianI
LTTY cLetterTypeI
LTNA szLetterNameI
RNID mnBatchRunIDIYes
STMPP szARStatementProcessingIYes
VERS szVersionIYes
PID szProgramIdIYes
CTL szStatementNumberIYes
ATXA mnAmountTaxableI
ATXN mnAmountTaxExemptI
STAM mnAmtTax2I
ODAM mnOutstandingDraftAmountI
AIDR szRemitToStatementAddressFlagIYes
AGE cBaseAgingDateIYes
PYRD mnAmountPaymentsReceivedI
DT1J jdDateLastStatementDateI
ADJD mnAmountReceiptAdjustmentDomesI
TADA mnTransactionDiscountAmountI
TAAP mnTransactionPaymntAmountI
TAAJ mnTransactionWriteOffAmountI
ACL mnAmountCreditLimitI
TCRC szTransactionCurrencyCode I
Related Tables
F0010Company Constants
F0101Address Book Master
F03B20A/R Notification History
Related Business Functions
N03B0150Customer Master - MBF
B03B0068F03B31 Write Activity Records
B9800100Get Audit Information
Processing
Call Customer Master MBF
Call F03B31 Write Activity Record
Determine the Remit to Address
Call Get Audit Information
Insert the F03B20 record
^
D03B0150 - F03B20 Write Statement Header Record
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnStatementAddress | STMA | MATH_NUMERIC | NONE | NONE |
This is the address number used to print multi-tiered Accounts Receivable Statements. | ||||
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
| ||||
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
| ||||
mnAmountOpen | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
mnAmountDiscountTaken | ADSA | MATH_NUMERIC | NONE | NONE |
The amount by which an invoice or voucher is reduced if paid by a specific date. The discount taken does not have to be the same as the
| ||||
mnAmountAdjustments | ADJ | MATH_NUMERIC | NONE | NONE |
The domestic amount by which an invoice was changed or the domestic amount of the receipt write-off. | ||||
mnAmountDue | AD | MATH_NUMERIC | NONE | NONE |
The balance or amount due on an open invoice or voucher. In the Address Book Master file (F0101), this is a memo amount field used to
| ||||
mnAmountPreviouslyDue | PAD | MATH_NUMERIC | NONE | NONE |
The total amount of open invoices that appeared on the previous statement after payments and discounts were applied. | ||||
mnAmountFuture | FTR | MATH_NUMERIC | NONE | NONE |
The total amount of the invoices that is due prior to the first aging category defined when the Credit Analysis Refresh program (R03B525)
| ||||
mnCurrentAmountDue | CURR | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the current aging category as defined in either the Accounts Receivable constants or the
| ||||
mnAmtAgingCategories1 | AG1 | MATH_NUMERIC | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | NONE |
The total open invoice amount that is in the seventh category as defined in either the Accounts Receivable constants or the processing
| ||||
szNotificationType | NOT | char | NONE | NONE |
A code that indicates whether the transaction is a statement (ST) or a delinquency notice (DL). | ||||
cNotificationApproval | NAPR | char | NONE | NONE |
A system-assigned code that indicates the status of a statement, deliquency notice, or delinquency fee. Valid values
| ||||
mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
cAgingMethod | AGEM | char | NONE | NONE |
A code that designates which aging categories the system uses to assign invoices. The system uses the date specified in the Age as of
| ||||
mnAgingDaysARCurrent | CRDY | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with the value of AGR1 to define the number of days in the current aging category. | ||||
mnAgingDaysAR001 | AGR1 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with CRDY and AGR2 to define the current and first aging categories. | ||||
mnAgingDaysAR002 | AGR2 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR1 and AGR3 to define the first and second aging categories. | ||||
mnAgingDaysAR003 | AGR3 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR2 and AGR4 to define the second and third aging categories. | ||||
mnAgingDaysAR004 | AGR4 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR3 and AGR5 to define the third and fourth aging categories. | ||||
mnAgingDaysAR005 | AGR5 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR4 and AGR6 to define the fourth and fifth aging categories. | ||||
mnAgingDaysAR006 | AGR6 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR5 and AGR7 to define the fifth and sixth aging categories. | ||||
mnAgingDaysAR007 | AGR7 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR6 to define the sixth aging category. | ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
jdDateDueJulian | 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
| ||||
cLetterType | LTTY | char | NONE | 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 | NONE | 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
| ||||
mnBatchRunID | RNID | MATH_NUMERIC | NONE | NONE |
This is an internally assigned number that groups transaction records with a batch header record based on a particular execution of the G/L
| ||||
szARStatementProcessing | STMPP | char | NONE | NONE |
The program selected to produce the statement or delinquency notice. | ||||
szVersion | VERS | char | NONE | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
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
| ||||
szStatementNumber | CTL | char | NONE | NONE |
Accounts Payable - A code the system uses to determine the order in which A/P payments are printed. The value of the field differs
| ||||
mnAmountTaxable | ATXA | MATH_NUMERIC | NONE | NONE |
The amount on which taxes are assessed. | ||||
mnAmountTaxExempt | ATXN | MATH_NUMERIC | NONE | NONE |
The amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the
| ||||
mnAmtTax2 | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). | ||||
mnOutstandingDraftAmount | ODAM | MATH_NUMERIC | NONE | NONE |
The total value of the open draft amounts. Outstanding drafts are considered all drafts in Italy and only drafts not yet due in France. | ||||
szRemitToStatementAddressFlag | AIDR | char | NONE | NONE |
An accounting term referring to an account which is a subdivision of an object account. You may establish subsidiary accounts to keep
| ||||
cBaseAgingDate | AGE | char | OPT | NONE |
A code that specifies which date on the invoice record to use to calculate aging. The system compares the date specified on the invoice
| ||||
mnAmountPaymentsReceived | PYRD | MATH_NUMERIC | NONE | NONE |
The total domestic amount of the receipts that were applied to invoices. | ||||
jdDateLastStatementDate | DT1J | JDEDATE | OPT | NONE |
The date that the last statement was processed. The system displays this information from the A/R Statistical Summary table (F03B16S). | ||||
mnAmountReceiptAdjustmentDomes | ADJD | MATH_NUMERIC | OPT | NONE |
The sum of the write-off, deduction, and chargeback amounts. | ||||
mnTransactionDiscountAmount | TADA | MATH_NUMERIC | OPT | NONE |
The amount by which an invoice is reduced if paid by a specific date. The discount taken does not have to be the same as the discount
| ||||
mnTransactionPaymntAmount | TAAP | MATH_NUMERIC | OPT | NONE |
The amount of the receipt expressed in the transaction (foreign) currency. | ||||
mnTransactionWriteOffAmount | TAAJ | MATH_NUMERIC | OPT | NONE |
An amount that the system subtracts from the open amount of the invoice and does not require the customer to pay. | ||||
mnAmountCreditLimit | ACL | MATH_NUMERIC | OPT | NONE |
The total amount that you allow the customer to spend on purchases before the system sends a workflow message. This value is used
| ||||
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. |
None |
None |