Value Types Used For Accounts Receivable Balance File

Overview

The column templates defined in (ARS066) are used when the accounts receivable balance file is displayed for the payers in 'Acc Receivable. Display Balances' (ARS225). The column templates defined in (ARS070) are used when the accounts receivable balance file is printed for selected payers in 'Acc Receivable. Print Balances' (ARS520).

The value types 20, 21, 22, and 23 are used for the four credit limits that are defined for the payer on 'Customer. Open' (CRS610/J) and stored in table OCUSMA.

The following table details the balances for all other value types which are stored in separate fields in table FSLBAL. These balances are primarily updated through the general ledger work file update program (GLS040), and during the night run when function program CRS930 (Update customer with invoice amount from ledger) is processed.

Value type in (ARS066) and (ARS070)	Field in FSLBAL	Field in OCUSMA	Description
1	TUOV		Turnover excluding VAT (local currency)
2	INAM		Amount invoiced (local currency)
3	PYAM		Amount paid (local currency)
4	OUAM		Outstanding amount (local currency)
5	TDIN		Amount past due (local currency)
6	OOAM		Drafts not past due. That is, drafts with a remittance status of less than 45 (local currency).
7	BLOA		Stopped amount (local currency)
8	ADEA		Allowance for doubtful debts (local currency)
10	ACAD		Debit amount (local currency)
11	ACAC		Credit (local currency)
20	-	CRLM	Credit limit 1
21	-	CRL2	Credit limit 2
22	-	CRL3	Credit limit 3
23	-	ODUD	Number of credit days
30	DSAM		DSO value
31	DSOC		DSO code
32	ACTO		Action code
40	PDNR		Payment document not submitted to bank
41	PDDR		Payment document past due
42	PDNC		Payment document risk not revoked
50	UNPM		Rejected amount - check or draft
51	UNPN		Rejected number of checks or drafts
61	O18L		Cash discount (local currency)
62	O19L		Payment tolerances (local currency)
63	O15L		Bill back invoice amount (local currency)
64	O16L		Debit note amount (local currency)
65	O20L		Write-offs using accounting options 20-99 (local currency)
101	TUOC		Turnover excluding VAT (foreign currency)
102	INAC		Amount invoiced (foreign currency)
103	PYAC		Amount paid (foreign currency)
104	OUAC		Outstanding amount (foreign currency)
105	TDIC		Amount past due (foreign currency)
106	OOAC		Drafts not past due. That is, drafts with a remittance status of less than 45 (foreign currency)
107	BLOC		Stopped amount (foreign currency)
110	CUAD		Debit (foreign currency)
111	CUAC		Credit (foreign currency)
161	O18C		Cash discount (foreign currency)
162	O19C		Payment tolerances (foreign currency)
163	O15C		Bill back invoice amount (foreign currency)
164	O16C		Debit note amount (foreign currency)
165	O20C		Write-offs using accounting options 20-99 (foreign currency)