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

88 COLUMNS | 4 INDEXES | Print definition?910 | 48S | F48S910 TABLE

48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F48S910W2884Billing Detail Journal 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 W2ICU, W2ICUA, W2BCTY, W2GTYP, W2CRDB, W2KCO, W2CO, W2DGJ, W2PN, W2FY, W2CTRY, W2DCT, W2DOC, W2SFX, W2JELN, W2MCU, W2OBJ, W2SUB, W2SBL, W2SBLT, W2AID, W2AM, W2ANI, W2LT, W2EXA, W2EXR, W2GLC, W2AN8, W2ASID, W2AA, W2ACR, W2U, W2UM, W2JTAX, W2JTXF, W2AA1, W2AA2, W2CRCD, W2CRCE, W2CRCF, W2ERDB, W2CRRM, W2ERDT, W2CRR, W2CRRD, W2EXR1, W2WR01, W2JBCD, W2JBST, W2HMCU, W2JMCU, W2ANUM, W2TYKY, W2TKEY, W2TBDT, W2AN8O, W2DOCO, W2PCTN, W2COCH, W2LNID, W2MCUF, W2OBJF, W2SUBSID, W2SBLC, W2SBTC, W2WR07, W2RP11, W2BCI, W2DGL, W2PRSQ, W2SBSQ, W2SCSQ, W2SLNK, W2CLNK, W2CCOD, W2TCLS, W2ELGC, W2DSVJ, W2PRTR, W2PRTO, W2UKID, W2JOBN, W2PID, W2USER, W2UPMJ, W2UPMT, W2TXA1, W2TXITM FROM F48S910

TOP910 | 48S | F48S910 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1W2ICUBatch NumberNumericGeneric Edit80 Allow NULL? 
2W2ICUABatch Number - ActiveNumericGeneric Edit80 Allow NULL? 
3W2BCTYBatch TypeCharacterUDC (48 BT)10 Allow NULL? 
4W2GTYPGeneration TypeCharacterUDC (48 GT)10 Allow NULL? 
5W2CRDBCredit/DebitCharacterUDC (40 CG)10 Allow NULL? 
6W2KCODocument CompanyStringGeneric Edit50 Allow NULL? 
7W2COCompanyStringGeneric Edit50 Allow NULL? 
8W2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
9W2PNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
10W2FYFiscal YearNumericGeneric Edit20 Allow NULL? 
11W2CTRYCenturyNumericGeneric Edit20 Allow NULL? 
12W2DCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
13W2DOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
14W2SFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
15W2JELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
16W2MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
17W2OBJObject AccountStringGeneric Edit60 Allow NULL? 
18W2SUBSubsidiaryStringGeneric Edit80 Allow NULL? 
19W2SBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
20W2SBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
21W2AIDAccount IDStringGeneric Edit80 Allow NULL? 
22W2AMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
23W2ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
24W2LTLedger TypesStringUDC (09 LT)20 Allow NULL? 
25W2EXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
26W2EXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
27W2GLCG/L OffsetStringGeneric Edit40 Allow NULL? 
28W2AN8Address NumberNumericUDC80 Allow NULL? 
29W2ASIDSerial NumberStringGeneric Edit250 Allow NULL? 
30W2AAAmountNumericGeneric Edit152 Allow NULL? 
31W2ACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
32W2UUnitsNumericGeneric Edit152 Allow NULL? 
33W2UMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
34W2JTAXAmount - Journaled TaxNumericGeneric Edit152 Allow NULL? 
35W2JTXFAmount - Journaled Tax - ForeignNumericGeneric Edit152 Allow NULL? 
36W2AA1AmountNumericGeneric Edit152 Allow NULL? 
37W2AA2AmountNumericGeneric Edit152 Allow NULL? 
38W2CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
39W2CRCECurrency Code - SourceStringGeneric Edit30 Allow NULL? 
40W2CRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
41W2ERDBDate - Exchange Rate Date BasisCharacterGeneric Edit10 Allow NULL? 
42W2CRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
43W2ERDTDate - Exchange RateDateGeneric Edit60
44W2CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
45W2CRRDCurrency Conversion Rate - DivisorNumericGeneric Edit150 Allow NULL? 
46W2EXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
47W2WR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
48W2JBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
49W2JBSTJob StepStringUDC (06 GS)40 Allow NULL? 
50W2HMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
51W2JMCUBusiness Unit - HostStringGeneric Edit120 Allow NULL? 
52W2ANUMNumber - AAI Table NumberNumericGeneric Edit40 Allow NULL? 
53W2TYKYKey TypeCharacterUDC (48 TY)10 Allow NULL? 
54W2TKEYTable KeyStringGeneric Edit120 Allow NULL? 
55W2TBDTDate - Table Basis (Julian)DateGeneric Edit60
56W2AN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
57W2DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
58W2PCTNParent Contract NumberNumericGeneric Edit80 Allow NULL? 
59W2COCHContract Change NumberStringGeneric Edit30 Allow NULL? 
60W2LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
61W2MCUFBU - FromStringGeneric Edit120 Allow NULL? 
62W2OBJFObject Account FromStringGeneric Edit60 Allow NULL? 
63W2SUBSIDSubsidiary AccountStringGeneric Edit80 Allow NULL? 
64W2SBLCSubledger - G/L CostStringGeneric Edit80 Allow NULL? 
65W2SBTCSubledger Type - CostCharacterUDC (00 ST)10 Allow NULL? 
66W2WR07EnterpriseOne Consulting - Service TypeStringUDC (00 W7)30 Allow NULL? 
67W2RP11Category Code - Business Unit 11StringUDC (00 11)30 Allow NULL? 
68W2BCIBilling Control IDNumericGeneric Edit80 Allow NULL? 
69W2DGLDate - For G/L (and Voucher)DateGeneric Edit60
70W2PRSQParent Sequence NumberNumericGeneric Edit30 Allow NULL? 
71W2SBSQSequence NumberNumericGeneric Edit30 Allow NULL? 
72W2SCSQSecondary Sequence NumberNumericGeneric Edit30 Allow NULL? 
73W2SLNKSplit LinkNumericGeneric Edit110 Allow NULL? 
74W2CLNKComponent LinkNumericGeneric Edit110 Allow NULL? 
75W2CCODComponent CodeStringUDC (48 CM)50 Allow NULL? 
76W2TCLSTransaction ClassificationCharacterUDC (48 TC)10 Allow NULL? 
77W2ELGCEligibility CodeCharacterUDC (48 EL)10 Allow NULL? 
78W2DSVJDate - Service/TaxDateGeneric Edit60
79W2PRTRTransaction No. - PayrollNumericGeneric Edit90 Allow NULL? 
80W2PRTOOriginal Transaction Number - PayrollNumericGeneric Edit90 Allow NULL? 
81W2UKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
82W2JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
83W2PIDProgram IDStringGeneric Edit100 Allow NULL? 
84W2USERUser IDStringGeneric Edit100 Allow NULL? 
85W2UPMJDate - UpdatedDateGeneric Edit60
86W2UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
87W2TXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
88W2TXITMTax - Short Item NumberNumericGeneric Edit80 Allow NULL? 

TOP910 | 48S | F48S910 INDEXES

NumberDescription
1Unique Key Id (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2BatchNumberActive
ElementAliasDescriptionSequence
1ICUABatch Number - ActiveAscending
3Batch Number
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
4Batch Number Anum
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2ANUMNumber - AAI Table NumberAscending