JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

105 COLUMNS | 4 INDEXES | Print definition?920 | 31B | F31B08 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B08TM1054Tank MasterFiles31B: 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

TOP920 | 31B | F31B08 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1TMWTKIDTank IDNumericGeneric Edit80 Allow NULL? 
2TMTKNUTank NumberStringGeneric Edit100 Allow NULL? 
3TMTKNMTank NameStringGeneric Edit150 Allow NULL? 
4TMTKDSTank DescriptionStringGeneric Edit300 Allow NULL? 
5TMTKGRTank GroupStringGeneric Edit100 Allow NULL? 
6TMTKVSTank Volume StatusCharacterUDC (31B VS)10 Allow NULL? 
7TMTKHSTank Hygiene StatusCharacterUDC (31B HS)10 Allow NULL? 
8TMTKSTATank StatusCharacterUDC (31B SV)10 Allow NULL? 
9TMTDOCTank Date Out of CommissionDateGeneric Edit60
10TMTCRSTank Comment ReasonStringGeneric Edit300 Allow NULL? 
11TMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
12TMTDICTank Date Back In CommissionDateGeneric Edit60
13TMLOCNLocationStringGeneric Edit200 Allow NULL? 
14TMWLOTNBlend Lot NumberStringGeneric Edit300 Allow NULL? 
15TMWLOTN2Blend Lot Number 2StringGeneric Edit300 Allow NULL? 
16TMTKTYPTank TypeStringUDC (31B TT)30 Allow NULL? 
17TMTSHPTank ShapeStringUDC (31B TV)300 Allow NULL? 
18TMTKFMTank Fabrication MaterialStringUDC (31B FM)300 Allow NULL? 
19TMTKFFTank FermenterCharacterGeneric Edit10 Allow NULL? 
20TMTKCSTank Capacity - StorageNumericGeneric Edit154 Allow NULL? 
21TMTKCWTank Capacity - Ferment WhiteNumericGeneric Edit154 Allow NULL? 
22TMTKCRTank Capacity - Ferment RedNumericGeneric Edit154 Allow NULL? 
23TMUMTWUOM - Tank - WeightStringGeneric Edit20 Allow NULL? 
24TMUMTVUOM - Tank - VolumeStringUDC (31B UM)20 Allow NULL? 
25TMUMTDUOM - Tank - DimensionStringUDC (31B UM)20 Allow NULL? 
26TMWUMP1Winery UOM Pressure 1StringUDC (31B UM)20 Allow NULL? 
27TMUMT1Winery UOM Temperature 1StringUDC (31B UM)20 Allow NULL? 
28TMTKRPTank Reference PointStringGeneric Edit300 Allow NULL? 
29TMTKRHTank Reference HeightNumericGeneric Edit154 Allow NULL? 
30TMTRHM1Tank Reference Height MetVal1NumericGeneric Edit154 Allow NULL? 
31TMTHU1Tank Reference Height USVal1NumericGeneric Edit154 Allow NULL? 
32TMTHU2Tank Reference Height USVal2NumericGeneric Edit154 Allow NULL? 
33TMTHU3Tank Reference Height USVal3NumericGeneric Edit154 Allow NULL? 
34TMTKFHSTank Fill Height - StorageNumericGeneric Edit154 Allow NULL? 
35TMTSM1Tank Storage Height MetVal1NumericGeneric Edit154 Allow NULL? 
36TMTSU1Tank Storage Height USVal1NumericGeneric Edit154 Allow NULL? 
37TMTSU2Tank Storage Height USVal2NumericGeneric Edit154 Allow NULL? 
38TMTSU3Tank Storage Height USVal3NumericGeneric Edit154 Allow NULL? 
39TMTKFHWTank Fill Height - WhiteNumericGeneric Edit154 Allow NULL? 
40TMTWM1Tank Ferm White Height MetVal1NumericGeneric Edit154 Allow NULL? 
41TMTWU1Tank Ferm White Height USVal1NumericGeneric Edit154 Allow NULL? 
42TMTWU2Tank Ferm White Height USVal2NumericGeneric Edit154 Allow NULL? 
43TMTWU3Tank Ferm White Height USVal3NumericGeneric Edit154 Allow NULL? 
44TMTKFHRTank Fill Height - RedNumericGeneric Edit154 Allow NULL? 
45TMTRMT1Tank Ferm Red Height MetVal1NumericGeneric Edit154 Allow NULL? 
46TMTRU1Tank Ferm Red Height USVal1NumericGeneric Edit154 Allow NULL? 
47TMTRU2Tank Ferm Red Height USVal2NumericGeneric Edit154 Allow NULL? 
48TMTRU3Tank Ferm Red Height USVal3NumericGeneric Edit154 Allow NULL? 
49TMDCCODip Chart CodeStringGeneric Edit80 Allow NULL? 
50TMTDCDTank Dip Chart DescriptionStringGeneric Edit300 Allow NULL? 
51TMTKFCTank Floor ConfigurationStringUDC (31B FC)30 Allow NULL? 
52TMTKINTank InsulatedCharacterGeneric Edit10 Allow NULL? 
53TMTKTCTank Temperature ControlledCharacterGeneric Edit10 Allow NULL? 
54TMTKSCTank System - CoolingCharacterGeneric Edit10 Allow NULL? 
55TMTKCCTank Control System - CoolingStringUDC (31B TC)30 Allow NULL? 
56TMTCRFTank Cooling RefrigerantStringUDC (31B CR)40 Allow NULL? 
57TMTTRCTank Temperature Range CoolingNumericGeneric Edit30 Allow NULL? 
58TMTTRCMTank Temperature Range Cooling MaxNumericGeneric Edit30 Allow NULL? 
59TMTKSHTank System - HeatingCharacterGeneric Edit10 Allow NULL? 
60TMTKCHTank Control System - HeatingStringUDC (31B TH)30 Allow NULL? 
61TMTKHMTank Heating MediumStringUDC (31B HM)40 Allow NULL? 
62TMTTRHTemperature Range HeatingNumericGeneric Edit30 Allow NULL? 
63TMTTRHMTemperature Range Heating MaximumNumericGeneric Edit30 Allow NULL? 
64TMTKPLTank PlacementCharacterUDC (31B TP)10 Allow NULL? 
65TMTKCFTank CalibrationCharacterUDC (31B MC)10 Allow NULL? 
66TMTKFATank Fixed AgitatorCharacterGeneric Edit10 Allow NULL? 
67TMTKPUTank PumpingStringUDC (31B PT)30 Allow NULL? 
68TMTKRVTank Racking ValveCharacterGeneric Edit10 Allow NULL? 
69TMTKMOTank MicroOxygenatedCharacterGeneric Edit10 Allow NULL? 
70TMTKSATank Spirit ApprovedCharacterGeneric Edit10 Allow NULL? 
71TMTKPRTank PressurizedCharacterGeneric Edit10 Allow NULL? 
72TMTKLPTank Pressure LevelNumericGeneric Edit40 Allow NULL? 
73TMTKPSPlank Tank FlagCharacterGeneric Edit10 Allow NULL? 
74TMCPNUMCooper NumberNumericGeneric Edit80 Allow NULL? 
75TMSUPLBlend SupplierNumericGeneric Edit80 Allow NULL? 
76TMCTROWOriginCountryStringUDC (00 CN)30 Allow NULL? 
77TMFORESForestStringUDC (31B FO)80 Allow NULL? 
78TMTKPQQuantity - Tank PlankNumericGeneric Edit60 Allow NULL? 
79TMTPBNPiping Bank NumberStringGeneric Edit100 Allow NULL? 
80TMANUMWAsset Number WineNumericGeneric Edit80 Allow NULL? 
81TMTKGTGauge TypeCharacterUDC (31B TG)10 Allow NULL? 
82TMWCGCost GroupStringGeneric Edit120 Allow NULL? 
83TMWOTCOne-Time CostCharacterGeneric Edit10 Allow NULL? 
84TMVVIVirtual Vessel IndicatorCharacterGeneric Edit10 Allow NULL? 
85TMWRFBlend Mgmt ReferenceStringGeneric Edit300 Allow NULL? 
86TMWCDBlend Mgmt CodeStringGeneric Edit30 Allow NULL? 
87TMWABBlend Mgmt NumberNumericGeneric Edit80 Allow NULL? 
88TMWNUMBlend Mgmt NumericNumericGeneric Edit154 Allow NULL? 
89TMWMDTBlend Mgmt DateDateGeneric Edit60
90TMURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
91TMURDTUser Reserved DateDateGeneric Edit60
92TMURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
93TMURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
94TMURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
95TMUSERUser IDStringGeneric Edit100 Allow NULL? 
96TMPIDProgram IDStringGeneric Edit100 Allow NULL? 
97TMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
98TMMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
99TMUPMJDate - UpdatedDateGeneric Edit60
100TMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
101TMWTKC01Tank Master Category Code 1StringUDC (31B K1)100 Allow NULL? 
102TMWTKC02Tank Master Category Code 2StringUDC (31B K2)100 Allow NULL? 
103TMWTKC03Tank Master Category Code 3StringUDC (31B K3)100 Allow NULL? 
104TMWTKC04Tank Master Category Code 4StringUDC (31B K4)100 Allow NULL? 
105TMWTKC05Tank Master Category Code 5StringUDC (31B K5)100 Allow NULL? 

TOP920 | 31B | F31B08 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1WTKIDTank IDAscending
2MCUBusiness UnitAscending
2NameMCU
ElementAliasDescriptionSequence
1TKNMTank NameAscending
2MCUBusiness UnitAscending
3NumberMCU
ElementAliasDescriptionSequence
1TKNUTank NumberAscending
2MCUBusiness UnitAscending
4DipChrtCdMCU
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2DCCODip Chart CodeAscending