MISC - Miscellaneous APIs

APIs For This Group

INVMISC - Summary of K_INVRLOG

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            SBBEGIN           'Starting Date'                 10A
BOTH            SBEND             'Ending Date'                   10A
BOTH            SBPCTLOW          '% Low'                          5 2
BOTH            SBPCTMED          '% Med'                          5 2
BOTH            SBPCTHIG          '% High'                         5 2
BOTH            OPBUYR            'Buyer { Optional }'             5A
BOTH            OPLOCN            'Location { Optional }'          5A
BOTH            OPFORCINT         'Forecast Interval ( Optional }  3 0 
BOTH            RVDAYUSED         'Days  used'                     3 0
BOTH            RVAVGCYCS         'Average Cycle Stock '          11 2
BOTH            RVAVGOVST         'Average Over Stock '           11 2
BOTH            RVAVGFWBT         'Average Forward Bought '       11 2
BOTH            RVAVGSAFS         'Average Safety Stock'          11 2
BOTH            RVAVGONOR         'Average On Order'              11 2
BOTH            RVAVGOHND         'Average On Hand'               11 2      
BOTH            RVAVGMOHN         'Average Manual On Hand'        11 2
BOTH            RVTOTALLA         'Total All Averages'            13 2
BOTH            RVPROAMNT         'Proposed Carrying Cost'        13 2
BOTH            RVPROAMTM         'Proposed Carrying Cost Manual' 13 2
BOTH            RVNK3SONHL        'Avg O/H Low not using K3S'     13 2
BOTH            RVNK3SONHM        'Avg O/H Med not using K3S'     13 2
BOTH            RVNK3SONHH        'Avg O/H Hig not using K3S'     13 2
BOTH            RVSCCNK3LW        'Carr/Cost Low not using K3S'   13 2
BOTH            RVSCRNK3MD        'Carr/Cost Med not using K3S'   13 2
BOTH            RVSCRNK3HG        'Carr/Cost Hig not using K3S'   13 2
BOTH            RVCRCSTLW         'K3 Savings Carr/Cost Low  '    13 2
BOTH            RVCRCSTMD         'K3 Savings Carr/Cost Hig  '    13 2
BOTH            RVCRCSTHG         'K3 Savings Carr/Cost Med  '    13 2
BOTH            RVEFCTCRC         'Effective Carrying Cost'        8 5

FINMISC - Summary of K_FINALOG

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            SBBEGIN           'Starting Date'                 10A
BOTH            SBEND             'Ending Date'                   10A
BOTH            OPBUYR            'Buyer { Optional }'             5A
BOTH            OPLOCN            'Location { Optional }'          5A
BOTH            OPFORCINT         'Forecast Interval ( Optional }' 3 0 
BOTH            OPTYPE            'Inventory Type  ( Optional }'   2A 
BOTH            RVDAYUSED         'Days  used'                     3 0
BOTH            RVDAYSVAL         'Days Value'                     3 0
BOTH            RVTOTSALE         'Total Sales  '                 13 2
BOTH            RVTOTDEMN         'Total Demand '                 13 2
BOTH            RVTOTPROF         'Total Profit Sales '           13 2
BOTH            RVTOTPRFP         'Profit Sales % '                5 2
BOTH            RVTOTOUTS         'Total Lost Sales '             13 2      
BOTH            RVTOTPRFL         'Total Profit Lost Sales '      13 2
BOTH            RVTOTPRLP         'Total Profit Lost Slaes %'      5 2
BOTH            RVTOPRDAY         'Average Items from Period'      5 0
BOTH            RVTOTITEM         'Average Items from Company'     5 0

UPDMISC - Submit A Job In The Work Scheduler For Batch Processing

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            SBJOBID           'Job Scheduler ID '             10A
BOTH            RVJOBSENT         'Job Successfully submited'      1A

APIMISC - Return Stats for Another API

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            IDAPIPG           'API Program '                  10A
BOTH            RVDATE            'Compile Date MM/DD/YR'          6A
BOTH            RVLSTUSED         'Last Time Used MM/DD/YY'        6A
BOTH            RVDAYSUSED        'Days Used '                     5 0 

