Load Purchase order (SPO)
You find it by typing the RamBase command: "INP/72500". By using this you may upload purchase orders (SPO) to the system.
Field | Required | Length | Example | Description |
|---|---|---|---|---|
SUPPLIERID | Y* | Supplier account. * Either SUPPLIERID or SUPPLIERSECTERNALREFERENCE must be specified. If both are included in the file, SUPPLIERID will be used. | ||
SUPPLIERSEXTERNALREFERENCE | Y* | Suppliers external reference * Either SUPPLIERID or SUPPLIERSECTERNALREFERENCE must be specified. If both are included in the file, SUPPLIERID will be used | ||
CURRENCY | Y | Currency of the purchase order | ||
SUPPLIERSREFERENCENUMBER | Suppliers reference number e.g. quote number | |||
PRODUCTID | Product Id (IT) | |||
PRODUCTNAME | Product name. Either product id or product name must exist on a line | |||
SUPPLIERSPRODUCTNAME | Suppliers product name | |||
QUANTITY | Y | Quantity to purchase | ||
REQUESTEDDATE | Y | Requested date. | ||
NETPRICE | Purchase price. | |||
MPN | MPN, if MPN is provided also Manufacturer is required. | |||
MANUFACTURER | Manufacturer. | |||
NOTE | Note on the SPO item | |||
ACCNO | Account Id (Will override ACCCODE if both are given) | |||
ACCCODE | Account number | |||
TYPE | Type of Purchase Order. Must be blank or “REQUISITION” | |||
DEPNO | Department number | |||
PRJNO | Project number | |||
ASTNO | Asset number | |||
PRODUCTSEXTERNALREFERENCE | Products external reference | |||
VATCODE | Value added tax code | |||
DIM4 | Dimension 4 | |||
DIM5 | Dimension 5 | |||
DIM6 | Dimension 6 | |||
DIM7 | Dimension 7 | |||
DIM8 | Dimension 8 | |||
DIM9 | Dimension 9 | |||
DIM10 | Dimension 10 |