PO_VCHR_DSTWK

(SQL Table)
Index Back

Voucher Distribution Table

  • Parent record: VOUCHER_LINE
  • # 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 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

    Default Value: 1

    5 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    6 VCHR_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line Number
    7 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    9 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    11 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    12 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
    13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    15 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered