Imports - Parts Import Information

Facility

Must Match Existing Facility

int(5)

Part Number

Create New - just needs to be within character limit and adhere to character restrictions

Update - Must match existing Part Number within facility selected

char(25)

Primary Vendor

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. Should have a map ability to map to existing codes

If a match is not found the part will be added with a part type of Part.

char(2)

Account Code

If they have the switch set to Validate, it must match an existing 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)

Stock Flag

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)

Last Purchase Date

date

Last Receive Date

date

Last Invoice Date

date

Manufacturer A

char(8)

Manufacturer B

char(8)

Back Order Date

date

Back Order Quantity

decimal(6,2)

On Order Quantity

decimal(6,2)

Stock Area A Quantity

decimal(6,1)

Stock Area A Bin

char(10)

Stock Area B Quantity

Only allow if they have system switch to allow up to 2 stock areas

decimal(6,1)

Stock Area B Bin

Only allow if they have system switch to allow up to 2 stock areas

char(10)

Stock Area C Quantity

Only allow if they have system switch to allow up to 3 stock areas

decimal(6,1)

Stock Area C Bin

Only allow if they have system switch to allow up to 3 stock areas

char(10)

Stock Area D Quantity

Only allow if they have system switch to allow up to 4 stock areas

decimal(6,1)

Stock Area D Bin

Only allow if they have system switch to allow up to 4 stock areas

char(10)

Stock Area E Quantity

Only allow if they have system switch to allow up to 5 stock areas

decimal(6,1)

Stock Area E Bin

Only allow if they have system switch to allow up to 5 stock areas

char(10)

Yearly Usage

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