BI_INSTALL_TRMS

(SQL Table)
Index Back

Installmnt Bill Terms for Sche

  • Parent Record Of BI_INSTALL_SCHE BI_INST_SCHE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_BI_NONVW

    2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

    Prompt Table: BI_HDR

    3 INSTALL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Installment Plan ID

    Prompt Table: BI_INSTAL_EF_VW

    4 INSTALL_START_DT Date(10) DATE Starting Date
    5 INSTALL_PLAN_TYPE Character(4) VARCHAR2(4) NOT NULL Installment Plan Type
    CUST=Custom Installments
    EQL=Equal Installments
    PCT=Percentage Installments
    6 TOTAL_INSTALL_NBR Number(3,0) SMALLINT NOT NULL Total Number of Installments
    7 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

    Default Value: BI_HDR.BI_CURRENCY_CD

    8 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

    Default Value: BI_HDR.BASE_CURRENCY

    9 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency

    Default Value: BI_HDR.CURRENCY_CD_XEU

    10 SERVICE_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount
    11 SERVICE_CHRG_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount
    12 SERVICE_CHRG_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount
    13 SERVICE_CHRG_PCT Number(6,2) DECIMAL(5,2) NOT NULL Service Charge Percent
    14 SERVICE_CHRG_APP Character(1) VARCHAR2(1) NOT NULL Service Charge
    1=None
    2=First Installment Only
    3=All Installments
    4=Last Installment Only

    Default Value: 1

    15 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier

    Prompt Table: BI_IB_SUR_LN_VW

    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
    18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    19 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    20 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    21 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID