| id |
integer |
Yes |
Yes |
nextval('inventory_product_codes_id_seq'::regclass) |
Unique identifier |
| product_code |
character varying(10) |
No |
No |
|
Product code of this product group |
| description |
character varying(80) |
No |
No |
|
Product group description |
| default_margin |
numeric(9,2) |
No |
No |
|
Low margin limit to to trigger low margin alert |
| sub_category |
boolean |
No |
No |
|
Not used ecommerce field |
| top_category_code |
character varying(10) |
No |
No |
|
Not used ecommerce field |
| code_sequence_no |
numeric(7) |
No |
No |
|
Not used ecommerce field |
| code_page_size |
numeric(3) |
No |
No |
|
Not used ecommerce field |
| code_display_type |
character varying(17) |
No |
No |
|
Not used ecommerce field |
| sales_acct |
integer |
No |
No |
|
Default sales department normally used for this product group |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| surcharge_pct |
numeric(7,2) |
Yes |
No |
|
Surcharge or shop supply percentage to charge for this product code |
| discount_code |
character varying(1)[] |
Yes |
No |
'{" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "}'::character varying[] |
|
| discount_mode |
smallint[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::smallint[] |
|
| discount_pct |
numeric(7,4)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| discount_amt |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |