BU_ITMS_IN_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BU_ITEMS_INV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | ITM_STATUS_EFFDT | Date(10) | DATE |
Item Status Date
Default Value: %DATE |
| 5 | 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 |
| 6 | ITM_STAT_DT_FUTURE | Date(10) | DATE | Item Date Future |
| 7 | ITM_STATUS_FUTURE | Character(1) | VARCHAR2(1) NOT NULL |
Item Status Future
1=Active 2=Hold 3=Discontinue 4=Inactive |
| 8 | LAST_ADJUSTMENT | Date(10) | DATE | Last Adjustment |
| 9 | LAST_ORDER | Character(10) | VARCHAR2(10) NOT NULL | Last Order |
| 10 | LAST_ORDER_DATE | Date(10) | DATE | Last Order Date |
| 11 | LAST_PUTAWAY_DATE | Date(10) | DATE | Last Putaway |
| 12 | QTY_AVAILABLE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Available |
| 13 | QTY_RESERVED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Reserved |
| 14 | QTY_OWNED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Owned |
| 15 | QTY_ONHAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity On Hand |
| 16 | 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 |
| 17 | LAST_MO_DEMAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Last Month Demand |
| 18 | LAST_QTR_DEMAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Last Quarter Demand |
| 19 | LAST_2QTR_DEMAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Last 2 Qtrs Demand |
| 20 | LAST_ANNUAL_DEMAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Last Ann. Demand |
| 21 | LAST_UD_DEMAND | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Last User Defined Demand |
| 22 | LAST_DEMAND_DATE | Date(10) | DATE | Last Demand Calc Date |
| 23 | REPLENISH_CLASS | Character(4) | VARCHAR2(4) NOT NULL |
Replenish Class
Prompt Table: REPLEN_CLS_INV |
| 24 | REPL_CALC_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Replenish Calc Period (Days)
Default Value: REPL_SETUP_INV.REPL_CALC_PERIOD |
| 25 | REPLENISH_LEAD | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Replenish Lead (Days) |
| 26 | HISTORICAL_LEAD | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Historic Lead |
| 27 | PROJECTED_LEAD | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Projected Lead |
| 28 | SAFETY_STOCK | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Safety Stock |
| 29 | STOCKOUT_RATE | Number(4,1) | DECIMAL(3,1) NOT NULL |
Desired Stock-In Probability
Default Value: REPL_SETUP_INV.STOCKOUT_RATE Prompt Table: STKOUT_RATE_INV |
| 30 | REORDER_POINT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Reorder Point |
| 31 | REORDER_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Reorder Qty |
| 32 | QTY_IUT_PAR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | InterUnit Par Qty |
| 33 | EOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Economic Order Quantity |
| 34 | AOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Average Order Qty |
| 35 | FOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Fixed Order Quantity |
| 36 | QTY_MAXIMUM | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Maximum Qty |
| 37 | DAYS_SUPPLY | Number(16,4) | DECIMAL(15,4) NOT NULL | Number of Days Supply |
| 38 | ORDER_MULTIPLE | Number(6,0) | INTEGER NOT NULL | Order Quantity Multiple |
| 39 | SAFETY_LEAD_TIME | Number(16,4) | DECIMAL(15,4) NOT NULL | Safety Lead Time |
| 40 | TARGET_LEVEL | Number(16,4) | DECIMAL(15,4) NOT NULL | Target Stocking Level |
| 41 | EXCESS_BU | Character(5) | VARCHAR2(5) NOT NULL |
Excess Business Unit
Prompt Table: SP_BUIN_NONVW |
| 42 | LAST_ISS_EXCESS | Number(5,0) | INTEGER NOT NULL | Last Issue Excess Offset |
| 43 | USE_UP_QOH | Character(1) | VARCHAR2(1) NOT NULL |
Use Up Quantity On Hand
Y/N Table Edit Default Value: N |
| 44 | INSPECT_TIME | Number(16,4) | DECIMAL(15,4) NOT NULL | Inspection Lead Time |
| 45 | DOCK_TO_STOCK | Number(16,4) | DECIMAL(15,4) NOT NULL | Dock to Stock Lead Time |
| 46 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CM_MATL_ELE_VW |
| 47 | COST_GROUP_CD | Character(6) | VARCHAR2(6) NOT NULL |
Standard Cost Group
Prompt Table: CM_COSTGROUP |
| 48 | LAST_CYCLE_COUNT | Date(10) | DATE |
Last Cycle Count
Default Value: %Date |
| 49 | LAST_PIT_COUNT | Date(10) | DATE | Last Physical Count |
| 50 | LAST_UTIL_REVIEW | Date(10) | DATE | Last Utilization Review Date |
| 51 | NEXT_UTIL_REVIEW | Date(10) | DATE | Next Utilization Review Date |
| 52 | RELATED_ITEM_ID | Character(15) | VARCHAR2(15) NOT NULL | Related Item |
| 53 | ROPC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | ROPC Instance |
| 54 | ROPC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
ROPC Status
1=Not Processed 2=In Process 3=Process Complete Default Value: 1 |
| 55 | SSTC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | SSTC Instance |
| 56 | SSTC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SSTC Status
1=Not Processed 2=In Process 3=Process Complete Default Value: 1 |
| 57 | EOQC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | EOQC Instance |
| 58 | EOQC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
EOQC Status
1=Not Processed 2=In Process 3=Process Complete Default Value: 1 |
| 59 | HLDC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Hist Lead Calc Instance |
| 60 | HLDC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hist Lead Calc Status
1=Not Processed 2=In Process 3=Process Complete Default Value: 1 |
| 61 | ANNDM_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | AnnDem Instance |
| 62 | ANNDM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AnnDem Status
1=Not Processed 2=In Process 3=Complete Default Value: 1 |
| 63 | CYCLE_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Cycle Count Instance |
| 64 | NO_REPLENISH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Not Included In Replenishment
Y/N Table Edit Default Value: Y |
| 65 | 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 |
| 66 | PHANTOM_ITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Phantom Item
Y/N Table Edit Default Value: N |
| 67 | 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 |
| 68 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP |
Date Timestamp
Default Value: %Datetime |
| 69 | LAST_PRICE_PAID | Number(15,4) | DECIMAL(14,4) NOT NULL | Last Price Paid |
| 70 | AVERAGE_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Average Purchase Price |
| 71 | AVERAGE_COST_MAT | Number(15,4) | DECIMAL(14,4) NOT NULL | Average Material Cost |
| 72 | CURRENT_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Current Purchase Cost |
| 73 | DFLT_ACTUAL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Default Actual Cost |
| 74 | EXCESS_INVENTORY | Character(1) | VARCHAR2(1) NOT NULL |
Excess Inventory
N=None R=Repair S=Score Default Value: N |
| 75 | REVISION_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Revision Control
Y/N Table Edit Default Value: BUS_UNIT_OPT_MG.REVISION_CONTROL |
| 76 | 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 |
| 77 | ISSUE_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Component Issue Method
COM=Use Comp. ISS=Issue KIT=Kit REPL=Replenish Default Value: ISS |
| 78 | STAGED_DATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Staged Date Control
N=Staged Date Tracking OFF Y=Staged Date Tracking ON |
| 79 | ISSUE_MULTIPLE | Number(16,4) | DECIMAL(15,4) NOT NULL |
Prdn Issue Multiple
Default Value: 1 |
| 80 | REPLENISH_POINT | Number(16,4) | DECIMAL(15,4) NOT NULL | Prdn Replenishment Point |
| 81 | WIP_MIN_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | WIP Minimum Quantity |
| 82 | IP_PLANNING_FLG | Character(1) | VARCHAR2(1) NOT NULL | Inventory Policy Planning Item |
| 83 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL |
Planner Code
Prompt Table: PLANNER_TBL |
| 84 | YIELD_CALC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Calc Comp Yield at Completion
Y/N Table Edit Default Value: N |
| 85 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Production Area
Prompt Table: %EDITTABLE |
| 86 | 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 |
| 87 | 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 |
| 88 | MASTER_RTG_OPT | Character(3) | VARCHAR2(3) NOT NULL |
Master Routing Option
FAM=Item Family GRP=Item Group ITM=Item Default Value: ITM |
| 89 | 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 |
| 90 | STD_PACK_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Standard Pack Unit of Measure
Prompt Table: INV_SHIP_UOM_VW |
| 91 | FORECAST_ITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Demand Planning Item
Y/N Table Edit Default Value: N |
| 92 | FORECASTER | Character(20) | VARCHAR2(20) NOT NULL |
Forecaster
Prompt Table: DP_FORECASTER |
| 93 | COUNTRY_IST_ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Intrastat Country of Origin
Prompt Table: COUNTRY_TBL |
| 94 | IST_REGION_ORIGIN | Character(4) | VARCHAR2(4) NOT NULL |
Intrastat Region of Origin
Prompt Table: STATE_TBL |
| 95 | 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 |
| 96 | TRANSFER_YIELD | Number(5,1) | DECIMAL(4,1) NOT NULL | Transfer Yield |
| 97 | 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 |
| 98 | INV_STOCK_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Stock Type
Prompt Table: STOCK_TYPE_INV |
| 99 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 100 | ISOLATE_ITEM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/10/1999 whs - added
Y/N Table Edit Default Value: N |
| 101 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes Y/N Table Edit |
| 102 | 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 |
| 103 | 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 |
| 104 | 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 |
| 105 | SHELF_LIFE | Number(4,0) | SMALLINT NOT NULL | Shelf Life (Days) |
| 106 | AVAIL_LEAD_TIME | Number(4,0) | SMALLINT NOT NULL | Availability Lead Time (Days) |
| 107 | RETEST_LEAD_TIME | Number(4,0) | SMALLINT NOT NULL | Retest Lead Time (Days) |
| 108 | MATERIAL_RECON_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Material Reconciliation Flag
Y/N Table Edit Default Value: MASTER_ITEM_TBL.MATERIAL_RECON_FLG |
| 109 | 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 |
| 110 | CHARGE_MARKUP_PCNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL |
Charge Markup %
Default Value: INV_ITEMS.CHARGE_MARKUP_PCNT |
| 111 | CHARGE_MARKUP_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL |
Charge Markup Amt
Default Value: INV_ITEMS.CHARGE_MARKUP_AMT |
| 112 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Charge Code
Default Value: INV_ITEMS.CHARGE_CODE Prompt Table: CHARGE_CODE_INV |
| 113 | MFG_COSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Used in Manufacturing
Y/N Table Edit Default Value: N |
| 114 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Consigned Flag
Default Value: N |
| 115 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VNDR_SET_INV_VW |
| 116 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: VNDR_LOC_INV_VW |
| 117 | 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 |
| 118 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL |
Routing Code
Prompt Table: EN_RTG_HDR_VW |
| 119 | MFG_LEADTIME_F | Number(3,0) | SMALLINT NOT NULL | 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. |
| 120 | MFG_LEADTIME_V | Number(3,0) | SMALLINT NOT NULL | 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. |
| 121 | MFG_LTRATEF | Character(2) | VARCHAR2(2) NOT NULL |
mfg fixed lead time rate
DY=Days HR=Hours MN=Minutes SC=Seconds Default Value: HR |
| 122 | MFG_LTRATEV | Character(2) | VARCHAR2(2) NOT NULL |
Mfg var lead time rate
DY=Days HR=Hours MN=Minutes SC=Seconds Default Value: HR |
| 123 | OVERSIZED | Character(1) | VARCHAR2(1) NOT NULL |
Oversized Item
Y/N Table Edit Default Value: N |
| 124 | ADD_HANDLING | Character(1) | VARCHAR2(1) NOT NULL |
Additional Handling
Y/N Table Edit Default Value: N |
| 125 | ITEM_FIELD_C30_A | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 126 | ITEM_FIELD_C30_B | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 127 | ITEM_FIELD_C30_C | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 128 | ITEM_FIELD_C30_D | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 129 | ITEM_FIELD_C30_E | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 130 | ITEM_FIELD_C30_F | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 131 | ITEM_FIELD_C30_G | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 132 | ITEM_FIELD_C30_H | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 133 | ITEM_FIELD_C30_I | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 134 | ITEM_FIELD_C1_A | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 135 | ITEM_FIELD_C1_B | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 136 | ITEM_FIELD_C1_C | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 137 | ITEM_FIELD_C1_D | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 138 | ITEM_FIELD_C1_E | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 139 | ITEM_FIELD_C1_F | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 140 | ITEM_FIELD_C1_G | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 141 | ITEM_FIELD_C1_H | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 142 | ITEM_FIELD_C10_A | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 143 | ITEM_FIELD_C10_B | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 144 | ITEM_FIELD_C10_C | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 145 | ITEM_FIELD_C10_D | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 146 | ITEM_FIELD_C10_E | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 147 | ITEM_FIELD_C10_F | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 148 | ITEM_FIELD_C10_G | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 149 | ITEM_FIELD_C10_H | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 150 | ITEM_FIELD_C10_I | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 151 | ITEM_FIELD_C2 | Character(2) | VARCHAR2(2) NOT NULL | User-defined item field - Character 2 |
| 152 | ITEM_FIELD_C2_B | Character(2) | VARCHAR2(2) NOT NULL | User-defined item field - Character 2 |
| 153 | ITEM_FIELD_C4 | Character(4) | VARCHAR2(4) NOT NULL | User-defined item field - Character 4 |
| 154 | ITEM_FIELD_C4_B | Character(4) | VARCHAR2(4) NOT NULL | User-defined item field - Character 4 |
| 155 | ITEM_FIELD_C4_C | Character(4) | VARCHAR2(4) NOT NULL | User-defined item field - Character 4 |
| 156 | ITEM_FIELD_C6 | Character(6) | VARCHAR2(6) NOT NULL | User-defined item field - Character 6 |
| 157 | ITEM_FIELD_C6_B | Character(6) | VARCHAR2(6) NOT NULL | User-defined item field - Character 6 |
| 158 | ITEM_FIELD_C8 | Character(8) | VARCHAR2(8) NOT NULL | User-defined item field - Character 8 |
| 159 | ITEM_FIELD_C8_B | Character(8) | VARCHAR2(8) NOT NULL | User-defined item field - Character 8 |
| 160 | ITEM_FIELD_C8_C | Character(8) | VARCHAR2(8) NOT NULL | User-defined item field - Character 8 |
| 161 | ITEM_FIELD_N12_A | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 162 | ITEM_FIELD_N12_B | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 163 | ITEM_FIELD_N12_C | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 164 | ITEM_FIELD_N12_D | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 165 | ITEM_FIELD_N12_E | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 166 | ITEM_FIELD_N12_F | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 167 | ITEM_FIELD_N12_G | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 168 | ITEM_FIELD_N15_A | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 169 | ITEM_FIELD_N15_B | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 170 | ITEM_FIELD_N15_C | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 171 | ITEM_FIELD_N15_D | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 172 | ITEM_FIELD_N15_E | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 173 | ITEM_FIELD_N15_F | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 174 | ITEM_FIELD_N15_G | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 175 | EXPORTER_ECCN | Character(16) | VARCHAR2(16) NOT NULL | Export Cntl Classification Nbr |
| 176 | EXPORT_LIC_NBR | Character(18) | VARCHAR2(18) NOT NULL | Export License Nbr |
| 177 | INCL_WIP_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include WIP Quantity
Y/N Table Edit |
| 178 | DECLARED_VALUE | Signed Number(17,0) | DECIMAL(16) NOT NULL | Custom's Declared Value |
| 179 | SF_WIP_MAX_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | WIP maximum QTY |
| 180 | SF_RPL_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Replenishment Mode
1=Backflush 2=Manual 3=Kanban Default Value: 1 |
| 181 | SF_RPL_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Repl Source
1=Inventory 2=Supplier 3=Feeder Default Value: 1 |
| 182 | SF_RPL_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Replenishment Method
1=Pull List 2=Pull Ticket 3=Workflow Default Value: 1 |
| 183 | SF_RPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rpl Type
1=One Time 2=Reusable Default Value: 1 |
| 184 | SF_DISPATCH_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Dispatch Mode
1=Deferred 2=Immediate Default Value: 1 |
| 185 | SF_RPL_STOR_AREA | Character(5) | VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table: STOR_AR_INSP_VW |
| 186 | SF_RPL_STOR_LEV1 | Character(4) | VARCHAR2(4) NOT NULL |
Level 1
Prompt Table: STOR_L1_INSP_VW |
| 187 | SF_RPL_STOR_LEV2 | Character(4) | VARCHAR2(4) NOT NULL |
Level 2
Prompt Table: STOR_L2_INSP_VW |
| 188 | SF_RPL_STOR_LEV3 | Character(4) | VARCHAR2(4) NOT NULL |
Level 3
Prompt Table: STOR_L3_INSP_VW |
| 189 | SF_RPL_STOR_LEV4 | Character(4) | VARCHAR2(4) NOT NULL |
Level 4
Prompt Table: STOR_L4_INSP_VW |
| 190 | SF_RPL_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Replenishment Vendor ID
Prompt Table: VENDOR_PO_VW |
| 191 | SF_RPL_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Replinshment Vendor
Prompt Table: VNDR_LOC_VW1 |
| 192 | SF_RPL_PRDN_AREA | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 193 | DP_PUBLISH_DATE | Date(10) | DATE | DP_PUBLISH_DATE |
| 194 | DP_POLICYSET | Character(10) | VARCHAR2(10) NOT NULL | DP_POLICYSET |
| 195 | DP_POLICYCONTROL | Character(20) | VARCHAR2(20) NOT NULL | DP_POLICYCONTROL |
| 196 | DP_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
| 197 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: IN_ITEM_PROD_VW |
| 198 | VMI_REPLEN_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Replenishment UOM
Prompt Table: IN_SHP_UOM_VW1 |
| 199 | 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 |
| 200 | REPL_INCL_DEMAND | Character(1) | VARCHAR2(1) NOT NULL |
Include Demand
Y/N Table Edit Default Value: N |
| 201 | REPL_DMD_DAYS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Offset Days Option
1=Replenish Lead Days 2=Offset Days |
| 202 | OFFSET_DAYS | Number(4,0) | SMALLINT NOT NULL | The number of days to +/- from the current value date when forecasting. |
| 203 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 204 | 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 |