AR_ITMIN_LST_VW

(SQL View)

SELECT H.BILL_TO_CUST_ID , H.INVOICE_DT , H.INVOICE , 'IN' , K.NAME1 FROM PS_BI_HDR H , PS_SET_CNTRL_REC S , PS_CUSTOMER K WHERE H.BILL_STATUS = 'INV' AND H.TEMPLATE_IVC_FLG = 'N' AND S.RECNAME = 'CUSTOMER' AND S.SETCNTRLVALUE = H.BUSINESS_UNIT AND S.SETID = K.SETID AND H.BILL_TO_CUST_ID = K.CUST_ID AND NOT EXISTS ( SELECT A.ITEM FROM PS_AR_EBP_ITEM_VW A , PS_CUSTOMER B WHERE A.CUST_ID = B.CUST_ID) UNION SELECT A.CUST_ID , A.DUE_DT , A.ITEM , A.ENTRY_TYPE , B.NAME1 FROM PS_AR_EBP_ITEM_VW A , PS_CUSTOMER B WHERE A.CUST_ID = B.CUST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INVOICE_DT Date(10) DATE Invoice Date

3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

4 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table: ENTRY_TYPE_TBL

5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
2	INVOICE_DT	Date(10)	DATE	Invoice Date
3	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
4	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction. Prompt Table: ENTRY_TYPE_TBL
5	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1