Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FTVSHIP Finance
SGHE Banner Operational Data Store Composite View Source: FTVSHIP - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVSHIP_ADDR_LINE1 FTMSHIP COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

AF_PURCHASE_ORDER

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_ITEM

AF_PURCHASE_ORDER

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_ITEM

AF_PURCHASE_ORDER

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_ITEM

AF_PURCHASE_ORDER

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.0