	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

106 COLUMNS | 12 INDEXES | 812 | 12 | F1201 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
12: Fixed Assets
1	812	F1201	FA	106	12	Asset Master File	Master Files	12: Fixed Assets	AS400 Coexistence Tables

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

TOP 812 | 12 | F1201 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	FACO	Company	String	Generic Edit	5	0	Allow NULL?
2	FANUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
3	FAAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
4	FAAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
5	FAASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
6	FASEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
7	FAACL1	Major Accounting Class	String	UDC (12 C1)	3	0	Allow NULL?
8	FAACL2	Major Equipment Class	String	UDC (12 C2)	3	0	Allow NULL?
9	FAACL3	Manufacturer	String	UDC (12 C3)	3	0	Allow NULL?
10	FAACL4	Model Year	String	UDC (12 C4)	3	0	Allow NULL?
11	FAACL5	Usage Miles or Hours	String	UDC (12 C5)	3	0	Allow NULL?
12	FAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
13	FADL01	Description	String	Generic Edit	30	0	Allow NULL?
14	FADL02	Description 02	String	Generic Edit	30	0	Allow NULL?
15	FADL03	Description 03	String	Generic Edit	30	0	Allow NULL?
16	FADSCC	Description - Compressed	String	Generic Edit	40	0	Allow NULL?
17	FADAJ	Date - Acquired	Date	Generic Edit	6	0
18	FADSP	Date - Disposed or Retired	Date	Generic Edit	6	0
19	FAEQST	Equipment Status	String	UDC (12 ES)	2	0	Allow NULL?
20	FANORU	New or Used on Acquisition	Character	UDC (H12 NO)	1	0	Allow NULL?
21	FAAESV	Amount - Estimated Salvage Value	Numeric	Generic Edit	15	2	Allow NULL?
22	FAARPC	Amount - Replacement Cost	Numeric	Generic Edit	15	2	Allow NULL?
23	FAALRC	Amount - Last Years Replacement Cost	Numeric	Generic Edit	15	2	Allow NULL?
24	FAAMCU	Asset Cost Account - Business Unit	String	Generic Edit	12	0	Allow NULL?
25	FAAOBJ	Asset Cost Account - Object	String	Generic Edit	6	0	Allow NULL?
26	FAASUB	Asset Cost Account - Subsidiary	String	Generic Edit	8	0	Allow NULL?
27	FADMCU	Accumulated Depreciation Account - BU	String	Generic Edit	12	0	Allow NULL?
28	FADOBJ	Accumulated Depreciation Account - Objct	String	Generic Edit	6	0	Allow NULL?
29	FADSUB	Accumulated Depreciation Account - Sub	String	Generic Edit	8	0	Allow NULL?
30	FAXMCU	Depreciation Expense - BU	String	Generic Edit	12	0	Allow NULL?
31	FAXOBJ	Depreciation Expense - Object	String	Generic Edit	6	0	Allow NULL?
32	FAXSUB	Depreciation Expense - Subsidiary	String	Generic Edit	8	0	Allow NULL?
33	FARMCU	Asset Revenue - Business Unit	String	Generic Edit	12	0	Allow NULL?
34	FAROBJ	Asset Revenue - Object	String	Generic Edit	6	0	Allow NULL?
35	FARSUB	Asset Revenue - Subsidiary	String	Generic Edit	8	0	Allow NULL?
36	FAARCQ	Asset Item Current Quantity	Numeric	Generic Edit	15	2	Allow NULL?
37	FAAROQ	Asset Item Original Quantity	Numeric	Generic Edit	15	2	Allow NULL?
38	FATXJS	Tax Entity	Numeric	Generic Edit	8	0	Allow NULL?
39	FAAITY	Amount - Investment Tax Credit	Numeric	Generic Edit	15	2	Allow NULL?
40	FAAITP	Amount - Investment Tax Credit PYE	Numeric	Generic Edit	15	2	Allow NULL?
41	FAFINC	Financing Method	Character	UDC (12 FM)	1	0	Allow NULL?
42	FAITCO	ITC Owned - (Y/N)	Character	UDC (H12 IV)	1	0	Allow NULL?
43	FAPURO	Purchase Option	Character	UDC (H12 PU)	1	0	Allow NULL?
44	FAAPUR	Amount - Purchase Option Price	Numeric	Generic Edit	15	2	Allow NULL?
45	FAPURP	Purchase Option Credit Percentage	Numeric	Generic Edit	3	3	Allow NULL?
46	FAAPOM	Amount - Purchase Option Maximum Credit	Numeric	Generic Edit	15	2	Allow NULL?
47	FALANO	Address Number - Lessor/Rentor/Mortgagor	Numeric	Generic Edit	8	0	Allow NULL?
48	FAJCD	Date - Contract Date	Date	Generic Edit	6	0
49	FADEXJ	Date - Expired (Julian)	Date	Generic Edit	6	0
50	FAAMF	Amount - Monthly Payment	Numeric	Generic Edit	15	2	Allow NULL?
51	FARMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
52	FARMK2	Name - Remark	String	Generic Edit	30	0	Allow NULL?
53	FAINSP	Insurance Policy Number	String	Generic Edit	25	0	Allow NULL?
54	FAINSC	Insurance Company	String	Generic Edit	25	0	Allow NULL?
55	FAINSM	Policy Renewal Month	Numeric	Generic Edit	2	0	Allow NULL?
56	FAINSA	Amount - Insurance Premium	Numeric	Generic Edit	15	2	Allow NULL?
57	FAAIV	Amount - Insurance Value	Numeric	Generic Edit	15	2	Allow NULL?
58	FAINSI	Insurance Value Index (future use)	Numeric	Generic Edit	7	0	Allow NULL?
59	FAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
60	FALCT	Date - Last Changed	Date	Generic Edit	6	0
61	FALOC	Business Unit - Location	String	Generic Edit	12	0	Allow NULL?
62	FAADDS	State	String	UDC (00 S)	3	0	Allow NULL?
63	FAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
64	FAEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
65	FADER	Date - Expected Return	Date	Generic Edit	6	0
66	FAMSGA	Action - Message Control	Character	UDC (H01 MR)	1	0	Allow NULL?
67	FAEX	Name - Explanation	String	Generic Edit	30	0	Allow NULL?
68	FAEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
69	FAAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
70	FAACL6	Category Code - F/A 6	String	UDC (12 C6)	3	0	Allow NULL?
71	FAACL7	Category Code - F/A 7	String	UDC (12 C7)	3	0	Allow NULL?
72	FAACL8	Category Code - F/A 8	String	UDC (12 C8)	3	0	Allow NULL?
73	FAACL9	Category Code - F/A 9	String	UDC (12 C9)	3	0	Allow NULL?
74	FAACL0	Category Code - F/A 10 (Rate Group)	String	UDC (12 C0)	3	0	Allow NULL?
75	FASFC	Standard Fuel Consumption	Numeric	Generic Edit	15	2	Allow NULL?
76	FADADC	Disposal Accumulated Depreciation - BU	String	Generic Edit	12	0	Allow NULL?
77	FADADO	Disposal Accumulated Depreciation - Obj	String	Generic Edit	6	0	Allow NULL?
78	FADADS	Disposal Accumulated Depreciation - Sub	String	Generic Edit	8	0	Allow NULL?
79	FAUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
80	FAKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
81	FAKITL	Kit - 2nd Item Number	String	Generic Edit	25	0	Allow NULL?
82	FAAFE	AFE Number	String	Generic Edit	12	0	Allow NULL?
83	FAJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
84	FAJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
85	FAUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
86	FASBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
87	FAUPMJ	Date - Updated	Date	Generic Edit	6	0
88	FAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
89	FAUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
90	FAFA0	Category Code - F/A 20	String	UDC (12 F0)	3	0	Allow NULL?
91	FAFA1	Category Code - F/A 11	String	UDC (12 F1)	3	0	Allow NULL?
92	FAFA2	Category Code - F/A 12	String	UDC (12 F2)	3	0	Allow NULL?
93	FAFA3	Category Code - F/A 13	String	UDC (12 F3)	3	0	Allow NULL?
94	FAFA4	Category Code - F/A 14	String	UDC (12 F4)	3	0	Allow NULL?
95	FAFA5	Category Code - F/A 15	String	UDC (12 F5)	3	0	Allow NULL?
96	FAFA6	Category Code - F/A 16	String	UDC (12 F6)	3	0	Allow NULL?
97	FAFA7	Category Code - F/A 17	String	UDC (12 F7)	3	0	Allow NULL?
98	FAFA8	Category Code - F/A 18	String	UDC (12 F8)	3	0	Allow NULL?
99	FAFA9	Category Code - F/A 19	String	UDC (12 F9)	3	0	Allow NULL?
100	FAFA21	Category Code - F/A 21	String	UDC (12 21)	10	0	Allow NULL?
101	FAFA22	Category Code - F/A 22	String	UDC (12 22)	10	0	Allow NULL?
102	FAFA23	Category Code - F/A 23	String	UDC (12 23)	10	0	Allow NULL?
103	FAWOYN	Allow Work Order (Y/N)	Character	Generic Edit	1	0	Allow NULL?
104	FACRTL	Criticality	Numeric	Generic Edit	2	0	Allow NULL?
105	FAWRFL	Warranty Flag	Character	UDC (17 PF)	1	0	Allow NULL?
106	FAWARJ	Date - Warranty Expiration(Julian)	Date	Generic Edit	6	0

