| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| obj_oid |
int8 |
19 |
|
|
|
| account_code.department_oid
|
fkcdepartment_oid |
| allocation.paying_department_oid
|
fkcalloc_paying_department_oid |
| department_code.department_oid
|
fkcdepartment_code_department_oid |
| invoice.paying_dept_oid
|
fkcinvoice_paying_dept_oid |
|
|
| name |
varchar |
2147483647 |
|
|
|
|
|
| billing_contact_oid |
int8 |
19 |
√ |
|
null |
|
| person.obj_oid
|
fkcdepartment_billing_contact_oid |
|
| street |
varchar |
2147483647 |
√ |
|
null |
|
|
| street2 |
varchar |
2147483647 |
√ |
|
null |
|
|
| city |
varchar |
2147483647 |
√ |
|
null |
|
|
| state |
varchar |
2147483647 |
√ |
|
null |
|
|
| postal_code |
varchar |
2147483647 |
√ |
|
null |
|
|
| country |
varchar |
2147483647 |
√ |
|
null |
|
|
| email |
varchar |
2147483647 |
√ |
|
null |
|
|
| telephone |
varchar |
2147483647 |
√ |
|
null |
|
|
| fax |
varchar |
2147483647 |
√ |
|
null |
|
|
| tax_exempt_number |
varchar |
2147483647 |
√ |
|
null |
|
|
| origin |
varchar |
2147483647 |
√ |
|
null |
|
|
| deleted |
bool |
1 |
√ |
|
null |
|
|
Table contained 0 rows at Wed May 07 11:05 EDT 2014
|
