VCHR_CORR_WS2

(SQL Table)
Index Back

Voucher Distribution Table

  • Parent record: VOUCHER_LINE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
    2 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
    3 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
    A=Automatically calculated
    M=Manual Entry
    4 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
    5 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
    A=Automatically calculated
    M=Manual Entry
    6 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
    7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    10 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
    11 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.
    12 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
    13 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
    C=Closed Item
    N=Not an Open Item Account
    O=Open Item
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    16 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.
    17 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
    18 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.
    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
    32 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    33 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    34 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    35 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
    36 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
    37 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
    38 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
    39 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
    40 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.
    41 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    42 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW

    43 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    44 CUR_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Inter Unit Exchange Rate
    45 CUR_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Interunit excahnge divisor
    46 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    47 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    48 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    49 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    50 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
    51 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    52 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    53 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    54 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    55 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
    56 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document
    57 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
    58 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    59 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
    60 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
    61 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    62 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    63 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    64 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    65 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    66 CUSTOM_DATE_D Date(10) DATE Custom Date
    67 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    68 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
    69 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    70 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    71 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    72 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
    73 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

    Prompt Table: SP_BU_WM_NONVW

    74 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

    Prompt Table: %EDIT_WO_ID

    75 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

    Prompt Table: %EDIT_WO_TASK

    76 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
    1=Labor
    2=Tools
    3=Material
    77 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

    Prompt Table: %EDIT_RES_LINE