| id |
integer |
Yes |
Yes |
nextval('inventory_promo_codes_id_seq'::regclass) |
Unique identifier |
| promo_code |
character varying(25) |
No |
No |
|
Promotional or price reason code |
| description |
character varying(35) |
No |
No |
|
Description of promotion |
| color_text |
bigint |
No |
No |
|
Text colour code for display |
| color_back |
bigint |
No |
No |
|
Backround colour code for display |
| cumulative |
boolean |
No |
No |
|
Price 'Cumulative' flag; FALSE = No TRUE = Yes |
| _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 |