SYSACT_VW (SQL View)	Index Back
System Activity Panel View

SYSACT_VW

(SQL View)

System Activity Panel View

SELECT business_unit , ' ' , ' ' , entry_type , ' ' , ' ' , ' ' , SUM(entry_amt_base) , currency_cd , SUM(ENTRY_AMT) , ENTRY_CURRENCY FROM PS_ITEM_ACTIVITY GROUP BY business_unit , entry_type , currency_cd , ENTRY_CURRENCY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

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

5 SYS_TRAN_TYPE Character(1) VARCHAR2(1) NOT NULL Activity Type
A=Draft Management
B=Deductions Management
C=Cash Applied
D=Discounts
F=Overdue Charges
G=Payment Plan Item-Maintenance
I=Billing
M=Maintenance
P=Write-offs - Payments
R=Refunds - Maintenance
T=Transfers
W=Write-offs - Maintenance
X=Direct Debit
Y=Write Offs - Deduction

6 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.

7 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

8 ENTRY_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit.

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

10 ENTRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the monetary amount of a pending item transaction such as invoice or credit memo.

11 ENTRY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency associated with the monetary amount of a pending item.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	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.
5	SYS_TRAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Activity Type A=Draft Management B=Deductions Management C=Cash Applied D=Discounts F=Overdue Charges G=Payment Plan Item-Maintenance I=Billing M=Maintenance P=Write-offs - Payments R=Refunds - Maintenance T=Transfers W=Write-offs - Maintenance X=Direct Debit Y=Write Offs - Deduction
6	GROUP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
7	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
8	ENTRY_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	ENTRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of a pending item transaction such as invoice or credit memo.
11	ENTRY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency associated with the monetary amount of a pending item.