CUST_CRSPD_BVW

(SQL View)
 Index Back

Cust Correspondence View w bnk

Date Init. Issue # Description

SELECT A.SETID , A.CUST_ID , A.EFFDT , A.EFF_STATUS , A.BANK_CD , A.BANK_ACCT_KEY , A.CRSPD_ADDR , A.ADDRESS_SEQ_NUM , A.CNTCT_SEQ_NUM , A.ONE_DOCUMENT_PER , A.DUN_ID , A.DUN_GROUP , A.DUN_HOLD , A.DUN_HOLD_DT , A.ST_ID , A.ST_GROUP , A.ST_HOLD , A.ST_HOLD_DT , A.CRSPD_CNTCT , A.LANGUAGE_CD , A.OC_GROUP , A.OC_ADMIN_ID , A.OC_ADMIN_HOLD , A.OC_ADMIN_HOLD_DT , A.OC_FIN_ID , A.OC_FIN_HOLD , A.OC_FIN_HOLD_DT , A.OC_PNLTY_ID , A.OC_PNLTY_HOLD , A.OC_PNLTY_HOLD_DT , A.ASSESS_OC_FLAG , A.VIEW_STMT_IMAG_CWB , A.LAST_MAINT_OPRID , A.DATE_LAST_MAINT FROM PS_CUST_CRSPD A WHERE A.BANK_CD <> ' ' AND A.BANK_ACCT_KEY <> ' '

  • Parent record: CUSTOMER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: CUSTOMER

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

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

    Prompt Table: BANK_AR_BR_VW

    6 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_AR_R_VW

    7 CRSPD_ADDR Character(1) VARCHAR2(1) NOT NULL Address
    C=Contact Address
    D=Override
    I=Item Address
    P=Primary Address

    Default Value: P

    8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: CUST_ADDR_CR_VW

    9 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CNCT_EF_VW

    10 ONE_DOCUMENT_PER Character(1) VARCHAR2(1) NOT NULL One Document Per
    B=Business Unit
    S=SETID

    Default Value: S

    11 DUN_ID Character(5) VARCHAR2(5) NOT NULL Dunning ID

    Prompt Table: DUNNING_TBL

    12 DUN_GROUP Character(2) VARCHAR2(2) NOT NULL Dunning Group
    %=All Groups
    A=Group A
    B=Group B
    C=Group C
    D=Group D
    13 DUN_HOLD Character(1) VARCHAR2(1) NOT NULL Dunning Hold

    Y/N Table Edit

    Default Value: N

    14 DUN_HOLD_DT Date(10) DATE Dunning Hold Date
    15 ST_ID Character(5) VARCHAR2(5) NOT NULL Statement ID

    Prompt Table: STATEMENT_TBL

    16 ST_GROUP Character(2) VARCHAR2(2) NOT NULL Statement Group
    %=All Statement Groups
    A=Group A
    B=Group B
    C=Group C
    D=Group D
    17 ST_HOLD Character(1) VARCHAR2(1) NOT NULL Statement Hold

    Y/N Table Edit

    Default Value: N

    18 ST_HOLD_DT Date(10) DATE Statement Hold Date
    19 CRSPD_CNTCT Character(1) VARCHAR2(1) NOT NULL Contact
    D=Override
    P=Primary Contact
    S=Suppress Contact

    Default Value: S

    20 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: PSOPTIONS.LANGUAGE_CD

    21 OC_GROUP Character(2) VARCHAR2(2) NOT NULL Overdue Charge Group
    %=All Overdue Charge Groups
    A=Group A
    B=Group B
    C=Group C
    D=Group D
    22 OC_ADMIN_ID Character(5) VARCHAR2(5) NOT NULL Overdue Charge Admin ID

    Prompt Table: OC_ADMIN_VW

    23 OC_ADMIN_HOLD Character(1) VARCHAR2(1) NOT NULL Overdue Charge Admin Hold

    Y/N Table Edit

    Default Value: N

    24 OC_ADMIN_HOLD_DT Date(10) DATE Overdue Charge Admin Hold Date
    25 OC_FIN_ID Character(5) VARCHAR2(5) NOT NULL Overdue Charge Finance ID

    Prompt Table: OC_FIN_VW

    26 OC_FIN_HOLD Character(1) VARCHAR2(1) NOT NULL Overdue Charge Finance Hold

    Y/N Table Edit

    Default Value: N

    27 OC_FIN_HOLD_DT Date(10) DATE Overdue Charge Fin Hold Date
    28 OC_PNLTY_ID Character(5) VARCHAR2(5) NOT NULL Overdue Charge Penalty ID

    Prompt Table: OC_PNLTY_VW

    29 OC_PNLTY_HOLD Character(1) VARCHAR2(1) NOT NULL Overdue Charge Penalty Hold

    Y/N Table Edit

    Default Value: N

    30 OC_PNLTY_HOLD_DT Date(10) DATE Overdue Charge Pen Hold Date
    31 ASSESS_OC_FLAG Character(1) VARCHAR2(1) NOT NULL Assess Overdue Charges

    Y/N Table Edit

    Default Value: Y

    32 VIEW_STMT_IMAG_CWB Character(1) VARCHAR2(1) NOT NULL Field used to determine if Statment Images will be generated to be displayed as attachment at Collection Workbench in Receivables
    N=No
    Y=Yes
    33 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    34 DATE_LAST_MAINT Date(10) DATE Date Last Maintained