GL Transaction
Oracle E-Business Suite Financials for General Ledger and Accounts Payable GL Table Mapping to Oracle Utilities Customer Care and Billing
Column
Data Type
Description
CCB Table
Column
Data Type
Remarks
STATUS
VARCHAR2 (50)
Journal Import status (Required field)
‘NEW’, for all new transactions
LEDGER_ID
SET_OF_BOOK_ID
NUMBER
Ledger defining column
Derived from BPEL
Identifies the account ledger to use for posting
Value = 1 (Corresponds to 'Vision Operations (USA) ' Ledger Name)
ACCOUNTING_DATE
DATE
Effective date of the transaction (Required)
CI_FT
ACCOUNTING_DT
DATE
Date used by GL to define the accounting period into which the Financial Transaction is booked.
CURRENCY_CODE
VARCHAR2 (15)
Currency (Required)
CI_FT
CURRENCY_CD
CHAR (3)
 
DATE_CREATED
DATE
Standard Who column
(Required)
Derived from BPEL
Value =sysdate
CREATED_BY
NUMBER
Standard Who column (Required)
Value= -1
ACTUAL_FLAG
VARCHAR2 (1)
Balance type (actual, budget, or encumbrance)(Required)
‘A’
USER_JE_CATEGORY_NAME
VARCHAR2 (25)
Journal entry category user defined name (Required)
‘CCB EBS’
USER_JE_SOURCE_NAME
VARCHAR2 (25)
Journal entry source user defined name (Required)
‘CCB EBS’
CURRENCY_CONVERSION_DATE
DATE
Date of exchange rate
Leave blank
ENCUMBRANCE_TYPE_ID
NUMBER
Encumbrance type defining column
 
BUDGET_VERSION_ID
NUMBER
Budget version defining column
 
USER_CURRENCY_CONVERSION_TYPE
VARCHAR2 (30)
Type of exchange rate
 
CURRENCY_CONVERSION_RATE
NUMBER
Foreign currency exchange rate
 
AVERAGE_JOURNAL_FLAG
VARCHAR2 (1)
Average journal flag
 
ORIGINATING_BAL_SEG_VALUE
VARCHAR2 (25)
Originating balancing segment value
 
SEGMENT1
VARCHAR2 (25)
COMPANY
CI_FT_GL
GL_ACCT
Position1
Varchar2 (254)
Use dot (.) as the delimiter to extract this information from the Gl_Acct.
2 dots (..) indicate skip or null.
SEGMENT2
VARCHAR2 (25)
DEPARTMENT
CI_FT_GL
GL_ACCT
Position 2
Varchar2 (254)
 
SEGMENT3
VARCHAR2 (25)
ACCOUNT
CI_FT_GL
GL_ACCT
Position 3
Varchar2 (254)
 
SEGMENT4
VARCHAR2 (25)
SUB-ACCOUNT
CI_FT_GL
GL_ACCT
Position 4
Varchar2 (254)
 
SEGMENT5
VARCHAR2 (25)
PRODUCT
CI_FT_GL
GL_ACCT
Position 5
Varchar2 (254)
 
SEGMENT6
VARCHAR2 (25)
PROGRAM CODE
CI_FT_GL
GL_ACCT
Position 6
Varchar2 (254)
 
SEGMENT7
VARCHAR2 (25)
ALTERNATE ACCOUNT
CI_FT_GL
GL_ACCT
Position 7
Varchar2 (254)
 
SEGMENT8
VARCHAR2 (25)
PROJECT
CI_FT_GL
GL_ACCT
Position 8
Varchar2 (254)
 
SEGMENT9
VARCHAR2 (25)
AFFILIATE
CI_FT_GL
GL_ACCT
Position 9
Varchar2 (254)
Use dot (.) as the delimiter to extract this information from the Gl_Acct.
2 dots (..) indicate skip or null.
SEGMENT10
VARCHAR2 (25)
FUND AFFILIATE
CI_FT_GL
GL_ACCT
Position 10
Varchar2 (254)
 
SEGMENT11
VARCHAR2 (25)
OPERATING UNIT AFFILIATE
CI_FT_GL
GL_ACCT
Position 11
Varchar2 (254)
 
SEGMENT12
VARCHAR2 (25)
BUDGET REFERENCE
CI_FT_GL
GL_ACCT
Position 12
Varchar2 (254)
 
