GP Tables

JC40103 - JC_Cost_Code_Format_SETP

SQL Query Builder

26 Columns

Column Description Type Length
Record_Sequence smallint
Cost_Code_Max_Length smallint
Cost_Code_Segment_Nbr_1 smallint
Cost_Code_Segment_Nbr_2 smallint
Cost_Code_Segment_Nbr_3 smallint
Cost_Code_Segment_Nbr_4 smallint
Cost_Code_Segment_Nbr_5 smallint
Cost_Code_Segment_Name_1 char(11)
Cost_Code_Segment_Name_2 char(11)
Cost_Code_Segment_Name_3 char(11)
Cost_Code_Segment_Name_4 char(11)
Cost_Code_Segment_Name_5 char(11)
Cost_Code_Seg_Length_1 smallint
Cost_Code_Seg_Length_2 smallint
Cost_Code_Seg_Length_3 smallint
Cost_Code_Seg_Length_4 smallint
Cost_Code_Seg_Length_5 smallint
Cost_Code_Nbr_Segments smallint
Cost_Code_Format char(31)
Cost_Code_Separator char(1)
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 JC40103. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

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

Record_Sequence