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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

146 tables812 | 76A

76A: Argentina
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F76001ANC71Next Number File - ARGMaster Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
2812F76002AJD31JDE/D.G.I. Document Type Relation - ARGMaster Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
3812F760081AV691SICORE Step 1 and 2 - ARG - 00Transaction Files00: Foundation EnvironmentNo
4812F760082AV711SICORE Output File - ARG - 00Transaction Files00: Foundation EnvironmentNo
5812F760101AV0231A/B Tag File - ARGTransaction Files04: Accounts PayableAS400 Coexistence Tables
6812F760401AK2121Gross Income Withholding Percentage - ARGMaster Files04: Accounts PayableAS400 Coexistence Tables
7812F760402AK181V.A.T. withholding percentage - ARGMaster Files04: Accounts PayableAS400 Coexistence Tables
8812F760403AK3121Profit Withholding Percentage - ARG - 04Master Files76A: ArgentinaAS400 Coexistence Tables
9812F760404AK571Profit Withholding Percentage - 4th.Category - ARGMaster Files04: Accounts PayableAS400 Coexistence Tables
10812F760405AK791Contract Withholding Percentage - ARGMaster Files04: Accounts PayableAS400 Coexistence Tables
11812F760406AK681Profit Withholding - Payments Done - ARGTransaction Files04: Accounts PayableAS400 Coexistence Tables
12812F760407AK461Gross Income - State Set Up - ARGMaster Files04: Accounts PayableAS400 Coexistence Tables
13812F760409AV951Voucher Authorization Rules Maintenance - ARGMaster Files04: Accounts PayableAS400 Coexistence Tables
14812F760410AK0101Eventual Services Withholding Percentage - ARGMaster Files04: Accounts PayableAS400 Coexistence Tables
15812F760411AB2321A/P Tag Ledger Tag File - ARGTransaction Files04: Accounts PayableAS400 Coexistence Tables
16812F760414AV1342A/P Payment Detail Tag File - ARG - 04Transaction Files76A: ArgentinaAS400 Coexistence Tables
17812F760472AK941F04572 Tag File - ARGTransaction Files04: Accounts PayableAS400 Coexistence Tables
18812F760473AE5321PCG Detail Information Tag File - ARG - 04Transaction Files76A: ArgentinaAS400 Coexistence Tables
19812F760499AK8143Contract Withholding - Advances - ARG -04 - 04Master Files76A: ArgentinaAS400 Coexistence Tables
20812F7607AV4111Withholding Exempt Percentage - ARG - 04 - 04Master Files76A: ArgentinaAS400 Coexistence Tables
21812F7608AV541Supplier State Agreement - ARG - 04Master Files04: Accounts PayableAS400 Coexistence Tables
22812F764008ATQ711Aditionals Tax Areas - ARGTransaction Files04: Accounts PayableAS400 Coexistence Tables
23812F7691SBAV311CITI A/P Final Step SB Table - ARG - 00 - RevisarTransaction Files00: Foundation EnvironmentNo
24812F76A00T031Taxes - Initial Set Up - ARG - 00Constants Files00: Foundation EnvironmentAS400 Coexistence Tables
25812F76A003RG111A/P Tag File - CAI Storage - ARG - 00Transaction Files00: Foundation EnvironmentAS400 Coexistence Tables
26812F76A005RH111CAI - Invoice range for Preprinters - ARG - 03BFiles76A: Argentina
27812F76A010ZV9261F0101Z2 Argentinean Tag Table - ARG - 01 - 76ABatch Input Files76: Latin American Localization
28812F76A0110U192UTE Members - 76AFiles76: Latin American Localization
29812F76A0209HF942Header and Footer Invoice/ShipmentNote History WF - ARG - 76AFiles76: Latin American Localization
30812F76A020PHF941Header/Footer Inv./ShipmentNote History WF Purge - AR - 76AFiles76: Latin American Localization
31812F76A0219DL581Detail Lines Invoice/ShipmentNote History WF - ARG - - 76AFiles76: Latin American Localization
32812F76A021PDL581Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76AFiles76: Latin American Localization
33812F76A0394R021Sales V.A.T. Tape File - ARG - 03 - 76AFiles76: Latin American Localization
34812F76A043RG111A/P Tag File - CAI Storage - ARG - 04Transaction Files04: Accounts PayableAS400 Coexistence Tables
35812F76A0440CD151Check details RG 1547 - ARG - 04 - 76AFiles76: Latin American Localization
36812F76A0441TR22TXT File RG1547- ARG - 04 - 76AFiles76: Latin American Localization
37812F76A0444WF32RG1547 Work File - ARG - 04 - 76AFiles76: Latin American Localization
38812F76A0456X181Security Withholding Payments Done - ARGFiles76A: Argentina
39812F76A0494D121Purchasing Flat File - ARG - 04 - 76AFiles76: Latin American Localization
40812F76A08CF301Credit Invoice Payments - ARG - 00Transaction Files00: Foundation EnvironmentAS400 Coexistence Tables
41812F76A09TT623Invoice Total - ARG - 00 - 00Transaction Files76A: ArgentinaAS400 Coexistence Tables
42812F76A09PTT621Invoice Total Purge - ARG - 03B - 76AFiles76: Latin American LocalizationBusiness Data
43812F76A10TD251Taxes - Tax Definition - ARG - 00 - 00Master Files76A: ArgentinaAS400 Coexistence Tables
44812F76A100RG21Autoprinter Supplier Control File - ARG - 00 - 00Transaction Files76A: ArgentinaAS400 Coexistence Tables
45812F76A11TF42Account ID Relationship - ARG - 00Transaction Files00: Foundation EnvironmentAS400 Coexistence Tables
46812F76A12TM41Taxes - Minimum Tax By Date - ARG - 00Secondary Master Files00: Foundation EnvironmentAS400 Coexistence Tables
47812F76A1244FQ131Fixed Assets by Data Type Record - Anexo A - ARG - 12Transaction Files76A: ArgentinaAS400 Coexistence Tables
48812F76A13TV101Taxes - Tax Values - ARG - 00Secondary Master Files00: Foundation EnvironmentAS400 Coexistence Tables
49812F76A14TP21Taxes - Tax Predecessor - ARG - 00Secondary Master Files00: Foundation EnvironmentAS400 Coexistence Tables
50812F76A15TE51Taxes - Effective and Expiration Dates - ARG - 00Master Files00: Foundation EnvironmentAS400 Coexistence Tables
51812F76A16TG62Taxes - Tax Groups - ARG - 00Master Files00: Foundation EnvironmentAS400 Coexistence Tables
52812F76A17TL51Taxes - Invoice/Shipment Note Letter - ARG - 00Secondary Master Files00: Foundation EnvironmentAS400 Coexistence Tables
53812F76A18TO184Taxes - Tax Amounts by Sales Order Line - ARG - 00Transaction Files00: Foundation EnvironmentAS400 Coexistence Tables
54812F76A18PTO181Taxes - Tax Amounts by Sales Order Line Purge - ARG - - 76ATransaction Files76: Latin American LocalizationBusiness Data
55812F76A19TI214Taxes - Tax Amounts by Invoice Suffix AGRTransaction Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
56812F76A19PTI211Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76AFiles76: Latin American Localization
57812F76A19Z1VK391Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03BTransaction Files76A: ArgentinaAS400 Coexistence Tables
58812F76A20IC231Credit Invoice Constants - ARG - 03B - 76AFiles76: Latin American Localization
59812F76A21IH301Credit Invoice Header - F76A21 - ARG - 3B - 76AFiles76: Latin American Localization
60812F76A21PIH301Credit Invoice Header Purge - ARG - 03B - 76AFiles76: Latin American Localization
61812F76A22ID241Credit Invoice Detail - F76A22 - ARG - 03B - 76AFiles76: Latin American Localization
62812F76A22PID241Credit Invoice Detail Purge - ARG - 03B - 76AFiles76: Latin American Localization
63812F76A23IW181Credit Invoice Withholdings - F76A23 - ARG - 03B - 76AFiles76: Latin American Localization
64812F76A23PIW181Credit Invoice Withholdings Purge - ARG - 03B - 76AFiles76: Latin American Localization
65812F76A24IE353Credit Invoice Information - Accounts Payable - ARG - - 76AFiles76: Latin American Localization
66812F76A25IF132Credit Invoice Tax Area Relationship - ARG - 04 - 76AFiles76: Latin American Localization
67812F76A26IG142Credit Invoice Status Rules - ARG - 04 - 76AFiles76: Latin American Localization
68812F76A30V8321F0411Z1 Tag File - ARG 04Transaction Files04: Accounts PayableAS400 Coexistence Tables
69812F76A30HV6111EDI Batch Input Localization File - ARG - 04 - 76AFiles76: Latin American Localization
70812F76A30TV7211F76A30 Tag File Z1 - ARG - 04 - 76AFiles76: Latin American Localization
71812F76A32X322A/P Account ID Relationship - ARG - 04 - 04Transaction Files76A: ArgentinaAS400 Coexistence Tables
72812F76A33X4151Receipt Invoice - Audit Log AGRTransaction Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
73812F76A391C1111Adjustment Indexes - 76AFiles76: Latin American Localization
74812F76A392C2212Calculated costs header - 76AFiles76: Latin American Localization
75812F76A393C3321Calculated costs detail - 76AFiles76: Latin American Localization
76812F76A394C4281Adjustments - 76AFiles76: Latin American Localization
77812F76A395AA91AAI Document Type - Work in Progress Adjustment - 76AFiles76: Latin American Localization
78812F76A396CS152Item Valuation Cost Master - 76AFiles76: Latin American Localization
79812F76A401UT92UTE Members Type - ARG - 04Files76A: Argentina
80812F76A41LD151CERG G/L - Lot Detail - ARG - 09 - - 09Files76A: ArgentinaNo
81812F76A4111IL92Item Ledger Tag File - ARG - 76AFiles76: Latin American Localization
82812F76A411HB0171AP Header Tag File - ARG - 04 - 76AFiles76: Latin American Localization
83812F76A411PB2321Purge A/P Tag Ledger Tag - ARG - 04 - 76AFiles76: Latin American Localization
84812F76A411QB1231F76A411P Tag File Purge - ARG - 04 - 76AFiles76: Latin American Localization
85812F76A411RB4171Voucher Localization Purge Header File - ARG - 04 - 76AFiles76: Latin American Localization
86812F76A411TB1231F760411A A/P Tag File - ARG - 04 - 76AFiles76: Latin American Localization
87812F76A414PV1341Purge - A/P Payment Detail - ARG - 04 - 76AFiles76: Latin American Localization
88812F76A42TF111CERG G/L - Work File - ARG - 09 - 09Files76A: ArgentinaNo
89812F76A43PF11CERG G/L - Bank Conciliation - ARG - 09 - 09Files76A: ArgentinaNo
90812F76A44VP11CERG A/P - Pending Vouchers - ARG - 04 - 04Files76A: ArgentinaNo
91812F76A45PR11CERG A/P - Payments - ARG - 04 - 09Files76A: ArgentinaNo
92812F76A46VP11CERG A/R - Pending Invoices - ARG - 03B - 03BFiles76A: ArgentinaNo
93812F76A47RE11CERG A/R - Receipts - ARG - 03B - 03BFiles76A: ArgentinaNo
94812F76A48PI141CERG A/P - Control Payments -ARG - 04 - 04Files76A: ArgentinaNo
95812F76A49CR141CERG A/R - Control Receipts - ARG - 03B - 03BFiles76A: ArgentinaNo
96812F76A50A1121Processed Documents in Legal Applications - ARG - 00 - 76AFiles76: Latin American Localization
97812F76A60BY201Receipts Header Argentine Tag File - 03BMaster Files76A: ArgentinaAS400 Coexistence Tables
98812F76A60Z1TF251Receipt Header Argentine Tag File Batch Input - 03BFiles76A: ArgentinaAS400 Coexistence Tables
99812F76A7101TA171Batch for Remittance - ARG - 03B - 76AExtra Features Files76: Latin American Localization
100812F76A715PI91Prenumbered Invoice / Shipment Note Print - ARGFiles42: Sales ManagementAS400 Coexistence Tables
101812F76A8000TF21V.A.T. Purchasing Tape File - Argentina 04 - 04PC Download/Batch Edit Files76A: ArgentinaAS400 Coexistence Tables
102812F76A8001V2301Generation SICORE's Files - Last Step -RG 738/99 - 04Files76A: ArgentinaAS400 Coexistence Tables
103812F76A8002V3131SICORE RG738 Withholding EntityFiles04: Accounts PayableAS400 Coexistence Tables
104812F76A8011PA192Supplier Information RG 726 - 04Files76A: ArgentinaAS400 Coexistence Tables
105812F76A8014CT91CITI Report - ARG - - 04Files76A: ArgentinaAS400 Coexistence Tables
106812F76A8015PW51RG814 - Profit Withholding and Payment Order - ARG - 04 - 76AFiles76: Latin American Localization
107812F76A8017TF182A/P Payment Detail Aditional Tag File RG 738 - ARG - 04Files76A: ArgentinaAS400 Coexistence Tables
108812F76A801TV221Withholding SICORE RG 738/99 - Text File - 04Files76A: ArgentinaAS400 Coexistence Tables
109812F76A8020EP121Gross Income Exempt Percentage - ARG - 04 - 76AFiles76: Latin American Localization
110812F76A8021LC71General Local Constants - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
111812F76A802TV321SICORE RG738 Withholding Entity - Text File - 04Files76A: ArgentinaAS400 Coexistence Tables
112812F76A8030MT171Taxes - Minimun Tax By Invoice - ARG - 03B - 76AFiles76: Latin American Localization
113812F76A8050PP171Perceptions Exempt Percentages - 03BFiles76A: ArgentinaAS400 Coexistence Tables
114812F76A8051PE211Perceptions Exempt per Company - 03BFiles76A: ArgentinaAS400 Coexistence Tables
115812F76A8070K7131Profit Withholding - Payments Done - RG 830 - ARG - 0 - 76ATransaction Files76: Latin American Localization
116812F76A8080NN91Certificate Next Number RG 738/99- ARG - 04Files76A: ArgentinaAS400 Coexistence Tables
117812F76A8081CR81Company Relation RG 738/99 - ARG - 04Files76A: ArgentinaAS400 Coexistence Tables
118812F76A8090VP181V.A.T. Witholding Percentage Rg726Files04: Accounts PayableAS400 Coexistence Tables
119812F76A81C5301A/P Payment Control Group File - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
120812F76A82C6421A/P Payment Control Group File - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
121812F76A8230C1171Percentages by state / agreement Gross Income - ARG - - 76AMaster Files76: Latin American Localization
122812F76A8231C261States members by Multilateral Agreement Gross Inc AR - 76AMaster Files76: Latin American Localization
123812F76A8500TF431Tag File F03B14 - ARG - 03B - 76AFiles76: Latin American Localization
124812F76A8510TF311Tag File F76A60 - ARG - 03B - 76AFiles76: Latin American Localization
125812F76A85Z1BE361Tag File F76A60 Batch Entry - ARG - 03B - 76AFiles76: Latin American Localization
126812F76A90R021Sales V.A.T. Tape File - Argentina - 03BTransaction Files76A: ArgentinaAS400 Coexistence Tables
127812F76A9001IB11IIBB Transaction File - ARG - 00Transaction Files00: Foundation EnvironmentAS400 Coexistence Tables
128812F76A93R311IIBB Perception Tape - ARG - 00Transaction Files00: Foundation EnvironmentAS400 Coexistence Tables
129812F76AUI04WC451A/P Tag Legel Tax File - ARG - WFWork Files04: Accounts PayableAS400 Coexistence Tables
130812F76AUI18WF123Taxes - Tax amount by order line - Work File - ARG - 42Work Files42: Sales ManagementAS400 Coexistence Tables
131812F76AUI20HF942Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00Work Files76A: ArgentinaAS400 Coexistence Tables
132812F76AUI21DL581Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00Work Files76A: ArgentinaAS400 Coexistence Tables
133812F76AUI22WF101WF - Legal Reports Errors - ARG - 00Work Files00: Foundation EnvironmentAS400 Coexistence Tables
134812F76AUI23TW71Taxes - Totals by Tax Code - ARGWork Files42: Sales ManagementAS400 Coexistence Tables
135812F76AUI24TI233Taxes Work File - ARG - 00Work Files00: Foundation EnvironmentAS400 Coexistence Tables
136812F76AUI44WF161CERG A/P - Work File - ARG - 04 - 04Files76A: ArgentinaNo
137812F76AUI46WF181CERG A/R -Work File - ARG - 03B - 03BFiles76A: ArgentinaNo
138812F76AUI50WF91VAT Perception Support RG 715 WF - ARG - 04 - 76AFiles76: Latin American Localization
139812F76AUI51IK101Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76AFiles76: Latin American Localization
140812F76AUI81WF592Draft - Invoices Work File - ARG - 03B - 76AWork Files76: Latin American Localization
141812F76AUI82WF493Draft - Drafts Work File - ARG - 03B - 03BWork Files76: Latin American Localization
142812F76AUI83WF664Draft - Application Drafts - Invoices Work File - ARG - 76AWork Files76: Latin American Localization
143812F76AUI84IN51Supplier Without information from Internet - Rg 726Files04: Accounts PayableAS400 Coexistence Tables
144812F76AUI88LI131Work File Last Invoice Number by Month - ARG - 03B - 76AWork Files76: Latin American Localization
145812F76AUI89WF244Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76AFiles76: Latin American Localization
146812F76AUI98CA61Cost Account Work Table - Work in Progress Adjustment - 76AFiles76: Latin American Localization