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

106 COLUMNS | 13 INDEXES | Print definition?920 | 12 | F1201 TABLE

12: Fixed Assets
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F1201FA10613Asset Master FileMaster 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 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, FAUSER, FALCT, FALOC, FAADDS, FAPID, FAEFTB, FADER, FAMSGA, FAEX, FAEXR, FAAN8, FAACL6, FAACL7, FAACL8, FAACL9, FAACL0, FASFC, FADADC, FADADO, FADADS, FAUNIT, FAKIT, FAKITL, FAAFE, FAJBCD, FAJBST, FAUN, FASBLI, FAUPMJ, FAJOBN, FAUPMT, FAFA0, FAFA1, FAFA2, FAFA3, FAFA4, FAFA5, FAFA6, FAFA7, FAFA8, FAFA9, FAFA21, FAFA22, FAFA23, FAWOYN, FACRTL, FAWRFL, FAWARJ FROM F1201

TOP920 | 12 | F1201 COLUMNS

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

TOP920 | 12 | F1201 INDEXES

NumberDescription
1Item Number (Primary/Unique)
ElementAliasDescriptionSequence
1NUMBAsset Item NumberAscending
2Unit Number
ElementAliasDescriptionSequence
1APIDUnit or Tag NumberAscending
3Serial Number
ElementAliasDescriptionSequence
1ASIDSerial NumberAscending
4MajorClass Subclass +A
ElementAliasDescriptionSequence
1ACL1Major Accounting ClassAscending
2ACL2Major Equipment ClassAscending
3NUMBAsset Item NumberAscending
5Parent No Sequence No +A
ElementAliasDescriptionSequence
1AAIDParent NumberAscending
2SEQSequence NumberAscending
3NUMBAsset Item NumberAscending
6Parent Number
ElementAliasDescriptionSequence
1AAIDParent NumberAscending
7compresseddescription +a
ElementAliasDescriptionSequence
1DSCCDescription - CompressedAscending
2NUMBAsset Item NumberAscending
8business unit +a
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2NUMBAsset Item NumberAscending
9location asset item number
ElementAliasDescriptionSequence
1LOCBusiness Unit - LocationAscending
2NUMBAsset Item NumberAscending
11parent item number +a
ElementAliasDescriptionSequence
1KITParent (short) Item NumberAscending
2NUMBAsset Item NumberAscending
12Parent Number Serial Number
ElementAliasDescriptionSequence
1AAIDParent NumberAscending
2ASIDSerial NumberAscending
13Majorclass Subclass +B
ElementAliasDescriptionSequence
1ACL1Major Accounting ClassAscending
2ACL2Major Equipment ClassAscending
3ACL3ManufacturerAscending
4ACL4Model YearAscending
5ACL5Usage Miles or HoursAscending
6ACL6Category Code - F/A 6Ascending
7ACL7Category Code - F/A 7Ascending
8ACL8Category Code - F/A 8Ascending
9ACL9Category Code - F/A 9Ascending
10ACL0Category Code - F/A 10 (Rate Group)Ascending
14Description
ElementAliasDescriptionSequence
1DL01DescriptionAscending