AM_WC_PROCGRPVW (SQL View)	Index Back
WC Procurment Group PGI This view gets the Pre-Interface rows that are in PGI status and calculates the number of days it has been in the pre_am table.

AM_WC_PROCGRPVW

(SQL View)

WC Procurment Group PGI

This view gets the Pre-Interface rows that are in PGI status and calculates the number of days it has been in the pre_am table.

SELECT PRE_INTFC_ID , PRE_INTFC_LINE_NUM , BUSINESS_UNIT_AM , ASSET_ID , DESCR , LOAD_STATUS , PO_GROUP_ID , PO_GRP_SEQ_NUM , BUSINESS_UNIT_PO , PO_ID , BUSINESS_UNIT_RECV , RECEIVER_ID , BUSINESS_UNIT_AP , VOUCHER_ID , DTTM_STAMP , %DateDiff( %datepart(DTTM_STAMP), %currentdatein) FROM PS_INTFC_PRE_AM WHERE LOAD_STATUS = 'PGI' AND PO_GROUP_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRE_INTFC_ID Number(8,0) INTEGER NOT NULL Pre-Interface ID

2 PRE_INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Pre-Interface Line Number

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized

7 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

8 PO_GRP_SEQ_NUM Number(8,0) INTEGER NOT NULL Procurement Group Sequence

9 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

10 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

11 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

12 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

13 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

14 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

15 DTTM_STAMP 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.

16 DAYS_DIFF Signed Number(7,0) DECIMAL(6) NOT NULL Payment Days Difference

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRE_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Pre-Interface ID
2	PRE_INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Pre-Interface Line Number
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	LOAD_STATUS	Character(3)	VARCHAR2(3) NOT NULL	/* -> JMZ. PSOFT. 11-OCT-2002 / New Status were added : HLD and INP for Asset Management. / <- JMZ. PSOFT. 11-OCT-2002 */ CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized
7	PO_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	GroupID
8	PO_GRP_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Procurement Group Sequence
9	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
10	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
11	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
12	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
13	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
14	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
15	DTTM_STAMP	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.
16	DAYS_DIFF	Signed Number(7,0)	DECIMAL(6) NOT NULL	Payment Days Difference