Segment Data

CCM_SEGCUR Defined Structure

The CCM_SEGCUR structure contains operating segment currency rate data.

Mnemonic Field Name Format
SC_DATAYR Data year integer
SC_DATAFYR Data fiscal year end month integer
SC_CALYR Data calendar year integer
SC_SRCYFYR Source fiscal year end month integer
SC_XRATE Period end exchange rate floating point double precision
SC_XRATE12 12-month moving exchange rate floating point double precision
SC_SRCCUR Source currency code character
SC_CURCD ISO currency code (USD) character

CCM_SEGSRC Defined Structure

The CCM_SEGSRC structure contains operating segment source data.

Mnemonic Field Name Format
SS_SRCYR Source year integer
SS_SRCFYR Source fiscal year end month integer
SS_CALYR Data calendar year integer
SS_RCST1 Reserved 1 integer
SS_SSRCE Source document code character
SS_SUCODE Source update code character
SS_CURCD ISO currency code character
SS_SRCCUR Source ISO currency code character
SS_HNAICS Segment primary historical NAICS character

CCM_SEGPROD Defined Structure

The CCM_SEGPROD structure contains operating segment product data.

Mnemonic Field Name Format
SP_SRCYR Source year integer
SP_SRCFYR Source fiscal year end month integer
SP_PDID Product identifier integer
SP_PSID Segment link – segment identifier integer
SP_PSALE External revenues floating point single precision
SP_RCST1 Reserved 1 floating point single precision
SP_PNAICS Product NAICS code character
SP_PSTYPE Segment link- segment type character
SP_PNAME Product name character

CCM_SEGCUST Defined Structure

The CCM_SEGCUST structure contains operating segment customer data.

Mnemonic Field Name Format
SC_SRCYR Source year integer
SC_SRCFYR Source fiscal year end month integer
SC_CDID customer identifier integer
SC_CSID Segment link – segment identifier integer
SC_CSALE customer revenues floating point single precision
SC_RCST1 Reserved 1 integer
SC_CTYPE Customer type character
SC_CGEOCD Geographic area code character
SC_CGEOAR Geographic area type character
SC_CSTYPE Segment link – segment type character
SC_CNAME Customer name data character

CCM_SEGDTL Defined Structure

The CCM_SEGDTL structure contains operating segment detail data.

Mnemonic Field Name Format
SD_SRCYR Source year integer
SD_SRCFYR Source fiscal year end month integer
SD_SID Segment identifier integer
SD_RCST1 Reserved 1 integer
SD_STYPE Segment type character
SD_SOPTP1 Operating segment type 1 character
SD_SOPTP2 Operating segment type character
SD_SGEOTP Geographic segment type character
SD_SNAME Segment name character

CCM_SEGITM Defined Structure

The CCM_SEGITM structure contains operating segment item data.

Mnemonic Field Name Format
SI_DATYR Data year integer
SI_FISCYR Data fiscal year end month integer
SI_SRCYR Source year integer
SI_SRCFYR Source fiscal year end month integer
SI_CALYR Data calendar year integer
SI_SID Segment identifier integer
SI_EMP Employees integer
SI_SALE Net sales floating point single precision
SI_OIBD Operating income before depreciations floating point single precision
SI_DP Depreciation & amortization floating point single precision
SI_OIAD Operating income after depreciation floating point single precision
SI_CAPX Capital expenditures floating point single precision
SI_IAT Identifiable assets floating point single precision
SI_EQEARN Equity in earnings floating point single precision
SI_INVEQ Investments at equity floating point single precision
SI_RD Research & development floating point single precision
SI_OBKLG Order backlog floating point single precision
SI_EXPORTS Export sales floating point single precision
SI_INTSEG Inter-segment eliminations integer
SI_OPINC Operating profit floating point single precision
SI_PI Pretax income floating point single precision
SI_IB Income before extraordinary earnings floating point single precision
SI_NI Net income (loss) floating point single precision
SI_RCST1 Reserved 1 floating point single precision
SI_RCST2 Reserved 2 floating point single precision
SI_RCST3 Reserved 3 floating point single precision
SI_SALEF Footnote 1 - sales character
SI_OPINCF Footnote 2 – operating profit character
SI_CAPXF Footnote 3 – capital expenditures character
SI_EQEARNF Footnote 4 – equity in earnings character
SI_EMPF Footnote 5 - employees character
SI_RDF Footnote 6 – research & development character
SI_STYPE Segment type character

CCM_SEGNAICS Defined Structure

The CCM_SEGNAICS structure contains operating segment NAICS data.

Mnemonic Field Name Format
SN_SRCYR Source year integer
SN_SRCFYR Source fiscal year end month integer
SN_SID Segment identifier integer
SN_RCST1 Reserved 1 integer
SN_STYPE Segment type character
SN_SNAICS NAICS code character
SN_RANK Ranking integer
SN_SIC Segment SIC code integer

CCM_SEGGEO Defined Structure

The CCM_SEGGEO structure contains operating segment geographic data.

Mnemonic Field Name Format
SG_SRCYR Source year integer
SG_SRCFYR Source fiscal year end month integer
SG_SID Segment identifier integer
SG_RCST1 Reserved 1 integer
SG_STYPE Segment type character
SG_SGEOCD Geographic area code character
SG_SGEOTP Geographic area type character