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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

97 COLUMNS | 1 INDEXES | Print definition?920 | 07 | F0716709 TABLE

07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0716709EA971Employee Assignment T/E Template Info HistoryFiles07: PayrollBusiness 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 EATSKID, EAPDBA, EAANI, EAJBCD, EAJBST, EAACTB, EAABT1, EAABR1, EAABT2, EAABR2, EAABT3, EAABR3, EAABT4, EAABR4, EAUITM, EASBL, EASBLT, EAOPSQ, EAASII, EAUN, EAPOS, EAUAMT, EASHFT, EASHD, EALD, EAHMCO, EAHMCU, EAMCUO, EATARA, EAITM, EAWR01, EARCCD, EAANN8, EAWCMP, EAWET, EAMAIL, EAP001, EAP002, EAP003, EAP004, EAEAASNUMB, EAERC, EAQOBJ, EAEQRT, EADOCO, EADCTO, EATYR, EAUOM, EAOPST, EAREAC, EAKITL, EAKITA, EADTEREQF, EAEAPAYBS, EAEAINFLG, EAEACTCD01, EAEACTCD02, EAEACTCD03, EAEACTCD04, EAEACTCD05, EAEACTCD06, EAEACTCD07, EAEACTCD08, EAEACTCD09, EAEACTCD10, EAEAURCH1, EAEAURCH2, EAEAURST1, EAEAURST2, EAEAURST3, EAEAURST4, EAEAURST5, EAEAURST6, EAEAURST7, EAEAURMN1, EAEAURMN2, EAEAURCU1, EAEAURCU2, EAEAURDT1, EAEAURDT2, EAEXR1, EATXA1, EAVGCSF, EAVGCOA, EAVVTY, EAVVTC, EACRCD, EACRDC, EARCHGMODE, EARCHGCODE, EACUSTAN8, EAOTRULECD, EAPID, EAUSER, EAJOBN, EAUPMJ, EAUPMT FROM F0716709

