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

COMPANY..WS20801 Table Definition

(COMPANY..WS_GL_TRX_Header_OPEN)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
RCTRXSEQ numeric(19,5)

Recurring ...(more) Join Now GL20000.RCTRXSEQ
SOURCDOC char(11)

Field values: 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo PP000001.SOURCDOC
REFRENCE char(31)

Reference:...(more) Join Now POP10300.REFRENCE
TRXDATE datetime

TrxDate Transaction Date used when the transaction was posted CM20502.TRXDATE
RVRSNGDT datetime


RCRNGTRX tinyint


BALFRCLC smallint


PSTGSTUS smallint

Posting St...(more) Join Now RM10301.PSTGSTUS
LASTUSER char(15)

Last User:...(more) Join Now GL20000.LASTUSER
LSTDTEDT datetime

Last Date ...(more) Join Now GL20000.LSTDTEDT
USWHPSTD char(15)

User Who P...(more) Join Now GL20000.USWHPSTD
TRXTYPE smallint


SQNCLINE numeric(19,5)

Sequence L...(more) Join Now VAT10302.SQNCLINE
GLHDRMSG binary(4)


GLHDRMS2 binary(4)


TRXSORCE char(13)

Transactio...(more) Join Now
SERIES smallint

Series: I...(more) Join Now SY00500.SERIES
ORTRXTYP smallint

Originatin...(more) Join Now GL20000.ORTRXTYP
ORCTRNUM char(21)

Originatin...(more) Join Now GL20000.ORCTRNUM
ORMSTRID char(31)

Originatin...(more) Join Now GL20000.ORMSTRID
ORMSTRNM char(65)

Originatin...(more) Join Now GL20000.ORMSTRNM
ORDOCNUM char(21)

Originatin...(more) Join Now GL20000.ORDOCNUM
ORPSTDDT datetime

Originatio...(more) Join Now GL20000.ORPSTDDT
ORTRXSRC char(13)
0
Originatin...(more) Join Now
CURNCYID char(15)

Currency I...(more) Join Now CM20000
join ... more text available
NOTEINDX numeric(19,5)

Note Index...(more) Join Now
join ... more text available
GLHDRVAL binary(4)


PERIODID smallint

Period ID:...(more) Join Now GL20000.PERIODID
OPENYEAR smallint

Open Year:...(more) Join Now GL20000.OPENYEAR
CLOSEDYR smallint


HISTRX tinyint


REVPRDID smallint


REVYEAR smallint


REVCLYR smallint


REVHIST tinyint


ICTRX tinyint

IC TRX: T...(more) Join Now GL20000.ICTRX
ERRSTATE int

Error Stat...(more) Join Now SY00500.ERRSTATE
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


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