BO_REQ_TMPLT(SQL Table) |
Index Back |
---|---|
FSR TemplateFinancial Structure Request Template |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name 1
Prompt Table: FLD_REQ_SFLD_VW |
3 | BO_REQ_TMPLT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Financial Structure Request Template Type
C=ChartField T=Tree Only Default Value: C |
4 | BO_REQ_TMPLT_NAME | Character(60) | VARCHAR2(60) NOT NULL | Financial Structure Request Template Name |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
6 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table: RECDEFN_VW |
7 | GL_ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Role Name
Prompt Table: ROLE_USRLST_VW |
8 | GL_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By |
9 | GL_ENTERED_DTTM | DateTime(26) | TIMESTAMP | Entered Date/Time |
10 | GL_UPDATED_BY | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
11 | GL_UPDATED_DTTM | DateTime(26) | TIMESTAMP | Updated Date/Time |
12 | GL_DESCRLONG | Long Character | CLOB | Long Description |