id |
integer |
Yes |
Yes |
nextval('inventory_promo_codes_id_seq'::regclass) |
|
promo_code |
character varying(25) |
No |
No |
|
Promo or reason code |
description |
character varying(35) |
No |
No |
|
Description of promo code |
color_text |
bigint |
No |
No |
|
Test color. This color wil appear on the sales order line to make it stand out. |
color_back |
bigint |
No |
No |
|
Backround color. This color wil appear on the sales order line to make it stand out. |
cumulative |
boolean |
No |
No |
|
Is this price 'Cumulative' with other promo codes TRUE = Yes FALSE = No |
_dbversion |
integer |
No |
No |
|
|
_created |
timestamp without time zone |
No |
No |
|
|
_created_by |
character varying(3) |
No |
No |
|
|
_modified |
timestamp without time zone |
No |
No |
|
|
_modified_by |
character varying(3) |
No |
No |
|
|