| TRANSACTIONNUMBER |
int |
|
Default = 1 |
|
| TRANSACTIONTYPECODE |
tinyint |
|
Default = 1 |
|
| TRANSACTIONTYPE |
nvarchar(23) (Computed) |
yes |
CASE [TRANSACTIONTYPECODE] WHEN 1 THEN N'Computer Check' WHEN 8 THEN N'Deposit' WHEN 16 THEN N'Adjustment deposit' WHEN 17 THEN N'Adjustment payment' WHEN 32 THEN N'Adjustment transfer out' WHEN 33 THEN N'Adjustment transfer in' END |
|
| TRANSACTIONFLAGCODE |
tinyint |
|
Default = 1 |
|
| TRANSACTIONFLAG |
nvarchar(18) (Computed) |
yes |
CASE [TRANSACTIONFLAGCODE] WHEN 1 THEN N'Deposit' WHEN 2 THEN N'Check/Payment' WHEN 3 THEN N'Adjustment' WHEN 4 THEN N'Special Adjustment' END |
|
| ORIGINATINGID |
uniqueidentifier |
yes |
|
|
| STATUSCODE |
tinyint |
|
Default = 1 |
|
| STATUS |
nvarchar(11) (Computed) |
yes |
CASE [STATUSCODE] WHEN 1 THEN N'Outstanding' WHEN 2 THEN N'Cleared' WHEN 3 THEN N'Reconciled' WHEN 4 THEN N'Voided' END |
|
| CLEAREDDATE |
datetime |
yes |
|
|
| VOIDDATE |
datetime |
yes |
|
|
| PROCESSING |
bit |
|
Default = 0 |
|
| ADDRESSBLOCK |
nvarchar(150) |
|
Default = '' |
|
| CITY |
nvarchar(50) |
|
Default = '' |
|
| POSTCODE |
nvarchar(12) |
|
Default = '' |
|
| VOIDDATETYPECODE |
tinyint |
|
Default = 0 |
|
| VOIDDATETYPE |
nvarchar(17) (Computed) |
yes |
CASE [VOIDDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Payment post date' WHEN 2 THEN N'Specific date' END |
|
| REVERSALPOSTDATE |
datetime |
yes |
|
|
| REVERSALPOSTDATETYPECODE |
tinyint |
|
Default = 1 |
|
| REVERSALPOSTDATETYPE |
nvarchar(17) (Computed) |
yes |
CASE [REVERSALPOSTDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Payment post date' WHEN 2 THEN N'Specific date' END |
|
| REVERSALPOSTSTATUSCODE |
tinyint |
|
Default = 1 |
|
| REVERSALPOSTSTATUS |
nvarchar(10) (Computed) |
yes |
CASE [REVERSALPOSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Posted' END |
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|