VCHR_LNERRC_VW

(SQL View)
 Index Back

Voucher Line


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.VOUCHER_LINE_NUM , B.TOTAL_DISTRIBS , B.BUSINESS_UNIT_PO , B.PO_ID , B.LINE_NBR , B.SCHED_NBR , B.DESCR , B.MERCHANDISE_AMT , B.ITM_SETID , B.INV_ITEM_ID , B.QTY_VCHR , B.UNIT_OF_MEASURE , B.UNIT_PRICE , B.ERROR_FLAG , B.TAX_CD_VAT , B.DISTRIB_MTHD_FLG , B.VCHR_AMT_FORCE_FLG , B.BUSINESS_UNIT_RECV , B.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , B.MATCH_LINE_OPT , B.TXN_CURRENCY_CD , B.CURRENCY_CD , B.VAT_TXN_TYPE_CD , B.SHIPTO_ID , B.SUT_BASE_ID , B.TAX_CD_SUT , B.VAT_APPLICABILITY , B.VAT_USE_ID , B.VAT_ENTITY , B.MATCH_LINE_STATUS FROM PS_VOUCHER A , PS_VOUCHER_LINE B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID

  • Parent record: VOUCHER

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

    Prompt Table: BUS_UNIT_TBL_FS

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: VOUCHER

    3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

    Default Value: 1

    4 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions
    5 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Prompt Table: SP_BUS_PM_NONVW

    6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: %EDITTABLE14

    7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Prompt Table: %EDITTABLE15

    8 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

    Prompt Table: %EDITTABLE16

    9 DESCR Character(30) VARCHAR2(30) 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
    12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDITTABLE13

    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 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag

    Y/N Table Edit

    Default Value: N

    17 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

    18 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
    A=Amount
    Q=Quantity

    Default Value: A

    19 VCHR_AMT_FORCE_FLG Character(1) VARCHAR2(1) NOT NULL Force Unit Price

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SP_BUS_PM_NONVW

    21 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

    Prompt Table: %EDITTABLE12

    22 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

    Prompt Table: %EDITTABLE8

    23 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

    Prompt Table: %EDITTABLE9

    24 MATCH_LINE_OPT Character(1) VARCHAR2(1) NOT NULL Match Line Option
    E=ERS
    F=Full Match
    N=Don't Match

    Default Value: N

    25 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    27 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

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

    Prompt Table: SHIPTO_TBL

    29 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination

    Prompt Table: SHIPTO_TBL

    30 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax

    Prompt Table: TAX_SALE_VW

    31 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
    32 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type

    Prompt Table: VAT_USE_TBL

    33 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
    34 MATCH_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Match Line Status
    E=Match Error
    M=Matched
    N=Not Matched