ORD_BU_ITEMS_VW

(SQL View)
 Index Back

Operating Inventory Update Vw


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.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.INCL_WIP_QTY_FLG , 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_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 ITM_STATUS_EFFDT Date(10) DATE Item Status 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
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)

Default Value: REPL_SETUP_INV.REPL_CALC_PERIOD

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

Default Value: REPL_SETUP_INV.STOCKOUT_RATE

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
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
46 COST_GROUP_CD Character(6) VARCHAR2(6) NOT NULL Standard Cost Group
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.

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

89 STD_PACK_UOM Character(3) VARCHAR2(3) NOT NULL Standard Pack Unit of Measure
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
92 COUNTRY_IST_ORIGIN Character(3) VARCHAR2(3) NOT NULL Intrastat Country of Origin
93 IST_REGION_ORIGIN Character(4) VARCHAR2(4) NOT NULL Intrastat Region of Origin
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
97 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type
98 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
99 ISOLATE_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL 11/10/1999 whs - added

Default Value: N

100 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes
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

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

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

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

Default Value: N

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

Default Value: N

114 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
115 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
116 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
117 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
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

Default Value: N

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

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
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
185 SF_RPL_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL Level 1
186 SF_RPL_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL Level 2
187 SF_RPL_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL Level 3
188 SF_RPL_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL Level 4
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
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

Default Value: 99

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