	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

93 COLUMNS | 2 INDEXES | 812 | 16 | F1602Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
16: Profit Management (EPS)
1	812	F1602Z1	CZ	93	2	External Cost Analyzer Balances - Interoperability Table	Files	16: Profit Management (EPS)	Business 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 CZEDUS, CZEDBT, CZEDTN, CZEDLN, CZEDCT, CZTYTN, CZEDFT, CZEDDT, CZDRIN, CZEDDL, CZEDSP, CZPNID, CZTNAC, CZEDTY, CZEDSQ, CZEDTS, CZEDER, CZEDTC, CZEDTR, CZEDGL, CZEDDH, CZEDAN, CZVWNM, CZACTB, CZAID, CZCFY, CZLT, CZSBL, CZSBLT, CZABR1, CZABT1, CZABR2, CZABT2, CZABR3, CZABT3, CZABR4, CZABT4, CZITM, CZCO, CZAPYC, CZAN01, CZAN02, CZAN03, CZAN04, CZAN05, CZAN06, CZAN07, CZAN08, CZAN09, CZAN10, CZAN11, CZAN12, CZAN13, CZAN14, CZNB01, CZNB02, CZNB03, CZNB04, CZNB05, CZNB06, CZNB07, CZNB08, CZNB09, CZNB10, CZNB11, CZNB12, CZNB13, CZNB14, CZASMF, CZAWTD, CZBORG, CZBREQ, CZBAPR, CZMCU, CZOBJ, CZSUB, CZCRCD, CZCRCX, CZPM01, CZPM02, CZPM03, CZPM04, CZPM05, CZPM06, CZPM07, CZPM08, CZPM09, CZPM10, CZUSER, CZPID, CZUPMJ, CZUPMT, CZJOBN FROM F1602Z1

