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. |