...
| Fields | Description |
| Checkbook Currency | A label used to identify the Currency of the Checkbook. Receipts cannot be posted if this value is missing. This is a looked-up value and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| CheckbookSK | A label used to identify the SK value of the Checkbook. This is a looked-up value, that is primarily used for support, and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| Created | A label used to identify the Created Date/Time of the Transaction. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| Created By | A label used to identify the name of the user that created the Transaction. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| CustomerSK | A label used to identify the SK value of the Customer on the Transaction. This is a looked-up value, that is primarily used for support, and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| GL Date | A date field used to enter the date the transaction will post to the General Ledger. This defaults to blank and is set to the Transaction Date on Approve or Ready to Post. If a user manually sets this value then it is not overwritten on Approve/Ready to Post. This date must be a valid date that falls within an open fiscal period for Sales. If not, the message "Receipt Date is required." will be displayed. This field is only editable while the transaction Status is "New" but is disabled once an application for this receipt has been made. Linked Database Field: ERPx_#####.#####. |
| Last Updated | A label used to identify the Last Updated Date/Time of the Transaction. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| Last Updated By | A label used to identify the name of the user that last updated the Transaction. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| Receipt Currency | A label used to identify the Currency of the Receipt. Receipts may not always be in the same currency as the Checkbook. This comes from the value assigned on Home tab and is not editable from here. Linked Database Field: ERPx_#####.#####. |
| Transaction ID | A label used to identify the Transaction. This is a system assigned value that is not editable by a user. Linked Database Field: ERPx_#####.#####. |
| TransactionSK | A label used to identify the SK value of the Transaction. This is a looked-up value, that is primarily used for support, and is never editable by a user. Linked Database Field: ERPx_#####.#####. |
| MC: Exchange Date From | A date field used to show the 'Start Date' of the 'Exchange Rate' from the Exchange Table that applies assigned to this transaction. The exchange Rate is looked-up based on the Transaction Date, not the GL Date. This field is only visible when the 'Receipt Currency' and 'Checkbook Currency' do not match is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. |
| MC: Exchange Date To | A date field used to show the 'End Date' of the 'Exchange Rate' from the Exchange Table that applies Table assigned to this transaction. The exchange Rate is looked-up based on the Transaction Date, not the GL Date. This field is only visible when the 'Receipt Currency' and 'Checkbook Currency' do not match is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. |
| MC: Exchange Rate | A label to show the 'Exchange Rate' that applies to this transaction. The 'Exchange Rate' is looked-up from the 'Exchange Table' assigned to this transaction, based on the Transaction Date, not the GL Date. This field is only visible when the 'Receipt Currency' and 'Checkbook Currency' do not match is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. |
| MC: Exchange Rate Calculation Method | A label to show the 'Calculation Method' property from the 'Exchange Table' assigned to this transaction. This field is only visible when the 'Receipt Currency' and 'Checkbook Currency' do not match is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. |
| MC: Exchange Table | A label to show which the Exchange Table the assigned to this transaction is using. This field is only visible when the 'Receipt Currency' and 'Checkbook Currency' do not match is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. ***How is this assigned?*** |
| MC: From Currency | A label to show the 'From Currency' property from the 'Exchange Table' assigned to this transaction. This field is only visible when the 'Receipt Currency' and 'Checkbook Currency' do not match is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. |
| MC: To Currency | A label to show the 'To Currency' property from the 'Exchange Table' assigned to this transaction. This field is only visible when the 'Receipt Currency' and 'Checkbook Currency' do not match is not in the Home Currency. This is a looked-up value and is not editable. Linked Database Field: ERPx_#####.#####. |
...