Table Data dictionary report - vendors

Generated: 2018-01-15 7:20:03 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: Data_Dict_DoNotRemove
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('vendors_id_seq'::regclass)
vendor_no character varying(20) No No Vendor code
currency character varying(3) Yes No Vendor's currency
name character varying(60) No No Vendor's name
account_no character varying(20) Yes No ''::character varying Account number the vendor assigns you (GL account is in address table)
last_po_number character varying(10) No No Last PO to this vendor
last_payment_ref character varying(25) No No Last payment reference or check number
last_payment_date date No No Last payment date
terms_code character varying(10) No No Terms code normally used
fob_desc character varying(30) No No
present_bal numeric(15,2) No No Present balance owing
no_credit smallint No No
credit_line numeric(13) No No Credit limit
notes character varying(30) No No Short note about vendor. Appears on header of PO
buyer_name character varying(60) No No Buyers name
reference character varying(60) Yes No ''::character varying
ven_1099 boolean Yes No false CPRS/1099 used TRUE = Yes FALSE = No
ven_1099_id_type character varying(1) No No B = Business Number U = Social Insurance Number
gl_ap_no character varying(24) No No GL accounts payable account
tax_id character varying(60) No No Business or social insurance number
po_type character varying(1) No No
use_remit_to boolean Yes No false Use remit to TRUE = Yes FALSE = No
print_cheques boolean No No Print check by default TRUE = Yes FALSE = 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
hold boolean Yes No false On hold TRUE = Yes FALSE = No
status character varying(1) Yes No 'A'::character varying Status A = Active I = Inactive
udf_data hstore No No ''::hstore hstore field containing user defined data
use_billing_taxes boolean No No Use billing taxes for PO TRUE = Yes FALSE = No
last_year_purchases numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] This year's purchases
this_year_purchases numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] This year's purchases
next_year_purchases numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Next year's purchases
color_text bigint Yes No 0
color_back bigint Yes No (B'111111111111111111111111'::"bit")::integer
bank_institution character varying(3) No No
bank_transit character varying(5) No No
bank_account character varying(31) No No

Constraints

Name Type Definition Comment
vendor_pkey Primary key (id)

Report generated by pgAdmin III