RB_TEMPLATE(SQL Table) |
Index Back |
|---|---|
Template DefinitionDefines an import template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LI_TEMPLATE_ID |
Character(31) | VARCHAR2(31) NOT NULL |
template identifier
Default Value: NEXT |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | LI_TEMPLATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
what type of import template is this?
01=Manual Template 02=Profile Template 03=Implicit Template 04=Optional Template Default Value: 01 |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | RECORDNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_VENDOR_EC 06=ITM_VNDR_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 11=MANUFACTURER_EC 12=ITEM_MFG_EC 13=EN_REVISION_EC |
| 8 | RA_PROFILE_ID | Number(18,0) | DECIMAL(18) NOT NULL |
Profile - profile ID
Prompt Table: RA_PROF_ACT_VW |