	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

104 tables910 | 49

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
49: Transportation Management
1	910	F47092TX	DT	30	1	EDI Request for Quote Detail Tax - Inbound	Batch Input Files	42B: Sales Order Entry
2	910	F47500WF	SZ	9	1	Inbound Transaction Processor Workfile	Files	49: Transportation Management
3	910	F49002	TX	35	1	Transportation Constants	Constants Files	49: Transportation Management	Business Data
4	910	F49003	LT	28	1	Load Type Constants	Constants Files	49: Transportation Management	Business Data
5	910	F49004	CT	23	1	Mode of Transport Constants	Constants Files	49: Transportation Management	Business Data
6	910	F49005	TG	15	1	Generate Tracking Number	Constants Files	49: Transportation Management	Business Data
7	910	F490051	XG	23	1	Generate Tracking Number Segment	Constants Files	49: Transportation Management	Business Data
8	910	F490052	YG	18	1	Generate Tracking Segment Next Number	Constants Files	49: Transportation Management	Business Data
9	910	F490053	ZG	16	4	Generate Tracking Number Separator	Constants Files	49: Transportation Management	Business Data
10	910	F49010	VM	45	1	Vehicle Master (Conversion from World File)	Master Files	49: Transportation Management	Business Data
11	910	F49012	VO	13	1	Vehicle Compartments (Conversion from World File)	Secondary Master Files	49: Transportation Management	Business Data
12	910	F49015	ST	9	2	Vehicle Status	Secondary Master Files	49: Transportation Management	Business Data
13	910	F4902	TV	17	1	Vehicle Current Load	Balance Files	49: Transportation Management	Business Data
14	910	F49020	VL	21	2	Vehicle/Staff License Information	Secondary Master Files	49: Transportation Management	Business Data
15	910	F49025	CV	18	1	Connected Vehicles (Conversion from World File)	Secondary Master Files	49: Transportation Management	Business Data
16	910	F49030	VE	10	1	Vehicle Equipment (Conversion from World File)	Secondary Master Files	49: Transportation Management	Business Data
17	910	F49040	VS	12	1	Vehicle Staff (Conversion from World File)	Secondary Master Files	49: Transportation Management	Business Data
18	910	F49041	VS	12	1	Depot/Vehicle Staff	Master Files	49: Transportation Management	Business Data
19	910	F4906	CM	17	1	Carrier Master	Master Files	49: Transportation Management	Business Data
20	910	F49075	PM	8	3	Product Mix	Extra Features Files	49: Transportation Management	Business Data
21	910	F4908	II	24	1	Item Shipping Information	Secondary Master Files	49: Transportation Management	Business Data
22	910	F49110	BW	88	4	Transportation Bill of Lading Workfile	Work Files	49: Transportation Management	Business Data
23	910	F49111	CD	17	1	Carton Detail Shipment Workfile	Files	49: Transportation Management	Business Data
24	910	F49130	BW	46	1	Shipment Document Workfile	Work Files	49: Transportation Management	Business Data
25	910	F49140	BW	49	1	SSCC Print Label Workfile	Work Files	49: Transportation Management	Business Data
26	910	F49141	PW	39	1	Packing List Workfile	Work Files	49: Transportation Management	Business Data
27	910	F49160	NN	16	1	Document Next Number	Extra Features Files	49: Transportation Management	Business Data
28	910	F49170	NN	3	1	Load Next Numbers	Constants Files	49: Transportation Management	Business Data
29	910	F4918	LT	18	2	Load Tender History	Transaction Files	49: Transportation Management	Business Data
30	910	F49191	DS	24	1	Document Definition	Master Files	49: Transportation Management	Business Data
31	910	F49195	DU	7	1	Document Set - Keys Doc Code - Doc Set (Conversion from World)	Extra Features Files	49: Transportation Management	Business Data
32	910	F49196	DU	7	2	Document Set	Secondary Master Files	49: Transportation Management	Business Data
33	910	F49197	OQ	18	1	Depot Document Print Set Up (Conversion from World File)	Secondary Master Files	49: Transportation Management	Business Data
34	910	F49198	OQ	25	1	Depot Document Print Setup	Secondary Master Files	49: Transportation Management	Business Data
35	910	F4930	VM	33	2	Vehicle Master	Master Files	49: Transportation Management	Business Data
36	910	F49301	VO	17	1	Vehicle Compartments	Master Files	49: Transportation Management	Business Data
37	910	F49302	VE	16	2	Vehicle Equipment	Master Files	49: Transportation Management	Business Data
38	910	F4931	VG	45	1	Vehicle Type	Master Files	49: Transportation Management	Business Data
39	910	F4935	VH	22	1	Connected Vehicle Header	Master Files	49: Transportation Management	Business Data
40	910	F4936	CW	17	2	Connected Vehicle Detail	Master Files	49: Transportation Management	Business Data
41	910	F49380	SU	18	4	Seal Numbers	Transaction Files	49: Transportation Management	Business Data
42	910	F4941	RS	91	6	Shipment Routing Steps	Transaction Files	49: Transportation Management	Business Data
43	910	F4942	IS	34	4	Shipment Detail	Transaction Files	49: Transportation Management	Business Data
44	910	F4943	SP	28	6	Shipment Pieces	Transaction Files	49: Transportation Management	Business Data
45	910	F4944	OE	21	1	Shipment/Load Options and Equipment	Transaction Files	49: Transportation Management	Business Data
46	910	F4945	SC	45	8	Shipment Charges	Transaction Files	49: Transportation Management	Business Data
47	910	F4947	ST	20	2	Shipment Status Codes	Transaction Files	49: Transportation Management	Business Data
48	910	F49490	TQ	27	5	Document Selection	Batch Input Files	49: Transportation Management	Business Data
49	910	F4950	RT	53	14	Routing Entries	Master Files	49: Transportation Management	Business Data
50	910	F49501	RD	35	1	Intermodal Detail Routing Entries	Master Files	49: Transportation Management	Business Data
51	910	F4951	ZN	18	1	Carrier Zone Definitions	Master Files	49: Transportation Management	Business Data
52	910	F4952	RE	29	1	Routing Restrictions	Master Files	49: Transportation Management	Business Data
53	910	F4953	RG	7	1	Routing Hierarchy	Constants Files	49: Transportation Management	Business Data
54	910	F4956	IX	18	1	Option and Equipment Inclusions/Exclusions	Master Files	49: Transportation Management	Business Data
55	910	F4957	BC	25	2	Transportation Confirmed Batch Shipment	Constants Files	49: Transportation Management	Business Data
56	910	F49590	DB	15	1	Document Print Batch Header	Batch Input Files	49: Transportation Management	Business Data
57	910	F49591	DB	25	3	Document Print - Batch Selection	Work Files	49: Transportation Management	Business Data
58	910	F49592	DH	37	2	Document Print Batch Document Header	Work Files	49: Transportation Management	Business Data
59	910	F49594	DI	40	2	Document Print - Document Detail	Work Files	49: Transportation Management	Business Data
60	910	F49595	DK	35	3	Document Print - Document Summary	Transaction Files	49: Transportation Management	Business Data
61	910	F4960	TM	79	4	Load Header	Transaction Files	49: Transportation Management	Business Data
62	910	F4961	LL	33	1	Load Legs	Transaction Files	49: Transportation Management	Business Data
63	910	F49611	LD	22	1	Load Stop Sequence	Transaction Files	49: Transportation Management	Business Data
64	910	F49612	TD	18	2	Load Vehicles	Transaction Files	49: Transportation Management	Business Data
65	910	F49614	TS	14	1	Load Staff	Transaction Files	49: Transportation Management	Business Data
66	910	F4962	TE	31	2	Load Compartments	Transaction Files	49: Transportation Management	Business Data
67	910	F49621	TD	46	2	Load Compartment Detail	Transaction Files	49: Transportation Management	Business Data
68	910	F4963	TI	36	1	Load In-transit	Transaction Files	49: Transportation Management	Business Data
69	910	F49631	TO	86	2	Load In-transit Ledger	Transaction Files	49: Transportation Management
70	910	F49632	LB	40	3	Load In-transit Left on Board	Transaction Files	49: Transportation Management	Business Data
71	910	F49633	IQ	38	1	Load In-Transit Confirmed Quantities	Files	49: Transportation Management
72	910	F49634	QD	29	1	Load In-Transit Confirmed Quantities Detail	Files	49: Transportation Management
73	910	F49695	DR	35	1	Document Register	History Files	49: Transportation Management	Business Data
74	910	F49696	DJ	27	2	Document Register Detail	History Files	49: Transportation Management	Business Data
75	910	F49697	DN	24	3	Document Register Summary	Extra Features Files	49: Transportation Management	Business Data
76	910	F4970	FT	10	1	Freight Rate Schedule	Master Files	49: Transportation Management	Business Data
77	910	F4971	RD	49	1	Freight Rate Definition	Master Files	49: Transportation Management	Business Data
78	910	F4972	RX	29	10	Rate Detail	Master Files	49: Transportation Management	Business Data
79	910	F49721	QS	18	1	Spot Quote Detail	Transaction Files	49: Transportation Management	Business Data
80	910	F4973	TL	14	4	Rate Structure Definition	Master Files	49: Transportation Management	Business Data
81	910	F4974	RW	34	2	RateWare XL Rate Constants	Files	49: Transportation Management
82	910	F4977	MR	30	2	Rate Parameters	Master Files	49: Transportation Management	Business Data
83	910	F4978	CG	16	1	Charge Code Definitions	Master Files	49: Transportation Management	Business Data
84	910	F4981	FH	94	11	Freight Audit History	History Files	49: Transportation Management	Business Data
85	910	F49T00	IC	15	1	Integration Constants	Files	49: Transportation Management
86	910	F49T01	CR	14	2	Cross Reference	Files	49: Transportation Management
87	910	F49T05	OR	10	1	OTM Record Reservation	Files	49: Transportation Management
88	910	F49T10	OR	71	2	Sales Order Release Staging Table	Files	49: Transportation Management
89	910	F49T100	OB	67	2	Procurement Freight Request staging table	Files	49: Transportation Management
90	910	F49T11	IT	45	1	Item Staging Table	Files	49: Transportation Management
91	910	F49T20	SS	54	3	Shipment Staging Table	Files	49: Transportation Management
92	910	F49T211	TP	41	7	Sales Order Detail File - Secondary Tag Table	Files	49: Transportation Management
93	910	F49T219	TP	41	7	Sales Order Detail File - Secondary Tag History Table	Files	49: Transportation Management
94	910	F49T30	SO	44	4	Sales Confirm Staging Table	Files	49: Transportation Management
95	910	F49T311	TP	18	1	Purchase Order Detail - OTM	Files	49: Transportation Management
96	910	F49T380	SO	15	2	Seal Numbers	Files	49: Transportation Management
97	910	F49T40	TC	31	3	Shipment Freight Cost Staging Table	Files	49: Transportation Management
98	910	F49T50	LO	46	2	Order Release Location Staging	Files	49: Transportation Management
99	910	F49T60	IV	18	1	Voucher Cross Reference	Files	49: Transportation Management
100	910	F49T70	CS	27	2	Corporations Staging Table	Files	49: Transportation Management
101	910	F49T70W	CW	6	2	Corporations Staging Work Table	Files	49: Transportation Management
102	910	F49T80	LC	31	2	Locations Staging Table	Files	49: Transportation Management
103	910	F49T80W	LW	6	2	Locations Staging Work Table	Files	49: Transportation Management
104	910	F49T90	IT	4	1	Inbound Transmissions	Files	49: Transportation Management

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

104 tables910 | 49