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

COMPANY..ME97707 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ME_Job_ID char
''

ME_Job_Open_Date datetime
'1/1/1900'

ME_Job_Close_Date datetime
'1/1/1900'

SLPRSNID char
''
Salesperso...(more) Join Now PA01101.SLPRSNID
join ... more text available
ME_Proposal_Number char
''

MEuserdefined2 char
''

ME_Work_Order_Number char
''

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
ME_Work_Scope char
''

ME_Used_In_Budgeting_1 tinyint
0

ME_Used_In_Budgeting_2 tinyint
0

ME_Used_In_Budgeting_3 tinyint
0

ME_Used_In_Budgeting_4 tinyint
0

ME_Used_In_Budgeting_5 tinyint
0

ME_Used_In_Budgeting_6 tinyint
0

ME_Used_In_Budgeting_7 tinyint
0

ME_User_Defined char
''

meestoprev numeric
0.00

ME_Est_Start_Date datetime
'1/1/1900'

ME_Est_Complete_Date datetime
'1/1/1900'

ME_Actual_Start_Date datetime
'1/1/1900'

ME_Actual_End_Date datetime
'1/1/1900'

ME_Actual_Operating_Reve numeric
0.00

ME_Actual_Sales_Tax numeric
0.00

ME_Est_Cost_Labor numeric
0.00

ME_Est_Cost_Material numeric
0.00

ME_Orig_Est_Cost_Labo numeric
0.00

ME_Orig_Est_Cost_Mate numeric
0.00

ME_Actual_Cost_Labor numeric
0.00

ME_Actual_Cost_Material numeric
0.00

FRTAMNT numeric
0.00
Freight Am...(more) Join Now PA11801.FRTAMNT
MISCAMNT numeric
0.00
Misc Amoun...(more) Join Now ICJC9000.MISCAMNT
TRDISAMT numeric
0.00
Trade Disc...(more) Join Now PA11801.TRDISAMT
MEuserdefined3 char
''

MEuserdefined1 char
''

NOTEINDX numeric
0.00
Note Index...(more) Join Now
join ... more text available
ME_Op_Cost__Revenue numeric
0.00

ME_Op_Cost__CostLabor numeric
0.00

ME_Op_Cost__Cost_Materie numeric
0.00

ME_Adjustments numeric
0.00

ME_User_Defined_5 char
''

ME_User_Defined_6 char
''

ME_User_Defined_7 char
''

ME_Job_Status smallint
0

ME_Actual_Rev_Collected numeric
0.00

ME_Reporting tinyint
0

ME_WIP_Account_Ind int
0

ME_CB_Udefs_1 tinyint
0

ME_CB_Udefs_2 tinyint
0

ME_CB_Udefs_3 tinyint
0

ME_CB_Udefs_4 tinyint
0

ME_CB_Udefs_5 tinyint
0

ME_CB_Udefs_6 tinyint
0

ME_CB_Udefs_7 tinyint
0

ME_Date_Udefs_1 datetime
'1/1/1900'

ME_Date_Udefs_2 datetime
'1/1/1900'

ME_Date_Udefs_3 datetime
'1/1/1900'

ME_Date_Udefs_4 datetime
'1/1/1900'

ME_Date_Udefs_5 datetime
'1/1/1900'

ME_Date_Udefs_6 datetime
'1/1/1900'

ME_Date_Udefs_7 datetime
'1/1/1900'

ME_Numeric_Udefs_1 numeric
0.00

ME_Numeric_Udefs_2 numeric
0.00

ME_Numeric_Udefs_3 numeric
0.00

ME_Numeric_Udefs_4 numeric
0.00

ME_Numeric_Udefs_5 numeric
0.00

ME_Numeric_Udefs_6 numeric
0.00

ME_Numeric_Udefs_7 numeric
0.00

ME_User_Defined_Budget_C_1 tinyint
0

ME_User_Defined_Budget_C_2 tinyint
0

ME_User_Defined_Budget_C_3 tinyint
0

ME_User_Defined_Budget_C_4 tinyint
0

ME_User_Defined_Budget_C_5 tinyint
0

ME_User_Defined_Budget_C_6 tinyint
0

ME_User_Defined_Budget_C_7 tinyint
0

DEFAULTGRANTID char
''

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