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

56 columns | Print definition?812 | TXR1

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File31TDTXR1Tax Rate 1NumericGeneric Edit73
2F0028Sales Tax Work File by Taxing Authority2TETXR1Tax Rate 1NumericGeneric Edit73
3F0029Sales Tax Work File by Taxing Authority and Document2TFTXR1Tax Rate 1NumericGeneric Edit73
4F4008Tax Areas4TATXR1Tax Rate 1NumericGeneric Edit73
TOP04: Accounts Payable
5F09UI006Tax (F0018) Replica31TDTXR1Tax Rate 1NumericGeneric Edit73
TOP09E: Expense Reimbursment
6F20112Expense Report Detail38EDTXR1Tax Rate 1NumericGeneric Edit73
TOP40: Inventory/OP Base
7F40UI00TTax Work File8PNTXR1Tax Rate 1NumericGeneric Edit73
TOP42: Sales Management
8F42565Invoice Print File51IWTXR1Tax Rate 1NumericGeneric Edit73
TOP43E: Requisition Self Service
9F43E20Shopping Cart Detail23SCTXR1Tax Rate 1NumericGeneric Edit73
10F43E20WFeReq - Shopping Cart Work File24SWTXR1Tax Rate 1NumericGeneric Edit73
TOP47: Electronic Commerce
11F470161EDI Purchase Order Additional Header - Outbound24S3TXR1Tax Rate 1NumericGeneric Edit73
12F470171EDI Purchase Order Additional Detail - Outbound21S4TXR1Tax Rate 1NumericGeneric Edit73
13F470461EDI Invoice Additional Header - Outbound26S3TXR1Tax Rate 1NumericGeneric Edit73
14F470471EDI Invoice Additional Detail - Outbound24S4TXR1Tax Rate 1NumericGeneric Edit73
15F470473EDI Invoice Detail Charges24S7TXR1Tax Rate 1NumericGeneric Edit73
16F471061EDI Response to RFQ Additional Header - Outbound26S3TXR1Tax Rate 1NumericGeneric Edit73
17F471071EDI Response to RFQ Additional Detail - Outbound24S4TXR1Tax Rate 1NumericGeneric Edit73
TOP55: Reserved for Clients
18F74H1051Invoicing Workfile - New29IWTXR1Tax Rate 1NumericGeneric Edit73
TOP74: EMEA Localization
19F74093Workfile for Printing IVA Summary - Italy30HCTXR1Tax Rate 1NumericGeneric Edit73
20F7420018Taxes by Sales Order Line - COMM - 426STTXR1Tax Rate 1NumericGeneric Edit73
21F7430018Taxes by A/R Invoice Line - COMM - 03B6TITXR1Tax Rate 1NumericGeneric Edit73
22F7430035Taxes by Legal Document Line - COMM - 03B7PITXR1Tax Rate 1NumericGeneric Edit73
TOP74H: Hungary
23F74H1004VAT Declaration Detail10VDTXR1Tax Rate 1NumericGeneric Edit73
TOP74R: CIS
24F74R0018Russian Tax File - 74R24TDTXR1Tax Rate 1NumericGeneric Edit73
TOP75T: Taiwan
25F75T004GUI/VAT Transaction Header - 75T16THTXR1Tax Rate 1NumericGeneric Edit73
26F75T0049GUI/VAT Transaction Header History - 75T16THTXR1Tax Rate 1NumericGeneric Edit73
27F75T004PGUI/VAT Transaction Header POS - 75T16THTXR1Tax Rate 1NumericGeneric Edit73
28F75T004ZGUI/VAT Transaction Header - Work - 75T14ZHTXR1Tax Rate 1NumericGeneric Edit73
TOP76A: Argentina
29F76A13Taxes - Tax Values - ARG - 008TVTXR1Tax Rate 1NumericGeneric Edit73
30F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 0016TOTXR1Tax Rate 1NumericGeneric Edit73
31F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A16TOTXR1Tax Rate 1NumericGeneric Edit73
32F76A19Taxes - Tax Amounts by Invoice Suffix AGR14TITXR1Tax Rate 1NumericGeneric Edit73
33F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A14TITXR1Tax Rate 1NumericGeneric Edit73
34F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B32VKTXR1Tax Rate 1NumericGeneric Edit73
35F76A8050Perceptions Exempt Percentages - 03B5PPTXR1Tax Rate 1NumericGeneric Edit73
36F76A8230Percentages by state / agreement Gross Income - ARG - - 76A6C1TXR1Tax Rate 1NumericGeneric Edit73
37F76AUI18Taxes - Tax amount by order line - Work File - ARG - 4210WFTXR1Tax Rate 1NumericGeneric Edit73
38F76AUI24Taxes Work File - ARG - 0014TITXR1Tax Rate 1NumericGeneric Edit73
39F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A24WFTXR1Tax Rate 1NumericGeneric Edit73
TOP76B: Brazil - Reporting System Only
40F7603B1A/R Additional Information - Brazil6CITXR1Tax Rate 1NumericGeneric Edit73
41F7603B1PArchive A/R Additional Information - Brazil - 03B6BPTXR1Tax Rate 1NumericGeneric Edit73
42F7608BICMS Tax Rates4TBTXR1Tax Rate 1NumericGeneric Edit73
43F7611BNota Fiscal Detail - Brazil66FDTXR1Tax Rate 1NumericGeneric Edit73
44F761BAAS Fiscal file book65FBTXR1Tax Rate 1NumericGeneric Edit73
45F76B18IPI Taxes6FCTXR1Tax Rate 1NumericGeneric Edit73
TOP76C: Colombia
46F76CI1Tax Parameters - COL - 76C11PITXR1Tax Rate 1NumericGeneric Edit73
47F76CI2Economic Activity - COL - 76C7AETXR1Tax Rate 1NumericGeneric Edit73
48F76CT2Sales/Use/V.A.T. Tax File - COL - 76C19CTTXR1Tax Rate 1NumericGeneric Edit73
49F76CUI02Tax Detail - Work File - COL - 76C30TDTXR1Tax Rate 1NumericGeneric Edit73
50F76CUI04Tax Detail for Distribution - Work File - COL - 76C31TDTXR1Tax Rate 1NumericGeneric Edit73
TOP76E: Ecuador
51F76E4020Withholding Certificate Information w/ SRI - EC - 0410CRTXR1Tax Rate 1NumericGeneric Edit73
TOP76H: Chile
52F76H218Taxes by Sales Order Line - CHI - 42 - 76H15TDTXR1Tax Rate 1NumericGeneric Edit73
TOP76V: Venezuela
53F76VLC01Purchase Register Temporal - VEN -04 - 76V4LCTXR1Tax Rate 1NumericGeneric Edit73
54F76VLO01Withholdings Temporal Table - VEN -04 - 76V18LOTXR1Tax Rate 1NumericGeneric Edit73
55F76VLV01Temporal Table for VAT Type - R76VLV01 - VEN -03B - 76V2IMTXR1Tax Rate 1NumericGeneric Edit73
56F76VLV03Temporal Table for VAT Type - R76VLV02 - VEN -03B - 76V2IATXR1Tax Rate 1NumericGeneric Edit73