VCHE_PO_D_NM_VW

(SQL View)
Index Back

Voucher PO Distrib Line


SELECT a.business_unit , a.po_id , c.line_nbr , d.sched_nbr , d.distrib_line_num , d.distrib_line_num , d.account , d.altacct , D.DEPTID , d.business_unit_gl , b.descr254_mixed , d.statistics_code , d.statistic_amount , d.merchandise_amt , d.qty_po , d.qty_po , d.business_unit_pc , d.activity_id , d.analysis_type , d.resource_type , d.resource_category , d.resource_sub_cat , d.business_unit_am , d.profile_id , ' ' , a.currency_cd , %subrec(CF12_AN_SBR, d) , d.project_id , d.saletx_amt , d.usetax_amt , d.rt_type , d.currency_cd_base , d.vat_txn_type_cd , d.vat_aport_cntrl , d.cost_type , d.vat_applicability , d.tax_cd_vat , d.tax_cd_vat_pct , d.vat_recovery_pct , d.vat_rebate_pct , d.vat_calc_type , d.vat_nrcvr_pro_flg , d.vat_rcvry_pct_src , d.vat_rebate_pct_src , %subrec(pur_usr_dst_sbr, d) , d.budget_dt , d.roll_stat_r , d.business_unit_in , d.peg_status , d.vat_use_id , d.distrib_ln_status , d.distrib_pct FROM ps_po_hdr_fs a , ps_po_line_fs b , PS_PO_LINE_SHIP_FS c , ps_po_line_dist_fs d WHERE a.business_unit = b.business_unit AND a.po_id = b.po_id AND ((a.po_status IN ('D','X','PX')) OR ((a.chng_ord_batch > 0) AND (a.po_status IN ('A','PA','O'))) OR (a.po_status = 'C')) AND (a.ers_action = 'N' OR a.ers_action = ' ') AND b.business_unit = c.business_unit AND b.po_id = c.po_id AND b.line_nbr = c.line_nbr AND c.business_unit = d.business_unit AND c.po_id = d.po_id AND c.line_nbr = d.line_nbr AND c.sched_nbr = d.sched_nbr AND d.dst_acct_type = 'DST' AND b.cancel_status <> 'X' AND c.cancel_status <> 'X' AND d.distrib_ln_status <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO 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
6 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
8 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
13 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.
14 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
15 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
16 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
17 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
18 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
19 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
20 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
21 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
22 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
23 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
24 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
25 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
26 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
27 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
28 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
29 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
30 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
31 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
32 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
33 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
34 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
35 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
36 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
37 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
38 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
39 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
40 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
41 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
42 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
44 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.
45 VAT_APORT_CNTRL Character(1) VARCHAR2(1) NOT NULL VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit
46 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
47 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
48 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.
49 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
50 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
51 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
52 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
53 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
54 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
55 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
56 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
57 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
58 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
59 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
60 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
61 CUSTOM_DATE_D Date(10) DATE Custom Date
62 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2
63 BUDGET_DT Date(10) DATE Budget Date
64 ROLL_STAT_R Character(1) VARCHAR2(1) NOT NULL Rolled
65 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
66 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
67 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
68 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
69 DISTRIB_PCT Number(8,4) DECIMAL(7,4) NOT NULL Distribution Percentage