GP Tables

JC00301 - JC_Keys_MSTR

SQL Query Builder

17 Columns

Column Description Type Length
Job_TRX_Number char(21)
WS_Job_Number char(17)
DCSTATUS smallint
Document Status values (4)
0 = Reserved1 = Work (unposted)2 = Open (posted, not fully applied)3 = History (fully applied/paid)
Document_Source char(3)
BCHSOURC char(15)
DOCDATE datetime
MDFUSRID char(15)
MODIFDT datetime
Modified_Time datetime
SV_Language_ID smallint
Time_Zone char(3)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
DEX_ROW_ID int auto number (1,1)

Related Tables

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

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00401

WSReserved_CB2

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00401

WSReserved_CB3

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00401

WSReserved_CB5

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00401

WSReserved_CB4

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00401

Time_Zone

CN00500 CN100100 JC00102 JC00103 JC00106 JC00201 JC00401 JC00501