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

NULL

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)

NULL

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.

int

NOT NULL

Y

Product identifier from PRODUCTS.SKU_ID

smallint

NOT NULL

Y

Store identifier from STORES.STORE_ID

date

NOT NULL

Y

Date of sale/stock

number(10, 3)

NULL

Y

The amount of units sold in natural units, pcs, kg, liters, and others

number(10, 2)

NULL

Y

SALES_VALUE: The total amount of sales at the checkout minus returns (including VAT). Amounts paid by bonuses and coupons must be excluded. If the total SKU/STORE/DATE amount is negative, fill with 0 (zero)

number(8, 2)

NULLY

DISCOUNT_VALUE: The total amount of the discount (including VAT) granted for promotions. E.g. promotions with combined mechanics (for example, 1+1=3, buy 1 and get a discount on the second, and others) must be distributed for all 3 skus. Example: Buy 1 and get 50% discount for second means 100 + 70 * 50% = 135. First SKU discount: 100 - 135100/(100+70) = 20.59, Second SKU discount: 70 - 13570/(100+70) = 14.41

number(10, 3)

NULL

Y

Balance at the end of the day in natural units. It is also necessary to fill in for those days where there were no sales (except for days with a zero balance). For new positions, it is filled from the day of the first sale.

number(12, 2)

NULL

Balance amount (for analytics)

number(10, 3)

NULL

Reserved for MySales

number(10, 3)

NULL

Y

The amount of goods receipts in quantitative terms pcs. kg liters and others

number(8, 3)

NULL

The amount of units used in production (in natural units, kg, liters and others)

number(10, 3)

NULL

Wholesale quantity.
Populated by the provided update request

number(10, 3)

NULL

Wholesale amount.
Populated by the provided update request

number(3,2)

NULL

The share of presence on the balance. To be completed during the second phase of MySales implementation. It is necessary to take into account the time of presence on the balance for culinary and other goods, which always go to zero at the end of the day

number(10, 3)

NULL

The volume of goods sold due to expiring shelf days period

number(10, 3)

NULL

The amount of goods sold due to expiring shelf days period

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