Get Lens Transactions (/lenses/transactions)

Method accepts a one character transaction code, start date in the format yyyymmdd, and start time in the format hhmm .

This method returns all transactions from the specified date/time to the present.

Valid transaction codes are:

  • A - lens adjustment transactions

  • C - lens receiving transactions

  • S - stock count transactions

  • T - stock return to vender transactions

  • U - stock usage transactions

  • W - lens breakage transactions

 

Example request:

http://localhost:4567/api/lenses/transactions?Code=W&Starting%20Date=20210601&Starting%20Time=0000

 

Returns

The following information is returned

  • txDate - the transaction date

  • txTime - the transaction time

  • stockTxCreateCode - this is the method that created the transaction, values are “A” for automatic trnasaction or “M” for manual transaction

  • stockTxCode - this is the transaction type (see transaction codes in input)

  • stockOrderNum - if the transaction is associated with an order number, it will be in this field

  • stockIsFor- this field determines if the stock is for a left or right lens or a single lens (can be used in either eye). values returned are R, L or S

  • stockNum - this is the internal RxUniverse stock number associated with the lens

  • stockDescription - this is the description of the lens

  • stockOpc - this is the OPC code for the lens in the transaction

  • poNum - if the transaction is a lens receiving transaction, this contains the purchase order number if one is associated with the transaction

  • breakageReason - if the transaction is for a breakage, this contains the breakage code for the lens breakage

  • transactionDescription - this is the description of the transaction

  • txQty - contains the number of lenses for the transactions

 

Example

[

{

"txDate": "20210609",

"txTime": "09533464",

"stockTxCreateCode": "A",

"stockTxCode": "W",

"stockOrderNum": "13000381",

"stockIsFor": "S",

"stockNum": "814460",

"stockDescription": "LVE FPSV +0100 70",

"stockOpc": "0023482516",

"poNum": "",

"breakageReason": "WAVE",

"transactionDescription": "WAVE",

"txQty": -1

},

{

"txDate": "20210609",

"txTime": "09533465",

"stockTxCreateCode": "A",

"stockTxCode": "W",

"stockOrderNum": "13000381",

"stockIsFor": "S",

"stockNum": "814460",

"stockDescription": "LVE FPSV +0100 70",

"stockOpc": "0023482516",

"poNum": "",

"breakageReason": "WAVE",

"transactionDescription": "WAVE",

"txQty": -1

}

]