CA_WC_LMTDTL_VW

(SQL View)
 Index Back

Contract Lines Billing Limit

This view contains the Contract Limit Amount by Contract line for the Workcenter.

SELECT HDR.CONTRACT_NUM ,DTL.CONTRACT_LINE_NUM , HDR.BUSINESS_UNIT , DTL.DESCR , BP.BILL_PLAN_ID , BP.BILL_PLAN_TYPE , BP.BP_STATUS , BP.HOLD_FLAG , LMT.CURRENCY_CD , LMT.LIMIT_AMT_BIL FROM PS_CA_CONTR_HDR HDR , PS_CA_LMT_FEE_DTL LMT , PS_CA_DETAIL DTL LEFT OUTER JOIN PS_CA_BILL_PLAN BP ON BP.CONTRACT_NUM = DTL.CONTRACT_NUM AND BP.BILL_PLAN_ID = DTL.BILL_PLAN_ID WHERE DTL.CONTRACT_NUM = HDR.CONTRACT_NUM AND LMT.CONTRACT_NUM = DTL.CONTRACT_NUM AND LMT.CONTRACT_LINE_NUM = DTL.CONTRACT_LINE_NUM AND HDR.CA_PROC_STATUS ='A' AND DTL.PRICING_STRUCTURE = 'RATE'

  • Related Language Record: CA_WC_LMTDL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
    6 BILL_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Method
    01=As Incurred
    02=Installment
    03=Recurring
    04=Milestone
    05=Percent Complete
    06=Immediate
    07=Value Based
    7 BP_STATUS Character(3) VARCHAR2(3) NOT NULL Billing Plan Status
    CAN=Cancelled
    DON=Completed
    PND=Pending
    PRG=In Progress
    RCL=Recycled
    RDY=Ready
    RIP=Reversal In Progress
    RQD=Action Required
    RRP=Recycled
    RVS=Reversed
    8 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    10 LIMIT_AMT_BIL Signed Number(28,3) DECIMAL(26,3) NOT NULL Funded/Billing Limit Amount