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
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

126 COLUMNS | 1 INDEXES | Print definition?920 | 12 | F1201Z1 TABLE

12: Fixed Assets
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F1201Z1FA1261Unedited Asset Master TransactionsTransaction Files12: Fixed AssetsBusiness 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 FAEDUS, FAEDBT, FAEDTN, FAEDLN, FAEDCT, FATYTN, FAEDFT, FAEDDT, FADRIN, FAEDDL, FAEDSP, FAPNID, FATNAC, FACO, FANUMB, FAAPID, FAAAID, FAASID, FASEQ, FAACL1, FAACL2, FAACL3, FAACL4, FAACL5, FAMCU, FADL01, FADL02, FADL03, FADSCC, FADAJ, FADSP, FAEQST, FANORU, FAAESV, FAARPC, FAALRC, FAAMCU, FAAOBJ, FAASUB, FADMCU, FADOBJ, FADSUB, FAXMCU, FAXOBJ, FAXSUB, FARMCU, FAROBJ, FARSUB, FAARCQ, FAAROQ, FATXJS, FAAITY, FAAITP, FAFINC, FAITCO, FAPURO, FAAPUR, FAPURP, FAAPOM, FALANO, FAJCD, FADEXJ, FAAMF, FARMK, FARMK2, FAINSP, FAINSC, FAINSM, FAINSA, FAAIV, FAINSI, FALCT, FALOC, FAADDS, FAEFTB, FADER, FAMSGA, FAEX, FAEXR, FAAN8, FAACL6, FAACL7, FAACL8, FAACL9, FAACL0, FASFC, FADADC, FADADO, FADADS, FAUNIT, FAKIT, FAKITL, FAAFE, FAJBCD, FAJBST, FAUN, FASBLI, FAUPMT, FAFA0, FAFA1, FAFA2, FAFA3, FAFA4, FAFA5, FAFA6, FAFA7, FAFA8, FAFA9, FAFA21, FAFA22, FAFA23, FAWOYN, FACRTL, FAWRFL, FAWARJ, FAURCD, FAURDT, FAURAT, FAURAB, FAURRF, FATORG, FAUSER, FAPID, FAJOBN, FAUPMJ, FATDAY FROM F1201Z1

