| id |
integer |
Yes |
Yes |
nextval('sales_taxes_id_seq'::regclass) |
Unique identifier |
| tax_no |
smallint |
No |
No |
|
Tax code created by user |
| name |
character varying(60) |
No |
No |
|
Tax name or description |
| rate |
numeric(7,4) |
No |
No |
|
Tax rate to apply |
| gl_account |
character varying(24) |
No |
No |
|
General Ledger tax liability accouunt |
| short_name |
character varying(20) |
No |
No |
|
Tax short name to use on forms |
| use_partial_rate |
boolean |
No |
No |
|
Partial tax rate allowed flag; TRUE = Yes FALSE = No |
| partial_rate |
numeric(7,4) |
No |
No |
|
Partial tax rate |
| _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 |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |
| freight |
boolean |
No |
No |
false |
Tax applicable to freight flag; FALSE = No TRUE = Yes |
| surcharge |
boolean |
No |
No |
true |
Tax applicable to surcharges flag; FALSE = No TRUE = Yes |
| include_landed |
boolean |
No |
No |
true |
Include tax to Purchase Order landed cost flag; FALSE = No (tax is recoverable) TRUE = Yes (tax is added to purchase cost) |
| gl_credit_account |
character varying(24) |
No |
No |
|
General Ledger account for recoverable tax - Input Tax Credit account |