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 |