BI_EIVC_LIST_VW

(SQL View)
 Index Back

To be processed bill list.


SELECT H.BUSINESS_UNIT , H.INVOICE , H.BILL_TO_CUST_ID , H.BILL_STATUS , H.BILL_TYPE_ID , H.BILL_SOURCE_ID , H.BILL_CYCLE_ID , H.PROCESS_INSTANCE , H.ADD_DTTM , H.RANGE_SELECTION_ID , B.INVOICE_LAYOUT_ID , L.PAGE_ORIENTATION , H.CONSOL_HDR , H.CONSOL_INVOICE , H.IVC_PRINTED_FLG , H.IVC_DELIVERED_FLG , H.INVOICE_DT , H.DUE_DT , H.BILL_TO_MEDIA , H.PVN_GEN_LVL , H.BUSINESS_UNIT_CA , H.CONTRACT_NUM , H.CONTRACT_LINE_NUM , H.BUSINESS_UNIT_PC , H.PROJECT_ID , H.EIVC_COPY_IND , PUBLIC_VOUCHER_NBR , PC_DISTRIB_STATUS , BI_APPROVAL_STATUS , S.EIVC_STATUS FROM PS_BI_HDR H , PS_BI_IVC_FORM B , PS_BI_IVC_LAYOUT L , PS_BI_EIVC_STATUS S WHERE H.TEMPLATE_IVC_FLG = 'N' AND H.INVOICE_FORM_ID = B.INVOICE_FORM_ID AND B.INVOICE_LAYOUT_ID = L.INVOICE_LAYOUT_ID AND H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.INVOICE = S.INVOICE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
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
5 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
6 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
7 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
10 RANGE_SELECTION_ID Character(30) VARCHAR2(30) NOT NULL Range Selection ID
11 INVOICE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL Invoice Layout ID
12 PAGE_ORIENTATION Character(1) VARCHAR2(1) NOT NULL Layout Type
E=Crystal
L=SQR - Landscape
P=SQR - Portrait
X=XML Publisher
13 CONSOL_HDR Character(1) VARCHAR2(1) NOT NULL Consolidated Hdr?
N=No
Y=Yes
14 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.
15 IVC_PRINTED_FLG Character(1) VARCHAR2(1) NOT NULL Invoice Printed
N=Not Printed
R=Printed as Rebill
Y=Printed
16 IVC_DELIVERED_FLG Character(1) VARCHAR2(1) NOT NULL Invoice Delivered
17 INVOICE_DT Date(10) DATE Invoice Date
18 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
19 BILL_TO_MEDIA Character(1) VARCHAR2(1) NOT NULL Bill To Media
A=Email Invoice as Attachment
E=EDI
H=Federal Highway File
N=Email Notification
P=Print Copy
X=Electronic Invoice File
20 PVN_GEN_LVL Character(2) VARCHAR2(2) NOT NULL PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract
C=Contract Number
CL=Contract Number/Contract Line
CP=Contract Number/Project
21 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit
22 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
23 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
24 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
25 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
26 EIVC_COPY_IND Character(1) VARCHAR2(1) NOT NULL E-Invoice Copy Indicator
N=Original Elec Invoice File
O=Cannot Generate EIVC File
Y=Copy Electronic Invoice File
27 PUBLIC_VOUCHER_NBR Number(6,0) INTEGER NOT NULL Public Voucher Number
28 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
29 BI_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=Not Required
1=Initial
2=Pending
3=Approved
4=Denied
5=Canceled
30 EIVC_STATUS Character(4) VARCHAR2(4) NOT NULL Electronic Invoice Status
ACC=Accepted
FAL=Failed Delivery
GEN=Generated
RDY=Ready
REC=Received
REF=Refused
REJ=Rejected
REV=Reversed
TRA=Transmitted