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

112 COLUMNS | 1 INDEXES | Print definition?920 | 31B | F31B110 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B110MB1121Mass Barrel UpdateFiles31B: 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 MBWUMBID, MBWUMBDES, MBWUMBBATP, MBBATP, MBWUMBBATV, MBBATV, MBWUMBMCU, MBMCU, MBWUMBBID, MBBARID, MBWUMBCONO, MBBARCN, MBWUMBAGE, MBRKNUM, MBWUMBLOCN, MBLOCN, MBWUMBOC, MBCTRO, MBWUMBCS, MBBCST, MBWUMBOYR, MBOYRC, MBWUMBCON, MBBARCO, MBWUMBPOWN, MBPOWN, MBWUMBPFOR, MBFORES, MBWUMBTSLV, MBTLEV, MBWUMBCC1, MBSCTM, MBWUMBCC2, MBSDRM, MBWUMBCC3, MBSBDM, MBWUMBCC4, MBSDRL, MBWUMBCC5, MBINFO, MBWUMBAVL, MBBAVC, MBWUMBADR, MBAJRS, MBWUMBOOS, MBDAOS, MBWUMBVS, MBBVST, MBWUMBRN, MBRKNMR, MBWUMBSHV, MBSHAV, MBWUMBDSHV, MBSHAVD, MBWUMBTRWK, MBTSTR, MBWUMBDFU, MBDAFU, MBWUMBNU, MBNXUSE, MBWUMBNFLL, MBNUMFL, MBWUMBTMET, MBMTDLT, MBWUMBDT, MBDALT, MBWUMBDS, MBDALS, MBWUMBCOM, MBGECM, MBWUMBCSTG, MBWCG, MBWUMBOWN, MBBOWN, MBWUMBLF, MBLEAS, MBWUMBLT, MBLESTM, MBWUMBLD, MBLESDT, MBWUMBLDOC, MBLESDN, MBWUMBLCOM, MBLESCO, MBWUMBLCNM, MBLESCN, MBWUMBIFL, MBINSF, MBFCAP, MBTOCAP, MBBCUOM, MBWUMBUCD, MBWCD, MBWUMBUDT, MBWMDT, MBWUMBUNB, MBWAB, MBWUMBUNM, MBWNUM, MBWUMBURF, MBWRF, MBURCD, MBURDT, MBURAT, MBURRF, MBURAB, MBUSER, MBPID, MBJOBN, MBUPMJ, MBUPMT, MBWCTRO FROM F31B110

