The journal source domain is used to identify the source of GL journals like Payables, Receivables, and so on in Financial Analytics. You can configure the domain member mappings between batch types in JDE Edwards Enterprise One and journal sources in Financial Analytics.
Domain Member Mapping
The table illustrates domain member mappings for the Journal Source domain. You can modify the seeded mappings to satisfy your requirements.
| Source Member | Source Member Code | Target Member | Target Member Code |
|---|---|---|---|
|
A/P Checks (Automatic) |
K |
Account Payables |
AP |
|
Account Payables |
Payables |
Account Payables |
AP |
|
Direct Payments |
Q |
Account Payables |
AP |
|
Manual & Void Checks w/Match |
M |
Account Payables |
AP |
|
Manual Checks without Match |
W |
Account Payables |
AP |
|
Voucher Entry |
V |
Account Payables |
AP |
|
A/R Drafts |
& |
Account Receivables |
AR |
|
Invoice Entry |
I |
Account Receivables |
AR |
|
Invoices |
IB |
Account Receivables |
AR |
|
Account Receivables |
Receivables |
Account Receivables |
AR |
|
Cash Receipts and Adjustments |
R |
Account Receivables |
AR |
|
Receipts & Adjustments |
RB |
Account Receivables |
AR |
|
Revenue |
Revenue |
Account Receivables |
AR |
|
Asset Revaluation |
AR |
Fixed Assets |
FA |
|
Asset Transfer |
E |
Fixed Assets |
FA |
|
Depreciation - Journal Entries |
X |
Fixed Assets |
FA |
|
Fixed Assets |
Fixed Assets |
Fixed Assets |
FA |
|
COGS |
COGS |
Inventory |
INV |
|
Inventory |
N |
Inventory |
INV |
|
General Accounting |
G |
Inventory |
INV |
Note:
Use the following SQL to see the list of batch types (source domain members) in JDE:
SELECT * FROM F0005 WHERE DRSY = '98' AND DRRT = 'IT'
Payables, Receivables, Fixed Assets, COGS and Revenue are internal source member codes. These do not come from JDE batch types. These are used to tag the subledger transactions in the respective subledger facts in Financial Analytics.
ETL
JOURNAL_SOURCE_ID is hard-coded in the SDE interfaces for based on the internally sourced domain members.
| Interface Name | JOURNAL_SOURCE_ID |
|---|---|
|
SDE_JDE_APTransactionFact% |
GL_JOURNAL_SOURCE~Payables |
|
SDE_JDE_ARTransactionFact% |
GL_JOURNAL_SOURCE~Receivables |
|
SDE_JDE_GLCogs_Fact |
GL_JOURNAL_SOURCE~COGS |
|
SDE_JDE_GLRevenue_Fact% |
GL_JOURNAL_SOURCE~Revenue |
Optional or Mandatory
Optional - For JD Edwards EnterpriseOne, you only need to change the default values if the seeded source domain and domain mappings do not meet your business requirements.