DebitRefunds
Return all purchase bill types 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 criterias can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: ID, Amount, Date, DepositTo, Memo, Number, PaymentMethod, BillID, BillNumber, AccountID, AccountDisplayID, AccountName, SupplierID, SupplierDisplayID, SupplierName. All the other columns and operators are processed client side.
SELECT * FROM DebitRefunds WHERE ID = "7cabea25-6250-4df5-bb37-77eb2d38f803" SELECT * FROM DebitRefunds WHERE Amount = 1600.00 SELECT * FROM DebitRefunds WHERE AccountName = "Processing account"
Insert
The following attributes are required when performing an insert: Amount, Date, DepositTo, BillID, AccountID.
INSERT INTO DebitRefunds(Date, Amount, AccountID, DepositTo, BillID) VALUES("01/02/2019", 54, "3a35e83a-5070-432d-b6ec-f4791f353352", "Account", "f6703af2-7494-4ecc-b0f6-b2bb9c813782")
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. |
| Amount | Double | False |
Total amount of the debit to be refunded, can be equal to or less than the bill amount. |
| Date | Datetime | False |
The date of the entry. |
| DepositTo | String | False |
If allocating a banking account for the payment specify Account. If using undeposited funds specify UndepositedFunds. |
| Memo | String | False |
Memo text for the object. |
| Number | String | False |
Purchase bill number. |
| PaymentMethod | String | False |
Payment method text. |
| 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. |
| BillID | Uuid | False |
Unique identifier in the form of a guid. |
| BillNumber | String | True |
Bill number. |
| BillURI | String | True |
Uniform resource identifier associated with the bill. |
| AccountID | Uuid | False |
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. |
| SupplierID | Uuid | False |
Unique guid identifier belonging to the assigned supplier contact. |
| SupplierDisplayID | String | True |
Customer contact Card ID, can also be used as a unique supplier contact identifier. |
| SupplierName | String | True |
Name of the supplier contact. |
| SupplierURI | String | True |
Uniform resource identifier associated with the supplier contact object. |
| CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |