Module List > Module ME tables ME97705
You are currently viewing the COMPANY database.
Change

COMPANY..ME97705 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ME_Job_ID char
''

GRANTID char
''

ME_Trx_Type smallint
0

ME_Breakdown_Code char
''

LNITMSEQ int
0
Line Item ...(more) Join Now PA11801.LNITMSEQ
SQNCLINE numeric
0.00
Sequence L...(more) Join Now PP50101.SQNCLINE
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now RM20101.DOCDATE
DOCNUMBR char
''
Document N...(more) Join Now RM20102.DOCNUMBR
ME_Document_Number_WORK char
''

DOCTYPE smallint
0
Document T...(more) Join Now PM30300.DOCTYPE
MEuserdefined2 char
''

ME_Work_Order_Number char
''

ME_User_Defined char
''

DSCRIPTN char
''

ME_Amount_Type smallint
0

TRXAMNT numeric
0.00

ME_Originating_Master_ID char
''

MEuserdefined1 char
''

ME_Proposal_Number char
''

JRNENTRY int
0

MEuserdefined3 char
''

ME_User_Defined_5 char
''

ME_User_Defined_6 char
''

ME_User_Defined_7 char
''

ACTINDX int
0
Account In...(more) Join Now WO010702.ACTINDX
join ... more text available
HOURSWKD int
0

GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now RM20101.GLPOSTDT
ME_GL_Distribution_LI_In int
0

ME_Module_LI_Index int
0

ORIGAMT numeric
0.00

VOIDED tinyint
0

COMMNTID char
''

join ... more text available
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