R/F3003.R

In ejneer/camdata: User Friendly Access to CAM Data Sources

#' Routing Master File
#' 
#' F3003 - Routing Master File 
#' 
#' @param db2_connection JDE Database Connection
#' @param friendly_names Flag to return human-readable column names.  Default TRUE.
#' @export
F3003 <- function(db2_connection, friendly_names = TRUE) {
    F3003 <- dplyr::tbl(db2_connection, dbplyr::in_schema('PRODDTA', 'F3003'))
        if (friendly_names) {
            F3003 <- F3003 %>% dplyr::select(
                `Type of Routing` = `IRTRT`,
                `Parent (short) Item Number` = `IRKIT`,
                `Kit - 2nd Item Number` = `IRKITL`,
                `3rd Item Number - Kit` = `IRKITA`,
                `Branch` = `IRMMCU`,
                `Auto Load Description` = `IRALD`,
                `Description` = `IRDSC1`,
                `Line/Cell Identifier` = `IRLINE`,
                `Business Unit` = `IRMCU`,
                `Sequence Number - Operations` = `IROPSQ`,
                `Effective - From Date` = `IREFFF`,
                `Effective - Thru Date` = `IREFFT`,
                `Pay Point Code` = `IRBFPF`,
                `Labor or Machine` = `IRLAMC`,
                `Time Basis Code` = `IRTIMB`,
                `Factor - Operation Shrinkage Factor` = `IROPSR`,
                `Units - Batch Quantity` = `IRBQTY`,
                `Unit of Measure as Input` = `IRUOM`,
                `Run Machine - Standard` = `IRRUNM`,
                `Run Labor - Standard` = `IRRUNL`,
                `Setup Labor - Standard` = `IRSETL`,
                `Rate - Piecework` = `IRPWRT`,
                `Crew Size` = `IRSETC`,
                `Move Hours - Standard` = `IRMOVD`,
                `Queue Hours - Standard` = `IRQUED`,
                `Percent - Leadtime Overlap` = `IRLTPC`,
                `Percent - Overlap` = `IRPOVR`,
                `Sequence Number - Next Operation` = `IRNXOP`,
                `Percent - Operational Planned Yield` = `IROPYP`,
                `Percent - Cumulative Planned Yield` = `IRCPYP`,
                `Unit or Tag Number` = `IRAPID`,
                `Message Number` = `IRSHNO`,
                `Type Operation Code` = `IROPSC`,
                `Inspection Code` = `IRINPE`,
                `Job Type (Craft) Code` = `IRJBCD`,
                `Address Number` = `IRAN8`,
                `Primary / Last Supplier Number` = `IRVEND`,
                `Purchase Order (Y/N)` = `IRPOY`,
                `Cost Component` = `IRCOST`,
                `Project Business Unit` = `IROMCU`,
                `Object Account` = `IROBJ`,
                `Subsidiary` = `IRSUB`,
                `Routing Revision Level` = `IRRREV`,
                `User Reserved Code` = `IRURCD`,
                `User Reserved Date` = `IRURDT`,
                `User Reserved Amount` = `IRURAT`,
                `User Reserved Reference` = `IRURRF`,
                `User Reserved Number` = `IRURAB`,
                `User ID` = `IRUSER`,
                `Program ID` = `IRPID`,
                `Date - Updated` = `IRUPMJ`,
                `Time of Day` = `IRTDAY`,
                `Work Station ID` = `IRJOBN`,
                `Workcenter Branch` = `IRWMCU`,
                `Location` = `IRLOCN`,
                `Resource units consumed` = `IRRUC`,
                `Capacity Unit of measure` = `IRCAPU`,
                `Activity-Based Costing Activity Code` = `IRACTB`,
                `Asset Item Number` = `IRNUMB`,
                `Co/By Counter` = `IRCBCO`,
                `Component/Ingredient Counter` = `IRCICO`,
                `Intermediate Counter` = `IRIMCO`,
                `Minimum Production` = `IRMPRO`,
                `Constraints Flag` = `IRAPSC`,
                `Minimum Separation` = `IRMNSP`,
                `Maximum Separation` = `IRMXSP`,
                `Competency Type` = `IRCMPE`,
                `Competency Code` = `IRCMPC`,
                `Competency Level From` = `IRCPLVLFR`,
                `Competency Level To` = `IRCPLVLTO`,
                `Rule Match Flag` = `IRCMRQ`,
                `Address Number - Manager` = `IRANSA`,
                `Supervisor` = `IRANPA`,
                `Address Number - Assigned To` = `IRANP`,
                `Maintenance Schedule Flag` = `IRWSCHF`,
                `Resources Assigned` = `IRTRAF`,
                `DFM Operation On Critical Path` = `IRDFOPC`
            )
        }
    return(F3003)
}