BI_HDR_IVC_D_VW

(SQL View)
 Index Back

invoiced bills

invoiced bills

SELECT H.BUSINESS_UNIT , H.INVOICE , H.ADD_DTTM , %DatePart(H.ADD_DTTM) , H.DT_INVOICED , %DateDiff(%DatePart(H.ADD_DTTM), H.DT_INVOICED) , H.INVOICE_AMOUNT , H.BI_CURRENCY_CD , H.BILLING_SPECIALIST , H.INVOICE_TYPE , H.BILL_TYPE_ID , H.BILL_STATUS , H.BILL_SOURCE_ID , H.BILL_TO_CUST_ID , H.CONTRACT_NUM , H.PROJECT_ID , %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, H.DT_INVOICED) , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, H.DT_INVOICED) , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, H.DT_INVOICED) %Concat '-' %Concat %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, H.DT_INVOICED) FROM PS_BI_HDR H WHERE BILL_STATUS IN ('INV', 'FNL') AND CONSOL_HDR IN ('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_NOIVC_VW

3 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
4 ADD_DT Date(10) DATE Customer Added On
5 DT_INVOICED Date(10) DATE Date Invoiced
6 BI_DAYS_UNBILLED Number(8,0) INTEGER NOT NULL Days Unbilled
7 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
8 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
9 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist
10 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

Default Value: REG

11 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

Prompt Table: BI_TYPE

12 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

Default Value: NEW

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

Prompt Table: BI_SRC

14 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_BI_A2_VW

15 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
16 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
17 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
18 IVC_YEAR Character(4) VARCHAR2(4) NOT NULL Invoice Year
19 MO_YR_IVC Character(7) VARCHAR2(7) NOT NULL date invoiced