Page Comparison

int

number(10)

int

integer

smallint

number(5)

smallint

smallint

tinyint

number(3)
number(1)

smallint

smallint

IDENTITY

SEQUENCE

AUTO_INCREMENT

serial (integer)
smallserial (smallint)

char(*)

char(*)

char(*) character set latin1

char(*)

nchar

nchar(*)

char(*) character set utf8mb4

char(*)

varchar(*)

varchar2(*)

varchar(*) character set latin1

varchar(*)

nvarchar(*)

nvarchar2(*)

varchar(*) character set utf8mb4

varchar(*)

date

date

date

date

datetime

timestamp

datetime

timestamp without timezone

numeric(p,s)

number(p,s)

numeric(p,s)

numeric(p,s)

smallint

NOT NULL

Y

Price number

nvarchar(256)

NULL

Name

datetime

NULL

Update date

*

*

*

The priceline ID in the client ERP system, if it is not compatible with the smallint type.

Used to transfer data between systems.

smallint

NOT NULL

Y

Region number

nvarchar(256)

NULL

Y

Region name

*

*

*

The region ID in the client ERP system, if it is not compatible with the smallint type.

Used to transfer data between systems.

smallint

NOT NULL

Y

Store number. It is desirable that the number that the user sees is filled in here

nvarchar(256)

NOT NULL

Y

Store name

smallint

NOT NULL

Y

Region number from the REGIONS table

smallint

NULL

Price serial number from the PRICELINES table

date

NULL

Store opening date

date

NULL

Store closing date

nvarchar(32)

NULL

Store code from the accounting system. Filled in only if the STORE_ID field is generated and does not match the number that the user sees.

nvarchar(256)

NULL

Store Address

datetime

NULL

Update date

tinyint

NULL

Warehouse sign. Filled in as 1 for warehouses. Stores must be NULL. The value 0 is not allowed.

tinyint

NULL

Store Format Id

char(1)

NULL

Store Format Code (e.g. Mini, Super, Hyper, Warehouse)

*

*

*

The store ID / warehouse ID in the client ERP system, if it is not compatible with the smallint type.

If different table in ERP system used, use a prefix, such as S for stores (S45) and W for warehouses (W2).

Used to transfer data between systems.

smallint

NOT NULL

Y

Group number

nvarchar(256)

NULL

Y

The name of the group of goods. Unique.

nvarchar(32)

NULL

Group code from accounting system

smallint

NULL

Paternal group number (for building hierarchies)

number(12, 2)

NULL

Filled in on the MySales side

number(12, 2)

NULL

Filled in on the MySales side

number(8, 2)

NULL

Filled in on the MySales side

number(10, 2)

NULL

Filled in on the MySales side

datetime

NULL

Update date

*

*

*

The group ID in the client ERP system, if it is not compatible with the smallint type.

Used to transfer data between systems.

int

NOT NULL

Y

Product identifier

smallint

NOT NULL

Y

Group number from the GROUPS table. SKUs are tied to the lowest level of the product hierarchy.

nvarchar(256)

NOT NULL

Y

Name of product. Unique

nvarchar(20)

NULL

Item code from the accounting system. Filled in only if the SKU_ID field is generated and does not match the number that the user sees

smallint

NULLOnly for replenishment

Supplier identifier from SUPPLIERS table.
()

number(10, 2)

NULL

Purchase price WITHOUT value added tax

number(10, 2)

NULL

Filled in on the MySales side

number(10, 2)

NULL

Filled in on the MySales side

number(10, 2)

NULL

Filled in on the MySales side

number(10, 2)

NULL

Filled in on the MySales side

smallint

NULL

Required for Replenishment

Total expiration period, in days.

(Expiration date minus production date)

number(10, 3)

NULL

Only for Reorder Point

Multiplicity of orders for DC

number(10, 3)

NULL

Only for Reorder Point

Minimum order quantity

nvarchar(10)

NULLY

unit of measurement

datetime

NULL

insert or update date

number(5, 2)

NULL

Only for Price Optimisation

% vat on value added purchases. If %=0 then put 0

number(10, 3)

NULL

Only for Replenishment

Product weight, kg

number(10, 3)

NULL

Product volume, l

number(6, 2)

NULL

Product height, см

number(6, 2)

NULL

Product width, cm

number(6, 2)

NULL

Product length, cm

*

*

*

The product ID in the client ERP system, if it is not compatible with the int type.
Used to transfer data between systems.

smallint

NOT NULL

Y

Supplier identifier

nvarchar(9)

NULL

Supplier code in the ERP system

nvarchar(256)

