HEADER_IDBATCH_SEQ_NUMPROPERTY_NAMEPMT_BAT_PRP_MAP(SQL Table) |
Index Back |
|---|---|
payment batch propertiespayment batch properties |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HEADER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Header_id |
| 2 | BATCH_SEQ_NUM |
Number(15,0) | DECIMAL(15) NOT NULL | Batch Number |
| 3 | PROPERTY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Property Name |
| 4 | VALUE_TR | Character(254) | VARCHAR2(254) NOT NULL | VALUE_TR field for Treausry sub-system. We have used this field to replace VALUE filed. |