BI_BILL_MSG_TBL(SQL Table) |
Index Back |
---|---|
Billing Msg Table for SF |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW |
2 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | MSG_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
Message Category
Prompt Table: BI_MSG_CAT_TBL |
6 | DESCR254A | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
7 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL | Key Word |
8 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL | Key Word 2 |
9 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL | Key Word 3 |