InvoiceLine
Schema file for InvoiceLine.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the record. | |
| IsDeleted | Bool | True |
Indicates whether the record has been moved to the Recycle Bin. | |
| Name | String | False |
Name of the record. | |
| CurrencyIsoCode | String | False |
ISO code for the currency in which the revenue amount is expressed. | |
| CreatedDate | Datetime | True |
Date and time when the record was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the record. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the record. |
| InvoiceId | String | True |
Invoice.Id |
ID of the Invoice associated with this record. |
| ReferenceEntityItemId | String | False |
ID of the ReferenceEntityItem associated with this record. | |
| ReferenceEntityItemIdType | String | False |
Specifies the type of the 'ReferenceEntityItemId' polymorphic field to use in the statement. | |
| ReferenceEntityItemIdExternalFieldName | String | False |
Specifies the external field name of the 'ReferenceEntityItemId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| GroupReferenceEntityItemId | String | False |
ID of the GroupReferenceEntityItem associated with this record. | |
| GroupReferenceEntityItemIdType | String | False |
Specifies the type of the 'GroupReferenceEntityItemId' polymorphic field to use in the statement. | |
| GroupReferenceEntityItemIdExternalFieldName | String | False |
Specifies the external field name of the 'GroupReferenceEntityItemId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| Quantity | Double | False |
Quantity of the product. | |
| UnitPrice | Decimal | False |
Price per unit for the product. | |
| ChargeAmount | Decimal | False |
Field containing ChargeAmount information. | |
| TaxAmount | Decimal | False |
Field containing TaxAmount information. | |
| AdjustmentAmount | Decimal | False |
Field containing AdjustmentAmount information. | |
| InvoiceStatus | String | True |
Status of the Invoice. | |
| Description | String | False |
Text description of the record. | |
| InvoiceLineStartDate | Date | False |
Date associated with InvoiceLineStart. | |
| InvoiceLineEndDate | Date | False |
Date associated with InvoiceLineEnd. | |
| ReferenceEntityItemType | String | False |
Type classification for ReferenceEntityItem. | |
| ReferenceEntityItemTypeCode | String | False |
Field containing ReferenceEntityItemTypeCode information. | |
| Product2Id | String | False |
Product2.Id |
ID of the Product associated with this record. |
| RelatedLineId | String | False |
InvoiceLine.Id |
ID of the RelatedLine associated with this record. |
| Type | String | True |
Type of account or classification. | |
| TaxName | String | False |
Field containing TaxName information. | |
| TaxCode | String | False |
Field containing TaxCode information. | |
| TaxRate | Double | False |
Field containing TaxRate information. | |
| TaxEffectiveDate | Date | False |
Date associated with TaxEffective. | |
| GrossUnitPrice | Decimal | False |
Field containing GrossUnitPrice information. | |
| ChargeTaxAmount | Decimal | True |
Field containing ChargeTaxAmount information. | |
| ChargeAmountWithTax | Decimal | True |
Field containing ChargeAmountWithTax information. | |
| AdjustmentTaxAmount | Decimal | True |
Field containing AdjustmentTaxAmount information. | |
| AdjustmentAmountWithTax | Decimal | True |
Field containing AdjustmentAmountWithTax information. | |
| TaxProcessingStatus | String | False |
Status of the TaxProcessing. | |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| SystemModstamp | Datetime | True |
Date and time when the record was last modified by a user or by an automated process. | |
| LastModifiedDate | Datetime | True |
Date and time when the record was last modified. |