FSL |
|||||||
|
|
|
||||||
|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
dbo |
fsl_layis_tmp |
|
guid |
sql_variant |
Guid |
No |
No |
|
|
|
|
sch_no |
|
Schedule Number |
|
|
|
|
|
|
sch_desc |
|
Schedule Description |
|
|
|
|
|
|
serial_no |
int |
Serial Number |
|
|
|
|
|
|
cb_drcr |
sql_variant |
Closing Balance Debit Credit |
|
|
|
|
|
|
close_bal |
bigint |
Close Balance |
|
|
|
|
|
|
comp_close_bal |
|
Company Closing Balance |
|
|
|
|
|
|
schlay_operation |
sql_variant |
Schedule Layout Operation |
|
|
|
|
|
|
schlay_type |
|
Schedule Layout Type |
|
|
|
|
|
|
disp_flag |
int |
Display Flag |
|
|
|
|
|
|
fin_year |
sql_variant |
Finance Year |
|
|
|
|
|
|
fbid |
fin_financebook |
Finance Book |
|
|
|
|
fsl_schacc_rel |
Gives the details about account schedules |
schedule_no |
|
Schedule Number |
Yes |
|
|
|
|
|
acc_sch_no |
|
Account Schedule Number |
|
|
|
|
|
|
fb_id |
|
Finance Book Id |
|
|
|
|
|
|
company_code |
|
Company Code |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
type |
sql_variant |
Type |
|
|
|
|
|
|
parsch_no |
|
Parent Schedule Number |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
fsl_schlay_dtl |
Gives the schedule layout details |
company_code |
sql_variant |
Company Code |
Yes |
|
|
|
|
|
schlay_no |
|
Schedule Layout Number |
|
|
|
|
|
|
acc_sch_no |
|
Account Schedule Number |
|
|
|
|
|
|
fb_id |
|
Finance Book Id |
|
|
|
|
|
|
sch_layout_flag |
|
Schedule Layout Flag |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
schlay_type |
sql_variant |
Schedule Layout Type |
|
|
|
|
|
|
line_no |
int |
Line Number |
|
|
|
|
|
|
grp_incl_flag |
sql_variant |
Group Inclusion Flag |
|
|
|
|
|
|
schlay_incl_flag |
|
Schedule Layout Group Inclusion |
|
|
|
|
|
|
sequence_no |
int |
Sequence Number |
|
|
|
|
|
|
acc_flag_bal |
sql_variant |
Account Flag Balance |
|
|
|
|
|
|
schlay_operation |
|
Schedule Layout |
|
|
|
|
|
|
schedule_printview |
|
Schedule Print View |
|
|
|
|
|
|
group_desc |
|
Group Description |
|
|
|
|
|
|
schlay_tot_desc |
|
Schedule Layout Total Description |
|
|
|
|
|
|
par_secgrp |
|
Parent Schedule Group |
|
|
|
|
|
|
total_sequence |
int |
Total Sequence |
|
|
|
|
|
|
total_operation |
sql_variant |
Total Operation |
|
|
|
|
|
|
total_view |
|
Total View |
|
|
|
|
|
|
total_bal_flag |
|
Total Balance Flag |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
fsl_schlay_hdr |
Gives the schedule layout header information |
company_code |
sql_variant |
Company Code |
Yes |
|
|
|
|
|
schlay_no |
|
Schedule Layout Number |
|
|
|
|
|
|
sch_layout_flag |
|
Schedule Layout Flag |
|
|
|
|
|
|
fb_id |
|
Finance Book Id |
|
|
|
|
|
|
fb_type |
|
Finance Book Type |
|
|
|
|
|
|
status |
|
Status.Values 0 Inactive,1 Active |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
schlay_desc |
sql_variant |
Schedule Layout Description |
|
|
|
|
|
|
schlay_class |
|
Schedule Layout Class |
|
|
|
|
|
|
effective_from |
datetime |
Effective From |
|
|
|
|
|
|
effective_to |
|
Effective To |
|
|
|
|
|
|
coa_id |
sql_variant |
Chart Of Account Id |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
fsl_schlay_hdr_tmp |
|
timestamp |
int |
Time Stamp |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
company_code |
|
Company Code |
|
|
|
|
|
|
schlay_class |
|
Schedule Layout |
|
|
|
|
|
|
fb_type |
|
Finance Book Type |
|
|
|
|
|
|
fb_id |
|
Finance Book |
|
|
|
|
|
|
coa_id |
|
Chart Of Account Id |
|
|
|
|
|
|
seq_flag |
|
Sequence Flag |
|
|
|
|
|
|
sr_line_no |
int |
Serial Line Number |
|
|
|
|
|
|
schlay_no |
sql_variant |
Schedule Layout |
|
|
|
|
|
|
line_flag |
|
Line Flag |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
fsl_schlay_tmp |
|
timestamp |
int |
Time Stamp |
|
|
|
|
|
|
guid |
sql_variant |
Guide |
|
|
|
|
|
|
company_code |
|
Company Code |
|
|
|
|
|
|
schlay_no |
|
Schedule Layout |
|
|
|
|
|
|
acc_sch_no |
|
Account Schedule Layout |
|
|
|
|
|
|
schlay_type |
|
Schedule Layout Type |
|
|
|
|
|
|
fb_id |
|
Finance Book Id |
|
|
|
|
|
|
fb_type |
|
Finance Book Type |
|
|
|
|
|
|
line_no |
int |
Line Number |
|
|
|
|
|
|
incl_flag |
sql_variant |
Inclusion Flag |
|
|
|
|
|
|
grp_incl_flag |
|
Group Inclusion Flag |
|
|
|
|
|
|
sch_incl_flag |
|
Schedule Inclusion Flag |
|
|
|
|
|
|
account_desc |
|
Account Description |
|
|
|
|
|
|
account_group |
|
Account Group |
|
|
|
|
|
|
sequence_no |
int |
Sequence Number |
|
|
|
|
|
|
acc_flag_bal |
sql_variant |
Account Flag Balance |
|
|
|
|
|
|
schlay_operation |
|
Schedule Operation |
|
|
|
|
|
|
schlay_indent |
int |
Schedule Layout Indent |
|
|
|
|
|
|
schedule_printview |
sql_variant |
Schedule Print View |
|
|
|
|
|
|
group_desc |
|
Group Description |
|
|
|
|
|
|
schlay_tot_desc |
|
Schedule Layout Total Description |
|
|
|
|
|
|
new_line_no |
int |
New Line Number |
|
|
|
|
|
|
schlay_class |
sql_variant |
Schedule Layout Class |
|
|
|
|
|
|
par_secgrp |
|
Parent Schedule Group |
|
|
|
|
|
|
total_sequence |
int |
Total Sequence |
|
|
|
|
|
|
total_operation |
sql_variant |
Total Operation |
|
|
|
|
|
|
total_bal_flag |
|
Total Balance Flag |
|
|
|
|
|
|
total_view |
|
Total View |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
|
|
grp_desc |
sql_variant |
Group Description |
|
|
|
|
fsl_layout_sch_dtl |
|
fsl_compcode |
fin_companycode |
Company Code |
|
|
|
|
|
|
fsl_fbid |
fin_financebook |
Finance Book |
|
|
|
|
|
|
fsl_layoutno |
fin_desc255 |
Layout No. |
|
|
|
|
|
|
fsl_layouttype |
fin_flag |
Layout Type |
|
|
|
|
|
|
fsl_schno |
fin_desc255 |
Schedule No. |
|
|
|
|
|
|
fsl_schdetdesc |
fin_desc255 |
Schedule Detail Description |
|
|
|
|
|
|
fsl_schdesc |
fin_text255 |
Schedule Description |
|
|
|
|
|
|
fsl_parschno |
fin_desc255 |
Parent Schedule Number |
|
|
|
|
|
|
fsl_schtype |
fin_flag |
Schedule Type |
|
|
|
|
|
|
fsl_grpno |
fin_desc255 |
Group No. |
|
|
|
|
|
|
fsl_srlno |
fin_number |
Serial No. |
|
|
|
|
|
|
fsl_lineno |
fin_number |
Line No. |
|
|
|
|
|
|
fsl_operation |
fin_action |
Operation Code |
|
|
|
|
|
|
fsl_guid |
fin_guid |
Guide |
|
|
|
|
fsl_layout_sch_bal_dtl |
|
Fslbal_guid |
fin_guid |
Guide |
|
|
|
|
|
|
Fslbal_companycode |
fin_companycode |
Company Code |
|
|
|
|
|
|
Fslbal_pkg_ref_no |
fin_mac_rpttype |
Package Reference No. |
|
|
|
|
|
|
Fslbal_due_date |
fin_datetime |
Due date |
|
|
|
|
|
|
Fslbal_rpt_code |
fin_hrtext20 |
Report Code |
|
|
|
|
|
|
Fslbal_sheet_code |
fin_targetcode |
Sheet Code |
|
|
|
|
|
|
Fslbal_run_no |
fin_mac_rpttype |
Run No. |
|
|
|
|
|
|
Fslbal_fbid |
fin_financebookid |
Finance Book Id |
|
|
|
|
|
|
Fslbal_schno |
fin_desc255 |
Schedule No. |
|
|
|
|
|
|
Fslbal_schdesc |
fin_desc120 |
Schedule Description |
|
|
|
|
|
|
Fslbal_parschno |
fin_desc255 |
Parent Schedule Number |
|
|
|
|
|
|
Fslbal_schlaytype |
fin_flag |
Schedule Type |
|
|
|
|
|
|
Fslbal_groupno |
fin_desc255 |
Group No. |
|
|
|
|
|
|
Fslbal_serialno |
fin_number |
Serial Number |
|
|
|
|
|
|
Fslbal_lineno |
fin_number |
Line Number |
|
|
|
|
|
|
Fslbal_seqno |
fin_number |
Sequence Number |
|
|
|
|
|
|
Fslbal_obdrcr |
fin_drcridentifier |
Debit Credit Flag |
|
|
|
|
|
|
Fslbal_openbal |
fin_amount |
Opening Balance |
|
|
|
|
|
|
Fslbal_prddrcr |
fin_drcridentifier |
Period Debit-Credit |
|
|
|
|
|
|
Fslbal_prddebit |
fin_amount |
Period Debit |
|
|
|
|
|
|
Fslbal_prdcredit |
fin_amount |
Period Credit |
|
|
|
|
|
|
Fslbal_prdbal |
fin_amount |
Period Balance |
|
|
|
|
|
|
Fslbal_cbdrcr |
fin_drcridentifier |
Closing Balance Debit Credit |
|
|
|
|
|
|
Fslbal_closebal |
fin_amount |
Closing Balance |
|
|
|
|
|
|
Fslbal_accflagbal |
fin_flag |
Account Flag |
|
|
|
|
|
|
Fslbal_schlay_opr |
fin_flag |
Operation Code |
|
|
|
|
|
|
Fslbal_acct_grp |
fin_accountgroup |
Account Group |
|
|
|
|
|
|
Fslbal_createdby |
fin_user |
Created by |
|
|
|
|
|
|
Fslbal_createddate |
datetime |
Created Date |
|
|
|
|
|
|
Fslbal_modifiedby |
fin_user |
Modified By |
|
|
|
|
|
|
Fslbal_modifieddate |
datetime |
Modified Date |
|
|
|
|
|
|
|
|
|
|
|