List of Values On Settlement Code, displaying Settlement Code and Settlement Description Poplists N/A Buttons N/A Additional Behaviour N/A Description This form will be based on two blocks: CTRL - non-base table, non queryable. SETT - base table on idb_Settlements. Queryable, insert/delete/update allowed. Each record in this block will be linked directly to the settlement date in the top block, ie. Only records matching the settlement date above can be manipulated here. Form structure Object Description Form: Title : Maintain Settlement Calendar. CALEMAIN non-base table. Block: CTRL Insert, Update allowed. Join columns: ctrl.nbt_sett_date = sett.sett_dt. Label : Date nbt_sett_date Display. Mandatory. User Enterable. Insert. Update. Base table on idb_settlements. Block: SETT Query, Update, Insert, Delete allowed. Order by settlement_code. Label : Code sett_code Display. User Enterable. Query. Insert. Delete. Must be unique for the nbt_sett_date. LoV on idb_sett_types. Label : Description nbt_sett_description Display only. Label : Payment Date payment_date Display. User Enterable. Query. Insert. Delete. Format : DD-MON-YYYY. Label : Run(s) nbt_runs Display only. Label : Planned Run Date Planned_ssr_run_date Display. User Enterable. Query. Insert. Update. Delete. Format : DD-MON-YYYY.
List of Values On Settlement Code, displaying Settlement Code and Settlement Description Poplists N/A Buttons N/A Additional Behaviour N/A Description This form will be based on two blocks: CTRL - non-base table, non queryable. SETT - base table on idb_Settlements. Queryable, insert/delete/update allowed. Each record in this block will be linked directly to the settlement date in the top block, ie. Only records matching the settlement date above can be manipulated here. Form structure Object Description Form: CALEMAIN Title : Maintain Settlement Calendar. Block: CTRL non-base table. Insert, Update allowed. Join columns: ctrl.nbt_sett_date = sett.sett_dt. nbt_sett_date Label : Date Display. Mandatory. User Enterable. Insert. Update. Block: SETT Base table on idb_settlements. Query, Update, Insert, Delete allowed. Order by settlement_code. sett_code Label : Code Display. User Enterable. Query. Insert. Delete. Must be unique for the nbt_sett_date. LoV on idb_sett_types. nbt_sett_description Label : Description Display only. payment_date Label : Payment Date Display. User Enterable. Query. Insert. Delete. Format : DD-MON-YYYY. nbt_runs Label : Run(s) Display only. Planned_ssr_run_date Label : Planned Run Date Display. User Enterable. Query. Insert. Update. Delete. Format : DD-MON-YYYY.
SVAAISRA_Technical_Spec_redlined_v27.2_CP1418.docx