Skip to main content
Aria Knowledge Central

Snowflake VM Object: Recurring Credits

► Recurring Credits

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
RECURRING_CREDIT_NO NUMBER the recurring_credit_no for the referenced record
ACCOUNT_NO NUMBER The account number related to the customer referenced
USERID TEXT The userid for login related to the customer referenced
CANCEL_COMMENTS TEXT the cancel_comments for the referenced record
CANCEL_DATE DATE the cancel_date for the referenced record
COMMENTS TEXT The detailed comments related to the referenced data
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data
CREDIT_INTERVAL_MONTHS NUMBER the credit_interval_months for the referenced record
CREDIT_SERVICE TEXT the credit_service for the referenced record
CURRENCY_CD TEXT The ISO currency code of the referenced data
ELIGIBLE_PLAN_INSTANCES VARIANT An embedded one to many JSON subrecord related to eligible plan instances
ELIGIBLE_PLANS VARIANT An embedded one to many JSON subrecord related to eligible plans
ELIGIBLE_SERVICE_TYPES VARIANT An embedded one to many JSON subrecord related to eligible service types
EXPIRATION_DATE DATE the expiration_date for the referenced record
EXPIRATION_MONTHS NUMBER the expiration_months for the referenced record
EXPIRATION_TYPE_INDICATOR TEXT the expiration_type_indicator for the referenced record
FIRST_CREDIT_DATE DATE the first_credit_date for the referenced record
LAST_CREDIT_DATE DATE the last_credit_date for the referenced record
MASTER_PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for an master plan instance
MASTER_CLIENT_PLAN_INSTANCE_ID TEXT The client facing unique identifier for an master plan instance
NEXT_CREDIT_DATE DATE the next_credit_date for the referenced record
NUMBER_OF_CREDITS_REMAINING NUMBER the number_of_credits_remaining for the referenced record
NUMBER_OF_CREDITS_REQUIRED NUMBER the number_of_credits_required for the referenced record
PERCENTAGE_SOURCE_PLAN NUMBER the percentage_source_plan for the referenced record
PERCENTAGE_SOURCE_SERVICE NUMBER the percentage_source_service for the referenced record
REASON_NO NUMBER the reason_no for the referenced record
RECURRING_CREDIT_AMOUNT NUMBER the recurring_credit_amount for the referenced record
RECURRING_CREDIT_TYPE_NO NUMBER the recurring_credit_type_no for the referenced record
SOURCE_COUPON TEXT the source_coupon for the referenced record
STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced
USE_CHARGE_SERVICE BOOLEAN the use_charge_service 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

ELIGIBLE_PLANS RECURRING_CREDITS VM_RC_ELIGIBLE_PLANS
ELIGIBLE_PLAN_INSTANCES RECURRING_CREDITS VM_RC_ELIGIBLE_PLAN_INSTANCES
ELIGIBLE_SERVICE_TYPES RECURRING_CREDITS VM_RC_ELIGIBLE_SERVICE_TYPES
  • Was this article helpful?