EM_VCHR_LNQV_VW

(SQL View)
 Index Back

EC Voucher Line


SELECT BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM , BUSINESS_UNIT_PO , PO_ID , LINE_NBR , SCHED_NBR , DESCR , DESCR254_MIXED , MERCHANDISE_AMT , ITM_SETID , INV_ITEM_ID , QTY_VCHR , UNIT_OF_MEASURE , UNIT_PRICE , TAX_CD_VAT , BUSINESS_UNIT_RECV , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , MATCH_LINE_OPT , TXN_CURRENCY_CD , SHIPTO_ID , VAT_TXN_TYPE_CD , VAT_USE_ID , BUSINESS_UNIT_GL , SUT_APPLICABILITY , VAT_APPLICABILITY , DSCNT_APPL_FLG , MAX_DISTRIB_LINE , TOTAL_DISTRIBS , VENDOR_ID , VNDR_LOC , TAX_DSCNT_FLG , TAX_FRGHT_FLG , TAX_MISC_FLG , TAX_VAT_FLG , VAT_RCRD_INPT_FLG , VAT_RCRD_OUTPT_FLG , VAT_TREATMENT , VAT_SVC_SUPPLY_FLG , VAT_SERVICE_TYPE , COUNTRY_LOC_BUYER , STATE_LOC_BUYER , COUNTRY_LOC_SELLER , STATE_LOC_SELLER FROM PS_VCHR_LINE_QV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

Default Value: 1

4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

Prompt Table: SP_BU_PM_NONVW

5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
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 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

Default Value: INV_ITEMS.SETID

12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

15 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
16 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.

Prompt Table: VAT_HEADER_VW

17 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

Prompt Table: SP_BU_PM_NONVW

18 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
19 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
20 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
21 MATCH_LINE_OPT Character(1) VARCHAR2(1) NOT NULL Match Line Option
E=ERS
F=Full Match
N=Don't Match
22 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Default Value: VCHR_HDR_QV.TXN_CURRENCY_CD

23 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

24 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

25 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type

Prompt Table: VAT_USE_TBL

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

Prompt Table: SP_BUPRCR_NONVW

27 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
28 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
29 DSCNT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Discount

Default Value: Y

30 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line
31 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions
32 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
33 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
34 TAX_DSCNT_FLG Character(1) VARCHAR2(1) NOT NULL Include Discount
35 TAX_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight
36 TAX_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Include Misc Charges
37 TAX_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Include VAT
N=No
Y=Yes
38 VAT_RCRD_INPT_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.
39 VAT_RCRD_OUTPT_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
40 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
41 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
42 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
43 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner
44 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner
45 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner
46 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner