Load Product Account (ARTACCLOAD) - INP/63678
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 |
|---|---|---|---|---|
ACCCODE | Y** | 1030 | General Ledger (GL) account number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. | |
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. | |
ASTNO | Y** | 1003 | Asset number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. | |
DEPNO | Y** | 1000 | Department number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. | |
DIM10 | Dimension 10 | |||
DIM4 | Dimension 4 | |||
DIM5 | Dimension 5 | |||
DIM6 | Dimension 6 | |||
DIM7 | Dimension 7 | |||
DIM8 | Dimension 8 | |||
DIM9 | Dimension 9 | |||
EXTERNALPRODUCTID | Y* | 123456 | The product external ID. *If PRODUCTNAME is not a unique value you must use PRODUCTID or EXTERNALPRODUCTID. | |
PRJNO | Y** | 1001 | Project number. **ACCCODE, DEPNO, PRJNO or ASTNO must have a value. | |
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. | |
VATCODE | 00 | Value added tax code. |