BU_ITEMS_UPD_VW

(SQL View)
 Index Back

BU ITEMS INV View


SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.ITM_STATUS_EFFDT , A.ITM_STATUS_CURRENT , A.ITM_STAT_DT_FUTURE , A.ITM_STATUS_FUTURE , A.LAST_ADJUSTMENT , A.LAST_ORDER , A.LAST_ORDER_DATE , A.LAST_PUTAWAY_DATE , A.QTY_AVAILABLE , A.QTY_RESERVED , A.QTY_OWNED , A.QTY_ONHAND , A.LAST_DEMAND_CALC , A.LAST_MO_DEMAND , A.LAST_QTR_DEMAND , A.LAST_2QTR_DEMAND , A.LAST_ANNUAL_DEMAND , A.LAST_UD_DEMAND , A.LAST_DEMAND_DATE , A.REPLENISH_CLASS , A.REPL_CALC_PERIOD , A.REPLENISH_LEAD , A.HISTORICAL_LEAD , A.PROJECTED_LEAD , A.SAFETY_STOCK , A.STOCKOUT_RATE , A.REORDER_POINT , A.REORDER_QTY , A.QTY_IUT_PAR , A.EOQ , A.AOQ , A.FOQ , A.QTY_MAXIMUM , A.DAYS_SUPPLY , A.ORDER_MULTIPLE , A.SAFETY_LEAD_TIME , A.TARGET_LEVEL , A.EXCESS_BU , A.LAST_ISS_EXCESS , A.USE_UP_QOH , A.INSPECT_TIME , A.DOCK_TO_STOCK , A.COST_ELEMENT , A.COST_GROUP_CD , A.LAST_CYCLE_COUNT , A.LAST_PIT_COUNT , A.LAST_UTIL_REVIEW , A.NEXT_UTIL_REVIEW , A.RELATED_ITEM_ID , A.ROPC_INSTANCE , A.ROPC_STATUS , A.SSTC_INSTANCE , A.SSTC_STATUS , A.EOQC_INSTANCE , A.EOQC_STATUS , A.HLDC_INSTANCE , A.HLDC_STATUS , A.ANNDM_INSTANCE , A.ANNDM_STATUS , A.CYCLE_INSTANCE , A.NO_REPLENISH_FLG , A.INCL_WIP_QTY_FLG , A.SOURCE_CODE , A.PHANTOM_ITEM_FLAG , A.BOM_USAGE , A.DT_TIMESTAMP , A.LAST_PRICE_PAID , A.AVERAGE_COST , A.AVERAGE_COST_MAT , A.CURRENT_COST , A.DFLT_ACTUAL_COST , A.EXCESS_INVENTORY , A.REVISION_CONTROL , A.EN_AUTO_REV , A.ISSUE_METHOD , A.STAGED_DATE_FLAG , A.ISSUE_MULTIPLE , A.REPLENISH_POINT , A.WIP_MIN_QTY , A.IP_PLANNING_FLG , A.PLANNER_CD , A.YIELD_CALC_FLG , A.PRDN_AREA_CODE , A.TRANSIT_COST_TYP , A.UOM_CONV_FLAG , A.MASTER_RTG_OPT , A.REF_ROUTING_ITEM , A.STD_PACK_UOM , A.FORECAST_ITEM_FLAG , A.FORECASTER , A.COUNTRY_IST_ORIGIN , A.IST_REGION_ORIGIN , A.TRANSFER_MIN_ORDER , A.TRANSFER_YIELD , A.NON_OWN_FLAG , A.INV_STOCK_TYPE , A.SHIP_TYPE_ID , A.ISOLATE_ITEM_FLG , A.INVENTORY_ITEM , A.MG_PRDN_OPTION , A.MG_VALID_PRDN_OPT , A.MG_ASSOCIATED_BOM , A.SHELF_LIFE , A.AVAIL_LEAD_TIME , A.RETEST_LEAD_TIME , A.MATERIAL_RECON_FLG , A.USG_TRCKNG_METHOD , A.CHARGE_MARKUP_PCNT , A.CHARGE_MARKUP_AMT , A.CHARGE_CODE , A.MFG_COSTED_FLAG , A.CONSIGNED_FLAG , A.VENDOR_ID , A.VNDR_LOC , A.BOM_CODE , A.RTG_CODE , A.MFG_LEADTIME_F , A.MFG_LEADTIME_V , A.MFG_LTRATEF , A.MFG_LTRATEV , A.OVERSIZED , A.ADD_HANDLING , %subrec(MASTER_ITEM_SBR, A) , A.EXPORTER_ECCN , A.EXPORT_LIC_NBR , A.DECLARED_VALUE , A.SF_WIP_MAX_QTY , A.SF_RPL_MODE , A.SF_RPL_SOURCE , A.SF_RPL_METHOD , A.SF_RPL_TYPE , A.SF_DISPATCH_MODE , A.SF_RPL_STOR_AREA , A.SF_RPL_STOR_LEV1 , A.SF_RPL_STOR_LEV2 , A.SF_RPL_STOR_LEV3 , A.SF_RPL_STOR_LEV4 , A.SF_RPL_VENDOR_ID , A.SF_RPL_VNDR_LOC , A.SF_RPL_PRDN_AREA , A.DP_PUBLISH_DATE , A.DP_POLICYSET , A.DP_POLICYCONTROL , A.DP_PUBLISHNAME , A.PRODUCT_ID , A.VMI_REPLEN_UOM , A.REORD_QTY_OPTION , A.REPL_INCL_DEMAND , A.REPL_DMD_DAYS_OPT , A.OFFSET_DAYS , A.LOT_BACKFLUSH_OPT FROM PS_BU_ITEMS_INV A

# 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 INCL_WIP_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Include WIP Quantity
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: UNITS_SPCK_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

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

Default Value: N

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

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 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: 1

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: STOR_AR_INSP_VW

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

Prompt Table: STOR_L1_INSP_VW

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

Prompt Table: STOR_L2_INSP_VW

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

Prompt Table: STOR_L3_INSP_VW

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

Prompt Table: STOR_L4_INSP_VW

189 SF_RPL_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Replenishment Vendor ID
190 SF_RPL_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Replinshment Vendor
191 SF_RPL_PRDN_AREA Character(10) VARCHAR2(10) NOT NULL Production Area
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
197 VMI_REPLEN_UOM Character(3) VARCHAR2(3) NOT NULL Replenishment UOM

Prompt Table: IN_SHP_UOM_VW1

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