PROCESS_INSTANCEPSA_MULTCUR_AET(SQL Table) |
Index Back |
|---|---|
AE Multi-Currency state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source Recname |
| 3 | RECNAME_TARGET | Character(15) | VARCHAR2(15) NOT NULL | Target Recname |
| 4 | RECNAME_TMP | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name |
| 5 | FIELDNAME_FROM_CUR | Character(18) | VARCHAR2(18) NOT NULL | From Currency |
| 6 | FIELDNAME_FROM_AMT | Character(18) | VARCHAR2(18) NOT NULL | From Amount |
| 7 | FIELDNAME_TO_CUR | Character(18) | VARCHAR2(18) NOT NULL | To Currency |
| 8 | FIELDNAME_TO_AMT | Character(18) | VARCHAR2(18) NOT NULL | To Amount |
| 9 | FIELDNAME_RT_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Rate Type |
| 10 | FIELDNAME_CUREFFDT | Character(18) | VARCHAR2(18) NOT NULL | Currency Effective Date |
| 11 | BU_CUR_SW | Character(1) | VARCHAR2(1) NOT NULL | Currency Override |
| 12 | WORK_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Count of Anything |