Revision Date 3/19/2013 3/19/2013 3/21/2013 3/21/2013 3/23/2013 3/23/2013

Version v1 v2 v3 v4 v5 v5

Revision By Vasim C Gaurav U Katherine L Vasim C Katherine L Vasim C

Revision Remarks Table Names Compiled Added few more details Provided descriptions and remarks for some tables Prioritized the table details that we need Added desc and remards to the requested table Request for few more table descriptions

Database Name
SC7PROD

Table Name
CUSTOMER_ORDER

SC7PROD

SALES_PART

SC7PROD

PURCHASE_ORDER_LINE

SC7PROD

CUSTOMER_ORDER_LINE

SC7PROD

Shipments

SC7PROD

accounting_balance_auth

SC7PROD

budget_period_amount1

SC7PROD

inventory_part_in_transit

SC7PROD

inventory_part

SC7PROD

INVENTORY_TRANSACTION_HIST2

SC7PROD

shipment_handling_utility

SC7PROD

cust_order_line_address_2

SC7PROD

identity_invoice_info

SC7PROD

customer_order_delivery

SC7PROD

COMPANY

SC7PROD

EMP_EMPLOYED_TIME

SC7PROD

COMPANY_PERSON_ALL

SC7PROD

PERS_EDUCATION_PROFILE

SC7PROD

PERS_RELATED

SC7PROD

COMPANY_ORG_PUB

SC7PROD

COMPANY_ORG_STRUCTURE

SC7PROD

SALES_MARKET

SC7PROD SC7PROD

SALES_PART_SALESMAN_LOV CUSTOMER_INFO_ADDRESS_TYPE

SC7PROD

INVOICE

SC7PROD

CURRENCY_RATE

SC7PROD

RETURN_MATERIAL_JOIN

SC7PROD

LOV_COMMODITY_GROUP_1

SC7PROD

CUST_ORD_CUSTOMER

SC7PROD

INVENTORY_PART_TAB

SC7PROD

CUSTOMER_ORDER_INV_HEAD

SC7PROD

SALES_PART

SC7PROD SC7PROD

SALES_PART_SALESMAN_LOV CUSTOMER_INFO_ADDRESS

SC7PROD SC7PROD

RETURN_MATERIAL CUSTOMER_ORDER_LINE_ADDRESS

SC7PROD SC7PROD

CUSTOMER_ORDER_ADDRESS CUST_ORD_CUSTOMER_ADDRESS

SC7PROD SC7PROD

CUSTOMER_ORDER_INV_ITEM_JOIN CUST_ORD_CUSTOMER

SC7PROD SC7PROD

CUSTOMER_INFO_ADDRESS_TYPE VMO_BASE_CODEDESC

SC7PROD

VMO_OPPORTUNITY

SC7PROD

INVOICE_TAB

SC7PROD SC7PROD

LEDGER_ITEM_TAB C_GROUP_UNIT_CLI

SC7PROD

CUSTOMER_ORDER_LINE_TAB

SC7PROD

INVENTORY_PART_IN_TRANSIT_ALL

INVENTORY_PART_IN_TRANSIT_ALL

SC7PROD

PURCHASE_ORDER_HIST_TAB

SC7PROD

SHIPMENT_ORDER_LINE

SC7PROD

COMPANY_FINANCE

SC7PROD SC7PROD

ISO_COUNTRY_DEF ORGANIZATION

SC7PROD SC7PROD SC7PROD SC7PROD SC7PROD SC7PROD

VMO_ACTIVITY VMO_COMPANY VMOV_BASE_RELATION VMO_BASE_FIELDTEXT VMO_BASE_USER CUSTOMER_CREDIT_INFO

REC Line Performatce Dashboard and Pe

SCLoad.dbo.Results

Column Name
OBJSTATE

ORDER_NO CONTRACT

CUSTOMER_NO REGION_CODE CUSTOMER_PO_NO CUSTOMER_NAME CONTRACT

CATALOG_NO CATALOG_DESC ORDER_NO DEMAND_ORDER_NO DEMAND_RELEASE DEMAND_SEQUENCE_NO ORDER_NO RELEASE_NO LINE_NO ORDER_NO CONTRACT CATALOG_NO CATALOG_DESC ORDER_ID OBJSTATE

CUSTOMER_NO CUSTOMER_PO_NO CUSTOMER_NAME SALES_CONTRACT_NO LINE_NO

TYPE_DESIGNATION QTY_RETURNED BUY_QTY_DUE QTY_SHIPPED REAL_SHIP_DATE PLANNED_SHIP_DATE WANTED_DELIVERY_DATE PLANNED_DELIVERY_DATE DEMAND_ORDER_REF1

DEMAND_ORDER_REF2 DEMAND_ORDER_REF3 REL_NO LINE_NO SHIPMENT_ID SHIPMENT_ID SHIPMENT_ID SHIPMENT_ID SHIPMENT_ID company

accounting_year accounting_period account code_c code_d code_e code_f code_g code_h code_i code_j amount_balance amount_bud company accounting_year accounting_period account code_c code_d code_e

code_f code_g code_h code_i code_j amount_balance budget_version amount_bud qty_balance contract part_no quantity contract part_no description part_product_code prime_commodity unit_meas contract

part_no quantity direction date_created shipment_id C_container_id part_no part_description c_group_unit_id qty_in_package_unit address1 address2 zip_code city country_code package_unit_id line_no package_unit_id order_no rel_no line_item_no state order_no line_no

rel_no line_item_no IDENTITY IDENTITY_TYPE PARTY_TYPE ORDER_NO LINE_NO REL_NO LINE_ITEM_NO DATE_DELIVERED COMPANY

NAME COMPANY_ID EMP_NO AGREEMENT_NAME AGREEMENT_ID DATE_OF_EMPLOYMENT DATE_OF_LEAVING DEGREE_OF_OCCUPATION EMPLOYMENT_TYPE LEAVING_CAUSE_TYPE LEAVING_CAUSE_ID LEAVING_NOTIFICATION_DATE DATE_OF_EMPLOYMENT COMPANY_ID EMP_NO ASSIGNMENT_TYPE Age CITIZENSHIP COMPANY_OFFICE DATE_OF_BIRTH EMP_CAT_NAME EMPLOYEE_NAME EMPLOYEE_STATUS FNAME FREE_FIELD1 FREE_FIELD3 FREE_FIELD4 FREE_FIELD6 LNAME NAME2 NAME8 ORG_CODE ORG_NAME

ORG_CODE PERSON_ID PLACE_OF_BIRTH POS_CODE POS_TITLE SEX SUP_EMP_NO SUP_NAME VALUE_DESCRIPTION1 VALUE_DESCRIPTION1 PERSON_ID EDUCATION_LEVEL_NO EDUCATION_LEVEL_NAME EDUCATION_FIELD_NO EDUCATION_FIELD_NAME START_YEAR END_YEAR PERSON_ID RELATIVE_PHONE RELATIVE_FIRST_NAME RELATIVE_LAST_NAME EMERGENCY_CONTACT RELATIONSHIP COMPANY_ID ORG_CODE ORG_NAME SUP_ORG_CODE COMPANY_ID SORT_ORG VALID_TO VALID_FROM ORG_CODE MARKET_CODE

OBJVERSION SALESMAN_CODE OBJVERSION CUSTOMER_ID ADDRESS_ID OBJVERSION INVOICE COMPANY

ADV_INV

OBJVERSION COMPANY CURRENCY_CODE VALID_FROM RMA_NO RMA_LINE_NO OBJVERSION COMMODITY_CODE

