Snowflake VM Object: Pending Invoice Lines

Last updated
Save as PDF

► Pending Invoice Lines

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
INVOICE_NO	NUMBER	The aria facing unique identifier for an invoice
LINE_NO	NUMBER	the line_no for the referenced record
ADVANCE_BILLING_PERIOD_TOTAL_DAYS	NUMBER	the advance_billing_period_total_days for the referenced record
BASE_PLAN_UNITS	NUMBER	the base_plan_units for the referenced record
COMMENTS	TEXT	The detailed comments related to the referenced data
CREDIT_COUPON	TEXT	the credit_coupon for the referenced record
CREDIT_REASON	TEXT	the credit_reason for the referenced record
END_DATE	DATE	the end_date for the referenced record
IS_TAX_RELATED	BOOLEAN	A True or False indicator showing if the record is tax related
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE	TEXT	the nonsubscription_offering_rate_schedule for the referenced record
NONSUBSCRIPTION_OFFERING_RATE_SCHEDULE_TIER	TEXT	the nonsubscription_offering_rate_schedule_tier for the referenced record
PLAN_NO	NUMBER	The Aria facing unique identifier for a plan
PLAN_INSTANCE_NO	NUMBER	The Aria facing unique identifier for a plan_instance
PLAN_RATE_SCHEDULE	VARIANT	An embedded one to many JSON subrecord related to plan_rate_schedule
PLAN_RATE_SCHEDULE_SERVICE_TIER	TEXT	the plan_rate_schedule_service_tier for the referenced record
PRORATION_DESCRIPTION	TEXT	the proration_description for the referenced record
PRORATION_FACTOR	TEXT	the proration_factor for the referenced record
PRORATION_OPERATION_TYPE	TEXT	the proration_operation_type for the referenced record
PRORATION_REMAINING_DAYS	NUMBER	the proration_remaining_days for the referenced record
PURCHASE_ORDER_NUMBER	TEXT	The aria facing unique identifier for a purchase order
RATE	NUMBER	the rate for the referenced record
SERVICE_NO	NUMBER	the service_no for the referenced record
CLIENT_SERVICE_ID	TEXT	the client_service_id for the referenced record
SERVICE_CREDIT	TEXT	the service_credit for the referenced record
SERVICE_CREDIT_SOURCE_TRANSACTION	VARIANT	An embedded one to many JSON subrecord related to service_credit_source_transaction
START_DATE	DATE	the start_date for the referenced record
SURCHARGE_RATE_SCHEDULE	VARIANT	An embedded one to many JSON subrecord related to surcharge_rate_schedule
SURCHARGE_RATE_SCHEDULE_TIER	VARIANT	An embedded one to many JSON subrecord related to surcharge_rate_schedule_tier
UNITS	NUMBER	the units for the referenced record
USAGE_TYPE	TEXT	the usage_type 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