| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| FTVVEND_1099_ADDR_SEQNO |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR VENDOR_TAXABLE_REPORTING |
FEDERAL_ADDRESS_NUMBER FEDERAL_ADDRESS_NUMBER |
NO NO |
|
| FTVVEND_1099_ATYP_CODE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR VENDOR_TAXABLE_REPORTING |
FEDERAL_ADDRESS_TYPE FEDERAL_ADDRESS_TYPE |
NO NO |
|
| FTVVEND_1099_RPT_ID |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR |
TAX_ID |
NO |
NA |
| FTVVEND_ACTIVITY_DATE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
VENDOR_ACTIVITY_DATE VENDOR_ACTIVITY_DATE |
NO NO |
|
| FTVVEND_ADDR_SEQNO |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR |
ORDER_FROM_ADDRESS_NUMBER |
NO |
NA |
| FTVVEND_ATYP_CODE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR |
ORDER_FROM_ADDRESS_TYPE |
NO |
NA |
| FTVVEND_CARRIER_IND |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
CARRIER_VENDOR CARRIER_VENDOR |
NO NO |
|
| FTVVEND_COLLECT_TAX |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
VENDOR_COLLECTS_TAX VENDOR_COLLECTS_TAX |
NO NO |
|
| FTVVEND_CONTACT |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR |
CONTACT_NAME |
NO |
NA |
| FTVVEND_CTRY_CODE_PHONE |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR VENDOR |
COUNTRY_CODE PHONE_COUNTRY_CODE |
NO NO |
|
| FTVVEND_CURR_CODE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
CURRENCY CURRENCY |
NO NO |
|
| FTVVEND_DATA_ORIGIN |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
VENDOR_DATA_ORIGIN |
NO |
|
| FTVVEND_DISC_CODE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
DISCOUNT DISCOUNT |
NO NO |
|
| FTVVEND_EFF_DATE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
VENDOR_START_DATE VENDOR_START_DATE |
NO NO |
|
| FTVVEND_EPROC_IND |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
EPROCUREMENT_VENDOR_IND |
NO |
|
| FTVVEND_FED_WHOLD_PCT |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
FEDERAL_WITHHOLDING_PERCENT |
NO |
|
| FTVVEND_GROUPING_IND |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
INVOICE_GROUPING |
NO |
|
| FTVVEND_IN_ST_IND |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
VENDOR_RESIDENCY |
NO |
|
| FTVVEND_ITYP_SEQ_CODE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
TAX_INCOME_TYPE_KEY TAX_INCOME_TYPE_KEY |
NO NO |
|
| FTVVEND_PHONE_AREA |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR |
PHONE_AREA |
NO |
NA |
| FTVVEND_PHONE_EXT |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR |
PHONE_EXT |
NO |
NA |
| FTVVEND_PHONE_NUMBER |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR |
PHONE_NUMBER |
NO |
NA |
| FTVVEND_PIDM |
NA |
NO |
REPORTING VIEW |
VENDOR_TYPE VENDOR |
VENDOR_UID VENDOR_UID |
NO NO |
NA |
| FTVVEND_PIDM_OWNER |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR VENDOR_TAXABLE_REPORTING |
FEDERAL_REPORT_VENDOR_UID FEDERAL_REPORT_VENDOR_UID FEDERAL_REPORT_VENDOR_UID |
NO NO NO |
|
| FTVVEND_PMT_HOLD_RSN_CODE |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
PAYMENT_HOLD_REASON |
NO |
|
| FTVVEND_PO_HOLD_RSN_CODE |
FTMVEND |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
ORDER_HOLD_REASON ORDER_HOLD_REASON |
NO NO |
|
| FTVVEND_ST_WHOLD_PCT |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
STATE_WITHHOLDING_PERCENT |
NO |
|
| FTVVEND_USER_ID |
FTMVEND |
NO |
REPORTING VIEW |
AF_VENDOR |
VENDOR_USER_ID |
NO |
|
| FTVVEND_VEND_CHECK_ADDR_SEQNO |
FTMVEND |
NO |
|
|
|
|
NA |
| FTVVEND_VEND_CHECK_ATYP_CODE |
FTMVEND |
NO |
|
|
|
|
NA |
| FTVVEND_VEND_CHECK_PIDM |
NA |
NO |
|
|
|
|
NA |