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 |