Table GL_JournalLine

Diagram GL Diagram I

PRIMARY KEY
GL_JournalLine_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
GL_Journal_ID NUMBER (10, 0) NOT NULL		GL_Journal
Line NUMBER (10, 0) NOT NULL
IsGenerated CHAR (1) default: 'N' CHECK ( IsGenerated in ( 'Y' , 'N' )) NOT NULL
Description NVARCHAR2 (255)
AmtSourceDr NUMBER default: 0 NOT NULL
AmtSourceCr NUMBER default: 0 NOT NULL
C_Currency_ID NUMBER (10, 0) NOT NULL		C_Currency
C_ConversionType_ID NUMBER (10, 0) NOT NULL		C_ConversionType
CurrencyRate NUMBER default: 0 NOT NULL
DateAcct DATE NOT NULL
AmtAcctDr NUMBER default: 0 NOT NULL
AmtAcctCr NUMBER default: 0 NOT NULL
C_UOM_ID NUMBER (10, 0)		C_UOM
Qty NUMBER default: 0
C_ValidCombination_ID NUMBER (10, 0) NOT NULL		C_ValidCombination
FOREIGN KEY ADClient_GLJournalLine: AD_Client_ID => AD_Client ADOrg_GLJournalLine: AD_Org_ID => AD_Org CConversionType_GLJournalLine: C_ConversionType_ID => C_ConversionType CCurrency_GLJournalLine: C_Currency_ID => C_Currency CUOM_GLJournalLine: C_UOM_ID => C_UOM CVC_GLJournalLine: C_ValidCombination_ID => C_ValidCombination GLJournal_GLJournalLine: GL_Journal_ID => GL_Journal
REFERENCED BY I_GLJournal