Century Corp is a consumer electronics manufacturer that distributes products through retailers around the world. Century Corp has thousands of employees in plants, warehouses, and offices worldwide. Their mission is to provide quality products and services to their customers.
Century Corp is a group of data sources that contain financial, human resources, inventory, and order information. The last three data sources are designed to be used with chart of accounts data.
FILE=CENTCOMP, SUFFIX=FOC, FDFC=19, FYRT=00 SEGNAME=COMPINFO, SEGTYPE=S1, $ FIELD=STORE_CODE, ALIAS=SNUM, FORMAT=A6, INDEX=I, TITLE='Store Id#:', DESCRIPTION='Store Id#', $ FIELD=STORENAME, ALIAS=SNAME, FORMAT=A20, WITHIN=STATE, TITLE='Store,Name:', DESCRIPTION='Store Name', $ FIELD=STATE, ALIAS=STATE, FORMAT=A2, WITHIN=PLANT, TITLE='State:', DESCRIPTION=State, $ DEFINE REGION/A5=DECODE STATE ('AL' 'SOUTH' 'AK' 'WEST' 'AR' 'SOUTH' 'AZ' 'WEST' 'CA' 'WEST' 'CO' 'WEST' 'CT' 'EAST' 'DE' 'EAST' 'DC' 'EAST' 'FL' 'SOUTH' 'GA' 'SOUTH' 'HI' 'WEST' 'ID' 'WEST' 'IL' 'NORTH' 'IN' 'NORTH' 'IA' 'NORTH' 'KS' 'NORTH' 'KY' 'SOUTH' 'LA' 'SOUTH' 'ME' 'EAST' 'MD' 'EAST' 'MA' 'EAST' 'MI' 'NORTH' 'MN' 'NORTH' 'MS' 'SOUTH' 'MT' 'WEST' 'MO' 'SOUTH' 'NE' 'WEST' 'NV' 'WEST' 'NH' 'EAST' 'NJ' 'EAST' 'NM' 'WEST' 'NY' 'EAST' 'NC' 'SOUTH' 'ND' 'NORTH' 'OH' 'NORTH' 'OK' 'SOUTH' 'OR' 'WEST' 'PA' 'EAST' 'RI' 'EAST' 'SC' 'SOUTH' 'SD' 'NORTH' 'TN' 'SOUTH' 'TX' 'SOUTH' 'UT' 'WEST' 'VT' 'EAST' 'VA' 'SOUTH' 'WA' 'WEST' 'WV' 'SOUTH' 'WI' 'NORTH' 'WY' 'WEST' 'NA' 'NORTH' 'ON' 'NORTH' ELSE ' ');, TITLE='Region:', DESCRIPTION=Region, $
SECTION 01 STRUCTURE OF FOCUS FILE CENTCOMP ON 05/15/03 AT 10.20.49 COMPINFO 01 S1 ************** *STORE_CODE **I *STORENAME ** *STATE ** * ** * ** *************** **************
FILE=CENTFIN, SUFFIX=FOC, FDFC=19, FYRT=00 SEGNAME=ROOT_SEG, SEGTYPE=S4, $ FIELD=YEAR, ALIAS=YEAR, FORMAT=YY, WITHIN='*Time Period', $ FIELD=QUARTER, ALIAS=QTR, FORMAT=Q, WITHIN=YEAR, TITLE=Quarter, DESCRIPTION=Quarter, $ FIELD=MONTH, ALIAS=MONTH, FORMAT=M, TITLE=Month, DESCRIPTION=Month, $ FIELD=ITEM, ALIAS=ITEM, FORMAT=A20, TITLE=Item, DESCRIPTION=Item, $ FIELD=VALUE, ALIAS=VALUE, FORMAT=D12.2, TITLE=Value, DESCRIPTION=Value, $ DEFINE ITYPE/A12=IF EDIT(ITEM,'9$$$$$$$$$$$$$$$$$$$') EQ 'E' THEN 'Expense' ELSE IF EDIT(ITEM,'9$$$$$$$$$$$$$$$$$$$') EQ 'R' THEN 'Revenue' ELSE 'Asset';, TITLE=Type, DESCRIPTION='Type of Financial Line Item',$ DEFINE MOTEXT/MT=MONTH;,$
SECTION 01 STRUCTURE OF FOCUS FILE CENTFIN ON 05/15/03 AT 10.25.52 ROOT_SEG 01 S4 ************** *YEAR ** *QUARTER ** *MONTH ** *ITEM ** * ** *************** **************
FILE=CENTHR, SUFFIX=FOC SEGNAME=EMPSEG, SEGTYPE=S1, $ FIELD=ID_NUM, ALIAS=ID#, FORMAT=I9, TITLE='Employee,ID#', DESCRIPTION='Employee Identification Number', $ FIELD=LNAME, ALIAS=LN, FORMAT=A14, TITLE='Last,Name', DESCRIPTION='Employee Last Name', $ FIELD=FNAME, ALIAS=FN, FORMAT=A12, TITLE='First,Name', DESCRIPTION='Employee First Name', $ FIELD=PLANT, ALIAS=PLT, FORMAT=A3, TITLE='Plant,Location', DESCRIPTION='Location of the manufacturing plant', WITHIN='*Location', $ FIELD=START_DATE, ALIAS=SDATE, FORMAT=YYMD, TITLE='Starting,Date', DESCRIPTION='Date of employment',$ FIELD=TERM_DATE, ALIAS=TERM_DATE, FORMAT=YYMD, TITLE='Termination,Date', DESCRIPTION='Termination Date', $ FIELD=STATUS, ALIAS=STATUS, FORMAT=A10, TITLE='Current,Status', DESCRIPTION='Job Status', $ FIELD=POSITION, ALIAS=JOB, FORMAT=A2, TITLE=Position, DESCRIPTION='Job Position', $ FIELD=PAYSCALE, ALIAS=PAYLEVEL, FORMAT=I2, TITLE='Pay,Level', DESCRIPTION='Pay Level', WITHIN='*Wages',$ DEFINE POSITION_DESC/A17=IF POSITION EQ 'BM' THEN 'Plant Manager' ELSE IF POSITION EQ 'MR' THEN 'Line Worker' ELSE IF POSITION EQ 'TM' THEN 'Line Manager' ELSE 'Technician'; TITLE='Position,Description', DESCRIPTION='Position Description', WITHIN='PLANT',$ DEFINE BYEAR/YY=START_DATE; TITLE='Beginning,Year', DESCRIPTION='Beginning Year', WITHIN='*Starting Time Period',$
DEFINE BQUARTER/Q=START_DATE; TITLE='Beginning,Quarter', DESCRIPTION='Beginning Quarter', WITHIN='BYEAR', DEFINE BMONTH/M=START_DATE; TITLE='Beginning,Month', DESCRIPTION='Beginning Month', WITHIN='BQUARTER',$ DEFINE EYEAR/YY=TERM_DATE; TITLE='Ending,Year', DESCRIPTION='Ending Year', WITHIN='*Termination Time Period',$ DEFINE EQUARTER/Q=TERM_DATE; TITLE='Ending,Quarter', DESCRIPTION='Ending Quarter', WITHIN='EYEAR',$ DEFINE EMONTH/M=TERM_DATE; TITLE='Ending,Month', DESCRIPTION='Ending Month', WITHIN='EQUARTER',$ DEFINE RESIGN_COUNT/I3=IF STATUS EQ 'RESIGNED' THEN 1 ELSE 0; TITLE='Resigned,Count', DESCRIPTION='Resigned Count',$ DEFINE FIRE_COUNT/I3=IF STATUS EQ 'TERMINAT' THEN 1 ELSE 0; TITLE='Terminated,Count', DESCRIPTION='Terminated Count',$ DEFINE DECLINE_COUNT/I3=IF STATUS EQ 'DECLINED' THEN 1 ELSE 0; TITLE='Declined,Count', DESCRIPTION='Declined Count',$ DEFINE EMP_COUNT/I3=IF STATUS EQ 'EMPLOYED' THEN 1 ELSE 0; TITLE='Employed,Count', DESCRIPTION='Employed Count',$ DEFINE PEND_COUNT/I3=IF STATUS EQ 'PENDING' THEN 1 ELSE 0; TITLE='Pending,Count', DESCRIPTION='Pending Count',$ DEFINE REJECT_COUNT/I3=IF STATUS EQ 'REJECTED' THEN 1 ELSE 0; TITLE='Rejected,Count', DESCRIPTION='Rejected Count',$ DEFINE FULLNAME/A28=LNAME||', '|FNAME; TITLE='Full Name', DESCRIPTION='Full Name: Last, First', WITHIN='POSITION_DESC',$
DEFINE SALARY/D12.2=IF BMONTH LT 4 THEN PAYLEVEL * 12321 ELSE IF BMONTH GE 4 AND BMONTH LT 8 THEN PAYLEVEL * 13827 ELSE PAYLEVEL * 14400;, TITLE='Salary', DESCRIPTION='Salary',$ DEFINE PLANTLNG/A11=DECODE PLANT (BOS 'Boston' DAL 'Dallas' LA 'Los Angeles' ORL 'Orlando' SEA 'Seattle' STL 'St Louis' ELSE 'n/a');$
SECTION 01 STRUCTURE OF FOCUS FILE CENTHR ON 05/15/03 AT 10.40.34 EMPSEG 01 S1 ************** *ID_NUM ** *LNAME ** *FNAME ** *PLANT ** * ** *************** **************
FILE=CENTINV, SUFFIX=FOC, FDFC=19, FYRT=00 SEGNAME=INVINFO, SEGTYPE=S1, $ FIELD=PROD_NUM, ALIAS=PNUM, FORMAT=A4, INDEX=I, TITLE='Product,Number:', DESCRIPTION='Product Number', $ FIELD=PRODNAME, ALIAS=PNAME, FORMAT=A30, WITHIN=PRODCAT, TITLE='Product,Name:', DESCRIPTION='Product Name', $ FIELD=QTY_IN_STOCK, ALIAS=QIS, FORMAT=I7, TITLE='Quantity,In Stock:', DESCRIPTION='Quantity In Stock', $ FIELD=PRICE, ALIAS=RETAIL, FORMAT=D10.2, TITLE='Price:', DESCRIPTION=Price, $ FIELD=COST, ALIAS=OUR_COST, FORMAT=D10.2, TITLE='Our,Cost:', DESCRIPTION='Our Cost:', $ DEFINE PRODCAT/A22 = IF PRODNAME CONTAINS 'LCD' THEN 'VCRs' ELSE IF PRODNAME CONTAINS 'DVD' THEN 'DVD' ELSE IF PRODNAME CONTAINS 'Camcor' THEN 'Camcorders' ELSE IF PRODNAME CONTAINS 'Camera' THEN 'Cameras' ELSE IF PRODNAME CONTAINS 'CD' THEN 'CD Players' ELSE IF PRODNAME CONTAINS 'Tape' THEN 'Digital Tape Recorders' ELSE IF PRODNAME CONTAINS 'Combo' THEN 'Combo Players' ELSE 'PDA Devices'; WITHIN=PRODTYPE, TITLE='Product Category:' ,$ DEFINE PRODTYPE/A19 = IF PRODNAME CONTAINS 'Digital' OR 'DVD' OR 'QX' THEN 'Digital' ELSE 'Analog';,WITHIN='*Product Dimension', TITLE='Product Type:',$
SECTION 01 STRUCTURE OF FOCUS FILE CENTINV ON 05/15/03 AT 10.43.35 INVINFO 01 S1 ************** *PROD_NUM **I *PRODNAME ** *QTY_IN_STOCK** *PRICE ** * ** *************** **************
FILE=CENTORD, SUFFIX=FOC SEGNAME=OINFO, SEGTYPE=S1, $ FIELD=ORDER_NUM, ALIAS=ONUM, FORMAT=A5, INDEX=I, TITLE='Order,Number:', DESCRIPTION='Order Number', $ FIELD=ORDER_DATE, ALIAS=ODATE, FORMAT=YYMD, TITLE='Date,Of Order:', DESCRIPTION='Date Of Order', $ FIELD=STORE_CODE, ALIAS=SNUM, FORMAT=A6, INDEX=I, TITLE='Company ID#:', DESCRIPTION='Company ID#', $ FIELD=PLANT, ALIAS=PLNT, FORMAT=A3, INDEX=I, TITLE='Manufacturing,Plant', DESCRIPTION='Location Of Manufacturing Plant', WITHIN='*Location',$ DEFINE YEAR/YY=ORDER_DATE;, WITHIN='*Time Period',$ DEFINE QUARTER/Q=ORDER_DATE;, WITHIN='YEAR',$ DEFINE MONTH/M=ORDER_DATE;, WITHIN='QUARTER',$ SEGNAME=PINFO, SEGTYPE=S1, PARENT=OINFO, $ FIELD=PROD_NUM, ALIAS=PNUM, FORMAT=A4,INDEX=I, TITLE='Product,Number#:', DESCRIPTION='Product Number#', $ FIELD=QUANTITY, ALIAS=QTY, FORMAT=I8C, TITLE='Quantity:', DESCRIPTION=Quantity, $ FIELD=LINEPRICE, ALIAS=LINETOTAL, FORMAT=D12.2MC, TITLE='Line,Total', DESCRIPTION='Line Total', $ DEFINE LINE_COGS/D12.2=QUANTITY*COST;, TITLE='Line,Cost Of,Goods Sold', DESCRIPTION='Line cost of goods sold', $ DEFINE PLANTLNG/A11=DECODE PLANT (BOS 'Boston' DAL 'Dallas' LA 'Los Angeles' ORL 'Orlando' SEA 'Seattle' STL 'St Louis' ELSE 'n/a'); SEGNAME=INVSEG, SEGTYPE=DKU, PARENT=PINFO, CRFILE=CENTINV, CRKEY=PROD_NUM, CRSEG=INVINFO,$ SEGNAME=STOSEG, SEGTYPE=DKU, PARENT=OINFO, CRFILE=CENTCOMP, CRKEY=STORE_CODE, CRSEG=COMPINFO,$
SECTION 01 STRUCTURE OF FOCUS FILE CENTORD ON 05/15/03 AT 10.17.52 OINFO 01 S1 ************** *ORDER_NUM **I *STORE_CODE **I *PLANT **I *ORDER_DATE ** * ** *************** ************** I +-----------------+ I I I STOSEG I PINFO 02 I KU 03 I S1 .............. ************** :STORE_CODE :K *PROD_NUM **I :STORENAME : *QUANTITY ** :STATE : *LINEPRICE ** : : * ** : : * ** :............: *************** JOINED CENTCOMP ************** I I I I INVSEG 04 I KU .............. :PROD_NUM :K :PRODNAME : :QTY_IN_STOCK: :PRICE : : : :............: JOINED CENTINV
FILE=CENTQA, SUFFIX=FOC, FDFC=19, FYRT=00 SEGNAME=PROD_SEG, SEGTYPE=S1, $ FIELD=PROD_NUM, ALIAS=PNUM, FORMAT=A4, INDEX=I, TITLE='Product,Number', DESCRIPTION='Product Number', $ SEGNAME=PROB_SEG, PARENT=PROD_SEG, SEGTYPE=S1, $ FIELD=PROBNUM, ALIAS=PROBNO, FORMAT=I5, TITLE='Problem,Number', DESCRIPTION='Problem Number', WITHIN=PLANT,$ FIELD=PLANT, ALIAS=PLT, FORMAT=A3, INDEX=I, TITLE=Plant, DESCRIPTION=Plant, WITHIN=PROBLEM_LOCATION,$ FIELD=PROBLEM_DATE, ALIAS=PDATE, FORMAT=YYMD, TITLE='Date,Problem,Reported', DESCRIPTION='Date Problem Was Reported', $ FIELD=PROBLEM_CATEGORY, ALIAS=PROBCAT, FORMAT=A20, $ TITLE='Problem,Category', DESCRIPTION='Problem Category', WITHIN=*Problem,$ FIELD=PROBLEM_LOCATION, ALIAS=PROBLOC, FORMAT=A10, TITLE='Location,Problem,Occurred', DESCRIPTION='Location Where Problem Occurred', WITHIN=PROBLEM_CATEGORY,$ DEFINE PROB_YEAR/YY=PROBLEM_DATE;, TITLE='Year,Problem,Occurred', DESCRIPTION='Year Problem Occurred', WITHIN=*Time Period,$ DEFINE PROB_QUARTER/Q=PROBLEM_DATE; TITLE='Quarter,Problem,Occurred', DESCRIPTION='Quarter Problem Occurred', WITHIN=PROB_YEAR,$ DEFINE PROB_MONTH/M=PROBLEM_DATE; TITLE='Month,Problem,Occurred', DESCRIPTION='Month Problem Occurred', WITHIN=PROB_QUARTER,$ DEFINE PROBLEM_OCCUR/I5 WITH PROBNUM=1;, TITLE='Problem,Occurrence' DESCRIPTION='# of times a problem occurs',$ DEFINE PLANTLNG/A11=DECODE PLANT (BOS 'Boston' DAL 'Dallas' LA 'Los Angeles' ORL 'Orlando' SEA 'Seattle' STL 'St Louis' ELSE 'n/a');$ SEGNAME=INVSEG, SEGTYPE=DKU, PARENT=PROD_SEG, CRFILE=CENTINV, CRKEY=PROD_NUM, CRSEG=INVINFO,$
SECTION 01 STRUCTURE OF FOCUS FILE CENTQA ON 05/15/03 AT 10.46.43 PROD_SEG 01 S1 ************** *PROD_NUM **I * ** * ** * ** * ** *************** ************** I +-----------------+ I I I INVSEG I PROB_SEG 02 I KU 03 I S1 .............. ************** :PROD_NUM :K *PROBNUM ** :PRODNAME : *PLANT **I :QTY_IN_STOCK: *PROBLEM_DATE** :PRICE : *PROBLEM_CAT>** : : * ** :............: *************** JOINED CENTINV **************
FILE=CENTGL ,SUFFIX=FOC SEGNAME=ACCOUNTS, SEGTYPE=S1 FIELDNAME=GL_ACCOUNT, ALIAS=GLACCT, FORMAT=A7, TITLE='Ledger,Account', FIELDTYPE=I, $ FIELDNAME=GL_ACCOUNT_PARENT, ALIAS=GLPAR, FORMAT=A7, TITLE=Parent, PROPERTY=PARENT_OF, REFERENCE=GL_ACCOUNT, $ FIELDNAME=GL_ACCOUNT_TYPE, ALIAS=GLTYPE, FORMAT=A1, TITLE=Type,$ FIELDNAME=GL_ROLLUP_OP, ALIAS=GLROLL, FORMAT=A1, TITLE=Op, $ FIELDNAME=GL_ACCOUNT_LEVEL, ALIAS=GLLEVEL, FORMAT=I3, TITLE=Lev, $ FIELDNAME=GL_ACCOUNT_CAPTION, ALIAS=GLCAP, FORMAT=A30, TITLE=Caption, PROPERTY=CAPTION, REFERENCE=GL_ACCOUNT, $ FIELDNAME=SYS_ACCOUNT, ALIAS=ALINE, FORMAT=A6, TITLE='System,Account,Line', MISSING=ON, $
SECTION 01 STRUCTURE OF FOCUS FILE CENTGL ON 05/15/03 AT 15.18.48 ACCOUNTS 01 S1 ************** *GL_ACCOUNT **I *GL_ACCOUNT_>** *GL_ACCOUNT_>** *GL_ROLLUP_OP** * ** *************** **************
FILE=CENTSYSF ,SUFFIX=FOC SEGNAME=RAWDATA ,SEGTYPE=S2 FIELDNAME = SYS_ACCOUNT , ,A6 , FIELDTYPE=I, TITLE='System,Account,Line', $ FIELDNAME = PERIOD , ,YYM , FIELDTYPE=I,$ FIELDNAME = NAT_AMOUNT , ,D10.0 , TITLE='Month,Actual', $ FIELDNAME = NAT_BUDGET , ,D10.0 , TITLE='Month,Budget', $ FIELDNAME = NAT_YTDAMT , ,D12.0 , TITLE='YTD,Actual', $ FIELDNAME = NAT_YTDBUD , ,D12.0 , TITLE='YTD,Budget', $
SECTION 01 STRUCTURE OF FOCUS FILE CENTSYSF ON 05/15/03 AT 15.19.27 RAWDATA 01 S2 ************** *SYS_ACCOUNT **I *PERIOD **I *NAT_AMOUNT ** *NAT_BUDGET ** * ** *************** **************
FILE=CENTSTMT, SUFFIX=FOC SEGNAME=ACCOUNTS, SEGTYPE=S1 FIELD=GL_ACCOUNT, ALIAS=GLACCT, FORMAT=A7, TITLE='Ledger,Account', FIELDTYPE=I, $ FIELD=GL_ACCOUNT_PARENT, ALIAS=GLPAR, FORMAT=A7, TITLE=Parent, PROPERTY=PARENT_OF, REFERENCE=GL_ACCOUNT, $ FIELD=GL_ACCOUNT_TYPE, ALIAS=GLTYPE, FORMAT=A1, TITLE=Type,$ FIELD=GL_ROLLUP_OP, ALIAS=GLROLL, FORMAT=A1, TITLE=Op, $ FIELD=GL_ACCOUNT_LEVEL, ALIAS=GLLEVEL, FORMAT=I3, TITLE=Lev, $ FIELD=GL_ACCOUNT_CAPTION, ALIAS=GLCAP, FORMAT=A30, TITLE=Caption, PROPERTY=CAPTION, REFERENCE=GL_ACCOUNT, $ SEGNAME=CONSOL, SEGTYPE=S1, PARENT=ACCOUNTS, $ FIELD=PERIOD, ALIAS=MONTH, FORMAT=YYM, $ FIELD=ACTUAL_AMT, ALIAS=AA, FORMAT=D10.0, MISSING=ON, TITLE='Actual', $ FIELD=BUDGET_AMT, ALIAS=BA, FORMAT=D10.0, MISSING=ON, TITLE='Budget', $ FIELD=ACTUAL_YTD, ALIAS=AYTD, FORMAT=D12.0, MISSING=ON, TITLE='YTD,Actual', $ FIELD=BUDGET_YTD, ALIAS=BYTD, FORMAT=D12.0, MISSING=ON, TITLE='YTD,Budget', $
SECTION 01 STRUCTURE OF FOCUS FILE CENTSTMT ON 05/15/03 AT 14.45.44 ACCOUNTS 01 S1 ************** *GL_ACCOUNT **I *GL_ACCOUNT_>** *GL_ACCOUNT_>** *GL_ROLLUP_OP** * ** *************** ************** I I I I CONSOL 02 I S1 ************** *PERIOD ** *ACTUAL_AMT ** *BUDGET_AMT ** *ACTUAL_YTD ** * ** *************** **************
|
Information Builders |