[en] Knowledge Center

[en] ACCOUNT

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

[en] PRODUCTID

[en] 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. This field is required.

[en] PRODUCTNAME

[en] 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. This field is required.

[en] CUSTOMERSPRODUCTNAME

[en] 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. This field is required.

[en] QUANTITY

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

[en] REQUESTEDDATE

[en] 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. This field is required.

[en] LOC

[en] 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.

[en] PROBABILITY

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

[en] CUSTOMERSREFERENCE

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

[en] CUSTOMERSREFERENCENO

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

[en] SHIPPINGADDRESSID

[en] 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.