Superannuation fund details for an AccountRight company file.
Table Specific Information
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, EmployerMembershipNumber, Name, PhoneNumber, Website. All the other columns and operators are processed client side.
SELECT * FROM SuperannuationFunds WHERE ID = "a05b34e5-5d10-465a-98ae-aa2a7eb65a35" SELECT * FROM SuperannuationFunds WHERE Name = "AMP Life"
|ID [KEY]||Uuid||Unique identifier in the form of a guid.|
|EmployerMembershipNumber||String||Employer Membership number.|
|Name||String||Name of the superannuation fund.|
|PhoneNumber||String||Superannuation fund contact phone number.|
|Website||String||World wide web address for superannuation fund.|
|RowVersion||String||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||Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.|
|CompanyFileId||String||The ID of the company file. Takes precedence over the CompanyFileId connection property.|