PO_LINE_DIST_PS

(SQL View)
 Index Back

PO Line Dist PS View


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(CF16_AN_SBR,A) ,A.PROJECT_ID ,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.BUSINESS_UNIT_PC ,A.ACTIVITY_ID ,A.ANALYSIS_TYPE ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.PROCESS_INSTANCE ,A.PROCESS_MAN_CLOSE ,A.REQ_ID ,A.REQ_LINE_NBR ,A.REQ_SCHED_NBR ,A.REQ_DISTRIB_NBR ,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.PO_POST_STATUS ,A.CLOSE_AMOUNT ,A.CLOSE_AMOUNT_BSE ,A.QTY_REQ ,A.DISTRIB_TYPE ,A.INVOICE_CLOSE_IND ,' ' FROM PS_PO_LINE_DISTRIB A

# 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: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: PROJID_BUGL_VW

29 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
30 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.
31 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid

Default Value: V

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

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

33 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

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

Y/N Table Edit

Default Value: N

35 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.
36 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
37 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
38 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
39 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
40 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
41 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
42 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
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 PO_POST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Post Amount
50 PO_POST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Post Base Amount
51 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

Default Value: N

52 PC_DISTRIB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL PC Distribution Amount
53 PC_DISTRIB_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL PC Distribution Base Amount
54 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
58 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
59 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
60 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None

Default Value: N

61 CLOSE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Close Amount
62 CLOSE_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Close Base Amount
63 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
64 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
65 INVOICE_CLOSE_IND Character(1) VARCHAR2(1) NOT NULL Invoice Close Indicator
66 LEDGER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Ledger Category