CA_BILL_PLAN_H

(SQL Table)
 Index Back

Contract Bill Plan

Primary record for each Contract Bill Plan.

  • Related Language Record: CA_BILLPLN_LA_H

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: SP_CA_NONVW

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

    Default Value: NEXT

    Prompt Table: CA_BILL_PLAN

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

    Default Value: 1

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

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: CA_HOLD_RSN

    14 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

    15 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

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

    Prompt Table: BI_CYCLE_VW

    17 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

    18 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

    19 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

    20 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

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

    Default Value: CA_CONTR_HDR.CNTCT_SEQ_BILL

    Prompt Table: CA_CST_CNTBI_VW

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

    Prompt Table: CA_BILL_BY_VW

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

    Prompt Table: BI_INQPHONE_VW
    Set Control Field: BUSINESS_UNIT_BI

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

    Prompt Table: BI_SPECIALST_VW
    Set Control Field: BUSINESS_UNIT_BI

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

    Default Value: CA_CONTR_HDR.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

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

    Default Value: D

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

    Default Value: N

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

    Prompt Table: BI_IVC_FORM_VW

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

    Default Value: H

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: BI_AUTH_EF_VW
    Set Control Field: BUSINESS_UNIT_BI

    38 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
    39 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
    40 BILL_THRU_DATE Date(10) DATE Billed Thru Date
    41 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID

    Prompt Table: CA_SCHED_TBL_VW
    Set Control Field: BUSINESS_UNIT

    42 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

    43 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

    44 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

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

    Default Value: 0

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

    Prompt Table: BI_SUM_TMPLT_VW

    47 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

    48 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

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

    Default Value: CA_CONTR_HDR.LOC_REFERENCE_ID

    Prompt Table: GM_SPNSR_LC2_VW
    Set Control Field: BUSINESS_UNIT