Table Data dictionary report - customers

Generated: 2016-12-16 1:18:41 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: DDF_Do_Not_Remove
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('customers_id_seq'::regclass)
cust_no character varying(20) No No customer code Links to addresses-link_no
name character varying(60) No No Customers name
currency character varying(3) No No Customers currency Blank if base currency
reference character varying(60) No No Not used
last_invoice_no character varying(25) No No Customers last invoice number posted
last_invoice_date date No No Customers last date invoice date
present_bal numeric(15,2) No No Customers present accounts receivable balance
no_credit smallint No No Customer’s Credit Limit Type. 0=No Credit 1=Unlimited Credit 2=Limited Credit
credit_line numeric(13) No No Customers credit limit
disc_pct numeric(5,2) No No Customers overall invoice discount that is applied after line discounts
terms_code character varying(10) No No Customers terms code. Links to Payment_terms -> terms_code
notes character varying(30) No No Customer note that shows on top of order entry screen
misc1 character varying(40) No No Customer misc field that is used in price matrix for group pricing
spec_handling character varying(1) No No A-Z for use only in reporting and filtering
statement_code boolean No No Not used Populated with 'FALSE'
svce_chg_code boolean No No Flag to set if customer gets charged service/finance charges True = Yes Galse = No
tax_prompt boolean No No Not used populated with 'FALSE'
dflt_ship_to character varying(20) No No Customers default ship to Used as the default ship to on all new sales orders for this customer
e_commerce boolean No No Not used Populated with 'FALSE'
e_shipment_notify boolean No No Not used Populated with 'FALSE'
e_past_due_notices boolean No No Not used Populated with 'FALSE'
e_monthly_statements boolean No No Not used Populated with 'FALSE'
upload_status boolean No No Not used Populated with 'FALSE'
modify_status boolean No No Not used Populated with 'TRUE'
last_sale_amt numeric(15,2) No No Not used Populated with 0.00
last_pmt_amt numeric(15,2) No No Last amount customer paid
statement_type character varying(1) No No Type of statement customer wants. Only used on lists so user can select and filter prior to sending/printing statements F - Form E - Email B - Both N - None
invoice_type character varying(1) No No Type of statement customer wants. Only used on lists so user can select and filter prior to sending/printing statements F - Form E - Email B - Both N - None
po_no_required boolean No No Does customer require a purchase order on invoices 'TRUE' = Yes 'FALSE' = No
ar_account character varying(24) No No The GL control account used to post this customer's AR
avg_days_to_pay numeric(15,2) No No Average days this customer pays accounts receivable
_dbversion integer No No Version of Spire used to create this record. If converted from BV this will have the BV version number.
_created timestamp without time zone No No Date and time this record was created
_created_by character varying(3) No No Code of the user that created this record
_modified timestamp without time zone No No Date and time this record was last edited
_modified_by character varying(3) No No Code of the user that last edited this record
approved_by character varying(3) No No User initials that approved customers credit change
approved_date date No No Date that the customers credit was changed
color_text bigint Yes No 0 Color of the customer name. Used only for discplay purposes.
color_back bigint Yes No (B'111111111111111111111111'::"bit")::integer Color of the background of the customer name. Used only for discplay purposes.
website character varying(125) No No Customers website address
open_ord numeric(15,2) No No Value of all un invoices orders for this customer
bank_institution character varying(3) No No Customers bank institution number used for EFT
bank_transit character varying(5) No No Customers bank transit number used for EFT
bank_account character varying(31) No No Customers bank account number used for EFT
status character varying(1) Yes No 'A'::character varying Customers current status A = Active I = Inactive P = Prospect
levy_exempt boolean Yes No false Customer staus for charging inventory levies Charge levies = 'FALSE' Do not charge levies = 'TRUE'
surcharge_exempt boolean Yes No false Is customer exempt on surcharges on sales No = "FALSE' Yes = 'TRUE'
last_year_sales numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Customers total sales last year Array field containing 13 periods
this_year_sales numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Customers total sales this year Array field containing 13 periods
next_year_sales numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Customers total sales next year Array field containing 13 periods
last_year_gp numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Customers total gross profit last year Array field containing 13 periods
this_year_gp numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Customers total gross profit this year Array field containing 13 periods
next_year_gp numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Customers total gross profit next year Array field containing 13 periods
hold boolean Yes No false Is customer on hold No = 'FALSE' Yes = 'TRUE'
last_pmt_date date No No Date of customers last AR payment
udf_data hstore No No ''::hstore User defined hstore data

Constraints

Name Type Definition Comment
customer_pkey Primary key (id)

Report generated by pgAdmin III