TOP920 | 31B | F31B110 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1MBWUMBIDUpdate Mass Barrel IDNumericGeneric Edit150 Allow NULL? 
2MBWUMBDESUpdate Mass Barrel DescriptionStringGeneric Edit400 Allow NULL? 
3MBWUMBBATPUpdate Barrel TypeCharacterGeneric Edit10 Allow NULL? 
4MBBATPBarrel TypeStringUDC (31B BT)40 Allow NULL? 
5MBWUMBBATVUpdate Barrel Type VariationCharacterGeneric Edit10 Allow NULL? 
6MBBATVBarrel Type VariationStringUDC (31B BV)20 Allow NULL? 
7MBWUMBMCUUpdate Barrel WineryCharacterGeneric Edit10 Allow NULL? 
8MBMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
9MBWUMBBIDUpdate Barrel IDCharacterGeneric Edit10 Allow NULL? 
10MBBARIDBarrel IDStringGeneric Edit300 Allow NULL? 
11MBWUMBCONOUpdate Barrel Collection NumberCharacterGeneric Edit10 Allow NULL? 
12MBBARCNBarrel Collection NumberNumericGeneric Edit60 Allow NULL? 
13MBWUMBAGEUpdate Barrel AgeCharacterGeneric Edit10 Allow NULL? 
14MBRKNUMBarrel AgeNumericGeneric Edit80 Allow NULL? 
15MBWUMBLOCNUpdate Barrel LocationCharacterGeneric Edit10 Allow NULL? 
16MBLOCNLocationStringGeneric Edit200 Allow NULL? 
17MBWUMBOCUpdate Barrel Origin CountryCharacterGeneric Edit10 Allow NULL? 
18MBCTROOriginCountryStringUDC (00 CN)30 Allow NULL? 
19MBWUMBCSUpdate Barrel Color StatusCharacterGeneric Edit10 Allow NULL? 
20MBBCSTBarrel Color StatusStringUDC (31B CB)100 Allow NULL? 
21MBWUMBOYRUpdate Barrel Other YearCharacterGeneric Edit10 Allow NULL? 
22MBOYRCOther Year CodeNumericGeneric Edit40 Allow NULL? 
23MBWUMBCONUpdate Barrel ConditionCharacterGeneric Edit10 Allow NULL? 
24MBBARCOBarrel ConditionCharacterUDC (31B BC)10 Allow NULL? 
25MBWUMBPOWNUpdate Barrel Previous OwnerCharacterGeneric Edit10 Allow NULL? 
26MBPOWNPrevious OwnerNumericGeneric Edit80 Allow NULL? 
27MBWUMBPFORUpdate Barrel ForestCharacterGeneric Edit10 Allow NULL? 
28MBFORESForestStringUDC (31B FO)80 Allow NULL? 
29MBWUMBTSLVUpdate Barrel Toast LevelCharacterGeneric Edit10 Allow NULL? 
30MBTLEVToast LevelStringUDC (31B TL)30 Allow NULL? 
31MBWUMBCC1Update Barrel Category Code 1CharacterGeneric Edit10 Allow NULL? 
32MBSCTMBarrel Category Code 1StringUDC (31B R1)100 Allow NULL? 
33MBWUMBCC2Update Barrel Category Code 2CharacterGeneric Edit10 Allow NULL? 
34MBSDRMBarrel Category Code 2StringUDC (31B R2)100 Allow NULL? 
35MBWUMBCC3Update Barrel Category Code 3CharacterGeneric Edit10 Allow NULL? 
36MBSBDMBarrel Category Code 3StringUDC (31B R3)100 Allow NULL? 
37MBWUMBCC4Update Barrel Category Code 4CharacterGeneric Edit10 Allow NULL? 
38MBSDRLBarrel Category Code 4StringUDC (31B R4)200 Allow NULL? 
39MBWUMBCC5Update Barrel Category Code 5CharacterGeneric Edit10 Allow NULL? 
40MBINFOBarrel Category Code 5StringUDC (31B R5)100 Allow NULL? 
41MBWUMBAVLUpdate Barrel Availability CodeCharacterGeneric Edit10 Allow NULL? 
42MBBAVCBarrel Availability CodeStringUDC (31B AC)40 Allow NULL? 
43MBWUMBADRUpdate Barrel Adjustment ReasonCharacterGeneric Edit10 Allow NULL? 
44MBAJRSAdjustment Reason CodeStringUDC (31B RC)200 Allow NULL? 
45MBWUMBOOSUpdate Barrel Date Out Of ServiceCharacterGeneric Edit10 Allow NULL? 
46MBDAOSDate Out of ServiceDateGeneric Edit60
47MBWUMBVSUpdate Barrel Volume StatusCharacterGeneric Edit10 Allow NULL? 
48MBBVSTBarrel Volume StatusStringUDC (31B VS)30 Allow NULL? 
49MBWUMBRNUpdate Barrel Rack NumberCharacterGeneric Edit10 Allow NULL? 
50MBRKNMRRack NumberStringGeneric Edit200 Allow NULL? 
51MBWUMBSHVUpdate Barrel ShavedCharacterGeneric Edit10 Allow NULL? 
52MBSHAVBarrel ShavedCharacterUDC (31B SH)10 Allow NULL? 
53MBWUMBDSHVUpdate Barrel Shave DateCharacterGeneric Edit10 Allow NULL? 
54MBSHAVDShave DateDateGeneric Edit80
55MBWUMBTRWKUpdate Barrel Toast ReworkCharacterGeneric Edit10 Allow NULL? 
56MBTSTRToast ReworkCharacterGeneric Edit10 Allow NULL? 
57MBWUMBDFUUpdate Barrel Date Of First UseCharacterGeneric Edit10 Allow NULL? 
58MBDAFUDate First UseDateGeneric Edit80
59MBWUMBNUUpdate Barrel Next UseCharacterGeneric Edit10 Allow NULL? 
60MBNXUSENext UseStringUDC (31B NU)40 Allow NULL? 
61MBWUMBNFLLUpdate Barrel Number Of FillsCharacterGeneric Edit10 Allow NULL? 
62MBNUMFLNumber of FillsNumericGeneric Edit40 Allow NULL? 
63MBWUMBTMETUpdate Barrel Last Treatment MethodCharacterGeneric Edit10 Allow NULL? 
64MBMTDLTMethod Last TreatmentStringUDC (31B LT)80 Allow NULL? 
65MBWUMBDTUpdate Barrel Date of Last TreatmentCharacterGeneric Edit10 Allow NULL? 
66MBDALTDate Last TreatmentDateGeneric Edit80
67MBWUMBDSUpdate Barrel Date of Last SulfurCharacterGeneric Edit10 Allow NULL? 
68MBDALSDate Last SulfurDateGeneric Edit80
69MBWUMBCOMUpdate Barrel CommentsCharacterGeneric Edit10 Allow NULL? 
70MBGECMGeneral CommentsStringGeneric Edit400 Allow NULL? 
71MBWUMBCSTGUpdate Barrel Cost GroupCharacterGeneric Edit10 Allow NULL? 
72MBWCGCost GroupStringGeneric Edit120 Allow NULL? 
73MBWUMBOWNUpdate Barrel OwnerCharacterGeneric Edit10 Allow NULL? 
74MBBOWNBarrel OwnerNumericGeneric Edit80 Allow NULL? 
75MBWUMBLFUpdate Barrel Leased FlagCharacterGeneric Edit10 Allow NULL? 
76MBLEASLeased YNCharacterUDC (31B LS)10 Allow NULL? 
77MBWUMBLTUpdate Barrel Lease TermCharacterGeneric Edit10 Allow NULL? 
78MBLESTMLease TermNumericGeneric Edit30 Allow NULL? 
79MBWUMBLDUpdate Barrel Lease DateCharacterGeneric Edit10 Allow NULL? 
80MBLESDTLease DateDateGeneric Edit80
81MBWUMBLDOCUpdate Barrel Lease Document NumberCharacterGeneric Edit10 Allow NULL? 
82MBLESDNLease Document NumberNumericGeneric Edit80 Allow NULL? 
83MBWUMBLCOMUpdate Barrel Lease CompanyCharacterGeneric Edit10 Allow NULL? 
84MBLESCOLeasing CompanyNumericGeneric Edit80 Allow NULL? 
85MBWUMBLCNMUpdate Barrel Lease Company NameCharacterGeneric Edit10 Allow NULL? 
86MBLESCNLeasing Company NameStringGeneric Edit300 Allow NULL? 
87MBWUMBIFLUpdate Barrel Insert FlagCharacterGeneric Edit10 Allow NULL? 
88MBINSFInsert FlagCharacterGeneric Edit10 Allow NULL? 
89MBFCAPFermentation CapacityNumericGeneric Edit154 Allow NULL? 
90MBTOCAPBarrel Total CapacityNumericGeneric Edit154 Allow NULL? 
91MBBCUOMBarrel Capacity UOMStringUDC (31B UM)20 Allow NULL? 
92MBWUMBUCDUpdate Blend Mgmt CodeCharacterGeneric Edit10 Allow NULL? 
93MBWCDBlend Mgmt CodeStringGeneric Edit30 Allow NULL? 
94MBWUMBUDTUpdate Blend Mgmt DateCharacterGeneric Edit10 Allow NULL? 
95MBWMDTBlend Mgmt DateDateGeneric Edit60
96MBWUMBUNBUpdate Blend Mgmt NumberCharacterGeneric Edit10 Allow NULL? 
97MBWABBlend Mgmt NumberNumericGeneric Edit80 Allow NULL? 
98MBWUMBUNMUpdate Blend Mgmt NumericCharacterGeneric Edit10 Allow NULL? 
99MBWNUMBlend Mgmt NumericNumericGeneric Edit154 Allow NULL? 
100MBWUMBURFUpdate Blend Mgmt ReferenceCharacterGeneric Edit10 Allow NULL? 
101MBWRFBlend Mgmt ReferenceStringGeneric Edit300 Allow NULL? 
102MBURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
103MBURDTUser Reserved DateDateGeneric Edit60
104MBURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
105MBURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
106MBURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
107MBUSERUser IDStringGeneric Edit100 Allow NULL? 
108MBPIDProgram IDStringGeneric Edit100 Allow NULL? 
109MBJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
110MBUPMJDate - UpdatedDateGeneric Edit60
111MBUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
112MBWCTROCountryStringUDC (31B CN)30 Allow NULL? 

TOP920 | 31B | F31B110 INDEXES

NumberDescription
1UpdateID (Primary/Unique)
ElementAliasDescriptionSequence
1WUMBIDUpdate Mass Barrel IDAscending