The open interface table is called AIF_OPEN_INTERFACE. The table definition is as follows:
Table G-1 AIF_OPEN_INTERFACE Table Definitions
| Column Name | Data Type | Comment |
|---|---|---|
| BATCH_NAME | VARCHAR2(200 BYTE) | Required. Used to filter the data |
| YEAR | NUMBER(15,0) | Optional. Required if period mapping is Explicit |
| PERIOD | VARCHAR2(30 BYTE) | Optional. Required if period mapping is Explicit |
| PERIOD_NUM | NUMBER(15,0) | Optional. Required if period mapping is Explicit |
| CURRENCY | VARCHAR2(10 BYTE) | Required. |
| DATAVIEW | VARCHAR2(8 BYTE) | Used for HFM applications. Assign value of YTD or Periodic. Default value is YTD |
| DESC1 | VARCHAR2(75 BYTE) | Optional. Mapped to DESC1 |
| DESC2 | VARCHAR2(75 BYTE) | Optional. Mapped to DESC2 |
| AMOUNT | NUMBER(29,12) | Required. Mapped to AMOUNT |
| AMOUNT_YTD | NUMBER(29,12) | Optional. Mapped to AMOUNT_YTD |
| AMOUNT_PTD | NUMBER(29,12) | Optional. Mapped to AMOUNT_PTD |
| COL01 | VARCHAR2(75 BYTE) | Input Source Column 1 |
| COL02 | VARCHAR2(75 BYTE) | Input Source Column 2 |
| COL03 | VARCHAR2(75 BYTE) | Input Source Column 3 |
| …. | ||
| COL30 | VARCHAR2(75 BYTE) | Input Source Column 30 |
| ATTR1 | VARCHAR2(20 BYTE) | Optional. Mapped to ATTR1 |
| ATTR2 | VARCHAR2(20 BYTE) | Optional. Mapped to ATTR2 |
| … | ||
| ATTR13 | VARCHAR2(20 BYTE) | Optional Mapped to ATTR13 |
| ATTR14 | VARCHAR2(20 BYTE) | Reserved. Do not map. |