| id |
integer |
Yes |
Yes |
nextval('addresses_id_seq'::regclass) |
|
| 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 code for, Company, Customer Code, Division, Employee Code, Job Cost number, Purchase History Number , Purchase Order Number, Sales History Invoice Number, Sales Order Number, Vendor Code, Warehouse |
| addr_type |
character varying(1) |
No |
No |
|
B = Billing S = Ship To |
| ship_id |
character varying(20) |
No |
No |
|
ShipTo ID from Sales Order Purchase Order Sales History Purchase History Customer Vendor |
| name |
character varying(60) |
No |
No |
|
Name from Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| city |
character varying(45) |
No |
No |
|
City from Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| prov_state |
character varying(2) |
No |
No |
|
Province/State from Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| postal_zip |
character varying(16) |
No |
No |
|
Postal Code / Zip Code from Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| country_code |
character varying(3) |
No |
No |
|
Country from Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| phone_type |
smallint |
No |
No |
|
Telephone format 1 = Masked 2 = Un Masked |
| phone |
character varying(30) |
No |
No |
|
Phone Number for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| 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 Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| email |
character varying(254) |
No |
No |
|
Email address for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| webpage |
character varying(80) |
No |
No |
|
Webpage for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| hold |
boolean |
No |
No |
|
False - Not held True - Held |
| sales_terr |
character varying(10) |
No |
No |
|
Territory code for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| sales_terr_desc |
character varying(80) |
No |
No |
|
Territory Name for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| sales_person |
character varying(10) |
No |
No |
|
Salesperson code for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| slspsn_name |
character varying(60) |
No |
No |
|
Salesperson Name for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| ship_code |
character varying(10) |
No |
No |
|
Ship code for Customer, Purchase History, Purchase Order, Sales History, Sales Order, |
| ship_desc |
character varying(60) |
No |
No |
|
Ship name for Customer, Purchase History, Purchase Order, Sales History, Sales Order, |
| dflt_whse |
character varying(6) |
No |
No |
|
Default warehouse code for customer |
| rv_account |
character varying(24) |
No |
No |
|
Revenue GL account for customer Expense GL account for vendor |
| sell_no |
smallint |
No |
No |
|
Customers sell level 1-20 |
| native |
boolean |
No |
No |
|
|
| ecommerce |
boolean |
No |
No |
|
|
| billto_csp |
boolean |
No |
No |
|
Not Used |
| _dbversion |
integer |
No |
No |
|
Spire version that wrote this record If data was converted from BV then the BV version |
| _created |
timestamp without time zone |
No |
No |
|
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 |
|
Date and time the this record was last edited |
| _modified_by |
character varying(3) |
No |
No |
|
User that last ediited this record |
| address |
character varying(45)[] |
No |
No |
|
Address for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse address[1] = address line 1 - 4 |
| contact_name |
character varying(60)[] |
No |
No |
|
Contact 1, 2 and 3 Names for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| contact_phone_type |
smallint[] |
No |
No |
|
Contact 1, 2 and 3 telephone types for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| contact_phone |
character varying(30)[] |
No |
No |
|
Contact 1, 2 and 3 telephone number for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| contact_fax_type |
smallint[] |
No |
No |
|
Contact 1, 2 and 3 fax numner types for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| contact_fax |
character varying(30)[] |
No |
No |
|
Contact 1, 2 and 3 fax numbers for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| contact_email |
character varying(254)[] |
No |
No |
|
Contact 1, 2 and 3 email addresses for Company, Customer, Division, Employee, Job Cost, Purchase History, Purchase Order, Sales History, Sales Order, Vendor, Warehouse |
| sales_tax_no |
smallint[] |
No |
No |
|
Sales tax codes charged on/to customer Vendor Sales Order Purchase Order Sales history Purchase history |
| sales_tax_exempt_no |
character varying(20)[] |
No |
No |
|
Sales tax exempt numbers customer Vendor Sales Order Purchase Order Sales history Purchase history |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data |