Load Customer Quotes (CQU)
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 |