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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

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

149 tables910 | 76A

76A: Argentina
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F76001ANC71Next Number File - ARG - 03B - 76AMaster Files76: Latin American LocalizationBusiness Data
2910F76002AJD31JDE/D.G.I. Document Type Relation - ARG - 03B - 76AMaster Files76: Latin American LocalizationBusiness Data
3910F760081AV691SICORE Step 1 & 2 - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
4910F760082AV711SICORE Output File - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
5910F760101AV0231A/B Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
6910F760401AK2121Gross Income Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
7910F760402AK181V.A.T. withholding percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
8910F760403AK3121Profit Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American Localization
9910F760404AK571Profit Withholding Percentage - 4th.Category - ARG - - 76AMaster Files76: Latin American LocalizationBusiness Data
10910F760405AK791Contract Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
11910F760406AK681Profit Withholding - Payments Done - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
12910F760407AK461Gross Income - State Set Up - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
13910F760409AV951Voucher Authorization Rules Maintenance - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
14910F760410AK0101Eventual Services Withholding Percentage - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
15910F760411AB2321A/P Ledger Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
16910F760414AV1342A/P Payment Detail Tag Table - ARG - 04 - 76ATransaction Files76: Latin American Localization
17910F760472AK941F04572 Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
18910F760473AE5321PCG Detail Information Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
19910F760499AK8143Contract Withholding - Advances - ARG -04 - 76AMaster Files76: Latin American Localization
20910F7607AV4111Withholding Exempt Percentage - ARG - 04 - 04 - 76AMaster Files76: Latin American Localization
21910F7608AV541Supplier State Agreement - ARG - 04 - 76AMaster Files76: Latin American LocalizationBusiness Data
22910F764008ATQ711Aditionals Tax Areas - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
23910F7691SBAV311CITI A/P Final Step SB Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
24910F76A00T031Taxes - Initial Set Up - ARG - 00 - 76AConstants Files76: Latin American LocalizationBusiness Data
25910F76A003RG111A/P Tag File - CAI Storage - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
26910F76A005RH111CAI - Invoice range for Preprinters - ARG - 03BFiles76A: Argentina
27910F76A010ZV9261F0101Z2 Argentinean Tag Table - ARG - 01 - 76ABatch Input Files76: Latin American Localization
28910F76A0110U192UTE Members - 76AFiles76: Latin American Localization
29910F76A0209HF942Header & Footer Invoice/ShipmentNote History WF - ARG - 76AFiles76: Latin American Localization
30910F76A020PHF941Header/Footer Inv./ShipmentNote History WF Purge - AR - 76AFiles76: Latin American Localization
31910F76A0219DL581Detail Lines Invoice/ShipmentNote History WF - ARG - - 76AFiles76: Latin American Localization
32910F76A021PDL581Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76AFiles76: Latin American Localization
33910F76A0394R021Sales V.A.T. Tape File - ARG - 03 - 76AFiles76: Latin American Localization
34910F76A043RG111A/P Tag Table - CAI Storage - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
35910F76A0440CD151Check details RG 1547 - ARG - 04 - 76AFiles76: Latin American Localization
36910F76A0441TR22TXT File RG1547- ARG - 04 - 76AFiles76: Latin American Localization
37910F76A0444WF32RG1547 Work File - ARG - 04 - 76AFiles76: Latin American Localization
38910F76A0456X181Security Withholding Payments Done - ARGFiles76A: Argentina
39910F76A0494D121Purchasing Flat File - ARG - 04 - 76AFiles76: Latin American Localization
40910F76A050SC92Small Contributor Limits - ARG - 04Files76A: Argentina
41910F76A08CF301Credit Invoice Payments - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
42910F76A09TT623Invoice Total - ARG - 03B - 76ATransaction Files76: Latin American Localization
43910F76A09PTT621Invoice Total Purge - ARG - 03B - 76AFiles76: Latin American LocalizationBusiness Data
44910F76A10TD251Taxes - Tax Definition - ARG - 00 - 76AMaster Files76: Latin American Localization
45910F76A100RG21Autoprinter Supplier Control File - ARG - 04 - 76ATransaction Files76: Latin American Localization
46910F76A11TF42Account ID Relationship - ARG - 00 - 76ATransaction Files76: Latin American LocalizationBusiness Data
47910F76A12TM41Taxes - Minimum Tax By Date - ARG - 00 - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
48910F76A1244FQ131Fixed Assets by Data Type Record - Anexo A - ARG - 12 - 76ATransaction Files76: Latin American Localization
49910F76A13TV101Taxes - Tax Values - ARG - 00 - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
50910F76A14TP21Taxes - Tax Predecessor - ARG - 00 - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
51910F76A15TE51Taxes - Effective and Expiration Dates - ARG - 00 - 76AMaster Files76: Latin American LocalizationBusiness Data
52910F76A16TG62Taxes - Tax Groups - ARG - 00 - 76AMaster Files76: Latin American LocalizationBusiness Data
53910F76A17TL51Taxes - Invoice/Shipment Note Letter - ARG - 03B - 76ASecondary Master Files76: Latin American LocalizationBusiness Data
54910F76A18TO184Taxes - Tax Amounts by Sales Order Line - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
55910F76A18PTO181Taxes - Tax Amounts by Sales Order Line Purge - ARG - - 76ATransaction Files76: Latin American LocalizationBusiness Data
56910F76A19TI214Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
57910F76A19PTI211Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76AFiles76: Latin American Localization
58910F76A19Z1VK391Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76ATransaction Files76: Latin American Localization
59910F76A20IC231Credit Invoice Constants - ARG - 03B - 76AFiles76: Latin American Localization
60910F76A21IH301Credit Invoice Header - F76A21 - ARG - 3B - 76AFiles76: Latin American Localization
61910F76A21PIH301Credit Invoice Header Purge - ARG - 03B - 76AFiles76: Latin American Localization
62910F76A22ID241Credit Invoice Detail - F76A22 - ARG - 03B - 76AFiles76: Latin American Localization
63910F76A22PID241Credit Invoice Detail Purge - ARG - 03B - 76AFiles76: Latin American Localization
64910F76A23IW181Credit Invoice Withholdings - F76A23 - ARG - 03B - 76AFiles76: Latin American Localization
65910F76A23PIW181Credit Invoice Withholdings Purge - ARG - 03B - 76AFiles76: Latin American Localization
66910F76A24IE353Credit Invoice Information - Accounts Payable - ARG - - 76AFiles76: Latin American Localization
67910F76A25IF132Credit Invoice Tax Area Relationship - ARG - 04 - 76AFiles76: Latin American Localization
68910F76A26IG142Credit Invoice Status Rules - ARG - 04 - 76AFiles76: Latin American Localization
69910F76A30V8321F0411Z1 Tag Table - ARG - 04 - 76ATransaction Files76: Latin American LocalizationBusiness Data
70910F76A30HV6111EDI Batch Input Localization File - ARG - 04 - 76AFiles76: Latin American Localization
71910F76A30TV7211F76A30 Tag File Z1 - ARG - 04 - 76AFiles76: Latin American Localization
72910F76A32X322A/P Account ID Relationship - ARG - 04 - 76ATransaction Files76: Latin American Localization
73910F76A33X4151Receipt Invoice - Audit Log ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
74910F76A391C1111Adjustment Indexes - 76AFiles76: Latin American Localization
75910F76A392C2212Calculated costs header - 76AFiles76: Latin American Localization
76910F76A393C3321Calculated costs detail - 76AFiles76: Latin American Localization
77910F76A394C4281Adjustments - 76AFiles76: Latin American Localization
78910F76A395AA91AAI Document Type - Work in Progress Adjustment - 76AFiles76: Latin American Localization
79910F76A396CS152Item Valuation Cost Master - 76AFiles76: Latin American Localization
80910F76A401UT92UTE Members Type - ARG - 04Files76A: Argentina
81910F76A405SE71Small Contributors that Exceeded the Limit - ARG - 04Files76A: Argentina
82910F76A41LD151CERG G/L - Lot Detail - ARG - 09 - 76AFiles76: Latin American Localization
83910F76A4111IL92Item Ledger Tag File - ARG - 76AFiles76: Latin American Localization
84910F76A411HB0171AP Header Tag File - ARG - 04 - 76AFiles76: Latin American Localization
85910F76A411PB2321Purge A/P Tag Ledger Tag - ARG - 04 - 76AFiles76: Latin American Localization
86910F76A411QB1231F76A411P Tag File Purge - ARG - 04 - 76AFiles76: Latin American Localization
87910F76A411RB4171Voucher Localization Purge Header File - ARG - 04 - 76AFiles76: Latin American Localization
88910F76A411TB1231F760411A A/P Tag File - ARG - 04 - 76AFiles76: Latin American Localization
89910F76A414PV1341Purge - A/P Payment Detail - ARG - 04 - 76AFiles76: Latin American Localization
90910F76A42TF111CERG G/L - Work File - ARG - 09 - 76AFiles76: Latin American Localization
91910F76A43PF11CERG G/L - Bank Conciliation - ARG - 09 - 76AFiles76: Latin American Localization
92910F76A430PD121Contract Service Withholding - Payments Done - ARG - 04Files76A: Argentina
93910F76A44VP11CERG A/P - Pending Vouchers - ARG - 04 - 76AFiles76: Latin American Localization
94910F76A45PR11CERG A/P - Payments - ARG - 04 - 76AFiles76: Latin American Localization
95910F76A46VP11CERG A/R - Pending Invoices - ARG - 03B - 76AFiles76: Latin American Localization
96910F76A47RE11CERG A/R - Receipts - ARG - 03B - 76AFiles76: Latin American Localization
97910F76A48PI141CERG A/P - Control Payments -ARG - 04 - 76AFiles76: Latin American Localization
98910F76A49CR141CERG A/R - Control Receipts - ARG - 03B - 76AFiles76: Latin American Localization
99910F76A50A1121Processed Documents in Legal Applications - ARG - 00 - 76AFiles76: Latin American Localization
100910F76A60BY201Receipts Header Argentine Tag File - 03B - 76AMaster Files76: Latin American Localization
101910F76A60Z1TF251Receipt Header Argentine Tag File Batch Input - ARG - - 76AFiles76: Latin American Localization
102910F76A7101TA171Batch for Remittance - ARG - 03B - 76AExtra Features Files76: Latin American Localization
103910F76A715PI91Prenumbered Invoice / Shipment Note Print - ARG - 42 - 76AFiles76: Latin American LocalizationBusiness Data
104910F76A8000TF21VAT Purchasing Tape - Argentina - ARG - 04 - 76APC Download/Batch Edit Files76: Latin American Localization
105910F76A8001V2301Generation SICOREs - Last Step -RG 738/99 - ARG - 04 - 76AFiles76: Latin American Localization
106910F76A8002V3131SICORE RG738 Withholding Entity - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
107910F76A8011PA192Supplier Information RG 726 - ARG - 04 - 76AFiles76: Latin American Localization
108910F76A8014CT91CITI Report - ARG - 04 - 76AFiles76: Latin American Localization
109910F76A8015PW51RG814 - Profit Withholding & Payment Order - ARG - 04 - 76AFiles76: Latin American Localization
110910F76A8017TF182A/P Payment Detail Aditional Tag Table RG 738 - ARG - - 76AFiles76: Latin American Localization
111910F76A801TV221Withholding SICORE RG 738/99 - Text Table - 04 - 76AFiles76: Latin American Localization
112910F76A8020EP121Gross Income Exempt Percentage - ARG - 04 - 76AFiles76: Latin American Localization
113910F76A8021LC71General Local Constants - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
114910F76A802TV321SICORE RG738 Withholding Entity - Text Table - ARG - - 76AFiles76: Latin American Localization
115910F76A8030MT171Taxes - Minimun Tax By Invoice - ARG - 03B - 76AFiles76: Latin American Localization
116910F76A8050PP171Perceptions Exempt Percentages - ARG - 03B - 76AFiles76: Latin American Localization
117910F76A8051PE211Perceptions Exempt per Company - ARG - 03B - 76AFiles76: Latin American Localization
118910F76A8070K7131Profit Withholding - Payments Done - RG 830 - ARG - 0 - 76ATransaction Files76: Latin American Localization
119910F76A8080NN91Certificate Next Number RG 738/99- ARG - 04 - 76AFiles76: Latin American Localization
120910F76A8081CR81Company Relation RG 738/99 - ARG - 04 - 76AFiles76: Latin American Localization
121910F76A8090VP181V.A.T. Witholding Percentage Rg726 - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
122910F76A81C5301A/P Payment Control Group File - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
123910F76A82C6421A/P Payment Control Group File - ARG - 04 - 76AFiles76: Latin American LocalizationBusiness Data
124910F76A8230C1171Percentages by state / agreement Gross Income - ARG - - 76AMaster Files76: Latin American Localization
125910F76A8231C261States members by Multilateral Agreement Gross Inc AR - 76AMaster Files76: Latin American Localization
126910F76A8500TF431Tag File F03B14 - ARG - 03B - 76AFiles76: Latin American Localization
127910F76A8510TF311Tag File F76A60 - ARG - 03B - 76AFiles76: Latin American Localization
128910F76A85Z1BE361Tag File F76A60 Batch Entry - ARG - 03B - 76AFiles76: Latin American Localization
129910F76A90R021Sales V.A.T. Tape File - ARG - 03B - 76ATransaction Files76: Latin American Localization
130910F76A9001IB11IIBB Transaction File - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
131910F76A93R311IIBB Perception Tape - ARG - 03B - 76ATransaction Files76: Latin American LocalizationBusiness Data
132910F76AUI04WC451A/P Legel Tax Tag Table - ARG - 04 - 76AWork Files76: Latin American LocalizationBusiness Data
133910F76AUI18WF123Taxes - Tax amount by order line - Work File - ARG - - 76AWork Files76: Latin American LocalizationBusiness Data
134910F76AUI20HF942Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76AWork Files76: Latin American Localization
135910F76AUI21DL581Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76AWork Files76: Latin American Localization
136910F76AUI22WF101WF - Legal Reports Errors - ARG - 03B - 76AWork Files76: Latin American LocalizationBusiness Data
137910F76AUI23TW71Taxes - Totals by Tax Code - ARG - 42 - 76AWork Files76: Latin American LocalizationBusiness Data
138910F76AUI24TI233Taxes Work File - ARG - 03B - 76AWork Files76: Latin American LocalizationBusiness Data
139910F76AUI44WF161CERG A/P - Worktable - ARG - 04 - 76AFiles76: Latin American Localization
140910F76AUI46WF181CERG A/R -Work File - ARG - 03B - 76AFiles76: Latin American Localization
141910F76AUI50WF91VAT Perception Support RG 715 WF - ARG - 04 - 76AFiles76: Latin American Localization
142910F76AUI51IK101Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76AFiles76: Latin American Localization
143910F76AUI81WF592Draft - Invoices Work File - ARG - 03B - 76AWork Files76: Latin American Localization
144910F76AUI82WF493Draft - Drafts Work File - ARG - 03B - 03BWork Files76: Latin American Localization
145910F76AUI83WF664Draft - Application Drafts - Invoices Work File - ARG - 76AWork Files76: Latin American Localization
146910F76AUI84IN51Supplier Without information from Internet - Rg 726 A - 76AFiles76: Latin American LocalizationBusiness Data
147910F76AUI88LI131Work File Last Invoice Number by Month - ARG - 03B - 76AWork Files76: Latin American Localization
148910F76AUI89WF244Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76AFiles76: Latin American Localization
149910F76AUI98CA61Cost Account Work Table - Work in Progress Adjustment - 76AFiles76: Latin American Localization