RB_IMPBASIC_AET(SQL Table) |
Index Back |
|---|---|
Common application recordUsed as Application Engine State Record by RB_BASIC_UPD (AE Application ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | USE_PRIMARY_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Use Primary Name
N=No Y=Yes |
| 3 | NAME_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Business Object Name Type |
| 4 | CM_PURPOSE_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Relationship Contact Method Purpose ID |
| 5 | BO_CM_USE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Use type of a Busines Object's Contact Method.
E=Business Object Relationship R=Business Object Role U=Contact Method Usage |
| 6 | USE_PRIMARY_CM | Character(1) | VARCHAR2(1) NOT NULL |
Use Primary Contact Method
N=No Y=Yes |
| 7 | CM_USE_ID | Number(6,0) | INTEGER NOT NULL | Relationship Contact Method Purpose ID |
| 8 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 9 | REL_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 10 | 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 |
| 11 | TO_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name |
| 12 | BAS_FIELDLIST | Long Character(1024) | VARCHAR2(1024) | Field List for Basic Data |
| 13 | CM_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Contact Method Type ID |