SMT_SPLIT_DTL

(SQL Table)
Index Back

Split Conditions Detail

  • Parent record: SMT_SPLIT_CNTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SMT_SPLIT_ID Character(5) VARCHAR2(5) NOT NULL Payment Split ID
    3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 ROW_NUMBER Number(3,0) SMALLINT NOT NULL Row_Number
    7 SMT_SPLIT_PERCENT Number(12,8) DECIMAL(11,8) NOT NULL Reschedule Percentage
    8 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer
    9 SMT_TERMS_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SMTTM_NONVW

    10 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Prompt Table: SMT_PYMT_TRM_VW

    11 SMT_SIGHT_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SMTST_NONVW

    12 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code

    Prompt Table: SMT_SIGHTCD_VW

    13 REUSABLE_FLAG Character(1) VARCHAR2(1) NOT NULL Reusable Item Flag

    Y/N Table Edit

    Default Value: N

    14 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Prompt Table: SP_SETBNK_NONVW

    15 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_VW8

    16 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

    Prompt Table: BANK_ACCT_VW11