Table GL_Journal

Diagram C Diagram GL Diagram I

PRIMARY KEY
GL_Journal_ID NUMBER (10, 0) NOT NULL

AD_Client_ID NUMBER (10, 0) NOT NULL
AD_Org_ID NUMBER (10, 0) NOT NULL
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
C_AcctSchema_ID NUMBER (10, 0) NOT NULL		C_AcctSchema
C_DocType_ID NUMBER (10, 0) NOT NULL		C_DocType
DocumentNo NVARCHAR2 (30) NOT NULL
DocStatus CHAR (2) NOT NULL
DocAction CHAR (2) NOT NULL
IsApproved CHAR (1) default: 'N' CHECK ( IsApproved in ( 'Y' , 'N' )) NOT NULL
IsPrinted CHAR (1) default: 'N' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL
Description NVARCHAR2 (255) NOT NULL
PostingType CHAR (1) NOT NULL
GL_Budget_ID NUMBER (10, 0)		GL_Budget
GL_Category_ID NUMBER (10, 0) NOT NULL		GL_Category
DateDoc DATE NOT NULL
DateAcct DATE NOT NULL
C_Period_ID NUMBER (10, 0) NOT NULL		C_Period
C_Currency_ID NUMBER (10, 0)		C_Currency
C_ConversionType_ID NUMBER (10, 0) NOT NULL		C_ConversionType
CurrencyRate NUMBER default: 0 NOT NULL
GL_JournalBatch_ID NUMBER (10, 0)		GL_JournalBatch
TotalDr NUMBER default: 0 NOT NULL
TotalCr NUMBER default: 0 NOT NULL
ControlAmt NUMBER default: 0
Processing CHAR (1)
Processed CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' ))
Posted CHAR (1) default: 'N' NOT NULL
FOREIGN KEY C_AcctSchema_GL_Journal: C_AcctSchema_ID => C_AcctSchema C_Period_Journal: C_Period_ID => C_Period CConversionType_GLJournal: C_ConversionType_ID => C_ConversionType CCurrency_GLJournal: C_Currency_ID => C_Currency CDocType_GLJournal: C_DocType_ID => C_DocType GLBudget_GLJournal: GL_Budget_ID => GL_Budget GLCategory_GLJournal: GL_Category_ID => GL_Category GLJournalBatch_GLJournal: GL_JournalBatch_ID => GL_JournalBatch
REFERENCED BY C_RevenueRecognition_Run, GL_JournalLine, I_GLJournal