Table
The list of all tables referenced by TSWrite functions in this workbook. This list is only visible when there is more than one table being written to. The selected table controls what is displayed in the Records list.
Records
A list of the records that are to be updated for the selected table. The selected table’s name is displayed in the header row. The records list contains a column that specifies the action and a column for each field in the primary key. The possible actions are:
| Action | Description |
| Create Only | The record will be created if it does not already exist, and it will be ignored otherwise. |
| Create or Modify | The record will be modified if it exists, otherwise it will be created. |
| Ignore | The record will not be created or modified. Selecting Ignore automatically deselects every column in the Columns grid. Every TSWrite function for this record will return <Skipped> in Excel. |
| Modify Only | The record will be modified if it exists, otherwise it will be ignored. |
| Undefined | An invalid action was supplied to the TSWrite function, and you must select a valid action before data can be sent. |
Columns
Each row in the Columns grid represents a value that will be written to Sage 300 CRE. The Selected checkbox indicates whether or not the value will be sent to Sage 300 CRE. The Field Name indicates the name of the column that the value will be written to. The Value shows the data that will be written. You can double-click the Value cell to modify what will be sent before clicking Write.
Write
Click this button to send values to Sage 300 CRE.
Cancel
Click Cancel to discard your changes and dismiss the window.
Help
Click Help to display the web help the Approve Changes window.