# C Mapping Fields for the Statistics History Update

This appendix contains the following topics:

## C.1 Mapping Fields in the A/R Statistical History Table (F03B16)

This section contains a list of the fields in the F03B16 table. Some of the fields are key fields.

### C.1.1 Fields in the F03B16 Table

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.

The following calculations are done per each period requested on processing options:

If Accumulated End Balance >= Sales Amount (SAG)

• Accumulated End Balance = Accumulated End Balance - Sales Amount (SAG)

• Accumulated DSO Days = Accumulated DSO Days + Days in Period (DAYP)

Else

• Accumulated DSO Days = Accumulated DSO Days + ((Accumulated End Balance / Sales Amount (SAG)) *Days in Period (DAYP))

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

The following calculations are done per each period before the current period based on periods requested on processing options:

Days Sales Outstanding (continued) DSO
• Accumulated Total Sales = Accumulated Total Sales + Sales Amount (SAG)
• Accumulated End Balance = Accumulated End Balance + Ending Balance Amount (ENBL)

• Accumulated Total Number Days = Accumulated Total Number Days + Days in Period (DAYP)

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:

• Accumulated Total Sales = Accumulated Total Sales + Sales Amount (SAG)

• Accumulated Total Number Days = Accumulated Total Number Days + Days in Period (DAYP)

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.

The following calculations are done per each period requested on processing options:

If Current Balance >= Sales Amount (SAG)

• Current Balance = Current Balance - Sales Amount (SAG)

• Accumulated Best DSO Days = Accumulated Best DSO Days + Days in Period (DAYP)

Else

• Accumulated Best DSO Days = Accumulated Best DSO Days + ((Current Balance / Sales Amount (SAG)) * Days in Period (DAYP))

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

The following calculations are done per each period before the current period based on periods requested on processing options:

• Accumulated Total Sales = Accumulated Total Sales + Sales Amount (SAG)

• Current Balance = Current Balance + Ending Balance Amount (ENBL) - Amount Past Due (DLBL)

• Accumulated Total Number Days = Accumulated Total Number Days + Days in Period (DAYP)

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:

• Accumulated Total Sales = Accumulated Total Sales + Sales Amount (SAG)

• Accumulated Total Number Days = Accumulated Total Number Days + Days in Period (DAYP)

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:

• Number of Days Late = Day Difference between Due Data (DDJ) and Receipt G/L Date (DGJ)

• Total Number of Days Late = Total Number of Days Late + Number of Days Late

Per each paid in full receipt (F03B14):

• Total Number of Days Late = Total Number of Days Late + Number of Days Late

• Total Amount Paid Late = Totals Amount Paid Late + Accumulated Payment Amount (F03B14.PAAP)

If total amount paid late is not zero:

• Current Average Days Late = (Number of Days Late (Accumulated Payment Amount (F03B14.PAAP) /Total Amount Paid Late)) *

• Previous Average Days Late = (Total Average Days Late * (Previous Payment Amount /Total Amount Paid Late))

• Total Average Days Late = Current Average Days Late / Previous Average Days Late

• Previous Payment Amount = Previous Payment Amount +Accumulated Payment Amount (F03B14.PAAP)

Average Days Late = Total Average Days Late

Average Days Late (continued) ADVDL If a F03B16 record exists:
• Previous Amount Paid Late = Payment Amount (F03B16.PAAP)

• Current Average Days Late = Total Average Days Late * (Total Amount Paid Late /Payment Amount (F03B16.PAAP))

• Payment Amount (F03B16.PAAP))Previous Average Days Late = Average Days Late (F03B16.AVDL) * (Previous Amount Paid Late /

• Average Days Late = Current Average Days Late + Previous Average Days

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:

• Total Number of Days Late = Total Number of Days Late + Number of Days Late

• Average Days Late Non- Weighted = (Total Number of Days Late / Number of Invoices Paid (F03B16.NINP))

If a F03B16 record exists:

• Previous Total Number of Days Late = (Average Days Late Non- Weighted (F03B16.AVDN) /Number of Invoices Paid (F03B16.NINP))

• Previous Total Number of Days Late = Previous Total Number of Days Late + Total Number of Days Late

• Average Days Late Non- Weighted = (Previous Total Number of Days Late /Number of Invoices Paid (F03B16.NINP))

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.

## C.2 Mapping Fields in the A/R Statistical Summary Table (F03B16S)

This section contains a list of the fields in the F03B16S table. Some of the fields are key fields.

### C.2.1 Fields in the F03B16S Table

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.