AB_CREDITBU_VW

(SQL View)
 Index Back

Action List Credit Cross BU Vw


select c.setid,c.cust_id, C.name1, C.roleuser, sum(bal_AMT), cr_limit, cr_limit_rev_dt, cr_limit_range,credit_class, c.currency_cd from ps_customer c, ps_cust_data D, PS_CUST_CREDIT O where C.cust_status = 'A' and C.bill_to_flg = 'Y' and C.cust_level <> 'P' and c.setid = ( SELECT setid from ps_set_cntrl_rec where setcntrlvalue = D.business_unit and recname = 'CUSTOMER' ) and C.cust_id = D.cust_id and O.setid = C.setid and d.cust_id = O.cust_id and O.effdt = ( select max(effdt) from PS_CUST_CREDIT where setid = O.setid and cust_id = O.cust_id and effdt <= %currentdatein and eff_status = 'A' ) group by c.setid,c.cust_id, C.name1, c.roleuser, cr_limit, cr_limit_rev_dt, cr_limit_range,credit_class, c.currency_cd

  • Related Language Record: AB_CREDITBU_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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.
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    5 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance
    6 CR_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Limit
    7 CR_LIMIT_REV_DT Date(10) DATE Credit Limit Review Date
    8 CR_LIMIT_RANGE Number(3,0) SMALLINT NOT NULL Limit Range %
    9 CREDIT_CLASS Character(2) VARCHAR2(2) NOT NULL Credit Class
    A=Class A
    B=Class B
    C=Class C
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code