JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

203 COLUMNS | 22 INDEXES | Print definition?910 | 48S | F4812H TABLE

48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4812HWD20322Billing Workfile HistoryHistory Files48S: Service BillingBusiness Data
SQL:  selectupdate insert create

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.

SELECT WDDCT, WDDOC, WDKCO, WDDGL, WDJELN, WDAID, WDMCU, WDRP11, WDOBJ, WDSUB, WDSBL, WDSBLT, WDOPSQ, WDWR01, WDWR07, WDLT, WDCTRY, WDFY, WDPN, WDCO, WDODCT, WDOSFX, WDODOC, WDOKCO, WDPO, WDPDCT, WDPKCO, WDPSFX, WDOGNO, WDR001, WDR002, WDR003, WDPRTR, WDJBCD, WDJBST, WDPDBA, WDPTAX, WDEQCG, WDEQWO, WDACL0, WDERC, WDAN8, WDDC, WDHMCU, WDJMCU, WDRP12, WDDSVJ, WDDAGO, WDAGS, WDEXA, WDEXR, WDPCFG, WDPRIC, WDU, WDUM, WDAA, WDDOCM, WDDOCO, WDDCTO, WDKCOO, WDCOCH, WDLNID, WDOPIM, WDPCTN, WDPCTT, WDPCKO, WDPRSQ, WDSBSQ, WDSCSQ, WDBCI, WDLSSQ, WDPMSQ, WDLSPM, WDTCLS, WDELGC, WDJRST, WDICUJ, WDIVD, WDHLD, WDRDJ, WDVOID, WDICUA, WDJRSP, WDBDPN, WDSLNK, WDCLNK, WDCCOD, WDCCR, WDCINR, WDCRVR, WDSBAR, WDTBDT, WDCAP, WDBRT, WDPERT, WDADCR, WDCAPI, WDBRTI, WDPCIM, WDADCI, WDTX, WDTOG, WDEXR1, WDTXA1, WDDCP, WDJTAX, WDJTXF, WDBTOL, WDCRCD, WDCRR, WDCRRM, WDFTOL, WDITOL, WDITXA, WDITAM, WDIDSC, WDCITL, WDCITA, WDCITX, WDCIDS, WDIJST, WDPRTF, WDICU, WDAN8O, WDVINV, WDDI, WDDOCZ, WDDCTI, WDKCOI, WDSFX, WDSBSK, WDBLKK, WDAID5, WDSBL5, WDSBT5, WDAID6, WDSBL6, WDSBT6, WDAREX, WDGLC, WDRGLC, WDPRET, WDRTNG, WDRTPS, WDFRTN, WDDWNL, WDCBLC, WDDEJ, WDCRRD, WDCRCE, WDCRCF, WDAA2, WDTYKY, WDDGJ, WDIDGJ, WDPTFG, WDITM, WDPAID, WDFEA, WDERDB, WDERDT, WDSUBA, WDBCTK, WDPARS, WDPRGR, WDCPGP, WDBBF, WDMKRP, WDFBAS, WDRFBS, WDTKM1, WDTKM2, WDTKM3, WDTKA1, WDTKA2, WDTKA3, WDTKG1, WDTKT1, WDHBTL, WDHITL, WDHITX, WDHTAM, WDPRIF, WDNCTL, WDUSER, WDJOBN, WDPID, WDUPMJ, WDUPMT, WDVGCSF, WDVGCOA, WDVVTY, WDVVTC, WDRAS, WDRAG, WDJPGC, WDBUF, WDAA3, WDACR, WDPRTP, WDHBIN, WDHBRV, WDBPTX FROM F4812H

