id |
integer |
Yes |
Yes |
nextval('shipping_methods_id_seq'::regclass) |
Unique identifier |
code |
character varying(10) |
No |
No |
|
Shipping method code |
description |
character varying(60) |
No |
No |
|
Shipping method description |
freight_taxable |
boolean |
No |
No |
|
Shipping method taxable flag; FALSE = No TRUE = Yes |
freight_type |
character varying(1) |
No |
No |
|
Freight Type; A = Fixed amount P = Prompt each time R = Percentage on sales |
freight_threshold |
numeric(15,2) |
No |
No |
|
Threshhold for no charge freight |
freight_rate |
numeric(5,2) |
No |
No |
|
Freight rate percent or amount |
freight_min |
numeric(15,2) |
No |
No |
|
Minimum freight to charge |
freight_max |
numeric(15,2) |
No |
No |
|
Maximum freight to charge |
_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 |