R/F3002.R

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

#' Bill of Material Master File
#' 
#' F3002 - Bill of Material Master File 
#' 
#' @param db2_connection JDE Database Connection
#' @param friendly_names Flag to return human-readable column names.  Default TRUE.
#' @export
F3002 <- function(db2_connection, friendly_names = TRUE) {
    F3002 <- dplyr::tbl(db2_connection, dbplyr::in_schema('PRODDTA', 'F3002'))
        if (friendly_names) {
            F3002 <- F3002 %>% dplyr::select(
                `Type Bill of Material` = `IXTBM`,
                `Parent (short) Item Number` = `IXKIT`,
                `Kit - 2nd Item Number` = `IXKITL`,
                `3rd Item Number - Kit` = `IXKITA`,
                `Branch` = `IXMMCU`,
                `Item Number - Short` = `IXITM`,
                `2nd Item Number` = `IXLITM`,
                `3rd Item Number` = `IXAITM`,
                `Component Branch` = `IXCMCU`,
                `Component Line Number` = `IXCPNT`,
                `Substitute Item Sequence Number` = `IXSBNT`,
                `Partials Allowed (Y/N)` = `IXPRTA`,
                `Quantity - Standard Required Quantity` = `IXQNTY`,
                `Unit of Measure` = `IXUM`,
                `Units - Batch Quantity` = `IXBQTY`,
                `Unit of Measure as Input` = `IXUOM`,
                `Fixed or Variable Batch Size` = `IXFVBT`,
                `Effective - From Date` = `IXEFFF`,
                `Effective - Thru Date` = `IXEFFT`,
                `Effective From Serial Number` = `IXFSER`,
                `Effective Thru Serial Number` = `IXTSER`,
                `Issue Type Code` = `IXITC`,
                `Required` = `IXFTRC`,
                `Optional Item (Kit)` = `IXOPTK`,
                `Default Component` = `IXFORV`,
                `Component Costing Method` = `IXCSTM`,
                `Costing Method - Purchasing` = `IXCSMP`,
                `Order With` = `IXORDW`,
                `Fixed or Variable Quantity` = `IXFORQ`,
                `Co-Products/By-Products/Intermediate` = `IXCOBY`,
                `Component Type` = `IXCOTY`,
                `From Potency` = `IXFRMP`,
                `Thru Potency` = `IXTHRP`,
                `From Grade` = `IXFRGD`,
                `Thru Grade` = `IXTHGD`,
                `Sequence Number - Operations` = `IXOPSQ`,
                `Sequence - Bubble Sequence` = `IXBSEQ`,
                `Feature Planned Percent` = `IXFTRP`,
                `Feature Cost Percent` = `IXF$RP`,
                `Resource Percent` = `IXRSCP`,
                `Percent - Percent of Scrap` = `IXSCRP`,
                `Percent - Rework` = `IXREWP`,
                `Percent - As is` = `IXASIP`,
                `Percent - Cumulative Planned Yield` = `IXCPYP`,
                `Operation Scrap Percent` = `IXSTPP`,
                `Leadtime Offset Days` = `IXLOVD`,
                `ECO Number` = `IXECO`,
                `Engineering Change Reason` = `IXECTY`,
                `Date - Engineering Change Date` = `IXECOD`,
                `Description` = `IXDSC1`,
                `Line Type` = `IXLNTY`,
                `Unit Price per Primary` = `IXPRIC`,
                `Amount - Unit Cost` = `IXUNCS`,
                `Percent Assembly Sales Price` = `IXPCTK`,
                `Message Number` = `IXSHNO`,
                `Project Business Unit` = `IXOMCU`,
                `Object Account` = `IXOBJ`,
                `Subsidiary` = `IXSUB`,
                `Bill Revision Level` = `IXBREV`,
                `Component Revision Level` = `IXCMRV`,
                `Last Revision No.` = `IXRVNO`,
                `Item Number - Use Up/Go To` = `IXUUPG`,
                `User Reserved Code` = `IXURCD`,
                `User Reserved Date` = `IXURDT`,
                `User Reserved Amount` = `IXURAT`,
                `User Reserved Reference` = `IXURRF`,
                `User Reserved Number` = `IXURAB`,
                `User ID` = `IXUSER`,
                `Program ID` = `IXPID`,
                `Work Station ID` = `IXJOBN`,
                `Date - Updated` = `IXUPMJ`,
                `Time of Day` = `IXTDAY`,
                `Active Ingredient Flag` = `IXAING`,
                `Substitute Counter` = `IXSUCO`,
                `Consumption Start` = `IXSTRC`,
                `Consumption End` = `IXENDC`,
                `Constraints Flag` = `IXAPSC`,
                `Component Line Number BOM` = `IXCPNB`,
                `Bubble Sequence Alpha Numeric` = `IXBSEQAN`,
                `Lean Superflush Flag` = `IXBCHAR`,
                `Prep Code` = `IXBOSTR`
            )
        }
    return(F3002)
}