PMT_IDPMT_REF(SQL Table) |
Index Back |
|---|---|
Payment Reference RecordFinancial Gateway - Source System Reference Keys Converted to table in order to utilize the CopyTo function. No data should be loaded into this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PMT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Payment id |
| 2 | PMT_MSG_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment Message ID |
| 3 | PMT_SEQ_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 5 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 6 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 7 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 8 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 9 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 10 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 11 | KEY_CHAR_40_08 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/08 |
| 12 | KEY_CHAR_40_09 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/09 |
| 13 | KEY_CHAR_40_10 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/10 |
| 14 | KEY_CHAR_40_11 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/11 |
| 15 | KEY_CHAR_40_12 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/12 |
| 16 | KEY_CHAR_40_13 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/13 |
| 17 | KEY_CHAR_40_14 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/14 |
| 18 | KEY_CHAR_40_15 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/15 |
| 19 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 20 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 21 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 22 | KEY_DATE_04 | Date(10) | DATE | Key Date 04 |
| 23 | KEY_DATE_05 | Date(10) | DATE | Key Date 05 |
| 24 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 25 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 26 | KEY_DTTM_03 | DateTime(26) | TIMESTAMP | Key Date Time 03 |
| 27 | KEY_DTTM_04 | DateTime(26) | TIMESTAMP | Key Date Time 04 |
| 28 | KEY_DTTM_05 | DateTime(26) | TIMESTAMP | Key Date Time 05 |
| 29 | KEY_SIGN_01 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 01 |
| 30 | KEY_SIGN_02 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 02 |
| 31 | KEY_SIGN_03 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 03 |
| 32 | KEY_SIGN_04 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 04 |
| 33 | KEY_SIGN_05 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 05 |