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
3F0911GLAccount Ledger
4F4101IMItem Master
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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

1025 columns | Print definition?812 | AN8

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master6MCAN8Address NumberNumericUDC80
2F0006SDate Effective Business Unit Master8MCAN8Address NumberNumericUDC80
3F0006Z1Cost Center Unedited Transaction Table19SZAN8Address NumberNumericUDC80
4F00092Supplemental Data22T3AN8Address NumberNumericUDC80
5F00094CTI Properties1T1AN8Address NumberNumericUDC80
6F0010Company Constants52CCAN8Address NumberNumericUDC80
7F0018Sales/Use/V.A.T. Tax File9TDAN8Address NumberNumericUDC80
8F00189WF - Tax Reconciliation9TGAN8Address NumberNumericUDC80
9F0029Sales Tax Work File by Taxing Authority and Document12TFAN8Address NumberNumericUDC80
10F0030Bank Transit Number Master File4AYAN8Address NumberNumericUDC80
11F0039MGenerated Document Media Object History4GHAN8Address NumberNumericUDC80
12F004201Prepayment Transaction Table23PTAN8Address NumberNumericUDC80
13F0401Z1Supplier Master - Batch File14VOAN8Address NumberNumericUDC80
14F0911Account Ledger48GLAN8Address NumberNumericUDC80
15F1501Tenant/Lease Master6NEAN8Address NumberNumericUDC80
16F4303Log Master16PKAN8Address NumberNumericUDC80
17F4303MLog Models14PMAN8Address NumberNumericUDC80
TOP01: Address Book
18F0101Address Book Master1ABAN8Address NumberNumericUDC80
19F0101Z2Address Book - Interoperability14SZAN8Address NumberNumericUDC80
20F01092Suplemental Data Base - Code4A2AN8Address NumberNumericUDC80
21F01093Suplemental Data Base - Narrative3A3AN8Address NumberNumericUDC80
22F0111Address Book - Who's Who1WWAN8Address NumberNumericUDC80
23F01111Contact Information1WNAN8Address NumberNumericUDC80
24F01111Z1Batch - Contact Information14CBAN8Address NumberNumericUDC80
25F01112Related Person1CPAN8Address NumberNumericUDC80
26F01112Z1Batch - Related Person14PBAN8Address NumberNumericUDC80
27F0111Z1Batch Who's Who Information14BWAN8Address NumberNumericUDC80
28F0114Address Book Memo/Text Information1ATAN8Address NumberNumericUDC80
29F0115Address Book - Contact Phone Numbers1WPAN8Address NumberNumericUDC80
30F01151Electronic Address1EAAN8Address NumberNumericUDC80
31F01151Z1Batch - Electronic Address14EBAN8Address NumberNumericUDC80
32F0115Z1Phones - Interoperability15PIAN8Address NumberNumericUDC80
33F0116Address by Date1ALAN8Address NumberNumericUDC80
34F01161Alternate Address1WLAN8Address NumberNumericUDC80
35F01161Z1Batch - Alternative Address14LBAN8Address NumberNumericUDC80
36F011901Contacts Subscriptions Table3CSAN8Address NumberNumericUDC80
37F01401Action Plan4APAN8Address NumberNumericUDC80
38F01411Action Plan Activity4ACAN8Address NumberNumericUDC80
39F0150Address Organization Structure Master File - OSTP - PA8 - AN83MAAN8Address NumberNumericUDC80
40F01501Enhanced Parent Child3PRAN8Address NumberNumericUDC80
41F01815AB Word Search Master Table - OneWorld1ASAN8Address NumberNumericUDC80
42F0401Supplier Master1A6AN8Address NumberNumericUDC80
TOP02: Electronic Mail
43F0113Message Log Ledger File1ZZAN8Address NumberNumericUDC80
44F01134PPAT Bulletin Board Enlistment4ZWAN8Address NumberNumericUDC80
45F0126Flash Schedule Master File1A#AN8Address NumberNumericUDC80
TOP03: Accounts Receivable
46F03012Customer Master by Line of Business1AIAN8Address NumberNumericUDC80
47F03012ADate Effective Category Codes1A2AN8Address NumberNumericUDC80
48F03012Z1Customer Master LOB-Batch File14VOAN8Address NumberNumericUDC80
49F0311Accounts Receivable Ledger2RPAN8Address NumberNumericUDC80
50F0312A/R Batch Cash Application9RUAN8Address NumberNumericUDC80
TOP03B: Enhanced Accounts Receivable
51F03B11Customer Ledger5RPAN8Address NumberNumericUDC80
52F03B112Invoice Revisions20RWAN8Address NumberNumericUDC80
53F03B112PInvoice Revisions Purge File20RWAN8Address NumberNumericUDC80
54F03B11PCustomer Ledger Purge File5RPAN8Address NumberNumericUDC80
55F03B11Z1Invoice Transactions - Batch File23VJAN8Address NumberNumericUDC80
56F03B11Z2F03B11 Interoperability Table18SYAN8Address NumberNumericUDC80
57F03B13Receipts Header File3RYAN8Address NumberNumericUDC80
58F03B13PReceipts Header Purge File3RYAN8Address NumberNumericUDC80
59F03B13Z1Electronic Receipts Input20RUAN8Address NumberNumericUDC80
60F03B13Z2F03B13 Interoperability Table16SYAN8Address NumberNumericUDC80
61F03B14A/R Check Detail File8RZAN8Address NumberNumericUDC80
62F03B14PReceipts Detail Purge File8RZAN8Address NumberNumericUDC80
63F03B14Z2F03B14 Interoperability Table21SZAN8Address NumberNumericUDC80
64F03B15Credit and Cash Management1RTAN8Address NumberNumericUDC80
65F03B16A/R Statistical History1RVAN8Address NumberNumericUDC80
66F03B16SA/R Statistical Summary1RSAN8Address NumberNumericUDC80
67F03B20A/R Notification History6ZRAN8Address NumberNumericUDC80
68F03B21A/R Notification History Detail3ZSAN8Address NumberNumericUDC80
69F03B22A/R Fee Journal History6RSAN8Address NumberNumericUDC80
70F03B23A/R Fee Journal History Detail7RTAN8Address NumberNumericUDC80
71F03B29Credit Insurance Table14IPAN8Address NumberNumericUDC80
72F03B31Customer Activity Log3ZGAN8Address NumberNumericUDC80
73F03B40A/R Deduction Management32RBAN8Address NumberNumericUDC80
74F03B465A/R Netting Workfile2ROAN8Address NumberNumericUDC80
75F03B575Auto Debit Invoice Select and Build8RDAN8Address NumberNumericUDC80
76F03B672Draft Remittance Work File - One World Only6RDAN8Address NumberNumericUDC80
77F09UI011Receipt Prepost Work File31GLAN8Address NumberNumericUDC80
TOP04: Accounts Payable
78F0030WBank Account/Supplier Number Workfile1AXAN8Address NumberNumericUDC80
79F0401MMultiple Vendor Bank Account Status1A6AN8Address NumberNumericUDC80
80F0411Accounts Payable Ledger7RPAN8Address NumberNumericUDC80
81F0411AWF - As Of - Accounts Payable Ledger7RPAN8Address NumberNumericUDC80
82F0411PPurge - Accounts Payable Ledger7RPAN8Address NumberNumericUDC80
83F0411Z1Voucher Transactions - Batch File25VLAN8Address NumberNumericUDC80
84F0411Z3F0411 Interoperability Table29SZAN8Address NumberNumericUDC80
85F0414Accounts Payable Matching Document Detail25RNAN8Address NumberNumericUDC80
86F0414AWF - As Of - Accounts Payable Payment Detail25RNAN8Address NumberNumericUDC80
87F0414PPurge - Accounts Payable Matching Document Detail25RNAN8Address NumberNumericUDC80
88F0414Z1F0414 Interoperability Table38SZAN8Address NumberNumericUDC80
89F0450Payee Control File6PCAN8Address NumberNumericUDC80
90F04514WF - 1099 Combined Workfile (Merge of F045141 and F045143)4G1AN8Address NumberNumericUDC80
91F045141WF - 1099 G/L Workfile4G1AN8Address NumberNumericUDC80
92F045143WF - 1099 A/P WorkFile4G1AN8Address NumberNumericUDC80
93F04572A/P Payment Processing - Summary File14KKAN8Address NumberNumericUDC80
94F04573A/P Payment Processing - Detail File9KIAN8Address NumberNumericUDC80
95F0474N3Supplier Inf. Foreigen Payments Sweden1QCAN8Address NumberNumericUDC80
96F04UI0061099 Workfiles User Index3G1AN8Address NumberNumericUDC80
97F09UI005Tax Offsets User Index19GLAN8Address NumberNumericUDC80
98F09UI006Tax (F0018) Replica9TDAN8Address NumberNumericUDC80
TOP05: Time Accounting and HRM Base
99F05100Resource Competency2CMAN8Address NumberNumericUDC80
100F05100Z1Resource Competencies Unedited Transactions File9CUAN8Address NumberNumericUDC80
101F05102Goal Master2SMAN8Address NumberNumericUDC80
102F05107Competency Update Approval Routing4CUAN8Address NumberNumericUDC80
103F05111Training/Development1CTAN8Address NumberNumericUDC80
104F05112Skills/Resources2STAN8Address NumberNumericUDC80
105F05113Accomplishments1ATAN8Address NumberNumericUDC80
106F05114Certifications2CTAN8Address NumberNumericUDC80
107F05115Education1ETAN8Address NumberNumericUDC80
108F05116Languages2LTAN8Address NumberNumericUDC80
109F05120Competency History2MMAN8Address NumberNumericUDC80
110F05122Action Plan2APAN8Address NumberNumericUDC80
111F05152WFResults Work File2WFAN8Address NumberNumericUDC80
112F05153WFResults Work File Competency Detail2WFAN8Address NumberNumericUDC80
113F05154WFResults Work File Competency Words Detail2WFAN8Address NumberNumericUDC80
114F054101Employee Personal Profile Information History Table1EHAN8Address NumberNumericUDC80
115F054101WEmployee Personal Profile Information Work Table1EPAN8Address NumberNumericUDC80
116F054111Employee Emergency Contact History Table1CHAN8Address NumberNumericUDC80
117F054111WEmployee Emergency Contact Work Table1ECAN8Address NumberNumericUDC80
118F05420Workflow Approval Table1WAAN8Address NumberNumericUDC80
119F0605D/B/A Period Control File1J@AN8Address NumberNumericUDC80
120F0607Wage Attachment Ledger File1JIAN8Address NumberNumericUDC80
121F0609Deduction/Benefit/Accrual Ledger File1Y$AN8Address NumberNumericUDC80
122F06106Employee Pay Instructions1YMAN8Address NumberNumericUDC80
123F06107Employee Wage Attachment Rules1J$AN8Address NumberNumericUDC80
124F061071Employee Wage Attachment Fee File1J$AN8Address NumberNumericUDC80
125F06145Calendar Month DBA Summary History File1YHAN8Address NumberNumericUDC80
126F06149Fiscal and Anniversary Rollover Work File1Y7AN8Address NumberNumericUDC80
127F0618Employee Transaction History1YTAN8Address NumberNumericUDC80
128F0619Benefit/Accrual Detail File1Y$AN8Address NumberNumericUDC80
129F0625Change Code History File1JBAN8Address NumberNumericUDC80
130F06251Step Progression Rate History File1JBAN8Address NumberNumericUDC80
131F0626Wage Attachment Control File1JGAN8Address NumberNumericUDC80
132F0627Workers Compensation Summary History1JHAN8Address NumberNumericUDC80
133F06925Employee/Vendor Cross Reference6YGAN8Address NumberNumericUDC80
134F06936Retro Pay Types Rate1JAAN8Address NumberNumericUDC80
135F0709Deduction/Benefit/Accrual Ledger File1Y$AN8Address NumberNumericUDC80
136F07300Employee Lockout Code File1YBAN8Address NumberNumericUDC80
TOP05A: OW HR & PR Foundation
137F05003Verification of Employment Data1EVAN8Address NumberNumericUDC80
138F05840Employee/Supervisor Relationship Level1SRAN8Address NumberNumericUDC80
139F05842Employee/Supervisor Approval History1ATAN8Address NumberNumericUDC80
140F060116Employee Master Information1YAAN8Address NumberNumericUDC80
141F0601161Point-In-Time Employee Master3PTAN8Address NumberNumericUDC80
142F060116WEE Master Request File1YAAN8Address NumberNumericUDC80
143F060116ZUnedited Quick Hire Transaction File14SZAN8Address NumberNumericUDC80
144F060117Employee Master - International Data1YAAN8Address NumberNumericUDC80
145F060117AEmployee Master - International Data Tag1YAAN8Address NumberNumericUDC80
146F060120Employee Master Additional Information File1YAAN8Address NumberNumericUDC80
147F06345Historical Payroll Register1JLAN8Address NumberNumericUDC80
148F08042HR History2JWAN8Address NumberNumericUDC80
TOP05T: Time Entry
149F051126Managers Delegates Setup File2Y6AN8Address NumberNumericUDC80
150F06022Employee Piecerate File1JAAN8Address NumberNumericUDC80
151F06116Employee Transaction Detail File1YTAN8Address NumberNumericUDC80
152F06116Z1Employee Transactions - Batch File18VLAN8Address NumberNumericUDC80
153F0623Piecework History File1JLAN8Address NumberNumericUDC80
154F06278Retro Timecard Detail File2YTAN8Address NumberNumericUDC80
155F06290Payroll Accounting Journal Work File16YRAN8Address NumberNumericUDC80
156F063951Payroll Journal (Compressed) File13GLAN8Address NumberNumericUDC80
157F069136Tip Disbursement1JEAN8Address NumberNumericUDC80
TOP05U: OW HR & PR Foundation US
158F053030IRS Form W-4 - Employee's Withholding Certificate1EWAN8Address NumberNumericUDC80
159F05850EEO-1 Annual Data4EOAN8Address NumberNumericUDC80
TOP06: Payroll (old) - Obsolete-do not reuse
160F060118Employee Jobs1YEAN8Address NumberNumericUDC80
161F060119Employee Jobs History File1YEAN8Address NumberNumericUDC80
162F060146Employees Pay Rate File1JIAN8Address NumberNumericUDC80
163F06017Employee Tax Exceptions/Overrides1YAAN8Address NumberNumericUDC80
164F06042Future Data EE Master Revisions2JOAN8Address NumberNumericUDC80
165F06146Employee Transaction History Summary1YNAN8Address NumberNumericUDC80
166F0618TATemp table for F0618T for conversion1YTAN8Address NumberNumericUDC80
TOP07: Payroll
167F05290WF - Payroll Journal (Detail)13JRAN8Address NumberNumericUDC80
168F06053Interim Check Parameters File1YWAN8Address NumberNumericUDC80
169F06136Tax History1YZAN8Address NumberNumericUDC80
170F06136ATax Summary (Additional)1YZAN8Address NumberNumericUDC80
171F06147Fiscal and Anniversary Year History1YDAN8Address NumberNumericUDC80
172F06148Tax Area Transaction History1Y@AN8Address NumberNumericUDC80
173F06156Pay Check History Summary1YUAN8Address NumberNumericUDC80
174F06166Pay Check History Tax Ledger1YVAN8Address NumberNumericUDC80
175F06166ATax Ledger (Additional)1YVAN8Address NumberNumericUDC80
176F063106Deduction/Benefit Work File1Y7AN8Address NumberNumericUDC80
177F06350IWF - Paycheck (Interims)3Y4AN8Address NumberNumericUDC80
178F06490Payroll/Accounts Payable Ledger Detail10JRAN8Address NumberNumericUDC80
179F065016Automatic Bank Deposit Master1YGAN8Address NumberNumericUDC80
180F0690361Employee Rollover Table Overrides1ROAN8Address NumberNumericUDC80
181F0701732Additional Tax Overrides1AOAN8Address NumberNumericUDC80
182F0701733Additional Calc Methods1YCAN8Address NumberNumericUDC80
183F0701734Prior Head Tax from a Previous Employer1Y3AN8Address NumberNumericUDC80
184F0701740Quantum Control Tax1YQAN8Address NumberNumericUDC80
185F0701741Canadian Deduction1YDAN8Address NumberNumericUDC80
186F0705DBA Period Control File1J@AN8Address NumberNumericUDC80
187F07100CCQ WORKFILE3F7AN8Address NumberNumericUDC80
188F07107Employee Wage Attachment Rules1JWAN8Address NumberNumericUDC80
189F071072Employee Level Multi Child Support Overrides1JXAN8Address NumberNumericUDC80
190F071073Employee Level Multi Wage Attachment Rules1J3AN8Address NumberNumericUDC80
191F071074Wage Attachment Exemption Rules1WEAN8Address NumberNumericUDC80
192F07149Accrual Fiscal/Anniversary History Work File2Y8AN8Address NumberNumericUDC80
193F0717ROE Summary History1JFAN8Address NumberNumericUDC80
194F07171ROE Summary History Comments1JPAN8Address NumberNumericUDC80
195F071861Stub Detail Piece Rate History File13Y8AN8Address NumberNumericUDC80
196F0719DBA Transaction Detail History1Y$AN8Address NumberNumericUDC80
197F0724Burden Distribution File4YSAN8Address NumberNumericUDC80
198F07241Burden Distribution File4YSAN8Address NumberNumericUDC80
199F0728Employee Paid Workers Compensation Transactions1YWAN8Address NumberNumericUDC80
200F0729Employee DBA Override Instructions1Y9AN8Address NumberNumericUDC80
201F07350Payment File3Y0AN8Address NumberNumericUDC80
202F073521Stub Detail Piece Rate File13Y2AN8Address NumberNumericUDC80
203F07353Tax Detail File1Y3AN8Address NumberNumericUDC80
204F07355Pre-Payroll Error File3Y5AN8Address NumberNumericUDC80
205F073911Leave Rollover Balance Report Work File2Y8AN8Address NumberNumericUDC80
206F074001New Hire Reporting Workfile - OneWorld Only1NHAN8Address NumberNumericUDC80
207F07490Payroll - Accounts Payable Detail (One World)15JRAN8Address NumberNumericUDC80
208F07620Leave Transactions1LVAN8Address NumberNumericUDC80
209F07621Employee Medical Leave Information1L1AN8Address NumberNumericUDC80
210F07622Employee Leave - Medical Opinions1L2AN8Address NumberNumericUDC80
211F07623Employee Leave Change Request1L3AN8Address NumberNumericUDC80
212F07624Employee Medical Leave Change Information1L4AN8Address NumberNumericUDC80
213F07630Leave Messaging and Audit1LMAN8Address NumberNumericUDC80
214F077011Tax History Integrity (Temp)5Y$AN8Address NumberNumericUDC80
215F077021Transaction History Integrity(Temp)5Y$AN8Address NumberNumericUDC80
216F07727Canadian Pension Information5J7AN8Address NumberNumericUDC80
217F07800Year-End Employee Table3JEAN8Address NumberNumericUDC80
218F07811Negative Amount Workfile3JEAN8Address NumberNumericUDC80
219F07830Employee Federal Control Table5Y0AN8Address NumberNumericUDC80
220F07831Employee State/Local Control Table5YBAN8Address NumberNumericUDC80
221F07832Employee Special Handling Control Table4YHAN8Address NumberNumericUDC80
222F078507ADP Employee Additional Information1YEAN8Address NumberNumericUDC80
223F07855Employee Fund Allocation1AFAN8Address NumberNumericUDC80
224F07860Superannuation Date Tracking1STAN8Address NumberNumericUDC80
225F07880SUI Magnetic Media Workfile1YWAN8Address NumberNumericUDC80
226F07UI200Timecard History Work File4THAN8Address NumberNumericUDC80
227F186206Leave Group List1LGAN8Address NumberNumericUDC80
TOP08: Human Resources
228F05410Employee E-Signature1ESAN8Address NumberNumericUDC80
229F054115Employee Phone Number History Table1HPAN8Address NumberNumericUDC80
230F054115WEmployee Phone Number Work Table1PNAN8Address NumberNumericUDC80
231F0800609Gap Analysis Snapshot1YIAN8Address NumberNumericUDC80
232F08092Human Resources General Description-User Def Codes3JZAN8Address NumberNumericUDC80
233F08093Human Resources General Description - Narration3JYAN8Address NumberNumericUDC80
234F082003Grade/Step Progression Detail File2YWAN8Address NumberNumericUDC80
235F083305Mail Merge Header/Detail6MMAN8Address NumberNumericUDC80
236F08336BDep/Ben X-Reference Tag Table1E2AN8Address NumberNumericUDC80
237F08338Primary Care Physician Table1E7AN8Address NumberNumericUDC80
238F08338BPrimary Care Physician Tag Table1PTAN8Address NumberNumericUDC80
239F085520Available Plans and Plan Options by Employee History Table2PHAN8Address NumberNumericUDC80
240F085520WAvailable Plans and Plan Options by Employee Work Table2APAN8Address NumberNumericUDC80
241F085528ESS History Table Cross Reference1ESAN8Address NumberNumericUDC80
242F085530WEmployee Current/Pending Elections Work Table1CPAN8Address NumberNumericUDC80
243F085536Dependent/Beneficiary X-Reference History Table2DHAN8Address NumberNumericUDC80
244F085536WDependent/Beneficiary X-Reference Work Table2DBAN8Address NumberNumericUDC80
245F085537WCurrent Dep/Ben X-Reference Work Table1XBAN8Address NumberNumericUDC80
246F085550Employee Self-Service Personal Information Options14IOAN8Address NumberNumericUDC80
247F085560Number of Participants by Employee1NPAN8Address NumberNumericUDC80
248F08710Employee Setup Master2ESAN8Address NumberNumericUDC80
249F08713POrganization Chart Public Information Flags1PIAN8Address NumberNumericUDC80
250F08720Employee Status Change2SCAN8Address NumberNumericUDC80
251F08750Managers Delegates2MDAN8Address NumberNumericUDC80
252F087711CBPA Appraisal Header3XJAN8Address NumberNumericUDC80
253F087711ACBPA Appraisal Header Tag Table3XJAN8Address NumberNumericUDC80
254F087715CBPA Diary Table1XMAN8Address NumberNumericUDC80
255F087721CBPA Appraisal Creation Work File3XPAN8Address NumberNumericUDC80
TOP08A: eRecruit
256F08403Extended Applicant Information1EIAN8Address NumberNumericUDC80
257F08470Job Postings15JPAN8Address NumberNumericUDC80
258F08490Recruitment Information2RIAN8Address NumberNumericUDC80
259F08492EEO Survey2EOAN8Address NumberNumericUDC80
260F08498Recruit Apply Posting3APAN8Address NumberNumericUDC80
TOP08AD: ADP Integration
261F05137ADP Employee Master Information3ADAN8Address NumberNumericUDC80
262F051371ADP Employee DBA Instructions3ADAN8Address NumberNumericUDC80
263F051372ADP Employee Job Master Information3ADAN8Address NumberNumericUDC80
264F051373ADP Employee Auto Deposit Instructions3ADAN8Address NumberNumericUDC80
265F051374ADP Employee Tax Withholding/Override Instructions3ADAN8Address NumberNumericUDC80
TOP08B: Benefits Administration
266F08320WFAvailable Plans and Plan Options by Employee Work Table2BVAN8Address NumberNumericUDC80
267F08330Employee Enrollment1BGAN8Address NumberNumericUDC80
268F08330BEmployee Enrollment Tag File1BTAN8Address NumberNumericUDC80
269F08330CEmployee Enrollment Tag Table C1PCAN8Address NumberNumericUDC80
270F08330WFEmployee Current/Pending Elections Work Table1BRAN8Address NumberNumericUDC80
271F08336Dep/Ben to Employee Plan X-Reference1BJAN8Address NumberNumericUDC80
272F08336WFDependent/Beneficiary X-Ref Work Table2BDAN8Address NumberNumericUDC80
273F0833WFBenefit Statement Work file3WFAN8Address NumberNumericUDC80
274F08346401(K) Elections1B4AN8Address NumberNumericUDC80
275F08370Reimbursement Spending Acct - Balance File2B7AN8Address NumberNumericUDC80
276F08371Reimbursement Spending Account Claims File1B6AN8Address NumberNumericUDC80
277F08372FSA - Pay Instruction File1BMAN8Address NumberNumericUDC80
278F08380WFBatch Enrollment Work File2BEAN8Address NumberNumericUDC80
279F08381WFRecalculate Plan Option Costs2RCAN8Address NumberNumericUDC80
280F08501Employee Pension Activity Master1HHAN8Address NumberNumericUDC80
281F08502Pension Plan Activity Balance1HIAN8Address NumberNumericUDC80
282F08511Employee Pension Activity Detail1HJAN8Address NumberNumericUDC80
283F085303WIRS W-4 Form Work File1W4AN8Address NumberNumericUDC80
284F08901Participant file1HUAN8Address NumberNumericUDC80
285F08911Qualifying Event Information4HVAN8Address NumberNumericUDC80
286F08912Additional Qualifying Event4HBAN8Address NumberNumericUDC80
TOP08H: Health and Safety
287F08601Injury/Illness Case Master4HLAN8Address NumberNumericUDC80
TOP08P: Position Control
288F08111Position Budget Detail3HQAN8Address NumberNumericUDC80
289F08111PPurge - Position Budget Detail3HQAN8Address NumberNumericUDC80
TOP08R: Recruitment Management - (Appl. Track. & Req.)
290F06012Personnel Resume1YDAN8Address NumberNumericUDC80
291F06013Personnel Resume Text1YEAN8Address NumberNumericUDC80
292F06018Date Parameter Extension1YFAN8Address NumberNumericUDC80
293F08045Employee Turnover Analysis5HTAN8Address NumberNumericUDC80
294F08102Requisition Information24HNAN8Address NumberNumericUDC80
295F08105Requisition Activity2HMAN8Address NumberNumericUDC80
296F08401Applicant Master1HAAN8Address NumberNumericUDC80
297F08401WFApplicant Work File1XNAN8Address NumberNumericUDC80
298F08402Applicant Master - Append Table1HAAN8Address NumberNumericUDC80
TOP08U: OW HR US
299F08360Nondiscrimination Groups3HEAN8Address NumberNumericUDC80
300F08369Plan Control Group Test History4NCAN8Address NumberNumericUDC80
301F08910CORBA Qualified Beneficiary File4J1AN8Address NumberNumericUDC80
302F089101COBRA Subsequent Qualified Event Info.21J2AN8Address NumberNumericUDC80
TOP08W: Wage and Salary
303F08201Salary Review Workfile4HRAN8Address NumberNumericUDC80
304F08830WFCompensation Root Work Table6YNAN8Address NumberNumericUDC80
305F08831WFCompensation Detail Work Table3YSAN8Address NumberNumericUDC80
TOP09: General Accounting
306F0911PPurge - Account Ledger48GLAN8Address NumberNumericUDC80
307F0911RWF - Acct Ledger File for Reconciliation39GLAN8Address NumberNumericUDC80
308F0911Z1Journal Entry Transactions - Batch File65VNAN8Address NumberNumericUDC80
309F0911Z4F0911 Interoperability Table70SZAN8Address NumberNumericUDC80
310F0917Bank Statement Detail21GDAN8Address NumberNumericUDC80
311F09617Auto Bank Statement Detail26GMAN8Address NumberNumericUDC80
312F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY2GLAN8Address NumberNumericUDC80
313F09UI015Indexed Computations Multi-Tiered Entries48GLAN8Address NumberNumericUDC80
314F09UI618Auto Bank Statement Process Work Table9NBAN8Address NumberNumericUDC80
315F11151Currency Cross Rates Calculation Master3CEAN8Address NumberNumericUDC80
TOP09E: Expense Reimbursment
316F09E114Exchange Rate Identifiers4ERAN8Address NumberNumericUDC80
317F20104Expense Report Group Profiles11GPAN8Address NumberNumericUDC80
318F20111Expense Report Header29EHAN8Address NumberNumericUDC80
TOP10: Financial Reporting
319F10UI005Organization Structure Report Work Table25SRAN8Address NumberNumericUDC80
TOP11: Multi Currency
320F0015Currency Exchange Rates3CXAN8Address NumberNumericUDC80
321F0015Z1External Currency Exchange Rates25ZEAN8Address NumberNumericUDC80
TOP12: Fixed Assets
322F1201Asset Master File69FAAN8Address NumberNumericUDC80
323F1201PAsset Master Purge Table69FAAN8Address NumberNumericUDC80
324F1201Z1Unedited Asset Master Transactions80FAAN8Address NumberNumericUDC80
325F1204Location Tracking Table32FMAN8Address NumberNumericUDC80
326F1204PLocation Tracking Purge Table32FMAN8Address NumberNumericUDC80
327F12092Fixed Assets Supplemental Data Codes Type10F3AN8Address NumberNumericUDC80
TOP13: Plant/Equipment Management
328F13411PM Projections30RXAN8Address NumberNumericUDC80
TOP13C: Condition-Base Maintenance
329F1310Condition-Based Alerts6CAAN8Address NumberNumericUDC80
330F1310Z1Unedited Condition-Based Alerts20CBAN8Address NumberNumericUDC80
331F1316Condition-Based Maintenance Message Rules2CMAN8Address NumberNumericUDC80
332F1318Condition-Based Maintenance Alert Action Rules1ARAN8Address NumberNumericUDC80
TOP13E: Equipment Cost Analysis
333F1381Equipment Analysis Filters7EFAN8Address NumberNumericUDC80
TOP15: Property Management
334F15013Sales Overage Master3NOAN8Address NumberNumericUDC80
335F15013BSales Overage Master File17NOAN8Address NumberNumericUDC80
336F15016Tenant Escalation Master2NUAN8Address NumberNumericUDC80
337F15016BTenant Escalation Master3NUAN8Address NumberNumericUDC80
338F1501BLease Master Header File8NEAN8Address NumberNumericUDC80
339F1503Log Standards Master28NBAN8Address NumberNumericUDC80
340F1511Tenant/Lease Billings Detail9NJAN8Address NumberNumericUDC80
341F1511BTenant/Lease Billings Detail Master9NJAN8Address NumberNumericUDC80
342F1511HTenant/Lease Billings Detail History9N#AN8Address NumberNumericUDC80
343F1511HBTenant/Lease Billings Detail History9NCAN8Address NumberNumericUDC80
344F1513FASB 13 Lease Control File9O3AN8Address NumberNumericUDC80
345F1513BFASB 13 Lease Control File9O3AN8Address NumberNumericUDC80
346F1521Log Detail Master23NBAN8Address NumberNumericUDC80
347F1525A/R Fee Interest3N0AN8Address NumberNumericUDC80
348F1525BA/R Fee and Interest3NMAN8Address NumberNumericUDC80
349F1538WF - Expence Participation Register1NZAN8Address NumberNumericUDC80
350F1538BEP Billing Register Work File1NZAN8Address NumberNumericUDC80
351F1540Sales Report Control File17NRAN8Address NumberNumericUDC80
352F1540BSales Report Control File6NRAN8Address NumberNumericUDC80
353F1541Tenant Sales History8N8AN8Address NumberNumericUDC80
354F15410Tenant Weekly Sales File10N9AN8Address NumberNumericUDC80
355F1541BTenant Sales History File9N8AN8Address NumberNumericUDC80
356F1541BWSales History Work File11OWAN8Address NumberNumericUDC80
357F1542Projected Sales10OJAN8Address NumberNumericUDC80
358F1543BTenant Sales Analysis Reporting File6OAAN8Address NumberNumericUDC80
359F1548Escalation Billing Register1N1AN8Address NumberNumericUDC80
360F1548BEscalation Billing Register1N1AN8Address NumberNumericUDC80
361F15525WPM Statements Credit/Cash Build Workfile1RTAN8Address NumberNumericUDC80
362F1565Security Deposit Master21JFAN8Address NumberNumericUDC80
363F1570Legal Clauses2NDAN8Address NumberNumericUDC80
364F15701Legal Clause Options Audit2NKAN8Address NumberNumericUDC80
365F157012Lease Option Type Detail6NCAN8Address NumberNumericUDC80
366F15702Legal Clause Space Detail2NFAN8Address NumberNumericUDC80
367F157021Legal Clause Space Detail Audit2NGAN8Address NumberNumericUDC80
368F15702DLegal Clause Space Detail - Alternate Description2NFAN8Address NumberNumericUDC80
369F15703Legal Clause Amounts2NIAN8Address NumberNumericUDC80
TOP15L: Adv Real Estate Forecasting
370F15L001WWork File for R15L0013Q1AN8Address NumberNumericUDC80
371F15L201AREF Permission List Details2PDAN8Address NumberNumericUDC80
372F15L301AREF Projected Sales10PSAN8Address NumberNumericUDC80
TOP17: Customer Service Management
373F1720Contract Header15CHAN8Address NumberNumericUDC80
374F1721Contract Detail28CDAN8Address NumberNumericUDC80
375F1791Entitlement Dates5EMAN8Address NumberNumericUDC80
376F3111Z2Warranty Claim/Supplier Recovery processing48WPAN8Address NumberNumericUDC80
377F3112Z2Warranty Claim/Supplier Recovery processing35WLAN8Address NumberNumericUDC80
378F4801Z2Warranty Claim/Supplier Recovery processing41WSAN8Address NumberNumericUDC80
TOP17C: Call Management
379F17111Base Warranty Defaults2BCAN8Address NumberNumericUDC80
380F1731Installed Base Location History5LQAN8Address NumberNumericUDC80
381F1754Call Queue Routing Rules11ZBAN8Address NumberNumericUDC80
382F1755Customer Call Master24ZAAN8Address NumberNumericUDC80
383F1757Task Master13ZAAN8Address NumberNumericUDC80
384F1760Time Entry7ZBAN8Address NumberNumericUDC80
385F1797CSMS Address Book Information1CSAN8Address NumberNumericUDC80
TOP18: Resource Scheduling
386F186202Employee List Group Members2LGAN8Address NumberNumericUDC80
387F186205Temp Cached Employees2TCAN8Address NumberNumericUDC80
388F186602Labor Rules Tag File3TFAN8Address NumberNumericUDC80
TOP30: Product Data Management
389F30006Work Center Master File9IWAN8Address NumberNumericUDC80
390F30006Z1Work Center Transaction File22SZAN8Address NumberNumericUDC80
391F300311Lean Multi Level Routing Detail File32EHAN8Address NumberNumericUDC80
392F3003Z1Routing Transactions File49SZAN8Address NumberNumericUDC80
393F3016Kanban Master21KMAN8Address NumberNumericUDC80
TOP31: Shop Floor Control
394F30161Z1Inbound Kanban Card Detail18SZAN8Address NumberNumericUDC80
395F3111Work Order Parts List35WMAN8Address NumberNumericUDC80
396F3111SPurge - Shop Floor Parts List35WMAN8Address NumberNumericUDC80
397F3111Z1Outbound Work Order Parts List48SZAN8Address NumberNumericUDC80
398F3112Work Order Routing22WLAN8Address NumberNumericUDC80
399F31122Work Order Time Transactions4WTAN8Address NumberNumericUDC80
400F31122SPurge Work Order Time Transactions4WTAN8Address NumberNumericUDC80
401F31122Z1Work Order Time Transactions Unedited Transaction Table17SZAN8Address NumberNumericUDC80
402F3112SPurge Shop Floor Control Routing Instructions22WLAN8Address NumberNumericUDC80
403F3112Z1Outbound Work Order Routings35SZAN8Address NumberNumericUDC80
404F4801SPurge - Work Order Master file22WAAN8Address NumberNumericUDC80
405F4801Z1Outbound Work Order Header41SYAN8Address NumberNumericUDC80
TOP31B: Blend Management
406F31B01Winery Master10WIAN8Address NumberNumericUDC80
407F31B02Staff Master2STAN8Address NumberNumericUDC80
408F31B111Work Group Staff Allocation8GSAN8Address NumberNumericUDC80
409F31B35Owner Master2OMAN8Address NumberNumericUDC80
TOP31P: Engineer To Order
410F31P10Project Quote Header16PQAN8Address NumberNumericUDC80
TOP32: Configuration Management
411F3201Configurator Master Table9CMAN8Address NumberNumericUDC80
412F32019Configurator Master History Table9CHAN8Address NumberNumericUDC80
413F3294Configured String History File12KZAN8Address NumberNumericUDC80
414F32943Configured String History - OneWorld13KOAN8Address NumberNumericUDC80
TOP34: Requirements Planning
415F3406Customer Address Relationship1CRAN8Address NumberNumericUDC80
416F3430Vendor Schedule Quantity File14MVAN8Address NumberNumericUDC80
417F3435Vendor Schedule Commitment File9MCAN8Address NumberNumericUDC80
418F3440Vendor Schedule History File11MHAN8Address NumberNumericUDC80
419F3450Adhoc Vendor Schedule File3MAAN8Address NumberNumericUDC80
420F3460Forecast File6MFAN8Address NumberNumericUDC80
421F43211Supplier Schedule Master File5SSAN8Address NumberNumericUDC80
422F43213SRS Ship Dates7VPAN8Address NumberNumericUDC80
TOP34A: Advanced Planning & Scheduling
423F34A60Last Outbound Purchase Order/Transfer Order4OBAN8Address NumberNumericUDC80
TOP36: Forecasting
424F3400Forecast Summary File15SGAN8Address NumberNumericUDC80
425F34007Forecast Prices3FHAN8Address NumberNumericUDC80
426F3460Z1Forecast Unedited Transactions19FTAN8Address NumberNumericUDC80
TOP37: Quality Management
427F3711Test Results12TRAN8Address NumberNumericUDC80
428F3711Z1Test Results Unedited Transaction Table25SZAN8Address NumberNumericUDC80
429F37900Certificate of Analysis (COA) Extract12TRAN8Address NumberNumericUDC80
430F40318Preference Profile - Quality Management1QCAN8Address NumberNumericUDC80
TOP38: Agreement Management
431F38010Agreement Master18DNAN8Address NumberNumericUDC80
432F38111Agreements Transaction Ledger4DZAN8Address NumberNumericUDC80
TOP40: Inventory/OP Base
433F3003Routing Master File36IRAN8Address NumberNumericUDC80
434F30UI006Lot Tracking Work File12ILAN8Address NumberNumericUDC80
435F4001ZBatch Receiver File - Order Headings36SYAN8Address NumberNumericUDC80
436F40051Return Material Authorization22RDAN8Address NumberNumericUDC80
437F40071Customer Preference Groups1CUAN8Address NumberNumericUDC80
438F4011ZBatch Receiver File - Order Details32SZAN8Address NumberNumericUDC80
439F4015Order Templates2OTAN8Address NumberNumericUDC80
440F40300RPreference Resolution History - Master29PMAN8Address NumberNumericUDC80
441F40301Preference Profile - Payment Terms1PTAN8Address NumberNumericUDC80
442F40301RPreference Resolution Ledger - Payment Terms3PTAN8Address NumberNumericUDC80
443F40302Preference Profile - Unit of Measure1PUAN8Address NumberNumericUDC80
444F40302RPreference Resolution Ledger - Pricing Unit Of Measure3PUAN8Address NumberNumericUDC80
445F40303Preference Profile - Revenue Cost Center1RVAN8Address NumberNumericUDC80
446F40303RPreference Resolution Ledger - Revenue Business Unit3RVAN8Address NumberNumericUDC80
447F40304Preference Profile - End Use1PEAN8Address NumberNumericUDC80
448F40304RPreference Resolution Ledger - End Use3PEAN8Address NumberNumericUDC80
449F40305Preference Profile - Print Messages1RMAN8Address NumberNumericUDC80
450F40305RPreference Resolution Ledger - Print Messages3RMAN8Address NumberNumericUDC80
451F40306Preference Profile - Inventory Sourcing1SRAN8Address NumberNumericUDC80
452F40307Preference Profile - Product Allocations1LAAN8Address NumberNumericUDC80
453F40308Preference Profile - Grade and Potency1GSAN8Address NumberNumericUDC80
454F40308RPreference Resolution Ledger - Grade and Potency3GSAN8Address NumberNumericUDC80
455F40309Preference Profile - Delivery Date1DYAN8Address NumberNumericUDC80
456F40309RPreference Resolution Ledger - Delivery Date3DYAN8Address NumberNumericUDC80
457F40310Preference Profile - Line of Business1LBAN8Address NumberNumericUDC80
458F40310RPreference Resolution Ledger - Line Of Business3LBAN8Address NumberNumericUDC80
459F40311Preference Profile - Price Code 11P1AN8Address NumberNumericUDC80
460F40311RPreference Resolution Ledger - User Defined Price Code #13P1AN8Address NumberNumericUDC80
461F40312Preference Profile - Price Code 21P2AN8Address NumberNumericUDC80
462F40312RPreference Resolution Ledger - User Defined Price Code #23P2AN8Address NumberNumericUDC80
463F40313Preference Profile - Price Code 31P3AN8Address NumberNumericUDC80
464F40313RPreference Resolution Ledger - User Defined Price Code #33P3AN8Address NumberNumericUDC80
465F40314Preference Profile - Price Adjustment Schedule1PJAN8Address NumberNumericUDC80
466F40314RPreference Resolution Ledger - Price Adjustment Schedule3PJAN8Address NumberNumericUDC80
467F40315Preference Profile - Invoice Cycling1PIAN8Address NumberNumericUDC80
468F40315RPreference Resolution Ledger - Invoice Cycle3PIAN8Address NumberNumericUDC80
469F40316Preference Profile - Order Preparation1OPAN8Address NumberNumericUDC80
470F40316RPreference Resolution Ledger - Order Preparation Days3OPAN8Address NumberNumericUDC80
471F40318RPreference Resolution Ledger - Quality Management3QCAN8Address NumberNumericUDC80
472F40320Preference Profile - Multi Shipping/Receiving Locations1LPAN8Address NumberNumericUDC80
473F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations2LPAN8Address NumberNumericUDC80
474F40329Preference Profile - Document Distribution1DDAN8Address NumberNumericUDC80
475F40330Preference Profile - Document Set1DGAN8Address NumberNumericUDC80
476F40331Preference Profile - Options and Equipment1OEAN8Address NumberNumericUDC80
477F40332Preference Profile - Customer Freight1CFAN8Address NumberNumericUDC80
478F40333Preference Profile - Carrier1CAAN8Address NumberNumericUDC80
479F40334Preference Profile - Mode of Transport1MTAN8Address NumberNumericUDC80
480F40338Preference Profile - Payment Terms (Branch)1PTAN8Address NumberNumericUDC80
481F40338RPreference Resolution Ledger - Payment Terms (Branch)3PTAN8Address NumberNumericUDC80
482F40339Preference Profile - Product Allocations (Branch)1LAAN8Address NumberNumericUDC80
483F40341Preference Profile - Next Order Status1NSAN8Address NumberNumericUDC80
484F40341RPreference Resolution Ledger - Next Order Status3NSAN8Address NumberNumericUDC80
485F40344Preference Profile - Sales Commission1SAAN8Address NumberNumericUDC80
486F40344RPreference Resolution Ledger - Sales Commission3SAAN8Address NumberNumericUDC80
487F40345Preference Profile - Customer Currency1CRAN8Address NumberNumericUDC80
488F40345RPreference Resolution Ledger - Customer Currency3CRAN8Address NumberNumericUDC80
489F40347Preference Profile - Pricing UOM (Branch)1RIAN8Address NumberNumericUDC80
490F40347RPreference Resolution Ledger - Pricing UOM (Branch)3RIAN8Address NumberNumericUDC80
491F40349Preference Profile - Revenue Business Unit (Branch)1RVAN8Address NumberNumericUDC80
492F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)3RVAN8Address NumberNumericUDC80
493F40350Preference Profiles - Conatiner Deposit/Rental1OQAN8Address NumberNumericUDC80
494F40P011Promotion Deal Detail File5PDAN8Address NumberNumericUDC80
495F40UI002Supplier History Rebuild -workfile2UTAN8Address NumberNumericUDC80
496F40UI17Allocation Work File8ZGAN8Address NumberNumericUDC80
497F40UI74Price Adjustment History Work File20AWAN8Address NumberNumericUDC80
498F41001Inventory Constants28CIAN8Address NumberNumericUDC80
499F4104Item Cross Reference File1IVAN8Address NumberNumericUDC80
500F4106Item Base Price File7BPAN8Address NumberNumericUDC80
501F4201Z1Sales Order Header Unedited Transaction File26SYAN8Address NumberNumericUDC80
502F4209Held Orders3HOAN8Address NumberNumericUDC80
503F4211AUSales Order Detail Audit File13AUAN8Address NumberNumericUDC80
504F4211DTSales Order Detail Date Tracking File7DTAN8Address NumberNumericUDC80
505F4211Z1Sales Order Detail Unedited Transaction File31SZAN8Address NumberNumericUDC80
506F4215Shipment Header33XHAN8Address NumberNumericUDC80
507F4220Basic Serial Numbers10SWAN8Address NumberNumericUDC80
TOP40G: Grower Management
508F40G101Ownership Distribution3ODAN8Address NumberNumericUDC80
509F40G102Grower Contacts4GCAN8Address NumberNumericUDC80
510F40G150Crush and Purchase Report Details30CPAN8Address NumberNumericUDC80
TOP40R: Demand Scheduling
511F40R10Demand Header3DHAN8Address NumberNumericUDC80
512F40R11Demand Detail4DDAN8Address NumberNumericUDC80
513F40R12Cumulative Quantities4CQAN8Address NumberNumericUDC80
514F40R12WFCUM Rollback Workfile7CQAN8Address NumberNumericUDC80
515F40R20Demand Rules2DRAN8Address NumberNumericUDC80
516F40R21Demand Processing Cross Reference2XCAN8Address NumberNumericUDC80
517F40R22Demand Workflow2DWAN8Address NumberNumericUDC80
518F40R23Product CUM Model2PCAN8Address NumberNumericUDC80
519F40R24Carton CUM Model2CLAN8Address NumberNumericUDC80
520F40R30WFDemand Work File15DSAN8Address NumberNumericUDC80
521F40R31Additional Demand Label Data2ADAN8Address NumberNumericUDC80
522F40R41Demand History6DIAN8Address NumberNumericUDC80
523F40R42Cumulative Quantity History5CHAN8Address NumberNumericUDC80
524F47171EDI Demand Header15EHAN8Address NumberNumericUDC80
525F471721EDI Demand Supplemental Data22EUAN8Address NumberNumericUDC80
526F4720EDI Time Zone1TMAN8Address NumberNumericUDC80
527F47UI002ASN Extract Packaging Work File31SPAN8Address NumberNumericUDC80
TOP40S: Supply Chain Self Service
528F4947SWSelf-Service Shipment Tracking Work File23SWAN8Address NumberNumericUDC80
TOP41: Inventory Management
529F41013Unique Product Number4UNAN8Address NumberNumericUDC80
530F4111Item Ledger File36ILAN8Address NumberNumericUDC80
531F41131Stranded Hard Commitments Table22IUAN8Address NumberNumericUDC80
532F4118Container Deposit File1CNAN8Address NumberNumericUDC80
533F41181Container Transaction File1CMAN8Address NumberNumericUDC80
534F41182Container Serial4CSAN8Address NumberNumericUDC80
535F41291ZLanded Cost Cache Table13IGAN8Address NumberNumericUDC80
536F41UI001Inventory Transactions Detail File45ITAN8Address NumberNumericUDC80
TOP41B: Bulk Stock Management
537F41509Four-Point Analysis Maintenance File9PGAN8Address NumberNumericUDC80
538F41511Bulk Product Transaction File43PAAN8Address NumberNumericUDC80
TOP42: Sales Management
539F4015WOrder Templates - Web Customers1ODAN8Address NumberNumericUDC80
540F4074Price Adjustment Ledger File14ALAN8Address NumberNumericUDC80
541F42004Commission Constants File1CMAN8Address NumberNumericUDC80
542F42005Sales Commission File6SCAN8Address NumberNumericUDC80
543F4201Sales Order Header File13SHAN8Address NumberNumericUDC80
544F42019Sales Order Header History File13SHAN8Address NumberNumericUDC80
545F4211Sales Order Detail File18SDAN8Address NumberNumericUDC80
546F42119Sales Order History File18SDAN8Address NumberNumericUDC80
547F42140Customer Master Commission Information1CMAN8Address NumberNumericUDC80
548F42199S.O. Detail Ledger File18SLAN8Address NumberNumericUDC80
549F4229Sales Summary History File3SSAN8Address NumberNumericUDC80
550F42430Customer Set1CSAN8Address NumberNumericUDC80
551F42565Invoice Print File12IWAN8Address NumberNumericUDC80
552F42800G1Sales Update G Batch Detail Workfile115DGAN8Address NumberNumericUDC80
553F42CSSCustomer Self Service Workfile1CSAN8Address NumberNumericUDC80
554F42UI005Sales Commission File6SCAN8Address NumberNumericUDC80
555F42UI01SO Header Cache File (MBF)18ZHAN8Address NumberNumericUDC80
556F42UI11SO Detail Cache File (MBF)22ZDAN8Address NumberNumericUDC80
557F42UI11CCustomer Self Service Shopping Cart Workfile6SCAN8Address NumberNumericUDC80
558F42UI520Pick Slips Header File6S8AN8Address NumberNumericUDC80
559F42UI521Pick Slips Detail File16S9AN8Address NumberNumericUDC80
560F42UI800Sales Detail Work File - Sales Update36SDAN8Address NumberNumericUDC80
TOP43: Procurement
561F41061Supplier Price/Catalog File2CBAN8Address NumberNumericUDC80
562F41291Item Cost Components14IGAN8Address NumberNumericUDC80
563F4301Purchase Order Header12PHAN8Address NumberNumericUDC80
564F4301ZPO Header Work File16PAAN8Address NumberNumericUDC80
565F4301Z1Purchase Order Header Unedited Transaction Table25SYAN8Address NumberNumericUDC80
566F4305Log Master7PLAN8Address NumberNumericUDC80
567F43080Approvals Fields Constants29PDAN8Address NumberNumericUDC80
568F43090Supplier/Item Relationships1PCAN8Address NumberNumericUDC80
569F43092Z1Receipt Routing Unedited Transaction Table38SZAN8Address NumberNumericUDC80
570F43093Inspection/Sample Size Table1PEAN8Address NumberNumericUDC80
571F43094Supplier Item Additional Routes1P5AN8Address NumberNumericUDC80
572F4311Purchase Order Detail File19PDAN8Address NumberNumericUDC80
573F4311ZPurchase Order Generator File23PWAN8Address NumberNumericUDC80
574F4311Z1Purchase Order Detail Unedited Transaction Table32SZAN8Address NumberNumericUDC80
575F43121Purchase Order Receiver File2PRAN8Address NumberNumericUDC80
576F43121ZReceiver workfile38PWAN8Address NumberNumericUDC80
577F43121Z1Receipts Unedited Transaction Table19SZAN8Address NumberNumericUDC80
578F4314ZVoucher Match Selection File101PNAN8Address NumberNumericUDC80
579F43199P.O. Detail Ledger File - Flexible Version19OLAN8Address NumberNumericUDC80
580F4330Supplier Selection File5P0AN8Address NumberNumericUDC80
581F4331Quantity Breaks File4P1AN8Address NumberNumericUDC80
582F4340Purchase Rebate Master File1RDAN8Address NumberNumericUDC80
583F4341Purchase Rebate Threshold File1RLAN8Address NumberNumericUDC80
584F4342Purchase Inclusion Rules1RKAN8Address NumberNumericUDC80
585F4343Purchase Rebate History2RHAN8Address NumberNumericUDC80
586F4350Supplier Page Hyperlinks1H1AN8Address NumberNumericUDC80
587F4351Supplier Item Hyperlinks1H2AN8Address NumberNumericUDC80
588F4355Subcontractor Threshold1PTAN8Address NumberNumericUDC80
589F43632ZOpen Purchase Order by Item Work File17OIAN8Address NumberNumericUDC80
590F4371Suggested Reorder Stock Items3PDAN8Address NumberNumericUDC80
591F43UI50HPO Print Header Work File8PAAN8Address NumberNumericUDC80
TOP43C: Contracts
592F43C20Contract Payee26CPAN8Address NumberNumericUDC80
TOP43E: Requisition Self Service
593F43E091Approval Authority (Employee)1AEAN8Address NumberNumericUDC80
594F43E11Requisition Detail7RDAN8Address NumberNumericUDC80
TOP43Q: Strategic Sourcing
595F43Q30Event Invited Bidders4EVAN8Address NumberNumericUDC80
596F43Q35Event Bidder Password Temp Table1PTAN8Address NumberNumericUDC80
597F43Q40Response Header5RAAN8Address NumberNumericUDC80
598F43Q401Response Header Question6RCAN8Address NumberNumericUDC80
599F43Q402Response Header Question List6RDAN8Address NumberNumericUDC80
600F43Q403Bidder Response Decline4RIAN8Address NumberNumericUDC80
601F43Q404Response Disallow5RJAN8Address NumberNumericUDC80
602F43Q405Response Disallow Line6RKAN8Address NumberNumericUDC80
603F43Q41Response Line6RBAN8Address NumberNumericUDC80
604F43Q411Response Detail Question7REAN8Address NumberNumericUDC80
605F43Q412Response Detail Question Price Break7RGAN8Address NumberNumericUDC80
606F43Q413Response Detail Question Price Components6RHAN8Address NumberNumericUDC80
607F43Q414Response Detail Question List7RLAN8Address NumberNumericUDC80
608F43Q50Analyze Event Header4AVAN8Address NumberNumericUDC80
609F43Q51Analyze Event Detail5EDAN8Address NumberNumericUDC80
610F43Q91Bidder Registration1BRAN8Address NumberNumericUDC80
611F43Q911F43Q911 - Bidder Country VAT1BCAN8Address NumberNumericUDC80
TOP43S: Supplier Self Service
612F43001Procurement Self-Service Transaction Log3SAAN8Address NumberNumericUDC80
613F4313POFLIP8PFAN8Address NumberNumericUDC80
614F4323PO FLIP Header2PDAN8Address NumberNumericUDC80
TOP44H: Homebuilder Management
615F4454Vendor Assignment (World)7JGAN8Address NumberNumericUDC80
616F4455Vendor Assignment (Takeoffs) (World)8JHAN8Address NumberNumericUDC80
617F4459Material Item Pricing (World)3JLAN8Address NumberNumericUDC80
618F44H601Bid Header15BHAN8Address NumberNumericUDC80
619F44H603Material Item Pricing3MPAN8Address NumberNumericUDC80
620F44H604Vendor Assignment8VAAN8Address NumberNumericUDC80
621F44H604WVendor Assignment Workfile2VWAN8Address NumberNumericUDC80
622F44H604ZHB Vendor Assignment Unedited Transaction File21SZAN8Address NumberNumericUDC80
623F44H611Bid Details23BDAN8Address NumberNumericUDC80
624F44H611WBid Details Work File27BWAN8Address NumberNumericUDC80
625F44H711Lot Start Workfile5SWAN8Address NumberNumericUDC80
626F44H711PAfter Start Purchasing6TPAN8Address NumberNumericUDC80
627F44H711ZHB Lot Start Unedited Transaction File18SZAN8Address NumberNumericUDC80
628F44H712Lot Start Workfile Takeoff Detail5STAN8Address NumberNumericUDC80
629F44H71W1Lot Start Generation Workfile6GWAN8Address NumberNumericUDC80
630F44H73W1Lot Start - P.O. / Committment Generation Work File6CGAN8Address NumberNumericUDC80
631F44H9905HomeBuilder Integrated Addresses1MHAN8Address NumberNumericUDC80
TOP45: Advanced Pricing
632F4072Price Adjustment Detail5ADAN8Address NumberNumericUDC80
633F4072WPrice Adjustment Detail Work File5ADAN8Address NumberNumericUDC80
634F4077Rebate Thresholds2RTAN8Address NumberNumericUDC80
635F4078Rebate Transaction Summary1RHAN8Address NumberNumericUDC80
636F4079Rebate Transaction Detail1SVAN8Address NumberNumericUDC80
637F4510Price Workbench Query Header3PWAN8Address NumberNumericUDC80
638F4511WPricing Structure View42APAN8Address NumberNumericUDC80
639F45520Price List Header8PHAN8Address NumberNumericUDC80
640F45521Price List Detail19PDAN8Address NumberNumericUDC80
641F45715Adjustment Balances5ABAN8Address NumberNumericUDC80
642F4572Live Promotions X-Reference by Cost Type1XRAN8Address NumberNumericUDC80
643F4572Z1Live Promotions Interface - Inbound / Outbound23LPAN8Address NumberNumericUDC80
644F4572ZPPurge Live Promotions Interface23PGAN8Address NumberNumericUDC80
645F4574Key Reference Table13KRAN8Address NumberNumericUDC80
646F4575Ship and Debit History13AHAN8Address NumberNumericUDC80
647F4575TMPShip and Debit History - Temp Table13AHAN8Address NumberNumericUDC80
648F4576Ship and Debit Claims14ACAN8Address NumberNumericUDC80
649F4576TMPShip and Debit Claims- Temp Table14ACAN8Address NumberNumericUDC80
650F4576Z1Ship and Debit Claims Unedited Transaction Table27Z1AN8Address NumberNumericUDC80
TOP46: Warehouse Management
651F4600Warehouse Requests11R1AN8Address NumberNumericUDC80
652F4600PUWarehouse Requests - Purged11R1AN8Address NumberNumericUDC80
653F460131Standard Pack Recommendation Rules2SPAN8Address NumberNumericUDC80
654F4611Warehouse Suggestions117R2AN8Address NumberNumericUDC80
655F4611PUWarehouse Suggestions - Purged116R2AN8Address NumberNumericUDC80
656F4611Z1Unedited Suggestion Table128SZAN8Address NumberNumericUDC80
657F46130Putaway Reservations8R3AN8Address NumberNumericUDC80
658F46130PUPutaway Reservations - Purged8R3AN8Address NumberNumericUDC80
659F4615Carton Recommendations16CRAN8Address NumberNumericUDC80
660F46201Carton Charge Reference Setup1CCAN8Address NumberNumericUDC80
661F46UI15Carton Recommendations - Work File16RCAN8Address NumberNumericUDC80
662F4942Z1Work File for F494221SYAN8Address NumberNumericUDC80
TOP46L: License Plating
663F46L060LPN Supplier Inbound ASN Levels2SIAN8Address NumberNumericUDC80
664F46L070LPN Supplier Cross Reference2SCAN8Address NumberNumericUDC80
665F46LUI01Assign/Remove Items To LP Work File30WFAN8Address NumberNumericUDC80
TOP46R: RFID Outbound
666F46R070EPC Company Length Definition3ECAN8Address NumberNumericUDC80
TOP47: Electronic Commerce
667F47011EDI Purchase Order Header - Inbound31SYAN8Address NumberNumericUDC80
668F47012EDI Purchase Order Detail - Inbound32SZAN8Address NumberNumericUDC80
669F47016EDI Purchase Order Header - Outbound27SYAN8Address NumberNumericUDC80
670F470161EDI Purchase Order Additional Header - Outbound14S3AN8Address NumberNumericUDC80
671F47017EDI Purchase Order Detail - Outbound32SZAN8Address NumberNumericUDC80
672F470171EDI Purchase Order Additional Detail - Outbound15S4AN8Address NumberNumericUDC80
673F47021EDI P.O. Acknowledgment Header - Inbound27SYAN8Address NumberNumericUDC80
674F47022EDI P.O. Acknowledgment Detail - Inbound32SZAN8Address NumberNumericUDC80
675F47026EDI P.O. Acknowledgment Header - Outbound28SYAN8Address NumberNumericUDC80
676F47027EDI P.O. Acknowledgment Detail - Outbound32SZAN8Address NumberNumericUDC80
677F47031EDI Shipping Notice Header - Inbound28SYAN8Address NumberNumericUDC80
678F47032EDI Shipping Notice Detail - Inbound35SZAN8Address NumberNumericUDC80
679F47037EDI Shipping Notice Detail - Outbound33SZAN8Address NumberNumericUDC80
680F470371EDI Shipping Notice Detail - Outbound33SZAN8Address NumberNumericUDC80
681F47041EDI Invoice Header - Inbound23SYAN8Address NumberNumericUDC80
682F47042EDI Invoice Detail - Inbound26SZAN8Address NumberNumericUDC80
683F47044EDI Invoice Summary - Inbound23SWAN8Address NumberNumericUDC80
684F47046EDI Invoice Header (Sales) - Outbound28SYAN8Address NumberNumericUDC80
685F470461EDI Invoice Additional Header - Outbound16S3AN8Address NumberNumericUDC80
686F470462EDI Invoice Expanded Header (Sales)8S5AN8Address NumberNumericUDC80
687F47047EDI Invoice Detail (Sales) - Outbound32SZAN8Address NumberNumericUDC80
688F470471EDI Invoice Additional Detail - Outbound17S4AN8Address NumberNumericUDC80
689F47056EDI Payment Order Header - Outbound26D1AN8Address NumberNumericUDC80
690F470561EDI Payment Order Bank N and A - Outbound18D2AN8Address NumberNumericUDC80
691F470561WEDI Payment Order Bank N and A - Work20D2AN8Address NumberNumericUDC80
692F470562EDI Payment Order Vendor N and A - Outbound18D4AN8Address NumberNumericUDC80
693F470562WEDI Payment Order Vendor N and A - Work18D4AN8Address NumberNumericUDC80
694F470563EDI Payment Order Payee N and A - Outbound18D5AN8Address NumberNumericUDC80
695F470563WEDI Payment Order Payee N and A - Work18D5AN8Address NumberNumericUDC80
696F47056WEDI Payment Order Header - Work26D1AN8Address NumberNumericUDC80
697F47057EDI Payment Order Remittance Advice - Outbound26D3AN8Address NumberNumericUDC80
698F47057WEDI Payment Order Remittance Advice - Work26D3AN8Address NumberNumericUDC80
699F4706EDI Order Address Information14ZAAN8Address NumberNumericUDC80
700F47061EDI Planning Schedule Header - Inbound27MJAN8Address NumberNumericUDC80
701F47066EDI Planning Schedule Header - Outbound27MJAN8Address NumberNumericUDC80
702F47071EDI Receiving Advice Header - Inbound28SYAN8Address NumberNumericUDC80
703F47072EDI Receiving Advice Detail - Inbound33SZAN8Address NumberNumericUDC80
704F47076EDI Receiving Advice Header - Outbound28SYAN8Address NumberNumericUDC80
705F47077EDI Receiving Advice Detail - Outbound33SZAN8Address NumberNumericUDC80
706F47081EDI Price Sales Catalog Header - Inbound18FVAN8Address NumberNumericUDC80
707F47091EDI Request for Quote Header - Inbound31SYAN8Address NumberNumericUDC80
708F47092EDI Request for Quote Detail - Inbound32SZAN8Address NumberNumericUDC80
709F47096EDI Request for Quote Header - Outbound27SYAN8Address NumberNumericUDC80
710F47097EDI Request for Quote Detail - Outbound32SZAN8Address NumberNumericUDC80
711F47098EDI RFQ Detail Quantity - Outbound11SZAN8Address NumberNumericUDC80
712F47101EDI Response to RFQ Header - Inbound27SYAN8Address NumberNumericUDC80
713F47102EDI Response to RFQ Detail - Inbound32SZAN8Address NumberNumericUDC80
714F47103EDI Response to RFQ Detail Quantity - Inbound11SZAN8Address NumberNumericUDC80
715F47106EDI Response to RFQ Header - Outbound28SYAN8Address NumberNumericUDC80
716F471061EDI Response to RFQ Additional Header - Outbound16S3AN8Address NumberNumericUDC80
717F47107EDI Response to RFQ Detail - Outbound32SZAN8Address NumberNumericUDC80
718F471071EDI Response to RFQ Additional Detail - Outbound17S4AN8Address NumberNumericUDC80
719F47113EDI Lockbox/Payment Detail - Batch15Z3AN8Address NumberNumericUDC80
720F47121EDI Product Activity Data Header - Inbound16M1AN8Address NumberNumericUDC80
721F47122EDI Product Activity Data Detail - Inbound19MJAN8Address NumberNumericUDC80
722F47126EDI Product Activity Data Header - Outbound16M1AN8Address NumberNumericUDC80
723F47127EDI Product Activity Data Detail - Outbound19MJAN8Address NumberNumericUDC80
724F47131EDI Purchase Order Change Header - Inbound28SYAN8Address NumberNumericUDC80
725F47132EDI Purchase Order Change Detail - Inbound33SZAN8Address NumberNumericUDC80
726F47136EDI Purchase Order Change Header - Outbound27SYAN8Address NumberNumericUDC80
727F47137EDI Purchase Order Change Detail - Outbound33SZAN8Address NumberNumericUDC80
728F47141EDI P.O. Change Acknowledgment Header - Inbound28SYAN8Address NumberNumericUDC80
729F47142EDI P.O. Change Acknowledgment Detail - Inbound34SZAN8Address NumberNumericUDC80
730F47146EDI P.O. Change Acknowledgment Header - Outbound29SYAN8Address NumberNumericUDC80
731F47147EDI P.O. Change Acknowledgment Detail - Outbound34SZAN8Address NumberNumericUDC80
732F47156EDI Shipping Schedule Header - Outbound28SYAN8Address NumberNumericUDC80
733F47157EDI Shipping Schedule Detail - Outbound33SZAN8Address NumberNumericUDC80
734F47191EDI Acknowledgement Header23AHAN8Address NumberNumericUDC80
735F4722EDI Tolerance Rules2PZAN8Address NumberNumericUDC80
736F4780Address Cross-Reference3AXAN8Address NumberNumericUDC80
737F47HLHierarchical Configuration4HLAN8Address NumberNumericUDC80
TOP48: Work Order Processing
738F4801Work Order Master File22WAAN8Address NumberNumericUDC80
739F4808Order Routing Approval Master5CAAN8Address NumberNumericUDC80
740F4818Order Approval Audit4CBAN8Address NumberNumericUDC80
741F4827Work Order Approval Routing7W5AN8Address NumberNumericUDC80
742F48UI001X4801 Master Business Function Workfile25WAAN8Address NumberNumericUDC80
TOP48S: Service Billing
743F48096Billing Rate / Mark up Table19WQAN8Address NumberNumericUDC80
744F4812Billing Detail Workfile42WDAN8Address NumberNumericUDC80
745F4812HBilling Workfile - History42WDAN8Address NumberNumericUDC80
746F4812HSBilling Workfile History Purged Save42WDAN8Address NumberNumericUDC80
747F48520Invoice Summary Access2AEAN8Address NumberNumericUDC80
748F48S0618Payroll Reclassification Workfile1YTAN8Address NumberNumericUDC80
749F48S910Billing Detail Journal File28W2AN8Address NumberNumericUDC80
750F48S911Compressed Journal File34W3AN8Address NumberNumericUDC80
751F48SUI01Billing Detail Print Workfile42WDAN8Address NumberNumericUDC80
TOP49: Transportation Management
752F49110Transportation Bill of Lading Workfile13BWAN8Address NumberNumericUDC80
753F49141Packing List Workfile9PWAN8Address NumberNumericUDC80
754F4963Load In-transit6TIAN8Address NumberNumericUDC80
755F49631Load In-transit Ledger34TOAN8Address NumberNumericUDC80
756F49632Load In-transit Left on Board6LBAN8Address NumberNumericUDC80
757F49695Document Register21DRAN8Address NumberNumericUDC80
TOP51: Job Costing
758F51911Draw Reporting Master12GKAN8Address NumberNumericUDC80
TOP52: Contract Billing
759F5212T and M - Unit Price and Lumpsum Cross Reference Accounts16G5AN8Address NumberNumericUDC80
760F5280WContract Revenue Summary Work File25GYAN8Address NumberNumericUDC80
TOP55: Reserved for Clients
761F5574T12Cash Flow Table -BO1CFAN8Address NumberNumericUDC80
762F5574T14New Credit Analysis Report -BO2CAAN8Address NumberNumericUDC80
763F55ARAP1ARandAP TEMP TABLE1ARAN8Address NumberNumericUDC80
764F55CS001Check/Draft Integrity Report2CSAN8Address NumberNumericUDC80
765F55IF001Address Book Extension1EXAN8Address NumberNumericUDC80
766F55IF311As Of1RPAN8Address NumberNumericUDC80
767F55IF421Sales Order per BO19SDAN8Address NumberNumericUDC80
768F55IF425Sales Order per BO - 200519SDAN8Address NumberNumericUDC80
769F55IFCCHCredit Check Info4X1AN8Address NumberNumericUDC80
770F55IFPRPFatture soggette a promozione10PPAN8Address NumberNumericUDC80
771F55IFRTtabella esportazione3RTAN8Address NumberNumericUDC80
772F55IFSCHCust / Supp Balance Workfile - Copia estesa di F744126RPAN8Address NumberNumericUDC80
773F55IFSFVEstrazione del venduto per Sales Force Automation3FSAN8Address NumberNumericUDC80
774F55IFTARCustomer Target and Share Info4TAAN8Address NumberNumericUDC80
775F55IFVABOutput File di R55IFVALB1OZAN8Address NumberNumericUDC80
776F55IFVALOutput File di R55IFVALOR4FAAN8Address NumberNumericUDC80
777F55IFWKFWork File F0911_wkf script ribaltamento costi4WFAN8Address NumberNumericUDC80
778F55LOC01Lokasyon-Satisci Iliskisi2LOAN8Address NumberNumericUDC80
779F55PREMIPremi a cliente2PRAN8Address NumberNumericUDC80
780F55SCONTSconti a cliente3SCAN8Address NumberNumericUDC80
781F55W0100Correction Invoice Print - WF119SDAN8Address NumberNumericUDC80
782F59SHL02Souhrnné hlá?ení k DPH - sumární8SHAN8Address NumberNumericUDC80
783F74401W/T Additional A/B Information - Italy1RFAN8Address NumberNumericUDC80
784F7460Next Auto Debit Number2QLAN8Address NumberNumericUDC80
785F74H1050Invoicing Workfile Header - New7IHAN8Address NumberNumericUDC80
786F74H1051Invoicing Workfile - New15IWAN8Address NumberNumericUDC80
787F74Q0165WF do R74Q016510WFAN8Address NumberNumericUDC80
788F74Q0175WF dla R74Q01755WFAN8Address NumberNumericUDC80
789F74T531Customer Ledger Tranaction File5CTAN8Address NumberNumericUDC80
790F74T532Supplier Ledger Transaction File5SLAN8Address NumberNumericUDC80
791F74T100WEndorsment Temp Table1MKAN8Address NumberNumericUDC80
792F74T133Customer Year End Table2CTAN8Address NumberNumericUDC80
793F74T134Supplier Year End Table2STAN8Address NumberNumericUDC80
794F59BF001B Formlar? Tablosu7BFAN8Address NumberNumericUDC80
795F59BN01Garanti Bankasi Cek/Senet Entegrasyon Tablosu31BNAN8Address NumberNumericUDC80
796F59I0022P07 Shipment Details - Serial Numbers5PSAN8Address NumberNumericUDC80
TOP74: EMEA Localization
797F0018TIntrastat Revision9TDAN8Address NumberNumericUDC80
798F00900Year-End VAT Revision File - Italy3IRAN8Address NumberNumericUDC80
799F0091A/B Vendor Information for Year-end IVA tape - Italy1IFAN8Address NumberNumericUDC80
800F7400B1Belgium VAT Work File1QAAN8Address NumberNumericUDC80
801F74030GGermany-Bank Transit Number Master File Addtl Information4AYAN8Address NumberNumericUDC80
802F74030HDutch-Payments Bank Information1NLAN8Address NumberNumericUDC80
803F74093Workfile for Printing IVA Summary - Italy9HCAN8Address NumberNumericUDC80
804F741001TAddress Book Tag File - COMM - 011ATAN8Address NumberNumericUDC80
805F7430010Legal Document Header - COMM - 03B8LDAN8Address NumberNumericUDC80
806F7430030Legal Document Header (Print Info) - COMM - 03B8PIAN8Address NumberNumericUDC80
807F7430031Legal Document Address (Print Info) - COMM - 03B4PIAN8Address NumberNumericUDC80
808F744101Intrastat Supplier/Item Cross Reference Table2INAN8Address NumberNumericUDC80
809F74411Withholding Tax Detail File-Italy7RSAN8Address NumberNumericUDC80
810F74412Customer / Supplier Balance Workfile (A/R and A/P)8RPAN8Address NumberNumericUDC80
811F74413VAT Ceiling Limit-Italy19VCAN8Address NumberNumericUDC80
812F74900Foreign Receivables and Payables - EMEA7RPAN8Address NumberNumericUDC80
813F74S55Expenses and Exchange Rate for Payments - Spain4Q5AN8Address NumberNumericUDC80
TOP74B: Begium Localization
814F7403B11Belgium - Work File Yearly Vat Declaration Data1QAAN8Address NumberNumericUDC80
815F74B200Yearly/Quarterly VAT Listing - Belgium1VTAN8Address NumberNumericUDC80
TOP74H: Hungary
816F74H1010Effective EU Tax Identifiers1AEAN8Address NumberNumericUDC80
TOP74P: Poland
817F74P03BWA/R Trial Balance - POL - 03B - 74P10P3AN8Address NumberNumericUDC80
818F74P04WA/P Trial Balance Work Table - POL - 04 - 74P10P2AN8Address NumberNumericUDC80
TOP74R: CIS
819F74R0007Legal Document Footer Signature Setup - RUS - 00 - 74R8FSAN8Address NumberNumericUDC80
820F74R0018Russian Tax File - 74R41TDAN8Address NumberNumericUDC80
821F74R0100Petty Cash Transactions - RUS - 00 - 74R22PCAN8Address NumberNumericUDC80
822F74R101TAddress Book Tag File - RUS - 01 - 74R1ABAN8Address NumberNumericUDC80
823F74R3031Legal Document Address (Print Info) - RUS - 03B - 74R4PIAN8Address NumberNumericUDC80
TOP74S: Spain
824F74S0010Company Tag File - Spain2CCAN8Address NumberNumericUDC80
825F74S74Additional Information for 347 and 349 Models - Spain1Q4AN8Address NumberNumericUDC80
TOP74U: United Kingdom Localizations
826F74U25BTInterest Tag Table - 153PKAN8Address NumberNumericUDC80
827F74U4015AB - HMRC Information Relation - UK - 041IRAN8Address NumberNumericUDC80
TOP74Y: Italy - Reporting System Only
828F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy12TIAN8Address NumberNumericUDC80
TOP75A: Australia - Reporting System Only
829F75A0003Australia/New Zealand tax calculation rules5ZRAN8Address NumberNumericUDC80
830F75A0005Coinage Details Work File1A5AN8Address NumberNumericUDC80
831F75A0006Australian Employee Tax Overrides1ZEAN8Address NumberNumericUDC80
832F75A0009Employee DBA Instructions1A9AN8Address NumberNumericUDC80
833F75A0010Australian Employee Termination Details1A0AN8Address NumberNumericUDC80
834F75A0140Australian Group Certificates1ZGAN8Address NumberNumericUDC80
835F75A0201Recipient Created Tax Invoice Tag File1TFAN8Address NumberNumericUDC80
836F75A0202GST - RCTI Adjustment Print Control Table1RAAN8Address NumberNumericUDC80
837F75A0220Payment Summary Workfile3PSAN8Address NumberNumericUDC80
838F75A0301Superannuation Payment1SAAN8Address NumberNumericUDC80
839F75A670Long Service Leave Dates1LLAN8Address NumberNumericUDC80
840F75A671Long Service Leave Audit1LAAN8Address NumberNumericUDC80
TOP75C: China - Reporting System Only
841F0018CNChina - Transmitted vouchers to JinSui9CTAN8Address NumberNumericUDC80
TOP75J: Japan - Reporting System Only
842F750401Japanese A/B Tag File1J4AN8Address NumberNumericUDC80
843F750401AAddress Book - Withholding Tax Category-Japan1JJAN8Address NumberNumericUDC80
844F750411Withholding Tax Detail Table - Japan8JXAN8Address NumberNumericUDC80
845F75C0401China Supplier Master Additional Information1CSAN8Address NumberNumericUDC80
TOP75T: Taiwan
846F75T001GUI/VAT Declaration Site - 75T18DSAN8Address NumberNumericUDC80
847F75T004GUI/VAT Transaction Header - 75T50THAN8Address NumberNumericUDC80
848F75T0049GUI/VAT Transaction Header History - 75T50THAN8Address NumberNumericUDC80
849F75T004PGUI/VAT Transaction Header POS - 75T50THAN8Address NumberNumericUDC80
850F75T004ZGUI/VAT Transaction Header - Work - 75T30ZHAN8Address NumberNumericUDC80
851F75T009GUI/VAT Customer Constants - 75T1DVAN8Address NumberNumericUDC80
852F75T0091GUI/VAT Supplier Constants - 75T1SDAN8Address NumberNumericUDC80
TOP75Z: New Zealand - Reporting System Only
853F75Z0001New Zealand Special Processing Parameters4Z1AN8Address NumberNumericUDC80
854F75Z0002New Zealand Ledger Detail1Z2AN8Address NumberNumericUDC80
855F75Z0003New Zealand Average Gross Earnings Master1Z3AN8Address NumberNumericUDC80
856F75Z0004New Zealand Average Gross Earnings Detail1Z4AN8Address NumberNumericUDC80
857F75Z0005New Zealand Employee Tax Overrides1ZDAN8Address NumberNumericUDC80
858F75Z0006Leave Taken A.G.E. Work File1Z6AN8Address NumberNumericUDC80
859F75Z0009New Zealand Tax Detail Work File1TXAN8Address NumberNumericUDC80
860F75Z0010New Zealand Tax Detail Tag Table1TDAN8Address NumberNumericUDC80
TOP76A: Argentina
861F760101AA/B Tag File - ARG1V0AN8Address NumberNumericUDC80
862F760406AProfit Withholding - Payments Done - ARG1K6AN8Address NumberNumericUDC80
863F760473APCG Detail Information Tag File - ARG - 048E5AN8Address NumberNumericUDC80
864F760499AContract Withholding - Advances - ARG -04 - 042K8AN8Address NumberNumericUDC80
865F7607AWithholding Exempt Percentage - ARG - 04 - 041V4AN8Address NumberNumericUDC80
866F7608ASupplier State Agreement - ARG - 041V5AN8Address NumberNumericUDC80
867F76A0110UTE Members - 76A1U1AN8Address NumberNumericUDC80
868F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A23HFAN8Address NumberNumericUDC80
869F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A23HFAN8Address NumberNumericUDC80
870F76A043A/P Tag File - CAI Storage - ARG - 041RGAN8Address NumberNumericUDC80
871F76A0456Security Withholding Payments Done - ARG1X1AN8Address NumberNumericUDC80
872F76A09Invoice Total - ARG - 00 - 0017TTAN8Address NumberNumericUDC80
873F76A09PInvoice Total Purge - ARG - 03B - 76A17TTAN8Address NumberNumericUDC80
874F76A13Taxes - Tax Values - ARG - 002TVAN8Address NumberNumericUDC80
875F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 0010TOAN8Address NumberNumericUDC80
876F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A10TOAN8Address NumberNumericUDC80
877F76A19Taxes - Tax Amounts by Invoice Suffix AGR10TIAN8Address NumberNumericUDC80
878F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A10TIAN8Address NumberNumericUDC80
879F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B28VKAN8Address NumberNumericUDC80
880F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A5IEAN8Address NumberNumericUDC80
881F76A401UTE Members Type - ARG - 042UTAN8Address NumberNumericUDC80
882F76A8001Generation SICORE's Files - Last Step -RG 738/99 - 0423V2AN8Address NumberNumericUDC80
883F76A8002SICORE RG738 Withholding Entity8V3AN8Address NumberNumericUDC80
884F76A8011Supplier Information RG 726 - 043PAAN8Address NumberNumericUDC80
885F76A8015RG814 - Profit Withholding and Payment Order - ARG - 04 - 76A1PWAN8Address NumberNumericUDC80
886F76A8020Gross Income Exempt Percentage - ARG - 04 - 76A1EPAN8Address NumberNumericUDC80
887F76A8050Perceptions Exempt Percentages - 03B1PPAN8Address NumberNumericUDC80
888F76A8070Profit Withholding - Payments Done - RG 830 - ARG - 0 - 76A1K7AN8Address NumberNumericUDC80
889F76A81A/P Payment Control Group File - ARG - 04 - 76A5C5AN8Address NumberNumericUDC80
890F76A82A/P Payment Control Group File - ARG - 04 - 76A4C6AN8Address NumberNumericUDC80
891F76A8230Percentages by state / agreement Gross Income - ARG - - 76A7C1AN8Address NumberNumericUDC80
892F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0023HFAN8Address NumberNumericUDC80
893F76AUI22WF - Legal Reports Errors - ARG - 007WFAN8Address NumberNumericUDC80
894F76AUI24Taxes Work File - ARG - 0010TIAN8Address NumberNumericUDC80
895F76AUI44CERG A/P - Work File - ARG - 04 - 049WFAN8Address NumberNumericUDC80
896F76AUI46CERG A/R -Work File - ARG - 03B - 03B9WFAN8Address NumberNumericUDC80
897F76AUI51Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A3IKAN8Address NumberNumericUDC80
898F76AUI81Draft - Invoices Work File - ARG - 03B - 76A7WFAN8Address NumberNumericUDC80
899F76AUI82Draft - Drafts Work File - ARG - 03B - 03B41WFAN8Address NumberNumericUDC80
900F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A17WFAN8Address NumberNumericUDC80
901F76AUI84Supplier Without information from Internet - Rg 7263INAN8Address NumberNumericUDC80
902F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A9WFAN8Address NumberNumericUDC80
TOP76B: Brazil - Reporting System Only
903F76011Address Book Brazilian Tag File1AIAN8Address NumberNumericUDC80
904F76011PArchive Address Book Brazilian Tag Table - 041PRAN8Address NumberNumericUDC80
905F7601BNota Fiscal Header - Brazil14FHAN8Address NumberNumericUDC80
906F7603B1A/R Additional Information - Brazil5CIAN8Address NumberNumericUDC80
907F7603B1PArchive A/R Additional Information - Brazil - 03B5BPAN8Address NumberNumericUDC80
908F76101BNota Fiscal - Header (Fiscal Books) - 4210QXAN8Address NumberNumericUDC80
909F7611BNota Fiscal Detail - Brazil42FDAN8Address NumberNumericUDC80
910F761BAAS Fiscal file book45FBAN8Address NumberNumericUDC80
911F76421Sales Order Header Tag File - Brazil7SIAN8Address NumberNumericUDC80
912F76B0403Service Taxes Paid Externally - 041STAN8Address NumberNumericUDC80
913F76B0411Voucher Additional Information Brazil - 046VBAN8Address NumberNumericUDC80
914F76B04AGeneration for Federal Tax Authority - 042RFAN8Address NumberNumericUDC80
915F76B20Account Payable and Receivable Table - IN68 - 03B3PRAN8Address NumberNumericUDC80
916F76B30Nota Fiscal Header/Table for Goods - IN68 - 428MMAN8Address NumberNumericUDC80
917F76B31Nota Fiscal Detail/Table for Goods - IN68 - 426IMAN8Address NumberNumericUDC80
918F76B40Nota Fiscal Header/Table for Services - IN68 - 428MSAN8Address NumberNumericUDC80
919F76B41Nota Fiscal Detail/Table for Services - IN68 - 426ISAN8Address NumberNumericUDC80
920F76B410CIN86-Work Table for Services Outbound Nota Fiscal Hea - 428SHAN8Address NumberNumericUDC80
921F76B410DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4210CHAN8Address NumberNumericUDC80
922F76B473TF04573 Brazilian Temp WH File - BR - 048W3AN8Address NumberNumericUDC80
923F76B70Physical and Legal Person Table - IN68 - 423FJAN8Address NumberNumericUDC80
924F76B8601IN86-Work Table for Individuals and Legal Entities - 042FJAN8Address NumberNumericUDC80
925F76B8602IN86-Work Table for Suppliers and Customers - 045PRAN8Address NumberNumericUDC80
926T76B001Temporary file for DIPJ - Customer / Supplier - 421QAAN8Address NumberNumericUDC80
TOP76C: Colombia
927F76C001General Parameters - COL - 049PGAN8Address NumberNumericUDC80
928F76C0101A/B Tag File - COL - 76C1V0AN8Address NumberNumericUDC80
929F76C031AA/R Customer ledger As Of - F76C031A - COL - 045RPAN8Address NumberNumericUDC80
930F76C034AA/R Check Detail file As Of - COL - 76C8RZAN8Address NumberNumericUDC80
931F76C0411A/P Tag File - COL - 76C6RPAN8Address NumberNumericUDC80
932F76C575Work File Magnetic Media - COL - 0411Q1AN8Address NumberNumericUDC80
933F76CT1Tributary Information - COL - 76C10TIAN8Address NumberNumericUDC80
934F76CT2Sales/Use/V.A.T. Tax File - COL - 76C6CTAN8Address NumberNumericUDC80
935F76CUI02Tax Detail - Work File - COL - 76C8TDAN8Address NumberNumericUDC80
936F76CUI04Tax Detail for Distribution - Work File - COL - 76C9TDAN8Address NumberNumericUDC80
TOP76E: Ecuador
937F76E0001Tax Person Code - ECU - 76E1TCAN8Address NumberNumericUDC80
938F76E4010Withholding Certificate Information - EC - 047CEAN8Address NumberNumericUDC80
939F76E4020Withholding Certificate Information w/ SRI - EC - 043CRAN8Address NumberNumericUDC80
TOP76H: Chile
940F76H101TAddress Book Tag File - CHI - 01 - 76H1AHAN8Address NumberNumericUDC80
941F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H6PIAN8Address NumberNumericUDC80
942F76H611Actual Item Ledger File - CHI - 41 - 76H37ALAN8Address NumberNumericUDC80
TOP76P: Peru
943F76P101TAddress Book Tag File - PER - 01 - 76P1APAN8Address NumberNumericUDC80
944F76P473TF04573 Tag File - PER - 04 - 76P8K3AN8Address NumberNumericUDC80
TOP76V: Venezuela
945F76V0401Relation Invoice/Retention Code - VEN - 76V5REAN8Address NumberNumericUDC80
946F76V1001A/B Additional Info. Tag File - VE - 011WCAN8Address NumberNumericUDC80
947F76V101ZEDI A/B Additional Information - VE - 015ZWAN8Address NumberNumericUDC80
948F76V4011A/P Ledger Tag File - VEN - 045TFAN8Address NumberNumericUDC80
949F76V411ZVoucher Batch Upload Tag File - VEN - 045BIAN8Address NumberNumericUDC80
950F76V4581Withholding Historical File - VEN - 047HRAN8Address NumberNumericUDC80
951F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 042TDAN8Address NumberNumericUDC80
952F76VLV02Temporal for receipts from F03B14 - VEN - 03B - 76V3COAN8Address NumberNumericUDC80
953F76VLVCFControl Invoice Number for Sales Register - VEN - 03B - 76V2CFAN8Address NumberNumericUDC80
954F76VTARTTemporal Table for Withholdings - VEN -04 - 76V4TRAN8Address NumberNumericUDC80
TOP77: Payroll (Canadian)
955F06176Unemployment Insurance History File1YSAN8Address NumberNumericUDC80
956F0713Tax History1YZAN8Address NumberNumericUDC80
957F0713SAVBackup Copy of F0713 For Tax Ledger Repost1YZAN8Address NumberNumericUDC80
958F0716Pay Check History Tax Ledger - Canadian DB1YVAN8Address NumberNumericUDC80
959F07183Commission History Detail File1ZBAN8Address NumberNumericUDC80
960F77173ROE Summary History Work File1JFAN8Address NumberNumericUDC80
961F77200Canadian Employee Year-End Form Header - F772003J5AN8Address NumberNumericUDC80
962F77201TNegative Amount Print3NAAN8Address NumberNumericUDC80
963F77210Canadian Employee Year-End Form Detail - F722103J6AN8Address NumberNumericUDC80
964F77220Employee Special Handling Detail - F772203J3AN8Address NumberNumericUDC80
965F77230Employee Pension Maintenance - F772305J8AN8Address NumberNumericUDC80
966F77703Payroll History Audit Report - Worktable1ARAN8Address NumberNumericUDC80
TOP89: Conversion Programs
967F06116TNeeded for upgrade from Xe to B92YTAN8Address NumberNumericUDC80
968F0618TNeeded for upgrade from Xe to B92YTAN8Address NumberNumericUDC80
969F07186TPiece Rate History File12Y8AN8Address NumberNumericUDC80
970F07352TPiece Rate Stub Detail Tag File13Y2AN8Address NumberNumericUDC80
971F40344ATemporay Preference Profile - Sales Commission1SAAN8Address NumberNumericUDC80
972F4072TEMPrice Adjustment Detail - Temp for Upgrade5ADAN8Address NumberNumericUDC80
973F42005ASales Commission File - Temporary6SCAN8Address NumberNumericUDC80
974F42140ACopy from F42140 to Temp Table F42140A1CMAN8Address NumberNumericUDC80
975F43199ATemp F43199 for ERP 9.0 Upgrade19OLAN8Address NumberNumericUDC80
976F89AD020Person_Address cross reference table2PEAN8Address NumberNumericUDC80
977F89AD050Lookup table for populating CRM Partner Addresses2PAAN8Address NumberNumericUDC80
978F89AD060Lookup table for populating CRM Competitor Addresses2ADAN8Address NumberNumericUDC80
979F89CA080Lookup Table for CRM to EOne Company Ids2COAN8Address NumberNumericUDC80
980F89CB06CTable - Opportunity_For_FCST_ID - Opportunity Lookup Table3TCAN8Address NumberNumericUDC80
981F89LUADDAddress lookup table2ADAN8Address NumberNumericUDC80
TOP90CA: CRM Foundation
982F90CA001F0101 Used Address Book Number Table1UAAN8Address NumberNumericUDC80
983F90CA002F90CB02E Mirror table for sync filtering.2OMAN8Address NumberNumericUDC80
984F90CA003F42140 Mirror table for sync filtering.1SMAN8Address NumberNumericUDC80
985F90CA004F42150 and F42160 Aggregate table for sync filtering.1AGAN8Address NumberNumericUDC80
986F90CA030Profile Table1PRAN8Address NumberNumericUDC80
987F90CA042Flat Employee Hierarchy1EMAN8Address NumberNumericUDC80
988F90CA18CSales Team Alignment Table1STAN8Address NumberNumericUDC80
989F90CA50BMEMBER PERSON Table1MEAN8Address NumberNumericUDC80
990F90CA50DEMAIL CONTACT Table2EMAN8Address NumberNumericUDC80
991F90CA63EActivity Customer Associative Table (FOR CRM UPGRADE)1ACAN8Address NumberNumericUDC80
992F90CA902Email_Extension Table1EEAN8Address NumberNumericUDC80
TOP90CB: CRM Sales Force Automation
993F90CB02DOpportunity_Contact Table2ODAN8Address NumberNumericUDC80
994F90CB02MCost Table40OMAN8Address NumberNumericUDC80
TOP90CG: CRM Case Management
995F90CG506Provider Group Employees1ZCAN8Address NumberNumericUDC80
TOPD3N: dcLINK (data collection) - DSI
996FD3N0001dcLINK Xpress Check Out1ZZAN8Address NumberNumericUDC80
997FD3N0200Employee Join/Leave Pattern History File1JLAN8Address NumberNumericUDC80
998FD3N0201Employee Join/Leave Employee Selection Cache2ESAN8Address NumberNumericUDC80
999FD3N161PPallet Tracking Table 411PHAN8Address NumberNumericUDC80
1000FD3N913TranPrint - Default Labels - Table6DLAN8Address NumberNumericUDC80
TOPF31: Lean Transactions
1001FF31010Production Master File28EHAN8Address NumberNumericUDC80
1002FF31011TransactionID Master File19EHAN8Address NumberNumericUDC80
1003FF31011SPurge - TransactionID Master File19ERAN8Address NumberNumericUDC80
1004FF31111Lean Transaction Parts List36PLAN8Address NumberNumericUDC80
1005FF31111SPurge - Lean Transaction Parts List36PRAN8Address NumberNumericUDC80
1006FF31112Routing Transaction Table31EHAN8Address NumberNumericUDC80
1007FF31112SPurge - Routing Transaction Table31ETAN8Address NumberNumericUDC80
1008FF31113Lean Transaction Labor Detail6LDAN8Address NumberNumericUDC80
1009FF31113SPurge - Lean Transaction Labor Detail6LRAN8Address NumberNumericUDC80
TOPH90: ONEWORLD TOOLS
1010F0112Time Log Ledger File1PTAN8Address NumberNumericUDC80
1011F01131PPAT Message Control File2ZZAN8Address NumberNumericUDC80
1012F01131MJDEM Multi Level Message6ZMAN8Address NumberNumericUDC80
1013F01133PPAT Message Detail File2ZTAN8Address NumberNumericUDC80
1014F01136JDEM Mail Filters2ZPAN8Address NumberNumericUDC80
1015F01137Workflow Message Security1ZXAN8Address NumberNumericUDC80
1016F99HDRWorkflow Demonstration Sales Order Header2WHAN8Address NumberNumericUDC80
TOPH91: Design Tools
1017F9801NEWEmployee Information - New Version1AAAN8Address NumberNumericUDC80
1018F9801OLDEmployee Information - Old Version1AAAN8Address NumberNumericUDC80
1019F98TCHDRTable Conversion Header6HDAN8Address NumberNumericUDC80
TOPH95: Tech Resources/Applications
1020F00166Media Object Categories16GTAN8Address NumberNumericUDC80
1021F0092Library Lists - User41ULAN8Address NumberNumericUDC80
1022F9500003Audit Header Table4AHAN8Address NumberNumericUDC80
1023F9500005Temporary Audit Table18TAAN8Address NumberNumericUDC80
1024F98OWNTUOneWorld NT Users1NTAN8Address NumberNumericUDC80
TOPH96: Deployment
1025F9660Task Breaks6TBAN8Address NumberNumericUDC80