Imports - Purchase Order Transaction Import Information

Field

Value

Type/Size

Required for Create New

Required for Update

Update Allowed

PO Facility

Must Match existing facility

int(5)

  •  
  •  
  •  

PO Number

 

char(10)

  •  
  •  
  •  

PO Extension

When not Specified

Default is 0000

If PO is a blanket PO this number will be generated by the system and will override the entered number.

int(4)

  •  
  •  
  •  

PO Line Number

Switch (SSM-P #8) Determines max number of lines allowed on PO.

Lines will go in sequential order if doing a create new

int(2)

  •  
  •  
  •  

PO Line Status

“Y” = Line Complete

“P” = Line Partially Recieved

“N” or blank - Line Open

char(1)

  •  
  •  
  •  

Line Deleted Flag

  • "D" = Line Deleted

  • blank = Line not deleted

Char(1)

  •  
  •  
  •  

Part Number

Required

 Char(25)

  •  
  •  
  •  

Vendor Xref

Vendors Part numb 

 Char(25)

  •  
  •  
  •  

Description

 Not Editable for File Parts (Will skip over if filled out)

Char(40)

  •  
  •  
  •  

Manufacturer

 Not Editable for File Parts

Char(5)

  •  
  •  
  •  

Issue Unit

 Not Editable for File Parts

Char(5)

  •  
  •  
  •  

Bin Number

Not Editable for File Parts

 Char(10)

  •  
  •  
  •  

SIC Code

 if left empty switch (SSM-P #20) default SIC code will be used.

Char(6)

  •  
  •  
  •  

Part on File Flag

 "Y" = Part is on file

  • "N" = Part is a non-file part

if adding line will be defaulted to "Y" for  file part  or to "N" for non-file part

char(1)

  •  
  •  
  •  

Order Quantity

 

 decimal(7,4)

  •  
  •  
  •  

Original Order Quantity

 

decimal(7,4)

  •  
  •  
  •  

Order Price

 decimal(9,4)

  •  
  •  
  •  

Line Taxable Flag

 "Y" or "V" = Line taxable at Vendor tax rate

  • "F" = Line taxable at Facility tax rate

  • "N" = Not taxable

 char(1)

  •  
  •  
  •  

Freight

 

 decimal(9,4)

  •  
  •  
  •  

Line Billed Flag 

 

 Char(1)

  •  
  •  
  •  

Account Number

 If file part

when Switch (SSM-P #36) = "Y" or "V"

  if spaces will use Part's account code

when Switch (SSM-P #36) = "N"

if spaces will use default account code (SSM-P #37)

 Char(25)

  •  
  •  
  •  

WO Facility 

 

int(5)

  •  
  •  
  •  

WO Number

 

char(7)

  •  
  •  
  •  

WO Line

When not specified

default is switch "Po Prefix (SSM-P #17)

 int(2)

  •  
  •  
  •  

Requisition 

When not specified

default is switch "Po Suffix (SSM-P #18)

 char(10)

  •  
  •  
  •  

Freight Received Flag

 "Y" = Freight received on this line

  • Spaces = Freight not received

char(1) 

  •  
  •  
  •