BI_TYPE_EF_VW

(SQL View)
 Index Back

Bill Type - Effective View


SELECT a.setid , a.bill_type_id , a.effdt , a.eff_status , a.descr , a.descrshort , a.invoice_form_id , a.bill_by_id , a.bill_cycle_id , a.dst_id_ar , a.bank_cd , a.bank_acct_key , a.bill_inquiry_phone , a.pymnt_terms_cd , a.billing_specialist , a.billing_authority , a.ivc_num_id , a.con_ivc_num_id , a.bi_pnlseries_id , a.gl_lvl , a.ar_lvl , a.ar_dst_opt , a.bi_ap_lvl , a.enable_dfr_rev_flg , a.dfr_acctg_dt_cd , a.dfr_rev_proration , a.dfr_mid_period_day , a.rev_recog_basis , a.dst_id_dfr , a.accrue_unbilled , a.entry_event , a.template_id , a.physical_nature , a.vat_svc_perfrm_flg , a.att_ivc_img_opt , a.use_pc_cfs , a.bi_from_email_addr , a.collector , a.cr_analyst FROM PS_BI_TYPE a WHERE a.effdt = ( SELECT MAX(effdt) FROM PS_BI_TYPE WHERE setid=a.setid AND bill_type_id=a.bill_type_id AND effdt <= %CurrentDateIn) AND a.eff_status='A'

  • Related Language Record: BI_TYPE_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form

    Prompt Table: BI_IVC_FORM_VW

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

    Prompt Table: BI_BILL_BY_VW

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

    Prompt Table: BI_CYCLE_VW

    10 DST_ID_AR Character(10) VARCHAR2(10) NOT NULL Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.

    Prompt Table: DST_CODE_AR_VW

    11 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    12 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    13 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone
    14 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.

    Prompt Table: AR_TRMS_VW

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

    Prompt Table: BI_SPECIALIST

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

    Prompt Table: BI_AUTHORITY_VW

    17 IVC_NUM_ID Character(8) VARCHAR2(8) NOT NULL Invoice Number ID

    Prompt Table: BI_IVC_NUM_VW

    18 CON_IVC_NUM_ID Character(8) VARCHAR2(8) NOT NULL Consolidated Invoice Number ID
    19 BI_PNLSERIES_ID Character(8) VARCHAR2(8) NOT NULL Page Series ID

    Prompt Table: BI_PNLSERIESHDR

    20 GL_LVL Character(1) VARCHAR2(1) NOT NULL GL Level
    A=AR Creates GL Acct Entries
    B=BI Creates GL Acct Entries
    N=No GL Accounting Entries
    21 AR_LVL Character(1) VARCHAR2(1) NOT NULL AR Level
    H=Header is AR Open Item
    L=Bill Line is AR Open Item
    N=No AR Open Items
    22 AR_DST_OPT Character(1) VARCHAR2(1) NOT NULL AR Distribution Option
    H=Use Header for Distribution
    L=Use Line for Distribution
    23 BI_AP_LVL Character(1) VARCHAR2(1) NOT NULL InterUnit AP Level
    H=Header is AP Voucher
    L=Bill Line is AP Voucher
    N=No AP Voucher
    24 ENABLE_DFR_REV_FLG Character(1) VARCHAR2(1) NOT NULL Enable Deferred Revenues
    25 DFR_ACCTG_DT_CD Character(1) VARCHAR2(1) NOT NULL Future Period Accounting Dates
    F=First Day in Accounting Period
    L=Last Day in Accounting Period
    U=User Defined
    26 DFR_REV_PRORATION Character(1) VARCHAR2(1) NOT NULL Proration Method
    1=By Days Within Range
    2=Evenly Using All Pds
    3=Evenly Using Mid-period Rule
    4=Evenly/Partial by Days
    5=User Defined Proration Method
    27 DFR_MID_PERIOD_DAY Number(2,0) SMALLINT NOT NULL Mid-Period # of Days
    28 REV_RECOG_BASIS Character(3) VARCHAR2(3) NOT NULL Revenue Recognition Basis
    CHG=From/To Date Range
    CON=Contract Date
    INV=Invoice Date
    ORD=Order Date
    SHP=Ship Date
    STE=Start/End Date Range
    UD1=User Date 1
    UD2=User Date 2
    29 DST_ID_DFR Character(10) VARCHAR2(10) NOT NULL Deferred Distribution Code
    30 ACCRUE_UNBILLED Character(1) VARCHAR2(1) NOT NULL Accrue Bills of This Level
    31 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

    Prompt Table: EE_AR_CODE1_VW

    32 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    33 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    34 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
    1=Ship To Location
    2=Ship From Location
    3=Buyer's Location
    4=Supplier's Location
    35 ATT_IVC_IMG_OPT Character(1) VARCHAR2(1) NOT NULL Attach Invoice Image Option
    0=Do not Attach Invoice Image
    1=Attach Invoice Image
    9=Not Defined at this level
    36 USE_PC_CFS Character(1) VARCHAR2(1) NOT NULL Use Project ChartFields
    37 BI_FROM_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL From Email Address
    38 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

    Prompt Table: COLLECTOR_TBL

    39 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.

    Prompt Table: CR_ANALYST_TBL