| id |
integer |
Yes |
Yes |
nextval('customers_id_seq'::regclass) |
Unique indentifier |
| cust_no |
character varying(20) |
No |
No |
|
Customer code |
| name |
character varying(60) |
No |
No |
|
Customer name |
| currency |
character varying(3) |
Yes |
No |
|
Customer currency; blank = base currency - links to currencies.code |
| reference |
character varying(60) |
No |
No |
|
Customer reference number |
| last_invoice_no |
character varying(25) |
No |
No |
|
Customer's last invoice number posted |
| last_invoice_date |
date |
No |
No |
|
Customer's last date invoice date |
| present_bal |
numeric(15,2) |
No |
No |
|
Customer's 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 |
|
Customer's credit limit |
| disc_pct |
numeric(5,2) |
No |
No |
|
Customer's default invoice discount % that is applied after line discounts |
| terms_code |
character varying(10) |
No |
No |
|
Customer's terms code - links to payment_terms.terms_code |
| notes |
character varying(30) |
No |
No |
|
Customer's note that is displayed on top of Sales Order entry screen. Can be set in Edit Customer, General, User Defined Fields |
| misc1 |
character varying(40) |
No |
No |
|
Customer type field that is used in price matrix for group pricing. Can be set in Edit Customer, General, User Defined Fields - links to record_types.user_type where record_types.link_tbl='CUST' |
| spec_handling |
character varying(1) |
No |
No |
|
Customer's special field . Can be set in Edit Customer, General, User Defined Fields. A-Z for use only in reporting and filtering. |
| statement_code |
boolean |
Yes |
No |
|
Customer's statement setting as set in Edit Customer, Billing, Satements and Invoices; FALSE = Not required TRUE = Statement required |
| svce_chg_code |
boolean |
Yes |
No |
|
Customer's Service / Finance charge flag; FALSE = No TRUE = Yes |
| tax_prompt |
boolean |
Yes |
No |
|
Not used |
| dflt_ship_to |
character varying(20) |
No |
No |
|
Customer's default ship to code - used as the default ship to on all new sales orders for this customer |
| upload |
boolean |
Yes |
No |
|
Not used by Spire - populated with 'FALSE' |
| last_sale_amt |
numeric(15,2) |
No |
No |
|
Customer's last sale amount |
| last_pmt_amt |
numeric(15,2) |
No |
No |
|
Customer's last payment amount |
| statement_type |
character varying(1) |
No |
No |
|
Customer's statement setting as set in Edit Customer, Billing, Satements and Invoices; B = Both form and email E = Email F = Form N = Not required |
| invoice_type |
character varying(1) |
No |
No |
|
Customer's invoice setting as set in Edit Customer, Billing, Satements and Invoices; B = Both form and email E = Email F = Form N = Not required |
| po_no_required |
boolean |
Yes |
No |
|
Customer's purchase order number required flag; FALSE = No TRUE = Yes |
| ar_account |
character varying(24) |
No |
No |
|
General Ledger control account used for Accounts Receivable - links to gl_accounts.account_no |
| avg_days_to_pay |
numeric(15,2) |
No |
No |
|
Customer's average days to pay accounts receivable |
| _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 record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |
| approved_by |
character varying(3) |
No |
No |
|
User initials that approved customer's credit limit change |
| approved_date |
date |
No |
No |
|
Date that the customer's credit limit was changed |
| color_text |
bigint |
Yes |
No |
0 |
Text colour code for display of name |
| color_back |
bigint |
Yes |
No |
(B'111111111111111111111111'::"bit")::integer |
Background colour code for display of name |
| website |
character varying(125) |
No |
No |
|
Customer's website address |
| open_ord |
numeric(15,2) |
No |
No |
|
Customer's un-invoiced Sales Orders value |
| bank_institution |
character varying(3) |
No |
No |
|
Customer's bank institution number used for EFT |
| bank_transit |
character varying(5) |
No |
No |
|
Customer's bank transit number used for EFT |
| bank_account |
character varying(31) |
No |
No |
|
Customer's bank account number used for EFT |
| status |
character varying(1) |
Yes |
No |
'A'::character varying |
Customer's current status; A = Active I = Inactive P = Prospect |
| levy_exempt |
boolean |
Yes |
No |
false |
Customer's status for charging inventory levies; FALSE = Not exempt, charge levies TRUE = Exempt, do not charge levies |
| surcharge_exempt |
boolean |
Yes |
No |
false |
Customer's status for charging service / finance charges; FALSE = Not exempt, charge service fee TRUE = Exempt, do not charge fee |
| last_year_sales |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Customer's total sales last year by period |
| this_year_sales |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Customer's total sales this year by period |
| next_year_sales |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Customer's total sales next year by period |
| last_year_gp |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Customer's total gross profit last year by period |
| this_year_gp |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Customer's total gross profit this year by period |
| next_year_gp |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Customer's total gross profit next year by period |
| hold |
boolean |
Yes |
No |
false |
Customer's on hold flag; FALSE = Not on hold TRUE = On hold |
| last_pmt_date |
date |
No |
No |
|
Customer's last payment date in Accounts Receivable |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |
| last_modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified by a Spire process, not a user edit |
| provider_id |
character varying(32) |
No |
No |
|
Customer's identifier for Payment Gateway use |