	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

83 COLUMNS | 4 INDEXES | 812 | 49 | F49110 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
49: Transportation Management
1	812	F49110	BW	83	4	Transportation Bill of Lading Workfile	Work 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 BWBN01, BWMCUZ, BWDCCD, BWSHPN, BWRSSN, BWCTID, BWJOBS, BWSEQN, BWSDPC, BWORGN, BWANCC, BWRAN8, BWAN8, BWSHAN, BWMOT, BWCARS, BWFRTH, BWRSDJ, BWRSDT, BWNPCS, BWNCTR, BWWGTS, BWWTUM, BWDRCF, BWDOC, BWDCT, BWKCO, BWDCNS, BWCO, BWEMCU, BWMCU, BWDTDO, BWREFQ, BWREFN, BWDOCO, BWDCTO, BWKCOO, BWLNID, BWITM, BWSOQS, BWUOM, BWNMFC, BWITWT, BWWGTU, BWTEMP, BWSTPU, BWDNTY, BWDNTP, BWDETP, BWDTPU, BWVCF, BWPRAS, BWIQTY, BWSTUM, BWBUM6, BWAMBR, BWVUOM, BWCNMR, BWLNMB, BWRTN, BWURCD, BWURDT, BWURAT, BWURAB, BWURRF, BWAETC, BWSLN, BWCIRV, BWYEAR1, BWCSTPO, BWRLNU, BWPSIG, BWRORN, BWCUMS, BWETRSC, BWCITM, BWDKID, BWETRC, BWPSJOBNO, BWJOBSQ, BWDELBATCH, BWUKID, BWCUMID FROM F49110

TOP 812 | 49 | F49110 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	BWBN01	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
2	BWMCUZ	Business Unit - Alt	String	Generic Edit	12	0	Allow NULL?
3	BWDCCD	Document Code	String	Generic Edit	4	0	Allow NULL?
4	BWSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
5	BWRSSN	Routing Step Number	Numeric	Generic Edit	3	1	Allow NULL?
6	BWCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
7	BWJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
8	BWSEQN	Sequence Number	Numeric	Generic Edit	7	0	Allow NULL?
9	BWSDPC	Status - Document Print Control	Character	UDC (49 DP)	1	0	Allow NULL?
10	BWORGN	Origin Address Number	Numeric	Generic Edit	8	0	Allow NULL?
11	BWANCC	Address Number Destination	Numeric	Generic Edit	8	0	Allow NULL?
12	BWRAN8	Related - Address Number	Numeric	Generic Edit	8	0	Allow NULL?
13	BWAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
14	BWSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
15	BWMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
16	BWCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
17	BWFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
18	BWRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
19	BWRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
20	BWNPCS	Number of Pieces	Numeric	Generic Edit	5	0	Allow NULL?
21	BWNCTR	Number of Containers	Numeric	Generic Edit	5	0	Allow NULL?
22	BWWGTS	Shipment Weight	Numeric	Generic Edit	15	4	Allow NULL?
23	BWWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
24	BWDRCF	Flag - Delivery Document Recreate	Character	Generic Edit	1	0	Allow NULL?
25	BWDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
26	BWDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
27	BWKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
28	BWDCNS	Document Number Source	Character	UDC (49 DA)	1	0	Allow NULL?
29	BWCO	Company	String	Generic Edit	5	0	Allow NULL?
30	BWEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
31	BWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
32	BWDTDO	Date - Document	Date	Generic Edit	6	0
33	BWREFQ	Reference Number Qualifier	String	UDC (41 X6)	2	0	Allow NULL?
34	BWREFN	Reference Number	String	Generic Edit	30	0	Allow NULL?
35	BWDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
36	BWDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
37	BWKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
38	BWLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
39	BWITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
40	BWSOQS	Quantity Shipped	Numeric	Generic Edit	15	2	Allow NULL?
41	BWUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
42	BWNMFC	Freight Classification (NMFC)	String	UDC (49 BE)	4	0	Allow NULL?
43	BWITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
44	BWWGTU	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
45	BWTEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
46	BWSTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
47	BWDNTY	Density	Numeric	Generic Edit	7	2	Allow NULL?
48	BWDNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
49	BWDETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
50	BWDTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
51	BWVCF	Volume Correction Factor	Numeric	Generic Edit	7	4	Allow NULL?
52	BWPRAS	Price at Ambient/Standard/Weight (A S W)	Character	UDC (38 PR)	1	0	Allow NULL?
53	BWIQTY	Units - Invoice Quantity	Numeric	Generic Edit	15	2	Allow NULL?
54	BWSTUM	Quantity - Primary Stock Accounting Unit	Numeric	Generic Edit	15	2	Allow NULL?
55	BWBUM6	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
56	BWAMBR	Volume - Ambient	Numeric	Generic Edit	15	2	Allow NULL?
57	BWVUOM	Unit of Measure - Volume	String	UDC (00 UM)	2	0	Allow NULL?
58	BWCNMR	Contract Number	String	Generic Edit	24	0	Allow NULL?
59	BWLNMB	Leg Number	Numeric	Generic Edit	3	0	Allow NULL?
60	BWRTN	Route Number	Numeric	Generic Edit	8	0	Allow NULL?
61	BWURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
62	BWURDT	User Reserved Date	Date	Generic Edit	6	0
63	BWURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
64	BWURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
65	BWURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
66	BWAETC	Authorization Code	String	Generic Edit	10	0	Allow NULL?
67	BWSLN	Seal Number	Numeric	Generic Edit	10	0	Allow NULL?
68	BWCIRV	Item Revision Level - Customer/Supplier	String	Generic Edit	20	0	Allow NULL?
69	BWYEAR1	Model Year 1	Numeric	Generic Edit	4	0	Allow NULL?
70	BWCSTPO	Customer PO	String	Generic Edit	30	0	Allow NULL?
71	BWRLNU	Release Number	String	Generic Edit	10	0	Allow NULL?
72	BWPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
73	BWRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
74	BWCUMS	CUM Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
75	BWETRSC	Excess Reason Code	String	UDC (49 ES)	3	0	Allow NULL?
76	BWCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
77	BWDKID	Dock ID	String	Generic Edit	20	0	Allow NULL?
78	BWETRC	Excess Responsibility	String	UDC (49 EC)	3	0	Allow NULL?
79	BWPSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
80	BWJOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
81	BWDELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?
82	BWUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
83	BWCUMID	CUM ID	Numeric	Generic Edit	15	0	Allow NULL?

