Load Customer quotes (CQU) - INP/52194
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 |
ACCOUNT | Y* | 100168 | Customer identifier. *ACCOUNT or ACCOUNTEXTID must have a value | |
ACCOUNTEXTID | Y* | CUS-9812 | The customer external ID. *ACCOUNT or ACCOUNTEXTID must have a value | |
BUFQTY | 100 | Buffer quantity. | ||
CUR | Y | NOK | Currency. The value must be valid for the given customer. | |
QTY | Y | 10 | Quoted quantity | |
PART | Y* | EP1K50TC144-1 | Product name. Must exist in the article archive. *PART/MFR, CUSPART or PARTEXTID is used to identify the correct product. | |
PARTEXTID | Y* | External identifier for the part. *PART/MFR, CUSPART or PARTEXTID is used to identify the correct product. | ||
MFR | Y* | ACME | Manufacturer. *PART/MFR or CUSPART is used to identify the correct product. | |
PRICE | Y | 159 | Quoted price in given currency. | |
EXPIRE | Y** | YYYY.MM.DD | Date that a specific item in the quote is valid to. **VALIDFORM or EXPIRE must have a value. | |
VALIDFROM | Y** | YYYY.MM.DD | Date that a quote is valid from. **VALIDFORM or EXPIRE must have a value. | |
VALIDTO | YYYY.MM.DD | Date that the quote is valid to. If not defined, it will get a default value configured for the company. | ||
YOURNO | HLD/12345 | Customer quote number. | ||
YOURREF | John Doe | Customer quote reference, typically a person. | ||
SQUREF | ||||
CUSPART | Y* | Electric component A | Customer product name. Must exists as a customer product name associated with the customer on a product. *PART/MFR, CUSPART or PARTEXTID is used to identify the correct product. | |
LOC | 3 | OSL | Location |