Report

Dear Friends

There is a requirement for which we need to extract a report

Requirement

""Measure the carrieru2019s ability to pick up goods at the warehouse, on time, and measure the warehouse ability to have the items ready on time for collection by the carriers""

Formula

1) Turnaround time = the time between the truck arrives at the warehouse and the time between

it leaves the warehouse

2) % of refused trucks or containers = number of trucks or containers refused / the number of

trucks or containers that arrived at the warehouse gate

3) % on time pick up = collection on time / number of scheduled daily shipments

Friends please suggest me where can i take all the table & field names for developing a new report or any existing report is already available?

Required table & filed names

Company code (production plant or sales and distribution company)

Warehouse

Carrier

Turnaround time

% of refused trucks / containers

% on time pick up in hours

Month

Day

time truck arrival

time truck departure

Turnaround time

number of trucks or containers refused

number of trucks or containers total

% of refused trucks / containers

Number of collection on time

number of scheduled daily shipments

% on time pick up in hours