IN_C_IT_SUB_EVW (SQL View)	Index Back
CRM Item Substitute Publish This view is Used by the Batch Publish section of the AE Program IN_ITMLOAD to publish the Item Changes/Adds to other Nodes. This view is a dummy view to satisfy the needs of the batch publish so it does not actually return any data. If Item substitutes are added to the item sync message this view should be changed to use the item sync substitutes segment.

IN_C_IT_SUB_EVW

(SQL View)

CRM Item Substitute Publish

This view is Used by the Batch Publish section of the AE Program IN_ITMLOAD to publish the Item Changes/Adds to other Nodes. This view is a dummy view to satisfy the needs of the batch publish so it does not actually return any data. If Item substitutes are added to the item sync message this view should be changed to use the item sync substitutes segment.

SELECT A.SETID , A.INV_ITEM_ID , A.SUB_ITM_ID , %subrec(IN_C_ITMSUB_ESR, A) , ' ' , ' ' , 0 FROM PS_SUBSTITUTE_ITM A WHERE A.SETID = 'DUMMY' AND A.SETID < 'DUMMY'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MST_ITM_PRPT_VW

3 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
Prompt Table: MST_ITM_VW3

4 SUB_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr.

5 EFFDT_FROM Date(10) DATE Effective Date From
Default Value: %DATE

6 EFFDT_TO Date(10) DATE NOT NULL Effective Date To

7 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
Default Value: 1

8 USE_FOR_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Use for Shipments
Y/N Table Edit
Default Value: N

9 USE_FOR_PROCURE Character(1) VARCHAR2(1) NOT NULL Use for Procurement
Y/N Table Edit
Default Value: N

10 USE_FOR_MANUFACTUR Character(1) VARCHAR2(1) NOT NULL Use for Manufacturing
Y/N Table Edit
Default Value: N

11 USE_PROCUREMENT Character(1) VARCHAR2(1) NOT NULL Use for Procurement
A=Automatic Substitution
B=Manual and Automatic
M=Manual Substitution
N=Do Not Use
Default Value: N

12 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

13 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MST_ITM_PRPT_VW
3	SUB_ITM_ID	Character(18)	VARCHAR2(18) NOT NULL	11/30/99 RML Added label "Substitute" Prompt Table: MST_ITM_VW3
4	SUB_PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr.
5	EFFDT_FROM	Date(10)	DATE	Effective Date From Default Value: %DATE
6	EFFDT_TO	Date(10)	DATE NOT NULL	Effective Date To
7	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate Default Value: 1
8	USE_FOR_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use for Shipments Y/N Table Edit Default Value: N
9	USE_FOR_PROCURE	Character(1)	VARCHAR2(1) NOT NULL	Use for Procurement Y/N Table Edit Default Value: N
10	USE_FOR_MANUFACTUR	Character(1)	VARCHAR2(1) NOT NULL	Use for Manufacturing Y/N Table Edit Default Value: N
11	USE_PROCUREMENT	Character(1)	VARCHAR2(1) NOT NULL	Use for Procurement A=Automatic Substitution B=Manual and Automatic M=Manual Substitution N=Do Not Use Default Value: N
12	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
13	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance