JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

78 COLUMNS | 1 INDEXES | Print definition?920 | 31B | F31B751 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B751OA781Operation Configuration for Vessel AttributesFiles31B: 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 OAWCFGID, OAWCOPCD, OAWBOPID, OAWBOPCD, OAWFTLOC, OAWFTKFM, OAWFTKFF, OAWFTKVC, OAWTVCTY, OAWFTKCW, OAWTWCTY, OAWFTKCR, OAWTRCTY, OAWFUMTV, OAWFUMTW, OAWFTSTA, OAWFTKTC, OAWFTKFC, OAWFTKPL, OAWFTKHS, OAWFTKVS, OAWFBAVC, OAWFBCST, OAWTTLOC, OAWTTKFM, OAWTTKFF, OAWTTKVC, OAWTTVCT, OAWTTKCW, OAWTTWCT, OAWTTKCR, OAWTTRCT, OAWTUMTV, OAWTUMTW, OAWTTSTA, OAWTTKTC, OAWTTKFC, OAWTTKPL, OAWTTKHS, OAWTTKVS, OAWTBAVC, OAWTBCST, OAWNTKST, OAWNTKHS, OAWNTKVS, OAWNBAVC, OAWFABGC, OAWFABCS, OAWFBTOF, OAWFBFOF, OAWFAMLT, OAWFBSTF, OAWNTTAS, OAWNTTHS, OAWNTTVS, OAWTABAC, OAWTABGC, OAWTABCS, OAWTBTOF, OAWTBFOF, OAWTAMLT, OAWTBSTF, OAURCD, OAURDT, OAURAT, OAURAB, OAURRF, OAUSER, OAPID, OAJOBN, OAUPMJ, OATDAY, OAWAOTC, OAWRF, OAWCD, OAWAB, OAWNUM, OAWMDT FROM F31B751

