Knowledge Center

ACCOUNT

Customer Id. Unique number created by RamBase. This is not required.

CUSTOMERSPRODUCTNAME

Y

The customer's name of the product, If neither product id nor product name is provided, the customer can upload the customers product name. This requires an account to be also provided. RamBase searches the product archive based on the customer's product name and the customer account. An error is logged if no match is found.

CUSTOMERSREFERENCE

The customers reference, e.g.: SPO/12345 (any string).

CUSTOMERSREFERENCENO

The customers reference number, e.g.: SFC/112233 (any string).

LOC

Location of the forecast, e.g.: VAT. If LOC is not provided it will be set to LOC from the COM archive. The location will be validated against the database and an error is logged if no location is found.There is also a limitations that there can not be a mix of locations in the file – only one.

PROBABILITY

The probability, in percentage, of receiving a firm order, e.g.: 65.

PRODUCTID

Y

The identification of the product, e.g.: #123456 If a productid is provided it will be checked against the database to see if it exists. The job will log an error if no products are found.

PRODUCTNAME

Y

The name of a product, You do not have to give a product id, a product name is enough. RamBase searches the product archive with the provided name. If the product can not be found the job logs an error.

QUANTITY

Y

The number of products, e.g.: 10. This field is required.

REQUESTEDDATE

Y

The requested delivery date for the product. This date is used for further planning in Sales and operation planning (SOP). Use the formats DD.MM.YYYY, DD-MM-YYYY, YYYY.MM.DD, YYYY-MM-DD.

SHIPPINGADDRESSID

Refers to a specific shipping address for the customer, e.g.: If the field is given, it is validated along with the provided account. If no shipping address with this identifier is located in the provided customer account, then an error is logged.