Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The displayed name of the delivery method
 NAMEREQUIRED bit   Default = 1 Indicates whether a patron's name is required for this method
 ADDRESSREQUIRED bit   Default = 0 Indicates whether a patron's address is required for this method
 BLOCKDELIVERY bit   Default = 0 Indicates whether this method should be disabled within a given time period before the event
 BLOCKTIMEVALUE smallint   Default = ((0)) The amount of time before the event when this method should be disabled
 BLOCKTIMEUNITCODE tinyint   Default = 1 The unit of time the value in BLOCKTIMEVALUE represents
 ISACTIVE bit   Default = 1 Indicates whether this method is currently available for use
 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.
 PHONEREQUIRED bit   Default = 0 Indicates whether a patron's phone number is required for this method
 EMAILREQUIRED bit   Default = 0 Indicates whether a patron's e-mail address is required for this method
 PRINTCODE tinyint   Default = 0 Describes when to print associated sales documents when using this method
 BLOCKTIMEUNIT nvarchar(5) (Computed) CASE [BLOCKTIMEUNITCODE] WHEN 0 THEN N'Hours' WHEN 1 THEN N'Days' END Provides a translation for the 'BLOCKTIMEUNITCODE' field.
 PRINT nvarchar(36) (Computed) CASE [PRINTCODE] WHEN 0 THEN N'Defer for later printing' WHEN 1 THEN N'Immediately upon completion of order' WHEN 2 THEN N'Email upon completion of order' END

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_DELIVERYMETHOD_DATEADDED DATEADDED    
 IX_DELIVERYMETHOD_DATECHANGED DATECHANGED      
 PK_DELIVERYMETHOD ID  
 UC_DELIVERYMETHOD_NAME NAME    

Trigger Name Description
 TR_DELIVERYMETHOD_UPDATE_PRINTCODE
 TR_DELIVERYMETHOD_AUDIT_UPDATE
 TR_DELIVERYMETHOD_AUDIT_DELETE

Referenced by Field
 BATCHTICKETPRINTJOB DELIVERYMETHODID
 DELIVERYMETHODFEE DELIVERYMETHODID
 DOCUMENTPRINTINGRULE DELIVERYMETHODID
 SALESMETHODDELIVERYMETHOD DELIVERYMETHODID
 SALESORDER DELIVERYMETHODID

Entity-Relationship diagram of this table