147 COLUMNS | 15 INDICIES 920 | 04 | F0411 Accounts Payable Ledger

SchemaNamePrefixColumnsIndiciesDescriptionTypeReportCategory
920 F0411 RP 147 15 Accounts Payable Ledger Transaction Files 04: Accounts Payable 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.

147 COLUMNS | TOP 920 | 04 | F0411 Accounts Payable Ledger

Col#FieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement

15 INDICIES | TOP 920 | 04 | F0411 Accounts Payable Ledger

1: Document Type + A (Primary/Unique)

ElementAliasDescriptionSequence
5 SFXE Pay Item Extension Number 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: Document Type + B

ElementAliasDescriptionSequence
3 KCO Document Company Ascending
2 DCT Document Type Ascending
1 DOC Document (Voucher Invoice etc.) Ascending

3: Batch Type Number + A

ElementAliasDescriptionSequence
7 GLC G/L Offset Ascending
6 CO Company Ascending
5 DOC Document (Voucher Invoice etc.) Ascending
4 DCT Document Type Ascending
3 KCO Document Company Ascending
2 ICU Batch Number Ascending
1 ICUT Batch Type Ascending

4: Batch Type Number + B

ElementAliasDescriptionSequence
7 CTRY Century Ascending
6 FY Fiscal Year Ascending
5 PN Period Number - General Ledger Ascending
4 GLC G/L Offset Ascending
3 CO Company Ascending
2 ICU Batch Number Ascending
1 ICUT Batch Type Ascending

5: Batch Type Number +C

ElementAliasDescriptionSequence
3 POST G/L Posted Code Ascending
2 ICUT Batch Type Ascending
1 ICU Batch Number Ascending

6: Supplier Invoice Number +

ElementAliasDescriptionSequence
3 DIVJ Date - Invoice - Julian Descending
2 VINV Supplier Invoice Number Ascending
1 AN8 Address Number Ascending

7: Address Number Due Date +A

ElementAliasDescriptionSequence
7 SFXE Pay Item Extension Number Ascending
6 SFX Document Pay Item Ascending
5 KCO Document Company Ascending
4 DOC Document (Voucher Invoice etc.) Ascending
3 DCT Document Type Ascending
2 DDJ Date - Net Due Ascending
1 AN8 Address Number Ascending

8: Address Num Doc Type +A

ElementAliasDescriptionSequence
6 SFXE Pay Item Extension Number Ascending
5 SFX Document Pay Item Ascending
4 KCO Document Company Ascending
3 DOC Document (Voucher Invoice etc.) Ascending
2 DCT Document Type Ascending
1 AN8 Address Number Ascending

9: Address Num PO +A

ElementAliasDescriptionSequence
7 KCO Document Company Ascending
6 DCT Document Type Ascending
5 DOC Document (Voucher Invoice etc.) Ascending
4 PKCO Document Company (Purchase Order) Ascending
3 PDCT Document Type - Purchase Order Ascending
2 PO Purchase Order Ascending
1 AN8 Address Number Ascending

10: Sent to Suplier +A

ElementAliasDescriptionSequence
3 DDJ Date - Net Due Descending
2 AN8 Address Number Ascending
1 SNTO Address Number - Approver Ascending

11: PayeeNumber Doc Type +A

ElementAliasDescriptionSequence
6 SFXE Pay Item Extension Number Ascending
5 SFX Document Pay Item Ascending
4 KCO Document Company Ascending
3 DOC Document (Voucher Invoice etc.) Ascending
2 DCT Document Type Ascending
1 PYE Payee Address Number Ascending

12: PWP No Address Num +A

ElementAliasDescriptionSequence
3 PST Pay Status Code Ascending
2 AN8 Address Number Ascending
1 PWPG Pay When Paid Group Number Ascending

13: NetTId NetDoc +A

ElementAliasDescriptionSequence
3 NETRC5 Netting Line ID Ascending
2 NETDOC Netting Document Number Ascending
1 NETTCID Netting Transaction ID Ascending

14: NetTId NetDoc +B

ElementAliasDescriptionSequence
4 VOD Void Flag Ascending
3 NETRC5 Netting Line ID Ascending
2 NETDOC Netting Document Number Ascending
1 NETTCID Netting Transaction ID Ascending

15: Contract Harvest +A

ElementAliasDescriptionSequence
5 RP1 A/R - A/P - Miscellaneous Code 1 Ascending
4 SEQN Sequence Number Ascending
3 PYE Payee Address Number Ascending
2 WVID Vessel ID Ascending
1 CNTRTID Contract ID Ascending