BI_HDR_SRCH_VW

(SQL View)
 Index Back

SELECT H.business_unit ,H.invoice ,H.invoice_type ,H.bill_status ,H.INVOICE_DT , %Substring(%Cast(H.INVOICE_DT, Date, Character), 1, 4) , %Substring(%Cast(H.INVOICE_DT, Date, Character), 9, 2) , %Substring(%Cast(H.INVOICE_DT, Date, Character), 6, 2) ,C.NAME1 ,H.INVOICE_DT , %Substring(%Cast(H.INVOICE_DT, Date, Character), 1, 4) , %Substring(%Cast(H.INVOICE_DT, Date, Character), 9, 2) , %Substring(%Cast(H.INVOICE_DT, Date, Character), 6, 2) , %Substring(%Cast(H.INVOICE_DT, Date, Character), 6, 2) , H.business_unit FROM PS_BI_HDR H , ps_customer C , PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = H.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER' AND S.SETID = C.SETID AND H.BILL_TO_CUST_ID = C.CUST_ID

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

Default Value: NEXT

Prompt Table: BI_HDR_NOIVC_VW

3 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

4 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

5 INVOICE_DT Date(10) DATE Invoice Date
6 INVOICE_DT_YEAR Character(4) VARCHAR2(4) NOT NULL Invoice Date
7 INVOICE_DT_DAY Character(2) VARCHAR2(2) NOT NULL Invoice Date Day
8 INVOICE_DT_MONTH2 Character(2) VARCHAR2(2) NOT NULL 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
9 CUST_NAME_FINGBL Character(40) VARCHAR2(40) NOT NULL Customer Name1
10 SES_DOCUMENT_DATE Date(10) DATE Document Date
11 SES_YEAR Character(4) VARCHAR2(4) NOT NULL Document Date Hierarchy
12 SES_DAY Character(2) VARCHAR2(2) NOT NULL Day
13 SES_MONTH Character(2) VARCHAR2(2) NOT NULL 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
14 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL 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
15 BUS_UNIT_BIALTSRCH Character(5) VARCHAR2(5) NOT NULL Bills in Business Unit