C Mapping Fields for the Statistics History Update

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)"

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. 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) 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 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	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. 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) 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 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: 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.