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

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