ERPRef.com

140 COLUMNS | 5 INDICIES 920 | 03 | F0311 Accounts Receivable Ledger

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F0311	RP	140	5	Accounts Receivable Ledger	Transaction Files	03: Accounts Receivable	Business Data

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

140 COLUMNS | TOP 920 | 03 | F0311 Accounts Receivable Ledger

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

5 INDICIES | TOP 920 | 03 | F0311 Accounts Receivable Ledger

1: Document Type +A (Primary)

Element	Alias	Description	Sequence
6	DCTM	Document Type - Matching	Ascending
5	DOCM	Document - Matching(Payment or Item)	Ascending
4	SFX	Document Pay Item	Ascending
3	KCO	Document Company	Ascending
2	DCT	Document Type	Ascending
1	DOC	Document (Voucher Invoice etc.)	Ascending

2: Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

3: Doc Number Doc Type +B

Element	Alias	Description	Sequence
6	DCTM	Document Type - Matching	Ascending
5	DOCM	Document - Matching(Payment or Item)	Ascending
4	SFX	Document Pay Item	Descending
3	KCO	Document Company	Ascending
2	DCT	Document Type	Ascending
1	DOC	Document (Voucher Invoice etc.)	Ascending

4: Company

Element	Alias	Description	Sequence
1	CO	Company	Ascending

6: PO PO Type +C

Element	Alias	Description	Sequence
5	LNID	Line Number	Ascending
4	SFXO	Order Suffix	Ascending
3	PKCO	Document Company (Purchase Order)	Ascending
2	PDCT	Document Type - Purchase Order	Ascending
1	PO	Purchase Order	Ascending