SSF_COR_BNK_NLD

(SQL Table)
 Index Back

Corporate Bank Accounts NLD

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    2 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: O

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: 1

    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 SSF_BANK_ACCT_ID Number(3,0) SMALLINT NOT NULL Unique Bank Account Identifier. It is a sequence number field, unique by COMMON_ID, SA_ID_TYPE.

    Prompt Table: SSF_ACCT_ID_VW

    7 SSF_ACCT_SEL_NLD Character(1) VARCHAR2(1) NOT NULL Account Information
    B=Business Unit
    E=External Organization

    Default Value: E

    8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    11 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr

    Prompt Table: ORG_LOCATIONVW2

    12 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr

    Prompt Table: ORG_CONTACT3_VW

    13 SSF_OLA_CON_NLD Character(1) VARCHAR2(1) NOT NULL OLA Contract Code Netherlands
    A=A-Contract
    B=B-Contract
    C=C-Contract
    14 SSF_OLA_CD_NLD Character(2) VARCHAR2(2) NOT NULL OLA Code
    12=OLA Code 12
    13=OLA Code 13
    14=OLA Code 14
    15=OLA Code 15
    15 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
    16 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    17 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    18 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    19 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time