141 COLUMNS | 24 INDICIES 920 | 00 | F0911 Account Ledger

SchemaNamePrefixColumnsIndiciesDescriptionTypeReportCategory
920 F0911 GL 141 24 Account Ledger Transaction Files 09: General Accounting 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.

141 COLUMNS | TOP 920 | 00 | F0911 Account Ledger

Col#FieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement

24 INDICIES | TOP 920 | 00 | F0911 Account Ledger

1: Doc Type Number + (Primary/Unique)

ElementAliasDescriptionSequence
7 EXTL Line Extension Code Ascending
6 LT Ledger Types Ascending
5 JELN Journal Entry Line Number Ascending
4 DGJ Date - For G/L (and Voucher) - Julian Descending
3 KCO Document Company Ascending
2 DOC Document (Voucher Invoice etc.) Ascending
1 DCT Document Type Ascending

6: Post Code Batch Type +

ElementAliasDescriptionSequence
10 EXTL Line Extension Code Ascending
9 JELN Journal Entry Line Number Ascending
8 DCT Document Type Ascending
7 KCO Document Company Ascending
6 DOC Document (Voucher Invoice etc.) Ascending
5 DGJ Date - For G/L (and Voucher) - Julian Ascending
4 LT Ledger Types Ascending
3 ICU Batch Number Ascending
2 ICUT Batch Type Ascending
1 POST G/L Posted Code Ascending

8: Reconcile Account ID +

ElementAliasDescriptionSequence
5 DGJ Date - For G/L (and Voucher) - Julian Ascending
4 DCT Document Type Ascending
3 LT Ledger Types Ascending
2 AID Account ID Ascending
1 RCND Reconciled Code Ascending

9: Post Code Acct ID +A

ElementAliasDescriptionSequence
10 DGJ Date - For G/L (and Voucher) - Julian Ascending
9 CRCD Currency Code - From Ascending
8 SBLT Subledger Type Ascending
7 SBL Subledger - G/L Ascending
6 PN Period Number - General Ledger Ascending
5 FY Fiscal Year Ascending
4 CTRY Century Ascending
3 LT Ledger Types Ascending
2 AID Account ID Ascending
1 POST G/L Posted Code Ascending

10: Post Code Acct ID +B

ElementAliasDescriptionSequence
11 BRE Batch Rear End Posted Code Ascending
10 ASID Serial Number Ascending
9 DGJ Date - For G/L (and Voucher) - Julian Ascending
8 SBLT Subledger Type Ascending
7 SBL Subledger - G/L Ascending
6 PN Period Number - General Ledger Ascending
5 FY Fiscal Year Ascending
4 CTRY Century Ascending
3 LT Ledger Types Ascending
2 AID Account ID Ascending
1 POST G/L Posted Code Ascending

11: Post Code Acct ID +C

ElementAliasDescriptionSequence
8 DGJ Date - For G/L (and Voucher) - Julian Ascending
7 CRCD Currency Code - From Ascending
6 PN Period Number - General Ledger Ascending
5 FY Fiscal Year Ascending
4 CTRY Century Ascending
3 LT Ledger Types Ascending
2 AID Account ID Ascending
1 POST G/L Posted Code Ascending

12: Batch Type Number +

ElementAliasDescriptionSequence
6 DGJ Date - For G/L (and Voucher) - Julian Ascending
5 KCO Document Company Ascending
4 DOC Document (Voucher Invoice etc.) Ascending
3 DCT Document Type Ascending
2 ICU Batch Number Ascending
1 ICUT Batch Type Ascending

13: Post Code Acct ID +D

ElementAliasDescriptionSequence
7 DGJ Date - For G/L (and Voucher) - Julian Ascending
6 PN Period Number - General Ledger Ascending
5 FY Fiscal Year Ascending
4 CTRY Century Ascending
3 LT Ledger Types Ascending
2 AID Account ID Ascending
1 POST G/L Posted Code Ascending

15: Doc Type Number +B

ElementAliasDescriptionSequence
7 JELN Journal Entry Line Number Descending
6 EXTL Line Extension Code Ascending
5 LT Ledger Types Ascending
4 DGJ Date - For G/L (and Voucher) - Julian Ascending
3 KCO Document Company Ascending
2 DOC Document (Voucher Invoice etc.) Ascending
1 DCT Document Type Ascending

17: LC DCT EXA DOC KCO

ElementAliasDescriptionSequence
4 KCO Document Company Ascending
3 DOC Document (Voucher Invoice etc.) Ascending
2 EXA Name - Alpha Explanation Ascending
1 DCT Document Type Ascending

18: LD AID LT DGJ CRCD

