Skip to Content
0
Former Member
Jan 21, 2008 at 06:44 PM

Service Management: Contract data sources, Exrractors and cubes

8 Views

Hi Fellows: I have never worked in Service Management before and I have been asked to locate the extract strucutres, data sources and cubes for some reports. The reports are for contracts, contract renewals, Contract repairs, Contracts Units End of Service, Contract customers, Contract Customer Report Card etc. Are there any standard extractors, data sources for contracts or service Management?

Contracts PLACE ID

Contracts

Contracts MODEL ID

Contracts SERIAL ID

Contracts Contract Start Date

Contracts Contract End Date

Contracts LINE VALUE

Contracts Contract ID

Contracts Contract Version

Contracts Invoice Date

Contracts Invoice ID

Contracts NAME

Contracts LOCATION

Contracts Address

Contracts City

Contracts Global Name

Contracts Name

Contracts Place ID

Contracts State

Contracts Zip

Contracts Sales Group B

Contracts Sales Group C

Contracts Contract ID

Contracts Version

Contracts Term of Contract

Contracts PO Number

Contracts Product Location

Contracts Phone

Contracts Model ID

Contracts Serial ID

Contracts Part ID

Contracts Quantity

Contracts Service Plan

***Contract Renewals:

Contract Version

Status of New Contract

New PG Description

Event Code

Event Created

New Price

New Travel Price

Old Price

Old Travel Price

****Contract repairs:

Problem Resolution

Received Date

Repair Center Info, name, address, ciy, state, postalcode, country

Repair Center Info, name, address, ciy, state, postalcode, country

Repair Center Info, name, address, ciy, state, postalcode, country

Repair Center Info, name, address, ciy, state, postalcode, country

Repair Center Info, name, address, ciy, state, postalcode, country

Repair Center Info, name, address, ciy, state, postalcode, country

Scheduled Ship Date

Serial # Received

Serial # Registered

Serial # Shipped

Service Repair (Work) Order #

Technician’s name

Tracking #

Account Indicator