FBDI Values for GL_INTERFACE TABLE | Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing Source Value | Comments (DATA Mapping Comment) |
---|---|---|
*Status Code | NEW | Journal Import Status Default by CCS in Batch report. |
*Ledger ID | Ledger ID from the Manage Primary Ledger page in ERP. Defaulted in CCS. | |
*Effective Date of Transaction | CI_FT (ACCOUNTING_DT) | Accounting Date. Should be in YYYY/MM/DD format. |
*Journal Source | Journal Entry Source Name. Defaulted in CCS as per ERP configuration. | |
*Journal Category | Journal Category Name for the transaction. Must be a valid value in Manage Journal Categories Setup Task Page in ERP. Populated /Defaulted by CCS. | |
*Currency Code | CI_FT (CURRENCY_CD) | Must be a valid value in Manage Currencies Task Page in ERP. Use 3 character ISO currency code (Example: USD) |
*Journal Entry Creation Date | SYSDATE | Journal Creation Date in YYYY/MM/DD format. |
*Actual Flag | A | Balance Type of the Journal. Defaulted “A” by CCS |
Segment1 | CI_FT_GL (GL_ACCT Position1) | Distribution Codes Configuration in CCS to reflect the General Ledger accounts in the ERP. From Segment 1 to 10 |
Segment2 | CI_FT_GL (GL_ACCT Position2) | |
Segment3 | CI_FT_GL (GL_ACCT Position3) | |
Segment4 | CI_FT_GL (GL_ACCT Position4) | |
Segment5 | CI_FT_GL (GL_ACCT Position5) | |
Segment6 | CI_FT_GL (GL_ACCT Position6) | |
Segment7 | CI_FT_GL (GL_ACCT Position7) | |
Segment8 | CI_FT_GL (GL_ACCT Position8) | |
Segment9 | CI_FT_GL (GL_ACCT Position9) | |
Segment10 | CI_FT_GL (GL_ACCT Position10) | |
Up to Segment30 | CCS has functionality for 10 Segment. For the next 20 Segment CCS batch report will pass a Blank Value. | |
Entered Debit Amount | CI_FT_GL, (Amount) | Blank if the Amount is negative. Amount columns must not contain a thousand separator and must use a period (.) as the decimal separator. |
Entered Credit Amount | CI_FT_GL, (AMOUNT) | Blank if the Amount is positive. Amount columns must not contain a thousand separator and must use a period (.) as the decimal separator. |
Converted Debit Amount | ||
Converted Credit Amount | ||
REFERENCE1 (Batch Name) | CI_FT_PROC, (BATCH_CD) | |
REFERENCE2 (Batch Description) | ||
REFERENCE4 (Journal Entry Name) | ||
REFERENCE5 (Journal Entry Description) | ||
REFERENCE6 (Journal Entry Reference) | ||
REFERENCE7 (Journal Entry Reversal flag) | ||
REFERENCE8 (Journal Entry Reversal Period) | ||
REFERENCE9 (Journal Reversal Method) | ||
REFERENCE10 (Journal Entry Line Description) | ||
Statistical Amount | ||
Currency Conversion Type | ||
Currency Conversion Date | ||
Currency Conversion Rate | ||
Interface Group Identifier | CI_FT_PROC, (BATCH_NBR) | A number used for grouping of Journals. |
Context field for Journal Entry Line DFF | ||
ATTRIBUTE1 Value for Journal Entry Line DFF | ||
ATTRIBUTE2 Value for Journal Entry Line DFF | ||
ATTRIBUTE3 Value for Journal Entry Line DFF | ||
ATTRIBUTE4 Value for Journal Entry Line DFF | ||
ATTRIBUTE5 Value for Journal Entry Line DFF | ||
ATTRIBUTE6 Value for Journal Entry Line DFF | ||
ATTRIBUTE7 Value for Journal Entry Line DFF | ||
ATTRIBUTE8 Value for Journal Entry Line DFF | ||
ATTRIBUTE9 Value for Journal Entry Line DFF | ||
ATTRIBUTE10 Value for Journal Entry Line DFF | ||
Attribute11 Value for Captured Information DFF | ||
Attribute12 Value for Captured Information DFF | ||
Attribute13 Value for Captured Information DFF | ||
Attribute14 Value for Captured Information DFF | ||
Attribute15 Value for Captured Information DFF | ||
Attribute16 Value for Captured Information DFF | ||
Attribute17 Value for Captured Information DFF | ||
Attribute18 Value for Captured Information DFF | ||
Attribute19 Value for Captured Information DFF | ||
Attribute20 Value for Captured Information DFF | ||
Context field for Captured Information DFF | ||
Clearing Company | ||
Ledger Name | ||
Encumbrance Type ID | ||
Reconciliation Reference |