vthirdpartylist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tpid int8 19 √ null
tpreference varchar 30 √ null
tpname text 2147483647 √ null
tptype varchar 10 √ null
tpfiscalid varchar 2147483647 √ null
tpidentitycardid varchar 2147483647 √ null
tpstatus varchar 10 √ null
tpmainadrstreet1 varchar 250 √ null
tpmainadrcity varchar 50 √ null
tagroles text 2147483647 √ null
created_at timestamp 29,6 √ null
created_by int8 19 √ null
updated_at timestamp 29,6 √ null
updated_by int8 19 √ null
parentid int8 19 √ null
parentname varchar 100 √ null
parentreference varchar 30 √ null
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
tpbrand varchar 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views