PO_LN_DIST_APPR (SQL View)	Index Back
PO Distribution Appr PO Distribution Appr <* Date Init Issue Description 09/18/2008 PKL F-GL-91-KYEU-0021 Chartfield Security Enhancements *>

PO_LN_DIST_APPR

(SQL View)

PO Distribution Appr

PO Distribution Appr <* Date Init Issue Description 09/18/2008 PKL F-GL-91-KYEU-0021 Chartfield Security Enhancements *>

SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.DST_ACCT_TYPE , A.DISTRIB_LINE_NUM , A.QTY_PO , A.CURRENCY_CD , A.MERCHANDISE_AMT , A.CURRENCY_CD_BASE , A.MERCH_AMT_BSE , A.LOCATION , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CFS16_AN_SBR,A) , %subrec(PC_CF1_N_SBR,A) , A.STATISTICS_CODE , A.STATISTIC_AMOUNT , A.CHARTFIELD_STATUS , A.BUSINESS_UNIT_GL , A.DISTRIB_LN_STATUS , A.DIST_PROCESSED_FLG , A.SYSTEM_SOURCE , A.BUSINESS_UNIT_REQ , A.PROCESS_INSTANCE , A.PROCESS_MAN_CLOSE , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.REQ_DISTRIB_NBR , A.QTY_REQ , A.PO_POST_AMT , A.PO_POST_AMT_BSE , A.PC_DISTRIB_STATUS , A.PC_DISTRIB_AMT , A.PC_DISTRIB_AMT_BSE , A.PROFILE_ID , A.CAP_NUM , A.CAP_SEQUENCE , A.EMPLID , A.BUSINESS_UNIT_AM , A.BUSINESS_UNIT_IN , A.DISTRIB_TYPE , A.PO_POST_STATUS , A.CLOSE_AMOUNT , A.CLOSE_AMOUNT_BSE , A.INVOICE_CLOSE_IND , A.FINANCIAL_ASSET_SW , A.MONETARY_AMOUNT , A.MONETARY_AMT_BSE , A.BUDGET_DT , A.BUDGET_LINE_STATUS FROM PS_PO_LINE_DISTRIB A , PS_PO_LINE B , PS_PO_LINE_SHIP C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND B.CANCEL_STATUS <> 'X' AND B.CANCEL_STATUS <> 'C' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID AND A.LINE_NBR = C.LINE_NBR AND A.SCHED_NBR = C.SCHED_NBR AND C.CANCEL_STATUS <> 'X' AND C.CANCEL_STATUS <> 'C' AND A.DST_ACCT_TYPE = 'DST' AND A.DISTRIB_LN_STATUS <> 'X'

Parent record: PO_LINE_SHIP_FS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
Default Value: DST

6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

7 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity

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

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

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

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

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

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

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

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

16 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: %EDIT_OPER_UNIT

17 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: %EDIT_PRODUCT

18 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: %EDIT_FUND_CODE

19 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: %EDIT_CLASS_FLD

20 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: %EDIT_PROG_CODE

21 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: %EDIT_BUD_REF

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

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

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

25 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: %EDIT_CHARTFLD1

26 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: %EDIT_CHARTFLD2

27 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: %EDIT_CHARTFLD3

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

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

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

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

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

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

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

35 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

36 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.

37 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid
Default Value: V

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

39 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

40 DIST_PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Distribution Processed

41 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

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

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

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

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

46 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

47 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

48 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

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

50 PO_POST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Post Amount

51 PO_POST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Post Base Amount

52 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

53 PC_DISTRIB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL PC Distribution Amount

54 PC_DISTRIB_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL PC Distribution Base Amount

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

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

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

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

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

60 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

61 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

62 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None

63 CLOSE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Close Amount

64 CLOSE_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Close Base Amount

65 INVOICE_CLOSE_IND Character(1) VARCHAR2(1) NOT NULL Invoice Close Indicator

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

67 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.

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

69 BUDGET_DT Date(10) DATE Budget Date

70 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment Default Value: DST
6	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
7	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
11	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
12	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
13	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
14	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
16	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: %EDIT_OPER_UNIT
17	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: %EDIT_PRODUCT
18	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: %EDIT_FUND_CODE
19	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: %EDIT_CLASS_FLD
20	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: %EDIT_PROG_CODE
21	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: %EDIT_BUD_REF
22	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
23	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
24	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
25	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: %EDIT_CHARTFLD1
26	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: %EDIT_CHARTFLD2
27	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: %EDIT_CHARTFLD3
28	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
29	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
30	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
31	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
32	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
33	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
34	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
35	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
36	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
37	CHARTFIELD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Status R=Recycled V=Valid Default Value: V
38	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
39	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
40	DIST_PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribution Processed
41	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
42	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
43	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
44	PROCESS_MAN_CLOSE	Character(1)	VARCHAR2(1) NOT NULL	Process Manual Close N=No P=Processed Y=Yes
45	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
46	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
47	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
48	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
49	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
50	PO_POST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Post Amount
51	PO_POST_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Post Base Amount
52	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
53	PC_DISTRIB_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	PC Distribution Amount
54	PC_DISTRIB_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	PC Distribution Base Amount
55	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
56	CAP_NUM	Character(15)	VARCHAR2(15) NOT NULL	Capital Acquisition Plan #
57	CAP_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	CAP Sequence
58	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
59	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
60	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
61	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
62	PO_POST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Post Status D=Distributed N=None
63	CLOSE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Close Amount
64	CLOSE_AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Close Base Amount
65	INVOICE_CLOSE_IND	Character(1)	VARCHAR2(1) NOT NULL	Invoice Close Indicator
66	FINANCIAL_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Capitalized Asset N=Non Cap Y=Capitalize
67	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.
68	MONETARY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount - VCHR BU Base
69	BUDGET_DT	Date(10)	DATE	Budget Date
70	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