OracleEBS中文数据字典.doc

OracleOracle ERPERP 数据字典数据字典 i 内容索引内容索引内容索引内容索引 1总概总概 1 1 1数据关系图 1 2基础信息基础信息 2 2 1数据关系图 2 2 2数据表简述 3 2 3数据表明细 3 2 3 1GL SETS OF BOOKS 3 2 3 2GL PERIOD SETS 5 2 3 3GL PERIODS 5 2 3 4GL CODE COMBINATIONS 6 3日记帐日记帐 8 3 1数据关系图 8 3 2数据表简述 8 3 3数据表明细 9 3 3 1GL JE BATCHES 9 3 3 2GL JE HEADERS 10 3 3 3GL JE LINES 12 4日记帐导入日记帐导入 14 4 1数据关系图 14 4 2数据表简述 14 4 3数据表明细 14 4 3 1gl interface 14 1 1 1 1 总概总概总概总概 1 11 1数据关系图数据关系图 2 1 21 2数据表简述数据表简述 表名描述相关视图备注 GL BALANCES余额表 1 31 3数据表明细数据表明细 1 3 1GL BALANCES 名称类型可为空描述 SET OF BOOKS IDNUMBER 15 帐薄 Id CODE COMBINATION IDNUMBER 15 帐户 ID CURRENCY CODEVARCHAR2 15 币种 PERIOD NAMEVARCHAR2 15 区间 ACTUAL FLAGVARCHAR2 1 标记 A 实际款 B 预算 款 E 保留款 TRANSLATED FLAGVARCHAR2 1 Y REVALUATION STATUSVARCHAR2 1 Y PERIOD TYPEVARCHAR2 15 Y PERIOD YEARNUMBER 15 Y区间年 四位数字 PERIOD NUMNUMBER 15 Y区间月 PERIOD NET DRNUMBERY本期借方发生额 PERIOD NET CRNUMBERY本期贷方发生额 PERIOD TO DATE ADBNUMBERY QUARTER TO DATE DRNUMBERY QUARTER TO DATE CRNUMBERY QUARTER TO DATE ADBNUMBERY YEAR TO DATE ADBNUMBERY PROJECT TO DATE DRNUMBERY期初借方余额 原币 PROJECT TO DATE CRNUMBERY期初贷方余额 原币 PROJECT TO DATE ADBNUMBERY BEGIN BALANCE DRNUMBERY期初借方余额 原币 BEGIN BALANCE CRNUMBERY期初贷方余额 原币 PERIOD NET DR BEQNUMBERY本期借方余额 本位币 PERIOD NET CR BEQNUMBERY本期贷方余额 本位币 BEGIN BALANCE DR BEQNUMBERY期初借方余额 本位币 BEGIN BALANCE CR BEQNUMBERY期初贷方余额 本位币 TEMPLATE IDNUMBER 15 Y ENCUMBRANCE DOC IDNUMBER 15 Y ENCUMBRANCE LINE NUMNUMBER 15 Y 3 2 2 2 基础信息基础信息基础信息基础信息 2 12 1数据关系图数据关系图 4 2 22 2数据表简述数据表简述 表名描述相关视图备注 5 GL SETS OF BOOKS帐簿表 GL PERIOD SETS总帐日历表 GL PERIODS总帐日历明细表GL PERIODS V GL CODE COMBINATIONS帐户表 2 32 3数据表明细数据表明细 2 3 1GL SETS OF BOOKS 帐簿表 外键 FK 主键表主键列外键列 FND CURRENCIESCURRENCY CODECURRENCY CODE FND ID FLEX STRUCTURESID FLEX NUMCHART OF ACCOUNTS ID GL CODE COMBINATIONSCODE COMBINATION IDCUM TRANS CODE COMBINATION ID GL CODE COMBINATIONSCODE COMBINATION IDRET EARN CODE COMBINATION ID GL CODE COMBINATIONSCODE COMBINATION IDRES ENCUMB CODE COMBINATION I D GL CODE COMBINATIONSCODE COMBINATION IDNET INCOME CODE COMBINATION I D GL CODE COMBINATIONSCODE COMBINATION IDROUNDING CODE COMBINATION ID GL DAILY CONVERSION TYPESCONVERSION TYPEDAILY TRANSLATION RATE TYPE GL PERIOD SETSPERIOD SET NAMEPERIOD SET NAME GL PERIOD TYPESPERIOD TYPEACCOUNTED PERIOD TYPE GL TRANSACTION CALENDARTRANSACTION CALENDAR I D TRANSACTION CALENDAR ID 快速编码列 QuickCodes 列快速编码类型快速编码表 ALLOW INTERCOMPANY POST FLAGYES NO N Y GL LOOKUPS No Yes CONSOLIDATION SOB FLAGYES NO N Y GL LOOKUPS No Yes ENABLE AUTOMATIC TAX FLAGYES NO N Y GL LOOKUPS No Yes ENABLE AVERAGE BALANCES FLAGYES NO N Y GL LOOKUPS No Yes ENABLE BUDGETARY CONTROL FLAGYES NO N Y GL LOOKUPS No Yes ENABLE JE APPROVAL FLAGYES NO N Y GL LOOKUPS No Yes REQUIRE BUDGET JOURNALS FLAGYES NO N Y GL LOOKUPS No Yes SUSPENSE ALLOWED FLAGYES NO N GL LOOKUPS No 6 YYes TRACK ROUNDING IMBALANCE FLAGYES NO N Y GL LOOKUPS No Yes TRANSLATE EOD FLAGYES NO N Y GL LOOKUPS No Yes TRANSLATE QATD FLAGYES NO N Y GL LOOKUPS No Yes TRANSLATE YATD FLAGYES NO N Y GL LOOKUPS No Yes 列描述 名称类型可为空描述 SET OF BOOKS ID PK NUMBER 15 N帐薄 ID CURRENCY CODEVARCHAR2 15 N币种代码 CHART OF ACCOUNTS IDNUMBER 15 N弹性域结构 ID NAMEVARCHAR2 30 N帐簿名称 PERIOD SET NAMEVARCHAR2 15 N帐簿区间 日历 名 SUSPENSE ALLOWED FLAGVARCHAR2 1 N ALLOW POSTING WARNING FLAGVARCHAR2 1 N ACCOUNTED PERIOD TYPEVARCHAR2 15 N SHORT NAMEVARCHAR2 20 N帐簿简程 REQUIRE BUDGET JOURNALS FLAGVARCHAR2 1 N ENABLE BUDGETARY CONTROL FLAGVARCHAR2 1 N ALLOW INTERCOMPANY POST FLAGVARCHAR2 1 N LATEST ENCUMBRANCE YEARNUMBER 15 Y EARLIEST UNTRANS PERIOD NAMEVARCHAR2 15 Y CUM TRANS CODE COMBINATION IDNUMBER 15 Y FUTURE ENTERABLE PERIODS LIMITNUMBER 15 Y LATEST OPENED PERIOD NAMEVARCHAR2 15 Y RET EARN CODE COMBINATION IDNUMBER 15 Y RES ENCUMB CODE COMBINATION IDNUMBER 15 Y DESCRIPTIONVARCHAR2 240 Y ENABLE AVERAGE BALANCES FLAGVARCHAR2 1 N CONSOLIDATION SOB FLAGVARCHAR2 1 N TRANSLATE EOD FLAGVARCHAR2 1 N TRANSLATE QATD FLAGVARCHAR2 1 N TRANSLATE YATD FLAGVARCHAR2 1 N TRANSACTION CALENDAR IDNUMBER 15 Y DAILY TRANSLATION RATE TYPEVARCHAR2 30 Y NET INCOME CODE COMBINATION IDNUMBER 15 Y 7 GLOBAL ATTRIBUTE CATEGORYVARCHAR2 30 Y GLOBAL ATTRIBUTE1VARCHAR2 150 Y GLOBAL ATTRIBUTE2VARCHAR2 150 Y GLOBAL ATTRIBUTE3VARCHAR2 150 Y GLOBAL ATTRIBUTE4VARCHAR2 150 Y GLOBAL ATTRIBUTE5VARCHAR2 150 Y GLOBAL ATTRIBUTE6VARCHAR2 150 Y GLOBAL ATTRIBUTE7VARCHAR2 150 Y GLOBAL ATTRIBUTE8VARCHAR2 150 Y GLOBAL ATTRIBUTE9VARCHAR2 150 Y GLOBAL ATTRIBUTE10VARCHAR2 150 Y ENABLE AUTOMATIC TAX FLAGVARCHAR2 1 N ENABLE JE APPROVAL FLAGVARCHAR2 1 N MRC SOB TYPE CODEVARCHAR2 1 N TRACK ROUNDING IMBALANCE FLAGVARCHAR2 1 N ROUNDING CODE COMBINATION IDNUMBER 15 Y 2 3 2GL PERIOD SETS 总帐日历表 名称类型可为空描述 PERIOD SET NAME PK VARCHAR2 15 N区间 日历 名 DESCRIPTIONVARCHAR2 240 Y备注 2 3 3GL PERIODS 总帐日历明细表 名称类型可为空描述 PERIOD SET NAME PK VARCHAR2 15 N区间 日历 名 PERIOD NAME PK VARCHAR2 15 N区间 日历 明细名 START DATEDATEN起始日期 END DATEDATEN截至日期 PERIOD TYPEVARCHAR2 15 N区间类型 PERIOD YEARNUMBER 15 N区间年份 PERIOD NUMNUMBER 15 N区间序号 QUARTER NUMNUMBER 15 N区间季节号 ENTERED PERIOD NAMEVARCHAR2 15 N手工输入区间明细名 ADJUSTMENT PERIOD FLAGVARCHAR2 1 N DESCRIPTIONVARCHAR2 240 Y备注 YEAR START DATEDATEY年度起始日期 QUARTER START DATEDATEY季度起始日期 8 2 3 4GL CODE COMBINATIONS 帐户表 用于存放已选择的弹性域段值 累计型帐号 SUMMARY FLAG Y 且TEMPLATE ID not NULL 明细型帐号 SUMMARY FLAG N 且 TEMPLATE ID NULL 外键 FK 主键表主键列外键列 FND ID FLEX STRUCTURE S ID FLEX NUMCHART OF ACCOUNTS I D GL SUMMARY TEMPLATESTEMPLATE IDTEMPLATE ID 快速编码列 QuickCodes 列快速编码类型快速编码表 ACCOUNT TYPE ACCOUNT TYPE A E L O R GL LOOKUPS A E L O R DETAIL BUDGETING ALLOWED FLAGYES NO N Y GL LOOKUPS No Yes DETAIL POSTING ALLOWED FLAGYES NO N Y GL LOOKUPS No Yes PRESERVE FLAGYES NO N Y GL LOOKUPS No Yes REFRESH FLAGYES NO N Y GL LOOKUPS No Yes SUMMARY FLAGYES NO N Y GL LOOKUPS No Yes 列描述 名称类型可为空描述 CODE COMBINATION IDNUMBER 15 N帐户 ID CHART OF ACCOUNTS IDNUMBER 15 N弹性域结构 ID FND ID FLEX STRUCTURES ID FL EX NUM DETAIL POSTING ALLOWED FLAGVARCHAR2 1 N DETAIL BUDGETING ALLOWED FLAGVARCHAR2 1 N ACCOUNT TYPEVARCHAR2 1 N帐号类型 ENABLED FLAGVARCHAR2 1 N启用标志 Y 是 N 非 SUMMARY FLAGVARCHAR2 1 N标识是否是父 累计组标记 Y 是 N 非 SEGMENT1VARCHAR2 25 Y弹性域段值 VARCHAR2 25 Y DESCRIPTIONVARCHAR2 240 Y备注 TEMPLATE IDNUMBER 15 Y 9 ALLOCATION CREATE FLAGVARCHAR2 1 Y START DATE ACTIVEDATEY生效起始日期 END DATE ACTIVEDATEY生效截止日期 ATTRIBUTE1VARCHAR2 150 Y VARCHAR2 150 Y SEGMENT ATTRIBUTE1VARCHAR2 60 Y VARCHAR2 60 Y JGZZ RECON FLAGVARCHAR2 1 Y JGZZ RECON CONTEXTVARCHAR2 30 Y REFERENCE1VARCHAR2 1 Y REFERENCE2VARCHAR2 1 Y REFERENCE3VARCHAR2 1 Y REFERENCE4VARCHAR2 1 Y REFERENCE5VARCHAR2 1 Y PRESERVE FLAGVARCHAR2 1 Y REFRESH FLAGVARCHAR2 1 Y IGI BALANCED BUDGET FLAGVARCHAR2 1 Y COMPANY COST CENTER ORG IDNUMBER 15 Y 10 3 3 3 日记帐日记帐日记帐日记帐 3 13 1数据关系图数据关系图 3 2数据表简述数据表简述 表名描述相关视图备注 GL JE BATCHES批次表 GL JE HEADERS凭证头表 11 GL JE LINES凭证分录表 GL JE CATEGORIES TL GL JE SOURCES TL GL ENCUMBRANCE TYPES 3 3数据表明细数据表明细 3 3 1GL JE BATCHES 批次表 外键 FK 主键表主键列外键列 FND CONCURRENT REQUEST S REQUEST IDREQUEST ID GL JE BATCHESJE BATCH IDPARENT JE BATCH ID GL PERIODSPERIOD NAMEDEFAULT PERIOD NAME GL SETS OF BOOKSSET OF BOOKS IDSET OF BOOKS ID 快速编码列 QuickCodes 列快速编码类型快速编码表 ACTUAL FLAGBATCH TYPE A B E GL LOOKUPS A B E APPROVAL STATUS CODEJE BATCH APPROVAL STATUS A I J R V Z GL LOOKUPS Approved In Rejected Required Validation N A AVERAGE JOURNAL FLAGAB JOURNAL TYPEGL LOOKUPS NNo YYes 列描述 名称类型可为空描述 JE BATCH IDNUMBER 15 N批次 ID SET OF BOOKS IDNUMBER 15 N帐薄 ID NAMEVARCHAR2 100 N 12 STATUSVARCHAR2 1 N STATUS VERIFIEDVARCHAR2 1 N ACTUAL FLAGVARCHAR2 1 N DEFAULT EFFECTIVE DATEDATEN BUDGETARY CONTROL STATUSVARCHAR2 1 N STATUS RESET FLAGVARCHAR2 1 Y DEFAULT PERIOD NAMEVARCHAR2 15 Y UNIQUE DATEVARCHAR2 30 Y EARLIEST POSTABLE DATEDATEY POSTED DATEDATEY DATE CREATEDDATEY DESCRIPTIONVARCHAR2 240 Y CONTROL TOTALNUMBERY RUNNING TOTAL DRNUMBERY RUNNING TOTAL CRNUMBERY RUNNING TOTAL ACCOUNTED DRNUMBERY RUNNING TOTAL ACCOUNTED CRNUMBERY ATTRIBUTE1VARCHAR2 150 Y PACKET IDNUMBER 15 Y USSGL TRANSACTION CODEVARCHAR2 30 Y CONTEXT2VARCHAR2 150 Y POSTING RUN IDNUMBER 15 Y REQUEST IDNUMBER 15 Y UNRESERVATION PACKET IDNUMBER 15 Y AVERAGE JOURNAL FLAGVARCHAR2 1 N ORG IDNUMBER 15 Y APPROVAL STATUS CODEVARCHAR2 1 N PARENT JE BATCH IDNUMBER 15 Y 3 3 2GL JE HEADERS 凭证头表 名称类型可为空描述 JE HEADER IDNUMBER 15 凭证头 ID SET OF BOOKS IDNUMBER 15 帐薄 ID JE CATEGORYVARCHAR2 25 JE SOURCEVARCHAR2 25 PERIOD NAMEVARCHAR2 15 区间 NAMEVARCHAR2 100 CURRENCY CODEVARCHAR2 15 STATUSVARCHAR2 1 过帐标记 P 已过帐 U 未过帐 13 DATE CREATEDDATE DATE CREATEDDATE ACCRUAL REV FLAGVARCHAR2 1 MULTI BAL SEG FLAGVARCHAR2 1 ACTUAL FLAGVARCHAR2 1 凭证类别标记 A 实际款 B 预算 款 DEFAULT EFFECTIVE DATEDATE TAX STATUS CODEVARCHAR2 1 CONVERSION FLAGVARCHAR2 1 Y CREATION DATEDATEY CREATED BYNUMBER 15 Y LAST UPDATE LOGINNUMBER 15 Y ENCUMBRANCE TYPE IDNUMBER 15 Y BUDGET VERSION IDNUMBER 15 Y BALANCED JE FLAGVARCHAR2 1 Y BALANCING SEGMENT VALUEVARCHAR2 25 Y JE BATCH IDNUMBER 15 Y FROM RECURRING HEADER IDNUMBER 15 Y UNIQUE DATEVARCHAR2 30 Y EARLIEST POSTABLE DATEDATEY POSTED DATEDATEY ACCRUAL REV EFFECTIVE DATEDATEY ACCRUAL REV PERIOD NAMEVARCHAR2 15 Y ACCRUAL REV STATUSVARCHAR2 1 Y ACCRUAL REV JE HEADER IDNUMBER 15 Y ACCRUAL REV CHANGE SIGN FLAGVARCHAR2 1 DESCRIPTIONVARCHAR2 240 Y CONTROL TOTALNUMBERY RUNNING TOTAL DRNUMBERY RUNNING TOTAL CRNUMBERY RUNNING TOTAL ACCOUNTED DRNUMBERY RUNNING TOTAL ACCOUNTED CRNUMBERY CURRENCY CONVERSION RATENUMBERY CURRENCY CONVERSION TYPEVARCHAR2 30 Y CURRENCY CONVERSION DATEDATEY EXTERNAL REFERENCEVARCHAR2 80 Y PARENT JE HEADER IDNUMBER 15 Y REVERSED JE HEADER IDNUMBER 15 Y ORIGINATING BAL SEG VALUEVARCHAR2 25 Y INTERCOMPANY MODENUMBER 15 Y DR BAL SEG VALUEVARCHAR2 25 Y 14 CR BAL SEG VALUEVARCHAR2 25 Y USSGL TRANSACTION CODEVARCHAR2 30 Y CONTEXT2VARCHAR2 150 Y DOC SEQUENCE IDNUMBERY DOC SEQUENCE VALUENUMBERY JGZZ RECON CONTEXTVARCHAR2 30 Y JGZZ RECON REFVARCHAR2 240 Y 3 3 3GL JE LINES 凭证分录表 名称类型可为空描述 JE HEADER IDNUMBER 15 凭证头 ID JE LINE NUMNUMBER 15 SET OF BOOKS IDNUMBER 15 帐薄 ID CODE COMBINATION IDNUMBER 15 帐户 ID PERIOD NAMEVARCHAR2 15 EFFECTIVE DATEDATE STATUSVARCHAR2 1 ENTERED DRNUMBERY录入借方 ENTERED CRNUMBERY录入贷方 ACCOUNTED DRNUMBERY本位币借方 ACCOUNTED CRNUMBERY本位币贷方 DESCRIPTIONVARCHAR2 240 Y LINE TYPE CODEVARCHAR2 20 Y INVOICE DATEDATEY TAX CODEVARCHAR2 15 Y INVOICE IDENTIFIERVARCHAR2 20 Y INVOICE AMOUNTNUMBERY NO1VARCHAR2 150 Y STAT AMOUNTNUMBERY IGNORE RATE FLAGVARCHAR2 1 Y USSGL TRANSACTION CODEVARCHAR2 30 Y SUBLEDGER DOC SEQUENCE IDNUMBERY SUBLEDGER DOC SEQUENCE VALUENUMBERY GL SL LINK IDNUMBERY GL SL LINK TABLEVARCHAR2 30 Y JGZZ RECON STATUSVARCHAR2 1 Y JGZZ RECON DATEDATEY JGZZ RECON IDNUMBERY JGZZ RECON REFVARCHAR2 240 Y JGZZ RECON CONTEXTVARCHAR2 30 Y 15 TAXABLE LINE FLAGVARCHAR2 1 Y TAX TYPE CODEVARCHAR2 1 Y TAX CODE IDNUMBER 15 Y TAX ROUNDING RULE CODEVARCHAR2 1 Y AMOUNT INCLUDES TAX FLA