	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

74 COLUMNS | 7 INDEXES | 812 | 40 | F4215 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40: Inventory/OP Base
1	812	F4215	XH	74	7	Shipment Header	Transaction Files	49: Transportation Management	No

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 XHSHPN, XHSSTS, XHPNID, XHHLCF, XHPKCD, XHWGQ, XHWGTS, XHWGTU, XHIDQ1, XHID1, XHIDQ2, XHID2, XHMOT, XHROTE, XHEQCD, XHEQIN, XHEQNB, XHASNA, XHASND, XHASNT, XHMCU, XHNMCU, XHORGN, XHSRCO, XHBPFG, XHAEXP, XHECST, XHDRQJ, XHDRQT, XHRSDJ, XHRSDT, XHPDOV, XHAN8, XHSHAN, XHCTY1, XHADDS, XHADDZ, XHCTR, XHZON, XHSCT1, XHSCT2, XHSCT3, XHCAR1, XHCAR2, XHCAR3, XHILEL, XHFRTH, XHFRSC, XHDLLV, XHRSLT, XHBFSD, XHDSTN, XHUMD1, XHNRTS, XHUSER, XHPID, XHJOBN, XHUPMJ, XHTDAY, XHCTYO, XHADSO, XHADZO, XHCTRO, XHSC1O, XHSC2O, XHSC3O, XHAETC, XHETRSC, XHETRC, XHURCD, XHURDT, XHURAT, XHURAB, XHURRF FROM F4215

