|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
ldu_upload_dtl |
Gives the legacy details |
ou_id |
int |
Organization Unit Id |
Yes |
No |
|
|
|
|
fb_id |
sql_variant |
Finance Book Id |
|
|
|
|
|
|
finance_year |
|
Finance Year |
|
|
|
|
|
|
finance_period |
|
Finance Period |
|
|
|
|
|
|
account_code |
|
Account Code |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
currency_code |
sql_variant |
Currency Code |
|
|
|
|
|
|
drcr_flag |
|
Debit Credit Flag |
|
|
|
|
|
|
base_amount |
bigint |
Base Amount |
|
|
|
|
|
|
tran_amount |
|
Transaction Amount |
|
|
|
|
|
|
createdby |
sql_variant |
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
ldu_upload_tmp |
|
ou_id |
int |
Organization Unit Id |
Yes |
|
|
|
|
|
fb_id |
sql_variant |
Finance Book Id |
|
|
|
|
|
|
finance_year |
|
Finance Year |
|
|
|
|
|
|
finance_period |
|
Finance Period |
|
|
|
|
|
|
account_code |
|
Account Code |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
currency_code |
sql_variant |
Currency Code |
|
|
|
|
|
|
drcr_flag |
|
Debit Credit Flag |
|
|
|
|
|
|
base_amount |
bigint |
Base Amount |
|
|
|
|
|
|
tran_amount |
|
Transaction Amount |
|
|
|
|
|
|
error_id |
int |
Error I d |
|
|
|
|
|
|
error_dtl |
sql_variant |
Error Detail |
|
|
|
|
|
|
upl_flag |
|
Upload Flag |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|