TOP920 | 12 | F1201Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1FAEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2FAEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3FAEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4FAEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5FAEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6FATYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7FAEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8FAEDDTEDI - Transmission DateDateGeneric Edit60
9FADRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10FAEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11FAEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12FAPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13FATNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14FACOCompanyStringGeneric Edit50 Allow NULL? 
15FANUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
16FAAPIDUnit or Tag NumberStringUDC120 Allow NULL? 
17FAAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
18FAASIDSerial NumberStringGeneric Edit250 Allow NULL? 
19FASEQSequence NumberNumericGeneric Edit60 Allow NULL? 
20FAACL1Major Accounting ClassStringUDC (12 C1)30 Allow NULL? 
21FAACL2Major Equipment ClassStringUDC (12 C2)30 Allow NULL? 
22FAACL3ManufacturerStringUDC (12 C3)30 Allow NULL? 
23FAACL4Model YearStringUDC (12 C4)30 Allow NULL? 
24FAACL5Usage Miles or HoursStringUDC (12 C5)30 Allow NULL? 
25FAMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
26FADL01DescriptionStringGeneric Edit300 Allow NULL? 
27FADL02Description 02StringGeneric Edit300 Allow NULL? 
28FADL03Description 03StringGeneric Edit300 Allow NULL? 
29FADSCCDescription - CompressedStringGeneric Edit400 Allow NULL? 
30FADAJDate - AcquiredDateGeneric Edit60
31FADSPDate - Disposed or RetiredDateGeneric Edit60
32FAEQSTEquipment StatusStringUDC (12 ES)20 Allow NULL? 
33FANORUNew or Used on AcquisitionCharacterUDC (H12 NO)10 Allow NULL? 
34FAAESVAmount - Estimated Salvage ValueNumericGeneric Edit152 Allow NULL? 
35FAARPCAmount - Replacement CostNumericGeneric Edit152 Allow NULL? 
36FAALRCAmount - Last Years Replacement CostNumericGeneric Edit152 Allow NULL? 
37FAAMCUAsset Cost Account - Business UnitStringGeneric Edit120 Allow NULL? 
38FAAOBJAsset Cost Account - ObjectStringGeneric Edit60 Allow NULL? 
39FAASUBAsset Cost Account - SubsidiaryStringGeneric Edit80 Allow NULL? 
40FADMCUAccumulated Depreciation Account - BUStringGeneric Edit120 Allow NULL? 
41FADOBJAccumulated Depreciation Account - ObjctStringGeneric Edit60 Allow NULL? 
42FADSUBAccumulated Depreciation Account - SubStringGeneric Edit80 Allow NULL? 
43FAXMCUDepreciation Expense - BUStringGeneric Edit120 Allow NULL? 
44FAXOBJDepreciation Expense - ObjectStringGeneric Edit60 Allow NULL? 
45FAXSUBDepreciation Expense - SubsidiaryStringGeneric Edit80 Allow NULL? 
46FARMCUAsset Revenue - Business UnitStringGeneric Edit120 Allow NULL? 
47FAROBJAsset Revenue - ObjectStringGeneric Edit60 Allow NULL? 
48FARSUBAsset Revenue - SubsidiaryStringGeneric Edit80 Allow NULL? 
49FAARCQAsset Item Current QuantityNumericGeneric Edit152 Allow NULL? 
50FAAROQAsset Item Original QuantityNumericGeneric Edit152 Allow NULL? 
51FATXJSTax EntityNumericGeneric Edit80 Allow NULL? 
52FAAITYAmount - Investment Tax CreditNumericGeneric Edit152 Allow NULL? 
53FAAITPAmount - Investment Tax Credit PYENumericGeneric Edit152 Allow NULL? 
54FAFINCFinancing MethodCharacterUDC (12 FM)10 Allow NULL? 
55FAITCOITC Owned - (Y/N)CharacterUDC (H12 IV)10 Allow NULL? 
56FAPUROPurchase OptionCharacterUDC (H12 PU)10 Allow NULL? 
57FAAPURAmount - Purchase Option PriceNumericGeneric Edit152 Allow NULL? 
58FAPURPPurchase Option Credit PercentageNumericGeneric Edit33 Allow NULL? 
59FAAPOMAmount - Purchase Option Maximum CreditNumericGeneric Edit152 Allow NULL? 
60FALANOAddress Number - Lessor/Rentor/MortgagorNumericGeneric Edit80 Allow NULL? 
61FAJCDDate - Contract DateDateGeneric Edit60
62FADEXJDate - Expired (Julian)DateGeneric Edit60
63FAAMFAmount - Monthly PaymentNumericGeneric Edit152 Allow NULL? 
64FARMKName - RemarkStringGeneric Edit300 Allow NULL? 
65FARMK2Name - RemarkStringGeneric Edit300 Allow NULL? 
66FAINSPInsurance Policy NumberStringGeneric Edit250 Allow NULL? 
67FAINSCInsurance CompanyStringGeneric Edit250 Allow NULL? 
68FAINSMPolicy Renewal MonthNumericGeneric Edit20 Allow NULL? 
69FAINSAAmount - Insurance PremiumNumericGeneric Edit152 Allow NULL? 
70FAAIVAmount - Insurance ValueNumericGeneric Edit152 Allow NULL? 
71FAINSIInsurance Value Index (future use)NumericGeneric Edit70 Allow NULL? 
72FALCTDate - Last ChangedDateGeneric Edit60
73FALOCBusiness Unit - LocationStringGeneric Edit120 Allow NULL? 
74FAADDSStateStringUDC (00 S)30 Allow NULL? 
75FAEFTBDate - Beginning EffectiveDateGeneric Edit60
76FADERDate - Expected ReturnDateGeneric Edit60
77FAMSGAAction - Message ControlCharacterUDC (H01 MR)10 Allow NULL? 
78FAEXName - ExplanationStringGeneric Edit300 Allow NULL? 
79FAEXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
80FAAN8Address NumberNumericGeneric Edit80 Allow NULL? 
81FAACL6Category Code - F/A 6StringUDC (12 C6)30 Allow NULL? 
82FAACL7Category Code - F/A 7StringUDC (12 C7)30 Allow NULL? 
83FAACL8Category Code - F/A 8StringUDC (12 C8)30 Allow NULL? 
84FAACL9Category Code - F/A 9StringUDC (12 C9)30 Allow NULL? 
85FAACL0Category Code - F/A 10 (Rate Group)StringUDC (12 C0)30 Allow NULL? 
86FASFCStandard Fuel ConsumptionNumericGeneric Edit152 Allow NULL? 
87FADADCDisposal Accumulated Depreciation - BUStringGeneric Edit120 Allow NULL? 
88FADADODisposal Accumulated Depreciation - ObjStringGeneric Edit60 Allow NULL? 
89FADADSDisposal Accumulated Depreciation - SubStringGeneric Edit80 Allow NULL? 
90FAUNITUnitStringGeneric Edit80 Allow NULL? 
91FAKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
92FAKITLKit - 2nd Item NumberStringGeneric Edit250 Allow NULL? 
93FAAFEAFE NumberStringGeneric Edit120 Allow NULL? 
94FAJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
95FAJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
96FAUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
97FASBLISubledger Inactive CodeCharacterUDC (00 SI)10 Allow NULL? 
98FAUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
99FAFA0Category Code - F/A 20StringUDC (12 F0)30 Allow NULL? 
100FAFA1Category Code - F/A 11StringUDC (12 F1)30 Allow NULL? 
101FAFA2Category Code - F/A 12StringUDC (12 F2)30 Allow NULL? 
102FAFA3Category Code - F/A 13StringUDC (12 F3)30 Allow NULL? 
103FAFA4Category Code - F/A 14StringUDC (12 F4)30 Allow NULL? 
104FAFA5Category Code - F/A 15StringUDC (12 F5)30 Allow NULL? 
105FAFA6Category Code - F/A 16StringUDC (12 F6)30 Allow NULL? 
106FAFA7Category Code - F/A 17StringUDC (12 F7)30 Allow NULL? 
107FAFA8Category Code - F/A 18StringUDC (12 F8)30 Allow NULL? 
108FAFA9Category Code - F/A 19StringUDC (12 F9)30 Allow NULL? 
109FAFA21Category Code - F/A 21StringUDC (12 21)100 Allow NULL? 
110FAFA22Category Code - F/A 22StringUDC (12 22)100 Allow NULL? 
111FAFA23Category Code - F/A 23StringUDC (12 23)100 Allow NULL? 
112FAWOYNAllow Work Order (Y/N)CharacterGeneric Edit10 Allow NULL? 
113FACRTLCriticalityNumericGeneric Edit20 Allow NULL? 
114FAWRFLWarranty FlagCharacterUDC (17 PF)10 Allow NULL? 
115FAWARJDate - Warranty Expiration(Julian)DateGeneric Edit60
116FAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
117FAURDTUser Reserved DateDateGeneric Edit60
118FAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
119FAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
120FAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
121FATORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
122FAUSERUser IDStringGeneric Edit100 Allow NULL? 
123FAPIDProgram IDStringGeneric Edit100 Allow NULL? 
124FAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
125FAUPMJDate - UpdatedDateGeneric Edit60
126FATDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP920 | 12 | F1201Z1 INDEXES

NumberDescription
1User ID Batch Transaction +A (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending