Load Supplier Quotes (SQU)
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 |
CUR |
Y |
NOK |
Currency. The value must valid for the given supplier. |
|
PART |
Y |
EP1K50TC144-2 |
Product name. Must exist in the article archive. PART and MFR are used to identify the correct product. |
|
MFR |
Y |
ACME |
Manufacturer. |
|
PRICE |
Y |
168.00 |
Quoted price in given currency. |
|
ACCOUNT |
10278 |
Supplier Identifier. |
||
YOURNO |
Supplier quote number. |
|||
YOURREF |
John Doe |
Supplier reference, typically a person. |
||
VALIDFROM |
2003.03.17 |
Date that the quote is valid from. Can be overruled on each item by value in EXPIRE. |
||
VALIDTO |
2004.03.05 |
Date that the quote is valid to. |
||
ISSHIPANDDEBIT |
1 |
1 |
Valid options are "0" and "1", should be set to "1" if it is a Ship & Debit quote. It is automatically set to "0" which means that the system will understand it as an ordinary quote. |
|
QTY |
5040 |
Quoted quantity. |
||
EXPIRE |
2015.06.30 |
Date that a specific item in the quote is valid to. |
||
CUSTOMER |
TEM-NO:CUS/10246 |
Customer to be supplied if the supplier quote is valid for one customer only. |