Skip to main content

Knowledge Center

Load Product account - 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

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