GreenshadesOnline Integration Help
dbo.GO_EmployeePayRecordDirectDepositHistory View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeePayRecordDirectDepositHistory View |
| Creation Date | 7/17/2015 10:23 AM |
| Is Schema Bound |  |
| Encrypted | |
| Ansi Nulls |  |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| Index | int | 4 | |||||
| PayDate | Stores the check date | datetime | 4 | ||||
| EffectiveDate | datetime | 4 | |||||
| EmployeeID | Stores the unique identifier of a specific employee | char | 15 | ||||
| TransactionType | Denotes the type of account; use 22 for a checking account and 32 for a savings account | int | 4 |  | |||
| RoutingNumber | Stores the routing number | char | 9 | ||||
| AccountNumber | Stores the account number | char | 17 | ||||
| Amount | Stores the direct deposit amount | numeric | 9 (19,5) | ||||
| CheckNumber | Stores the check number | char | 21 | ||||
| EmployeeDDHistoryID | int | 4 | |||||
| Parent_PayRecordRowID | int | 4 |