	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

105 COLUMNS | 4 INDEXES | 812 | 31B | F31B08 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	812	F31B08	TM	105	4	Tank Master	Files	31B: Blend Management

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 TMWTKID, TMTKNU, TMTKNM, TMTKDS, TMTKGR, TMTKVS, TMTKHS, TMTKSTA, TMTDOC, TMTCRS, TMMCU, TMTDIC, TMLOCN, TMWLOTN, TMWLOTN2, TMTKTYP, TMTSHP, TMTKFM, TMTKFF, TMTKCS, TMTKCW, TMTKCR, TMUMTW, TMUMTV, TMUMTD, TMWUMP1, TMUMT1, TMTKRP, TMTKRH, TMTRHM1, TMTHU1, TMTHU2, TMTHU3, TMTKFHS, TMTSM1, TMTSU1, TMTSU2, TMTSU3, TMTKFHW, TMTWM1, TMTWU1, TMTWU2, TMTWU3, TMTKFHR, TMTRMT1, TMTRU1, TMTRU2, TMTRU3, TMDCCO, TMTDCD, TMTKFC, TMTKIN, TMTKTC, TMTKSC, TMTKCC, TMTCRF, TMTTRC, TMTTRCM, TMTKSH, TMTKCH, TMTKHM, TMTTRH, TMTTRHM, TMTKPL, TMTKCF, TMTKFA, TMTKPU, TMTKRV, TMTKMO, TMTKSA, TMTKPR, TMTKLP, TMTKPS, TMCPNUM, TMSUPL, TMCTROW, TMFORES, TMTKPQ, TMTPBN, TMANUMW, TMTKGT, TMWCG, TMWOTC, TMVVI, TMWRF, TMWCD, TMWAB, TMWNUM, TMWMDT, TMURCD, TMURDT, TMURAT, TMURRF, TMURAB, TMUSER, TMPID, TMJOBN, TMMKEY, TMUPMJ, TMUPMT, TMWTKC01, TMWTKC02, TMWTKC03, TMWTKC04, TMWTKC05 FROM F31B08

