mssub_bms.ms_appl

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Default	Comments
mstr_persons	Table	access_account_id	uuid	2147483647	√	null	An optional association with a global Access Account, used for authentication to the application by users. Constraint Reference An Access Account can only be associated with a single Person record and as such must be unique in this table. The reference to the `ms_syst_data.syst_access_accounts` table is a cross-database reference and therefore cannot be enforced using conventional database referential integrity constraints. The application developer, therefore, is responsible for ensuring that values in this table actually match valid `ms_syst_data.syst_access_accounts` records.
mstr_country_address_format_assocs	Table	address_format_id	uuid	2147483647		null	Identifies the address format which is to be associated with the country.
mstr_countries	Table	capital	text	2147483647	√	null	Capital city from Geonames
mstr_countries	Table	cldr_display_name	text	2147483647	√	null	(CLDR display name) :: Country’s customary English short name (CLDR)
mstr_contacts	Table	contact_data	jsonb	2147483647		'{}'::jsonb	Contains the actual contact data being stored by the record as well as associated metadata such as specialized data fields, mapping of the specialized fields to standard representation for data maintenance, display, printing, and integration.
mstr_person_contact_roles	Table	contact_id	uuid	2147483647		null	A reference to the Contact record which serves the given Role for the given Person.
mstr_contacts	Table	contact_notes	text	2147483647	√	null	Optional user provided notes related to the Contact record.
mstr_contacts	Table	contact_state_id	uuid	2147483647		null	Establishes the current life-cycle state of the contact record, such as whether the record is active or not.
mstr_contacts	Table	contact_type_id	uuid	2147483647		null	Indicates the type of the contact record. Contact records store inforamtion of varying types such as phone numbers, physical addresses, email addresses, etc. The value in this column establishes which kind of contact data is being stored and indicates the data processing rules to apply.
mstr_countries	Table	continent	text	2147483647	√	null	(Continent) :: Continent from Geonames
mstr_country_name_format_assocs	Table	country_id	uuid	2147483647		null	Identifies the country with with the name format is being associated.
mstr_country_phone_format_assocs	Table	country_id	uuid	2147483647		null	Identifies the country with with the phone format is being associated.
mstr_country_address_format_assocs	Table	country_id	uuid	2147483647		null	Identifies the country with with the address format is being associated.
mstr_country_phone_format_assocs	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_bank_entities	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_facility_places	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_person_roles	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_address_format_assocs	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_selling_entities	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_staff_entities	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_inventory_places	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_person_contact_roles	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_purchasing_entities	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_name_format_assocs	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_purchasing_entities	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_phone_format_assocs	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_facility_places	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_address_format_assocs	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_staff_entities	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_person_contact_roles	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_selling_entities	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_bank_entities	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_name_format_assocs	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_inventory_places	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_person_roles	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_phone_format_assocs	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_contacts	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entity_selling_entities	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entity_bank_entities	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_persons	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entity_facility_places	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entity_staff_entities	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entity_inventory_places	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_country_address_format_assocs	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entities	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_countries	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entity_person_roles	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_entity_purchasing_entities	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_country_name_format_assocs	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_places	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_person_contact_roles	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
mstr_country_name_format_assocs	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_address_format_assocs	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_bank_entities	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_selling_entities	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_person_roles	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_staff_entities	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_inventory_places	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_phone_format_assocs	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_purchasing_entities	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_facility_places	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_person_contact_roles	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_inventory_places	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_phone_format_assocs	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_purchasing_entities	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_facility_places	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_selling_entities	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_bank_entities	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_staff_entities	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_person_roles	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_address_format_assocs	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_name_format_assocs	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_person_contact_roles	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_name_format_assocs	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_phone_format_assocs	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_bank_entities	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_inventory_places	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_purchasing_entities	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_person_roles	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_selling_entities	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_facility_places	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_person_contact_roles	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_address_format_assocs	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_staff_entities	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_phone_format_assocs	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_person_roles	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_person_contact_roles	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_purchasing_entities	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_staff_entities	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_inventory_places	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_bank_entities	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_name_format_assocs	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_address_format_assocs	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_facility_places	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_selling_entities	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	dial	text	2147483647	√	null	Country code from ITU-T recommendation E.164, sometimes followed by area code
mstr_places	Table	display_name	text	2147483647	√	null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	display_name	text	2147483647	√	null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	display_name	text	2147483647	√	null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	ds	text	2147483647	√	null	(DS) :: Distinguishing signs of vehicles in international traffic
mstr_countries	Table	edgar	text	2147483647	√	null	(EDGAR) :: EDGAR country code from SEC
mstr_entity_purchasing_entities	Table	entity_id	uuid	2147483647		null	Identifies the Entity which is the “vendor” in the relationship.
mstr_entity_person_roles	Table	entity_id	uuid	2147483647		null	The Entity with which the identified Person has a Role. In many regards, this field identifies the Owner of the record.
mstr_entity_staff_entities	Table	entity_id	uuid	2147483647		null	The record ID identifying the Entity which represents the Employee, Contractor, or other staff member.
mstr_entity_selling_entities	Table	entity_id	uuid	2147483647		null	Identifies the Entity which will act as the Customer in the selling relationship.
mstr_entity_bank_entities	Table	entity_id	uuid	2147483647		null	Identifies an Entity which acts as a bank or financial institution in the relationship.
mstr_entity_person_roles	Table	entity_person_role_id	uuid	2147483647		null	Identifies the Role being assigned to the Person for the identified Entity.
mstr_entities	Table	entity_state_id	uuid	2147483647		null	Establishes current state of the entity in the established lifecycle of entity records. General Usage Certain application features and behaviors will depend on the configuration of the state value selected for a entity record.
mstr_entities	Table	entity_type_id	uuid	2147483647		null	Defines the kind of entity that is being represented by the record and by extension the kinds of uses in which the entity may be used. General Usage Application functionality is determined in part by the configuration of the selected type.
mstr_contacts	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
mstr_entities	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
mstr_places	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
mstr_persons	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
mstr_countries	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
mstr_countries	Table	fips	text	2147483647	√	null	(FIPS) :: Codes from the U.S. standard FIPS PUB 10-4
mstr_persons	Table	formatted_name	jsonb	2147483647		'{}'::jsonb	Contains a jsonb object describing the naming fields, field layout, and the actual values of the user’s name. Note that the format will normally have originated from the `ms_appl_data.syst_name_formats` table, but reflects the name formatting configuration at the time of capture.
mstr_entity_inventory_places	Table	fulfills_external_inventory	bool	1		false	If true, inventory units may be fulfilled from this place, for this entity. If false, this inventory may not participate as a source of fulfillment to third parties.
mstr_entity_inventory_places	Table	fulfills_internal_inventory	bool	1		false	If true, inventory units may be fulfilled from this managed inventory to another inventory managed by the system. If false, the inventory may not serve as the source of inventory units to other managed inventories. Transferring inventory out is an example of a transaction requiring this internal fulfillment ability.
mstr_countries	Table	gaul	text	2147483647	√	null	(GAUL) :: Global Administrative Unit Layers from the Food and Agriculture Organization
mstr_countries	Table	geoname_id	text	2147483647	√	null	(Geoname ID) :: Geoname ID
mstr_countries	Table	global_code	text	2147483647	√	null	(Global Code) :: Country classification from United Nations Statistics Division
mstr_countries	Table	global_name	text	2147483647	√	null	(Global Name) :: Country classification from United Nations Statistics Division
mstr_contacts	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_name_format_assocs	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_phone_format_assocs	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_person_roles	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_country_address_format_assocs	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_facility_places	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_purchasing_entities	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_inventory_places	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_bank_entities	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_person_contact_roles	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_selling_entities	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entity_staff_entities	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	intermediate_region_code	text	2147483647	√	null	(Intermediate Region Code) :: Country classification from United Nations Statistics Division
mstr_countries	Table	intermediate_region_name	text	2147483647	√	null	(Intermediate Region Name) :: Country classification from United Nations Statistics Division
mstr_countries	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_places	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_entities	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_contacts	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_persons	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
mstr_countries	Table	ioc	text	2147483647	√	null	(IOC) :: Codes assigned by the International Olympics Committee
mstr_country_name_format_assocs	Table	is_default_for_country	bool	1		false	If true, this format should be used as the default format for the country. General Usage There should only ever be one default for any one country_id.
mstr_country_address_format_assocs	Table	is_default_for_country	bool	1		false	If true, this format should be used as the default format for the country. There should only ever be one default for any one country_id.
mstr_country_phone_format_assocs	Table	is_default_for_country	bool	1		false	If true, this format should be used as the default format for the country. General Usage There should only ever be one default for any one country_id.
mstr_countries	Table	is_independent	text	2147483647	√	null	(is_independent) :: Country status, based on the CIA World Factbook
mstr_countries	Table	iso3166_1_alpha_2	text	2147483647	√	null	Alpha-2 codes from ISO 3166-1
mstr_countries	Table	iso3166_1_alpha_3	text	2147483647	√	null	Alpha-3 codes from ISO 3166-1 (synonymous with World Bank Codes)
mstr_countries	Table	iso3166_1_numeric	text	2147483647	√	null	Numeric codes from ISO 3166-1
mstr_countries	Table	iso4217_currency_alphabetic_code	text	2147483647	√	null	ISO 4217 currency alphabetic code
mstr_countries	Table	iso4217_currency_country_name	text	2147483647	√	null	(ISO4217-currency_country_name) :: ISO 4217 country name
mstr_countries	Table	iso4217_currency_minor_unit	text	2147483647	√	null	(ISO4217-currency_minor_unit) :: ISO 4217 currency number of minor units
mstr_countries	Table	iso4217_currency_name	text	2147483647	√	null	(ISO4217-currency_name) :: ISO 4217 currency name
mstr_countries	Table	iso4217_currency_numeric_code	text	2147483647	√	null	(ISO4217-currency_numeric_code) :: ISO 4217 currency numeric code
mstr_countries	Table	itu	text	2147483647	√	null	(ITU) :: Codes assigned by the International Telecommunications Union
mstr_countries	Table	languages	text	2147483647	√	null	(Languages) :: Languages from Geonames
mstr_countries	Table	marc	text	2147483647	√	null	(MARC) :: MAchine-Readable Cataloging codes from the Library of Congress
mstr_country_name_format_assocs	Table	name_format_id	uuid	2147483647		null	Identifies the name format which is to be associated with the country.
mstr_countries	Table	official_name_ar	text	2147483647	√	null	Country or Area official Arabic short name from UN Statistics Division
mstr_countries	Table	official_name_cn	text	2147483647	√	null	Country or Area official Chinese short name from UN Statistics Division
mstr_countries	Table	official_name_en	text	2147483647	√	null	Country or Area official English short name from UN Statistics Division
mstr_countries	Table	official_name_es	text	2147483647	√	null	Country or Area official Spanish short name from UN Statistics Division
mstr_countries	Table	official_name_fr	text	2147483647	√	null	Country or Area official French short name from UN Statistics Division
mstr_countries	Table	official_name_ru	text	2147483647	√	null	Country or Area official Russian short name from UN Statistics Division
mstr_entity_bank_entities	Table	owning_entity_id	uuid	2147483647		null	Identifies the Entity on whose behalf the banking relationship exists.
mstr_entity_purchasing_entities	Table	owning_entity_id	uuid	2147483647		null	Identifies the Entity that will purchase goods and services from the vendor Entity.
mstr_entities	Table	owning_entity_id	uuid	2147483647		null	Indicates which managing entity is the owning entity for purposes of default visibility and usage limitations. General Usage The limited cases are primarily evident in searches and lists. Explicit assignment of rights to entities, persons, facilities, etc. that are not the owning entity is still possible and those rights will prevail over the default access rules for non-owning entities. There is a special case of owning entity where an entity is self owning. There may only be a single entity that is self owning and that, by definition, establishes that entity as the ‘global entity’. The global entity has global administrative rights as well as allows access to those persons, facilities, and entities that it owns effectively making them global to all other managed entities. The global entity may be an actual business entity which essentially owns the MSBMS Instance or it may a purely administrative construct for managing the system.
mstr_entity_facility_places	Table	owning_entity_id	uuid	2147483647		null	Establishes the Entity which uses the Place as a workplace.
mstr_entity_selling_entities	Table	owning_entity_id	uuid	2147483647		null	Identifies the Owning Entity which has a selling relationship with the Customer Entity.
mstr_persons	Table	owning_entity_id	uuid	2147483647		null	Indicates which Managing Entity owns the Person record for the purposes of default visibility and access. General Usage Any Person record owned by the Global Entity is by default visible and usable by any Managed Entity.
mstr_contacts	Table	owning_entity_id	uuid	2147483647		null	Indicates the entity which is the owner or “controlling”. General Usage There are a couple of ways this can be used. The first case is illustrated by the example of a managed entity and an staffing entity that is an individual. The owning entity in this case will be the managed entity for contacts such as the details of the person’s office address, phone, and email addresses that is used in carrying out their duties as staff. The second case is where the entity is in a selling, purchasing, or banking relationship with the managed entity. In this case the owning entity is the entity with which the managed entity has a relationship since a customer, vendor, or bank determines their own contact details.
mstr_entity_staff_entities	Table	owning_entity_id	uuid	2147483647		null	Identifies the Managed Entity which employs the staff member.
mstr_places	Table	owning_entity_id	uuid	2147483647		null	Indicates which Managing Entity owns the Place record for the purposes of default visibility and access. General Usage Any Place record owned by the Global Entity is by default visible and usable by any Managed Entity.
mstr_entity_inventory_places	Table	owning_entity_id	uuid	2147483647		null	Establishes the Entity which has an Inventory Relationship to the identified place.
mstr_person_contact_roles	Table	person_contact_role_id	uuid	2147483647		null	Indicates a specific use or purpose for the identified Contact information.
mstr_person_contact_roles	Table	person_id	uuid	2147483647		null	Identifies the Person which has the relationship to the Contact information.
mstr_entity_person_roles	Table	person_id	uuid	2147483647		null	The Person that is being assigned a Role with the Entity.
mstr_persons	Table	person_state_id	uuid	2147483647	√	null	Indicates in which Person life-cycle state the record current sits. This can include designating the record as active or inactive.
mstr_persons	Table	person_type_id	uuid	2147483647		null	The “kind” of Person being represented by the record. Specifically if the record represents an actual individual person or a function such as “clerk”.
mstr_country_phone_format_assocs	Table	phone_format_id	uuid	2147483647		null	Identifies the phone format which is to be associated with the country.
mstr_person_contact_roles	Table	place_id	uuid	2147483647	√	null	This is an optional value indicating whether the given Contact information is associated with a known Place. General Usage If the Contact information is associated with a specific Place, a reference to the Place record ID will appear here. Otherwise the value will be `NULL`.
mstr_entity_inventory_places	Table	place_id	uuid	2147483647		null	Identifies the place that will have an Inventory Relationship with the Owning Entity.
mstr_entity_facility_places	Table	place_id	uuid	2147483647		null	Identifies the Place which has a workplace relationship with the Owning Entity.
mstr_places	Table	place_state_id	uuid	2147483647	√	null	Establishes where in the record life-cycle that the record current sits.
mstr_places	Table	place_type_id	uuid	2147483647		null	Defines the kind of Place the record represents. Different types of Places may offer different functional abilities and limitations.
mstr_entity_inventory_places	Table	receives_external_inventory	bool	1		false	If true, this inventory may receive inventory shipments from third parties such as might originate from purchase order transactions. If false, this inventory may not receive inventory from external third parties.
mstr_entity_inventory_places	Table	receives_internal_inventory	bool	1		false	If true, inventory units may be received into this inventory from other inventories managed by the system. If false, other managed inventories will not be valid sources to replenish stocks in this inventory. Transferred inventory would be an example of a transaction requiring the inventory to allow the processing of internal receipts.
mstr_countries	Table	region_code	text	2147483647	√	null	(Region Code) :: Country classification from United Nations Statistics Division
mstr_countries	Table	region_name	text	2147483647	√	null	(Region Name) :: Country classification from United Nations Statistics Division
mstr_countries	Table	sub_region_code	text	2147483647	√	null	(Sub-region Code) :: Country classification from United Nations Statistics Division
mstr_countries	Table	sub_region_name	text	2147483647	√	null	(Sub-region Name) :: Country classification from United Nations Statistics Division
mstr_countries	Table	tld	text	2147483647	√	null	(TLD) :: Top level domain from Geonames
mstr_countries	Table	wmo	text	2147483647	√	null	(WMO) :: Country abbreviations by the World Meteorological Organization

Showing 1 to 229 of 229 entries