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
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
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

84 columns | Print definition?812 | URC1

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F007101Text Processor Header12TAURC1User Reserved CodeStringGeneric Edit30
2F007111Text Processor Detail Table6TBURC1User Reserved CodeStringGeneric Edit30
TOP03B: Enhanced Accounts Receivable
3F03B11Customer Ledger117RPURC1User Reserved CodeStringGeneric Edit30
4F03B11PCustomer Ledger Purge File117RPURC1User Reserved CodeStringGeneric Edit30
5F03B11Z1Invoice Transactions - Batch File131VJURC1User Reserved CodeStringGeneric Edit30
6F03B13Receipts Header File72RYURC1User Reserved CodeStringGeneric Edit30
7F03B13PReceipts Header Purge File72RYURC1User Reserved CodeStringGeneric Edit30
8F03B14A/R Check Detail File118RZURC1User 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 Remittance Work File - One World Only70RDURC1User 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 File108VLURC1User 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
29F4078Rebate Transaction Summary27RHURC1User Reserved CodeStringGeneric Edit30
30F4079Rebate Transaction Detail26SVURC1User Reserved CodeStringGeneric Edit30
TOP55: Reserved for Clients
31F55IF311As Of156RPURC1User Reserved CodeStringGeneric Edit30
TOP74: EMEA Localization
32F740018TTag File F0018 - EMEA - 747TFURC1User Reserved CodeStringGeneric Edit30
33F74900Foreign Receivables and Payables - EMEA65RPURC1User Reserved CodeStringGeneric Edit30
TOP75T: Taiwan
34F75T001GUI/VAT Declaration Site - 75T37DSURC1User Reserved CodeStringGeneric Edit30
35F75T001PGUI/VAT Declaration Period - 75T10DPURC1User Reserved CodeStringGeneric Edit30
36F75T002GUI/VAT Number Register - 75T14NRURC1User Reserved CodeStringGeneric Edit30
37F75T0029GUI/VAT Number Register History - 75T14NRURC1User Reserved CodeStringGeneric Edit30
38F75T003GUI/VAT Number Segment - 75T19NSURC1User Reserved CodeStringGeneric Edit30
39F75T0039GUI/VAT Number Segment History - 75T19NSURC1User Reserved CodeStringGeneric Edit30
40F75T004GUI/VAT Transaction Header - 75T85THURC1User Reserved CodeStringGeneric Edit30
41F75T0049GUI/VAT Transaction Header History - 75T85THURC1User Reserved CodeStringGeneric Edit30
42F75T004PGUI/VAT Transaction Header POS - 75T85THURC1User Reserved CodeStringGeneric Edit30
43F75T005GUI/VAT Transaction Detail - 75T35TDURC1User Reserved CodeStringGeneric Edit30
44F75T0059GUI/VAT Transaction Detail History - 75T35TDURC1User Reserved CodeStringGeneric Edit30
45F75T005PGUI/VAT Transaction Detail POS - 75T35TDURC1User Reserved CodeStringGeneric Edit30
46F75T008GUI/VAT Tax Type Mapping - 75T5TMURC1User Reserved CodeStringGeneric Edit30
47F75T009GUI/VAT Customer Constants - 75T16DVURC1User Reserved CodeStringGeneric Edit30
48F75T0091GUI/VAT Supplier Constants - 75T13SDURC1User Reserved CodeStringGeneric Edit30
49F75T010GUI/VAT User / Declaration Site Mapping - 75T9UMURC1User Reserved CodeStringGeneric Edit30
50F75T012GUI/VAT GL Account Mapping - 75T7GLURC1User Reserved CodeStringGeneric Edit30
51F75T403GUI/VAT Declaration Report 403 - 75T116D3URC1User Reserved CodeStringGeneric Edit30
TOP76A: Argentina
52F760101AA/B Tag File - ARG22V0URC1User Reserved CodeStringGeneric Edit30
53F760411AA/P Tag Ledger Tag File - ARG30B2URC1User Reserved CodeStringGeneric Edit30
54F760414AA/P Payment Detail Tag File - ARG - 0433V1URC1User Reserved CodeStringGeneric Edit30
55F760473APCG Detail Information Tag File - ARG - 0431E5URC1User Reserved CodeStringGeneric Edit30
56F76A010ZF0101Z2 Argentinean Tag Table - ARG - 01 - 76A25V9URC1User Reserved CodeStringGeneric Edit30
57F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A80HFURC1User Reserved CodeStringGeneric Edit30
58F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A80HFURC1User Reserved CodeStringGeneric Edit30
59F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A51DLURC1User Reserved CodeStringGeneric Edit30
60F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A51DLURC1User Reserved CodeStringGeneric Edit30
61F76A20Credit Invoice Constants - ARG - 03B - 76A14ICURC1User Reserved CodeStringGeneric Edit30
62F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A26IEURC1User Reserved CodeStringGeneric Edit30
63F76A25Credit Invoice Tax Area Relationship - ARG - 04 - 76A4IFURC1User Reserved CodeStringGeneric Edit30
64F76A26Credit Invoice Status Rules - ARG - 04 - 76A5IGURC1User Reserved CodeStringGeneric Edit30
65F76A30F0411Z1 Tag File - ARG 0429V8URC1User Reserved CodeStringGeneric Edit30
66F76A33Receipt Invoice - Audit Log AGR13X4URC1User Reserved CodeStringGeneric Edit30
67F76A392Calculated costs header - 76A11C2URC1User Reserved CodeStringGeneric Edit30
68F76A393Calculated costs detail - 76A22C3URC1User Reserved CodeStringGeneric Edit30
69F76A394Adjustments - 76A18C4URC1User Reserved CodeStringGeneric Edit30
70F76A411PPurge A/P Tag Ledger Tag - ARG - 04 - 76A30B2URC1User Reserved CodeStringGeneric Edit30
71F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A33V1URC1User Reserved CodeStringGeneric Edit30
72F76A48CERG A/P - Control Payments -ARG - 04 - 044PIURC1User Reserved CodeStringGeneric Edit30
73F76A49CERG A/R - Control Receipts - ARG - 03B - 03B4CRURC1User Reserved CodeStringGeneric Edit30
74F76A7101Batch for Remittance - ARG - 03B - 76A9TAURC1User Reserved CodeStringGeneric Edit30
75F76A8011Supplier Information RG 726 - 0415PAURC1User Reserved CodeStringGeneric Edit30
76F76A8090V.A.T. Witholding Percentage Rg72614VPURC1User Reserved CodeStringGeneric Edit30
77F76AUI04A/P Tag Legel Tax File - ARG - WF30WCURC1User Reserved CodeStringGeneric Edit30
78F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0080HFURC1User Reserved CodeStringGeneric Edit30
79F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0051DLURC1User Reserved CodeStringGeneric Edit30
80F76AUI46CERG A/R -Work File - ARG - 03B - 03B16WFURC1User Reserved CodeStringGeneric Edit30
TOP76C: Colombia
81F76C0101A/B Tag File - COL - 76C14V0URC1User Reserved CodeStringGeneric Edit30
82F76C0411A/P Tag File - COL - 76C18RPURC1User Reserved CodeStringGeneric Edit30
TOP76P: Peru
83F76P480SPOT Voucher Information - PER - 04 - 76P12SVURC1User Reserved CodeStringGeneric Edit30
TOP76V: Venezuela
84F76V4581Withholding Historical File - VEN - 0425HRURC1User Reserved CodeStringGeneric Edit30