BIRETRAN_LISTVW

(SQL View)
 Index Back

Invoices to be retransmitted

Displays the list of invoices to be re-transmitted

SELECT BUSINESS_UNIT , INVOICE , BILL_TO_CUST_ID , IVC_PRINTED_DT , CONSOL_HDR , CONSOL_INVOICE FROM PS_BI_HDR HDR WHERE PROCESS_INSTANCE = 0 AND BILL_TO_MEDIA = 'E' AND IVC_PRINTED_DT IS NOT NULL AND NOT EXISTS ( SELECT 'X' FROM PS_BI_HDR_EC EC WHERE EC.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND EC.INVOICE = HDR.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.