跟日记帐录入相关的表
Journal Import Overview:
flow:
Subledgers(子类帐--子模块:AP,AR and so on)--->gl_interface data table--->5 N% Q8 K' X5 h* { {0 Y0 W+ I
journal import--->gl_je_batches/gl_je_headers/gl_je_lines data tables --->oracle assetsERP, SAP, Oracle ERP,用友,金蝶: j3 j, ~' m& W) q: F
Journal Creation Methods:bbs.erp100.com$ ?5 b/ @& H: W, ]4 V' Y6 n: g, f
Within Oracle General Ledger, you can work with the following types of journal entries:
-- Manual Journal Entries: Basic journal entry type used for most accounting transactions.Erp100论坛5 r' X: E" {5 l: J
Examples include adjustments and reclassifications.
-- Reversing Journal Entries: Entries are created by reversing an existing journal entry.
You can reverse any journal entry and post it to the current or any future open accounting& C, K: O/ h- v! c7 }
period.
-- Recurring Journal Entries: Entries are defined once, then are repeated for each
subsequent accounting period you generate. You can use recurring journal entries to
define automatic consolidating and eliminating entries.ERP, SAP, Oracle ERP,用友,金蝶8 W$ r7 P, }3 P) ?9 v% |( c
-- Mass Allocations: Entries utilize a single journal entry formula to allocate balances
across a group of cost centers, departments, divisions or other segments. Examples4 a( O4 [! n! P' D1 @( J
include rent expense allocated by headcount or administrative costs allocated by machinebbs.erp100.com) B7 S" d# @( G$ F5 C
labor hours.1 W- n! v6 W0 U) h1 |
-- Journal Import: Imports of journal entry information from feeder systems.
-- Journal Wizard (ADI): Upload journal entries from an Excel spreadsheet.
9 H- _8 K P9 L7 S+ F
Journal Posting:
-- Batch Posting: Navigate to the Post Journals window to post a group of journal batches.
-- Manual Posting: Select the More Actions button from either the Journals window or the2 u( y @4 L, b. K0 ^- L2 {
Batch window to post a journal batch at the time of entry. This option is available only if0 Z) V1 ?$ e+ s; o' M' p
the profile option Journals: Allow Posting During Journal Entry has been set to Yes.
When you post journals, Oracle General Ledger posts all journals in a batch. You cannotErp100论坛8 M v, k- Z f3 e" L! A# m4 J6 t
post individual journal entries in a batch.
-- Automatic Posting: Run the AutoPost program to post journal batches automatically
based on a schedule you define.ERP, SAP, Oracle ERP,用友,金蝶3 I* _7 K$ H9 f- O2 ]
Journal Posting Status
Correcting Batch Posting Errors: Review the batch to identify the posting error. Common
explanations for unpostable batches include:ERP, SAP, Oracle ERP,用友,金蝶; m% Y& i y8 W8 E2 S$ S
-- Control total violations
-- Posting to unopened periods
-- Unbalanced journal entriesErp100论坛! Q6 Y) E9 G8 _3 m* F6 o
Correct the specific error and post the batch from the More Actions window.Erp100论坛, k" }* X6 ^% {* R9 s) a/ H. F
Posting Status:
Unposted Pending
Processing Selected for postingERP, SAP, Oracle ERP,用友,金蝶& a7 D% U2 s0 Z& _2 [
Posted Error
Approved In Process
ERP, SAP, Oracle ERP,用友,金蝶" C# ~+ C- R% M% ~
ERP, SAP, Oracle ERP,用友,金蝶) ?3 /( C6 p% _* O/ H: S! }
Journal Entry TablesErp100论坛# L7 B& |# q/ u7 V+ F3 x# [* J2 B
The major tables storing journal entries related information are as follows:
-- GL_JE_BATCHESERP, SAP, Oracle ERP,用友,金蝶0 ] G3 t: _' G' J- Q
-- GL_JE_HEADERSERP, SAP, Oracle ERP,用友,金蝶, |( w6 | q/ k3 M: {7 ~8 N/ /: a
-- GL_JE_LINES) l8 j0 ?$ w% P
-- GL_CODE_COMBINATIONS
-- GL_BALANCES
GL_CODE_COMBINATIONS
Refer to the previous section, Identifying Currency, Calendar and Chart of Accounts Tables,
for a discussion of this table.-最专业的ERP社区,帮助你在ERP行业实现价值!0 |& t2 p3 A* |( W2 J2 L: j
A one-to-many relationship exists between GL_BALANCES table and GL_JE_LINES table.bbs.erp100.com% Q N: R( |& M7 s( r. ~) }
However, there is no direct relation between the other tables.
GL_JE_BATCHES:-最专业的ERP社区,帮助你在ERP行业实现价值!3 /" U4 e9 @3 t. s+ t
--this table stores details of journal entry batches.
--a batch is a grouping of journal entries * C, x6 F I, k9 m }5 [
--in general ledger,journal entries are posted in batches.
--each row in this table includes the batch name, status,running total debits
and credits for all entries in the batch ,and other information.
(N) Journals > Enter (B) New Batchbbs.erp100.com( T% Q2 z- d2 W( Z
-- JE_BATCH_ID (PK)ERP, SAP, Oracle ERP,用友,金蝶: s$ X0 H; U% /& L2 b
-- NAME
-- STATUS: Posted or Unposted
-- ACTUAL_FLAG: A = Actuals, B= Budgets, E = Encumbrance
-- DEFAULT_PERIOD_NAME
-- POSTED_DATE( z+ i4 ]" F- u: ^1 G
-- DESCRIPTION
-- SET_OF_BOOKS_ID
-- POSTING_RUN_ID: Posting sequence numberERP, SAP, Oracle ERP,用友,金蝶$ i L: Q2 }: c8 B* S0 V; r5 B
-- RUNNING_TOTAL_DR-最专业的ERP社区,帮助你在ERP行业实现价值!$ p: K* m# L: P, e6 L& |% z
-- RUNNING_TOTAL_CR
-- RUNNING_TOTAL_ACCOUNTED_DR
-- RUNNING_TOTAL_ACCOUNTED_CRErp100论坛" h: K& w4 Z2 /
Foreign KeysERP, SAP, Oracle ERP,用友,金蝶8 _. r T/ s. D$ h3 E, N+ p
Primary Key Table Primary Key Column Foreign Key Column FND_CONCURRENT_ REQUEST_ID REQUEST_ID
REQUESTS
GL_JE_BATCHES JE_BATCH_ID PARENT_JE_BATCH_IDbbs.erp100.com7 ]/ M. V! f7 c- [ {
GL_PERIODS PERIOD_NAME DEFAULT_PERIOD_NAME
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID
------------------------------------------------------------------------------------------------
GL_JE_HEADERS:
--this table stores journal entry information.bbs.erp100.com0 e9 i! h+ b2 Q) Y$ D& O! Y! O
--there is a one-to-many relationship between journal entry batches and journal entries.Erp100论坛2 H! ^/ K% g- A: t
--each row in this table includes the associated batch id ,journal entry name and description,ERP, SAP, Oracle ERP,用友,金蝶5 d3 p' k4 }, i K$ `2 R
and other information about the journal entry.
(N) Journals > Enter (B) New JournalErp100论坛% K+ u+ |( V4 L* g) b
Major Columns
-- JE_HEADER_ID (PK)Erp100论坛# @+ ~0 Q) W% j3 s; j$ {$ Q9 J
-- SET_OF_BOOKS_ID6 e' l; { o( x0 L0 o
-- JE_CATEGORY7 v a0 F/ l/ |
-- JE_SOURCE
-- PERIOD_NAME-最专业的ERP社区,帮助你在ERP行业实现价值!7 U" s" {* M" J, U* k+ F B
-- NAME
-- RUNNING_TOTAL_DR$ L/ A0 |& E" [3 b- r- V
-- RUNNING_TOTAL_CR
-- RUNNING_TOTAL_ACCOUNTED_DR5 L0 u2 X ~/ ^. t! D( D8 ?* z$ t
-- RUNNING_TOTAL_ACCOUNTED_CRErp100论坛1 d. z1 g& o D0 J a
-- STATUS
-- ACTUAL_FLAG
-- JE_BATCH_IDERP, SAP, Oracle ERP,用友,金蝶4 h7 ?: b5 J6 V4 v3 Z
-- POSTED_DATE2 p3 x' e1 P' t8 @
-- DESCRIPTION
-- CURRENCY_CODE-最专业的ERP社区,帮助你在ERP行业实现价值!. t7 b; A. y/ m5 U) f5 n
Foreign Keys-最专业的ERP社区,帮助你在ERP行业实现价值!+ o0 {9 q+ K* I. v
Primary Key Table Primary Key Column Foreign Key Column
FND_CURRENCIES CURRENCY_CODE CURRENCY_CODEERP, SAP, Oracle ERP,用友,金蝶/ L [- M* m$ v' c, /* z( B( X+ x0 ]
FND_FLEX_VALUES FLEX_VALUE ORIGINATING_BAL_SEG_VALUE
FND_FLEX_VALUES FLEX_VALUE DR_BAL_SEG_VALUE
FND_FLEX_VALUES FLEX_VALUE CR_BAL_SEG_VALUEbbs.erp100.com8 g$ V3 /8 V: `. V! X5 m0 J* J
GL_BUDGET_VERSIONS BUDGET_VERSION_ID BUDGET_VERSION_ID
GL_DAILY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPES CONVERSION_TYPE
GL_ENCUMBRANCE_ENCUMBRANCE_ENCUMBRANCE_TYPES TYPE_ID TYPE_IDERP, SAP, Oracle ERP,用友,金蝶% O& Z9 f. q; ]! a0 {8 K
GL_JE_BATCHES JE_BATCH_ID JE_BATCH_IDERP, SAP, Oracle ERP,用友,金蝶3 s" c: ?7 k2 p; O6 F& Z
GL_JE CATEGORIES_TL JE_CATEGORY_NAME JE_CATEGORY2 y) W) D( z- c7 h1 j8 g
GL_JE_HEADERS JE_HEADER_ID ACCRUAL_REV_JE_HEADER_ID
GL_JE_HEADERS JE_HEADER_ID PARENT_JE_HEADER_ID E1 l8 |& B" _8 p; X
GL_JE_HEADERS JE_HEADER_ID REVERSED_JE_HEADER_IDbbs.erp100.com( J6 F9 a/ k4 T3 _; p
GL_JE_SOURCES_TL JE_SOURCE_NAME JE_SOURCE
GL_RECURRING_RECURRING_ FROM_RECURRING_HEADERS HEADER_ID HEADER_ID
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID
--------------------------------------------------------------------------------------------------
GL_JE_LINES
--this table stores journal entry lines.ERP, SAP, Oracle ERP,用友,金蝶! r8 ?+ j4 N! n5 c/ l, L T
--there is a one-to-many relationship between journal entries headers and journalErp100论坛: d. u, E6 N3 _
entry line./ n4 `- O: K: [; `9 V4 {8 |
--this table contain the information about the account and amount for each line of the : w' M- Q8 M+ J1 R8 L
entry.) m' L+ S5 /" n* S' v8 g6 N' u
(N) Journals > Enter (B) New Journal-最专业的ERP社区,帮助你在ERP行业实现价值!: O( f# U& V, e+ M7 p' v N& J
Major Columns' d4 P* B0 l7 M
-- JE_HEADER_ID (PK)
-- JE_LINE_NUM (PK)Erp100论坛/ /' {3 b1 E( u; y0 N9 h
-- SET_OF_BOOKS_IDbbs.erp100.com& u0 h" X2 d; @0 c: c& A
-- CODE_COMBINATION_ID* [5 e j# P- @! T" H8 x
-- PERIOD_NAME0 j8 Y; B7 h6 ]4 K: h
-- EFFECTIVE _DATE. f- U2 Z. ?5 }* B, B$ p
-- STATUSErp100论坛& H' r6 a, C, b0 L5 y
-- ENTERED_DR
-- ENTERED_CR
-- ACCOUNTED_DRErp100论坛4 ~- l0 h" M4 p+ W& v" Y2 t5 `
-- ACCOUNTED_CR
-- DESCRIPTION
-- STAT_AMOUNTErp100论坛& w3 k. }9 T/ X# @# o7 L
ENTERED_DR and ENTERED_CR store the value of the entered currency;
ACCOUNTED_DR and ACCOUNTED_CR store the value of the calculated journal in the
base currency.Erp100论坛3 D: u0 P$ `. v" n" n
Foreign Keysbbs.erp100.com- s/ {3 j9 m' {+ r
Primary Key Table Primary Key Column Foreign Key Columnbbs.erp100.com5 u/ Y8 {# ]/ ~9 u, a! ?. H9 V
GL_CODE_COMBINATIONS CODE_COMBINATION_ID CODE_COMBINATION_IDErp100论坛( p! ~, @8 F! @/ A$ w
GL_JE_HEADERS JE_HEADER_ID JE_HEADER_ID
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID
GL_USSGL_ USSGL_ USSGL_& /# B( t) O3 e. H
TRANSACTION_CODES TRANSACTION_CODE TRANSACTION_CODE-最专业的ERP社区,帮助你在ERP行业实现价值!' h% O4 V, G- Q
-------------------------------------------------------------------------------------------6 q* e9 m' e7 |! c/ M R9 |! V
GL_BALANCES:Note: This table stores activity rather than the actual balance
-- this table stores net debit (净借记)and net credit (净贷记)information for detail and
summary accounts.bbs.erp100.com% @1 /! J i( [5 A& ?/ N* u
-- the information is stored as actual, budget,and encumbrance amounts, it also stores
functional currency,foreign currency ,and statistical balances for each accounting period0 I/ Y7 r1 U! q5 K
that has ever been opened.-最专业的ERP社区,帮助你在ERP行业实现价值!; c! _" @; M# S5 O
--GL_BALANCES is populated by the system during the GL Post and Summary Account TemplateErp100论坛5 /" F: r2 J# R' p, /6 [
Defination-最专业的ERP社区,帮助你在ERP行业实现价值!- f2 [( }3 K& W+ V9 A2 c3 F1 i
--it is used for standard account inquiries and for Financial Statement Generator(FSG)reportingERP, SAP, Oracle ERP,用友,金蝶& X' n; J0 Q2 K# n k, F4 u
Use the following formula to calculate the period-to-date balance:
-- (PERIOD_NET_DR - PERIOD_NET_CR) = Period-to-Date Balance
Use the following formula to calculate the year-to-date balance:
-- (BEGIN_BALANCE_DR - BEGIN_BALANCE_CR)+(PERIOD_NET_DR - PERIOD_NET_CR) = Year-to-Date Balance0 c/ c0 A9 H7 W8 X3 H, q
Major Columns7 z( U. B! F2 z: s3 W* r. J
-- SET_OF_BOOKS_ID (PK)
-- CODE_COMBINATION_ID (PK)
-- CURRENCY_CODE (PK)-最专业的ERP社区,帮助你在ERP行业实现价值!3 Y6 m, J6 A% n$ G4 ^! k. f
-- PERIOD_NAME (PK)
-- ACTUAL_FLAG (PK)-最专业的ERP社区,帮助你在ERP行业实现价值!8 ^% y# N6 z: K5 N" j
-- ENCUMBRANCE_TYPE_ID (PK)
-- TRANSLATED_FLAG (PK); Q Z% J. f* X& p; o# e b
-- BUDGET_VERSION_ID (PK)
-- PERIOD_NET_DR
-- PERIOD_NET_CR
-- QUARTER_TO_DATE_DR
-- QUARTER_TO_DATE_CR8 e. K7 X$ f, J0 T( x- s* w0 q
-- PROJECT_TO_DATE_DRERP, SAP, Oracle ERP,用友,金蝶* C9 Y! @4 U. X3 i4 _
-- PROJECT_TO_DATE_CR
-- BEGIN_BALANCE_DR
-- BEGIN_BALANCE_CR
-- TEMPLATE_ID
Note: PROJECT_TO_DATE_DR and PROJECT_TO_DATE_CR columns retain the life-todate balance6 s6 G9 v* Z. T: Q+ I; a( x6 e
Foreign Keys
Primary Key Table Primary Key Column Foreign Key Column
FND_CURRENCIES CURRENCY_CODE CURRENCY_CODE
GL_BUDGET_VERSION BUDGET_VERSION_ID BUDGET_VERSION_ID
GL_CODE_COMBINATIONS CODE_COMBINATION_ID CODE_COMBINATION_ID
GL_ENCUMBRANCE_TYPES ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
GL_PERIOD_TYPES PERIOD_TYPE PERIOD_TYPE* i1 Q1 {3 |( Y: i8 _
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID-最专业的ERP社区,帮助你在ERP行业实现价值!$ f3 M7 s, x$ s/ L# j. b" M/ n
GL_SUMMARY_TEMPLATES TEMPLATE_ID TEMPLATE_ID
flow:
Subledgers(子类帐--子模块:AP,AR and so on)--->gl_interface data table--->5 N% Q8 K' X5 h* { {0 Y0 W+ I
journal import--->gl_je_batches/gl_je_headers/gl_je_lines data tables --->oracle assetsERP, SAP, Oracle ERP,用友,金蝶: j3 j, ~' m& W) q: F
Journal Creation Methods:bbs.erp100.com$ ?5 b/ @& H: W, ]4 V' Y6 n: g, f
Within Oracle General Ledger, you can work with the following types of journal entries:
-- Manual Journal Entries: Basic journal entry type used for most accounting transactions.Erp100论坛5 r' X: E" {5 l: J
Examples include adjustments and reclassifications.
-- Reversing Journal Entries: Entries are created by reversing an existing journal entry.
You can reverse any journal entry and post it to the current or any future open accounting& C, K: O/ h- v! c7 }
period.
-- Recurring Journal Entries: Entries are defined once, then are repeated for each
subsequent accounting period you generate. You can use recurring journal entries to
define automatic consolidating and eliminating entries.ERP, SAP, Oracle ERP,用友,金蝶8 W$ r7 P, }3 P) ?9 v% |( c
-- Mass Allocations: Entries utilize a single journal entry formula to allocate balances
across a group of cost centers, departments, divisions or other segments. Examples4 a( O4 [! n! P' D1 @( J
include rent expense allocated by headcount or administrative costs allocated by machinebbs.erp100.com) B7 S" d# @( G$ F5 C
labor hours.1 W- n! v6 W0 U) h1 |
-- Journal Import: Imports of journal entry information from feeder systems.
-- Journal Wizard (ADI): Upload journal entries from an Excel spreadsheet.
9 H- _8 K P9 L7 S+ F
Journal Posting:
-- Batch Posting: Navigate to the Post Journals window to post a group of journal batches.
-- Manual Posting: Select the More Actions button from either the Journals window or the2 u( y @4 L, b. K0 ^- L2 {
Batch window to post a journal batch at the time of entry. This option is available only if0 Z) V1 ?$ e+ s; o' M' p
the profile option Journals: Allow Posting During Journal Entry has been set to Yes.
When you post journals, Oracle General Ledger posts all journals in a batch. You cannotErp100论坛8 M v, k- Z f3 e" L! A# m4 J6 t
post individual journal entries in a batch.
-- Automatic Posting: Run the AutoPost program to post journal batches automatically
based on a schedule you define.ERP, SAP, Oracle ERP,用友,金蝶3 I* _7 K$ H9 f- O2 ]
Journal Posting Status
Correcting Batch Posting Errors: Review the batch to identify the posting error. Common
explanations for unpostable batches include:ERP, SAP, Oracle ERP,用友,金蝶; m% Y& i y8 W8 E2 S$ S
-- Control total violations
-- Posting to unopened periods
-- Unbalanced journal entriesErp100论坛! Q6 Y) E9 G8 _3 m* F6 o
Correct the specific error and post the batch from the More Actions window.Erp100论坛, k" }* X6 ^% {* R9 s) a/ H. F
Posting Status:
Unposted Pending
Processing Selected for postingERP, SAP, Oracle ERP,用友,金蝶& a7 D% U2 s0 Z& _2 [
Posted Error
Approved In Process
ERP, SAP, Oracle ERP,用友,金蝶" C# ~+ C- R% M% ~
ERP, SAP, Oracle ERP,用友,金蝶) ?3 /( C6 p% _* O/ H: S! }
Journal Entry TablesErp100论坛# L7 B& |# q/ u7 V+ F3 x# [* J2 B
The major tables storing journal entries related information are as follows:
-- GL_JE_BATCHESERP, SAP, Oracle ERP,用友,金蝶0 ] G3 t: _' G' J- Q
-- GL_JE_HEADERSERP, SAP, Oracle ERP,用友,金蝶, |( w6 | q/ k3 M: {7 ~8 N/ /: a
-- GL_JE_LINES) l8 j0 ?$ w% P
-- GL_CODE_COMBINATIONS
-- GL_BALANCES
GL_CODE_COMBINATIONS
Refer to the previous section, Identifying Currency, Calendar and Chart of Accounts Tables,
for a discussion of this table.-最专业的ERP社区,帮助你在ERP行业实现价值!0 |& t2 p3 A* |( W2 J2 L: j
A one-to-many relationship exists between GL_BALANCES table and GL_JE_LINES table.bbs.erp100.com% Q N: R( |& M7 s( r. ~) }
However, there is no direct relation between the other tables.
GL_JE_BATCHES:-最专业的ERP社区,帮助你在ERP行业实现价值!3 /" U4 e9 @3 t. s+ t
--this table stores details of journal entry batches.
--a batch is a grouping of journal entries * C, x6 F I, k9 m }5 [
--in general ledger,journal entries are posted in batches.
--each row in this table includes the batch name, status,running total debits
and credits for all entries in the batch ,and other information.
(N) Journals > Enter (B) New Batchbbs.erp100.com( T% Q2 z- d2 W( Z
-- JE_BATCH_ID (PK)ERP, SAP, Oracle ERP,用友,金蝶: s$ X0 H; U% /& L2 b
-- NAME
-- STATUS: Posted or Unposted
-- ACTUAL_FLAG: A = Actuals, B= Budgets, E = Encumbrance
-- DEFAULT_PERIOD_NAME
-- POSTED_DATE( z+ i4 ]" F- u: ^1 G
-- DESCRIPTION
-- SET_OF_BOOKS_ID
-- POSTING_RUN_ID: Posting sequence numberERP, SAP, Oracle ERP,用友,金蝶$ i L: Q2 }: c8 B* S0 V; r5 B
-- RUNNING_TOTAL_DR-最专业的ERP社区,帮助你在ERP行业实现价值!$ p: K* m# L: P, e6 L& |% z
-- RUNNING_TOTAL_CR
-- RUNNING_TOTAL_ACCOUNTED_DR
-- RUNNING_TOTAL_ACCOUNTED_CRErp100论坛" h: K& w4 Z2 /
Foreign KeysERP, SAP, Oracle ERP,用友,金蝶8 _. r T/ s. D$ h3 E, N+ p
Primary Key Table Primary Key Column Foreign Key Column FND_CONCURRENT_ REQUEST_ID REQUEST_ID
REQUESTS
GL_JE_BATCHES JE_BATCH_ID PARENT_JE_BATCH_IDbbs.erp100.com7 ]/ M. V! f7 c- [ {
GL_PERIODS PERIOD_NAME DEFAULT_PERIOD_NAME
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID
------------------------------------------------------------------------------------------------
GL_JE_HEADERS:
--this table stores journal entry information.bbs.erp100.com0 e9 i! h+ b2 Q) Y$ D& O! Y! O
--there is a one-to-many relationship between journal entry batches and journal entries.Erp100论坛2 H! ^/ K% g- A: t
--each row in this table includes the associated batch id ,journal entry name and description,ERP, SAP, Oracle ERP,用友,金蝶5 d3 p' k4 }, i K$ `2 R
and other information about the journal entry.
(N) Journals > Enter (B) New JournalErp100论坛% K+ u+ |( V4 L* g) b
Major Columns
-- JE_HEADER_ID (PK)Erp100论坛# @+ ~0 Q) W% j3 s; j$ {$ Q9 J
-- SET_OF_BOOKS_ID6 e' l; { o( x0 L0 o
-- JE_CATEGORY7 v a0 F/ l/ |
-- JE_SOURCE
-- PERIOD_NAME-最专业的ERP社区,帮助你在ERP行业实现价值!7 U" s" {* M" J, U* k+ F B
-- NAME
-- RUNNING_TOTAL_DR$ L/ A0 |& E" [3 b- r- V
-- RUNNING_TOTAL_CR
-- RUNNING_TOTAL_ACCOUNTED_DR5 L0 u2 X ~/ ^. t! D( D8 ?* z$ t
-- RUNNING_TOTAL_ACCOUNTED_CRErp100论坛1 d. z1 g& o D0 J a
-- STATUS
-- ACTUAL_FLAG
-- JE_BATCH_IDERP, SAP, Oracle ERP,用友,金蝶4 h7 ?: b5 J6 V4 v3 Z
-- POSTED_DATE2 p3 x' e1 P' t8 @
-- DESCRIPTION
-- CURRENCY_CODE-最专业的ERP社区,帮助你在ERP行业实现价值!. t7 b; A. y/ m5 U) f5 n
Foreign Keys-最专业的ERP社区,帮助你在ERP行业实现价值!+ o0 {9 q+ K* I. v
Primary Key Table Primary Key Column Foreign Key Column
FND_CURRENCIES CURRENCY_CODE CURRENCY_CODEERP, SAP, Oracle ERP,用友,金蝶/ L [- M* m$ v' c, /* z( B( X+ x0 ]
FND_FLEX_VALUES FLEX_VALUE ORIGINATING_BAL_SEG_VALUE
FND_FLEX_VALUES FLEX_VALUE DR_BAL_SEG_VALUE
FND_FLEX_VALUES FLEX_VALUE CR_BAL_SEG_VALUEbbs.erp100.com8 g$ V3 /8 V: `. V! X5 m0 J* J
GL_BUDGET_VERSIONS BUDGET_VERSION_ID BUDGET_VERSION_ID
GL_DAILY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPES CONVERSION_TYPE
GL_ENCUMBRANCE_ENCUMBRANCE_ENCUMBRANCE_TYPES TYPE_ID TYPE_IDERP, SAP, Oracle ERP,用友,金蝶% O& Z9 f. q; ]! a0 {8 K
GL_JE_BATCHES JE_BATCH_ID JE_BATCH_IDERP, SAP, Oracle ERP,用友,金蝶3 s" c: ?7 k2 p; O6 F& Z
GL_JE CATEGORIES_TL JE_CATEGORY_NAME JE_CATEGORY2 y) W) D( z- c7 h1 j8 g
GL_JE_HEADERS JE_HEADER_ID ACCRUAL_REV_JE_HEADER_ID
GL_JE_HEADERS JE_HEADER_ID PARENT_JE_HEADER_ID E1 l8 |& B" _8 p; X
GL_JE_HEADERS JE_HEADER_ID REVERSED_JE_HEADER_IDbbs.erp100.com( J6 F9 a/ k4 T3 _; p
GL_JE_SOURCES_TL JE_SOURCE_NAME JE_SOURCE
GL_RECURRING_RECURRING_ FROM_RECURRING_HEADERS HEADER_ID HEADER_ID
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID
--------------------------------------------------------------------------------------------------
GL_JE_LINES
--this table stores journal entry lines.ERP, SAP, Oracle ERP,用友,金蝶! r8 ?+ j4 N! n5 c/ l, L T
--there is a one-to-many relationship between journal entries headers and journalErp100论坛: d. u, E6 N3 _
entry line./ n4 `- O: K: [; `9 V4 {8 |
--this table contain the information about the account and amount for each line of the : w' M- Q8 M+ J1 R8 L
entry.) m' L+ S5 /" n* S' v8 g6 N' u
(N) Journals > Enter (B) New Journal-最专业的ERP社区,帮助你在ERP行业实现价值!: O( f# U& V, e+ M7 p' v N& J
Major Columns' d4 P* B0 l7 M
-- JE_HEADER_ID (PK)
-- JE_LINE_NUM (PK)Erp100论坛/ /' {3 b1 E( u; y0 N9 h
-- SET_OF_BOOKS_IDbbs.erp100.com& u0 h" X2 d; @0 c: c& A
-- CODE_COMBINATION_ID* [5 e j# P- @! T" H8 x
-- PERIOD_NAME0 j8 Y; B7 h6 ]4 K: h
-- EFFECTIVE _DATE. f- U2 Z. ?5 }* B, B$ p
-- STATUSErp100论坛& H' r6 a, C, b0 L5 y
-- ENTERED_DR
-- ENTERED_CR
-- ACCOUNTED_DRErp100论坛4 ~- l0 h" M4 p+ W& v" Y2 t5 `
-- ACCOUNTED_CR
-- DESCRIPTION
-- STAT_AMOUNTErp100论坛& w3 k. }9 T/ X# @# o7 L
ENTERED_DR and ENTERED_CR store the value of the entered currency;
ACCOUNTED_DR and ACCOUNTED_CR store the value of the calculated journal in the
base currency.Erp100论坛3 D: u0 P$ `. v" n" n
Foreign Keysbbs.erp100.com- s/ {3 j9 m' {+ r
Primary Key Table Primary Key Column Foreign Key Columnbbs.erp100.com5 u/ Y8 {# ]/ ~9 u, a! ?. H9 V
GL_CODE_COMBINATIONS CODE_COMBINATION_ID CODE_COMBINATION_IDErp100论坛( p! ~, @8 F! @/ A$ w
GL_JE_HEADERS JE_HEADER_ID JE_HEADER_ID
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID
GL_USSGL_ USSGL_ USSGL_& /# B( t) O3 e. H
TRANSACTION_CODES TRANSACTION_CODE TRANSACTION_CODE-最专业的ERP社区,帮助你在ERP行业实现价值!' h% O4 V, G- Q
-------------------------------------------------------------------------------------------6 q* e9 m' e7 |! c/ M R9 |! V
GL_BALANCES:Note: This table stores activity rather than the actual balance
-- this table stores net debit (净借记)and net credit (净贷记)information for detail and
summary accounts.bbs.erp100.com% @1 /! J i( [5 A& ?/ N* u
-- the information is stored as actual, budget,and encumbrance amounts, it also stores
functional currency,foreign currency ,and statistical balances for each accounting period0 I/ Y7 r1 U! q5 K
that has ever been opened.-最专业的ERP社区,帮助你在ERP行业实现价值!; c! _" @; M# S5 O
--GL_BALANCES is populated by the system during the GL Post and Summary Account TemplateErp100论坛5 /" F: r2 J# R' p, /6 [
Defination-最专业的ERP社区,帮助你在ERP行业实现价值!- f2 [( }3 K& W+ V9 A2 c3 F1 i
--it is used for standard account inquiries and for Financial Statement Generator(FSG)reportingERP, SAP, Oracle ERP,用友,金蝶& X' n; J0 Q2 K# n k, F4 u
Use the following formula to calculate the period-to-date balance:
-- (PERIOD_NET_DR - PERIOD_NET_CR) = Period-to-Date Balance
Use the following formula to calculate the year-to-date balance:
-- (BEGIN_BALANCE_DR - BEGIN_BALANCE_CR)+(PERIOD_NET_DR - PERIOD_NET_CR) = Year-to-Date Balance0 c/ c0 A9 H7 W8 X3 H, q
Major Columns7 z( U. B! F2 z: s3 W* r. J
-- SET_OF_BOOKS_ID (PK)
-- CODE_COMBINATION_ID (PK)
-- CURRENCY_CODE (PK)-最专业的ERP社区,帮助你在ERP行业实现价值!3 Y6 m, J6 A% n$ G4 ^! k. f
-- PERIOD_NAME (PK)
-- ACTUAL_FLAG (PK)-最专业的ERP社区,帮助你在ERP行业实现价值!8 ^% y# N6 z: K5 N" j
-- ENCUMBRANCE_TYPE_ID (PK)
-- TRANSLATED_FLAG (PK); Q Z% J. f* X& p; o# e b
-- BUDGET_VERSION_ID (PK)
-- PERIOD_NET_DR
-- PERIOD_NET_CR
-- QUARTER_TO_DATE_DR
-- QUARTER_TO_DATE_CR8 e. K7 X$ f, J0 T( x- s* w0 q
-- PROJECT_TO_DATE_DRERP, SAP, Oracle ERP,用友,金蝶* C9 Y! @4 U. X3 i4 _
-- PROJECT_TO_DATE_CR
-- BEGIN_BALANCE_DR
-- BEGIN_BALANCE_CR
-- TEMPLATE_ID
Note: PROJECT_TO_DATE_DR and PROJECT_TO_DATE_CR columns retain the life-todate balance6 s6 G9 v* Z. T: Q+ I; a( x6 e
Foreign Keys
Primary Key Table Primary Key Column Foreign Key Column
FND_CURRENCIES CURRENCY_CODE CURRENCY_CODE
GL_BUDGET_VERSION BUDGET_VERSION_ID BUDGET_VERSION_ID
GL_CODE_COMBINATIONS CODE_COMBINATION_ID CODE_COMBINATION_ID
GL_ENCUMBRANCE_TYPES ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
GL_PERIOD_TYPES PERIOD_TYPE PERIOD_TYPE* i1 Q1 {3 |( Y: i8 _
GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID-最专业的ERP社区,帮助你在ERP行业实现价值!$ f3 M7 s, x$ s/ L# j. b" M/ n
GL_SUMMARY_TEMPLATES TEMPLATE_ID TEMPLATE_ID