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

2 columns | Print definition?910 | BASR | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP09: General Accounting
1F09123Advanced Variable Numerator27VNBASRBasis RatioStringUDC20
2F09123AAdvanced Variable Numerator Busines Unit Override3BOBASRBasis RatioStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 09 / RT (Allocation Ratio Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        01Category Code 01Y
2        02Category Code 02Y
3        03Category Code 03Y
4        04Category Code 04Y
5        05Category Code 05Y
6        06Category Code 06Y
7        07Category Code 07Y
8        08Category Code 08Y
9        09Category Code 09Y
10        10Category Code 10Y
11        11Category Code 11Y
12        12Category Code 12Y
13        13Category Code 13Y
14        14Category Code 14Y
15        15Category Code 15Y
16        16Category Code 16Y
17        17Category Code 17Y
18        18Category Code 18Y
19        19Category Code 19Y
20        20Category Code 20Y
21        21Category Code 21Y
22        22Category Code 22Y
23        23Category Code 23Y
24        24Category Code 24Y
25        25Category Code 25Y
26        26Category Code 26Y
27        27Category Code 27Y
28        28Category Code 28Y
29        29Category Code 29Y
30        30Category Code 30Y
31        31Category Code 31Y
32        32Category Code 32Y
33        33Category Code 33Y
34        34Category Code 34Y
35        35Category Code 35Y
36        36Category Code 36Y
37        37Category Code 37Y
38        38Category Code 38Y
39        39Category Code 39Y
40        40Category Code 40Y
41        41Category Code 41Y
42        42Category Code 42Y
43        43Category Code 43Y
44        44Category Code 44Y
45        45Category Code 45Y
46        46Category Code 46Y
47        47Category Code 47Y
48        48Category Code 48Y
49        49Category Code 49Y
50        50Category Code 50Y
51        51Business UnitY
52        52Related Business UnitY
53        53Home Business UnitY
54        54Job Business UnitY
55        55Employee Pool Grouping CodeY
56        56Job Pool Grouping CodeY