Data Dictionary - Financial Calendar Closure |
|||||
|
|
|||||
|
Table Name FCC_BFG_COMPONENT_MAP |
|
||||
|
|
|||||
|
Table Comment Gives the BFG - COMPONENT mapping status |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
BFG_CODE |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
COMPONENT_ID |
varchar(16) |
NOT NULL |
Component Id |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
MAP_STATUS |
varchar(25) |
NULL |
Map Status.Values A-Active,I-Inactive |
No |
No |
|
MAP_BY |
varchar(15) |
NULL |
Map By |
No |
No |
|
MAP_DATE |
datetime |
NULL |
Map Date |
No |
No |
|
UNMAP_BY |
varchar(15) |
NULL |
Unmap By |
No |
No |
|
UNMAP_DATE |
datetime |
NULL |
Unmap Date |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name fcc_bfg_error_dtl |
|
||||
|
|
|||||
|
Table Comment Gives the errors mapped to Business function group |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
run_no |
varchar(18) |
NOT NULL |
Run Number |
Yes |
No |
|
ou_id |
int |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
bfg_code |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
fb_id |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
error_id |
varchar(40) |
NULL |
Error Id |
No |
No |
|
error_desc |
varchar(30) |
NULL |
Error Description |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name FCC_BFG_MST |
|
||||
|
|
|||||
|
Table Comment Gives the Business function group details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
BFG_CODE |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
LANGUAGE_ID |
decimal(10) |
NOT NULL |
Language Id |
Yes |
No |
|
BFG_NAME |
varchar(40) |
NOT NULL |
Business Function Group Name |
No |
No |
|
STATUS |
varchar(25) |
NOT NULL |
Status.Values A-Active,I-Inactive |
No |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
PREBFG_CODE |
varchar(20) |
NULL |
Pre-Business Function Group Code |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name FCC_BFG_PRD_CLOSE_STATUS |
|
||||
|
|
|||||
|
Table Comment Gives the Business function group /period closure status |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
OU_ID |
decimal(10) |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
BFG_CODE |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
FB_ID |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
FIN_YEAR |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
FIN_PERIOD |
varchar(15) |
NOT NULL |
Finance Period |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
STATUS |
varchar(25) |
NULL |
Status.Values C Closed,O Open,P Provisionally Closed,N Not Started,I In Progress,A Abort,R Resume,X Cancelled,M Closed for MAC |
No |
No |
|
CLOSED_BY |
varchar(15) |
NULL |
Closed By |
No |
No |
|
CLOSED_DATE |
datetime |
NULL |
Closed Date |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
RUN_NO |
varchar(18) |
NULL |
Run Number |
No |
No |
|
|
|||||
|
Table Name FCC_BFG_YR_CLOSE_STATUS |
|
||||
|
|
|||||
|
Table Comment Gives the Business function group / year closure status |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
OU_ID |
decimal(10) |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
BFG_CODE |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
FB_ID |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
FIN_YEAR |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
STATUS |
varchar(25) |
NULL |
Status.Values C Closed, O Open, P Provisionally Closed, N Not Started, I In Progress, A Abort, R Resume, X Cancelled, M Closed for MAC |
No |
No |
|
CLOSED_BY |
varchar(15) |
NULL |
Closed By |
No |
No |
|
CLOSED_DATE |
datetime |
NULL |
Closed Date |
No |
No |
|
RUN_NO |
varchar(18) |
NULL |
Run Number |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name fcc_cls_fb_run_trn |
|
||||
|
|
|||||
|
Table Comment Gives the details about Financial book closures |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
run_no |
varchar(10) |
NOT NULL |
Run Number |
Yes |
No |
|
ou_id |
int |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
fb_id |
varchar(40) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
fin_year |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
fin_period |
varchar(15) |
NOT NULL |
Finance Period |
Yes |
No |
|
timestamp |
int |
NOT NULL |
Time Stamp |
No |
No |
|
guid |
varchar(40) |
NOT NULL |
Guide |
No |
No |
|
company_code |
varchar(10) |
NOT NULL |
Company Code |
No |
No |
|
prd_yr_option |
varchar(25) |
NOT NULL |
Period Year Option |
No |
No |
|
status |
varchar(25) |
NOT NULL |
Status.Values C Closed, O Open, P Provisionally Closed, N Not Started, I In Progress, A Abort, R Resume, X Cancelled, M Closed for MAC |
No |
No |
|
language_id |
varchar(25) |
NOT NULL |
Language Id |
No |
No |
|
run_status |
varchar(25) |
NOT NULL |
Run Status.Values C Closed, O Open, P Provisionally Closed, N Not Started, I In Progress, A Abort, R Resume, X Cancelled, M Closed for MAC |
No |
No |
|
service |
varchar(28) |
NOT NULL |
Service |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Created Date |
No |
No |
|
modifiedby |
varchar(15) |
NULL |
Modified By |
No |
No |
|
modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name FCC_ERROR_DTL |
|
||||
|
|
|||||
|
Table Comment Gives the errors generated while executing offline stored procedures |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
ERROR_ID |
varchar(6) |
NOT NULL |
Error Id |
Yes |
No |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
FB_ID |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
FIN_YEAR |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
FIN_PERIOD |
varchar(15) |
NOT NULL |
Finance Period |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
ERROR_DESC |
varchar(255) |
NULL |
Error Description |
No |
No |
|
RUN_NO |
varchar(18) |
NULL |
Run Number |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name fcc_mac_fbp_post |
|
||||
|
|
|||||
|
Table Comment Gives the posting details on close MAC calendar |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
batch_id |
varchar(40) |
NULL |
Batch Id |
No |
No |
|
company_code |
varchar(10) |
NULL |
Company Code |
No |
No |
|
component_name |
varchar(60) |
NULL |
Component Name |
No |
No |
|
bu_id |
varchar(20) |
NULL |
Business Unit Id |
No |
No |
|
fb_id |
varchar(20) |
NULL |
Finance Book Id |
No |
No |
|
tran_ou |
int |
NULL |
Transaction Organization Unit |
No |
No |
|
document_no |
varchar(40) |
NULL |
Document Number |
No |
No |
|
tran_type |
varchar(40) |
NULL |
Transaction Type |
No |
No |
|
tran_date |
datetime |
NULL |
Transaction Date |
No |
No |
|
posting_date |
datetime |
NULL |
Posting Date |
No |
No |
|
account_code |
varchar(32) |
NULL |
Account Code |
No |
No |
|
drcr_flag |
varchar(6) |
NULL |
Debit Credit Flag |
No |
No |
|
currency_code |
varchar(5) |
NULL |
Currency Code |
No |
No |
|
tran_amount |
numeric(28,8) |
NULL |
Transaction Amount |
No |
No |
|
base_amount |
numeric(28,8) |
NULL |
Base Amount |
No |
No |
|
exchange_rate |
numeric(15,5) |
NULL |
Exchange Rate |
No |
No |
|
ou_id |
int |
NULL |
Organization Unit Id |
No |
No |
|
par_base_amount |
numeric(28,8) |
NULL |
Parallel Base Amount |
No |
No |
|
par_exchange_rate |
numeric(15,5) |
NULL |
Parallel Exchange Rate |
No |
No |
|
analysis_code |
varchar(5) |
NULL |
Analysis Code |
No |
No |
|
subanalysis_code |
varchar(5) |
NULL |
Subanalysis Code |
No |
No |
|
cost_center |
varchar(32) |
NULL |
Cost Center |
No |
No |
|
mac_post_flag |
varchar(25) |
NULL |
Management Account Post Flag |
No |
No |
|
|
|||||
|
Table Name FCC_PRD_CLOSE_HISTORY |
|
||||
|
|
|||||
|
Table Comment Gives the history of period closure status |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
OU_ID |
decimal(10) |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
FB_ID |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
FIN_YEAR |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
FIN_PERIOD |
varchar(15) |
NOT NULL |
Finance Period |
Yes |
No |
|
BFG_CODE |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
SERIAL_NO |
varchar(18) |
NOT NULL |
Serial Number |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
RUN_NO |
varchar(18) |
NULL |
Run Number |
No |
No |
|
STATUS |
varchar(25) |
NULL |
Status.Values C Closed, O Open, P Provisionally Closed, N Not Started, I In Progress, A Abort, R Resume, X Cancelled, M Closed for MAC |
No |
No |
|
CLOSED_BY |
varchar(15) |
NULL |
Closed By |
No |
No |
|
CLOSED_DATE |
datetime |
NULL |
Closed Date |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name FCC_PRD_CLOSE_STATUS |
|
||||
|
|
|||||
|
Table Comment Gives the period closure status |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
OU_ID |
decimal(10) |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
FB_ID |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
FIN_YEAR |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
FIN_PERIOD |
varchar(15) |
NOT NULL |
Finance Period |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
STATUS |
varchar(25) |
NULL |
Status.Values C Closed, O Open, P Provisionally Closed, N Not Started, I In Progress, A Abort, R Resume, X Cancelled, M Closed for MAC |
No |
No |
|
CLOSED_BY |
varchar(15) |
NULL |
Closed By |
No |
No |
|
CLOSED_DATE |
datetime |
NULL |
Closed Date |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
RUN_NO |
varchar(18) |
NULL |
Run Number |
No |
No |
|
SEQUENCENO |
decimal(10) |
NULL |
Sequence Number |
No |
No |
|
|
|||||
|
Table Name FCC_YR_CLOSE_HISTORY |
|
||||
|
|
|||||
|
Table Comment Gives the history of year closure |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
OU_ID |
decimal(10) |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
FB_ID |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
FIN_YEAR |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
BFG_CODE |
varchar(20) |
NOT NULL |
Business Function Group Code |
Yes |
No |
|
SERIAL_NO |
varchar(18) |
NOT NULL |
Serial Number |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
STATUS |
varchar(25) |
NULL |
Status.Values C Closed, O Open, P Provisionally Closed, N Not Started, I In Progress, A Abort, R Resume, X Cancelled, M Closed for MAC |
No |
No |
|
CLOSED_BY |
varchar(15) |
NULL |
Closed By |
No |
No |
|
CLOSED_DATE |
datetime |
NULL |
Closed Date |
No |
No |
|
RUN_NO |
varchar(18) |
NULL |
Run Number |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name FCC_YR_CLOSE_STATUS |
|
||||
|
|
|||||
|
Table Comment Gives the year closure status |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COMPANY_CODE |
varchar(10) |
NOT NULL |
Company Code |
Yes |
No |
|
OU_ID |
decimal(10) |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
FB_ID |
varchar(20) |
NOT NULL |
Finance Book Id |
Yes |
No |
|
FIN_YEAR |
varchar(15) |
NOT NULL |
Finance Year |
Yes |
No |
|
TIMESTAMP |
decimal(10) |
NULL |
Time Stamp |
No |
No |
|
STATUS |
varchar(25) |
NULL |
Status.Values C Closed, O Open, P Provisionally Closed, N Not Started, I In Progress, A Abort, R Resume, X Cancelled, M Closed for MAC |
No |
No |
|
CLOSED_BY |
varchar(15) |
NULL |
Closed By |
No |
No |
|
CLOSED_DATE |
datetime |
NULL |
Closed Date |
No |
No |
|
CREATEDBY |
varchar(15) |
NULL |
Created By |
No |
No |
|
CREATEDDATE |
datetime |
NULL |
Created Date |
No |
No |
|
MODIFIEDBY |
varchar(15) |
NULL |
Modified By |
No |
No |
|
MODIFIEDDATE |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|||||
|
Table Name mac_yrprd |
|
||||
|
|
|||||
|
Table Comment Gives the details about the years and the periods |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
guid |
varchar(40) |
NULL |
Guide |
No |
No |
|
startdate |
datetime |
NULL |
Start Date |
No |
No |
|
enddate |
datetime |
NULL |
End Date |
No |
No |
|
period |
varchar(40) |
NULL |
Period |
No |
No |
|
|
|
|
|
|
|