BI_SRC_EF_VW

(SQL View)
Index Back

Billing Sources Effective View


SELECT a.setid , a.bill_source_id , a.effdt , a.eff_status , a.descr , a.descrshort , a.bill_cycle_id , a.pymnt_terms_cd , a.destination_id , a.bill_inquiry_phone , a.bank_cd , a.bank_acct_key , a.ivc_num_id , a.con_ivc_num_id , a.bi_pnlseries_id , a.invoice_form_id , a.bill_by_id , a.dst_id_ar , a.billing_specialist , a.billing_authority , a.template_id , a.physical_nature , a.vat_svc_perfrm_flg , a.att_ivc_img_opt, a.collector, a.cr_analyst FROM PS_BI_SRC a WHERE a.effdt = ( SELECT MAX(effdt) FROM PS_BI_SRC WHERE setid=a.setid AND bill_source_id=a.bill_source_id AND effdt <= %CurrentDateIn) AND a.eff_status='A'

  • Related Language Record: BI_SRC_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

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: BI_SRC

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier

    Prompt Table: BI_CYCLE_VW

    8 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

    9 DESTINATION_ID Character(20) VARCHAR2(20) NOT NULL Destination
    10 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone
    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 IVC_NUM_ID Character(8) VARCHAR2(8) NOT NULL Invoice Number ID

    Prompt Table: BI_IVC_NUM_VW

    14 CON_IVC_NUM_ID Character(8) VARCHAR2(8) NOT NULL Consolidated Invoice Number ID
    15 BI_PNLSERIES_ID Character(8) VARCHAR2(8) NOT NULL Page Series ID

    Prompt Table: BI_PNLSERIESHDR

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

    Prompt Table: BI_IVC_FORM

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

    Prompt Table: BI_BILL_BY

    18 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

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

    Prompt Table: BI_SPECIALIST

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

    Prompt Table: BI_AUTHORITY_VW

    21 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    22 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    23 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
    24 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
    25 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

    26 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