JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F48SUI01WD1992Billing Detail Print WorkfileWork 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, WDRAS, WDRAG, WDJPGC, WDBUF, WDAA3, WDACR, WDPRTP, WDHBIN, WDHBRV, WDBPTX FROM F48SUI01

TOP910 | 48S | F48SUI01 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? 
190WDRASRe-burdening Adjustment StatusCharacterUDC (48S RS)10 Allow NULL? 
191WDRAGRe-burdening Adjustment GroupNumericGeneric Edit80 Allow NULL? 
192WDJPGCJob Pool Grouping CodeStringUDC (00 12)30 Allow NULL? 
193WDBUFBurdening Used FlagCharacterGeneric Edit10 Allow NULL? 
194WDAA3AmountNumericGeneric Edit152 Allow NULL? 
195WDACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
196WDPRTPPricing Type - ContractsCharacterUDC (52 PT)10 Allow NULL? 
197WDHBINAmount - Historical Burdened InvoiceNumericGeneric Edit152 Allow NULL? 
198WDHBRVAmount - Historical Burdened RevenueNumericGeneric Edit152 Allow NULL? 
199WDBPTXBase Pay Transaction NumberNumericGeneric Edit90 Allow NULL? 

TOP910 | 48S | F48SUI01 INDEXES

NumberDescription
1Billing Cntl ID G/L Date + (Primary/Unique)
ElementAliasDescriptionSequence
1BCIBilling Control IDAscending
2DGLDate - For G/L (and Voucher)Ascending
3SBSQSequence NumberAscending
4PRSQParent Sequence NumberAscending
5SCSQSecondary Sequence NumberAscending
6SLNKSplit LinkAscending
7CLNKComponent LinkAscending
8CCODComponent CodeAscending
2Invoice Number Inv. Type +
ElementAliasDescriptionSequence
1DOCZDocument (Order # Invoice etc.)Ascending
2DCTIDocument Type - Invoice OnlyAscending
3KCOIDocument Company (Invoice)Ascending
4SFXDocument Pay ItemAscending
5MCUBusiness UnitAscending
6OBJObject AccountAscending
7SUBSubsidiaryAscending
8JBCDJob Type (Craft) CodeAscending