Mass Maintenance
Create all tt Tables and tx Views for the Integrate Process
Before performing this task, create a looped template and process in Integrate. Refer to BDC Script Template with Looping Enabled or GUI Script Template with Looping Enabled in Integrate for more information.
Create the tt tables and tx views for the each loop -- header and detail data -- manually or by using the Auto Generate functionality in Integrate. Refer to Generate Database Objects Automatically for more information.
Tables and views may be created in cMass_Data or any database that has a supporting component and data source registered in the Stewardship Tier.
If using auto-generated tables, add these columns to each tt table. If manually generating the tables, include these columns:
NOTE: ID column must be set as the PrimaryKey of the tt Table.
Column Name |
Data Type |
Value |
RequestID NOTE: Place this column underneath the ID and ParentID columns. |
int |
NULL |
PostError |
int |
NULL DEFAULT (2) |
PostMessage |
nvarchar (max) |
NULL DEFAULT '' |
boaStatus |
int |
NULL |
ValidationErrorMessage |
nvarchar (max) |
NULL |
Severity |
int |
NULL |
Reject |
bit |
NULL DEFAULT (0) |
RejectReason |
nvarchar (max) |
NULL |
RejectedBy |
nvarchar (50) |
NULL |
LockReject |
bit |
NULL |
Continue with Create rt Tables from the tt Tables.