Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ITEM	System generated item number that defines this commodity within the purchase order.	NUMBER	FPRPOTX	FPRPOTX_ITEM	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PAY_TAX_TO	Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority.	VARCHAR2(1)	FPRPOTX	FPRPOTX_PAY_TAX_TO	NO	NO
PRIORITY	Number used to establish the order in which taxes are to be compounded for a taxed commodity.	NUMBER	FPRPOTX	FPRPOTX_PRIORITY_NUM	NO	NO
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FPRPOTX	FPRPOTX_POHD_CODE	NO	NO
TAXABLE_AMOUNT	Amount that is multiplied by the tax rate to give tax amount.	NUMBER	FPRPOTX	FPRPOTX_TAXABLE_AMT	NO	NO
TAX_AMOUNT	Amount of tax computed or entered for a document tax rate.	NUMBER	FPRPOTX	FPRPOTX_TAX_AMT	NO	NO
TAX_RATE	Code representing the tax rate.	VARCHAR2(4)	FPRPOTX	FPRPOTX_TRAT_CODE	NO	NO
TAX_RATE_DESC	Tax rate description or title.	VARCHAR2(35)	FTVTRAT	FTVTRAT_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: