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