Table C_Currency

Diagram AD  Diagram GL  Diagram I  Diagram M  Diagram PA  Diagram S  Diagram T 

PRIMARY KEY
C_Currency_ID NUMBER (10, 0) NOT NULL
AD_Client_ID NUMBER (10, 0) NOT NULL		AD_Client
AD_Org_ID NUMBER (10, 0) NOT NULL		AD_Org
IsActive CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL
Created DATE default: SYSDATE NOT NULL
CreatedBy NUMBER (10, 0) NOT NULL
Updated DATE default: SYSDATE NOT NULL
UpdatedBy NUMBER (10, 0) NOT NULL
ISO_Code CHAR (3) NOT NULL
CurSymbol NVARCHAR2 (10)
Description NVARCHAR2 (255) NOT NULL
StdPrecision NUMBER (10, 0) NOT NULL
CostingPrecision NUMBER (10, 0) NOT NULL
IsEuro CHAR (1) default: 'N' CHECK ( IsEuro in ( 'Y' , 'N' )) NOT NULL
IsEMUMember CHAR (1) default: 'N' CHECK ( IsEMUMember in ( 'Y' , 'N' )) NOT NULL
EMUEntryDate DATE
EMURate NUMBER default: 0
FOREIGN KEY C_CurrencyClient: AD_Client_ID => AD_Client C_CurrencyOrg: AD_Org_ID => AD_Org
REFERENCED BY AD_Role, C_AcctSchema, C_Allocation, C_BankAccount, C_BankStatementLine, C_CashBook, C_CashLine, C_Commission, C_CommissionDetail, C_Conversion_Rate, C_Conversion_Rate, C_Country, C_Currency_Acct, C_Currency_Trl, C_Cycle, C_ElementValue, C_Invoice, C_Order, C_OrderLine, C_Payment, C_PaymentProcessor, C_Project, C_RevenueRecognition_Plan, C_RfQ, C_RfQResponse, Fact_Acct, GL_Journal, GL_JournalBatch, GL_JournalLine, I_BankStatement, I_Conversion_Rate, I_Conversion_Rate, I_GLJournal, I_Invoice, I_Order, I_Product, M_Freight, M_PriceList, M_Product_PO, PA_ReportColumn, S_TimeExpenseLine, T_Aging, T_InventoryValue