REQ_LN_DIST_VW (SQL View)	Index Back
Requisition Distribution View Requisition Distribution View

REQ_LN_DIST_VW

(SQL View)

Requisition Distribution View

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , A.QTY_REQ , A.MERCHANDISE_AMT , A.LOCATION , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(cf16_an_sbr,A) , %subrec(pc_cf1_n_sbr,A) , A.BUSINESS_UNIT_GL , A.BUSINESS_UNIT_REQ , A.PROCESS_INSTANCE , A.PROCESS_MAN_CLOSE , A.BUDGET_LINE_STATUS , A.DISTRIB_LN_STATUS , B.DISTRIB_MTHD_FLG , A.DISTRIB_PCT , A.CURRENCY_CD_BASE , A.CURRENCY_CD , A.AMT_OPEN_BSE , A.MERCH_AMT_BSE , A.QTY_OPEN_STD , A.QTY_REQ_STD , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.ENTRY_EVENT , A.BUDGET_DT , A.KK_CLOSE_FLAG , A.BUSINESS_UNIT_AM , A.PROFILE_ID , A.FINANCIAL_ASSET_SW , A.EMPLID , A.CAP_NUM , A.CAP_SEQUENCE , A.TAG_NUMBER , A.COST_TYPE , %subrec(PUR_USR_DST_SBR, A) FROM PS_REQ_LN_DISTRIB A , PS_REQ_LINE_SHIP B 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

# 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
Default Value: NEXT

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 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

31 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: REQ_HDR.BUSINESS_UNIT
Prompt Table: SP_BUPRCR_NONVW

32 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

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

34 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
N=No
P=Processed
Y=Yes

35 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning

36 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

37 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

38 DISTRIB_PCT Number(8,4) DECIMAL(7,4) NOT NULL Distribution Percentage

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

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

41 AMT_OPEN_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Open Base

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

43 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM

44 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM

45 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

46 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

47 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

48 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

49 BUDGET_DT Date(10) DATE Budget Date

50 KK_CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control Close Flag

51 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

52 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

53 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize

54 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

55 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

56 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

57 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

58 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

59 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

60 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

61 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

62 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

63 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

64 CUSTOM_DATE_D Date(10) DATE Custom Date

65 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2

#	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 Default Value: NEXT
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	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
7	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
8	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
9	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
10	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
12	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
13	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
14	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
15	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
16	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
17	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
18	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
19	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
20	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
21	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
22	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
23	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
24	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
25	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
26	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
27	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
28	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
29	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
30	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
31	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: REQ_HDR.BUSINESS_UNIT Prompt Table: SP_BUPRCR_NONVW
32	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
33	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
34	PROCESS_MAN_CLOSE	Character(1)	VARCHAR2(1) NOT NULL	Process Manual Close N=No P=Processed Y=Yes
35	BUDGET_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	-> SL - 15-AUG-2002 MISC_CRITERIA label has been added <- B=Bypass E=Error N=Not Chk'd V=Valid W=Warning
36	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
37	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity
38	DISTRIB_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Distribution Percentage
39	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
40	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
41	AMT_OPEN_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Open Base
42	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
43	QTY_OPEN_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Open Standard UOM
44	QTY_REQ_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Requested Stand. UOM
45	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
46	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
47	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
48	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
49	BUDGET_DT	Date(10)	DATE	Budget Date
50	KK_CLOSE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Close Flag
51	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
52	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
53	FINANCIAL_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Capitalized Asset N=Non Cap Y=Capitalize
54	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
55	CAP_NUM	Character(15)	VARCHAR2(15) NOT NULL	Capital Acquisition Plan #
56	CAP_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	CAP Sequence
57	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
58	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
59	USER_DIST_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
60	CUSTOM_C100_D1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
61	CUSTOM_C100_D2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
62	CUSTOM_C100_D3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
63	CUSTOM_C100_D4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
64	CUSTOM_DATE_D	Date(10)	DATE	Custom Date
65	CUSTOM_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2