# relationship

## Type: table

## Columns

| Column                             | Type      | Attributes                   | Description |
| ---------------------------------- | --------- | ---------------------------- | ----------- |
| accountnbr                         | varchar   |                              |             |
| acknowledgementprintscriptrowid    | int       |                              |             |
| allowbackorder                     | tinyint   |                              |             |
| apaccountrowid                     | int       |                              |             |
| applycreditlimit                   | tinyint   |                              |             |
| araccountrowid                     | int       |                              |             |
| box1099rowid                       | int       |                              |             |
| companyname                        | varchar   |                              |             |
| companyrowid                       | int       |                              |             |
| competitortypelistitemrowid        | int       |                              |             |
| creditbalance                      | decimal   |                              |             |
| creditlimitamount                  | decimal   |                              |             |
| currencyratetyperowid              | int       |                              |             |
| currencyrowid                      | int       |                              |             |
| customertypelistitemrowid          | int       |                              |             |
| deliverymethod                     | varchar   |                              |             |
| departmentrowid                    | int       |                              |             |
| description                        | varchar   |                              |             |
| electronicaccountnbr               | varchar   |                              |             |
| electronicbankname                 | varchar   |                              |             |
| electronicbillpayment              | tinyint   |                              |             |
| electronicroutingnbr               | varchar   |                              |             |
| employeetypelistitemrowid          | int       |                              |             |
| expenseaccountrowid                | int       |                              |             |
| expenseclassrowid                  | int       |                              |             |
| financecharge                      | tinyint   |                              |             |
| firstactivitydate                  | datetime  |                              |             |
| fobrowid                           | int       |                              |             |
| holdpayment                        | tinyint   |                              |             |
| invoicedeliverymethodlistitemrowid | int       |                              |             |
| invoiceformatrowid                 | int       |                              |             |
| invoiceprintscriptrowid            | int       |                              |             |
| isactive                           | tinyint   |                              |             |
| iscompetitor                       | tinyint   |                              |             |
| iscustomer                         | tinyint   |                              |             |
| isemployee                         | tinyint   |                              |             |
| isindividual                       | tinyint   |                              |             |
| ismanufacturer                     | tinyint   |                              |             |
| isonetime                          | tinyint   |                              |             |
| isothername                        | tinyint   |                              |             |
| ispartner                          | tinyint   |                              |             |
| isprospect                         | tinyint   |                              |             |
| issalesperson                      | tinyint   |                              |             |
| istaxable                          | tinyint   |                              |             |
| isvendor                           | tinyint   |                              |             |
| languagelistitemrowid              | int       |                              |             |
| leadrowid                          | int       |                              |             |
| manufacturertypelistitemrowid      | int       |                              |             |
| opportunityrowid                   | int       |                              |             |
| othernametypelistitemrowid         | int       |                              |             |
| parentrelationshiprowid            | int       |                              |             |
| partnertypelistitemrowid           | int       |                              |             |
| paymentmethodlistitemrowid         | int       |                              |             |
| pricelevelrowid                    | int       |                              |             |
| prospecttypelistitemrowid          | int       |                              |             |
| purchaseorderrequired              | tinyint   |                              |             |
| relationshipid                     | varchar   |                              |             |
| relationshiprowid                  | int       |                              |             |
| resalenbr                          | varchar   |                              |             |
| role1099                           | tinyint   |                              |             |
| rowid                              | int       | auto\_increment              |             |
| salesaccountrowid                  | int       |                              |             |
| salesclassrowid                    | int       |                              |             |
| salespersontypelistitemrowid       | int       |                              |             |
| salestaxgrouprowid                 | int       |                              |             |
| separatecheck                      | tinyint   |                              |             |
| shippingmethodlistitemrowid        | int       |                              |             |
| taxnbr                             | varchar   |                              |             |
| taxregistrationnbr                 | varchar   |                              |             |
| termrowid                          | int       |                              |             |
| updatetimestamp                    | timestamp | on update CURRENT\_TIMESTAMP |             |
| vendortypelistitemrowid            | int       |                              |             |
| webaddress                         | varchar   |                              |             |

v.ismain -- Wed, Feb 28, 2018 2:58 PM