	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

94 COLUMNS | 11 INDEXES | 812 | 49 | F4981 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
49: Transportation Management
1	812	F4981	FH	94	11	Freight Audit History	History Files	49: Transportation 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 FHUK01, FHSHPN, FHRSSN, FHVMCU, FHLDNM, FHDLNO, FHOSEQ, FHNMFC, FHDSGP, FHFRT1, FHFRT2, FHORGN, FHNMCU, FHBLPB, FHOVFG, FHOVFH, FHMOT, FHCARS, FHCAMD, FHWGTS, FHWTUM, FHSCVL, FHVLUM, FHFRSC, FHRTNM, FHSDSQ, FHSCSN, FHRTGB, FHRTDQ, FHUOM, FHCGC1, FHAG, FHFAA, FHNAMT, FHCRDC, FHNAMF, FHCRCD, FHDOCO, FHDCTO, FHKCOO, FHLNID, FHODOC, FHODCT, FHOKCO, FHJELN, FHDOC, FHDCT, FHKCO, FHDGJ, FHVINV, FHREFQ, FHREFN, FHSHAN, FHCTY1, FHADDS, FHADDZ, FHZON, FHCZON, FHFRTH, FHRTN, FHADDJ, FHUKID, FHURCD, FHURDT, FHURAT, FHURAB, FHURRF, FHUSER, FHPID, FHJOBN, FHUPMJ, FHTDAY, FHFRSN, FHANI, FHTXA1, FHEXR1, FHCTYO, FHADSO, FHADZO, FHCTRO, FHSCT1, FHSCT2, FHSCT3, FHSC1O, FHSC2O, FHSC3O, FHLNMB, FHCNMR, FHSTAM, FHCTAM, FHTX, FHOVRTAX, FHATXA, FHCTXA FROM F4981

