Skip to main content

Knowledge Center

Load Purchase order (SPO) - INP/72500

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