Skip to main content
Aria Knowledge Central

Snowflake VC Object: Pending Invoice Lines

► Pending Invoice Lines




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.
INVOICE_NO NUMBER The Aria facing unique identifier for an invoice.
LINE_NO NUMBER The unique identifier for an invoice line.
ORDER_NO NUMBER The unique identifier for an order.
ORDER_LINE_NO NUMBER The unique identifier for an order line.
SURCHARGE_NO NUMBER The surcharge_no for the referenced record.
ADVANCE_BILLING_PERIOD_TOTAL_DAYS NUMBER The advance billing period total days.
BASE_PLAN_UNITS NUMBER The quantity of base plan units for the referenced data.
COMMENTS TEXT A verbose explanation of details related to the referenced data.
CREDIT_COUPON_CODE TEXT The credit coupon code.
CREDIT_REASON_NO NUMBER The unique identifier for a credit reason number.
END_DATE DATE The end date.
IS_TAX_RELATED BOOLEAN Is the record tax related?
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE_NO NUMBER The nonsubscription_offering_rate_schedule for the referenced record.
NONSUBSCRIPTION_OFFERING_CLIENT_RATE_SCHEDULE_ID TEXT The nonsubscription_offering_client_rate_schedule for the referenced record.
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE_TIER NUMBER The nonsubscription offering rate schedule tier.
PLAN_NO NUMBER The plan_no for the referenced record
CLIENT_PLAN_ID TEXT The unique identifier for a client plan record.
PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id.
PLAN_RATE_SCHEDULE_NO NUMBER The plan_rate_schedule_no for the referenced record.
CLIENT_PLAN_RATE_SCHEDULE_ID TEXT The client_plan_rate_schedule_id for the referenced record.
PLAN_RATE_SCHEDULE_SERVICE_TIER NUMBER The plan_rate_schedule_service_tier for the referenced record.
PRORATION_DESCRIPTION TEXT A verbose proration description of the pending invoice lines.
PRORATION_FACTOR NUMBER The proration factor.
PRORATION_OPERATION_TYPE_NO NUMBER The unique identifier for a proration operation type number.
PRORATION_REMAINING_DAYS NUMBER The days remaining for proration.
PURCHASE_ORDER_NUMBER TEXT The aria facing unique identifier for a purchase order.
RATE NUMBER The rate for the referenced data.
SERVICE_NO NUMBER The service_no for the referenced record.
CLIENT_SERVICE_ID TEXT The unique identifier for the client service id.
SERVICE_CREDIT_NO NUMBER The unique identifier for a service credit number.
SERVICE_CREDIT_SOURCE_TRANSACTION_NO NUMBER The unique identifier for a service credit source transaction.
START_DATE DATE The start date.
SURCHARGE_RATE_SCHEDULE_NO NUMBER The surcharge_rate_schedule_no for the referenced record.
SURCHARGE_RATE_SCHEDULE_TIER NUMBER The surcharge_rate_schedule_tier for the referenced record.
UNITS NUMBER The quantity of units for the referenced data.
USAGE_TYPE_NO NUMBER The unique identifier for a usage_type record.
USAGE_TYPE_CD TEXT The unique code for a usage_type record.
IS_CUSTOM_RATED BOOLEAN Is the record customer rated?
  • Was this article helpful?