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	FPBPOHD	FPBPOHD_ACTIVITY_DATE	NO	NO
ADDITIONAL_AMOUNT	Amount of additional charges e.g.freight for this purchase order.	NUMBER	FPBPOHD	FPBPOHD_ADDL_CHRG_AMT	NO	NO
APPROVAL_IND	Indicates the document has met final approval.	VARCHAR2(1)	FPBPOHD	FPBPOHD_APPR_IND	NO	NO
BLANKET_ORDER	Blanket code the purchase order was created from.	VARCHAR2(8)	FPBPOHD	FPBPOHD_BLANKET_CODE	NO	NO
BLANKET_ORDER_IND	Blanket indicator.	VARCHAR2(1)	CALCULATION	NVL(FPBPOHD_BLANKET_IND,'N')	NO	NO
BUILDING	Name for the building associated with a specific shipping address.	VARCHAR2(15)	FTVSHIP	FTVSHIP_BUILDING	NO	NO
BUYER	Code used to identify a purchasing buyer.	VARCHAR2(4)	FPBPOHD	FPBPOHD_BUYR_CODE	NO	NO
BUYER_NAME	Name of the buyer.	VARCHAR2(35)	FTVBUYR	FTVBUYR_NAME	NO	NO
CANCEL_DATE	Date the purchase order was cancelled.	DATE	FPBPOHD	FPBPOHD_CANCEL_DATE	NO	NO
CANCEL_IND	Indicates if the purchase order was canceled.	VARCHAR2(1)	CALCULATION	NVL(FPBPOHD_CANCEL_IND,'N')	NO	NO
CANCEL_REASON	Reason the purchase order was cancelled.	VARCHAR2(4)	FPBPOHD	FPBPOHD_CRSN_CODE	NO	NO
CANCEL_REASON_DESC	Retrieves the description of the cancel reason.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FTVCRSN_DESC	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	FTVSHIP	FTVSHIP_CARRIER_ROUTE	NO	NO
CARRIER_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FPBPOHD	FPBPOHD_CARRIER_PIDM	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FPBPOHD	FPBPOHD_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(50)	FTVSHIP	FTVSHIP_CITY	NO	NO
CLOSED_DATE	Date that the purchase order is closed.	DATE	FPBPOHD	FPBPOHD_CLOSED_DATE	NO	NO
CLOSED_IND	Indicates if the document has been closed from an encumbrance perspective.	VARCHAR2(1)	CALCULATION	NVL(FPBPOHD_CLOSED_IND,'N')	NO	NO
COMPLETE_IND	Indicates if the purchase order document is complete.	VARCHAR2(1)	FPBPOHD	FPBPOHD_COMPLETE_IND	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
COPIED_PURCHASE_ORDER	Purchahse order code of the document copied.	VARCHAR2(8)	FPBPOHD	FPBPOHD_COPIED_FROM	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	FTVSHIP	FTVSHIP_CORRECTION_DIGIT	NO	NO
COUNTY	The county code associated with the entity's address.	VARCHAR2(63)	NA	NA	NO	NO
COUNTY_DESC	The description of the county code associated with the entity's address.	VARCHAR2(255)	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	Default discount code representing the value of the discount to be taken on the purchase order accounting amount.	VARCHAR2(2)	FPBPOHD	FPBPOHD_DISC_CODE	NO	NO
DISCOUNT_DESC	Discount description.	VARCHAR2(35)	FTVDISC	FTVDISC_DESC	NO	NO
DISCOUNT_PERCENT	Discount percent.	NUMBER	FTVDISC	FTVDISC_PCT	NO	NO
DOCUMENT_SOURCE	If the purchase order has been created via an eprocuremnt system, this is set to EPROC-SYSTEM CODE. The default is BANNER. If PO is created from the self-service module then it can be set to SELF_SERVICE.	VARCHAR2(26)	FPBPOHD	FPBPOHD_ORIGIN_CODE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EDI_IND	Indicates if the purchase order is to be sent via electronic data transfer.	VARCHAR2(1)	CALCULATION	NVL(FPBPOHD_EDI_IND,'N')	NO	NO
FLOOR	Floor number specific to the shipping address.	VARCHAR2(10)	FTVSHIP	FTVSHIP_FLOOR	NO	NO
FREIGHT_TERMS	Freight terms code indicating the method of payment for freight.	VARCHAR2(2)	FPBPOHD	FPBPOHD_FTRM_CODE	NO	NO
FREIGHT_TERMS_DESC	Freight terms code description.	VARCHAR2(30)	FTVFTRM	FTVFTRM_DESC	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
ORDER_FROM_ADDRESS_TYPE	This field identifies the address type of the vendor address.	VARCHAR2(2)	FPBPOHD	FPBPOHD_ATYP_CODE	NO	NO
ORDER_FROM_ADDRESS_TYPE_DESC	Description for the address type of the vendor.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ORDER_FROM_ADDRESS_TYPE_NUMBER	Sequence number of the order from address for the vendor.	NUMBER	FPBPOHD	FPBPOHD_ATYP_SEQ_NUM	NO	NO
ORGANIZATION_CODE	Identification accounting code used for the department.	VARCHAR2(6)	FPBPOHD	FPBPOHD_ORGN_CODE	NO	NO
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_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(63)	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	The indicator that specifies if the phone number is to be unlisted or not.	VARCHAR2(1)	NA	NA	NO	NO
POSTAL_CODE	Postal code associated with the ship-to address.	VARCHAR2(30)	FTVSHIP	FTVSHIP_ZIP_CODE	NO	NO
PO_CHANGE_DATE	Last posted date for the purchase order change.	DATE	FUNCTION	FOKODSF.F_PO_LAST_CHANGE_DATE	NO	NO
PO_CHANGE_ORDER	Last change number for the purchase order change.	VARCHAR2(40)	FUNCTION	FOKODSF.F_PO_LAST_CHANGE_SEQNO	NO	NO
PO_END_DATE	Purchase Order end date representing either the termination date of a blanket order or the end date of a rush order.	DATE	CALCULATION	NVL(FPBPOHD_REXP_DATE,FPBPOHD_BLANKET_TERM_DATE)	NO	NO
PO_START_DATE	Purchase order start date.	DATE	NA	NA	NO	NO
PRINTED_DATE	Date on which a purchase order was printed.	DATE	FPBPOHD	FPBPOHD_PO_PRINTED_DATE	NO	NO
PRINT_IND	Indicates if the document has been printed.	VARCHAR2(1)	CALCULATION	NVL(FPBPOHD_PRINT_IND,'N')	NO	NO
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FPBPOHD	FPBPOHD_CODE	NO	NO
PURCHASE_ORDER_CLASS	Shipping classification code for the commodity. Such as hazardous substance.	VARCHAR2(1)	FPBPOHD	FPBPOHD_PCLS_CODE	NO	NO
PURCHASE_ORDER_CLASS_DESC	Shipping classification description.	VARCHAR2(35)	FTVPCLS	FTVPCLS_DESC	NO	NO
PURCHASE_ORDER_DATE	Date on which a purchase order was created.	DATE	FPBPOHD	FPBPOHD_PO_DATE	NO	NO
PURCHASE_ORDER_TYPE	Purchase order type.	VARCHAR2(1)	FPBPOHD	FPBPOHD_PO_TYPE_IND	NO	NO
PURCHASE_ORDER_TYPE_DESC	The purchase order type description.	VARCHAR2(30)	CALCULATION	DECODE(FPBPOHD_PO_TYPE_IND)	NO	NO
PURCHASE_ORDER_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FPBPOHD	FPBPOHD_USER_ID	NO	NO
RECEIVING_REQUIRED	Indicates whether Invoices associated with this Purchase Orders will require Matching. Valid values are [N]o matching, [Y]es matching, [U] for no matching.	VARCHAR2(1)	FPBPOHD	FPBPOHD_MATCH_REQUIRED	NO	NO
RECEIVING_REQUIRED_DESC	Description of the receiving required code.	VARCHAR2(15)	CALCULATION	DECODE(FPBPOHD_MATCH_REQUIRED)	NO	NO
REQUESTOR_EMAIL_ADDRESS	Requestor email address.	VARCHAR2(128)	FPBPOHD	FPBPOHD_EMAIL_ADDR	NO	NO
REQUESTOR_FAX_AREA	Requestor fax area code.	VARCHAR2(6)	FPBPOHD	FPBPOHD_FAX_AREA	NO	NO
REQUESTOR_FAX_EXT	Requestor fax number extension.	VARCHAR2(10)	FPBPOHD	FPBPOHD_FAX_EXT	NO	NO
REQUESTOR_FAX_NUMBER	Requestor fax telephone number.	VARCHAR2(12)	FPBPOHD	FPBPOHD_FAX_NUMBER	NO	NO
REQUESTOR_NAME	Name of the person who is submitting the purchase order.	VARCHAR2(35)	FPBPOHD	FPBPOHD_NAME	NO	NO
REQUESTOR_PHONE_AREA	Requestor's area code.	VARCHAR2(6)	FPBPOHD	FPBPOHD_PHONE_AREA	NO	NO
REQUESTOR_PHONE_EXT	Requestor's phone number extension.	VARCHAR2(10)	FPBPOHD	FPBPOHD_PHONE_EXT	NO	NO
REQUESTOR_PHONE_NUMBER	Requestor's telephone number.	VARCHAR2(12)	FPBPOHD	FPBPOHD_PHONE_NUM	NO	NO
REQUIRED_DATE	Date given to the vendors as a required deliver by date.	DATE	FPBPOHD	FPBPOHD_REQD_DATE	NO	NO
REQUISITION_OR_BID_SOURCE	Requisition or bid indicator. Values are (B)id, (R)equisition, or null.	VARCHAR2(1)	FPBPOHD	FPBPOHD_REQ_BID_IND	NO	NO
REQUISITION_OR_BID_SOURCE_DESC	Description of the requisition or bid code.	VARCHAR2(15)	CALCULATION	DECODE(FPBPOHD_REQ_BID_IND)	NO	NO
REQUISITION_TEXT	Indicates if the document has associated text.	VARCHAR2(1)	FPBPOHD	FPBPOHD_TEXT_IND	NO	NO
REQUISITION_TEXT_DESC	Description of the requisition text.	VARCHAR2(25)	CALCULATION	DECODE(FPBPOHD_TEXT_IND)	NO	NO
RUSH_AMOUNT	Maximum dollar amount permissible for a rush purchase order.	NUMBER	FPBPOHD	FPBPOHD_RUSH_AMT	NO	NO
RUSH_ORDER_IND	Indicates is this is a rush purchase order.	VARCHAR2(1)	FPBPOHD	FPBPOHD_RUSH_IND	NO	NO
SHIPPING_ADDRESS	Code representing the shipment address.	VARCHAR2(6)	FPBPOHD	FPBPOHD_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(63)	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)	CALCULATION	NVL(FPBPOHD_SUSP_IND,'N')	NO	NO
THIRD_PARTY_DOCUMENT	Third party eproc system purchase order number. Banner will always create a new po number for Purchase Orders from eprocurement..	VARCHAR2(20)	FPBPOHD	FPBPOHD_DOC_REF_CODE	NO	NO
TOTAL_APPROVED_ITEM_AMOUNT	Total approved amount for all items in the purchase order calculated as unit price time quantity plus taxes plus additional charges minus discounts.	NUMBER	FUNCTION	FOKODSF.F_CALC_TOT_APPROV_ITEM_AMT	NO	NO
TOTAL_BLANKET_ORDER_BAL	Calculates blanket order balance for all items in the purchase order.	NUMBER	FUNCTION	FOKODSF.F_CALC_BLANKET_ORDER_BAL	NO	NO
TOTAL_CONVERTED_AMOUNT	Total conversion amount approved for all purchase order items calculated as unit price time quantity plus taxes plus additional charges minus discounts.	NUMBER	FUNCTION	FOKODSF.F_CALC_TOT_CONVERT_ITEM_AMT	NO	NO
TRANSACTION_DATE	Purchase order accounting transaction date used to post to the ledgers determining the posting fiscal year and fiscal period.	DATE	FPBPOHD	FPBPOHD_TRANS_DATE	NO	NO
VENDOR_CONTACT	Vendor's contact.	VARCHAR2(35)	FPBPOHD	FPBPOHD_VENDOR_CONTACT	NO	NO
VENDOR_EMAIL_ADDRESS	Vendor's email address.	VARCHAR2(128)	FPBPOHD	FPBPOHD_VEND_EMAIL_ADDR	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: