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  | 
  | 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 
 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 
  | 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 
  | char(1)  |