Invoices
Columns
Name
Type
ReadOnly
Description
Id [KEY]
String
False
The unique identifier for this record.
InvoiceOwner_Id
String
False
The Id of the owner of this invoice.
InvoiceOwner_Name
String
True
The name of the owner of this invoice.
InvoiceNumber
String
False
The number of this invoice.
Subject
String
False
The subject of this invoice.
SalesOrder_Id
String
False
The Id of the sales order linked to this invoice.
SalesOrder_Name
String
True
The name of the sales order linked to this invoice.
InvoiceDate
Date
False
The date listed in the invoice.
PurchaseOrder
String
False
The purchase order linked with this invoice.
DueDate
Date
False
The date when this invoice is due at.
ExciseDuty
Double
False
The amount of excise duty for this invoice.
SalesCommission
Double
False
The amount of sales commission for this invoice.
Status
String
False
The status of the invoice.
AccountName_Id
String
False
The Id of the account linked with this invoice.
AccountName_Name
String
True
The name of the account linked with this invoice.
CreatedBy_Id
String
False
The Id of the User who created the record.
CreatedBy_Name
String
True
The name of the user who created the record.
ContactName_Id
String
False
The Id of the contact linked with this invoice.
ContactName_Name
String
True
The name of the contact linked with this invoice.
ModifiedBy_Id
String
False
The Id of the User who modified the record.
ModifiedBy_Name
String
True
The name of the User who modified the record.
CreatedTime
Datetime
False
The time when the record was created.
ModifiedTime
Datetime
False
The time when the record was modified.
Tag
String
False
A list of tags related to this invoice.
BillingStreet
String
False
The billing street of the invoice.
ShippingStreet
String
False
The shipping street of the invoice.
BillingCity
String
False
The billing city of the invoice.
ShippingCity
String
False
The shipping city of the invoice.
BillingState
String
False
The billing state of the invoice.
ShippingState
String
False
The shipping state of the invoice.
BillingCode
String
False
The billing code of the invoice.
ShippingCode
String
False
The shipping code of the invoice.
BillingCountry
String
False
The billing country of the invoice.
ShippingCountry
String
False
The shippingcountry of the invoice.
ProductDetails
String
False
A json aggregate of the product details for this invoice.
SubTotal
Double
True
The subtotal of this invoice.
Discount
Double
False
The discount applied to this invoice.
Tax
Double
True
The tax applied to this invoice.
Adjustment
Double
False
The adjustment applied to this invoice.
GrandTotal
Double
True
The grand total of this invoice.
TermsandConditions
String
False
The terms and conditions of this invoice.
Description
String
False
The description of this invoice.
Pseudo-Columns
Name
Type
Description
Word
String
Used to search for a specific word in records.
DuplicateCheckFields
String
The field/s to be used for checking in an upsert.
Converted
Boolean
Set to true to return only converted records.
Approved
Boolean
Set to true to return only approved records.
CustomViewId
String
The custom view Id to be used for filtering this record.
Last updated