| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | SlpCode | Sales Employee Code | int | 11 | 0 | | | | Allow NULL? |
| 2 | SlpName | Sales Employee Name | nvarchar | 155 | 0 | | | | Allow NULL? |
| 3 | Memo | Remarks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | Commission | % Commission for Sales Employee | num | 19 | 6 | | | | Allow NULL? |
| 5 | GroupCode | Commission Group | int | 6 | 0 | OCOG | 0 | | Allow NULL? |
| 6 | Locked | Locked | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 7 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 8 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 9 | EmpID | Employee ID | int | 11 | 0 | OHEM | | | Allow NULL? |
| 10 | Active | Active | char | 1 | 0 | | Y | N=Inactive, Y=Active | Allow NULL? |
| 11 | Telephone | Telephone | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | Mobil | Mobile | nvarchar | 50 | 0 | | | | Allow NULL? |
| 13 | Fax | Fax | nvarchar | 20 | 0 | | | | Allow NULL? |
| 14 | Email | E-Mail | nvarchar | 100 | 0 | | | | Allow NULL? |
| 15 | DPPStatus | Data Protection Status | char | 1 | 0 | | N | B=Blocked, D=Erased, N=None, U=Unblocked | Allow NULL? |