BU_ITEMS_INV

(SQL Table)
 Index Back

Operating Inventory Record

This record contains quantities and attributes for items in a business unit.

  • Parent Record Of BU_ITEMS_CONFIG BU_ITMS_CFG_ESR BU_ITM_CFG_TML4

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUIN_NONVW

    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 ITM_STATUS_EFFDT Date(10) DATE Item Status Date

    Default Value: %DATE

    4 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    5=Pending Approval
    6=Denied Approval
    7=Under Initialization
    5 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future
    6 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    7 LAST_ADJUSTMENT Date(10) DATE Last Adjustment
    8 LAST_ORDER Character(10) VARCHAR2(10) NOT NULL Last Order
    9 LAST_ORDER_DATE Date(10) DATE Last Order Date
    10 LAST_PUTAWAY_DATE Date(10) DATE Last Putaway
    11 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
    12 QTY_RESERVED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Reserved
    13 QTY_OWNED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Owned
    14 QTY_ONHAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity On Hand
    15 LAST_DEMAND_CALC Character(1) VARCHAR2(1) NOT NULL Last Demand Calculation
    1=Last Annual
    2=Last 2 Qtrs
    3=Last 3 Qtrs
    4=Last Qtr
    5=Last User Defined Period
    16 LAST_MO_DEMAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Last Month Demand
    17 LAST_QTR_DEMAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Last Quarter Demand
    18 LAST_2QTR_DEMAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Last 2 Qtrs Demand
    19 LAST_ANNUAL_DEMAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Last Ann. Demand
    20 LAST_UD_DEMAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Last User Defined Demand
    21 LAST_DEMAND_DATE Date(10) DATE Last Demand Calc Date
    22 REPLENISH_CLASS Character(4) VARCHAR2(4) NOT NULL Replenish Class

    Prompt Table: REPLEN_CLS_INV

    23 REPL_CALC_PERIOD Number(3,0) SMALLINT NOT NULL Replenish Calc Period (Days)
    24 REPLENISH_LEAD Signed Number(16,2) DECIMAL(14,2) NOT NULL Replenish Lead (Days)
    25 HISTORICAL_LEAD Signed Number(16,2) DECIMAL(14,2) NOT NULL Historic Lead
    26 PROJECTED_LEAD Signed Number(16,2) DECIMAL(14,2) NOT NULL Projected Lead
    27 SAFETY_STOCK Signed Number(17,4) DECIMAL(15,4) NOT NULL Safety Stock
    28 STOCKOUT_RATE Number(4,1) DECIMAL(3,1) NOT NULL Desired Stock-In Probability

    Prompt Table: STKOUT_RATE_INV

    29 REORDER_POINT Signed Number(17,4) DECIMAL(15,4) NOT NULL Reorder Point
    30 REORDER_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Reorder Qty
    31 QTY_IUT_PAR Signed Number(17,4) DECIMAL(15,4) NOT NULL InterUnit Par Qty
    32 EOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Economic Order Quantity
    33 AOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Average Order Qty
    34 FOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Fixed Order Quantity
    35 QTY_MAXIMUM Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Qty
    36 DAYS_SUPPLY Number(16,4) DECIMAL(15,4) NOT NULL Number of Days Supply
    37 ORDER_MULTIPLE Number(6,0) INTEGER NOT NULL Order Quantity Multiple
    38 SAFETY_LEAD_TIME Number(16,4) DECIMAL(15,4) NOT NULL Safety Lead Time
    39 TARGET_LEVEL Number(16,4) DECIMAL(15,4) NOT NULL Target Stocking Level
    40 EXCESS_BU Character(5) VARCHAR2(5) NOT NULL Excess Business Unit

    Prompt Table: SP_BUIN_NONVW

    41 LAST_ISS_EXCESS Number(5,0) INTEGER NOT NULL Last Issue Excess Offset
    42 USE_UP_QOH Character(1) VARCHAR2(1) NOT NULL Use Up Quantity On Hand

    Y/N Table Edit

    Default Value: N

    43 INSPECT_TIME Number(16,4) DECIMAL(15,4) NOT NULL Inspection Lead Time
    44 DOCK_TO_STOCK Number(16,4) DECIMAL(15,4) NOT NULL Dock to Stock Lead Time
    45 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

    Prompt Table: CM_MATL_ELE_VW

    46 COST_GROUP_CD Character(6) VARCHAR2(6) NOT NULL Standard Cost Group

    Prompt Table: CM_COSTGROUP

    47 LAST_CYCLE_COUNT Date(10) DATE Last Cycle Count

    Default Value: %Date

    48 LAST_PIT_COUNT Date(10) DATE Last Physical Count
    49 LAST_UTIL_REVIEW Date(10) DATE Last Utilization Review Date
    50 NEXT_UTIL_REVIEW Date(10) DATE Next Utilization Review Date
    51 RELATED_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Related Item
    52 ROPC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL ROPC Instance
    53 ROPC_STATUS Character(1) VARCHAR2(1) NOT NULL ROPC Status
    1=Not Processed
    2=In Process
    3=Process Complete

    Default Value: 1

    54 SSTC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL SSTC Instance
    55 SSTC_STATUS Character(1) VARCHAR2(1) NOT NULL SSTC Status
    1=Not Processed
    2=In Process
    3=Process Complete

    Default Value: 1

    56 EOQC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL EOQC Instance
    57 EOQC_STATUS Character(1) VARCHAR2(1) NOT NULL EOQC Status
    1=Not Processed
    2=In Process
    3=Process Complete

    Default Value: 1

    58 HLDC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Hist Lead Calc Instance
    59 HLDC_STATUS Character(1) VARCHAR2(1) NOT NULL Hist Lead Calc Status
    1=Not Processed
    2=In Process
    3=Process Complete

    Default Value: 1

    60 ANNDM_INSTANCE Number(10,0) DECIMAL(10) NOT NULL AnnDem Instance
    61 ANNDM_STATUS Character(1) VARCHAR2(1) NOT NULL AnnDem Status
    1=Not Processed
    2=In Process
    3=Complete

    Default Value: 1

    62 CYCLE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Cycle Count Instance
    63 NO_REPLENISH_FLG Character(1) VARCHAR2(1) NOT NULL Not Included In Replenishment

    Y/N Table Edit

    Default Value: Y

    64 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
    1=Make
    2=Buy
    3=Expense
    4=Service
    5=Floor Stock
    6=Planning

    Default Value: 2

    65 PHANTOM_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Phantom Item

    Y/N Table Edit

    Default Value: N

    66 BOM_USAGE Character(2) VARCHAR2(2) NOT NULL BOM Usage
    1=By Effectivity Date
    2=By Revision

    Default Value: BUS_UNIT_OPT_MG.BOM_USAGE

    67 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

    Default Value: %Datetime

    68 LAST_PRICE_PAID Number(15,4) DECIMAL(14,4) NOT NULL Last Price Paid
    69 AVERAGE_COST Number(15,4) DECIMAL(14,4) NOT NULL Average Purchase Price
    70 AVERAGE_COST_MAT Number(15,4) DECIMAL(14,4) NOT NULL Average Material Cost
    71 CURRENT_COST Number(15,4) DECIMAL(14,4) NOT NULL Current Purchase Cost
    72 DFLT_ACTUAL_COST Number(15,4) DECIMAL(14,4) NOT NULL Default Actual Cost
    73 EXCESS_INVENTORY Character(1) VARCHAR2(1) NOT NULL Excess Inventory
    N=None
    R=Repair
    S=Score

    Default Value: N

    74 REVISION_CONTROL Character(1) VARCHAR2(1) NOT NULL Revision Control

    Y/N Table Edit

    Default Value: BUS_UNIT_OPT_MG.REVISION_CONTROL

    75 EN_AUTO_REV Character(1) VARCHAR2(1) NOT NULL 02/16/99 LAJ...CN#EG800-1.0 Yes/No field to indicate if new revisions should be created automatically.

    Y/N Table Edit

    Default Value: BUS_UNIT_OPT_MG.EN_AUTO_REV

    76 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
    COM=Use Comp.
    ISS=Issue
    KIT=Kit
    REPL=Replenish

    Default Value: ISS

    77 STAGED_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL Staged Date Control
    N=Staged Date Tracking OFF
    Y=Staged Date Tracking ON
    78 ISSUE_MULTIPLE Number(16,4) DECIMAL(15,4) NOT NULL Prdn Issue Multiple

    Default Value: 1

    79 REPLENISH_POINT Number(16,4) DECIMAL(15,4) NOT NULL Prdn Replenishment Point
    80 WIP_MIN_QTY Number(16,4) DECIMAL(15,4) NOT NULL WIP Minimum Quantity
    81 IP_PLANNING_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Policy Planning Item

    Y/N Table Edit

    Default Value: N

    82 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

    Prompt Table: PLANNER_TBL

    83 YIELD_CALC_FLG Character(1) VARCHAR2(1) NOT NULL Calc Comp Yield at Completion

    Y/N Table Edit

    Default Value: N

    84 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

    Prompt Table: %EDITTABLE

    85 TRANSIT_COST_TYP Character(1) VARCHAR2(1) NOT NULL Transit Priority Type
    C=Percentage of Item Cost
    F=Fixed Cost
    Q=Factor of Quantity
    W=Factor of Weight

    Default Value: F

    86 UOM_CONV_FLAG Character(1) VARCHAR2(1) NOT NULL UOM Conversion Flag
    0=Use Entered UOM
    1=Convert to Standard UOM
    2=Convert to Default Stock UOM

    Default Value: BU_ATTRIB_INV.UOM_CONV_FLAG

    87 MASTER_RTG_OPT Character(3) VARCHAR2(3) NOT NULL Master Routing Option
    FAM=Item Family
    GRP=Item Group
    ITM=Item

    Default Value: ITM

    88 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item

    Default Value: BU_ITEMS_INV.INV_ITEM_ID

    Prompt Table: MG_ITEM_OWN1_VW

    89 STD_PACK_UOM Character(3) VARCHAR2(3) NOT NULL Standard Pack Unit of Measure

    Prompt Table: INV_SHIP_UOM_VW

    90 FORECAST_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Demand Planning Item

    Y/N Table Edit

    Default Value: N

    91 FORECASTER Character(20) VARCHAR2(20) NOT NULL Forecaster

    Prompt Table: DP_FORECASTER

    92 COUNTRY_IST_ORIGIN Character(3) VARCHAR2(3) NOT NULL Intrastat Country of Origin

    Prompt Table: COUNTRY_TBL

    93 IST_REGION_ORIGIN Character(4) VARCHAR2(4) NOT NULL Intrastat Region of Origin

    Prompt Table: STATE_TBL_IST_V

    94 TRANSFER_MIN_ORDER Number(12,4) DECIMAL(11,4) NOT NULL CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Min Order Qty. jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/26/02: Added label PL_TRANS_MIN_ORDER
    95 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
    96 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
    N=No
    Y=Yes

    Y/N Table Edit

    97 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type

    Prompt Table: STOCK_TYPE_INV

    98 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD

    99 ISOLATE_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL 11/10/1999 whs - added

    Y/N Table Edit

    Default Value: N

    100 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes

    Y/N Table Edit

    101 MG_PRDN_OPTION Character(2) VARCHAR2(2) NOT NULL 09/23/98 SCC CN#EN800-4.0: New field
    01=Use BOM/Routing Defaults
    02=Use Prdn Option Maintenance

    Default Value: 01

    102 MG_VALID_PRDN_OPT Character(1) VARCHAR2(1) NOT NULL 03/03/99 SCC CN#EN800-4.0: New field

    Y/N Table Edit

    Default Value: N

    103 MG_ASSOCIATED_BOM Character(18) VARCHAR2(18) NOT NULL 04/99 LAJ CN#EN800.6.0 Necessary for new CPG functionality. It stores the assembly item that is the primary method for producing secondary co-products. This field defaults to the assembly item (itself).

    Default Value: BU_ITEMS_INV.INV_ITEM_ID

    Prompt Table: MG_ITEM_OWN1_VW

    104 SHELF_LIFE Number(4,0) SMALLINT NOT NULL Shelf Life (Days)
    105 AVAIL_LEAD_TIME Number(4,0) SMALLINT NOT NULL Availability Lead Time (Days)
    106 RETEST_LEAD_TIME Number(4,0) SMALLINT NOT NULL Retest Lead Time (Days)
    107 MATERIAL_RECON_FLG Character(1) VARCHAR2(1) NOT NULL Material Reconciliation Flag

    Y/N Table Edit

    Default Value: MASTER_ITEM_TBL.MATERIAL_RECON_FLG

    108 USG_TRCKNG_METHOD Character(2) VARCHAR2(2) NOT NULL Usage Tracking Method
    01=None
    02=Billing
    03=Costing

    Default Value: MASTER_ITEM_TBL.USG_TRCKNG_METHOD

    109 CHARGE_MARKUP_PCNT Signed Number(16,2) DECIMAL(14,2) NOT NULL Charge Markup %

    Default Value: INV_ITEMS.CHARGE_MARKUP_PCNT

    110 CHARGE_MARKUP_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Charge Markup Amt

    Default Value: INV_ITEMS.CHARGE_MARKUP_AMT

    111 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code

    Default Value: INV_ITEMS.CHARGE_CODE

    Prompt Table: CHARGE_CODE_INV

    112 MFG_COSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Used in Manufacturing

    Y/N Table Edit

    Default Value: N

    113 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

    Y/N Table Edit

    Default Value: N

    114 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_SET_INV_VW

    115 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_LOC_INV_VW

    116 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database

    Prompt Table: EN_BOMC_HP_VW

    117 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

    Prompt Table: EN_RTG_HDR_VW

    118 MFG_LEADTIME_F Number(3,0) SMALLINT NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
    119 MFG_LEADTIME_V Number(3,0) SMALLINT NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
    120 MFG_LTRATEF Character(2) VARCHAR2(2) NOT NULL mfg fixed lead time rate
    DY=Days
    HR=Hours
    MN=Minutes
    SC=Seconds

    Default Value: HR

    121 MFG_LTRATEV Character(2) VARCHAR2(2) NOT NULL Mfg var lead time rate
    DY=Days
    HR=Hours
    MN=Minutes
    SC=Seconds

    Default Value: HR

    122 OVERSIZED Character(1) VARCHAR2(1) NOT NULL Oversized Item

    Y/N Table Edit

    Default Value: N

    123 ADD_HANDLING Character(1) VARCHAR2(1) NOT NULL Additional Handling

    Y/N Table Edit

    Default Value: N

    124 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    125 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    126 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    127 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    128 ITEM_FIELD_C30_E Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    129 ITEM_FIELD_C30_F Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    130 ITEM_FIELD_C30_G Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    131 ITEM_FIELD_C30_H Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    132 ITEM_FIELD_C30_I Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    133 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    134 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    135 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    136 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    137 ITEM_FIELD_C1_E Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    138 ITEM_FIELD_C1_F Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    139 ITEM_FIELD_C1_G Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    140 ITEM_FIELD_C1_H Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    141 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    142 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    143 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    144 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    145 ITEM_FIELD_C10_E Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    146 ITEM_FIELD_C10_F Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    147 ITEM_FIELD_C10_G Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    148 ITEM_FIELD_C10_H Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    149 ITEM_FIELD_C10_I Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    150 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
    151 ITEM_FIELD_C2_B Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
    152 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
    153 ITEM_FIELD_C4_B Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
    154 ITEM_FIELD_C4_C Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
    155 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
    156 ITEM_FIELD_C6_B Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
    157 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
    158 ITEM_FIELD_C8_B Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
    159 ITEM_FIELD_C8_C Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
    160 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
    161 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
    162 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
    163 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
    164 ITEM_FIELD_N12_E Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
    165 ITEM_FIELD_N12_F Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
    166 ITEM_FIELD_N12_G Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
    167 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
    168 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
    169 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
    170 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
    171 ITEM_FIELD_N15_E Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
    172 ITEM_FIELD_N15_F Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
    173 ITEM_FIELD_N15_G Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
    174 EXPORTER_ECCN Character(16) VARCHAR2(16) NOT NULL Export Cntl Classification Nbr
    175 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
    176 INCL_WIP_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Include WIP Quantity

    Y/N Table Edit

    Default Value: N

    177 DECLARED_VALUE Signed Number(17,0) DECIMAL(16) NOT NULL Custom's Declared Value
    178 SF_WIP_MAX_QTY Number(16,4) DECIMAL(15,4) NOT NULL WIP maximum QTY
    179 SF_RPL_MODE Character(1) VARCHAR2(1) NOT NULL Replenishment Mode
    1=Backflush
    2=Manual
    3=Kanban

    Default Value: 1

    180 SF_RPL_SOURCE Character(1) VARCHAR2(1) NOT NULL Repl Source
    1=Inventory
    2=Supplier
    3=Feeder

    Default Value: 1

    181 SF_RPL_METHOD Character(1) VARCHAR2(1) NOT NULL Replenishment Method
    1=Pull List
    2=Pull Ticket
    3=Workflow

    Default Value: 3

    182 SF_RPL_TYPE Character(1) VARCHAR2(1) NOT NULL Rpl Type
    1=One Time
    2=Reusable

    Default Value: 1

    183 SF_DISPATCH_MODE Character(1) VARCHAR2(1) NOT NULL Dispatch Mode
    1=Deferred
    2=Immediate

    Default Value: 1

    184 SF_RPL_STOR_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

    Prompt Table: SF_RPLLOC_AR_VW

    185 SF_RPL_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL Level 1

    Prompt Table: SF_RPLLOC_L1_VW

    186 SF_RPL_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL Level 2

    Prompt Table: SF_RPLLOC_L2_VW

    187 SF_RPL_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL Level 3

    Prompt Table: SF_RPLLOC_L3_VW

    188 SF_RPL_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL Level 4

    Prompt Table: SF_RPLLOC_L4_VW

    189 SF_RPL_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Replenishment Vendor ID

    Prompt Table: VENDOR_PO_VW

    190 SF_RPL_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Replinshment Vendor

    Prompt Table: VNDR_LOC_VW3

    191 SF_RPL_PRDN_AREA Character(10) VARCHAR2(10) NOT NULL Production Area

    Prompt Table: SF_PA_PR_SCH_VW

    192 DP_PUBLISH_DATE Date(10) DATE DP_PUBLISH_DATE
    193 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
    194 DP_POLICYCONTROL Character(20) VARCHAR2(20) NOT NULL DP_POLICYCONTROL
    195 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
    196 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: IN_ITEM_PROD_VW

    197 VMI_REPLEN_UOM Character(3) VARCHAR2(3) NOT NULL Replenishment UOM

    Prompt Table: INV_ORD3_UOM_VW
    Set Control Field: BUSINESS_UNIT

    198 REORD_QTY_OPTION Character(2) VARCHAR2(2) NOT NULL Reorder Point Order Quantities
    1=EOQ
    2=Min/Max
    3=AOQ
    4=Static Reorder Qty
    5=Demand Quantity
    99=Use Business Unit Default
    199 REPL_INCL_DEMAND Character(1) VARCHAR2(1) NOT NULL Include Demand

    Y/N Table Edit

    Default Value: N

    200 REPL_DMD_DAYS_OPT Character(1) VARCHAR2(1) NOT NULL Offset Days Option
    1=Replenish Lead Days
    2=Offset Days
    201 OFFSET_DAYS Number(4,0) SMALLINT NOT NULL The number of days to +/- from the current value date when forecasting.
    202 LOT_BACKFLUSH_OPT Character(1) VARCHAR2(1) NOT NULL Backflush Lot Option
    0=Default from BU
    1=Manual
    2=Earliest Expiration Date
    3=Earliest Available Date

    Default Value: 0