Part Kit Master Field Definitions
- Alan Michalec (Unlicensed)
Owned by Alan Michalec (Unlicensed)
May 17, 2018
2 min read
Loading data...
| Field | Value | Type/Size |
|---|---|---|
| Facility | Required | int(5) |
| Kit Number | Required | char(25) |
| Kit Description | char(40) | |
| Cross Reference | char(25) | |
| Account Code | char(25) | |
| Classification | char(12) | |
| Issue Unit | char(3) | |
| Major VMRS | int(3) | |
| Intermediate VMRS | int(3) | |
| Minor VMRS | int(3) | |
| Bin Number | char(10) | |
| Create Tags | Y = Create Tags (Checked) N = Don't Create Tags (Not Checked) | char(1) |
| Has MSDS | Y = Has MSDS(Checked) N = No MSDS(Not Checked) | char(1) |
| Period 1 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 2 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 1 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 3 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 4 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 5 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 6 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 7 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 8 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 9 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 10 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 11 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Period 12 Usage | When a figure is entered the sum of the period usages will be placed in the yearly usage field and the average per period will be calculated. | decimal(7,2)+/- |
| Average Period Usage | System generated. Not Imported. | decimal(7,2)+/- |
| Yearly Usage | When individual period usage is supplied this field will be the sum of the period usages. When no period usages are supplied then the figure entered here will be used to calculate the average per period usage and this figure will be distributed evenly among the period usages. | decimal(7,2)+/- |
| Manufacturer A | char(8) | |
| Manufacturer A | char(8) |