TOP910 | 48S | F4812H COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
2WDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3WDKCODocument CompanyStringGeneric Edit50 Allow NULL? 
4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
5WDJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
6WDAIDAccount IDStringGeneric Edit80 Allow NULL? 
7WDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
8WDRP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
9WDOBJObject AccountStringGeneric Edit60 Allow NULL? 
10WDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
11WDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
12WDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
13WDOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
14WDWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
15WDWR07EnterpriseOne Consulting - Service TypeStringUDC (00 W7)30 Allow NULL? 
16WDLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
17WDCTRYCenturyNumericGeneric Edit20 Allow NULL? 
18WDFYFiscal YearNumericGeneric Edit20 Allow NULL? 
19WDPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
20WDCOCompanyStringGeneric Edit50 Allow NULL? 
21WDODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
22WDOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
23WDODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
24WDOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
25WDPOPurchase OrderStringGeneric Edit80 Allow NULL? 
26WDPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
27WDPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
28WDPSFXPurchase Order SuffixStringGeneric Edit30 Allow NULL? 
29WDOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
30WDR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
31WDR002Category Code - G/L2StringUDC (09 02)30 Allow NULL? 
32WDR003Category Code - G/L3StringUDC (09 03)30 Allow NULL? 
33WDPRTRTransaction No. - PayrollNumericGeneric Edit90 Allow NULL? 
34WDJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
35WDJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
36WDPDBADBA CodeNumericGeneric Edit50 Allow NULL? 
37WDPTAXTax TypeStringUDC (06 TX)20 Allow NULL? 
38WDEQCGEquipment WorkedStringGeneric Edit90 Allow NULL? 
39WDEQWOEquipment Worked OnStringGeneric Edit90 Allow NULL? 
40WDACL0Category Code - F/A 10 (Rate Group)StringUDC (12 C0)30 Allow NULL? 
41WDERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
42WDAN8Address NumberNumericUDC80 Allow NULL? 
43WDDCDescription - CompressedStringGeneric Edit400 Allow NULL? 
44WDHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
45WDJMCUBusiness Unit - HostStringGeneric Edit120 Allow NULL? 
46WDRP12Category Code - Business Unit 12StringUDC (00 12)30 Allow NULL? 
47WDDSVJDate - Service/TaxDateGeneric Edit60
48WDDAGODate - Age OverrideDateGeneric Edit60
49WDAGSSuspend AgingCharacterGeneric Edit10 Allow NULL? 
50WDEXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
51WDEXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
52WDPCFGBurden FlagCharacterUDC (48 PC)10 Allow NULL? 
53WDPRICUnit Price per PrimaryNumericGeneric Edit154 Allow NULL? 
54WDUUnitsNumericGeneric Edit152 Allow NULL? 
55WDUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
56WDAAAmountNumericGeneric Edit152 Allow NULL? 
57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80 Allow NULL? 
58WDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
59WDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
60WDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
61WDCOCHContract Change NumberStringGeneric Edit30 Allow NULL? 
62WDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
63WDOPIMOwner Pay ItemStringGeneric Edit150 Allow NULL? 
64WDPCTNParent Contract NumberNumericGeneric Edit80 Allow NULL? 
65WDPCTTParent Contract TypeStringUDC (00 DT)20 Allow NULL? 
66WDPCKOParent Contract Document CompanyStringGeneric Edit50 Allow NULL? 
67WDPRSQParent Sequence NumberNumericGeneric Edit30 Allow NULL? 
68WDSBSQSequence NumberNumericGeneric Edit30 Allow NULL? 
69WDSCSQSecondary Sequence NumberNumericGeneric Edit30 Allow NULL? 
70WDBCIBilling Control IDNumericGeneric Edit80 Allow NULL? 
71WDLSSQProcess CompleteCharacterUDC (48 LQ)10 Allow NULL? 
72WDPMSQPayment Sequence NumberNumericGeneric Edit30 Allow NULL? 
73WDLSPMRevenue CompletedCharacterUDC (48 LS)10 Allow NULL? 
74WDTCLSTransaction ClassificationCharacterUDC (48 TC)10 Allow NULL? 
75WDELGCEligibility CodeCharacterUDC (48 EL)10 Allow NULL? 
76WDJRSTJournal Status CodeCharacterUDC (48 JR)10 Allow NULL? 
77WDICUJBatch Number - RevenueNumericGeneric Edit80 Allow NULL? 
78WDIVDDate - InvoiceDateGeneric Edit60
79WDHLDHold Code - Service Billing TransactionCharacterUDC (48 HL)10 Allow NULL? 
80WDRDJDate - Released (Julian)DateGeneric Edit60
81WDVOIDVoid (V)CharacterUDC (H09 VO)10 Allow NULL? 
82WDICUABatch Number - ActiveNumericGeneric Edit80 Allow NULL? 
83WDJRSPJournal Status Code - PreviousCharacterUDC (48 JR)10 Allow NULL? 
84WDBDPNBurden PendingCharacterUDC (48 BE)10 Allow NULL? 
85WDSLNKSplit LinkNumericGeneric Edit110 Allow NULL? 
86WDCLNKComponent LinkNumericGeneric Edit110 Allow NULL? 
87WDCCODComponent CodeStringUDC (48 CM)50 Allow NULL? 
88WDCCRComponent Cost Rate TableStringGeneric Edit100 Allow NULL? 
89WDCINRComponent Invoice Rate TableStringGeneric Edit100 Allow NULL? 
90WDCRVRComponent Revenue Rate TableStringGeneric Edit100 Allow NULL? 
91WDSBARAdjustment Reason CodeStringUDC (48 AR)20 Allow NULL? 
92WDTBDTDate - Table Basis (Julian)DateGeneric Edit60
93WDCAPCap or Override RateCharacterUDC (48 CA)10 Allow NULL? 
94WDBRTRevenue Rate Markup OverrideNumericGeneric Edit152 Allow NULL? 
95WDPERTPercentage - Revenue MarkupNumericGeneric Edit73 Allow NULL? 
96WDADCRAmount - Revenue MarkupNumericGeneric Edit152 Allow NULL? 
97WDCAPICap or Override Rate - InvoiceCharacterUDC (48 CB)10 Allow NULL? 
98WDBRTIInvoice Markup Rate OverrideNumericGeneric Edit152 Allow NULL? 
99WDPCIMPercentage - Invoice MarkupNumericGeneric Edit73 Allow NULL? 
100WDADCIAmount - Invoice MarkupNumericGeneric Edit152 Allow NULL? 
101WDTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
102WDTOGTaxable or GrossCharacterUDC (48 TO)10 Allow NULL? 
103WDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
104WDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
105WDDCPDiscount % - Payment TermsNumericGeneric Edit50 Allow NULL? 
106WDJTAXAmount - Journaled TaxNumericGeneric Edit152 Allow NULL? 
107WDJTXFAmount - Journaled Tax - ForeignNumericGeneric Edit152 Allow NULL? 
108WDBTOLAmount - RevenueNumericGeneric Edit152 Allow NULL? 
109WDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
110WDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
111WDCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
112WDFTOLAmount - Foreign Total BilledNumericGeneric Edit152 Allow NULL? 
113WDITOLAmount - InvoiceNumericGeneric Edit152 Allow NULL? 
114WDITXAAmount - Invoice taxableNumericGeneric Edit152 Allow NULL? 
115WDITAMAmount - Invoice TaxNumericGeneric Edit152 Allow NULL? 
116WDIDSCAmount - Invoice Discount AvailableNumericGeneric Edit152 Allow NULL? 
117WDCITLAmount - Foreign InvoicedNumericGeneric Edit152 Allow NULL? 
118WDCITAAmount - Foreign invoice taxableNumericGeneric Edit152 Allow NULL? 
119WDCITXAmount - Foreign Invoice TaxNumericGeneric Edit152 Allow NULL? 
120WDCIDSAmount - Foreign Invoice Discount AvailNumericGeneric Edit152 Allow NULL? 
121WDIJSTInvoice Journal Status CodeCharacterUDC (48 IJ)10 Allow NULL? 
122WDPRTFPrinted FlagCharacterUDC (48 PS)10 Allow NULL? 
123WDICUBatch NumberNumericGeneric Edit80 Allow NULL? 
124WDAN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
125WDVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
126WDDIDate - InvoiceDateGeneric Edit60
127WDDOCZDocument (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
128WDDCTIDocument Type - Invoice OnlyStringUDC (00 DI)20 Allow NULL? 
129WDKCOIDocument Company (Invoice)StringGeneric Edit50 Allow NULL? 
130WDSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
131WDSBSKSummarization Key - Service BillingStringGeneric Edit40 Allow NULL? 
132WDBLKKComposite Key BlockStringGeneric Edit800 Allow NULL? 
133WDAID5Account IDStringGeneric Edit80 Allow NULL? 
134WDSBL5SubledgerStringGeneric Edit80 Allow NULL? 
135WDSBT5Subledger TypeCharacterUDC (00 ST)10 Allow NULL? 
136WDAID6Account IDStringGeneric Edit80 Allow NULL? 
137WDSBL6SubledgerStringGeneric Edit80 Allow NULL? 
138WDSBT6Subledger TypeCharacterUDC (00 ST)10 Allow NULL? 
139WDAREXOverride Bill When Paid RuleCharacterUDC (52 OR)10 Allow NULL? 
140WDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
141WDRGLCRetention G/L OffsetStringGeneric Edit40 Allow NULL? 
142WDPRETPercent RetainageNumericGeneric Edit52 Allow NULL? 
143WDRTNGRetainageNumericGeneric Edit152 Allow NULL? 
144WDRTPSRetainage - Prior - Stored MaterialNumericGeneric Edit152 Allow NULL? 
145WDFRTNForeign RetainageNumericGeneric Edit152 Allow NULL? 
146WDDWNLDownload Flag - Service BillingCharacterUDC (48 DW)10 Allow NULL? 
147WDCBLCCoding Block ChangeCharacterUDC (48 CO)10 Allow NULL? 
148WDDEJDate - Transaction EnteredDateGeneric Edit60
149WDCRRDCurrency Conversion Rate - DivisorNumericGeneric Edit150 Allow NULL? 
150WDCRCECurrency Code - SourceStringGeneric Edit30 Allow NULL? 
151WDCRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
152WDAA2AmountNumericGeneric Edit152 Allow NULL? 
153WDTYKYKey TypeCharacterUDC (48 TY)10 Allow NULL? 
154WDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
155WDIDGJDate - Invoice Journal Date - JulianDateGeneric Edit60
156WDPTFGPay When Paid FlagCharacterGeneric Edit10 Allow NULL? 
157WDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
158WDPAIDAmount - Extended Cost/PriceNumericGeneric Edit152 Allow NULL? 
159WDFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
160WDERDBDate - Exchange Rate Date BasisCharacterGeneric Edit10 Allow NULL? 
161WDERDTDate - Exchange RateDateGeneric Edit60
162WDSUBASubsidiary - AlternateStringGeneric Edit80 Allow NULL? 
163WDBCTKBatch Control KeyStringGeneric Edit100 Allow NULL? 
164WDPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
165WDPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
166WDCPGPCustomer Price GroupStringUDC (40 PC)80 Allow NULL? 
167WDBBFBilling Basis FlagCharacterGeneric Edit10 Allow NULL? 
168WDMKRP% FeeNumericGeneric Edit94 Allow NULL? 
169WDFBASInvoice Fee BasisCharacterUDC (H50 FB)10 Allow NULL? 
170WDRFBSRevenue Fee BasisCharacterUDC (H50 RF)10 Allow NULL? 
171WDTKM1Key Type - Markup Table Type 1CharacterUDC (48 TY)10 Allow NULL? 
172WDTKM2Key Type - Markup Table Type 2CharacterUDC (48 TY)10 Allow NULL? 
173WDTKM3Key Type - Markup Table Type 3CharacterUDC (48 TY)10 Allow NULL? 
174WDTKA1Key Type - Acct Derivation Table 1CharacterUDC (48 TY)10 Allow NULL? 
175WDTKA2Key Type - Acct Derivation Table 2CharacterUDC (48 TY)10 Allow NULL? 
176WDTKA3Key Type - Acct Derivation Table 3CharacterUDC (48 TY)10 Allow NULL? 
177WDTKG1Key Type - G/L Offset TableCharacterUDC (48 TY)10 Allow NULL? 
178WDTKT1Key Type - Tax Derivation TableCharacterUDC (48 TY)10 Allow NULL? 
179WDHBTLAmount - Revenue - HistoricalNumericGeneric Edit152 Allow NULL? 
180WDHITLAmount - Invoice - HistoricalNumericGeneric Edit152 Allow NULL? 
181WDHITXAmount - Invoice Taxable- HistoricalNumericGeneric Edit152 Allow NULL? 
182WDHTAMAmount - Invoice Taxable- HistoricalNumericGeneric Edit152 Allow NULL? 
183WDPRIFUnit Price per Primary-ForeignNumericGeneric Edit154 Allow NULL? 
184WDNCTLNTE Control FlagCharacterGeneric Edit10 Allow NULL? 
185WDUSERUser IDStringGeneric Edit100 Allow NULL? 
186WDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
187WDPIDProgram IDStringGeneric Edit100 Allow NULL? 
188WDUPMJDate - UpdatedDateGeneric Edit60
189WDUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
190WDVGCSFGeoCode Ship FromStringGeneric Edit100 Allow NULL? 
191WDVGCOAGeoCode Order AcceptStringGeneric Edit100 Allow NULL? 
192WDVVTYVertex Transaction TypeStringUDC (73 TY)60 Allow NULL? 
193WDVVTCVertex Product CategoryStringUDC (73 PC)100 Allow NULL? 
194WDRASRe-burdening Adjustment StatusCharacterUDC (48S RS)10 Allow NULL? 
195WDRAGRe-burdening Adjustment GroupNumericGeneric Edit80 Allow NULL? 
196WDJPGCJob Pool Grouping CodeStringUDC (00 12)30 Allow NULL? 
197WDBUFBurdening Used FlagCharacterGeneric Edit10 Allow NULL? 
198WDAA3AmountNumericGeneric Edit152 Allow NULL? 
199WDACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
200WDPRTPPricing Type - ContractsCharacterUDC (52 PT)10 Allow NULL? 
201WDHBINAmount - Historical Burdened InvoiceNumericGeneric Edit152 Allow NULL? 
202WDHBRVAmount - Historical Burdened RevenueNumericGeneric Edit152 Allow NULL? 
203WDBPTXBase Pay Transaction NumberNumericGeneric Edit90 Allow NULL? 

TOP910 | 48S | F4812H INDEXES

NumberDescription
1Billing Control ID G/L Date + (Primary/Unique)
ElementAliasDescriptionSequence
1BCIBilling Control IDAscending
2DGLDate - For G/L (and Voucher)Ascending
3PRSQParent Sequence NumberAscending
4SBSQSequence NumberAscending
5SCSQSecondary Sequence NumberAscending
6SLNKSplit LinkAscending
7CLNKComponent LinkAscending
8CCODComponent CodeAscending
2Billing Cntl ID G/L Date +
ElementAliasDescriptionSequence
1BCIBilling Control IDAscending
2DGLDate - For G/L (and Voucher)Ascending
3SBSQSequence NumberAscending
4SLNKSplit LinkAscending
5CLNKComponent LinkAscending
3Billing Control ID Seq No. +
ElementAliasDescriptionSequence
1BCIBilling Control IDAscending
2SBSQSequence NumberAscending
3SCSQSecondary Sequence NumberAscending
4Active Batch Number
ElementAliasDescriptionSequence
1ICUABatch Number - ActiveAscending
5Batch Number Inv Number +
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2DOCZDocument (Order # Invoice etc.)Ascending
3DCTIDocument Type - Invoice OnlyAscending
4KCOIDocument Company (Invoice)Ascending
5SFXDocument Pay ItemAscending
6Business Unit Last Seq. +
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2LSSQProcess CompleteAscending
7Address No. Transaction No. +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PRTRTransaction No. - PayrollAscending
3DSVJDate - Service/TaxAscending
4TCLSTransaction ClassificationAscending
8Business Unit Object +
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2OBJObject AccountAscending
3SUBSubsidiaryAscending
4DGLDate - For G/L (and Voucher)Ascending
5SBLSubledger - G/LAscending
6SBLTSubledger TypeAscending
7JBCDJob Type (Craft) CodeAscending
8JBSTJob StepAscending
9Customer Business Unit +
ElementAliasDescriptionSequence
1AN8OAddress Number - Job A/RAscending
2MCUBusiness UnitAscending
3OBJObject AccountAscending
4SUBSubsidiaryAscending
5SBLSubledger - G/LAscending
6SBLTSubledger TypeAscending
7JBCDJob Type (Craft) CodeAscending
8JBSTJob StepAscending
9DGLDate - For G/L (and Voucher)Ascending
10Contract Number Type +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4COCHContract Change NumberAscending
5LNIDLine NumberAscending
6MCUBusiness UnitAscending
7OBJObject AccountAscending
8SUBSubsidiaryAscending
11Invoice Number Type +
ElementAliasDescriptionSequence
1DOCZDocument (Order # Invoice etc.)Ascending
2DCTIDocument Type - Invoice OnlyAscending
3KCOIDocument Company (Invoice)Ascending
4SFXDocument Pay ItemAscending
5MCUBusiness UnitAscending
6OBJObject AccountAscending
7SUBSubsidiaryAscending
12Split Link Component Link +
ElementAliasDescriptionSequence
1SLNKSplit LinkAscending
2CLNKComponent LinkAscending
3CCODComponent CodeAscending
4OPIMOwner Pay ItemAscending
13Address Number Trans No. +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PRTRTransaction No. - PayrollAscending
3PDBADBA CodeAscending
4PTAXTax TypeAscending
14Component Link Comp Code +
ElementAliasDescriptionSequence
1CLNKComponent LinkAscending
2CCODComponent CodeAscending
16Subledger Subledger Type +
ElementAliasDescriptionSequence
1SBLSubledger - G/LAscending
2SBLTSubledger TypeAscending
3MCUBusiness UnitAscending
4OBJObject AccountAscending
5SUBSubsidiaryAscending
6DGLDate - For G/L (and Voucher)Ascending
7JBCDJob Type (Craft) CodeAscending
8JBSTJob StepAscending
17Contract Contract Type +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4COCHContract Change NumberAscending
5OPIMOwner Pay ItemAscending
18Split Link Comp Link +
ElementAliasDescriptionSequence
1CLNKComponent LinkAscending
2SLNKSplit LinkAscending
3CCODComponent CodeAscending
21Batch Number Doc Number +
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2DOCZDocument (Order # Invoice etc.)Ascending
3DCTIDocument Type - Invoice OnlyAscending
4KCOIDocument Company (Invoice)Ascending
22Doc Type Trans No. +
ElementAliasDescriptionSequence
1DCTDocument TypeAscending
2PRTRTransaction No. - PayrollAscending
3AN8Address NumberAscending
4LSSQProcess CompleteAscending
23Batch Number Contract No +A
ElementAliasDescriptionSequence
1ICUBatch NumberDescending
2DOCODocument (Order No Invoice etc.)Descending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5COCHContract Change NumberAscending
6LNIDLine NumberAscending
7CCRComponent Cost Rate TableAscending
24Retro Adjustment Group BCI +
ElementAliasDescriptionSequence
1RAGRe-burdening Adjustment GroupAscending
2BCIBilling Control IDAscending
3DGLDate - For G/L (and Voucher)Ascending
4SBSQSequence NumberAscending
5PRSQParent Sequence NumberAscending
6SCSQSecondary Sequence NumberAscending
7SLNKSplit LinkAscending
8CLNKComponent LinkAscending
9CCODComponent CodeAscending
25PCTN PCTT PCKO
ElementAliasDescriptionSequence
1PCTNParent Contract NumberAscending
2PCTTParent Contract TypeAscending
3PCKOParent Contract Document CompanyAscending
4DOCZDocument (Order # Invoice etc.)Ascending
5DCTIDocument Type - Invoice OnlyAscending
6KCOIDocument Company (Invoice)Ascending