ColumnName |
Domain |
Datatype |
NULL |
Definition |
USER_COMPANY_ID |
|
VARCHAR2(30) |
NO |
Name: Domain. Description: Alias for database schema that will be updated. |
S_IMPORT_CD |
|
VARCHAR2(1) |
NO |
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table. |
EXTERNAL_USER |
|
VARCHAR2(20) |
NO |
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. |
CURRENCY_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Currency Schedule. Description: The identifier for the currency schedule |
EFFECTIVE_DT |
|
DATE |
NO |
Name: Effective Date. Description: The date the exchange rate was effective. |
FROM_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
Name: From Currency Code. Description: The Currency code of the transaction that is being converted. |
TO_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
Name: To Currency Code. Description: The Currency code being converted to. |
EXCHANGE_RATE |
|
NUMBER(20, 10) |
NO |
Name: Exchange Rate. Description: The exchange rate. |