1 / 20

Custom Fields for Static and Trade Data

Custom Fields for Static and Trade Data. Required key fields when creating the Custom Fields. Custom Fields for Static and Trade Data. Create a Data Map table for TPOW. Note that the TZKEY, and the audit keys are automatically updated. Sample of Book custom fields.

uttara
Download Presentation

Custom Fields for Static and Trade Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Custom Fields for Static and Trade Data Required key fields when creating the Custom Fields

  2. Custom Fields for Static and Trade Data

  3. Create a Data Map table for TPOW

  4. Note that the TZKEY, and the audit keys are automatically updated

  5. Sample of Book custom fields

  6. Sample of Book custom fields

  7. Quick tip to report ERRORLEVEL from Batch echo *Start.success* ERRORLEVEL is: %ERRORLEVEL% Sample batch: @echo off if "%1"=="-start" goto :start if "%1"=="-stop" goto :stop gotowrongParams :start ::**** :: Insert start up stripts here... :: If there is an error, set ERRORLEVEL=1 ::**** set ERRORLEVEL=0 echo. echo ******** echo starting the service... echo. ::start "" "C:\Program Files\Microsoft Office\office11\winword.exe" start notepad.exe if ERRORLEVEL 1 goto error qprocess notepad.exe echo *Start.success* ERRORLEVEL is: %ERRORLEVEL% echo. goto end :stop ::**** :: Insert stopping stripts here... :: If there is an error, set ERRORLEVEL>1 ::**** set ERRORLEVEL=0 echo. echo ******** echo stopping the service... echo. qprocess notepad.exe taskkill /f /im notepad.exe if ERRORLEVEL 1 gotonoProcess goto end :noProcess set ERRORLEVEL=2 echo *noProcess* ERRORLEVEL is now: %ERRORLEVEL% echo. exit /b 2 :error :: Errorhandler. Log application status and cause of error here. Set :: ERRORLEVEL > 1 before returning to caller. set ERRORLEVEL=1 echo. echo **** Error handler inside test.bat **** echo. echo *error* ERRORLEVEL is now: %ERRORLEVEL% echo. exit /b 1 :wrongParams :: Output an error if the wrong parameters were passed to this script. :: Maybe try to self correct the parameter... set ERRORLEVEL=1 echo. echo '%1' is an invalid parameter. echo Usage: %0 [-stop ^| -start] echo *wrongParams* ERRORLEVEL is now: %ERRORLEVEL% echo. exit /b 1 :end

  8. COAL PHYSICAL Sample Coal Physical Trade

  9. Coal Physical Sample Coal Physical Trade Spec

  10. COAL Actualization Click on the Actualize icon “A” then manually enter the coal data

  11. Coal Report with PRODSIMPLE GLOI Un-actualized amount does not roll to the next month

  12. Coal Report with PRODSIMPLE GLOI If the prior month actualization volume is more than the nominal volume, the excess amount does not account into the following month.

  13. Coal Report with PRODSIMPLE GLOI With the PRODSIMPLE = set to “0” the cumulative of the un-actualized volume will roll to the next available month

  14. Coal Report with PRODSIMPLE GLOI Note: if there is an overage of the actualized volume, the cumulative under and overage will roll to the next month

  15. Oracle selective row return select name, price from items where rownum > 5 and rownum < 11; Or select name, price from items where rownum between 5 and 11; // This method to add the row count to the newly created table so you could retrieve any data rows in a new table create table Z_MASTERBATCH_JOINED AS select rownum as ROW_ID, A1.C0_REPORT_DATE AS A_C0_REPORT_DATE, A1.C1_RUN_DATE AS A_C1_RUN_DATE

More Related