FBDI Values for AP_PAYMENT_REQUESTS_INT | Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing Source Value | Comments (DATA Mapping Comment) |
---|---|---|
Transaction Identifier | CI_ADJ_APREQ (AP_REQ_ID) | |
Party Name | CI_ADJ_APREQ (ENTITY_NAME) | |
Party Original System Reference | SA_ID | |
Party Type | Person, Organization, Group or Relationship | |
Location Original System Reference | PREM_ID | |
Country | CI_ADJ_APREQ (COUNTRY) | |
Address Line 1 | CI_ADJ_APREQ (Address 1) | |
Address Line 2 | CI_ADJ_APREQ (Address 2) | |
Address Line 3 | CI_ADJ_APREQ (Address 3) | |
Address Line 4 | CI_ADJ_APREQ (Address 4) | |
Phonetic Address Line | ||
Address Element Attribute 1 | ||
Address Element Attribute 2 | ||
Address Element Attribute 3 | ||
Address Element Attribute 4 | ||
Address Element Attribute 5 | ||
Building | ||
Floor Number | ||
City | CI_ADJ_APREQ (City) | |
State | CI_ADJ_APREQ (State) | |
Province | ||
County | ||
Postal code | CI_ADJ_APREQ (Postal) | |
Postal Plus 4 code | ||
Addressee | ||
Global Location Number | ||
Language | ||
Phone Country Code | ||
Phone Area Code | ||
Phone | ||
Phone Extension | ||
Payee E-mail address | ||
Party Tax Registration Number | ||
Account Country Code | ||
Account Currency Code | ||
Account Number | ||
IBAN | ||
Secondary Account Reference | ||
Account Name | ||
Account Type Code | ||
Bank Name | ||
Bank Number | ||
Bank Branch Name | ||
Bank Branch Number | ||
BIC | ||
Check Digits | ||
Account Description | ||
Account Alternate Name | ||
*Business Unit | Use Business Unit Value in the report configuration in CCS | |
*Source | Default a value in CCB. Setup in ERP, define the value at Payables Lookup, Type= Source). | |
*Invoice Number | CI_ADJ (ADJ_ID) | |
*Invoice Date | CI_ADJ (CRE_DT) | |
*Currency | CI_ADJ (CURRENCY_CD) | |
Description | ||
Import Set | ||
Legal Entity | ||
Payment Terms | ||
Payment Method | ||
Pay Group | ||
Liability Combination | ||
Document Category Code | ||
Voucher Number | ||
Requester First Name | ||
Requester Last Name | ||
Payment Priority | ||
Payment Reason Comments | ||
Attribute Category | ||
Attribute 1 | ||
Attribute 2 | ||
Attribute 3 | ||
Attribute 4 | ||
Attribute 5 | ||
Attribute 6 | ||
Attribute 7 | ||
Attribute 8 | ||
Attribute 9 | ||
Attribute 10 | ||
Attribute 11 | ||
Attribute 12 | ||
Attribute 13 | ||
Attribute 14 | ||
Attribute 15 | ||
Attribute Number 1 | ||
Attribute Number 2 | ||
Attribute Number 3 | ||
Attribute Number 4 | ||
Attribute Number 5 | ||
Attribute Date 1 | ||
Attribute Date 2 | ||
Attribute Date 3 | ||
Attribute Date 4 | ||
Attribute Date 5 | ||
Line Number | The number of the invoice line. | |
*Amount | CI_ADJ (ADJ_AMT) | |
Line Description | Additional or detailed information about the invoice line. This information can be displayed on the check comment. | |
Distribution Combination | Account Combination used for creating invoice distribution. Generally, if left blank, value will be defaulted from setup. | |
Distribution Set | ||
Line Requester First Name | ||
Line Requester Last Name | ||
Line Attribute Category | ||
Line Attribute 1 | ||
Line Attribute 2 | ||
Line Attribute 3 | ||
Line Attribute 4 | ||
Line Attribute 5 | ||
Line Attribute 6 | ||
Line Attribute 7 | ||
Line Attribute 8 | ||
Line Attribute 9 | ||
Line Attribute 10 | ||
Line Attribute 11 | ||
Line Attribute 12 | ||
Line Attribute 13 | ||
Line Attribute 14 | ||
Line Attribute 15 | ||
Line Attribute Number 1 | ||
Line Attribute Number 2 | ||
Line Attribute Number 3 | ||
Line Attribute Number 4 | ||
Line Attribute Number 5 | ||
Line Attribute Date 1 | ||
Line Attribute Date 2 | ||
Line Attribute Date 3 | ||
Line Attribute Date 4 | ||
Line Attribute Date 5 |