TransactionCurrencyBase

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StatusCode int4 10 √ null
ModifiedOn timestamp 26,3 √ null
StateCode int4 10 null
VersionNumber bytea 2147483647 null
ModifiedBy uuid 2147483647 √ null
ImportSequenceNumber int4 10 √ null
OverriddenCreatedOn timestamp 26,3 √ null
CreatedOn timestamp 26,3 √ null
TransactionCurrencyId uuid 2147483647 null
ExchangeRate numeric 25,10 √ null
CurrencySymbol varchar 13 null
UniqueDscId uuid 2147483647 √ null
CurrencyName varchar 100 null
CreatedBy uuid 2147483647 √ null
ISOCurrencyCode varchar 5 null
OrganizationId uuid 2147483647 null
CurrencyPrecision int4 10 2
CreatedOnBehalfBy uuid 2147483647 √ null
ModifiedOnBehalfBy uuid 2147483647 √ null
EntityImageId uuid 2147483647 √ null
id serial 10 √ nextval('v1."TransactionCurrencyBase_id_seq"'::regclass)
ContactBase.currency_id ContactBase_currency_id_fkeyR
InvoiceBase.currency_id InvoiceBase_currency_id_fkeyR
InvoiceDetailBase.currency_id InvoiceDetailBase_currency_id_fkeyR
new_POBase.currency_id new_POBase_currency_id_fkeyR
new_receiptBase.currency_id new_receiptBase_currency_id_fkeyR
new_trackerBase.currency_id new_trackerBase_currency_id_fkeyR
Offer.currency_id Offer_currency_id_fkeyR
Posts.currency_id Posts_currency_id_fkeyR
SalesOrderBase.currency_id SalesOrderBase_currency_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
TransactionCurrencyBase_pkey Primary key Asc id
TransactionCurrencyBase_id_key Must be unique Asc id

Relationships

Close relationships within degrees of separation