	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

105 COLUMNS | 2 INDEXES | 920 | 42 | F470371T TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F470371T	UZ	105	2	Tag for F470371- EDI shipping Notice Detail - Outbound	Files	42: Sales Management	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 UZAAID, UZACOM, UZAID, UZANBY, UZANI, UZANTY, UZASN, UZBACK, UZCLVL, UZCMCG, UZCMGL, UZCMGP, UZCORD, UZDCTO, UZDMCS, UZDMCT, UZDOCO, UZEDBT, UZEDCT, UZEDDL, UZEDDT, UZEDER, UZEDFT, UZEDLN, UZEDOC, UZEDSP, UZEDSQ, UZEDST, UZEDTY, UZEKCO, UZEXR1, UZFAPP, UZFUN2, UZKCOO, UZLNID, UZLT, UZMCLN, UZMERL, UZNUMB, UZOBJ, UZODLN, UZOMCU, UZORP, UZORPR, UZOSEQ, UZPEND, UZPOE, UZPRGR, UZPROV, UZPRP3, UZPRP4, UZPRP5, UZPSDJ, UZRESL, UZRPRC, UZSBL, UZSBLT, UZSO02, UZSO03, UZSO04, UZSO05, UZSO06, UZSO07, UZSO08, UZSO09, UZSO10, UZSO11, UZSO12, UZSO13, UZSO14, UZSO15, UZSO16, UZSO17, UZSO18, UZSO19, UZSO20, UZSUB, UZSWMS, UZTAX1, UZTPC, UZTXA1, UZUNCD, UZUPC1, UZUPC2, UZUPC3, UZVEND, UZXCTO, UZXDCK, UZXKCO, UZXLLN, UZXORN, UZXPTY, UZXSFX, UZEMCU, UZIR01, UZIR02, UZIR03, UZIR04, UZIR05, UZSBAL, UZUSER, UZPID, UZJOBN, UZUPMJ, UZTDAY FROM F470371T

