VCHR_TP_PO_L_VW(SQL View) |
Index Back |
|---|---|
Voucher PO Line |
| SELECT a.business_unit , a.po_id , b.line_nbr , c.sched_nbr , b.itm_setid , b.inv_item_id , %Substring(b.descr254_mixed, 1, 30) , b.unit_of_measure , c.price_po , c.merchandise_amt - d.amt_matched , c.qty_po - d.qty_matched , c.qty_po - d.qty_matched , b.unit_of_measure , c.price_po , c.unit_prc_tol , c.pct_unit_prc_tol , c.ext_prc_tol , c.pct_ext_prc_tol , c.match_line_opt , b.wthd_cd , b.wthd_sw , c.distrib_mthd_flg , a.currency_cd , c.shipto_id , c.sut_base_id , c.tax_cd_sut , c.sut_excptn_type , c.sut_excptn_certif , c.sut_applicability , c.vat_applicability , c.tax_cd_vat , c.vat_txn_type_cd , c.vat_use_id , c.freight_terms FROM ps_po_hdr_fs a , ps_po_line_fs b , PS_PO_LINE_SHIP_FS c , ps_po_ln_ship_mtch d WHERE a.business_unit = b.business_unit AND a.po_id = b.po_id AND b.business_unit = c.business_unit AND b.po_id = c.po_id AND b.line_nbr = c.line_nbr AND a.in_process_flg = 'N' 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.match_action = 'N'))) AND (a.ers_action = 'N' OR a.ers_action = ' ') AND c.cancel_status <> 'X' AND b.cancel_status <> 'X' 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 |
| # | 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 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 9 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 10 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 11 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 12 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 13 | UOM_PO | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure PO |
| 14 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 15 | UNIT_PRC_TOL | Number(14,5) | DECIMAL(13,5) NOT NULL | Unit Price Tolerance |
| 16 | PCT_UNIT_PRC_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | % Unit Price Tolerance |
| 17 | EXT_PRC_TOL | Number(14,5) | DECIMAL(13,5) NOT NULL | Ext Price Tolerance |
| 18 | PCT_EXT_PRC_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | % Ext Price Tolerance |
| 19 | MATCH_LINE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS F=Full Match N=Don't Match |
| 20 | WTHD_CD | Character(5) | VARCHAR2(5) NOT NULL | Withholding Code |
| 21 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 |
| 22 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
| 23 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 24 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 25 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL | Sales/Use Tax Destination |
| 26 | TAX_CD_SUT | Character(8) | VARCHAR2(8) NOT NULL | Tax Code - Sales and Use Tax |
| 27 | SUT_EXCPTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Exception Type
D=Direct Pay E=Exempt/Exonerated N=None |
| 28 | SUT_EXCPTN_CERTIF | Character(20) | VARCHAR2(20) NOT NULL | Sales/Use Tax Exception Certif |
| 29 | SUT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Applicability
D=Direct Pay E=Item is Exempt S=Sales Tax Applicable U=Use Tax Applicable X=Purchaser Is Exonerated |
| 30 | 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 |
| 31 | 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. |
| 32 | 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. |
| 33 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
| 34 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |