Skip to main content
Aria Knowledge Central

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
Child Views

Variant

Source Table

Child View Name

LOCALE_DETAILS SERVICES VM_SERVICE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS SERVICES VM_SERVICE_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS SERVICES VM_SERVICE_PFA_VALUE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS SERVICES VM_SERVICE_PRODUCT_FIELD_ASSIGNMENTS
  • Was this article helpful?