Composite View Source: FTVSHIP

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: FTVSHIP Finance

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FTVSHIP_ADDR_LINE1	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	STREET_LINE1 STREET_LINE1	NA
FTVSHIP_ADDR_LINE2	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	STREET_LINE2 STREET_LINE2	NA
FTVSHIP_ADDR_LINE3	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	STREET_LINE3 STREET_LINE3	NA
FTVSHIP_BUILDING	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	BUILDING BUILDING	NA
FTVSHIP_CARRIER_ROUTE	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	CARRIER_ROUTE CARRIER_ROUTE	NA
FTVSHIP_CITY	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	CITY CITY	NA
FTVSHIP_CONTACT	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	CONTACT_NAME CONTACT_NAME	NA
FTVSHIP_CORRECTION_DIGIT	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	CORRECTION_DIGIT CORRECTION_DIGIT	NA
FTVSHIP_DELIVERY_POINT	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	DELIVERY_POINT DELIVERY_POINT	NA
FTVSHIP_FLOOR	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	FLOOR FLOOR	NA
FTVSHIP_NATN_CODE	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	NATION NATION	NA
FTVSHIP_PHONE_AREA	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	PHONE_AREA PHONE_AREA	NA
FTVSHIP_PHONE_EXT	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	PHONE_EXT PHONE_EXT	NA
FTVSHIP_PHONE_NUM	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	PHONE_NUMBER PHONE_NUMBER	NA
FTVSHIP_STATE	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	STATE_PROVINCE STATE_PROVINCE	NA
FTVSHIP_ZIP_CODE	FTMSHIP	COMPOSITE VIEW	AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ITEM	POSTAL_CODE POSTAL_CODE	NA

Ver: 8.1