OBJVERSION CUSTOMER_NO CUST_GRP NAME11 PART_NO PRIME_COMMODITY PART_PRODUCT_CODE TYPE_DESIGNATION SECOND_COMMODITY CONTRACT DESCRIPTION COUNTRY_OF_ORIGIN INVOICE_ID COMPANY PARTY PARTY_TYPE INVOICE_DATE CURRENCY CONTRACT CATALOG_GROUP CATALOG_DESC CATALOG_NO SALESMAN_CODE NAME ADDRESS_ID CUSTOMER_ID COUNTRY RMA_NO SHIP_ADDR_NO REL_NO LINE_NO LINE_ITEM_NO

ORDER_NO COUNTRY_CODE ORDER_NO COUNTRY_CODE CUSTOMER_NO ADDR_NO DISTRICT_CODE * CUSTOMER_NO CURRENCY_CODE NAME CUSTOMER_ID ADDRESS_ID IDCOD IDLNG CODEDESC SORTORDER IDOPP IDOPP as OppRel_Key C_OPPORTUNITYID C_OPPORTUNITYID OPPORTUNITYINFO STARTDATE IDCODOWL C_EXPIREDATE IDCODCUR IDCODPRS C_OPPORTUNITYSEGMENT C_PROBABILITYDOUBLE C_TOTAL_VALUE C_PROBABILITYXORDERVALUE C_FROMDATE C_TODATE IDUSER C_CURRENCYTOTAL1 C_SALESPARTNO_1 C_SALESPARTNODESC1 C_WATT1 C_PRICEWP1 C_PRICEPERUNIT1 C_SALESPRICE1 C_CURRENCYPRICE1 C_QUANTITY1 C_SALESUNIT1 C_KWP1 C_TOTALPRICE1 C_NOPALLETS1 C_NOTRUCKS1

C_SALESPARTNO2 C_SALESPARTNODESC2 C_WATT2 C_PRICEWP2 C_PRICEPERUNIT2 C_SALESPRICE2 C_CURRENCYPRICE2 C_QUANTITY2 C_SALESUNIT2 C_KWP2 C_TOTALPRICE2 C_CURRENCYTOTAL2 C_NOPALLETS2 C_NOTRUCKS2 C_SALESPARTNO3 C_SALESPARTNODESC3 C_WATT3 C_PRICEWP3 C_PRICEPERUNIT3 C_SALESPRICE3 C_CURRENCYPRICE3 C_QUANTITY3 C_SALESUNIT3 C_KWP3 C_TOTALPRICE3 C_CURRENCYTOTAL3 C_NOPALLETS3 C_NOTRUCKS3 DUE_DATE INVOICE_ID COMPANY INVOICE_DATE * CONTRACT PART_NO LOCATION_NO STATE QTY_ONHAND CONTRACT PART_NO BUY_QTY_DUE CUSTOMER_NO DELIVERY_TERMS DEMAND_ORDER_REF1 ROWSTATE DELIVERING_CONTRACT SERIAL_NO

CONTRACT HISTORY_NO HIST_OBJSTATE ORDER_NO SHIPMENT_ID ORDER_NO LINE_NO REL_NO LINE_ITEM_NO Company Code DESCRIPTION Currency Valid from Parallel Currency * Contract ORG_CODE DESCRIPTION ORG_COST COMPANY CALENDER_ID * * * * * Identity Name Party_TYPE_DB Party_ Type Credit_Analysis_code

REC Line Performatce Dashboard and Performance line tables

Date Class ClassFile Comment NCell Charge E Pmpp Umpp Impp Uoc Isc

Rs Rsh FF Iap Irev1 Irev2 SerialNumber

CellType LotCounter Operator Temperature Color Breakage Bin BinCounter Uap Urev1 Urev2 Pmpp_2 Uoc_2 Isc_2 FF_2 NCell_2 Uref TCref CalibID CalibDate FIQuality BIQuality CIQuality FIDBID BIDBID CIDBID MonitorCell WaferID FlasherPower

Description
Status of the order

Customer order no Site

Customer number Region code Customer Purchase Order No Customer Name Site

