Table GL_Budget

Diagram GL Diagram I Diagram PA

PRIMARY KEY
GL_Budget_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
Name NVARCHAR2 (60) NOT NULL
Description NVARCHAR2 (255)
IsPrimary CHAR (1) default: 'Y' CHECK ( IsPrimary in ( 'Y' , 'N' )) NOT NULL
BudgetStatus CHAR (1)
REFERENCED BY Fact_Acct, Fact_Acct_Balance, GL_Journal, I_GLJournal, PA_ReportColumn, PA_ReportLine