Portal Invoices
PortalInvoices
41 columns Fetched February 27, 2026
Columns
Billing_Log_RecID Numeric
Invoice_Number Text nullable
Invoice_Type Text
Billing_Type_ID Text nullable
Company_RecID Numeric
Also in 44 reports
Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code Company Company Address Company Company Type Descriptions Company Company Types Company Custom Fields Company Group Company Markets Company Mgmt Company State Tax Rate Company Team Company Work Roles Company Work Types Configuration Contact Contact Group Document Expense Invoice Expense Invoice Header Invoice Time Invoices Management Report Setup Member Certifications Opportunity Opportunity Restricted Portal Config Names Pricing Schedule Project Header Purchase Order Template Sales Commission Sales Order Service Location Service Summary Service Summary Open Time Unposted Expense Unposted Invoice Warehouse
CompanyRecId Numeric
Company_Name Text nullable
Owner_Level_RecID Numeric
Also in 48 reports
Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location
Billing_Status_RecID Numeric
Also in 4 reports
Date_Invoice DateTime nullable
Universal_Formatted_Date_Invoice Text nullable
Due_Date DateTime nullable
Universal_Formatted_Due_Date Text nullable
Universal_Formatted_Due_Date_Text Text nullable
Billing_Terms_RecID Numeric
Also in 7 reports
Status_Description Text nullable
Invoice_Amount Numeric
AGR_Header_RecID Numeric
Also in 20 reports
Agreement_Name Text nullable
TicketNbr Numeric
Ticket_Summary Text nullable
PM_Project_RecID Numeric
Project_ID Text nullable
Date_Created DateTime
Date_Closed DateTime nullable
Closed_Flag Boolean nullable
Date_Paid DateTime nullable
Universal_Formatted_Date_Paid Text nullable
Paid_Amount Numeric nullable
Processing_Flag Boolean
Credit_Amount Numeric nullable
Balance Numeric nullable
CurrencySymbol Text nullable
Updated_By Text nullable
Last_Update DateTime
Time_Zone Text nullable
Company_ID Text nullable
CompanyAccountNumber Text nullable
CompanyFinanceStatus Text nullable
IsoCurrencyCode Text nullable
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Billing_Log_RecID | Numeric | No | |
| Invoice_Number | Text | Yes | unique |
| Invoice_Type | Text | No | unique |
| Billing_Type_ID | Text | Yes | unique |
| Company_RecID | Numeric | No | 44 reports Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code Company Company Address Company Company Type Descriptions Company Company Types Company Custom Fields Company Group Company Markets Company Mgmt Company State Tax Rate Company Team Company Work Roles Company Work Types Configuration Contact Contact Group Document Expense Invoice Expense Invoice Header Invoice Time Invoices Management Report Setup Member Certifications Opportunity Opportunity Restricted Portal Config Names Pricing Schedule Project Header Purchase Order Template Sales Commission Sales Order Service Location Service Summary Service Summary Open Time Unposted Expense Unposted Invoice Warehouse |
| CompanyRecId | Numeric | No | unique |
| Company_Name | Text | Yes | unique |
| Remit_To_RecID | Numeric | No | |
| Owner_Level_RecID | Numeric | No | 48 reports Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location |
| Billing_Status_RecID | Numeric | No | |
| Date_Invoice | DateTime | Yes | unique |
| Universal_Formatted_Date_Invoice | Text | Yes | unique |
| Due_Date | DateTime | Yes | unique |
| Universal_Formatted_Due_Date | Text | Yes | unique |
| Universal_Formatted_Due_Date_Text | Text | Yes | unique |
| Billing_Terms_RecID | Numeric | No | |
| Status_Description | Text | Yes | unique |
| Invoice_Amount | Numeric | No | unique |
| AGR_Header_RecID | Numeric | No | |
| Agreement_Name | Text | Yes | unique |
| TicketNbr | Numeric | No | unique |
| Ticket_Summary | Text | Yes | unique |
| PM_Project_RecID | Numeric | No | |
| Project_ID | Text | Yes | unique |
| Date_Created | DateTime | No | unique |
| Date_Closed | DateTime | Yes | unique |
| Closed_Flag | Boolean | Yes | unique |
| Date_Paid | DateTime | Yes | unique |
| Universal_Formatted_Date_Paid | Text | Yes | unique |
| Paid_Amount | Numeric | Yes | unique |
| Processing_Flag | Boolean | No | unique |
| Credit_Amount | Numeric | Yes | unique |
| Balance | Numeric | Yes | unique |
| CurrencySymbol | Text | Yes | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | No | unique |
| Time_Zone | Text | Yes | unique |
| Company_ID | Text | Yes | unique |
| CompanyAccountNumber | Text | Yes | unique |
| CompanyFinanceStatus | Text | Yes | unique |
| IsoCurrencyCode | Text | Yes | unique |