BI_PVG_ALL_VW

(SQL View)
 Index Back

Bill Hdr w INV bill status vw


SELECT business_unit , invoice , invoice_dt , accounting_dt , %DatePart(add_dttm) , bi_currency_cd , bill_status , invoice_amount , bill_to_cust_id , bill_source_id , bill_type_id , billing_specialist , invoice_type , billing_frequency , contract_num , project_id , gen_ar_item_flg , gen_ap_vchr_flg , ap_created_dt , ar_entry_created , gl_entry_created , ' ' , ar_lvl , business_unit_to , preload_ind , consol_hdr , %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, INVOICE_DT) , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, INVOICE_DT) , %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, ACCOUNTING_DT) , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, ACCOUNTING_DT) , %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, add_dttm) , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, add_dttm) FROM PS_BI_HDR WHERE bill_status NOT IN ('CAN', 'TMP', 'TMR') OR ((BILL_STATUS = 'TMP' OR BILL_STATUS = 'TMR') AND (PC_DISTRIB_STATUS <> 'I')) AND CONSOL_HDR <> 'Y' AND TEMPLATE_IVC_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_BI_NONVW

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

Default Value: NEXT

Prompt Table: BI_HDR_IVC_VW

3 INVOICE_DT Date(10) DATE Invoice Date
4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
5 DATE_ADDED Date(10) DATE Date Added
6 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
7 BILL_STATUS Character(3) VARCHAR2(3) NOT NULL Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill
8 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
9 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_BI_A2_VW

10 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
11 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
12 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist
13 INVOICE_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
14 BILLING_FREQUENCY Character(3) VARCHAR2(3) NOT NULL Billing Frequency
INS=Installment
ONC=Once
REC=Recurring
15 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
16 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
17 GEN_AR_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Generate AR Open Item
18 GEN_AP_VCHR_FLG Character(1) VARCHAR2(1) NOT NULL Generate AP Voucher
19 AP_CREATED_DT Date(10) DATE AP Voucher Created Date
20 AR_ENTRY_CREATED Character(1) VARCHAR2(1) NOT NULL AR Accounting Entry Created

Y/N Table Edit

21 GL_ENTRY_CREATED Character(1) VARCHAR2(1) NOT NULL GL Accounting Entry Created

Y/N Table Edit

22 AP_ENTRY_CREATED Character(1) VARCHAR2(1) NOT NULL AP Voucher Entries Created
N=AP Voucher Entries Not Created
Y=AP Voucher Entries Created
23 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
24 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
25 PRELOAD_IND Character(1) VARCHAR2(1) NOT NULL Billing: Used to indicate the status of the invoice with regard to the PreLoad Process (BIPRELD). 1=Pending - Invoices ready to be processed 2=Done - Invoices processed with no errors 3=ComboEdit Error - Invoices contain combo edit error
1=Pending
2=Done
3=ComboEdit Error
26 CONSOL_HDR Character(1) VARCHAR2(1) NOT NULL Consolidated Hdr?
N=No
Y=Yes
27 IVC_MONTH Character(2) VARCHAR2(2) NOT NULL Invoice Month
01=01-January
02=02-February
03=03-March
04=04-April
05=05-May
06=06-June
07=07-July
08=08-August
09=09-September
10=10-October
11=11-November
12=12-December
28 IVC_YEAR Character(4) VARCHAR2(4) NOT NULL Invoice Year
29 ACCT_MONTH Character(2) VARCHAR2(2) NOT NULL Accounting Month
01=01-January
02=02-February
03=03-March
04=04-April
05=05-May
06=06-June
07=07-July
08=08-August
09=09-September
1=01-January
10=10-October
11=11-November
12=12-December
2=02-February
3=03-March
4=04-April
5=05-May
6=06-June
7=07-July
8=08-August
9=09-September
30 ACCT_YEAR Character(4) VARCHAR2(4) NOT NULL Accounting Year
31 ADD_MONTH Character(2) VARCHAR2(2) NOT NULL Add Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
32 ADD_YEAR Character(4) VARCHAR2(4) NOT NULL Add Year