TOP 812 | 31B | F31B08 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	TMWTKID	Tank ID	Numeric	Generic Edit	8	0	Allow NULL?
2	TMTKNU	Tank Number	String	Generic Edit	10	0	Allow NULL?
3	TMTKNM	Tank Name	String	Generic Edit	15	0	Allow NULL?
4	TMTKDS	Tank Description	String	Generic Edit	30	0	Allow NULL?
5	TMTKGR	Tank Group	String	Generic Edit	10	0	Allow NULL?
6	TMTKVS	Tank Volume Status	Character	UDC (31B VS)	1	0	Allow NULL?
7	TMTKHS	Tank Hygiene Status	Character	UDC (31B HS)	1	0	Allow NULL?
8	TMTKSTA	Tank Status	Character	UDC (31B SV)	1	0	Allow NULL?
9	TMTDOC	Tank Date Out of Commission	Date	Generic Edit	6	0
10	TMTCRS	Tank Comment Reason	String	Generic Edit	30	0	Allow NULL?
11	TMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
12	TMTDIC	Tank Date Back In Commission	Date	Generic Edit	6	0
13	TMLOCN	Location	String	Generic Edit	20	0	Allow NULL?
14	TMWLOTN	Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
15	TMWLOTN2	Blend Lot Number 2	String	Generic Edit	30	0	Allow NULL?
16	TMTKTYP	Tank Type	String	UDC (31B TT)	3	0	Allow NULL?
17	TMTSHP	Tank Shape	String	UDC (31B TV)	30	0	Allow NULL?
18	TMTKFM	Tank Fabrication Material	String	UDC (31B FM)	30	0	Allow NULL?
19	TMTKFF	Tank Fermenter	Character	Generic Edit	1	0	Allow NULL?
20	TMTKCS	Tank Capacity - Storage	Numeric	Generic Edit	15	4	Allow NULL?
21	TMTKCW	Tank Capacity - Ferment White	Numeric	Generic Edit	15	4	Allow NULL?
22	TMTKCR	Tank Capacity - Ferment Red	Numeric	Generic Edit	15	4	Allow NULL?
23	TMUMTW	UOM - Tank - Weight	String	Generic Edit	2	0	Allow NULL?
24	TMUMTV	UOM - Tank - Volume	String	UDC (31B UM)	2	0	Allow NULL?
25	TMUMTD	UOM - Tank - Dimension	String	UDC (31B UM)	2	0	Allow NULL?
26	TMWUMP1	Winery UOM Pressure 1	String	UDC (31B UM)	2	0	Allow NULL?
27	TMUMT1	Winery UOM Temperature 1	String	UDC (31B UM)	2	0	Allow NULL?
28	TMTKRP	Tank Reference Point	String	Generic Edit	30	0	Allow NULL?
29	TMTKRH	Tank Reference Height	Numeric	Generic Edit	15	4	Allow NULL?
30	TMTRHM1	Tank Reference Height MetVal1	Numeric	Generic Edit	15	4	Allow NULL?
31	TMTHU1	Tank Reference Height USVal1	Numeric	Generic Edit	15	4	Allow NULL?
32	TMTHU2	Tank Reference Height USVal2	Numeric	Generic Edit	15	4	Allow NULL?
33	TMTHU3	Tank Reference Height USVal3	Numeric	Generic Edit	15	4	Allow NULL?
34	TMTKFHS	Tank Fill Height - Storage	Numeric	Generic Edit	15	4	Allow NULL?
35	TMTSM1	Tank Storage Height MetVal1	Numeric	Generic Edit	15	4	Allow NULL?
36	TMTSU1	Tank Storage Height USVal1	Numeric	Generic Edit	15	4	Allow NULL?
37	TMTSU2	Tank Storage Height USVal2	Numeric	Generic Edit	15	4	Allow NULL?
38	TMTSU3	Tank Storage Height USVal3	Numeric	Generic Edit	15	4	Allow NULL?
39	TMTKFHW	Tank Fill Height - White	Numeric	Generic Edit	15	4	Allow NULL?
40	TMTWM1	Tank Ferm White Height MetVal1	Numeric	Generic Edit	15	4	Allow NULL?
41	TMTWU1	Tank Ferm White Height USVal1	Numeric	Generic Edit	15	4	Allow NULL?
42	TMTWU2	Tank Ferm White Height USVal2	Numeric	Generic Edit	15	4	Allow NULL?
43	TMTWU3	Tank Ferm White Height USVal3	Numeric	Generic Edit	15	4	Allow NULL?
44	TMTKFHR	Tank Fill Height - Red	Numeric	Generic Edit	15	4	Allow NULL?
45	TMTRMT1	Tank Ferm Red Height MetVal1	Numeric	Generic Edit	15	4	Allow NULL?
46	TMTRU1	Tank Ferm Red Height USVal1	Numeric	Generic Edit	15	4	Allow NULL?
47	TMTRU2	Tank Ferm Red Height USVal2	Numeric	Generic Edit	15	4	Allow NULL?
48	TMTRU3	Tank Ferm Red Height USVal3	Numeric	Generic Edit	15	4	Allow NULL?
49	TMDCCO	Dip Chart Code	String	Generic Edit	8	0	Allow NULL?
50	TMTDCD	Tank Dip Chart Description	String	Generic Edit	30	0	Allow NULL?
51	TMTKFC	Tank Floor Configuration	String	UDC (31B FC)	3	0	Allow NULL?
52	TMTKIN	Tank Insulated	Character	Generic Edit	1	0	Allow NULL?
53	TMTKTC	Tank Temperature Controlled	Character	Generic Edit	1	0	Allow NULL?
54	TMTKSC	Tank System - Cooling	Character	Generic Edit	1	0	Allow NULL?
55	TMTKCC	Tank Control System - Cooling	String	UDC (31B TC)	3	0	Allow NULL?
56	TMTCRF	Tank Cooling Refrigerant	String	UDC (31B CR)	4	0	Allow NULL?
57	TMTTRC	Tank Temperature Range Cooling	Numeric	Generic Edit	3	0	Allow NULL?
58	TMTTRCM	Tank Temperature Range Cooling Max	Numeric	Generic Edit	3	0	Allow NULL?
59	TMTKSH	Tank System - Heating	Character	Generic Edit	1	0	Allow NULL?
60	TMTKCH	Tank Control System - Heating	String	UDC (31B TH)	3	0	Allow NULL?
61	TMTKHM	Tank Heating Medium	String	UDC (31B HM)	4	0	Allow NULL?
62	TMTTRH	Temperature Range Heating	Numeric	Generic Edit	3	0	Allow NULL?
63	TMTTRHM	Temperature Range Heating Maximum	Numeric	Generic Edit	3	0	Allow NULL?
64	TMTKPL	Tank Placement	Character	UDC (31B TP)	1	0	Allow NULL?
65	TMTKCF	Tank Calibration	Character	UDC (31B MC)	1	0	Allow NULL?
66	TMTKFA	Tank Fixed Agitator	Character	Generic Edit	1	0	Allow NULL?
67	TMTKPU	Tank Pumping	String	UDC (31B PT)	3	0	Allow NULL?
68	TMTKRV	Tank Racking Valve	Character	Generic Edit	1	0	Allow NULL?
69	TMTKMO	Tank MicroOxygenated	Character	Generic Edit	1	0	Allow NULL?
70	TMTKSA	Tank Spirit Approved	Character	Generic Edit	1	0	Allow NULL?
71	TMTKPR	Tank Pressurized	Character	Generic Edit	1	0	Allow NULL?
72	TMTKLP	Tank Pressure Level	Numeric	Generic Edit	4	0	Allow NULL?
73	TMTKPS	Plank Tank Flag	Character	Generic Edit	1	0	Allow NULL?
74	TMCPNUM	Cooper Number	Numeric	Generic Edit	8	0	Allow NULL?
75	TMSUPL	Blend Supplier	Numeric	Generic Edit	8	0	Allow NULL?
76	TMCTROW	OriginCountry	String	UDC (00 CN)	3	0	Allow NULL?
77	TMFORES	Forest	String	UDC (31B FO)	8	0	Allow NULL?
78	TMTKPQ	Quantity - Tank Plank	Numeric	Generic Edit	6	0	Allow NULL?
79	TMTPBN	Piping Bank Number	String	Generic Edit	10	0	Allow NULL?
80	TMANUMW	Asset Number Wine	Numeric	Generic Edit	8	0	Allow NULL?
81	TMTKGT	Gauge Type	Character	UDC (31B TG)	1	0	Allow NULL?
82	TMWCG	Cost Group	String	Generic Edit	12	0	Allow NULL?
83	TMWOTC	One-Time Cost	Character	Generic Edit	1	0	Allow NULL?
84	TMVVI	Virtual Vessel Indicator	Character	Generic Edit	1	0	Allow NULL?
85	TMWRF	Blend Mgmt Reference	String	Generic Edit	30	0	Allow NULL?
86	TMWCD	Blend Mgmt Code	String	Generic Edit	3	0	Allow NULL?
87	TMWAB	Blend Mgmt Number	Numeric	Generic Edit	8	0	Allow NULL?
88	TMWNUM	Blend Mgmt Numeric	Numeric	Generic Edit	15	4	Allow NULL?
89	TMWMDT	Blend Mgmt Date	Date	Generic Edit	6	0
90	TMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
91	TMURDT	User Reserved Date	Date	Generic Edit	6	0
92	TMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
93	TMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
94	TMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
95	TMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
96	TMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
97	TMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
98	TMMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
99	TMUPMJ	Date - Updated	Date	Generic Edit	6	0
100	TMUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
101	TMWTKC01	Tank Master Category Code 1	String	UDC (31B K1)	10	0	Allow NULL?
102	TMWTKC02	Tank Master Category Code 2	String	UDC (31B K2)	10	0	Allow NULL?
103	TMWTKC03	Tank Master Category Code 3	String	UDC (31B K3)	10	0	Allow NULL?
104	TMWTKC04	Tank Master Category Code 4	String	UDC (31B K4)	10	0	Allow NULL?
105	TMWTKC05	Tank Master Category Code 5	String	UDC (31B K5)	10	0	Allow NULL?

TOP 812 | 31B | F31B08 INDEXES

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	WTKID	Tank ID	Ascending
2	MCU	Business Unit	Ascending

NameMCU

Element	Alias	Description	Sequence
1	TKNM	Tank Name	Ascending
2	MCU	Business Unit	Ascending

NumberMCU

Element	Alias	Description	Sequence
1	TKNU	Tank Number	Ascending
2	MCU	Business Unit	Ascending

DipChrtCdMCU

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	DCCO	Dip Chart Code	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

105 COLUMNS | 4 INDEXES | 812 | 31B | F31B08 TABLE

TOP 812 | 31B | F31B08 COLUMNS

TOP 812 | 31B | F31B08 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

105 COLUMNS | 4 INDEXES | 812 | 31B | F31B08 TABLE

TOP812 | 31B | F31B08 COLUMNS

TOP812 | 31B | F31B08 INDEXES

TOP 812 | 31B | F31B08 COLUMNS

TOP 812 | 31B | F31B08 INDEXES