1 / 8

Overview of Data Extraction/Availability

Overview of Data Extraction/Availability. Databases underlying major systems. ERP/Fourth Shift-Titanium 8, proprietary. Next version is MS SQL only Payroll-SQL Base 7.51 HR Perspective – MS Access Novatime-Time & Attendance, MS SQL Express 2005. Data Hierarchy-Fourth Shift.

laurie
Télécharger la présentation

Overview of Data Extraction/Availability

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview of Data Extraction/Availability

  2. Databases underlying major systems • ERP/Fourth Shift-Titanium 8, proprietary. Next version is MS SQL only • Payroll-SQL Base 7.51 • HR Perspective – MS Access • Novatime-Time & Attendance, MS SQL Express 2005

  3. Data Hierarchy-Fourth Shift • Manufacturing (Main)* • Item • Order • History • Finance (FIN)* • General Ledger • Accounts Payable • Accounts Receivable

  4. Ways to Access Data • Internal Reports – F7 from most screens, most not very useful. Exception is GL Report Writer, which is difficult to use • Direct Access-Not possible w/ this version of Fourth Shift ODBC-Crystal Reports/FoxPro-Difficult & Problematic on this version of Fourth Shift w/ proprietary database. • Extract-FoxPro – Using Bulk of external reporting is done this way. Timeliness & file sharing issues • Extract-Excel – Limited use, Convenient but limited to FS “Views” • Extract-Access – Not currently used. Also limited to FS “Views” • Archive File – Flat file, must be parsed & interpreted by program. Most SOX control reports use this d/t the fields available.

  5. Refer to FS Data Export Help

  6. Fourth Shift Views • Master View-General Ledger • Batch Detail-Account • Batch Detail-Sequence • Detail Activity • GL Accounts • Organizations • Period Activity • Recap Activity • Recur/Template • Report Writer • Unposted Detail - Account • Master View – Item • Bills • Customer Quotes • Demands • Master View-Customer • Customer Data • Customer Extended Text • Master View-External Data • AP PO Header Data • AP PO Line Data • Archive Data • GL Transactions • INVC FRT Data • INVC Order Data • INVC Serial No • INVC Ship/Pick • INVC Shipment Data • Inventory Transactions • Sales Analysis

  7. Fourth Shift Views-Cont’d • Master View-Item Cont’d • Forecast • History • Inventory • Item Cost • Mini Inventory • Multilevel Bill • Planning Data • Reference Data • Supplies • Vendor/Item Performance • Item Lot Master • Lot/Serial Data • Serial Number • Catalog • Master View-Location • Location Description • Master View-Miscellaneous • Data View • Name & Address Data • Text Message Data • Global Extended Text Data • Current Definition Data • VAT Data • Item History-Misc. • Item History-At Level Cost • Item History-Balance • Item History-Tran Qty • Item History-Tran Cost • Item History-Rolled Cost • Currency Exch. Rate data

  8. Fourth Shift Views-Cont’d • Master View-Misc. Cont’d • Batch Process • Prod Line Data • Master View-Orders • CO Detail • CO Detail ExTxt • CO Header • CO Header ExTxt • CO Shipments View • Custom Products Config • MO Config • MO Detail • MO Header • MO WIP • Master View-Orders cont’d • PO Detail • PO Detail ExTxt • PO Header • PO Header ExTxt • PO S line WIP • S Line Config • Master View-Payables • Checks G/L Distrib. • Checks • Elect. Payment Set • Inv 1099 • Inv. Adjustments • Inv G/L Detail • Inv Matching • Invoice Detail

More Related