BU_AP_REF

(SQL Table)
Index Back

AP Business Unit Definition

  • Related Language Record: BU_AP_REF_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor Set ID

    Prompt Table: SF_AP_VNDR_OPTN

    7 AP_VOUCHER_SEQ_BY Character(1) VARCHAR2(1) NOT NULL Voucher Sequencing By
    A=Automatic Sequencing
    R=Use SF Refund# as Voucher#

    Default Value: A

    8 AP_PREFIX_SF Character(2) VARCHAR2(2) NOT NULL Ap Prefix
    9 VCHR_NUM_LAST_USED Number(8,0) INTEGER NOT NULL Last Voucher Number
    10 SF_AP_ORIGIN Character(3) VARCHAR2(3) NOT NULL Voucher Origin
    11 SF_AP_OPRID Character(8) VARCHAR2(8) NOT NULL AP User ID
    12 GRP_AP_NUM_OPT Character(1) VARCHAR2(1) NOT NULL Control Group Numbering

    Y/N Table Edit

    Default Value: N

    13 GRP_AP_ID_LASTUSED Number(10,0) DECIMAL(10) NOT NULL Group ID Last Used
    14 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

    Prompt Table: SP_BU_GL_NONVW

    15 POST_OPTION Character(1) VARCHAR2(1) NOT NULL Posting Option

    Y/N Table Edit

    Default Value: Y

    16 POST_THRU_DT Date(10) DATE Post Thru Date
    17 DB_NUMBER Number(9,0) DECIMAL(9) NOT NULL D+B Number
    18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL