MTM_PRODNM_TBL(SQL Table) |
Index Back |
---|---|
MTM Supplier info tableAnalytics/Filexport supplier/Product information table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | MTM_VENDOR_NM | Character(20) | VARCHAR2(20) NOT NULL |
3rd party analytics vendor used for valuation and analytics.
Prompt Table: MTM_VENDORNM_VW |
2 | MTM_SRC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Represents the type of interface method (Excel/COM/FSI/File Format)
COM=Component Object Model FLE=File Format FSI=Peoplesoft Financial Services XLA=Excel Add-In |
3 | TR_STAGE_TBL_RECNM | Character(15) | VARCHAR2(15) NOT NULL |
An internal work field that contains the EDI staging table name.
Prompt Table: MTM_STG_TBL_VW |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | MTM_FN_OR_MCRO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to designate whether a Microsoft Excel-based third party analytics solution
F=Function M=Macro |
6 | MTM_WRKBOOK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate that a Microsoft Excel workbook object is required in order to execut
Y/N Table Edit Default Value: N |
7 | MTM_CONTACT | Character(20) | VARCHAR2(20) NOT NULL | Vendor contact representative name for treasury-selected third party analytics application. |
8 | MTM_CNTCT_TITLE | Character(20) | VARCHAR2(20) NOT NULL | Vendor contact representative title for treasury-selected third party analytics application. |
9 | MTM_CNTCT_PHONE | Character(20) | VARCHAR2(20) NOT NULL | Vendor contact representative phone number for treasury-selected third party analytics application |
10 | MTM_CNTCT_LOC | Character(20) | VARCHAR2(20) NOT NULL | Vendor contact representative address for treasury-selected third party analytics application. |
11 | MTM_INTERFACE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
mtm interface type
C=COM Interface F=FSI interface L=File Export Interface X=Excel interface |
12 | MTM_MAP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
The technical interface method utilized by the Treasury product to submit and receive third party analytic
CO=COM Functions FE=File Export FN=Function FS=FSI Functions |
13 | FILE_PATH_NAME | Character(254) | VARCHAR2(254) NOT NULL | File Path |