5.11.2.3 Creating Load Table
This step is applicable for loading ledger data from Type I or Type II load table.
Staging table STG_GL_DATA (used for Type III load) is packaged with the
application. Multiple load tables (Type I or Type II) can be created as required by the
System Administrator. Table structure for the Type I and Type II load tables is given in
the following sections:
-- --------------------------------------------------------------------
-- Uncomment the m1..m12 columns if you plan to load a range of months (Type II Load Table).
-- Add lines for all of the LEDGER_STAT user-defined leaf columns in the
place
-- indicated below. Don't forget to add commas if you need to.
CREATE TABLE &load_table_name( ds VARCHAR2(12) NOT NULL, -- data_source
year_s NUMBER(5) NOT NULL, accum_type char(1) NOT NULL, consolidat NUMBER(5) NOT
NULL, isocrncycd VARCHAR2(3) DEFAULT '002' NOT NULL, financ_id NUMBER(14) NOT NULL,
org_id NUMBER(14) NOT NULL, gl_acct_id NUMBER(14) NOT NULL, cmn_coa_id NUMBER(14)
NOT NULL, prdct_id NUMBER(14) NOT NULL, baltypecd NUMBER(5) DEFAULT 0 NOT NULL, --
-- m1 NUMBER(15,4), -- m2 NUMBER(15,4), -- m3 NUMBER(15,4), -- m4 NUMBER(15,4), --
m5 NUMBER(15,4), -- m6 NUMBER(15,4), -- m7 NUMBER(15,4), -- m8 NUMBER(15,4), -- m9
NUMBER(15,4), -- m10 NUMBER(15,4), -- m11 NUMBER(15,4), -- m12 NUMBER(15,4), --
one_month_amt NUMBER(15,4) -- --
-------------------------------------------------------------------- -- Other leaf
columns (PROPERTY_COLUMN from REV_COLUMN_PROPERTIES for LEDGER_STAT): --
------------------------------------------------------------- -- . . . --
)
-- -------------------------------------------------------------------