UPG_DIST_LINE

(SQL Table)
Index Back

Upgrade Dist Line 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
    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

    Prompt Table: SP_BUPRCR_NONVW

    6 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    10 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
    11 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document

    Y/N Table Edit

    Default Value: N