199 COLUMNS | 21 INDICIES 812 | 48S | F4812H Billing Workfile - History

SchemaNamePrefixColumnsIndiciesDescriptionTypeReportCategory
812 F4812H WD 199 21 Billing Workfile - History History Files 48S: Service Billing No

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.

199 COLUMNS | TOP 812 | 48S | F4812H Billing Workfile - History

Col#FieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement

21 INDICIES | TOP 812 | 48S | F4812H Billing Workfile - History

1: Billing Control ID G/L Date + (Primary/Unique)

ElementAliasDescriptionSequence
1 BCI Billing Control ID Ascending
2 DGL Date - For G/L (and Voucher) Ascending
3 PRSQ Parent Sequence Number Ascending
4 SBSQ Sequence Number Ascending
5 SCSQ Secondary Sequence Number Ascending
6 SLNK Split Link Ascending
7 CLNK Component Link Ascending
8 CCOD Component Code Ascending

2: Billing Cntl ID G/L Date +

ElementAliasDescriptionSequence
1 BCI Billing Control ID Ascending
2 DGL Date - For G/L (and Voucher) Ascending
3 SBSQ Sequence Number Ascending
4 SLNK Split Link Ascending
5 CLNK Component Link Ascending

3: Billing Control ID Seq No. +

ElementAliasDescriptionSequence
1 BCI Billing Control ID Ascending
2 SBSQ Sequence Number Ascending
3 SCSQ Secondary Sequence Number Ascending

4: Active Batch Number

ElementAliasDescriptionSequence
1 ICUA Batch Number - Active Ascending

5: Batch Number Inv Number +

ElementAliasDescriptionSequence
1 ICU Batch Number Ascending
2 DOCZ Document (Order # Invoice etc.) Ascending
3 DCTI Document Type - Invoice Only Ascending
4 KCOI Document Company (Invoice) Ascending
5 SFX Document Pay Item Ascending

6: Business Unit Last Seq. +

ElementAliasDescriptionSequence
1 MCU Business Unit Ascending
2 LSSQ Process Complete Ascending

7: Address No. Transaction No. +

ElementAliasDescriptionSequence
1 AN8 Address Number Ascending
2 PRTR Transaction No. - Payroll Ascending
3 DSVJ Date - Service/Tax Ascending
4 TCLS Transaction Classification Ascending

8: Business Unit Object +

ElementAliasDescriptionSequence
1 MCU Business Unit Ascending
2 OBJ Object Account Ascending
3 SUB Subsidiary Ascending
4 DGL Date - For G/L (and Voucher) Ascending
5 SBL Subledger - G/L Ascending
6 SBLT Subledger Type Ascending
7 JBCD Job Type (Craft) Code Ascending
8 JBST Job Step Ascending

9: Customer Business Unit +

ElementAliasDescriptionSequence
1 AN8O Address Number - Job A/R Ascending
2 MCU Business Unit Ascending
3 OBJ Object Account Ascending
4 SUB Subsidiary Ascending
5 SBL Subledger - G/L Ascending
6 SBLT Subledger Type Ascending
7 JBCD Job Type (Craft) Code Ascending
8 JBST Job Step Ascending
9 DGL Date - For G/L (and Voucher) Ascending

10: Contract Number Type +

ElementAliasDescriptionSequence
1 DOCO Document (Order No Invoice etc.) Ascending
2 DCTO Order Type Ascending
3 KCOO Order Company (Order Number) Ascending
4 COCH Contract Change Number Ascending
5 LNID Line Number Ascending
6 MCU Business Unit Ascending
7 OBJ Object Account Ascending
8 SUB Subsidiary Ascending

11: Invoice Number Type +

ElementAliasDescriptionSequence
1 DOCZ Document (Order # Invoice etc.) Ascending
2 DCTI Document Type - Invoice Only Ascending
3 KCOI Document Company (Invoice) Ascending
4 SFX Document Pay Item Ascending
5 MCU Business Unit Ascending
6 OBJ Object Account Ascending
7 SUB Subsidiary Ascending

12: Split Link Component Link +

ElementAliasDescriptionSequence
1 SLNK Split Link Ascending
2 CLNK Component Link Ascending
3 CCOD Component Code Ascending

13: Address Number Trans No. +

ElementAliasDescriptionSequence
1 AN8 Address Number Ascending
2 PRTR Transaction No. - Payroll Ascending
3 PDBA DBA Code Ascending
4 PTAX Tax Type Ascending

14: Component Link Comp Code +

ElementAliasDescriptionSequence
1 CLNK Component Link Ascending
2 CCOD Component Code Ascending

16: Subledger Subledger Type +

ElementAliasDescriptionSequence
1 SBL Subledger - G/L Ascending
2 SBLT Subledger Type Ascending
3 MCU Business Unit Ascending
4 OBJ Object Account Ascending
5 SUB Subsidiary Ascending
6 DGL Date - For G/L (and Voucher) Ascending
7 JBCD Job Type (Craft) Code Ascending
8 JBST Job Step Ascending

17: Contract Contract Type +

ElementAliasDescriptionSequence
1 DOCO Document (Order No Invoice etc.) Ascending
2 DCTO Order Type Ascending
3 KCOO Order Company (Order Number) Ascending
4 COCH Contract Change Number Ascending
5 OPIM Owner Pay Item Ascending

18: Split Link Comp Link +

ElementAliasDescriptionSequence
1 CLNK Component Link Ascending
2 SLNK Split Link Ascending
3 CCOD Component Code Ascending

21: Batch Number Doc Number +

ElementAliasDescriptionSequence
1 ICU Batch Number Ascending
2 DOCZ Document (Order # Invoice etc.) Ascending
3 DCTI Document Type - Invoice Only Ascending
4 KCOI Document Company (Invoice) Ascending

22: Doc Type Trans No. +

ElementAliasDescriptionSequence
1 DCT Document Type Ascending
2 PRTR Transaction No. - Payroll Ascending
3 AN8 Address Number Ascending
4 LSSQ Process Complete Ascending

23: Batch Number Contract No +A

ElementAliasDescriptionSequence
1 ICU Batch Number Descending
2 DOCO Document (Order No Invoice etc.) Descending
3 DCTO Order Type Ascending
4 KCOO Order Company (Order Number) Ascending
5 COCH Contract Change Number Ascending
6 LNID Line Number Ascending
7 CCR Component Cost Rate Table Ascending

24: Retro Adjustment Group BCI +

ElementAliasDescriptionSequence
1 RAG Retro Adjustment Group Ascending
2 BCI Billing Control ID Ascending
3 DGL Date - For G/L (and Voucher) Ascending
4 SBSQ Sequence Number Ascending
5 PRSQ Parent Sequence Number Ascending
6 SCSQ Secondary Sequence Number Ascending
7 SLNK Split Link Ascending
8 CLNK Component Link Ascending
9 CCOD Component Code Ascending