Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ITEM		System generated item number that defines this commodity within the purchase order.	NUMBER(4)		FPRPOTX	FPRPOTX_ITEM
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_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
PRIORITY		Number used to establish the order in which taxes are to be compounded for a taxed commodity.	NUMBER(2)		FPRPOTX	FPRPOTX_PRIORITY_NUM
PURCHASE_ORDER		User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)		FPRPOTX	FPRPOTX_POHD_CODE
TAXABLE_AMOUNT	Taxable Amount	Amount that is multiplied by the tax rate to give tax amount.	NUMBER(17,2)		FPRPOTX	FPRPOTX_TAXABLE_AMT
TAX_AMOUNT	Tax Amount	Amount of tax computed or entered for a document tax rate.	NUMBER(17,2)		FPRPOTX	FPRPOTX_TAX_AMT
TAX_RATE		Code representing the tax rate.	VARCHAR2(4)		FPRPOTX	FPRPOTX_TRAT_CODE
TAX_RATE_DESC		Tax rate description or title.	VARCHAR2(35)		FTVTRAT	FTVTRAT_DESC
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: