The V_INVOICESTATUS view in the DBO schema provides a comprehensive financial summary for each invoice issued to customers. It consolidates core invoice attributes, payment status, aging information, and financial balances—both with and without fees and interest. This view is central to understanding customer liabilities, payment behavior, and the status of invoicing operations.
All monetary values are presented from Telefakt’s perspective, meaning:
Positive amounts indicate money owed to Telefakt.
Negative amounts represent money Telefakt owes to the customer (e.g., credits or overpayments).
Key Attributes
Invoice Identification and Metadata
Column
Description
V_INVSTAT_INV_ID
Primary key from the INVOICE table (INV_ID). Uniquely identifies the invoice.
V_INVSTAT_INV_DATE
Date when the invoice was created.
V_INVSTAT_INV_DUE_DATE
The due date for the invoice payment.
V_INVSTAT_INV_INVOICE
The type of invoice – either Invoice or Credit Note.
V_INVSTAT_INV_CREDIT_ID
Links to the opposing invoice or credit note in case of cross-referencing.
V_INVSTAT_YEAR
Year in which the invoice was issued.
Payment & Status Tracking
Column
Description
V_INVSTAT_INV_PAYMENT_STATUS
User-friendly text representation of invoice status, based on financial values.
V_INVSTAT_DAYS_OVERDUE
Days past the due date; negative values indicate not yet due.
V_INVSTAT_LAST_PLACEMENT_DATE
Date of the last recorded financial movement on the invoice.
V_INVSTAT_LAST_PAYMENT
Date of the most recent payment made toward this invoice.
V_INVSTAT_LAST_UPDATED
Timestamp when this record was last updated.
V_INVSTAT_LAST_IMPORT_FILENAME
Origin of the last update. Always reports "Arvatoqueue" as updater.
Customer Information
Column
Description
V_INVSTAT_BU_ID
Customer ID (BU_ID) from the BUSINESS table.
V_INVSTAT_BU_NAME
Name of the customer or company.
V_INVSTAT_BU_LOCATION
Site/department associated with the customer, e.g., branch office.
V_INVSTAT_BU_CUST_OWNER
Owner of the customer account.
Financials – Base Currency (Usually NOK)
Column
Description
V_INVSTAT_INVOICED
The invoiced amount in NOK.
V_INVSTAT_PAID
Total paid amount in NOK. May be negative if overpaid.
V_INVSTAT_CREDITED
Total amount credited to this invoice.
V_INVSTAT_BALANCE
Current balance excluding fees and interest.
V_INVSTAT_BALANCE_W_FEE_INT
Balance including fees and interest.
V_INVSTAT_TOTAL_DUE
Amount due (excl. fees & interest) only if invoice is overdue.
V_INVSTAT_DUE_WO_FEES_AND_INT
Due balance including fees & interest only if overdue.
V_INVSTAT_ADDED_FEES
Additional fees appended post-invoicing.
V_INVSTAT_FEES_PAID
Portion of fees already paid.
V_INVSTAT_PAID_OUT
Amount paid out to the customer (refunds, credits).
V_INVSTAT_WRITTEN_OFF
Losses written off from the invoice (unrecoverable debt).
V_INVSTAT_TRANSFERRED
Unpaid interest transferred from a previous invoice. Matches inv_transferred_interest in INVOICE.
V_INVSTAT_ACCRUED
Unpaid charges (non-interest) transferred from a previous invoice. Matches inv_transferred_charges in INVOICE.
Financials – Original Invoice Currency
Column
Description
V_INVSTAT_CUR_NAME
Currency name as per ISO standard (usually NOK).
V_INVSTAT_CUR_INVOICED
Invoiced amount in the original currency of issuance.
Deprecated or Unused Columns
These columns are included for legacy or placeholder reasons and should be ignored in production use:
Column
Reason
V_INVSTAT_INV_NUMBER
Historic invoice number; not used anymore.
V_INVSTAT_CREDIT_INV_ID
Duplicate of V_INVSTAT_INV_CREDIT_ID.
V_INVSTAT_APPLIED
Always set to 0. Placeholder with no current use.
V_INVSTAT_LAST_REMINDER
(No description provided). Presumably, last reminder communication sent.
Usage Recommendations
Use this view for financial dashboards, overdue invoice reports, and collections analysis.
For legal or financial reconciliation, join with the INVOICE and BUSINESS tables using INV_ID and BU_ID.
To check outstanding liabilities, reference V_INVSTAT_BALANCE.
For monitoring write-offs or overpayments, rely on V_INVSTAT_WRITTEN_OFF and negative V_INVSTAT_PAID.
Caveats
Deprecated columns are retained for backward compatibility but should not be referenced in new queries or reports.
The LAST_IMPORT_FILENAME will always show "Arvatoqueue".
