Snowflake VM Object: Services
- ► Services
-
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 SERVICE_NO NUMBER the service_no for the referenced record CLIENT_SERVICE_ID TEXT the client_service_id for the referenced record NAME TEXT the name for the referenced record SERVICE_TYPE_CD TEXT the service_type_cd for the referenced record IS_TAXABLE BOOLEAN A True or False indicator showing if the record is taxable SERVICE_LOCATION_NO VARIANT the service_location_no for the referenced record CLIENT_SERVICE_LOCATION_ID TEXT the client_service_location_id for the referenced record IS_SERVICE_CREDITS_ELIGIBLE BOOLEAN A True or False indicator showing if the record is the service credit eligible COMMODITY_CODE TEXT the commodity_code for the referenced record PRODUCT_FIELD_ASSIGNMENTS VARIANT An embedded one to many JSON subrecord related to product field assignments LOCALE_DETAILS VARIANT An embedded one to many JSON subrecord related to the records locale TAX_SERVICE_GROUP_NO NUMBER the tax_service_group_no for the referenced record TAX_SERVICE_CLIENT_GROUP_ID TEXT the tax_service_client_group_id for the referenced record REVENUE_ACCOUNT_GL_CODE_NO NUMBER the revenue_account_gl_code_no for the referenced record REVENUE_ACCOUNT_GL_CODE_ID TEXT the revenue_account_gl_code_id for the referenced record ACCOUNT_RECEIVABLE_GL_CODE_NO NUMBER the account_receivable_gl_code_no for the referenced record ACCOUNT_RECEIVABLE_GL_CODE_ID TEXT the account_receivable_gl_code_id for the referenced record DEFERRED_GL_CODE_NO NUMBER the deferred_gl_code_no for the referenced record DEFERRED_GL_CODE_ID TEXT the deferred_gl_code_id for the referenced record 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