Difference between revisions of "Writing Data"

1,294 bytes added ,  18:09, 14 November 2016
no edit summary
(Created page with "== Overview == ODBClink allows you to write data into your accounting package. '''Note that this feature is only available in ODBClink Pro Edition'''. ODBClink provides a ...")
 
Line 31: Line 31:


=== Fields used to return result information ===
=== Fields used to return result information ===
Each import table include specialised fields to provide result information. These fields do depend on the accounting package you are integrating with.
* '''RecordedUID''' is used for MYOB AccountRight Live and provides the '''UID''' of the transaction or data recorded. For endpoints that do not have a UID, the field will either contain the words ''Imported''' or '''Not Imported'''.
* '''RecordedRowVersion''' is used for MYOB AccountRight Live and provides the '''RowVersion''' of the transaction or data recorded. For endpoints that do not have a RowVersion, the field will either contain the words ''Imported''' or '''Not Imported'''.
* '''RecordedDate''' is used for MYOB AccountRight Live and provides the date when the transaction was recorded. If the import process failed, it will be set to NULL. This fields is also used a control field. ODBClink will only attempt to import records which have a RecordedDate of NULL.
* '''RecordedResult''' is a text field used for MYOB AccountRight Live and provides the descriptive result returned by the import process. If the import was successful, it will set to '''Success'''. Any other value is an error and provides the description of the error.
=== Fields used as data ===
All other fields in an import table are used as data field.
1,344

edits