GP Tables

WSDC011 - SV_Comm_Work

SQL Query Builder

54 Columns

Column Description Type Length
SLPRSNID char(15)
SRCDOCTYP smallint
SRCDOCNUM char(21)
CUSTNMBR char(15)
ADRSCODE char(15)
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)
POSTEDDT datetime
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
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)

Related Tables

Tables that share columns with WSDC011. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

Modified_Time

PDK10500 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301

Wennsoft_Affiliate

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Region

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Branch

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Time_Zone

CN00500 CN100100 JC00102 JC00103 JC00106 JC00201 JC00301 JC00401

SV_Language_ID

JC00102 JC00103 JC00106 JC00201 JC00301 JC00401 JC00501 JC00601

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21