TOP 812 | 49 | F49110 INDEXES

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	BN01	Batch Number	Ascending
2	MCUZ	Business Unit - Alt	Ascending
3	DCCD	Document Code	Ascending
4	SHPN	Shipment Number	Ascending
5	RSSN	Routing Step Number	Ascending
6	DOCO	Document (Order No Invoice etc.)	Ascending
7	DCTO	Order Type	Ascending
8	KCOO	Order Company (Order Number)	Ascending
9	LNID	Line Number	Ascending
10	UKID	Unique Key ID (Internal)	Ascending

Shipment Rtg Step Item U/M

Element	Alias	Description	Sequence
1	BN01	Batch Number	Ascending
2	MCUZ	Business Unit - Alt	Ascending
3	DCCD	Document Code	Ascending
4	SHPN	Shipment Number	Ascending
5	RSSN	Routing Step Number	Ascending
6	ITM	Item Number - Short	Ascending
7	UOM	Unit of Measure as Input	Ascending

BN01 MCUZ + With LNID Desc

Element	Alias	Description	Sequence
1	BN01	Batch Number	Ascending
2	MCUZ	Business Unit - Alt	Ascending
3	DCCD	Document Code	Ascending
4	SHPN	Shipment Number	Ascending
5	RSSN	Routing Step Number	Ascending
6	DOCO	Document (Order No Invoice etc.)	Ascending
7	DCTO	Order Type	Ascending
8	KCOO	Order Company (Order Number)	Ascending
9	LNID	Line Number	Descending

UKID

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	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

83 COLUMNS | 4 INDEXES | 812 | 49 | F49110 TABLE

TOP 812 | 49 | F49110 COLUMNS

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

83 COLUMNS | 4 INDEXES | 812 | 49 | F49110 TABLE

TOP812 | 49 | F49110 COLUMNS

TOP812 | 49 | F49110 INDEXES

TOP 812 | 49 | F49110 COLUMNS

TOP 812 | 49 | F49110 INDEXES