Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT_POSTING_STATUS		Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed.	VARCHAR2(1)		TBRAPPL	TBRAPPL_ACCT_FEED_IND
ACCOUNT_POSTING_STATUS_DESC	Account Posting Status Description	Accounting posting status description.	VARCHAR2(255)		FUNCTION	TBD
ACCOUNT_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		TBRAPPL	TBRAPPL_PIDM
APPLIED_AMOUNT		Amount of the payment that paid off the charge.	NUMBER(12, 2)		TBRAPPL	TBRAPPL_AMOUNT
APPL_OF_PAYMENT_ACTIVITY_DATE	Applicant Of Payment Activity Date	Date that information for this record in the table was entered or last updated.	DATE		TBRAPPL	TBRAPPL_ACTIVITY_DATE
APPL_OF_PAYMENT_USER_ID	Applicant Of Payment User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		TBRAPPL	TBRAPPL_USER
CHARGE_TRAN_NUMBER		Transaction number of the detail code used as the charge transaction in application of payments.	NUMBER(8)		TBRAPPL	TBRAPPL_CHG_TRAN_NUMBER
CONTRACT_PAYMENT_TRANSACTION	Contract Payment Transaction	Contract payment transaction number, which together with the pay transaction number identifies the receivable account detail record on which the application of payment is based.	NUMBER		TBRAPPL	TBRAPPL_CPDT_TRAN_NUMBER
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DIRECT_PAYMENT_TYPE	Direct Payment Type	Indicates the direct application of payment type specified when the transaction was entered on the account. Valid values are: T = Direct Transaction Paid, I = Direct Invoice Paid, B = Both Direct Transaction Paid and Invoice Paid, Null = neither Direct Transaction Paid and Invoice Paid.	VARCHAR2(255)		TBRAPPL	TBRAPPL_DIRECT_PAY_TYPE
DIRECT_PAYMENT_TYPE_DESC	Direct Payment Type Description	Direct payment type description	VARCHAR2		FUNCTION	TBD
DIRECT_PAY_IND		Indicates that the transaction was a direct application of payment specified when the transaction was entered on the account.	VARCHAR2(1)		TBRAPPL	TBRAPPL_DIRECT_PAY_IND
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
INVOICE_NUMBER_PAID	Invoice Number Paid	Identification number of the invoice paid by the application of payment.	VARCHAR2(8)		TBRAPPL	TBRAPPL_INV_NUMBER_PAID
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
PAY_TRAN_NUMBER		Transaction number of the detail code used as the payment transaction in application of payments.	NUMBER(8)		TBRAPPL	TBRAPPL_PAY_TRAN_NUMBER
POSTING_DATE		Date the accounting transaction was interfaced to the financial ledgers.	DATE		TBRAPPL	TBRAPPL_FEED_DATE
POSTING_DOCUMENT		Document code generated to identify and feed this transaction to finance.	VARCHAR2(8)		TBRAPPL	TBRAPPL_FEED_DOC_CODE
REAPPLICATION_IND		Indicates that this application of payment record was created because the un-application of payment process had been run for this account. Valid value is: Y - the record was created due to an un-application of payment being processed, or was an original record that was unapplied.	VARCHAR2(1)		TBRAPPL	TBRAPPL_REAPPL_IND
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: