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 |
