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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

153 tables920 | 76A

76A: Argentina
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F76001ANC71Next Number File - ARG - 03B - 76AMaster Files76: Latin American LocalizationBusiness Data
2920F76002AJD31JDE/D.G.I. Document Type Relation - ARG - 03B - 76AMaster Files76: Latin American LocalizationBusiness Data
3920F760081AV691SICORE Step 1 & 2 - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
4920F760082AV711SICORE Output File - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
5920F760101AV0231A/B Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
6920F760401AK2121Gross Income Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
7920F760402AK181V.A.T. withholding percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
8920F760403AK3121Profit Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American Localization
9920F760404AK571Profit Withholding Percentage - 4th.Category - ARG - - 76AMaster Files76: Latin American LocalizationBusiness Data
10920F760405AK791Contract Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
11920F760406AK681Profit Withholding - Payments Done - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
12920F760407AK461Gross Income - State Set Up - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
13920F760409AV951Voucher Authorization Rules Maintenance - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
14920F760410AK0101Eventual Services Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
15920F760411AB2321A/P Ledger Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
16920F760414AV1342A/P Payment Detail Tag Table - ARG - 04 - 76ATransaction Files76: Latin American Localization
17920F760472AK941F04572 Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
18920F760473AE5321PCG Detail Information Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
19920F760499AK8143Contract Withholding - Advances - ARG -04 - 76AMaster Files76: Latin American Localization
20920F7607AV4111Withholding Exempt Percentage - ARG - 04 - 04 - 76AMaster Files76: Latin American Localization
21920F7608AV541Supplier State Agreement - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
22920F764008ATQ711Aditionals Tax Areas - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
23920F7691SBAV311CITI A/P Final Step SB Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
24920F76A00T031Taxes - Initial Set Up - ARG - 00 - 76AConstants Files76: Latin American LocalizationBusiness Data
25920F76A003RG111A/P Tag File - CAI Storage - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
26920F76A005RH111CAI - Invoice range for Preprinters - ARG - 03BFiles76A: Argentina
27920F76A010RG191RG 3685 Purchase and Sales Information Workfile - 76A - 00Files76A: Argentina
28920F76A010ZV9261F0101Z2 Argentinean Tag Table - ARG - 01 - 76ABatch Input Files76: Latin American Localization
29920F76A0110U192UTE Members - 76AFiles76: Latin American Localization
30920F76A0209HF942Header & Footer Invoice/ShipmentNote History WF - ARG - 76AFiles76: Latin American Localization
31920F76A020PHF941Header/Footer Inv./ShipmentNote History WF Purge - AR - 76AFiles76: Latin American Localization
32920F76A0219DL581Detail Lines Invoice/ShipmentNote History WF - ARG - - 76AFiles76: Latin American Localization
33920F76A021PDL581Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76AFiles76: Latin American Localization
34920F76A0394R021Sales V.A.T. Tape File - ARG - 03 - 76AFiles76: Latin American Localization
35920F76A0403AW121Additional Profit WithholdingFiles76A: Argentina
36920F76A043RG111A/P Tag Table - CAI Storage - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
37920F76A0440CD151Check details RG 1547 - ARG - 04 - 76AFiles76: Latin American Localization
38920F76A0441TR22TXT File RG1547- ARG - 04 - 76AFiles76: Latin American Localization
39920F76A0444WF32RG1547 Work File - ARG - 04 - 76AFiles76: Latin American Localization
40920F76A0456X181Security Withholding Payments Done - ARGFiles76A: Argentina
41920F76A0494D121Purchasing Flat File - ARG - 04 - 76AFiles76: Latin American Localization
42920F76A050SC92Small Contributor Limits - ARG - 04Files76A: Argentina
43920F76A08CF301Credit Invoice Payments - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
44920F76A09TT623Invoice Total - ARG - 03B - 76ATransaction Files76: Latin American Localization
45920F76A09PTT621Invoice Total Purge - ARG - 03B - 76AFiles76: Latin American LocalizationBusiness Data
46920F76A10TD251Taxes - Tax Definition - ARG - 00 - 76AMaster Files76: Latin American Localization
47920F76A100RG21Autoprinter Supplier Control File - ARG - 04 - 76ATransaction Files76: Latin American Localization
48920F76A11TF42Account ID Relationship - ARG - 00 - 76ATransaction Files76: Latin American LocalizationBusiness Data
49920F76A12TM41Taxes - Minimum Tax By Date - ARG - 00 - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
50920F76A1244FQ131Fixed Assets by Data Type Record - Anexo A - ARG - 12 - 76ATransaction Files76: Latin American Localization
51920F76A13TV101Taxes - Tax Values - ARG - 00 - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
52920F76A14TP21Taxes - Tax Predecessor - ARG - 00 - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
53920F76A15TE51Taxes - Effective and Expiration Dates - ARG - 00 - 76AMaster Files76: Latin American LocalizationBusiness Data
54920F76A16TG62Taxes - Tax Groups - ARG - 00 - 76AMaster Files76: Latin American LocalizationBusiness Data
55920F76A17TL51Taxes - Invoice/Shipment Note Letter - ARG - 03B - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
56920F76A18TO184Taxes - Tax Amounts by Sales Order Line - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
57920F76A18PTO181Taxes - Tax Amounts by Sales Order Line Purge - ARG - - 76ATransaction Files76: Latin American LocalizationBusiness Data
58920F76A19TI214Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
59920F76A19PTI211Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76AFiles76: Latin American Localization
60920F76A19Z1VK391Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76ATransaction Files76: Latin American Localization
61920F76A20IC231Credit Invoice Constants - ARG - 03B - 76AFiles76: Latin American Localization
62920F76A21IH301Credit Invoice Header - F76A21 - ARG - 3B - 76AFiles76: Latin American Localization
63920F76A21PIH301Credit Invoice Header Purge - ARG - 03B - 76AFiles76: Latin American Localization
64920F76A22ID241Credit Invoice Detail - F76A22 - ARG - 03B - 76AFiles76: Latin American Localization
65920F76A22PID241Credit Invoice Detail Purge - ARG - 03B - 76AFiles76: Latin American Localization
66920F76A23IW181Credit Invoice Withholdings - F76A23 - ARG - 03B - 76AFiles76: Latin American Localization
67920F76A23PIW181Credit Invoice Withholdings Purge - ARG - 03B - 76AFiles76: Latin American Localization
68920F76A24IE353Credit Invoice Information - Accounts Payable - ARG - - 76AFiles76: Latin American Localization
69920F76A25IF132Credit Invoice Tax Area Relationship - ARG - 04 - 76AFiles76: Latin American Localization
70920F76A26IG142Credit Invoice Status Rules - ARG - 04 - 76AFiles76: Latin American Localization
71920F76A30V8321F0411Z1 Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
72920F76A30HV6111EDI Batch Input Localization File - ARG - 04 - 76AFiles76: Latin American Localization
73920F76A30TV7211F76A30 Tag File Z1 - ARG - 04 - 76AFiles76: Latin American Localization
74920F76A32X322A/P Account ID Relationship - ARG - 04 - 76ATransaction Files76: Latin American Localization
75920F76A33X4151Receipt Invoice - Audit Log ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
76920F76A391C1111Adjustment Indexes - 76AFiles76: Latin American Localization
77920F76A392C2212Calculated costs header - 76AFiles76: Latin American Localization
78920F76A393C3321Calculated costs detail - 76AFiles76: Latin American Localization
79920F76A394C4281Adjustments - 76AFiles76: Latin American Localization
80920F76A395AA91AAI Document Type - Work in Progress Adjustment - 76AFiles76: Latin American Localization
81920F76A396CS152Item Valuation Cost Master - 76AFiles76: Latin American Localization
82920F76A40WC335Withholding Certificates Legal Number - 76AFiles76A: Argentina
83920F76A401UT92UTE Members Type - ARG - 04Files76A: Argentina
84920F76A405SE71Small Contributors that Exceeded the Limit - ARG - 04Files76A: Argentina
85920F76A41LD151CERG G/L - Lot Detail - ARG - 09 - 76AFiles76: Latin American Localization
86920F76A4111IL92Item Ledger Tag File - ARG - 76AFiles76: Latin American Localization
87920F76A411HB0171AP Header Tag File - ARG - 04 - 76AFiles76: Latin American Localization
88920F76A411PB2321Purge A/P Tag Ledger Tag - ARG - 04 - 76AFiles76: Latin American Localization
89920F76A411QB1231F76A411P Tag File Purge - ARG - 04 - 76AFiles76: Latin American Localization
90920F76A411RB4171Voucher Localization Purge Header File - ARG - 04 - 76AFiles76: Latin American Localization
91920F76A411TB1231F760411A A/P Tag File - ARG - 04 - 76AFiles76: Latin American Localization
92920F76A414PV1341Purge - A/P Payment Detail - ARG - 04 - 76AFiles76: Latin American Localization
93920F76A42TF111CERG G/L - Work File - ARG - 09 - 76AFiles76: Latin American Localization
94920F76A43PF11CERG G/L - Bank Conciliation - ARG - 09 - 76AFiles76: Latin American Localization
95920F76A430PD121Contract Service Withholding - Payments Done - ARG - 04Files76A: Argentina
96920F76A44VP11CERG A/P - Pending Vouchers - ARG - 04 - 76AFiles76: Latin American Localization
97920F76A45PR11CERG A/P - Payments - ARG - 04 - 76AFiles76: Latin American Localization
98920F76A46VP11CERG A/R - Pending Invoices - ARG - 03B - 76AFiles76: Latin American Localization
99920F76A47RE11CERG A/R - Receipts - ARG - 03B - 76AFiles76: Latin American Localization
100920F76A48PI141CERG A/P - Control Payments -ARG - 04 - 76AFiles76: Latin American Localization
101920F76A49CR141CERG A/R - Control Receipts - ARG - 03B - 76AFiles76: Latin American Localization
102920F76A50A1121Processed Documents in Legal Applications - ARG - 00 - 76AFiles76: Latin American Localization
103920F76A55HW141Withholding Certificates Legal Number History Files - 76AFiles76A: Argentina
104920F76A60BY201Receipts Header Argentine Tag File - 03B - 76AMaster Files76: Latin American Localization
105920F76A60Z1TF251Receipt Header Argentine Tag File Batch Input - ARG - - 76AFiles76: Latin American Localization
106920F76A7101TA171Batch for Remittance - ARG - 03B - 76AExtra Features Files76: Latin American Localization
107920F76A715PI91Prenumbered Invoice / Shipment Note Print - ARG - 42 - 76AFiles76: Latin American LocalizationBusiness Data
108920F76A8000TF21VAT Purchasing Tape - Argentina - ARG - 04 - 76APC Download/Batch Edit Files76: Latin American Localization
109920F76A8001V2301Generation SICORE's - Last Step -RG 738/99 - ARG - 04 - 76AFiles76: Latin American Localization
110920F76A8002V3131SICORE RG738 Withholding Entity - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
111920F76A8011PA192Supplier Information RG 726 - ARG - 04 - 76AFiles76: Latin American Localization
112920F76A8014CT91CITI Report - ARG - 04 - 76AFiles76: Latin American Localization
113920F76A8015PW51RG814 - Profit Withholding & Payment Order - ARG - 04 - 76AFiles76: Latin American Localization
114920F76A8017TF182A/P Payment Detail Aditional Tag Table RG 738 - ARG - - 76AFiles76: Latin American Localization
115920F76A801TV221Withholding SICORE RG 738/99 - Text Table - 04 - 76AFiles76: Latin American Localization
116920F76A8020EP121Gross Income Exempt Percentage - ARG - 04 - 76AFiles76: Latin American Localization
117920F76A8021LC71General Local Constants - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
118920F76A802TV321SICORE RG738 Withholding Entity - Text Table - ARG - - 76AFiles76: Latin American Localization
119920F76A8030MT171Taxes - Minimun Tax By Invoice - ARG - 03B - 76AFiles76: Latin American Localization
120920F76A8050PP171Perceptions Exempt Percentages - ARG - 03B - 76AFiles76: Latin American Localization
121920F76A8051PE211Perceptions Exempt per Company - ARG - 03B - 76AFiles76: Latin American Localization
122920F76A8070K7131Profit Withholding - Payments Done - RG 830 - ARG - 0 - 76ATransaction Files76: Latin American Localization
123920F76A8080NN91Certificate Next Number RG 738/99- ARG - 04 - 76AFiles76: Latin American Localization
124920F76A8081CR81Company Relation RG 738/99 - ARG - 04 - 76AFiles76: Latin American Localization
125920F76A8090VP181V.A.T. Witholding Percentage Rg726 - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
126920F76A81C5301A/P Payment Control Group File - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
127920F76A82C6421A/P Payment Control Group File - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
128920F76A8230C1171Percentages by state / agreement Gross Income - ARG - - 76AMaster Files76: Latin American Localization
129920F76A8231C261States members by Multilateral Agreement Gross Inc AR - 76AMaster Files76: Latin American Localization
130920F76A8500TF431Tag File F03B14 - ARG - 03B - 76AFiles76: Latin American Localization
131920F76A8510TF311Tag File F76A60 - ARG - 03B - 76AFiles76: Latin American Localization
132920F76A85Z1BE361Tag File F76A60 Batch Entry - ARG - 03B - 76AFiles76: Latin American Localization
133920F76A90R021Sales V.A.T. Tape File - ARG - 03B - 76ATransaction Files76: Latin American Localization
134920F76A9001IB11IIBB Transaction File - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
135920F76A93R311IIBB Perception Tape - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
136920F76AUI04WC451A/P Legel Tax Tag Table - ARG - 04 - 76AWork Files76: Latin American LocalizationBusiness Data
137920F76AUI18WF123Taxes - Tax amount by order line - Work File - ARG - - 76AWork Files76: Latin American LocalizationBusiness Data
138920F76AUI20HF942Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76AWork Files76: Latin American Localization
139920F76AUI21DL581Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76AWork Files76: Latin American Localization
140920F76AUI22WF101WF - Legal Reports Errors - ARG - 03B - 76AWork Files76: Latin American LocalizationBusiness Data
141920F76AUI23TW71Taxes - Totals by Tax Code - ARG - 42 - 76AWork Files76: Latin American LocalizationBusiness Data
142920F76AUI24TI233Taxes Work File - ARG - 03B - 76AWork Files76: Latin American LocalizationBusiness Data
143920F76AUI44WF161CERG A/P - Worktable - ARG - 04 - 76AFiles76: Latin American Localization
144920F76AUI46WF181CERG A/R -Work File - ARG - 03B - 76AFiles76: Latin American Localization
145920F76AUI50WF91VAT Perception Support RG 715 WF - ARG - 04 - 76AFiles76: Latin American Localization
146920F76AUI51IK101Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76AFiles76: Latin American Localization
147920F76AUI81WF592Draft - Invoices Work File - ARG - 03B - 76AWork Files76: Latin American Localization
148920F76AUI82WF493Draft - Drafts Work File - ARG - 03B - 03BWork Files76: Latin American Localization
149920F76AUI83WF664Draft - Application Drafts - Invoices Work File - ARG - 76AWork Files76: Latin American Localization
150920F76AUI84IN51Supplier Without information from Internet - Rg 726 A - 76AFiles76: Latin American LocalizationBusiness Data
151920F76AUI88LI131Work File Last Invoice Number by Month - ARG - 03B - 76AWork Files76: Latin American Localization
152920F76AUI89WF244Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76AFiles76: Latin American Localization
153920F76AUI98CA61Cost Account Work Table - Work in Progress Adjustment - 76AFiles76: Latin American Localization