Snowflake VC Object: Account Fields
- ► Account Fields
-
Field
Datatype
Description
CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated EVENT_ID TEXT EVENT_ID for the change JSON record CREATETIME NUMBER CREATETIME createtime of the changed JSON record ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record. FIELD_NAME TEXT The field_name for the referenced record. FIELD_NO NUMBER The field_no for the referenced record. FIELD_ORDER NUMBER The field_order for the referenced record. DESCRIPTION TEXT The description of the field for the referenced record. INPUT_TYPE_CD TEXT The input type code. IS_REQUIRED BOOLEAN Is the account field required for data entry? IS_RESTRICTED_TO_ALLOWED_VALUES BOOLEAN Is data entry restricted to allowed values MAXIMUM_SELECTIONS NUMBER The maximum number of selections. MINIMUM_SELECTIONS NUMBER The minimum number of selections. CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data. UPDATED_TSTAMP TIMESTAMP_NTZ The timestamp of the update milestone.
-
Field
Datatype
Description
CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated EVENT_ID TEXT EVENT_ID for the change JSON record CREATETIME NUMBER CREATETIME createtime of the changed JSON record ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record. ACCOUNT_NO NUMBER The account number related to the customer referenced FIELD_NAME TEXT The field_name for the referenced record. FIELD_NO NUMBER The field_no for the referenced record.