Load Product Account
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.
At least one of the fields PRODUCTID, PRODUCTNAME and EXTERNALPRODUCTID must be provided to identify the product.
|
Field |
Required |
Length |
Example |
Description |
|
PRODUCTID |
Y* |
#100000 |
The Product ID assigned by Rambase. *If PRODUCTNAME is not a unique value you must use PRODUCTID or EXTERNALPRODUCTID. |
|
|
PRODUCTNAME |
Y* |
Mobile phone |
The name of the product (Part). *If PRODUCTNAME is not a unique value you must use PRODUCTID or EXTERNALPRODUCTID. |
|
|
EXTERNALPRODUCTID |
Y* |
123456 |
The product external ID. *If PRODUCTNAME is not a unique value you must use PRODUCTID or EXTERNALPRODUCTID. |
|
|
ACCKEY |
Y |
HOMESALE |
Account key. Valid options: HOMESALE, VATSALE, EUSALE, EXPSALE, XMSALE, HOMEPURC, VATPURCH, EUPURC, EXPPURC and XMPURC. Possible to specify multiple values using a commalist, e.g. "HOMESALE,VATSALE". Unique key for account record. |
|
|
ACCCODE |
Y** |
1030 |
General Ledger (GL) account number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. |
|
|
DEPNO |
Y** |
1000 |
Department number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. |
|
|
PRJNO |
Y** |
1001 |
Project number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. |
|
|
ASTNO |
Y** |
1003 |
Asset number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. |
|
|
VATCODE |
00 |
Value added tax code. |
||
|
DIM4 |
Dimension 4 |
|||
|
DIM5 |
Dimension 5 |
|||
|
DIM6 |
Dimension 6 |
|||
|
DIM7 |
Dimension 7 |
|||
|
DIM8 |
Dimension 8 |
|||
|
DIM9 |
Dimension 9 |
|||
|
DIM10 |
Dimension 10 |