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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

3 columns | Print definition?920 | PGMP | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP04: Accounts Payable
1F0417A/P Payments - Default Print and Update3KBPGMPA/P Payment Processing - Print ProgramStringUDC100
2F04571A/P Payment Processing - Header20KHPGMPA/P Payment Processing - Print ProgramStringUDC100
3F04572A/P Payment Processing - Summary4KKPGMPA/P Payment Processing - Print ProgramStringUDC100

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

TOPUDC 04 / PP (Produce Bank File) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1P04572Print Payments - Standard N
2P04572AProduce EFT Diskette - Austria2N
3P04572A3Create A/P Bank Diskette - Aus2N
4P04572BProduce Bank Tape - BACS2N
5P04572CPrint Payments - Canada N
6P04572CB1Check + Bordero - BR Bradesco N
7P04572DBBordero Print - BR Bradesco1N
8P04572DB1A/P Payments - BR Bradesco N
9P04572DK1Produce Bank File-Denmark Giro2N
10P04572DK5Produce Bank Tape - Denmark2N
11P04572F1Produce Bank Tape - France2N
12P04572F1BXCreate Paper Transfer - France2N
13P04572F2Print Payments - France N
14P04572F3Create Bank Tape - France Intl2N
15P04572FI1Produce Bank File-Finland Dom2N
16P04572FI2Produce Bank File-Finland For2N
17P04572G1Produce Bank Tape - Germany2N
18P04572G2Produce EFT Diskette - Germany2N
19P04572G3Print Cheques - Germany N
20P04572G5Create A/P Bank Diskette - Ger2N
21P04572H1Create A/P Bank Tape - CLIEOP02N
22P04572H2Create A/P Bank Tape - ABN AMR2N
23P04572I1Produce Bank Tape - Italy2N
24P04572I2Print Payments - Italy N
25P04572JPrint Payments - Contract Mgmt N
26P04572JDBank Tape - Japan DENSAI N
27P04572JFProduce Bank Tape - Japan N
28P04572JPProduce Bank Tape - Japan1N
29P04572L2International EFT Dkt -Belgium2N
30P04572L3Produce Bank Diskette - Belgiu2N
31P04572NPrint Payments - Drafts N
32P04572NO1Produce Bank File - Norway DNB2N
33P04572NO2Produce Bank File - Norway DNB2N
34P04572OZProduce EFT File - Australia2N
35P04572RBBordero - Brazil Bradesco N
36P04572S2Produce EFT Diskette - Swiss2N
37P04572S3Swiss SOG Post Payment2N
38P04572SE1Produce Bank File - Sweden BGI2N
39P04572SE2Produce Bank File - Sweden BGU2N
40P04572SE3Produce Bank File - Sweden PG2N
41P04572T1Produce Bank Tape - PPD Format2N
42P04572T2Produce Bank Tape - CTX Format2N
43P04572T3Produce Bank File - IAT Format2N
44P04572U1Print Payments - UK Check N
45P47052TProduce EDI Payment Order/Rmt2N
46P74N572Aproduce EFT File NZ - ANZ N
47P74N572BProduce EFT File NZ - BNZ N
48P74N572NProduce EFT File NZ - National N
49P74N572WProduce EFT File NZ - Westpac N
50P74S572APrint Check - Spain N
51P74S572BPrint Check/Letter - Spain N
52P74S572CPrint Draft - Spain N
53P74S572DPrint Transfer Order - Spain1N
54P74S572EPrint Transf. Order/Fgn -Spain1N
55P74S572FProduce Bank Tape - Spain1N
56P74S572FAProduce Bank Tape - Spain1N
57P7604721AOnly payment order-Arg 04 N
58P760472ACheck - Arg 04 N
59P76A04722Deferred check - Arg 04 N