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?920 | BDFATR | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP76B: Brazil
1F76B473Dynamic Formater Layouts Specification - 03B5DSBDFATRDynamic Formater AttributeStringUDC50
2F76B476Dynamic Formater Bank Attributes Cross Reference - 03B3BXBDFATRDynamic Formater AttributeStringUDC50

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

TOPUDC 76B / F1 (Dynamic Formatter Attributes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1     S0001UDV - User Defined Value Y
2     S0002Blanks Y
3     S0003Zeros Y
4     Z0001Company Person/Corp Code1Y
5     Z0002Company Tax ID Y
6     Z0003Company Bank Agency Y
7     Z0004Company Bank Account No Y
8     Z0005Company Bank Agency Digit Y
9     Z0006Company Bank Account Digit Y
10     Z0007Company Bank Agency No+Digit Y
11     Z0008Company Bank Account No+Digit Y
12     Z0009Company Name Y
13     Z0010Formated File Date Created Y
14     Z0011Formated File Time Created Y
15     Z0012Company Bank Number Y
16     Z0013Company Bank Name Y
17     Z0014Payment Instrument1Y
18     Z0015Company Street Name Y
19     Z0016Company Street No Y
20     Z0017Company Street Complement Y
21     Z0018Company City Y
22     Z0019Company Postal Code - 5 dig. Y
23     Z0020Company State Code Y
24     Z0021Bank Return Code2Y
25     Z0022Formated File Line Count Y
26     Z0023Check Control Number Y
27     Z0024Return Occurrences2Y
28     Z0025Payee/Payor Bank No Y
29     Z0026Payee/Payor Bank Agency No Y
30     Z0027Payee/Payor Bank Account No Y
31     Z0028Payee/Payor Bank Agency Digit Y
32     Z0029Payee/Payor Bank Account Digit Y
33     Z0030Payee Bank Agency No + Digit Y
34     Z0031Payee Bank Account No + Digit Y
35     Z0032Payee/Payor Name Y
36     Z0033Document Number Y
37     Z0034Payment Date Y
38     Z0035Payment Amount Y
39     Z0037Bank Return Payment Date Y
40     Z0038Bank Return Payment Amount Y
41     Z0040Payment Sequence Y
42     Z0041Total Payment Amount Y
43     Z0042Payee/Payor Person Corp Code1Y
44     Z0043Payee/Payor Tax ID Y
45     Z0044Bar Code - Payee Bank No Y
46     Z0045Bar Code - Currency Code Y
47     Z0046Bar Code - Control Digit Y
48     Z0047Bar Code - Payment Amount Y
49     Z0048Bar Code Y
50     Z0049Due Date Y
51     Z0050Open Amount Y
52     Z0051Discount Taken Y
53     Z0052Rebate Amount Y
54     Z0053Discount Taken Y
55     Z0054Interest Y
56     Z0055Abatement Y
57     Z0056Fee + Fee 2 Amount Y
58     Z0057Company Postal Code - 3 dig. Y
59     Z0058Bank File Number Y
60     Z0059Bank AgencyDigit+AccountDigit Y
61     Z0060Bank Accord Number Y
62     Z0061Payee Address Book No Y
63     Z0062Detail Sequence in Segment Y
64     Z0063Line Sequence in Segment EP Y
65     Z0064Bar Code - Free Field Y
66     Z0065File Formater Line Type1Y
67     Z0066Bar Code - Date Due Facto Y
68     Z0067Bank Duplicata Number Y
69     Z0068Document Number Y
70     Z0069Invoice Date Y
71     Z0070Client User Code Y
72     Z0071Bank Send Code Y
73     Z0072Boleto Creation Y
74     Z0073Protest Instructions Y
75     Z0074Protest Days Y
76     Z0075Interest by Day Y
77     Z0076Discount Due Date A/R Y
78     Z0077Payee/Payor Address Line 1 Y
79     Z0078Payee/Payor Postal Code - 3d Y
80     Z0079Payee/Payor Postal Code - 5d Y
81     Z0080Message Code Y
82     Z0081Message Description Y
83     Z0082Extract Amount Expenses Y
84     Z0085Discount Available by Day Y
85     Z0086Boleto Creation Y
86     Z0087Payment Group Control Number Y
87     Z0088Payee/Payor City Y
88     Z0089Payee/Payor State Code Y
89     Z0090Payee/Payor Address Line 2 Y
90     Z0091Payee/Payor Address Line 3 Y
91     Z0092Payee/Payor Address Line 4 Y
92     Z0093Bank Return Code 2 Y
93     Z0094Bank Return Code 3 Y
94     Z0095Bank Return Code 4 Y
95     Z0096Bank Return Code 5 Y
96     Z0097Currency Code1Y
97     Z0098Voucher Due Date Y
98     Z0100Segment Code1Y