| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACCOUNT_ACTUAL_COST_AMOUNT
|
Account Actual Cost Amount
|
Actual cost amount of the transaction.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_ACTUAL_COST_AMT
|
|
ACCOUNT_AMOUNT
|
Account Amount
|
Amount of the transaction.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_AMOUNT
|
|
ACCOUNT_BALANCE
|
Account Balance
|
Remaining balance of the charge amount on the transaction.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_BALANCE
|
|
ACCOUNT_CHART_OF_ACCOUNTS
|
Account Chart Of Accounts
|
Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_COAS_CODE
|
|
ACCOUNT_CHART_OF_ACCOUNTS_DESC
|
Account Chart Of Accounts Description
|
Retrieved description or title of the associated chart of accounts.
|
VARCHAR2(255)
|
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
ACCOUNT_FUND
|
Account Fund
|
Funding source code used with this accounting transaction.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_FUND_CODE
|
|
ACCOUNT_FUND_DESC
|
Account Fund Description
|
Retrieved description or title of the associated fund.
|
VARCHAR2(255)
|
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
ACCOUNT_FUND_STATUS
|
Account Fund Status
|
Extracted current status of the associated fund.
|
VARCHAR2(63)
|
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
|
ACCOUNT_POSTING_STATUS
|
Account Posting Status
|
Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_ACCT_FEED_IND
|
|
ACCOUNT_TRANSACTION_NUMBER
|
Account Transaction Number
|
A unique one up number assigned to each transaction within the grants account.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_TRAN_NUMBER
|
|
ACCT_CHART_OF_ACCOUNTS_STATUS
|
Account Chart Of Accounts Status
|
Status of the account chart of accounts.
|
VARCHAR2(63)
|
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
|
ADJUSTED_BILLED_INVOICE_NUMBER
|
Adjusted Billed Invoice Number
|
Billed invoice number adjusted on the charge.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_BILL_INV_ADJ_NO
|
|
ADJUSTED_PAID_INVOICE_NUMBER
|
Adjusted Paid Invoice Number
|
Adjusted invoice number paid with the payment.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_PAID_INV_ADJ_NO
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
BILLED_INVOICE_NUMBER
|
Billed Invoice Number
|
Invoice number billed on the charge.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_BILL_INV_SEQ_NO
|
|
BILL_DATE
|
Bill Date
|
Date that the transaction was billed.
|
DATE
|
|
TRRACCD
|
TRRACCD_BILL_DATE
|
|
CASHIER_END_DATE
|
Cashier End Date
|
Ending date of the cashiering session for the transaction.
|
DATE
|
|
TRRACCD
|
TRRACCD_CSHR_END_DATE
|
|
CASHIER_END_TIME
|
Cashier End Time
|
Ending time of the cashiering session for the transaction.
|
VARCHAR2(63)
|
|
CALCULATION
|
TO_CHAR(TBRACCD_CSHR_END_DATE)
|
|
CASHIER_SESSION_NUMBER
|
Cashier Session Number
|
Session number assigned to each cashier session.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_SESSION_NUMBER
|
|
DETAIL_CODE
|
Detail Code
|
Code defining type of transaction in accounts receivable.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_DETAIL_CODE
|
|
DETAIL_CODE_DESC
|
Detail Code Description
|
Transaction type description.
|
VARCHAR2(255)
|
|
TBBDETC
|
TBBDETC_DESC
|
|
DETAIL_CODE_TYPE
|
Detail Code Type
|
Determines if the detail code is being used as a charge or a payment.
|
VARCHAR2(63)
|
|
TBBDETC
|
TBBDETC_TYPE_IND
|
|
EFFECTIVE_DATE
|
Effective Date
|
Date the transaction becomes effective. As of this date, the transaction is calculated into amount due and is eligible to be fed to accounting.
|
DATE
|
|
TRRACCD
|
TRRACCD_EFFECTIVE_DATE
|
|
ENTRY_DATE
|
Entry Date
|
Date the transaction was entered on the account.
|
DATE
|
|
TRRACCD
|
TRRACCD_ENTRY_DATE
|
|
GRANT_ID
|
Grant ID
|
Unique user defined or system generated one-up number for this grant.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_GRNT_CODE
|
|
LETTER_OF_CREDIT_NUMBER
|
Letter Of Credit Number
|
Actual letter of credit number associated to the payment management system code.
|
VARCHAR2(63)
|
|
FRVPMSC
|
FRVPMSC_LOC_NO
|
|
LONG_TITLE
|
Long Title
|
Grant long title or description.
|
VARCHAR2(256)
|
|
FRBGRNT
|
FRBGRNT_LONG_TITLE
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
PAID_INVOICE_NUMBER
|
Paid Invoice Number
|
Invoice number paid with the payment.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_PAID_INV_SEQ_NO
|
|
PAYMENT_MANAGEMENT_SYS_CODE
|
Payment Management Sys Code
|
Unique identifier assigned as a payment management system code within grants, containing the letter of credit number and a amount limit that can be drawn on a letter of credit.
|
VARCHAR2(63)
|
|
FRBGBIL
|
FRBGBIL_PMSC_CODE
|
|
PAYMENT_MANAGEMENT_SYS_DESC
|
Payment Management Sys Description
|
Payment management system description.
|
VARCHAR2(255)
|
|
FRVPMSC
|
FRVPMSC_DESC
|
|
PAYMENT_REFERENCE_NUMBER
|
Payment Reference Number
|
External reference number of item used to make payment. Can be credit card, wire payment, check number, etc.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_PAYMENT_ID
|
|
POSTING_DATE
|
Posting Date
|
Date the accounting transaction was interfaced to the financial ledgers.
|
DATE
|
|
TRRACCD
|
TRRACCD_FEED_DATE
|
|
POSTING_DOCUMENT
|
Posting Document
|
Document code generated to identify and feed this transaction to finance.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_FEED_DOC_CODE
|
|
POST_CASHIER
|
Post Cashier
|
Identification code of the cashier who entered the transaction.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_USER_ID
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
REBILL_IND
|
Rebill Indicator
|
Used to trigger payment rebill on the account.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_REBILL_IND
|
|
SHORT_TITLE
|
Short Title
|
Short name or title for the grant.
|
VARCHAR2(255)
|
|
FRBGRNT
|
FRBGRNT_TITLE
|
|
SOURCE
|
Source
|
Identifies the source of how the transaction was entered on the account.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_SRCE_CODE
|
|
SOURCE_DESC
|
Source Description
|
Source code extracted description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
TRANSACTION_DATE
|
Transaction Date
|
Date used by the finance system to control posting to the ledgers.
|
DATE
|
|
TRRACCD
|
TRRACCD_TRANS_DATE
|
|
TRANSACTION_DESC
|
Transaction Description
|
Accounting transaction description.
|
VARCHAR2(255)
|
|
TRRACCD
|
TRRACCD_DESC
|
|
TRANSACTION_NUMBER_PAID
|
Transaction Number Paid
|
Specified transaction number used to apply a payment directly against with this transaction.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_TRAN_NUMBER_PAID
|
|
WITHHOLDING_AMOUNT
|
Withholding Amount
|
Amount to withhold from the billed agency.
|
NUMBER
|
|
TRRACCD
|
TRRACCD_WITHHOLDING_AMT
|
|
WITHHOLDING_IND
|
Withholding Indicator
|
Determines if withholding an amount to the billed agency.
|
VARCHAR2(63)
|
|
TRRACCD
|
TRRACCD_WITHHOLDING_IND
|