EU_DOC_CUST_VW (SQL View)	Index Back
Items on a Document Similar definition as the DOC_CUST_VW record plus three more fields: EU_BU_CUR_CD, EU_CUST_CUR_CD and EU_CUST_RT_TYPE. This new fields store the business unit's base currency and the customers' currency and rate type. This record is used in the EU_ITEM_DOC panel for performance reasons. So, recover that information from the database is performed once and not every time the user selects the 'Display' option from the panel's switch.

EU_DOC_CUST_VW

(SQL View)

Items on a Document

Similar definition as the DOC_CUST_VW record plus three more fields: EU_BU_CUR_CD, EU_CUST_CUR_CD and EU_CUST_RT_TYPE. This new fields store the business unit's base currency and the customers' currency and rate type. This record is used in the EU_ITEM_DOC panel for performance reasons. So, recover that information from the database is performed once and not every time the user selects the 'Display' option from the panel's switch.

SELECT A.document , A.document_line , A.business_unit , A.cust_id , A.item , A.item_line , A.item_seq_num , C.name1 , A.entry_type , A.entry_reason , A.entry_amt , A.entry_currency , A.entry_amt_base , A.currency_cd , D.BASE_CURRENCY , C.CURRENCY_CD , C.CUR_RT_TYPE FROM ps_customer C , PS_ITEM_ACTIVITY A , PS_BU_CRTCUR_VW_AR D WHERE a.document <> ' ' AND c.setid=( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = a.business_unit AND RECNAME='CUSTOMER') AND c.cust_id=a.cust_id AND A.BUSINESS_UNIT = D.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DOCUMENT Character(30) VARCHAR2(30) NOT NULL Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.

2 DOCUMENT_LINE Number(6,0) INTEGER NOT NULL Specifies the line number of a Document ID used as a reference on a Receivables item.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

5 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

6 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

7 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number

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

9 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.

10 ENTRY_REASON Character(5) VARCHAR2(5) NOT NULL "Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."

11 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance

12 BAL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code - Bal Amount

13 BAL_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance - Base Currency

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 EU_BU_CUR_CD Character(3) VARCHAR2(3) NOT NULL BU Currency Code

16 EU_CUST_CUR_CD Character(3) VARCHAR2(3) NOT NULL Customer Currency Code

17 EU_CUST_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Rate Type for Customer

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DOCUMENT	Character(30)	VARCHAR2(30) NOT NULL	Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
2	DOCUMENT_LINE	Number(6,0)	INTEGER NOT NULL	Specifies the line number of a Document ID used as a reference on a Receivables item.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
5	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
6	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
7	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
8	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
9	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.
10	ENTRY_REASON	Character(5)	VARCHAR2(5) NOT NULL	"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
11	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
12	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
13	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	EU_BU_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	BU Currency Code
16	EU_CUST_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Customer Currency Code
17	EU_CUST_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Rate Type for Customer