23maverick23
6/30/2014 - 2:46 PM

NSOA: Default advanced mappings 06232014

NSOA: Default advanced mappings 06232014

<PULL>
    <EMPLOYEE_TO_USER>
        OA_FIELDS nickname,email,role_id,job_code_id,primary_filter_set,line_manager_id
        OA_FIELDS_INITIAL_ONLY nickname,email,role_id,job_code_id,primary_filter_set

        role_id '2'
        job_code_id '2'
        primary_filter_set '2'
        line_manager_id lookup=supervisor:lookup_table=user:lookup_by=netsuite_user_id:lookup_return=id
    </EMPLOYEE_TO_USER>

    <CUSTOMER_TO_CUSTOMER>
        OA_FIELDS web,phone,fax,email,address1,address2,city,state,zip
        OA_FIELDS_INITIAL_ONLY web,phone,fax,email,address1,address2,city,state,zip
        NS_FIELDS url,phone,fax,email

        web url
        phone phone
        fax fax
        email email
    </CUSTOMER_TO_CUSTOMER>

    <JOB_TO_PROJECT>
        OA_FIELDS start_date,user_id,notes,netsuite_exchange_rate,project_stage_id,budget,budget_time,netsuite_project_expenses
        OA_CUSTOM_FIELDS netsuite_exchange_rate,netsuite_project_expenses
        OA_FIELDS_INITIAL_ONLY user_id
        NS_FIELDS jobPrice,startDate,comments,custentity_oa_project_stage,custentity_oa_budget_money,custentity_oa_budget_hours
        NS_CUSTOM_FIELDS custentity_oa_project_stage,custentity_oa_budget_money,custentity_oa_budget_hours

        user_id '2'
        start_date startDate
        notes comments
        netsuite_exchange_rate '1'
        netsuite_project_expenses 'Billable'
        budget custentity_oa_budget_money
        budget_time custentity_oa_budget_hours

        # used to catch projects without a stage selected; sets them to Active
        IF <<END
            IF (custentity_oa_project_stage < '1') THEN project_stage_id '2'
        END
    </JOB_TO_PROJECT>

    <PROJECT_BILLING_RULE_TIME>
        OA_FIELDS start_date,end_date,category_when,rate_from,slip_stage_id,rate_card_id,rate_multiplier
        NS_FIELDS rate

        start_date _REMOVE
        end_date _REMOVE
        category_when 'A'
        rate_from 'R'
        rate_card_id '8'
        slip_stage_id '1'
        rate_multiplier rate

    </PROJECT_BILLING_RULE_TIME>

    <PROJECT_BILLING_RULE_FIXED_FEE>
        OA_FIELDS start_date,end_date,category_id,category_when,percent,name,amount,description,slip_stage_id,cost_center_id
        NS_FIELDS memo,amount,quantity,rate,item

        start_date _REMOVE
        end_date _REMOVE
        category_when 'A'
        percent '100'
        name memo,' (', quantity,' @ ' , rate, ')'
        description memo,' (', quantity,' @ ' , rate, ')'
        amount amount
        slip_stage_id '1'
        cost_center_id '1'
    </PROJECT_BILLING_RULE_FIXED_FEE>

    <EXPENSE_CATEGORY_TO_ITEM>
        OA_FIELDS type

        type 'R'
    </EXPENSE_CATEGORY_TO_ITEM>
</PULL>

<PUSH>
    <TIMESHEET>
        OA_FIELDS id

        FILTER <<END
            id > '1718'
        END
    </TIMESHEET>

    <EXPENSE_REP_TO_EXPENSE_REP>
        OA_FIELDS number,date_approved
        NS_FIELDS custbody_oa_exp_approved
        NS_CUSTOM_FIELDS custbody_oa_exp_approved

        custbody_oa_exp_approved date_approved

        FILTER <<END
            number > '594'
        END
    </EXPENSE_REP_TO_EXPENSE_REP>

    <INVOICE_TO_INVOICE>
        OA_FIELDS number

        FILTER <<END
            number > '691'
        END
    </INVOICE_TO_INVOICE>

    <REVENUE_TO_JOURNAL>
        OA_FIELDS id

        FILTER <<END
            id > '6232'
        END
    </REVENUE_TO_JOURNAL>
</PUSH>