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

151 tables920 | 31B

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B01WI452Winery MasterFiles31B: Blend Management
2920F31B02ST382Staff MasterFiles31B: Blend Management
3920F31B03BM1165Barrel Master TableFiles31B: Blend Management
4920F31B031BP581Barrel Profile TableFiles31B: Blend Management
5920F31B032BT201Barrel Types and CapacitiesFiles31B: Blend Management
6920F31B033BS181Current Barrel Segment MasterFiles31B: Blend Management
7920F31B03EBE803Barrel Inquiry Work FileFiles31B: Blend Management
8920F31B04MT232Material Type MasterFiles31B: Blend Management
9920F31B042MT121Material Type CombinationFiles31B: Blend Management
10920F31B05EM493Equipment MasterFiles31B: Blend Management
11920F31B051EC183Equipment ConsumablesFiles31B: Blend Management
12920F31B052EA254Equipment AssignmentsFiles31B: Blend Management
13920F31B053CA285Consumable AssignmentsFiles31B: Blend Management
14920F31B06WV163Weight/Volume ConversionsFiles31B: Blend Management
15920F31B07EU534EUR Master FileFiles31B: Blend Management
16920F31B0700SM182Specification MasterFiles31B: Blend Management
17920F31B0701SD241Specification DetailFiles31B: Blend Management
18920F31B0702ES171EUR SpecificationsFiles31B: Blend Management
19920F31B0703WS191Specification Wine StatusesFiles31B: Blend Management
20920F31B0704VD252Specification Version DetailFiles31B: Blend Management
21920F31B0705BN412Blend Named Calculation VersionFiles31B: Blend Management
22920F31B0710HA271Harvest AssumptionsFiles31B: Blend Management
23920F31B0720PM282Protocol MasterFiles31B: Blend Management
24920F31B0721EP303EUR ProtocolsFiles31B: Blend Management
25920F31B0730LA201EUR Loss AssumptionsFiles31B: Blend Management
26920F31B0731WS201EUR Wine Status Loss AssumptionsFiles31B: Blend Management
27920F31B0740PA511Planning AssumptionsFiles31B: Blend Management
28920F31B0741CC221EUR Cull and CascadeFiles31B: Blend Management
29920F31B0750OF181EUR Operation List FlagFiles31B: Blend Management
30920F31B0751OL191Operation ListFiles31B: Blend Management
31920F31B0760CA211EUR Conversion AssumptionsFiles31B: Blend Management
32920F31B0770BM292Brand MasterFiles31B: Blend Management
33920F31B0790SV411Specification ValidationFiles31B: Blend Management
34920F31B07AGAG71EUR Accounting GroupsFiles31B: Blend ManagementBusiness Data
35920F31B08TM1054Tank MasterFiles31B: Blend Management
36920F31B0800RE193F31B0800 Recalculation Error HandlingFiles31B: Blend Management
37920F31B10VB202VBT HeaderFiles31B: Blend Management
38920F31B100BC251Bill Of Lading Composition DetailsFiles31B: Blend ManagementBusiness Data
39920F31B101VD254VBT DetailFiles31B: Blend Management
40920F31B103UV152Unknown Vessel MasterFiles31B: Blend Management
41920F31B104DP212Named Calculation User Default PathsFiles31B: Blend Management
42920F31B105PH232Named Calculation Path HeaderFiles31B: Blend Management
43920F31B106PD192Named Calculation Path DetailFiles31B: Blend Management
44920F31B107FH232Named Calculation Format HeaderFiles31B: Blend Management
45920F31B108FD202Named Calculation Format DetailFiles31B: Blend Management
46920F31B109NC412Blend Named CalculationFiles31B: Blend Management
47920F31B11WG231Work Group MasterFiles31B: Blend Management
48920F31B110MB1121Mass Barrel UpdateFiles31B: Blend Management
49920F31B111GS192Work Group Staff AllocationFiles31B: Blend Management
50920F31B112AA162Work Group Work Area AssignmentFiles31B: Blend Management
51920F31B114TB402Trial Blend HeaderFiles31B: Blend Management
52920F31B115BD347Trial Blend Lot DetailsFiles31B: Blend Management
53920F31B115WLW1136Trial Blend Input Lot WorkfileFiles31B: Blend Management
54920F31B116CH222Temperature Conversion Chart HeaderFiles31B: Blend Management
55920F31B117CD212Temperature Conversion Chart DetailFiles31B: Blend Management
56920F31B12PA292Work Area MasterFiles31B: Blend Management
57920F31B120HI341Vessel Inquiry Work FileFiles31B: Blend Management
58920F31B13WC551Winery ConstantsFiles31B: Blend Management
59920F31B130CM263Container Master TableFiles31B: Blend Management
60920F31B14MC231WIM ConstantsFiles31B: Blend Management
61920F31B15TD302Setup Tank Dip ChartFiles31B: Blend Management
62920F31B151DC115Setup Tank Dip Chart DetailsFiles31B: Blend Management
63920F31B17Z1SZ312Operation EUR Transaction FileFiles31B: Blend Management
64920F31B18Z1SZ382VBT Barrel Transaction FileFiles31B: Blend Management
65920F31B19Z1SZ512Instructed Attributes Transaction FileFiles31B: Blend Management
66920F31B20CC71Cost ComponentsMaster Files31B: Blend ManagementBusiness Data
67920F31B21CG81Cost Groups HeaderMaster Files31B: Blend ManagementBusiness Data
68920F31B211CG121Cost Groups DetailMaster Files31B: Blend ManagementBusiness Data
69920F31B23CR71GL Category Cost Group Cross ReferenceMaster Files31B: Blend ManagementBusiness Data
70920F31B25TR285QA History Results WorkfileFiles31B: Blend Management
71920F31B31WL915Blend Lot MasterFiles31B: Blend Management
72920F31B311LC259Lot CompositionFiles31B: Blend Management
73920F31B314LS122Lot StyleFiles31B: Blend Management
74920F31B315LO113Lot OwnersFiles31B: Blend Management
75920F31B316LE114Lot EURFiles31B: Blend Management
76920F31B317LC192Lot CommentsFiles31B: Blend Management
77920F31B318AC151Lot Accumulated AdditivesFiles31B: Blend Management
78920F31B31CBC131Blend Lot CostsMaster Files31B: Blend ManagementBusiness Data
79920F31B31Z1SZ367Operations Composition Transaction FileTransaction Files31B: Blend ManagementBusiness Data
80920F31B32WS181Wine StatusFiles31B: Blend Management
81920F31B33OD144Operation DependencyFiles31B: Blend Management
82920F31B33DCDT201Dependency Chain Cache StructureFiles31B: Blend Management
83920F31B33WRW112Related TB Report WorkfileFiles31B: Blend Management
84920F31B34ST282Style DefinitionFiles31B: Blend Management
85920F31B341SW144Style Invisible By WineryFiles31B: Blend Management
86920F31B342SA162Style AssigmentFiles31B: Blend Management
87920F31B343BS282Barrel Style DefinitionFiles31B: Blend Management
88920F31B34Z1SZ317Operations Style Transaction FileTransaction Files31B: Blend ManagementBusiness Data
89920F31B35OM172Owner MasterFiles31B: Blend Management
90920F31B37GA194Geographic Area MasterFiles31B: Blend Management
91920F31B371GR156Geographic Area RelationshipFiles31B: Blend Management
92920F31B372GD23Growing Area DescendentsFiles31B: Blend Management
93920F31B373GD23Appellation DescendentsFiles31B: Blend Management
94920F31B38VR232Variety MasterFiles31B: Blend Management
95920F31B3CZ1SZ317Operations Cost Transaction FileTransaction Files31B: Blend ManagementBusiness Data
96920F31B40SA222Summary Attributes Definition FileFiles31B: Blend Management
97920F31B40WQW164Summary Attributes Query Work FileFiles31B: Blend Management
98920F31B42IN162Instructed Attributes DefinitionFiles31B: Blend Management
99920F31B45AT342Additive TemplatesFiles31B: Blend Management
100920F31B46CT323Consumable TemplatesFiles31B: Blend Management
101920F31B50BD183Blend ID DefinitionFiles31B: Blend Management
102920F31B501BS31Blend ID Sequence NumbersFiles31B: Blend Management
103920F31B5100AC241Wine Premises Report Attribute TableFiles31B: Blend Management
104920F31B5101WL241Wine Premises Report Line DefinitionFiles31B: Blend Management
105920F31B5102WC282Wine Premises Report ConfigurationFiles31B: Blend Management
106920F31B5103AD292Wine Premises Report Operation DetailFiles31B: Blend Management
107920F31B5120WP401Wine Premises Report PreviewFiles31B: Blend Management
108920F31B52Z1SZ317Operations Equipment Transaction FileTransaction Files31B: Blend ManagementBusiness Data
109920F31B53Z1SZ327Operations Consumables Transaction FileTransaction Files31B: Blend ManagementBusiness Data
110920F31B60OT1001Operation Trace Track WorkfileFiles31B: Blend Management
111920F31B61EL761End Wine Lots WorkfileFiles31B: Blend Management
112920F31B62SS471Sample Search Work TableFiles31B: Blend Management
113920F31B65OH648Operation HeaderFiles31B: Blend Management
114920F31B65Z1SZ998Operations Transaction FileTransaction Files31B: Blend ManagementBusiness Data
115920F31B66BT592Blend TransactionsMaster Files31B: Blend ManagementBusiness Data
116920F31B66BAO181Blend As Of BalanceFiles31B: Blend Management
117920F31B67QA172Quality AssignmentsFiles31B: Blend ManagementBusiness Data
118920F31B68RO101Reversed OperationsFiles31B: Blend Management
119920F31B70VA494Operation Vessel AssignmentsFiles31B: Blend Management
120920F31B71VV263Operation - Vessel to Vessel DetailFiles31B: Blend Management
121920F31B72VD201Operation Vessel DipsFiles31B: Blend Management
122920F31B73BC672Base Operation Configuration.Files31B: Blend Management
123920F31B74WM82Operation Workflow Status MappingFiles31B: Blend Management
124920F31B75OC1302Operation ConfigurationFiles31B: Blend Management
125920F31B751OA781Operation Configuration for Vessel AttributesFiles31B: Blend Management
126920F31B75CCG131Configured Op Cost Groups by WineryFiles31B: Blend Management
127920F31B76VW142Wineries for Configured OperationFiles31B: Blend Management
128920F31B77VM142Material Types for Configured OperationFiles31B: Blend Management
129920F31B78WS152Wine Statuses for Configured OperationFiles31B: Blend Management
130920F31B79DS182Default Styles for Operation ConfigurationFiles31B: Blend Management
131920F31B80LC182Default Lot Comments for Configured OperationFiles31B: Blend Management
132920F31B81VT152Vessel Types for Configured OperationFiles31B: Blend Management
133920F31B82VE132Equipment Types for Configured OperationFiles31B: Blend Management
134920F31B84OA252Operation AdditivesFiles31B: Blend Management
135920F31B85WT754Weigh Tag MasterFiles31B: Blend Management
136920F31B87LO431List of Operations View Work FileFiles31B: Blend Management
137920F31B88IV1071Inventory By Vessel WorkfileFiles31B: Blend Management
138920F31B90QA121QA for Operation ConfigurationFiles31B: Blend ManagementBusiness Data
139920F31B91BL653Bill Of Lading MasterFiles31B: Blend ManagementBusiness Data
140920F31B922PL111Permission List DefinitionFiles31B: Blend Management
141920F31B93WH383Work Order HeaderFiles31B: Blend ManagementBusiness Data
142920F31B93Z1SZ387WIM Work Order Transaction FileTransaction Files31B: Blend ManagementBusiness Data
143920F31B95OV131QA Test Result Blend Override for Operation ConfigurationFiles31B: Blend ManagementBusiness Data
144920F31B96BD211Bill Of Lading DetailsFiles31B: Blend ManagementBusiness Data
145920F31B97HR221Human Resource AssignmentsFiles31B: Blend ManagementBusiness Data
146920F31B97Z1SZ307Operations Resource Transaction FileTransaction Files31B: Blend ManagementBusiness Data
147920F31B98BM312Bottling MasterFiles31B: Blend ManagementBusiness Data
148920F31B99DD181Decant DetailFiles31B: Blend ManagementBusiness Data
149920F31BAAIBL151Blend Automatic Accounting InstructionsMaster Files31B: Blend ManagementBusiness Data
150920F31BQAZ1SZ377Operations Quality Test Transaction FileTransaction Files31B: Blend ManagementBusiness Data
151920F31BSPZ1ST453Sample TransactionsFiles31B: Blend Management