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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail 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
40G: Grower Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40G0200BU1881Grower Block Update ProfileFiles40G: Grower 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 BUBLUPID, BUBLUPDESC, BUUFRMCODE, BUFARMCODE, BUUBLNAM, BUBLNAM, BUUBLTYPE, BUBLTYPE, BUUGRCMPCD, BUGRCMPCD, BUUAN8GR, BUAN8GR, BUUAN8BR, BUAN8BR, BUUAN8CR, BUAN8CR, BUUAN8V, BUAN8V, BUUAN8BL, BUAN8BL, BUUGOAREA, BUGOAREA, BUUAPPLLAT, BUAPPLLAT, BUUGREGION, BUGREGION, BUUGDISTR, BUGDISTR, BUUVARCODE, BUVARCODE, BUUCURQLTY, BUCURQLTY, BUUTARQLTY, BUTARQLTY, BUUMATYP, BUMATYP, BUUWATERTY, BUWATERTY, BUUIVOL, BUIVOL, BUUPRUNEMT, BUPRUNEMT, BUUSOILTYP, BUSOILTYP, BUUCLONE, BUCLONE, BUUROOTSTK, BUROOTSTK, BUUROWSPC, BUROWSPC, BUUPLTSPC, BUPLTSPC, BUUPDNOP, BUNOP, BUUPLTAREA, BUPLTAREA, BUUGRSAREA, BUGRSAREA, BUUDIMA, BUDIMA, BUUDIMB, BUDIMB, BUUDIMUOM, BUDIMUOM, BUUELEV, BUELEVATIO, BUUEXTRRTE, BUEXTRRTE, BUUUPLTDAT, BUUPLTDAT, BUUGROW01, BUGROW01, BUUGROW02, BUGROW02, BUUGROW03, BUGROW03, BUUGROW04, BUGROW04, BUUGROW05, BUGROW05, BUUGROW06, BUGROW06, BUUGROW07, BUGROW07, BUUGROW08, BUGROW08, BUUGROW09, BUGROW09, BUUGROW10, BUGROW10, BUUGROW11, BUGROW11, BUUGROW12, BUGROW12, BUUGROW13, BUGROW13, BUUGROW14, BUGROW14, BUUGROW15, BUGROW15, BUUCGROW01, BUCGROW01, BUUCGROW02, BUCGROW02, BUUCGROW03, BUCGROW03, BUUCGROW04, BUCGROW04, BUUCGROW05, BUCGROW05, BUUUGDAT01, BUUGDATE01, BUUUGDAT02, BUUGDATE02, BUUUGDAT03, BUUGDATE03, BUUUGDAT04, BUUGDATE04, BUUUGDAT05, BUUGDATE05, BUUUGDAT06, BUUGDATE06, BUUUGDAT07, BUUGDATE07, BUUUGDAT08, BUUGDATE08, BUUGNUM01, BUGNUM01, BUUGNUM02, BUGNUM02, BUUGNUM03, BUGNUM03, BUUGNUM04, BUGNUM04, BUUGNUM05, BUGNUM05, BUUSITEC, BUSITEC, BUUSITEP, BUSITEP, BUUGPRC, BUGPRC, BUUUOM4, BUUOM4, BUUPLNEST, BUPLNEST, BUUCONTUOM, BUCONTUOM, BUUQTYLOAD, BUQTYLOAD, BUUBLNAM2, BUBLNAM2, BUUPARCEL1, BUPARCEL1, BUUPARCEL2, BUPARCEL2, BUUPARCEL3, BUPARCEL3, BUUPAREA1, BUPAREA1, BUUPAREA2, BUPAREA2, BUUPAREA3, BUPAREA3, BUUGOVID1, BUGOVID1, BUUGOVID2, BUGOVID2, BUUGOVID3, BUGOVID3, BUUGOVID4, BUGOVID4, BUUOPERID, BUOPERID, BUUSITEID, BUSITEID, BUUPTMATNM, BUMATCALID, BUURCD, BUURDT, BUURRF, BUURAB, BUURAT, BUTORG, BUUSER, BUPID, BUJOBN, BUUUPMJ FROM F40G0200

