GP Tables

JC40202 - JC_Cost_Codes_MSTR_SETP

SQL Query Builder

69 Columns

Column Description Type Length
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_Alias char(27)
Cost_Code_Description char(31)
ACTINDX Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. int
Next_Subdivision_Type smallint
Profit_Type_Number smallint
Profit_Amount numeric(19,5)
Type_of_Transaction smallint
Cost_Element smallint
ESTSTARTDATE datetime
ESTCOMPDATE datetime
Cost_Code_Est_Unit numeric(19,5)
Estimated_Amt_Units numeric(19,5)
Estimated_Measure_Code char(7)
Cost_Code_Estimated_Cst numeric(19,5)
Cost_Code_Rvsd_Est_Cost numeric(19,5)
Cost_Code_Forecast_Cost numeric(19,5)
Cost_Code_Rvsd_Forecast numeric(19,5)
Production_Estimate_Qty numeric(19,5)
Production_Qty_Unit numeric(19,5)
Production_Measure_Code char(7)
VNDRNMBR char(25)
ITEMNMBR char(31)
PORDNMBR char(21)
WRKRCOMP char(7)
User_Define_1 char(31)
User_Define_2 char(31)
USERDEF1 char(21)
USERDEF2 char(21)
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
User_Defined_Date_3 datetime
User_Defined_Date_4 datetime
User_Defined_CB_1 tinyint
User_Defined_CB_2 tinyint
User_Defined_CB_3 tinyint
User_Defined_CB_4 tinyint
Wennsoft_Affiliate char(15)
Wennsoft_Branch char(15)
Wennsoft_Region char(15)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
SV_Language_ID smallint
Time_Zone char(3)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
WSReserved_CB6 tinyint
WSReserved_CB7 tinyint
WSReserved_CB8 tinyint
WSReserved_CB9 tinyint
WSReserved_CB10 tinyint
WSReserved_STR1 char(11)
WSReserved_STR2 char(11)
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with JC40202. 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

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB2

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB3

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB5

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB4

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

Wennsoft_Affiliate

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701