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.