TOP920 | 07 | F0716709 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1EATSKIDTask Unique Key IDNumericGeneric Edit150 Allow NULL? 
2EAPDBADBA CodeNumericGeneric Edit50 Allow NULL? 
3EAANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
4EAJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
5EAJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
6EAACTBActivity-Based Costing Activity CodeStringGeneric Edit100 Allow NULL? 
7EAABT1Managerial Analysis Type 1CharacterUDC10 Allow NULL? 
8EAABR1Managerial Analysis Code 1StringGeneric Edit120 Allow NULL? 
9EAABT2Managerial Analysis Type 2CharacterUDC10 Allow NULL? 
10EAABR2Managerial Analysis Code 2StringGeneric Edit120 Allow NULL? 
11EAABT3Managerial Analysis Type 3CharacterUDC10 Allow NULL? 
12EAABR3Managerial Analysis Code 3StringGeneric Edit120 Allow NULL? 
13EAABT4Managerial Analysis Type 4CharacterUDC10 Allow NULL? 
14EAABR4Managerial Analysis Code 4StringGeneric Edit120 Allow NULL? 
15EAUITMItem Number - Unknown Format EnteredStringGeneric Edit260 Allow NULL? 
16EASBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
17EASBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
18EAOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
19EAASIIAsset Number-InputStringGeneric Edit260 Allow NULL? 
20EAUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
21EAPOSPosition IDStringGeneric Edit80 Allow NULL? 
22EAUAMTAmount - UprateNumericGeneric Edit93 Allow NULL? 
23EASHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
24EASHDAmount - Shift DifferentialNumericGeneric Edit93 Allow NULL? 
25EALDPercent or AmountCharacterUDC (07 LD)10 Allow NULL? 
26EAHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
27EAHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
28EAMCUOBusiness Unit - ChargeoutStringGeneric Edit120 Allow NULL? 
29EATARATax Area (Work)StringGeneric Edit100 Allow NULL? 
30EAITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
31EAWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
32EARCCDRecord TypeCharacterUDC (07 RC)10 Allow NULL? 
33EAANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
34EAWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
35EAWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
36EAMAILRouting Code - CheckStringUDC (06 CR)100 Allow NULL? 
37EAP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
38EAP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
39EAP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
40EAP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
41EAEAASNUMBAsset Number Worked - BilledStringGeneric Edit260 Allow NULL? 
42EAERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
43EAQOBJEquipment Object AccountStringGeneric Edit60 Allow NULL? 
44EAEQRTBilling Rate - EquipmentNumericGeneric Edit92 Allow NULL? 
45EADOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
46EADCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
47EATYRType of HoursCharacterUDC (31 TY)10 Allow NULL? 
48EAUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
49EAOPSTOperation Status Code W.O.StringUDC (31 OS)20 Allow NULL? 
50EAREACReason CodeStringUDC (31 RC)20 Allow NULL? 
51EAKITLKit - 2nd Item NumberStringGeneric Edit250 Allow NULL? 
52EAKITA3rd Item Number - KitStringGeneric Edit250 Allow NULL? 
53EADTEREQFFlag-Daily Time Entry RequiredCharacterGeneric Edit10 Allow NULL? 
54EAEAPAYBSPay Basis - EE AssigmentStringUDC (07 AB)30 Allow NULL? 
55EAEAINFLGFlag - Inactive AssignmentCharacterGeneric Edit10 Allow NULL? 
56EAEACTCD01Category Code 01 - EE AssignmentStringUDC (07 A1)40 Allow NULL? 
57EAEACTCD02Category Code 02 - EE AssignmentStringUDC (07 A2)40 Allow NULL? 
58EAEACTCD03Category Code 03 - EE AssignmentStringUDC (07 A3)60 Allow NULL? 
59EAEACTCD04Category Code 04 - EE AssignmentStringUDC (07 A4)60 Allow NULL? 
60EAEACTCD05Category Code 05 - EE AssignmentStringUDC (07 A5)60 Allow NULL? 
61EAEACTCD06Category Code 06 - EE AssignmentStringUDC (07 A6)60 Allow NULL? 
62EAEACTCD07Category Code 07 - EE AssignmentStringUDC (07 A7)80 Allow NULL? 
63EAEACTCD08Category Code 08 - EE AssignmentStringUDC (07 A8)80 Allow NULL? 
64EAEACTCD09Category Code 09 - EE AssignmentStringUDC (07 A9)100 Allow NULL? 
65EAEACTCD10Category Code 10 - EE AssignmentStringUDC (07 A0)100 Allow NULL? 
66EAEAURCH1User Reserved Char 01CharacterGeneric Edit10 Allow NULL? 
67EAEAURCH2User Reserved Char 02CharacterGeneric Edit10 Allow NULL? 
68EAEAURST1User Reserved String 01StringGeneric Edit50 Allow NULL? 
69EAEAURST2User Reserved String 02StringGeneric Edit50 Allow NULL? 
70EAEAURST3User Reserved String 03StringGeneric Edit150 Allow NULL? 
71EAEAURST4User Reserved String 04StringGeneric Edit150 Allow NULL? 
72EAEAURST5User Reserved String 05StringGeneric Edit150 Allow NULL? 
73EAEAURST6User Reserved String 06StringGeneric Edit150 Allow NULL? 
74EAEAURST7User Reserved String 07StringGeneric Edit300 Allow NULL? 
75EAEAURMN1User Reserved Numeric 01NumericGeneric Edit154 Allow NULL? 
76EAEAURMN2User Reserved Numeric 02NumericGeneric Edit154 Allow NULL? 
77EAEAURCU1User Reserved Currency 01NumericGeneric Edit152 Allow NULL? 
78EAEAURCU2User Reserved Currency 02NumericGeneric Edit152 Allow NULL? 
79EAEAURDT1User Reserved Date 01DateGeneric Edit60
80EAEAURDT2User Reserved Date 02DateGeneric Edit60
81EAEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
82EATXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
83EAVGCSFGeoCode Ship FromStringGeneric Edit100 Allow NULL? 
84EAVGCOAGeoCode Order AcceptStringGeneric Edit100 Allow NULL? 
85EAVVTYVertex Transaction TypeStringUDC (73 TY)60 Allow NULL? 
86EAVVTCVertex Product CategoryStringUDC (73 PC)100 Allow NULL? 
87EACRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
88EACRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
89EARCHGMODERecharge ModeCharacterUDC (05 RM)10 Allow NULL? 
90EARCHGCODEAssignment Recharge CodeCharacterUDC (07 RC)10 Allow NULL? 
91EACUSTAN8Customer NumberNumericGeneric Edit80 Allow NULL? 
92EAOTRULECDCode - Overtime RuleStringUDC (07 OR)30 Allow NULL? 
93EAPIDProgram IDStringGeneric Edit100 Allow NULL? 
94EAUSERUser IDStringGeneric Edit100 Allow NULL? 
95EAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
96EAUPMJDate - UpdatedDateGeneric Edit60
97EAUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 07 | F0716709 INDEXES

NumberDescription
1Task ID (Primary/Unique)
ElementAliasDescriptionSequence
1TSKIDTask Unique Key IDAscending