TEST_CASECOMPARE_TYPE1=Delta (Results v.s Expected)
2=Expected data not in Results
3=Unexpected data in Results
COMPARE_SOURCEA=Actuals
E=Expected
BUSINESS_UNITVOUCHER_IDPYMNT_CNTORDERBYNUMPYMNT_MESSAGE_CDPrompt Table: PYMNT_MSG_TBL
PYMNT_VCHR_MS_C(SQL Table) |
Index Back |
|---|---|
BTF: Payment Vchr Xref Message |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEST_CASE |
Character(30) | VARCHAR2(30) NOT NULL | BTF Test Case |
| 2 | COMPARE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results |
| 3 | COMPARE_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals E=Expected |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 6 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 7 | ORDERBYNUM |
Number(3,0) | SMALLINT NOT NULL | Order-By Number |
| 8 | PYMNT_MESSAGE_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Message Code
Prompt Table: PYMNT_MSG_TBL |