VIEW BOM Routing Resources


VIEW BOM Routing Resources

Share this:

Price: $149.99

 

Product Description

NOTE - This is a VIEW not a report and enables you to build dozens of reports.  

What happens now?

Once you've decided on the report or view you'd like to buy, simply add it to your basket and proceed through the checkout. You will visit 2checkout.com who are our payment processor, and on successful payment you will return to our site and the code will be unlocked for you to use. There will be a direct link in the order confirmation screen, or you can view the code at any time in the future through your Account screen.

What am I buying?

There are a total of 205 lines of code in this product. Here is an example:
69.    Resource_Type.MEANING Resource_Type,
70.    RR.UNIT_OF_MEASURE Resource_Unit_Of_Measure,
71.    DECODE(RWIP.BASIS_TYPE, 'LOT', (1/DECODE(ASSY.FIXED_LOT_MULTIPLIER, NULL,
72.   1, 0,1, ASSY.FIXED_LOT_MULTIPLIER)
73.   ), 1) * RWIP.USAGE_RATE_OR_AMOUNT Resource_Units_Per_Assembly,
74.    RMTR.EFFECTIVITY_DATE Routing_Effective_Date,

Report Fields

Cost Type Resource Name Assembly Item
Activity Alternate Routing Assembly Description
Assembly Item Type Assembly Unit Of Measure Available 24 Hours Flag
Backflush Flag Common Routing Item Common Routing Assembly Desc
Completion Subinventory Configuration Bill Flag Cost Element
Cost Type Count Point Department
Department Description Department Disable Date Department Resource Capacity
Department Share Capacity Flag Engineering Change Order Engineering Initiation Date
Engineering Routing Flag Flow Routing Flag Minimum Transfer Quantity
Operation Item Operation Code Operation Description
Operation Disable Date Operation Effective Date Operation Lead Time Percent
Operation Sequence Number Option Dependent Flag Outside Process Description
Resource Autocharge Resource Capacity Units Resource Cost Basis
Resource Cost Code Resource Cost Per Assembly Resource Description
Resource Disable Date Resource Group Name Resource Missing Cost Flag
Resource Name Resource Offset Percent Resource Schedule Code
Resource Sequence Number Resource Type Resource Unit Of Measure
Resource Units Per Assembly Routing Effective Date Routing Effective Time
Routing Implementation Date Routing Revision Standard Rate Flag
Usage Rate Or Amount Usage Rate Or Amount Inverse

You may also like