AR_ITEM_VW2 (SQL View)	Index Back
Items

AR_ITEM_VW2

(SQL View)

Items

SELECT i.business_unit , i.cust_id , i.item , i.item_line , i.ar_specialist , i.broker_id , i.cr_analyst , i.sales_person , i.sales_person2 , c.name1 , i.accounting_dt , i.bal_amt , i.bal_currency , i.item_status , i.deduction_status , i.dispute_status , i.collection_status , i.doubtful , i.ship_to_cust_id , i.sold_to_cust_id FROM PS_ITEM i , PS_CUSTOMER c WHERE i.cust_id = c.cust_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.

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

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

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

9 SALES_PERSON2 Character(8) VARCHAR2(8) NOT NULL Identifies a second Sales Person. Populated on the Item Table to identify an additional Sales Person the Item is applied to.

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

11 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

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

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

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

15 DEDUCTION_STATUS Character(5) VARCHAR2(5) NOT NULL Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet

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

17 COLLECTION_STATUS Character(3) VARCHAR2(3) NOT NULL Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.

18 DOUBTFUL Character(1) VARCHAR2(1) NOT NULL Identifies items ( or invoices ) which probably will not be paid by the customer. This status is used for items whose balances have been moved from the receivables account to the doubtful account using the transfer worksheet.

19 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

20 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	AR_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Accounts Recievable Specialist - person responsible for an action on an item.
6	BROKER_ID	Character(15)	VARCHAR2(15) NOT NULL	Broker ID
7	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.
8	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.
9	SALES_PERSON2	Character(8)	VARCHAR2(8) NOT NULL	Identifies a second Sales Person. Populated on the Item Table to identify an additional Sales Person the Item is applied to.
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
13	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
14	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status C=Closed O=Open
15	DEDUCTION_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Deduction Status C=Closed I=In Process O=Created/Opened W=On Worksheet
16	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.
17	COLLECTION_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
18	DOUBTFUL	Character(1)	VARCHAR2(1) NOT NULL	Identifies items ( or invoices ) which probably will not be paid by the customer. This status is used for items whose balances have been moved from the receivables account to the doubtful account using the transfer worksheet.
19	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
20	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer