Show TOC

Background documentationInterface ITmxInventoryTrans

 

Method name: GetOpenReceivingDocuments

  • Short Description

    Retrieves open documents from the receiving table.

  • Stored Procedure

    com_get_open_receiving_hdrs

  • Functionality

    Retrieve data from the tables Receiving and Receiving_dtl based on parameters within vStorenum and output the result to OutputFile. The output file is comma delimited and has the following format:

    • [header]Storenum,Rectransnum,TxnStatus,DocumentNum,ReceivingType,ShipType,PoNum,VendorNum,DiscrepancyNum,Note,ReceiveDate,CartonCount,HashQty,Datetime,Cashiernum,Itemcount

    • [detail]Itemcnt,Plunum,Pluanchor,QtyOrdered,QtyReceived,RetailPrice,Cost,Reason,SuggestedPrice

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

vStorenum

IN

VARIANT

OutputFile

IN

BSTR
Method name: GetListOfReceivingDocuments

  • Short Description

    Retrieves the list of documents from the receiving table.

  • Stored Procedure

    com_get_list_receiving_hdrs

  • Functionality

    Retrieve data from the Receiving table based on the parameters vStorenum and StartingDate and output the result to OutputFile. The output file has the following format:

    • Documentnum

    • ……/t….. Plunum

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

vStorenum

IN

VARIANT

StartingDate

IN

VARIANT

OutputFile

IN

BSTR
Method name: UpdatePhysicalInvDocument

  • Short Description

    Update the inventory document.

  • Stored Procedures

    • xps_update_inventory_physical

    • xps_update_inventory_physical_dtl

  • Functionality

    SAP POS updates the inventory document based on the fields defined in the input file DocFile. The input file is comma delimited and has the following format:

    • [header]

      iStorenum,iCashiernum,iPitransnum,iBucketid,strDocumentnum,dtInvdate,dtModtime,strNote,strOrigin,iReason,dtRequiredBy,dtTxndate,strTxnstatus,iLocation,iItemcount,

    • [detail]

      siStorenum,iPitransnum,strPlunum,strPluanchor,dcQty,dcQtyonhand,

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

DocFile

IN

BSTR
Method name: UpdateTransferDocument

  • Short Description

    Update the transfer document.

  • Stored Procedures

    • xps_update_transfer_hdr

    • xps_update_transfer_dtl

  • Functionality

    SAP POS updates the transfer document based on the fields defined in the input file DocFile. The input file is comma delimited and has the following format:

    • [header]

      iStsTransNum,strTxnStatus,dtDatetime,dtTransferDate,strDocNum,strVendorNum,strShipType,iStoreNum,iCartonCount,iHashQty,strReason,strNote,strTransferType,iTransferStore,iCashiernum,iItemcount

    • [detail]

      iStoreNum,iStsTransNum,iItemCnt,strPluNum,iQty,iQtyReceived,iRetailPrice,strPluAnchor,strDocNum,

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

DocFile

IN

BSTR
Method name: UpdateReceivingDocument

  • Short Description

    Update the receiving document.

  • Stored Procedures

    • xps_update_receiving

    • xps_update_receiving_dtl

  • Functionality

    SAP POS updates the receiving document based on the fields defined in the input file DocFile. The input file is comma delimited and has the following format:

    • [header]

      storeNum,recTransNum,txnStatus,docNum,receivingType,shipType,poNum,vendorNum,discrepancyNum,note,receiveDate,cartonCount,hashQty,datetime,cashiernum,itemcount,

    • [detail]

      iStoreNum,iRecTransNum,iItemCnt,strPluNum,strPluAnchor,iQtyOrdered,iQtyReceived,iRetailPrice,iCost,strDocNum,strReason,iSuggestedPrice,

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

DocFile

IN

BSTR
Method name: GetPLUUpdates

  • Short Description

    Retrieves PLU updates.

  • Stored Procedure

    com_get_pluupdates

  • Functionality

    SAP POS retrieves PLU updates based on the update time and sequence number and outputs the result data to OutputFile. You can use the CollectionFormat to define the content of the output file. If you do not use a collection format, SAP POS outputs all PLU data. The output file is comma delimited and when there is no collection format has the following format:

    plunum,deptnum,pludesc,retailprice,allowdisc,commissionid,vendorid,propromptid,cost,sugretail,promoprice,promoexpire(datetime),promonum,promotxnseqnum,pkgsize,orderingnum,updateditem

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

OutputFile

IN

BSTR

StartingDate

IN

VARIANT

SeqNum

IN

VARIANT

CollectionFormat

IN

BSTR
Method name: GetOpenPhysicalInventoryDocuments

  • Short Description

    Retrieves open documents from inventory.

  • Stored Procedure

    com_get_physical_inventory_hdrs

  • Functionality

    SAP POS retrieves open documents based on the parameter vStorenum and outputs the result data to OutputFile. The output file is comma delimited and has the following format:

    • [header]

      Storenum,CashierNum,PITransnum,BucketId,DocumentNum,InvDate,ModTime,Note,Origin,Reason,RequiredBy,TxnDate,Txnstatus,Location,ItemCount,

    • [detail]

      Storenum,PItransnum,Itemcnt,PLUNum,PLUAnchor,Qty,QtyOnHand,

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

vStorenum

IN

VARIANT

OutputFile

IN

BSTR
Method name: GetOpenTranserDocuments

  • Short Description

    Retrieves the open transfer documents.

  • Stored Procedure

    com_get_open_transfer_hdrs

  • Functionality

    SAP POS retrieves the open transfer documents based on vStorenum and outputs the result data to OutputFile. The output file is comma delimited and has the following format:

    • [header]

      tstransnum,TxnStatus,TxnDate,TransferDate,DocumentNum,VendorNum,ShipType,Storenum,CartonCount,HashQty,ReasonCode,Note,TransferType,TransferStore,Cashiernum,ItemCount

    • [detail]

      Itemcnt,PLUNum,Qty,QtyReceived,RetailPrice,PLUAnchor,Cost,PLUDesc

  • Preconditions

    You must register TmxAPI.DLL.

  • Result

    HRESULT

Parameter Name

Parameter Type

Data Type

vStorenum

IN

VARIANT

OutputFile

IN

BSTR