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' |
# | 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 |