Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' Name of the post process
 DESCRIPTION nvarchar(255)   Default = '' Description of the post process
 INCLUDEBYPOSTDATE bit   Default = 0 Post unposted transactions with post date through a specific date
 POSTTHROUGHDATECODE tinyint   Default = 0 End date for transactions to post
 POSTTHROUGHDATE nvarchar(20) (Computed) CASE [POSTTHROUGHDATECODE] WHEN 0 THEN N'This period end date' WHEN 1 THEN N'Last period end date' WHEN 2 THEN N'Process date' END Provides a translation for the 'POSTTHROUGHDATECODE' field.
 SUMMARIZEBYDATECODE tinyint   Default = 0 Method to summarize transactions according to date
 SUMMARIZEBYDATE nvarchar(13) (Computed) CASE [SUMMARIZEBYDATECODE] WHEN 0 THEN N'Post date' WHEN 1 THEN N'Fiscal period' END Provides a translation for the 'SUMMARIZEBYDATECODE' field.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the post process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the outpue ID set to be created by the receipting process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 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.

Foreign Key Field Type Null Notes Description
 FINANCIALSYSTEMID uniqueidentifier   FINANCIALSYSTEM.ID FK to the Financial system
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_GLPOSTPROCESS_DATEADDED DATEADDED    
 IX_GLPOSTPROCESS_DATECHANGED DATECHANGED      
 IX_GLPOSTPROCESS_FINANCIALSYSTEMID FINANCIALSYSTEMID      
 PK_GLPOSTPROCESS ID  
 UC_GLPOSTPROCESS_NAME NAME    

Trigger Name Description
 TR_GLPOSTPROCESS_AUDIT_UPDATE
 TR_GLPOSTPROCESS_AUDIT_DELETE

Referenced by Field
 GLPOSTPROCESSPOSTMETHOD GLPOSTPROCESSID
 GLPOSTPROCESSSTATUS PARAMETERSETID
 GLPOSTPROCESSTRANSACTIONCRITERIA GLPOSTPROCESSID

Entity-Relationship diagram of this table