RFQ_REQ_DSTB_VW

(SQL View)
Index Back

RFQ Dist Info from REQ


SELECT A.BUSINESS_UNIT , A.RFQ_ID , A.LINE_NBR , A.REQ_ID , A.REQ_LINE_NBR , A.SCHED_NBR , C.QTY_REQ , C.MERCHANDISE_AMT , C.CURRENCY_CD , C.BUSINESS_UNIT_AM , C.PROFILE_ID , C.FINANCIAL_ASSET_SW , C.BUSINESS_UNIT_GL , C.ACCOUNT , C.ALTACCT , C.DEPTID , %subrec(CF16_AN_SBR,C) , C.PROJECT_ID , C.BUSINESS_UNIT_IN , C.STATISTICS_CODE , C.DISTRIB_LINE_NUM , C.COST_TYPE , C.BUDGET_DT , C.TAG_NUMBER , C.BUSINESS_UNIT_PC , C.ACTIVITY_ID , C.ANALYSIS_TYPE , C.RESOURCE_TYPE , C.RESOURCE_CATEGORY , C.RESOURCE_SUB_CAT , C.QTY_OPEN , C.QTY_OPEN_STD , C.AMT_OPEN , C.AMT_OPEN_BSE FROM PS_RFQ_REQ_XREF A , PS_REQ_LN_DISTRIB C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.REQ_ID = C.REQ_ID AND A.REQ_LINE_NBR = C.LINE_NBR AND A.SCHED_NBR = C.SCHED_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
5 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
8 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
11 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
12 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
13 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
14 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
15 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

17 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: PROJID_BUGL_VW

30 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
31 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
32 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
33 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
34 BUDGET_DT Date(10) DATE Budget Date
35 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
36 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
37 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
38 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
39 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
40 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
41 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
42 QTY_OPEN Number(16,4) DECIMAL(15,4) NOT NULL Open Quantity
43 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM
44 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount
45 AMT_OPEN_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Open Base