POS_AR_ITEM_VW1 (SQL View)	Index Back
Position Item Rec - With Bank Positions view of Receivables' open items that do not have a dispute status, and are not credit memos or prepayments. These are items where the bank account has been defined

POS_AR_ITEM_VW1

(SQL View)

Position Item Rec - With Bank

Positions view of Receivables' open items that do not have a dispute status, and are not credit memos or prepayments. These are items where the bank account has been defined

SELECT DISTINCT A.DUE_DT ,A.BAL_AMT ,A.BAL_CURRENCY ,A.BANK_SETID ,A.BANK_CD ,A.BANK_ACCT_KEY ,B.BUSINESS_UNIT_GL ,B.BUSINESS_UNIT ,A.CUST_ID ,A.ITEM ,A.ITEM_LINE , D.BNK_ID_NBR ,C.BANK_ACCOUNT_NUM FROM PS_ITEM A , PS_BUS_UNIT_TBL_AR B , PS_BANK_ACCT_TBL C , PS_BANK_CD_TBL D WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.ITEM_STATUS = 'O' AND A.DISPUTE_STATUS= ' ' AND A.ENTRY_TYPE <> 'CR' AND A.ENTRY_TYPE <> 'PR' AND A.BANK_SETID = C.SETID AND A.BANK_CD = C.BANK_CD AND A.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND D.SETID = C.SETID AND D.BANK_CD = C.BANK_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_DATE Date(10) DATE Represents a date upon which business is conducted within a given company in a given country.

2 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

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

4 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

6 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

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

8 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

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

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

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

12 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

13 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_DATE	Date(10)	DATE	Represents a date upon which business is conducted within a given company in a given country.
2	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
3	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
4	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
5	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
6	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
9	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.
10	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.
11	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
12	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
13	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.