This is an old revision of the document!

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.

Wiki