versago:multi_select_table_structure
Multi-Select Database Table Structure Details
| Column Name | Type and Size | Notes |
| User columns from initial setup appear first | | |
| vgo_PaymentDate | DateTime | For payment processing |
| vgo_PaymentDetails | nvarchar(100) | For payment processing |
| vgo_CC_RespCode | nvarchar(50) | For payment processing |
| vgo_TransID | nvarchar(50) | For payment processing |
| vgo_PaymentType | Int | For payment processing |
| vgo_CreatedBy | nvarchar(50) | Creation information |
| vgo_CreateDate | DateTime | Creation information |
| vgo_CreatedById | Int | Creation information |
| vgo_PostingStatus | Int | Processing control |
| vgo_PostingDate | DateTime | Processing control |
| vgo_PostingId | Int | Processing control |
| vgo_BatchId | Int | Processing control |
| User columns added after initial setup appear last | | |
| | | |
Payment Processing items are used by the internal payment process. These values are only populated for payment transaction.
Creation Information items are populated for all transactions.
vgo_CreatedBy: Versago user ID (email) that created the transaction.
vgo_CreateDate: Date and time the transaction was created.
vgo_CreatedById: Versago internal user ID number.
Processing Control items can be used to manage back-end processing using tools such as Bizweaver.
vgo_PostingStatus: Typically used to indicate if a record has been processed by the back-end.
vgo_PostingDate: Typically used to capture when a record has been processed by the back-end.
vgo_PostingId: Typically used to capture the ID number of the record created during back-end processing.
vgo_BatchId: A sequential number added by the application when a set of records is added to the database. This value can be used to process a group of records together during back-end processing.
versago/multi_select_table_structure.txt · Last modified: 2019/09/20 09:58 (external edit)