INVOICE_FACT¶

This fact table stores information about invoices.

Relationships¶

The following diagram illustrates the relationships between this table and other related tables.

INVOICE_FACT relationship diagram

Columns¶

Column	Data type	Description
`AGEDDAYS`	NUMBER	The number of days since an invoice became outstanding. For a visual reference of this data element in the source system, see Appendix B: AGEDDAYS.
`AGEGROUP`	VARCHAR	A category of the invoice based on its age group (0-30 days, 31-60 days, 61-90 days, over 90 days). For a visual reference of this data element in the source system, see Appendix B: AGEGROUP.
`ARAGINGINVOICEDUESTATUS`	VARCHAR	The status of the invoice indicating whether it is Within Due or Over Due. Default value: N/A
`AVERAGEDAYS`	NUMBER	The number of days between the due date and the maximum date posted for invoices with a 0 balance. For a visual reference of this data element in the source system, see Appendix B: AVERAGEDAYS.
`BALANCEAMOUNT`	NUMBER	The remaining amount of the invoice. For a visual reference of this data element in the source system, see Appendix B: BALANCEAMOUNT.
`BILLAMOUNT`	NUMBER	The total amount billed. For a visual reference of this data element in the source system, see Appendix B: BILLAMOUNT.
`BUILDID`	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
`COMPANYID`	NUMBER	The identifier for the company. For a visual reference of this data element in the source system, see Appendix B: COMPANYID.
`COMPANYKEY`	NUMBER	The identifier for the company.
`CREDITLIMIT`	NUMBER	The limit on the credit card.
`CUSTOMERGUID`	VARCHAR	A globally unique identifier for the customer.
`CUSTOMERID`	NUMBER	The identifier for the customer. For a visual reference of this data element in the source system, see Appendix B: CUSTOMERID.
`CUSTOMERNAME`	VARCHAR	The name of the customer.
`DAYSSALESOUTSTANDING`	NUMBER	The number of days it takes a staffing company to collect the payments from customer(s).
`DEPARTMENTNAME`	VARCHAR	The name of the department.
`DISCOUNTAMOUNT`	NUMBER	The dollar amount of a discount applied to an invoice.
`DUEDATE`	DATE	The date by which payment for the invoice is expected. For a visual reference of this data element in the source system, see Appendix B: DUEDATE.
`INVCOMPLETELYOUTSTANDING`	NUMBER	The total amount of completely outstanding invoices. For a visual reference of this data element in the source system, see Appendix B: INVCOMPLETELYOUTSTANDING.
`INVOICEAMOUNT`	NUMBER	The total amount of the invoice. For a visual reference of this data element in the source system, see Appendix B: INVOICEAMOUNT.
`INVOICEDATE`	DATE	The date and time the invoice was issued. For a visual reference of this data element in the source system, see Appendix B: INVOICEDATE.
`INVOICEGUID`	VARCHAR	A globally unique identifier for the invoice.
`INVOICEKEY`	NUMBER	The primary key referencing an invoice.
`INVOICENUMBER`	VARCHAR	A unique identifier assigned to an invoice. For a visual reference of this data element in the source system, see Appendix B INVOICENUMBER.
`INVOICETOPAYMENTSTATUS`	VARCHAR	The current payment status of an invoice (Partially Outstanding, Paid Outside Due Date, Complete Outstanding, and N/A).
`INVPAIDOUTSIDEDUEDATE`	NUMBER	An indication of whether an invoice was paid outside of its due date. For a visual reference of this data element in the source system, see Appendix B: INVPAIDOUTSIDEDUEDATE.
`INVPAIDWITHINDUEDATE`	NUMBER	An indication of whether an invoice was paid within its due date. For a visual reference of this data element in the source system, see Appendix B: INVPAIDWITHINDUEDATE.
`MAXDATEPOSTED`	DATE	The latest date an invoice was posted.
`OFFICEID`	NUMBER	The identifier for the office. For a visual reference of this data element in the source system, see Appendix B: OFFICEID.
`OFFICEKEY`	NUMBER	A foreign key referencing the office in the DIMOFFICE table.
`OVERDUEBALANCEAMOUNT`	NUMBER	The total balance amount of invoices that are overdue. Default value: 0
`PAYMENTAMOUNT`	NUMBER	The amount paid. For a visual reference of this data element in the source system, see Appendix B: PAYMENTAMOUNT.
`PAYMENTSOUTSIDEDUEDATE`	NUMBER	The total number of payments received after the invoice due date.
`PAYMENTSWITHINDUEDATE`	NUMBER	The total number of payments received within the invoice due date.
`PAYMENTTERMS`	VARCHAR	The Customer Payment Terms from Billing Setup, such as Due On Receipt, Net 2 Days, Net 10 Days, Net 12 Days, Net 15 Days, etc. For a visual reference of this data element in the source system, see Appendix B: PAYMENTTERMS.
`ROLLUPTOPARENTCUSTOMER`	VARCHAR	An indication of whether the rollup to parent customer is allowed or not.
`SALESTAXAMOUNT`	NUMBER	The total amount of sales tax. Formula: Sales Tax Rate * Gross Profit. For a visual reference of this data element in the source system, see Appendix B: SALESTAXAMOUNT.
`TOTALFINANCECHARGE`	NUMBER	The total finance charge accumulated for the invoice. For a visual reference of this data element in the source system, see Appendix B: TOTALFINANCECHARGE.
`WITHINDUEDATEBALANCEAMOUNT`	NUMBER	The total balance amount of invoices that are still within their due date. Default value: 0