PYCYCL_EXP_PYMT

(SQL Table)
Index Back

Pymnt Methods for Pymnt Select

  • Parent record: PYCYCL_BNK
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

    Default Value: PYCYCL.PAY_CYCLE

    2 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_AP_NONVW

    4 PAY_DOC_ID Character(20) VARCHAR2(20) NOT NULL Advice ID

    Prompt Table: PYMNT_EXP_VW1

    5 PYCYCL_KEY_FIELD1 Character(20) VARCHAR2(20) NOT NULL Pay Cycle Mapping Key Field 1
    6 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence

    Prompt Table: PYMNT_EXP_VW3

    7 PYCYCL_KEY_FIELD2 Date(10) DATE Pay Cycle Mapping Key Field 2
    8 PYCYCL_KEY_FIELD3 Number(15,0) DECIMAL(15) NOT NULL Pay Cycle Mapping Key Field 3
    9 DISC_APPLY_FLG Character(1) VARCHAR2(1) NOT NULL Discount Apply Flag

    Y/N Table Edit

    10 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    11 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    12 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    13 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
    14 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag

    Y/N Table Edit

    Default Value: Y