CREDITTYPECODE

This code table stores translations of credit type codes.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
DESCRIPTION nvarchar(100) Stores the description of the table entry
ACTIVE bit Default = 1 Indicates whether or not the table entry is active
SEQUENCE int Default = 0 Stores the user-defined sequence for the table entry
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) yes convert(bigint, TS) Numeric representation of the timestamp.

Foreign Keys

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

Indexes

Index Name Fields Unique Primary Clustered
IX_CREDITTYPECODE_DATEADDED DATEADDED yes
PK_CREDITTYPECODE ID yes yes
UIX_CREDITTYPECODE_DESCRIPTION DESCRIPTION yes

Triggers

Trigger Name Description
TR_CREDITTYPECODE_AUDIT_UPDATE
TR_CREDITTYPECODE_AUDIT_DELETE
TR_CREDITTYPECODE_INSERT_BBNCCODETABLEIDMAP
TR_CREDITTYPECODE_DELETE_BBNCCODETABLEIDMAP
TR_CREDITTYPECODE_AUDIT_ETLDELETEDID

Referenced by

Referenced by Field
BANKACCOUNTDEPOSIT CREDITTYPECODEID
BATCHAMPROIMPORTPURCHASE PURCHASE_CREDITTYPECODEID
BATCHREVENUE CREDITTYPECODEID
BATCHSPONSORSHIP CREDITTYPECODEID
CREDITCARD CREDITTYPECODEID
CREDITCARDPAYMENTMETHODDETAIL CREDITTYPECODEID
GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE ID
RECEIVABLEPAYMENTCREDITCARD CREDITTYPECODEID
RECONCILIATIONDETAIL CREDITTYPECODEID
RECURRINGGIFTAMENDMENT CREDITTYPECODEID
RECURRINGGIFTAMENDMENT PREVIOUSCREDITTYPECODEID
SALESDEPOSITTEMPLATEPAYMENTMETHOD CREDITTYPECODEID
SALESORDERITEMREVENUESCHEDULE CREDITTYPECODEID