Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 REVENUEPOSTMETHODCODE tinyint   Default = 0 Post method for Revenue transactions.
 REVENUEREFERENCE nvarchar(255)   Default = '' Default reference value for Revenue transactions.
 CASHPOSTMETHODCODE tinyint   Default = 0 Post method for Cash transactions.
 CASHPOSTMETHOD nvarchar(18) (Computed) CASE [CASHPOSTMETHODCODE] WHEN 0 THEN N'Detail' WHEN 1 THEN N'Summary' WHEN 2 THEN N'Summary by deposit' END Provides a translation for the 'CASHPOSTMETHODCODE' field.
 CASHREFERENCE nvarchar(255)   Default = '' Default reference value for Cash transactions.
 ARPOSTMETHODCODE tinyint   Default = 0 Post method for Accounts Receivable transactions.
 ARPOSTMETHOD nvarchar(7) (Computed) CASE [ARPOSTMETHODCODE] WHEN 0 THEN N'Detail' WHEN 1 THEN N'Summary' END Provides a translation for the 'ARPOSTMETHODCODE' field.
 ARREFERENCE nvarchar(255)   Default = '' Default reference value for Accounts Receivable transactions.
 SUMMARIZECODE tinyint   Default = 0 Summary method.
 SUMMARIZE nvarchar(13) (Computed) CASE [SUMMARIZECODE] WHEN 0 THEN N'Post Date' WHEN 1 THEN N'Fiscal Period' END Provides a translation for the 'SUMMARIZECODE' field.
 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.
 REVALUATIONGAINLOSSPOSTMETHODCODE tinyint   Default = 0 Post method for revaluation gain/loss transactions.
 REVALUATIONGAINLOSSPOSTMETHOD nvarchar(7) (Computed) CASE [REVALUATIONGAINLOSSPOSTMETHODCODE] WHEN 0 THEN N'Detail' WHEN 1 THEN N'Summary' END Provides a translation for the 'REVALUATIONGAINLOSSPOSTMETHODCODE' field.
 REVALUATIONGAINLOSSREFERENCE nvarchar(255)   Default = '' Default reference value for revaluation gain/loss transactions.
 REVENUEPOSTMETHOD nvarchar(27) (Computed) CASE [REVENUEPOSTMETHODCODE] WHEN 0 THEN N'Detail' WHEN 1 THEN N'Summary' WHEN 2 THEN N'Summary by application type' WHEN 3 THEN N'Summary by deposit' END

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

Index Name Field(s) Unique Primary Clustered
 IX_POSTTOGLPROCESSDETAIL_DATEADDED DATEADDED    
 IX_POSTTOGLPROCESSDETAIL_DATECHANGED DATECHANGED      
 PK_POSTTOGLPROCESSDETAIL ID  

Trigger Name Description
 TR_POSTTOGLPROCESSDETAIL_AUDIT_UPDATE
 TR_POSTTOGLPROCESSDETAIL_AUDIT_DELETE

Entity-Relationship diagram of this table