Part No Part Description Order Number Customer order connected to the PO Customer order line reference information Customer order reference information Order Number Release no of each demand order line no of each order Customer order number Site Part No Part Description Order Number of the customer's order Status of the order

Customer number Customer PO Number Customer Name Contract no for the customer

More information of the parts' characteristics Amount of qty returned Sales qty of the order line Delivered qty of the order line Actual date shipped to customer's location Planned date shipped to custmer's location Customer' wanted date to deliver the order Customer' planned date to deliver the order Depending on the type of order, a reference to the origin is displayed. The order number is displayed for shop orders, work orders, customer orders, purchase orders, and material requisitions. The RMA (Return Material Authorization) number is displayed for RMA authorizations, and the project ID is displayed if the origin is a project line no of each order Realease no of each demand order

Unique key to reference shipment no Unique key to reference shipment no Unique key to reference shipment no Unique key to reference shipment no Unique key to reference shipment no Legal entity in IFS

Account period year Acounting period month. Account no which is assigned to differenciate different account. Product Project Object Currency

Employee CounterPart Accounting currency balance, for example EUR for solar company budget amount for the account and cost center for the year. Legal entity in IFS, Exampel, Module = 14, Cell = 13, Italy = IT, Site Services = 20, Wafer = 21 Account period year. Example 2013 Acounting period month. Example Jan=01, Feb=02, Opening = 0, Closing = 13 Account no which is assigned to differenciate different account. Product Project Object

Currency

Employee CounterPart Version of the budget

Site Part No Quantity of inventory Site = MST01, MST02 = Bonded Warehouse for Roderdam warehouse (K+N, Hellman), MST04 = Bonded Warehouse for CM

Quality of the module - example, Q1, Q2,Q3 watt class examplesm pcs, kgs, grams Site

Part No Quantity of inventory Inventory movement, + (coming in) , - (going out) Transaction creation date Shipment document no. Container id Part no Part Description Pallet ID/Group unit Qty in the group unit address of the shipment address of the shipment zip code of the shipment city of the shipment, Example Boulder country this is tie to the group unit id. customer order detail in each line customer order no release no of the order Customer's address based on state it is located Order No of the order line no of each order

release no of the order Customer No Type of customer Differentiate whether is the a Customer or Supplier Order No of the order line no of each order release no of the order Date on when the order is delivered Legal entity in IFS,

Legal name, Company Name Unique Business Unit ID Unique Employee ID NA NA Date of joining REC Date of leaving REC Type of Employee Reason of Leaving Reason of Leaving ID

NA

NA

NA

Business Unit ID Department Code Department Description Legal entity

Country code,

System generated timestamp. Format:- YYYYMMDDHHMMSS Code to identify the sales person. System generated timestamp. Format:- YYYYMMDDHHMMSS Customer id Address id, to represent multiple address of the customer System generated timestamp. Format:- YYYYMMDDHHMMSS To indicate invoice no Legal entity in IFS

To check for invoice if it is for advance.

System generated timestamp. Format:- YYYYMMDDHHMMSS Legal entity Currency code Validity date of the currency rate Unique RMA ID Line no Date Time Stamp

Customer no Define the customer group Part no of the inventory watt class Quality of the module More information of the parts' characteristics Commodity grp - classification of the parts Site Description of part Country of origin of part's inventory Customer's invoice no Legal entity

Invoice date Currency paid for this invoice Site Watt class + Quality Part Description Part Number

Address id, to represent multiple address of the customer Customer id Country of the customer resided in

release no of the order line no of each order

Order No of the order Country code of the country Order No of the order Country code of the country Customer no Address of the order to be shipped to

Customer order no Currency code Name of the Customer Customer no Address id, to represent multiple address of the customer Document code Language Region / Country

Date due to pay the invoice Invoice no Legal entity Invoice Date Site Part no Warehouse location Status of the group unit Qty on hand to indicate the pallet details Site Part No of the order Order qty Customer no Terms of delivery, Icoterms Purchase order tie to customer order Status of the order line Site to deliver the good Unique number for each module

