PASTD_DTL_MVW (SQL View)	Index Back
Past Due Itens Past Due Itens

PASTD_DTL_MVW

(SQL View)

Past Due Itens

SELECT I.BUSINESS_UNIT , I.CUST_ID , I.ITEM , I.ITEM_LINE , I.ORIG_ITEM_AMT , I.DISPUTE_AMOUNT , I.DISPUTE_STATUS , I.SUBCUST_QUAL1 , I.SUBCUST_QUAL2 , I.COLLECTOR , I.SALES_PERSON , I.CR_ANALYST , I.AR_SPECIALIST , I.BROKER_ID , I.BAL_CURRENCY , I.BAL_AMT , I.DUE_DT , I.ITEM_STATUS , I.DISPUTE_DT , I.BAL_AMT_BASE , I.CURRENCY_CD , I.CONVERS_EXISTS , I.PYMNT_TERMS_CD , I.ROWID AS ROWID1 , C.ROWID AS ROWID2 FROM PS_ITEM I , PS_OPI_SYSCFG_TBL1 C WHERE I.ITEM_STATUS = 'O' AND I.DUE_DT < C.CURRENT_DATE1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDS_NONVW

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

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

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

5 ORIG_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Original Item Amount

6 DISPUTE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.

7 DISPUTE_STATUS Character(3) VARCHAR2(3) NOT NULL Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.

8 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

9 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

10 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

11 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

12 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.

13 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.

14 BROKER_ID Character(15) VARCHAR2(15) NOT NULL Broker ID

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

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

17 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

18 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
C=Closed
O=Open

19 DISPUTE_DT Date(10) DATE Specifies the date that an item was placed in dispute status.

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

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

22 CONVERS_EXISTS Character(1) VARCHAR2(1) NOT NULL "A flag that indicates whether a conversation is associated with a single item or with multiple items ."

23 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

24 ROWID1 Character(254) VARCHAR2(254) NOT NULL Row ID

25 ROWID2 Character(254) VARCHAR2(254) NOT NULL Row ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW
2	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.
3	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.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	ORIG_ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Original Item Amount
6	DISPUTE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.
7	DISPUTE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
8	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
9	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
10	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
11	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
12	CR_ANALYST	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
13	AR_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Accounts Recievable Specialist - person responsible for an action on an item.
14	BROKER_ID	Character(15)	VARCHAR2(15) NOT NULL	Broker ID
15	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
16	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
17	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
18	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status C=Closed O=Open
19	DISPUTE_DT	Date(10)	DATE	Specifies the date that an item was placed in dispute status.
20	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
22	CONVERS_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	"A flag that indicates whether a conversation is associated with a single item or with multiple items ."
23	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
24	ROWID1	Character(254)	VARCHAR2(254) NOT NULL	Row ID
25	ROWID2	Character(254)	VARCHAR2(254) NOT NULL	Row ID