Table B-1 AIF_BALANCE_RULESの定義
| AIF_BALANCE_RULESの列 | AIF_BALANCE_RULESの定義 |
|---|---|
| RULE_ID | NUMBER(15,0) NOT NULL ENABLE |
| RULE_NAME | VARCHAR2(80 CHAR) NOT NULL ENABLE |
| PARTITIONKEY | NUMBER(10,0) |
| CATKEY | NUMBER(10,0) |
| APPLICATION_ID | NUMBER(15,0) NOT NULL ENABLE |
| SOURCE_SYSTEM_ID | NUMBER(15,0) NOT NULL ENABLE |
| SOURCE_LEDGER_ID | NUMBER(15,0) |
| IMPGROUPKEY | VARCHAR2(20 CHAR) |
| PLAN_TYPE | VARCHAR2(30 CHAR) |
| SOURCE_APP_PLAN_TYPE | VARCHAR2(30 CHAR) |
| MULTI_PERIOD_FILE_FLAG | VARCHAR2(1 CHAR) |
| RULE_DESCRIPTION | VARCHAR2(400 CHAR) |
| STATUS | VARCHAR2(30 CHAR) |
| FILE_NAME_STATIC | VARCHAR2(256 CHAR) |
| FILE_PATH | VARCHAR2(256 CHAR) |
| FILE_NAME_DATE_FORMAT | VARCHAR2(30 CHAR) |
| FILE_NAME_SUFFIX_TYPE | VARCHAR2(30 CHAR) |
| PERIOD_MAPPING_TYPE | VARCHAR2(30 CHAR) |
| CALENDAR_ID | VARCHAR2(100 CHAR) |
| RULE_ATTR1 | VARCHAR2(100 CHAR) |
| RULE_ATTR2 | VARCHAR2(100 CHAR) |
| RULE_ATTR3 | VARCHAR2(100 CHAR) |
| RULE_ATTR4 | VARCHAR2(100 CHAR) |
| DIRECT_FILE_LOAD_FLAG | VARCHAR2(1 CHAR) |
| LEDGER_GROUP | VARCHAR2(10 CHAR) |
| INCL_ZERO_BALANCE_FLAG | VARCHAR2(1 CHAR) |
| BALANCE_SELECTION | VARCHAR2(30 CHAR) |
| AMOUNT_TYPE | VARCHAR2(30 CHAR) |
| BALANCE_METHOD_CODE | VARCHAR2(30 CHAR) |
| BALANCE_TYPE | VARCHAR2(1 CHAR) |
| BAL_SEG_VALUE_OPTION_CODE | VARCHAR2(30 CHAR) |
| EXCHANGE_RATE_OPTION_CODE | VARCHAR2(30 CHAR) |
| EXCHANGE_BEGIN_RATE_TYPE | VARCHAR2(30 CHAR) |
| EXCHANGE_END_RATE_TYPE | VARCHAR2(30 CHAR) |
| EXCHANGE_AVERAGE_RATE_TYPE | VARCHAR2(30 CHAR) |
| DATA_SYNC_OBJECT | VARCHAR2(255 CHAR) |
| DATA_SYNC_OBJECT_ID | VARCHAR2(50 CHAR) |
| INCLUDE_ADJ_PERIODS_FLAG | VARCHAR2(1 CHAR) |
| BALANCE_AMOUNT_BS | VARCHAR2(10 CHAR) |
| BALANCE_AMOUNT_IS | VARCHAR2(10 CHAR) |
| AS_OF_DATE | DATE |
| BLANK_PERIODKEY | DATE |
| BR_MEMBER_NAME | VARCHAR2(80 CHAR) |
| BR_MEMBER_DISP_NAME | VARCHAR2(80 CHAR) |
| CURRENCY_CODE | VARCHAR2(10 CHAR) |
| DP_MEMBER_NAME | VARCHAR2(80 CHAR) |
| LEDGER_GROUP_ID | NUMBER(15,0) |
| VERSION | VARCHAR2(80 CHAR) |
| SIGNAGE_METHOD | VARCHAR2(30 CHAR) |
| LOAD_OPTIONS | VARCHAR2(2000 CHAR) |
| ICP_LOAD | VARCHAR2(1 CHAR) |