Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FPRPODT	FPRPODT_ACTIVITY_DATE	NO	NO
ADDITIONAL_CHARGES_AMOUNT	Amount of additional charges for the commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_ADDL_CHRG_AMT,0)	NO	NO
AGREEMENT_MINIMUM_QUANTITY	The minimum quanity that can be ordered for the specified commodity and unit of measure.	NUMBER	FUNCTION	FOKODSF.F_GET_MIN_QUANTITY	NO	NO
APPROVED_ITEM_AMOUNT	Calculation to determine the actual cost of an item.	NUMBER	CALCULATION	(NVL(FPRPODT_QTY,0)*NVL(FPRPODT_UNIT_PRICE,0))+NVL(FPRPODT_ADDL_CHRG_AMT,0)+NVL(FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT,0)	NO	NO
BID_NUMBER	Bid number.	VARCHAR2(8)	FPRBIDD	FPRBIDD_BIDH_CODE	NO	NO
BLANKET_ORDER_REMAINING_BAL	Contains the remaining balance of the blanket order.	NUMBER	FPRPODT	FPRPODT_BO_REMAIN_BAL	NO	NO
BUILDING	Name for the building associated with a specific shipping address.	VARCHAR2(15)	FTVSHIP	FTVSHIP_BUILDING	NO	NO
CANCEL_DATE	Date the purchase order was cancelled.	DATE	FPRPODT	FPRPODT_CANCEL_DATE	NO	NO
CANCEL_IND	Indicates if the purchase order was canceled.	VARCHAR2(1)	FPRPODT	FPRPODT_CANCEL_IND	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	FTVSHIP	FTVSHIP_CARRIER_ROUTE	NO	NO
CHANGE_ORDER_AMOUNT	Gross value of the change order.	NUMBER	FPRPODT	FPRPODT_EXT_AMT	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(50)	FTVSHIP	FTVSHIP_CITY	NO	NO
CLOSED_IND	Indicates if the document has been closed from an encumbrance perspective.	VARCHAR2(1)	FPRPODT	FPRPODT_CLOSED_IND	NO	NO
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(10)	FPRPODT	FPRPODT_COMM_CODE	NO	NO
COMMODITY_DESC	Commodity description or title.	VARCHAR2(50)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COMMODITY_DESC_CHANGE_IND	Indicates when the default commodity description has been overwritten in the purchase order.	VARCHAR2(1)	CALCULATION	NVL(FPRPODT_DESC_CHGE_IND,'N')	NO	NO
CONTACT_NAME	Name or title of the primary contact for the ship-to address. Used as an attention-to field.	VARCHAR2(35)	FTVSHIP	FTVSHIP_CONTACT	NO	NO
CONVERTED_ADDITNAL_AMOUNT	Base currency additional charges amount calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)	NO	NO
CONVERTED_APPROVED_ITEM_AMOUNT	Calculation to determine the actual converted cost of an item.	NUMBER				NO
CONVERTED_DISCOUNT_AMOUNT	Base currency discount amount calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_DISC_AMT,0)	NO	NO
CONVERTED_TAX_AMOUNT	Base currency tax amount calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_TAX_AMT,0)	NO	NO
CONVERTED_UNIT_PRICE	Base currency unit price calculated for this commodity record.	NUMBER	CALCULATION	NVL(FPRPODT_CONVERT_UNIT_PRICE,0)	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	FTVSHIP	FTVSHIP_CORRECTION_DIGIT	NO	NO
COUNTY	County for this address.	VARCHAR2(1)	NA	NA	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(1)	NA	NA	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	FTVSHIP	FTVSHIP_DELIVERY_POINT	NO	NO
DISCOUNT_AMOUNT	Value of the discount taken on the invoice or purchase order accounting amount.	NUMBER	CALCULATION	NVL(FPRPODT_DISC_AMT,0)	NO	NO
DISCOUNT_PERCENT	Extract discount percent for the purchase order from the discount code.	NUMBER	FUNCTION	FOKODSF.F_PO_DISC_PCT	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
FLOOR	Floor number specific to the shipping address.	VARCHAR2(10)	FTVSHIP	FTVSHIP_FLOOR	NO	NO
ITEM	System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER	FPRPODT	FPRPODT_ITEM	NO	NO
ITEM_CHANGE_ORDER	Last change sequence number of the purchase order.	NUMBER	FUNCTION	FOKODSF.F_PO_ITEM_LAST_CHANGE_SEQNO	NO	NO
ITEM_DELIVERY_DATE	Date given to the vendors as a required deliver by date.	DATE	FPRPODT	FPRPODT_REQD_DATE	NO	NO
LIQUIDATION_AMOUNT	Amount that has been liquidated against the original encumbrance.	NUMBER	CALCULATION	NVL(FPRPODT_LIQ_AMT,0)	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
NATION	Nation/country code associated with the address.	VARCHAR2(5)	FTVSHIP	FTVSHIP_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PHONE_AREA	Phone area code for the ship-to address.	VARCHAR2(6)	FTVSHIP	FTVSHIP_PHONE_AREA	NO	NO
PHONE_EXT	Phone extension number for the ship-to address.	VARCHAR2(10)	FTVSHIP	FTVSHIP_PHONE_EXT	NO	NO
PHONE_INTL_ACCESS	Free format international access code for telephone number including country and city code.	VARCHAR2(1)	NA	NA	NO	NO
PHONE_NUMBER	Phone number for the ship-to address.	VARCHAR2(12)	FTVSHIP	FTVSHIP_PHONE_NUM	NO	NO
PHONE_NUMBER_COMBINED	Extracted combined phone number for the ship to address.	VARCHAR2(28)	CALCULATION	FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||FTVSHIP_PHONE_EXT	NO	NO
PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.	VARCHAR2(1)	NA	NA	NO	NO
POSTAL_CODE	Postal code associated with the ship-to address.	VARCHAR2(30)	FTVSHIP	FTVSHIP_ZIP_CODE	NO	NO
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FPRPODT	FPRPODT_POHD_CODE	NO	NO
QUANTITY	Number of units ordered.	NUMBER	CALCULATION	NVL(FPRPODT_QTY,0)	NO	NO
REQUESTOR_NAME	Name of the person who is submitting the purchase order.	VARCHAR2(35)	FPBPOHD	FPBPOHD_NAME	NO	NO
REQUISITION	User-defined or system assigned one-up requisition number.	VARCHAR2(8)	FPRREQD	FPRREQD_REQH_CODE	NO	NO
REQUISITION_NUMBER	System assigned one-up number of the commodity on the requisition item.	NUMBER	FPRREQD	FPRREQD_ITEM	NO	NO
SHIPMENT_TO_ADDRESS	Code representing the shipment address.	VARCHAR2(6)	FPRPODT	FPRPODT_SHIP_CODE	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(3)	FTVSHIP	FTVSHIP_STATE	NO	NO
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(75)	FTVSHIP	FTVSHIP_ADDR_LINE1	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(75)	FTVSHIP	FTVSHIP_ADDR_LINE2	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(75)	FTVSHIP	FTVSHIP_ADDR_LINE3	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(30)	NA	NA	NO	NO
SUSPENSE_IND	Indicator used to inform the user that a document is being held in suspense due to missing or erroneous data content.	VARCHAR2(1)	FPRPODT	FPRPODT_SUSP_IND	NO	NO
TAX_AMOUNT	Amount of tax computed or entered for a document item.	NUMBER	CALCULATION	NVL(FPRPODT_TAX_AMT,0)	NO	NO
TAX_GROUP	Tax group code to be used for this commodity record.	VARCHAR2(4)	FPRPODT	FPRPODT_TGRP_CODE	NO	NO
TAX_GROUP_DESC	Tax group description.	VARCHAR2(35)	FTVTGRP	FTVTGRP_TITLE	NO	NO
TEXT_USAGE	Indicates if attached text is standard, user modified, or to be ignored.	VARCHAR2(1)	FPRPODT	FPRPODT_TEXT_USAGE	NO	NO
TEXT_USAGE_DESC	Description of the text usage.	VARCHAR2(10)	CALCULATION	DECODE(FPRPODT_TEXT_USAGE)	NO	NO
UNIT_OF_MEASURE	Unit of measure applicable to the selected commodity.	VARCHAR2(3)	FPRPODT	FPRPODT_UOMS_CODE	NO	NO
UNIT_OF_MEASURE_DESC	Description or title of the unit of measure.	VARCHAR2(35)	FTVUOMS	FTVUOMS_DESC	NO	NO
UNIT_PRICE	Unit price for goods and or services.	NUMBER	CALCULATION	NVL(FPRPODT_UNIT_PRICE,0)	NO	NO
USER_ID	Unique identification code of the user who entered or last modified the item.	VARCHAR2(30)	FPRPODT	FPRPODT_USER_ID	NO	NO
VENDOR_AGREEMENT	Code identifying an established agreement with a vendor for a specified unit price, minimum quantity and maximum dollar amount when ordering a specific commodity and unit of measure for that commodity.	VARCHAR2(15)	FPRPODT	FPRPODT_AGRE_CODE	NO	NO
VENDOR_REFERENCE_NUMBER	Vendor reference or part number for a commodity item provided.	VARCHAR2(15)	FPRPODT	FPRPODT_VEND_REF_NUM	NO	NO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FPBPOHD	FPBPOHD_VEND_PIDM	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: