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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

97 columns | Print definition?910 | URC1

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F007101Text Processor Header12TAURC1User Reserved CodeStringGeneric Edit30
2F007111Text Processor Detail Table6TBURC1User Reserved CodeStringGeneric Edit30
3F03B11Customer Ledger117RPURC1User Reserved CodeStringGeneric Edit30
4F03B11PCustomer Ledger Purge File117RPURC1User Reserved CodeStringGeneric Edit30
5F03B11Z1Batch Invoices131VJURC1User Reserved CodeStringGeneric Edit30
6F03B13Receipts Header72RYURC1User Reserved CodeStringGeneric Edit30
7F03B13PReceipts Header Purge File72RYURC1User Reserved CodeStringGeneric Edit30
8F03B14Receipts Detail118RZURC1User Reserved CodeStringGeneric Edit30
9F03B14PReceipts Detail Purge File118RZURC1User Reserved CodeStringGeneric Edit30
10F03B14Z2F03B14 Interoperability Table145SZURC1User Reserved CodeStringGeneric Edit30
11F03B575Auto Debit Invoice Select and Build126RDURC1User Reserved CodeStringGeneric Edit30
12F03B672Draft Remittance70RDURC1User Reserved CodeStringGeneric Edit30
TOP04: Accounts Payable
13F0411Accounts Payable Ledger90RPURC1User Reserved CodeStringGeneric Edit30
14F0411AWF - As Of Accounts Payable Ledger90RPURC1User Reserved CodeStringGeneric Edit30
15F0411PPurge - Accounts Payable Ledger90RPURC1User Reserved CodeStringGeneric Edit30
16F0411Z1Voucher Transactions - Batch Upload108VLURC1User Reserved CodeStringGeneric Edit30
17F0411Z3F0411 Interoperability Table142SZURC1User Reserved CodeStringGeneric Edit30
TOP10: Financial Reporting
18F1001Multi-Site Consolidation Transfer File Header31GPURC1User Reserved CodeStringGeneric Edit30
19F1001Z1Unedited MSC Interoperability Header Table41IAURC1User Reserved CodeStringGeneric Edit30
20F1002Multi-Site Consolidation Transfer File38GQURC1User Reserved CodeStringGeneric Edit30
21F1002Z1Unedited MSC Interoperability Table47SZURC1User Reserved CodeStringGeneric Edit30
TOP15L: Adv Real Estate Forecasting
22F15L301AREF Projected Sales26PSURC1User Reserved CodeStringGeneric Edit30
TOP34: Requirements Planning
23F3435Vendor Schedule Commitment File18MCURC1User Reserved CodeStringGeneric Edit30
24F3440Vendor Schedule History File17MHURC1User Reserved CodeStringGeneric Edit30
25F3450Adhoc Vendor Schedule File19MAURC1User Reserved CodeStringGeneric Edit30
TOP41: Inventory Management
26F4118Container Deposit File27CNURC1User Reserved CodeStringGeneric Edit30
27F41181Container Transaction File34CMURC1User Reserved CodeStringGeneric Edit30
TOP45: Advanced Pricing
28F4077Rebate Thresholds25RTURC1User Reserved CodeStringGeneric Edit30
29F4077PRebate Thresholds Purge26RTURC1User Reserved CodeStringGeneric Edit30
30F4078Rebate Transaction Summary27RHURC1User Reserved CodeStringGeneric Edit30
31F4079Rebate Transaction Detail26SVURC1User Reserved CodeStringGeneric Edit30
TOP55: Reserved for Clients
32F55IF311As Of156RPURC1User Reserved CodeStringGeneric Edit30
TOP70: Multi-National Products - obsolete-do not reuse
33F704001Payment WH Info TEMP - COMM - 0457PTURC1User Reserved CodeStringGeneric Edit30
34F704002Payment WH Info - COMM - 0456PFURC1User Reserved CodeStringGeneric Edit30
35F704002PPayment WH Info Purge - COMM - 0456PFURC1User Reserved CodeStringGeneric Edit30
36F704003Payment Done - Accum - COMM - 0415PDURC1User Reserved CodeStringGeneric Edit30
37F707111Text Processor Detail Table - 706TBURC1User Reserved CodeStringGeneric Edit30
TOP74: EMEA Localization
38F740018TTag File F0018 - EMEA - 747TFURC1User Reserved CodeStringGeneric Edit30
39F74900Foreign Receivables and Payables - EMEA65RPURC1User Reserved CodeStringGeneric Edit30
TOP74R: CIS
40F74R0401Adjustment to Voucher - RUS - 04 - 74R8ADURC1User Reserved CodeStringGeneric Edit30
41F74R0402Correction to Voucher - RUS - 04 - 74R9COURC1User Reserved CodeStringGeneric Edit30
42F74R3038Adjustment Invoice Header Info AR/SOP - RUS - 74R39AIURC1User Reserved CodeStringGeneric Edit30
43F74R311Prepayment Detail Tax File - RUS - 03B42DEURC1User Reserved CodeStringGeneric Edit30
TOP74U: United Kingdom Localizations
44F74U0445SPC Accounts Payable Match Doc Detail Tag File - UK - 4313RNURC1User Reserved CodeStringGeneric Edit30
TOP75T: Taiwan
45F75T001GUI/VAT Declaration Site - 75T38DSURC1User Reserved CodeStringGeneric Edit30
46F75T001PGUI/VAT Declaration Period - 75T10DPURC1User Reserved CodeStringGeneric Edit30
47F75T002GUI/VAT Number Register - 75T14NRURC1User Reserved CodeStringGeneric Edit30
48F75T0029GUI/VAT Number Register History - 75T14NRURC1User Reserved CodeStringGeneric Edit30
49F75T003GUI/VAT Number Segment - 75T19NSURC1User Reserved CodeStringGeneric Edit30
50F75T0039GUI/VAT Number Segment History - 75T19NSURC1User Reserved CodeStringGeneric Edit30
51F75T004GUI/VAT Transaction Header - 75T100THURC1User Reserved CodeStringGeneric Edit30
52F75T0049GUI/VAT Transaction Header History - 75T100THURC1User Reserved CodeStringGeneric Edit30
53F75T004PGUI/VAT Transaction Header POS - 75T101THURC1User Reserved CodeStringGeneric Edit30
54F75T005GUI/VAT Transaction Detail - 75T48TDURC1User Reserved CodeStringGeneric Edit30
55F75T0059GUI/VAT Transaction Detail History - 75T48TDURC1User Reserved CodeStringGeneric Edit30
56F75T005PGUI/VAT Transaction Detail POS - 75T47TDURC1User Reserved CodeStringGeneric Edit30
57F75T005TGUI/VAT Transaction Detail Temp - 75T48TDURC1User Reserved CodeStringGeneric Edit30
58F75T008GUI/VAT Tax Type Mapping - 75T5TMURC1User Reserved CodeStringGeneric Edit30
59F75T009GUI/VAT Customer Constants - 75T17DVURC1User Reserved CodeStringGeneric Edit30
60F75T0091GUI/VAT Supplier Constants - 75T13SDURC1User Reserved CodeStringGeneric Edit30
61F75T010GUI/VAT User / Declaration Site Mapping - 75T9UMURC1User Reserved CodeStringGeneric Edit30
62F75T012GUI/VAT GL Account Mapping - 75T7GLURC1User Reserved CodeStringGeneric Edit30
63F75T403GUI/VAT Declaration Report 403 - 75T116D3URC1User Reserved CodeStringGeneric Edit30
TOP76A: Argentina
64F760101AA/B Tag Table - ARG - 04 - 76A22V0URC1User Reserved CodeStringGeneric Edit30
65F760411AA/P Ledger Tag Table - ARG - 04 - 76A30B2URC1User Reserved CodeStringGeneric Edit30
66F760414AA/P Payment Detail Tag Table - ARG - 04 - 76A33V1URC1User Reserved CodeStringGeneric Edit30
67F760473APCG Detail Information Tag Table - ARG - 04 - 76A31E5URC1User Reserved CodeStringGeneric Edit30
68F76A010ZF0101Z2 Argentinean Tag Table - ARG - 01 - 76A25V9URC1User Reserved CodeStringGeneric Edit30
69F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A80HFURC1User Reserved CodeStringGeneric Edit30
70F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A80HFURC1User Reserved CodeStringGeneric Edit30
71F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A51DLURC1User Reserved CodeStringGeneric Edit30
72F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A51DLURC1User Reserved CodeStringGeneric Edit30
73F76A20Credit Invoice Constants - ARG - 03B - 76A14ICURC1User Reserved CodeStringGeneric Edit30
74F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A26IEURC1User Reserved CodeStringGeneric Edit30
75F76A25Credit Invoice Tax Area Relationship - ARG - 04 - 76A4IFURC1User Reserved CodeStringGeneric Edit30
76F76A26Credit Invoice Status Rules - ARG - 04 - 76A5IGURC1User Reserved CodeStringGeneric Edit30
77F76A30F0411Z1 Tag Table - ARG - 04 - 76A29V8URC1User Reserved CodeStringGeneric Edit30
78F76A33Receipt Invoice - Audit Log ARG - 03B - 76A13X4URC1User Reserved CodeStringGeneric Edit30
79F76A392Calculated costs header - 76A11C2URC1User Reserved CodeStringGeneric Edit30
80F76A393Calculated costs detail - 76A22C3URC1User Reserved CodeStringGeneric Edit30
81F76A394Adjustments - 76A18C4URC1User Reserved CodeStringGeneric Edit30
82F76A411PPurge A/P Tag Ledger Tag - ARG - 04 - 76A30B2URC1User Reserved CodeStringGeneric Edit30
83F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A33V1URC1User Reserved CodeStringGeneric Edit30
84F76A48CERG A/P - Control Payments -ARG - 04 - 76A4PIURC1User Reserved CodeStringGeneric Edit30
85F76A49CERG A/R - Control Receipts - ARG - 03B - 76A4CRURC1User Reserved CodeStringGeneric Edit30
86F76A7101Batch for Remittance - ARG - 03B - 76A9TAURC1User Reserved CodeStringGeneric Edit30
87F76A8011Supplier Information RG 726 - ARG - 04 - 76A15PAURC1User Reserved CodeStringGeneric Edit30
88F76A8090V.A.T. Witholding Percentage Rg726 - ARG - 04 - 76A14VPURC1User Reserved CodeStringGeneric Edit30
89F76AUI04A/P Legel Tax Tag Table - ARG - 04 - 76A30WCURC1User Reserved CodeStringGeneric Edit30
90F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A80HFURC1User Reserved CodeStringGeneric Edit30
91F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A51DLURC1User Reserved CodeStringGeneric Edit30
92F76AUI46CERG A/R -Work File - ARG - 03B - 76A16WFURC1User Reserved CodeStringGeneric Edit30
TOP76C: Colombia
93F76C0101A/B Tag File - COL - 76C14V0URC1User Reserved CodeStringGeneric Edit30
94F76C0411A/P Tag File - COL - 76C18RPURC1User Reserved CodeStringGeneric Edit30
TOP76P: Peru
95F76P480SPOT Voucher Information - PER - 04 - 76P12SVURC1User Reserved CodeStringGeneric Edit30
TOP76V: Venezuela
96F76V0311Exportation Number - VEN - 76V5TFURC1User Reserved CodeStringGeneric Edit30
97F76V4581Withholding Historical File - VEN - 0425HRURC1User Reserved CodeStringGeneric Edit30