REQUESTOR_TBLVW

(SQL View)
Index Back

REQUESTOR_TBL component Search

This record is created to be used as the Update/Display Search Record for REQUESTOR_TBL component.

SELECT A.REQUESTOR_ID , B.OPRDEFNDESC , A.ACTIVE_FLG , A.REQ_STATUS , A.SHIPTO_SETID , A.SHIPTO_ID , A.LOCATION_SETID , A.LOCATION , A.ORIGIN_PO_SETID , A.ORIGIN , A.DEPTID_SETID , A.CATALOG_SETID , A.CATALOG_ID , A.PHONE , A.FAX , A.USE_ASSGN_CAT_ONLY , A.CURRENCY_CD , A.CONSOLIDATE_FLG , A.PRICE_CAN_CHANGE , A.DEFAULT_IN_BU , A.BUSINESS_UNIT_GL , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR, A) , A.PROJECT_ID , A.BUSINESS_UNIT_PC , A.ACTIVITY_ID , A.ANALYSIS_TYPE , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.CC_SECURITY_ID , A.CC_USE_FLAG , A.OVERRIDE_SUB_FLAG FROM PS_REQUESTOR_TBL A , PSOPRDEFN B WHERE A.REQUESTOR_ID = B.OPRID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
3 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active

Y/N Table Edit

Default Value: Y

4 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

Default Value: O

5 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

6 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIP_SHIPSET_VW

7 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

8 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOC_LOCSET_VW

9 ORIGIN_PO_SETID Character(5) VARCHAR2(5) NOT NULL PO Origin Setid

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

10 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Prompt Table: ORGN_ORGNSET_VW

11 DEPTID_SETID Character(5) VARCHAR2(5) NOT NULL Department SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

12 CATALOG_SETID Character(5) VARCHAR2(5) NOT NULL Catalog Setid

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

13 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID
14 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
15 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
16 USE_ASSGN_CAT_ONLY Character(1) VARCHAR2(1) NOT NULL Use Only Assigned Catalogs

Y/N Table Edit

Default Value: N

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

Prompt Table: CURRENCY_CD_TBL

18 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes

Y/N Table Edit

Default Value: N

19 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

20 DEFAULT_IN_BU Character(1) VARCHAR2(1) NOT NULL Defaults Inventory BU

Y/N Table Edit

Default Value: N

21 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPRCR_NONVW

22 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT
Set Control Field: BUSINESS_UNIT_GL

23 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT
Set Control Field: BUSINESS_UNIT_GL

24 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
25 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

26 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

27 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

28 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

29 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

30 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

31 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

32 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

33 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

34 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

35 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

36 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

37 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJID_BUGL_VW

38 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
39 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
40 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
41 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
42 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
43 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
44 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
45 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card

Y/N Table Edit

Default Value: N

46 OVERRIDE_SUB_FLAG Character(1) VARCHAR2(1) NOT NULL Override Auto Item Substitute
N=N
Y=Y