Skip to main content
Aria Knowledge Central

Snowflake VM Object: Account Fields

► Account Fields

Field

Datatype

Description

CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client
IS_DELETED BOOLEAN Denotes a True/False as to if the referenced data has been deleted via soft delete
REF_PK TEXT REF_PK The PK of the ref_type concatenated with a pipe as needed within the JSON
FIELD_NO NUMBER the field_no for the referenced record
FIELD_NAME TEXT the field_name for the referenced record
DESCRIPTION TEXT The detailed description related to the referenced data
IS_REQUIRED BOOLEAN A True or False indicator showing if the record is mandatory
INPUT_TYPE_CD TEXT the input_type_cd for the referenced record
MINIMUM_SELECTIONS NUMBER the minimum_selections for the referenced record
MAXIMUM_SELECTIONS NUMBER the maximum_selections for the referenced record
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data
UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data
IS_RESTRICTED_TO_ALLOWED_VALUES BOOLEAN A True or False indicator showing if the record is restricted to allowed values
FIELD_ORDER NUMBER the field_order for the referenced record
ALLOWED_VALUES VARIANT The allowable data values for the pull down lists related to the referenced data
LOCALE_DETAILS VARIANT An embedded one to many JSON subrecord related to the records locale
CREATED_BATCH_ID NUMBER The aria facing creation batch id assigned upon landing for the referenced data
CREATED_BATCH_TSTAMP TIMESTAMP_NTZ The aria facing batch timstamp assigned upon landing for the referenced data, showing its creation in snowflake
UPDATED_BATCH_ID NUMBER The aria facing update batch id assigned upon landing for the referenced data
UPDATED_BATCH_TSTAMP TIMESTAMP_NTZ The aria facing batch timstamp assigned upon landing for the referenced data, showing its update in snowflake
Child Views
Variant Source Table Child View Name
ALLOWED_VALUES ACCOUNT_FIELDS VM_AF_ALLOWED_VALUES
LOCALE_DETAILS ACCOUNT_FIELDS VM_AF_LD_ALLOWED_VALUES
LOCALE_DETAILS ACCOUNT_FIELDS VM_AF_LOCALE_DETAILS
  • Was this article helpful?