SEGMENT13
VARCHAR2 (25)
CHARTFIELD1
CI_FT_GL
GL_ACCT
Position 13
Varchar2 (254)
 
SEGMENT14
VARCHAR2 (25)
CHARTFIELD2
CI_FT_GL
GL_ACCT
Position 14
Varchar2 (254)
 
SEGMENT15
VARCHAR2 (25)
CHARTFIELD3
CI_FT_GL
GL_ACCT
Position 15
Varchar2 (254)
 
SEGMENT16
VARCHAR2 (25)
FUND CODE
CI_DST_CODE_EFF
FUND_CD
Varchar2 (12)
Only used when fund accounting is enabled in Oracle Utilities Customer Care and Billing.
SEGMENT17
VARCHAR2 (25)
Key flexfield segments
 
 
 
Derived from BPEL
Leave blank
SEGMENT18
VARCHAR2 (25)
 
 
 
 
 
SEGMENT19
VARCHAR2 (25)
 
 
 
 
 
SEGMENT20
VARCHAR2 (25)
 
 
 
 
 
SEGMENT21
VARCHAR2 (25)
 
 
 
 
 
SEGMENT22
VARCHAR2 (25)
 
 
 
 
 
SEGMENT23
VARCHAR2 (25)
Key flexfield segments
 
 
 
Derived from BPEL
Leave blank
SEGMENT24
VARCHAR2 (25)
 
 
 
 
 
SEGMENT25
VARCHAR2 (25)
 
 
 
 
 
SEGMENT26
VARCHAR2 (25)
 
 
 
 
 
SEGMENT27
VARCHAR2 (25)
 
 
 
 
 
SEGMENT28
VARCHAR2 (25)
 
 
 
 
 
SEGMENT29
VARCHAR2 (25)
 
 
 
 
 
SEGMENT30
VARCHAR2 (25)
 
 
 
 
 
ENTERED_DR
NUMBER
Transaction debit amount, entered currency
CI_FT_GL
AMOUNT
NUMBER (15,2)
Base Currency Amount
Leave blank if the Amount is negative
ENTERED_CR
NUMBER
 
 
 
 
Leave blank if the amount is positive
ACCOUNTED_DR
NUMBER
 
 
 
 
Base Currency Amount
Leave blank if the Amount is negative
ACCOUNTED_CR
NUMBER
 
 
 
 
Leave it Bank if the Amount is Positive
TRANSACTION_DATE
DATE
Date of transaction
Leave blank
PERIOD_NAME
VARCHAR2 (15)
Accounting period
Leave blank
REFERENCE1
VARCHAR2 (100)
Journal Import reference columns.
 
 
Leave blank
REFERENCE2
VARCHAR2 (240)
 
 
 
 
 
REFERENCE3
VARCHAR2 (100)
 
 
 
 
 
REFERENCE4
VARCHAR2 (100)
 
 
 
 
 
REFERENCE5
VARCHAR2 (240)
 
 
 
 
 
REFERENCE6
VARCHAR2 (100)
 
 
 
 
 
REFERENCE7
VARCHAR2 (100)
 
 
 
 
 
REFERENCE8
VARCHAR2 (100)
 
 
 
 
 
REFERENCE9
VARCHAR2 (100)
 
 
 
 
 
REFERENCE10
VARCHAR2 (240)
 
 
 
 
 
REFERENCE11
VARCHAR2 (240)
 
 
 
 
 
REFERENCE12
VARCHAR2 (100)
 
 
 
 
 
REFERENCE13
VARCHAR2 (100)
 
 
 
 
 
REFERENCE14
VARCHAR2 (100)
 
 
 
 
 
REFERENCE15
VARCHAR2 (100)
Journal Import reference columns.
 
 
 
REFERENCE16
VARCHAR2 (100)
 
 
 
 
Leave blank
REFERENCE17
VARCHAR2 (100)
 
 
 
 
 
REFERENCE18
VARCHAR2 (100)
 
 
 
 
 
REFERENCE19
VARCHAR2 (100)
 
 
 
 
 
REFERENCE20
VARCHAR2 (100)
 
 
 
 
 
REFERENCE21
VARCHAR2 (240)
 
 
 
 
 
REFERENCE22
VARCHAR2 (240)
 
 
 
 
 
REFERENCE23
VARCHAR2 (240)
 
 
 
 
 