NTYMISC - Write Out Multi-purpose Notifications

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            SBUSERID          'User ID '                      10A
BOTH            SBUSERSND         'Sent from User Id '            10A
BOTH            SBSUBJECT         'Subject '                      40A
BOTH            SBMESSAGE         'Message...'                   257A
BOTH            SBLINK            'Link '                        257A  
BOTH            SBPTYPE           'Type '                         20A 
BOTH            SBNOTE            'Note '                         50A  
BOTH			RVID			  'Notification ID'				  11 0

RUSMISC - Return User and User ID for a REP User

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            IDREPUSER         'User Requested '               10A
BOTH            RVUSER_ID         'User ID'                        9 0
BOTH            RVUSERNAME        'User Name'                    257A 
BOTH            RVEMAIL           'Email Address'                257A 
BOTH            RVDISPLAY         'Display Name '                 52A 
BOTH            RVSTATE           'State' 						   4 0
BOTH            RVROLE            'Role '                         12A 
BOTH            RVITMXPAGE        'Items per page'                 2A 
BOTH            RVPAGERNGE        'Page Range'                     2A
BOTH            RVCURFORMT        'Current Format  '               3A 
BOTH            RVLANG            'Language '                      5A 
BOTH            RVK3S             'K3S'                            1A 
BOTH            RVUNDERLINE       'Underline '                     4 0 
BOTH            RVCLICKLINE       'Clickline '                     4 0
BOTH            RVUNIT1           'Unit 1' 						   4 0
BOTH            RVUNIT2           'Unit 2' 	 					   4 0
BOTH            RVUNIT3           'Unit 3' 	 					   4 0
BOTH            RVUNIT4           'Unit 4' 	  					   4 0
BOTH            RVPROBATION       'Probation'                      4 0
BOTH            RVSERVCHECK       'Service Check' 				   4 0
BOTH            RVORDRPOINT       'Order Point'                    4 0
BOTH            RVBACKORDER       'BackOrder'                      4 0
BOTH            RVNOFILLDT        'NoFilDft '                      4 0

VERMISC - Record API & R6 Version installed at a Customer

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            SBAPIVER          'API Version Installed '        10A
BOTH            SBINTVER          'R6 Interf. Version Installed'  10A  

CPAMISC - Copy Product History Across Locations Driver

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            IDPROD            'From Product ID'               25A
BOTH            SBPROD            'To Product ID'                 25A
BOTH            SBHISTYPE         'History Type '                  1 0
BOTH            SBUSRSTAT         'From Product User Status'       1A
BOTH            SBFREZEND         'From Product Freeze Until'     10A
BOTH            SBCLRAVG          'From Product Clear Average 0/1' 1A
BOTH            SBMULTPLY         'Multiplier'                     9 4
BOTH            SBCPYMODE         'Add(A); Replace(R)'             1A
BOTH            SBDIFINTR         'To Prod w/other Interval Y/N '  1A

STAMISC - Summary by Comp/Locn/Prod

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            SBPER12END        'Interval 12 Month End '         1A
BOTH            SBPER13END        'Interval 13 Month End '         1A
BOTH            SBPER52END        'Interval 52 Month End '         1A

RLSMISC - Release Locks created from ODBC

BOTH            USER              'ODBC Authorization User'       10A

NTRMISC - Is it period end?

BOTH            K3SOBJ            'K3S Object library'            10A
BOTH            COMP              'Company'                        1A
BOTH            COMPCOD           'Company code'                   3A
BOTH            USER              'User calling the program'      10A
BOTH            ERRORS            'Error indicator'                1A
BOTH            ERRMSG            'Error message'                100A
BOTH            ERRFIELD          'Field in error'                20A
BOTH            IDFORCINT         'Forecast interval'              3 0
BOTH            RVPETODAY         'Period end? 0=NO,1=Yes'         1 0