InvoiceItem
A line item in an invoice.
Columns
| Name | Type | Description |
| soldtocontactid | String | The 'soldtocontactid' column for the 'invoiceitem' table. |
| accountid | String | The 'accountid' column for the 'invoiceitem' table. |
| accountingcode | String | The 'accountingcode' column for the 'invoiceitem' table. |
| updateddate | Datetime | The 'updateddate' column for the 'invoiceitem' table. |
| productid | String | The 'productid' column for the 'invoiceitem' table. |
| invoiceid | String | The 'invoiceid' column for the 'invoiceitem' table. |
| chargeamount | Decimal | The 'chargeamount' column for the 'invoiceitem' table. |
| taxamount | Decimal | The 'taxamount' column for the 'invoiceitem' table. |
| subscriptionid | String | The 'subscriptionid' column for the 'invoiceitem' table. |
| createdbyid | String | The 'createdbyid' column for the 'invoiceitem' table. |
| taxcode | String | The 'taxcode' column for the 'invoiceitem' table. |
| revrecstartdate | Date | The 'revrecstartdate' column for the 'invoiceitem' table. |
| servicestartdate | Date | The 'servicestartdate' column for the 'invoiceitem' table. |
| taxexemptamount | Decimal | The 'taxexemptamount' column for the 'invoiceitem' table. |
| journalentryid | String | The 'journalentryid' column for the 'invoiceitem' table. |
| defaultpaymentmethodid | String | The 'defaultpaymentmethodid' column for the 'invoiceitem' table. |
| parentaccountid | String | The 'parentaccountid' column for the 'invoiceitem' table. |
| taxmode | String | The 'taxmode' column for the 'invoiceitem' table. |
| billtocontactsnapshotid | String | The 'billtocontactsnapshotid' column for the 'invoiceitem' table. |
| amendmentid | String | The 'amendmentid' column for the 'invoiceitem' table. |
| appliedtoinvoiceitemid | String | The 'appliedtoinvoiceitemid' column for the 'invoiceitem' table. |
| rateplanchargeid | String | The 'rateplanchargeid' column for the 'invoiceitem' table. |
| serviceenddate | Date | The 'serviceenddate' column for the 'invoiceitem' table. |
| updatedbyid | String | The 'updatedbyid' column for the 'invoiceitem' table. |
| deferredrevenueaccountingcodeid | String | The 'deferredrevenueaccountingcodeid' column for the 'invoiceitem' table. |
| productrateplanid | String | The 'productrateplanid' column for the 'invoiceitem' table. |
| quantity | Decimal | The 'quantity' column for the 'invoiceitem' table. |
| chargename | String | The 'chargename' column for the 'invoiceitem' table. |
| recognizedrevenueaccountingcodeid | String | The 'recognizedrevenueaccountingcodeid' column for the 'invoiceitem' table. |
| billtocontactid | String | The 'billtocontactid' column for the 'invoiceitem' table. |
| soldtocontactsnapshotid | String | The 'soldtocontactsnapshotid' column for the 'invoiceitem' table. |
| rateplanid | String | The 'rateplanid' column for the 'invoiceitem' table. |
| chargedate | Datetime | The 'chargedate' column for the 'invoiceitem' table. |
| uom | String | The 'uom' column for the 'invoiceitem' table. |
| unitprice | Decimal | The 'unitprice' column for the 'invoiceitem' table. |
| productrateplanchargeid | String | The 'productrateplanchargeid' column for the 'invoiceitem' table. |
| createddate | Datetime | The 'createddate' column for the 'invoiceitem' table. |
| processingtype | String | The 'processingtype' column for the 'invoiceitem' table. |
| id | String | The 'id' column for the 'invoiceitem' table. |
| sku | String | The 'sku' column for the 'invoiceitem' table. |
| balance | Decimal | The 'balance' column for the 'invoiceitem' table. |
| accountreceivableaccountingcodeid | String | The 'accountreceivableaccountingcodeid' column for the 'invoiceitem' table. |