JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

5097 tables920

<
00: Foundation Environment
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0000194SY51Generic Interface Table for B0000194Files09: General AccountingBusiness Data
2920F0002NN311Next Numbers - AutomaticConstants Files09: General AccountingControl Tables
3920F00021NL101Next Numbers by Company/Fiscal Year - AutomaticConstants Files09: General AccountingControl Tables
4920F00022UK21Unique Key File - Next Available Unique KeyConstants Files41: Inventory ManagementBusiness Data
5920F00023DN245Distributed Next Number TableMaster Files90CA: CRM FoundationSystem Tables
6920F0006MC1527Business Unit MasterMaster Files09: General AccountingBusiness Data
7920F0006DLJ72Business Unit Alternate Description MasterExtra Features Files09: General AccountingBusiness Data
8920F0006DZ1SZ261Business Unit Alternate Description Z fileExtra Features Files09: General AccountingBusiness Data
9920F0006SMC1571Date Effective Business Unit MasterExtra Features Files09: General AccountingBusiness Data
10920F0006S1SH81Business Unit Snapshot HeaderExtra Features Files09: General AccountingBusiness Data
11920F0006Z1SZ1611Cost Center Unedited Transaction TableBatch Input Files05A: PeopleSoft HR & PR FoundationBusiness Data
12920F0006Z2SZ1651Business Unit Master Z FileMaster Files09: General AccountingBusiness Data
13920F0007CZ433Workday CalendarExtra Features Files30: Product Data ManagementBusiness Data
14920F0008CD252Date Fiscal PatternsConstants Files09: General AccountingBusiness Data
15920F00085DS181Daylight Savings RulesConstants FilesH91: Design ToolsSystem Tables
16920F0008BCD631Date Fiscal Patterns - 52 Period AccountingConstants Files09: General AccountingBusiness Data
17920F0009GC661General ConstantsConstants Files09: General AccountingBusiness Data
18920F00090T1221Supplemental Database SetupConstants Files41: Inventory ManagementBusiness Data
19920F00090DT581Supplemental Database Language PreferencesTransaction Files41: Inventory ManagementBusiness Data
20920F00091T2341Supplemental Database Data TypesTransaction Files41: Inventory ManagementBusiness Data
21920F00092T3305Supplemental DataTransaction Files41: Inventory ManagementBusiness Data
22920F00093FM122Flash MessagesExtra Features Files17: Customer Service ManagementBusiness Data
23920F00094T1101CTI PropertiesExtra Features Files09: General AccountingBusiness Data
24920F00095A173Business Object ReservationExtra Features Files42: Sales Management
25920F00096M0371Default Media Object Category by TableExtra Features Files42: Sales ManagementBusiness Data
26920F00098ED91Enable Distributed Next NumnerFiles90CA: CRM FoundationBusiness Data
27920F0010CC655Company ConstantsConstants Files09: General AccountingBusiness Data
28920F00101CC82Company by Country - 00Files00: Foundation Environment
29920F0010TCC121Company Constants Tag TableFiles09: General Accounting
30920F0010ZSZ841Company Constants Z FileConstants Files09: General AccountingBusiness Data
31920F0011IC241Batch Control RecordsExtra Features Files09: General AccountingBusiness Data
32920F0011WIC51F0011W - WF - Batch To DetailFiles09: General Accounting
33920F0012KG202Automatic Accounting Instructions MasterConstants Files09: General AccountingBusiness Data
34920F0012DLJ81AAI Alternate Description MasterExtra Features Files09: General AccountingBusiness Data
35920F0013CV101Currency CodesExtra Features Files09: General AccountingBusiness Data
36920F0014PN161Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
37920F00141L353Advanced Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
38920F00142L4231Due Date RulesConstants Files03B: Enhanced Accounts ReceivableBusiness Data
39920F00143L561Due Date Rules Day RangeConstants Files03B: Enhanced Accounts ReceivableBusiness Data
40920F00144L663Installment Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
41920F00147L8161Multitiered Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
42920F0018TD686TaxesExtra Features Files09: General AccountingBusiness Data
43920F00189TG202WF - Tax ReconciliationRegular Work Files09: General AccountingBusiness Data
44920F0018RED272Tax Reconciliation RepositoryFiles09: General Accounting
45920F0019CG61Generic Message/Rate TypesExtra Features Files48: Work Order ProcessingBusiness Data
46920F00191CE61Generic Message/RatesExtra Features Files48: Work Order ProcessingBusiness Data
47920F00192CF51General Message DetailExtra Features Files48: Work Order ProcessingBusiness Data
48920F0022VA111Tax RulesConstants Files04: Accounts PayableBusiness Data
49920F0024UG22Batch Approval / Post Security FileExtra Features Files09: General AccountingBusiness Data
50920F0025LH282Ledger Type Master FileConstants Files09: General AccountingBusiness Data
51920F0026CL181Job Cost ConstantsConstants Files51: Job CostingBusiness Data
52920F0028TE101Sales Tax Work File by Taxing AuthorityRegular Work Files09: General AccountingBusiness Data
53920F0029TF141Sales Tax Work File by Taxing Authority and DocumentRegular Work Files09: General AccountingBusiness Data
54920F0030AY346Bank Transit MasterMaster Files04: Accounts PayableBusiness Data
55920F0030TAZ91Bank Account X12 InformationSecondary Master Files04: Accounts PayableBusiness Data
56920F0031AV71Bank Transit Master Tag TableFiles00: Foundation Environment
57920F0039GN282Generated Documents DefinitionExtra Features Files42: Sales ManagementBusiness Data
58920F0039MGH121Generated Document Media Object HistoryHistory Files42: Sales ManagementBusiness Data
59920F0040Z1ZB122Error Message Log TableBatch Input Files42B: Sales Order EntryBusiness Data
60920F0041Z1ZF114Transaction Control FileBatch Input Files42B: Sales Order EntryBusiness Data
61920F004201PT723Prepayment Transaction TableTransaction Files42: Sales ManagementBusiness Data
62920F00421RS153Column RelationshipsFiles09: General AccountingBusiness Data
63920F00422RB155Data RelationshipsFiles09: General AccountingBusiness Data
64920F00422AVR104Value Relationships - Work TableFiles09: General Accounting
65920F00424AC91Relationship ColumnsFiles09: General AccountingBusiness Data
66920F0045ER212Services Error RecoveryFiles34A: Advanced Planning & Scheduling
67920F0046PL102Processing LogTransaction Files09: General AccountingBusiness Data
68920F0047DE152Data Export ControlTransaction Files09: General AccountingBusiness Data
69920F0048CM135Code Mappings MasterTransaction Files00: Foundation EnvironmentBusiness Data
70920F0049CA152Business Function Call Abstraction RegisterFiles34A: Advanced Planning & Scheduling
71920F0050MA124Organization Structure Master FileExtra Features Files09: General AccountingBusiness Data
72920F00690M191Cost Center Types of DataExtra Features Files41: Inventory ManagementBusiness Data
73920F00692M281Cost Center Supplemental Data CodesExtra Features Files41: Inventory ManagementBusiness Data
74920F00693M361Cost Center Supplemental Data TextExtra Features Files41: Inventory ManagementBusiness Data
75920F0070CK121Country Constants Master FileConstants Files09: General AccountingBusiness Data
76920F007021WTB171Transactions to Batch Headers Work TableFiles00: Foundation Environment
77920F007032WOB71Batches Out Of Balance Work TableFiles09: General Accounting
78920F0075CC115Credit Card InformationFiles09E: Expense ReimbursmentBusiness Data
79920F0080S251Supplemental Data Type Security FileExtra Features Files41: Inventory ManagementBusiness Data
80920F0085YN31Audit Record Y/N File - EuroConstants Files09: General AccountingBusiness Data
81920F0087EU72Conversion Constants File for EuroExtra Features Files09: General AccountingBusiness Data
82920F0095IT51Integration TimestampFiles00: Foundation Environment
83920F00UI391GW161Generated Document Work TableWork Files42: Sales ManagementBusiness Data
84920F00UI392GW151Text Substitution Work TableWork Files42: Sales ManagementBusiness Data
85920F00UI393GW131Bookmark Work TableWork Files42: Sales ManagementBusiness Data
86920F01RS01WTH61PCFGTV Header Public DataWork FilesH95: Object and Environment Tech
87920F01RS11WTD491PCFGTV Detail Public DataWork FilesH95: Object and Environment Tech
88920F01RS12WTR41PCFGTV Role Public DataFilesH95: Object and Environment Tech
89920F01RS13WTA141PCFGTV By Role Public DataFilesH95: Object and Environment Tech
90920F03B470PG72Pay When Paid Group HeaderExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
91920F0401Z1VO951Supplier Master - Batch UploadBatch Input Files01: Address BookBusiness Data
92920F0901WOWO21Account Master Search Word OccurrenceExtra Features Files09: General AccountingBusiness Data
93920F0901WSWS43Account - Word SearchExtra Features Files09: General AccountingBusiness Data
94920F0902GB569Account BalancesBalance Files09: General AccountingBusiness Data
95920F0911GL14124Account LedgerTransaction Files09: General AccountingBusiness Data
96920F09190C9104Inter/Intra Company Account RelationshipsFiles11: Multi CurrencyBusiness Data
97920F097001WCB71Companies Out of Balance Work TableFiles09: General Accounting
98920F15019NL291Billing Frequency MasterMaster Files15: Real Estate ManagementBusiness Data
99920F17001CS611Service/Warranty Constants Table - F17001Constants Files17C: Call ManagementBusiness Data
100920F4008TA352Tax AreasExtra Features Files04: Accounts PayableBusiness Data
101920F40081EU272Alternate Tax Rate/Area DefinitionFiles00: Foundation Environment
102920F40082AC82Alternate Tax Area by Country - 00Files00: Foundation Environment
103920F4096FA211Sales Flex AccountingMaster Files42: Sales ManagementBusiness Data
104920F4303MPM262Log ModelsExtra Features Files43: ProcurementBusiness Data
105920F5192JC111Inquiry ColumnsConstants Files43: ProcurementBusiness Data
106920F5192DJC61Supplier Analysis Alternate Language DescriptionExtra Features Files43: ProcurementBusiness Data
107920F5193JD71Inquiry FormatsConstants Files43: ProcurementBusiness Data
108920F5194JE51Inquiry PathsConstants Files43: ProcurementBusiness Data
109920F5301DI436Change Request Master TableMaster Files53: Change ManagementBusiness Data
110920F744008TA91Tax areas - Tag Table EMEA - Spain / ItalyMaster Files04: Accounts PayableBusiness Data
111920F800010TD172Time DimensionMaster Files00: Foundation EnvironmentBusiness Data
112920F80D306HD141Action DefinitionFiles80D: Plant Manager Dashboard
113920F80D307HD111Metric Action Cross ReferenceFiles80D: Plant Manager Dashboard
114920F80D309MS121Metric Series Cross RefFiles80D: Plant Manager Dashboard
115920F80D310AL131Alert DefinitionFiles80D: Plant Manager Dashboard
116920F80D312AS121Alert SubscriptionFiles80D: Plant Manager Dashboard
117920F80D321MG121UI Metric Group DefinitionFiles80D: Plant Manager Dashboard
118920F80D322MD171UI Metric Group DetailFiles80D: Plant Manager Dashboard
01: Address Book
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
119920F0101AB9515Address Book MasterMaster Files01: Address Book
120920F0101Z2SZ1251Address Book - InteroperabilityBatch Input Files01: Address BookBusiness Data
121920F01090A1161Supplemental Database - CoreExtra Features Files01: Address BookBusiness Data
122920F01092A2104Supplemental Database - CodeExtra Features Files01: Address BookBusiness Data
123920F01093A372Supplemental Database - NarrativeExtra Features Files01: Address BookBusiness Data
124920F0111WW533Address Book - Who's WhoSecondary Master Files01: Address BookBusiness Data
125920F01112CP202Related PersonSecondary Master Files01: Address BookBusiness Data
126920F01112Z1PB331Batch - Related PersonBatch Input Files01: Address BookBusiness Data
127920F0111Z1BW682Batch Who's Who InformationPC Download/Batch Edit Files01: Address BookBusiness Data
128920F01138DS311AB Data Permission List DefinitionsExtra Features Files01: Address Book
129920F0114AT41Address Book Memo/Text InformationSecondary Master Files01: Address BookBusiness Data
130920F0115WP172Address Book - Phone NumbersSecondary Master Files01: Address BookBusiness Data
131920F01151EA182Electronic AddressSecondary Master Files01: Address BookBusiness Data
132920F01151Z1EB311Batch - Electronic AddressBatch Input Files01: Address BookBusiness Data
133920F0115Z1PI291Phones - InteroperabilityFiles01: Address Book
134920F0116AL211Address by DateMaster Files01: Address BookBusiness Data
135920F01161WL221Alternate AddressSecondary Master Files01: Address BookBusiness Data
136920F01161DWDW221Customer Alternate Address ExportFiles01: Address Book
137920F01161Z1LB351Batch - Alternative AddressBatch Input Files01: Address BookBusiness Data
138920F0117A8133Postal CodesMaster Files01: Address BookBusiness Data
139920F0118A7132Postal Code AddressFiles01: Address BookBusiness Data
140920F011901CS172Contacts Subscriptions TableFiles01: Address Book
141920F01301AM593Activity MasterFiles01: Address Book
142920F01301DAD608Activity DetailFiles01: Address Book
143920F01301WAW501Mobile Client Deleted ActivitiesFiles01: Address Book
144920F01302AD41Activity -- Deleted IDs for SyncFiles01: Address Book
145920F01311CC312Centralized Calendar MasterFiles01: Address Book
146920F01315CC133Calendar AssociationsFiles01: Address Book
147920F01321RM151Recurrence MasterFiles01: Address Book
148920F01331RE122Recurrence ExclusionFiles01: Address Book
149920F01401AP131Action PlanFiles01: Address Book
150920F01411AC171Action Plan ActivityFiles01: Address Book
151920F0150MA138Address Organization Structure MasterExtra Features Files01: Address BookBusiness Data
152920F01501PR143Enhanced Parent ChildSecondary Master Files01: Address BookBusiness Data
153920F01505TD104Tier DescriptionsFiles01: Address BookBusiness Data
154920F01815AS42AB Word Search MasterExtra Features Files01: Address BookBusiness Data
155920F01816AO21Address Book Search Word OccurrenceExtra Features Files01: Address BookBusiness Data
156920F0401A6801Supplier MasterMaster Files01: Address BookBusiness Data
02: Electronic Mail
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
157920F0113ZZ251Message Log Ledger FileTransaction Files02: Electronic MailBusiness Data
158920F01132CY61PPAT Message Text FileTransaction Files02: Electronic MailBusiness Data
159920F01134ZW43PPAT Bulletin Board EnlistmentMaster Files02: Electronic MailBusiness Data
160920F0126A#401'Flash' Schedule Master FileMaster Files02: Electronic MailBusiness Data
03: Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
161920F03012AI2107Customer Master by Line of BusinessMaster Files03: Accounts Receivable
162920F03012AA2391Date Effective Category CodesFiles01: Address BookBusiness Data
163920F03012Z1VO2221Customer Master LOB-Batch TableBatch Input Files01: Address BookBusiness Data
164920F0311RP1405Accounts Receivable LedgerTransaction Files03: Accounts ReceivableBusiness Data
165920F0312RU524A/R Batch Cash ApplicationBatch Input Files03: Accounts ReceivableBusiness Data
03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
166920F00171NC41Interoperability-Net Change TableFiles03B: Enhanced Accounts Receivable
167920F007101TA201Text Processor HeaderTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
168920F007111TB142Text Processor Detail TableTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
169920F03012TAT102Customer Master by Line of Business Tag TableConstants Files01: Address Book
170920F03B08RD132Credit/Collection Date PatternConstants Files03B: Enhanced Accounts ReceivableBusiness Data
171920F03B11RP15724Customer LedgerTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
172920F03B112RW675Invoice RevisionsBalance Files03B: Enhanced Accounts ReceivableBusiness Data
173920F03B112PRW671Invoice Revisions Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
174920F03B116RK271Revenue Recognition InvoiceFiles03B: Enhanced Accounts Receivable
175920F03B117RL825Revenue Recognition GL InfoFiles03B: Enhanced Accounts Receivable
176920F03B118RM281Revenue Recognition Invoice AuditFiles03B: Enhanced Accounts Receivable
177920F03B119RN831Revenue Recognition GL Info AuditFiles03B: Enhanced Accounts Receivable
178920F03B11PRP1571Customer Ledger Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
179920F03B11SWCS111Customer Ledger Summary Work TableFiles03B: Enhanced Accounts Receivable
180920F03B11TTK91Customer Ledger Tag TableFiles03B: Enhanced Accounts Receivable
181920F03B11Z1VJ2021Batch InvoicesBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
182920F03B11Z2SY1712F03B11 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
183920F03B13RY9710Receipts HeaderTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
184920F03B13PRY971Receipts Header Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
185920F03B13Z1RU435Electronic Receipts InputBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
186920F03B13Z2SY1102F03B13 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
187920F03B14RZ13517Receipts DetailTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
188920F03B14PRZ1351Receipts Detail Purge FilePurge Files03B: Enhanced Accounts ReceivableBusiness Data
189920F03B14Z2SZ1492F03B14 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
190920F03B15RT562Credit and Cash ManagementRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
191920F03B15TRT342F03B15 Tag TableRegular Work Files03B: Enhanced Accounts Receivable
192920F03B16RV584A/R Statistical HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
193920F03B16SRS472A/R Statistical SummaryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
194920F03B20ZR624A/R Notification HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
195920F03B21ZS632A/R Notification History DetailHistory Files03B: Enhanced Accounts ReceivableBusiness Data
196920F03B22RS331A/R Fee Journal HistoryHistory Files03B: Enhanced Accounts ReceivableBusiness Data
197920F03B23RT241A/R Fee Journal History DetailHistory Files03B: Enhanced Accounts ReceivableBusiness Data
198920F03B25RF122Delinquency PolicyConstants Files03B: Enhanced Accounts ReceivableBusiness Data
199920F03B26RL242A/R Delinquency Policy NotificationConstants Files03B: Enhanced Accounts ReceivableBusiness Data
200920F03B27RM251A/R Delinquency Policy Detail - FeesConstants Files03B: Enhanced Accounts ReceivableBusiness Data
201920F03B28RJ91Letter TextConstants Files03B: Enhanced Accounts ReceivableBusiness Data
202920F03B29IP193Credit InsuranceSecondary Master Files03B: Enhanced Accounts ReceivableBusiness Data
203920F03B30ZI91Activity Type MasterConstants Files03B: Enhanced Accounts ReceivableBusiness Data
204920F03B31ZG155Customer Activity LogTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
205920F03B40RB392A/R Deduction ManagementTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
206920F03B40TRB21A/R Deduction Management TagFiles03B: Enhanced Accounts Receivable
207920F03B41RC232A/R Deduction ActivityTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
208920F03B41Z1SZ312Inteoperability - Deductions ManagementFiles03B: Enhanced Accounts ReceivableBusiness Data
209920F03B42RD141Deductions Activity MasterMaster Files03B: Enhanced Accounts ReceivableBusiness Data
210920F03B424TK121Invoice Trigger HierarchyFiles03B: Enhanced Accounts Receivable
211920F03B425TK81InvoiceTrigger DateFiles03B: Enhanced Accounts Receivable
212920F03B426TK171Invoice Trigger ConfigurationFiles03B: Enhanced Accounts Receivable
213920F03B465RO551A/R Netting WorkfileWork Files03B: Enhanced Accounts ReceivableBusiness Data
214920F03B50RE101Receipt Application Algorithm Execution ListsSecondary Master Files03B: Enhanced Accounts ReceivableBusiness Data
215920F03B571RC351Auto Debit Batch ControlTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
216920F03B575RD1441Auto Debit Invoice Select and BuildTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
217920F03B57OWRE51Auto Debit Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
218920F03B672RD803Draft RemittanceTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
219920F03B67OWRE61Drafts Standard Formatted Tape FileTransaction Files03B: Enhanced Accounts ReceivableBusiness Data
220920F03B920ZC21Credit Reporting Tape - ExperianExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
221920F03B920CZD21Credit Reporting Tape - CreditelExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
222920F03BUI04W3101Work File for Integrity by Offset AccountRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
223920F03BUI05R541Auto Receipts Batch WorkfileRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
224920F09UI011GL521Receipt Prepost Work FileRegular Work Files03B: Enhanced Accounts ReceivableBusiness Data
225920F74W300RU41A/R Fee Journal History Detail Tag FileFiles03B: Enhanced Accounts Receivable
04: Accounts Payable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
226920F0030WAX21Bank Account/Supplier Number WorktableRegular Work Files04: Accounts PayableBusiness Data
227920F0401MA631Multiple Vendor Bank Account StatusSecondary Master Files04: Accounts PayableBusiness Data
228920F0401TVT201Supplier Master - Voucher Match Automation FileExtra Features Files04: Accounts Payable
229920F0401Z1TVT241Supplier Master - Voucher Match Automation Tag FileExtra Features Files04: Accounts Payable
230920F0411RP14715Accounts Payable LedgerTransaction Files04: Accounts PayableBusiness Data
231920F0411ARP1421WF - 'As Of' Accounts Payable LedgerRegular Work Files04: Accounts PayableBusiness Data
232920F0411PRP1471Purge - Accounts Payable LedgerPurge Files04: Accounts PayableBusiness Data
233920F0411SWSS111Supplier Ledger Summary Work TableFiles04: Accounts Payable
234920F0411XCM121CM Voucher Cross ReferenceFiles04: Accounts PayableBusiness Data
235920F0411Z1VL1821Voucher Transactions - Batch UploadBatch Input Files04: Accounts PayableBusiness Data
236920F0411Z1TVT332Voucher Transactions Batch Upload - Voucher Match AutomationExtra Features Files04: Accounts Payable
237920F0411Z3SZ1962F0411 Interoperability TableBatch Input Files04: Accounts PayableBusiness Data
238920F0413RM4411Accounts Payable - Matching DocumentTransaction Files04: Accounts PayableBusiness Data
239920F0413ARM441WF - 'As Of' Accounts Payable Payment RegisterRegular Work Files04: Accounts PayableBusiness Data
240920F0413PRM441Purge - Accounts Payable Matching DocumentsPurge Files04: Accounts PayableBusiness Data
241920F0413Z1SY652F0413 Interoperability TableBatch Input Files04: Accounts PayableBusiness Data
242920F0414RN538Accounts Payable Matching Document DetailTransaction Files04: Accounts PayableBusiness Data
243920F0414ARN542WF - 'As Of' Accounts Payable Payment DetailRegular Work Files04: Accounts PayableBusiness Data
244920F0414PRN531Purge - Accounts Payable Matching Document DetailPurge Files04: Accounts PayableBusiness Data
245920F0414Z1SZ732F0414 Interoperability TableWork Files04: Accounts PayableBusiness Data
246920F0415KJ141A/P Payments - Check SequencingExtra Features Files04: Accounts PayableBusiness Data
247920F0417KB151A/P Payments - Default Print and UpdateExtra Features Files04: Accounts PayableBusiness Data
248920F0417MKB31Multiple Vendor Bank Account TypesSecondary Master Files04: Accounts PayableBusiness Data
249920F04257W2KE41Payments Window WorktableWork Files04: Accounts PayableBusiness Data
250920F0450PC182Payee ControlHistory Files04: Accounts PayableBusiness Data
251920F04514G12811099 Merged Worktables (F045141:F045143)Regular Work Files04: Accounts PayableBusiness Data
252920F045141G12811099 G/L WorktableRegular Work Files04: Accounts PayableBusiness Data
253920F045143G12811099 A/P WorktableRegular Work Files04: Accounts PayableBusiness Data
254920F045145G21211099 Securities Identification FileFiles04: Accounts Payable
255920F04514WFKR181K Record WorkfileFiles04: Accounts Payable
256920F04515OWG1211099 Electronic MediaWork Files04: Accounts PayableBusiness Data
257920F0457KM261A/P Payment TapeMaster Files04: Accounts PayableBusiness Data
258920F04571KH391A/P Payment Processing - HeaderWork Files04: Accounts PayableBusiness Data
259920F04572KK614A/P Payment Processing - SummaryWork Files04: Accounts PayableBusiness Data
260920F04572OWKN41A/P Payment TapeWork Files04: Accounts PayableBusiness Data
261920F04573KI543A/P Payment Processing - DetailWork Files04: Accounts PayableBusiness Data
262920F04614CT152T5018 Tax FileFiles04: Accounts Payable
263920F046141CU132T5018 Tax WorkfileFiles04: Accounts Payable
264920F046UI01CV65T5018 Tax WorkfileFiles04: Accounts Payable
265920F0474N1QB102A/P Enterprise Info. - Sweden BGI/BGUSecondary Master Files04: Accounts PayableBusiness Data
266920F0474N2QD221A/P Enterprise Info. - Norway DNBSecondary Master Files04: Accounts PayableBusiness Data
267920F0474N3QC132Supplier Inf. Foreigen Payments SwedenSecondary Master Files04: Accounts PayableBusiness Data
268920F0490GC21A/P 'As Of' Date WorktableWork Files04: Accounts PayableBusiness Data
269920F04UI004RP71Integrity Report WorktableWork Files04: Accounts PayableBusiness Data
270920F04UI006G1651099 Worktable User IndexWork Files04: Accounts PayableBusiness Data
271920F09UI005GL571Tax Offsets User IndexWork Files04: Accounts PayableBusiness Data
272920F09UI006TD681Tax (F0018) ReplicaWork Files04: Accounts PayableBusiness Data
273920F7404S1SW31Swiss SOG Payment Format Order NumberHistory Files04: Accounts PayableBusiness Data
05: Time Accounting and HRM Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
274920F05005GF211Generic UBE FileFiles05: Time Accounting and HRM Base
275920F050116WEM272Employee Master Integrations Work FileFiles05: Time Accounting and HRM Base
276920F050611UR112URL DefinitionsFiles05: Time Accounting and HRM Base
277920F050612UR93Media Object URL IntersectionFiles05: Time Accounting and HRM Base
278920F05100CM112Resource CompetencyMaster Files05: Time Accounting and HRM BaseBusiness Data
279920F05100Z1CU282Resource Competencies Unedited Transactions FileFiles05: Time Accounting and HRM Base
280920F05101CY142Course MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
281920F05102SM226Goal MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
282920F05103AM91Scale MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
283920F05104CM111Competency MasterMaster Files05: Time Accounting and HRM BaseBusiness Data
284920F05105GS153Goal SuggestionsFiles05: Time Accounting and HRM BaseBusiness Data
285920F05106CU91Competency Update EventsFiles05: Time Accounting and HRM BaseBusiness Data
286920F05107CU91Competency Update Approval RoutingFiles05: Time Accounting and HRM BaseBusiness Data
287920F05107ACU101Competency Update Approval Routing Tag FileFiles05: Time Accounting and HRM Base
288920F05108UT151Unconfirmed Training AdditionalFiles08: Human Resources
289920F05111CT183Training/DevelopmentTransaction Files05: Time Accounting and HRM BaseBusiness Data
290920F05112ST131Skills/ResourcesTransaction Files05: Time Accounting and HRM BaseBusiness Data
291920F051124Y491Director Text Setup FileFiles05T: Time EntryBusiness Data
292920F05113AT131AccomplishmentsTransaction Files05: Time Accounting and HRM BaseBusiness Data
293920F05114CT191CertificationsTransaction Files05: Time Accounting and HRM BaseBusiness Data
294920F05115ET143EducationTransaction Files05: Time Accounting and HRM BaseBusiness Data
295920F05116LT111LanguagesTransaction Files05: Time Accounting and HRM BaseBusiness Data
296920F05117GL112Goal Action PlanTransaction Files05: Time Accounting and HRM BaseBusiness Data
297920F051171GL205Goal ActionsFiles05: Time Accounting and HRM BaseBusiness Data
298920F05118AC91Aggregate CompetenciesTransaction Files05: Time Accounting and HRM BaseBusiness Data
299920F05119CL91Competency LevelsTransaction Files05: Time Accounting and HRM BaseBusiness Data
300920F05120MM151Competency HistoryHistory Files05: Time Accounting and HRM BaseBusiness Data
301920F05121CR92Competency/CourseTransaction Files05: Time Accounting and HRM BaseBusiness Data
302920F05122AP102Action PlanSecondary Master Files05: Time Accounting and HRM BaseBusiness Data
303920F051400SF91Searchable Competency FieldsFiles05: Time Accounting and HRM Base
304920F051402SC81Search ConstantsFiles05: Time Accounting and HRM Base
305920F051413SI71Competency Search ImportanceFiles05: Time Accounting and HRM Base
306920F051421WI82Word IndexFiles05: Time Accounting and HRM Base
307920F051422CW91Competency WordsFiles05: Time Accounting and HRM Base
308920F051423LW101Level WordsFiles05: Time Accounting and HRM Base
309920F051424CD101Competency Detail UDC WordsFiles05: Time Accounting and HRM Base
310920F051425CD101Competency Detail WordsFiles05: Time Accounting and HRM Base
311920F051427IW61Ignore WordsFiles05: Time Accounting and HRM Base
312920F051428RW71Related WordsFiles05: Time Accounting and HRM Base
313920F051429AC91AcronymFiles05: Time Accounting and HRM Base
314920F05152WFWF81Results Work FileFiles05: Time Accounting and HRM Base
315920F05153WFWF91Results Work File Competency DetailFiles05: Time Accounting and HRM Base
316920F05154WFWF101Results Work File Competency Words DetailFiles05: Time Accounting and HRM Base
317920F05400PF274Self-Service Process Flow SettingsFiles05: Time Accounting and HRM Base
318920F054101EH511Employee Personal Profile Information History TableFiles05: Time Accounting and HRM Base
319920F054101WEP525Employee Personal Profile Information Work TableFiles05: Time Accounting and HRM Base
320920F054111CH251Employee Emergency Contact History TableFiles05: Time Accounting and HRM Base
321920F054111WEC264Employee Emergency Contact Work TableFiles05: Time Accounting and HRM Base
322920F05420WA152Workflow Approval TableFiles05: Time Accounting and HRM Base
323920F05430UT121ESS User Defined TextFiles05: Time Accounting and HRM Base
324920F06005JE301Batch Processing ParametersWork Files07: PayrollBusiness Data
325920F0605J@271D/B/A Period Control FileBalance Files05: Time Accounting and HRM BaseBusiness Data
326920F0607JI261Wage Attachment Ledger FileTransaction Files05: Time Accounting and HRM BaseBusiness Data
327920F0609Y$419Deduction/Benefit/Accrual Ledger FileTransaction Files05: Time Accounting and HRM BaseBusiness Data
328920F06106YM1058Employee Pay InstructionsSecondary Master Files05: Time Accounting and HRM BaseBusiness Data
329920F06107J$491Employee Wage Attachment RulesSecondary Master Files05: Time Accounting and HRM BaseBusiness Data
330920F061071J$231Employee Wage Attachment Fee FileSecondary Master Files07: PayrollBusiness Data
331920F06145YH543Calendar Month DBA Summary History FileHistory Files07: PayrollBusiness Data
332920F06149Y7141Fiscal and Anniversary Rollover Work FileBalance Files05: Time Accounting and HRM BaseBusiness Data
333920F0618YT14927Employee Transaction HistoryHistory Files05: Time Accounting and HRM BaseBusiness Data
334920F0619Y$339Benefit/Accrual Detail FileHistory Files05: Time Accounting and HRM BaseBusiness Data
335920F0625JB195Change Code History FileHistory Files05: Time Accounting and HRM BaseBusiness Data
336920F06251JB104Step Progression Rate History FileTransaction Files07: PayrollBusiness Data
337920F0626JG244Wage Attachment Control FileTransaction Files05: Time Accounting and HRM BaseBusiness Data
338920F0627JH1001Workers Compensation Summary HistoryHistory Files05: Time Accounting and HRM BaseBusiness Data
339920F069016YP213Payroll Tax Area ProfileConstants Files07: PayrollBusiness Data
340920F069016TYP91Payroll Tax Area Profile - Tag FileConstants Files07: Payroll
341920F069027Y2101Table Code Unit-of-Measure WindowConstants Files05: Time Accounting and HRM BaseBusiness Data
342920F069036YX72Payroll Transaction Cross ReferenceConstants Files05: Time Accounting and HRM BaseBusiness Data
343920F069086YI104Payroll Corporate Tax IdentificationConstants Files05: Time Accounting and HRM BaseBusiness Data
344920F069106Y1534Union Benefits MasterConstants Files05: Time Accounting and HRM BaseBusiness Data
345920F069116YC13510Payroll Transaction ConstantsConstants Files07: PayrollBusiness Data
346920F069116TYC471Payroll Transaction Constants - Tag FileConstants Files07: Payroll
347920F069117YB31Tax Authority Tax Exemption FileConstants Files05: Time Accounting and HRM BaseBusiness Data
348920F069126YL403Union Rates FileConstants Files05: Time Accounting and HRM BaseBusiness Data
349920F0691261YL251Additional Union RatesFiles05: Time Accounting and HRM Base
350920F069130YD161Group LimitsConstants Files07: Payroll
351920F069140YM171Employee DBA Group Limit OverridesFiles07: Payroll
352920F06915JH165Holiday TableConstants Files05: Time Accounting and HRM BaseBusiness Data
353920F069150Y1201DBA Group Plan Group Limit OverridesFiles07: Payroll
354920F069160Y9181Employee DBA Override Instructions Group LimitsFiles07: Payroll
355920F069162JH51Job Type/ Item Cross Reference FileConstants Files05: Time Accounting and HRM BaseBusiness Data
356920F06919YB41Denomination Table FileConstants Files05: Time Accounting and HRM BaseBusiness Data
357920F06920YQ221Savings Bond General ConstantExtra Features Files05: Time Accounting and HRM BaseBusiness Data
358920F069216YB194Workers Compensation Insurance RatesConstants Files05: Time Accounting and HRM BaseBusiness Data
359920F069226YH142Unemployment Insurance RatesConstants Files05: Time Accounting and HRM Base
360920F06923YH362Valid Job Type/ Step ConstantConstants Files05: Time Accounting and HRM BaseBusiness Data
361920F06925YG91Employee/Vendor Cross ReferenceExtra Features Files05: Time Accounting and HRM BaseBusiness Data
362920F06926Y#41Tax Area/ Vendor Cross ReferenceExtra Features Files05: Time Accounting and HRM BaseBusiness Data
363920F06927J531Payee Voucher RulesExtra Features Files07: PayrollBusiness Data
364920F06931J3101Wage Attachment FileConstants Files07: PayrollBusiness Data
365920F069311J361Wage Attachment Additional ExemptionsConstants Files07: PayrollBusiness Data
366920F069312J391Wage Attachment Exemptions FileConstants Files07: PayrollBusiness Data
367920F06933J@202Step Progression ParametersConstants Files07: PayrollBusiness Data
368920F06936JA197Retro Pay Types RateConstants Files07: PayrollBusiness Data
369920F06972YR63Retro Pay Type TableConstants Files07: PayrollBusiness Data
370920F0709Y$5915Deduction/Benefit/Accrual Ledger FileTransaction Files07: PayrollBusiness Data
371920F07300YB112Employee Lockout Code FileRegular Work Files05: Time Accounting and HRM BaseBusiness Data
372920F073111AA82Pay Type to Activity Type AssociationFiles05: Time Accounting and HRM Base
373920F07315GS103Employee Group Schedules DirectorFiles05: Time Accounting and HRM Base
374920F085590DS231Disability and Veteran Status History TableFiles05: Time Accounting and HRM Base
375920F085590WDS181Disability Status Work TableFiles05: Time Accounting and HRM Base
376920F085605WVS201Veteran Status Work TableFiles05: Time Accounting and HRM Base
377920F086011CO161Establishment InformationFiles05: Time Accounting and HRM Base
05A: PeopleSoft HR & PR Foundation
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
378920F05002EV91Pay Type by CategoryFiles05A: PeopleSoft HR & PR FoundationBusiness Data
379920F05003EV581Verification of Employment DataFiles05A: PeopleSoft HR & PR FoundationBusiness Data
380920F05004SC71Common Settings for HR Employee Self Service ProgramsFiles05A: PeopleSoft HR & PR FoundationBusiness Data
381920F05840SR84Employee/Supervisor Relationship LevelTransaction Files05A: PeopleSoft HR & PR FoundationBusiness Data
382920F05842AT133Employee/Supervisor Approval HistoryTransaction Files05A: PeopleSoft HR & PR FoundationBusiness Data
383920F05844AH101Approval Hierarchy TableTransaction Files05A: PeopleSoft HR & PR FoundationBusiness Data
384920F060116YA21114Employee Master InformationMaster Files05A: PeopleSoft HR & PR FoundationBusiness Data
385920F0601161PT2131Point-In-Time Employee MasterHistory Files05A: PeopleSoft HR & PR FoundationBusiness Data
386920F0601162PH71Point-In-Time Employee Master HeaderHistory Files05A: PeopleSoft HR & PR FoundationBusiness Data
387920F060116WYA2291EE Master Request FileSecondary Master Files05A: PeopleSoft HR & PR FoundationBusiness Data
388920F060116ZSZ2082Unedited Quick Hire Transaction FileTransaction Files05A: PeopleSoft HR & PR FoundationBusiness Data
389920F060117YA161Employee Master - International DataMaster Files05A: PeopleSoft HR & PR FoundationBusiness Data
390920F060117AYA71Employee Master - International Data TagFiles05A: PeopleSoft HR & PR Foundation
391920F060119YE605Employee Jobs History FileMaster Files05A: PeopleSoft HR & PR FoundationBusiness Data
392920F060120YA291Employee Master Additional Information FileMaster Files05A: PeopleSoft HR & PR FoundationBusiness Data
393920F06041JK31Specify Future Data FieldsConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
394920F06045BB121Employee Master - Mass ChangesBatch Input Files05A: PeopleSoft HR & PR FoundationBusiness Data
395920F06345JL582Historical Payroll RegisterRegular Work Files05A: PeopleSoft HR & PR FoundationBusiness Data
396920F069056YO201Establishment Constant FileConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
397920F08011JV151Job Evaluation - Compensable Factors TableConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
398920F08040JT311HR History ConstantsConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
399920F08041JU31Select Data Items for History TrackingConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
400920F08042JW123HR HistoryHistory Files05A: PeopleSoft HR & PR FoundationBusiness Data
401920F08043AC111HR Additional ConstantsConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
402920F08046HZ52Turnover Column ConsolidationConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
403920F08094JW41Profile Database, Cross ReferenceExtra Features Files05A: PeopleSoft HR & PR FoundationBusiness Data
404920F08095J9171Payroll Resume/HR ConversionExtra Features Files05A: PeopleSoft HR & PR FoundationBusiness Data
405920F08096H$102HR Generic Table HeadingsConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
406920F08097H#71HR Generic Table RangesConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
407920F08393BN71Pay Type TablesConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
408920F083931BN71DBA Pay Type TablesConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
409920F08396HX81Key Employee HeadingConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
410920F08397HY101Key Employee DetailConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
411920F08591H5102Accrued Benefit FormulasConstants Files05A: PeopleSoft HR & PR FoundationBusiness Data
412920F980014DMD106Mail Merge Runtime Web DataFiles05A: PeopleSoft HR & PR FoundationBusiness Data
05T: Time Entry
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
413920F051123Y31941Self Service Time Entry Layout Setup FileFiles05T: Time EntryBusiness Data
414920F051126Y6102Managers Delegates Setup FileFiles05T: Time EntryBusiness Data
415920F05210AW101Advanced Labor Management TasksFiles05T: Time Entry
416920F05211AO131Advanced Labor Management Workbench OptionsFiles05T: Time Entry
417920F05212AV81Advanced Labor Management Workbench Task VersionsFiles05T: Time Entry
418920F05601CP161Component Pay InstructionsFiles05T: Time Entry
419920F059022PC161Pay Calculation TableFiles05T: Time Entry
420920F059062LD101Labor Distribution PeriodsFiles05T: Time Entry
421920F059063EO111Employee Labor Distribution Period OverridesFiles05T: Time Entry
422920F06022JA251Employee Piecerate FileExtra Features Files05T: Time EntryBusiness Data
423920F06116YT21935Employee Transaction Detail FileTransaction Files05T: Time EntryBusiness Data
424920F06116Z1VL21811Employee Transactions - Batch FileBatch Input Files05T: Time EntryBusiness Data
425920F06116Z2VM2224ESS Timecard HistoryFiles05T: Time Entry
426920F0623JL592Piecework History FileExtra Features Files05T: Time EntryBusiness Data
427920F0624J#171Burden Distribution FileHistory Files05T: Time EntryBusiness Data
428920F06241J#191Burden Distribution FileHistory Files05T: Time EntryBusiness Data
429920F06278YT1578Retro Timecard Detail FileExtra Features Files05T: Time EntryBusiness Data
430920F06290YR231Payroll Accounting Journal Work FileRegular Work Files05T: Time EntryBusiness Data
431920F063951GL683Payroll Journal (Compressed) FileWork Files05T: Time EntryBusiness Data
432920F06904Y#219Automatic Accounting InstructionsConstants Files05T: Time EntryBusiness Data
433920F069136JE291Tip DisbursementExtra Features Files05T: Time EntryBusiness Data
434920F06914JG51Accounting Summarization Rules FileConstants Files05T: Time EntryBusiness Data
435920F069151JG51Holiday CodesConstants Files05T: Time EntryBusiness Data
436920F06916JJ141Piecework Item MasterExtra Features Files05T: Time EntryBusiness Data
437920F069161JE51Item Master Cross Reference FileConstants Files05T: Time EntryBusiness Data
438920F06918JN192PF - Piece Rate FileConstants Files05T: Time EntryBusiness Data
439920F069246Y382Shift Differential TableConstants Files05T: Time EntryBusiness Data
440920F069306Y@81Union Local Cross ReferenceConstants Files05T: Time EntryBusiness Data
441920F06932J471Classification/Pay Cross ReferenceConstants Files05T: Time EntryBusiness Data
05U: E1 HR & PR Foundation US
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
442920F053030EW161IRS Form W-4, Employee's Withholding CertificateFiles05U: E1 HR & PR Foundation USBusiness Data
443920F053031EW102Tables for IRS Form W-4, EE Withhld Allowance - 2007 onFiles05U: E1 HR & PR Foundation USBusiness Data
444920F053032EW131Tables for IRS Form W-4, EE Withhld Allowance - Pre 2007Files05U: E1 HR & PR Foundation US
445920F05850EO251EEO-1 Annual DataHistory Files05U: E1 HR & PR Foundation USBusiness Data
06: Payroll (old) - Obsolete-do not reuse
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
446920F060118YE594Employee JobsMaster Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
447920F060146JI131Employees Pay Rate FileMaster Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
448920F06017YA102Employee Tax Exceptions/OverridesMaster Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
449920F06042JO102Future Data EE Master RevisionsTransaction Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
450920F06146YN6012Employee Transaction History SummaryMaster Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
451920F0618TAYT111Temp table for F0618T for conversionFiles06: Payroll (old) - Obsolete-do not reuse
452920F06210YD813Payroll Cycle ParametersWork Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
453920F069096YK511Payroll General ConstantsMaster Files06: Payroll (old) - Obsolete-do not reuseBusiness Data
454920F0690961YK211Payroll Additional ConstantsFiles06: Payroll (old) - Obsolete-do not reuse
07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
455920F05290JR702WF - Payroll Journal (Detail)Extra Features Files07: PayrollBusiness Data
456920F055011WAD698Auto Deposit Instructions Work FileFiles07: Payroll
457920F06053YW362Interim Check Parameters FileMaster Files07: PayrollBusiness Data
458920F06136YZ7413Tax HistoryHistory Files07: PayrollBusiness Data
459920F06136AYZ681Tax Summary (Additional)Files07: Payroll
460920F06136BYZ741Tax Summary (PA ACT 32)Files07: Payroll
461920F06147YD173Fiscal and Anniversary Year HistoryHistory Files07: PayrollBusiness Data
462920F06148Y@136Tax Area Transaction HistoryHistory Files07: Payroll
463920F06156YU4511Pay Check History SummaryHistory Files07: PayrollBusiness Data
464920F06166YV197Pay Check History Tax LedgerHistory Files07: PayrollBusiness Data
465920F06166AYV271Tax Ledger (Additional)Files07: Payroll
466920F06166BYV311Tax Ledger (PA ACT 32)Files07: Payroll
467920F06209Y@641Execution Control ParametersConstants Files07: PayrollBusiness Data
468920F06270JP831Retro Processing ParameterExtra Features Files07: PayrollBusiness Data
469920F06271JQ41Retro Processing SelectionExtra Features Files07: PayrollBusiness Data
470920F063106Y7292Deduction/Benefit Work FileWork Files07: PayrollBusiness Data
471920F06350IY4532WF - Paycheck (Interims)Regular Work Files07: PayrollBusiness Data
472920F06490JR233Payroll/Accounts Payable Ledger DetailExtra Features Files07: PayrollBusiness Data
473920F06491J6201Payroll/Accounts Payable Ledger DetailExtra Features Files07: PayrollBusiness Data
474920F06492JC102Payroll - Accounts Payable ControlExtra Features Files07: PayrollBusiness Data
475920F065016YG281Automatic Bank Deposit MasterMaster Files07: PayrollBusiness Data
476920F065016TYG241Automatic Bank Deposit Master (Additional)Files07: Payroll
477920F06560Y861Bank Reconciliation - Issue FileBatch Input Files07: PayrollBusiness Data
478920F06561Y961Bank Reconciliation - Paid FileBatch Input Files07: PayrollBusiness Data
479920F06720JE2201W-2/1099 Processing ControlExtra Features Files07: PayrollBusiness Data
480920F068500YZ121941 - Federal Tax HistoryExtra Features Files07: PayrollBusiness Data
481920F06900Y$151Payroll Fiscal PatternsConstants Files07: PayrollBusiness Data
482920F069025TR41Calculation Table RulesFiles07: Payroll
483920F069026Y2233Payroll Generic TablesConstants Files07: PayrollBusiness Data
484920F0690361RO91Employee Rollover Table OverridesFiles07: Payroll
485920F069066JD247Pay Cycle ConstantConstants Files07: PayrollBusiness Data
486920F069076YF72Insured Pay CodeConstants Files07: PayrollBusiness Data
487920F069171YP241Payroll Payment/ Reporting TermsConstants Files07: PayrollBusiness Data
488920F0701730VS92Populate Vertex Filing StatusFiles07: Payroll
489920F0701731YC131Compensation OverridesFiles07: Payroll
490920F0701732AO261Additional Tax OverridesFiles07: Payroll
491920F0701733YC291Additional Calc MethodsFiles07: Payroll
492920F0701734Y3211Prior Head Tax from a Previous EmployerFiles07: Payroll
493920F0701735YC161Pretax Deduction OverridesFiles07: Payroll
494920F0701740YQ162Quantum Control TaxFiles07: Payroll
495920F0701741YD162Canadian DeductionFiles07: Payroll
496920F0705J@163DBA Period Control FileTransaction Files07: PayrollBusiness Data
497920F07100F7172CCQ WORKFILEWork Files07: PayrollBusiness Data
498920F07107JW612Employee Wage Attachment RulesMaster Files07: PayrollBusiness Data
499920F071072JX91Employee Level Multi Child Support OverridesConstants Files07: PayrollBusiness Data
500920F071073J3121Employee Level Multi Wage Attachment RulesFiles07: Payroll
501920F071074WE141Wage Attachment Exemption RulesFiles07: Payroll
502920F071075JW232Wage Attachment Child Support EFT DetailFiles07: Payroll
503920F07149Y8203Accrual Fiscal/Anniversary History Work FileFiles07: PayrollBusiness Data
504920F0716701EA971Employee Assignment T/E Template InformationFiles07: PayrollBusiness Data
505920F0716702EA212Employee Assignment RatesFiles07: PayrollBusiness Data
506920F0716703EA142Employee Assignment Job DescriptionFiles07: PayrollBusiness Data
507920F0716704EA71Employee Assignment Default Pay TypeFiles07: PayrollBusiness Data
508920F0716709EA971Employee Assignment T/E Template Info HistoryFiles07: PayrollBusiness Data
509920F0717JF538ROE Summary HistoryHistory Files07: PayrollBusiness Data
510920F07171JP42ROE Summary History CommentsHistory Files07: PayrollBusiness Data
511920F07172YD51ROE Max/MinConstants Files07: PayrollBusiness Data
512920F07186Y8221Stub Information History TableWork Files07: PayrollBusiness Data
513920F071861Y8201Stub Detail Piece Rate History FileFiles07: PayrollBusiness Data
514920F0719Y$592DBA Transaction Detail HistoryHistory Files07: PayrollBusiness Data
515920F07209Y@411Execution Control ParametersConstants Files07: PayrollBusiness Data
516920F07210YD993Pay Cycle Parameters FileWork Files07: PayrollBusiness Data
517920F07212Y281Paystub Retro Pay State SetupFiles07: Payroll
518920F07235Y672Auto Deposit Bank WorkfileFiles07: PayrollBusiness Data
519920F07236Y6141Auto Deposit Tape File SetupFiles07: PayrollBusiness Data
520920F07236TY6231Auto Deposit Tape File Setup (Additional)Files07: Payroll
521920F0724YS241Burden Distribution FileHistory Files07: PayrollBusiness Data
522920F07241YS242Burden Distribution FileHistory Files07: PayrollBusiness Data
523920F0728YW132Employee Paid Workers Compensation TransactionsFiles07: Payroll
524920F0729Y9932Employee DBA Override InstructionsFiles07: PayrollBusiness Data
525920F07350Y0525Payment FileWork Files07: PayrollBusiness Data
526920F07351Y1272Payment Distribution FileWork Files07: PayrollBusiness Data
527920F07351TY1241Payment Distribution File (Additional)Files07: Payroll
528920F07352Y2221Stub Information FileWork Files07: PayrollBusiness Data
529920F073521Y2201Stub Detail Piece Rate FileFiles07: PayrollBusiness Data
530920F07353Y3323Tax Detail FileWork Files07: PayrollBusiness Data
531920F07354Y4101Report Setup FileConstants Files07: PayrollBusiness Data
532920F07355Y5362Pre-Payroll Error FileWork Files07: PayrollBusiness Data
533920F07390RO141Year-End Rollover WorkfileFiles07: Payroll
534920F073911Y8171Leave Rollover Balance Report Work FileWork Files07: PayrollBusiness Data
535920F07400NH81New Hire Detail File - Common FormatWork Files07S: Payroll SUIBusiness Data
536920F074001NH1151New Hire Reporting Workfile - OneWorld OnlyWork Files07S: Payroll SUIBusiness Data
537920F074001RNH151New Hire Report Setup - OneWorld OnlyConstants Files07S: Payroll SUIBusiness Data
538920F074001WNH151SUI/New Hire Client loader for F074001RInstall Files07S: Payroll SUIBusiness Data
539920F07415NH81New Hire Detail File - IndianaWork Files07: PayrollBusiness Data
540920F07436NH81New Hire Detail File - OhioMaster Files07S: Payroll SUIBusiness Data
541920F07439NH81New Hire Detail File - PennsylvaniaMaster Files07S: Payroll SUIBusiness Data
542920F07440NH81New Hire Detail File - Rhode IslandWork Files07: PayrollBusiness Data
543920F07490JR244Payroll - Accounts Payable Detail (One World)Extra Features Files07: PayrollBusiness Data
544920F07491J6232Payroll - Accounts Payable Summary FileExtra Features Files07: PayrollBusiness Data
545920F07492JC113Payroll - Accounts Payable Control FileExtra Features Files07: PayrollBusiness Data
546920F07500GC91Geocoder Report SetupFiles07: PayrollBusiness Data
547920F075611Y911Bank File of Cleared Checks - Flat File OneWorld OnlyWork Files07: PayrollBusiness Data
548920F07600LC211Leave Administration ControlFiles07: PayrollBusiness Data
549920F07601LS153Leave Type SetupFiles07: PayrollBusiness Data
550920F07602LR151Leave Verification RulesFiles07: Payroll
551920F07603FV281FMLA Leave Substitution RulesFiles07: Payroll
552920F07620LV255Leave TransactionsFiles07: PayrollBusiness Data
553920F07621L1261Employee Medical Leave InformationFiles07: PayrollBusiness Data
554920F07622L2151Employee Leave - Medical OpinionsFiles07: PayrollBusiness Data
555920F07623L3211Employee FMLA Request HeaderFiles07: PayrollBusiness Data
556920F07624L4251Employee Medical Leave Change InformationFiles07: PayrollBusiness Data
557920F07630LM111Leave Messaging and AuditFiles07: Payroll
558920F077011Y$121Tax History Integrity (Temp)Regular Work Files07: PayrollBusiness Data
559920F077011AY$141Tax History Integrity Additional (Temp)Regular Work Files07: PayrollBusiness Data
560920F077011BY3151Tax Integrity (PA Act32)Files07: Payroll
561920F077021Y$151Transaction History Integrity(Temp)Regular Work Files07: PayrollBusiness Data
562920F07727J7283Canadian Pension InformationHistory Files07: PayrollBusiness Data
563920F07800JE92Year-End Employee TableExtra Features Files07Y: US Payroll Year End
564920F07810JE521Year-End Control TableExtra Features Files07Y: US Payroll Year End
565920F07811JE121Negative Amount WorkfileExtra Features Files07Y: US Payroll Year End
566920F07815YF91Special Handling Codes SetupExtra Features Files07Y: US Payroll Year End
567920F07821JG163Company Form Count TableExtra Features Files07Y: US Payroll Year EndBusiness Data
568920F07822JI512Company Federal Control TableExtra Features Files07Y: US Payroll Year End
569920F07823YF142Year-End Report TableExtra Features Files07Y: US Payroll Year End
570920F07824JD253Company State/Local Control TableExtra Features Files07Y: US Payroll Year End
571920F07825JA493Company Special Handling Control TableExtra Features Files07Y: US Payroll Year End
572920F07826JB92Additional ParametersExtra Features Files07Y: US Payroll Year End
573920F07830Y09011Employee Federal Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
574920F078303YF81Arizona SUI magnetic media table (03)Regular Work Files07S: Payroll SUIBusiness Data
575920F078305YW81California SUI Magnetic Media Table (05)Work Files07S: Payroll SUIBusiness Data
576920F078306YF81Colorado SUI magnetic media table (06)Regular Work Files07S: Payroll SUIBusiness Data
577920F07831YB5314Employee State/Local Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
578920F078310YF81Florida SUI magnetic media table (10)Regular Work Files07S: Payroll SUIBusiness Data
579920F078311YF81Georgia SUI magnetic media table (11)Regular Work Files07S: Payroll SUIBusiness Data
580920F078312YF81Hawaii SUI magnetic media table (12)Extra Features Files07S: Payroll SUIBusiness Data
581920F07832YH6611Employee Special Handling Control TableExtra Features Files07Y: US Payroll Year EndBusiness Data
582920F078329YF81Nevada SUI Magnetic Media Table (29)Regular Work Files07S: Payroll SUIBusiness Data
583920F078344YW81Texas SUI Magnetic Media Table(44)Work Files07S: Payroll SUIBusiness Data
584920F078345YF81Utah SUI magnetic media table (45)Regular Work Files07S: Payroll SUIBusiness Data
585920F078348YW81Washington SUI Magnetic Media Table (48)Work Files07S: Payroll SUIBusiness Data
586920F07835JE41W-2 Magnetic Media WorkfileExtra Features Files07Y: US Payroll Year End
587920F07836JE411099 Magnetic Media WorkfileExtra Features Files07Y: US Payroll Year End
588920F07845FZ151Fund MasterFiles07: Payroll
589920F07850FG161Group Fund SetupFiles07: Payroll
590920F078504VA261Vertex Geo Code to ADP CodeFiles07: PayrollBusiness Data
591920F078505YA21ADP PDBA Quarterly Table SetupFiles07: PayrollBusiness Data
592920F078506YJ21ADP Company Code to JDE Company CodeFiles07: PayrollBusiness Data
593920F078507YE211ADP Employee Additional InformationFiles07: PayrollBusiness Data
594920F078510VR1342ADP Quarterly Integrity ReportFiles07: Payroll
595920F07855AF301Employee Fund AllocationFiles07: Payroll
596920F07860ST71Superannuation Date TrackingFiles07: Payroll
597920F078601RF41Table for storing W2 Mag Media InformationExtra Features Files07Y: US Payroll Year End
598920F078602RS51State Mag Media TableExtra Features Files07Y: US Payroll Year End
599920F078603R9411099 Mag MediaTransaction Files07Y: US Payroll Year End
600920F078651RM41W2 EFW2 Electronic Filing BuildExtra Features Files07Y: US Payroll Year End
601920F078652RF41W-2C EFW2C Electronic Filing BuildExtra Features Files07Y: US Payroll Year End
602920F07869RM41W-2 EFW2 Electronic Filing State BuildExtra Features Files07Y: US Payroll Year End
603920F07880YW912SUI Magnetic Media WorkfileWork Files07S: Payroll SUIBusiness Data
604920F07881YF81SUI Magnetic Media Flat File - GenericWork Files07S: Payroll SUIBusiness Data
605920F07885YW283SUI Payments for Quarterly ReportingWork Files07S: Payroll SUI
606920F07900NC201Non Calendar Tax Fiscal Date PatternsConstants Files07: PayrollBusiness Data
607920F07901Y5492Pre-Payroll DBA Calculation Control TableConstants Files07: PayrollBusiness Data
608920F079320WX351Wage Attachment Exemptions by Pay FrequencyFiles07: Payroll
609920F07940YY131Set Vertex Tax TableConstants Files07: PayrollBusiness Data
610920F079420PD221Prevailing Wage DBAsFiles07: Payroll
611920F079425PR241Prevailing Wage DBA RangeFiles07: Payroll
612920F079430PW402Prevailing Wage Transaction DetailFiles07: Payroll
613920F079435PF282Prevailing Wage Fringe DetailFiles07: Payroll
614920F079440PW392Prevailing Wage Transaction HistoryFiles07: Payroll
615920F079445PH272Prevailing Wage Fringe HistoryFiles07: Payroll
616920F07991YX111Deduction, Benefit, Accrual History Conversion DataBatch Input Files07: PayrollBusiness Data
617920F07992YQ111Payroll Tax History Conversion DataBatch Input Files07: PayrollBusiness Data
618920F07UI200TH1016Timecard History Work FileWork Files07: PayrollBusiness Data
619920F186206LG32Leave Group ListFiles07: Payroll
620920F8907422MA181New Hire Detail File - Massachusetts (22)Master Files07S: Payroll SUIBusiness Data
621920F8907427MT561New Hire Detail File - Montana (27)Master Files07S: Payroll SUIBusiness Data
622920F8907428NE181New Hire Detail File - Nebraska(28)Master Files07S: Payroll SUIBusiness Data
623920F8907444TX451New Hire Detail File Transfer - Texas (44)Master Files07S: Payroll SUIBusiness Data
08: Human Resources
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
624920F05401DT101Self-Service Process Flow Director TextFiles08: Human Resources
625920F05402SA91Self-Service Step/ApplicationCross-ReferenceFiles08: Human Resources
626920F05403PR101Self-Service Script Position RulesFiles08: Human Resources
627920F05410ES131Employee E-SignatureFiles08: Human Resources
628920F054115HP151Employee Phone Number History TableFiles08: Human Resources
629920F054115WPN163Employee Phone Number Work TableFiles08: Human Resources
630920F0800601JC115Organizational Business Unit/Job Cross-ReferenceMaster Files08: Human ResourcesBusiness Data
631920F0800602JC181Job Competency MasterMaster Files08: Human ResourcesBusiness Data
632920F0800603JC125Job Group CompetenciesMaster Files08: Human ResourcesBusiness Data
633920F0800604JC125Organizational Business Unit CompetenciesMaster Files08: Human ResourcesBusiness Data
634920F0800605JC135Job Type/Step CompetenciesMaster Files08: Human ResourcesBusiness Data
635920F0800606JC207Competency Options - OverridesMaster Files08: Human ResourcesBusiness Data
636920F0800607JC115Organizational CompetenciesMaster Files08: Human ResourcesBusiness Data
637920F0800608JC91Date Effective Organizational StructureMaster Files08: Human ResourcesBusiness Data
638920F0800609YI394Gap Analysis SnapshotMaster Files08: Human ResourcesBusiness Data
639920F0800610JC156Competencies in Structure and JobMaster Files08: Human ResourcesBusiness Data
640920F0800611JC114Job Competency Default - OverridesMaster Files08: Human ResourcesBusiness Data
641920F0800612JC171User Defined Job Competency Description ReferenceMaster Files08: Human ResourcesBusiness Data
642920F08006WFJC205Job Competency Default Overrides Work FileMaster Files08: Human ResourcesBusiness Data
643920F080436VT722VETS-4212 Employment ReportFiles08: Human Resources
644920F080700XR121Fusion XREF TableFiles08: Human Resources
645920F080701LU191Fusion Lookup MapFiles08: Human Resources
646920F080702EM271Fusion Entity MapFiles08: Human Resources
647920F080703LT111Fusion Lookup TableFiles08: Human Resources
648920F080704FE121Fusion Business Objects Extracted TableFiles08: Human Resources
649920F080705FT101HR2HR Transaction DetailsFiles08: Human Resources
650920F080706FC152Fusion Configuration DetailsFiles08: Human Resources
651920F08090JX311HRM Supplemental Data TypesConstants Files08: Human ResourcesBusiness Data
652920F08092JZ174Human Resources General Description-User Def CodesTransaction Files08: Human ResourcesBusiness Data
653920F08093JY122Human Resources General Description - NarrationTransaction Files08: Human ResourcesBusiness Data
654920F08116AC81ACA Applicable Large EmployerFiles08: Human Resources
655920F081161AD585ACA Employee EligibilityFiles08: Human Resources
656920F0811619AD581ACA Employee Eligibility ArchiveFiles08: Human Resources
657920F081162AP271ACA ParametersFiles08: Human Resources
658920F0811629AP301ACA Parameters HistoryFiles08: Human Resources
659920F081163AS181ACA Home Company SummaryFiles08: Human Resources
660920F0811639AS181ACA Home Company Summary ArchiveFiles08: Human Resources
661920F082002YV181Grade/Step Progression Header FileRegular Work Files08: Human ResourcesBusiness Data
662920F082003YW291Grade/Step Progression Detail FileRegular Work Files08: Human ResourcesBusiness Data
663920F08320CPX111Plan Master Tag FileFiles08: Human Resources
664920F083301BS71Benefit StatementFiles08: Human ResourcesBusiness Data
665920F083302HT71Benefit Statement Heading Codes TypeFiles08: Human ResourcesBusiness Data
666920F083303CR101Benefit Statement Cross Reference DetailFiles08: Human ResourcesBusiness Data
667920F083304AH81Associate Benefit Statement HeadingFiles08: Human ResourcesBusiness Data
668920F083305MM361Mail Merge Header/DetailFiles08: Human ResourcesBusiness Data
669920F08336BE2121Dep/Ben X-Reference Tag TableMaster Files08: Human ResourcesBusiness Data
670920F08338E7161Primary Care Physician TableMaster Files08: Human Resources
671920F08338BPT112Primary Care Physician Tag TableFiles08: Human Resources
672920F08350CBX111Categories by Benefit Group Tag FileFiles08: Human Resources
673920F08391B0281User Program ParametersExtra Features Files08: Human ResourcesBusiness Data
674920F085500AD81Allowed Dependent Relations Per PlanFiles08: Human Resources
675920F085510ER91Benefit Categories by Enrollment EventsFiles08: Human Resources
676920F085515WP111Workflow Process FileFiles08: Human Resources
677920F085520PH291Available Plans and Plan Options by Employee History TableFiles08: Human Resources
678920F085520WAP535Available Plans and Plan Options by Employee Work TableFiles08: Human Resources
679920F085528ES91ESS History Table Cross ReferenceFiles08: Human Resources
680920F085530WCP303Employee Current/Pending Elections Work TableFiles08: Human Resources
681920F085536DH282Dependent/Beneficiary X-Reference History TableFiles08: Human Resources
682920F085536WDB295Dependent/Beneficiary X-Reference Work TableFiles08: Human Resources
683920F085537WXB213Current Dep/Ben X-Reference Work TableFiles08: Human Resources
684920F085540PU141Benefits Enrollment Plan/Option URL AddressFiles08: Human Resources
685920F085550IO142Employee Self-Service Personal Information OptionsFiles08: Human Resources
686920F085560NP31Number of Participants by EmployeeFiles08: Human Resources
687920F08710ES235Employee Setup MasterMaster Files08: Human ResourcesBusiness Data
688920F087101DT42Default Setup TasksMaster Files08: Human ResourcesBusiness Data
689920F087102TL143Setup Task ListMaster Files08: Human ResourcesBusiness Data
690920F087103TD263Setup Task DetailsMaster Files08: Human ResourcesBusiness Data
691920F08711ET174Employee Setup TasksMaster Files08: Human ResourcesBusiness Data
692920F08713PPI81Organization Chart Public Information FlagsFiles08: Human Resources
693920F08720SC134Employee Status ChangeTransaction Files08: Human ResourcesBusiness Data
694920F08721SD101Employee Status Change DetailsTransaction Files08: Human ResourcesBusiness Data
695920F08730SS91Employee Status Change SetupTransaction Files08: Human ResourcesBusiness Data
696920F08731SL81Employee Status Change Setup DetailTransaction Files08: Human ResourcesBusiness Data
697920F08740MR143Manager's Self Service ReportsTransaction Files08: Human ResourcesBusiness Data
698920F08750MD111Managers DelegatesTransaction Files08: Human ResourcesBusiness Data
699920F08771XG131CBPA System Company ConstantsMaster Files08: Human ResourcesBusiness Data
700920F087711XJ494CBPA Appraisal HeaderFiles08: Human ResourcesBusiness Data
701920F087711AXJ114CBPA Appraisal Header Tag TableFiles08: Human ResourcesBusiness Data
702920F087711BXK151Performance Appraisal Header Template KeysFiles08: Human ResourcesBusiness Data
703920F087715XM183CBPA Diary TableFiles08: Human ResourcesBusiness Data
704920F08771AXG71CBPA System Company Constants Tag TableMaster Files08: Human ResourcesBusiness Data
705920F08772XH131CBPA System Business Unit OverridesFiles08: Human ResourcesBusiness Data
706920F087721XP121CBPA Appraisal Creation Work FileFiles08: Human ResourcesBusiness Data
707920F08772AXH71CBPA System Business Unit Overrides Tag TableFiles08: Human ResourcesBusiness Data
708920F08773XL151CBPA System Appraisal Type OverridesFiles08: Human ResourcesBusiness Data
709920F08773AXL91CBPA System Appraisal Type Overrides Tag TableFiles08: Human ResourcesBusiness Data
710920F08776XO112CBPA Appraisal TemplatesFiles08: Human ResourcesBusiness Data
711920F089921DT112Rules DetailFiles08: Human ResourcesBusiness Data
712920F08JDWF1JC191Job Description Changes Integration Work FileFiles08: Human Resources
713920F08JDWF2JH263Job Description History Integration Work FileFiles08: Human Resources
08A: eRecruit
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
714920F08403EI102Extended Applicant InformationFiles08A: eRecruit
08AD: ADP Integration
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
715920F05137AD941ADP Employee Master InformationTransaction Files08AD: ADP IntegrationBusiness Data
716920F051371AD1281ADP Employee DBA InstructionsTransaction Files08AD: ADP IntegrationBusiness Data
717920F051372AD101ADP Employee Job Master InformationTransaction Files08AD: ADP IntegrationBusiness Data
718920F051373AD151ADP Employee Auto Deposit InstructionsTransaction Files08AD: ADP IntegrationBusiness Data
719920F051374AD141ADP Employee Tax Withholding/Override InstructionsTransaction Files08AD: ADP IntegrationBusiness Data
720920F051375AD1332ADP Payroll DBA Transaction ConstantsTransaction Files08AD: ADP IntegrationBusiness Data
721920F05138PC163ADP - Pay Cycle Review ControlFiles08AD: ADP IntegrationBusiness Data
08B: Benefits Administration
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
722920F06024YJ122Beneficiary/Co-owner FileExtra Features Files08B: Benefits AdministrationBusiness Data
723920F08320BA672Benefits Plan MasterMaster Files08B: Benefits AdministrationBusiness Data
724920F083201B131Plan Master TextSecondary Master Files08B: Benefits AdministrationBusiness Data
725920F083202B5192Plan Additional OptionsSecondary Master Files08B: Benefits AdministrationBusiness Data
726920F083202BMD83Plan Additional Option Tag TableFiles08B: Benefits Administration
727920F083203BG121Plan Master RatesMaster Files08B: Benefits AdministrationBusiness Data
728920F08320BPP122Plan/Plan Option Tag TableWork Files08B: Benefits Administration
729920F08320DPD201Plan Master Tag TableFiles08B: Benefits Administration
730920F08320WFBV321Available Plans and Plan Options by Employee Work TableWork Files08B: Benefits AdministrationBusiness Data
731920F08320XPX32Plan Name ConversionFiles08B: Benefits Administration
732920F08321BE31Vesting SchedulesConstants Files08B: Benefits AdministrationBusiness Data
733920F08330BG189Employee EnrollmentTransaction Files08B: Benefits AdministrationBusiness Data
734920F08330BBT141Employee Enrollment Tag FileTransaction Files08B: Benefits AdministrationBusiness Data
735920F08330CPC101Employee Enrollment Tag Table CFiles08B: Benefits Administration
736920F08330WFBR191Employee Current/Pending Elections Work TableWork Files08B: Benefits AdministrationBusiness Data
737920F08336BJ135Dep/Ben to Employee Plan X-ReferenceSecondary Master Files08B: Benefits AdministrationBusiness Data
738920F08336WFBD232Dependent/Beneficiary X-Ref Work TableWork Files08B: Benefits AdministrationBusiness Data
739920F0833WFWF1542Benefit Statement Work fileWork Files08B: Benefits AdministrationBusiness Data
740920F08345B321401(k) Elections SetupExtra Features Files08B: Benefits AdministrationBusiness Data
741920F08346B461401(K) ElectionsExtra Features Files08B: Benefits AdministrationBusiness Data
742920F08350BK53Categories within Benefit GroupsSecondary Master Files08B: Benefits AdministrationBusiness Data
743920F08350BI881Benefit Categories by Benefit Group Tag TableSecondary Master Files08B: Benefits AdministrationBusiness Data
744920F08351BU72Plans within Benefit CategoriesSecondary Master Files08B: Benefits AdministrationBusiness Data
745920F08351BPC51Plans within Categories Tag TableSecondary Master Files08B: Benefits AdministrationBusiness Data
746920F08370B7203Reimbursement Spending Acct - Balance FileBalance Files08B: Benefits AdministrationBusiness Data
747920F08371B6367Reimbursement Spending Account Claims FileTransaction Files08B: Benefits AdministrationBusiness Data
748920F08372BM182FSA - Pay Instruction FileExtra Features Files08B: Benefits AdministrationBusiness Data
749920F08380WFBE231Batch Enrollment Work FileWork Files08B: Benefits AdministrationBusiness Data
750920F08381WFRC141Recalculate Plan Option CostsWork Files08B: Benefits AdministrationBusiness Data
751920F08390B9161EligibilityConstants Files08B: Benefits AdministrationBusiness Data
752920F08392BF141Batch Enrollment ParametersConstants Files08B: Benefits AdministrationBusiness Data
753920F08395B8141Enrollment Date TermsConstants Files08B: Benefits AdministrationBusiness Data
754920F08500ES121Enrollment Event SetupConstants Files08B: Benefits AdministrationBusiness Data
755920F08501HH292Employee Pension Activity MasterMaster Files08B: Benefits AdministrationBusiness Data
756920F08502HI282Pension Plan Activity BalanceBalance Files08B: Benefits AdministrationBusiness Data
757920F08505BS91Benefit Self Service ConstantFiles08B: Benefits AdministrationBusiness Data
758920F08510BC81Benefit Categories by Enrollment EventsConstants Files08B: Benefits AdministrationBusiness Data
759920F08511HJ81Employee Pension Activity DetailTransaction Files08B: Benefits AdministrationBusiness Data
760920F08515QB71Plan DBA/Enrollment DBA Cross ReferenceSecondary Master Files08B: Benefits AdministrationBusiness Data
761920F085201HK221Pension Plan Calculation RulesConstants Files08B: Benefits AdministrationBusiness Data
762920F085303WW4222IRS W-4 Form Work FileFiles08B: Benefits Administration
763920F085518SO241Benefit Confirmation Statement OptionsFiles08B: Benefits Administration
764920F085573WMM111Entered Benefit Amount/Rate EditsFiles08B: Benefits Administration
765920F085574MI111Maximum Insurance Coverage Increase AmountsFiles08B: Benefits Administration
766920F08593H771Retirement Rule DefinitionConstants Files08B: Benefits AdministrationBusiness Data
767920F08901HU292Participant fileMaster Files08B: Benefits AdministrationBusiness Data
768920F08911HV171Qualifying Event InformationTransaction Files08B: Benefits AdministrationBusiness Data
769920F08912HB81Additional Qualifying EventTransaction Files08B: Benefits AdministrationBusiness Data
08C: PeopleSoft HR Canadian
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
770920F08021YY71Canadian Employment EquityMaster Files08C: PeopleSoft HR CanadianBusiness Data
771920F08022YZ221Canadian Employment Equity WorkfilePC Download/Batch Edit Files08C: PeopleSoft HR CanadianBusiness Data
08H: Health and Safety
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
772920F08601HL486Injury/Illness Case MasterMaster Files08H: Health and Safety
773920F08601BIT71Injury/Illness Case Master Tag TableFiles08H: Health and SafetyBusiness Data
774920F08601CPI181Additional Health and Safety InformationFiles08H: Health and Safety
775920F086400OR71Injury/Illness Establishment Detail InformationFiles08H: Health and SafetyBusiness Data
776920F086401RH141Injury/Illness Report Header InformationFiles08H: Health and SafetyBusiness Data
08LM: HCM Learning Management Integr
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
777920F0805ER81External System RolesFiles08LM: HCM Learning Management Integr
08P: Position Control
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
778920F08001JM7612Job informationMaster Files08P: Position ControlBusiness Data
779920F08005JV71Business Unit/ Job Id. X-RefExtra Features Files08P: Position ControlBusiness Data
780920F08101HP358Position MasterMaster Files08P: Position ControlBusiness Data
781920F081012HC71Position AccountsMaster Files08P: Position ControlBusiness Data
782920F08101PHP351Purge - Position MasterMaster Files08P: Position ControlBusiness Data
783920F08111HQ209Position Budget DetailTransaction Files08P: Position ControlBusiness Data
784920F08111PHQ201Purge - Position Budget DetailTransaction Files08P: Position ControlBusiness Data
08R: Recruitment Management - (Appl. Track. & Req.)
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
785920F06012YD281Personnel ResumeSecondary Master Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
786920F06013YE81Personnel Resume TextSecondary Master Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
787920F06018YF101Date Parameter ExtensionSecondary Master Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
788920F08045HT94Employee Turnover AnalysisHistory Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
789920F08102HN475Requisition InformationMaster Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
790920F08105HM92Requisition ActivityTransaction Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
791920F08401HA432Applicant MasterMaster Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
792920F08401WFXN451Applicant Work FileWork Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
793920F08402HA71Applicant Master - Append TableSecondary Master Files08R: Recruitment Management - (Appl. Track. & Req.)Business Data
08U: PeopleSoft HR US
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
794920F08360HE317Nondiscrimination GroupsSecondary Master Files08U: PeopleSoft HR USBusiness Data
795920F08361NA71Plan Control Group - NDTFiles08U: PeopleSoft HR USBusiness Data
796920F08362NB104NDT - Tests Associated with PlanFiles08U: PeopleSoft HR USBusiness Data
797920F08365HX171NDT - Criteria HeadingConstants Files08U: PeopleSoft HR USBusiness Data
798920F08366HY221NDT - Key Employee DetailConstants Files08U: PeopleSoft HR USBusiness Data
799920F08367HZ31NDT - Company Selection CriteriaConstants Files08U: PeopleSoft HR USBusiness Data
800920F083675PF232NDT - Prior Year Testing Method Selection CriteriaFiles08U: PeopleSoft HR US
801920F08368DB152NDT - Nondiscrimination TotalsConstants Files08U: PeopleSoft HR USBusiness Data
802920F08369NC111Plan Control Group Test HistoryFiles08U: PeopleSoft HR USBusiness Data
803920F08910J1461COBRA Qualified Beneficiary FileMaster Files08U: PeopleSoft HR USBusiness Data
804920F089101J2271COBRA Subsequent Qualified Event Info.Secondary Master Files08U: PeopleSoft HR USBusiness Data
805920F08920JS425COBRA CoverageBalance Files08U: PeopleSoft HR USBusiness Data
806920F08990HW435COBRA General ConstantsConstants Files08U: PeopleSoft HR USBusiness Data
807920F089901CC265COBRA General Constants Additional InformationFiles08U: PeopleSoft HR USBusiness Data
808920F089902J2132COBRA General Constants - COBRA Notices InformationMaster Files08U: PeopleSoft HR US
809920F08991HD335COBRA Qualifying Event ConstantConstants Files08U: PeopleSoft HR USBusiness Data
810920F08992QE133Qualifying Event Rules HeaderFiles08U: PeopleSoft HR USBusiness Data
811920F08994H1192COBRA Payment HistoryFiles08U: PeopleSoft HR USBusiness Data
812920F08995H2142COBRA Notification HistoryFiles08U: PeopleSoft HR USBusiness Data
813920F08996J3151COBRA Notice HistoryHistory Files08U: PeopleSoft HR US
08W: Wage and Salary
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
814920F082001HS2615Pay Grade/Salary Range TableConstants Files08W: Wage and SalaryBusiness Data
815920F08201HR567Salary Review WorkfileMaster Files08W: Wage and SalaryBusiness Data
816920F08290HG91Pay/Salary Formula FileConstants Files08W: Wage and SalaryBusiness Data
817920F08818YM171Increase Type RulesConstants Files08W: Wage and SalaryBusiness Data
818920F08820YT241Increase Guideline Master TableConstants Files08W: Wage and SalaryBusiness Data
819920F08821YD221Increase Guideline Range TableConstants Files08W: Wage and Salary
820920F08830WFYN924Compensation Root Work TableWork Files08W: Wage and SalaryBusiness Data
821920F08831WFYS282Compensation Detail Work TableWork Files08W: Wage and SalaryBusiness Data
822920F08832WFMM101Compensation Model Work TableWork Files08W: Wage and SalaryBusiness Data
09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
823920F0050AMA491Structure Definition FileExtra Features Files09: General AccountingBusiness Data
824920F0901GM8415Account MasterMaster Files09: General AccountingBusiness Data
825920F0901CGM211Account Category CodesFiles09: General Accounting
826920F0901DLK32Account Master - Alternate DescriptionExtra Features Files09: General AccountingBusiness Data
827920F0902BGB822Account Balances - 52 Period AccountingExtra Features Files09: General AccountingBusiness Data
828920F0902PGB561Purge - Account BalancesPurge Files09: General AccountingBusiness Data
829920F0902Z1GB461Account Balances - Batch FileBatch Input Files09: General AccountingBusiness Data
830920F0907GY112Chart of Accounts FormatConstants Files09: General AccountingBusiness Data
831920F0909AC62Chart of Accounts - Reference FileExtra Features Files09: General AccountingBusiness Data
832920F0911PGL1411Purge - Account LedgerPurge Files09: General AccountingBusiness Data
833920F0911RGL896WF - Account Ledger ReconciliationRegular Work Files09: General AccountingBusiness Data
834920F0911R1GL91Account Reconciliations Header - OneWorld ONLYRegular Work Files09: General AccountingBusiness Data
835920F0911SWGS91Account Ledger Summary Work TableFiles09: General Accounting
836920F0911Z1VN1934Journal Entry Transactions - Batch FileBatch Input Files09: General AccountingBusiness Data
837920F0911Z4SZ1681F0911 Interoperability TableBatch Input Files09: General AccountingBusiness Data
838920F0912RJ531Cost Allocations/Flex BudgetingExtra Features Files09: General AccountingBusiness Data
839920F09123VN653Advanced Variable NumeratorFiles09: General Accounting
840920F09123ABO101Advanced Variable Numerator Busines Unit OverrideFiles09: General Accounting
841920F0912ARI623Index Computation Entry FileExtra Features Files09: General AccountingBusiness Data
842920F0912BR#591Variable Allocation FileExtra Features Files09: General AccountingBusiness Data
843920F0916GH191Bank Statement HeaderExtra Features Files09: General AccountingBusiness Data
844920F0917GD555Bank Statement DetailExtra Features Files09: General AccountingBusiness Data
845920F09218LS161Online Consolidations Set-up FileExtra Features Files09: General AccountingBusiness Data
846920F092181LR112Online Consolidation Detail FileExtra Features Files09: General AccountingBusiness Data
847920F09300FR1085OVFS Report TableFiles09: General Accounting
848920F09301FS322Submitted One View Financial Statements TableFiles09: General Accounting
849920F09302OC231OVFS ConstantsFiles09: General Accounting
850920F09305GR81OVFS Row Definition Grouping Elements TableFiles09: General AccountingBusiness Data
851920F09310RS651OVFS Row Definition Setup TableFiles09: General Accounting
852920F09320CS341OVFS Column Definition Setup TableFiles09: General Accounting
853920F09330RT654OVFS Statement Definition Setup TableFiles09: General Accounting
854920F09340VS441OVFS Statement Version Setup TableFiles09: General Accounting
855920F09350WRW293OVFS Row Definition Work TableFiles09: General Accounting
856920F09360WCL144OVFS Column List Work TableFiles09: General Accounting
857920F09370WBW483OVFS Balance Work TableFiles09: General Accounting
858920F09380WCB183OVFS Column Balance Work TableFiles09: General Accounting
859920F09505GN51WF - Bank File of Cleared Checks.Regular Work Files09: General AccountingBusiness Data
860920F095051GN11Bank File OF Cleared Checks - Flat File OneWorldONLYRegular Work Files09: General AccountingBusiness Data
861920F09521FR523Cash Type RulesFiles09: General Accounting
862920F09522FD366Cash Forecast DataFiles09: General Accounting
863920F09523FS166Cash Forecast Reporting StructuresFiles09: General Accounting
864920F09525FB52Cash Forecast Bank AccountsFiles09: General Accounting
865920F09610SG383Electronic Bank Statement Staging HeaderFiles09: General Accounting
866920F09611BG253Electronic Bank Statement Staging DetailFiles09: General Accounting
867920F09616GN264Auto Bank Statement HeaderFiles09: General Accounting
868920F09617GM544Auto Bank Statement DetailFiles09: General Accounting
869920F09621GS111Bank Account Cross ReferenceFiles09: General Accounting
870920F09622TT121Transaction Type Cross ReferenceFiles09: General Accounting
871920F09626GR301Auto Reconciliation Rules SetupFiles09: General Accounting
872920F09627GG91Auto Reconciliation Group SetupFiles09: General Accounting
873920F09628GA131Auto Bank Statement Account SetupFiles09: General Accounting
874920F097021WTA202Account Ledger to Account Master Work TableFiles09: General Accounting
875920F097031WAB311Account Balance to Account Master Work TableFiles09: General Accounting
876920F097041WAB102Accounts to Business Units Work TableFiles09: General Accounting
877920F09706WNB81Batch and Company Within Batch Out of Balance Work TableFiles09: General Accounting
878920F09UI004R#191Variable Numerator Allocations work file"T" Work Files09: General AccountingBusiness Data
879920F09UI007GL191Match Bank Tape to Recon File - ONE WORLD ONLY"T" Work Files09: General AccountingBusiness Data
880920F09UI008GM111Global Business Unit Change"T" Work Files09: General AccountingBusiness Data
881920F09UI009GB691Trial Balance Generic Work File - OneWorld ONLY"T" Work Files09: General AccountingBusiness Data
882920F09UI010WF124WorkFile for R097011"T" Work Files09: General AccountingBusiness Data
883920F09UI013GL51Company by Batch Out of Balance"T" Work Files09: General AccountingBusiness Data
884920F09UI014GB112Annual Close Work TableWork Files09: General AccountingBusiness Data
885920F09UI015GL1042Indexed Computations Multi-Tiered EntriesWork Files09: General AccountingBusiness Data
886920F09UI016GW212Account Balance Compare ExceptionsWork Files09: General Accounting
887920F09UI017FW441Cash Forecast DetailFiles09: General Accounting
888920F09UI123VW321Advanced Variable Numerator WorktableFiles09: General Accounting
889920F09UI124PG91Advanced Variable Numerator Pool Grouping WorktableFiles09: General Accounting
890920F09UI618NB445Auto Bank Statement Process Work TableFiles09: General Accounting
891920F11151CE165Currency Cross Rates Calculation MasterExtra Features Files09: General AccountingBusiness Data
892920F48S80SD123Segment DefinitionFiles09: General Accounting
893920F48S81CM111Burden Computation MethodFiles09: General Accounting
894920F48S82BR193Burden Base RulesFiles09: General Accounting
895920F48S83PD132Pool DefinitionFiles09: General Accounting
896920F48S84PG113Pool Grouping CodesFiles09: General Accounting
897920F48S85RT132Burden RatesFiles09: General Accounting
898920F52G02BS513Burdening Summarized LedgerFiles09: General Accounting
899920F52G11BD555Burdening Detail LedgerFiles09: General Accounting
900920F52G11WFBW541Temporary Burdened Detail Ledger WorkfileWork Files09: General Accounting
901920F52G31WFRB161Reburdening Transactions WorkfileFiles09: General Accounting
902920F52G32WPG41Pool Grouping Selection WorkfileWork Files09: General Accounting
903920F52G60BW375Burden Rate Calculations WorkfileFiles09: General Accounting
904920F70UI001WA302Work File for G/L by Cat. Code LocalizationWork Files09: General AccountingBusiness Data
905920F740911WA282Work File for G/L Report by Category Code LocalizationWork Files09: General AccountingBusiness Data
09E: Expense Reimbursment
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
906920F09E105TM111Tax MappingExtra Features Files09E: Expense ReimbursmentBusiness Data
907920F09E108PR271Policy Edit RulesExtra Features Files09E: Expense ReimbursmentBusiness Data
908920F09E109PC122Expense Category SetupExtra Features Files09E: Expense ReimbursmentBusiness Data
909920F09E110AS121Audit Selection RulesExtra Features Files09E: Expense Reimbursment
910920F09E114ER101Exchange Rate IdentifiersExtra Features Files09E: Expense Reimbursment
911920F09E118PM101Expense Category / Report Type to Pay Type MappingExtra Features Files09E: Expense Reimbursment
912920F09E119EX171Expense Reimbursement Routing RulesConstants Files09E: Expense Reimbursment
913920F09E120EX132Expense Report Routing History LogHistory Files09E: Expense Reimbursment
914920F09E150CI957Credit Card Transaction Interface TableFiles09E: Expense Reimbursment
915920F20103EP231Employee Profile DefinitionMaster Files09E: Expense ReimbursmentBusiness Data
916920F20104GP171Expense Report Group ProfilesMaster Files09E: Expense ReimbursmentBusiness Data
917920F20106EM61Account Mapping DefinitionExtra Features Files09E: Expense Reimbursment
918920F20107BP62Business Purpose HistoryExtra Features Files09E: Expense Reimbursment
919920F20111EH423Expense Report HeaderTransaction Files09E: Expense Reimbursment
920920F20112ED866Expense Report DetailTransaction Files09E: Expense Reimbursment
10: Financial Reporting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
921920F0050BMA491Business Unit Structure Build FileExtra Features Files10: Financial ReportingBusiness Data
922920F10005GO101User Defined Code Control FileExtra Features Files10: Financial ReportingBusiness Data
923920F1001GP385Multi-Site Consolidation Transfer File HeaderHistory Files10: Financial ReportingBusiness Data
924920F1001Z1IA511Unedited MSC Interoperability Header TableExtra Features Files10: Financial ReportingBusiness Data
925920F1002GQ455Multi-Site Consolidation Transfer FileBalance Files10: Financial ReportingBusiness Data
926920F1002Z1SZ571Unedited MSC Interoperability TableBatch Input Files10: Financial ReportingBusiness Data
927920F1003GR583Multi-Site Consolidation Transfer File - Category CodesExtra Features Files10: Financial ReportingBusiness Data
928920F100901FR322Level of DetailExtra Features Files10: Financial ReportingBusiness Data
929920F1017CS142Consolidation SpecificationsExtra Features Files10: Financial ReportingBusiness Data
930920F10430CF383Multi-Site Consolidation - Account StructureExtra Features Files10: Financial ReportingBusiness Data
931920F10430ACG271Account Structure DefinitionExtra Features Files10: Financial ReportingBusiness Data
932920F10470CS232Consolidation Specifications (OW)Extra Features Files10: Financial ReportingBusiness Data
933920F10471ER261Elimination Rules (OW)Extra Features Files10: Financial ReportingBusiness Data
934920F10520CF142Statement of Cash Flow RulesFiles10: Financial Reporting
935920F10909G191Object/Subsidiary Control TableExtra Features Files10: Financial ReportingBusiness Data
936920F10UI001CF416Account Structure Build WorkfileWork Files10: Financial ReportingBusiness Data
937920F10UI002BU582Dynamically Created Business UnitsWork Files10: Financial ReportingBusiness Data
938920F10UI003AC332Dynamically Created AccountsWork Files10: Financial ReportingBusiness Data
939920F10UI005SR311Organization Structure Report Work TableWork Files10: Financial ReportingBusiness Data
940920F10UI006GE364MSC - F1002 Elimination Work FileWork Files10: Financial ReportingBusiness Data
941920F10UI007MC62Business Unit Structure Search Form Work TableWork Files10: Financial ReportingBusiness Data
942920F10UI520CW91Cash Flow Statement WorktableFiles10: Financial Reporting
11: Multi Currency
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
943920F0015CX164Currency Exchange RatesExtra Features Files11: Multi CurrencyBusiness Data
944920F0015Z1ZE381External Currency Exchange RatesFiles11: Multi CurrencyBusiness Data
945920F1113C162Currency Restatement Rates FileExtra Features Files11: Multi CurrencyBusiness Data
946920F1114C2361Company Conversions Parameter FileExtra Features Files11: Multi CurrencyBusiness Data
947920F11UI001LC31Load Domestic Currency Codes - A/R Work FileWork Files11: Multi CurrencyBusiness Data
11C: Cash Basis
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
948920F11CUI01CB31A/R Cash Basis Work FileFiles11C: Cash Basis
949920F11CUI02CB31A/P Cash Basis Work FileFiles11C: Cash Basis
12: Fixed Assets
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
950920F1200LN21Fixed Asset ConstantsConstants Files12: Fixed AssetsBusiness Data
951920F12002FD251Default Accounting ConstantsConstants Files12: Fixed AssetsBusiness Data
952920F12003FF221Default Depreciation ConstantsConstants Files12: Fixed AssetsBusiness Data
953920F1201FA10613Asset Master FileMaster Files12: Fixed AssetsBusiness Data
954920F1201DLJ62Asset Master - Alternate DescriptionMaster Files12: Fixed AssetsBusiness Data
955920F1201PFA1061Asset Master Purge TableMaster Files12: Fixed AssetsBusiness Data
956920F1201Z1FA1261Unedited Asset Master TransactionsTransaction Files12: Fixed AssetsBusiness Data
957920F1202FL528Asset Account Balances FileBalance Files12: Fixed AssetsBusiness Data
958920F1202PFL521Asset Account Balances Purge TableBalance Files12: Fixed AssetsBusiness Data
959920F1204FM338Location Tracking TableHistory Files13: Plant/Equipment ManagementBusiness Data
960920F1204PFM331Location Tracking Purge TableHistory Files13: Plant/Equipment ManagementBusiness Data
961920F1205FT281Equipment MessagesHistory Files13: Plant/Equipment ManagementBusiness Data
962920F1205PFT281Equipment Messages Purge TableHistory Files13: Plant/Equipment ManagementBusiness Data
963920F1208FP151Units of Production Schedule Master FileExtra Features Files12: Fixed AssetsBusiness Data
964920F12090F2101Asset Mgt Supplemental Database TypesExtra Features Files12: Fixed AssetsBusiness Data
965920F12092F3111Fixed Assets Supplemental Data Codes TypeExtra Features Files12: Fixed AssetsBusiness Data
966920F1210FB81Location History TextHistory Files13: Plant/Equipment ManagementBusiness Data
967920F1210WFB81WF - Location History - Log DetailRegular Work Files13: Plant/Equipment ManagementBusiness Data
968920F1212FY83Parent HistoryHistory Files13: Plant/Equipment ManagementBusiness Data
969920F1212PFY81Parent History Purge TableHistory Files13: Plant/Equipment ManagementBusiness Data
970920F12141DT72Disposal Account Rule TableConstants Files12: Fixed AssetsBusiness Data
971920F1215GV151Specification Cross ReferenceConstants Files13: Plant/Equipment ManagementBusiness Data
972920F1216GZ181Specification DataSecondary Master Files13: Plant/Equipment ManagementBusiness Data
973920F1217WR712Equipment Master ExtensionSecondary Master Files17C: Call ManagementBusiness Data
974920F1217PWR712Equipment Master Extension Purge TableSecondary Master Files17C: Call ManagementBusiness Data
975920F1217Z1WR721Unedited Equipment Tag TransactionsTransaction Files17C: Call ManagementBusiness Data
976920F1217Z2WR861Unedited Equipment Tag TransactionsTransaction Files17C: Call ManagementBusiness Data
977920F12841RI62Revaluation IndexSecondary Master Files12: Fixed AssetsBusiness Data
978920F12851LU261Depreciation RulesConstants Files12: Fixed AssetsBusiness Data
979920F12851DLU261Demo Depreciation RulesInstall Files12: Fixed AssetsBusiness Data
980920F12852LV232Annual Depreciation RulesConstants Files12: Fixed AssetsBusiness Data
981920F12852DLV231Demo Annual Depreciation RulesInstall Files12: Fixed AssetsBusiness Data
982920F12853LW171Depreciation FormulasConstants Files12: Fixed AssetsBusiness Data
983920F12853DLW171Demo Depreciation FormulasInstall Files12: Fixed AssetsBusiness Data
984920F12854LZ161Depreciation Period Spread RulesConstants Files12: Fixed AssetsBusiness Data
985920F12911ERGL201Post G/L to FA Exceptions Work FileRegular Work Files12: Fixed AssetsBusiness Data
986920F1301FG235Equipment RatesExtra Features Files13: Plant/Equipment ManagementBusiness Data
987920F1301PFG231Equipment Rates Purge TableExtra Features Files13: Plant/Equipment ManagementBusiness Data
988920F1391F831Equipment Category Code MappingConstants Files13: Plant/Equipment ManagementBusiness Data
989920F1392GF22Supplemental Data Cross RefFiles13: Plant/Equipment ManagementBusiness Data
13: Plant/Equipment Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
990920F1206FH101Equipment License MasterSecondary Master Files13: Plant/Equipment ManagementBusiness Data
991920F1206PFH101Equipment License Master Purge TableSecondary Master Files13: Plant/Equipment ManagementBusiness Data
992920F1207FW666Maintenance Schedule FileMaster Files13: Plant/Equipment ManagementBusiness Data
993920F12071FZ761Equipment PM Schedule (Model)Secondary Master Files13: Plant/Equipment ManagementBusiness Data
994920F1207PFW661Maintenance Schedule Purge TableMaster Files13: Plant/Equipment ManagementBusiness Data
995920F12120Z1SZ342Unedited Meter Reading TransactionsBatch Input Files13: Plant/Equipment ManagementBusiness Data
996920F12121ET152Equipment TemplatesMaster Files13: Plant/Equipment Management
997920F12122EL92Equipment Template ListingMaster Files13: Plant/Equipment Management
998920F1300F9101Equipment ConstantsConstants Files13: Plant/Equipment ManagementBusiness Data
999920F13017PL464Equipment Parts ListFiles13: Plant/Equipment ManagementBusiness Data
1000920F1302FK291Rental RulesExtra Features Files13: Plant/Equipment ManagementBusiness Data
1001920F1303FJ121Billing Exception DaysExtra Features Files13: Plant/Equipment ManagementBusiness Data
1002920F1304FN294Equipment Location BillingTransaction Files13: Plant/Equipment ManagementBusiness Data
1003920F1305FV101Equipment Distribution RulesExtra Features Files13: Plant/Equipment ManagementBusiness Data
1004920F1306F5161Meter Reading EstimatesExtra Features Files13: Plant/Equipment ManagementBusiness Data
1005920F1306PF5161Meter Reading Estimates Purge TableExtra Features Files13: Plant/Equipment ManagementBusiness Data
1006920F1307F1224Status History FileHistory Files13: Plant/Equipment ManagementBusiness Data
1007920F1307PF1221Status History Purge TableHistory Files13: Plant/Equipment ManagementBusiness Data
1008920F1308F072Equipment Routes TableSecondary Master Files13: Plant/Equipment ManagementBusiness Data
1009920F1308PF071Equipment Routes Purge TableSecondary Master Files13: Plant/Equipment ManagementBusiness Data
1010920F13411RX432PM ProjectionsHistory Files13: Plant/Equipment ManagementBusiness Data
1011920F1390FV61Equipment Rate Code DefinitionExtra Features Files13: Plant/Equipment ManagementBusiness Data
1012920F13907FC71Associated Service TypesExtra Features Files13: Plant/Equipment ManagementBusiness Data
1013920F13907PFC71Associated Service Types Purge TableExtra Features Files13: Plant/Equipment ManagementBusiness Data
1014920F1393GO281Maintenance RulesConstants Files13: Plant/Equipment ManagementBusiness Data
1015920F3111IGSIG121WO Parts for IGS IntegrationFiles13: Plant/Equipment Management
1016920F4829DL171Work Order Delivery InformationFiles13: Plant/Equipment ManagementBusiness Data
13C: Condition-Base Maintenance
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1017920F1310CA834Condition-Based AlertsFiles13C: Condition-Base Maintenance
1018920F1310Z1CB971Unedited Condition-Based AlertsFiles13C: Condition-Base Maintenance
1019920F1316CM191Condition-Based Maintenance Message RulesFiles13C: Condition-Base Maintenance
1020920F1318AR202Condition-Based Maintenance Alert Action RulesFiles13C: Condition-Base Maintenance
13E: Equipment Cost Analysis
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1021920F1380EA141Equipment Analysis GroupsExtra Features Files13E: Equipment Cost AnalysisBusiness Data
1022920F1381EF531Equipment Analysis FiltersExtra Features Files13E: Equipment Cost Analysis
1023920F1382EL184Equipment Analysis ListingFiles13E: Equipment Cost Analysis
1024920F1383EC365Equipment Analysis CostsFiles13E: Equipment Cost Analysis
1025920F1385ER132Equipment Analysis RulesFiles13E: Equipment Cost Analysis
13R: Resource Assignments
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1026920F48301RX241Resource Assignments ConstantsMaster Files13R: Resource AssignmentsBusiness Data
1027920F48302WP163Maintenance Schedule PeriodsFiles13R: Resource Assignments
1028920F48307RH282Resource Working HoursFiles13R: Resource AssignmentsBusiness Data
1029920F48310RM533Resource MasterMaster Files13R: Resource AssignmentsBusiness Data
1030920F48311RA668Resource AssignmentsFiles13R: Resource AssignmentsBusiness Data
1031920F48311SRA665Purge - Resource AssignmentsPurge Files13R: Resource AssignmentsBusiness Data
1032920F48315WS233Maintenance Schedule MetricsFiles13R: Resource Assignments
1033920F48316RS242Maintenance Rescheduling MetricsFiles13R: Resource Assignments
14: Modeling - Planning & Budgeting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1034920F1401BP161Budget PatternsConstants Files14: Modeling - Planning & BudgetingBusiness Data
1035920F1403BD301Forecast BasisFiles14: Modeling - Planning & Budgeting
1036920F1404BY582Forecast Results - HeaderFiles14: Modeling - Planning & Budgeting
1037920F14041BZ311Forecast Results - DetailFiles14: Modeling - Planning & Budgeting
1038920F1405BB181Business Unit Growth PatternsFiles14: Modeling - Planning & Budgeting
1039920F1406FB233Forecast Growth PatternsFiles14: Modeling - Planning & Budgeting
15: Real Estate Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1040920F1501NE723Tenant/Lease MasterMaster Files15: Real Estate ManagementBusiness Data
1041920F15011NK231Billings Generation Control MasterBalance Files15: Real Estate ManagementBusiness Data
1042920F15011BNK711BIllings Generation ControlBalance Files15: Real Estate ManagementBusiness Data
1043920F15012NS691Tenant E.P. Class MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1044920F150120NW171Tenant Exclusion HeaderFiles15: Real Estate ManagementBusiness Data
1045920F150120DNW101Tenant Exclusion - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1046920F150121NX251Tenant Exclusion DetailFiles15: Real Estate ManagementBusiness Data
1047920F150122NY191Share Factor Denominator HeaderFiles15: Real Estate ManagementBusiness Data
1048920F150122ASA241Share Factor Denominator AuditFiles15: Real Estate ManagementBusiness Data
1049920F150122DNY101Share Factor Denominator - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1050920F150123NZ151Share Factor Denominator DetailFiles15: Real Estate ManagementBusiness Data
1051920F15012BNS978Tenant E.P. Class MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1052920F15013NO681Sales Overage MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1053920F15013BNO896Sales Overage Master FileSecondary Master Files15: Real Estate ManagementBusiness Data
1054920F15014NP361Product Scales MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1055920F15014BNP559Product Scales MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1056920F15015NQ401Minimum rent/recoveries MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1057920F15015BNQ545Min/Max Rents And Recoveries MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1058920F15016NU701Tenant Escalation MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1059920F15016BNU824Tenant Escalation MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1060920F15017NW576Lease Master DetailBalance Files15: Real Estate ManagementBusiness Data
1061920F15019DNL101Billing Frequency - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1062920F1501BNE618Lease Master HeaderMaster Files15: Real Estate ManagementBusiness Data
1063920F1501BDNE111Lease Master Header - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1064920F1502NF711Recurring Billings MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1065920F15020NN624Extended Billings MasterMaster Files15: Real Estate ManagementBusiness Data
1066920F1502BNF8212Recurring Billings MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1067920F1502BDNF111Recurring Billings Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1068920F1502WABNF221Rent Increase AmountsRegular Work Files15: Real Estate ManagementBusiness Data
1069920F1502WBN4841Estimated EP Recurring BillingsRegular Work Files15: Real Estate ManagementBusiness Data
1070920F1503NB341Log Standards MasterTransaction Files15: Real Estate ManagementBusiness Data
1071920F1504NC141Log Standards Text MasterTransaction Files15: Real Estate ManagementBusiness Data
1072920F1505ND491Management Fee MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1073920F1505BND608Management Fee MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1074920F1505HOK121Revenue Fee Generation HistoryHistory Files15: Real Estate ManagementBusiness Data
1075920F1505HBOK201Revenue Fee Generation HistoryHistory Files15: Real Estate ManagementBusiness Data
1076920F1506OP181Floor MasterMaster Files15: Real Estate ManagementBusiness Data
1077920F1506DOP131Floor Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1078920F1507NH604Unit MasterMaster Files15: Real Estate ManagementBusiness Data
1079920F1507DNH151Unit Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1080920F1510OE361Property Management ConstantsConstants Files15: Real Estate ManagementBusiness Data
1081920F1510BOE431Real Estate Management ConstantsConstants Files15: Real Estate ManagementBusiness Data
1082920F1511NJ871Tenant/Lease Billings DetailTransaction Files15: Real Estate ManagementBusiness Data
1083920F15110BOB183Expense Participation Class AccountRegular Work Files15: Real Estate ManagementBusiness Data
1084920F1511BNJ9512Lease Billings MasterTransaction Files15: Real Estate ManagementBusiness Data
1085920F1511B1NW151Billing Batches SummaryFiles15: Real Estate ManagementBusiness Data
1086920F1511HN#861Tenant/Lease Billings Detail HistoryHistory Files15: Real Estate ManagementBusiness Data
1087920F1511HBNC936Lease Billings HistoryHistory Files15: Real Estate ManagementBusiness Data
1088920F1512NA324Billing Code ExtensionConstants Files15: Real Estate ManagementBusiness Data
1089920F1512DNA111Billing Code Extension - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1090920F1513O3591FASB 13 Lease Control FileTransaction Files15: Real Estate ManagementBusiness Data
1091920F1513BO3692FASB 13 Lease ControlTransaction Files15: Real Estate ManagementBusiness Data
1092920F1514NW254Area MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1093920F15141NC293Gross Lease Occupied AreasFiles15: Real Estate ManagementBusiness Data
1094920F15142NV251Area DefinitionsMaster Files15: Real Estate ManagementBusiness Data
1095920F1514DNW161Area Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1096920F1514WNW81Area Work FileWork Files15: Real Estate ManagementBusiness Data
1097920F1515CH231E.P. Cap RulesFiles15: Real Estate ManagementBusiness Data
1098920F15151CD281Building E.P. CapsFiles15: Real Estate ManagementBusiness Data
1099920F15152LC381Lease E.P. CapsSecondary Master Files15: Real Estate ManagementBusiness Data
1100920F151521LO241Lease E.P. Accounts Not Subject to CapFiles15: Real Estate ManagementBusiness Data
1101920F15153LC434Lease Cap HistoryFiles15: Real Estate ManagementBusiness Data
1102920F1516NX91Extended Invoice TextFiles15: Real Estate ManagementBusiness Data
1103920F151991NB201G/L Transaction A/R Application Work FileWork Files15: Real Estate ManagementBusiness Data
1104920F15199WNB133G/L Transaction Summarization Work FileWork Files15: Real Estate ManagementBusiness Data
1105920F1521NB4013Log Detail MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1106920F15211AT1491Real Estate AttributesFiles15: Real Estate Management
1107920F1521DNB111Log Detail Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1108920F1522UT191Unit Attribute Template NameFiles15: Real Estate Management
1109920F15221UF122Unit Attribute Template FieldsFiles15: Real Estate Management
1110920F1523OG282Log Standard MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1111920F1523DOG111Log Standards Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1112920F1525N0371A/R Fee InterestSecondary Master Files15: Real Estate ManagementBusiness Data
1113920F1525BNM453Fees and InterestSecondary Master Files15: Real Estate ManagementBusiness Data
1114920F1530NG342Expense Participation Class MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1115920F15301AO352E.P. Class Account OverridesFiles15: Real Estate ManagementBusiness Data
1116920F15302LT161Ledger Type GroupsFiles15: Real Estate ManagementBusiness Data
1117920F15303CH312E.P. Class Expenses HistoryHistory Files15: Real Estate ManagementBusiness Data
1118920F1530HNG201Expense Participation Class Master HeaderMaster Files15: Real Estate ManagementBusiness Data
1119920F1530HDHD101E.P. Class Master Alternate DescriptionFiles15: Real Estate ManagementBusiness Data
1120920F1531OM283Expense Participation Class AdjustmentSecondary Master Files15: Real Estate ManagementBusiness Data
1121920F1531DOM111Expense Participation Class Adj. - Alternate DescriptionFiles15: Real Estate ManagementBusiness Data
1122920F1532BNT345Expense Participation Audit FileHistory Files15: Real Estate ManagementBusiness Data
1123920F1533NM121Tenant Class Account ExclusionsTransaction Files15: Real Estate ManagementBusiness Data
1124920F1533BNM521Tenant Account ExclusionsMaster Files15: Real Estate ManagementBusiness Data
1125920F1538NZ851WF - Expence Participation RegisterSecondary Master Files15: Real Estate ManagementBusiness Data
1126920F1538BNZ1523EP Billing RegisterRegular Work Files15: Real Estate ManagementBusiness Data
1127920F1538B1GU391Occupancy Gross Up AuditTransaction Files15: Real Estate ManagementBusiness Data
1128920F1538B2RD271Exclusion/RedistributionFiles15: Real Estate ManagementBusiness Data
1129920F1539AAU331EP Billing Account Adjustments AuditFiles15: Real Estate ManagementBusiness Data
1130920F1539CAU281EP Billing Class Adjustments Audit FileFiles15: Real Estate ManagementBusiness Data
1131920F1539EAU341EP Billing Account Exclusions AuditFiles15: Real Estate ManagementBusiness Data
1132920F1539FCAU271EP Billing Adj Factor EP Class AuditFiles15: Real Estate ManagementBusiness Data
1133920F1539FLAU331EP Billing Adj Factor Lease AuditFiles15: Real Estate ManagementBusiness Data
1134920F1540NR411Sales Report Control FileTransaction Files15: Real Estate ManagementBusiness Data
1135920F1540BNR677Sales Report ControlTransaction Files15: Real Estate ManagementBusiness Data
1136920F1541N8341Tenant Sales HistoryHistory Files15: Real Estate ManagementBusiness Data
1137920F15410N9401Tenant Weekly SalesHistory Files15: Real Estate ManagementBusiness Data
1138920F1541BN8504Tenant Sales HistoryHistory Files15: Real Estate ManagementBusiness Data
1139920F1541BWOW621Sales History Work FileFiles15: Real Estate ManagementBusiness Data
1140920F1542OJ512Projected SalesFiles15: Real Estate ManagementBusiness Data
1141920F1543BOA792Tenant Sales Analysis Reporting FileBalance Files15: Real Estate ManagementBusiness Data
1142920F1544OB351Sales Analysis Control FileSecondary Master Files15: Real Estate ManagementBusiness Data
1143920F1544BOB481Sales Analysis ControlSecondary Master Files15: Real Estate ManagementBusiness Data
1144920F1544BDOB121Sales Analysis Control - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1145920F1547OI281Sales SeasonalityFiles15: Real Estate ManagementBusiness Data
1146920F1548N1611Escalation Billing RegisterTransaction Files15: Real Estate ManagementBusiness Data
1147920F1548BN1721Escalation Billing RegisterTransaction Files15: Real Estate ManagementBusiness Data
1148920F1549OL141Seasonality ModelsFiles15: Real Estate ManagementBusiness Data
1149920F1550NV221Escalation Index MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1150920F15525WRT591PM Statements Credit/Cash Build WorkfileWork Files15: Real Estate ManagementBusiness Data
1151920F1565JF405Security Deposit MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1152920F1570ND252Legal ClausesMaster Files15: Real Estate ManagementBusiness Data
1153920F15701NK253Legal Clause Options AuditSecondary Master Files15: Real Estate ManagementBusiness Data
1154920F157011NA141Lease Option Type HeaderMaster Files15: Real Estate ManagementBusiness Data
1155920F157011DNA101Lease Option Type Header - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1156920F157012NC201Lease Option Type DetailMaster Files15: Real Estate ManagementBusiness Data
1157920F157012DNC111Lease Option Type Detail - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1158920F15702NF242Legal Clause Space DetailSecondary Master Files15: Real Estate ManagementBusiness Data
1159920F157021NG223Legal Clause Space Detail AuditSecondary Master Files15: Real Estate ManagementBusiness Data
1160920F15702DNF131Legal Clause Space Detail - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1161920F15703NI243Legal Clause AmountsSecondary Master Files15: Real Estate ManagementBusiness Data
1162920F159071NY242Market/Potential/Renewal Rent MasterSecondary Master Files15: Real Estate ManagementBusiness Data
1163920F159071DNY131Market/Potential/Renewal Rent Master - Alternate DescriptionExtra Features Files15: Real Estate ManagementBusiness Data
1164920F8915CV1N7161Property Management Table Conversion Master AuditWork Files15: Real Estate ManagementBusiness Data
1165920F8915CV2N991Property Management Table Conversion Detail AuditWork Files15: Real Estate ManagementBusiness Data
15L: Adv Real Estate Forecasting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1166920F15L001WQ1192Work File for R15L001Files15L: Adv Real Estate ForecastingBusiness Data
1167920F15L100BC453AREF Building ConstantsFiles15L: Adv Real Estate ForecastingBusiness Data
1168920F15L1001BM452AREF Building Constants ModelsFiles15L: Adv Real Estate ForecastingBusiness Data
1169920F15L101UM999AREF Unit MasterFiles15L: Adv Real Estate ForecastingBusiness Data
1170920F15L102AH381AREF Unit Assumptions Master HeaderFiles15L: Adv Real Estate ForecastingBusiness Data
1171920F15L103SH271AREF Sales Overage Rule HeaderFiles15L: Adv Real Estate ForecastingBusiness Data
1172920F15L104EH231AREF E.P. Rules HeaderFiles15L: Adv Real Estate ForecastingBusiness Data
1173920F15L105GP371AREF Growth Pattern FileFiles15L: Adv Real Estate ForecastingBusiness Data
1174920F15L106RB211AREF Recurring Bill Code Rules HeaderFiles15L: Adv Real Estate ForecastingBusiness Data
1175920F15L107EF222AREF Recycle Assumption RulesFiles15L: Adv Real Estate ForecastingBusiness Data
1176920F15L108AD392AREF Base Account DefinitionFiles15L: Adv Real Estate ForecastingBusiness Data
1177920F15L109BR393AREF Budget ResultsFiles15L: Adv Real Estate ForecastingBusiness Data
1178920F15L109WGA261AREF Grown Amounts Work FileFiles15L: Adv Real Estate ForecastingBusiness Data
1179920F15L110AS531AREF Account StatusFiles15L: Adv Real Estate ForecastingBusiness Data
1180920F15L111AD351AREF Account Status DetailFiles15L: Adv Real Estate ForecastingBusiness Data
1181920F15L112AD281AREF Unit Assumptions Master DetailFiles15L: Adv Real Estate ForecastingBusiness Data
1182920F15L113SD191AREF Sales Overage DetailFiles15L: Adv Real Estate ForecastingBusiness Data
1183920F15L114ED322AREF E.P. Rules DetailFiles15L: Adv Real Estate ForecastingBusiness Data
1184920F15L116RD231AREF Recurring Bill Code Rules DetailFiles15L: Adv Real Estate ForecastingBusiness Data
1185920F15L118DD331AREF Base Account Definition DetailFiles15L: Adv Real Estate ForecastingBusiness Data
1186920F15L120AA171AREF Account AssociationFiles15L: Adv Real Estate ForecastingBusiness Data
1187920F15L141GL323AREF Gross Lease Occupied AreaFiles15L: Adv Real Estate ForecastingBusiness Data
1188920F15L200PL71AREF Permission ListsFiles15L: Adv Real Estate ForecastingBusiness Data
1189920F15L201PD82AREF Permission List DetailsFiles15L: Adv Real Estate ForecastingBusiness Data
1190920F15L202AS103AREF SecurityFiles15L: Adv Real Estate ForecastingBusiness Data
1191920F15L301PS591AREF Projected SalesFiles15L: Adv Real Estate ForecastingBusiness Data
1192920F15L302PG243AREF Prior Gross BillingsFiles15L: Adv Real Estate ForecastingBusiness Data
1193920F15L38NZ1402AREF EP Billing RegisterRegular Work Files15L: Adv Real Estate ForecastingBusiness Data
1194920F15L401SF512AREF Share Factor Denominator AuditFiles15L: Adv Real Estate Forecasting
1195920F15L402SG322AREF Tenant Exclusion Rule AuditFiles15L: Adv Real Estate Forecasting
1196920F15L403SH411AREF Gross Up Processing AuditFiles15L: Adv Real Estate ForecastingBusiness Data
16: Profit Management (EPS)
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1197920F1602CB611Cost Analyzer BalancesBalance Files16: Profit Management (EPS)Business Data
1198920F1602Z1CZ932External Cost Analyzer Balances - Interoperability TableFiles16: Profit Management (EPS)Business Data
1199920F1603CV251Cost Analyzer View StructureExtra Features Files16: Profit Management (EPS)Business Data
1200920F1609CC171Cost Management ConstantsConstants Files16: Profit Management (EPS)Business Data
1201920F1610CD741Cost Calculation DefinitionsExtra Features Files16: Profit Management (EPS)Business Data
1202920F1611CT482Cost Calculation TransactionsTransaction Files16: Profit Management (EPS)Business Data
1203920F1620CT141Cost Object TypesConstants Files16: Profit Management (EPS)Business Data
1204920F1630CD481Driver DefinitionsMaster Files16: Profit Management (EPS)Business Data
1205920F1632CB391Driver BalancesBalance Files16: Profit Management (EPS)Business Data
1206920F1632Z1CY611External Driver Balances-Interoperability TableFiles16: Profit Management (EPS)Business Data
1207920F1640AM212Activity Master FileMaster Files16: Profit Management (EPS)Business Data
1208920F1642RH161Rate Master Header FileMaster Files16: Profit Management (EPS)Business Data
1209920F16421RD181Rate Master Detail FileMaster Files16: Profit Management (EPS)Business Data
1210920F1690CK143Enables Tables by ApplicationSecondary Master Files16: Profit Management (EPS)Business Data
1211920F16UI001CA51Enabled Tables by Application work fileWork Files16: Profit Management (EPS)Business Data
17: Customer Service Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1212920F17113AD151Assessor DefaultsSecondary Master Files17: Customer Service ManagementBusiness Data
1213920F1720CH742Contract HeaderMaster Files17: Customer Service ManagementBusiness Data
1214920F1721CD1327Contract DetailMaster Files17: Customer Service ManagementBusiness Data
1215920F1724CT311Service Contract CoverageMaster Files17: Customer Service ManagementBusiness Data
1216920F1725ST201Service Contract ServicesMaster Files17: Customer Service ManagementBusiness Data
1217920F1726DR91Contract Duration RangesMaster Files17: Customer Service ManagementBusiness Data
1218920F1729SP132Service Contract Service PackageMaster Files17: Customer Service ManagementBusiness Data
1219920F1732RA231Registration Activity RulesFiles17: Customer Service ManagementBusiness Data
1220920F1762SC81Case Inactivity Time ScheduleFiles17: Customer Service ManagementBusiness Data
1221920F1771RT121Standard Repair TimeFiles17: Customer Service ManagementBusiness Data
1222920F1775TC361Claim Temporary TableFiles17: Customer Service ManagementBusiness Data
1223920F1791EM131Entitlement DatesMaster Files17: Customer Service ManagementBusiness Data
1224920F1792CP91Cost Code PercentagesMaster Files17: Customer Service ManagementBusiness Data
1225920F1793LF402S/WM Line Type ConstantsMaster Files17: Customer Service ManagementBusiness Data
1226920F1794NK421Billing/Amort Control MasterMaster Files17: Customer Service ManagementBusiness Data
1227920F3111Z2WP1602Warranty Claim/Supplier Recovery processingBatch Input Files17: Customer Service ManagementBusiness Data
1228920F3112Z2WL1791Warranty Claim/Supplier Recovery processingBatch Input Files17: Customer Service ManagementBusiness Data
1229920F31171WS671Parts List - ExtensionSecondary Master Files17: Customer Service ManagementBusiness Data
1230920F31171SWS671Purge Parts List - ExtensionSecondary Master Files17: Customer Service ManagementBusiness Data
1231920F31172WS711Routing Instructions - ExtensionSecondary Master Files17: Customer Service ManagementBusiness Data
1232920F31172SWS711Purge Routing Instructions - ExtensionSecondary Master Files17: Customer Service ManagementBusiness Data
1233920F4117PR221Item Master - Service/Warranty ExtensionSecondary Master Files17: Customer Service ManagementBusiness Data
1234920F41171PB231Item Branch Master - Service/Warranty ExtensionSecondary Master Files17: Customer Service ManagementBusiness Data
1235920F4801TZ2WQ1342Warranty Claim/Supplier Recovery processingTransaction Files17: Customer Service ManagementBusiness Data
1236920F4801Z2WS1482Warranty Claim/Supplier Recovery processingTransaction Files17: Customer Service ManagementBusiness Data
1237920F48161KC234Failure Analysis CodesSecondary Master Files17: Customer Service ManagementBusiness Data
1238920F48162KN302Failure Analysis Tree NamesSecondary Master Files17: Customer Service ManagementBusiness Data
1239920F48163KT115Failure Analysis Tree DefinitionSecondary Master Files17: Customer Service ManagementBusiness Data
1240920F48164KB454Failure Analysis DetailSecondary Master Files17: Customer Service ManagementBusiness Data
1241920F48165KX123Maintenance Request/Work Order Failure AnalysisTransaction Files17: Customer Service ManagementBusiness Data
1242920F48166KP123Failure Analysis Pareto TableExtra Features Files17: Customer Service ManagementBusiness Data
17C: Call Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1243920F17111BC263Base Warranty DefaultsMaster Files17C: Call ManagementBusiness Data
1244920F1713EE223ECOs Applied to EquipmentMaster Files17C: Call ManagementBusiness Data
1245920F1731LQ283Equipment Master Location HistorySecondary Master Files17C: Call ManagementBusiness Data
1246920F17311LD281Equipment Master Location DetailsTransaction Files17C: Call ManagementBusiness Data
1247920F1750CR221S/WM SequencesMaster Files17C: Call ManagementBusiness Data
1248920F1751GS202Case Status RulesTableMaster Files17C: Call ManagementBusiness Data
1249920F1752CT101Case TypesMaster Files17C: Call ManagementBusiness Data
1250920F1753GP171Case PriorityMaster Files17C: Call ManagementBusiness Data
1251920F1754ZB162Case Provider Group Routing RulesSecondary Master Files17C: Call ManagementBusiness Data
1252920F1755ZA21113Case MasterMaster Files17C: Call ManagementBusiness Data
1253920F1757ZA332Task MasterMaster Files17C: Call ManagementBusiness Data
1254920F1758ZB131Time ZonesMaster Files17C: Call ManagementBusiness Data
1255920F1759CL121Case Required FieldsMaster Files17C: Call ManagementBusiness Data
1256920F1760ZB935Time EntryMaster Files17C: Call ManagementBusiness Data
1257920F1790PM162Product Family/Model MasterMaster Files17C: Call ManagementBusiness Data
1258920F1797CS511S/WM Address Book InformationSecondary Master Files17C: Call ManagementBusiness Data
18: Timecard Automation
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1259920F186101FD144Field and Function DefinitionsFiles18: Timecard AutomationBusiness Data
1260920F186201EG102Employee GroupsFiles18: Timecard AutomationBusiness Data
1261920F186202LG92Employee List Group MembersFiles18: Timecard AutomationBusiness Data
1262920F186203SG111Employee Select Group LinesFiles18: Timecard AutomationBusiness Data
1263920F186204CG71Employee Combo Group MembersFiles18: Timecard AutomationBusiness Data
1264920F186205TC21Temp Cached EmployeesFiles18: Timecard AutomationBusiness Data
1265920F186301TT323Timecard TemplatesFiles18: Timecard AutomationBusiness Data
1266920F186401OS113Overtime Rule SetsFiles18: Timecard AutomationBusiness Data
1267920F186402OR102Overtime RulesFiles18: Timecard AutomationBusiness Data
1268920F186403OA141Overtime Accumulator RulesFiles18: Timecard AutomationBusiness Data
1269920F186405OC132Overtime Change Rule LinesFiles18: Timecard AutomationBusiness Data
1270920F186406OL71Overtime Call Rule Set RulesFiles18: Timecard AutomationBusiness Data
1271920F186407OB321Overtime Call BSFN RulesFiles18: Timecard AutomationBusiness Data
1272920F186408PI72Overtime Rule Pay Type InclusionsFiles18: Timecard AutomationBusiness Data
1273920F186409CI72Overtime Rule Pay Type Category InclusionsFiles18: Timecard AutomationBusiness Data
1274920F186410OT131Overtime Time Card Select LinesFiles18: Timecard Automation
1275920F186411OP201Overtime Pay Type Exclusion ListsFiles18: Timecard Automation
1276920F186601MT92Labor Rules Master Transaction FileFiles18: Timecard AutomationBusiness Data
1277920F186602TF2236Labor Rules Tag FileFiles18: Timecard AutomationBusiness Data
1278920F186701RR213Retropay RulesFiles18: Timecard AutomationBusiness Data
1279920F186702PI71Retropay Rules Paytype InclusionsFiles18: Timecard AutomationBusiness Data
1280920F186703CI71Retropay Rule Pay Type Category InclusionsFiles18: Timecard AutomationBusiness Data
1281920F186704RP131Retropay Time Card Select LinesFiles18: Timecard Automation
30: Product Data Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1282920F0007Z1SZ565Work Day Calendar Transaction FileCommunication Files30: Product Data ManagementBusiness Data
1283920F30006IW562Work Center Master FileMaster Files30: Product Data ManagementBusiness Data
1284920F30006TIW121Work Center Master Tag File - not used in B9,obsolete in B10Master Files30: Product Data ManagementBusiness Data
1285920F30006Z1SZ705Work Center Transaction FileTransaction Files30: Product Data ManagementBusiness Data
1286920F30008IW252Work Center Rates FileMaster Files30: Product Data ManagementBusiness Data
1287920F300210EH263Lean Multi Level Bill of Material HeaderFiles30: Product Data Management
1288920F300211ED976Lean Multi Level Bill of Material DetailFiles30: Product Data Management
1289920F3002Z1SZ946Bill of Material Transaction FileTransaction Files30: Product Data ManagementBusiness Data
1290920F300311EH614Lean Multi-Level Routing Detail FileFiles30: Product Data Management
1291920F3003TIR121Routing Tag File - not used in B9, obsolete in B10Master Files30: Product Data ManagementBusiness Data
1292920F3003Z1SZ906Routing Transactions FileTransaction Files30: Product Data ManagementBusiness Data
1293920F3007WU467Work Center Resource UnitsMaster Files30: Product Data ManagementBusiness Data
1294920F3009TIA151Manufacturing Constants Tag File - Needed for upgradeConstants Files89: Conversion ProgramsBusiness Data
1295920F3016KM349Kanban MasterMaster Files30: Product Data ManagementBusiness Data
1296920F30161KD141Kanban Card DetailMaster Files30: Product Data ManagementBusiness Data
1297920F3016TKM112Kanban Master Tag TableFiles30: Product Data Management
1298920F3017KS241Kanban Size Calculation DefinitionFiles30: Product Data Management
1299920F3018KP301Kanban Size Calculation ParametersFiles30: Product Data Management
1300920F3019KR101Kanban Replenishment CapacityFiles30: Product Data Management
1301920F30UI008IJ191Bill of Material Comparison Work FileWork Files30: Product Data ManagementBusiness Data
1302920F30UI010WF32Bill Of Material Work FileFiles30: Product Data Management
1303920F30UI013LK21Low Level Code Work Table for BOM IntegrityFiles30: Product Data Management
1304920F30UI014BH212BOM Header Work File for BIFiles30: Product Data Management
1305920F30UI015BD431BOM Item Fact Work File for BIFiles30: Product Data Management
1306920F30UI016BE234BOM Explosion Work File for BIFiles30: Product Data Management
30A: Product Costing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1307920F300261IE264Item Cost Component DetailFiles30A: Product CostingBusiness Data
1308920F30UI011CC223Work File for Cost ComponentFiles30A: Product Costing
1309920F30UI012PC221Work File for Parent ChildFiles30A: Product Costing
31: Shop Floor Control
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1310920F30161Z1SZ322Inbound Kanban Card DetailBatch Input Files31: Shop Floor ControlBusiness Data
1311920F3102IG443Production CostTransaction Files31A: Manufacturing AccountingBusiness Data
1312920F3102SIG443Purge - Production CostPurge Files31A: Manufacturing AccountingBusiness Data
1313920F3102TIG142Work Order Variance Tag - Needed for upgradeBalance Files89: Conversion ProgramsBusiness Data
1314920F3102WFIG634Production Cost Work FileTransaction Files31A: Manufacturing AccountingBusiness Data
1315920F3105IS152Work Order LSNSecondary Master Files31: Shop Floor ControlBusiness Data
1316920F3105SIS151Purge Work Order LSNPurge Files31: Shop Floor ControlBusiness Data
1317920F3106SD122W.O. Cross Reference FileTransaction Files31A: Manufacturing AccountingBusiness Data
1318920F3108SJ102Summarized WO Cross-ReferenceTransaction Files31A: Manufacturing AccountingBusiness Data
1319920F3109IP254Line/Item Relationship MasterMaster Files31: Shop Floor ControlBusiness Data
1320920F31091IQ258Schedule Quantity DetailTransaction Files31: Shop Floor Control
1321920F31091SIQ258Schedule Quantity Detail PurgeTransaction Files31: Shop Floor Control
1322920F3111WM8714Work Order Parts ListTransaction Files31: Shop Floor Control
1323920F3111SWM871Purge - Shop Floor Parts ListPurge Files31: Shop Floor ControlBusiness Data
1324920F3111STWM31Purge - Shop Floor Parts List Tag Table - Needed for upgradePurge Files89: Conversion ProgramsBusiness Data
1325920F3111TWM71Shop Floor Control Parts List Tag Table - Needed for upgradeTransaction Files89: Conversion Programs
1326920F3111Z1SZ1012Outbound Work Order Parts ListBatch Input Files31: Shop Floor ControlBusiness Data
1327920F3112WL1107Work Order RoutingTransaction Files31: Shop Floor ControlBusiness Data
1328920F31122WT4910Work Order Time TransactionsTransaction Files31: Shop Floor ControlBusiness Data
1329920F31122SWT491Purge Work Order Time TransactionsPurge Files31: Shop Floor ControlBusiness Data
1330920F31122STWT41Purge Work Order Time Transactions Tag Table - Needed for uPurge Files89: Conversion ProgramsBusiness Data
1331920F31122TWT51Work Order Time Transactions Tag Table -- Needed for upgradeTransaction Files89: Conversion ProgramsBusiness Data
1332920F31122Z1SZ641Work Order Time Transactions Unedited Transaction TableBatch Input Files31: Shop Floor ControlBusiness Data
1333920F3112SWL1101Purge Shop Floor Control Routing InstructionsPurge Files31: Shop Floor ControlBusiness Data
1334920F3112STWL121Purge Shop Floor Control Routing Instructions Tag TablePurge Files89: Conversion ProgramsBusiness Data
1335920F3112TWL151Shop Floor Control Routing Instructions Tag Table - Needed f"T" Work Files89: Conversion ProgramsBusiness Data
1336920F3112Z1SZ1241Outbound Work Order RoutingsBatch Input Files31: Shop Floor ControlBusiness Data
1337920F3112Z1TSZ81Outbound Work Order Routings Tag Table - Needed for upgradePurge Files89: Conversion ProgramsBusiness Data
1338920F3114IQ192Rate Schedule Transaction FileTransaction Files31: Shop Floor ControlBusiness Data
1339920F3115NC172Net Change Transaction tableTransaction Files31: Shop Floor Control
1340920F3118WN171Shortage Maintenance Master FileSecondary Master Files31: Shop Floor ControlBusiness Data
1341920F31UI002IG213User Index - Variances"T" Work Files31A: Manufacturing AccountingBusiness Data
1342920F31UI006LS441Line Scheduling Workbench - Work File"T" Work Files31: Shop Floor ControlBusiness Data
1343920F31UI427W1111Labor Variance User Index"T" Work Files31A: Manufacturing AccountingBusiness Data
1344920F31UI802WG253Accumulate Amounts by Account"T" Work Files31A: Manufacturing AccountingBusiness Data
1345920F31UI803SG274Work File for Summarizing Journal Entries"T" Work Files31A: Manufacturing AccountingBusiness Data
1346920F31UI804WR142Exception Report Work FIle"T" Work Files31A: Manufacturing AccountingBusiness Data
1347920F4802SWB101Purge Work Order InstructionsPurge Files31: Shop Floor ControlBusiness Data
31A: Manufacturing Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1348920F30UI003WR313WIP Revaluation Work FileFiles31A: Manufacturing Accounting
31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1349920F31B01WI452Winery MasterFiles31B: Blend Management
1350920F31B02ST382Staff MasterFiles31B: Blend Management
1351920F31B03BM1165Barrel Master TableFiles31B: Blend Management
1352920F31B031BP581Barrel Profile TableFiles31B: Blend Management
1353920F31B032BT201Barrel Types and CapacitiesFiles31B: Blend Management
1354920F31B033BS181Current Barrel Segment MasterFiles31B: Blend Management
1355920F31B03EBE803Barrel Inquiry Work FileFiles31B: Blend Management
1356920F31B04MT232Material Type MasterFiles31B: Blend Management
1357920F31B042MT121Material Type CombinationFiles31B: Blend Management
1358920F31B05EM493Equipment MasterFiles31B: Blend Management
1359920F31B051EC183Equipment ConsumablesFiles31B: Blend Management
1360920F31B052EA254Equipment AssignmentsFiles31B: Blend Management
1361920F31B053CA285Consumable AssignmentsFiles31B: Blend Management
1362920F31B06WV163Weight/Volume ConversionsFiles31B: Blend Management
1363920F31B07EU534EUR Master FileFiles31B: Blend Management
1364920F31B0700SM182Specification MasterFiles31B: Blend Management
1365920F31B0701SD241Specification DetailFiles31B: Blend Management
1366920F31B0702ES171EUR SpecificationsFiles31B: Blend Management
1367920F31B0703WS191Specification Wine StatusesFiles31B: Blend Management
1368920F31B0704VD252Specification Version DetailFiles31B: Blend Management
1369920F31B0705BN412Blend Named Calculation VersionFiles31B: Blend Management
1370920F31B0710HA271Harvest AssumptionsFiles31B: Blend Management
1371920F31B0720PM282Protocol MasterFiles31B: Blend Management
1372920F31B0721EP303EUR ProtocolsFiles31B: Blend Management
1373920F31B0730LA201EUR Loss AssumptionsFiles31B: Blend Management
1374920F31B0731WS201EUR Wine Status Loss AssumptionsFiles31B: Blend Management
1375920F31B0740PA511Planning AssumptionsFiles31B: Blend Management
1376920F31B0741CC221EUR Cull and CascadeFiles31B: Blend Management
1377920F31B0750OF181EUR Operation List FlagFiles31B: Blend Management
1378920F31B0751OL191Operation ListFiles31B: Blend Management
1379920F31B0760CA211EUR Conversion AssumptionsFiles31B: Blend Management
1380920F31B0770BM292Brand MasterFiles31B: Blend Management
1381920F31B0790SV411Specification ValidationFiles31B: Blend Management
1382920F31B07AGAG71EUR Accounting GroupsFiles31B: Blend ManagementBusiness Data
1383920F31B08TM1054Tank MasterFiles31B: Blend Management
1384920F31B0800RE193F31B0800 Recalculation Error HandlingFiles31B: Blend Management
1385920F31B10VB202VBT HeaderFiles31B: Blend Management
1386920F31B100BC251Bill Of Lading Composition DetailsFiles31B: Blend ManagementBusiness Data
1387920F31B101VD254VBT DetailFiles31B: Blend Management
1388920F31B103UV152Unknown Vessel MasterFiles31B: Blend Management
1389920F31B104DP212Named Calculation User Default PathsFiles31B: Blend Management
1390920F31B105PH232Named Calculation Path HeaderFiles31B: Blend Management
1391920F31B106PD192Named Calculation Path DetailFiles31B: Blend Management
1392920F31B107FH232Named Calculation Format HeaderFiles31B: Blend Management
1393920F31B108FD202Named Calculation Format DetailFiles31B: Blend Management
1394920F31B109NC412Blend Named CalculationFiles31B: Blend Management
1395920F31B11WG231Work Group MasterFiles31B: Blend Management
1396920F31B110MB1121Mass Barrel UpdateFiles31B: Blend Management
1397920F31B111GS192Work Group Staff AllocationFiles31B: Blend Management
1398920F31B112AA162Work Group Work Area AssignmentFiles31B: Blend Management
1399920F31B114TB402Trial Blend HeaderFiles31B: Blend Management
1400920F31B115BD347Trial Blend Lot DetailsFiles31B: Blend Management
1401920F31B115WLW1136Trial Blend Input Lot WorkfileFiles31B: Blend Management
1402920F31B116CH222Temperature Conversion Chart HeaderFiles31B: Blend Management
1403920F31B117CD212Temperature Conversion Chart DetailFiles31B: Blend Management
1404920F31B12PA292Work Area MasterFiles31B: Blend Management
1405920F31B120HI341Vessel Inquiry Work FileFiles31B: Blend Management
1406920F31B13WC551Winery ConstantsFiles31B: Blend Management
1407920F31B130CM263Container Master TableFiles31B: Blend Management
1408920F31B14MC231WIM ConstantsFiles31B: Blend Management
1409920F31B15TD302Setup Tank Dip ChartFiles31B: Blend Management
1410920F31B151DC115Setup Tank Dip Chart DetailsFiles31B: Blend Management
1411920F31B17Z1SZ312Operation EUR Transaction FileFiles31B: Blend Management
1412920F31B18Z1SZ382VBT Barrel Transaction FileFiles31B: Blend Management
1413920F31B19Z1SZ512Instructed Attributes Transaction FileFiles31B: Blend Management
1414920F31B20CC71Cost ComponentsMaster Files31B: Blend ManagementBusiness Data
1415920F31B21CG81Cost Groups HeaderMaster Files31B: Blend ManagementBusiness Data
1416920F31B211CG121Cost Groups DetailMaster Files31B: Blend ManagementBusiness Data
1417920F31B23CR71GL Category Cost Group Cross ReferenceMaster Files31B: Blend ManagementBusiness Data
1418920F31B25TR285QA History Results WorkfileFiles31B: Blend Management
1419920F31B31WL915Blend Lot MasterFiles31B: Blend Management
1420920F31B311LC259Lot CompositionFiles31B: Blend Management
1421920F31B314LS122Lot StyleFiles31B: Blend Management
1422920F31B315LO113Lot OwnersFiles31B: Blend Management
1423920F31B316LE114Lot EURFiles31B: Blend Management
1424920F31B317LC192Lot CommentsFiles31B: Blend Management
1425920F31B318AC151Lot Accumulated AdditivesFiles31B: Blend Management
1426920F31B31CBC131Blend Lot CostsMaster Files31B: Blend ManagementBusiness Data
1427920F31B31Z1SZ367Operations Composition Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1428920F31B32WS181Wine StatusFiles31B: Blend Management
1429920F31B33OD144Operation DependencyFiles31B: Blend Management
1430920F31B33DCDT201Dependency Chain Cache StructureFiles31B: Blend Management
1431920F31B33WRW112Related TB Report WorkfileFiles31B: Blend Management
1432920F31B34ST282Style DefinitionFiles31B: Blend Management
1433920F31B341SW144Style Invisible By WineryFiles31B: Blend Management
1434920F31B342SA162Style AssigmentFiles31B: Blend Management
1435920F31B343BS282Barrel Style DefinitionFiles31B: Blend Management
1436920F31B34Z1SZ317Operations Style Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1437920F31B35OM172Owner MasterFiles31B: Blend Management
1438920F31B37GA194Geographic Area MasterFiles31B: Blend Management
1439920F31B371GR156Geographic Area RelationshipFiles31B: Blend Management
1440920F31B372GD23Growing Area DescendentsFiles31B: Blend Management
1441920F31B373GD23Appellation DescendentsFiles31B: Blend Management
1442920F31B38VR232Variety MasterFiles31B: Blend Management
1443920F31B3CZ1SZ317Operations Cost Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1444920F31B40SA222Summary Attributes Definition FileFiles31B: Blend Management
1445920F31B40WQW164Summary Attributes Query Work FileFiles31B: Blend Management
1446920F31B42IN162Instructed Attributes DefinitionFiles31B: Blend Management
1447920F31B45AT342Additive TemplatesFiles31B: Blend Management
1448920F31B46CT323Consumable TemplatesFiles31B: Blend Management
1449920F31B50BD183Blend ID DefinitionFiles31B: Blend Management
1450920F31B501BS31Blend ID Sequence NumbersFiles31B: Blend Management
1451920F31B5100AC241Wine Premises Report Attribute TableFiles31B: Blend Management
1452920F31B5101WL241Wine Premises Report Line DefinitionFiles31B: Blend Management
1453920F31B5102WC282Wine Premises Report ConfigurationFiles31B: Blend Management
1454920F31B5103AD292Wine Premises Report Operation DetailFiles31B: Blend Management
1455920F31B5120WP401Wine Premises Report PreviewFiles31B: Blend Management
1456920F31B52Z1SZ317Operations Equipment Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1457920F31B53Z1SZ327Operations Consumables Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1458920F31B60OT1001Operation Trace Track WorkfileFiles31B: Blend Management
1459920F31B61EL761End Wine Lots WorkfileFiles31B: Blend Management
1460920F31B62SS471Sample Search Work TableFiles31B: Blend Management
1461920F31B65OH648Operation HeaderFiles31B: Blend Management
1462920F31B65Z1SZ998Operations Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1463920F31B66BT592Blend TransactionsMaster Files31B: Blend ManagementBusiness Data
1464920F31B66BAO181Blend As Of BalanceFiles31B: Blend Management
1465920F31B67QA172Quality AssignmentsFiles31B: Blend ManagementBusiness Data
1466920F31B68RO101Reversed OperationsFiles31B: Blend Management
1467920F31B70VA494Operation Vessel AssignmentsFiles31B: Blend Management
1468920F31B71VV263Operation - Vessel to Vessel DetailFiles31B: Blend Management
1469920F31B72VD201Operation Vessel DipsFiles31B: Blend Management
1470920F31B73BC672Base Operation Configuration.Files31B: Blend Management
1471920F31B74WM82Operation Workflow Status MappingFiles31B: Blend Management
1472920F31B75OC1302Operation ConfigurationFiles31B: Blend Management
1473920F31B751OA781Operation Configuration for Vessel AttributesFiles31B: Blend Management
1474920F31B75CCG131Configured Op Cost Groups by WineryFiles31B: Blend Management
1475920F31B76VW142Wineries for Configured OperationFiles31B: Blend Management
1476920F31B77VM142Material Types for Configured OperationFiles31B: Blend Management
1477920F31B78WS152Wine Statuses for Configured OperationFiles31B: Blend Management
1478920F31B79DS182Default Styles for Operation ConfigurationFiles31B: Blend Management
1479920F31B80LC182Default Lot Comments for Configured OperationFiles31B: Blend Management
1480920F31B81VT152Vessel Types for Configured OperationFiles31B: Blend Management
1481920F31B82VE132Equipment Types for Configured OperationFiles31B: Blend Management
1482920F31B84OA252Operation AdditivesFiles31B: Blend Management
1483920F31B85WT754Weigh Tag MasterFiles31B: Blend Management
1484920F31B87LO431List of Operations View Work FileFiles31B: Blend Management
1485920F31B88IV1071Inventory By Vessel WorkfileFiles31B: Blend Management
1486920F31B90QA121QA for Operation ConfigurationFiles31B: Blend ManagementBusiness Data
1487920F31B91BL653Bill Of Lading MasterFiles31B: Blend ManagementBusiness Data
1488920F31B922PL111Permission List DefinitionFiles31B: Blend Management
1489920F31B93WH383Work Order HeaderFiles31B: Blend ManagementBusiness Data
1490920F31B93Z1SZ387WIM Work Order Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1491920F31B95OV131QA Test Result Blend Override for Operation ConfigurationFiles31B: Blend ManagementBusiness Data
1492920F31B96BD211Bill Of Lading DetailsFiles31B: Blend ManagementBusiness Data
1493920F31B97HR221Human Resource AssignmentsFiles31B: Blend ManagementBusiness Data
1494920F31B97Z1SZ307Operations Resource Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1495920F31B98BM312Bottling MasterFiles31B: Blend ManagementBusiness Data
1496920F31B99DD181Decant DetailFiles31B: Blend ManagementBusiness Data
1497920F31BAAIBL151Blend Automatic Accounting InstructionsMaster Files31B: Blend ManagementBusiness Data
1498920F31BQAZ1SZ377Operations Quality Test Transaction FileTransaction Files31B: Blend ManagementBusiness Data
1499920F31BSPZ1ST453Sample TransactionsFiles31B: Blend Management
31P: Engineer To Order
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1500920F31P01PA291Project AttributesFiles31P: Engineer To OrderBusiness Data
1501920F31P10PQ374Project Quote HeaderFiles31P: Engineer To OrderBusiness Data
1502920F31P11QP453Project Quote DetailFiles31P: Engineer To OrderBusiness Data
1503920F31P12TD183Task DependenciesFiles31P: Engineer To OrderBusiness Data
1504920F31P21CC101Cost Classification TableFiles31P: Engineer To OrderBusiness Data
1505920F31PUI01SE111Scheduling Error ReportFiles31P: Engineer To Order
1506920F31PUI02RR51List of Records LockedFiles31P: Engineer To Order
1507920F4801ST1WA51Purge Table Work Order ETO Tag FileFiles48: Work Order Processing
1508920F4801T1WA51Work Order ETO Tag FileFiles48: Work Order Processing
1509920F4801Z11SY92Outbound Work Order ETO Tag FileFiles48: Work Order Processing
32: Configuration Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1510920F3201CM253Configurator Master TableMaster Files32: Configuration ManagementBusiness Data
1511920F32019CH251Configurator Master History TableHistory Files32: Configuration ManagementBusiness Data
1512920F3209CF191Configurator ConstantsConstants Files32: Configuration ManagementBusiness Data
1513920F3210WSW21Segment Value WorkfileFiles32: Configuration Management
1514920F3211KZ183Configurator Segment DetailFiles32: Configuration ManagementBusiness Data
1515920F32119KS181Configurator Segment Detail HistoryFiles32: Configuration ManagementBusiness Data
1516920F3212RC241Configurator Routings FileTransaction Files32: Configuration ManagementBusiness Data
1517920F3215CC4410Configurator Component TableMaster Files32: Configuration ManagementBusiness Data
1518920F32159CH412Configurator Component History TableHistory Files32: Configuration ManagementBusiness Data
1519920F3216PC282Configurator Price/Cost TableSecondary Master Files32: Configuration ManagementBusiness Data
1520920F32169KB281Configurator Price/Cost HistoryFiles32: Configuration ManagementBusiness Data
1521920F3281RT182Rules Table DefinitionExtra Features Files32: Configuration ManagementBusiness Data
1522920F3282RK761Configured Item/Rules Table Cross ReferenceExtra Features Files32: Configuration ManagementBusiness Data
1523920F32821RL181Rules Table Value DefinitionExtra Features Files32: Configuration ManagementBusiness Data
1524920F3283RD422Rules Table DetailExtra Features Files32: Configuration ManagementBusiness Data
1525920F3290C3241Configured Item InformationFiles32: Configuration ManagementBusiness Data
1526920F3291KW393Configured Item SegmentsMaster Files32: Configuration ManagementBusiness Data
1527920F3292KU347Cross Segment Editing RulesSecondary Master Files32: Configuration ManagementBusiness Data
1528920F32921KX182Cross Segment Editing Rules - ValuesSecondary Master Files32: Configuration ManagementBusiness Data
1529920F32922KV192Cross Segment Editing Rules - RangeSecondary Master Files32: Configuration ManagementBusiness Data
1530920F3293KY599Assembly Inclusions RulesSecondary Master Files32: Configuration ManagementBusiness Data
1531920F3295KS111Needed for upgrade from Xe and belowTransaction Files32: Configuration ManagementBusiness Data
1532920F32GOPGP342Configurator GOPFiles32: Configuration Management
33: Capacity Planning
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1533920F3303CT143Capacity Resource ProfileMaster Files33: Capacity PlanningBusiness Data
1534920F3311CN172Capacity Message FileTransaction Files33: Capacity PlanningBusiness Data
1535920F3312CW133Capacity PeggingTransaction Files33: Capacity PlanningBusiness Data
1536920F3313CR82Capacity Load TableTransaction Files33: Capacity PlanningBusiness Data
1537920F33133DC31Capacity Dates FileExtra Features Files33: Capacity PlanningBusiness Data
1538920F33UI001WL273Shop Floor Control Routing Instructions"T" Work Files31: Shop Floor ControlBusiness Data
34: Requirements Planning
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1539920F34004MG43Demand/Supply Inclusion RulesConstants Files34: Requirements PlanningBusiness Data
1540920F34006SJ53Forecast Summary Work FileWork Files36: ForecastingBusiness Data
1541920F3403MP213Branch Relationships Master FileMaster Files34: Requirements PlanningBusiness Data
1542920F3404PM132Co-Products Planning/Costing TableMaster Files34: Requirements PlanningBusiness Data
1543920F3406CR101Customer Address RelationshipFiles34: Requirements Planning
1544920F3411MM3310MPS/MRP/DRP Message FileTransaction Files34: Requirements PlanningBusiness Data
1545920F3412MW187MPS/MRP/DRP Lower Level Requirements FileTransaction Files34: Requirements PlanningBusiness Data
1546920F3413MR52MPS/MRP/DRP Summary FileTransaction Files34: Requirements PlanningBusiness Data
1547920F3420MS31Semphore Value TableTransaction Files34: Requirements PlanningBusiness Data
1548920F3430MV162Vendor Schedule Quantity FileTransaction Files34: Requirements PlanningBusiness Data
1549920F3435MC292Vendor Schedule Commitment FileTransaction Files34: Requirements PlanningBusiness Data
1550920F3440MH262Vendor Schedule History FileTransaction Files34: Requirements PlanningBusiness Data
1551920F34401PN402Production Number Master FileFiles34: Requirements Planning
1552920F34401TPN112Production Number Master Tag FileFiles34: Requirements Planning
1553920F34402PT202Production Number Structure FileFiles34: Requirements Planning
1554920F3450MA302Adhoc Vendor Schedule FileTransaction Files34: Requirements PlanningBusiness Data
1555920F3460MF224Forecast FileMaster Files34: Requirements PlanningBusiness Data
1556920F3460SWFS81Forecast Summary Work TableFiles36: Forecasting
1557920F34A70OW82Last Outbound Work Order TableFiles34: Requirements Planning
1558920F34UI003M8651MPS Time Series User Index"T" Work Files34: Requirements PlanningBusiness Data
1559920F34UI004M8131MPS Net Change User Index"T" Work Files34: Requirements PlanningBusiness Data
1560920F34UI005F574MRP Orders/Requirements User Index-Process Item"T" Work Files34: Requirements PlanningBusiness Data
1561920F34UI006W661MRP Co/By Product Net Quantity User Index"T" Work Files34: Requirements PlanningBusiness Data
1562920F4321PB511Supplier Schedule Master FileSecondary Master Files34: Requirements PlanningBusiness Data
1563920F43211SS131Supplier Schedule Master FileSecondary Master Files34: Requirements PlanningBusiness Data
1564920F43213VP262SRS Ship DatesSecondary Master Files34: Requirements PlanningBusiness Data
1565920F4321TPB121Supplier Schedule Master Tag File - Used for Upgrade from XeSecondary Master Files89: Conversion ProgramsBusiness Data
34A: Advanced Planning & Scheduling
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1566920F34A10N0511APS Integration ConstantsConstants Files34A: Advanced Planning & SchedulingBusiness Data
1567920F34A11N1151Numetrix Integration File DefinitionConstants Files34A: Advanced Planning & SchedulingBusiness Data
1568920F34A110N0152Work Center Resource TableFiles34A: Advanced Planning & Scheduling
1569920F34A120N0252Routing Master Resource TableFiles34A: Advanced Planning & Scheduling
1570920F34A150RR191Work Order Routing Resource TableFiles34A: Advanced Planning & Scheduling
1571920F34A160WR131Work Center Resource SetFiles34A: Advanced Planning & Scheduling
1572920F34A170WD142Work Center Resource and Set XRefFiles34A: Advanced Planning & Scheduling
1573920F34A180RR221Routing Master Resource SetFiles34A: Advanced Planning & Scheduling
1574920F34A190RD212Routing Master Resource and Set XRefFiles34A: Advanced Planning & Scheduling
1575920F34A210N0421ATP RulesFiles34A: Advanced Planning & Scheduling
1576920F34A30N081Order Status Definition TableFiles34A: Advanced Planning & Scheduling
1577920F34A32GP92Star ItemFiles34A: Advanced Planning & Scheduling
1578920F34A40N0621APS Integration Group Setup TableConstants Files34A: Advanced Planning & SchedulingBusiness Data
1579920F34A50IE22APS Integration ErrorsFiles34A: Advanced Planning & Scheduling
1580920F34A60OB152Last Outbound Purchase Order/Transfer OrderFiles34A: Advanced Planning & Scheduling
1581920F34A80N0121Resource Master TableFiles34A: Advanced Planning & Scheduling
1582920F34A90PI81Last Outbound Phantom InformationFiles34A: Advanced Planning & Scheduling
34X: In-Memory Planning Advisor
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1583920F34X001MC173Planning Advisor Message Type ConfigurationFiles34X: In-Memory Planning Advisor
1584920F34X010CC91Planning Advisor Critical Component Items TableFiles34X: In-Memory Planning Advisor
1585920F34X100WMS93Message Summary Work TableFiles34X: In-Memory Planning Advisor
1586920F34X101WIS463Item Summary Work TableFiles34X: In-Memory Planning Advisor
1587920F34X110WIL352Item List Work TableWork Files34X: In-Memory Planning Advisor
1588920F34X200WSD987Planning Details Supply/Demand Work TableFiles34X: In-Memory Planning Advisor
1589920F34X310WPD447Planning Advisor BOM Component Detail TableFiles34X: In-Memory Planning Advisor
35: Enterprise Facility Planning
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1590920F35UI001MA83MPS/MRP Planning - Multiple Plant User Index"T" Work Files35: Enterprise Facility PlanningBusiness Data
36: Forecasting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1591920F3400SG294Forecast Summary FileMaster Files34: Requirements PlanningBusiness Data
1592920F34007FH111Forecast PricesMaster Files34: Requirements PlanningBusiness Data
1593920F3460Z1FT405Forecast Unedited TransactionsFiles34: Requirements PlanningBusiness Data
1594920F3470DS281Demand Spreading TemplateFiles36: ForecastingBusiness Data
37: Quality Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1595920F3701QA793Test Definitions Master FileMaster Files37: Quality ManagementBusiness Data
1596920F37011TE132Test EquipmentFiles37: Quality ManagementBusiness Data
1597920F37012TC141Test ConsumablesFiles37: Quality ManagementBusiness Data
1598920F37013TR221Test Result NameFiles37: Quality ManagementBusiness Data
1599920F37014RC201Test Result ConversionsFiles37: Quality ManagementBusiness Data
1600920F37015CT182Test Result Conversion TablesFiles37: Quality ManagementBusiness Data
1601920F3702QS313Specifications Definitions Master FileMaster Files37: Quality ManagementBusiness Data
1602920F37021QD264Specifications Detail FileMaster Files37: Quality ManagementBusiness Data
1603920F3703QE391Non-Conforming MaterialMaster Files37: Quality ManagementBusiness Data
1604920F3705SC212Sample ContainerFiles37: Quality Management
1605920F3711TR13319Test ResultsMaster Files37: Quality ManagementBusiness Data
1606920F3711Z1SZ1462Test Results Unedited Transaction TableTransaction Files37: Quality ManagementBusiness Data
1607920F3712SD384Sample DetailFiles37: Quality Management
1608920F37900TR11311Certificate of Analysis (COA) ExtractWork Files37: Quality ManagementBusiness Data
1609920F40318QC695Preference Profile - Quality ManagementMaster Files37: Quality ManagementBusiness Data
38: Agreement Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1610920F38001DC141Agreement ConstantsConstants Files38: Agreement ManagementBusiness Data
1611920F38010DN591Agreement MasterMaster Files38: Agreement ManagementBusiness Data
1612920F38011DF401Agreement QuantitiesMaster Files38: Agreement ManagementBusiness Data
1613920F38012DP342Product Source/Destination MasterMaster Files38: Agreement ManagementBusiness Data
1614920F38013DQ221Agreement Quantities ScheduleMaster Files38: Agreement ManagementBusiness Data
1615920F38014DR232Agreement Formulas and FactorsMaster Files38: Agreement ManagementBusiness Data
1616920F38111DZ855Agreements Transaction LedgerTransaction Files38: Agreement ManagementBusiness Data
1617920F38112DX282Agreements Committed QuantitiesTransaction Files38: Agreement ManagementBusiness Data
39: Advanced Stock Valuation
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1618920F3904PL182Item Pool Valuation MasterMaster Files39: Advanced Stock ValuationBusiness Data
1619920F39041VC161Valuation Category MasterMaster Files39: Advanced Stock ValuationBusiness Data
1620920F39042SC162Company G/L Update Method MasterMaster Files39: Advanced Stock ValuationBusiness Data
1621920F3905SV241Valuation Method MasterMaster Files39: Advanced Stock ValuationBusiness Data
1622920F39061SO422Valuation Period TableRegular Work Files39: Advanced Stock ValuationBusiness Data
1623920F390619SO381Historical Valuation Period Detail TableHistory Files39: Advanced Stock ValuationBusiness Data
1624920F39062ST354Valuation Layers TableRegular Work Files39: Advanced Stock ValuationBusiness Data
1625920F39063SU331Period Additional Quantity TableTransaction Files39: Advanced Stock ValuationBusiness Data
1626920F390639SU331Historical Additional Quantity TableHistory Files39: Advanced Stock ValuationBusiness Data
1627920F39064DS262Valuation Document Summary TableRegular Work Files39: Advanced Stock ValuationBusiness Data
1628920F390649DS261Historical Valuation Document Summary TableHistory Files39: Advanced Stock ValuationBusiness Data
1629920F3908CS151Item Pool Valuation Cost MasterMaster Files39: Advanced Stock ValuationBusiness Data
1630920F3910SC273G/L Adjustment TableTransaction Files39: Advanced Stock ValuationBusiness Data
1631920F39120TF262Temporary Period Build File for Stock ValuationWork Files39: Advanced Stock ValuationBusiness Data
1632920F39120WTW214Period Detail Work FileWork Files39: Advanced Stock ValuationBusiness Data
1633920F39121WAQ142Additional Quantity Work FileRegular Work Files39: Advanced Stock ValuationBusiness Data
1634920F39122SV22Company and Unique Key ID From Extracted F4111Work Files39: Advanced Stock ValuationBusiness Data
40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1635920F3002IX8116Bill of Material Master FileMaster Files30: Product Data Management
1636920F30026IE343Item Cost Component Add-OnsSecondary Master Files30A: Product CostingBusiness Data
1637920F3003IR7712Routing Master FileMaster Files30: Product Data ManagementBusiness Data
1638920F3009IA501Job Shop Manufacturing ConstantsConstants Files30: Product Data ManagementBusiness Data
1639920F3011IZ823Bill of Materials Change FileHistory Files30: Product Data ManagementBusiness Data
1640920F3013CY558ECO Parts List DetailSecondary Master Files30: Product Data ManagementBusiness Data
1641920F3015CQ134Component Locator FileSecondary Master Files30: Product Data ManagementBusiness Data
1642920F30UI001WF331Component Locators Work File"T" Work Files30: Product Data ManagementBusiness Data
1643920F30UI002IX143Bill of Material Structure Analysis Work File"T" Work Files30: Product Data ManagementBusiness Data
1644920F30UI004WF734Bill of Material Update Work File"T" Work Files30: Product Data ManagementBusiness Data
1645920F30UI006IL286Lot Tracking Work FileRegular Work Files41: Inventory ManagementBusiness Data
1646920F3405MU72Forecast Consumption PeriodsMaster Files34: Requirements PlanningBusiness Data
1647920F3462MB144Forecast Shipment SummaryMaster Files34: Requirements PlanningBusiness Data
1648920F4001ZSY1491Batch Receiver File - Order HeadingsBatch Input Files42B: Sales Order EntryBusiness Data
1649920F4001Z50HC91Batch Receiver File - Order Headings CommissionsFiles42B: Sales Order Entry
1650920F4001ZTXRT91Recurring Order Header Tax TableBatch Input Files42B: Sales Order EntryBusiness Data
1651920F40039DT541Document Type MasterSecondary Master Files41: Inventory ManagementBusiness Data
1652920F40051RD704Return Material AuthorizationMaster Files42B: Sales Order EntryBusiness Data
1653920F40052RV302Return Material Authorization DefaultsTransaction Files42B: Sales Order EntryBusiness Data
1654920F4006OA221Order Address InformationTransaction Files40: Inventory/OP BaseBusiness Data
1655920F4006ZOY211Batch Order Receiver - Order Address InformationBatch Input Files42B: Sales Order EntryBusiness Data
1656920F40070PF172Preference Master FileMaster Files42: Sales ManagementBusiness Data
1657920F40071CU132Customer Preference GroupsSecondary Master Files42: Sales ManagementBusiness Data
1658920F40072GI132Item Preference GroupsSecondary Master Files42: Sales ManagementBusiness Data
1659920F40073HY332Preference Hierarchy FileSecondary Master Files42: Sales ManagementBusiness Data
1660920F4009CP501Distribution/Manufacturing ConstantsConstants Files41: Inventory ManagementBusiness Data
1661920F40095DL81Default Locations/PrintersConstants Files41: Inventory ManagementBusiness Data
1662920F40096DQ31Default Print QueuesConstants Files41: Inventory ManagementBusiness Data
1663920F4009T1CT101Distribution/Manufacturing Constant Tag TableConstants Files41: Inventory Management
1664920F4011ZSZ2511Batch Receiver File - Order DetailsBatch Input Files42B: Sales Order EntryBusiness Data
1665920F4011Z60DC111Batch Receiver File - Order Details CommissionsFiles42B: Sales Order Entry
1666920F4011ZTXZT201Recurring Order Detail Tax TableBatch Input Files42B: Sales Order EntryBusiness Data
1667920F4012ZSP381Batch Receiver File - Destination QuantityBatch Input Files42B: Sales Order EntryBusiness Data
1668920F4012ZWSP431WF - Destination QuantityRegular Work Files42B: Sales Order EntryBusiness Data
1669920F4013SX101Order Processing Cross Reference FileExtra Features Files40: Inventory/OP BaseBusiness Data
1670920F4013ZKS211Kit Components Batch FileBatch Input Files42B: Sales Order EntryBusiness Data
1671920F4015OT172Order TemplatesTransaction Files40: Inventory/OP BaseBusiness Data
1672920F4016TU113Print MessagesExtra Features Files41: Inventory ManagementBusiness Data
1673920F4017TV101Print Message Report DefaultsExtra Features Files41: Inventory ManagementBusiness Data
1674920F40203FS151Order Activity RulesConstants Files40: Inventory/OP BaseBusiness Data
1675920F40205LF381Line Type Control Constants FileConstants Files40: Inventory/OP BaseBusiness Data
1676920F40205TOI192Line Type Control Constants Tag FileConstants Files40: Inventory/OP BaseBusiness Data
1677920F40241CD21UNSPSC Commodity CodeFiles43B: Voucher Match and Landed Cost
1678920F40241DCA91UNSPSC Code Alternate DescriptionFiles43B: Voucher Match and Landed Cost
1679920F40243CR42Commodity RelationshipFiles43B: Voucher Match and Landed Cost
1680920F40300RPM312Preference Resolution History - MasterExtra Features Files42: Sales ManagementBusiness Data
1681920F40301PT261Preference Profile - Payment TermsExtra Features Files42B: Sales Order Entry
1682920F40301RPT262Preference Resolution Ledger - Payment TermsExtra Features Files42B: Sales Order EntryBusiness Data
1683920F40302PU261Preference Profile - Unit of MeasureExtra Features Files42B: Sales Order EntryBusiness Data
1684920F40302RPU242Preference Resolution Ledger - Pricing Unit Of MeasureExtra Features Files42B: Sales Order EntryBusiness Data
1685920F40303RV261Preference Profile - Revenue Cost CenterExtra Features Files42B: Sales Order EntryBusiness Data
1686920F40303RRV242Preference Resolution Ledger - Revenue Business UnitExtra Features Files42B: Sales Order EntryBusiness Data
1687920F40304PE241Preference Profile - End UseExtra Features Files42B: Sales Order EntryBusiness Data
1688920F40304RPE252Preference Resolution Ledger - End UseExtra Features Files42B: Sales Order EntryBusiness Data
1689920F40305RM301Preference Profile - Print MessagesExtra Features Files42: Sales ManagementBusiness Data
1690920F40305RRM262Preference Resolution Ledger - Print MessagesExtra Features Files42: Sales ManagementBusiness Data
1691920F40306SR311Preference Profile - Inventory SourcingExtra Features Files42: Sales ManagementBusiness Data
1692920F40307LA291Preference Profile - Product AllocationsExtra Features Files42B: Sales Order EntryBusiness Data
1693920F40308GS271Preference Profile - Grade and PotencyExtra Features Files42B: Sales Order EntryBusiness Data
1694920F40308RGS282Preference Resolution Ledger - Grade and PotencyExtra Features Files42B: Sales Order EntryBusiness Data
1695920F40309DY291Preference Profile - Delivery DateExtra Features Files42B: Sales Order EntryBusiness Data
1696920F40309RDY302Preference Resolution Ledger - Delivery DateExtra Features Files42B: Sales Order EntryBusiness Data
1697920F40310LB231Preference Profile - Line of BusinessExtra Features Files42B: Sales Order EntryBusiness Data
1698920F40310RLB242Preference Resolution Ledger - Line Of BusinessExtra Features Files42B: Sales Order EntryBusiness Data
1699920F40311P1231Preference Profile - Price Code 1Extra Features Files42B: Sales Order EntryBusiness Data
1700920F40311RP1242Preference Resolution Ledger - User Defined Price Code #1Extra Features Files42B: Sales Order EntryBusiness Data
1701920F40312P2231Preference Profile - Price Code 2Extra Features Files42B: Sales Order EntryBusiness Data
1702920F40312RP2242Preference Resolution Ledger - User Defined Price Code #2Extra Features Files42B: Sales Order EntryBusiness Data
1703920F40313P3231Preference Profile - Price Code 3Extra Features Files42B: Sales Order EntryBusiness Data
1704920F40313RP3242Preference Resolution Ledger - User Defined Price Code #3Extra Features Files42B: Sales Order EntryBusiness Data
1705920F40314PJ241Preference Profile - Price Adjustment ScheduleExtra Features Files42B: Sales Order EntryBusiness Data
1706920F40314RPJ262Preference Resolution Ledger - Price Adjustment ScheduleExtra Features Files42B: Sales Order EntryBusiness Data
1707920F40315PI241Preference Profile - Invoice CyclingExtra Features Files42: Sales ManagementBusiness Data
1708920F40315RPI262Preference Resolution Ledger - Invoice CycleExtra Features Files42: Sales ManagementBusiness Data
1709920F40316OP261Preference Profile - Order PreparationExtra Features Files42B: Sales Order EntryBusiness Data
1710920F40316ROP272Preference Resolution Ledger - Order Preparation DaysExtra Features Files42B: Sales Order EntryBusiness Data
1711920F40318RQC712Preference Resolution Ledger - Quality ManagementExtra Features Files37: Quality ManagementBusiness Data
1712920F40320LP412Preference Profile - Multi Shipping/Receiving LocationsExtra Features Files46: Warehouse ManagementBusiness Data
1713920F40320RLP423Preference Resolution Ledger - Multi ShiP/Rec LocationsExtra Features Files46: Warehouse ManagementBusiness Data
1714920F40329DD281Preference Profile - Document DistributionExtra Features Files49: Transportation ManagementBusiness Data
1715920F40330DG311Preference Profile - Document SetExtra Features Files49: Transportation ManagementBusiness Data
1716920F40331OE251Preference Profile - Options and EquipmentExtra Features Files49: Transportation ManagementBusiness Data
1717920F40332CF321Preference Profile - Customer FreightExtra Features Files49: Transportation ManagementBusiness Data
1718920F40333CA362Preference Profile - CarrierExtra Features Files49: Transportation ManagementBusiness Data
1719920F40334MT321Preference Profile - Mode of TransportExtra Features Files49: Transportation ManagementBusiness Data
1720920F40338PT251Preference Profile - Payment Terms (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
1721920F40338RPT272Preference Resolution Ledger - Payment Terms (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
1722920F40339LA291Preference Profile - Product Allocations (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
1723920F40341NS271Preference Profile - Next Order StatusExtra Features Files42B: Sales Order EntryBusiness Data
1724920F40341RNS292Preference Resolution Ledger - Next Order StatusExtra Features Files42B: Sales Order EntryBusiness Data
1725920F40344SA311Preference Profile - Sales CommissionExtra Features Files42: Sales ManagementBusiness Data
1726920F40344RSA312Preference Resolution Ledger - Sales CommissionExtra Features Files42B: Sales Order EntryBusiness Data
1727920F40345CR241Preference Profile - Customer CurrencyExtra Features Files42B: Sales Order EntryBusiness Data
1728920F40345RCR262Preference Resolution Ledger - Customer CurrencyExtra Features Files42B: Sales Order EntryBusiness Data
1729920F40347RI261Preference Profile - Pricing UOM (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
1730920F40347RRI282Preference Resolution Ledger - Pricing UOM (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
1731920F40349RV261Preference Profile - Revenue Business Unit (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
1732920F40349RRV282Preference Resolution Ledger - Revenue Bus Unit (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
1733920F40350OQ281Preference Profiles - Conatiner Deposit/RentalExtra Features Files41: Inventory ManagementBusiness Data
1734920F40500CC254Commodity Structure DefinitionsFiles40: Inventory/OP Base
1735920F40510UC92UNSPSC and Commodity Structure RelationshipFiles40: Inventory/OP Base
1736920F40520SC93Supplier and Commodity Structure RelationshipFiles40: Inventory/OP Base
1737920F40530SX104Supplier Commodity Structure Cross ReferenceFiles40: Inventory/OP Base
1738920F40540IC82Item and Commodity Structure RelationshipFiles40: Inventory/OP Base
1739920F40551GL92G/L Account and Commodity Structure RelationshipFiles40: Inventory/OP Base
1740920F40711PD132Preference Values DefinitionFiles45: Advanced PricingBusiness Data
1741920F40721PV152Preference Values DetailFiles45: Advanced PricingBusiness Data
1742920F40741PH181Preference Adjustment HistoryFiles40: Inventory/OP BaseBusiness Data
1743920F4080RO448Related Order Cross Reference TableFiles31P: Engineer To Order
1744920F4090MK41Distribution/Manufacturing - AAI Record TypeConstants Files40: Inventory/OP BaseBusiness Data
1745920F4091KF501Category Code Key Position FileMaster Files40: Inventory/OP BaseBusiness Data
1746920F4092GP131Group Code Key Definition TableMaster Files45: Advanced PricingBusiness Data
1747920F4093GD131Item/Customer Group RelationshipMaster Files45: Advanced PricingBusiness Data
1748920F4094KI112Item/Customer Key ID Master FileMaster Files45: Advanced PricingBusiness Data
1749920F40941IK122Item Key ID Master FileFiles45: Advanced PricingBusiness Data
1750920F40942CK122Customer Key ID Master FileFiles45: Advanced PricingBusiness Data
1751920F40943OK102Order Group Key ID Master FileFiles45: Advanced PricingBusiness Data
1752920F4095ML91Distribution/Manufacturing - AAI ValuesConstants Files40: Inventory/OP BaseBusiness Data
1753920F40P01PH263Promotion Header FileFiles40: Inventory/OP BaseBusiness Data
1754920F40P011PD462Promotion Deal Detail FileFiles40: Inventory/OP BaseBusiness Data
1755920F40UI002UT191Supplier History Rebuild -workfileRegular Work Files43: ProcurementBusiness Data
1756920F40UI00TPN291Tax Work FileRegular Work Files40: Inventory/OP BaseBusiness Data
1757920F40UI17ZG221Allocation Work FileRegular Work Files42B: Sales Order EntryBusiness Data
1758920F40UI74AW811Price Adjustment History Work FileRegular Work Files45: Advanced PricingBusiness Data
1759920F40UI801ZB172Generic Error TableBatch Input Files40: Inventory/OP BaseBusiness Data
1760920F4100LM626Location MasterMaster Files41: Inventory ManagementBusiness Data
1761920F41001CI1082Inventory ConstantsConstants Files41: Inventory ManagementBusiness Data
1762920F41002UM166Item Units of Measure Conversion FactorsConstants Files41: Inventory ManagementBusiness Data
1763920F41003UC101Unit of Measure standard conversionConstants Files41: Inventory ManagementBusiness Data
1764920F41011PK371Bulk Item MasterMaster Files41B: Bulk Stock ManagementBusiness Data
1765920F41015BA122Item Duplication Work FileMaster Files41: Inventory ManagementBusiness Data
1766920F41022PN241Bulk Depot/Product InformationMaster Files41B: Bulk Stock ManagementBusiness Data
1767920F4104IV305Item Cross Reference FileExtra Features Files41: Inventory ManagementBusiness Data
1768920F4106BP327Item Base Price FileMaster Files45: Advanced PricingBusiness Data
1769920F4106NCSZ321Base Price ExtractionFiles45: Advanced PricingBusiness Data
1770920F4108IO626Lot MasterSecondary Master Files41: Inventory ManagementBusiness Data
1771920F41112IN492Item ASOF FileTransaction Files41: Inventory ManagementBusiness Data
1772920F41500PP624Tank Master FileMaster Files41B: Bulk Stock ManagementBusiness Data
1773920F41508PC247Default Tank InformationTransaction Files41B: Bulk Stock ManagementBusiness Data
1774920F4170I081Lot Status Activity RulesFiles41: Inventory ManagementBusiness Data
1775920F4171I1161Critical Hold ManagementFiles41: Inventory ManagementBusiness Data
1776920F42008HC122Order Hold ConstantsConstants Files40: Inventory/OP BaseBusiness Data
1777920F4201Z1SY1453Sales Order Header Unedited Transaction FileTransaction Files42: Sales ManagementBusiness Data
1778920F4207PM332Price by ItemExtra Features Files45: Advanced PricingBusiness Data
1779920F4208PG92Price by CustomerExtra Features Files45: Advanced PricingBusiness Data
1780920F4209HO277Held OrdersTransaction Files40: Inventory/OP BaseBusiness Data
1781920F4211AUAU581Sales Order Detail Audit FileHistory Files42: Sales ManagementBusiness Data
1782920F4211DTDT581Sales Order Detail Date Tracking FileHistory Files42B: Sales Order EntryBusiness Data
1783920F4211Z1SZ2533Sales Order Detail Unedited Transaction FileTransaction Files42: Sales ManagementBusiness Data
1784920F4215XH747Shipment HeaderTransaction Files49: Transportation ManagementBusiness Data
1785920F4217XI135Shipment Reference NumbersTransaction Files49: Transportation ManagementBusiness Data
1786920F4220SW336Basic Serial NumbersExtra Features Files42: Sales ManagementBusiness Data
1787920F4231EF122RT Event Filter DetailsFiles42: Sales Management
1788920F4314JM71Sales Order/Purchasing Text Detail LinesExtra Features Files40: Inventory/OP BaseBusiness Data
1789920F43800PR271Summary Voucher MatchTransaction Files43B: Voucher Match and Landed CostBusiness Data
1790920F46010IP292Item ProfileSecondary Master Files46: Warehouse ManagementBusiness Data
1791920F49080IC51Invoice Cycle CalculationExtra Features Files42: Sales ManagementBusiness Data
1792920F49085ID52Scheduled Invoice DateExtra Features Files42: Sales ManagementBusiness Data
1793920F49190DS171Document Definition File (Conversion from World File)Extra Features Files49: Transportation ManagementBusiness Data
1794920F49211UD1454Sales Order Detail File - Tag FileExtra Features Files42: Sales ManagementBusiness Data
1795920F49211Z1S11603Sales Order Detail Tag Unedited Transaction FileExtra Features Files42: Sales ManagementBusiness Data
1796920F49219UD1181Sales Order Detail - Tag History FileExtra Features Files42: Sales ManagementBusiness Data
40G: Grower Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1797920F31B77BWWS352Work File for Weigh Tag Summary ReportFiles40G: Grower Management
1798920F40G002GC161Grower Block DefaultsFiles40G: Grower Management
1799920F40G003HP164Harvest Period PatternsFiles40G: Grower Management
1800920F40G01GF612Grower FarmFiles40G: Grower Management
1801920F40G02GB1192Grower BlockFiles40G: Grower Management
1802920F40G0200BU1881Grower Block Update ProfileFiles40G: Grower Management
1803920F40G021SB131Block DescriptorsFiles40G: Grower Management
1804920F40G022BS121Block StylesFiles40G: Grower Management
1805920F40G023BC292Block CoordinatesFiles40G: Grower Management
1806920F40G03GH1305Grower HarvestFiles40G: Grower Management
1807920F40G0300HU1711Grower Harvest Update ProfileFiles40G: Grower Management
1808920F40G031FH202Harvest Estimate Freeze HdrFiles40G: Grower Management
1809920F40G032FD353Harvest Estimate Freeze DetailFiles40G: Grower Management
1810920F40G033CH142Continous Harvest EstimatesFiles40G: Grower Management
1811920F40G034HI161Harvest Item MasterFiles40G: Grower Management
1812920F40G041IS341Item Spray InformationFiles40G: Grower Management
1813920F40G042SE181Spray Master EUR RestrictionFiles40G: Grower Management
1814920F40G043SS191Restricted Spray Style Information - F40G043Files40G: Grower Management
1815920F40G101OD142Ownership DistributionFiles40G: Grower Management
1816920F40G102GC141Grower ContactsFiles40G: Grower Management
1817920F40G103IU242EUR - Intended Use DistributionFiles40G: Grower Management
1818920F40G104AD221Grower Action DatesFiles40G: Grower Management
1819920F40G150CP673Crush and Purchase Report DetailsFiles40G: Grower Management
1820920F40G151QL221Quality Result LimitsFiles40G: Grower Management
1821920F40G25WF241QA Operation History WorkfileFiles40G: Grower Management
1822920F40G30SAD282Assessments / Donations WorkfileFiles40G: Grower Management
1823920F40G50MC172Maturity Calc Program Name SetupFiles40G: Grower Management
1824920F40G60HS201Scheduled HarvestFiles40G: Grower Management
1825920F40G65FO482Farming Operation HeaderFiles40G: Grower Management
1826920F40G70WH262Harvest Operation Withholding DateFiles40G: Grower Management
1827920F40G75AC161Farming Operation Additional Configuration SetupFiles40G: Grower Management
1828920F40G80CV161Farming Operation Configuration Values EntryFiles40G: Grower Management
1829920F40G90PI151Grower POP Item Cross ReferenceSecondary Master Files40G: Grower Management
1830920F40G95PP541Pay On Proceeds Log FileTransaction Files40G: Grower Management
40P: Promotions Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1831920F40P02PS132Promotion StatusMaster Files40P: Promotions ManagementBusiness Data
40R: Demand Scheduling
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1832920F40R10DH424Demand HeaderFiles40R: Demand SchedulingBusiness Data
1833920F40R11DD1109Demand DetailFiles40R: Demand SchedulingBusiness Data
1834920F40R12CQ672Cumulative QuantitiesFiles40R: Demand SchedulingBusiness Data
1835920F40R121CR161CUM Required Quantities Detail TableFiles40R: Demand Scheduling
1836920F40R12WFCQ692CUM Rollback WorkfileFiles40R: Demand SchedulingBusiness Data
1837920F40R13DP191Demand PackagingFiles40R: Demand SchedulingBusiness Data
1838920F40R14DA252Demand AddressesFiles40R: Demand SchedulingBusiness Data
1839920F40R141DN161Demand Contact NamesFiles40R: Demand SchedulingBusiness Data
1840920F40R142DC161Demand Contact PhoneFiles40R: Demand SchedulingBusiness Data
1841920F40R143DS241Demand Address HistoryFiles40R: Demand SchedulingBusiness Data
1842920F40R20DR331Demand RulesFiles40R: Demand SchedulingBusiness Data
1843920F40R21XC161Demand Processing Cross ReferenceFiles40R: Demand SchedulingBusiness Data
1844920F40R22DW141Demand WorkflowFiles40R: Demand SchedulingBusiness Data
1845920F40R23PC191Product CUM ModelFiles40R: Demand SchedulingBusiness Data
1846920F40R24CL151Carton CUM ModelFiles40R: Demand SchedulingBusiness Data
1847920F40R30WFDS272Demand Work FileFiles40R: Demand SchedulingBusiness Data
1848920F40R31AD171Additional Demand Label DataFiles40R: Demand SchedulingBusiness Data
1849920F40R41DI1168Demand HistoryFiles40R: Demand SchedulingBusiness Data
1850920F40R42CH632Cumulative Quantity HistoryFiles40R: Demand SchedulingBusiness Data
1851920F47171EH411EDI Demand HeaderFiles40R: Demand SchedulingBusiness Data
1852920F47172ED1152EDI Demand DetailFiles40R: Demand SchedulingBusiness Data
1853920F471721EU371EDI Demand Supplemental DataFiles40R: Demand SchedulingBusiness Data
1854920F471722EA371EDI Demand AddressesFiles40R: Demand SchedulingBusiness Data
1855920F471723EC281EDI Demand Contact NamesFiles40R: Demand SchedulingBusiness Data
1856920F471724EN281EDI Demand Contact NumbersFiles40R: Demand SchedulingBusiness Data
1857920F47173ES431EDI Demand Scheduling DetailFiles40R: Demand SchedulingBusiness Data
1858920F471731EP311EDI Demand PackagingFiles40R: Demand SchedulingBusiness Data
1859920F4720TM91EDI Time ZoneFiles40R: Demand SchedulingBusiness Data
1860920F47800FF231EDI Transmission ValuesFiles40R: Demand Scheduling
1861920F47UI002SP602ASN Extract Packaging Work FileFiles40R: Demand Scheduling
40S: Supply Chain Self Service
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1862920F4947SWSW361Self-Service Shipment Tracking Work FileFiles49: Transportation ManagementBusiness Data
41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1863920F400391DE91Document Type Exclusion RulesFiles41: Inventory Management
1864920F410014T7843Template MasterMaster Files41: Inventory ManagementBusiness Data
1865920F410014DT8191Template Master - Alternative DescriptionFiles41: Inventory ManagementBusiness Data
1866920F41001T1CI81Inventory Constants Tag FileConstants Files41: Inventory ManagementBusiness Data
1867920F41006IK21Transaction Type Document Family FileExtra Features Files41: Inventory ManagementBusiness Data
1868920F41008S0342Matrix DetailFiles41: Inventory ManagementBusiness Data
1869920F41008DS0202Matrix Detail Alternate LanguageFiles41: Inventory ManagementBusiness Data
1870920F41009T9443Child Item Combination TableFiles41: Inventory ManagementBusiness Data
1871920F4101IM2098Item MasterMaster Files41: Inventory ManagementBusiness Data
1872920F41013UN142Unique Product NumberFiles41: Inventory Management
1873920F4101AIM1361Item FileSecondary Master Files41: Inventory ManagementBusiness Data
1874920F4101BIM551Item Master Bulk DataSecondary Master Files41: Inventory ManagementBusiness Data
1875920F4101CIM391Item Category CodesSecondary Master Files41: Inventory ManagementBusiness Data
1876920F4101DIM136Item Master - Alternative DescriptionMaster Files41: Inventory ManagementBusiness Data
1877920F4101FIM291Item Customer Service DataSecondary Master Files41: Inventory ManagementBusiness Data
1878920F4101GIB201Item Branch QuantitiesSecondary Master Files41: Inventory ManagementBusiness Data
1879920F4101HIH83Item Hierarchy (Web)Extra Features Files42B: Sales Order EntryBusiness Data
1880920F4101HDIH41Item Hierarchy - Alternate DescriptionExtra Features Files42B: Sales Order EntryBusiness Data
1881920F4101MIM811Item Manufacturing DataSecondary Master Files41: Inventory ManagementBusiness Data
1882920F4101PIM281Item Master PackagingSecondary Master Files41: Inventory ManagementBusiness Data
1883920F4101SIM311Item Master Shipping DataSecondary Master Files41: Inventory ManagementBusiness Data
1884920F4101WIM351Item Profile DataSecondary Master Files41: Inventory ManagementBusiness Data
1885920F4101Z1SZ2621F4101 Item Master Unedited Transaction TableMaster Files41: Inventory ManagementBusiness Data
1886920F4101Z1ASZ1201F4101 Detail Item Master Unedited TransactionTransaction Files41: Inventory ManagementBusiness Data
1887920F4102IB17613Item Branch FileSecondary Master Files41: Inventory ManagementBusiness Data
1888920F41021LI547Item Location FileBalance Files41: Inventory ManagementBusiness Data
1889920F410211PC82Project Commitment Detail TableFiles41: Inventory ManagementBusiness Data
1890920F41021ALI51Item Location File - Temporary UpgradeFiles41: Inventory Management
1891920F41021TLT231Item Location Tag FileFiles41: Inventory Management
1892920F41021WFLW582F41021 Transaction WorkfileBalance Files41: Inventory ManagementBusiness Data
1893920F41021Z1SZ711Item Location Unedited Transaction FileMaster Files41: Inventory ManagementBusiness Data
1894920F41023IL121Item Location Definition TableMaster Files41: Inventory ManagementBusiness Data
1895920F41025CS232Consignment Sites (FUTURE)Files41: Inventory Management
1896920F4105CO257Item Cost FileMaster Files41: Inventory ManagementBusiness Data
1897920F41051CH112Average Cost Work fileMaster Files41: Inventory ManagementBusiness Data
1898920F4105Z1SZ391Unedited Transaction Table - Item CostTransaction Files41: Inventory ManagementBusiness Data
1899920F41081LS141Allowed Lot StatusFiles41: Inventory Management
1900920F41090T1212Item Supplemental Data TypesConstants Files41: Inventory ManagementBusiness Data
1901920F41092T2164Item Supplemental Data Base User Defined CodesTransaction Files41: Inventory ManagementBusiness Data
1902920F41095T544User Sequence PreferenceExtra Features Files41: Inventory ManagementBusiness Data
1903920F4111IL7213Item Ledger FileTransaction Files41: Inventory ManagementBusiness Data
1904920F41113I8271Lot LedgerFiles41: Inventory ManagementBusiness Data
1905920F41131IU271Stranded Hard Commitments TableFiles41: Inventory ManagementBusiness Data
1906920F4115IH1851Item HistoryHistory Files41: Inventory ManagementBusiness Data
1907920F4118CN442Container Deposit FileMaster Files41: Inventory ManagementBusiness Data
1908920F41181CM527Container Transaction FileTransaction Files41: Inventory ManagementBusiness Data
1909920F41182CS81Container SerialFiles41: Inventory ManagementBusiness Data
1910920F41185CT211Container Reconciliation FileBatch Input Files41: Inventory ManagementBusiness Data
1911920F41291ZIG331Landed Cost Cache TableFiles41: Inventory ManagementBusiness Data
1912920F4130MH241Consignment Master Header (FUTURE)Files41: Inventory Management
1913920F4131MD232Consignment Master Detail (FUTURE)Files41: Inventory Management
1914920F4132UH342Usage Header (FUTURE)Files41: Inventory Management
1915920F4133UD494Usage Detail (FUTURE)Files41: Inventory Management
1916920F4140PI112Cycle Count Header FileExtra Features Files41: Inventory ManagementBusiness Data
1917920F4141PJ344Cycle Count Transaction FileExtra Features Files41: Inventory ManagementBusiness Data
1918920F4141TPC303Cycle Count Transaction Tag FileFiles41: Inventory Management
1919920F4141Z1SZ491F4141 Cycle Count Unedited Transaction TableMaster Files41: Inventory ManagementBusiness Data
1920920F4160IT315Tag Inventory FileExtra Features Files41: Inventory ManagementBusiness Data
1921920F41829IW21Item Word Search TableFiles41: Inventory ManagementBusiness Data
1922920F4190IG21Item GroupsFiles41: Inventory ManagementBusiness Data
1923920F41UI001IT2482Inventory Transactions Detail File"T" Work Files41: Inventory ManagementBusiness Data
1924920F41UI002TI241Inventory Transactions Batch File"T" Work Files41: Inventory ManagementBusiness Data
1925920F41UI003AA102ABC Analysis Detail - Work File"T" Work Files41: Inventory ManagementBusiness Data
41B: Bulk Stock Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1926920F41012VA292Conversion Table Interface FileMaster Files41B: Bulk Stock ManagementBusiness Data
1927920F41500TPL211Tank Master Additional Information Tag FileMaster Files41B: Bulk Stock Management
1928920F41501PD131Blend Category FileBalance Files41B: Bulk Stock ManagementBusiness Data
1929920F41503PB232Tank Strapping Table MaintenanceTransaction Files41B: Bulk Stock ManagementBusiness Data
1930920F41505PO192Allowed Products Matrix FileMaster Files41B: Bulk Stock ManagementBusiness Data
1931920F41506PM271Meter MasterMaster Files41B: Bulk Stock ManagementBusiness Data
1932920F41509PG492Four-Point Analysis Maintenance FileMaster Files41B: Bulk Stock ManagementBusiness Data
1933920F415091PG181Four-Point Temperature MaintenanceSecondary Master Files41B: Bulk Stock ManagementBusiness Data
1934920F41511PA986Bulk Product Transaction FileTransaction Files41B: Bulk Stock ManagementBusiness Data
1935920F41512PT317Gain/Loss Transactions FileTransaction Files41B: Bulk Stock ManagementBusiness Data
1936920F41512TPG171GainLoss Transactions Additional Information Tag FileTransaction Files41B: Bulk Stock Management
1937920F41514RH451Operational Reconciliations HistoryHistory Files41B: Bulk Stock ManagementBusiness Data
1938920F41514TRL211Operational Reconciliations History Tag FileHistory Files41B: Bulk Stock Management
1939920F41515PQ429Multi-Meter ReadingsTransaction Files41B: Bulk Stock ManagementBusiness Data
1940920F415311T3141D4311 Asphalt TableSecondary Master Files41B: Bulk Stock ManagementBusiness Data
41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1941920F41F02WFS1232Style End Item WorkfileFiles41F: Apparel Management
1942920F41F2019AP321Sales Order Header Style Items Tag History FileFiles41F: Apparel Management
1943920F41F201TAP321Sales Order Header Style Items Tag FileFiles41F: Apparel Management
1944920F41F301TAP331Purchase Order Header Style Items Tag FileFiles41F: Apparel Management
1945920FCW01ST83Item Structure DetailFiles41F: Apparel Management
1946920FCW011LT161Item Level TypeFiles41F: Apparel Management
1947920FCW02IS3010Item Structure DefinitionFiles41F: Apparel Management
1948920FCW02Z1RA281FCW02 Item Structure Definition Unedited Transaction TableFiles41F: Apparel Management
1949920FCW03MG331Matrix GridFiles41F: Apparel Management
1950920FCW031SP331Automatic Splitting by Size DefinitionFiles41F: Apparel Management
1951920FCW05CS42Collection Structure DefinitionFiles41F: Apparel Management
1952920FCW06CH212Collection HeaderFiles41F: Apparel Management
1953920FCW07CD123Collection DetailFiles41F: Apparel Management
1954920FCW08WK271Category Codes Work FileFiles41F: Apparel Management
1955920FCW09WR621Item Revisions Work FileFiles41F: Apparel Management
1956920FCW10WB1291Item Branch Work FileFiles41F: Apparel Management
1957920FCW103WM121Style WO Component Scrap InformationFiles41F: Apparel Management
1958920FCW105WF111Fair Share Sprinkling RateFiles41F: Apparel Management
1959920FCW11WP271Item Base Price File Work FileFiles41F: Apparel Management
1960920FCW12WC191Item Cost File Work FileFiles41F: Apparel Management
1961920FCW13WL121Item Location Work FileFiles41F: Apparel Management
1962920FCW14WT201Item Master Tag Work FileFiles41F: Apparel Management
1963920FCW15WF151Work File F41171Files41F: Apparel Management
1964920FCW16WF71Work File F4016Files41F: Apparel Management
1965920FCW17WF121Work File F41002Files41F: Apparel Management
1966920FCW18WF41Work File F49075Files41F: Apparel Management
1967920FCW19WF181Work File F46010Files41F: Apparel Management
1968920FCW20WX1211Matrix Work FileFiles41F: Apparel Management
1969920FCW21WK111Work File Confirm ShipmentsFiles41F: Apparel Management
1970920FCW22WL621Lot Master Work FileFiles41F: Apparel Management
1971920FCW25WO71Enter Work Order Work FileFiles41F: Apparel Management
1972920FCW31LV465Proposal Order Line DetailsFiles41F: Apparel Management
1973920FCW32WS251Item Shipping Information (F4908) Work FileFiles41F: Apparel Management
1974920FCW33PH332Price List HeaderFiles41F: Apparel Management
1975920FCW34PD302Price List DetailFiles41F: Apparel Management
1976920FCW35RO52Rounding MethodsFiles41F: Apparel Management
1977920FCW36RR41Rounding RulesFiles41F: Apparel Management
1978920FCW38TR53Price List Exchange RateFiles41F: Apparel Management
1979920FCW39AC41Priority Value for Category CodesFiles41F: Apparel Management
1980920FCW40TC41Price List GenerationFiles41F: Apparel Management
1981920FCW41CR261Commitment RulesFiles41F: Apparel Management
1982920FCW42TD111Price List Generation-Item ExceptionFiles41F: Apparel Management
1983920FCW43MO491Proposal Processing DetailsFiles41F: Apparel Management
1984920FCW44FP191Proposal Order DetailsFiles41F: Apparel Management
1985920FCW45OL1131Matrix Purchase Order Other LocationFiles41F: Apparel Management
1986920FCW46RT41Size Weights for ProposalsFiles41F: Apparel Management
1987920FCW48BH121Bill of Material Association HeaderFiles41F: Apparel Management
1988920FCW49BD164Bill of Material Association DetailFiles41F: Apparel Management
1989920FCW50BX732Bill of Material Association MatrixFiles41F: Apparel Management
1990920FCW51BU141BOM UsageFiles41F: Apparel Management
1991920FCW52RC111Style Routing Master FileFiles41F: Apparel Management
1992920FCW54WB41Bill of Material Work FileFiles41F: Apparel Management
1993920FCW55CM71Collection Templates HeaderFiles41F: Apparel Management
1994920FCW56MD162Collection Templates DetailFiles41F: Apparel Management
1995920FCW57WF391Work File Additional System Information (F4101)Files41F: Apparel Management
1996920FCW58WF171Item Master - Service/Warranty Extension (F4117) Work FileFiles41F: Apparel Management
1997920FCW59WF271Bulk Item Master (F41011) Work FileFiles41F: Apparel Management
1998920FCW60CM51CompositionsFiles41F: Apparel Management
1999920FCW61SI301Additional Style Item InformationFiles41F: Apparel Management
2000920FCW62WF61Compositions (FCW60) Work FileFiles41F: Apparel Management
2001920FCW63WF221Additional Style Item Information Work FileFiles41F: Apparel Management
2002920FCW64WX1491WO Receipts Matrix Entry Work FileFiles41F: Apparel Management
2003920FCW65OF1211Work Order Header for Style ItemsFiles41F: Apparel Management
2004920FCW66CR42Work Order Detail for Style ItemsFiles41F: Apparel Management
2005920FCW67WM872Style Work Order Parts ListFiles41F: Apparel Management
2006920FCW68WL821Style Work Order RoutingsFiles41F: Apparel Management
2007920FCW69WP121Work Order Parts List IssuesFiles41F: Apparel Management
2008920FCW70CB122Supplier Price/Catalog File - HeaderFiles41F: Apparel Management
2009920FCW71CB352Supplier Price/Catalog File - DetailFiles41F: Apparel Management
2010920FCW83PC161Work File F43090Files41F: Apparel Management
2011920FCW84TR53Exchange Rate for Outsource OperationsFiles41F: Apparel Management
2012920FCW85IE352Item Cost Component Add Ons Work FileFiles41F: Apparel Management
2013920FCW86WF101BOM Quantity Work FileFiles41F: Apparel Management
2014920FCW87LG111Style Item Balance Purge LogFiles41F: Apparel Management
2015920FCW88LG121Style Item Master Purge LogFiles41F: Apparel Management
2016920FCW89WM161Work Order Inventory Issues for Style ItemsFiles41F: Apparel Management
2017920FCW91C982Work File for RCW02Files41F: Apparel Management
2018920FCW93ST151Copy to Outsource Operations for Style ItemsFiles41F: Apparel Management
2019920FCW94WK32Restore Composition Work FileFiles41F: Apparel Management
2020920FCW96WO402Material AnalysisFiles41F: Apparel Management
2021920FCW961DL212Simulation Detailed Parts ListFiles41F: Apparel Management
2022920FCW962CL201Simulation Consolidated Parts ListFiles41F: Apparel Management
2023920FCW963AC141Adjustment CalculationFiles41F: Apparel Management
2024920FCW97GM392Grouping MessagesFiles41F: Apparel Management
42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2025920F03B421TH221Sales Order Trigger HierarchyFiles42: Sales Management
2026920F03B422TD81Sales Oder Trigger DateFiles42: Sales Management
2027920F03B423TC261Sales Order Trigger ConfigurationFiles42: Sales Management
2028920F4015WOD32Order Templates - Web CustomersExtra Features Files42B: Sales Order EntryBusiness Data
2029920F4020AR321Freight/Additional Charges Rate InformationConstants Files42: Sales ManagementBusiness Data
2030920F4074AL701Price Adjustment Ledger FileTransaction Files45: Advanced PricingBusiness Data
2031920F40UI16DS82Preference Print Message Work FileRegular Work Files42: Sales ManagementBusiness Data
2032920F42003RE82Related Salesperson FileExtra Features Files42: Sales ManagementBusiness Data
2033920F42004CM222Commission Constants FileExtra Features Files42: Sales ManagementBusiness Data
2034920F42005SC522Sales Commission FileExtra Features Files42: Sales ManagementBusiness Data
2035920F4201SH13310Sales Order Header FileTransaction Files42: Sales ManagementBusiness Data
2036920F42019SH1334Sales Order Header History FileHistory Files42: Sales ManagementBusiness Data
2037920F4201Z1THY101Sales Order Header Unedited Tax Transaction FileFiles42: Sales Management
2038920F420UI55UI331Kit Balance Work FileWork Files42: Sales Management
2039920F4211SD26819Sales Order Detail FileTransaction Files42: Sales Management
2040920F42119SD2689Sales Order History FileHistory Files42: Sales ManagementBusiness Data
2041920F4211Z1TDZ211Sales Order Detail Unedited Tax Transaction FileFiles42: Sales Management
2042920F42140CM222Customer Master Commission InformationFiles42: Sales ManagementBusiness Data
2043920F42150SH91Sales Order Header Commission InformationFiles42: Sales ManagementBusiness Data
2044920F4216XD194SO Pack Confirm DetailTransaction Files49: Transportation ManagementBusiness Data
2045920F42160SD111Sales Order Detail Commission InformationFiles42: Sales Management
2046920F42160ASD81Temp Table Sales Order Commission informationFiles42: Sales Management
2047920F42199SL2682S.O. Detail Ledger FileHistory Files42: Sales Management
2048920F4229SS641Sales Summary History FileExtra Features Files42: Sales ManagementBusiness Data
2049920F4239LC141Last Customer ShipmentFiles42: Sales ManagementBusiness Data
2050920F42430CS101Customer SetFiles42: Sales ManagementBusiness Data
2051920F42565IW2008Invoice Print FileRegular Work Files42: Sales ManagementBusiness Data
2052920F42800GSG461Sales Update G Batch WorkfileFiles42: Sales Management
2053920F42800G1DG1251Sales Update G Batch Detail WorkfileFiles42: Sales Management
2054920F42800TPTP21Sales Update TP Failure TableFiles42: Sales Management
2055920F4290SE191Delivery Note HistoryHistory Files42: Sales ManagementBusiness Data
2056920F42A011CA431CampaignsMaster Files42: Sales ManagementBusiness Data
2057920F42A012OP433OpportunityMaster Files42: Sales ManagementBusiness Data
2058920F42CSSCS181Customer Self Service WorkfileWork Files42B: Sales Order EntryBusiness Data
2059920F42UI005SC542Sales Commission FileExtra Features Files42: Sales ManagementBusiness Data
2060920F42UI01ZH1733SO Header Cache File (MBF)Regular Work Files42B: Sales Order EntryBusiness Data
2061920F42UI11ZD1894SO Detail Cache File (MBF)Regular Work Files42B: Sales Order Entry
2062920F42UI11CSC121Customer Self Service Shopping Cart WorkfileRegular Work Files42B: Sales Order EntryBusiness Data
2063920F42UI12ZD1553Sales Order Detail Cache 2 (MBF)Regular Work Files42B: Sales Order EntryBusiness Data
2064920F42UI130ZC632Commitment Work FileRegular Work Files42: Sales ManagementBusiness Data
2065920F42UI150ZH81Sales Order Header Commission Information Work FileWork Files42: Sales Management
2066920F42UI160ZD91Sales Order Detail Commission Information Work FileWork Files42: Sales Management
2067920F42UI520S8532Pick Slips Header FileWork Files42: Sales ManagementBusiness Data
2068920F42UI521S91404Pick Slips Detail FileWork Files42: Sales ManagementBusiness Data
2069920F42UI800SD1163Sales Detail Work File - Sales UpdateRegular Work Files42: Sales ManagementBusiness Data
2070920F47027TUZ501Tag for F47027 - EDI P.O. Acknowledgment Detail - OutboundFiles42: Sales ManagementBusiness Data
2071920F470371TUZ1052Tag for F470371- EDI shipping Notice Detail - OutboundFiles42: Sales ManagementBusiness Data
2072920F47047TUZ501Tag for F47047- EDI Invoice Detail (Sales) - OutboundFiles42: Sales ManagementBusiness Data
2073920F47107TUZ501Tag for F47107- EDI Response to RFQ Detail - OutboundFiles42: Sales ManagementBusiness Data
2074920F47147TUZ501Tag F47147 - EDI P.O. Change Acknowledgment Detail-OutboundFiles42: Sales ManagementBusiness Data
42B: Sales Order Entry
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2075920F4011ZTUZ591Batch Receiver File - Order Details TagFiles42B: Sales Order EntryBusiness Data
2076920F42019TXST91Sales Order Header History Tax TableHistory Files42B: Sales Order Entry
2077920F4201TXST91Sales Order Header Tax TableTransaction Files42B: Sales Order Entry
2078920F4201URSH271F4201 CRM User Reserved Tag FileFiles42B: Sales Order Entry
2079920F42119TXDT221Sales Order Detail History Tax TableHistory Files42B: Sales Order Entry
2080920F4211CZ1CZ223Sales Order Detail Unedited Transaction File - CRMFiles42B: Sales Order Entry
2081920F4211SWSS111Sales Order Detail Summary Work FileFiles42B: Sales Order Entry
2082920F4211TXDT221Sales Order Detail Tax TableTransaction Files42B: Sales Order Entry
2083920F4211URUR411F4211 CRM User Reserved Tag FileFiles42B: Sales Order Entry
2084920F4211URZUR433F4211Z1 CRM User Reserved Tag FileFiles42B: Sales Order Entry
2085920F42150Z1S2182Header Commission Unedited Transaction FileFiles42B: Sales Order Entry
2086920F42160Z1S3203Detail Commission Unedited Transaction FileFiles42B: Sales Order Entry
2087920F42199TXDT221SO Detail Ledger Tax TableHistory Files42B: Sales Order Entry
2088920F42216WFPB182Pending Blanket Release Work File - F42216WFFiles42B: Sales Order Entry
2089920F42420AL1152Audit Log TransactionFiles42B: Sales Order EntryBusiness Data
2090920F42420TXTA171Tax Audit Log TransactionFiles42B: Sales Order Entry
2091920F42440CS111Customer Segment ItemsFiles42B: Sales Order EntryBusiness Data
2092920F42UI440CS151Customer Segment Items - Work FileFiles42B: Sales Order EntryBusiness Data
2093920F47012TUZ851EDI Purchase Order Detail Tag - InboundFiles42B: Sales Order EntryBusiness Data
2094920F47092TUZ591EDI Request for Quote Detail Tag - InboundFiles42B: Sales Order EntryBusiness Data
2095920F47132TUZ861EDI Purchase Order Change Detail Tag - InboundFiles42B: Sales Order EntryBusiness Data
2096920F49299UD1371S.O. Detail Tag Ledger FileFiles42B: Sales Order EntryBusiness Data
2097920F90CA22BDT71Document templates tableFiles42B: Sales Order Entry
2098920F90CA24ADT81Proposal generation templatesFiles42B: Sales Order Entry
2099920F90CA24BAT161Proposal generation partsFiles42B: Sales Order Entry
2100920F90CA24CDA51Proposal generation template parts associationFiles42B: Sales Order Entry
42I: Outbound Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2101920F42I010OH291Outbound Inventory Agreement MasterFiles42I: Outbound Inventory Management
2102920F42I011OQ561Outbound Inventory Agreement DetailsFiles42I: Outbound Inventory Management
2103920F42I015OI634Outbound Inventory Agreement Transaction FileFiles42I: Outbound Inventory Management
2104920F42I02OI674Outbound Inventory Agreement AcknowledgeFiles42I: Outbound Inventory Management
2105920F42I021OQ543Outbound Inventory Item BalanceFiles42I: Outbound Inventory Management
2106920F42I03OI644Outbound Order Consumption Report FileFiles42I: Outbound Inventory Management
2107920F42I05OI241Outbound Inventory Staging LocationsFiles42I: Outbound Inventory Management
2108920F42I06OH801Outbound Inventory Agreement Master Change HistoryFiles42I: Outbound Inventory Management
2109920F42I07OQ701Outbound Inventory Agreement Details Change HistoryFiles42I: Outbound Inventory Management
2110920F42I08PR481Replenishment Quantity and Price Override TableFiles42I: Outbound Inventory Management
2111920F42I09OI481Outbound Hold and Return TransactionsFiles42I: Outbound Inventory Management
42W: Fulfilment Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2112920F4277701RH401Service Level Rule HeaderFiles42W: Fulfilment Management
2113920F4277703UI261Unfulfilled Items WorkfileFiles42W: Fulfilment Management
2114920F4277704UC141Unfulfilled CustomersFiles42W: Fulfilment Management
2115920F4277709HH401Service Level Rule Header HistoryFiles42W: Fulfilment Management
2116920F4277710FP151Fulfillment Plan IDFiles42W: Fulfilment Management
2117920F4277711RD481Service Level Rule DetailFiles42W: Fulfilment Management
2118920F4277719HD481Service Level Rule Detail HistoryFiles42W: Fulfilment Management
2119920F4277720AH131Fulfillment Rules HeaderFiles42W: Fulfilment Management
2120920F4277730AD171Fulfillment Rules DetailFiles42W: Fulfilment Management
2121920F4277750BS161Basic Fulfillment Scoring SetupFiles42W: Fulfilment Management
2122920F4277760SR442Service Level Rule SetupFiles42W: Fulfilment Management
2123920F427UI01RF572Release Fulfillment Work FileFiles42W: Fulfilment Management
2124920F427UI02ZX215Load Balance Auto Fulfillment Work FileFiles42W: Fulfilment Management
2125920F427UI03RS222Released Shipments WorkfileFiles42W: Fulfilment Management
42X: In-Memory Sales Advisor
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2126920F42X000PC221Sales Advisor ConstantsFiles42B: Sales Order Entry
2127920F42X001XA81Sales Advisor Included Document TypesFiles42B: Sales Order Entry
2128920F42X010FO113Buying Frequency by CustomerFiles42B: Sales Order Entry
2129920F42X010WUS327Line Advisor Work FileFiles42B: Sales Order Entry
2130920F42X020WXC244Order Advisor Work FileFiles42B: Sales Order Entry
2131920F42X040WGR241Order Upsell Item Group Totals Work FileFiles42B: Sales Order Entry
2132920F42X041WBR223Order Upsell Item Group Opportunities WFFiles42B: Sales Order Entry
2133920F42X050WCI334Order Level Upsell Candidate ItemsFiles42B: Sales Order Entry
2134920F42X060WDC323Supply Monitor Chart Work FileFiles42B: Sales Order Entry
2135920F42X201PS221Profitability Simulator Saved ScenariosFiles42B: Sales Order Entry
2136920F42X201BPG71Profitability Simulator Saved ChartsFiles42B: Sales Order Entry
2137920F42X201CPD71Profitability Simulator Saved DataFiles42B: Sales Order Entry
43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2138920F40910P#143Commitment Integrity Report Work FileRegular Work Files43: ProcurementBusiness Data
2139920F4095TEMML91F4095 Temporary TableConstants Files43: ProcurementBusiness Data
2140920F41061CB235Supplier Price/Catalog FileMaster Files45: Advanced PricingBusiness Data
2141920F41291IG283Item Cost ComponentsSecondary Master Files43B: Voucher Match and Landed Cost
2142920F43008AP63Approval LevelsExtra Features Files43: ProcurementBusiness Data
2143920F4301PH1276Purchase Order HeaderTransaction Files43: ProcurementBusiness Data
2144920F4301SWPS81Purchase Order Summary Work TableFiles43: Procurement
2145920F4301ZPA1425PO Header Work FileWork Files43: ProcurementBusiness Data
2146920F4301Z1SY1431Purchase Order Header Unedited Transaction TableTransaction Files43: Procurement
2147920F4303PK283Log MasterTransaction Files43: ProcurementBusiness Data
2148920F4304PC71Log Hierarchy ConstantsConstants Files43: Procurement
2149920F4305PL345Log MasterTransaction Files43: Procurement
2150920F43080PD1951Approvals Fields ConstantsTransaction Files43: ProcurementBusiness Data
2151920F43090PC525Supplier/Item RelationshipsExtra Features Files43: ProcurementBusiness Data
2152920F43091PP111Receipt Routing Master FileExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
2153920F43092PX224Purchase Order Receipt Routing FileExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
2154920F43092ZPV581Receipt Routing Work FileRegular Work Files43A: Purchase Order Receipt/RoutingBusiness Data
2155920F43092Z1SZ751Receipt Routing Unedited Transaction TableTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
2156920F43093PE101Inspection/Sample Size TableExtra Features Files43A: Purchase Order Receipt/RoutingBusiness Data
2157920F43094P581Supplier Item Additional RoutesExtra Features Files43: ProcurementBusiness Data
2158920F43099PO291Receipt Routing Ledger FileHistory Files43A: Purchase Order Receipt/RoutingBusiness Data
2159920F43100IX71Supplier and Branch Plant RelationshipFiles43: Procurement
2160920F4310XCM112CM Purchase Order Cross ReferenceFiles43: ProcurementBusiness Data
2161920F4311PD22812Purchase Order Detail FileTransaction Files43: Procurement
2162920F4311TPD192Purchase Order Detail Tag FileTransaction Files43: ProcurementBusiness Data
2163920F4311ZPW2545Purchase Order Generator FileRegular Work Files43: ProcurementBusiness Data
2164920F4311Z1SZ2371Purchase Order Detail Unedited Transaction TableTransaction Files43: Procurement
2165920F43121PR16312Purchase Order Receiver FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
2166920F43121TPR262Purchase Order Receiver Tag FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
2167920F43121TBPR102Purchase Order Receiver Tag TableTransaction Files43A: Purchase Order Receipt/Routing
2168920F43121ZPW2123Receiver workfileRegular Work Files43A: Purchase Order Receipt/RoutingBusiness Data
2169920F43121Z1SZ2031Receipts Unedited Transaction TableTransaction Files43A: Purchase Order Receipt/RoutingBusiness Data
2170920F43147FD592Freight Distribution WorkfileWork Files43B: Voucher Match and Landed Cost
2171920F4314ZPN2132Voucher Match Selection FileRegular Work Files43B: Voucher Match and Landed Cost
2172920F4316P3574Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
2173920F4316MP481Model Purchase Order Multiple Account FileFiles43: ProcurementBusiness Data
2174920F4316TP3161Purchase Order Multiple Account Tag FileFiles43: Procurement
2175920F4317PD241Purchase Order Detail Non-BillableFiles43: ProcurementBusiness Data
2176920F4318PY171Approval/Rejection ReasonsTransaction Files43: ProcurementBusiness Data
2177920F43199OL2308P.O. Detail Ledger File - Flexible VersionHistory Files43: ProcurementBusiness Data
2178920F4320PC131Purchase Order ClausesFiles43: Procurement
2179920F4322PZ141Purchasing Tolerance RulesConstants Files43: ProcurementBusiness Data
2180920F4330P0143Supplier Selection FileTransaction Files43: ProcurementBusiness Data
2181920F4331P1121Quantity Breaks FileTransaction Files43: ProcurementBusiness Data
2182920F4332P2141Multiple Requisition FileTransaction Files43: ProcurementBusiness Data
2183920F4333WFPO101Purchase Order Dispatch Work FileFiles43: Procurement
2184920F4340RD281Purchase Rebate Master FileMaster Files45: Advanced PricingBusiness Data
2185920F4341RL61Purchase Rebate Threshold FileMaster Files45: Advanced PricingBusiness Data
2186920F4342RK71Purchase Inclusion RulesMaster Files45: Advanced PricingBusiness Data
2187920F4343RH291Purchase Rebate HistoryTransaction Files45: Advanced PricingBusiness Data
2188920F4350H121Supplier Page HyperlinksExtra Features Files43: ProcurementBusiness Data
2189920F4351H231Supplier Item HyperlinksExtra Features Files43: ProcurementBusiness Data
2190920F4355PT71Subcontractor ThresholdFiles43: Procurement
2191920F43632ZOI271Open Purchase Order by Item Work FileRegular Work Files43: Procurement
2192920F4371PD351Suggested Reorder Stock ItemsFiles43: Procurement
2193920F43UI50CWC192PO Print Clauses TableFiles43: Procurement
2194920F43UI50DPW801PO Print Detail Work FileExtra Features Files43: ProcurementBusiness Data
2195920F43UI50HPA1061PO Print Header Work FileExtra Features Files43: ProcurementBusiness Data
2196920F44445ZSW81Subcontractor WaiverWork Files43: ProcurementBusiness Data
2197920F74U0140AC221ACM - Application Certificate ConstantsMaster Files43B: Voucher Match and Landed Cost
2198920F74U0141AC457ACM - Application / Certificate MasterMaster Files43B: Voucher Match and Landed Cost
2199920F74U0142DH261ACM - Application / Certificate Status HistoryHistory Files43B: Voucher Match and Landed Cost
43A: Purchase Order Receipt/Routing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2200920F43126P4585Purchase Order Receiver Multiple AccountFiles43A: Purchase Order Receipt/Routing
2201920F43126TP4203Purchase Order Receiver Multiple Account Tag FileFiles43A: Purchase Order Receipt/Routing
2202920F43127PR315Purchase Order Receiver Non-BillableFiles43A: Purchase Order Receipt/Routing
43B: Voucher Match and Landed Cost
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2203920F43146TP5111Voucher Match Multiple Account Tag FileFiles43B: Voucher Match and Landed Cost
2204920F43221RZ141Rounding RulesFiles43B: Voucher Match and Landed Cost
43C: Contracts
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2205920F43C01CH742Contract HeaderFiles43C: Contracts
2206920F43C010HP1251Contract Header ProfileFiles43C: Contracts
2207920F43C05CA201Contract Action DatesFiles43C: Contracts
2208920F43C10CB853Contract BlockFiles43C: Contracts
2209920F43C100BP1721Contract Block ProfileFiles43C: Contracts
2210920F43C11CD873Contract DetailFiles43C: Contracts
2211920F43C110DP1391Contract Harvest ProfileFiles43C: Contracts
2212920F43C20CP263Contract PayeeFiles43C: Contracts
2213920F43C30AD242Assessment DonationsFiles43C: Contracts
2214920F43C40AC153Contract Assessments DonationsFiles43C: Contracts
2215920F43C60CC152Contract ClausesFiles43C: Contracts
2216920F43C600CP141Clauses Mass UpdateFiles43C: Contracts
43E: Requisition Self Service
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2217920F43E01RH193Requisition Order HeaderFiles43E: Requisition Self Service
2218920F43E09AA441F43E09 - Approvals Activity TableFiles43E: Requisition Self Service
2219920F43E091AE111Approval Authority (Employee)Files43E: Requisition Self Service
2220920F43E092AG122Approval Authority (Employee Group/BU)Files43E: Requisition Self Service
2221920F43E093AU111Approval Authority (Business Unit)Files43E: Requisition Self Service
2222920F43E094AC71Approval Authority ConstantsFiles43E: Requisition Self Service
2223920F43E095AC122Approval Authority (Commodity/BU)Files43E: Requisition Self Service
2224920F43E11RD649Requisition DetailFiles43E: Requisition Self Service
2225920F43E121ER234eRequisition Receiver fileFiles43E: Requisition Self Service
2226920F43E15SX193Shopping Cart Cross ReferenceFiles43E: Requisition Self Service
2227920F43E16P3442Requisition Multiple Account FileFiles43E: Requisition Self ServiceBusiness Data
2228920F43E20SC381Shopping Cart DetailFiles43E: Requisition Self Service
2229920F43E20WFSW541eReq - Shopping Cart Work FileFiles43E: Requisition Self Service
2230920F43E21WFSU41Supplier Item URL Work FileFiles43E: Requisition Self Service
2231920F43E22PS331Direct Connect SetupFiles43E: Requisition Self Service
2232920F43E25EI111Direct Connect Supplier Extrinsic InformationFiles43E: Requisition Self Service
2233920F43E280DT132Delegation MasterFiles43E: Requisition Self Service
2234920F43E35CP162Direct Connect Communication Document BSSV PropertiesFiles43E: Requisition Self Service
43Q: Strategic Sourcing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2235920F43Q10EH631Event HeaderFiles43Q: Strategic SourcingBusiness Data
2236920F43Q11ED652Event DetailFiles43Q: Strategic SourcingBusiness Data
2237920F43Q15EC173Event CurrenciesFiles43Q: Strategic SourcingBusiness Data
2238920F43Q20EH381Event Header Bid QuestionsFiles43Q: Strategic SourcingBusiness Data
2239920F43Q201EH181Event Header Bid Question ListFiles43Q: Strategic SourcingBusiness Data
2240920F43Q21ED411Event Detail Bid QuestionsFiles43Q: Strategic SourcingBusiness Data
2241920F43Q211ED191Event Detail Bid Question ListFiles43Q: Strategic SourcingBusiness Data
2242920F43Q212PC181Event Detail Bid Question Price ComponentFiles43Q: Strategic SourcingBusiness Data
2243920F43Q213PB181Event Detail Price BreakFiles43Q: Strategic SourcingBusiness Data
2244920F43Q30EV232Event Invited BiddersFiles43Q: Strategic SourcingBusiness Data
2245920F43Q35PT141Event Bidder Password Temp TableFiles43Q: Strategic Sourcing
2246920F43Q40RA292Response HeaderFiles43Q: Strategic SourcingBusiness Data
2247920F43Q401RC353Response Header QuestionFiles43Q: Strategic SourcingBusiness Data
2248920F43Q402RD222Response Header Question ListFiles43Q: Strategic SourcingBusiness Data
2249920F43Q403RI191Bidder Response DeclineFiles43Q: Strategic SourcingBusiness Data
2250920F43Q404RJ192Response DisallowFiles43Q: Strategic SourcingBusiness Data
2251920F43Q405RK202Response Disallow LineFiles43Q: Strategic SourcingBusiness Data
2252920F43Q41RB313Response LineFiles43Q: Strategic SourcingBusiness Data
2253920F43Q411RE394Response Detail QuestionFiles43Q: Strategic SourcingBusiness Data
2254920F43Q412RG223Response Detail Question Price BreakFiles43Q: Strategic SourcingBusiness Data
2255920F43Q413RH223Response Detail Question Price ComponentsFiles43Q: Strategic SourcingBusiness Data
2256920F43Q414RL232Response Detail Question ListFiles43Q: Strategic SourcingBusiness Data
2257920F43Q50AV362Analyze Event HeaderFiles43Q: Strategic SourcingBusiness Data
2258920F43Q51ED423Analyze Event DetailFiles43Q: Strategic SourcingBusiness Data
2259920F43Q60BQ347Bid QuestionsFiles43Q: Strategic SourcingBusiness Data
2260920F43Q61BV172Bid Question List ValuesFiles43Q: Strategic SourcingBusiness Data
2261920F43Q62BC182Bid Question Price ComponentFiles43Q: Strategic SourcingBusiness Data
2262920F43Q90SC671Sourcing ConstantsFiles43Q: Strategic SourcingBusiness Data
2263920F43Q91BR331Bidder RegistrationFiles43Q: Strategic SourcingBusiness Data
2264920F43Q911BC142F43Q911 - Bidder Country VATFiles43Q: Strategic SourcingBusiness Data
2265920F43Q92AI212Adhoc Item DefinitionFiles43Q: Strategic SourcingBusiness Data
43S: JSSS/Supplier Self Service
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2266920F43001SA297Procurement Self-Service Transaction LogFiles43: ProcurementBusiness Data
2267920F4313PF365POFLIPFiles43S: JSSS/Supplier Self Service
2268920F4323PD181PO FLIP HeaderFiles43S: JSSS/Supplier Self Service
2269920F43S001AM51Alerts MasterFiles43S: JSSS/Supplier Self Service
2270920F43S002AC251Alerts ConfigurationFiles43S: JSSS/Supplier Self Service
44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2271920F4450JD1311Lot Proceed Header (World)Files44H: Homebuilder Management
2272920F4451JF321Lot Proceed Detail (World)Files44H: Homebuilder Management
2273920F4452JA191Plan Master (World)Files44H: Homebuilder Management
2274920F4453JB261Lot Master (World)Files44H: Homebuilder Management
2275920F4454JG81Vendor Assignment (World)Files44H: Homebuilder Management
2276920F4455JH131Vendor Assignment (Takeoffs) (World)Files44H: Homebuilder Management
2277920F4456JI1311Lot Proceed Entry (World)Files44H: Homebuilder Management
2278920F4457JJ241Takeoff File (World)Files44H: Homebuilder Management
2279920F4458JK241Takeoff (World)Files44H: Homebuilder Management
2280920F4459JL351Material Item Pricing (World)Files44H: Homebuilder Management
2281920F4461JN321Option Master (World)Files44H: Homebuilder Management
2282920F44H001HC291HomeBuilder ConstantsFiles44H: Homebuilder Management
2283920F44H0011LD171HomeBuilder Constants Lot Start DocumentsFiles44H: Homebuilder Management
2284920F44H002AR251HomeBuilder Activity RulesFiles44H: Homebuilder Management
2285920F44H0920ST191Extended Homebuilder Data TemplateFiles44H: Homebuilder Management
2286920F44H0921EH181Extended Homebuilder Data HeadingsFiles44H: Homebuilder Management
2287920F44H0929ED432Extended Homebuilder DataFiles44H: Homebuilder Management
2288920F44H092HEH171Extended Homebuilder Data HeadingsFiles44H: Homebuilder Management
2289920F44H092TST161Extended Homebuilder Data TemplateFiles44H: Homebuilder Management
2290920F44H101CM1081Community Phase MasterFiles44H: Homebuilder Management
2291920F44H101ZSZ1212HB Community Master Unedited Transaction FileFiles44H: Homebuilder Management
2292920F44H201LM1252Lot MasterFiles44H: Homebuilder Management
2293920F44H201HLM1261Lot Master HistoryFiles44H: Homebuilder Management
2294920F44H201ZSZ1384HB Lot Master Unedited Transaction FileFiles44H: Homebuilder Management
2295920F44H301PM822Plan MasterFiles44H: Homebuilder Management
2296920F44H401OC833Option MasterFiles44H: Homebuilder Management
2297920F44H4011OC781Option by CommunityFiles44H: Homebuilder Management
2298920F44H401WOW891Option Master Work FileFiles44H: Homebuilder Management
2299920F44H402PK372Option RelationshipsFiles44H: Homebuilder Management
2300920F44H403OP211Option PreferencesFiles44H: Homebuilder Management
2301920F44H4031OV221Option Preferences - Valid ValuesFiles44H: Homebuilder Management
2302920F44H4101HI231Item Master HomeBuilder ExtensionFiles44H: Homebuilder Management
2303920F44H501SM1741Sales Master TableFiles44H: Homebuilder Management
2304920F44H501HLS1841Lot Sales HistoryFiles44H: Homebuilder Management
2305920F44H501SSS1031Sales Statistics HistoryFiles44H: Homebuilder Management
2306920F44H501WSS821Sales Statistics Work TableFiles44H: Homebuilder Management
2307920F44H501ZSZ1872HB Sales Master Unedited Transaction FileFiles44H: Homebuilder Management
2308920F44H511OS416Option SelectionsFiles44H: Homebuilder Management
2309920F44H511HOH431Option Selection HistoryFiles44H: Homebuilder Management
2310920F44H512PS191Option Preference SelectionsFiles44H: Homebuilder Management
2311920F44H590CI262Closing Worksheet Accounting InstructionsFiles44H: Homebuilder Management
2312920F44H591CW292Closing Worksheet EntriesFiles44H: Homebuilder Management
2313920F44H592EM182Closing Worksheet Extended Data MappingFiles44H: Homebuilder Management
2314920F44H599CM153Closing Worksheet Data MappingFiles44H: Homebuilder Management
2315920F44H601BH581Bid HeaderFiles44H: Homebuilder Management
2316920F44H602TO363Takeoff Master FileFiles44H: Homebuilder Management
2317920F44H602HTH372Takeoff History FileFiles44H: Homebuilder Management
2318920F44H602WTS252Take Off Summary WorkfileWork Files44H: Homebuilder Management
2319920F44H603MP523Material Item PricingFiles44H: Homebuilder Management
2320920F44H604VA333Vendor AssignmentFiles44H: Homebuilder Management
2321920F44H604WVW342Vendor Assignment WorkfileFiles44H: Homebuilder Management
2322920F44H604ZSZ462HB Vendor Assignment Unedited Transaction FileFiles44H: Homebuilder Management
2323920F44H611BD897Bid DetailsFiles44H: Homebuilder Management
2324920F44H611WBW933Bid Details Work FileFiles44H: Homebuilder Management
2325920F44H711SW10615Lot Start WorkfileFiles44H: Homebuilder Management
2326920F44H711PTP593After Start PurchasingFiles44H: Homebuilder Management
2327920F44H711ZSZ1182HB Lot Start Unedited Transaction FileFiles44H: Homebuilder Management
2328920F44H712ST241Lot Start Workfile Takeoff DetailFiles44H: Homebuilder Management
2329920F44H71W1GW1052Lot Start Generation WorkfileFiles44H: Homebuilder Management
2330920F44H73W1CG846Lot Start - P.O. / Committment Generation Work FileWork Files44H: Homebuilder Management
2331920F44H73W2BG142Lot Start - Budget Generation WorkfileWork Files44H: Homebuilder Management
2332920F44H790HM463Construction MilestonesFiles44H: Homebuilder Management
2333920F44H902WWF31Budget Creation WorkfileFiles44H: Homebuilder Management
2334920F44H9905MH11HomeBuilder Integrated AddressesFiles44H: Homebuilder Management
2335920F44H9911MS31Milestone Status RulesFiles44H: Homebuilder Management
45: Advanced Pricing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2336920F4070SN228Price Adjustment ScheduleMaster Files45: Advanced PricingBusiness Data
2337920F4070PSN238Price Adjustment Schedule PurgeMaster Files45: Advanced PricingBusiness Data
2338920F4071AT622Price Adjustment TypeMaster Files45: Advanced PricingBusiness Data
2339920F4071PAT632Price Adjustment Type PurgeMaster Files45: Advanced PricingBusiness Data
2340920F4072AD377Price Adjustment DetailMaster Files45: Advanced PricingBusiness Data
2341920F4072PAD387Price Adjustment Detail PurgeMaster Files45: Advanced PricingBusiness Data
2342920F4072WAD402Price Adjustment Detail Work FileMaster Files45: Advanced PricingBusiness Data
2343920F4073FG233Free Goods Master FileMaster Files45: Advanced PricingBusiness Data
2344920F4073PFG243Free Goods Master File PurgeMaster Files45: Advanced PricingBusiness Data
2345920F4075VB123Price Variable TableMaster Files45: Advanced PricingBusiness Data
2346920F4076FM83Price Formula MasterMaster Files45: Advanced PricingBusiness Data
2347920F4077RT315Rebate ThresholdsMaster Files45: Advanced PricingBusiness Data
2348920F4077PRT325Rebate Thresholds PurgeMaster Files45: Advanced PricingBusiness Data
2349920F4078RH332Rebate Transaction SummaryTransaction Files45: Advanced PricingBusiness Data
2350920F4079SV365Rebate Transaction DetailTransaction Files45: Advanced PricingBusiness Data
2351920F4094TEMTC133ICID Conversion X-RefFiles45: Advanced PricingBusiness Data
2352920F40UI84XR71Orders Affected by Price Change (Work-file)Work Files45: Advanced PricingBusiness Data
2353920F4501MS142Master Schedule AdjustmentMaster Files45: Advanced PricingBusiness Data
2354920F4502FG131Free Goods CatalogFiles45: Advanced PricingBusiness Data
2355920F4510PW166Price Workbench Query HeaderFiles45: Advanced Pricing
2356920F4511WAP996Pricing Structure ViewFiles45: Advanced PricingBusiness Data
2357920F4550BH131Basket Master HeaderFiles45: Advanced PricingBusiness Data
2358920F4551BD182Basket Master DetailFiles45: Advanced PricingBusiness Data
2359920F45510SH121Search Agent Directives HeaderFiles45: Advanced PricingBusiness Data
2360920F45511SD121Search Agent Directives DetailFiles45: Advanced PricingBusiness Data
2361920F45511WSW111Search Agent Directives Work FileFiles45: Advanced PricingBusiness Data
2362920F45520PH291Price List HeaderFiles45: Advanced PricingBusiness Data
2363920F45520TXPT111Price List Header Tax TableFiles45: Advanced Pricing
2364920F45521PD292Price List DetailFiles45: Advanced PricingBusiness Data
2365920F45521TXLT101Price List Detail Tax TableFiles45: Advanced Pricing
2366920F45522PL102Price List Level-Break PatternFiles45: Advanced PricingBusiness Data
2367920F45523PC93Price List Columns Group PatternFiles45: Advanced PricingBusiness Data
2368920F45524PI102Price List Item SelectionFiles45: Advanced PricingBusiness Data
2369920F45715AB452Adjustment BalancesBalance Files45: Advanced PricingBusiness Data
2370920F4572XR304Live Promotions X-Reference by Cost TypeFiles45: Advanced PricingBusiness Data
2371920F4572Z1LP501Live Promotions Interface - Inbound / OutboundFiles45: Advanced PricingBusiness Data
2372920F4572ZPPG501Purge Live Promotions InterfaceFiles45: Advanced PricingBusiness Data
2373920F4573RF111Free Goods Reference FileTransaction Files45: Advanced PricingBusiness Data
2374920F4574KR978Key Reference TableTransaction Files45: Advanced PricingBusiness Data
2375920F4575AH831Ship and Debit HistoryTransaction Files45: Advanced PricingBusiness Data
2376920F4575TMPAH851Ship and Debit History - Temp TableTransaction Files42: Sales ManagementBusiness Data
2377920F4576AC881Ship and Debit ClaimsMaster Files45: Advanced PricingBusiness Data
2378920F4576TMPAC881Ship and Debit Claims- Temp TableMaster Files42: Sales ManagementBusiness Data
2379920F4576Z1Z11581Ship and Debit Claims Unedited Transaction TableTransaction Files45: Advanced PricingBusiness Data
2380920F4580MX112Price Matrix DefinitionFiles45: Advanced Pricing
46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2381920F4142CT402Warehouse Count TransactionsExtra Features Files46: Warehouse ManagementBusiness Data
2382920F4600R19915Warehouse RequestsTransaction Files46: Warehouse ManagementBusiness Data
2383920F4600PUR1951Warehouse Requests - PurgedPurge Files46: Warehouse ManagementBusiness Data
2384920F4600T1R1231Warehouse Request Tag tableFiles46: Warehouse Management
2385920F4600TP1R1231Warehouse Request Tag File - PurgedFiles46: Warehouse Management
2386920F4601TH171Warehouse Task HeaderTransaction Files46: Warehouse ManagementBusiness Data
2387920F46011IQ353Item Unit Of Measure DefinitionSecondary Master Files46: Warehouse ManagementBusiness Data
2388920F46012IS131Fixed LocationsExtra Features Files46: Warehouse ManagementBusiness Data
2389920F46013EQ101Carton Recommendation RulesExtra Features Files46: Warehouse ManagementBusiness Data
2390920F460131SP265Standard Pack Recommendation RulesFiles46: Warehouse ManagementBusiness Data
2391920F46014RG132Replenishment GroupsMaster Files46: Warehouse ManagementBusiness Data
2392920F46015RR222Replenishment Information by Random RuleMaster Files46: Warehouse ManagementBusiness Data
2393920F460151MS72Mixed Sequenced Packing GroupsFiles46: Warehouse Management
2394920F4601PUTH201Warehouse Task Header - PurgedPurge Files46: Warehouse ManagementBusiness Data
2395920F4602IF9017Location Detail InformationBalance Files46: Warehouse ManagementBusiness Data
2396920F46021LQ71Location CharacteristicsExtra Features Files46: Warehouse ManagementBusiness Data
2397920F46022LT191Location DimensionsMaster Files46: Warehouse ManagementBusiness Data
2398920F46024LC101Location CapacityExtra Features Files46: Warehouse ManagementBusiness Data
2399920F46025MQ81Maximum Putaway Quantity by ZoneExtra Features Files46: Warehouse ManagementBusiness Data
2400920F46026AC62Allowed Containers by LocationExtra Features Files46: Warehouse ManagementBusiness Data
2401920F46027AV175Available Space TiebreakerBalance Files46: Warehouse ManagementBusiness Data
2402920F46029LP163Proximity TiebreakerBalance Files46: Warehouse ManagementBusiness Data
2403920F46051LY81Fixed Replenisment ZonesExtra Features Files46: Warehouse ManagementBusiness Data
2404920F46091ID332Container and Carton CodesMaster Files46: Warehouse ManagementBusiness Data
2405920F46092OZ62Order GroupsConstants Files46: Warehouse ManagementBusiness Data
2406920F46093EM171Process Selection RulesConstants Files46: Warehouse ManagementBusiness Data
2407920F46093TJC171Process Group Tag TableFiles46: Warehouse Management
2408920F46095ET321Movement InstructionsConstants Files46: Warehouse ManagementBusiness Data
2409920F46095TTD201Movement Instructions Tag TableFiles46: Warehouse Management
2410920F46096OU62Unit Of Measure GroupsConstants Files46: Warehouse ManagementBusiness Data
2411920F46098CB193Container Bill of MaterialFiles46: Warehouse Management
2412920F4611R215914Warehouse SuggestionsTransaction Files46: Warehouse ManagementBusiness Data
2413920F4611PUR21581Warehouse Suggestions - PurgedPurge Files46: Warehouse ManagementBusiness Data
2414920F4611T1R2332Warehouse Suggestions Tag FileFiles46: Warehouse Management
2415920F4611TP1R2332Warehouse Suggestions Tag File - PurgedFiles46: Warehouse Management
2416920F4611Z1SZ1661Unedited Suggestion TableTransaction Files46: Warehouse ManagementBusiness Data
2417920F46130R3875Putaway ReservationsTransaction Files46: Warehouse ManagementBusiness Data
2418920F46130PUR3901Putaway Reservations - PurgedPurge Files46: Warehouse ManagementBusiness Data
2419920F4615CR386Carton RecommendationsFiles46: Warehouse ManagementBusiness Data
2420920F4620CD658Carton Detail InformationFiles46: Warehouse Management
2421920F46200BR354Bulk Pick RequestsWork Files46: Warehouse ManagementBusiness Data
2422920F46200PUBR371Bulk Pick Requests - PurgedPurge Files46: Warehouse ManagementBusiness Data
2423920F46201CC121Carton Charge Reference SetupFiles46: Warehouse Management
2424920F4622UL181Unusable Label NumbersFiles46: Warehouse Management
2425920F4625LN151Label Next NumbersFiles46: Warehouse Management
2426920F46821LX73Random LocationsExtra Features Files46: Warehouse ManagementBusiness Data
2427920F46822RQ113Random TablesExtra Features Files46: Warehouse ManagementBusiness Data
2428920F46UI15RC396Carton Recommendations - Work FileFiles46: Warehouse ManagementBusiness Data
2429920F4942Z1SY522Work File for F4942Transaction Files46: Warehouse ManagementBusiness Data
46L: License Plating
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2430920F46L001CL161License Plate Numbering ConstantsConstants Files46L: License Plating
2431920F46L010LS222License Plate SegmentsFiles46L: License Plating
2432920F46L011LN181License Plate Next NumbersFiles46L: License Plating
2433920F46L060SI182LPN Supplier Inbound ASN LevelsFiles46L: License Plating
2434920F46L070SC171LPN Supplier Cross ReferenceFiles46L: License Plating
2435920F46L10LM354License Plate MasterFiles46L: License Plating
2436920F46L11ID264License Plate Item DetailFiles46L: License Plating
2437920F46L12LC308License Plate CommitmentFiles46L: License Plating
2438920F46L20LC172LP Cross-ReferenceFiles46L: License Plating
2439920F46L30LC191Location CapacityFiles46L: License Plating
2440920F46L42CC271License Plate Cycle and Tag CountFiles46L: License Plating
2441920F46L99LM692License Plate HistoryFiles46L: License Plating
2442920F46LUI01WF463Assign/Remove Items To LP Work FileFiles46L: License Plating
2443920F46LUI02LP61Work Table for Manual Build UOM StructureFiles46L: License Plating
2444920F46LUI03WF123Assign/Remove Child LP Work FileFiles46L: License Plating
46R: RFID Outbound
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2445920F46R010SD172EPC Segment DefinitionFiles46R: RFID Outbound
2446920F46R020EM174EPC Manager MasterFiles46R: RFID Outbound
2447920F46R030ES141EPC Serial NumberFiles46R: RFID Outbound
2448920F46R050EH141EPC HeaderFiles46R: RFID Outbound
2449920F46R060EP162EPC Partition DefinitionFiles46R: RFID Outbound
2450920F46R070EC141EPC Company Length DefinitionFiles46R: RFID Outbound
47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2451920F0101GGL182Global location number for address bookFiles47: Electronic Commerce
2452920F47002SV51Flat File Cross-Reference TableConstants Files47: Electronic CommerceBusiness Data
2453920F47003SX181EDI Discrepancy Report Work FileRegular Work Files47: Electronic CommerceBusiness Data
2454920F47006ST251EDI Order Header - Outbound Tax TableFiles42: Sales Management
2455920F47007DT331EDI Order Detail - Outbound Tax TableFiles42: Sales Management
2456920F47011SY2111EDI Purchase Order Header - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2457920F4701150PH91EDI Purchase Order Header Commission InboundFiles42B: Sales Order Entry
2458920F47011TXST241EDI Purchase Order Header Tax - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2459920F47012SZ2671EDI Purchase Order Detail - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2460920F4701260PD111EDI Purchase Order Detail Commission InboundFiles42B: Sales Order Entry
2461920F47012TXDT301EDI Purchase Order Detail Tax - InboundBatch Input Files42B: Sales Order Entry
2462920F47013SP571EDI Purchase Order Detail (SDQ) - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2463920F47016SY1521EDI Purchase Order Header - OutboundBatch Input Files43: ProcurementBusiness Data
2464920F470161S3771EDI Purchase Order Additional Header - OutboundBatch Input Files43: ProcurementBusiness Data
2465920F47017SZ2341EDI Purchase Order Detail - OutboundBatch Input Files43: ProcurementBusiness Data
2466920F470171S4581EDI Purchase Order Additional Detail - OutboundBatch Input Files43: ProcurementBusiness Data
2467920F47021SY1161EDI P.O. Acknowledgment Header - InboundBatch Input Files43: ProcurementBusiness Data
2468920F47022SZ2261EDI P.O. Acknowledgment Detail - InboundBatch Input Files43: ProcurementBusiness Data
2469920F47026SY1531EDI P.O. Acknowledgment Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
2470920F47027SZ2571EDI P.O. Acknowledgment Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
2471920F47031SY1101EDI Shipping Notice Header - InboundBatch Input Files43A: Purchase Order Receipt/RoutingBusiness Data
2472920F47032SZ1821EDI Shipping Notice Detail - InboundBatch Input Files43A: Purchase Order Receipt/RoutingBusiness Data
2473920F47032TSZ311EDI Shipping Notice Detail- Inbound TagBatch Input Files43A: Purchase Order Receipt/RoutingBusiness Data
2474920F47036SY862EDI Shipping Notice Header - OutboundBatch Input Files49: Transportation ManagementBusiness Data
2475920F47036XST201EDI Shipping Notice Header Tax - OutboundBatch Input Files49: Transportation Management
2476920F47037SZ2171EDI Shipping Notice Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
2477920F470371SZ2584EDI Shipping Notice Detail - OutboundBatch Input Files49: Transportation ManagementBusiness Data
2478920F470371XDT341EDI Shipping Notice Detail Tax - OutboundBatch Input Files49: Transportation Management
2479920F470372AI793EDI ASN Demand Scheduling DetailFiles47: Electronic Commerce
2480920F470373AG662EDI ASN ShippingFiles47: Electronic Commerce
2481920F470374AM391EDI ASN Demand AddressesFiles47: Electronic Commerce
2482920F470375AK471EDI ASN Packaging DetailFiles47: Electronic Commerce
2483920F47041SY691EDI Invoice Header - InboundBatch Input Files43: ProcurementBusiness Data
2484920F47042SZ1101EDI Invoice Detail - InboundBatch Input Files43: ProcurementBusiness Data
2485920F47044SW561EDI Invoice Summary - InboundBatch Input Files43: ProcurementBusiness Data
2486920F47046SY1583EDI Invoice Header (Sales) - OutboundBatch Input Files42: Sales Management
2487920F470461S3672EDI Invoice Additional Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
2488920F470462S5561EDI Invoice Expanded Header (Sales)Files42: Sales Management
2489920F47047SZ2602EDI Invoice Detail (Sales) - OutboundBatch Input Files42: Sales Management
2490920F470471S4501EDI Invoice Additional Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
2491920F470472S6851EDI Invoice Expanded Detail (Sales)Files42: Sales Management
2492920F470473S7511EDI Invoice Detail ChargesFiles42: Sales Management
2493920F47056D1701EDI Payment Order Header - OutboundBatch Input Files04: Accounts PayableBusiness Data
2494920F470561D2441EDI Payment Order Bank N & A - OutboundBatch Input Files04: Accounts PayableBusiness Data
2495920F470561WD2441EDI Payment Order Bank N & A - WorkRegular Work Files04: Accounts PayableBusiness Data
2496920F470562D4441EDI Payment Order Vendor N & A - OutboundBatch Input Files04: Accounts PayableBusiness Data
2497920F470562WD4441EDI Payment Order Vendor N & A - WorkRegular Work Files04: Accounts PayableBusiness Data
2498920F470563D5441EDI Payment Order Payee N & A - OutboundBatch Input Files04: Accounts PayableBusiness Data
2499920F470563WD5441EDI Payment Order Payee N & A - WorkRegular Work Files04: Accounts PayableBusiness Data
2500920F47056WD1701EDI Payment Order Header - WorkRegular Work Files04: Accounts PayableBusiness Data
2501920F47057D31211EDI Payment Order Remittance Advice - OutboundBatch Input Files04: Accounts PayableBusiness Data
2502920F47057WD31211EDI Payment Order Remittance Advice - WorkRegular Work Files04: Accounts PayableBusiness Data
2503920F4706ZA342EDI Order Address InformationTransaction Files47: Electronic CommerceBusiness Data
2504920F47061MJ421EDI Planning Schedule Header - InboundBatch Input Files34: Requirements PlanningBusiness Data
2505920F47062MY381EDI Planning Schedule Detail - InboundBatch Input Files34: Requirements PlanningBusiness Data
2506920F47066MJ421EDI Planning Schedule Header - OutboundBatch Input Files34: Requirements PlanningBusiness Data
2507920F47067MY381EDI Planning Schedule Detail - OutboundBatch Input Files34: Requirements PlanningBusiness Data
2508920F47071SY1161EDI Receiving Advice Header - InboundBatch Input Files43: ProcurementBusiness Data
2509920F47072SZ2591EDI Receiving Advice Detail - InboundBatch Input Files43: ProcurementBusiness Data
2510920F47076SY1141EDI Receiving Advice Header - OutboundBatch Input Files43: ProcurementBusiness Data
2511920F47077SZ2451EDI Receiving Advice Detail - OutboundBatch Input Files43: ProcurementBusiness Data
2512920F47081FV421EDI Price Sales Catalog Header - InboundBatch Input Files43: ProcurementBusiness Data
2513920F47082FY871EDI Price Sales Catalog Detail - InboundBatch Input Files43: ProcurementBusiness Data
2514920F47091SY1501EDI Request for Quote Header - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2515920F4709150QH91EDI Request for Quote Header Commission - InboundFiles42B: Sales Order Entry
2516920F47091TXST241EDI Request for Quote Header Tax - InboundBatch Input Files42B: Sales Order Entry
2517920F47092SZ2581EDI Request for Quote Detail - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2518920F4709260QD111EDI Request for Quote Detail Commission - InboundFiles42B: Sales Order Entry
2519920F47093SP571EDI Request for Quote Detail (SDQ) - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2520920F47096SY1131EDI Request for Quote Header - OutboundBatch Input Files43: ProcurementBusiness Data
2521920F47097SZ2251EDI Request for Quote Detail - OutboundBatch Input Files43: ProcurementBusiness Data
2522920F47098SZ231EDI RFQ Detail Quantity - OutboundBatch Input Files43: ProcurementBusiness Data
2523920F47101SY1111EDI Response to RFQ Header - InboundBatch Input Files43: ProcurementBusiness Data
2524920F47102SZ2211EDI Response to RFQ Detail - InboundBatch Input Files43: ProcurementBusiness Data
2525920F47103SZ221EDI Response to RFQ Detail Quantity - InboundBatch Input Files43: ProcurementBusiness Data
2526920F47106SY1511EDI Response to RFQ Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
2527920F471061S3671EDI Response to RFQ Additional Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
2528920F47107SZ2571EDI Response to RFQ Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
2529920F471071S4501EDI Response to RFQ Additional Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
2530920F47111Z1262EDI Lockbox/Payment Header - TransactionBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
2531920F47112Z2371EDI Lockbox Header - TransactionBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
2532920F47113Z3401EDI Lockbox/Payment Detail - BatchBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
2533920F47114Z4451EDI Lockbox/Payment Detail - PaymentBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
2534920F47121M1311EDI Product Activity Data Header - InboundBatch Input Files41: Inventory ManagementBusiness Data
2535920F47122MJ901EDI Product Activity Data Detail - InboundBatch Input Files41: Inventory ManagementBusiness Data
2536920F47123MK571EDI Product Activity Data (SDQ) - InboundBatch Input Files41: Inventory ManagementBusiness Data
2537920F47126M1311EDI Product Activity Data Header - OutboundBatch Input Files41: Inventory ManagementBusiness Data
2538920F47127MJ891EDI Product Activity Data Detail - OutboundBatch Input Files41: Inventory ManagementBusiness Data
2539920F47128MK571EDI Product Activity Data (SDQ) - OutboundBatch Input Files41: Inventory ManagementBusiness Data
2540920F47131SY1731EDI Purchase Order Change Header - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2541920F4713150CH91EDI Purchase Order Change Header Commission - InboundFiles42B: Sales Order Entry
2542920F47131TXST241EDI Purchase Order Change Header Tax - InboundBatch Input Files42B: Sales Order Entry
2543920F47132SZ2591EDI Purchase Order Change Detail - InboundBatch Input Files42B: Sales Order EntryBusiness Data
2544920F4713260PD111EDI Purchase Order Change Detail Commission - InboundFiles42B: Sales Order Entry
2545920F47132TXDT301EDI Purchase Order Change Detail Tax - InboundBatch Input Files42B: Sales Order Entry
2546920F47136SY1161EDI Purchase Order Change Header - OutboundBatch Input Files43: ProcurementBusiness Data
2547920F47137SZ1921EDI Purchase Order Change Detail - OutboundBatch Input Files43: ProcurementBusiness Data
2548920F4714ZT221EDI Order Text Lines - HeaderExtra Features Files47: Electronic CommerceBusiness Data
2549920F47141SY1161EDI P.O. Change Acknowledgment Header - InboundBatch Input Files43: ProcurementBusiness Data
2550920F471411SZ151Purchase Order Edit Object Log TableBatch Input Files43: ProcurementBusiness Data
2551920F47142SZ2281EDI P.O. Change Acknowledgment Detail - InboundBatch Input Files43: ProcurementBusiness Data
2552920F47146SY1511EDI P.O. Change Acknowledgment Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
2553920F47147SZ2591EDI P.O. Change Acknowledgment Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
2554920F4715ZD221EDI Order Text Lines - DetailExtra Features Files47: Electronic CommerceBusiness Data
2555920F47156SY1083EDI Shipping Schedule Header - OutboundTransaction Files31: Shop Floor ControlBusiness Data
2556920F47157SZ2222EDI Shipping Schedule Detail - OutboundTransaction Files31: Shop Floor ControlBusiness Data
2557920F4716SZ301EDI Item Text - Inbound/OutboundBatch Input Files43: ProcurementBusiness Data
2558920F47181EH281EDI Consumption Header (FUTURE)Files41: Inventory Management
2559920F47182ED371EDI Consumption Detail (FUTURE)Files41: Inventory Management
2560920F47191AH581EDI Acknowledgement HeaderFiles47: Electronic Commerce
2561920F47192AE271EDI Acknowledgement Error DetailFiles47: Electronic CommerceBusiness Data
2562920F47194AR201EDI Acknowledgement ReferencesFiles47: Electronic CommerceBusiness Data
2563920F47196AA221EDI Acknowledgement Name And AddressFiles47: Electronic CommerceBusiness Data
2564920F47198AN201EDI Acknowledgement NotesFiles47: Electronic CommerceBusiness Data
2565920F4722PZ121EDI Tolerance RulesConstants Files47: Electronic CommerceBusiness Data
2566920F4780AX231Address Cross-ReferenceExtra Features Files45: Advanced PricingBusiness Data
2567920F47CTLZ5291EDI Lockbox/Payment Work FileWork Files03B: Enhanced Accounts ReceivableBusiness Data
2568920F47HLHL181Hierarchical ConfigurationSecondary Master Files49: Transportation ManagementBusiness Data
2569920F47UI001SZ601ASN Extract Work FileBatch Input Files42: Sales ManagementBusiness Data
48: Work Order Processing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2570920F48001WE51Work Order Default Coding FileConstants Files48: Work Order ProcessingBusiness Data
2571920F48002WF141Work Order Record Types FileConstants Files48: Work Order ProcessingBusiness Data
2572920F4801WA12832Work Order Master FileMaster Files48: Work Order ProcessingBusiness Data
2573920F4801SWA1281Purge - Work Order Master filePurge Files31: Shop Floor ControlBusiness Data
2574920F4801STWA1251Purge - Work Order Master Tag FilePurge Files31: Shop Floor ControlBusiness Data
2575920F4801TWA1276Work Order Master Tag FileMaster Files48: Work Order ProcessingBusiness Data
2576920F4801Z1SY2252Outbound Work Order HeaderTransaction Files31: Shop Floor ControlBusiness Data
2577920F4802WB103Work Order Instructions FileTransaction Files13: Plant/Equipment ManagementBusiness Data
2578920F4802HWC91Work Order Instructions File HeaderFiles48: Work Order ProcessingBusiness Data
2579920F4808CA91Order Routing Approval MasterMaster Files30: Product Data ManagementBusiness Data
2580920F48090W7191WO Supplemental Data TypesConstants Files48: Work Order ProcessingBusiness Data
2581920F48092W8162WO Supplemental DB User DefinedHistory Files48: Work Order ProcessingBusiness Data
2582920F4817SR653Service Order ExtensionSecondary Master Files17: Customer Service ManagementBusiness Data
2583920F4818CB113Order Approval AuditMaster Files30: Product Data ManagementBusiness Data
2584920F4826GE221W.O. Status Action TableConstants Files13: Plant/Equipment ManagementBusiness Data
2585920F4827W5131Work Order Approval RoutingConstants Files13: Plant/Equipment ManagementBusiness Data
2586920F48710WT1202Work Order Mass Update Template TableFiles48: Work Order Processing
2587920F48714WMU91Work Order Mass Update WorkfileFiles48: Work Order Processing
2588920F48UI001WA1371X4801 Master Business Function WorkfileRegular Work Files48: Work Order ProcessingBusiness Data
48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2589920F48011WG296Service Billing Batch ControlBatch Input Files48S: Service BillingBusiness Data
2590920F4805WK71Invoice Sequence/Summarization Table HeaderExtra Features Files48S: Service BillingBusiness Data
2591920F48051WK102Invoice Sequence/Summarization Table DetailExtra Features Files48S: Service BillingBusiness Data
2592920F48091WZ421Billing System ConstantsConstants Files48S: Service BillingBusiness Data
2593920F48091CCE61Independent Revenue/Invoice Company ExceptionConstants Files48S: Service Billing
2594920F48096WQ3710Billing Rate / Mark up TableExtra Features Files48S: Service BillingBusiness Data
2595920F4812WD20328Billing Detail WorkfileTransaction Files48S: Service BillingBusiness Data
2596920F48121WY151Generation Control File - Service BillingExtra Features Files48S: Service BillingBusiness Data
2597920F48127WO205Tax Derivation InformationExtra Features Files48S: Service BillingBusiness Data
2598920F48128WI131G/L Offset and Retainage InformationExtra Features Files48S: Service BillingBusiness Data
2599920F4812HWD20322Billing Workfile HistoryHistory Files48S: Service BillingBusiness Data
2600920F4812HSWD20320Billing Workfile History Purged SaveHistory Files48S: Service BillingBusiness Data
2601920F4822W411213Invoice Summary Work FileTransaction Files48S: Service Billing
2602920F48221WH192Service Billing Retention Release Cross Reference FileTransaction Files48S: Service BillingBusiness Data
2603920F48229W8161Delete Invoices Audit TableHistory Files48S: Service BillingBusiness Data
2604920F4823W0757Voucher SummaryTransaction Files48S: Service BillingBusiness Data
2605920F48423SD81Service Billing Trigger DateFiles48S: Service Billing
2606920F48424ST151Service Billing Trigger HierarchyFiles48S: Service Billing
2607920F48426ST221Service Billing Trigger ConfigurationFiles48S: Service Billing
2608920F4848SQ31Sequence/Summarization Data Item TableExtra Features Files48S: Service BillingBusiness Data
2609920F48520AE2310Invoice Summary AccessFiles48S: Service BillingBusiness Data
2610920F4858F792Layout Cross Reference TableExtra Features Files48S: Service BillingBusiness Data
2611920F4860AF102Component Table MasterExtra Features Files48S: Service BillingBusiness Data
2612920F4861AF134Component Table DetailExtra Features Files48S: Service BillingBusiness Data
2613920F4862AF53Component Cross ReferenceExtra Features Files48S: Service BillingBusiness Data
2614920F48S001WL71Draft and Final Invoice DocumentSecondary Master Files48S: Service BillingBusiness Data
2615920F48S002WM61Draft and Final Cross Reference Work FileSecondary Master Files48S: Service BillingBusiness Data
2616920F48S0618YT14725Payroll Reclassification WorkfileRegular Work Files48S: Service BillingBusiness Data
2617920F48S411BZ233CSB Pay When Paid TableFiles48S: Service Billing
2618920F48S58F7154Invoice Print Version Cross Reference TableExtra Features Files48S: Service BillingBusiness Data
2619920F48S910W2884Billing Detail Journal WorkfileWork Files48S: Service BillingBusiness Data
2620920F48S911W3524Summarized Journal WorkfileWork Files48S: Service BillingBusiness Data
2621920F48S912W6313G/L LinkFiles48S: Service Billing
2622920F48S95WV336Billing AAI InformationMaster Files48S: Service BillingBusiness Data
2623920F48SUI01WD1992Billing Detail Print WorkfileWork Files48S: Service BillingBusiness Data
2624920F48SUI02WD31Load domestic currency code - Billing SystemWork Files48S: Service BillingBusiness Data
49: Transportation Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2625920F47092TXDT301EDI Request for Quote Detail Tax - InboundBatch Input Files42B: Sales Order Entry
2626920F47500WFSZ91Inbound Transaction Processor WorkfileFiles49: Transportation Management
2627920F49002TX351Transportation ConstantsConstants Files49: Transportation ManagementBusiness Data
2628920F49003LT281Load Type ConstantsConstants Files49: Transportation ManagementBusiness Data
2629920F49004CT231Mode of Transport ConstantsConstants Files49: Transportation ManagementBusiness Data
2630920F49005TG151Generate Tracking NumberConstants Files49: Transportation ManagementBusiness Data
2631920F490051XG231Generate Tracking Number SegmentConstants Files49: Transportation ManagementBusiness Data
2632920F490052YG181Generate Tracking Segment Next NumberConstants Files49: Transportation ManagementBusiness Data
2633920F490053ZG164Generate Tracking Number SeparatorConstants Files49: Transportation ManagementBusiness Data
2634920F49010VM451Vehicle Master (Conversion from World File)Master Files49: Transportation ManagementBusiness Data
2635920F49012VO131Vehicle Compartments (Conversion from World File)Secondary Master Files49: Transportation ManagementBusiness Data
2636920F49015ST92Vehicle StatusSecondary Master Files49: Transportation ManagementBusiness Data
2637920F4902TV171Vehicle Current LoadBalance Files49: Transportation ManagementBusiness Data
2638920F49020VL212Vehicle/Staff License InformationSecondary Master Files49: Transportation ManagementBusiness Data
2639920F49025CV181Connected Vehicles (Conversion from World File)Secondary Master Files49: Transportation ManagementBusiness Data
2640920F49030VE101Vehicle Equipment (Conversion from World File)Secondary Master Files49: Transportation ManagementBusiness Data
2641920F49040VS121Vehicle Staff (Conversion from World File)Secondary Master Files49: Transportation ManagementBusiness Data
2642920F49041VS121Depot/Vehicle StaffMaster Files49: Transportation ManagementBusiness Data
2643920F4906CM171Carrier MasterMaster Files49: Transportation ManagementBusiness Data
2644920F49075PM83Product MixExtra Features Files49: Transportation ManagementBusiness Data
2645920F4908II241Item Shipping InformationSecondary Master Files49: Transportation ManagementBusiness Data
2646920F49110BW884Transportation Bill of Lading WorkfileWork Files49: Transportation ManagementBusiness Data
2647920F49111CD171Carton Detail Shipment WorkfileFiles49: Transportation ManagementBusiness Data
2648920F49130BW461Shipment Document WorkfileWork Files49: Transportation ManagementBusiness Data
2649920F49140BW491SSCC Print Label WorkfileWork Files49: Transportation ManagementBusiness Data
2650920F49141PW391Packing List WorkfileWork Files49: Transportation ManagementBusiness Data
2651920F49160NN161Document Next NumberExtra Features Files49: Transportation ManagementBusiness Data
2652920F49170NN31Load Next NumbersConstants Files49: Transportation ManagementBusiness Data
2653920F4918LT182Load Tender HistoryTransaction Files49: Transportation ManagementBusiness Data
2654920F49191DS241Document DefinitionMaster Files49: Transportation ManagementBusiness Data
2655920F49195DU71Document Set, Keys Doc Code, Doc Set (Conversion from World)Extra Features Files49: Transportation ManagementBusiness Data
2656920F49196DU72Document SetSecondary Master Files49: Transportation ManagementBusiness Data
2657920F49197OQ181Depot Document Print Set Up (Conversion from World File)Secondary Master Files49: Transportation ManagementBusiness Data
2658920F49198OQ251Depot Document Print SetupSecondary Master Files49: Transportation ManagementBusiness Data
2659920F4930VM332Vehicle MasterMaster Files49: Transportation ManagementBusiness Data
2660920F49301VO171Vehicle CompartmentsMaster Files49: Transportation ManagementBusiness Data
2661920F49302VE162Vehicle EquipmentMaster Files49: Transportation ManagementBusiness Data
2662920F4931VG451Vehicle TypeMaster Files49: Transportation ManagementBusiness Data
2663920F4935VH221Connected Vehicle HeaderMaster Files49: Transportation ManagementBusiness Data
2664920F4936CW172Connected Vehicle DetailMaster Files49: Transportation ManagementBusiness Data
2665920F49380SU184Seal NumbersTransaction Files49: Transportation ManagementBusiness Data
2666920F4941RS916Shipment Routing StepsTransaction Files49: Transportation ManagementBusiness Data
2667920F4942IS344Shipment DetailTransaction Files49: Transportation ManagementBusiness Data
2668920F4943SP286Shipment PiecesTransaction Files49: Transportation ManagementBusiness Data
2669920F4944OE211Shipment/Load Options and EquipmentTransaction Files49: Transportation ManagementBusiness Data
2670920F4945SC458Shipment ChargesTransaction Files49: Transportation ManagementBusiness Data
2671920F4947ST202Shipment Status CodesTransaction Files49: Transportation ManagementBusiness Data
2672920F49490TQ275Document SelectionBatch Input Files49: Transportation ManagementBusiness Data
2673920F4950RT5314Routing EntriesMaster Files49: Transportation ManagementBusiness Data
2674920F49501RD351Intermodal Detail Routing EntriesMaster Files49: Transportation ManagementBusiness Data
2675920F4951ZN181Carrier Zone DefinitionsMaster Files49: Transportation ManagementBusiness Data
2676920F4952RE291Routing RestrictionsMaster Files49: Transportation ManagementBusiness Data
2677920F4953RG71Routing HierarchyConstants Files49: Transportation ManagementBusiness Data
2678920F4956IX181Option and Equipment Inclusions/ExclusionsMaster Files49: Transportation ManagementBusiness Data
2679920F4957BC252Transportation Confirmed Batch ShipmentConstants Files49: Transportation ManagementBusiness Data
2680920F49590DB151Document Print Batch HeaderBatch Input Files49: Transportation ManagementBusiness Data
2681920F49591DB253Document Print - Batch SelectionWork Files49: Transportation ManagementBusiness Data
2682920F49592DH372Document Print Batch Document HeaderWork Files49: Transportation ManagementBusiness Data
2683920F49594DI402Document Print - Document DetailWork Files49: Transportation ManagementBusiness Data
2684920F49595DK353Document Print - Document SummaryTransaction Files49: Transportation ManagementBusiness Data
2685920F4960TM794Load HeaderTransaction Files49: Transportation ManagementBusiness Data
2686920F4961LL331Load LegsTransaction Files49: Transportation ManagementBusiness Data
2687920F49611LD221Load Stop SequenceTransaction Files49: Transportation ManagementBusiness Data
2688920F49612TD182Load VehiclesTransaction Files49: Transportation ManagementBusiness Data
2689920F49614TS141Load StaffTransaction Files49: Transportation ManagementBusiness Data
2690920F4962TE312Load CompartmentsTransaction Files49: Transportation ManagementBusiness Data
2691920F49621TD462Load Compartment DetailTransaction Files49: Transportation ManagementBusiness Data
2692920F4963TI361Load In-transitTransaction Files49: Transportation ManagementBusiness Data
2693920F49631TO862Load In-transit LedgerTransaction Files49: Transportation Management
2694920F49632LB403Load In-transit Left on BoardTransaction Files49: Transportation ManagementBusiness Data
2695920F49633IQ381Load In-Transit Confirmed QuantitiesFiles49: Transportation Management
2696920F49634QD291Load In-Transit Confirmed Quantities DetailFiles49: Transportation Management
2697920F49695DR351Document RegisterHistory Files49: Transportation ManagementBusiness Data
2698920F49696DJ272Document Register DetailHistory Files49: Transportation ManagementBusiness Data
2699920F49697DN243Document Register SummaryExtra Features Files49: Transportation ManagementBusiness Data
2700920F4970FT101Freight Rate ScheduleMaster Files49: Transportation ManagementBusiness Data
2701920F4971RD491Freight Rate DefinitionMaster Files49: Transportation ManagementBusiness Data
2702920F4972RX2910Rate DetailMaster Files49: Transportation ManagementBusiness Data
2703920F49721QS181Spot Quote DetailTransaction Files49: Transportation ManagementBusiness Data
2704920F4973TL144Rate Structure DefinitionMaster Files49: Transportation ManagementBusiness Data
2705920F4974RW342RateWare XL Rate ConstantsFiles49: Transportation Management
2706920F4977MR302Rate ParametersMaster Files49: Transportation ManagementBusiness Data
2707920F4978CG161Charge Code DefinitionsMaster Files49: Transportation ManagementBusiness Data
2708920F4981FH9411Freight Audit HistoryHistory Files49: Transportation ManagementBusiness Data
2709920F49T00IC151Integration ConstantsFiles49: Transportation Management
2710920F49T01CR142Cross ReferenceFiles49: Transportation Management
2711920F49T05OR101OTM Record ReservationFiles49: Transportation Management
2712920F49T10OR712Sales Order Release Staging TableFiles49: Transportation Management
2713920F49T100OB672Procurement Freight Request staging tableFiles49: Transportation Management
2714920F49T11IT451Item Staging TableFiles49: Transportation Management
2715920F49T20SS543Shipment Staging TableFiles49: Transportation Management
2716920F49T211TP417Sales Order Detail File - Secondary Tag TableFiles49: Transportation Management
2717920F49T219TP417Sales Order Detail File - Secondary Tag History TableFiles49: Transportation Management
2718920F49T30SO444Sales Confirm Staging TableFiles49: Transportation Management
2719920F49T311TP181Purchase Order Detail - OTMFiles49: Transportation Management
2720920F49T380SO152Seal NumbersFiles49: Transportation Management
2721920F49T40TC313Shipment Freight Cost Staging TableFiles49: Transportation Management
2722920F49T50LO462Order Release Location StagingFiles49: Transportation Management
2723920F49T60IV181Voucher Cross ReferenceFiles49: Transportation Management
2724920F49T70CS272Corporations Staging TableFiles49: Transportation Management
2725920F49T70WCW62Corporations Staging Work TableFiles49: Transportation Management
2726920F49T80LC312Locations Staging TableFiles49: Transportation Management
2727920F49T80WLW62Locations Staging Work TableFiles49: Transportation Management
2728920F49T90IT41Inbound TransmissionsFiles49: Transportation Management
51: Job Costing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2729920F51002GK41Job Cost Draws Next NumberConstants Files51: Job CostingBusiness Data
2730920F51006MVM81CM Currency Code MappingFiles51: Job CostingBusiness Data
2731920F51006XCM92CM Project Cross ReferenceFiles51: Job CostingBusiness Data
2732920F5101FH161Forecast Version Information FileFiles51: Job Costing
2733920F51010CS121CM Integration StatusFiles51: Job CostingBusiness Data
2734920F51011CM111CM Automated Transfer SetupFiles51: Job CostingBusiness Data
2735920F5108MD131Extended Job MasterMaster Files51: Job CostingBusiness Data
2736920F5109GJ231Chart Type MasterMaster Files51: Job CostingBusiness Data
2737920F51092MC111Multiple Cost Code SetupFiles51: Job Costing
2738920F5111FD1272Forecast DetailTransaction Files51: Job Costing
2739920F5144G7405Profit RecognitionHistory Files51: Job CostingBusiness Data
2740920F5145G751Profit Recognition Account BalanceHistory Files51: Job CostingBusiness Data
2741920F51901GP271Cost Code ScheduleSecondary Master Files51: Job CostingBusiness Data
2742920F51911GK238Draw Reporting MasterTransaction Files51: Job CostingBusiness Data
2743920F51911EXGK61Draw Explanation TableTransaction Files51: Job CostingBusiness Data
51F: Advanced Job Forecasting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2744920F51F100QF204Job Forecast HeaderFiles51F: Advanced Job Forecasting
2745920F51F10WPB201Job Forecast Billing WorktableFiles51F: Advanced Job Forecasting
2746920F51F110QG471Job Forecast DetailsFiles51F: Advanced Job Forecasting
2747920F51F115QJ181Remaining Work DetailFiles51F: Advanced Job Forecasting
2748920F51F120QK212Job Forecast Header HistoryFiles51F: Advanced Job Forecasting
2749920F51F125QI501Job Forecast Detail HistoryFiles51F: Advanced Job Forecasting
2750920F51F20WPA191Job Forecast Account Info WorktableRegular Work Files51F: Advanced Job Forecasting
2751920F51F30WVF691View Forecast Work TableWork Files51F: Advanced Job Forecasting
2752920F51F90QN821Formula DefinitionFiles51F: Advanced Job Forecasting
2753920F51F94QU121User Defined MOC DefinitionFiles51F: Advanced Job Forecasting
2754920F51F95QT182User Defined MOC RulesFiles51F: Advanced Job Forecasting
51X: In-Memory Project Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2755920F51X006JL42Job List by UserFiles51X: In-Memory Project Management
2756920F51X0902LB271Ledger Balances WorktableFiles51X: In-Memory Project Management
2757920F51X0911AL142Account Ledger WorktableFiles51X: In-Memory Project Management
2758920F51X10EX1753Project Advisor Console WorktableWork Files51X: In-Memory Project Management
2759920F51X100AR131Project Advisor Account RangeTableFiles51X: In-Memory Project Management
2760920F51X21BA281Billing Amount WorktableWork Files51X: In-Memory Project Management
2761920F51X30PB1091Project Advisor Results HeaderFiles51X: In-Memory Project Management
2762920F51X90X1601Column Definition TableFiles51X: In-Memory Project Management
2763920F51X91X2871Column Layout TableFiles51X: In-Memory Project Management
52: Contract Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2764920F4812HTWD201Billing Workfile History Tag TableFiles52: Contract Billing
2765920F4812TWD191Billing Detail Workfile Tag TableFiles52: Contract Billing
2766920F5201G417912Contract MasterMaster Files52: Contract BillingBusiness Data
2767920F5202G6969Contract Billing Line DetailMaster Files52: Contract BillingBusiness Data
2768920F52034G971Contract Header Log TextSecondary Master Files52: Contract BillingBusiness Data
2769920F5204GX152Retainage Rules InformationSecondary Master Files52: Contract BillingBusiness Data
2770920F5212G52910T and M, Unit Price and Lumpsum Cross Reference AccountsSecondary Master Files52: Contract BillingBusiness Data
2771920F5213G3144Fee Billing Line Cross Reference DetailsSecondary Master Files52: Contract BillingBusiness Data
2772920F52131GR113Rate Code Definition InformationSecondary Master Files52: Contract BillingBusiness Data
2773920F5214A4152Component Code/Burden Cross Reference TableSecondary Master Files52: Contract BillingBusiness Data
2774920F5215A5163Component/Burden Billing Line Cross Reference DetailsSecondary Master Files52: Contract BillingBusiness Data
2775920F5216A6338Milestone/Progress Billing InformationSecondary Master Files52: Contract BillingBusiness Data
2776920F52161A7175Mileston/Progress Billing Line Cross Reference DetailsSecondary Master Files52: Contract BillingBusiness Data
2777920F5217A7143Revenue Billing Line Cross ReferenceFiles52: Contract Billing
2778920F52423TK81Contract Billing Trigger DateFiles52: Contract Billing
2779920F52424TK201Contract Billing Trigger HierarchyFiles52: Contract Billing
2780920F52425TK261Contract Billing Trigger ConfigurationFiles52: Contract Billing
2781920F5280GW233Contract Revenue SummaryBalance Files52: Contract BillingBusiness Data
2782920F5280WGY484Contract Revenue Summary Work FileTransaction Files52: Contract BillingBusiness Data
52G: Proj & Gov Contract Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2783920F48091BBT61Billing Constants Business Unit TypeConstants Files52G: Proj & Gov Contract Accounting
2784920F4822HIH1131Invoice Summary HistoryHistory Files52G: Proj & Gov Contract Accounting
2785920F52G01MCM1831Advanced Contracts ModificationsMaster Files52G: Proj & Gov Contract Accounting
2786920F52G05AD448ACRN Detail TableFiles52G: Proj & Gov Contract Accounting
2787920F52G05HAH453ACRN History TableFiles52G: Proj & Gov Contract Accounting
2788920F52G20LC173Contract Specific Labor CategoriesFiles52G: Proj & Gov Contract Accounting
2789920F52G200LS161Advanced Contract Billing Limit SummaryFiles52G: Proj & Gov Contract Accounting
2790920F52G20WLW141Labor Category Work FileFiles52G: Proj & Gov Contract Accounting
2791920F52G21LR216Contract Specific Labor Category Cross ReferenceFiles52G: Proj & Gov Contract Accounting
2792920F52G80AG103Invoice Printing Account Range GroupsFiles52G: Proj & Gov Contract Accounting
2793920F52G81SH221Invoice Printing Style HeaderFiles52G: Proj & Gov Contract Accounting
2794920F52G82SD294Invoice Printing Style DetailFiles52G: Proj & Gov Contract Accounting
2795920F52G84CS83Invoice Level StylesFiles52G: Proj & Gov Contract Accounting
2796920F52G86BR112Invoice Printing Burden/Component Rule TableFiles52G: Proj & Gov Contract Accounting
2797920F52G88TL71Invoice Printing Text Line CodesFiles52G: Proj & Gov Contract Accounting
2798920F52G90WT541Invoice Printing Work TableFiles52G: Proj & Gov Contract Accounting
53: Change Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2799920F53001DU121World F53001 SpecsFiles53: Change Management
2800920F53005D1131Job Specific UDC's Master TableMaster Files53: Change ManagementBusiness Data
2801920F5301BDI488Change Request Master TableMaster Files53: Change ManagementBusiness Data
2802920F5301BZ1DI522Change Request Master Table WorkfileMaster Files53: Change Management
2803920F5302DK531F5302 World SpecsFiles53: Change Management
2804920F53101DU111Change Request Detail Status Update TableMaster Files53: Change ManagementBusiness Data
2805920F5311DK15511Change Request Details TableMaster Files53: Change ManagementBusiness Data
2806920F5311CMCM111CM Change Request Status DefaultFiles53: Change ManagementBusiness Data
2807920F5311XCM132CM Change Order Cross ReferenceFiles53: Change ManagementBusiness Data
2808920F5311Z1DK1602Change Request Details Table WorkfileMaster Files53: Change Management
2809920F5314D2485Planned Change Order Master TableMaster Files53: Change ManagementBusiness Data
2810920F5315D3474Change Order Master TableMaster Files53: Change ManagementBusiness Data
54HS: Health & Safety Incident Mgt
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2811920F54HS01S1998Incident MasterFiles54HS: Health & Safety Incident Mgt
2812920F54HS01MI11022Incident Master Change HistoryFiles54HS: Health & Safety Incident Mgt
2813920F54HS02S21143Incident PeopleFiles54HS: Health & Safety Incident Mgt
2814920F54HS021S3291Incident Injury / IllnessFiles54HS: Health & Safety Incident Mgt
2815920F54HS02MI21171Incident People Change HistoryFiles54HS: Health & Safety Incident Mgt
2816920F54HS02NI3321Incident Injury / Illness Change HistoryFiles54HS: Health & Safety Incident Mgt
2817920F54HS03S4511Incident EquipmentFiles54HS: Health & Safety Incident Mgt
2818920F54HS03MI4541Incident Equipment Change HistoryFiles54HS: Health & Safety Incident Mgt
2819920F54HS04S5201Incident AgenciesFiles54HS: Health & Safety Incident Mgt
2820920F54HS04MI5231Incident Agencies Change HistoryFiles54HS: Health & Safety Incident Mgt
2821920F54HS05S6151Incident Notification MembersFiles54HS: Health & Safety Incident Mgt
2822920F54HS05HI6121Incident Notifications SentFiles54HS: Health & Safety Incident Mgt
2823920F54HS06S7351Incident TasksFiles54HS: Health & Safety Incident Mgt
2824920F54HS06MI7381Incident Tasks Change HistoryFiles54HS: Health & Safety Incident Mgt
2825920F54HS07S8231Incident CostsFiles54HS: Health & Safety Incident Mgt
2826920F54HS07MI8261Incident Costs Change HistoryFiles54HS: Health & Safety Incident Mgt
2827920F54HS08S9341Incident Environmental ImpactFiles54HS: Health & Safety Incident Mgt
2828920F54HS08MI9371Incident Environmental Impact Change HistoryFiles54HS: Health & Safety Incident Mgt
2829920F54HS20SH322Safety HoursFiles54HS: Health & Safety Incident Mgt
54R: Rental Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2830920F54R01RC432Rental ConstantsFiles54R: Rental Management
2831920F54R02AD191Action DefinitionFiles54R: Rental Management
2832920F54R021AA352Action DetailsFiles54R: Rental Management
2833920F54R03LH191Line Type and Action Association HeaderFiles54R: Rental Management
2834920F54R031LD192Line Type and Action Association DetailFiles54R: Rental Management
2835920F54R099HL1403Rental Contract Header LedgerFiles54R: Rental Management
2836920F54R10CH1381Rental Contract HeaderFiles54R: Rental Management
2837920F54R11CD1875Rental Contract DetailFiles54R: Rental Management
2838920F54R12RR463Purchase Order Receiver Rentals FileFiles54R: Rental Management
2839920F54R199DL1893Rental Contract Detail LedgerFiles54R: Rental Management
2840920F54R20RO3310Rental Contract Related OrdersFiles54R: Rental Management
2841920F54R41TRI542Rental Item Details TableFiles54R: Rental Management
70: Multi-National Products
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2842920F700000FC71Functionalities By Country - COMM - 70Files70: Multi-National Products
2843920F700002L161Legal Document Types Tag File - COMM - 00Files70: Multi-National Products
2844920F700003LC21Company Country by Legal Document Type - COMM - 70Files70: Multi-National Products
2845920F7000100AF91Header Localization Additional DataFiles70: Multi-National Products
2846920F7000110DA173Detail Localization Additional DataFiles70: Multi-National Products
2847920F7000120OD71Base Object / Tag Table DefinitionFiles70: Multi-National Products
2848920F700018TE141Generic VAT - Informed Taxes by Report - COMM - 70Files70: Multi-National Products
2849920F700030IB91International Bank Account Number - COMM - 70Files04: Accounts Payable
2850920F700050BC101Bank Connection for Legal Documents - COMM - 00Files70: Multi-National Products
2851920F700100SC91Suspended VAT Setup by Country - COMM - 70Files70: Multi-National Products
2852920F700101GL92Suspended VAT - GLOffset - COMM - 70Files70: Multi-National Products
2853920F700102TE82Suspended VAT - Tax Explanation Code - COMM - 70Files70: Multi-National Products
2854920F700103EM102Suspended VAT - Exception Method - COMM - 70Files70: Multi-National Products
2855920F7001100LA601Localizations Additional Fields AB - 01Files70: Multi-National Products
2856920F7003B11LA631Localizations Additional Fields Customer Ledger - 01Files70: Multi-National Products
2857920F700411LA641Localizations Additional Fields Accounts Payable Ledger - 04Files70: Multi-National Products
2858920F7009001CA212Chart of Accounts by LevelFiles70: Multi-National Products
2859920F700911GA171GL Invoice NumberFiles70: Multi-National Products
2860920F702018TA242Taxes by Sales Order Line - COMM - 42Files70: Multi-National Products
2861920F702033D1141Sales Document Line Tag File - COMM - 42Files70: Multi-National Products
2862920F703030H1101Legal Document Header Tag File - COMM - 03BFiles70: Multi-National Products
2863920F703036B1111Legal Document Bank Connection - COMM - 03BFiles70: Multi-National Products
2864920F703037CI131Legal Document Contact Information - COMM - 03BFiles70: Multi-National Products
2865920F703B11AR111AR Invoice NumberFiles70: Multi-National Products
2866920F703B1Z1AZ111Sales EDI Invoice NumberFiles70: Multi-National Products
2867920F704001PT664Payment WH Info TEMP - COMM - 04Files70: Multi-National Products
2868920F704002PF645Payment WH Info - COMM - 04Files70: Multi-National Products
2869920F704002PPF645Payment WH Info Purge - COMM - 04Files70: Multi-National Products
2870920F704003PD244Payment Done - Accum - COMM - 04Files70: Multi-National Products
2871920F704008LA591Localizations Additional Fields Tax Area - 04Files70: Multi-National Products
2872920F70404Z7281G/L Registration Balance - 09Balance Files70: Multi-National ProductsBusiness Data
2873920F704100VA342Suspended VAT AP - COMM - 70Files70: Multi-National Products
2874920F704101IM221Generic Item Master Add Info - 70Files70: Multi-National Products
2875920F704101ALA601Localizations Additional Fields Item Master - 01Files70: Multi-National Products
2876920F704102IB231Generic Item Branch Add Info - 70Files70: Multi-National Products
2877920F704200FV303Final VAT AP - COMM - 70Files70: Multi-National Products
2878920F704201LA621Localizations Additional Fields Sales Order - 01Files70: Multi-National Products
2879920F704220AP111AP Invoice NumberFiles70: Multi-National Products
2880920F707111TB141Text Processor Detail Table - 70Transaction Files70: Multi-National Products
2881920F70XMLZ1SY502XML Transaction InterfaseFiles70: Multi-National Products
73: M & D complementary products
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2882920F7306VQ151Quantum Sales and Use Tax ConstantsConstants Files04: Accounts PayableBusiness Data
2883920F7307VX91Quantum Non-Stock Product CategoriesConstants Files04: Accounts PayableBusiness Data
2884920F7308VG51Quantum Database ConnectionConstants Files04: Accounts PayableBusiness Data
2885920F7308TPE81Quantum Database Connection Tag FileFiles04: Accounts Payable
74: EMEA Localization
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2886920F0018TTD461Intrastat RevisionConstants Files74: EMEA LocalizationBusiness Data
2887920F00900IR131Year-End VAT Revision - ItalyTransaction Files09: General AccountingBusiness Data
2888920F0091IF201A/B Vendor Information for Year-end IVA tape - ItalyTransaction Files04: Accounts PayableBusiness Data
2889920F00918BB21Year-end IVA Tape Creation - ItalyWork Files04: Accounts PayableBusiness Data
2890920F7400001NN101Legal Document Next Numbers - COMM - 00Files74: EMEA Localization
2891920F7400002LD121Legal Document Types - COMM - 00Files74: EMEA Localization
2892920F7400003RL91Legal Document Types / Document Types Relationship - COMM-00Files74: EMEA Localization
2893920F7400004IP71Legal Document Issue Places - COMM - 00Files74: EMEA Localization
2894920F7400006PD163Processed Documents in Legal Applications - COMM - 00Files74: EMEA Localization
2895920F7400007BD101Business Unit / Doc Type Next Number - COMM - 00Files74: EMEA Localization
2896920F740001SE71SEPA Account Setup - COMM - 74Files74: EMEA Localization
2897920F7400010LC72Company Aditional Information - COMM - 00Files74: EMEA Localization
2898920F740018AI131Intrastat Revision Additional - CZE - 74Files74: EMEA Localization
2899920F740018DDE661Data extraction ESL - 74Files74: EMEA Localization
2900920F740018OOT281Original Transaction Detail for Data ExtractionFiles74: EMEA Localization
2901920F740018TTF151Tag File F0018 - EMEA - 74Files74: EMEA Localization
2902920F740018WDE661Data extraction ESL - Workfile - 74Files74: EMEA Localization
2903920F7400B1QA22Belgium VAT WorktableWork Files04: Accounts PayableBusiness Data
2904920F7400C2DP42Obsolete - R7400C2 WorktableTransaction Files04: Accounts PayableBusiness Data
2905920F7400C2AFC31French VAT on A/RTransaction Files04: Accounts PayableBusiness Data
2906920F7400C3TG31French VAT on A/PTransaction Files04: Accounts PayableBusiness Data
2907920F74030BA121Bank ID - ItalyTransaction Files04: Accounts PayableBusiness Data
2908920F74030HNL392Dutch-Payments Bank InformationSecondary Master Files04: Accounts PayableBusiness Data
2909920F74030HAST41Dutch-Next Batch Number and Sequence NumberSecondary Master Files04: Accounts PayableBusiness Data
2910920F7404572KL141Detail Payment Instructions for German PaymentsSecondary Master Files04: Accounts PayableBusiness Data
2911920F7404573KI201Detail Payment Instructions EXT. for German PaymentsSecondary Master Files04: Accounts PayableBusiness Data
2912920F74091HA41Class/Register Setup - ItalyConstants Files04: Accounts PayableBusiness Data
2913920F74092HB61IVA Balances History - ItalyHistory Files04: Accounts PayableBusiness Data
2914920F74093HC681Worktable for Printing IVA Summary - ItalyWork Files04: Accounts PayableBusiness Data
2915920F740931HD71IVA Summary Report Header - Worktable- ItalyConstants Files04: Accounts PayableBusiness Data
2916920F741001TAT71Address Book Tag File - COMM - 01Files74: EMEA Localization
2917920F74101VV201Additional Address Book & Vat Id Info via VIES - EU - 01Files74: EMEA Localization
2918920F74101WVW231Additional Address Book & Vat Id Info Work File - EU - 01Files74: EMEA Localization
2919920F7420011SL72Sales Order / Legal Document Relationship - COMM - 42Files74: EMEA Localization
2920920F7420015SR63Invoices Related to Sales Order - COMM - 42Files74: EMEA Localization
2921920F7420018ST151Taxes by Sales Order Line - COMM - 42Files74: EMEA Localization
2922920F7420033PI231Sales Document Line (Print Info) - COMM - 42Files74: EMEA Localization
2923920F7420034PI111Price Adjustment (Print Info) - COMM - 42Files74: EMEA Localization
2924920F7420035PI51Item Cross-Reference (Print Info) - COMM - 42Files74: EMEA Localization
2925920F7430010LD232Legal Document Header - COMM - 03BFiles74: EMEA Localization
2926920F7430015DR63Invoices Related to AR DN/CN - COMM - 03BFiles74: EMEA Localization
2927920F7430018TI151Taxes by A/R Invoice Line - COMM - 03BFiles74: EMEA Localization
2928920F743002SM372SEPA MandateFiles74: EMEA Localization
2929920F7430020HA152History AmendmentFiles74: EMEA Localization
2930920F7430021DT131Print Templates Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
2931920F7430022DL81Print Line Type Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
2932920F7430023LD81Legal Documents Types / Print Template Relationship-COMM-03BFiles74: EMEA Localization
2933920F7430024DU111Legal Documents Print UBEs & Versions - COMM -03BFiles74: EMEA Localization
2934920F7430030PI341Legal Document Header (Print Info) - COMM - 03BFiles74: EMEA Localization
2935920F7430031PI201Legal Document Address (Print Info) - COMM - 03BFiles74: EMEA Localization
2936920F7430032PI111Legal Document Detail (Print Info) - COMM - 03BFiles74: EMEA Localization
2937920F7430033PI141A/R Document Line (Print Info) - COMM - 03BFiles74: EMEA Localization
2938920F7430034PI81Legal Document Attachment (Print Info) - COMM - 03BFiles74: EMEA Localization
2939920F7430035PI81Taxes by Legal Document Line - COMM - 03BFiles74: EMEA Localization
2940920F7430050BH111Print Batch Header - COMM - 03BFiles74: EMEA Localization
2941920F7430051BD81Print Batch Detail - COMM - 03BFiles74: EMEA Localization
2942920F74301BU21Bank Upload - ItalyTransaction Files04: Accounts PayableBusiness Data
2943920F743011PE131Signed Invoices - COMM - 74Files74: EMEA Localization
2944920F743011ZTK141Signed Batch Invoice - Tag Table -74Files74: EMEA Localization
2945920F743012PE111Unsigned Invoices - COMM - 74Files74: EMEA Localization
2946920F743013PE131Signed Invoices - COMM - 74Files74: EMEA Localization
2947920F743013ZTK141Signed Batch Invoice - Tag Table -74Files74: EMEA Localization
2948920F743025D141Print Template Definition Tag File - COMM - 03BFiles74: EMEA Localization
2949920F743035DT141Display Taxes by Legal Document Line - COMM - 03BFiles74: EMEA Localization
2950920F744101IN92Intrastat Supplier/Item Cross Reference TableConstants Files00: Foundation EnvironmentBusiness Data
2951920F744102IB162Intrastat Commodity Code Additional InformationRegular Work Files00: Foundation EnvironmentBusiness Data
2952920F744102TCC103Commodity Code Additional Inf Tag File - CZE - 74Files74: EMEA Localization
2953920F74411RS352Withholding Tax Detail - ItalyTransaction Files04: Accounts PayableBusiness Data
2954920F74412RP263Customer / Supplier Balance Worktable (A/P and A/R)Master Files74: EMEA LocalizationBusiness Data
2955920F74413VC251VAT Ceiling Limit-ItalyBalance Files04: Accounts Payable
2956920F7464108LO112Lot Additional Information - COMM - 41Files74: EMEA Localization
2957920F74900RP741Foreign Receivables and Payables - EMEARegular Work Files04: Accounts PayableBusiness Data
2958920F749101RD91Report Definition - EMEA - 74Files74: EMEA Localization
2959920F749102SD161Section Definition - EMEA - 74Files74: EMEA Localization
2960920F749103CD222Section Column Definition - EMEA - 74Files74: EMEA Localization
2961920F749104RD331Rows Definition - EMEA - 74Files74: EMEA Localization
2962920F749105ED172Cells Definition - EMEA - 74Files74: EMEA Localization
2963920F749110AG122Account Group Definition - EMEA - 74Files74: EMEA Localization
2964920F749111AG111Account Group Detail- EMEA - 74Files74: EMEA Localization
2965920F74UI90RD361WF - Report Detail - EMEA - 74Files74: EMEA Localization
2966920F74UI91AD201WF - Account Detail - EMEA - 74Files74: EMEA Localization
2967920F74UI92CV291WF - Account Cell Value - EMEA - 74Files74: EMEA Localization
2968920F74UI93CD72WF - Cost Center Detail - EMEA - 74Files74: EMEA Localization
2969920F74UI94CC51WF - Cost Center Detail by Company - EMEA - 74Files74: EMEA Localization
2970920F74UI95RH84WF - Report History - EMEA - 74Files74: EMEA Localization
2971920F74XMLZ1SY502XML Transaction InterfaceFiles74: EMEA Localization
2972920F74XMLZ2SY91XML Transaction Interface iSeries - COMMFiles74: EMEA Localization
74B: Begium Localization
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2973920F7403B11QA121Belgium - Work File Yearly Vat Declaration DataTransaction Files74: EMEA LocalizationBusiness Data
2974920F74B010CC111Company Additional Info - Belgium - 74BFiles74B: Begium Localization
2975920F74B100BT121Monthly VAT Table Belgium LocalisationsTransaction Files74: EMEA LocalizationBusiness Data
2976920F74B150YT51Yearly/Quarterly VAT File - BelgiumWork Files74B: Begium LocalizationBusiness Data
2977920F74B200VT131Yearly/Quarterly VAT Listing - BelgiumWork Files74B: Begium LocalizationBusiness Data
2978920F74B250CP241History VAT Listing - BEL - 00Files74B: Begium Localization
2979920F74GH20TDK21Belgium VAT Flat FileTransaction Files74: EMEA LocalizationBusiness Data
74D: Germany
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2980920F0018IGEQW21Intrastats File - Germany - Exports - 42Constants Files74: EMEA LocalizationBusiness Data
2981920F0018IGIXY21Intrastats File - Germany - Imports - 42Constants Files74: EMEA LocalizationBusiness Data
2982920F74030GAY171Germany-Bank Transit Number Master - Addtl Informatio - 04Secondary Master Files74: EMEA LocalizationBusiness Data
74F: France
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2983920F7409FOWET41ETAFI Interface - OneWorld ONLY - 09Work Files74: EMEA LocalizationBusiness Data
2984920F74F200CF91FEC - Sequence Type by CO - Fiscal Year - FRFiles74F: France
2985920F74F210FP141FEC - Last Sequence Number by CO-Fiscal Period - FRFiles74F: France
74H: Hungary
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2986920F741201CS91Accumulated Depreciation Asset Column Setup - HUN - 74Files74H: Hungary
2987920F741202WF192Work File Accumulated Asset Movement Dep - HUN - 74Files74H: Hungary
2988920F74H1002VB82VAT Table Build Header - HUN - 04Files74H: Hungary
2989920F74H1003VB82VAT Final Declaration Header - HUN - 04Files74H: Hungary
2990920F74H1004VD196VAT Declaration Detail - HUN -04Files74H: Hungary
2991920F74H1007TS124Tax Rate Summary Setup - HUN - 00Files74H: Hungary
2992920F74H1010AE81Effective EU Tax Identifiers - HUN - 00Files74H: Hungary
2993920F74H309GL262Gains & Losses Unrealized Account ing - HUN - 03BFiles74H: Hungary
2994920F74H409GL262A/P Gains & Losses Unrealized Accounting - HUN - 04Files74H: Hungary
2995920F74H410SA281Foreign Voucher Supplier Amounts - HUN - 74HFiles74H: Hungary
2996920F74H910VD232JE VAT Differences - HUN - 09Files74H: Hungary
74L: Portugal
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
2997920F74L002UU141Unused Legal Numbers - POR - 74LFiles74L: Portugal
2998920F74L101TK81Address Book Additional Information - Tag File - POR - 74LFiles74L: Portugal
2999920F74L3011MI102Manual Invoice Details - Tag Table - 74LFiles74L: Portugal
3000920F74L3035TD212Tax Details by Legal Document - POR - 74LFiles74L: Portugal
3001920F74L4008TK151Tax Rate/Area Additional Information - Tag File- POR - 74LFiles74L: Portugal
3002920F74L920TK101Referential Chart of Account - POR - 74LFiles74L: Portugal
3003920F74L921RA102Ref Accounts by Accounts - POR - 74LFiles74L: Portugal
3004920F74LUI01TT101Referential Account Details - Temp Table - 74LFiles74L: Portugal
3005920F74LUI02TT71Item Details - Temp Table - 74LFiles74L: Portugal
3006920F74LUI03TT91Tax Details - Temp Table - 74LFiles74L: Portugal
74P: Poland
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3007920F74902TAT462Account Balance Tag File - COM - 09 - 74PFiles74: EMEA Localization
3008920F74P0001ET71Exchange Table Number - POL - 11Files74P: Poland
3009920F74P03BWP3283A/R Trial Balance - POL - 03B - 74PFiles74: EMEA Localization
3010920F74P04WP2283A/P Trial Balance Work Table - POL - 04 - 74PFiles74: EMEA Localization
3011920F74P3B1TTF41Legal Document Header Tag File - POL - 03BFiles74P: Poland
3012920F74P3B23HD161A/R Fee Journal History Detail for Poland - POL - 03BFiles74P: Poland
3013920F74P3B24PD112Processed Documents in Finance Charge Processing - POL - 03BFiles74P: Poland
3014920F74P4010DT101Poland AP Document Types - POL -04 - 74PFiles74: EMEA Localization
3015920F74P411HP4182F0411 Header File - POL - 04 - 74PFiles74: EMEA Localization
3016920F74P412HTH91F0411 Tag File Header-POL- 04Files74P: Poland
3017920F74P9100CD272Cash Desk Transaction - POL - 74PFiles74: EMEA Localization
74R: Russia
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3018920F74R0001QA151Currency Codes to Words - 74RFiles74: EMEA Localization
3019920F74R0005DR101User Defined Codes - RUS - 00 - 74RFiles74: EMEA Localization
3020920F74R0007FS161Legal Document Footer Signature Setup - RUS - 00 - 74RFiles74: EMEA Localization
3021920F74R0011IC81Batch Tag File - RUS - 09 - 74RFiles74: EMEA Localization
3022920F74R0018TD8112Russian Tax File - 74RFiles74: EMEA Localization
3023920F74R010GC91Constant for VAT - RUS - 00Files74R: Russia
3024920F74R0100PC423Petty Cash Transactions - RUS - 00 - 74RFiles74: EMEA Localization
3025920F74R012CD131Cash Documents Next Number Setup - RUS - 00Files74R: Russia
3026920F74R013CA72Cash Account Setup - RUS - 00Files74R: Russia
3027920F74R01TPT101Petty Cash Transactions Tag File - RUS - 00Files74R: Russia
3028920F74R020GC71PettyCash Constants - RUS - 00Files74R: Russia
3029920F74R0401AD152Adjustment to Voucher - RUS - 04 - 74RFiles74R: Russia
3030920F74R0402CO162Correction to Voucher - RUS - 04 - 74RFiles74R: Russia
3031920F74R0480RP92Pay Item Differences - RUS - 04 - 74RFiles74: EMEA Localization
3032920F74R101TAB151Address Book Tag File - RUS - 01 - 74RFiles74: EMEA Localization
3033920F74R201VM81VAT Accrual on Sales Method Setup - RUS - 42Files74R: Russia
3034920F74R202TA71Transit VAT Account Setup - RUS - 42Files74R: Russia
3035920F74R3031PI111Legal Document Address (Print Info) - RUS - 03B - 74RFiles74: EMEA Localization
3036920F74R3032HF161Currency Code (Print Info) - RUS - 03BFiles74R: Russia
3037920F74R3033DF191Line additional info (Print Info) - RUS - 03BFiles74R: Russia
3038920F74R3034UM171Unit of Measure Relationship - RUS - 74RFiles74R: Russia
3039920F74R3035CC151Currency Code Relationship - RUS - 74RFiles74R: Russia
3040920F74R3036CO141Country of Origin Relationship - RUS - 74RFiles74R: Russia
3041920F74R3037AR112Adjustment Invoice Relationship in AR/SOP - RUS - 74RFiles74R: Russia
3042920F74R3038AI461Adjustment Invoice Header Info AR/SOP - RUS - 74RFiles74R: Russia
3043920F74R310HE211Prepayment Header Tax File - RUS - 03BFiles74R: Russia
3044920F74R311DE511Prepayment Detail Tax File - RUS - 03BFiles74R: Russia
3045920F74R3B14TF181F03B14 Tag File - RUS - 03B - 74RFiles74: EMEA Localization
3046920F74R400VR81Account Payable Setup for VAT Release - RUS - 00Files74R: Russia
3047920F74R4014TF181F0414 Tag File - RUS - 04 - 74RFiles74: EMEA Localization
3048920F74R410TH231Tax on Hold - RUS - 04Files74R: Russia
3049920F74R420TR262Tax Releases - RUS - 04Files74R: Russia
3050920F74R4500PO291Paymet Order Supplemental Data - RU - 04 - 74RFiles74: EMEA Localization
3051920F74R5010RC91Revaluation Code By Class - RUS - 12 - 74RFiles74: EMEA Localization
3052920F74R5110TF321F1201 Tag File - RUS - 12 - 74RFiles74: EMEA Localization
3053920F74R9001CA152Correspondence Account Setup - RUS -09 - 74RFiles74: EMEA Localization
3054920F74R9002GB469Correspondence Balance - RUS- 09 - 74RBalance Files74: EMEA Localization
3055920F74R9003CM152Correspondence Method - RUS -09 - 74RFiles74: EMEA Localization
3056920F74R9004CR212Correspondence Rules - RUS -09 - 74RFiles74: EMEA Localization
3057920F74R9010PL192Profit & Loss - RUS - 09 - 74RFiles74: EMEA Localization
3058920F74R9011CR373Correspondence Rules - RUS -09 - 74RFiles74: EMEA Localization
3059920F74R9020SE131Setup G/L Reports - RUS - 09 - 74RFiles74: EMEA Localization
3060920F74R9021DR191Report Detail Row Definition - RUS - 09 - 74RFiles74: EMEA Localization
3061920F74R9022AG251Accounts Group Definition - RUS - 09 - 74RFiles74: EMEA Localization
3062920F74R9023CO161Report Column Description - RUS - 09 - 74RFiles74: EMEA Localization
3063920F74R9029OA281Open Accounts - RUS - 09 - 74RFiles74: EMEA Localization
3064920F74R9030BS172Balance Sheet - RUS - 09 - 74RFiles74: EMEA Localization
3065920F74R9040CE202Changes in Equity - RUS - 09 - 74RFiles74: EMEA Localization
3066920F74R9050CF172Cash Flow - RUS - 09 - 74RFiles74: EMEA Localization
3067920F74RUI31W1391VAT Sales Book Workfile - RUS - 03BFiles74R: Russia
3068920F74RUI41W1401VAT Purchase Book Workfile - RUS - 04Files74R: Russia
3069920F74RUI42W2141VAT Purchase Book Workfile II - RUS - 04Files74R: Russia
74S: Spain
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3070920F74S0010CC81Company Tag File - Spain - 09Master Files74: EMEA LocalizationBusiness Data
3071920F74S101AI101Address Book - Additional Information - ESP - 01Files74S: Spain
3072920F74S340MF153V.A.T. Declaration Mark File - ESP - 00Files74S: Spain
3073920F74S341VF102V.A.T. Declaration Status - ESP - 00Files74S: Spain
3074920F74S342SV153Suspended VAT Declaration Mark File - ESP - 00Files74S: Spain
3075920F74S408TA122Tax Areas - 340 Model - ESP - 00Files74S: Spain
3076920F74S502SD52Stamps (Timbres) Fee Detail - 03BSecondary Master Files74: EMEA LocalizationBusiness Data
3077920F74S505SH43Stamps (Timbres) Fee Header - 03BSecondary Master Files74: EMEA LocalizationBusiness Data
3078920F74S55Q5181Expenses and Exchange Rate for Payments - Spain - 04Master Files74: EMEA LocalizationBusiness Data
3079920F74S70Q0182Model 347 - Record Type 0 - Spain - 03BMaster Files74: EMEA LocalizationBusiness Data
3080920F74S71Q1242Model 347 - Record Type 1 - Spain - 03BMaster Files74: EMEA LocalizationBusiness Data
3081920F74S72Q2252Model 347 - Record Type 2 - SpainMaster Files74S: SpainBusiness Data
3082920F74S73Q3303Model 347 - Record Type 3 - SpainMaster Files74S: SpainBusiness Data
3083920F74S74Q4131Additional Information for 347 & 349 Models - Spain - 03BMaster Files74: EMEA LocalizationBusiness Data
3084920F74S75Q531Model 347 - Link Between Rec. Type 0 & Rec. Type 1 - - 03BMaster Files74: EMEA LocalizationBusiness Data
3085920F74S76Q681Model 347 - Record Type 0 Tag File -Spain - 03BFiles74: EMEA LocalizationBusiness Data
3086920F74S77Q771Model 347 - Record Type 1 Tag File -Spain - 03BFiles74: EMEA LocalizationBusiness Data
3087920F74S78AT91Additional Information for 347 & 349 Models - Tag fileFiles74S: Spain
3088920F74S79TQ272Model 347 - Record Type 2 - Spain Tag FileFiles74S: Spain
3089920F74S90Q0271Model 349 - Record Type 0 - Spain - 03BMaster Files74: EMEA LocalizationBusiness Data
3090920F74S91Q1232Model 349 - Record Type 1 - Spain - 03BMaster Files74: EMEA LocalizationBusiness Data
3091920F74S92Q2201Model 349 - Record Type 2 Spain - 03BMaster Files74: EMEA LocalizationBusiness Data
3092920F74SCSBCS182A.E.B. Bank - Spain - 04Master Files74: EMEA LocalizationBusiness Data
74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3093920F74U006TPC221Business Unit Tag - 15Files74: EMEA LocalizationBusiness Data
3094920F74U0100CC281CIS System Constants - 04Constants Files74: EMEA LocalizationBusiness Data
3095920F74U0101SC121CIS Company Constants - 04Constants Files74: EMEA LocalizationBusiness Data
3096920F74U0102VC121Tax Payment Voucher Constants - 04Constants Files74: EMEA LocalizationBusiness Data
3097920F74U0105DI213CIS Document Information - 04Master Files74: EMEA LocalizationBusiness Data
3098920F74U0110SD204CIS Subcontractor Documents - 04Extra Features Files74: EMEA LocalizationBusiness Data
3099920F74U0111CC92CIS Company Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
3100920F74U0112SC81CIS System Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
3101920F74U0116TF324F0411 CIS Tag Table - 04Master Files74: EMEA LocalizationBusiness Data
3102920F74U0118VH253Payment Voucher Status History - 04History Files74: EMEA LocalizationBusiness Data
3103920F74U0120MV111CiS Supp F0411 Tag File - UK - 04Files74U: United Kingdom Localizations
3104920F74U0121MP111CIS PO Transaction Tag File - UK - 04Files74U: United Kingdom Localizations
3105920F74U012TPJ152Tenant EP Class Tag - 15Files74: EMEA LocalizationBusiness Data
3106920F74U01BTP3293Lease Master Tag File - 15Files74: EMEA LocalizationBusiness Data
3107920F74U0201P1421Property Company Constants - 15Files74: EMEA LocalizationBusiness Data
3108920F74U0202P2192Bank Base Rates (EPM) - 15Files74: EMEA LocalizationBusiness Data
3109920F74U0205P8437Payment Profile - 15Files74: EMEA LocalizationBusiness Data
3110920F74U0208PB141Bill Pattern Mapping - 15Files74: EMEA LocalizationBusiness Data
3111920F74U0209PF131EPM - Status Code Table - 15Files74: EMEA LocalizationBusiness Data
3112920F74U0212P8322Accounting Billing Profile - 15Files74: EMEA LocalizationBusiness Data
3113920F74U0213PW332Weekly Accounting Profile - 15Files74: EMEA LocalizationBusiness Data
3114920F74U02BTP6293Recurring Billing Tag - 15Files74: EMEA LocalizationBusiness Data
3115920F74U03BTPF211Lease Master Alternative UOM Tag File - 15Files74: EMEA LocalizationBusiness Data
3116920F74U0401SA481SPC - Constants - UK - 43Files74U: United Kingdom Localizations
3117920F74U0402SB151CIS - Supp Constants - UK - 04Files74U: United Kingdom Localizations
3118920F74U0405CH521SPC Certificate Holding Table - UK - 43Files74U: United Kingdom Localizations
3119920F74U0408LR243SPC Lower Level Retention - UK - 43Files74U: United Kingdom Localizations
3120920F74U0409LM243SPC Lower Level MCD - UK - 43Files74U: United Kingdom Localizations
3121920F74U0412AC322Application Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
3122920F74U0414CC322Certificate Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
3123920F74U0416PC322Purchase Order Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
3124920F74U0420SE994SPC - Application Master - UK - 43Master Files74U: United Kingdom Localizations
3125920F74U0421IO121Application Approval Invoice OverridesFiles74U: United Kingdom Localizations
3126920F74U0422AC194SPC Application/Certificate Cross Reference File - UK - 43Files74U: United Kingdom Localizations
3127920F74U0424PL424SPC Subcontractor Payment Liability - UK - 43Files74U: United Kingdom Localizations
3128920F74U0425SF1044SPC - Certificate Master - UK - 43Master Files74U: United Kingdom Localizations
3129920F74U0427LR42SOP5 Levy / Rate Table - UK - 43Files74U: United Kingdom Localizations
3130920F74U0429CR131SPL Cross Reference Table - UK - 43Files74U: United Kingdom Localizations
3131920F74U0430SG151Authenticated Receipts Letter Text - UK - 43Files74U: United Kingdom Localizations
3132920F74U0431LL163SPC ATR Late Letter Generation - UK - 43Files74U: United Kingdom Localizations
3133920F74U0445RN221SPC Accounts Payable Match Doc Detail Tag File - UK - 43Files74U: United Kingdom Localizations
3134920F74U0450SP251CIS Special Payee Rules - UK - 04Files74U: United Kingdom Localizations
3135920F74U0451SC151Sub-contractor/Special Payee Cross Reference - UK - 04Files74U: United Kingdom Localizations
3136920F74U0452SP151Special Payee Definitions - UK - 04Files74U: United Kingdom Localizations
3137920F74U071TPD211Property Unit Tag - 15Files74: EMEA LocalizationBusiness Data
3138920F74U203AP4291Billing Pattern - Periodic - 15Files74: EMEA LocalizationBusiness Data
3139920F74U203BP5161Billing Pattern - Weekly - 15Files74: EMEA LocalizationBusiness Data
3140920F74U207AP9221Payment Profile Status History - 15Files74: EMEA LocalizationBusiness Data
3141920F74U207BPA241Periodic Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
3142920F74U207CPH251Weekly Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
3143920F74U210WPL92Global Generation Currency Work Table - 15Files74: EMEA LocalizationBusiness Data
3144920F74U25BTPK211Interest Tag Table - 15Files74: EMEA LocalizationBusiness Data
3145920F74U4010SI112HMRC Subontractor Information - UK - 04Files74U: United Kingdom Localizations
3146920F74U4015IR82AB - HMRC Information Relation - UK - 04Files74U: United Kingdom Localizations
3147920F74U4020VS101Subcontrator Verification Status - UK -04Files74U: United Kingdom Localizations
3148920F74U4030VD151CIS Withholding Verification Detail - UK - 04Files74U: United Kingdom Localizations
3149920F74U4051HM243Header - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
3150920F74U4052SM241Subcontractor Detail - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
3151920F74U4053DM191Subcontractor Documents Detail - CIS Monthly Return - UK- 04Files74U: United Kingdom Localizations
3152920F74U420APA222SPC Application Amount Drill Down - UK - 43Files74U: United Kingdom Localizations
3153920F74U421AAH132SPC Application Approval History - UK - 43Files74U: United Kingdom Localizations
3154920F74U421BAD92Application Approval Delegates - UK - 43Files74U: United Kingdom Localizations
3155920F74U424APL315SPC Subcontractor Accrual Data - UK - 43Files74U: United Kingdom Localizations
3156920F74U424WWF305SPC Subcontractor Accrual Workfile - UK - 43Files74U: United Kingdom Localizations
3157920F74U4311PT111EPM - Purchase Order Tag File - 74UFiles74: EMEA LocalizationBusiness Data
3158920F74U4312SC292SPC - Purchase Order Additional Information - UK - 43Extra Features Files74U: United Kingdom Localizations
3159920F74U4314SD172SPC - Purchase Order Retention - UK - 43Extra Features Files74U: United Kingdom Localizations
3160920F74U4316SC452SPC - Purchase Order Line Additional Information - UK - 43Extra Features Files74U: United Kingdom Localizations
3161920F74U4318SD182SPC - Purchase Order Line Retention - UK - 43Extra Features Files74U: United Kingdom Localizations
3162920F74U4319CS181SPC Cumulative Labour Material Split - UK - 43Files74U: United Kingdom Localizations
3163920F74U4320TV101Requisition Template Qestions - UK - 43Files74U: United Kingdom Localizations
3164920F74U4321RA221Requisition Template Answers - UK - 43Files74U: United Kingdom Localizations
3165920F74UCW01CW21CIS Voucher Entry Workfile - UK - 04Files74U: United Kingdom Localizations
3166920F74UCW02CV61CIS Voucher Entry Workfile 2 - UK - 04Files74U: United Kingdom Localizations
3167920F74UCW03VM162CIS Voucher Match Workfile - UK - 04Files74U: United Kingdom Localizations
3168920F74UUI51HM243Header - XML Work File CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
3169920F74UUI52SM241Subcontractor Detail - XML WF CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
74W: Sweden
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3170920F74W001QC161Supplier Info. Foreign Payments per Payment - 74WSecondary Master Files74: EMEA LocalizationBusiness Data
3171920F74W200K092A/P Payment Processing Sequence Numbers File - 74WFiles74: EMEA Localization
3172920F74W201K191Debit Advice Header - 74WFiles74: EMEA Localization
3173920F74W202K2103Debit Advice Payment File - 74WFiles74: EMEA Localization
3174920F74W203K3191Debit Advice Invoice File - 74WFiles74: EMEA Localization
3175920F74W204K441Debit Advice Error File - 74WFiles74: EMEA Localization
3176920F74W210K5101A/P Automatic Payments Spot Rate - 74WFiles74: EMEA Localization
74Y: Italy
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3177920F740018ATT121Tax Rate Area and Transaction Type MappingFiles74Y: Italy
3178920F743B14ITI372Suspended IVA Generation - Receipt/Rebate Control-Ita - 03BTransaction Files74: EMEA LocalizationBusiness Data
3179920F74405RC121Withholding Tax Codes-ItalyTransaction Files74Y: ItalyBusiness Data
3180920F74Y0003IT91Legal Doc Type for Electronic InvoiceFiles74Y: Italy
3181920F74Y001CI141Company Additional InformationFiles74Y: Italy
3182920F74Y0030BT71Bank Transit Number Tag File - ITA - 04 - 74YFiles74: EMEA Localization
3183920F74Y008IN91Intrastat Additional Info for Service Tax Areas - ITA - 00Files74Y: Italy
3184920F74Y010BL71Black List Setup by Country Tax AreaFiles74Y: Italy
3185920F74Y0101RI161Address Book Italian Tag File - ITA - 01Files74Y: Italy
3186920F74Y011MP91Multi Purpose VAT Classification by Tax Area / Item - 74YFiles74Y: Italy
3187920F74Y015YL363Yearly List Declaration - WF - IT - 00Files74Y: Italy
3188920F74Y018IA212Intrastat Additional Info for Services - ITA - 00Files74Y: Italy
3189920F74Y020IH151Italy Intrastat Declarations - Header - ITA - 00Files74Y: Italy
3190920F74Y021ID252Italy Intrastat Declarations - Detail Sections - ITA - 00Files74Y: Italy
3191920F74Y022IA181Italy Intrastat Decl - Adjustment Section - ITA - 00Files74Y: Italy
3192920F74Y023IM161Italy Intrastat Decl - Modifications - ITA - 00Files74Y: Italy
3193920F74Y050TH332Third party Black List Amounts - IT - 00Files74Y: Italy
3194920F74Y060YS341Yearly List Summarized Workfile -ITA - 74YFiles74Y: Italy
3195920F74Y061YD261Yearly List Detailed Workfile -ITA - 74YFiles74Y: Italy
3196920F74Y101IN81Address Book Tag File Intrastat - ITA - 01Files74Y: Italy
3197920F74Y170CT192Contracts - IT - 00Files74Y: Italy
3198920F74Y171CR231Contract Relations - IT - 00Files74Y: Italy
3199920F74Y215RO62Invoices Related to Sales Order - ITA - 42Files74Y: Italy
3200920F74Y3016RL131Additional Information Yearly listFiles74Y: Italy
3201920F74Y315RI72Invoices Related to AR DN/CN - ITA - 03BFiles74Y: Italy
3202920F74Y415RV82Vouchers Related to AP DN/CN - ITA - 04Files74Y: Italy
3203920F74YUI01LC311Italy Legal Company WF - ITA - 74YFiles74Y: Italy
3204920F74YUI10CD271Italy Customer Detail WF - ITA - 74YFiles74Y: Italy
3205920F74YUI11SD291Italy SupplierDetail WF - ITA - 74YFiles74Y: Italy
74Z: Czech Republic
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3206920F74Z0010ZO191Cash Desk Document Printed - CZE - 74ZFiles74Z: Czech Republic
3207920F74ZUI01CZ71Corresponding AccountsFiles74Z: Czech Republic
3208920F74ZUI02CZ201Czech VAT Report - CZE - 74Z - Work FileFiles74Z: Czech Republic
75A: Australia
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3209920F75A0001ZA331Australia/New Zealand tax ParametersConstants Files07: PayrollBusiness Data
3210920F75A0002ZO321Australia/New Zealand tax OptionsConstants Files07: PayrollBusiness Data
3211920F75A0003ZR362Australia/New Zealand tax calculation rulesConstants Files07: PayrollBusiness Data
3212920F75A0004A4161Coinage Allocation ParametersConstants Files07: PayrollBusiness Data
3213920F75A0005A5161Coinage Details Work FileWork Files07: PayrollBusiness Data
3214920F75A0006ZE291Australian Employee Tax OverridesConstants Files07: PayrollBusiness Data
3215920F75A0009A9121Employee DBA InstructionsSecondary Master Files07: PayrollBusiness Data
3216920F75A0010A01181Australian Employee Termination DetailsSecondary Master Files07: Payroll
3217920F75A010TA0301Australian Employee Termination Details - Tag FileSecondary Master Files75A: Australia
3218920F75A011TBW341Australian Employee Termination Details Secondary Tag TableFiles07: Payroll
3219920F75A0140ZG372Australian Payment SummaryHistory Files07: Payroll
3220920F75A0145ZZ31Payment Summary ATO file build work fileWork Files07: Payroll
3221920F75A0150ZD181Foreign Employment DatesSecondary Master Files07: Payroll
3222920F75A0201TF181Recipient Created Tax Invoice Tag FileFiles03B: Enhanced Accounts ReceivableBusiness Data
3223920F75A0202RA171GST - RCTI Adjustment Print Control TableFiles03B: Enhanced Accounts ReceivableBusiness Data
3224920F75A0220PS311Payment Summary WorkfileFiles03B: Enhanced Accounts ReceivableBusiness Data
3225920F75A0301SA164Superannuation PaymentFiles75A: Australia
3226920F75A0401ZT131Australia State Payroll Tax Thresholds and RatesFiles75A: Australia
3227920F75A0402ZF71Australia State Payroll Tax Threshold Proration FormulasFiles75A: Australia
3228920F75A0403ZG81Australia State Payroll Tax Company GroupsFiles75A: Australia
3229920F75A0404ZM93Australia State Payroll Tax Company Group MembersFiles75A: Australia
3230920F75A0405ZP71Australia State Payroll Tax Eligible PDBsFiles75A: Australia
3231920F75A0406ZH291Australia State Payroll Taxable Wages HistoryFiles75A: Australia
3232920F75A0407TL161Australia State Payroll Tax Liability HistoryFiles75A: Australia
3233920F75A0500BP282AU Bonus and Back Pay Tax WorkfileFiles75A: Australia
3234920F75A0501TH282AU Bonus and Back Pay Tax HistoryFiles75A: Australia
3235920F75A200TF121GST - Tax Invoice / Adjustment Note Tag fileFiles03B: Enhanced Accounts ReceivableBusiness Data
3236920F75A670LL52Long Service Leave DatesFiles75A: Australia
3237920F75A671LA151Long Service Leave AuditFiles75A: Australia
3238920F75A9096ZC121Australian/New Zealand company constantsConstants Files07: Payroll
75C: China
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3239920F0018CNCT152China - Transmitted vouchers to JinSui - 04Transaction Files75: ASEAN LocalizationBusiness Data
3240920F75C001CR293Chinese GUI cross reference fileTransaction Files75C: China
3241920F75C002EA212Electronic Accounting BookFiles75C: China
3242920F75C003RI121Report Format DefinitionFiles75C: China
3243920F75C003TRT121Report Format Definition Tag file - ChinaFiles75C: China
3244920F75C004RN101Report Item - Natural Account MappingFiles75C: China
3245920F75C005RF91Report Item - Formula MappingFiles75C: China
3246920F75C006NA111Natural Account Structure Set UpFiles75C: China
3247920F75C007CA181China - Chart of Accounts Set UpFiles75C: China
3248920F75C008EM241Employee Record Information - ChinaFiles75C: China
3249920F75C009BI171GL Basic Information - ChinaFiles75C: China
3250920F75C010UR161Subsidiary Info Setup - ChinaFiles75C: China
3251920F75C010WAA471AP & AR XML Workfile - China -75CFiles75C: China
3252920F75C011UV401Account - Subsidiary Cross Reference - China - 75CFiles75C: China
3253920F75C012AB141Address Book Additional Information - ChinaFiles75C: China
3254920F75C013DE171Dynamic XML Element Name - CHINA - 00Files75C: China
3255920F75C014BA211AP/AR Balances - ChinaFiles75C: China
3256920F75C015CF361Cash Flow Data - ChinaFiles75C: China
3257920F75C01Z2FF21GUI Jinsui return flat file - China - 03BBatch Input Files75: ASEAN LocalizationBusiness Data
3258920F75C030AB121Additional Bank Information - CHINA - 75CFiles75C: China
3259920F75C04Z1CT41China A/P tax interface to JinSui - 04Transaction Files75: ASEAN LocalizationBusiness Data
3260920F75C091CL101Account master - Tag file - China LocalizationFiles75C: China
3261920F75C09Z1FF41GUI cancel printing invoice-Jinsui - China - 03BPC Download/Batch Edit Files75: ASEAN LocalizationBusiness Data
3262920F75C201MM181Modification Methods Information - CHINAFiles75C: China
3263920F75C202DA202Asset Disposal Amounts - CHINAFiles75C: China
3264920F75C203FA151Fixed Assets Card Usage Information - CHINAFiles75C: China
3265920F75C204AH211Asset Master History File - CHINAFiles75C: China
3266920F75C4106IB152Chinese Free Goods VAT base price - F75C4106 - 41Master Files75: ASEAN LocalizationBusiness Data
3267920F75C4203FC152Chinese VAT on Free Goods Cross Reference - China - 42Files75: ASEAN LocalizationBusiness Data
3268920F75C501CE121Payroll Category and Payroll Elements - CHINAFiles75C: China
3269920F75C502PP161Payroll Periods - CHINAFiles75C: China
3270920F75C503EP171Employee Payroll - CHINAFiles75C: China
3271920F75C504PC141Payroll Category - CHINAFiles75C: China
3272920F75C505PE121Payroll Elements - CHINAFiles75C: China
3273920F75C902SB781Subsidiary Balances File - ChinaFiles75C: China
3274920F75C910CF171China Reports Balance -CNAO V2Files75C: China
3275920F75C911DN192CNAO - E1 Document Number mapping - ChinaFiles75C: China
3276920F75C911AAL181Account Ledger Processing Info- China - 09Files75C: China
3277920F75C912TS431Transaction-wise Subsidiary Info - China - 09Files75C: China
3278920F75CDXMDX131Dynamic XML Output GeneratorFiles75C: China
3279920F75CUI04WF91China CNAO V2 Fixed Asset XML Work File - CHINAFiles75C: China
3280920F75CUI05MP551AP & AR Multiple Period XML Workfile - China -75CFiles75C: China
3281920F75CUI1CF241China Financial Report Work File - 10Files75: ASEAN Localization
3282920F75CUI2CF91China Financial Report Staging Work File - 10Files75: ASEAN Localization
3283920F75CUI3CW231Financial Reporting Work FIleFiles75C: China
75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3284920F75I0002Q1123Additional Information Master for SOFiles75I: India
3285920F75I001NN121Legal Document Next Numbers - IND - 00Files75I: India
3286920F75I005TG81Tax Groups-IND-00Files75I: India
3287920F75I006TS81O2C Tax Set up-IND-00Files75I: India
3288920F75I007LC111Tax Setup P2P - IND - 43Files75I: India
3289920F75I008PO382Purchase Order Receiver Tag File - IND - 43Files75I: India
3290920F75I009IS72Item Attributes/Category Codes Mapping - IND - 41Files75I: India
3291920F75I010AB101A/B Additional Tax Information - IN - 04Files75I: India
3292920F75I011PD131Percentage-Credit DistributionFiles75I: India
3293920F75I013PD161Credit DistributionFiles75I: India
3294920F75I016CS92Chapter Number Set Up - IND - 41Files75I: India
3295920F75I017SO361Sales Order Tag File IND 42Files75I: India
3296920F75I022TH131F0411 Tag File Header - IND - 04Transaction Files75I: India
3297920F75I031PI281Legal Document Address (Print Info) - IND - 00Files75I: India
3298920F75I035DG71Display Taxes by Legal Document Line Tag File - IND - 03BFiles75I: India
3299920F75I051IN131POT Setup - IND - 75IFiles75I: India
3300920F75I052IN211Services Category Additional information - IND - 75IFiles75I: India
3301920F75I053RA202Vouchers Generated for Reverse Charge AR IND - 75IFiles75I: India
3302920F75I055RP272Vouchers Generated for Reverse Charge AP - IND - 04Files75I: India
3303920F75I072TS212Tax Rules Setup - IND - 45Files75I: India
3304920F75I100QB588TDS Ceritificate Master MaintenanceMaster Files75I: India
3305920F75I100QEF801TDS Form 26Q - WorkFile (Quarterly)Files75I: India
3306920F75I100WEF441TDS Form 26 - WorkFileFiles75I: India
3307920F75I101QB633TDS Certificate Work MaintenanceFiles75I: India
3308920F75I102QB141TDS Certificate Master Maintenance -Tag FileFiles75I: India
3309920F75I103TA111TDS / TCS Acknowledgement NumberFiles75I: India
3310920F75I104TD171TDS Certificate Master Maintenance Tag FileFiles75I: India
3311920F75I10AQA292TDS Rate Maintenance FileMaster Files75I: India
3312920F75I119TCN51Challan number wise amountFiles75I: India
3313920F75I15AQC341TDS Document Company Maintenance FileMaster Files75I: India
3314920F75I20AQD353TDS Document CompanyMaster Files75I: India
3315920F75I210CS371Tax Registration Details - IND - 00Files75I: India
3316920F75I211TR101Tax Registration Details Tag File-IND-00Files75I: India
3317920F75I213TR141Tax Registration Details-Service Tax Tag File-IND-00Files75I: India
3318920F75I215PR71Tax Reg. Detail - PAN Ref Tag File - IND -00Files75I: India
3319920F75I220SC81State Level ConstantsFiles75I: India
3320920F75I2213TT303Setoff Temp TableFiles75I: India
3321920F75I2241VC291WorkFile for VAT/CST ReceivablesFiles75I: India
3322920F75I2242DA202VAT- Deferred Amounts for the Purchase cycleFiles75I: India
3323920F75I301Q1214Excise - Setup MasterMaster Files75I: India
3324920F75I302QA351Excise - Period MasterMaster Files75I: India
3325920F75I303Q2181Excise - ARE1 Bond Master-IND-75IMaster Files75I: India
3326920F75I304Q382Excise - Cross Reference FileMaster Files75I: India
3327920F75I305Q3182Excise - General Surety BondMaster Files75I: India
3328920F75I3051FY171Excise Fiscal YearsFiles75I: India
3329920F75I306EA91Excise Account Master -IND-00Files75I: India
3330920F75I3061EC81Excise Account Master - Credit Redistribution -INDFiles75I: India
3331920F75I309CS431Personal Consumption - CENVAT setoff - IND - 41Files75I: India
3332920F75I310WRE111Voucher Entry RecordFiles75I: India
3333920F75I310YQ21102Excise - MODVAT / PLA Summary FileTransaction Files75I: India
3334920F75I311EB152F75I310Y - Tag FileFiles75I: India
3335920F75I312Q1485Excise - Consignment/ Adjustment Detail File - ItemWiseTransaction Files75I: India
3336920F75I312YQ1626Excise-Consignment/Adjustment Detail -Item wiseFiles75I: India
3337920F75I313YQ1403Excise - RG23A - II ChapterWise Transaction FileTransaction Files75I: India
3338920F75I314YQ1444Excise - RG23A - II Item Wise Transaction FileTransaction Files75I: India
3339920F75I315YQ2402Excise - PLA Chapter Wise Transaction File for Yarn IndustryTransaction Files75I: India
3340920F75I316YQ2433Excise - PLA Item Wise Transaction FileTransaction Files75I: India
3341920F75I317YQ3392Excise - RG23C - II Chapter Wise Transaction FileTransaction Files75I: India
3342920F75I318YQ3433Excise - RG23C - II Item Wise Transaction FileTransaction Files75I: India
3343920F75I319BR1352Excise Amount - Transfer Detail FileFiles75I: India
3344920F75I319YQ1421Excise - Consolidated Excise Duty PaymentTransaction Files75I: India
3345920F75I320YQB561Excise - Payment DetailsTransaction Files75I: India
3346920F75I322Q3302Excise - Work File for F04211 & F4101Work Files75I: India
3347920F75I322DQC71Excise - Chapter wise temp file for F75I314/16/18(Ex - Amt)Work Files75I: India
3348920F75I322EQ3342Excise - Work File for F04211 & F4101(Based on F75I322)Work Files75I: India
3349920F75I322FQC111Excise - Chapter wise temp file for F75I314/16/18 (F75I322D)Work Files75I: India
3350920F75I323RA181Purchase Order Receiver AR3 Information - IND - 43Files75I: India
3351920F75I324Q3322Work File for ARE1 ARE3 IND 42Files75I: India
3352920F75I331AI371Customer Master Tagfile - IND - 03BFiles75I: India
3353920F75I343QA141Excise - Daywise Closing BalanceTransaction Files75I: India
3354920F75I344QB283Excise - ARE1 Bond RegisterTransaction Files75I: India
3355920F75I344CCD341ARE-1 Bond Register for Cancelled Receipts-IND-00Files75I: India
3356920F75I344YCD474Print ARE-1Bond Register-IND-00Files75I: India
3357920F75I345QR442Excise - ARE3 Form Header Details-IND-00Transaction Files75I: India
3358920F75I3451QD251Excise - ARE3 Form Detail-IND-00Transaction Files75I: India
3359920F75I345XQR462Excise - ARE-3 Form Header for YarnTransaction Files75I: India
3360920F75I346Q9463Excise - D3-Form TableTransaction Files75I: India
3361920F75I348CT141CT2/CT3 Annexure Certificate Master-IND-00Master Files75I: India
3362920F75I354QW361Excise ARE3 Tag file for Form Header IND 42Files75I: India
3363920F75I357CH474Consignment HeaderFiles75I: India
3364920F75I3571CW481Consignment - Work OrdersFiles75I: India
3365920F75I3572CS511Consignment - Stock TransfersFiles75I: India
3366920F75I3573CO532Consignment - Order ItemsFiles75I: India
3367920F75I3574CT623Consignment - Issues/Receipts TransactionsFiles75I: India
3368920F75I3575CP451Consignment - Work Order Part List Items - BalancesFiles75I: India
3369920F75I3576SW492Stock Transfer - Work OrdersFiles75I: India
3370920F75I380RG875Excise - RG-1 - Transaction File - INDFiles75I: India
3371920F75I382IP211Amount of Interest Paid per month - IND - 00Files75I: India
3372920F75I385ED391RG23D Register - Issues - IND - 42Files75I: India
3373920F75I390ER151Work With Excise ReportsFiles75I: India
3374920F75I3901CO782Work With Consignment - IND -43Files75I: India
3375920F75I395AER351ER - 5 (1)Files75I: India
3376920F75I395BER531ER - 5 (2)Files75I: India
3377920F75I395TER541ER - 5 (temp)Files75I: India
3378920F75I396AES361ER-6 - List of Finished goods manufacturedFiles75I: India
3379920F75I396BSE601ER-6Files75I: India
3380920F75I396COB311Table for Opening Balance QuantityFiles75I: India
3381920F75I396TSE571ER-6 TempFiles75I: India
3382920F75I397SC321ER-6 ScrapFiles75I: India
3383920F75I397BES371ER-6 ScrapFiles75I: India
3384920F75I401QA343Sales Form Information-IND-42Master Files75I: India
3385920F75I401CQA341Sales Form Information- SecondaryMaster Files75I: India
3386920F75I402PT583Purchase Tax Form DetailsFiles75I: India
3387920F75I402TPT581Purchase Tax Form Details -SecondaryFiles75I: India
3388920F75I403AB371Stock Transfer DetailsFiles75I: India
3389920F75I403TAB371Temp Data for F75i403Files75I: India
3390920F75I404CP221Consolidated tax paymentFiles75I: India
3391920F75I405DP222Deferred Input Tax CreditFiles75I: India
3392920F75I406SB291State / Branch Plant Cross ReferenceFiles75I: India
3393920F75I407IC311Item Category RelationshipFiles75I: India
3394920F75I4074AL211Price Adj Ledger Tag File - 03BFiles75I: India
3395920F75I408VC271VAT/CST Account MasterFiles75I: India
3396920F75I409VS281Personal Consumption - VAT setoff - IND - 41Files75I: India
3397920F75I411TF192F0411 Tag File - IN - 04Files75I: India
3398920F75I421MA111Assign Price / Cost ElementsFiles75I: India
3399920F75I4210FT161Sales Form Tracking - SecondaryFiles75I: India
3400920F75I4213SO321Setoff Report Data -IND -00Files75I: India
3401920F75I4216AB71Set Off Amount -INDFiles75I: India
3402920F75I4223SD581Sales Tax Summary/DetailFiles75I: India
3403920F75I4231PT291Purchase Tax Summary / DetailsFiles75I: India
3404920F75I601TR332TCS Register Details-IND-42Files75I: India
3405920F75I602IB302Item Branch Tagfile - IND - 41Files75I: India
3406920F75I603TM141TCS Prepayment Master File - IND-03BFiles75I: India
3407920F75I604TP231TCS Payment DetailsFiles75I: India
3408920F75I605TA121TCS Tax AmountFiles75I: India
3409920F75I611TT394TCS Prepayment Transaction File - IND-03BFiles75I: India
3410920F75I612TP232TCS Prepayment To Tax AuthorityFiles75I: India
3411920F75I701QH1074Bill of Entry - HeaderFiles75I: India
3412920F75I704CR71Service Tax Cross Reference File - INDFiles75I: India
3413920F75I731ST252Service Tax A/R File - IND - 03BFiles75I: India
3414920F75I732ST181Service Tax A/R File Additional Info - IND - 03BFiles75I: India
3415920F75I734PF81Service Tax Received File - IND - 03BFiles75I: India
3416920F75I735ST412Order Detail by Service Category Code - IND - 75IFiles75I: India
3417920F75I741ST282Service Tax A/P File - IND - 04Files75I: India
3418920F75I742ST191Service Tax A/P File Additional Info - IND - 04Files75I: India
3419920F75I744PF81Service Tax Payment File - IND - 04Files75I: India
3420920F75I750CE222Service Tax Cenvat File -09 - INDFiles75I: India
3421920F75I754AP131Advance Service Tax Payment File - IND -04Files75I: India
3422920F75I760AB261Advance Service Tax Balance File - INDFiles75I: India
3423920F75I790WT61Form ST-3 Working Table - IND - 09Files75I: India
3424920F75I790TSF141ST-3 Section 5A, 5AA and 5B Setup fileFiles75I: India
3425920F75I791IS293Item/Supplier Cost Components - IND - 43BMaster Files75I: India
3426920F75IEXCQZ71Excise Balance File lockMaster Files75I: India
3427920F75IUI01TW211eTCS Anuual Return - Work FileFiles75I: India
3428920F75IUI7WF241Service Tax Credit Register - Work File - INDFiles75I: India
75J: Japan
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
3429920F75010J041Bank/Branch Master - Japan - 04Master Files75: ASEAN LocalizationBusiness Data
3430920F750101BU11Bank ID Upload - Japan - 04Master Files75: ASEAN LocalizationBusiness Data
3431920F75010ABU21Bank ID Upload - Japan - 04Work Files75: ASEAN LocalizationBusiness Data
3432920F75012J2111Bank Charge - Japan - 04Constants Files75: ASEAN LocalizationBusiness Data
3433920F75013J381Stamp Tax - Japan - 04Master Files75: ASEAN LocalizationBusiness Data
3434920F75014JP101Withholding - Japan - 04Constants Files75: ASEAN LocalizationBusiness Data
3435920F750401J4101Japanese A/B Tag Table - 04Extra Features Files75: ASEAN LocalizationBusiness Data
3436920F750411JX223Withholding Tax Detail - Japan - 04Transaction Files75: ASEAN LocalizationBusiness Data
3437920F75C0401CS71China Supplier Master Additional Information - 04Extra Features Files75: ASEAN LocalizationBusiness Data
3438920F75J04SAJ432Hankin Hante Split Amounts - 04Files75: ASEAN LocalizationBusiness Data
3439920F75J3001AB81Tag file for Densai User NumberFiles75J: Japan
3440920F75J503LM91Setup for Life Month - 75J - JAPFiles75J: Japan
3441920F75J504RO