raja Table: Historical General Ledger Pool Account
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

raja Table: Historical General Ledger Pool Account

Parent Table

Name Description
raj Historical General Ledger Pool

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7
raja_idx0 por_s com_s reg_s off_s pool_id_s ym_eom_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
com_s
Company
CHAR(2) no
reg_s
Region
CHAR(2) no
off_s
Office
CHAR(3) no
pool_id_s
Pool ID
CHAR(10) no
ym_eom_s
Month end when created (YYYYMM)
CHAR(6) no
unique_l
Record number (possible values are 0 to 850)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
acct_balance_d
GL account amount
NUMBER(15,2) yes