|
Ordinal
|
Description
|
Data
Type
|
Data
Length
|
Required
|
Check
Constraints
|
Comments
|
|
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.
|