PROCESS_INSTANCEDefault Value: 1
PMT_LOAD_AET(SQL Table) |
Index Back |
|---|---|
Payment Load State RecordFinancial Gateway - Payment Load 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 | 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 | PMT_SOURCE | Character(10) | VARCHAR2(10) NOT NULL | Source System Name |
| 5 | BATCH_ID | Character(18) | VARCHAR2(18) NOT NULL | Batch ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | PMT_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment id |
| 8 | PMT_MSG_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment Message ID |
| 9 | PMT_SEQ_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | PMT_ID_MASK | Character(5) | VARCHAR2(5) NOT NULL | Financial Gateway - Payment Id Mask |
| 11 | LAST_PAYMENT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Payment Number Numeric |
| 12 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 13 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 14 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 15 | PARM_1 | Character(30) | VARCHAR2(30) NOT NULL | First Parameter |
| 16 | PAYMENT_CNT | Number(5,0) | INTEGER NOT NULL | Payment count |
| 17 | AE_APPSTATUS | Number(1,0) | SMALLINT NOT NULL |
AE Application Warning Status
Default Value: 1 |
| 18 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 19 | EVENT_TRACKING_ID | Number(10,0) | DECIMAL(10) NOT NULL | The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID. |
| 20 | EVENT_SEQUENCE | Character(40) | VARCHAR2(40) NOT NULL | Event Sequence Number |
| 21 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 22 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 23 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 24 | ADDENDA_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Addend Value use for Bank Statement Accounting |
| 25 | INTRMED_SEQ_NO | Number(3,0) | SMALLINT NOT NULL | A numeric value that sequentially identifiers the series of banks utilized for a given m |
| 26 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 27 | 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 |