Difference between revisions of "202.2.2.89"
From SPGC Document Wiki
(→pd2014) |
(→pd2014) |
||
| Line 108: | Line 108: | ||
|PDMATDT | |PDMATDT | ||
|datetime | |datetime | ||
| − | | | + | |0 |
|No | |No | ||
|No | |No | ||
Revision as of 11:32, 4 August 2016
paysliplog
| paysliplog | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| Id | int | 11 | Yes | Yes | No | |
| EmployeeNo | varchar | 20 | No | Yes | No | |
| PayDate | date | 0 | No | Yes | No | |
| DateOpen | datetime | 0 | No | Yes | No | |
| IpAddress | varchar | 50 | No | Yes | No | |
pd2014
| pd2014 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 11 | Yes | Yes | No | |
| PDMCOCD | varchar | 25 | No | No | No | |
| PDMLCCD | varchar | 25 | No | No | No | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | datetime | 0 | No | No | No | |
| PDMPOST | varchar | 7 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
