	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

79 COLUMNS | 4 INDEXES | 920 | 49 | F4960 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
49: Transportation Management
1	920	F4960	TM	79	4	Load Header	Transaction 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 TMVMCU, TMLDNM, TMNMCU, TMORGN, TMMCUX, TMANCC, TMANID, TMOVOD, TMCTY1, TMADDS, TMADDZ, TMCTR, TMZON, TMLDTY, TMLDLS, TMLOAD, TMSHFT, TMSEQ, TMTMLS, TMPPDJ, TMPMDT, TMADDJ, TMADTM, TMMOT, TMOVRM, TMVTYP, TMPVEH, TMRLNO, TMDUMV, TMCNNV, TMCARS, TMOVRC, TMROUT, TMRTN, TMFRSC, TMCZON, TMDSGP, TMDATY, TMDSCD, TMLDLE, TMSEAL, TMLMCU, TMLTRP, TMDSTN, TMUMD1, TMDSRC, TMODST, TMELTM, TMUM, TMCVUM, TMWTUM, TMVLUM, TMVR01, TMNSTP, TMRRTR, TMRATR, TMFRVC, TMFRVF, TMCRCP, TMIBRS, TMDKID, TMDEPU, TMDLPU, TMTPUF, TMTPUT, TMLSLT, TMLSUT, TMLALT, TMLAUT, TMURCD, TMURDT, TMURAT, TMURAB, TMURRF, TMUSER, TMPID, TMJOBN, TMUPMJ, TMTDAY FROM F4960

TOP 920 | 49 | F4960 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	TMVMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
2	TMLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
3	TMNMCU	Shipment Depot	String	Generic Edit	12	0	Allow NULL?
4	TMORGN	Origin Address Number	Numeric	Generic Edit	8	0	Allow NULL?
5	TMMCUX	Business Unit - Destination	String	Generic Edit	12	0	Allow NULL?
6	TMANCC	Address Number Destination	Numeric	Generic Edit	8	0	Allow NULL?
7	TMANID	Intermediate Destination Address Number	Numeric	Generic Edit	8	0	Allow NULL?
8	TMOVOD	Override Origin/Destination	Character	UDC (49 OV)	1	0	Allow NULL?
9	TMCTY1	City	String	Generic Edit	25	0	Allow NULL?
10	TMADDS	State	String	UDC (00 S)	3	0	Allow NULL?
11	TMADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
12	TMCTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
13	TMZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
14	TMLDTY	Load Type	String	UDC (49 LT)	2	0	Allow NULL?
15	TMLDLS	Load Status	String	UDC (49 SL)	2	0	Allow NULL?
16	TMLOAD	Date - Scheduled Load	Date	Generic Edit	6	0
17	TMSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
18	TMSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
19	TMTMLS	Time - Load Scheduled	Numeric	Generic Edit	6	0	Allow NULL?
20	TMPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
21	TMPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
22	TMADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
23	TMADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
24	TMMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
25	TMOVRM	Mode of Transport Override Code	Character	Generic Edit	1	0	Allow NULL?
26	TMVTYP	Vehicle Type	String	Generic Edit	12	0	Allow NULL?
27	TMPVEH	Primary Vehicle Id	String	Generic Edit	12	0	Allow NULL?
28	TMRLNO	Registration/License Number	String	Generic Edit	13	0	Allow NULL?
29	TMDUMV	Dummy Vehicle (Y/N)	Character	Generic Edit	1	0	Allow NULL?
30	TMCNNV	Connected Vehicle (Y/N)	Character	Generic Edit	1	0	Allow NULL?
31	TMCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
32	TMOVRC	Carrier Override Code	Character	Generic Edit	1	0	Allow NULL?
33	TMROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
34	TMRTN	Route Number	Numeric	Generic Edit	8	0	Allow NULL?
35	TMFRSC	Freight Rate Schedule	String	UDC (49 BK)	8	0	Allow NULL?
36	TMCZON	Carrier Zone	String	UDC (49 CF)	10	0	Allow NULL?
37	TMDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
38	TMDATY	Dispatch Type	Character	UDC (49 DY)	1	0	Allow NULL?
39	TMDSCD	Disposition Code	Character	UDC (49 DH)	1	0	Allow NULL?
40	TMLDLE	Load Line	Character	Generic Edit	1	0	Allow NULL?
41	TMSEAL	Number of Seals Required	Numeric	Generic Edit	5	0	Allow NULL?
42	TMLMCU	Depot - Prior Trip	String	Generic Edit	12	0	Allow NULL?
43	TMLTRP	Prior Trip Number	Numeric	Generic Edit	8	0	Allow NULL?
44	TMDSTN	Distance	Numeric	Generic Edit	5	0	Allow NULL?
45	TMUMD1	Unit of Measure - Distance	String	UDC (00 UM)	2	0	Allow NULL?
46	TMDSRC	Distance Source	Character	UDC (49 BC)	1	0	Allow NULL?
47	TMODST	Out of Route Distance	Numeric	Generic Edit	5	0	Allow NULL?
48	TMELTM	Time - Elapsed	Numeric	Generic Edit	6	0	Allow NULL?
49	TMUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
50	TMCVUM	Unit of Measure - Cubes	String	UDC (00 UM)	2	0	Allow NULL?
51	TMWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
52	TMVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
53	TMVR01	Reference	String	Generic Edit	25	0	Allow NULL?
54	TMNSTP	Number of Stops	Numeric	Generic Edit	3	0	Allow NULL?
55	TMRRTR	Routing Status	Character	UDC (49 DJ)	1	0	Allow NULL?
56	TMRATR	Rating Status	Character	UDC (49 DK)	1	0	Allow NULL?
57	TMFRVC	Amount - Supplier Freight Charge	Numeric	Generic Edit	15	4	Allow NULL?
58	TMFRVF	Amount - Supplier Freight Charge Foreign	Numeric	Generic Edit	15	4	Allow NULL?
59	TMCRCP	Currency Code - A/P Amounts	String	Generic Edit	3	0	Allow NULL?
60	TMIBRS	Inbound Route Selected	Character	Generic Edit	1	0	Allow NULL?
61	TMDKID	Dock ID	String	Generic Edit	20	0	Allow NULL?
62	TMDEPU	Date - Earliest Pickup	Date	Generic Edit	6	0
63	TMDLPU	Date - Latest Pickup	Date	Generic Edit	6	0
64	TMTPUF	Time - Pickup From	Numeric	Generic Edit	4	0	Allow NULL?
65	TMTPUT	Time - Pickup Thru	Numeric	Generic Edit	4	0	Allow NULL?
66	TMLSLT	Time - Scheduled Loading	Numeric	Generic Edit	6	0	Allow NULL?
67	TMLSUT	Time - Scheduled Unloading	Numeric	Generic Edit	6	0	Allow NULL?
68	TMLALT	Time - Actual Loading	Numeric	Generic Edit	6	0	Allow NULL?
69	TMLAUT	Time - Actual Unloading	Numeric	Generic Edit	6	0	Allow NULL?
70	TMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
71	TMURDT	User Reserved Date	Date	Generic Edit	6	0
72	TMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
73	TMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
74	TMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
75	TMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
76	TMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
77	TMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
78	TMUPMJ	Date - Updated	Date	Generic Edit	6	0
79	TMTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 49 | F4960 INDEXES

