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

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVVEND_1099_ADDR_SEQNO FTMVEND        
FTVVEND_1099_ATYP_CODE FTMVEND        
FTVVEND_1099_RPT_ID FTMVEND COMPOSITE VIEW

AF_VENDOR

TAX_ID

NA
FTVVEND_ACTIVITY_DATE FTMVEND        
FTVVEND_ADDR_SEQNO FTMVEND COMPOSITE VIEW

AF_VENDOR

ORDER_FROM_ADDRESS_NUMBER

NA
FTVVEND_ATYP_CODE FTMVEND COMPOSITE VIEW

AF_VENDOR

ORDER_FROM_ADDRESS_TYPE

NA
FTVVEND_CARRIER_IND FTMVEND        
FTVVEND_COLLECT_TAX FTMVEND        
FTVVEND_CONTACT FTMVEND COMPOSITE VIEW

AF_VENDOR

CONTACT_NAME

NA
FTVVEND_CTRY_CODE_PHONE FTMVEND        
FTVVEND_CURR_CODE FTMVEND        
FTVVEND_DATA_ORIGIN FTMVEND        
FTVVEND_DISC_CODE FTMVEND        
FTVVEND_EFF_DATE FTMVEND        
FTVVEND_EPROC_IND FTMVEND        
FTVVEND_FED_WHOLD_PCT FTMVEND        
FTVVEND_GROUPING_IND FTMVEND        
FTVVEND_IN_ST_IND FTMVEND        
FTVVEND_ITYP_SEQ_CODE FTMVEND        
FTVVEND_PHONE_AREA FTMVEND COMPOSITE VIEW

AF_VENDOR

PHONE_AREA

NA
FTVVEND_PHONE_EXT FTMVEND COMPOSITE VIEW

AF_VENDOR

PHONE_EXT

NA
FTVVEND_PHONE_NUMBER FTMVEND COMPOSITE VIEW

AF_VENDOR

PHONE_NUMBER

NA
FTVVEND_PIDM NA COMPOSITE VIEW

AF_VENDOR

VENDOR_UID

NA
FTVVEND_PIDM_OWNER FTMVEND        
FTVVEND_PMT_HOLD_RSN_CODE FTMVEND        
FTVVEND_PO_HOLD_RSN_CODE FTMVEND        
FTVVEND_ST_WHOLD_PCT FTMVEND        
FTVVEND_USER_ID FTMVEND        
FTVVEND_VEND_CHECK_ADDR_SEQNO FTMVEND COMPOSITE VIEW

AF_VENDOR

REMIT_TO_ADDRESS_NUMBER

NA
FTVVEND_VEND_CHECK_ATYP_CODE FTMVEND COMPOSITE VIEW

AF_VENDOR

REMIT_TO_ADDRESS_TYPE

NA
FTVVEND_VEND_CHECK_PIDM NA COMPOSITE VIEW

AF_VENDOR

REMIT_TO_VENDOR_UID

NA


Ver: