CustomerSalesOrderInvoiceCreditLine
The default sort (orderby) fields are by 'sop_invoice_credit_id' and 'sop_invoice_credit_line_id' descending.
Columns
| Name | Type | References | Description |
| CustomerId | Long | The associated customer record Id. See customers. | |
| CustomerName | String | The associated customer name. | |
| CustomerReference | String | The associated customer account reference. | |
| InvoiceCreditId | Long | Sales invoice credit Id. | |
| InvoiceCreditType | String | Sales invoice credit type. | |
| InvoiceCreditDocumentNo | String | Sales invoice credit document number. | |
| InvoiceCreditDocumentDate | Datetime | Sales invoice document date time (UTC). | |
| InvoiceCreditDocumentStatus | String | Sales invoice document status. | |
| InvoiceCreditExchangeRate | Decimal | Exchange rate for the sales invoice credit. | |
| InvoiceCreditDateTimeUpdated | Datetime | The date and time the sales invoice credit was last updated (UTC). | |
| InvoiceCreditLineId | Long | The associated sales invoice credit line Id. | |
| InvoiceCreditLineDate | Datetime | The invoice credit line date time (UTC). | |
| InvoiceCreditLineTotalValue | Decimal | The total value of the sop invoice credit line. | |
| InvoiceCreditLineTaxValue | Decimal | The tax value of the sop invoice credit line. | |
| InvoiceCreditLineDateTimeUpdated | Datetime | The date and time the sop invoice credit line was last updated (UTC). | |
| InvoiceLineProfitAnalysisId | Long | The associated sales invoice credit line profit analysis Id. | |
| InvoiceLineProfitAnalysisLineQuantity | Decimal | The quantity of the associated sop invoice credit line. | |
| InvoiceLineProfitAnalysisRealisedCostValue | Decimal | The realised cost value. | |
| InvoiceLineProfitAnalysisRealisedProfitValue | Decimal | The realised profit value. | |
| InvoiceLineProfitAnalysisDateTimeUpdated | Datetime | The date and time the sop invoice credit line profit analysis was last updated (UTC). | |
| ProductId | Long | The associated product record Id. See products. | |
| ProductCode | String | The code of the product ordered. | |
| ProductName | String | The name of the product ordered. | |
| ProductDescription | String | The associated product description. | |
| ProductDateTimeUpdated | Datetime | The date and time the product was last updated (UTC). | |
| ProductGroupId | Long | The associated product group record Id. | |
| ProductGroupCode | String | The associated product group code. | |
| ProductGroupDescription | String | The associated product group description. | |
| ProductGroupDateTimeUpdated | Datetime | The date and time the product group was last updated (UTC). |