REFERENCE24
VARCHAR2 (240)
 
 
 
 
 
REFERENCE25
VARCHAR2 (240)
 
 
 
 
 
REFERENCE26
VARCHAR2 (240)
 
 
 
 
 
REFERENCE27
VARCHAR2 (240)
 
 
 
 
 
REFERENCE28
VARCHAR2 (240)
 
 
 
 
 
REFERENCE29
VARCHAR2 (240)
 
 
 
 
 
REFERENCE30
VARCHAR2 (240)
 
 
 
 
 
JE_BATCH_ID
NUMBER
Journal entry batch defining column
Leave blank.
Populated by the Import Process when the Record errors
JE_HEADER_ID
NUMBER
Journal entry header defining column
Leave blank.
Populated by the Import Process when the Record errors.
JE_LINE_NUM
NUMBER
Journal entry line number
Leave blank
Populated by the Import Process when the Record errors
CHART_OF_ACCOUNTS_ID
NUMBER
Key flexfield structure defining column
Leave blank
FUNCTIONAL_CURRENCY_CODE
VARCHAR2 (15)
Ledger base currency
Leave blank
CODE_COMBINATION_ID
NUMBER
Key flexfield combination defining column
Derived from the Segments Entered Above
DATE_CREATED_IN_GL
DATE
Date Journal Import created batch
Leave blank
STATUS_DESCRIPTION
VARCHAR2 (240)
Journal import status description
Leave blank
Populated by the Import Process when the Record errors
STAT_AMOUNT
NUMBER
Statistical amount
Leave blank
GROUP_ID
NUMBER
Interface group defining column
CI_FT_PROC
BATCH_NBR
NUMBER (10)
This is the CCB GLDL Batch Number.
REQUEST_ID
NUMBER
Concurrent program request ID
Leave blank
Populated by the Import Process when the Record errors
SUBLEDGER_DOC_SEQUENCE_ID
NUMBER
Sequential numbering sequence defining column
Leave blank
SUBLEDGER_DOC_SEQUENCE_VALUE
NUMBER
Sequential numbering sequence value
 
ATTRIBUTE1
VARCHAR2 (150)
Descriptive flexfield segment
 
ATTRIBUTE2
VARCHAR2 (150)
Descriptive flexfield segment
 
GL_SL_LINK_ID
NUMBER
Link to associated subledger data
 
GL_SL_LINK_TABLE
VARCHAR2 (30)
Table containing associated subledger data
 
CONTEXT
VARCHAR2 (150)
Descriptive flexfield context column
 
CONTEXT2
VARCHAR2 (150)
Descriptive flexfield context column
 
INVOICE_DATE
DATE
Value added tax descriptive flexfield column
 
TAX_CODE
VARCHAR2 (15)
Value added tax descriptive flexfield column
 
INVOICE_IDENTIFIER
VARCHAR2 (20)
Value added tax descriptive flexfield column
 
ATTRIBUTE3
VARCHAR2 (150)
Descriptive flexfield segment
 
 
 
ATTRIBUTE4
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE5
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE6
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE7
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE8
VARCHAR2 (150)
Descriptive flexfield segment
 
Leave blank
ATTRIBUTE9
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE10
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE11
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE12
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE13
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE14
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE15
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE16
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE17
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE18
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE19
VARCHAR2 (150)
 
 
 
 
 
ATTRIBUTE20
VARCHAR2 (150)
 
 
 
 
 
INVOICE_AMOUNT
NUMBER
Value added tax descriptive flexfield column
 
CONTEXT3
VARCHAR2 (150)
Descriptive flexfield context column
 
USSGL_TRANSACTION_CODE
VARCHAR2 (30)
Government transaction code
Leave blank
DESCR_FLEX_ERROR_MESSAGE
VARCHAR2 (240)
Descriptive flexfield error message
 
JGZZ_RECON_REF
VARCHAR2 (240)
Global reconciliation reference
 
REFERENCE_DATE
DATE
Reference Date
 
SET_OF_BOOKS_ID
NUMBER
Ledger defining column
 
BALANCING_SEGMENT_VALUE
VARCHAR2 (25)
Balancing segment value
 
MANAGEMENT_SEGMENT_VALUE
VARCHAR2 (25)
Management segment value
 
FUNDS_RESERVED_FLAG
VARCHAR2 (1)
Reserved for Oracle internal use