ITEM_SS_VW

(SQL View)

SELECT a.business_unit , a.cust_id , a.item , a.item_line , a.item_status , a.ar_specialist , a.deduction_status , a.dispute_status , a.entry_type , a.entry_reason , a.orig_item_amt , a.currency_cd , a.bal_amt , a.bal_currency , a.due_dt , a.rt_type , a.rate_mult , a.rate_div , a.invoice , a.dt_invoiced , a.pprc_promo_cd , a.claim_no , a.claim_dt , a.document , a.order_no , a.po_ref , a.contract_num , a.merch_type , a.broker_id , a.sales_person , a.sales_person2 , a.cr_analyst , a.sold_to_cust_id , a.sold_to_addr_num , a.address_seq_num , a.collector , a.carrier_id , a.proof_of_delivery , a.bill_of_lading , a.ship_to_cust_id , a.ship_to_addr_num , a.accounting_dt , a.ship_from_bu , a.asof_dt , a.business_unit_om , a.post_dt , a.invoice_dt , a.business_unit_ca , a.contract_line_num , a.subrog_case_num FROM PS_ITEM a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUARAP_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.
Prompt Table: CUST_SRCH_VW

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 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
C=Closed
O=Open

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

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

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

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 ORIG_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Original Item Amount

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

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

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

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

16 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

17 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

18 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

19 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
Prompt Table: AR_BI_HDR_VW

20 DT_INVOICED Date(10) DATE Date Invoiced

21 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

22 CLAIM_NO Character(30) VARCHAR2(30) NOT NULL Claim Number for an item

23 CLAIM_DT Date(10) DATE Claim Date

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

25 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

26 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

27 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

28 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

29 BROKER_ID Character(15) VARCHAR2(15) NOT NULL Broker ID
Prompt Table: CUST_BRK_A1S_VW

30 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.
Prompt Table: AR_TEAM_MBR_VW

31 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.
Prompt Table: AR_TEAM_MBR_VW

32 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.
Prompt Table: CR_ANALYST_TBL

33 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
Prompt Table: CUSTOMER

34 SOLD_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Sold To Address Sequence Num

35 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Default Value: 1
Prompt Table: CUST_ADDR_SEQ

36 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.
Default Value: CUST_OPTION.COLLECTOR
Prompt Table: COLLECTOR_TBL
Set Control Field: BUSINESS_UNIT

37 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

38 PROOF_OF_DELIVERY Character(30) VARCHAR2(30) NOT NULL Proof of Delivery

39 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

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

41 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num

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

43 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

44 ASOF_DT Date(10) DATE As of Date

45 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

46 POST_DT Date(10) DATE The Date a transaction was Posted.

47 INVOICE_DT Date(10) DATE Invoice Date

48 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

49 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

50 SUBROG_CASE_NUM Character(30) VARCHAR2(30) NOT NULL Subrogation case number used for Insurance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARAP_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. Prompt Table: CUST_SRCH_VW
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	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status C=Closed O=Open
6	AR_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Accounts Recievable Specialist - person responsible for an action on an item.
7	DEDUCTION_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Deduction Status C=Closed I=In Process O=Created/Opened W=On Worksheet
8	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.
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	ORIG_ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Original Item Amount
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
14	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
15	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.
16	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
17	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
18	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
19	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice Prompt Table: AR_BI_HDR_VW
20	DT_INVOICED	Date(10)	DATE	Date Invoiced
21	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
22	CLAIM_NO	Character(30)	VARCHAR2(30) NOT NULL	Claim Number for an item
23	CLAIM_DT	Date(10)	DATE	Claim Date
24	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.
25	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
26	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
27	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
28	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type
29	BROKER_ID	Character(15)	VARCHAR2(15) NOT NULL	Broker ID Prompt Table: CUST_BRK_A1S_VW
30	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. Prompt Table: AR_TEAM_MBR_VW
31	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. Prompt Table: AR_TEAM_MBR_VW
32	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. Prompt Table: CR_ANALYST_TBL
33	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: CUSTOMER
34	SOLD_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Sold To Address Sequence Num
35	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: 1 Prompt Table: CUST_ADDR_SEQ
36	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments. Default Value: CUST_OPTION.COLLECTOR Prompt Table: COLLECTOR_TBL Set Control Field: BUSINESS_UNIT
37	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
38	PROOF_OF_DELIVERY	Character(30)	VARCHAR2(30) NOT NULL	Proof of Delivery
39	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
40	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
41	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
42	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
43	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
44	ASOF_DT	Date(10)	DATE	As of Date
45	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
46	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
47	INVOICE_DT	Date(10)	DATE	Invoice Date
48	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
49	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
50	SUBROG_CASE_NUM	Character(30)	VARCHAR2(30) NOT NULL	Subrogation case number used for Insurance