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