ElementAliasDescriptionSequence
6 SBLT Subledger Type Ascending
5 SBL Subledger - G/L Ascending
4 CRCD Currency Code - From Ascending
3 DGJ Date - For G/L (and Voucher) - Julian Descending
2 LT Ledger Types Ascending
1 AID Account ID Ascending

19: Type Number +C ascending

ElementAliasDescriptionSequence
7 JELN Journal Entry Line Number Ascending
6 EXTL Line Extension Code Ascending
5 LT Ledger Types Ascending
4 DGJ Date - For G/L (and Voucher) - Julian Ascending
3 KCO Document Company Ascending
2 DOC Document (Voucher Invoice etc.) Ascending
1 DCT Document Type Ascending

23: Asset No Account ID +

ElementAliasDescriptionSequence
5 DCT Document Type Ascending
4 DGJ Date - For G/L (and Voucher) - Julian Ascending
3 LT Ledger Types Ascending
2 AID Account ID Ascending
1 ASID Serial Number Ascending

24: Bill Code Ledger Type +

ElementAliasDescriptionSequence
8 DGJ Date - For G/L (and Voucher) - Julian Ascending
7 SBLT Subledger Type Ascending
6 SBL Subledger - G/L Ascending
5 SUB Subsidiary Ascending
4 OBJ Object Account Ascending
3 MCU Business Unit Ascending
2 LT Ledger Types Ascending
1 BC Bill Code Ascending

25: Company Business Unit +

ElementAliasDescriptionSequence
11 AN8 Address Number Ascending
10 DCT Document Type Ascending
9 POST G/L Posted Code Ascending
8 SBLT Subledger Type Ascending
7 SBL Subledger - G/L Ascending
6 LT Ledger Types Ascending
5 DGJ Date - For G/L (and Voucher) - Julian Ascending
4 OBJ Object Account Ascending
3 SUB Subsidiary Ascending
2 MCU Business Unit Ascending
1 CO Company Ascending

27: Post LedgerType +

ElementAliasDescriptionSequence
4 DGJ Date - For G/L (and Voucher) - Julian Descending
3 AID Account ID Ascending
2 LT Ledger Types Ascending
1 POST G/L Posted Code Ascending

28: AccountID Reference1

ElementAliasDescriptionSequence
2 R1 Reference 1 - JE Voucher Invoice etc. Ascending
1 AID Account ID Ascending

29: AccountID Century FiscalYr +

ElementAliasDescriptionSequence
8 CRCD Currency Code - From Ascending
7 SBLT Subledger Type Ascending
6 SBL Subledger - G/L Ascending
5 LT Ledger Types Ascending
4 FQ Fiscal Quarter (Obsolete) Ascending
3 FY Fiscal Year Ascending
2 CTRY Century Ascending
1 AID Account ID Ascending

30: Post Batch+ DescendingDCT +

ElementAliasDescriptionSequence
10 EXTL Line Extension Code Ascending
9 JELN Journal Entry Line Number Ascending
8 DCT Document Type Descending
7 KCO Document Company Descending
6 DOC Document (Voucher Invoice etc.) Ascending
5 DGJ Date - For G/L (and Voucher) - Julian Ascending
4 LT Ledger Types Ascending
3 ICU Batch Number Ascending
2 ICUT Batch Type Ascending
1 POST G/L Posted Code Ascending

32: SBL SBLT LT

ElementAliasDescriptionSequence
3 LT Ledger Types Ascending
2 SBLT Subledger Type Ascending
1 SBL Subledger - G/L Ascending

33: AccountID Century FiscalYr +A

ElementAliasDescriptionSequence
8 CRCD Currency Code - From Ascending
7 SBL Subledger - G/L Ascending
6 SBLT Subledger Type Ascending
5 LT Ledger Types Ascending
4 FQ Fiscal Quarter (Obsolete) Ascending
3 FY Fiscal Year Ascending
2 CTRY Century Ascending
1 AID Account ID Ascending

34: Batch Line_Ext Post_Code

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

35: AID LT DGJ DCT DOC KCO SBL

ElementAliasDescriptionSequence
8 SBLT Subledger Type Ascending
7 SBL Subledger - G/L Ascending
6 KCO Document Company Ascending
5 DOC Document (Voucher Invoice etc.) Ascending
4 DCT Document Type Ascending
3 DGJ Date - For G/L (and Voucher) - Julian Ascending
2 LT Ledger Types Ascending
1 AID Account ID Ascending

36: DCT DOC KCO DGJ LT DISTINCT

ElementAliasDescriptionSequence
5 LT Ledger Types Ascending
4 DGJ Date - For G/L (and Voucher) - Julian Descending
3 KCO Document Company Ascending
2 DOC Document (Voucher Invoice etc.) Ascending
1 DCT Document Type Ascending