Multi-Select Database Table Structure Details

Column Name Type and SizeNotes
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
  1. Payment Processing items are used by the internal payment process. These values are only populated for payment transaction.
  2. Creation Information items are populated for all transactions.
  3. vgo_CreatedBy: Versago user ID (email) that created the transaction.
  4. vgo_CreateDate: Date and time the transaction was created.
  5. vgo_CreatedById: Versago internal user ID number.
  6. Processing Control items can be used to manage back-end processing using tools such as Bizweaver.
  7. vgo_PostingStatus: Typically used to indicate if a record has been processed by the back-end.
  8. vgo_PostingDate: Typically used to capture when a record has been processed by the back-end.
  9. vgo_PostingId: Typically used to capture the ID number of the record created during back-end processing.
  10. 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.