camdata: User Friendly Access to CAM Data Sources

Documented in F4102

#' Item Branch File
#' 
#' F4102 - Item Branch File 
#' 
#' @param db2_connection JDE Database Connection
#' @param friendly_names Flag to return human-readable column names.  Default TRUE.
#' @export
F4102 <- function(db2_connection, friendly_names = TRUE) {
    F4102 <- dplyr::tbl(db2_connection, dbplyr::in_schema('PRODDTA', 'F4102'))
        if (friendly_names) {
            F4102 <- F4102 %>% dplyr::select(
                `Item Number - Short` = `IBITM`,
                `2nd Item Number` = `IBLITM`,
                `3rd Item Number` = `IBAITM`,
                `Business Unit` = `IBMCU`,
                `Sales Catalog Section` = `IBSRP1`,
                `Sub Section` = `IBSRP2`,
                `Sales Category Code 3` = `IBSRP3`,
                `Sales Category Code 4` = `IBSRP4`,
                `Sales Category Code 5` = `IBSRP5`,
                `Category Code 6` = `IBSRP6`,
                `Category Code 7` = `IBSRP7`,
                `Category Code 8` = `IBSRP8`,
                `Category Code 9` = `IBSRP9`,
                `Category Code 10` = `IBSRP0`,
                `Commodity Class` = `IBPRP1`,
                `Commodity Sub Class` = `IBPRP2`,
                `Supplier Rebate Code` = `IBPRP3`,
                `Master Planning Family` = `IBPRP4`,
                `Purchasing Category Code 5` = `IBPRP5`,
                `Group - Item Dimension` = `IBPRP6`,
                `Group - Warehouse Process 1` = `IBPRP7`,
                `Group - Warehouse Process 2` = `IBPRP8`,
                `Group - Warehouse Process 3` = `IBPRP9`,
                `Item Pool` = `IBPRP0`,
                `Commodity Code` = `IBCDCD`,
                `Product Group` = `IBPDGR`,
                `Dispatch Group` = `IBDSGP`,
                `Primary / Last Supplier Number` = `IBVEND`,
                `Planner Number` = `IBANPL`,
                `Buyer Number` = `IBBUYR`,
                `Category - G/L` = `IBGLPT`,
                `Country of Origin` = `IBORIG`,
                `Reorder Point - Input` = `IBROPI`,
                `Reorder Quantity - Input` = `IBROQI`,
                `Reorder Quantity - Maximum` = `IBRQMX`,
                `Reorder Quantity - Minimum` = `IBRQMN`,
                `Quantity - Order Multiples (SO/PO)` = `IBWOMO`,
                `Service Level` = `IBSERV`,
                `Safety Stock` = `IBSAFE`,
                `Days - Shelf Life Days` = `IBSLD`,
                `Check Availability Y/N` = `IBCKAV`,
                `Layer Code - Source` = `IBSRCE`,
                `Lot Status Code` = `IBLOTS`,
                `Potency Control` = `IBOT1Y`,
                `Grade Control` = `IBOT2Y`,
                `Standard Potency` = `IBSTDP`,
                `From Potency` = `IBFRMP`,
                `Thru Potency` = `IBTHRP`,
                `Standard Grade` = `IBSTDG`,
                `From Grade` = `IBFRGD`,
                `Thru Grade` = `IBTHGD`,
                `Component Type` = `IBCOTY`,
                `Margin Maintenance (%)` = `IBMMPC`,
                `Item Price Group` = `IBPRGR`,
                `Reprice (Basket Price) Category` = `IBRPRC`,
                `Order Reprice Category` = `IBORPR`,
                `Backorders Allowed (Y/N)` = `IBBACK`,
                `Item Flash Message` = `IBIFLA`,
                `ABC Code 1 - Sales - Inventory` = `IBABCS`,
                `ABC Code 1 - Margin - Inventory` = `IBABCM`,
                `ABC Code 3 - Investment - Inventory` = `IBABCI`,
                `ABC Code Override Indicator` = `IBOVR`,
                `Shipping Commodity Class` = `IBSHCM`,
                `Carrier Number` = `IBCARS`,
                `Preferred Carrier - Purchasing` = `IBCARP`,
                `Shipping Conditions Code` = `IBSHCN`,
                `Stocking Type` = `IBSTKT`,
                `Line Type` = `IBLNTY`,
                `FIFO Processing` = `IBFIFO`,
                `Cycle Count Category` = `IBCYCL`,
                `Print Message` = `IBINMG`,
                `Type Warranty` = `IBWARR`,
                `Serial Number Required` = `IBSRNR`,
                `Percent Margin` = `IBPCTM`,
                `Commission Category` = `IBCMCG`,
                `AIA Document Flag` = `IBFUF1`,
                `Purchasing Taxable (Y/N)` = `IBTX`,
                `Sales Taxable (Y/N)` = `IBTAX1`,
                `Planning Code` = `IBMPST`,
                `Item Display Code` = `IBMRPD`,
                `Flag - Net Change` = `IBMRPC`,
                `Units - Per Container` = `IBUPC`,
                `Round to Whole Number` = `IBSNS`,
                `Item Revision Level` = `IBMERL`,
                `Leadtime Level` = `IBLTLV`,
                `Leadtime MFG` = `IBLTMF`,
                `Leadtime Cumulative` = `IBLTCM`,
                `Order Policy Code` = `IBOPC`,
                `Value - Order Policy` = `IBOPV`,
                `Quantity - Accounting Cost` = `IBACQ`,
                `Quantity - MFG Leadtime` = `IBMLQ`,
                `Leadtime Per Unit` = `IBLTPU`,
                `Planning Time Fence Rule` = `IBMPSP`,
                `Fixed or Variable Leadtime` = `IBMRPP`,
                `Issue Type Code` = `IBITC`,
                `ECO Number` = `IBECO`,
                `Engineering Change Reason` = `IBECTY`,
                `Date - Engineering Change Date` = `IBECOD`,
                `Planning Time Fence Days` = `IBMTF1`,
                `Freeze Time Fence Days` = `IBMTF2`,
                `Message Time Fence Days` = `IBMTF3`,
                `MPS/MRP Time Fence 4` = `IBMTF4`,
                `Shipment Leadtime Offset` = `IBMTF5`,
                `Move Hours - Standard` = `IBMOVD`,
                `Queue Hours - Standard` = `IBQUED`,
                `Setup Labor - Standard` = `IBSETL`,
                `Shrink Factor` = `IBSRNK`,
                `Shrink Factor Method` = `IBSRKF`,
                `Time Basis Code` = `IBTIMB`,
                `Units - Batch Quantity` = `IBBQTY`,
                `Order With` = `IBORDW`,
                `Expedite Damper Days` = `IBEXPD`,
                `Defer Damper Days` = `IBDEFD`,
                `Quantity - Order Multiples (MRP)` = `IBMULT`,
                `Safety Leadtime` = `IBSFLT`,
                `Make/Buy Code` = `IBMAKE`,
                `Date - Future Use` = `IBLFDJ`,
                `Low Level Code` = `IBLLX`,
                `Commitment Method` = `IBCMGL`,
                `User Reserved Code` = `IBURCD`,
                `User Reserved Date` = `IBURDT`,
                `User Reserved Amount` = `IBURAT`,
                `User Reserved Number` = `IBURAB`,
                `User Reserved Reference` = `IBURRF`,
                `User ID` = `IBUSER`,
                `Program ID` = `IBPID`,
                `Work Station ID` = `IBJOBN`,
                `Date - Updated` = `IBUPMJ`,
                `Time of Day` = `IBTDAY`,
                `Standard Unit of Measure Conversion` = `IBTFLA`,
                `Commitment - Specific (Days)` = `IBCOMH`,
                `Replenishment Hours - Standard` = `IBAVRT`,
                `Issue and Receipt` = `IBPOC`,
                `Active Ingredient Flag` = `IBAING`,
                `Best Before Default Days` = `IBBBDD`,
                `Commitment Date Method` = `IBCMDM`,
                `Lot Expiraton Date Calculation Method` = `IBLECM`,
                `Lot Effective Default Days` = `IBLEDD`,
                `Mix Dates / Lots (Y/N)` = `IBMLOT`,
                `Purchasing Effective Days` = `IBPEFD`,
                `Sell By Default Days` = `IBSBDD`,
                `User Lot Date 1 Default Days` = `IBU1DD`,
                `User Lot Date 2 Default Days` = `IBU2DD`,
                `User Lot Date 3 Default Days` = `IBU3DD`,
                `User Lot Date 4 Default Days` = `IBU4DD`,
                `User Lot Date 5 Default Days` = `IBU5DD`,
                `Cross-Docking Flag` = `IBXDCK`,
                `Lot Audit Flag` = `IBLAF`,
                `Special Lot Format` = `IBLTFM`,
                `Restrict Work Order Lot Assignment` = `IBRWLA`,
                `Lot Number Pre-Assignment` = `IBLNPA`,
                `Lot Status Code Expanded` = `IBLOTC`,
                `Constraints Flag` = `IBAPSC`,
                `Priority One Alert Level` = `IBPRI1`,
                `Priority Two Alert Level` = `IBPRI2`,
                `Leadtime Conversion Factor` = `IBLTCV`,
                `Allow Shipping of Held Lots` = `IBASHL`,
                `Minimum Operational Threshold` = `IBOPTH`,
                `Minimum Cumulative Threshold` = `IBCUTH`,
                `Operational Threshold Unit of Measure` = `IBUMTH`,
                `Lean Manufacturing Flag` = `IBLMFG`,
                `Line/Cell Identifier` = `IBLINE`,
                `Total Product Cycle Time` = `IBDFTPCT`,
                `Kanban Item` = `IBKBIT`,
                `Demand Flow End Item Flag` = `IBDFENDITM`,
                `Kanban Explode to Lower Level` = `IBKANEXLL`,
                `Sellable Item` = `IBSCPSELL`,
                `Maximum Operational Threshold` = `IBMOPTH`,
                `Maximum Cumulative Threshold` = `IBMCUTH`,
                `Cumulative Threshold Unit of Measure` = `IBCUMTH`,
                `ATP Rule Name` = `IBATPRN`,
                `Check ATP` = `IBATPCA`,
                `ATP Components` = `IBATPAC`,
                `Country of Origin Required Flag` = `IBCOORE`,
                `ATO Forecast Control` = `IBVCPFC`,
                `Production Number Controlled` = `IBPNYN`
            )
        }
    return(F4102)
}