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

Ver: