KS_SERIALHIST

1

Item ID

string

25

Y

Item ID or part number

2

Serial Number

string

25

Y

serial number for this item ID

3

Order Number

string

30

The sales order or RMA that was related to the transaction

4

Order Type

string

1

S=Sales order
R=RMA
C=Credit Sales
order

Determines the type of order number

5

Source Record

string

30

The immediate shipment or receipts transaction number related to the order

6

Warranty Code

string

30

This is actually the xref_id which is looked up in the foreign key table to find the actual pk value (integer) in SQL DB. The lookup is a combination of type and company number.

7

Install Date

datetime

This is either the date the product was shipped or the date it was installed at the end user facility. It is used to determine warranty status in webServiceCenter application

8

Material Term

integer

4

The term (in days) for material coverage (i.e. parts)

9

Material Percent

float

The percentage coverage for material

10

Labor Term

integer

4

The term (in days) for labor coverage (i.e. services)

11

Labor Percent

float

The percentage coverage for labor

12

Outside Term

integer

4

The term (in days) for Outside coverage

13

Outside Percent

float

The percentage coverage for Outside charges

14

Misc Term

integer

4

The term (in days) for miscellaneous coverage

15

Misc Percent

float

The percentage coverage for miscellaneous charges

16

Business No

string

30

The assumption is the business entity is of type 'C' or customer. A lookup is done based on this value.

17

Status Code

string

R=Retired and
no longer used
S=Shipped to customer

Any other status code other than R or S assumes the serial number is available in inventory.