Home > Technical > Table Definitions > TABLEDETAILS

TABLEDETAILS

Records details about the tables to be replicated.

Column Type Description

STRTABLENAME

VARCHAR(30)

The name of the table to be replicated.

STRKEYNAME

VARCHAR(200)

A comma-delimited list of fieldnames that are the unique key for the table.

YSNTRIGGERS

VARCHAR(1)

‘T’ if replication triggers are in place for this table.

STRLOCATIONFIELD

VARCHAR(50)

The name of the field containing the include location. When we create a replication file for a location, the contents of this field must be empty or match the location the file is being created for. (A match is made when the location is anywhere within the location hierarchy).

MEMREPFIELDS

TEXT(16)

A comma-delimited list of fields in the table to be replicated.

YSNREPALLFIELDS

VARCHAR(1)

‘T’ if all fields are to be replicated.

STRLOCATIONEXCLUDEDFIELD

VARCHAR(50)

The name of the field containing the exclude location. When we create a replication file for a location, the contents of this field must be empty or NOT match the location the file is being created for. (A match is made when the location is anywhere within the location hierarchy).

YSNKEEPTRIGGERDURINGREP

VARCHAR(1)

‘T’ if triggers are to remain in place during replication. If ‘F’ triggers will be removed before replicating and recreated afterwards.

YSNREPADD

VARCHAR(1)

‘T’ if insertions into this table need to be replicated.

YSNREPUPD

VARCHAR(1)

‘T’ if updates into this table need to be replicated.

YSNREPDEL

VARCHAR(1)

‘T’ if deletions into this table need to be replicated.

STRLOCATIONXREFTABLENAME

VARCHAR(30)

The records is one table can be replicated based on the fact that a related table has changed. For example, you may want to send purchase order details if the purchase order header has changed. This is the name of the table that needs to be linked to.

STRLOCATIONXREFKEY

VARCHAR(50)

Used in conjunction with strLocationXRefTableName, this is a comma-delimited list of that table's primary key.

YSNCHECKFIELDSCHANGED

VARCHAR(1)

If you are only replicating some fields from a table this can be set to 'T' to make the update trigger check for changes in those fields before logging the record. This means that if only a field that is not to be replicated is changed, the record details are not replicated.

STRCHANGEFLAGFIELD

VARCHAR(50)

Rather than use triggers to track replication change, you can set up a table to replicate rows where a changed flag has been set to 'T', for example STORERNG.ysnChanged. This is the name of the field that should be checked. If it is empty, this method will not be used for replication.

YSNREPLICATEALLROWS

VARCHAR(1)

If this is 'T' then all rows will always be replicated each time.

YSNREPENABLED

VARCHAR(1)

'T' if replication is currently enabled for this table.

STREXPORTFOLDERS

VARCHAR(50)

 

YSNMAINEXPORT

VARCHAR(1)

 

INTCODE

INT(4)

 

 

Primary Key: INTCODE + STRTABLENAME

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)