STMT_CUST

(SQL Table)
 Index Back

Customer Statement Header

  • Parent Record Of AR_STMT_CUSDT_H DUN_CUST_DTL OC_CUST_DTL STMT_CUST_DTL STMT_DTL_ARCH

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETCS_NONVW

    2 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

    Prompt Table: CRSPD_CUST_D_VW

    3 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number

    Prompt Table: STMT_CUST

    4 ST_DT Date(10) DATE Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.
    5 ST_ID_TYPE Character(1) VARCHAR2(1) NOT NULL Statement Type
    B=Bal Fwd
    O=Open Item

    Default Value: O

    6 ST_STATUS Character(1) VARCHAR2(1) NOT NULL Statement Status
    A=BF Statement Active
    I=BF Statement Inactivated

    Default Value: A

    7 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
    8 DISPLAY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Display Currency