ADO.NET Provider for MYOB

Build 24.0.9062

CreditRefunds

Return, create and delete credit notes refunded to customers for an AccountRight company file.

Table Specific Information

Select

MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criteria can be executed by combining the criteria with AND and OR operators. These columns support the above comparison types for server side filtering: ID, Date, DeliveryStatus, Memo, Number, Payee, Amount, ChequePrinted, AccountID, AccountDisplayID, AccountName, CustomerID, CustomerDisplayID, CustomerName, InvoiceID, InvoiceNumber. All the other columns and operators are processed client side.

SELECT * FROM CreditRefunds WHERE ID = "6d35e53a-5070-432d-b9ec-f4791e353352
SELECT * FROM CreditRefunds WHERE AccountName = "AccountName"
SELECT * FROM CreditRefunds WHERE Amount = 340.44

Insert

The following attributes are required when performing an insert: Date, Amount, AccountID, CustomerID, InvoiceID.

INSERT INTO CreditRefunds (Date, Amount, AccountID, CustomerID, InvoiceID) VALUES ("01/02/2019", 54, "3a35e83a-5070-432d-b6ec-f4791f353352", "2619bed9-3750-45b5-b353-18f5651beb01", "f6703af2-7494-4ecc-b0f6-b2bb9c813782")

Columns

Name Type ReadOnly References Description
ID [KEY] Uuid True

Unique identifier in the form of a guid.

Date Datetime False

Transaction date.

DeliveryStatus String False

Remittance advise delivery status assigned to credit note: Print = ToBePrinted, Email = ToBeEmailed, PrintAndEmail = ToBePrintedAndEmailed, Nothing = AlreadyPrintedOrSent.

Memo String False

Memo text describing the credit refund.

Number String False

Sales invoice number

Payee String False

Payee address on the credit note belonging to the customer contact.

Amount Decimal False

Total credit amount to be refunded, can be equal to or less than the invoice amount.

ChequePrinted Boolean False

True or false.

RowVersion String True

Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.

URI String True

Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.

AccountID Uuid True

Accounts.ID

Unique identifier for the account in the form of a guid.

AccountDisplayID String True

Account code. Format includes separator ie 4-1100

AccountName String True

Name of the account.

AccountURI String True

Uniform resource identifier associated with the account object.

CustomerID Uuid True

Contacts.ID

Unique guid identifier belonging to the assigned customer contact.

CustomerDisplayID String True

Customer contact Card ID, can also be used as a unique customer contact identifier.

CustomerName String True

Name of the customer contact.

CustomerURI String True

Uniform resource identifier associated with the customer contact object.

InvoiceID Uuid False

SaleInvoices.ID

Unique identifier in the form of a guid.

InvoiceNumber String True

Invoice number.

InvoiceURI String True

Uniform resource identifier associated with the invoice.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062