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

139 columns | Print definition?920 | ICUT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0011Batch Control Records1ICICUTBatch TypeStringUDC20
2F0011WF0011W - WF - Batch To Detail1ICICUTBatch TypeStringUDC20
3F0018Taxes51TDICUTBatch TypeStringUDC20
4F007021WTransactions to Batch Headers Work Table4TBICUTBatch TypeStringUDC20
5F007032WBatches Out Of Balance Work Table4OBICUTBatch TypeStringUDC20
6F0911Account Ledger9GLICUTBatch TypeStringUDC20
TOP03: Accounts Receivable
7F0311Accounts Receivable Ledger16RPICUTBatch TypeStringUDC20
8F0312A/R Batch Cash Application3RUICUTBatch TypeStringUDC20
TOP03B: Enhanced Accounts Receivable
9F03B11Customer Ledger8RPICUTBatch TypeStringUDC20
10F03B112Invoice Revisions18RWICUTBatch TypeStringUDC20
11F03B112PInvoice Revisions Purge File18RWICUTBatch TypeStringUDC20
12F03B117Revenue Recognition GL Info12RLICUTBatch TypeStringUDC20
13F03B119Revenue Recognition GL Info Audit24RNICUTBatch TypeStringUDC20
14F03B11PCustomer Ledger Purge File8RPICUTBatch TypeStringUDC20
15F03B11Z1Batch Invoices26VJICUTBatch TypeStringUDC20
16F03B11Z2F03B11 Interoperability Table21SYICUTBatch TypeStringUDC20
17F03B13Receipts Header18RYICUTBatch TypeStringUDC20
18F03B13PReceipts Header Purge File18RYICUTBatch TypeStringUDC20
19F03B13Z1Electronic Receipts Input16RUICUTBatch TypeStringUDC20
20F03B13Z2F03B13 Interoperability Table31SYICUTBatch TypeStringUDC20
21F03B14Receipts Detail19RZICUTBatch TypeStringUDC20
22F03B14PReceipts Detail Purge File19RZICUTBatch TypeStringUDC20
23F03B14Z2F03B14 Interoperability Table32SZICUTBatch TypeStringUDC20
24F03B571Auto Debit Batch Control6RCICUTBatch TypeStringUDC20
25F03B575Auto Debit Invoice Select and Build11RDICUTBatch TypeStringUDC20
26F03B672Draft Remittance21RDICUTBatch TypeStringUDC20
27F03BUI05Auto Receipts Batch Workfile3R5ICUTBatch TypeStringUDC20
28F09UI011Receipt Prepost Work File6GLICUTBatch TypeStringUDC20
TOP04: Accounts Payable
29F0411Accounts Payable Ledger20RPICUTBatch TypeStringUDC20
30F0411AWF - 'As Of' Accounts Payable Ledger20RPICUTBatch TypeStringUDC20
31F0411PPurge - Accounts Payable Ledger20RPICUTBatch TypeStringUDC20
32F0411Z1Voucher Transactions - Batch Upload38VLICUTBatch TypeStringUDC20
33F0411Z3F0411 Interoperability Table42SZICUTBatch TypeStringUDC20
34F0413Accounts Payable - Matching Document9RMICUTBatch TypeStringUDC20
35F0413AWF - 'As Of' Accounts Payable Payment Register9RMICUTBatch TypeStringUDC20
36F0413PPurge - Accounts Payable Matching Documents9RMICUTBatch TypeStringUDC20
37F0413Z1F0413 Interoperability Table23SYICUTBatch TypeStringUDC20
38F09UI005Tax Offsets User Index4GLICUTBatch TypeStringUDC20
39F09UI006Tax (F0018) Replica51TDICUTBatch TypeStringUDC20
TOP09: General Accounting
40F0911PPurge - Account Ledger9GLICUTBatch TypeStringUDC20
41F0911RWF - Account Ledger Reconciliation9GLICUTBatch TypeStringUDC20
42F0911Z1Journal Entry Transactions - Batch File26VNICUTBatch TypeStringUDC20
43F0911Z4F0911 Interoperability Table31SZICUTBatch TypeStringUDC20
44F097021WAccount Ledger to Account Master Work Table10TAICUTBatch TypeStringUDC20
45F09706WBatch and Company Within Batch Out of Balance Work Table4NBICUTBatch TypeStringUDC20
46F09UI004Variable Numerator Allocations work file2R#ICUTBatch TypeStringUDC20
47F09UI013Company by Batch Out of Balance1GLICUTBatch TypeStringUDC20
48F09UI015Indexed Computations Multi-Tiered Entries9GLICUTBatch TypeStringUDC20
49F09UI618Auto Bank Statement Process Work Table20NBICUTBatch TypeStringUDC20
50F52G11Burdening Detail Ledger53BDICUTBatch TypeStringUDC20
51F70UI001Work File for G/L by Cat. Code Localization22WAICUTBatch TypeStringUDC20
52F740911Work File for G/L Report by Category Code Localization26WAICUTBatch TypeStringUDC20
TOP11C: Cash Basis
53F11CUI01A/R Cash Basis Work File3CBICUTBatch TypeStringUDC20
54F11CUI02A/P Cash Basis Work File3CBICUTBatch TypeStringUDC20
TOP15: Real Estate Management
55F1511B1Billing Batches Summary2NWICUTBatch TypeStringUDC20
56F1540Sales Report Control File12NRICUTBatch TypeStringUDC20
57F1540BSales Report Control22NRICUTBatch TypeStringUDC20
TOP31: Shop Floor Control
58F3106W.O. Cross Reference File6SDICUTBatch TypeStringUDC20
TOP38: Agreement Management
59F38111Agreements Transaction Ledger57DZICUTBatch TypeStringUDC20
TOP39: Advanced Stock Valuation
60F3910G/L Adjustment Table18SCICUTBatch TypeStringUDC20
TOP41: Inventory Management
61F41UI001Inventory Transactions Detail File11ITICUTBatch TypeStringUDC20
TOP42: Sales Management
62F42800GSales Update G Batch Workfile4SGICUTBatch TypeStringUDC20
TOP43: Procurement
63F43092ZReceipt Routing Work File17PVICUTBatch TypeStringUDC20
TOP43S: JSSS/Supplier Self Service
64F4313POFLIP24PFICUTBatch TypeStringUDC20
TOP45: Advanced Pricing
65F4575Ship and Debit History62AHICUTBatch TypeStringUDC20
66F4575TMPShip and Debit History - Temp Table62AHICUTBatch TypeStringUDC20
67F4576Ship and Debit Claims55ACICUTBatch TypeStringUDC20
68F4576TMPShip and Debit Claims- Temp Table55ACICUTBatch TypeStringUDC20
69F4576Z1Ship and Debit Claims Unedited Transaction Table86Z1ICUTBatch TypeStringUDC20
TOP47: Electronic Commerce
70F47056EDI Payment Order Header - Outbound16D1ICUTBatch TypeStringUDC20
71F470561EDI Payment Order Bank N & A - Outbound10D2ICUTBatch TypeStringUDC20
72F470561WEDI Payment Order Bank N & A - Work12D2ICUTBatch TypeStringUDC20
73F470562EDI Payment Order Vendor N & A - Outbound10D4ICUTBatch TypeStringUDC20
74F470562WEDI Payment Order Vendor N & A - Work10D4ICUTBatch TypeStringUDC20
75F470563EDI Payment Order Payee N & A - Outbound10D5ICUTBatch TypeStringUDC20
76F470563WEDI Payment Order Payee N & A - Work10D5ICUTBatch TypeStringUDC20
77F47056WEDI Payment Order Header - Work16D1ICUTBatch TypeStringUDC20
78F47057EDI Payment Order Remittance Advice - Outbound16D3ICUTBatch TypeStringUDC20
79F47057WEDI Payment Order Remittance Advice - Work16D3ICUTBatch TypeStringUDC20
80F47112EDI Lockbox Header - Transaction25Z2ICUTBatch TypeStringUDC20
81F47113EDI Lockbox/Payment Detail - Batch28Z3ICUTBatch TypeStringUDC20
TOP52: Contract Billing
82F5216Milestone/Progress Billing Information25A6ICUTBatch TypeStringUDC20
83F52161Mileston/Progress Billing Line Cross Reference Details12A7ICUTBatch TypeStringUDC20
TOP70: Multi-National Products
84F704100Suspended VAT AP - COMM - 7010VAICUTBatch TypeStringUDC20
85F704200Final VAT AP - COMM - 7011FVICUTBatch TypeStringUDC20
TOP74: EMEA Localization
86F740018DData extraction ESL - 7426DEICUTBatch TypeStringUDC20
87F740018WData extraction ESL - Workfile - 7426DEICUTBatch TypeStringUDC20
88F74093Worktable for Printing IVA Summary - Italy50HCICUTBatch TypeStringUDC20
89F74900Foreign Receivables and Payables - EMEA14RPICUTBatch TypeStringUDC20
TOP74F: France
90F74F210FEC - Last Sequence Number by CO-Fiscal Period - FR3FPICUTBatch TypeStringUDC20
TOP74H: Hungary
91F74H309Gains & Losses Unrealized Account ing - HUN - 03B13GLICUTBatch TypeStringUDC20
92F74H409A/P Gains & Losses Unrealized Accounting - HUN - 0413GLICUTBatch TypeStringUDC20
93F74H910JE VAT Differences - HUN - 099VDICUTBatch TypeStringUDC20
TOP74P: Poland
94F74P9100Cash Desk Transaction - POL - 74P13CDICUTBatch TypeStringUDC20
TOP74R: Russia
95F74R0011Batch Tag File - RUS - 09 - 74R1ICICUTBatch TypeStringUDC20
96F74R0100Petty Cash Transactions - RUS - 00 - 74R14PCICUTBatch TypeStringUDC20
97F74R311Prepayment Detail Tax File - RUS - 03B26DEICUTBatch TypeStringUDC20
98F74R410Tax on Hold - RUS - 0416THICUTBatch TypeStringUDC20
99F74R9003Correspondence Method - RUS -09 - 74R2CMICUTBatch TypeStringUDC20
100F74R9004Correspondence Rules - RUS -09 - 74R2CRICUTBatch TypeStringUDC20
101F74R9011Correspondence Rules - RUS -09 - 74R16CRICUTBatch TypeStringUDC20
TOP74U: United Kingdom Localizations
102F74U0420SPC - Application Master - UK - 4328SEICUTBatch TypeStringUDC20
103F74U0425SPC - Certificate Master - UK - 4330SFICUTBatch TypeStringUDC20
TOP74Y: Italy
104F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B8TIICUTBatch TypeStringUDC20
105F74Y015Yearly List Declaration - WF - IT - 0018YLICUTBatch TypeStringUDC20
TOP74Z: Czech Republic
106F74Z0010Cash Desk Document Printed - CZE - 74Z8ZOICUTBatch TypeStringUDC20
107F74ZUI01Corresponding Accounts5CZICUTBatch TypeStringUDC20
TOP75C: China
108F75C015Cash Flow Data - China11CFICUTBatch TypeStringUDC20
109F75C4203Chinese VAT on Free Goods Cross Reference - China - 4210FCICUTBatch TypeStringUDC20
TOP75I: India
110F75I611TCS Prepayment Transaction File - IND-03B16TTICUTBatch TypeStringUDC20
111F75I732Service Tax A/R File Additional Info - IND - 03B12STICUTBatch TypeStringUDC20
112F75I742Service Tax A/P File Additional Info - IND - 0413STICUTBatch TypeStringUDC20
113F75IUI7Service Tax Credit Register - Work File - IND11WFICUTBatch TypeStringUDC20
TOP76A: Argentina
114F76A4111Item Ledger Tag File - ARG - 76A2ILICUTBatch TypeStringUDC20
115F76AUI81Draft - Invoices Work File - ARG - 03B - 76A25WFICUTBatch TypeStringUDC20
116F76AUI82Draft - Drafts Work File - ARG - 03B - 03B28WFICUTBatch TypeStringUDC20
117F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A37WFICUTBatch TypeStringUDC20
TOP76B: Brazil
118F76B011Nota Fiscal Taxes Detail - Brazil - 4232TDICUTBatch TypeStringUDC20
119F76B835FCONT Account Ledger Operation - 76B2AOICUTBatch TypeStringUDC20
TOP76C: Colombia
120F76C031AA/R Customer ledger As Of - F76C031A - COL - 048RPICUTBatch TypeStringUDC20
121F76C034AA/R Check Detail file As Of - COL - 03B19RZICUTBatch TypeStringUDC20
122F76C575Work File Magnetic Media - COL - 042Q1ICUTBatch TypeStringUDC20
123F76C9415Workfile for Dialy Book - COL - 093LDICUTBatch TypeStringUDC20
124F76C9F02DIAN Formats by AccountID - COL - 0910DFICUTBatch TypeStringUDC20
125F76CT1Tributary Information - COL - 76C2TIICUTBatch TypeStringUDC20
126F76CT2Sales/Use/V.A.T. Tax File - COL - 76C7CTICUTBatch TypeStringUDC20
127F76CUI02Tax Detail - Work File - COL - 76C57TDICUTBatch TypeStringUDC20
128F76CUI04Tax Detail for Distribution - Work File - COL - 76C58TDICUTBatch TypeStringUDC20
TOP76E: Ecuador
129F76E0018Print Withholding Workfile - EC - 048TDICUTBatch TypeStringUDC20
130F76E4010Withholding Certificate Information - EC - 044CEICUTBatch TypeStringUDC20
TOP76H: Chile
131F76H6001Actual Cost Process Header - CHI - 41 - 76H22PHICUTBatch TypeStringUDC20
132F76H6201Replacement Cost Process Header - CHI - 4113RHICUTBatch TypeStringUDC20
133F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H13WFICUTBatch TypeStringUDC20
TOP76M: Mexico
134F76M0314Receipt Detail Tag File - Mexico10MAICUTBatch TypeStringUDC20
135F76M0414F0414 - Payment Detail Tag File - Mexico6RTICUTBatch TypeStringUDC20
136F76M930AR VAT on Gain/loss MEX - 76M19APICUTBatch TypeStringUDC20
137F76M940AP VAT on Gain/loss - MEX - 76M16APICUTBatch TypeStringUDC20
138F76M990GL VAT on Gain/loss MEX - 76M17GLICUTBatch TypeStringUDC20
TOPF31: Lean Transactions
139FF31201Cross Reference5CRICUTBatch TypeStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 98 / IT (Batch Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        #Payroll Vouchers N
2        #1Payroll Vouchers N
3        $Reserved for Clients N
4        %Reserved for Clients N
5        &A/R Drafts N
6        &BDraft Register N
7        +Bank Statement
8        +BBank Statements N
9        /Tenant Vouchers N
10        0Manufacturing
11        1Tenant Invoice Work Batch
12        2Tenant A/R Invoices
13        2BTenant A/R Invoices N
14        3Sales Report Entry
15        4Pro-Forma P/R Pay Period Jrnls
16        41Pro-Forma P/R Pay Period Jrnls N
17        5Pro-Forma Daily Timecard Jrnls
18        51Pro-Forma Daily Timecard Jrnls N
19        6Partnership Distribution
20        7Actual Payroll Period Journals
21        8Production FASTR
22        9Lockbox/Batch Cash Receipts
23        9BAutomatic Receipts N
24        @Reserved for Clients N
25        ARevenue - Check Entry N
26        ARAsset Revaluation N
27        BRevenue - Journal Entries N
28        CJIB Cost Allocations N
29        DCost Allocations/Flex Budget N
30        DBDraft Receipts N
31        EAsset Transfer N
32        FBalance Forward A/R Update N
33        FBBalance Forward A/R Updates N
34        GGeneral Accounting
35        HChange Orders
36        IInvoice Entry
37        IBInvoices N
38        JJIB Invoices and Statements
39        KA/P Checks (Automatic)
40        LALRS Checks
41        MManual & Void Checks w/Match
42        NInventory
43        NCFrozen Cost Update N
44        OPO/Contract Entries
45        PActual Timecard Journals
46        QDirect Payments
47        RCash Receipts and Adjustments
48        RBReceipts & AdjustmentsNY
49        SStock Transfers
50        STInter Branch Sales Transfer
51        TEquipment Time Entry
52        UOil & Gas Equipment Time Entry
53        UBUtility Billing N
54        VVoucher Entry
55        WManual Checks without Match
56        XDepreciation - Journal Entries
57        XXDetailed Currency Restatement N
58        YSubscription Sales
59        ZDisposal - Journal Entries