Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CURRENCYSYMBOL nvarchar(4)   Default = '' Character or characters used to represent the currency symbol (obsolete).
 CURRENCYGROUPSEPARATOR nvarchar(4)   Default = '' Character or characters used to separate groups of digits.
 CURRENCYDECIMALSEPARATOR nvarchar(4)   Default = '' Character or characters used to denote the decimal places of the number.
 CURRENCYDECIMALDIGITS tinyint   Default = 0 Number of digits used to represent the decimal portion of the number.
 DATEFORMAT nvarchar(50)   Default = '' Format in which date fields will be displayed when exported.
 FUZZYDATEFORMAT nvarchar(50)   Default = '' Format in which fuzzy date fields will be displayed when exported.
 MONTHDAYFORMAT nvarchar(50)   Default = '' Format in which month/day fields will be displayed when exported.
 HOURMINUTEFORMAT nvarchar(50)   Default = '' Format in which hour/minute fields will be displayed when exported.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint   Default = 0 Indicates how currency symbol display should be handled.
 CURRENCYSYMBOLDISPLAYSETTING nvarchar(20) (Computed) CASE [CURRENCYSYMBOLDISPLAYSETTINGCODE] WHEN 0 THEN N'Use currency setting' WHEN 1 THEN N'Display ISO code' WHEN 2 THEN N'Display symbol' WHEN 3 THEN N'Display no symbol' END Provides a translation for the 'CURRENCYSYMBOLDISPLAYSETTINGCODE' field.
 CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE tinyint   Default = 0 Indicates how the characters used to separate groups of digits should be handled.
 CURRENCYGROUPSEPARATORDISPLAYSETTING nvarchar(21) (Computed) CASE [CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE] WHEN 0 THEN N'Use system setting' WHEN 1 THEN N'Display space' WHEN 2 THEN N'Display custom symbol' WHEN 3 THEN N'Display no symbol' END Provides a translation for the 'CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE' field.
 CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE tinyint   Default = 0 Indicates how the character or characters used to denote the decimal places of the value should be handled.
 CURRENCYDECIMALSEPARATORDISPLAYSETTING nvarchar(21) (Computed) CASE [CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE] WHEN 0 THEN N'Use system setting' WHEN 1 THEN N'Display space' WHEN 2 THEN N'Display custom symbol' END Provides a translation for the 'CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE' field.
 CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE tinyint   Default = 0 Indicates how the number of digits used to represent the decimal portion of the value should be handled.
 CURRENCYDECIMALDIGITSDISPLAYSETTING nvarchar(20) (Computed) CASE [CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE] WHEN 0 THEN N'Use currency setting' WHEN 1 THEN N'Use custom setting' END Provides a translation for the 'CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE' field.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_BUSINESSPROCESSEXPORTFORMAT_DATEADDED DATEADDED    
 IX_BUSINESSPROCESSEXPORTFORMAT_DATECHANGED DATECHANGED      
 PK_BUSINESSPROCESSEXPORTFORMAT ID  

Trigger Name Description
 TR_BUSINESSPROCESSEXPORTFORMAT_AUDIT_UPDATE
 TR_BUSINESSPROCESSEXPORTFORMAT_AUDIT_DELETE

Referenced by Field
 ACKNOWLEDGEMENTPROCESSEXPORTFORMAT ID
 COAUPDATESUBMITPROCESSEXPORTFORMAT ID
 CONSTITUENTDUPLICATESEARCHPROCESSEXPORTFORMAT ID
 CONSTITUENTMERGEPROCESSEXPORTFORMAT ID
 CORRESPONDENCEPROCESSEXPORTFORMAT ID
 CREDITCARDPROCESSINGEXPORTFORMAT ID
 EXPORTPROCESSEXPORTFORMAT ID
 IMPORTSELECTIONPROCESSEXPORTFORMAT ID
 INVITATIONEXPORTFORMAT ID
 IRSFORM1099MISCPROCESSTEMPLATEEXPORTFORMAT ID
 MKTCONSTITUENTFILEIMPORTPROCESSEXPORTFORMAT ID
 MKTFINDERFILEIMPORTPROCESSEXPORTFORMAT ID
 MKTMAILINGPREACTIVATIONPROCESSEXPORTFORMAT ID
 MKTSEGMENTATIONACTIVATEPROCESSEXPORTFORMAT ID
 MKTSEGMENTATIONEXCLUSIONSPROCESSEXPORTFORMAT ID
 MKTSEGMENTATIONEXPORTPROCESS2EXPORTFORMAT ID
 MKTSEGMENTATIONEXPORTPROCESSEXPORTFORMAT ID
 MKTSEGMENTATIONSEGMENTCALCULATEPROCESSEXPORTFORMAT ID
 MKTSEGMENTLISTIMPORTPROCESSEXPORTFORMAT ID
 MKTUPDATEMAILINGCOUNTSPROCESSEXPORTFORMAT ID
 PLANNEDGIFTACKNOWLEDGEMENTPROCESSEXPORTFORMAT ID
 PLEDGEREMINDERPROCESSEXPORTFORMAT ID
 POSTTOGLPROCESSEXPORTFORMAT ID
 PRINTMEMBERSHIPCARDSPROCESSEXPORTFORMAT ID
 QUEUEPROCESSEXPORTFORMAT ID
 RECEIPTINGPROCESSEXPORTFORMAT ID
 SALESDEPOSITPROCESSEXPORTFORMAT ID
 STANDINGORDERSEXPORTPROCESSEXPORTFORMAT ID
 STEWARDSHIPPACKAGEPROCESSEXPORTFORMAT ID
 TRIBUTEACKNOWLEDGEMENTPROCESSEXPORTFORMAT ID

Entity-Relationship diagram of this table (ACKNOWLEDGEMENTPROCESSEXPORTFORMAT-MKTSEGMENTLISTIMPORTPROCESSEXPORTFORMAT)
Entity-Relationship diagram of this table (MKTUPDATEMAILINGCOUNTSPROCESSEXPORTFORMAT-TRIBUTEACKNOWLEDGEMENTPROCESSEXPORTFORMAT)