ADO.NET Provider for Sage 200

Build 26.0.9655

SalesOrderReturnInvoiceCreditViews

Returns the collection of sales orders and returns and invoices and credit notes.

Columns

Name Type References Description
SopOrderReturnId Long Sales order return record Id.
SopOrderReturnDocumentTypeId Long Sales order return document type.
SopOrderReturnDocumentNo String Sales order return document number.
SopOrderReturnDocumentDate Datetime Sales order return document date.
SopOrderReturnDocumentStatusId Long Sales order return document status record Id.
SopOrderReturnCustomerDocumentNo String Sales order return customer document number.
SopOrderReturnTotalNetValue Decimal Sales order return net value.
SopOrderReturnTotalTaxValue Decimal Sales order return tax value.
SopOrderReturnTotalGrossValue Decimal Sales order return gross value.
CustomerId Long Customer record Id.
CustomerReference String Customer account reference.
CustomerName String Customer account name.
CustomerShortName String Customer account short name.
SopInvoiceCreditId Long Sales invoice credit record Id.
SopInvoiceCreditDocumentNo String Sales invoice credit document number.
SopInvoiceCreditTypeId Long Sales invoice credit type.
SopInvoiceCreditTypeName String Sales invoice credit type name.
SopInvoiceCreditDocumentDate Datetime Sales invoice credit document date time.
SopInvoiceCreditDocumentStatusId Long Sales invoice credit document status record Id.
SopInvoiceCreditTotalNetValue Decimal Sales invoice credit net value.
SopInvoiceCreditTotalTaxValue Decimal Sales invoice credit tax value.
SopInvoiceCreditTotalGrossValue Decimal Sales invoice credit gross value.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655