SYSACT_TRAN_VW(SQL View) |
Index Back |
|---|---|
System Act by Transaction Type |
| SELECT I.BUSINESS_UNIT , I.ACCOUNTING_DT , E.SYS_TRAN_TYPE , I.ENTRY_AMT_BASE , I.CURRENCY_CD , I.ENTRY_AMT , I.ENTRY_CURRENCY FROM PS_ITEM_ACTIVITY I , PS_ENTRY_USE_TBL E WHERE E.ENTRY_USE_ID = I.ENTRY_USE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 3 | 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 |
| 4 | 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. |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | 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. |
| 7 | ENTRY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency associated with the monetary amount of a pending item. |