TOP 812 | 12 | F1201 INDEXES

Number

Description

Item Number (Primary/Unique)

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending

Unit Number

Element	Alias	Description	Sequence
1	APID	Unit or Tag Number	Ascending

Serial Number

Element	Alias	Description	Sequence
1	ASID	Serial Number	Ascending

MajorClass Subclass +A

Element	Alias	Description	Sequence
1	ACL1	Major Accounting Class	Ascending
2	ACL2	Major Equipment Class	Ascending
3	NUMB	Asset Item Number	Ascending

Parent No Sequence No +A

Element	Alias	Description	Sequence
1	AAID	Parent Number	Ascending
2	SEQ	Sequence Number	Ascending
3	NUMB	Asset Item Number	Ascending

Parent Number

Element	Alias	Description	Sequence
1	AAID	Parent Number	Ascending

compresseddescription +a

Element	Alias	Description	Sequence
1	DSCC	Description - Compressed	Ascending
2	NUMB	Asset Item Number	Ascending

business unit +a

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	NUMB	Asset Item Number	Ascending

location asset item number

Element	Alias	Description	Sequence
1	LOC	Business Unit - Location	Ascending
2	NUMB	Asset Item Number	Ascending

parent item number +a

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	NUMB	Asset Item Number	Ascending

Parent Number Serial Number

Element	Alias	Description	Sequence
1	AAID	Parent Number	Ascending
2	ASID	Serial Number	Ascending

Majorclass Subclass +B

Element	Alias	Description	Sequence
1	ACL1	Major Accounting Class	Ascending
2	ACL2	Major Equipment Class	Ascending
3	ACL3	Manufacturer	Ascending
4	ACL4	Model Year	Ascending
5	ACL5	Usage Miles or Hours	Ascending
6	ACL6	Category Code - F/A 6	Ascending
7	ACL7	Category Code - F/A 7	Ascending
8	ACL8	Category Code - F/A 8	Ascending
9	ACL9	Category Code - F/A 9	Ascending
10	ACL0	Category Code - F/A 10 (Rate Group)	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

106 COLUMNS | 12 INDEXES | 812 | 12 | F1201 TABLE

TOP 812 | 12 | F1201 COLUMNS

TOP 812 | 12 | F1201 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

106 COLUMNS | 12 INDEXES | 812 | 12 | F1201 TABLE

TOP812 | 12 | F1201 COLUMNS

TOP812 | 12 | F1201 INDEXES

TOP 812 | 12 | F1201 COLUMNS

TOP 812 | 12 | F1201 INDEXES