Load SOAFORWARD
When loading a file using the SOAFORWARD import job, the SOAFORWARD job will only register a new Purchase order response (SOA) item if there are changes to the item that require a new Purchase order response (SOA) item to be registered. This could be a change to the confirmed/requested date, quantity or change in price. If there are no changes to these fields, there will not be created a new Purchase order response (SOA) item.
Possible fields to be loaded into RamBase are listed in the Field-column in the following table. The other columns in this table provide additional information about each field.
Field | Required | Length | Example | Description |
|---|---|---|---|---|
PURCHASEORDERID | Y | SPO/100000-1 | Must contain either case or source of SOA/SPO item that should be forwarded. | |
PRODUCT | Y* | Product name. * Either PRODUCT or SUPPLIERPRODUCTNAME is mandatory. | ||
SUPPLIERSPRODUCTNAME | Y* | Suppliers product name. * Either PRODUCT or SUPPLIERPRODUCTNAME is mandatory. | ||
BUYERSREFERENCENUMBER | Buyers reference number. | |||
CONFIRMEDDELIVERYDATE | Confirmed delivery date. | |||
NETPRICE | Purchase price. | |||
NOTE | Note on the SOA item. | |||
QUANTITY | Quantity to be forwarded. | |||
REQUESTEDDELIVERYDATE | Used to find (prioritize, does not need to match) item to forward (not updated when forwarded). | |||
SUPPLIERSREFERENCENUMBER | Suppliers reference number. |