VCHR_APPRVL_MSG(SQL Table) |
Index Back |
---|---|
Voucher Payment Approval Msg |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
5 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
6 | EMAIL_SUBJECT_LONG | Character(85) | VARCHAR2(85) NOT NULL | Email Subject |
7 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |