MASTER_ITEM_CVW

(SQL View)
 Index Back

Item Master Header

Item Master Header

SELECT A.SETID , A.INV_ITEM_ID , A.ITM_STATUS_EFFDT , A.ITM_STATUS_CURRENT , A.ITM_STAT_DT_FUTURE , A.ITM_STATUS_FUTURE , A.DESCR60 , A.UNIT_MEASURE_STD , A.INV_ITEM_GROUP , A.INV_PROD_FAM_CD , A.DATE_ADDED , A.ORIG_OPRID , A.APPROVAL_OPRID , A.APPROVAL_DATE , A.LAST_MAINT_OPRID , A.LAST_DTTM_UPDATE , A.CHANGE_FIELD , A.INVENTORY_ITEM , A.LOT_CONTROL , A.SERIAL_CONTROL , A.SHIP_SERIAL_CNTRL , A.NON_OWN_FLAG , A.STAGED_DATE_FLAG , A.CM_GROUP , A.MATERIAL_RECON_FLG , A.USG_TRCKNG_METHOD , A.CONSIGNED_FLAG , A.PL_PRIO_FAMILY , A.ITEM_FIELD_C30_A , A.ITEM_FIELD_C30_B , A.ITEM_FIELD_C30_C , A.ITEM_FIELD_C30_D , A.ITEM_FIELD_C1_A , A.ITEM_FIELD_C1_B , A.ITEM_FIELD_C1_C , A.ITEM_FIELD_C1_D , A.ITEM_FIELD_C10_A , A.ITEM_FIELD_C10_B , A.ITEM_FIELD_C10_C , A.ITEM_FIELD_C10_D , A.ITEM_FIELD_C2 , A.ITEM_FIELD_C4 , A.ITEM_FIELD_C6 , A.ITEM_FIELD_C8 , A.ITEM_FIELD_N12_A , A.ITEM_FIELD_N12_B , A.ITEM_FIELD_N12_C , A.ITEM_FIELD_N12_D , A.ITEM_FIELD_N15_A , A.ITEM_FIELD_N15_B , A.ITEM_FIELD_N15_C , A.ITEM_FIELD_N15_D , ' ' , A.PROMISE_OPTION , A.DEVICE_TRACKING , A.SERIAL_IN_PRDN , A.TRACE_USAGE , A.TRACE_CHANGE , A.PHYSICAL_NATURE , ' ' , ' ' FROM PS_MASTER_ITEM_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

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 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
8 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
9 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
10 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
11 DATE_ADDED Date(10) DATE Date Added
12 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
13 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
14 APPROVAL_DATE Date(10) DATE Approval Date
15 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
16 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17 CHANGE_FIELD Character(18) VARCHAR2(18) NOT NULL Change Reason
18 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes
19 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
20 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
21 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
22 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
23 STAGED_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL Staged Date Control
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON
24 CM_GROUP Character(15) VARCHAR2(15) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
25 MATERIAL_RECON_FLG Character(1) VARCHAR2(1) NOT NULL Material Reconciliation Flag
26 USG_TRCKNG_METHOD Character(2) VARCHAR2(2) NOT NULL Usage Tracking Method
01=None
02=Billing
03=Costing
27 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
28 PL_PRIO_FAMILY Character(10) VARCHAR2(10) NOT NULL Demand Priority Family
29 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
30 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
31 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
32 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
33 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
34 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
35 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
36 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
37 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
38 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
39 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
40 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
41 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
42 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
43 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
44 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
45 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
46 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
47 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
48 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
49 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
50 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
51 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
52 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
53 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
54 PROMISE_OPTION Character(1) VARCHAR2(1) NOT NULL Order Promise Option
2=Perform ATP Reservations
55 DEVICE_TRACKING Character(1) VARCHAR2(1) NOT NULL Device Tracking Indicator

Y/N Table Edit

Default Value: N

56 SERIAL_IN_PRDN Character(1) VARCHAR2(1) NOT NULL Serial in Production

Y/N Table Edit

Default Value: N

57 TRACE_USAGE Character(1) VARCHAR2(1) NOT NULL Trace Usage
0=None
1=Serial Trace
2=Lot Trace

Default Value: 0

58 TRACE_CHANGE Character(1) VARCHAR2(1) NOT NULL Trace Changes

Default Value: 0

59 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

Default Value: G

60 TEMPLATE_LIST_ID Character(20) VARCHAR2(20) NOT NULL Item Template List ID
61 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

Prompt Table: CM_ELEMENT