TOP 920 | 42 | F470371T COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	UZAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
2	UZACOM	Apply Commission (Y/N)	Character	Generic Edit	1	0	Allow NULL?
3	UZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
4	UZANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
5	UZANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
6	UZANTY	Type - Address Number	Character	UDC (40 AN)	1	0	Allow NULL?
7	UZASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
8	UZBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
9	UZCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
10	UZCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
11	UZCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
12	UZCMGP	Costing Method - Inventory	String	Generic Edit	2	0	Allow NULL?
13	UZCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
14	UZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	UZDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
16	UZDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
17	UZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
18	UZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
19	UZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
20	UZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
21	UZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
22	UZEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
23	UZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
24	UZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
25	UZEDOC	EDI - Document Number	Numeric	Generic Edit	9	0	Allow NULL?
26	UZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
27	UZEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
28	UZEDST	EDI - Transaction Set Number	String	UDC (40 ST)	6	0	Allow NULL?
29	UZEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
30	UZEKCO	Company - Key (EDI - Document Key Co)	String	Generic Edit	5	0	Allow NULL?
31	UZEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
32	UZFAPP	Discount Application Type	Character	Generic Edit	1	0	Allow NULL?
33	UZFUN2	Trade Discount (Old)	Numeric	Generic Edit	15	4	Allow NULL?
34	UZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
35	UZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
36	UZLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
37	UZMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
38	UZMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
39	UZNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
40	UZOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
41	UZODLN	Document Line Number - Original	Numeric	Generic Edit	7	3	Allow NULL?
42	UZOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
43	UZORP	Order Repriced Indicator	Character	Generic Edit	1	0	Allow NULL?
44	UZORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
45	UZOSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
46	UZPEND	Pending Approval Flag	Character	Generic Edit	1	0	Allow NULL?
47	UZPOE	Port of Entry or Exit	String	UDC (40 PE)	6	0	Allow NULL?
48	UZPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
49	UZPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
50	UZPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
51	UZPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
52	UZPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
53	UZPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
54	UZRESL	Printed Code	Character	Generic Edit	1	0	Allow NULL?
55	UZRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
56	UZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
57	UZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
58	UZSO02	On Hand Updated	Character	Generic Edit	1	0	Allow NULL?
59	UZSO03	Configurator Print Flag	Character	Generic Edit	1	0	Allow NULL?
60	UZSO04	Sales Order Status 04	Character	Generic Edit	1	0	Allow NULL?
61	UZSO05	Substitute Item Indicator	Character	Generic Edit	1	0	Allow NULL?
62	UZSO06	Preference Commitment Indicator	Character	Generic Edit	1	0	Allow NULL?
63	UZSO07	Ship date (PDDJ) overridden	Character	Generic Edit	1	0	Allow NULL?
64	UZSO08	Price Adjustment Line Indicator	Character	Generic Edit	1	0	Allow NULL?
65	UZSO09	Price Adj. History Indicator	Character	Generic Edit	1	0	Allow NULL?
66	UZSO10	Preference Production Allocation	Character	Generic Edit	1	0	Allow NULL?
67	UZSO11	Transfer/Direct Ship/Intercompany Flag	Character	Generic Edit	1	0	Allow NULL?
68	UZSO12	Deferred entries flag	Character	Generic Edit	1	0	Allow NULL?
69	UZSO13	Euro Conversion Status Flag	Character	Generic Edit	1	0	Allow NULL?
70	UZSO14	Sales Order Status 14	Character	Generic Edit	1	0	Allow NULL?
71	UZSO15	Sales Order Status 15	Character	Generic Edit	1	0	Allow NULL?
72	UZSO16	Manufacturing Variance Accounting Flag	Character	Generic Edit	1	0	Allow NULL?
73	UZSO17	Sales Order Status 17	Character	Generic Edit	1	0	Allow NULL?
74	UZSO18	Sales Order Status 18	Character	Generic Edit	1	0	Allow NULL?
75	UZSO19	Sales Order Status 19	Character	Generic Edit	1	0	Allow NULL?
76	UZSO20	Sales Order Status 20	Character	Generic Edit	1	0	Allow NULL?
77	UZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
78	UZSWMS	Status - In Warehouse	Character	Generic Edit	1	0	Allow NULL?
79	UZTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
80	UZTPC	Temporary Price (Y/N)	Character	Generic Edit	1	0	Allow NULL?
81	UZTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
82	UZUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
83	UZUPC1	Price Code 1	String	UDC (40 P1)	2	0	Allow NULL?
84	UZUPC2	Price Code 2	String	UDC (40 P2)	2	0	Allow NULL?
85	UZUPC3	Price Code 3	String	UDC (40 P3)	2	0	Allow NULL?
86	UZVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
87	UZXCTO	Cross Dock Order Type	String	UDC (00 DT)	2	0	Allow NULL?
88	UZXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
89	UZXKCO	Cross Dock Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
90	UZXLLN	Cross Dock Line Number	Numeric	Generic Edit	6	3	Allow NULL?
91	UZXORN	Cross Dock Order No	Numeric	Generic Edit	8	0	Allow NULL?
92	UZXPTY	Cross Docking Priority for Sales Orders	Numeric	Generic Edit	15	0	Allow NULL?
93	UZXSFX	Cross Dock Order Suffix	String	Generic Edit	3	0	Allow NULL?
94	UZEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
95	UZIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
96	UZIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
97	UZIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
98	UZIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
99	UZIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
100	UZSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
101	UZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
102	UZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
103	UZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
104	UZUPMJ	Date - Updated	Date	Generic Edit	6	0
105	UZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 42 | F470371T INDEXES

Number

Description

Primary EDOC EDCT EKCO EDLN (Primary/Unique)

Element	Alias	Description	Sequence
1	EDOC	EDI - Document Number	Ascending
2	EKCO	Company - Key (EDI - Document Key Co)	Ascending
3	EDLN	EDI - Line Number	Ascending
4	EDCT	EDI - Document Type	Ascending

Document Number Doc Type +

Element	Alias	Description	Sequence
1	EDOC	EDI - Document Number	Ascending
2	EDCT	EDI - Document Type	Ascending
3	EKCO	Company - Key (EDI - Document Key Co)	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

105 COLUMNS | 2 INDEXES | 920 | 42 | F470371T TABLE

TOP 920 | 42 | F470371T COLUMNS

TOP 920 | 42 | F470371T 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

105 COLUMNS | 2 INDEXES | 920 | 42 | F470371T TABLE

TOP920 | 42 | F470371T COLUMNS

TOP920 | 42 | F470371T INDEXES

TOP 920 | 42 | F470371T COLUMNS

TOP 920 | 42 | F470371T INDEXES