Module List > Module WS tables WS20802
You are currently viewing the COMPANY database.
Change

COMPANY..WS20802 Table Definition

(COMPANY..WS_GL_Transaction_OPEN)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
WS_Job_Number char(17)


BACHNUMB char(15)

Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)

Batch Sour...(more) Join Now
JRNENTRY int

Journal En...(more) Join Now GL20000.JRNENTRY
SQNCLINE numeric(19,5)

Sequence L...(more) Join Now VAT10302.SQNCLINE
Product_Indicator smallint

Product In...(more) Join Now POP10110.Product_Indicator
ACTINDX int

Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
Service_Call_ID char(17)


Project_Number char(17)


Cost_Code_Number_1 char(7)


Cost_Code_Number_2 char(7)


Cost_Code_Number_3 char(7)


Cost_Code_Number_4 char(7)


Cost_Code_Description char(31)


Cost_Element smallint


WS_Cost_Code int


WS_Other_Cost_Sub_Code int


Equipment_ID char(31)


CRDTAMNT numeric(19,5)

Credit Amo...(more) Join Now GL20000.CRDTAMNT
DEBITAMT numeric(19,5)

Debit Amou...(more) Join Now GL20000.DEBITAMT
ORCRDAMT numeric(19,5)

Originatin...(more) Join Now GL20000.ORCRDAMT
ORDBTAMT numeric(19,5)

Originatin...(more) Join Now GL20000.ORDBTAMT
DSCRIPTN char(31)

Descriptio...(more) Join Now CM20200.DSCRIPTN
Profit_Type_Number smallint

1 =  ...(more) Join Now JC00701.Profit_Type_Number
Profit_Amount numeric(19,5)


TRXQTY numeric(19,5)

TRX QTY: T...(more) Join Now IV10001.TRXQTY
PSTGSTUS smallint

Posting St...(more) Join Now RM10301.PSTGSTUS
GLLINMSG binary(4)


GLLINMS2 binary(4)


GLLINVAL binary(4)


ACCTTYPE smallint


FXDORVAR smallint


BALFRCLC smallint


PSTNGTYP smallint


DECPLACS smallint

Decimal Pl...(more) Join Now SVC00600.DECPLACS
PORDNMBR char(21)

Purchase O...(more) Join Now PM10000.PORDNMBR
Rate_Per_Unit numeric(19,5)


Billing_Amount numeric(19,5)


VENDORID char(15)

Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
EMPLOYID char(15)

Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
ITEMNMBR char(31)

span style...(more) Join Now IV00101.ITEMNMBR
join ... more text available
ITEMDESC char(101)

Item Descr...(more) Join Now BM10300.ITEMDESC
USERID char(15)

The user t...(more) Join Now
join ... more text available
WS_Transaction_Date datetime


OH_Amount numeric(19,5)


OH_ACTINDX_CR int


OH_ACTINDX_DR int


Divisions char(15)


TRXHRUNT int


Payroll_Pay_Type smallint


PAYRCORD char(7)

Pay Record...(more) Join Now UPR40600.PAYRCORD
PAYRATE numeric(19,5)


DEPRTMNT char(7)

Department...(more) Join Now UPR00100.DEPRTMNT
join ... more text available
JOBTITLE char(7)

Job Title:...(more) Join Now UPR00100.JOBTITLE
PAYRTAMT numeric(19,5)

Pay Rate A...(more) Join Now UPR40600.PAYRTAMT
UPRTRXCD char(7)


UOFM char(9)

U Of M: T...(more) Join Now IV10001.UOFM
See I... more text available
CURNCYID char(15)

Currency I...(more) Join Now CM20000
join ... more text available
CURRNIDX smallint

Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
RTCLCMTD smallint

Rate Calcu...(more) Join Now CM20200.RTCLCMTD
XCHGRATE numeric(19,7)

Exchange R...(more) Join Now CM20200.XCHGRATE
DENXRATE numeric(19,7)

Denominati...(more) Join Now CM20200.DENXRATE
INTERID char(5)


RATETPID char(15)

A valid Ra...(more) Join Now
EXGTBLID char(15)

Exchange T...(more) Join Now CM20200.EXGTBLID
EXCHDATE datetime

Exchange D...(more) Join Now CM20200.EXCHDATE
PONUMBER char(17)

PO Number ...(more) Join Now POP10110.PONUMBER
TIME1 datetime

Time see ...(more) Join Now CM20200.TIME1
Labor_Group_Name char(15)


Pricing_Matrix_Name char(15)


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
SV_Language_ID smallint


Time_Zone char(3)


User_Define_1 char(31)


User_Define_2 char(31)


USERDEF1 char(21)

UserDefine...(more) Join Now CM20200.USERDEF1
USERDEF2 char(21)

UserDefine...(more) Join Now CM20200.USERDEF2
User_Def_Integer_1 int


User_Def_Integer_2 int


User_Defined_Integer_3 int


User_Defined_Integer_4 int


User_Defined_Dollar_1 numeric(19,5)


User_Defined_Dollar_2 numeric(19,5)


User_Defined_Dollar_3 numeric(19,5)


User_Defined_Dollar_4 numeric(19,5)


USRDAT01 datetime


USRDAT02 datetime


USRDAT03 datetime


User_Defined_Date2_4 datetime


User_Defined_CB_1 tinyint


User_Defined_CB_2 tinyint


User_Defined_CB_3 tinyint


User_Defined_CB_4 tinyint


WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_STR1 char(11)


WSReserved_STR2 char(11)


OPENYEAR smallint

Open Year:...(more) Join Now GL20000.OPENYEAR
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3