Fields - Glsl Transaction
| Field Name | Data Type | Description, Example |
|---|---|---|
| sltransactionid | long | Id for transaction |
| transactiontype | string | Type of transaction |
| documentnumber | string | Id for document associated with transaction |
| scheduleidentifier | long | Id for transaction schedule |
| invoicedate | date | Date of invoice for transacation |
| documentamount | money | Total amount on document |
| discountamount | money | Discount amount for transaction |
| remainingamount | money | Difference of discount and document amount |
| accounttype | string | Type of account assocaited with transaction |
| description | string | Description for transaction |
| transactionnumber | long | Transaction number |
| datereceived | date | Date invoice was received |
| duedate | date | Date invoice is due |
| ponumber | string | PO Number on transaction |
| discountdate | date | Date discount was applied |
| discounttype | int | 0 - No discount 1 - Discount percent 2 - Direct dollar discount |
| transactionstate | string | Current state of transaction |
| lastmodifieddate | date | Date transaction was last modified |
| lastmodifiedby | string | Name of user modified transaction most recently |
| converted | int | Data imported before dealers go live |
| externaltransactionid | long | Id for external transaction tracking |
| edited | int | Indicator if transaction has been edited |
| editeddate | date | Date when transaction was edited |
| accountingstore | string | Name of accounting database |
| associatedstore | string | Name of the working database |