Parts Import/Export
This program exports your Parts records into a tab 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) |
| Part Number | Required | char(25) |
| Primary Vendor | Required | int(10) |
| Vendor Part Number | char(25) | |
| Part Description | char(40) | |
| Part Type | Should match one of the part type codes listed in SSY Part Types tab. If a match is not found the part will be added with a part type of Part. | char(2) |
| Account Code | char(25) | |
| Major VMRS | int(3) | |
| Intermediate VMRS | int(3) | |
| Minor VMRS | int(3) | |
| Bin Number | char(10) | |
| Average Price | decimal(7,3) | |
| Sell Lock Flag | Y = True/Checked N = False/Unchecked | char(1) |
| Mark Up | Only applicable if sell lock flag = N Otherwise is auto-adjusted | decimal(0,3)+/- |
| Sell Price | Only applicable if sell lock flag = Y Otherwise is auto-adjusted | decimal(7,3) |
| Stockable | Y = True/Checked N = False/Unchecked | char(1) |
| Chargeable | Y = True/Checked N = False/Unchecked | char(1) |
| Consignment | Y = True/Checked N = False/Unchecked | char(1) |
| Issue Unit | char(3) | |
| Average Ship Days | int(4) | |
| Re-order Point | Only applicable if lock re-order flag = Y Otherwise is auto-adjusted | int(5) |
| Re-order Quantity | Only applicable if lock re-order flag = Y Otherwise is auto-adjusted | int(5) |
| Lock Re-order | Y = True/Checked N = False/Unchecked | char(1) |
| BO PO Facility | int(5) | |
| BO PO Number | char(10) | |
| Last PO Facility | int(5) | |
| Last PO Number | char(10) | |
| Last PO Extension | int(4) | |
| Last Invoice | char(12) | |
| BO Date | date | |
| Last Purchase Date | date | |
| Last Receive Date | date | |
| Last Invoice Date | date | |
| Manufacturer A | char(8) | |
| Manufacturer B | char(8) | |
| BO Quantity | decimal(6,2) | |
| On Order Quantity | Add part only. Will not update existing | decimal(6,2) |
| Stock Area A Quantity | decimal(6,1) | |
| Stock Area A Bin | char(10) | |
| Stock Area B Quantity | decimal(6,1) | |
| Stock Area B Bin | char(10) | |
| Stock Area C Quantity | decimal(6,1) | |
| Stock Area C Bin | char(10) | |
| Stock Area D Quantity | decimal(6,1) | |
| Stock Area D Bin | char(10) | |
| Stock Area E Quantity | decimal(6,1) | |
| Stock Area E Bin | char(10) | |
| Period 1 Usage | decimal(7,2) | |
| Period 2 Usage | decimal(7,2) | |
| Period 3 Usage | decimal(7,2) | |
| Period 4 Usage | decimal(7,2) | |
| Period 5 Usage | decimal(7,2) | |
| Period 6 Usage | decimal(7,2) | |
| Period 7 Usage | decimal(7,2) | |
| Period 8 Usage | decimal(7,2) | |
| Period 9 Usage | decimal(7,2) | |
| Period 10 Usage | decimal(7,2) | |
| Period 11 Usage | decimal(7,2) | |
| Period 12 Usage | decimal(7,2) | |
| Yearly Usage | If no value entered Total of periods 1 - 12 will by used If value entered will overwrite period usages distributing yearly usage evenly | decimal(7,2) |
| Track Warranty | Y = True/Checked N = False/Unchecked | char(1) |
| Create Tags | Y = True/Checked N = False/Unchecked | char(1) |
| Has MSDS | Y = True/Checked N = False/Unchecked | char(1) |
| Classification | char(12) | |
| Track Core | Y = True/Checked N = False/Unchecked | char(1) |
| Core Part Number | char(25) | |
| Warranty Miles | decimal(6,1) | |
| Warranty Months | int(3) | |
| Last Updated Date | date | |
| Current Period Miles | decimal(9,1) | |
| YTD Miles | decimal(9,1) | |
| LTD Miles | decimal(9,1) | |
| Current Period Months | int(5) | |
| YTD Months | int(5) | |
| LTD Months | int(5) | |
| Current Period Cost | decimal(7,4) | |
| YTD Cost | decimal(7,4) | |
| LTD Cost | decimal(7,4) |