Snowflake VC Object: Pending Invoice Lines
- ► Pending Invoice Lines
-
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. 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?