CA_BILL_PLAN

(SQL Table)
 Index Back

Contract Bill Plan

Primary record for each Contract Bill Plan.

  • Related Language Record: CA_BILLPLN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: SP_CA_NONVW

    2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

    Default Value: NEXT

    Prompt Table: CA_BILL_PLAN

    3 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
    4 CA_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Use Amount
    1=Percent
    2=Amount

    Default Value: 1

    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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

    Default Value: PND

    8 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold

    Y/N Table Edit

    Default Value: N

    9 HOLD_DATE Date(10) DATE Put On Hold Date
    10 HOLD_OPRID Character(30) VARCHAR2(30) NOT NULL Hold User
    11 HOLD_RSN Character(4) VARCHAR2(4) NOT NULL Hold Reason

    Prompt Table: CA_HOLD_RSN

    12 SYSTEM_DEFINED Character(2) VARCHAR2(2) NOT NULL "A flag that indicates the accounting entry line type. The valid line types are pre-populated by PeopleSoft. For example the value is ""A"" if the line represents a debit or credit to the AR account. Some examples of other values are D (Draft Receivables entry) and L (Cash Control entry). "

    Y/N Table Edit

    13 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

    Default Value: CA_CONTR_HDR.BUSINESS_UNIT_BI

    Prompt Table: SP_BUCABI_NONVW

    14 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier

    Prompt Table: BI_CYCLE_VW

    15 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

    Default Value: CA_CONTR_HDR.BILL_TYPE_ID

    Prompt Table: BI_TYPE_EF_VW
    Set Control Field: BUSINESS_UNIT_BI

    16 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

    Default Value: CA_BP_SRC_VW.BILL_SOURCE_ID

    Prompt Table: BI_SRC_EF_VW
    Set Control Field: BUSINESS_UNIT_BI

    17 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

    Default Value: CA_CONTR_HDR.BILL_TO_CUST_ID

    Prompt Table: %EDITTABLE2
    Set Control Field: BUSINESS_UNIT_BI

    18 ADDR_SEQ_NUM_BILL Number(5,0) INTEGER NOT NULL Address Sequence Number

    Default Value: CA_CONTR_HDR.ADDR_SEQ_NUM_BILL

    Prompt Table: CABI_ADDR_VW

    19 CNTCT_SEQ_BILL Number(5,0) INTEGER NOT NULL Contact Sequence - Bill To

    Prompt Table: CA_CST_CNTBI_VW

    20 BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL Bill By Identifier

    Prompt Table: CA_BILL_BY_VW

    21 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone

    Prompt Table: BI_INQPHONE_VW
    Set Control Field: BUSINESS_UNIT_BI

    22 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist

    Prompt Table: BI_SPECIALST_VW
    Set Control Field: BUSINESS_UNIT_BI

    23 CA_PER_COMPLETE Number(12,8) DECIMAL(11,8) NOT NULL Percent Complete
    24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CA_CONTR_HDR.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    25 BILL_CUR_OPT Character(1) VARCHAR2(1) NOT NULL Bill Currency
    D=Contract Currency
    M=Transaction Currency

    Default Value: D

    26 MAX_LINE_NUM Number(15,0) DECIMAL(15) NOT NULL An internal work field utilized in bank transfer processing.
    27 PRE_APPROVAL_FLG Character(1) VARCHAR2(1) NOT NULL Pre Approval Flag
    28 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

    Default Value: N

    29 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form

    Prompt Table: BI_IVC_FORM_VW

    30 INCLUDE_RETAINAGE Character(1) VARCHAR2(1) NOT NULL Include in Billing
    B=Bill
    H=Hold
    W=Write-off

    Default Value: H

    31 LAST_XREF_SEQ_NUM Number(5,0) INTEGER NOT NULL Last XREF Sequence Number
    32 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    33 TOLERANCE_AMT Number(16,2) DECIMAL(15,2) NOT NULL Tolerance Amount
    34 FINAL_FLAG Character(1) VARCHAR2(1) NOT NULL Final Bill Option

    Y/N Table Edit

    Default Value: N

    35 BILLING_AUTHORITY Character(8) VARCHAR2(8) NOT NULL Billing Authority

    Prompt Table: BI_AUTH_EF_VW
    Set Control Field: BUSINESS_UNIT_BI

    36 PRIOR_BP_STATUS Character(3) VARCHAR2(3) NOT NULL Prior Billing Plan Status
    CAN=Cancelled
    DON=Completed
    PND=Pending
    PRG=In Progress
    RCL=Recycled
    RDY=Ready
    RIP=Reversal In Progress
    RQD=Action Required
    RVS=Reversed
    37 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
    38 BILL_THRU_DATE Date(10) DATE Billed Thru Date
    39 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID

    Prompt Table: CA_SCHED_TBL_VW
    Set Control Field: BUSINESS_UNIT

    40 CA_PERCENT_TYPE Character(1) VARCHAR2(1) NOT NULL Used on Percent Complete Revenue and Bill Plans
    1=Specify
    2=Project
    3=Proj/Act

    Default Value: 1

    41 PLAN_CONTR_ACT Character(1) VARCHAR2(1) NOT NULL Activate Contract
    P=Leave Pending
    R=Set to Ready

    Y/N Table Edit

    Default Value: Y

    42 CA_TXN_SOURCE Character(3) VARCHAR2(3) NOT NULL Contracts Transaction Source
    CRM=CRM Transaction
    FPC=Projects Transaction
    FRE=Lease Administration Trans.

    Default Value: FPC

    43 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

    Default Value: 0

    44 SUM_TEMPLATE_ID Character(16) VARCHAR2(16) NOT NULL Summarization Template ID

    Prompt Table: BI_SUM_TMPLT_VW

    45 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
    ACH=ACH
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DD=Direct Debit
    DR=Draft
    EC=Electronic Check
    EFT=Electronic Fund Transfer
    GE=Giro - EFT
    PL=PayPal
    WIR=Wire Report

    Default Value: CA_CONTR_HDR.PAYMENT_METHOD

    46 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Default Value: CA_CONTR_HDR.PYMNT_TERMS_CD

    Prompt Table: AR_TRMS_VW
    Set Control Field: BUSINESS_UNIT_BI

    47 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID

    Default Value: CA_CONTR_HDR.LOC_REFERENCE_ID

    Prompt Table: CA_SPNSR_ALC_VW
    Set Control Field: BUSINESS_UNIT