Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 STARTINGCASH money   Default = 0
 ACTUALCASH money   Default = 0
 STATUSCODE tinyint   Default = 0 The status of the reconciliation.
 COMMENT nvarchar(max)   Default = '' The comment.
 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.
 STATUS nvarchar(9) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Open' WHEN 1 THEN N'Submitted' WHEN 2 THEN N'Approved' WHEN 3 THEN N'Deposited' END Provides a translation for the 'STATUSCODE' field.
 RECONCILIATIONDATE datetime The date and time when the reconciliation is submitted.
 APPROVALDATE datetime Date and time the reconciliation was approved
 ORIGINALSUBMISSIONDATE datetime The date and time the reconciliation was originally submitted. Should not account for edits made after submission.
 CASHOVERSHORTSALESMETHODCODE tinyint   Default = 0
 CHECKOVERSHORTSALESMETHODCODE tinyint   Default = 3
 CASHOVERSHORTDEPOSITED bit   Default = 0
 CHECKOVERSHORTDEPOSITED bit   Default = 0
 CASHOVERSHORTSALESMETHOD nvarchar(13) (Computed) CASE [CASHOVERSHORTSALESMETHODCODE] WHEN 0 THEN N'Daily Sales' WHEN 1 THEN N'Advance Sales' WHEN 2 THEN N'Online Sales' WHEN 3 THEN N'Group Sales' END
 CHECKOVERSHORTSALESMETHOD nvarchar(13) (Computed) CASE [CHECKOVERSHORTSALESMETHODCODE] WHEN 0 THEN N'Daily Sales' WHEN 1 THEN N'Advance Sales' WHEN 2 THEN N'Online Sales' WHEN 3 THEN N'Group Sales' END

Foreign Key Field Type Null Notes Description
 APPUSERID uniqueidentifier   APPUSER.ID The application user who adds the record
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 APPROVEDBYID uniqueidentifier APPUSER.ID The application user who approved the reconciliation

Index Name Field(s) Unique Primary Clustered
 IX_RECONCILIATION_APPUSERID APPUSERID      
 IX_RECONCILIATION_DATEADDED DATEADDED    
 IX_RECONCILIATION_DATECHANGED DATECHANGED      
 IX_RECONCILIATION_RECONCILIATIONDATE RECONCILIATIONDATE (DESC)      
 PK_RECONCILIATION ID  

Trigger Name Description
 TR_RECONCILIATION_AUDIT_UPDATE
 TR_RECONCILIATION_AUDIT_DELETE
 TR_RECONCILIATION_APPROVEDDURINGSALESDEPOSITPROCESS

Referenced by Field
 CLOSEDRAWERDENOMINATION RECONCILIATIONID
 CREDITPAYMENT RECONCILIATIONID
 RECONCILIATIONCREDITDETAIL ID
 RECONCILIATIONDETAIL RECONCILIATIONID
 RESERVATIONSECURITYDEPOSITPAYMENT RECONCILIATIONID
 SALESORDERPAYMENT RECONCILIATIONID

Entity-Relationship diagram of this table