Table 1. Sequences
Sequence Name Notes
NextReplNbr Increments the Sequence Number for each New ReplQueue Record
Table 2. TablesThe following are a list of Replication database Tables:
Name Label
ReplControl Replication Control
ReplCustAsgn Custom Assignments
ReplCustDefs Custom Definitions
ReplCustFlds Custom Fields
ReplDBXRef Database Cross Reference
ReplFieldXref Column Cross-Reference
ReplProperties Properties
ReplQueue Replication Queue
ReplTableXRef Table Cross-Reference
Table 3. ReplControl – Replication control
Field name Data type Notes
GroupID Character Control Group
CodeID Character Group Sub Code
CodeVal1 Character First Sub Code Filter
CodeVal2 Character Second Sub Code Filter
CodeVal3 Character Record Value
Index name Components Unique Primary
idxControl GroupID Yes Yes
CodeID
CodeVal1
CodeVal2

ReplCustAsgn - Custom assignments

No fields or indexes are defined at this time.

Table 4. ReplCustDefs - Custom definitions
Field name Data type Notes
SrcDB Character Source Database Name
SrcTable Character Source Table Name
CustName Character Name
CustDefType Character Definition Type (Variable, Temp-Table, or Buffer)
CustMisc Character If set to CustDefType the Data Type is a Variable. Otherwise, is the name of the table that this temp-table or buffer corresponds to.
Table 5. ReplCustFlds - Custom fields
Field name Data type Notes
SrcDB Character Source Database Name
SrcTable Character Source Table Name
FldName Character Name of this field
FldDataType Character Data type
FldWidth Integer Maximum width of a field. It applies to Decimal and Varchar Fields only
FldDec Integer Maximum number of Decimals
FldMand Logical Indicates if a field is mandatory field. It is set to No by default.
Table 6. ReplDBXRef - Database cross-reference
Field name Data type Notes
SrcDB Character Source Database
SchHldr Character Schema Holder DB
SchImg Character Target Schema Image
TgtType Character Target DB Type
TgtConnName Character Target DB Connection
TgtPhysName Character Target DB Physical Name
GenQRec Logical Generate Queue Record
ProcQRec Logical Process Queue Record
SrcPhysName Character Source DB Physical Name
SchPhysName Character Schema Holder DB Physical
Index name Components Unique Primary
idxDBXRef SrcDB Yes Yes
idxDBType TgtType
Table 7. ReplFieldXRef - Field cross-reference
Field name Data type Notes
SrcDB Character Source Database
SrcTable Character Source table
SrcField Character Source field
SrcDataType Character Source data type
SrcOrder Integer Field Order
SchField Character Schema Field
SchDataType Character Schema Data Type
TgtField Character Target Field
TgtDataType Character Target Data Type
TgtPrec Integer Target Precision
TgtScale Integer Scale
SrcExtent Integer Source Extent
TgtExtent Integer Target Extent
OverrideDefs Logical Override Precision/Scale Defaults
Index name Components Unique Primary
idxFldXRef SrcDB Yes Yes
SrcTable
SrcField
idxSrcOrder SrcDB
SrcTable
SrcOrder
Table 8. ReplProperties – Replication properties
Field name Data type Notes
PropertyName Character Property Name
PropertyValue Character Property Value
Index name Components Unique Primary
idxProperties PropertyName Yes Yes
Table 9. ReplQueue - Replication Queue
Field name Data type Notes
Sequence Integer Sequence Number
EventType Character Event Type Single Letter – Create, Write, Delete
SrcDB Character Replication Record’s Source Database
SrcTable Character Replication Record’s Source Table
SrcRecord Character Source Record ROWID
EventDate Date Date Replication Record was Generated
EventTime Character Time Replication Record was Generated
SrcTransID Integer Source Database Transaction Number
Username Character User Id of Transaction
Applied Logical Replication Record Processed over to SQL
ApplDate Date Date Replication Record was Processed
ApplTime Character Time Replication Record was Applied
Audited Logical Audited? (Verification)
AudDate Date Audited Date of Verification
AudTime Character Audit Time of Verification
UserCust Character User Custom Data
RawData Raw Field to Store RAW information about the Record
QThread Integer Replication Queue Processing Thread #
Sequence Integer Sequence Number
Index name Components Unique Primary
idxApplied Applied No No
QThread
Sequence
idxAudited Audited No No
idxSeq Sequence Yes Yes
idxSrcRecord SrcRecord No No
idxSrcTable SrcTable No No
Table 10. ReplTableXRef - Table cross-reference
Field name Data type Notes
SrcDB Character Source Database
SrcTable Character Source table
SchTable Character Schema Table
TgtTable Character Target Table
GenQRec Logical Generate Queue Record
ProcQRec Logical Process Queue Record
QThread Integer Queue Thread #
UseInDiff Logical Include in Differential
TrigInst Logical Trigger Installed
MrgdTrig Logical Merged Triggers
OrigDTrigProc Character Original Delete Trigger
OrigWTrigProc Character Original Write Trigger
Index name Components Unique Primary
idxDiff UseInDiff No No
idxTblXRef SrcDB Yes Yes
SrcTable
idxThread QThread No No