NameDescriptionTypeAdditional information
id

globally unique identifier

None.

id_mask

string

Required

Max length: 10

name

string

Required

Max length: 20

description

string

Max length: 200

date_from

date

Required

date_end

date

Required

by_amt

boolean

Required

by_pcg

boolean

Required

ap_amount

decimal number

None.

ap_percent

decimal number

None.

ap_price

decimal number

None.

ap_price_min

decimal number

None.

ap_price_max

decimal number

None.

id_branch

globally unique identifier

Required

id_pos

globally unique identifier

None.

id_list

globally unique identifier

None.

id_item

globally unique identifier

None.

id_item_type

globally unique identifier

None.

id_category

globally unique identifier

None.

by_day_week

boolean

Required

use_mon

boolean

Required

use_tue

boolean

Required

use_wed

boolean

Required

use_thu

boolean

Required

use_fri

boolean

Required

use_sat

boolean

Required

use_sun

boolean

Required

use_hour_ini

time interval

None.

use_hour_end

time interval

None.

active

boolean

Required

created_on

date

None.

last_update

date

None.

id_user_upd

globally unique identifier

None.

commited

boolean

None.

mt_branches

mt_branches

None.

mt_categories

mt_categories

None.

mt_items

mt_items

None.

mt_items_types

mt_items_types

None.

mt_pos

mt_pos

None.

mt_prices_list

mt_prices_list

None.

st_users

st_users

None.