Number

Description

Depot Load# (Primary/Unique)

Element	Alias	Description	Sequence
1	VMCU	Depot - Trip	Ascending
2	LDNM	Load Number	Ascending

Vehicle Ship Date +

Element	Alias	Description	Sequence
1	PVEH	Primary Vehicle Id	Ascending
2	PPDJ	Date - Promised Shipment	Ascending
3	SHFT	Shift Code	Ascending
4	SEQ	Sequence Number	Ascending

Shift Ship dt Veh Id

Element	Alias	Description	Sequence
1	SHFT	Shift Code	Ascending
2	PPDJ	Date - Promised Shipment	Ascending
3	PVEH	Primary Vehicle Id	Ascending

Prim Veh Reg Load Dt Shift+

Element	Alias	Description	Sequence
1	PVEH	Primary Vehicle Id	Ascending
2	RLNO	Registration/License Number	Ascending
3	LOAD	Date - Scheduled Load	Descending
4	SHFT	Shift Code	Descending
5	SEQ	Sequence 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

79 COLUMNS | 4 INDEXES | 920 | 49 | F4960 TABLE

TOP 920 | 49 | F4960 COLUMNS

TOP 920 | 49 | F4960 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

79 COLUMNS | 4 INDEXES | 920 | 49 | F4960 TABLE

TOP920 | 49 | F4960 COLUMNS

TOP920 | 49 | F4960 INDEXES

TOP 920 | 49 | F4960 COLUMNS

TOP 920 | 49 | F4960 INDEXES