This appendix contains the following topics:
Section C.1, "Mapping Fields in the A/R Statistical History Table (F03B16)"
Section C.2, "Mapping Fields in the A/R Statistical Summary Table (F03B16S)"
This section contains a list of the fields in the F03B16 table. Some of the fields are key fields.
Review the following table:
Field Name | Alias | Definition |
---|---|---|
Address Number | AN8 | A key field in this table. |
Company | CO | A key field in this table. |
Century | CTRY | A key field in this table. |
Fiscal Year | FY | A key field in this table. |
Period Number | PN | A key field in this table. |
Ending Date | END | Ending date of this period. |
Period Days | DAYP | Number of days in this period. |
Ending Balance Amount | ENBL | Start with beginning balance (the ending balance of the previous period) and add invoices and subtract receipts for the period processed. |
Delinquent Balance Amount | DLBL | Ending balance minus the sum of the future and current aging categories in the record. |
High Balance Amount | AHB | The sum of the open invoices that are past due for the customer. |
Date of High Balance | DHBJ | G/L Date from period with the high balance amount. |
Days Sales Outstanding | DSO | Review the following calculation methods.
Count Back Method: Accumulated End Balance = Starts with Ending Balance Amount (ENBL) Accumulated DSO Days = Zero If Accumulated End Balance <= Zero, stop DSO calculation. If period not found, stop DSO calculation. The following calculations are done per each period requested on processing options: If Accumulated End Balance >= Sales Amount (SAG)
Else
Stop DOS Calculation DSO = Accumulated DSO Days Average Balance Method: Accumulated Total Sales = Starts with Sales Amount (SAG) current period Accumulated End Balance = Starts with Ending Balance Amount (ENBL) current period Accumulated End Balance = Starts with Ending Balance Amount (ENBL) current period Accumulated Total Number Days = Starts with Days in Period (DAYP) current period f period not found, stop DSO calculation. The following calculations are done per each period before the current period based on periods requested on processing options: |
Days Sales Outstanding (continued) | DSO |
Average Number Days = Accumulated Total Number Days / Periods Processed DSO = ((Accumulated End Balance / Accumulated Total Sales) * Average Number Days) Current Balance Method: Accumulated End Balance = Ending Balance Amount (ENBL) current period Accumulated Total Sales = Starts with Sales Amount (SAG) current period Accumulated Total Number Days = Starts with Days in Period (DAYP) current period The following calculations are done per each period before the current period based on periods requested on processing options:
DSO = ((Accumulated End Balance * Accumulated Total Number Days) / Accumulated Total Sales) |
Best DSO | BDSO | Review the following calculation methods.
Count Back Method: Current Balance = Starts with Ending Balance Amount (ENBL) - Amount Past Due (DLBL) Accumulated DSO Days = Zero If Current Balance <= Zero, stop DSO calculation. If period not found, stop DSO calculation. The following calculations are done per each period requested on processing options: If Current Balance >= Sales Amount (SAG)
Else
|
Best DSO (continued) | BDSO | Stop Best DSO calculation
BDSO = Accumulated Best DSO Days Average Balance Method: Accumulated Total Sales = Starts with Sales Amount (SAG) current period Current Balance = Starts with Ending Balance Amount (ENBL) - Amount Past Due (DLBL) current period Accumulated Total Number Days = Starts with Days in Period (DAYP) current period If period not found, stop DSO calculation. The following calculations are done per each period before the current period based on periods requested on processing options:
Average Number Days = Accumulated Total Number Days / Periods Processed Best DSO = ((Current Balance / Accumulated Total Sales) * Average Number Days) Current Balance Method: Current Balance = Ending Balance Amount (ENBL) - Amount Past Due (DLBL) current period Accumulated Total Sales = Starts with Sales Amount (SAG) current period Accumulated Total Number Days = Starts with Days in Period (DAYP) current period The following calculations are done per each period before the current period based on periods requested on processing options:
Best DSO Amount = ((Current Balance * Accumulated Total Number Days) / Accumulated Total Sales) |
Delinquent DSO | DDSO | Difference between DSO and Best DSO in this record. |
Average Days Late | ADVDL | The Average Days Late maximum value is 999.
The Average Days Late minimum value is -999. Per Customer or Company and Period: Per each receipt (F03B14) with an Invoice Journal Date and Payment Amount populated:
Per each paid in full receipt (F03B14):
If total amount paid late is not zero:
Average Days Late = Total Average Days Late |
Average Days Late (continued) | ADVDL | If a F03B16 record exists:
|
Average Days Late Non-Weighted | AVDN | The Average Days Late maximum value is 999.
The Average Days Late minimum value is -999. Per Customer or Company and Period:
If a F03B16 record exists:
|
Gross Amount | AG | Sum of invoice gross amounts where the gross amount is greater than zero. Do not include chargeback (RB doc type) and deduction (RS doc type) invoices. |
Number of Invoices | NINV | Number of invoices where the gross amount is greater than or equal to zero. Do not include chargeback (RB doc type) and deduction (RS doc type) invoices. |
Sales Amount | SAG | Sum of invoice taxable amounts. If the taxable amount is empty on an invoice, then use the gross amount of that invoice. |
Credit Amount | CREE | Sum of invoice gross amounts where the gross amount is less than zero. |
Discount Available Amount | ADSC | Sum of invoice discount available amounts. |
Delinquency Fee Amount | DFEE | Sum of invoice gross amounts where the invoice is a delinquency fee (RF doc type). |
Chargeback Amount | ECBA | Sum of invoice gross amounts where the invoice is a chargeback (RB doc type). |
Number of Chargebacks | NCB | Number of invoices that are chargebacks (RB doc type). |
Payment Amount | PAAP | Sum of receipt pay-item payment amounts. |
Discount Taken Amount | ADSA | Sum of receipt pay-item discount taken amounts. |
Earnable Discount Amount (EDSC) | EDSC | Sum of receipt pay-item discount taken amounts where the G/L date of the receipt pay item is less than or equal to the discount due date of the invoice it is paying. |
Un-Earnable Discount Amount | UDSC | Sum of receipt pay-item discount taken amounts where the G/L date of the receipt pay item is greater than or equal to the discount due date of the invoice it is paying. |
Number of Invoices Paid | NINP | Number of receipt pay items that caused the open amount of an invoice to be zero. |
Paid Late Amount | AIPL | Sum of receipt pay item payment amounts where the G/L date of the receipt pay item is greater than the due date of the invoice it is paying. Invoice credit memos are not included in these calculations. |
Number of Invoices Paid Late | NIPL | Number of receipt pay items that caused the open amount of an invoice to be zero and the G/L date of the receipt pay item is greater than the due date of the invoice it paid. |
Deduction Amount | DDCA | Sum of receipt pay item deduction amounts. |
Number of Deductions | DDCN | Number of receipt pay items where the deduction amount is not zero. |
Minor Write Off Amount | MWO | The sum of bad debit and minor write-off amounts. |
Total Write Off Amount | TAWO | Bad debit amount plus minor amount write-off for this record. |
Bad Debit Amount | BDBT | If the Write-off Reason Code field is populated and the Special Handling Code in the 03B/RC UDC table is blank, the system adds write-off amounts to the Bad Debt total. Otherwise, the amount is accumulated into the Minor Write Off total. |
Non sufficient Funds Amount | ANSF | Sum of receipt check amounts where the receipt has been marked as insufficient funds. |
Number of NSFs | NNSF | Number of receipts that have been marked as insufficient funds. |
Collection Manager | CLMG | The address number of the collection manager for this customer. |
Credit Manager | CMGR | The address number of the credit manager for this customer. |
Recalculate High Balance Amount | RHB | Internal flag indicating that the system should recalculate the high balance for this record. |
Recalculate Ending Balance Amount | RBAL | Internal flag indicating that the system should recalculate the ending balance for this record. |
Currency Code | CRCD | The currency of all amounts in this record.If the company is 00000, then the currency code is the customer's currency. Otherwise, the currency code is the currency of the company. |
Future Amount Due | FTR | Sum of invoice open amounts that fall into the future aging category, as determined by the A/R constants for this company. |
Current Amount Due | CURR | Sum of invoice open amounts that fall into the current aging category, as determined by the A/R constants for this company. |
Aging Category 1 Amount | AG1 | Sum of invoice open amounts that fall into the first aging category, as determined by the A/R constants for this company. |
Aging Category 2 Amount | AG2 | Sum of invoice open amounts that fall into the second aging category, as determined by the A/R constants for this company. |
Aging Category 3 Amount | AG3 | Sum of invoice open amounts that fall into the third aging category, as determined by the A/R constants for this company. |
Aging Category 4 Amount | AG4 | Sum of invoice open amounts that fall into the fourth aging category, as determined by the A/R constants for this company. |
Aging Category 5 Amount | AG5 | Sum of invoice open amounts that fall into the fifth aging category, as determined by the A/R constants for this company. |
Aging Category 6 Amount | AG6 | Sum of invoice open amounts that fall into the sixth aging category, as determined by the A/R constants for this company. |
Aging Category 7 Amount | AG7 | Sum of invoice open amounts that fall into the seventh aging category, as determined by the A/R constants for this company. |
Changed Amount | CHGA | Internal amount. |
User ID | USER | Identification of the user who ran the program which last updated this record. |
Program ID | PID | Identification of the program that last updated this record. |
Date Last Updated | UPMJ | Date this record was last updated. |
Time Last Updated | UPMT | Time this record was last updated. |
Work Station ID | JOBN | Identification of the work station that last updated this record. |
Note:
The period ending date is the date used to age invoice open amounts.Do not include unapplied cash records (document type RU) when calculating Average Days Late, Average Days Late Non-Weighted, Credit Amount, Discount Taken Amount, Earnable Discount Taken Amount, Un-Earnable Discount Taken Amount, Number of Invoices Paid, Paid Late Amount, and Number of Invoices Paid Late.
The company 00000 records are the summation of a customer's activity across all companies.
This section contains a list of the fields in the F03B16S table. Some of the fields are key fields.
Review the following table:
Field Name | Alias | Definition |
---|---|---|
Address Number | AN8 | A key field in this table. |
Parent Child Relationship | PART | A key field in this table. |
Company | CO | A key field in this table. |
Ending Balance Amount | ENBL | Start with beginning balance (the ending balance of the previous period) and add invoices and subtract receipts for the period processed. |
High Balance Amount | AHB | Highest balance amount of all of the periods being processed in the F03B16 table. |
Date of High Balance | DHBJ | Date of the high balance in the F03B16 table corresponding to the above amount. |
High Credit Limit | ACLH | Credit limit of this customer. Calculated only for company 00000. |
Average Days Late | AVDL | See definition in the Fields in the F03B16 table section |
Average Days Late Non-Weighted | AVDN | See definition in the Fields in the F03B16 table section |
Gross Amount | AG | Sum of gross amounts in the F03B16 table. |
Number of Invoices | NINV | Total number of invoices in the F03B16 table. |
Sales Amount | SAG | Sum of sales amounts in the F03B16 table. |
Credit Amount | CREE | Sum of credit amounts in the F03B16 table. |
Discount Available Amount | ADSC | Sum of discount available amounts in the F03B16 table. |
Delinquency Fee Amount | DFEE | Sum of delinquency fee amounts in the F03B16 table. |
Chargeback Amount | ECBA | Sum of chargeback amounts in the F03B16 table. |
Number of Chargebacks | NCB | Total number of chargebacks in the F03B16 table. |
Date of First Invoice | DFIJ | The earliest invoice G/L date in the F03B11 table. |
Date of Last Invoice | DLIJ | The latest invoice G/L date in the F03B11 table. |
Date of Last Statement | DTIJ | The latest statement notification date in the F03B20 table. |
Amount Invoiced Current Year | ASTY | Sum of invoice gross amounts where the G/L date is within the current fiscal year as determined by the Credit/Collection Fiscal Date Patterns (F03B08). |
Amount Invoiced Prior Year | SPYE | Sum of invoice gross amounts where the G/L date is within the prior fiscal year as determined by the Credit/Collection Fiscal Date Patterns (F03B08). |
Payment Amount | PAAP | Sum of payment amounts in the F03B16 table. |
Earnable Discount Amount | EDSC | Sum of earnable discount taken amounts in the F03B16 table. |
Un-earnable Discount Amount | UDSC | Sum of un-earnable discount taken amounts in the F03B16 table. |
Number of Invoices Paid | NINP | Total number of invoices paid in the F03B16 table. |
Paid Late Amount | AIPL | Sum of paid late amounts in the F03B16 table. |
Number of Invoices Paid Late | NIPL | Total number of invoices paid late in the F03B16 table. |
Deduction Amount | DDCA | Sum of deduction amounts in the F03B16 table. |
Number of Deductions | DDCN | Total number of deductions in the F03B16 table. |
Minor Write Off Amount | MWO | Sum of the minor write-off amounts in the F03B16 table. |
Bad Debit Amount | BDBT | Sum of the bad debit amounts in the F03B16 table. |
Non Sufficient Funds Amount | ANSF | Sum of the nonsufficient funds amounts in the F03B16 table. |
Number of NSFs | NNSF | Total number of nonsufficient funds receipts in the F03B16 table. |
Date of Last Payment | DLP | The latest receipt pay item G/L date in the F03B14. Do not include un-applied cash (RU doc type) records. |
Amount of Last Payment | ALP | Payment amount corresponding to the above date. Do not include un-applied cash (RU doc type) records. |
Next Period to Process | NXPD | Next period after the Thru Date processing option. |
Number of Reminders Sent | NBR1 | Total number of notices sent in the F03B20 table. |
Date of Last Reminder Sent | DLQJ | Latest notification date in the F03B20 table. |
Currency Code | CRCD | The currency of all amounts in this record.If the company is 00000, then the currency code is the customer's currency. Otherwise, the currency code is the currency of the company. |
Credit Manager | CMGR | The address number of the credit manager for this customer. |
Collection Manager | CLMG | The address number of the collection manager for this customer. |
User ID | USER | Identification of the user who ran the program which last updated this record. |
Program ID | PID | Identification of the program that last updated this record. |
Date Last Updated | UPMJ | Date this record was last updated. |
Time Last Updated | UPMT | Time this record was last updated. |
Work Station ID | JOBN | Identification of the work station that last updated this record. |
Note:
Above explanations are for child records.Above explanations assume that only F03B16 records, which match the customer and company of this record, are considered.
The company 00000 records are the summation of a customer's activity across all companies.
For parent records, amount or number fields are the summation of the activity for parent and all of its descendants.
For parent records, date or high amount fields are the highest (or lowest, depending on the field's meaning) value in the activity of the parent or any of its descendants.