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?812 | 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 - Header File20KHPGMPA/P Payment Processing - Print ProgramStringUDC100
3F04572A/P Payment Processing - Summary File4KKPGMPA/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
1P04572A   Produce EFT Diskette - Austria
2P04572B   Produce Bank Tape - BACS
3P04572C   Print Payments - Canada
4P04572CB1 Check + Bordero - BR BradescoN
5P04572DB  Bordero Print - BR BradescoN
6P04572DB1 A/P Payments - BR BradescoN
7P04572DK1 Produce Bank File-Denmark GiroN
8P04572DK5 Produce Bank Tape - DenmarkN
9P04572F1  Produce Bank Tape - France
10P04572F1BXCreate Paper Transfer - FranceN
11P04572F2  Print Payments - France
12P04572FI1 Produce Bank File-Finland DomN
13P04572FI2 Produce Bank File-Finland ForN
14P04572G1  Produce Bank Tape - Germany
15P04572G2  Produce EFT Diskette - Germany
16P04572G3  Print Cheques - Germany
17P04572H1  Create A/P Bank Tape - CLIEOP0N
18P04572H2  Create A/P Bank Tape - ABN AMRN
19P04572I1  Produce Bank Tape - Italy
20P04572I2  Print Payments - Italy
21P04572J   Print Payments - Contract Mgmt
22P04572JP  Produce Bank Tape - JapanN
23P04572L1  International EFT Tape-Belgium
24P04572L2  International EFT Dkt -Belgium
25P04572L3  Produce Bank Diskette - BelgiuN
26P04572L4  Produce Dom-EURO Bank DsktN
27P04572N   Print Payments - Drafts
28P04572NO1 Produce Bank File - Norway DNBN
29P04572NO2 Produce Bank File - Norway DNBN
30P04572RB  Bordero - Brazil BradescoN
31P04572S1  Produce Bank Tape - Swiss 826
32P04572S2  Produce EFT Diskette - Swiss
33P04572S3  Swiss SOG Post PaymentN
34P04572SE1 Produce Bank File - Sweden BGIN
35P04572SE2 Produce Bank File - Sweden BGUN
36P04572SE3 Produce Bank File - Sweden PGN
37P04572T   Produce Bank Tape - Standard
38P04572T1  Produce Bank Tape - PPD Format
39P04572T2  Produce Bank Tape - CTX FormatN
40P47052T   Produce EDI Payment Order/Rmt
41P74S572A  Print Check - SpainN
42P74S572B  Print Check/Letter - SpainN
43P74S572C  Print Draft - SpainN
44P74S572D  Print Transfer Order - SpainN
45P74S572E  Print Transf. Order/Fgn -SpainN
46P74S572F  Produce Bank Tape - SpainN
47P7604721A Only payment order-Arg 04N
48P760472A  Check - Arg 04N
49P76A04722 Deferred check - Arg 04N