TOP920 | 31B | F31B751 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1OAWCFGIDConfigured Operation IDIntegerGeneric Edit110 Allow NULL? 
2OAWCOPCDConfigured Operation Short CodeStringGeneric Edit100 Allow NULL? 
3OAWBOPIDBase Operation IDIntegerGeneric Edit110 Allow NULL? 
4OAWBOPCDBase Operation Short CodeStringGeneric Edit100 Allow NULL? 
5OAWFTLOCFrom Tank LocationStringGeneric Edit200 Allow NULL? 
6OAWFTKFMFrom Tank Fabrication MaterialStringUDC (31B FM)300 Allow NULL? 
7OAWFTKFFFrom Tank FermenterCharacterUDC (31B VV)10 Allow NULL? 
8OAWFTKVCFrom Vessel CapacityNumericGeneric Edit154 Allow NULL? 
9OAWTVCTYVessel Capacity Value TypeCharacterUDC (31B VT)10 Allow NULL? 
10OAWFTKCWFrom Tank Capacity - Ferment WhiteNumericGeneric Edit154 Allow NULL? 
11OAWTWCTYWhite Fermenter Capacity Value TypeCharacterUDC (31B VT)10 Allow NULL? 
12OAWFTKCRFrom Tank Capacity - Ferment RedNumericGeneric Edit154 Allow NULL? 
13OAWTRCTYRed Fermenter Capacity Value TypeCharacterUDC (31B VT)10 Allow NULL? 
14OAWFUMTVUOM - From Tank - VolumeStringUDC (31B UM)20 Allow NULL? 
15OAWFUMTWUOM - From Tank - WeightStringUDC (31B UM)20 Allow NULL? 
16OAWFTSTAFrom Tank StatusCharacterUDC (31B SV)10 Allow NULL? 
17OAWFTKTCFrom Tank Temperature ControlledCharacterUDC (31B VV)10 Allow NULL? 
18OAWFTKFCFrom Tank Floor ConfigurationStringUDC (31B FC)30 Allow NULL? 
19OAWFTKPLFrom Tank PlacementCharacterUDC (31B TP)10 Allow NULL? 
20OAWFTKHSFrom Tank Hygiene StatusCharacterUDC (31B HS)10 Allow NULL? 
21OAWFTKVSFrom Tank Volume StatusCharacterUDC (31B VS)10 Allow NULL? 
22OAWFBAVCFrom Barrel Availability CodeStringUDC (31B AC)40 Allow NULL? 
23OAWFBCSTFrom Barrel Color StatusStringUDC (31B CB)100 Allow NULL? 
24OAWTTLOCTo Tank LocationStringGeneric Edit200 Allow NULL? 
25OAWTTKFMTo Tank Fabrication MaterialStringUDC (31B FM)300 Allow NULL? 
26OAWTTKFFTo Tank FermenterCharacterUDC (31B VV)10 Allow NULL? 
27OAWTTKVCTo Vessel CapacityNumericGeneric Edit154 Allow NULL? 
28OAWTTVCTTo Vessel Capacity Value TypeCharacterUDC (31B VT)10 Allow NULL? 
29OAWTTKCWTo Tank Capacity - Ferment WhiteNumericGeneric Edit154 Allow NULL? 
30OAWTTWCTWhite Fermenter Capacity To Value TypeCharacterUDC (31B VT)10 Allow NULL? 
31OAWTTKCRTo Tank Capacity - Ferment RedNumericGeneric Edit154 Allow NULL? 
32OAWTTRCTTo Red Fermenter Capacity Value TypeCharacterUDC (31B VT)10 Allow NULL? 
33OAWTUMTVUOM - To Tank - VolumeStringUDC (31B UM)20 Allow NULL? 
34OAWTUMTWUOM - To Tank - WeightStringUDC (31B UM)20 Allow NULL? 
35OAWTTSTATo Tank StatusCharacterUDC (31B SV)10 Allow NULL? 
36OAWTTKTCTo Tank Temperature ControlledCharacterUDC (31B VV)10 Allow NULL? 
37OAWTTKFCTo Tank Floor ConfigurationStringUDC (31B FC)30 Allow NULL? 
38OAWTTKPLTo Tank PlacementCharacterUDC (31B TP)10 Allow NULL? 
39OAWTTKHSTo Tank Hygiene StatusCharacterUDC (31B HS)10 Allow NULL? 
40OAWTTKVSTo Tank Volume StatusCharacterUDC (31B VS)10 Allow NULL? 
41OAWTBAVCTo Barrel Availability CodeStringUDC (31B AC)40 Allow NULL? 
42OAWTBCSTTo Barrel Color StatusStringUDC (31B CB)100 Allow NULL? 
43OAWNTKSTFrom Tank New StatusCharacterUDC (31B SV)10 Allow NULL? 
44OAWNTKHSFrom Tank New Hygiene StatusCharacterUDC (31B HS)10 Allow NULL? 
45OAWNTKVSFrom Tank New Volume StatusCharacterUDC (31B VS)10 Allow NULL? 
46OAWNBAVCFrom Barrel New Availability CodeStringUDC (31B AC)40 Allow NULL? 
47OAWFABGCFrom After Barrel General CommentsStringGeneric Edit400 Allow NULL? 
48OAWFABCSF/A Barrel Color StatusStringUDC (31B CB)100 Allow NULL? 
49OAWFBTOFFrom Barrel Treatment Operation FlagCharacterGeneric Edit10 Allow NULL? 
50OAWFBFOFFrom Barrel Fill Operation FlagCharacterGeneric Edit10 Allow NULL? 
51OAWFAMLTF/A Barrel Method Last TreatmentStringUDC (31B LT)80 Allow NULL? 
52OAWFBSTFFrom Barrel Sulphur Treatment FlagCharacterGeneric Edit10 Allow NULL? 
53OAWNTTASTo Tank New StatusCharacterUDC (31B SV)10 Allow NULL? 
54OAWNTTHSTo Tank New Hygiene StatusCharacterUDC (31B HS)10 Allow NULL? 
55OAWNTTVSTo Tank New Volume StatusCharacterUDC (31B VS)10 Allow NULL? 
56OAWTABACTo After Barrel Availability CodeStringUDC (31B AC)40 Allow NULL? 
57OAWTABGCTo After Barrel General CommentsStringGeneric Edit400 Allow NULL? 
58OAWTABCST/A Barrel Color StatusStringUDC (31B CB)100 Allow NULL? 
59OAWTBTOFTo Barrel Treatment Operation FlagCharacterGeneric Edit10 Allow NULL? 
60OAWTBFOFTo Barrel Fill Operation FlagCharacterGeneric Edit10 Allow NULL? 
61OAWTAMLTT/A Barrel Method Last TreatmentStringUDC (31B LT)80 Allow NULL? 
62OAWTBSTFTo Barrel Sulphur Treatment FlagCharacterGeneric Edit10 Allow NULL? 
63OAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
64OAURDTUser Reserved DateDateGeneric Edit60
65OAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
66OAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
67OAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
68OAUSERUser IDStringGeneric Edit100 Allow NULL? 
69OAPIDProgram IDStringGeneric Edit100 Allow NULL? 
70OAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
71OAUPMJDate - UpdatedDateGeneric Edit60
72OATDAYTime of DayNumericGeneric Edit60 Allow NULL? 
73OAWAOTCApply Periodic CostCharacterGeneric Edit10 Allow NULL? 
74OAWRFBlend Mgmt ReferenceStringGeneric Edit300 Allow NULL? 
75OAWCDBlend Mgmt CodeStringGeneric Edit30 Allow NULL? 
76OAWABBlend Mgmt NumberNumericGeneric Edit80 Allow NULL? 
77OAWNUMBlend Mgmt NumericNumericGeneric Edit154 Allow NULL? 
78OAWMDTBlend Mgmt DateDateGeneric Edit60

TOP920 | 31B | F31B751 INDEXES

NumberDescription
1Operation ConfigurationID (Primary/Unique)
ElementAliasDescriptionSequence
1WCFGIDConfigured Operation IDAscending