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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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

236 columns | Print definition?920 | SBLT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0902Account Balances38GBSBLTSubledger TypeCharacterUDC10
2F0911Account Ledger21GLSBLTSubledger TypeCharacterUDC10
3F4096Sales Flex Accounting11FASBLTSubledger TypeCharacterUDC10
TOP03: Accounts Receivable
4F0311Accounts Receivable Ledger52RPSBLTSubledger TypeCharacterUDC10
TOP03B: Enhanced Accounts Receivable
5F03B11Customer Ledger53RPSBLTSubledger TypeCharacterUDC10
6F03B117Revenue Recognition GL Info20RLSBLTSubledger TypeCharacterUDC10
7F03B119Revenue Recognition GL Info Audit38RNSBLTSubledger TypeCharacterUDC10
8F03B11PCustomer Ledger Purge File53RPSBLTSubledger TypeCharacterUDC10
9F03B11Z1Batch Invoices70VJSBLTSubledger TypeCharacterUDC10
10F03B11Z2F03B11 Interoperability Table66SYSBLTSubledger TypeCharacterUDC10
11F03B14Receipts Detail70RZSBLTSubledger TypeCharacterUDC10
12F03B14PReceipts Detail Purge File70RZSBLTSubledger TypeCharacterUDC10
13F03B14Z2F03B14 Interoperability Table83SZSBLTSubledger TypeCharacterUDC10
14F03B575Auto Debit Invoice Select and Build62RDSBLTSubledger TypeCharacterUDC10
15F09UI011Receipt Prepost Work File16GLSBLTSubledger TypeCharacterUDC10
TOP04: Accounts Payable
16F0411Accounts Payable Ledger51RPSBLTSubledger TypeCharacterUDC10
17F0411AWF - 'As Of' Accounts Payable Ledger51RPSBLTSubledger TypeCharacterUDC10
18F0411PPurge - Accounts Payable Ledger51RPSBLTSubledger TypeCharacterUDC10
19F0411Z1Voucher Transactions - Batch Upload69VLSBLTSubledger TypeCharacterUDC10
20F0411Z3F0411 Interoperability Table74SZSBLTSubledger TypeCharacterUDC10
21F09UI005Tax Offsets User Index35GLSBLTSubledger TypeCharacterUDC10
TOP05: Time Accounting and HRM Base
22F06106Employee Pay Instructions75YMSBLTSubledger TypeCharacterUDC10
23F0618Employee Transaction History18YTSBLTSubledger TypeCharacterUDC10
TOP05T: Time Entry
24F06116Employee Transaction Detail File18YTSBLTSubledger TypeCharacterUDC10
25F06116Z1Employee Transactions - Batch File35VLSBLTSubledger TypeCharacterUDC10
26F06116Z2ESS Timecard History35VMSBLTSubledger TypeCharacterUDC10
27F0623Piecework History File4JLSBLTSubledger TypeCharacterUDC10
28F0624Burden Distribution File12J#SBLTSubledger TypeCharacterUDC10
29F06241Burden Distribution File12J#SBLTSubledger TypeCharacterUDC10
30F06278Retro Timecard Detail File21YTSBLTSubledger TypeCharacterUDC10
31F06290Payroll Accounting Journal Work File8YRSBLTSubledger TypeCharacterUDC10
32F063951Payroll Journal (Compressed) File25GLSBLTSubledger TypeCharacterUDC10
33F06904Automatic Accounting Instructions15Y#SBLTSubledger TypeCharacterUDC10
34F069161Item Master Cross Reference File3JESBLTSubledger TypeCharacterUDC10
TOP07: Payroll
35F05290WF - Payroll Journal (Detail)25JRSBLTSubledger TypeCharacterUDC10
36F06490Payroll/Accounts Payable Ledger Detail23JRSBLTSubledger TypeCharacterUDC10
37F06491Payroll/Accounts Payable Ledger Detail16J6SBLTSubledger TypeCharacterUDC10
38F0716701Employee Assignment T/E Template Information17EASBLTSubledger TypeCharacterUDC10
39F0716709Employee Assignment T/E Template Info History17EASBLTSubledger TypeCharacterUDC10
40F0724Burden Distribution File15YSSBLTSubledger TypeCharacterUDC10
41F07241Burden Distribution File15YSSBLTSubledger TypeCharacterUDC10
42F07490Payroll - Accounts Payable Detail (One World)23JRSBLTSubledger TypeCharacterUDC10
43F07491Payroll - Accounts Payable Summary File16J6SBLTSubledger TypeCharacterUDC10
44F07UI200Timecard History Work File21THSBLTSubledger TypeCharacterUDC10
TOP08AD: ADP Integration
45F051371ADP Employee DBA Instructions80ADSBLTSubledger TypeCharacterUDC10
TOP08P: Position Control
46F081012Position Accounts5HCSBLTSubledger TypeCharacterUDC10
TOP09: General Accounting
47F0902BAccount Balances - 52 Period Accounting78GBSBLTSubledger TypeCharacterUDC10
48F0902PPurge - Account Balances38GBSBLTSubledger TypeCharacterUDC10
49F0902Z1Account Balances - Batch File41GBSBLTSubledger TypeCharacterUDC10
50F0911PPurge - Account Ledger21GLSBLTSubledger TypeCharacterUDC10
51F0911RWF - Account Ledger Reconciliation21GLSBLTSubledger TypeCharacterUDC10
52F0911Z1Journal Entry Transactions - Batch File38VNSBLTSubledger TypeCharacterUDC10
53F0911Z4F0911 Interoperability Table43SZSBLTSubledger TypeCharacterUDC10
54F0912Cost Allocations/Flex Budgeting48RJSBLTSubledger TypeCharacterUDC10
55F0912AIndex Computation Entry File53RISBLTSubledger TypeCharacterUDC10
56F0912BVariable Allocation File16R#SBLTSubledger TypeCharacterUDC10
57F0917Bank Statement Detail36GDSBLTSubledger TypeCharacterUDC10
58F09617Auto Bank Statement Detail39GMSBLTSubledger TypeCharacterUDC10
59F097031WAccount Balance to Account Master Work Table9ABSBLTSubledger TypeCharacterUDC10
60F09UI004Variable Numerator Allocations work file13R#SBLTSubledger TypeCharacterUDC10
61F09UI015Indexed Computations Multi-Tiered Entries21GLSBLTSubledger TypeCharacterUDC10
62F09UI016Account Balance Compare Exceptions6GWSBLTSubledger TypeCharacterUDC10
63F09UI123Advanced Variable Numerator Worktable8VWSBLTSubledger TypeCharacterUDC10
64F52G02Burdening Summarized Ledger11BSSBLTSubledger TypeCharacterUDC10
65F52G11Burdening Detail Ledger14BDSBLTSubledger TypeCharacterUDC10
66F52G11WFTemporary Burdened Detail Ledger Workfile14BWSBLTSubledger TypeCharacterUDC10
67F70UI001Work File for G/L by Cat. Code Localization10WASBLTSubledger TypeCharacterUDC10
68F740911Work File for G/L Report by Category Code Localization13WASBLTSubledger TypeCharacterUDC10
TOP09E: Expense Reimbursment
69F09E150Credit Card Transaction Interface Table10CISBLTSubledger TypeCharacterUDC10
70F20112Expense Report Detail60EDSBLTSubledger TypeCharacterUDC10
TOP10: Financial Reporting
71F1002Multi-Site Consolidation Transfer File12GQSBLTSubledger TypeCharacterUDC10
72F1002Z1Unedited MSC Interoperability Table21SZSBLTSubledger TypeCharacterUDC10
73F10471Elimination Rules (OW)9ERSBLTSubledger TypeCharacterUDC10
74F10UI006MSC - F1002 Elimination Work File11GESBLTSubledger TypeCharacterUDC10
TOP12: Fixed Assets
75F12002Default Accounting Constants22FDSBLTSubledger TypeCharacterUDC10
76F12003Default Depreciation Constants19FFSBLTSubledger TypeCharacterUDC10
77F1202Asset Account Balances File45FLSBLTSubledger TypeCharacterUDC10
78F1202PAsset Account Balances Purge Table45FLSBLTSubledger TypeCharacterUDC10
79F1204Location Tracking Table29FMSBLTSubledger TypeCharacterUDC10
80F1204PLocation Tracking Purge Table29FMSBLTSubledger TypeCharacterUDC10
81F12911ERPost G/L to FA Exceptions Work File20GLSBLTSubledger TypeCharacterUDC10
TOP13: Plant/Equipment Management
82F12120Z1Unedited Meter Reading Transactions23SZSBLTSubledger TypeCharacterUDC10
83F1304Equipment Location Billing10FNSBLTSubledger TypeCharacterUDC10
84F1305Equipment Distribution Rules10FVSBLTSubledger TypeCharacterUDC10
85F1306Meter Reading Estimates8F5SBLTSubledger TypeCharacterUDC10
86F1306PMeter Reading Estimates Purge Table8F5SBLTSubledger TypeCharacterUDC10
TOP13E: Equipment Cost Analysis
87F1383Equipment Analysis Costs8ECSBLTSubledger TypeCharacterUDC10
TOP15: Real Estate Management
88F1502Recurring Billings Master54NFSBLTSubledger TypeCharacterUDC10
89F1502BRecurring Billings Master50NFSBLTSubledger TypeCharacterUDC10
90F1502WBEstimated EP Recurring Billings53N4SBLTSubledger TypeCharacterUDC10
91F1511Tenant/Lease Billings Detail55NJSBLTSubledger TypeCharacterUDC10
92F1511BLease Billings Master51NJSBLTSubledger TypeCharacterUDC10
93F1511HTenant/Lease Billings Detail History55N#SBLTSubledger TypeCharacterUDC10
94F1511HBLease Billings History51NCSBLTSubledger TypeCharacterUDC10
95F15153Lease Cap History11LCSBLTSubledger TypeCharacterUDC10
96F15303E.P. Class Expenses History8CHSBLTSubledger TypeCharacterUDC10
97F1532BExpense Participation Audit File15NTSBLTSubledger TypeCharacterUDC10
98F1533BTenant Account Exclusions34NMSBLTSubledger TypeCharacterUDC10
99F1538B1Occupancy Gross Up Audit11GUSBLTSubledger TypeCharacterUDC10
TOP15L: Adv Real Estate Forecasting
100F15L109AREF Budget Results6BRSBLTSubledger TypeCharacterUDC10
101F15L110AREF Account Status7ASSBLTSubledger TypeCharacterUDC10
102F15L111AREF Account Status Detail7ADSBLTSubledger TypeCharacterUDC10
103F15L403AREF Gross Up Processing Audit12SHSBLTSubledger TypeCharacterUDC10
TOP16: Profit Management (EPS)
104F1602Cost Analyzer Balances7CBSBLTSubledger TypeCharacterUDC10
105F1602Z1External Cost Analyzer Balances - Interoperability Table29CZSBLTSubledger TypeCharacterUDC10
106F1610Cost Calculation Definitions21CDSBLTSubledger TypeCharacterUDC10
107F1611Cost Calculation Transactions16CTSBLTSubledger TypeCharacterUDC10
108F1630Driver Definitions26CDSBLTSubledger TypeCharacterUDC10
109F1632Driver Balances7CBSBLTSubledger TypeCharacterUDC10
110F1632Z1External Driver Balances-Interoperability Table29CYSBLTSubledger TypeCharacterUDC10
111F16421Rate Master Detail File12RDSBLTSubledger TypeCharacterUDC10
TOP17: Customer Service Management
112F1721Contract Detail22CDSBLTSubledger TypeCharacterUDC10
TOP17C: Call Management
113F1760Time Entry2ZBSBLTSubledger TypeCharacterUDC10
TOP18: Timecard Automation
114F186301Timecard Templates19TTSBLTSubledger TypeCharacterUDC10
115F186602Labor Rules Tag File32TFSBLTSubledger TypeCharacterUDC10
TOP40: Inventory/OP Base
116F4011ZBatch Receiver File - Order Details199SZSBLTSubledger TypeCharacterUDC10
117F4211Z1Sales Order Detail Unedited Transaction File178SZSBLTSubledger TypeCharacterUDC10
118F43800Summary Voucher Match11PRSBLTSubledger TypeCharacterUDC10
TOP41: Inventory Management
119F4111Item Ledger File58ILSBLTSubledger TypeCharacterUDC10
120F41UI001Inventory Transactions Detail File167ITSBLTSubledger TypeCharacterUDC10
TOP42: Sales Management
121F4211Sales Order Detail File165SDSBLTSubledger TypeCharacterUDC10
122F42119Sales Order History File165SDSBLTSubledger TypeCharacterUDC10
123F42199S.O. Detail Ledger File165SLSBLTSubledger TypeCharacterUDC10
124F42800G1Sales Update G Batch Detail Workfile21DGSBLTSubledger TypeCharacterUDC10
125F42UI12Sales Order Detail Cache 2 (MBF)59ZDSBLTSubledger TypeCharacterUDC10
126F42UI521Pick Slips Detail File116S9SBLTSubledger TypeCharacterUDC10
127F470371TTag for F470371- EDI shipping Notice Detail - Outbound57UZSBLTSubledger TypeCharacterUDC10
TOP42B: Sales Order Entry
128F42420Audit Log Transaction67ALSBLTSubledger TypeCharacterUDC10
TOP43: Procurement
129F40910Commitment Integrity Report Work File5P#SBLTSubledger TypeCharacterUDC10
130F43080Approvals Fields Constants5PDSBLTSubledger TypeCharacterUDC10
131F4311Purchase Order Detail File130PDSBLTSubledger TypeCharacterUDC10
132F4311ZPurchase Order Generator File134PWSBLTSubledger TypeCharacterUDC10
133F4311Z1Purchase Order Detail Unedited Transaction Table143SZSBLTSubledger TypeCharacterUDC10
134F43121Purchase Order Receiver File54PRSBLTSubledger TypeCharacterUDC10
135F43121ZReceiver workfile45PWSBLTSubledger TypeCharacterUDC10
136F43121Z1Receipts Unedited Transaction Table71SZSBLTSubledger TypeCharacterUDC10
137F43147Freight Distribution Workfile26FDSBLTSubledger TypeCharacterUDC10
138F4314ZVoucher Match Selection File154PNSBLTSubledger TypeCharacterUDC10
139F4316Purchase Order Multiple Account File13P3SBLTSubledger TypeCharacterUDC10
140F4316MModel Purchase Order Multiple Account File6P4SBLTSubledger TypeCharacterUDC10
141F43199P.O. Detail Ledger File - Flexible Version130OLSBLTSubledger TypeCharacterUDC10
142F43UI50DPO Print Detail Work File41PWSBLTSubledger TypeCharacterUDC10
TOP43A: Purchase Order Receipt/Routing
143F43126Purchase Order Receiver Multiple Account15P4SBLTSubledger TypeCharacterUDC10
144F43127Purchase Order Receiver Non-Billable13PRSBLTSubledger TypeCharacterUDC10
TOP43E: Requisition Self Service
145F43E16Requisition Multiple Account File14P3SBLTSubledger TypeCharacterUDC10
TOP43Q: Strategic Sourcing
146F43Q11Event Detail17EDSBLTSubledger TypeCharacterUDC10
TOP44H: Homebuilder Management
147F4453Lot Master (World)19JBSBLTSubledger TypeCharacterUDC10
148F44H590Closing Worksheet Accounting Instructions11CISBLTSubledger TypeCharacterUDC10
149F44H591Closing Worksheet Entries14CWSBLTSubledger TypeCharacterUDC10
150F44H73W1Lot Start - P.O. / Committment Generation Work File46CGSBLTSubledger TypeCharacterUDC10
151F44H73W2Lot Start - Budget Generation Workfile6BGSBLTSubledger TypeCharacterUDC10
TOP45: Advanced Pricing
152F4575Ship and Debit History53AHSBLTSubledger TypeCharacterUDC10
153F4575TMPShip and Debit History - Temp Table53AHSBLTSubledger TypeCharacterUDC10
154F4576Ship and Debit Claims81ACSBLTSubledger TypeCharacterUDC10
155F4576TMPShip and Debit Claims- Temp Table81ACSBLTSubledger TypeCharacterUDC10
156F4576Z1Ship and Debit Claims Unedited Transaction Table78Z1SBLTSubledger TypeCharacterUDC10
TOP47: Electronic Commerce
157F47012EDI Purchase Order Detail - Inbound200SZSBLTSubledger TypeCharacterUDC10
158F47017EDI Purchase Order Detail - Outbound144SZSBLTSubledger TypeCharacterUDC10
159F47022EDI P.O. Acknowledgment Detail - Inbound144SZSBLTSubledger TypeCharacterUDC10
160F47027EDI P.O. Acknowledgment Detail - Outbound200SZSBLTSubledger TypeCharacterUDC10
161F47042EDI Invoice Detail - Inbound56SZSBLTSubledger TypeCharacterUDC10
162F47047EDI Invoice Detail (Sales) - Outbound200SZSBLTSubledger TypeCharacterUDC10
163F47057EDI Payment Order Remittance Advice - Outbound102D3SBLTSubledger TypeCharacterUDC10
164F47057WEDI Payment Order Remittance Advice - Work102D3SBLTSubledger TypeCharacterUDC10
165F47072EDI Receiving Advice Detail - Inbound145SZSBLTSubledger TypeCharacterUDC10
166F47077EDI Receiving Advice Detail - Outbound145SZSBLTSubledger TypeCharacterUDC10
167F47092EDI Request for Quote Detail - Inbound200SZSBLTSubledger TypeCharacterUDC10
168F47097EDI Request for Quote Detail - Outbound144SZSBLTSubledger TypeCharacterUDC10
169F47102EDI Response to RFQ Detail - Inbound144SZSBLTSubledger TypeCharacterUDC10
170F47107EDI Response to RFQ Detail - Outbound199SZSBLTSubledger TypeCharacterUDC10
171F47122EDI Product Activity Data Detail - Inbound71MJSBLTSubledger TypeCharacterUDC10
172F47127EDI Product Activity Data Detail - Outbound71MJSBLTSubledger TypeCharacterUDC10
173F47132EDI Purchase Order Change Detail - Inbound201SZSBLTSubledger TypeCharacterUDC10
174F47137EDI Purchase Order Change Detail - Outbound145SZSBLTSubledger TypeCharacterUDC10
175F47142EDI P.O. Change Acknowledgment Detail - Inbound146SZSBLTSubledger TypeCharacterUDC10
176F47147EDI P.O. Change Acknowledgment Detail - Outbound202SZSBLTSubledger TypeCharacterUDC10
177F47157EDI Shipping Schedule Detail - Outbound153SZSBLTSubledger TypeCharacterUDC10
TOP48S: Service Billing
178F4812Billing Detail Workfile12WDSBLTSubledger TypeCharacterUDC10
179F4812HBilling Workfile History12WDSBLTSubledger TypeCharacterUDC10
180F4812HSBilling Workfile History Purged Save12WDSBLTSubledger TypeCharacterUDC10
181F4822Invoice Summary Work File20W4SBLTSubledger TypeCharacterUDC10
182F4823Voucher Summary18W0SBLTSubledger TypeCharacterUDC10
183F48426Service Billing Trigger Configuration7STSBLTSubledger TypeCharacterUDC10
184F48S0618Payroll Reclassification Workfile18YTSBLTSubledger TypeCharacterUDC10
185F48S910Billing Detail Journal Workfile20W2SBLTSubledger TypeCharacterUDC10
186F48S911Summarized Journal Workfile18W3SBLTSubledger TypeCharacterUDC10
187F48S912G/L Link4W6SBLTSubledger TypeCharacterUDC10
188F48S95Billing AAI Information19WVSBLTSubledger TypeCharacterUDC10
189F48SUI01Billing Detail Print Workfile12WDSBLTSubledger TypeCharacterUDC10
TOP51: Job Costing
190F5111Forecast Detail127FDSBLTSubledger TypeCharacterUDC10
191F5144Profit Recognition4G7SBLTSubledger TypeCharacterUDC10
192F51911Draw Reporting Master10GKSBLTSubledger TypeCharacterUDC10
TOP51X: In-Memory Project Management
193F51X0902Ledger Balances Worktable9LBSBLTSubledger TypeCharacterUDC10
194F51X0911Account Ledger Worktable10ALSBLTSubledger TypeCharacterUDC10
195F51X30Project Advisor Results Header100PBSBLTSubledger TypeCharacterUDC10
TOP52: Contract Billing
196F4812HTBilling Workfile History Tag Table9WDSBLTSubledger TypeCharacterUDC10
197F4812TBilling Detail Workfile Tag Table8WDSBLTSubledger TypeCharacterUDC10
198F5202Contract Billing Line Detail21G6SBLTSubledger TypeCharacterUDC10
199F5212T and M, Unit Price and Lumpsum Cross Reference Accounts12G5SBLTSubledger TypeCharacterUDC10
200F5280WContract Revenue Summary Work File21GYSBLTSubledger TypeCharacterUDC10
TOP52G: Proj & Gov Contract Accounting
201F4822HInvoice Summary History20IHSBLTSubledger TypeCharacterUDC10
TOP53: Change Management
202F5302F5302 World Specs15DKSBLTSubledger TypeCharacterUDC10
TOP74: EMEA Localization
203F74900Foreign Receivables and Payables - EMEA60RPSBLTSubledger TypeCharacterUDC10
TOP74H: Hungary
204F741202Work File Accumulated Asset Movement Dep - HUN - 747WFSBLTSubledger TypeCharacterUDC10
TOP74P: Poland
205F74902TAccount Balance Tag File - COM - 09 - 74P7ATSBLTSubledger TypeCharacterUDC10
TOP74R: Russia
206F74R9002Correspondence Balance - RUS- 09 - 74R42GBSBLTSubledger TypeCharacterUDC10
207F74R9029Open Accounts - RUS - 09 - 74R9OASBLTSubledger TypeCharacterUDC10
TOP74S: Spain
208F74S55Expenses and Exchange Rate for Payments - Spain - 0410Q5SBLTSubledger TypeCharacterUDC10
TOP74U: United Kingdom Localizations
209F74U0420SPC - Application Master - UK - 4319SESBLTSubledger TypeCharacterUDC10
210F74U0424SPC Subcontractor Payment Liability - UK - 4327PLSBLTSubledger TypeCharacterUDC10
211F74U0425SPC - Certificate Master - UK - 4320SFSBLTSubledger TypeCharacterUDC10
212F74U420ASPC Application Amount Drill Down - UK - 4315PASBLTSubledger TypeCharacterUDC10
213F74U424ASPC Subcontractor Accrual Data - UK - 4312PLSBLTSubledger TypeCharacterUDC10
214F74U424WSPC Subcontractor Accrual Workfile - UK - 4312WFSBLTSubledger TypeCharacterUDC10
215F74U4316SPC - Purchase Order Line Additional Information - UK - 4345SCSBLTSubledger TypeCharacterUDC10
TOP75C: China
216F75C015Cash Flow Data - China21CFSBLTSubledger TypeCharacterUDC10
217F75C902Subsidiary Balances File - China5SBSBLTSubledger TypeCharacterUDC10
218F75C902Subsidiary Balances File - China4SBLTLedger TypesStringUDC20
TOP76B: Brazil
219F7611BNota Fiscal Detail - BRA - 4294FDSBLTSubledger TypeCharacterUDC10
220F76B901IN86- Work Table for Account Master - 096BASBLTSubledger TypeCharacterUDC10
221F76B902IN86-Work Table for Account Balance - 097BCSBLTSubledger TypeCharacterUDC10
222F76B911IN86-Work Table for Journal Entries - 097BDSBLTSubledger TypeCharacterUDC10
TOP76C: Colombia
223F76C031AA/R Customer ledger As Of - F76C031A - COL - 0452RPSBLTSubledger TypeCharacterUDC10
224F76C034AA/R Check Detail file As Of - COL - 03B115RZSBLTSubledger TypeCharacterUDC10
225F76C0902Debits and Credits T/B by object account - COL - 76C19GBSBLTSubledger TypeCharacterUDC10
226F76C575Work File Magnetic Media - COL - 0420Q1SBLTSubledger TypeCharacterUDC10
227F76C9F02DIAN Formats by AccountID - COL - 0913DFSBLTSubledger TypeCharacterUDC10
228F76C9F11DIAN Formats File by Account Id - COL - 097DFSBLTSubledger TypeCharacterUDC10
229F76CT1Tributary Information - COL - 76C19TISBLTSubledger TypeCharacterUDC10
TOP76H: Chile
230F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H10I1SBLTSubledger TypeCharacterUDC10
231F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H21I2SBLTSubledger TypeCharacterUDC10
232F76H6005Account ID / Cost Type Relationship - CHI - 41 - 76H4ACSBLTSubledger TypeCharacterUDC10
233F76H902TAccount Balances Tag File - CHI - 09 - 76H7ATSBLTSubledger TypeCharacterUDC10
TOP83: Management Reporting - FASTR
234F83UI001Balance Audit Work File - (Financial Reporting)13R1SBLTSubledger TypeCharacterUDC10
TOP89: Conversion Programs
235F0902AAccount Debit Balances7GDSBLTSubledger TypeCharacterUDC10
236F43199ATemp F43199 for ERP 9.0 Upgrade130OLSBLTSubledger TypeCharacterUDC10

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

TOPUDC 00 / ST (Subledger Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 Blank N
2         AAddress Book Number Y
3         CBusiness Unit Number Y
4         EEquipment Number Y
5         FCase Number Y
6         GService Contract Header Y
7         IItem Number (Short) Y
8         JJob Change Request
9         LLease Number Y
10         MSummarized Work Order Number N
11         OOrder Number Y
12         SStructured Subledger
13         UUnit Number
14         WWork Order Number Y
15         XUser Defined Subledger Type
16         Y - Another User Defined Type
17         Z - Define Types As Needed