Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:57:08 AM Thursday, March 21, 2019 |
Last Modified | 12:57:08 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Identity |
---|---|---|---|---|
PaySlipDetailsID | int | 4 | False | 1 - 1 |
PaySlipID | int | 4 | True | |
ExtID1 | char(12) | 12 | True | |
ExtID2 | char(12) | 12 | True | |
SOID | int | 4 | True | |
UserID | int | 4 | True | |
ManagerID | int | 4 | True | |
SalesRep | char(24) | 24 | True | |
Period | int | 4 | True | |
CommissionRate | int | 4 | True | |
InvoiceNumber | char(10) | 10 | True | |
BoardPeriod | int | 4 | True | |
BoardDate | datetime | 8 | True | |
BoardAmount | money | 8 | True | |
CommissionAmount | money | 8 | True | |
CommissionType | char(64) | 64 | True | |
TotalC | money | 8 | True | |
TotalB | money | 8 | True | |
Due | money | 8 | True | |
Description | char(256) | 256 | True | |
CreatorID | int | 4 | False | |
CreateDate | datetime | 8 | False | |
UpdatorID | int | 4 | False | |
LastUpdate | datetime | 8 | False | |
QuoteID | int | 4 | True |