R/F3112.R

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

#' Work Order Routing
#' 
#' F3112 - Work Order Routing 
#' 
#' @param db2_connection JDE Database Connection
#' @param friendly_names Flag to return human-readable column names.  Default TRUE.
#' @export
F3112 <- function(db2_connection, friendly_names = TRUE) {
    F3112 <- dplyr::tbl(db2_connection, dbplyr::in_schema('PRODDTA', 'F3112'))
        if (friendly_names) {
            F3112 <- F3112 %>% dplyr::select(
                `Document (Order No Invoice etc.)` = `WLDOCO`,
                `Order Type` = `WLDCTO`,
                `Order Suffix` = `WLSFXO`,
                `Type of Routing` = `WLTRT`,
                `Parent (short) Item Number` = `WLKIT`,
                `Kit - 2nd Item Number` = `WLKITL`,
                `3rd Item Number - Kit` = `WLKITA`,
                `Branch` = `WLMMCU`,
                `Line/Cell Identifier` = `WLLINE`,
                `Business Unit` = `WLMCU`,
                `Auto Load Description` = `WLALD`,
                `Description` = `WLDSC1`,
                `Sequence Number - Operations` = `WLOPSQ`,
                `Type Operation Code` = `WLOPSC`,
                `Operation Status Code W.O.` = `WLOPST`,
                `Inspection Code` = `WLINPE`,
                `Time Basis Code` = `WLTIMB`,
                `Labor or Machine` = `WLLAMC`,
                `Pay Point Code` = `WLBFPF`,
                `Pay Point Status` = `WLPPRF`,
                `Job Type (Craft) Code` = `WLJBCD`,
                `Address Number` = `WLAN8`,
                `Critical Ratio` = `WLCRTR`,
                `Slack Time Ratio` = `WLSLTR`,
                `Date - Order/Transaction` = `WLTRDJ`,
                `Date - Requested` = `WLDRQJ`,
                `Date - Start (Julian)` = `WLSTRT`,
                `Date - Completion (Julian)` = `WLSTRX`,
                `Shift Code - Requested` = `WLRSFT`,
                `Shift Code - Start` = `WLSSFT`,
                `Shift Code - Completed` = `WLCSFT`,
                `Percent - Leadtime Overlap` = `WLLTPC`,
                `Percent - Overlap` = `WLPOVR`,
                `Percent - Operational Planned Yield` = `WLOPYP`,
                `Percent - Cumulative Planned Yield` = `WLCPYP`,
                `Sequence Number - Next Operation` = `WLNXOP`,
                `Crew Size` = `WLSETC`,
                `Move Hours - Standard` = `WLMOVD`,
                `Queue Hours - Standard` = `WLQUED`,
                `Run Machine - Standard` = `WLRUNM`,
                `Run Labor - Standard` = `WLRUNL`,
                `Setup Labor - Standard` = `WLSETL`,
                `Run Machine - Actual` = `WLMACA`,
                `Run Labor - Actual` = `WLLABA`,
                `Hours - Setup Labor Hours - Actual` = `WLSETA`,
                `Factor - Operation Shrinkage Factor` = `WLOPSR`,
                `Units - Order/Transaction Quantity` = `WLUORG`,
                `Units - Quantity Canceled/Scrapped` = `WLSOCN`,
                `Quantity Shipped` = `WLSOQS`,
                `Units - Quantity at Operation` = `WLQMTO`,
                `Rate - Piecework` = `WLPWRT`,
                `Unit of Measure as Input` = `WLUOM`,
                `Hours - Unaccounted Setup Labor` = `WLCTS2`,
                `Hours - Unaccounted Machine Hours` = `WLCTS3`,
                `Amount - Unaccounted Direct Labor` = `WLCTS4`,
                `Amount - Unaccounted Setup Labor` = `WLCTS5`,
                `Amount - Unaccounted Machine` = `WLCTS6`,
                `Unit or Tag Number` = `WLAPID`,
                `Message Number` = `WLSHNO`,
                `Project Business Unit` = `WLOMCU`,
                `Object Account` = `WLOBJ`,
                `Subsidiary` = `WLSUB`,
                `Primary / Last Supplier Number` = `WLVEND`,
                `Company - Key (Related Order)` = `WLRKCO`,
                `Related PO/SO/WO Number` = `WLRORN`,
                `Related PO/SO/WO Order Type` = `WLRCTO`,
                `Related PO/SO Line Number` = `WLRLLN`,
                `Document Type` = `WLDCT`,
                `User Reserved Code` = `WLURCD`,
                `User Reserved Date` = `WLURDT`,
                `User Reserved Amount` = `WLURAT`,
                `User Reserved Reference` = `WLURRF`,
                `User Reserved Number` = `WLURAB`,
                `User ID` = `WLUSER`,
                `Program ID` = `WLPID`,
                `Work Station ID` = `WLJOBN`,
                `Date - Updated` = `WLUPMJ`,
                `Time of Day` = `WLTDAY`,
                `Location` = `WLLOCN`,
                `Resource units consumed` = `WLRUC`,
                `Capacity Unit of measure` = `WLCAPU`,
                `Workcenter Branch` = `WLWMCU`,
                `Run Machine - Current` = `WLCMHR`,
                `Run Labor - Current` = `WLCLHR`,
                `Setup Labor - Current` = `WLCSHR`,
                `Cost Component` = `WLCOST`,
                `Activity-Based Costing Activity Code` = `WLACTB`,
                `Asset Item Number` = `WLNUMB`,
                `Amount - Unaccounted Scrap` = `WLCTS7`,
                `Units - Unaccounted Scrap` = `WLCTS8`,
                `Hours - Unaccounted Direct Labor` = `WLCTS9`,
                `Run Labor - Rate` = `WLLABP`,
                `Run Machine - Rate` = `WLMACR`,
                `Setup Labor - Rate` = `WLSETR`,
                `Constraints Flag` = `WLAPSC`,
                `Time - Scheduled Start (HH/MM/SS)` = `WLSEST`,
                `Time - Scheduled End (HH/MM/SS)` = `WLSEET`,
                `Time - Completed` = `WLTMCO`,
                `Date - Actual Start` = `WLD2J`,
                `Time - Start (HH/MM/SS)` = `WLSTTI`,
                `Competency Type` = `WLCMPE`,
                `Competency Code` = `WLCMPC`,
                `Competency Level From` = `WLCPLVLFR`,
                `Competency Level To` = `WLCPLVLTO`,
                `Rule Match Flag` = `WLCMRQ`,
                `Address Number - Manager` = `WLANSA`,
                `Supervisor` = `WLANPA`,
                `Address Number - Assigned To` = `WLANP`,
                `Maintenance Schedule Flag` = `WLWSCHF`,
                `Resources Assigned` = `WLTRAF`
            )
        }
    return(F3112)
}