Site System generated no for tracking PO history Status of the PO history Order no of the PO Shippment number number Purchase order number PO line number Release document version Part Number Basic Company Setup Name of the company Company Currency Date incorported or active in IFS Currency Code ISO code / defination of the country. Site Key cost center Code Name of key cost center code Company ID Master Calender Code

Customer Code Customer Name

Code to analysis Credit of the customer

matce Dashboard and Performance line tables

SCLoad.dbo.Results is not the IFS Table

Remarks
Example, Planned, Released, Reserved, Picked, Partially Delivered, Delivered, Canceled, Invoiced/Closed, or Blocked

Example, = MST01, MST02 = Bonded Warehouse for Roderdam warehouse (K+N, Hellman), MST04 = Bonded Warehouse for CM, M% = Modules, Z% = Sales Company

Example, EU, US, NEA, ASEAN Commonly used

Example, = MST01, MST02 = Bonded Warehouse for Roderdam warehouse (K+N, Hellman), MST04 = Bonded Warehouse for CM, M% = Modules

Example, Planned, Released, Reserved, Picked, Partially Delivered, Delivered, Canceled, Invoiced/Closed, or Blocked

Example, Module = 14, Cell = 13, Italy = IT, Site Services = 20, Wafer = 21 Example, 2013 Example Jan=01, Feb=02, Opening = 0, Closing = 13 This is the linkage to account no

Similar to Accounting_balance_auth. However is the forecast budget amount

Example, MST01, MST02 = Bonded Warehouse for Roderdam warehouse (K+N, Hellman), MST04 = Bonded Warehouse for CM

Example CO

Example, Internal or External

Exampel, Module = 14, Cell = 13, Italy = IT, Site Services = 20, Wafer = 21 Example, REC Cells Pte Ltd 13 = Cell, 13 = Modules, 20 = Site Service, 21 = Wafer

Permanent, Temporary, Contract Voluntarily, Downsizing

10.12. 13, 14,15

Example SG = Singapore, MY = Malaysia, ROW = Rest of World, ROE = Rest of Europe

Invoice_No Example, Module = 14, Cell = 13, Italy = IT, Site Services = 20, Wafer = 21

Example, True or False. False indicates no advance payment is required before delivery of goods.

* IFSAPP, W Warranty, 11-14 Module OEM, 270 WattClass, 1101 Moduler, 11-02 Celler, 11-03 Rmaterial Produktion, 11-04 Tillsatsmaterial Produktion

Example, Q1, Q2,Q3

ISO country code.

ASEAN, Australia.. Etc 0,1,2,399

Example, L4FG, SING_WH2 Example, Avaliable, Reserved, Delivered Example 1 pallet = 40 modules

Example, CIP, FCB Example, Invoiced, Cancelled MST01 --> MST02

MST02 Example, Planned, Released, Arrived, Received, Close

EUR, SGD EUR, SGD

MAINT, SGMAINTCAL

CUSTOMER Customer CA

Database Name
VIPS_*.xlsx

Table Name
Sheet1

Column Name
Product Period Wp Percent Department Cost Center No * *

Description

Departments.xlsx ForecastQlikview.xlsx FinFcst 201*.csv

Sheet1 ASP

Path

\\10.178.10.59\cell public\Reports\Daily\QlikView

Database Name
[ftp://recsolar:qWKF92ex@ftp.kuehnenagel.com/doc/NW_Oyvind Christiansen REC Solar Daily Arrival Report.xls]

Table Name
REC Solar

Column Name
Container Number Port of Loading Port of Discharge Final delivery point (SF only)(S) 1300C/cntr shipped on vessel/local ETA 1400C/cnt arr.dest.port/local 8850S/exp.arr.place of del./Loc Dt 2400/planned day of del/Loc.Date

Description