PO_LN_DST_NP_VA

(SQL View)
 Index Back

PO Line Accounting Entries VIN


SELECT D.BUSINESS_UNIT , D.PO_ID , D.LINE_NBR , D.SCHED_NBR , D.DISTRIB_LINE_NUM , V.SETID , D.TAX_CD_VAT , D.VAT_TXN_TYPE_CD , V.VAT_DST_ACCT_TYPE , D.QTY_PO , D.CURRENCY_CD , D.MERCHANDISE_AMT , D.CURRENCY_CD_BASE , D.MERCH_AMT_BSE , D.LOCATION , V.ACCOUNT , V.ALTACCT , V.DEPTID , %subrec(CF16_AN_SBR,V) , V.PROJECT_ID , D.STATISTICS_CODE , D.STATISTIC_AMOUNT , D.CHARTFIELD_STATUS , D.BUSINESS_UNIT_GL , D.DISTRIB_LN_STATUS , D.DIST_PROCESSED_FLG , D.SYSTEM_SOURCE , D.BUSINESS_UNIT_REQ , D.BUSINESS_UNIT_PC , D.ACTIVITY_ID , D.ANALYSIS_TYPE , D.RESOURCE_TYPE , D.RESOURCE_CATEGORY , D.RESOURCE_SUB_CAT , D.PROCESS_INSTANCE , D.PROCESS_MAN_CLOSE , D.MONETARY_AMOUNT , D.MONETARY_AMT_BSE , D.BUDGET_DT , D.BUDGET_LINE_STATUS , D.KK_CLOSE_FLAG , D.KK_PROCESS_PRIOR FROM PS_PO_LINE_DISTRIB D , PS_VAT_ACCT_TBL V WHERE D.TAX_CD_VAT = V.TAX_CD AND D.VAT_TXN_TYPE_CD = V.VAT_TXN_TYPE_CD AND V.VAT_DST_ACCT_TYPE = 'VIN' AND V.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = D.BUSINESS_UNIT AND RECNAME = 'TAX_CD') AND D.TAX_CD_VAT = V.TAX_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PO_HDR.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 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

Default Value: 1

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
8 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

Prompt Table: VAT_TXN_CD

9 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
10 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
13 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
14 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

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

Prompt Table: %EDIT_ACCOUNT

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

Prompt Table: %EDIT_ALTACCT

18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: PROJID_BUGL_VW

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

Prompt Table: STAT_BUGL_VW

33 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.
34 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid

Default Value: V

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

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

Prompt Table: SP_BUPRCR_NONVW

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

Default Value: O

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

Y/N Table Edit

Default Value: N

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

Default Value: PPO

39 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
40 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
41 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
42 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
43 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
44 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
45 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
46 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
47 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
N=No
P=Processed
Y=Yes

Default Value: N

48 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.
49 MONETARY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount - VCHR BU Base
50 BUDGET_DT Date(10) DATE Budget Date
51 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
52 KK_CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control Close Flag

Default Value: N

53 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document

Default Value: Y