JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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

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