TOP920 | 40G | F40G0200 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1BUBLUPIDGrower Block Update Profile IDNumericGeneric Edit80 Allow NULL? 
2BUBLUPDESCGrower Block Update Profile DescriptionStringGeneric Edit400 Allow NULL? 
3BUUFRMCODEUpdate Farm CodeCharacterGeneric Edit10 Allow NULL? 
4BUFARMCODEFarm CodeStringGeneric Edit80 Allow NULL? 
5BUUBLNAMUpdate Block NameCharacterGeneric Edit10 Allow NULL? 
6BUBLNAMBlock NameStringGeneric Edit400 Allow NULL? 
7BUUBLTYPEUpdate Block TypeCharacterGeneric Edit10 Allow NULL? 
8BUBLTYPEBlock TypeCharacterUDC (40G BT)10 Allow NULL? 
9BUUGRCMPCDUpdate Grower Composition CodeCharacterGeneric Edit10 Allow NULL? 
10BUGRCMPCDGrower Composition CodeStringUDC (40G GC)100 Allow NULL? 
11BUUAN8GRUpdate Grower RepresentativeCharacterGeneric Edit10 Allow NULL? 
12BUAN8GRGrower RepresentativeNumericGeneric Edit80 Allow NULL? 
13BUUAN8BRUpdate Blend RepresentativeCharacterGeneric Edit10 Allow NULL? 
14BUAN8BRBlend RepresentativeNumericGeneric Edit80 Allow NULL? 
15BUUAN8CRUpdate Contract RepresentativeCharacterGeneric Edit10 Allow NULL? 
16BUAN8CRContract RepresentativeNumericGeneric Edit80 Allow NULL? 
17BUUAN8VUpdate Supplier NumberCharacterGeneric Edit10 Allow NULL? 
18BUAN8VAddress Number - SupplierNumericGeneric Edit80 Allow NULL? 
19BUUAN8BLUpdate Block Address NumberCharacterGeneric Edit10 Allow NULL? 
20BUAN8BLBlock Address Book NumberNumericGeneric Edit80 Allow NULL? 
21BUUGOAREAUpdate Growing AreaCharacterGeneric Edit10 Allow NULL? 
22BUGOAREACode - Geographic AreaStringGeneric Edit40 Allow NULL? 
23BUUAPPLLATUpdate AppellationCharacterGeneric Edit10 Allow NULL? 
24BUAPPLLATCode - AppellationStringGeneric Edit80 Allow NULL? 
25BUUGREGIONUpdate RegionCharacterGeneric Edit10 Allow NULL? 
26BUGREGIONGrowing RegionStringUDC (40G GR)100 Allow NULL? 
27BUUGDISTRUpdate DistrictCharacterGeneric Edit10 Allow NULL? 
28BUGDISTRGrowing DistrictStringUDC (40G GD)100 Allow NULL? 
29BUUVARCODEUpdate Variety CodeCharacterGeneric Edit10 Allow NULL? 
30BUVARCODECode - VarietyStringGeneric Edit50 Allow NULL? 
31BUUCURQLTYUpdate Current QualityCharacterGeneric Edit10 Allow NULL? 
32BUCURQLTYCurrent QualityCharacterUDC (40G QL)10 Allow NULL? 
33BUUTARQLTYUpdate Target QualityCharacterGeneric Edit10 Allow NULL? 
34BUTARQLTYTarget QualityCharacterUDC (40G QL)10 Allow NULL? 
35BUUMATYPUpdate Material TypeCharacterGeneric Edit10 Allow NULL? 
36BUMATYPMaterial Type CodeStringGeneric Edit40 Allow NULL? 
37BUUWATERTYUpdate Irrigation TypeCharacterGeneric Edit10 Allow NULL? 
38BUWATERTYIrrigation TypeStringUDC (40G IT)20 Allow NULL? 
39BUUIVOLUpdate Irrigation VolumeCharacterGeneric Edit10 Allow NULL? 
40BUIVOLIrrigation VolumeNumericGeneric Edit152 Allow NULL? 
41BUUPRUNEMTUpdate Pruning MethodCharacterGeneric Edit10 Allow NULL? 
42BUPRUNEMTPruning MethodStringUDC (40G PM)20 Allow NULL? 
43BUUSOILTYPUpdate Soil TypeCharacterGeneric Edit10 Allow NULL? 
44BUSOILTYPSoil TypeStringUDC (40G ST)20 Allow NULL? 
45BUUCLONEUpdate CloneCharacterGeneric Edit10 Allow NULL? 
46BUCLONECloneStringUDC (40G CL)20 Allow NULL? 
47BUUROOTSTKUpdate Root StockCharacterGeneric Edit10 Allow NULL? 
48BUROOTSTKRoot StockStringUDC (40G RS)20 Allow NULL? 
49BUUROWSPCUpdate Row SpacingCharacterGeneric Edit10 Allow NULL? 
50BUROWSPCRow SpacingStringUDC (40G RW)20 Allow NULL? 
51BUUPLTSPCUpdate Plant SpacingCharacterGeneric Edit10 Allow NULL? 
52BUPLTSPCPlant SpacingStringUDC (40G PL)20 Allow NULL? 
53BUUPDNOPUpdate Number Of PlantsCharacterGeneric Edit10 Allow NULL? 
54BUNOPNumber of PlantsNumericGeneric Edit80 Allow NULL? 
55BUUPLTAREAUpdate Planted AreaCharacterGeneric Edit10 Allow NULL? 
56BUPLTAREAPlanted AreaNumericGeneric Edit154 Allow NULL? 
57BUUGRSAREAUpdate Gross AreaCharacterGeneric Edit10 Allow NULL? 
58BUGRSAREAGross AreaNumericGeneric Edit154 Allow NULL? 
59BUUDIMAUpdate Dimension ACharacterGeneric Edit10 Allow NULL? 
60BUDIMADimension ANumericGeneric Edit100 Allow NULL? 
61BUUDIMBUpdate Dimension BCharacterGeneric Edit10 Allow NULL? 
62BUDIMBDimension BNumericGeneric Edit100 Allow NULL? 
63BUUDIMUOMUpdate Dimension UOMCharacterGeneric Edit10 Allow NULL? 
64BUDIMUOMDimension Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
65BUUELEVUpdate ElevationCharacterGeneric Edit10 Allow NULL? 
66BUELEVATIOElevationNumericGeneric Edit50 Allow NULL? 
67BUUEXTRRTEUpdate Extraction RateCharacterGeneric Edit10 Allow NULL? 
68BUEXTRRTEExtraction RateNumericGeneric Edit100 Allow NULL? 
69BUUUPLTDATUpdate Planted DateCharacterGeneric Edit10 Allow NULL? 
70BUUPLTDATPlanted DateJDE UTimeGeneric Edit110
71BUUGROW01Update Grower Attribute 01CharacterGeneric Edit10 Allow NULL? 
72BUGROW01Grower Attribute 01StringUDC (40G 01)30 Allow NULL? 
73BUUGROW02Update Grower Attribute 02CharacterGeneric Edit10 Allow NULL? 
74BUGROW02Grower Attribute 02StringUDC (40G 02)30 Allow NULL? 
75BUUGROW03Update Grower Attribute 03CharacterGeneric Edit10 Allow NULL? 
76BUGROW03Grower Attribute 03StringUDC (40G 03)30 Allow NULL? 
77BUUGROW04Update Grower Attribute 04CharacterGeneric Edit10 Allow NULL? 
78BUGROW04Grower Attribute 04StringUDC (40G 04)30 Allow NULL? 
79BUUGROW05Update Grower Attribute 05CharacterGeneric Edit10 Allow NULL? 
80BUGROW05Grower Attribute 05StringUDC (40G 05)30 Allow NULL? 
81BUUGROW06Update Grower Attribute 06CharacterGeneric Edit10 Allow NULL? 
82BUGROW06Grower Attribute 06StringUDC (40G 06)80 Allow NULL? 
83BUUGROW07Update Grower Attribute 07CharacterGeneric Edit10 Allow NULL? 
84BUGROW07Grower Attribute 07StringUDC (40G 07)80 Allow NULL? 
85BUUGROW08Update Grower Attribute 08CharacterGeneric Edit10 Allow NULL? 
86BUGROW08Grower Attribute 08StringUDC (40G 08)80 Allow NULL? 
87BUUGROW09Update Grower Attribute 09CharacterGeneric Edit10 Allow NULL? 
88BUGROW09Grower Attribute 09StringUDC (40G 09)80 Allow NULL? 
89BUUGROW10Update Grower Attribute 10CharacterGeneric Edit10 Allow NULL? 
90BUGROW10Grower Attribute 10StringUDC (40G 10)80 Allow NULL? 
91BUUGROW11Update Grower Attribute 11CharacterGeneric Edit10 Allow NULL? 
92BUGROW11Grower Attribute 11StringUDC (40G 11)100 Allow NULL? 
93BUUGROW12Update Grower Attribute 12CharacterGeneric Edit10 Allow NULL? 
94BUGROW12Grower Attribute 12StringUDC (40G 12)100 Allow NULL? 
95BUUGROW13Update Grower Attribute 13CharacterGeneric Edit10 Allow NULL? 
96BUGROW13Grower Attribute 13StringUDC (40G 13)100 Allow NULL? 
97BUUGROW14Update Grower Attribute 14CharacterGeneric Edit10 Allow NULL? 
98BUGROW14Grower Attribute 14StringUDC (40G 14)100 Allow NULL? 
99BUUGROW15Update Grower Attribute 15CharacterGeneric Edit10 Allow NULL? 
100BUGROW15Grower Attribute 15StringUDC (40G 15)100 Allow NULL? 
101BUUCGROW01Update Grower Checkbox 01CharacterGeneric Edit10 Allow NULL? 
102BUCGROW01Grower Checkbox 01CharacterGeneric Edit10 Allow NULL? 
103BUUCGROW02Update Grower Checkbox 02CharacterGeneric Edit10 Allow NULL? 
104BUCGROW02Grower Checkbox 02CharacterGeneric Edit10 Allow NULL? 
105BUUCGROW03Update Grower Checkbox 03CharacterGeneric Edit10 Allow NULL? 
106BUCGROW03Grower Checkbox 03CharacterGeneric Edit10 Allow NULL? 
107BUUCGROW04Update Grower Checkbox 04CharacterGeneric Edit10 Allow NULL? 
108BUCGROW04Grower Checkbox 04CharacterGeneric Edit10 Allow NULL? 
109BUUCGROW05Update Grower Checkbox 05CharacterGeneric Edit10 Allow NULL? 
110BUCGROW05Grower Checkbox 05CharacterGeneric Edit10 Allow NULL? 
111BUUUGDAT01Update Grower Date 01CharacterGeneric Edit10 Allow NULL? 
112BUUGDATE01Date - Grower 01JDE UTimeGeneric Edit110
113BUUUGDAT02Update Grower Date 02CharacterGeneric Edit10 Allow NULL? 
114BUUGDATE02Date - Grower 02JDE UTimeGeneric Edit110
115BUUUGDAT03Update Grower Date 03CharacterGeneric Edit10 Allow NULL? 
116BUUGDATE03Date - Grower 03JDE UTimeGeneric Edit110
117BUUUGDAT04Update Grower Date 04CharacterGeneric Edit10 Allow NULL? 
118BUUGDATE04Date - Grower 04JDE UTimeGeneric Edit110
119BUUUGDAT05Update Grower Date 05CharacterGeneric Edit10 Allow NULL? 
120BUUGDATE05Date - Grower 05JDE UTimeGeneric Edit110
121BUUUGDAT06Update Grower Date 06CharacterGeneric Edit10 Allow NULL? 
122BUUGDATE06Date - Grower 06JDE UTimeGeneric Edit110
123BUUUGDAT07Update Grower Date 07CharacterGeneric Edit10 Allow NULL? 
124BUUGDATE07Date - Grower 07JDE UTimeGeneric Edit110
125BUUUGDAT08Update Grower Date 08CharacterGeneric Edit10 Allow NULL? 
126BUUGDATE08Date - Grower 08JDE UTimeGeneric Edit110
127BUUGNUM01Update Grower Numeric 01CharacterGeneric Edit10 Allow NULL? 
128BUGNUM01Grower Numeric 01NumericGeneric Edit157 Allow NULL? 
129BUUGNUM02Update Grower Numeric 02CharacterGeneric Edit10 Allow NULL? 
130BUGNUM02Grower Numeric 02NumericGeneric Edit157 Allow NULL? 
131BUUGNUM03Update Grower Numeric 03CharacterGeneric Edit10 Allow NULL? 
132BUGNUM03Grower Numeric 03NumericGeneric Edit157 Allow NULL? 
133BUUGNUM04Update Grower Numeric 04CharacterGeneric Edit10 Allow NULL? 
134BUGNUM04Grower Numeric 04NumericGeneric Edit157 Allow NULL? 
135BUUGNUM05Update Grower Numeric 05CharacterGeneric Edit10 Allow NULL? 
136BUGNUM05Grower Numeric 05NumericGeneric Edit157 Allow NULL? 
137BUUSITECUpdate Crush SiteCharacterGeneric Edit10 Allow NULL? 
138BUSITECCrush SiteStringGeneric Edit120 Allow NULL? 
139BUUSITEPUpdate Produced SiteCharacterGeneric Edit10 Allow NULL? 
140BUSITEPProduced SiteStringGeneric Edit120 Allow NULL? 
141BUUGPRCUpdate Default PriceCharacterGeneric Edit10 Allow NULL? 
142BUGPRCGrower Default PriceNumericGeneric Edit154 Allow NULL? 
143BUUUOM4Update Pricing UOMCharacterGeneric Edit10 Allow NULL? 
144BUUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
145BUUPLNESTUpdate Planned EstimateCharacterGeneric Edit10 Allow NULL? 
146BUPLNESTPlanned EstimateNumericGeneric Edit154 Allow NULL? 
147BUUCONTUOMUpdate Container TypeCharacterGeneric Edit10 Allow NULL? 
148BUCONTUOMContainer Type UomStringUDC (00 UM)20 Allow NULL? 
149BUUQTYLOADUpdate Quantity Per LoadCharacterGeneric Edit10 Allow NULL? 
150BUQTYLOADQuantity Per LoadNumericGeneric Edit154 Allow NULL? 
151BUUBLNAM2Update Alternate Block NameCharacterGeneric Edit10 Allow NULL? 
152BUBLNAM2Alternate Block NameStringGeneric Edit400 Allow NULL? 
153BUUPARCEL1Update Parcel Number 1CharacterGeneric Edit10 Allow NULL? 
154BUPARCEL1Parcel Number 1StringGeneric Edit250 Allow NULL? 
155BUUPARCEL2Update Parcel Number 2CharacterGeneric Edit10 Allow NULL? 
156BUPARCEL2Parcel Number 2StringGeneric Edit250 Allow NULL? 
157BUUPARCEL3Update Parcel Number 3CharacterGeneric Edit10 Allow NULL? 
158BUPARCEL3Parcel Number 3StringGeneric Edit250 Allow NULL? 
159BUUPAREA1Update Parcel Number 1 AreaCharacterGeneric Edit10 Allow NULL? 
160BUPAREA1Parcel Number 1 AreaNumericGeneric Edit154 Allow NULL? 
161BUUPAREA2Update Parcel Number 2 AreaCharacterGeneric Edit10 Allow NULL? 
162BUPAREA2Parcel Number 2 AreaNumericGeneric Edit154 Allow NULL? 
163BUUPAREA3Update Parcel Number 3 AreaCharacterGeneric Edit10 Allow NULL? 
164BUPAREA3Parcel Number 3 AreaNumericGeneric Edit154 Allow NULL? 
165BUUGOVID1Update Governmental ID 1CharacterGeneric Edit10 Allow NULL? 
166BUGOVID1Governmental Property ID 1StringGeneric Edit250 Allow NULL? 
167BUUGOVID2Update Governmental ID 2CharacterGeneric Edit10 Allow NULL? 
168BUGOVID2Governmental Property ID 2StringGeneric Edit250 Allow NULL? 
169BUUGOVID3Update Governmental ID 3CharacterGeneric Edit10 Allow NULL? 
170BUGOVID3Governmental Property ID 3StringGeneric Edit250 Allow NULL? 
171BUUGOVID4Update Governmental ID 4CharacterGeneric Edit10 Allow NULL? 
172BUGOVID4Governmental Property ID 4StringGeneric Edit250 Allow NULL? 
173BUUOPERIDUpdate Operator IDCharacterGeneric Edit10 Allow NULL? 
174BUOPERIDOperator IDStringGeneric Edit110 Allow NULL? 
175BUUSITEIDUpdate Site ID NumberCharacterGeneric Edit10 Allow NULL? 
176BUSITEIDSite ID NumberStringGeneric Edit80 Allow NULL? 
177BUUPTMATNMUpdate Maturity Calculation Name FlagCharacterGeneric Edit10 Allow NULL? 
178BUMATCALIDMaturity Calculation IDIntegerGeneric Edit110 Allow NULL? 
179BUURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
180BUURDTUser Reserved DateDateGeneric Edit60
181BUURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
182BUURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
183BUURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
184BUTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
185BUUSERUser IDStringGeneric Edit100 Allow NULL? 
186BUPIDProgram IDStringGeneric Edit100 Allow NULL? 
187BUJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
188BUUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110

TOP920 | 40G | F40G0200 INDEXES

NumberDescription
1UpdateProfileID (Primary/Unique)
ElementAliasDescriptionSequence
1BLUPIDGrower Block Update Profile IDAscending