Field Mapping Page
Use the External System Setup – Field Mapping page (FAI_EXTSYS_MAP) to map the fields from the 3rd Party Interface table (FAH_ACCTG_LINE) to the target fields in the PeopleSoft External Accounting Entry record (FAI_ACCTG_LINE), which is used by Journal Generator to create the PeopleSoft journals.
Navigation:
This example illustrates the fields and controls on the Field Mapping Page. You can find definitions for the fields and controls later on this page.
The External System Setup – Field Mapping page is delivered with preconfigured values for the 3rd Party Interface table (FAH_ACCTG_LINE). Therefore, when implementing the Fusion Accounting Hub integration, there is no mandatory update required for this page. However, as part of configuration, you should review and update the mapping according to your installation configuration, if necessary.
Note:
This page requires a one-to-one mapping relationship. Upon saving, an error message appears if an active ChartField is not mapped or if there is a many-to-one or one-to-many mapping relationship
You cannot map the Affiliate fields, Alternate Account, budget, or detailed Project Costing fields as there are no corresponding Fusion segments.
The following table lists the preconfigured field name values and mapping requirement:
| Target Field name PeopleSoft record: FAI_ACCTG_LINE | Source Field name Third Party Interface table * | Required |
|---|---|---|
|
ACCOUNT |
SEGMENT2 |
Yes |
|
ACCOUNTING_DT |
ACCOUNTING_DT |
Yes |
|
AFFILIATE |
||
|
AFFILIATE_INTRA1 |
||
|
AFFILIATE_INTRA2 |
||
|
ALTACCT |
||
|
BUDGET_REF |
||
|
BUSINESS_UNIT |
ANCHOR_BU |
Yes |
|
BUSINESS_UNIT_CHRG |
BUSINESS_UNIT_CHRG |
Yes |
|
CHARTFIELD1 |
||
|
CHARTFIELD2 |
||
|
CHARTFIELD3 |
||
|
CLASS_FLD |
||
|
CURRENCY_CD |
BASE_CURRENCY |
Yes |
|
DEPTID |
SEGMENT4 |
|
|
FOREIGN_AMOUNT |
FOREIGN_AMOUNT |
Yes |
|
FOREING_CURRENCY |
FOREIGN_CURRENCY |
Yes |
|
FUND_CODE |
SEGMENT7 |
|
|
IU_ANCHOR_FLG |
IU_ANCHOR_FLG |
Yes |
|
IU_TRAN_GRP_NBR |
||
|
JRNL_LN_REF |
||
|
LEDGER |
LEDGER |
Yes |
|
LINE_DESCR |
DESCR |
Yes |
|
MONETARY_AMOUNT |
MONETARY_AMOUNT |
Yes |
|
OPERATING_UNIT |
||
|
PRODUCT |
||
|
PROGRAM_CODE |
||
|
PROJECT_ID |
||
|
RATE_DIV |
RATE_DIV |
Yes |
|
RATE_MULT |
RATE_MULT |
Yes |
|
RT_TYPE |
RT_TYPE |
Yes |
* If implementing the Fusion Accounting Hub integration, the Source system records are the external 3rd Party Interface tables, FAH_ACCTG_HDR and FAH_ACCTG_LINE. If implementing another third party, the Source records are custom records, XXX_ACCTG_HDR and XXX_ACCTG_LN.