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>