BINEWTRN_LISTVW (SQL View)	Index Back
Invoices to be retransmitted Displays the list of invoices to be re-transmitted

BINEWTRN_LISTVW

(SQL View)

Invoices to be retransmitted

Displays the list of invoices to be re-transmitted

SELECT BUSINESS_UNIT , INVOICE , BILL_TO_CUST_ID , %DateNull , 'N' , ' ' FROM PS_BI_HDR_EC WHERE ECTRANSID = 'INVOICE'

# 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

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

4 IVC_PRINTED_DT Date(10) DATE Invoice Printed Date

5 CONSOL_HDR Character(1) VARCHAR2(1) NOT NULL Consolidated Hdr?
N=No
Y=Yes

6 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.

#	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
3	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
4	IVC_PRINTED_DT	Date(10)	DATE	Invoice Printed Date
5	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
6	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.