Table Data dictionary report - sales_order_archives

Generated: 9/23/2016 3:03:55 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('sales_order_archives_id_seq'::regclass)
order_no character varying(10) No No
cust_no character varying(20) No No
cust_name character varying(60) No No
status character varying(1) No No
order_date date No No
division character varying(3) No No
location character varying(24) No No
profit_centre character varying(24) No No
territory_code character varying(10) No No
salesperson_no character varying(10) No No
cust_po_no character varying(20) No No
ship_code character varying(10) No No
required_date date No No
ship_carrier character varying(20) No No
ship_track_id character varying(50) No No
terms_code character varying(10) No No
terms_description character varying(60) No No
terms_days_before_due smallint No No
terms_days_allowed smallint No No
terms_discount_rate numeric(5,2) Yes No
hold boolean No No
fob character varying(20) No No
ref_no character varying(20) No No
invoice_no character varying(10) No No
invoice_date date No No
inv_date_rrule character varying(120) No No
batch_no bigint No No
was_quote boolean No No
orig_quote_no character varying(10) No No
ship_id character varying(20) No No
currency character varying(3) No No
currency_rate_method character varying(1) No No
currency_rate numeric(13,7) Yes No
has_serialized_items boolean No No
discount numeric(5,2) Yes No
subtotal numeric(15,2) Yes No
total_discount numeric(15,2) Yes No
freight numeric(15,2) Yes No
sales_tax numeric(15,2) Yes No
gross_profit numeric(15,2) Yes No
total_current_cost numeric(15,2) Yes No
total_average_cost numeric(15,2) Yes No
total numeric(15,2) Yes No
total_payments numeric(15,2) Yes No
backordered boolean No No
total_surcharge numeric(15,2) Yes No
user_surcharge boolean No No
pack_date date No No
pack_init character varying(3) No No
processebyuser character varying(3) No No
invoicedbyuser character varying(3) No No
subtotal_ordered numeric(15,2) Yes No
total_discount_ordered numeric(15,2) Yes No
freight_ordered numeric(15,2) Yes No
sales_tax_ordered numeric(15,2) Yes No
gross_profit_ordered numeric(15,2) Yes No
current_cost_ordered numeric(15,2) Yes No
average_cost_ordered numeric(15,2) Yes No
total_ordered numeric(15,2) Yes No
backorder_created boolean No No
skip_validation boolean No No
cr_approve_amt numeric(15,2) No No
cr_approve_date date No No
cr_approve_user character varying(3) No No
user_type character varying(10) No No
job_no character varying(10) No No
job_acct_no character varying(10) No No
phase_id character varying(20) No No
contact_name character varying(60) No No
contact_phone character varying(30) No No
contact_fax character varying(30) No No
last_inv_no character varying(10) No No
last_inv_date date No No
contact_phone_type smallint No No
contact_fax_type smallint No No
contact_email character varying(254) No No
total_weight numeric(15,2) No No
order_type character varying(1) No No
ship_date date No No
standard_cost_ordered numeric(15,5) Yes No
del_by character varying(3) No No
_dbversion integer No No
_created timestamp without time zone No No
_created_by character varying(3) No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No
sales_tax_rate numeric(7,4)[] Yes No '{0,0,0,0}'::numeric[]
sales_tax_applicable numeric(15,2)[] Yes No '{0,0,0,0}'::numeric[]
sales_tax_total numeric(15,2)[] Yes No '{0,0,0,0}'::numeric[]
sales_tax_applicable_ordered numeric(15,2)[] Yes No '{0,0,0,0}'::numeric[]
sales_tax_total_ordered numeric(15,2)[] Yes No '{0,0,0,0}'::numeric[]
processed_date timestamp without time zone No No
invoiced_date timestamp without time zone No No
user_freight boolean Yes No false
deleted timestamp without time zone No No
udf_data hstore No No ''::hstore
partial_tax_rate numeric(7,4) No No 0
partial_tax_total numeric(15,2) No No 0

Constraints

Name Type Definition Comment
bve_order_del_pkey Primary key (id)

Report generated by pgAdmin III