| id |
integer |
Yes |
Yes |
nextval('addresses_id_seq'::regclass) |
Unique identifier |
| link_table |
character varying(4) |
No |
No |
|
Field to use for module linking; COMP = Company CUST = Customer DIV = Division EMP = Employee JC = Job Cost PHIS = Purchase History PORD = Purchase Order SHIS = Sales History SORD = Sales Order VEND = Vendor WHSE = Warehouse |
| link_no |
character varying(20) |
No |
No |
|
Field to store join value for link to; customers.cust_no, gl_divisions.division, employees.employee_no, jobs.job_no, purchase_history.purchase_no , purchase_orders.purchase_no, sales_history.invoice_no, sales_orders_order_no, vendors.vendor_no, inventory_warehouses.whse |
| addr_type |
character varying(1) |
No |
No |
|
Address type flag; B = Billing address S = Ship To address |
| ship_id |
character varying(20) |
Yes |
No |
|
ShipTo ID from; Customer, Sales Order, Sales History, Purchase History, Purchase Order, Vendor |
| name |
character varying(60) |
No |
No |
|
Name for; Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| city |
character varying(45) |
No |
No |
|
City for this record |
| prov_state |
character varying(2) |
No |
No |
|
Province/State for this record |
| postal_zip |
character varying(16) |
No |
No |
|
Postal Code / Zip Code for this record |
| country_code |
character varying(3) |
No |
No |
|
Country for this record |
| phone_type |
smallint |
No |
No |
|
Telephone display format; 1 - Masked 2 - Un Masked |
| phone |
character varying(30) |
No |
No |
|
Phone Number for this record |
| fax_type |
smallint |
No |
No |
|
Fax number type; 1 - Masked 2 - Un Masked 3 - Masked with "Fax" as prefix 4 - Masked with "Cell" as prefix |
| fax |
character varying(30) |
No |
No |
|
Fax number for this record |
| email |
character varying(254) |
No |
No |
|
Email address for this record |
| webpage |
character varying(80) |
No |
No |
|
Web page address for this record |
| hold |
boolean |
No |
No |
|
Hold flag; FALSE - Not Held TRUE - On Hold |
| sales_terr |
character varying(10) |
No |
No |
|
Territory code for this record - links to territories.code |
| sales_terr_desc |
character varying(80) |
No |
No |
|
Territory Name for this record |
| sales_person |
character varying(10) |
No |
No |
|
Salesperson code for this record - links to salespeople.salesperson_no |
| slspsn_name |
character varying(60) |
No |
No |
|
Salesperson Name for this record |
| ship_code |
character varying(10) |
No |
No |
|
Ship code for this record |
| ship_desc |
character varying(60) |
No |
No |
|
Ship description |
| dflt_whse |
character varying(6) |
No |
No |
|
Default warehouse code for customer |
| rv_account |
character varying(24) |
No |
No |
|
Revenue General Ledger account for Customer Expense General Ledger account for Vendor |
| sell_no |
smallint |
No |
No |
|
Customers sell level 1 - 20 |
| native |
boolean |
No |
No |
|
Not used |
| ecommerce |
boolean |
No |
No |
|
Used for ecommerce integration |
| billto_csp |
boolean |
No |
No |
|
Not used |
| _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 |
| address |
character varying(45)[] |
No |
No |
|
Street Address for this record - address[1] = address line 1, address[2] = address line 2, address[3] = address line 3, address[4] = address line 4 |
| contact_name |
character varying(60)[] |
Yes |
No |
|
Contact 1, 2 and 3 Names for this record - contact_name[1] = Contact 1, contact_name[2] = Contact 2, contact_name[3] = Contact 3 |
| contact_phone_type |
smallint[] |
Yes |
No |
|
Contact 1, 2 and 3 telephone types for this record |
| contact_phone |
character varying(30)[] |
Yes |
No |
|
Contact 1, 2 and 3 telephone number for this record |
| contact_fax_type |
smallint[] |
Yes |
No |
|
Contact 1, 2 and 3 fax numner types for this record |
| contact_fax |
character varying(30)[] |
Yes |
No |
|
Contact 1, 2 and 3 fax numbers for this record |
| contact_email |
character varying(254)[] |
Yes |
No |
|
Contact 1, 2 and 3 email addresses for this record |
| sales_tax_no |
smallint[] |
Yes |
No |
|
Sales tax codes charged to be used witht his address - links to sales_taxes.id |
| sales_tax_exempt_no |
character varying(20)[] |
Yes |
No |
|
Sales tax exemption numbers 1 - 4 for this record |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for address record |