Binding Function

RFDEINV

Binding ID

EXTRACT_INV_TRANS

Binding Description

Extract Transactions in LOCIH to flat file

Purpose

This Binding extracts inventory transactions from TagNet and formats into CSV text file format.  This can be run on a scheduled basis using the TagNet Scheduled Task Manager. The layout is adapted to customers using the EPQ module of TagNet when using the TagTrack Lift truck module. The first Tag Mapping event provides the subscribing system to know the mapping thus every subsequent transaction does not include the object details (just the TagID).

Note that a new REST API Transaction extract capability can now be utilized in the TagNet Extension framework (setup as a Job schedule). 

Logic

At selected intervals as specified by the Scheduled Task Manager (e.g. every hour), this function performs the following logic:

üSelects all unprocessed inventory transactions in RFDLOCIH (where RFDHSTFLG = ' ') and outputs to CSV file as shown further below.

üUpdates each processed LOCIH transaction set (where RFDHSTFLG = ' Y)

üAppends records to the output file and creates a archive for every extract

Restrictions

None identified

Files Updated

RFDLOCIH (Inventory Transaction History)

Comments

Program Name

URI set to RFDEINV

Binding Setup

Binding Properties

============================================================================================================

*** these are generated when someone uses base AssetTrack to commission/Map a tag to a new Asset

*** (when a new tag is mapped, an initial default location can be specified such as 'Receiving')

*** Note: this is where the external system builds the relationship between TagID and AssetID, future movements just reference TagID

*** Note2: there is location translation table ILVLT that can be used to map TagNet location matrix to flat code

============================================================================================================

NEW_RCPT,20100628,112138,1,,AA000000000000000000099E,,Dell,A000302,,2209WA,

NEW_RCPT,20100702,141145,1,,AA000000000000000000099A,,Milwaukee,CA_20400,,5378-20,

NEW_RCPT,20100708,084200,1,,AA00000000000000000009B4,,Lenovo,A004528,,T400s,

NEW_RCPT,20100708,084321,1,,AA00000000000000000009B7,,Lenovo,A000335,,T42,

NEW_RCPT,20100708,084504,1,,AA00000000000000000009BF,,Lenovo,A001212,,T500s,

NEW_RCPT,20100709,073056,1,,AA00000000000000000009C1,,Cisco,329998,,5446321,

NEW_RCPT,20100709,161100,1,,AA00000000000000000009C2,,Linksys,A012345,,W54RT,

================================================================================================================

*** these are generated when someone uses base AssetTrack to do an adhoc location move of a given Asset

*** (an example would be they move the asset from its inbound staging location to the asset's permanent location)

*** Note: there is location translation table ILVLT that can be used to map TagNet location matrix to flat code

================================================================================================================

ADJAT_MOVE,20100706,161100,-1,,D0D00000000000000000001B,,,,,,

ADJAT_MOVE,20100706,161100,1,,D0D00000000000000000001B,,,,,,,

ADJAT_MOVE,20100706,162310,-1,,D0D000000000000000000011,,,,,

ADJAT_MOVE,20100706,162310,1,,D0D000000000000000000011,,,,,,

ADJAT_MOVE,20100706,140923,-1,,D0D000000000000000000012,,,,,,

ADJAT_MOVE,20100706,140923,1,,D0D000000000000000000012,,,,,,

ADJAT_MOVE,20100706,091018,-1,,D0D000000000000000000013,,,,,,

ADJAT_MOVE,20100706,091018,1,,D0D000000000000000000013,,,,,,

==============================================================================================================

*** these adjustments to Inventory are generated when AssetTrack PI module is used via a formal count process

*** Note: there is location translation table ILVLT that can be used to map TagNet location matrix to flat code

==============================================================================================================

ADJ_PHYINV,20100628,190119,1,,1.0000000000000000000DF976,,,,,,

ADJ_PHYINV,20100628,190119,-1,,0000000000000000000DF982,,,,,,

ADJ_PHYINV,20100628,190119,1,,0000000000000000A1002163,,,,,,

ADJ_PHYINV,20100628,190119,-1,,0000000000000000E5000193,,,,,,

ADJ_PHYINV,20100628,190119,1,,200389000000000000000D7E,,,,,,

ADJ_PHYINV,20100628,190119,1,,200389000000000000000D8E,,,,,,

ADJ_PHYINV,20100628,190119,1,,200389000000000000000C7E,,,,,,

ADJ_PHYINV,20100628,190119,1,,20038900000000000000037A,,,,,,

ADJ_PHYINV,20100628,190119,-1,,200389000000000000000321,,,,,,

ADJ_PHYINV,20100628,190119,-1,,200389000000000000000474,,,,,,

ADJ_PHYINV,20100628,190119,1,,200389000000000000000A82,,,,,,

ADJ_PHYINV,20100628,190119,-1,,500000000000000000037B3B,,,,,,

ADJ_PHYINV,20100628,190119,1,,C2990000000000000000001A,,,,,,

ADJ_PHYINV,20100628,190119,-1,,C2990000000000000000001C,,,,,,

ADJ_PHYINV,20100628,190119,1,,E2003411B802011390365169,,,,,,

=======================================================================================================================

*** these are generated when Assets are read at fixed readers and automatically moved based on TagNet Server IMOVE rules

*** (this would only be applicable if Fixed read zones are deployed)

*** Note: there is location translation table ILVLT that can be used to map TagNet location matrix to flat code

========================================================================================================================

IMOVETRANS,20100607,131555,-1,,CC0000000000000000100975,,,,,,

IMOVETRANS,20100607,131555,1,,CC0000000000000000100975,,,,,,

IMOVETRANS,20100607,131619,-1,,CC000000000000000010068,,,,,,

IMOVETRANS,20100607,131619,1,,CC000000000000000010068,,,,,,

IMOVETRANS,20100607,131619,-1,,CC0000000000000000100975,,,,,,

IMOVETRANS,20100607,131619,1,,CC0000000000000000100975,,,,,,

IMOVETRANS,20100607,131628,-1,,CC000000000000000010069,,,,,,

IMOVETRANS,20100607,131628,1,,CC000000000000000010069,,,,,,

IMOVETRANS,20100607,131628,-1,,CC0000000000000000100975,,,,,,

IMOVETRANS,20100607,131628,1,,CC0000000000000000100975,,,,,,

IMOVETRANS,20100607,131700,-1,,CC000000000000000010700,,,,,,

IMOVETRANS,20100607,131700,1,,CC000000000000000010700,,,,,,