2 Settlement Date idb_ssr_runs / sett_date Date 3 Settlement text(2) idb_ssr_runs / sett_code Code 4 Run Type text(2) idb_ssr_runs / ssr_run_type_id Code 5 Run Number integer(7) idb_ssr_runs / ssr_run_type_id 6 GSP Group text(2) Null RDT Field Field Name Type Source / Value 1 Record Type text(3) = RDT 2 User Name text(8) 3 Report Parameters text(30) Input SSR Run Number HDR Field Field Name Type Source / Value 1 Record Type text(3) = HDR 2 Settlement Date idb_ssr_runs / sett_date Date 3 Settlement text(2) idb_ssr_runs / sett_code Code 4 Settlement text(30) idb_sett_types / description Code Description 5 SSR Run Date Date idb_ssr_runs / ssr_run_date 6 SSR Run integer(7) idb_ssr_runs / ssr_run_number Number 7 SSR Run Type text(2) idb_ssr_runs / ssr_run_type_id Id 8 Supplier Id text(4) idb_pd_sup_purchases / sup_mkt_ppt_id 9 Supplier Name text(40) idb_mkt_ppts / mkt_ppt_name GSP Field Field Name Type Source / Value 1 Record Type text(3) = GSP 2 GSP Group Id text(2) idb_pd_sup_purchases / gsp_group_id 3 GSP Group text(30) idb_gsp_groups / gsp_group_name Name SPX Field Field Name Type Source / Value 1 Record Type text(3) = SPX 2 Settlement integer(2) idb_pd_sup_purchases / sett_pd_id Period Id 3 Settlement text(6) Generated by a function call Period Label
2 Settlement Date Date idb_ssr_runs / sett_date 3 Settlement Code text(2) idb_ssr_runs / sett_code 4 Run Type Code text(2) idb_ssr_runs / ssr_run_type_id 5 Run Number integer(7) idb_ssr_runs / ssr_run_type_id 6 GSP Group text(2) Null RDT Field Field Name Type Source / Value 1 Record Type text(3) = RDT 2 User Name text(8) 3 Report Parameters text(30) Input SSR Run Number HDR Field Field Name Type Source / Value 1 Record Type text(3) = HDR 2 Settlement Date Date idb_ssr_runs / sett_date 3 Settlement Code text(2) idb_ssr_runs / sett_code 4 Settlement Code Description text(30) idb_sett_types / description 5 SSR Run Date Date idb_ssr_runs / ssr_run_date 6 SSR Run Number integer(7) idb_ssr_runs / ssr_run_number 7 SSR Run Type Id text(2) idb_ssr_runs / ssr_run_type_id 8 Supplier Id text(4) idb_pd_sup_purchases / sup_mkt_ppt_id 9 Supplier Name text(40) idb_mkt_ppts / mkt_ppt_name GSP Field Field Name Type Source / Value 1 Record Type text(3) = GSP 2 GSP Group Id text(2) idb_pd_sup_purchases / gsp_group_id 3 GSP Group Name text(30) idb_gsp_groups / gsp_group_name SPX Field Field Name Type Source / Value 1 Record Type text(3) = SPX 2 Settlement Period Id integer(2) idb_pd_sup_purchases / sett_pd_id 3 Settlement Period Label text(6) Generated by a function call
SVAAISRA_Technical_Spec_redlined_v27.2_CP1418.docx