camdata: User Friendly Access to CAM Data Sources

Documented in F4101

#' Item Master
#' 
#' F4101 - Item Master 
#' 
#' @param db2_connection JDE Database Connection
#' @param friendly_names Flag to return human-readable column names.  Default TRUE.
#' @export
F4101 <- function(db2_connection, friendly_names = TRUE) {
    F4101 <- dplyr::tbl(db2_connection, dbplyr::in_schema('PRODDTA', 'F4101'))
        if (friendly_names) {
            F4101 <- F4101 %>% dplyr::select(
                `Item Number - Short` = `IMITM`,
                `2nd Item Number` = `IMLITM`,
                `3rd Item Number` = `IMAITM`,
                `Description` = `IMDSC1`,
                `Description - Line 2` = `IMDSC2`,
                `Search Text` = `IMSRTX`,
                `Search Text - Compressed` = `IMALN`,
                `Sales Catalog Section` = `IMSRP1`,
                `Sub Section` = `IMSRP2`,
                `Sales Category Code 3` = `IMSRP3`,
                `Sales Category Code 4` = `IMSRP4`,
                `Sales Category Code 5` = `IMSRP5`,
                `Category Code 6` = `IMSRP6`,
                `Category Code 7` = `IMSRP7`,
                `Category Code 8` = `IMSRP8`,
                `Category Code 9` = `IMSRP9`,
                `Category Code 10` = `IMSRP0`,
                `Commodity Class` = `IMPRP1`,
                `Commodity Sub Class` = `IMPRP2`,
                `Supplier Rebate Code` = `IMPRP3`,
                `Master Planning Family` = `IMPRP4`,
                `Purchasing Category Code 5` = `IMPRP5`,
                `Group - Item Dimension` = `IMPRP6`,
                `Group - Warehouse Process 1` = `IMPRP7`,
                `Group - Warehouse Process 2` = `IMPRP8`,
                `Group - Warehouse Process 3` = `IMPRP9`,
                `Item Pool` = `IMPRP0`,
                `Commodity Code` = `IMCDCD`,
                `Product Group` = `IMPDGR`,
                `Dispatch Group` = `IMDSGP`,
                `Item Price Group` = `IMPRGR`,
                `Reprice (Basket Price) Category` = `IMRPRC`,
                `Order Reprice Category` = `IMORPR`,
                `Buyer Number` = `IMBUYR`,
                `Drawing Number` = `IMDRAW`,
                `Last Revision No.` = `IMRVNO`,
                `Drawing Size` = `IMDSZE`,
                `Cubic Dimensions - Volume` = `IMVCUD`,
                `Carrier Number` = `IMCARS`,
                `Preferred Carrier - Purchasing` = `IMCARP`,
                `Shipping Conditions Code` = `IMSHCN`,
                `Shipping Commodity Class` = `IMSHCM`,
                `Unit of Measure - Primary` = `IMUOM1`,
                `Unit of Measure - Secondary` = `IMUOM2`,
                `Unit of Measure - Purchasing` = `IMUOM3`,
                `Unit of Measure - Pricing` = `IMUOM4`,
                `Unit of Measure - Shipping` = `IMUOM6`,
                `Unit of Measure - Production` = `IMUOM8`,
                `Unit of Measure - Component` = `IMUOM9`,
                `Unit of Measure - Weight` = `IMUWUM`,
                `Unit of Measure - Volume` = `IMUVM1`,
                `Unit of Measure - Stocking` = `IMSUTM`,
                `Unit of Measure - Volume or Weight` = `IMUMVW`,
                `Cycle Count Category` = `IMCYCL`,
                `Category - G/L` = `IMGLPT`,
                `Level - Sales Base Price` = `IMPLEV`,
                `Level - Purchase Price` = `IMPPLV`,
                `Level - Inventory Cost` = `IMCLEV`,
                `Grade/Potency Pricing` = `IMPRPO`,
                `Check Availability Y/N` = `IMCKAV`,
                `Bulk/Packed Flag` = `IMBPFG`,
                `Layer Code - Source` = `IMSRCE`,
                `Potency Control` = `IMOT1Y`,
                `Grade Control` = `IMOT2Y`,
                `Standard Potency` = `IMSTDP`,
                `From Potency` = `IMFRMP`,
                `Thru Potency` = `IMTHRP`,
                `Standard Grade` = `IMSTDG`,
                `From Grade` = `IMFRGD`,
                `Thru Grade` = `IMTHGD`,
                `Component Type` = `IMCOTY`,
                `Stocking Type` = `IMSTKT`,
                `Line Type` = `IMLNTY`,
                `Contract - Item` = `IMCONT`,
                `Backorders Allowed (Y/N)` = `IMBACK`,
                `Item Flash Message` = `IMIFLA`,
                `Standard Unit of Measure Conversion` = `IMTFLA`,
                `Print Message` = `IMINMG`,
                `ABC Code 1 - Sales - Inventory` = `IMABCS`,
                `ABC Code 1 - Margin - Inventory` = `IMABCM`,
                `ABC Code 3 - Investment - Inventory` = `IMABCI`,
                `ABC Code Override Indicator` = `IMOVR`,
                `Type Warranty` = `IMWARR`,
                `Commission Category` = `IMCMCG`,
                `Serial Number Required` = `IMSRNR`,
                `Method - Kit/Configurator Pricing` = `IMPMTH`,
                `FIFO Processing` = `IMFIFO`,
                `Lot Status Code` = `IMLOTS`,
                `Days - Shelf Life Days` = `IMSLD`,
                `Planner Number` = `IMANPL`,
                `Planning Code` = `IMMPST`,
                `Percent Margin` = `IMPCTM`,
                `Margin Maintenance (%)` = `IMMMPC`,
                `Material Status` = `IMPTSC`,
                `Round to Whole Number` = `IMSNS`,
                `Leadtime Level` = `IMLTLV`,
                `Leadtime MFG` = `IMLTMF`,
                `Leadtime Cumulative` = `IMLTCM`,
                `Order Policy Code` = `IMOPC`,
                `Value - Order Policy` = `IMOPV`,
                `Quantity - Accounting Cost` = `IMACQ`,
                `Quantity - MFG Leadtime` = `IMMLQ`,
                `Leadtime Per Unit` = `IMLTPU`,
                `Planning Time Fence Rule` = `IMMPSP`,
                `Fixed or Variable Leadtime` = `IMMRPP`,
                `Issue Type Code` = `IMITC`,
                `Order With` = `IMORDW`,
                `Planning Time Fence Days` = `IMMTF1`,
                `Freeze Time Fence Days` = `IMMTF2`,
                `Message Time Fence Days` = `IMMTF3`,
                `MPS/MRP Time Fence 4` = `IMMTF4`,
                `Shipment Leadtime Offset` = `IMMTF5`,
                `Expedite Damper Days` = `IMEXPD`,
                `Defer Damper Days` = `IMDEFD`,
                `Safety Leadtime` = `IMSFLT`,
                `Make/Buy Code` = `IMMAKE`,
                `Co-Products/By-Products/Intermediate` = `IMCOBY`,
                `Low Level Code` = `IMLLX`,
                `Commitment Method` = `IMCMGL`,
                `Commitment - Specific (Days)` = `IMCOMH`,
                `User Reserved Code` = `IMURCD`,
                `User Reserved Date` = `IMURDT`,
                `User Reserved Amount` = `IMURAT`,
                `User Reserved Number` = `IMURAB`,
                `User Reserved Reference` = `IMURRF`,
                `User ID` = `IMUSER`,
                `Program ID` = `IMPID`,
                `Work Station ID` = `IMJOBN`,
                `Date - Updated` = `IMUPMJ`,
                `Time of Day` = `IMTDAY`,
                `UPC Number` = `IMUPCN`,
                `Aggregate SCC Code (PI=0)` = `IMSCC0`,
                `Unit of Measure - UPC` = `IMUMUP`,
                `Unit of Measure - Aggregate UPC` = `IMUMDF`,
                `Unit of Measure - SCC(PI=0)` = `IMUMS0`,
                `Unit of Measure - SCC(PI=1)` = `IMUMS1`,
                `Unit of Measure - SCC(PI=2)` = `IMUMS2`,
                `Unit of Measure - SCC(PI=3)` = `IMUMS3`,
                `Unit of Measure - SCC(PI=4)` = `IMUMS4`,
                `Unit of Measure - SCC(PI=5)` = `IMUMS5`,
                `Unit of Measure - SCC(PI=6)` = `IMUMS6`,
                `Unit of Measure - SCC(PI=7)` = `IMUMS7`,
                `Unit of Measure - SCC(PI=8)` = `IMUMS8`,
                `Issue and Receipt` = `IMPOC`,
                `Replenishment Hours - Standard` = `IMAVRT`,
                `Container Code` = `IMEQTY`,
                `Item Weight Required Y/N` = `IMWTRQ`,
                `Template` = `IMTMPL`,
                `Segment 1` = `IMSEG1`,
                `Segment 2` = `IMSEG2`,
                `Segment 3` = `IMSEG3`,
                `Segment 4` = `IMSEG4`,
                `Segment 5` = `IMSEG5`,
                `Segment 6` = `IMSEG6`,
                `Segment 7` = `IMSEG7`,
                `Segment 8` = `IMSEG8`,
                `Segment 9` = `IMSEG9`,
                `Segment 10` = `IMSEG0`,
                `Matrix Controlled` = `IMMIC`,
                `Active Ingredient Flag` = `IMAING`,
                `Best Before Default Days` = `IMBBDD`,
                `Commitment Date Method` = `IMCMDM`,
                `Lot Expiraton Date Calculation Method` = `IMLECM`,
                `Lot Effective Default Days` = `IMLEDD`,
                `Purchasing Effective Days` = `IMPEFD`,
                `Sell By Default Days` = `IMSBDD`,
                `User Lot Date 1 Default Days` = `IMU1DD`,
                `User Lot Date 2 Default Days` = `IMU2DD`,
                `User Lot Date 3 Default Days` = `IMU3DD`,
                `User Lot Date 4 Default Days` = `IMU4DD`,
                `User Lot Date 5 Default Days` = `IMU5DD`,
                `Dual Tolerance` = `IMDLTL`,
                `Dual Picking Process Option` = `IMDPPO`,
                `Dual Unit Of Measure Item` = `IMDUAL`,
                `Cross-Docking Flag` = `IMXDCK`,
                `Lot Audit Flag` = `IMLAF`,
                `Special Lot Format` = `IMLTFM`,
                `Restrict Work Order Lot Assignment` = `IMRWLA`,
                `Lot Number Pre-Assignment` = `IMLNPA`,
                `Lot Status Code Expanded` = `IMLOTC`,
                `Constraints Flag` = `IMAPSC`,
                `APS Planning UOM` = `IMAUOM`,
                `Consumable` = `IMCONB`,
                `Composition` = `IMGCMP`,
                `Priority One Alert Level` = `IMPRI1`,
                `Priority Two Alert Level` = `IMPRI2`,
                `Allow Shipping of Held Lots` = `IMASHL`,
                `Vendor Managed Inventory` = `IMVMINV`,
                `Method - Configurator Costing` = `IMCMETH`,
                `Explode Item (1/0)` = `IMEXPI`,
                `Minimum Operational Threshold` = `IMOPTH`,
                `Minimum Cumulative Threshold` = `IMCUTH`,
                `Operational Threshold Unit of Measure` = `IMUMTH`,
                `Lean Manufacturing Flag` = `IMLMFG`,
                `Line/Cell Identifier` = `IMLINE`,
                `Total Product Cycle Time` = `IMDFTPCT`,
                `Kanban Item` = `IMKBIT`,
                `Demand Flow End Item Flag` = `IMDFENDITM`,
                `Kanban Explode to Lower Level` = `IMKANEXLL`,
                `Sellable Item` = `IMSCPSELL`,
                `Maximum Operational Threshold` = `IMMOPTH`,
                `Maximum Cumulative Threshold` = `IMMCUTH`,
                `Cumulative Threshold Unit of Measure` = `IMCUMTH`,
                `ATP Rule Name` = `IMATPRN`,
                `Check ATP` = `IMATPCA`,
                `ATP Components` = `IMATPAC`,
                `Country of Origin Required Flag` = `IMCOORE`,
                `ATO Forecast Control` = `IMVCPFC`,
                `Production Number Controlled` = `IMPNYN`
            )
        }
    return(F4101)
}