CustomerSalesOrderInvoiceCreditLine
This resource returns a view of related customers, sales invoice credits, sales invoice credit lines, invoice line profit analysis, products, and product groups that can be queried on any field. 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). |