Module List >
Module WS tables
WSDC012
You are currently viewing the COMPANY
database.
Change
|
COMPANY..WSDC012 Table Definition
(COMPANY..SV_Comm_History)
Field Definitions:
What is the 'source' column?
| SLPRSNID |
char(15)
|
Salesperso...(more) Join Now
|
RM20101.SLPRSNID
|
|
join ... more text available
|
| SRCDOCTYP |
smallint
|
SourceDocT...(more) Join Now
|
CM20200.SRCDOCTYP
|
|
|
| SRCDOCNUM |
char(21)
|
SourceDocN...(more) Join Now
|
CM20200.SRCDOCNUM
|
|
|
| Comm_HistID |
smallint
|
|
|
|
|
| CUSTNMBR |
char(15)
|
Customer N...(more) Join Now
|
RM20101.CUSTNMBR
|
|
join ... more text available
|
| ADRSCODE |
char(15)
|
Address Co...(more) Join Now
|
RM20101.ADRSCODE
|
|
|
| Comm_PlanID |
char(5)
|
|
|
|
|
| Comm_PlanStartDate |
datetime
|
|
|
|
|
| Comm_PlanEndDate |
datetime
|
|
|
|
|
| Comm_Event |
tinyint
|
|
|
|
|
| Comm_Percent |
smallint
|
|
|
|
|
| Comm_Division |
char(15)
|
|
|
|
|
| Source_Commission |
char(15)
|
|
|
|
|
| SourceDocumentID |
char(17)
|
|
|
|
|
| Source_SubtotalAmount |
numeric(19,5)
|
|
|
|
|
| Source_DocumentAmount |
numeric(19,5)
|
|
|
|
|
| Source_CostActual |
numeric(19,5)
|
|
|
|
|
| Source_CostForecasted |
numeric(19,5)
|
|
|
|
|
| Source_ContractAmount |
numeric(19,5)
|
|
|
|
|
| Comm_AmountCalculated |
numeric(19,5)
|
|
|
|
|
| Comm_AmountToPay |
numeric(19,5)
|
|
|
|
|
| Comm_AmountRemaining |
numeric(19,5)
|
|
|
|
|
| Comm_EventDate |
datetime
|
|
|
|
|
| Comm_Status |
smallint
|
|
|
|
|
| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| POSTEDDT |
datetime
|
Posted Dat...(more) Join Now
|
RM10301.POSTEDDT
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| Time_Zone |
char(3)
|
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Service_User_Define_1 |
char(21)
|
|
|
|
|
| Service_User_Define_2 |
char(21)
|
|
|
|
|
| Service_User_Define_3 |
char(31)
|
|
|
|
|
| Service_User_Define_4 |
char(31)
|
|
|
|
|
| Service_User_Define_5 |
int
|
|
|
|
|
| Service_User_Define_6 |
int
|
|
|
|
|
| Service_User_Define_7 |
int
|
|
|
|
|
| Service_User_Define_8 |
int
|
|
|
|
|
| Service_User_Define_9 |
datetime
|
|
|
|
|
| Service_User_Define_10 |
datetime
|
|
|
|
|
| Service_User_Define_11 |
datetime
|
|
|
|
|
| Service_User_Define_12 |
datetime
|
|
|
|
|
| Service_User_Define_18 |
tinyint
|
|
|
|
|
| Service_User_Define_19 |
tinyint
|
|
|
|
|
| Service_User_Define_20 |
tinyint
|
|
|
|
|
| Service_User_Define_21 |
tinyint
|
|
|
|
|
| Service_User_Define_22 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_23 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_24 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_25 |
numeric(19,5)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|