Table B-1 AIF_BALANCE_RULES-Definitionen
AIF_BALANCE_RULES-Spalte | AIF_BALANCE_RULES-Definition |
---|---|
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) |