| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACCOUNT
|
Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.
|
VARCHAR2(6)
|
FPRPODA
|
FPRPODA_ACCT_CODE
|
|
ACCOUNT_DESC
|
Account code description or title.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
ACCOUNT_INDEX
|
Account Index used to default an accounting distribution.
|
VARCHAR2(6)
|
FPRPODA
|
FPRPODA_ACCI_CODE
|
|
ACCOUNT_INDEX_DESC
|
Description of the account index.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
ACCOUNT_INDEX_STATUS
|
Extracted current status of the associated account index.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
ACCOUNT_STATUS
|
Current status of the associated account.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
ACTIVITY
|
Code used to identify accounting data by activity.
|
VARCHAR2(6)
|
FPRPODA
|
FPRPODA_ACTV_CODE
|
|
ACTIVITY_DATE
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
FPRPODA
|
FPRPODA_ACTIVITY_DATE
|
|
ACTIVITY_DESC
|
Activity code title or description.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
ACTIVITY_STATUS
|
Extracted current status of the associated activity.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
ADDITIONAL_AMOUNT
|
Amount of additional charges for this invoice accounting amount on this invoice or purchase order.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_ADDL_CHRG_AMT,0)
|
|
ADDITIONAL_AMOUNT_RULE_CLASS
|
Accounting transaction code used to post to the ledgers for purchase order additional charges when using non-consolidated posting.
|
VARCHAR2(4)
|
FPRPODA
|
FPRPODA_ADDL_RUCL_CODE
|
|
ADDITIONAL_AMT_RULE_CLASS_DESC
|
Purchase order additional charges rule class code description.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
ADDITIONAL_CHARGE_PERCENT
|
Additional amount percent used for the purchase order accounting transcation.
|
NUMBER(7, 4)
|
FPRPODA
|
FPRPODA_ADDL_AMT_PCT
|
|
AMOUNT
|
Amount related to a purchase order's accounting line.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_AMT,0)
|
|
APPROVED_CHARGE_AMOUNT
|
Calculation to determine the actual cost within an accounting line.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_AMT,0)+NVL(FPRPODA_ADDL_CHRG_AMT,0)+NVL(FPRPODA_TAX_AMT,0)-NVL(FPRPODA_DISC_AMT,0)
|
|
CHART_OF_ACCOUNTS
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(1)
|
FPRPODA
|
FPRPODA_COAS_CODE
|
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts code description or title.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
CHART_OF_ACCOUNTS_STATUS
|
Extracted current status of the associated chart of accounts.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
CLOSED_IND
|
Indicates if the document has been closed from an encumbrance perspective.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(FPRPODA_CLOSED_IND,'N')
|
|
CONVERTED_ADDITIONAL_AMOUNT
|
Base currency additional charges amount calculated for this accounting record.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0)
|
|
CONVERTED_AMOUNT
|
Base currency amount calculated for this accounting record.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_CONVERT_AMT,0)
|
|
CONVERTED_DISCOUNT_AMOUNT
|
Base currency discount amount calculated for this accounting record.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_CONVERT_DISC_AMT,0)
|
|
CONVERTED_TAX_AMOUNT
|
Base currency tax amount calculated for this accounting record.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_CONVERT_TAX_AMT,0)
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
|
DISCOUNT_AMOUNT
|
Value of the discount taken on the invoice or purchase order accounting amount.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_DISC_AMT,0)
|
|
DISCOUNT_PERCENT
|
Discount percent for the purchase order accounting transaction.
|
NUMBER(7, 4)
|
FPRPODA
|
FPRPODA_DISC_AMT_PCT
|
|
DISCOUNT_RULE_CLASS
|
Accounting transaction code used to post to the ledgers for a purchase order discount when using non-consolidated posting.
|
VARCHAR2(4)
|
FPRPODA
|
FPRPODA_DISC_RUCL_CODE
|
|
DISCOUNT_RULE_CLASS_DESC
|
Purchase order discount rule class code description.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
DISTRIBUTION_PERCENT
|
Percentage of the of the transaction total amount assigned to this accounting distribution.
|
NUMBER(7, 4)
|
FPRPODA
|
FPRPODA_APPR_AMT_PCT
|
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
|
ENCUMBRANCE_ADJUSTMENT_AMOUNT
|
Encumbrance amount that will be posted to the encumbrance ledger to adjust the encumbrance to accurately reflect the new purchase order change amount and any encumbrance liquidations.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_ENCB_ADJT_AMT,0)
|
|
FISCAL_PERIOD
|
Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.
|
VARCHAR2(2)
|
FPRPODA
|
FPRPODA_PERIOD
|
|
FISCAL_YEAR
|
This field is a unique numeric identifier code for the fiscal year.
|
VARCHAR2(4)
|
FUNCTION
|
FOFYCNV
|
|
FUND
|
Unique fiscal entity code.
|
VARCHAR2(6)
|
FPRPODA
|
FPRPODA_FUND_CODE
|
|
FUND_DESC
|
Description or title of the associated fund.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
FUND_STATUS
|
Extracted current status of the associated fund.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
ITEM
|
System-generated item number which defines this commodity within the purchase order.
|
NUMBER(4)
|
FPRPODA
|
FPRPODA_ITEM
|
|
LIQUIDATION_RULE_CLASS
|
Accounting transaction code used to post to the ledgers for purchase order liquidations against the original encumbrance.
|
VARCHAR2(4)
|
FPRPODA
|
FPRPODA_RUCL_CODE_LIQ
|
|
LIQUIDATION_RULE_CLASS_DESC
|
Purchase order liquidation rule class code description.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
LOCATION
|
Identification accounting code of the physical location of the financial manager.
|
VARCHAR2(6)
|
FPRPODA
|
FPRPODA_LOCN_CODE
|
|
LOCATION_DESC
|
Extracted description or title of the associated location.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
LOCATION_STATUS
|
Extracted current status of the associated location.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
|
NSF_OVERRIDE_IND
|
Indicates if the transaction's non sufficient funds was overriden.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(FPRPODA_NSF_OVERRIDE_IND,'N')
|
|
NSF_SUSPENSE
|
Indicates that the transaction has been suspended due to a lack of budget.
|
VARCHAR2(1)
|
FPRPODA
|
FPRPODA_NSF_SUSP_IND
|
|
NSF_SUSPENSE_DESC
|
Description of the suspended code.
|
VARCHAR2(10)
|
CALCULATION
|
DECODE(FPRPODA_NSF_SUSP_IND)
|
|
ORGANIZATION_CODE
|
Identification accounting code used for the department.
|
VARCHAR2(6)
|
FPRPODA
|
FPRPODA_ORGN_CODE
|
|
ORGANIZATION_DESC
|
Extracted description or title associated with the organization code.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
ORGANIZATION_STATUS
|
Extracted current status of the associated organization.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
PROGRAM
|
Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.
|
VARCHAR2(6)
|
FPRPODA
|
FPRPODA_PROG_CODE
|
|
PROGRAM_DESC
|
Program code description.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
PROGRAM_STATUS
|
Extracted current status of the associated program.
|
VARCHAR2(1)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_STATUS
|
|
PROJECT
|
Work order code used to identify a cost accounting project.
|
VARCHAR2(8)
|
FPRPODA
|
FPRPODA_PROJ_CODE
|
|
PROJECT_DESC
|
Project description
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
|
PURCHASE_ORDER
|
User-defined or system assigned one-up purchase order number issued to this vendor.
|
VARCHAR2(8)
|
FPRPODA
|
FPRPODA_POHD_CODE
|
|
RULE_CLASS
|
Accounting transaction code defining rules used to control transactional updates to the ledgers.
|
VARCHAR2(4)
|
FPRPODA
|
FPRPODA_RUCL_CODE_PO
|
|
RULE_CLASS_DESC
|
Purchase order rule class code description.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
SEQUENCE_NUMBER
|
System-generated one-up number to support split accounting within a document.
|
NUMBER(4)
|
FPRPODA
|
FPRPODA_SEQ_NUM
|
|
SUSPENSE_IND
|
Indicator used to inform the user that a document is being held in suspense due to missing or erroneous data content on the accounting line.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(FPRPODA_SUSP_IND,'N')
|
|
TAX_AMOUNT
|
Amount of tax computed or entered for a document accounting amount.
|
NUMBER
|
CALCULATION
|
NVL(FPRPODA_TAX_AMT,0)
|
|
TAX_PERCENT
|
Tax percent used for the purchase order accounting transcation.
|
NUMBER(7, 4)
|
FPRPODA
|
FPRPODA_TAX_AMT_PCT
|
|
TAX_RULE_CLASS
|
Accounting transaction code used to post to the ledgers for purchase order taxes when using non-consolidated posting.
|
VARCHAR2(4)
|
FPRPODA
|
FPRPODA_TAX_RUCL_CODE
|
|
TAX_RULE_CLASS_DESC
|
Purchase order tax rule class code description.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
TRANSACTION_DATE
|
The date the transaction was posted.
|
DATE
|
FPRPODA
|
FPRPODA_POST_DATE
|
|
USER_ID
|
Unique identification code of the user who entered or last modified the item.
|
VARCHAR2(30)
|
FPRPODA
|
FPRPODA_USER_ID
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|