The Treasury open interface tables act as a staging area between your third-party application data and your Treasury data. You can use SQL*Loader to load third-party application data into Treasury. Once the data is loaded into the open interface tables, you can use concurrent programs to import the data from the open interface tables into Treasury tables. For a complete technical definition of all Treasury tables, see the eTRM.
If an interface column is designated as NOT NULL, you must enter a value in the column. It cannot be blank in order to be able to successfully save the data in the table. If a NOT NULL column is left blank, you will receive an error, and will not be able to save the record in the interface table.
A required columns is one in which you must enter data, while an optional field is one you may leave blank. If you do not enter a valid value in the required column field, the record will be rejected during import.
Columns designated as NULL are columns which are to be left unpopulated. If NULL columns are not left unpopulated, the import process will fail.
Enter values in a conditionally required column only if you have entered a value in another column that the conditionally required column is dependent on.
You can use some columns in the interface tables to import additional information. Treasury imports the data that you load into these columns provided that the information passes the validation checks during the import process.
These columns contain values that Treasury uses internally and that the user never sees. You can obtain these values only by looking in the Treasury tables. These ID columns correspond to other columns in the interface table. You do not need to enter a value for any of these ID columns if you enter a value in the corresponding column. For example, if you enter a BANK_NAME, you do not need to enter a BANK_ID.
If you enter values for both columns and the values do not match, the record will be rejected during import.
If you receive any errors when you import data from the open interface tables to Treasury, those errors are listed in the Deal Interface Summary window. You can use the Deal Interface Summary window to review and correct those errors. See: Deal Interface Summary.