SSF_RUN_CLI_NLD

(SQL Table)
 Index Back

Run control record clieop NLD

Run control record for clieop receivables NLD

  • Parent Record Of SSF_RUN_CLS_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    4 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: SSF_ACCT_BU_NLD

    5 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
    6 PROCESS_DATE Date(10) DATE NOT NULL Process Date

    Default Value: %date

    7 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Group Type

    Prompt Table: GROUP_TYPE_TBL
    Set Control Field: BUSINESS_UNIT

    8 RECON_LAYOUT_ID Character(8) VARCHAR2(8) NOT NULL Input File Layout ID

    Prompt Table: SSF_BNK_IN_C_VW
    Set Control Field: BUSINESS_UNIT

    9 SSF_FILEDIRF_NLD Character(254) VARCHAR2(254) NOT NULL File Directory
    10 SSF_FILEDIRL_NLD Character(254) VARCHAR2(254) NOT NULL File Directory
    11 SSF_FILE_ID_NLD Character(4) VARCHAR2(4) NOT NULL File ID
    12 BALANCE_GRP Character(1) VARCHAR2(1) NOT NULL Balance the Group

    Y/N Table Edit

    Default Value: N

    13 RPT_ONLY Character(1) VARCHAR2(1) NOT NULL Report Only
    N=No
    Y=Yes
    14 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
    15 SSF_TEST_CD_NLD Character(1) VARCHAR2(1) NOT NULL Testing Code
    P=Production
    T=Test
    16 SSF_FILE_NM_NLD Character(30) VARCHAR2(30) NOT NULL Clieop03 File Name
    17 SSF_FILE_LTR_NLD Character(30) VARCHAR2(30) NOT NULL Letter of Payment
    18 SSF_RESTRICT_INV Character(1) VARCHAR2(1) NOT NULL This field indicates that the payment will be held until an invoice is provided.

    Y/N Table Edit