FIF Ap Detail Publish

In Scope

Technical: FIF_AP_DETAIL_PUBLISH | ID: OR-MFCS-FIF_AP_DETAIL_PUBLISH

Stores the accounts payable detail information from Invoice Matching to be sent across to the external financial system.

See how this object fits into Finance

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Sequencing
Stage 2
Typical Sources
ERPLegacy

Target Structure

Load Approach
Table
Target Objects
FIF_AP_DETAIL_PUBLISH

Field Definitions(170)

Rules & Considerations(30)

Sample Load Data(4)

default

CREATE_IDR
USERENV
LINE_NUMBERR
1
IM_CREATE_DATER
2026-01-01
INVOICE_DOC_IDR
1000000001
LAST_UPDATE_IDR
USERENV
CREATE_DATETIMER
2026-01-01
APPLICATION_NAMER
FIF Ap Detail Publish Primary
FIF_AP_DETAIL_SEQ_NORPK
2
LAST_UPDATE_DATETIMER
2026-01-01
TAX
FIF Ap Detail Publish-001
UOM
FIF Ap Detail Publish-001
AMOUNT
1
TASK_ID
1000000001
TAX_RATE
1
LINE_TYPE
FIF Ap Detail Publish-001
PO_NUMBER
FIF Ap Detail Publish-001
TASK_NAME
FIF Ap Detail Publish Primary
WORK_TYPE
FIF Ap Detail Publish-001
PROJECT_ID
1000000001
UNIT_PRICE
1
ATTRIBUTE_1
FIF Ap Detail Publish-001
ATTRIBUTE_2
FIF Ap Detail Publish-001
ATTRIBUTE_3
FIF Ap Detail Publish-001
ATTRIBUTE_4
FIF Ap Detail Publish-001
ATTRIBUTE_5
FIF Ap Detail Publish-001
ATTRIBUTE_6
FIF Ap Detail Publish-001
ATTRIBUTE_7
FIF Ap Detail Publish-001
ATTRIBUTE_8
FIF Ap Detail Publish-001
ATTRIBUTE_9
FIF Ap Detail Publish-001
FINAL_MATCH
FIF Ap Detail Publish-001
TASK_NUMBER
FIF Ap Detail Publish-001
ATTRIBUTE_10
FIF Ap Detail Publish-001
ATTRIBUTE_11
FIF Ap Detail Publish-001
ATTRIBUTE_12
FIF Ap Detail Publish-001
ATTRIBUTE_13
FIF Ap Detail Publish-001
ATTRIBUTE_14
FIF Ap Detail Publish-001
ATTRIBUTE_15
FIF Ap Detail Publish-001
INTENDED_USE
FIF Ap Detail Publish-001
MANUFACTURER
FIF Ap Detail Publish-001
MODEL_NUMBER
FIF Ap Detail Publish-001
PACKING_SLIP
FIF Ap Detail Publish-001
PRODUCT_TYPE
FIF Ap Detail Publish-001
PROJECT_NAME
FIF Ap Detail Publish Primary
CONTRACT_NAME
FIF Ap Detail Publish Primary
SERIAL_NUMBER
FIF Ap Detail Publish-001
PO_LINE_NUMBER
1
PROJECT_NUMBER
FIF Ap Detail Publish-001
RECEIPT_NUMBER
FIF Ap Detail Publish-001
TRACK_AS_ASSET
FIF Ap Detail Publish-001
ACCOUNTING_DATE
2026-01-01
CONTRACT_NUMBER
FIF Ap Detail Publish-001
INCOME_TAX_TYPE
FIF Ap Detail Publish-001
TAX_REGIME_CODE
STD-FIF_AP-001
TAX_STATUS_CODE
ACTIVE
WARRANTY_NUMBER
FIF Ap Detail Publish-001
ASSESSABLE_VALUE
1
ATTRIBUTE_DATE_1
2026-01-01
ATTRIBUTE_DATE_2
2026-01-01
ATTRIBUTE_DATE_3
2026-01-01
ATTRIBUTE_DATE_4
2026-01-01
ATTRIBUTE_DATE_5
2026-01-01
COST_FACTOR_NAME
FIF Ap Detail Publish Primary
DISTRIBUTION_SET
FIF Ap Detail Publish-001
EXPENDITURE_TYPE
1
INVOICE_QUANTITY
1
ITEM_DESCRIPTION
FIF Ap Detail Publish: Baseline migration row
LINE_DESCRIPTION
FIF Ap Detail Publish: Baseline migration row
PRODUCT_CATEGORY
FIF Ap Detail Publish-001
SHIP_TO_LOCATION
FIF Ap Detail Publish-001
ASSET_CATEGORY_ID
1000000001
FUNDING_SOURCE_ID
SRC-FIF_AP-001
INCOME_TAX_REGION
FIF Ap Detail Publish-001
LINE_GROUP_NUMBER
1
PO_RELEASE_NUMBER
1
ATTRIBUTE_CATEGORY
FIF Ap Detail Publish-001
ATTRIBUTE_NUMBER_1
1
ATTRIBUTE_NUMBER_2
1
ATTRIBUTE_NUMBER_3
1
ATTRIBUTE_NUMBER_4
1
ATTRIBUTE_NUMBER_5
1
FISCAL_CHARGE_TYPE
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_1
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_2
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_3
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_4
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_5
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_6
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_7
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_8
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_9
FIF Ap Detail Publish-001
PO_SCHEDULE_NUMBER
1
SHIP_FROM_LOCATION
FIF Ap Detail Publish-001
TAX_CONTROL_AMOUNT
1
EXPENDITURE_TYPE_ID
1000000001
EXTRACT_DATE_RUN_ID
100001
FUNDING_SOURCE_NAME
FIF Ap Detail Publish Primary
GLOBAL_ATTRIBUTE_10
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_11
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_12
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_13
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_14
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_15
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_16
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_17
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_18
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_19
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_20
FIF Ap Detail Publish-001
PURCHASING_CATEGORY
FIF Ap Detail Publish-001
RECEIPT_LINE_NUMBER
1
REQUESTER_LAST_NAME
FIF Ap Detail Publish Primary
ASSET_BOOK_TYPE_CODE
STD-FIF_AP-001
REQUESTER_FIRST_NAME
FIF Ap Detail Publish Primary
STATISTICAL_QUANTITY
1
EXPENDITURE_ITEM_DATE
2026-01-01
FUNDING_SOURCE_NUMBER
FIF Ap Detail Publish-001
PRICE_CORRECTION_LINE
FIF Ap Detail Publish-001
TAX_JURISDICTION_CODE
STD-FIF_AP-001
WITHHOLDING_TAX_GROUP
FIF Ap Detail Publish-001
EXTERNAL_TAX_RATE_CODE
STD-FIF_AP-001
PO_DISTRIBUTION_NUMBER
1
GLOBAL_ATTRIBUTE_DATE_1
2026-01-01
GLOBAL_ATTRIBUTE_DATE_2
2026-01-01
GLOBAL_ATTRIBUTE_DATE_3
2026-01-01
GLOBAL_ATTRIBUTE_DATE_4
2026-01-01
GLOBAL_ATTRIBUTE_DATE_5
2026-01-01
OVERLAY_ACCOUNT_SEGMENT
FIF Ap Detail Publish-001
PRICE_CORRECTION_INV_NO
FIF Ap Detail Publish-001
TAX_CLASSIFICATION_CODE
STD-FIF_AP-001
DISTRIBUTION_COMBINATION
FIF Ap Detail Publish-001
EXPENDITURE_ORGANIZATION
1
PJC_RESERVED_ATTRIBUTE_2
FIF Ap Detail Publish-001
PJC_RESERVED_ATTRIBUTE_3
FIF Ap Detail Publish-001
PJC_RESERVED_ATTRIBUTE_4
FIF Ap Detail Publish-001
PJC_RESERVED_ATTRIBUTE_5
FIF Ap Detail Publish-001
PJC_RESERVED_ATTRIBUTE_6
FIF Ap Detail Publish-001
PJC_RESERVED_ATTRIBUTE_7
FIF Ap Detail Publish-001
PJC_RESERVED_ATTRIBUTE_8
FIF Ap Detail Publish-001
PJC_RESERVED_ATTRIBUTE_9
FIF Ap Detail Publish-001
CONSUMPTION_ADVICE_NUMBER
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_CATEGORY
FIF Ap Detail Publish-001
GLOBAL_ATTRIBUTE_NUMBER_1
1
GLOBAL_ATTRIBUTE_NUMBER_2
1
GLOBAL_ATTRIBUTE_NUMBER_3
1
GLOBAL_ATTRIBUTE_NUMBER_4
1
GLOBAL_ATTRIBUTE_NUMBER_5
1
PJC_RESERVED_ATTRIBUTE_10
FIF Ap Detail Publish-001
REQUESTER_EMPLOYEE_NUMBER
FIF Ap Detail Publish-001
EXPENDITURE_ORGANIZATION_ID
1000000001
LOCATION_OF_FINAL_DISCHARGE
FIF Ap Detail Publish-001
MULTIPERIOD_ACCOUNT_ACCRUAL
FIF Ap Detail Publish-001
OVERLAY_COST_CENTER_SEGMENT
FIF Ap Detail Publish-001
MULTIPERIOD_ACCOUNT_END_DATE
2026-01-01
PJC_USER_DEFINED_ATTRIBUTE_1
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_2
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_3
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_4
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_5
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_6
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_7
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_8
FIF Ap Detail Publish-001
PJC_USER_DEFINED_ATTRIBUTE_9
FIF Ap Detail Publish-001
PRICE_CORRECTION_INV_LINE_NO
2
PJC_USER_DEFINED_ATTRIBUTE_10
FIF Ap Detail Publish-001
PRODUCT_FISCAL_CLASSIFICATION
FIF Ap Detail Publish-001
PRORATE_ACROSS_ALL_ITEM_LINES
FIF Ap Detail Publish-001
TRANSACTION_BUSINESS_CATEGORY
FIF Ap Detail Publish-001
CONSUMPTION_ADVICE_LINE_NUMBER
1
MULTIPERIOD_ACCOUNT_START_DATE
2026-01-01
OVERLAY_PRIMARY_BALANC_SEGMENT
FIF Ap Detail Publish-001
USER_DEF_FISCAL_CLASSIFICATION
FIF Ap Detail Publish-001
FIF Ap Detail Publish | undefined | Oracle Retail