| id |
integer |
Yes |
Yes |
nextval('inventory_levy_codes_id_seq'::regclass) |
Unique identifier |
| code |
character varying(3) |
No |
No |
|
Levy code |
| name |
character varying(60) |
No |
No |
|
Levy name or description |
| amt_or_pct |
boolean |
No |
No |
|
Levy calculation method is amount; FALSE = Percentage TRUE = Amount |
| rate |
numeric(9,3) |
No |
No |
|
Amount or percentage charged on each item |
| gl_account |
character varying(24) |
No |
No |
|
General Ledger account to use when posting Levy charges |
| _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 |
| tax_flag |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Taxable flags for four taxes; FALSE = No TRUE = Yes |