NULL

Y

Supplier name

datetime

NULL

Update date

*

*

*

The supplier ID in the client ERP system, if it is not compatible with the smallint type.
Used to transfer data between systems.

smallint

NOT NULL

Y

Contract identifier

smallint

NOT NULL

Y

Supplier identifier from SUPPLIERS.SUPPLIER_ID

nvarchar(9)

NULL

Contract number in the accounting system

nvarchar(256)

NULL

Contract name or description

nvarchar(5)

NULL

Currency code

datetime

NULL

Update date

*

*

*

The contract ID in the client ERP system, if it is not compatible with the smallint type.
Used to transfer data between systems.

smallint

NOT NULL

Y

Manager identifier

nvarchar(120)

NOT NULL

Y

Manager name

nvarchar(100)

NULL

e-mail

nvarchar(50)

NULL

Phone number

datetime

NULL

Update date

*

*

*

The manager ID in the client ERP system, if it is not compatible with the smallint type.
Used to transfer data between systems.

nvarchar(10)

NOT NULL

Y

To order your own imports and optimize logistics

nvarchar(10)

NOT NULL

Y

Unit type: BASE - Base BASE_X - Base derivative BASE_A - Base, alternative COM - Commercial (no conversion units)

nvarchar(10)

NOT NULL

Y

Unit class for base (BASE) PIECE, WEIGHT, VOLUME, LENGTH, SQ

smallint

NOT NULL

Y

Accuracy, number of characters

numeric(10,5)

NOT NULL

Y

Calculation coefficient (x = 12 means 1 box = 12 pcs)

nvarchar(10)

NOT NULL

Y

Link to recalculation (UOM)

nvarchar(10)

NOT NULL

Y

Recalculation to base unit of measure

nvarchar(15)

NOT NULL

Y

Name of the unit of measurement

datetime

NULL

Date of change

*

*

*

The UOM ID in the client ERP system, if it is not compatible with the nvarchar(*) type.
Used to transfer data between systems.

int

NOT NULL

Y

Product identifier from PRODUCTS.SKU_ID

nvarchar(10)

NOT NULL

Y

Unit Reference (Table UOM_CLASSES.UOM)

nvarchar(10)

NOT NULL

Y

Name - for example, for piece goods

numeric(10,5)

NOT NULL

Y

Conversion factor for derived units = X/Y

numeric(10,5)

NOT NULL

Y

Conversion factor for derived units = X/Y

nvarchar(10)

NOT NULL

Y

Reference to the unit of conversion

numeric(10,3)

NOT NULL

Y

Quantity from the base unit of measurement - calculated value

numeric(10,3)

NULL

Net weight - filled in for the base unit of measure only

numeric(10,3)

NULL

Net volume - filled in for the base unit of measure only

numeric(10,3)

NULL

Gross weight - logistics - filled in for all units of measure

numeric(10,3)

NULL

Gross volume - logistics - filled in for all units of measure

numeric(8,3)

NULL

Length (overall length - logistics)

numeric(8,3)

NULL

Width (overall width - logistics)

numeric(8,3)

NULL

Height (Overall height - logistics)

int

NULL

The user who made the changes

datetime

NULL

Date of change

*

*

*

Used to transfer data between systems.

int

Order identifier / number created by MySales

smallint

Store identifier from STORES.STORE_ID

*

STORES.CLIENT_CODE

smallint

Supplier identifier from SUPPLIERS.SUPPLIER_ID

*

SUPPLIERS.CLIENT_CODE

smallint

Contract identifier from CONTRACTS.CONTRACT_ID

*

CONTRACTS.CLIENT_CODE

smallint

Warehouse identifier from STORES.STORE_ID

*

STORES.CLIENT_CODE

int

Оnly for cross-dock store orders.

Warehouse order identifier / number for cross-dock combined order

int

Оnly for push orders.

Push identifier / number RPM_PUSH.ID

int

Оnly if the order with the additional load period.

Additional load identifier / number from RPM_ADD.ID

date

Order Date

date

Planned Delivery Date

varchar(5)

Sign of a split order: pz - pick to zero, pr - promo, pzpr - pick to zero promo, t - tender, pzt - pick to zero tender, prt - promo tender

varchar

Order identifiers / numbers of stores cross-dock warehouse order

int

Product identifier from PRODUCTS.SKU_ID

*

PRODUCTS.CLIENT_CODE

smallint

Manager identifier for the product / store from
EXT_MANAGER.ID

EXT_MANAGER.CLIENT_CODE

number(11,2)

Order Quantity

datetime

Last modified order date