IMPORTFIXEDWIDTHFILETEMPLATE
Primary Key
Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Fields
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(250) | Default = '' | ||
DETAILROWPREFIX | nvarchar(50) | Default = '' | ||
BATCHSUMMARYPREFIX | nvarchar(50) | Default = '' | ||
FILESUMMARYPREFIX | nvarchar(50) | Default = '' | ||
FILENAME | nvarchar(255) | Default = '' | ||
DETAILCOLUMNMAP | xml | |||
FIXEDWIDTHDEFINITION | nvarchar(max) | Default = '' | ||
BATCHRECORDCOUNTSTARTPOSITION | bigint | Default = ((0)) | ||
BATCHRECORDCOUNTENDPOSITION | bigint | Default = ((0)) | ||
BATCHREVENUECOUNTSTARTPOSITION | bigint | Default = ((0)) | ||
BATCHREVENUECOUNTENDPOSITION | bigint | Default = ((0)) | ||
FILERECORDCOUNTSTARTPOSITION | bigint | Default = ((0)) | ||
FILERECORDCOUNTENDPOSITION | bigint | Default = ((0)) | ||
FILEREVENUECOUNTSTARTPOSITION | bigint | Default = ((0)) | ||
FILEREVENUECOUNTENDPOSITION | bigint | Default = ((0)) | ||
FIELDIDCOLUMN | nvarchar(250) | Default = '' | ||
STARTPOSITIONCOLUMN | nvarchar(250) | Default = '' | ||
ENDPOSITIONCOLUMN | nvarchar(250) | Default = '' | ||
DATEADDED | datetime | Default = getdate() | ||
DATECHANGED | datetime | Default = getdate() | ||
TS | timestamp | |||
TSLONG | bigint (Computed) | yes | CONVERT(bigint, TS) | |
LAYOUTFILEHASHEADERROW | bit | Default = 1 |
Foreign Keys
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
BATCHTEMPLATEID | uniqueidentifier | BATCHTEMPLATE.ID | ||
SITEID | uniqueidentifier | yes | SITE.ID | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID |
Indexes
Index Name | Fields | Unique | Primary | Clustered |
---|---|---|---|---|
IX_IMPORTFIXEDWIDTHFILETEMPLATE_BATCHTEMPLATEID | BATCHTEMPLATEID | |||
IX_IMPORTFIXEDWIDTHFILETEMPLATE_DATEADDED | DATEADDED | yes | ||
IX_IMPORTFIXEDWIDTHFILETEMPLATE_DATECHANGED | DATECHANGED | |||
IX_IMPORTFIXEDWIDTHFILETEMPLATE_SITEID | SITEID | |||
PK_IMPORTFIXEDWIDTHFILETEMPLATE | ID | yes | yes | |
UC_IMPORTFIXEDWIDTHFILETEMPLATE_NAME | NAME | yes |
Triggers
Trigger Name | Description |
---|---|
TR_IMPORTFIXEDWIDTHFILETEMPLATE_AUDIT_UPDATE | |
TR_IMPORTFIXEDWIDTHFILETEMPLATE_AUDIT_DELETE |
Referenced by
Referenced by | Field |
---|---|
IMPORTPROCESS | FIXEDWIDTHFILETEMPLATEID |