Find Jobs
Hire Freelancers

Cost Dist Conversion Process

$100-500 USD

Completed
Posted over 14 years ago

$100-500 USD

Paid on delivery
Convert historical distribution data held in table COST_DIST_PROJECT and merge into existing and new distribution records in table COST_DIST_LOCATION. DB Oracle 10g Would prefer to have the solution as a stored procedure if possible. ## Deliverables Convert historical distribution data held in table COST_DIST_PROJECT and merge into existing and new distribution records in table COST_DIST_LOCATION 1. Generate all historical cost location allocations up to 100%; select only records where the percentage allocated is < 100%. Then generate a new cost location record allocated to the home cost location for the remainder amount and percentage. 2. Select all project distributions and match against the percentage and expense report line item or expense report split line item and update the Project Id on the COST_DIST_LOCATION record. 3. Then, calculate the distribution amounts for all COST_DIST_LOCATION records. The amount allocated to each record should be calculated by summing the total PAYMENT_AMOUNT for each distinct expense_report_pk, expense_item_pk/expense_item_split_pk held in the ACCOUNTING_EXPORT_ARCHIVE table and for the specific cost_dist_cost_loc matching the allocated cost_loc in the COST_DIST_LOCATION table. Select on RPT record types from the ACCOUNTING_EXPORT_ARCHIVE table to perform this match. Update the accumulated amount into the cost_dist_location record.
Project ID: 2794734

About the project

6 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$238 USD in 4 days
5.0 (4 reviews)
3.5
3.5
6 freelancers are bidding on average $135 USD for this job
User Avatar
See private message.
$93.50 USD in 4 days
5.0 (2 reviews)
1.8
1.8
User Avatar
See private message.
$144.50 USD in 4 days
5.0 (2 reviews)
0.2
0.2
User Avatar
See private message.
$85 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$127.50 USD in 4 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$119 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Germany
5.0
3
Member since Jun 30, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.