Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Banking | ||||||||||
1 | OMTH | Reconciliation History | 6 | MatchType | Reconciliation Type | nVarChar | 2 | 0 | 0 | 0=Manual, 10=Ref. 2 + Due Date, 11=Ref. 3 + Due Date, 12=By Total, 1=Ref. 1, 2=Ref. 2, 3=Ref. 3, 4=Posting Date, 5=Due Date, 6=Ref. 1 + Posting Date, 7=Ref. 2 + Posting Date, 8=Ref. 3 + Posting Date, 9=Ref. 1 + Due Date |