📚 SAP Business One SDK Help

Table Name: ORTT

Table Description: CPI and FC Rates

Field Description Type Size Related Default Value Constraints
RateDate Exchange Rate Date Date 8 -      
Currency Currency Code nVarChar 3 -      
Rate Currency Rate Num 19.6 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
LogInstanc Log Instance Int 11 - 0    
UpdateDate Date of Update Date 8 -      
UserSign2 Updating User Int 11 OUSR      
Key Unique Field
PRIMARY Yes RateDate
    Currency
DATE No RateDate