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) |