Module List > Module JC tables JC40103
You are currently viewing the COMPANY database.
Change

COMPANY..JC40103 Table Definition

(COMPANY..JC_Cost_Code_Format_SETP)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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)
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