TR_XMLP_RPT_AET(SQL Table) |
Index Back |
|---|---|
XMLP AET Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | WORKSHEET_ID | Character(20) | VARCHAR2(20) NOT NULL | Cash Flows Worksheet ID |
| 7 | VALUE_DT | Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 8 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 9 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 10 | BU_GRP_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the Cash Position for a Business Unit Group in the report. |
| 11 | BU_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the Cash positon for a particular Business Unit or not. |
| 12 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 13 | BUSINESS_UNIT_GRP | Character(5) | VARCHAR2(5) NOT NULL | Group Business Unit |
| 14 | BUSINESS_UNIT_OPT | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the Cash Position for all the Business Units in the report. |
| 15 | ALL_ACC_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the cash position for all the Bank Account keys in the report. |
| 16 | ACC_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the cash position for a particular Bank Account key in the report. |
| 17 | ALL_BANK_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the cash position for all Banks in the report. |
| 18 | ACC_GRP_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the cash position for a particular Account Group in the report |
| 19 | BNK_ACCTGRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Account Group ID |
| 20 | BNK_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Determines whether to show the cash position for a particular Bank or not in the report. |
| 21 | ACCOUNT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Account SETID |
| 22 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 23 | 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 |
| 24 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 25 | BANK_CD2 | Character(5) | VARCHAR2(5) NOT NULL | A unique key identifier that represents a bank or counterparty. |
| 26 | GROUP_BY_FIELD_VAL | Character(30) | VARCHAR2(30) NOT NULL | Group by Field Value |
| 27 | GROUP_BY_FIELD_RPT | Character(3) | VARCHAR2(3) NOT NULL |
Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account BNK=Bank BU=Business Unit CUR=Position Currency GP1=Group By Field 1 GP2=Group By Field 2 GP3=Group By Field 3 GP4=Group By Field 4 GP5=Group By Field 5 GP6=Group By Field 6 GP7=Group By Field 7 SRC=Source Set VAL=Value Date |
| 28 | AMOUNT_OPTN | Character(3) | VARCHAR2(3) NOT NULL |
Amount Option determines whether to select POS_IMPCT_ORIG or POS_IMPCT_WEIGHT for Cash Position reports
O=Original W=Weighted |
| 29 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 30 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 31 | ASOFDATE | Date(10) | DATE | As of Date |
| 32 | GROUP_BY_FIELD_VAR | Character(3) | VARCHAR2(3) NOT NULL |
Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account BNK=Bank BU=Business Unit GP1=Group By Field 1 GP2=Group By Field 2 GP3=Group By Field 3 GP4=Group By Field 4 GP5=Group By Field 5 GP6=Group By Field 6 GP7=Group By Field 7 |
| 33 | FROM_DT | Date(10) | DATE | From Date |
| 34 | TO_DT | Date(10) | DATE | To Date |