VCHR_DIST_WRK1

(SQL Table)
 Index Back

EC Voucher Distrib Line

  • Parent record: VCHR_LINE_WRK1

    • # 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
    4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    5 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    7 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW

    9 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
    10 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.
    11 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
    12 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.
    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 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    17 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    18 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    19 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    20 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
    21 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    22 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    23 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    24 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
    25 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
    26 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
    27 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
    28 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    29 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    30 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    31 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    32 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
    33 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    34 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.
    35 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
    36 VAT_NONINV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amount
    37 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    38 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    39 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    40 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    41 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
    42 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPERUNT_BUGL_VW

    43 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODUCT_BUGL_VW

    44 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_BUGL_VW

    45 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASSCF_BUGL_VW

    46 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRAM_BUGL_VW

    47 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUD_REF_BUGL_VW

    48 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    49 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    50 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA02

    51 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CF1_BUGL_VW

    52 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CF2_BUGL_VW

    53 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CF3_BUGL_VW

    54 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    55 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key