Part Kit Master Import and Export
This program exports your Part Kit Master records into a delimited text file. This file can then be edited manually or via a spreadsheet program, and then re-imported into the RTA system to update any changes made.
Import Options:
Create New
Checked - New records will be created
Unchecked - New Records WILL NOT be created
Update Existing
Checked - Existing records will be updated
Unchecked - Existing Records WILL NOT be updated
Import Field Definitions
| 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 N = Don't Create Tags (Default) | char(1) |
| Has MSDS | Y = Has MSDS N = No MSDS (Default) | 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 B | char(8) |