TOP 812 | 40 | F4215 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	XHSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
2	XHSSTS	Shipment Status	String	UDC (41 SS)	2	0	Allow NULL?
3	XHPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
4	XHHLCF	Hierarchical Configuration	String	Generic Edit	18	0	Allow NULL?
5	XHPKCD	Packaging Code	String	UDC (41 X1)	5	0	Allow NULL?
6	XHWGQ	Weight Qualifier	String	UDC (41 X2)	2	0	Allow NULL?
7	XHWGTS	Shipment Weight	Numeric	Generic Edit	15	4	Allow NULL?
8	XHWGTU	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
9	XHIDQ1	Identifier Code Qualifier 1	String	UDC (41 X3)	2	0	Allow NULL?
10	XHID1	Identifier Code 1	String	Generic Edit	17	0	Allow NULL?
11	XHIDQ2	Identifier Code Qualifier 2	String	UDC (41 X3)	2	0	Allow NULL?
12	XHID2	Identifier Code 2	String	Generic Edit	17	0	Allow NULL?
13	XHMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
14	XHROTE	Routing	String	Generic Edit	35	0	Allow NULL?
15	XHEQCD	Equipment Description Code	String	UDC (41 X5)	2	0	Allow NULL?
16	XHEQIN	Equipment Initial	String	Generic Edit	4	0	Allow NULL?
17	XHEQNB	Equipment Number	String	Generic Edit	10	0	Allow NULL?
18	XHASNA	ASN Acknowledgement Type	String	UDC (41 AS)	2	0	Allow NULL?
19	XHASND	Date ASN Receipt Acknowledged	Date	Generic Edit	6	0
20	XHASNT	Time ASN Receipt Acknowledged	Numeric	Generic Edit	7	0	Allow NULL?
21	XHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
22	XHNMCU	Shipment Depot	String	Generic Edit	12	0	Allow NULL?
23	XHORGN	Origin Address Number	Numeric	Generic Edit	8	0	Allow NULL?
24	XHSRCO	Source of Order	Character	UDC (49 BD)	1	0	Allow NULL?
25	XHBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
26	XHAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
27	XHECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
28	XHDRQJ	Date - Requested	Date	Generic Edit	6	0
29	XHDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
30	XHRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
31	XHRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
32	XHPDOV	Promised Delivery Override	Character	Generic Edit	1	0	Allow NULL?
33	XHAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
34	XHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
35	XHCTY1	City	String	Generic Edit	25	0	Allow NULL?
36	XHADDS	State	String	UDC (00 S)	3	0	Allow NULL?
37	XHADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
38	XHCTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
39	XHZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
40	XHSCT1	Shipment Category Code 1	String	Generic Edit	3	0	Allow NULL?
41	XHSCT2	Shipment Category Code 2	String	Generic Edit	3	0	Allow NULL?
42	XHSCT3	Shipment Category Code 3	String	Generic Edit	3	0	Allow NULL?
43	XHCAR1	Preferred Carrier 1	Numeric	Generic Edit	8	0	Allow NULL?
44	XHCAR2	Preferred Carrier 2	Numeric	Generic Edit	8	0	Allow NULL?
45	XHCAR3	Preferred Carrier 3	Numeric	Generic Edit	8	0	Allow NULL?
46	XHILEL	Include/Exclude	Character	Generic Edit	1	0	Allow NULL?
47	XHFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
48	XHFRSC	Freight Rate Schedule	String	UDC (49 BK)	8	0	Allow NULL?
49	XHDLLV	Delivery/Line/Load Level	Character	UDC (49 DL)	1	0	Allow NULL?
50	XHRSLT	Route Selection Type	Character	UDC (49 BB)	1	0	Allow NULL?
51	XHBFSD	Billable Freight Summary/Detail	String	Generic Edit	1	0	Allow NULL?
52	XHDSTN	Distance	Numeric	Generic Edit	5	0	Allow NULL?
53	XHUMD1	Unit of Measure - Distance	String	UDC (00 UM)	2	0	Allow NULL?
54	XHNRTS	Number of Routing Steps	Numeric	Generic Edit	3	0	Allow NULL?
55	XHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
56	XHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
57	XHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
58	XHUPMJ	Date - Updated	Date	Generic Edit	6	0
59	XHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
60	XHCTYO	Origin City	String	Generic Edit	25	0	Allow NULL?
61	XHADSO	Origin State	String	UDC (00 S)	3	0	Allow NULL?
62	XHADZO	OriginPostal Code	String	Generic Edit	12	0	Allow NULL?
63	XHCTRO	OriginCountry	String	UDC (00 CN)	3	0	Allow NULL?
64	XHSC1O	Origin Category Code 1	String	Generic Edit	3	0	Allow NULL?
65	XHSC2O	Origin Category Code 2	String	Generic Edit	3	0	Allow NULL?
66	XHSC3O	Origin Category Code 3	String	Generic Edit	3	0	Allow NULL?
67	XHAETC	Authorization Code	String	Generic Edit	10	0	Allow NULL?
68	XHETRSC	Excess Reason Code	String	UDC (49 ES)	3	0	Allow NULL?
69	XHETRC	Excess Responsibility	String	UDC (49 EC)	3	0	Allow NULL?
70	XHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
71	XHURDT	User Reserved Date	Date	Generic Edit	6	0
72	XHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
73	XHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
74	XHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?

TOP 812 | 40 | F4215 INDEXES

Number

Description

ShipmentNumber (Primary/Unique)

Element	Alias	Description	Sequence
1	SHPN	Shipment Number	Ascending

AddressShipTo

Element	Alias	Description	Sequence
1	SHAN	Address Number - Ship To	Ascending

AddressSoldTo

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

ShipmentStatus

Element	Alias	Description	Sequence
1	SSTS	Shipment Status	Ascending

PostalZipcode

Element	Alias	Description	Sequence
1	ADDZ	Postal Code	Ascending

ShipmentDepot

Element	Alias	Description	Sequence
1	NMCU	Shipment Depot	Ascending

OriginAddressNumber

Element	Alias	Description	Sequence
1	ORGN	Origin Address Number	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

74 COLUMNS | 7 INDEXES | 812 | 40 | F4215 TABLE

TOP 812 | 40 | F4215 COLUMNS

TOP 812 | 40 | F4215 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

74 COLUMNS | 7 INDEXES | 812 | 40 | F4215 TABLE

TOP812 | 40 | F4215 COLUMNS

TOP812 | 40 | F4215 INDEXES

TOP 812 | 40 | F4215 COLUMNS

TOP 812 | 40 | F4215 INDEXES