Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
SPRTELE_ADDR_SEQNO |
SPATELE |
NO |
REPORTING VIEW |
TELEPHONE_CURRENT TELEPHONE |
ADDRESS_NUMBER ADDRESS_NUMBER |
NO NO |
NA |
SPRTELE_ATYP_CODE |
SPATELE |
NO |
REPORTING VIEW |
TELEPHONE TELEPHONE_CURRENT |
ADDRESS_TYPE ADDRESS_TYPE |
NO NO |
NA |
SPRTELE_COMMENT |
SPATELE |
NO |
REPORTING VIEW |
TELEPHONE_CURRENT ADDRESS_PREFERRED TELEPHONE |
PHONE_COMMENT PHONE_COMMENT PHONE_COMMENT |
NO NO NO |
NA |
SPRTELE_CTRY_CODE_PHONE |
TBD |
NO |
REPORTING VIEW |
ORGANIZATION_CONTACT ORGANIZATION_CONTACT ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT |
PHONE_COUNTRY_CODE FAX_COUNTRY_CODE COUNTRY_CODE COUNTRY_CODE COUNTRY_CODE |
NO NO NO NO NO |
|
SPRTELE_INTL_ACCESS |
SPATELE |
NO |
REPORTING VIEW |
ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT |
PHONE_INTL_ACCESS PHONE_INTL_ACCESS PHONE_INTL_ACCESS |
NO NO NO |
NA |
SPRTELE_PHONE_AREA |
SPATELE |
NO |
REPORTING VIEW |
ORGANIZATION_CONTACT ORGANIZATION_CONTACT TELEPHONE ORGANIZATION_CONTACT_SLOT PHONE_ASSIGNMENT TELEPHONE_CURRENT GRANT_PERSONNEL ORGANIZATION_CONTACT_SLOT ADDRESS_PREFERRED |
FAX_AREA PHONE_AREA PHONE_AREA PHONE_AREA_2 PHONE_AREA PHONE_AREA PHONE_AREA PHONE_AREA_1 PHONE_AREA |
NO NO NO NO NO NO NO NO NO |
NA |
SPRTELE_PHONE_EXT |
SPATELE |
NO |
REPORTING VIEW |
ORGANIZATION_CONTACT ADDRESS_PREFERRED ORGANIZATION_CONTACT_SLOT GRANT_PERSONNEL ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT TELEPHONE_CURRENT TELEPHONE |
FAX_EXT PHONE_EXT PHONE_EXT_1 PHONE_EXT PHONE_EXT_2 PHONE_EXT PHONE_EXT PHONE_EXT |
NO NO NO NO NO NO NO NO |
NA |
SPRTELE_PHONE_NUMBER |
SPATELE |
NO |
REPORTING VIEW |
ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT TELEPHONE TELEPHONE_CURRENT ORGANIZATION_CONTACT GRANT_PERSONNEL ADDRESS_PREFERRED ORGANIZATION_CONTACT_SLOT |
PHONE_NUMBER PHONE_NUMBER_1 PHONE_NUMBER PHONE_NUMBER FAX_NUMBER PHONE_NUMBER PHONE_NUMBER PHONE_NUMBER_2 |
NO NO NO NO NO NO NO NO |
NA |
SPRTELE_PIDM |
NA |
NO |
|
|
|
|
NA |
SPRTELE_PRIMARY_IND |
SPATELE |
NO |
REPORTING VIEW |
TELEPHONE ADDRESS_PREFERRED TELEPHONE_CURRENT |
PHONE_PRIMARY_IND PHONE_PRIMARY_IND PHONE_PRIMARY_IND |
NO NO NO |
NA |
SPRTELE_SEQNO |
SPATELE |
NO |
REPORTING VIEW |
ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT |
PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER |
NO NO NO |
NA |
SPRTELE_STATUS_IND |
SPATELE |
NO |
REPORTING VIEW |
ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT |
PHONE_STATUS_IND PHONE_STATUS_IND PHONE_STATUS_IND |
NO NO NO |
NA |
SPRTELE_TELE_CODE |
SPATELE |
NO |
REPORTING VIEW |
VENDOR PERSON TELEPHONE TELEPHONE_CURRENT VENDOR ADDRESS_PREFERRED ORGANIZATION_ENTITY |
ORDER_FROM_PHONE_TYPE PHONE_TYPE PHONE_TYPE PHONE_TYPE REMIT_TO_PHONE_TYPE PHONE_TYPE PHONE_TYPE |
NO NO NO NO NO NO NO |
NA |
SPRTELE_UNLIST_IND |
SPATELE |
NO |
REPORTING VIEW |
ORGANIZATION_ENTITY ORGANIZATION_CONTACT
TELEPHONE_CURRENT ADDRESS_PREFERRED VENDOR
ORGANIZATION_CONTACT PERSON TELEPHONE
VENDOR
|
PHONE_UNLIST_IND FAX_UNLIST_IND
PHONE_UNLIST_IND PHONE_UNLIST_IND
REMIT_TO_PHONE_UNLIST_IND PHONE_UNLIST_IND
PHONE_UNLIST_IND PHONE_UNLIST_IND
ORDER_FROM_PHONE_UNLIST_IND
|
NO NO NO NO NO NO NO NO NO |
NA |