REQ_RC_WB_AL_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , D.REQ_STATUS , D.REQ_NAME , D.BUDGET_HDR_STATUS , D.ACTIVITY_DATE , B.DUE_DT , D.REQ_DT , C.VENDOR_ID , C.VENDOR_SETID , C.ITM_SETID , C.INV_ITEM_ID , A.QTY_REQ , C.SOURCE_STATUS , A.CURRENCY_CD , A.MERCHANDISE_AMT , A.CURRENCY_CD_BASE , A.MERCH_AMT_BSE , A.LOCATION , A.ACCOUNT , A.ALTACCT , A.DEPTID , A.BUSINESS_UNIT_GL , A.DISTRIB_LN_STATUS , A.MONETARY_AMOUNT , A.MONETARY_AMT_BSE , A.KK_CLOSE_FLAG , A.BUDGET_DT , D.REQUESTOR_ID , %subrec(CF16_AN_SBR, A) , %subrec(PC_CF1_N_SBR, A) , D.CC_SECURITY_ID , D.CC_USE_FLAG FROM PS_REQ_LN_DISTRIB A ,PS_REQ_LINE_SHIP B , PS_REQ_LINE C , PS_REQ_HDR D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.LINE_NBR = B.LINE_NBR AND A.SCHED_NBR = B.SCHED_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.REQ_ID = C.REQ_ID AND B.LINE_NBR = C.LINE_NBR AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.REQ_ID = D.REQ_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Default Value: 1

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
Default Value: 1

5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
Default Value: 1

6 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled

7 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name

8 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

9 ACTIVITY_DATE Date(10) DATE Last Activity

10 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

11 REQ_DT Date(10) DATE Requisition Date

12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

14 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

16 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity

17 SOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL AutoSource Status
A=Available
C=Sourcing Complete
E=Non-Price Error
I=Sourcing In Process
N=Non-Price Error
P=Pricing Error

18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

19 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

20 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

21 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

22 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_TBL

23 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: %EDIT_ACCOUNT
Set Control Field: BUSINESS_UNIT_GL

24 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
Prompt Table: %EDIT_ALTACCT
Set Control Field: BUSINESS_UNIT_GL

25 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPTID_BUGL_VW

26 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL
Prompt Table: SP_BUPRCR_NONVW

27 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled
Default Value: O

28 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

29 MONETARY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount - VCHR BU Base

30 KK_CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control Close Flag
Y/N Table Edit
Default Value: N

31 BUDGET_DT Date(10) DATE Budget Date

32 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

33 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

34 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

35 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

36 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

37 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

38 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

39 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

40 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

41 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

42 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

43 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

44 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

45 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

46 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

47 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

48 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

49 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

50 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

51 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

52 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number

53 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number Default Value: 1
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
6	REQ_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Req status A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled
7	REQ_NAME	Character(30)	VARCHAR2(30) NOT NULL	Requisition Name
8	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
9	ACTIVITY_DATE	Date(10)	DATE	Last Activity
10	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
11	REQ_DT	Date(10)	DATE	Requisition Date
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
13	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
14	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
15	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
16	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
17	SOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AutoSource Status A=Available C=Sourcing Complete E=Non-Price Error I=Sourcing In Process N=Non-Price Error P=Pricing Error
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
20	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
21	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
22	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
23	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: %EDIT_ACCOUNT Set Control Field: BUSINESS_UNIT_GL
24	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: %EDIT_ALTACCT Set Control Field: BUSINESS_UNIT_GL
25	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
26	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL Prompt Table: SP_BUPRCR_NONVW
27	DISTRIB_LN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Line Status C=Closed M=Mass Liquidated O=Open P=Unavailable for Sourcing X=Canceled Default Value: O
28	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
29	MONETARY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount - VCHR BU Base
30	KK_CLOSE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Close Flag Y/N Table Edit Default Value: N
31	BUDGET_DT	Date(10)	DATE	Budget Date
32	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
33	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
34	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
35	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
36	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
37	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
38	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
39	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
40	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
41	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
42	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
43	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
44	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
45	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
46	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
47	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
48	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
49	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
50	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
51	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
52	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Procurement Card Number
53	CC_USE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Procurement Card Y/N Table Edit Default Value: N