TOP 812 | 49 | F4981 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	FHUK01	Unique Key ID 01 (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	FHSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
3	FHRSSN	Routing Step Number	Numeric	Generic Edit	3	1	Allow NULL?
4	FHVMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
5	FHLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
6	FHDLNO	Delivery Number	Numeric	Generic Edit	8	0	Allow NULL?
7	FHOSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
8	FHNMFC	Freight Classification (NMFC)	String	UDC (49 BE)	4	0	Allow NULL?
9	FHDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
10	FHFRT1	Freight Category Code 1	String	UDC (49 CJ)	6	0	Allow NULL?
11	FHFRT2	Freight Category Code 2	String	UDC (49 CK)	6	0	Allow NULL?
12	FHORGN	Origin Address Number	Numeric	Generic Edit	8	0	Allow NULL?
13	FHNMCU	Shipment Depot	String	Generic Edit	12	0	Allow NULL?
14	FHBLPB	Billable/Payable	Character	Generic Edit	1	0	Allow NULL?
15	FHOVFG	Override Flag	Character	UDC (49 BT)	1	0	Allow NULL?
16	FHOVFH	Freight Audit History Override Flag	Character	Generic Edit	1	0	Allow NULL?
17	FHMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
18	FHCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
19	FHCAMD	Auto Pay	Character	Generic Edit	1	0	Allow NULL?
20	FHWGTS	Shipment Weight	Numeric	Generic Edit	15	4	Allow NULL?
21	FHWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
22	FHSCVL	Volume - Scheduled Load	Numeric	Generic Edit	15	2	Allow NULL?
23	FHVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
24	FHFRSC	Freight Rate Schedule	String	UDC (49 BK)	8	0	Allow NULL?
25	FHRTNM	Rate Name	String	UDC (49 CN)	10	0	Allow NULL?
26	FHSDSQ	Schedule Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
27	FHSCSN	Secondary Schedule Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
28	FHRTGB	Rate Basis	Character	UDC (49 CD)	1	0	Allow NULL?
29	FHRTDQ	Rated Quantity	Numeric	Generic Edit	15	4	Allow NULL?
30	FHUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
31	FHCGC1	Charge Code 1	String	UDC (49 BL)	3	0	Allow NULL?
32	FHAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
33	FHFAA	Foreign Amount	Numeric	Generic Edit	15	2	Allow NULL?
34	FHNAMT	Amount - Net	Numeric	Generic Edit	15	2	Allow NULL?
35	FHCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
36	FHNAMF	Amount - Foreign Net	Numeric	Generic Edit	15	2	Allow NULL?
37	FHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
38	FHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
39	FHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
40	FHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
41	FHLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
42	FHODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
43	FHODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
44	FHOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
45	FHJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
46	FHDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
47	FHDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
48	FHKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
49	FHDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
50	FHVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
51	FHREFQ	Reference Number Qualifier	String	UDC (41 X6)	2	0	Allow NULL?
52	FHREFN	Reference Number	String	Generic Edit	30	0	Allow NULL?
53	FHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
54	FHCTY1	City	String	Generic Edit	25	0	Allow NULL?
55	FHADDS	State	String	UDC (00 S)	3	0	Allow NULL?
56	FHADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
57	FHZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
58	FHCZON	Carrier Zone	String	UDC (49 CF)	10	0	Allow NULL?
59	FHFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
60	FHRTN	Route Number	Numeric	Generic Edit	8	0	Allow NULL?
61	FHADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
62	FHUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
63	FHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
64	FHURDT	User Reserved Date	Date	Generic Edit	6	0
65	FHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
66	FHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
67	FHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
68	FHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
69	FHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
70	FHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
71	FHUPMJ	Date - Updated	Date	Generic Edit	6	0
72	FHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
73	FHFRSN	Freight Adjustment Reason Code	String	UDC (49 RS)	3	0	Allow NULL?
74	FHANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
75	FHTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
76	FHEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
77	FHCTYO	Origin City	String	Generic Edit	25	0	Allow NULL?
78	FHADSO	Origin State	String	UDC (00 S)	3	0	Allow NULL?
79	FHADZO	OriginPostal Code	String	Generic Edit	12	0	Allow NULL?
80	FHCTRO	OriginCountry	String	UDC (00 CN)	3	0	Allow NULL?
81	FHSCT1	Shipment Category Code 1	String	Generic Edit	3	0	Allow NULL?
82	FHSCT2	Shipment Category Code 2	String	Generic Edit	3	0	Allow NULL?
83	FHSCT3	Shipment Category Code 3	String	Generic Edit	3	0	Allow NULL?
84	FHSC1O	Origin Category Code 1	String	Generic Edit	3	0	Allow NULL?
85	FHSC2O	Origin Category Code 2	String	Generic Edit	3	0	Allow NULL?
86	FHSC3O	Origin Category Code 3	String	Generic Edit	3	0	Allow NULL?
87	FHLNMB	Leg Number	Numeric	Generic Edit	3	0	Allow NULL?
88	FHCNMR	Contract Number	String	Generic Edit	24	0	Allow NULL?
89	FHSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
90	FHCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
91	FHTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
92	FHOVRTAX	Carrier Tax Overridden	Character	Generic Edit	1	0	Allow NULL?
93	FHATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
94	FHCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?

TOP 812 | 49 | F4981 INDEXES

Number

Description

Unique Key (Primary/Unique)

Element	Alias	Description	Sequence
1	UK01	Unique Key ID 01 (Internal)	Ascending

Shipment Routing Step +

Element	Alias	Description	Sequence
1	SHPN	Shipment Number	Ascending
2	RSSN	Routing Step Number	Ascending
3	SDSQ	Schedule Sequence Number	Ascending
4	SCSN	Secondary Schedule Sequence Number	Ascending

Planning Depot Load +

Element	Alias	Description	Sequence
1	VMCU	Depot - Trip	Ascending
2	LDNM	Load Number	Ascending
3	SDSQ	Schedule Sequence Number	Ascending
4	SCSN	Secondary Schedule Sequence Number	Ascending

Delivery Number +

Element	Alias	Description	Sequence
1	DLNO	Delivery Number	Ascending
2	SDSQ	Schedule Sequence Number	Ascending
3	SCSN	Secondary Schedule Sequence Number	Ascending

Orig Doc Number

Element	Alias	Description	Sequence
1	ODOC	Document - Original	Ascending
2	ODCT	Document Type - Original	Ascending
3	OKCO	Document Company (Original Order)	Ascending
4	JELN	Journal Entry Line Number	Ascending

Voucher Keys

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending

Carrier Ship Date

Element	Alias	Description	Sequence
1	CARS	Carrier Number	Ascending
2	ADDJ	Date - Actual Ship Date	Ascending

Dest. Postal Ship Date

Element	Alias	Description	Sequence
1	ADDZ	Postal Code	Ascending
2	ADDJ	Date - Actual Ship Date	Ascending

Origin Postal Ship Date

Element	Alias	Description	Sequence
1	ADZO	OriginPostal Code	Ascending
2	ADDJ	Date - Actual Ship Date	Ascending

Reference# Carrier

Element	Alias	Description	Sequence
1	REFN	Reference Number	Ascending
2	CARS	Carrier Number	Ascending

Carrier Contract Number

Element	Alias	Description	Sequence
1	CARS	Carrier Number	Ascending
2	CNMR	Contract 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

94 COLUMNS | 11 INDEXES | 812 | 49 | F4981 TABLE

TOP 812 | 49 | F4981 COLUMNS

TOP 812 | 49 | F4981 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

94 COLUMNS | 11 INDEXES | 812 | 49 | F4981 TABLE

TOP812 | 49 | F4981 COLUMNS

TOP812 | 49 | F4981 INDEXES

TOP 812 | 49 | F4981 COLUMNS

TOP 812 | 49 | F4981 INDEXES