TOP 812 | 16 | F1602Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CZEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	CZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	CZEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	CZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	CZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	CZTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	CZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	CZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	CZDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	CZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	CZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	CZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	CZTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	CZEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
15	CZEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
16	CZEDTS	EDI - Transaction Set Number	String	Generic Edit	6	0	Allow NULL?
17	CZEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
18	CZEDTC	EDI - Transaction Action	Character	Generic Edit	1	0	Allow NULL?
19	CZEDTR	EDI - Transaction Type	Character	Generic Edit	1	0	Allow NULL?
20	CZEDGL	Batch File Create G/L Record	Character	Generic Edit	1	0	Allow NULL?
21	CZEDDH	Batch File Discount Handling Flag	Character	Generic Edit	1	0	Allow NULL?
22	CZEDAN	User Address Number	Numeric	Generic Edit	8	0	Allow NULL?
23	CZVWNM	View Number	Numeric	Generic Edit	2	0	Allow NULL?
24	CZACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
25	CZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
26	CZCFY	Century/Fiscal Year	Numeric	Generic Edit	4	0	Allow NULL?
27	CZLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
28	CZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
29	CZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
30	CZABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
31	CZABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
32	CZABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
33	CZABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
34	CZABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
35	CZABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
36	CZABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
37	CZABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
38	CZITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
39	CZCO	Company	String	Generic Edit	5	0	Allow NULL?
40	CZAPYC	Amount - Beginning Balance/PYE Forward	Numeric	Generic Edit	15	2	Allow NULL?
41	CZAN01	Amount - Net Posting 01	Numeric	Generic Edit	15	2	Allow NULL?
42	CZAN02	Amount - Net Posting 02	Numeric	Generic Edit	15	2	Allow NULL?
43	CZAN03	Amount - Net Posting 03	Numeric	Generic Edit	15	2	Allow NULL?
44	CZAN04	Amount - Net Posting 04	Numeric	Generic Edit	15	2	Allow NULL?
45	CZAN05	Amount - Net Posting 05	Numeric	Generic Edit	15	2	Allow NULL?
46	CZAN06	Amount - Net Posting 06	Numeric	Generic Edit	15	2	Allow NULL?
47	CZAN07	Amount - Net Posting 07	Numeric	Generic Edit	15	2	Allow NULL?
48	CZAN08	Amount - Net Posting 08	Numeric	Generic Edit	15	2	Allow NULL?
49	CZAN09	Amount - Net Posting 09	Numeric	Generic Edit	15	2	Allow NULL?
50	CZAN10	Amount - Net Posting 10	Numeric	Generic Edit	15	2	Allow NULL?
51	CZAN11	Amount - Net Posting 11	Numeric	Generic Edit	15	2	Allow NULL?
52	CZAN12	Amount - Net Posting 12	Numeric	Generic Edit	15	2	Allow NULL?
53	CZAN13	Amount - Net Posting 13	Numeric	Generic Edit	15	2	Allow NULL?
54	CZAN14	Amount - Net Posting 14	Numeric	Generic Edit	15	2	Allow NULL?
55	CZNB01	Amount - Net Balance 01	Numeric	Generic Edit	15	2	Allow NULL?
56	CZNB02	Amount - Net Balance 02	Numeric	Generic Edit	15	2	Allow NULL?
57	CZNB03	Amount - Net Balance 03	Numeric	Generic Edit	15	2	Allow NULL?
58	CZNB04	Amount - Net Balance 04	Numeric	Generic Edit	15	2	Allow NULL?
59	CZNB05	Amount - Net Balance 05	Numeric	Generic Edit	15	2	Allow NULL?
60	CZNB06	Amount - Net Balance 06	Numeric	Generic Edit	15	2	Allow NULL?
61	CZNB07	Amount - Net Balance 07	Numeric	Generic Edit	15	2	Allow NULL?
62	CZNB08	Amount - Net Balance 08	Numeric	Generic Edit	15	2	Allow NULL?
63	CZNB09	Amount - Net Balance 09	Numeric	Generic Edit	15	2	Allow NULL?
64	CZNB10	Amount - Net Balance 10	Numeric	Generic Edit	15	2	Allow NULL?
65	CZNB11	Amount - Net Balance 11	Numeric	Generic Edit	15	2	Allow NULL?
66	CZNB12	Amount - Net Balance 12	Numeric	Generic Edit	15	2	Allow NULL?
67	CZNB13	Amount - Net Balance 13	Numeric	Generic Edit	15	2	Allow NULL?
68	CZNB14	Amount - Net Balance 14	Numeric	Generic Edit	15	2	Allow NULL?
69	CZASMF	Assigment Flag	Character	Generic Edit	1	0	Allow NULL?
70	CZAWTD	Amount - Week-to-Date	Numeric	Generic Edit	15	2	Allow NULL?
71	CZBORG	Amount - Original/Beginning Budget	Numeric	Generic Edit	15	2	Allow NULL?
72	CZBREQ	Budget - Requested	Numeric	Generic Edit	15	2	Allow NULL?
73	CZBAPR	Budget - Approved	Numeric	Generic Edit	15	2	Allow NULL?
74	CZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
75	CZOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
76	CZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
77	CZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
78	CZCRCX	Currency Code - Denominated In	String	Generic Edit	3	0	Allow NULL?
79	CZPM01	Posting Code 1 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
80	CZPM02	Posting Code 2 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
81	CZPM03	Posting Code 3 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
82	CZPM04	Posting Code 4 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
83	CZPM05	Posting Code 5 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
84	CZPM06	Posting Code 6 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
85	CZPM07	Posting Code 7 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
86	CZPM08	Posting Code 8 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
87	CZPM09	Posting Code 9 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
88	CZPM10	Posting Code 10- Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
89	CZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
90	CZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
91	CZUPMJ	Date - Updated	Date	Generic Edit	6	0
92	CZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
93	CZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?

TOP 812 | 16 | F1602Z1 INDEXES

Number

Description

EdiUserid EDIBatchNumber + (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

EdiUserid EDIBatchNumber + Des

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Descending

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

93 COLUMNS | 2 INDEXES | 812 | 16 | F1602Z1 TABLE

TOP 812 | 16 | F1602Z1 COLUMNS

TOP 812 | 16 | F1602Z1 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

93 COLUMNS | 2 INDEXES | 812 | 16 | F1602Z1 TABLE

TOP812 | 16 | F1602Z1 COLUMNS

TOP812 | 16 | F1602Z1 INDEXES

TOP 812 | 16 | F1602Z1 COLUMNS

TOP 812 | 16 | F1602Z1 INDEXES