RB_IMPSPEC_AET(SQL Table) |
Index Back |
|---|---|
Import AET TableThis is the AET table used for Data Import App Engine. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | LI_IMPORT_ID | Character(31) | VARCHAR2(31) NOT NULL | Import ID |
| 4 | LI_MATCHING_ID | Character(31) | VARCHAR2(31) NOT NULL | matching spec id |
| 5 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
| 6 | SQL_STMT_2540 | Long Character(2540) | CLOB | SQL Statement length 2540 |
| 7 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 9 | SEQUENCE | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 10 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 11 | DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Done Flag |
| 12 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 13 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 14 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 15 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 16 | ATTACHERRUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Error file name that user sees. |
| 17 | ATTACHERRSYSFILE | Character(128) | VARCHAR2(128) NOT NULL | Unique System Error File Name |
| 18 | LI_NUM_REJECTS | Number(10,0) | DECIMAL(10) NOT NULL | the number of record rejections in a given file import run |
| 19 | INPUT_ROW_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Input Row Number |
| 20 | PREV_ROW_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Input Row Number |
| 21 | SOURCE_ROW_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Input Row Number |
| 22 | MAX_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Maximum Sequence Number |
| 23 | 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 |
| 24 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Record 1 Name |
| 25 | EOEW_ETL_SEQNUM | Number(10,0) | DECIMAL(10) NOT NULL | Sequence |
| 26 | EOEW_ERR_MSG01 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 27 | EOEW_ERR_MSG02 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 28 | EOEW_ERR_MSG03 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 29 | EOEW_ERR_MSG04 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 30 | EOEW_ERR_MSG05 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 31 | EOEW_ERR_MSG06 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 32 | EOEW_ERR_MSG07 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 33 | EOEW_ERR_MSG08 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 34 | EOEW_ERR_MSG09 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 35 | EOEW_ERR_MSG10 | Character(11) | VARCHAR2(11) NOT NULL | For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201". |
| 36 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 37 | RA_LIST_ID | Character(15) | VARCHAR2(15) NOT NULL | Audience ID |
| 38 | LI_HEADER_FLAG | Character(1) | VARCHAR2(1) NOT NULL | does the file have a header? |
| 39 | LI_HEADER_ROW_NUM | Number(3,0) | SMALLINT NOT NULL | what row contains the header? |
| 40 | FIELD_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Alias name for input source fields |
| 41 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 42 | IS_SUCCESSFUL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
IS_SUCCESSFUL_FLG
N=No Y=Yes |
| 43 | RB_UPD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Update upgrade flag and save |
| 44 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 45 | IS_TESTING | Character(1) | VARCHAR2(1) NOT NULL | IS_TESTING |
| 46 | LI_TOT_MATCHES | Number(10,0) | DECIMAL(10) NOT NULL | the number of matches in a list import |
| 47 | LI_AMB_MATCHES | Number(10,0) | DECIMAL(10) NOT NULL | the number of matches in a list import |
| 48 | ROW_CNT | Number(18,0) | DECIMAL(18) NOT NULL | Audience Row Count |
| 49 | BASIC_DATA_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enabled for Basic Data
N=No Y=Yes |
| 50 | RB_IMPT_PROC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process type for RBIMPORT
A=All Done C=Complete Copy Stage D=Done Stage Import M=Multiple Import N=Normal Data Import S=Stage Only W=Waiting for Stages |
| 51 | FILE_NUMBER | Number(3,0) | SMALLINT NOT NULL | File Number |
| 52 | GROUP_ROW_CNT | Number(18,0) | DECIMAL(18) NOT NULL | Audience Row Count |
| 53 | CDH_IND | Number(3,0) | SMALLINT NOT NULL | Use by RB_IMPSPEC_AET record to indicate if something is CDH |
| 54 | LI_TARGET_ID | Character(31) | VARCHAR2(31) NOT NULL | field target identifier |