Navigation: Filtering & Collection > Event Bindings > Available Bindings > Data Extract Bindings >

RFDEINV

Still need help? Create a Support Ticket with Stratum Support

Send comments on this topic.

← Previous Next →

 

 

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

File to Process

Outputs text file to location specified and archives. Refer to the the Binding Change for detailed explanations of each directive.

 

Execute Command

Executes the DOS command string at the end of the binding to send out file.

 

 

 

Export Mapping Example Layout (EPQ workflow)

 

Trans Type  RFDHSTACT

Trans date RFDHSTDTE

Trans Time RFDHSTTME

Trans Qty RFDLOCQTY

Cust location RFDERPLOC

Container Tag ID    RFDTAGUID

Cust Order RFDORDNO

 Unique ID UCCITMBRN

 Object ID RFDIID

Serial # ID RFDBINID

Part # UCCITMERP

Order Disposition

User Defined 1

User Defined 2

User Defined 3

User Defined 4

User Defined 5

LOCIH

LOCIH

LOCIH

LOCIH

ILVLT

LOCIH

PQTAG

UCCRCIM

TGMAP

TGMAP

UCCRCIM

PQHDR

 

 

 

 

 

NEW_RCPT

20091115

210000

1

3538

000000000000000000000027

 

111222

00023344

484848

4958575757

 

 

 

 

 

 

NEW_RCPT

20091115

210000

1

3538

000000000000000000000028

 

 

 

 

32292828727

 

 

 

 

 

 

ADJTT_PUT

20091116

210000

1

3539

000000000000000000000027

 

 

 

 

 

 

 

 

 

 

 

ADJAT_PUT

20091116

210000

1

3539

000000000000000000000028

 

 

 

 

 

 

 

 

 

 

 

STOCK__PUT

20091116

210000

1

3539

000000000000000000000027

 

 

STK12345

 

 

 

 

 

 

 

 

STOCK__PUT

20091116

210000

1

3539

000000000000000000000028

 

 

STK12346

 

 

 

 

 

 

 

 

ADJTT_PICK

20091118

210000

1

3539

000000000000000000000027

100

 

 

 

 

 

 

 

 

 

 

ADJAT_PICK

20091118

210000

1

3539

000000000000000000000028

100

 

 

 

 

 

 

 

 

 

 

ADJTT_PCKC

20091118

210000

1

3539

000000000000000000000027

100

 

 

 

 

 

 

 

 

 

 

ADJAT_PCKC

20091118

210000

1

3539

000000000000000000000028

100

 

 

 

 

 

 

 

 

 

 

ADJTT_MOVE

20091118

210000

1

3539

000000000000000000000027

 

 

 

 

 

 

 

 

 

 

 

ADJAT_MOVE

20091118

210000

1

3539

000000000000000000000028

 

 

 

 

 

 

 

 

 

 

 

SHIPMENT

20091203

210000

1

3540

000000000000000000000027

100

 

 

 

 

1

 

 

 

 

 

SHIPMENT

20091203

210000

1

3540

000000000000000000000028

100

 

 

 

 

1

 

 

 

 

 

SHIPMENT

20091205

210000

1

3540

000000000000000000000044

101

 

 

 

 

2

 

 

 

 

 

SHIPMENT

20091206

210000

1

3540

000000000000000000000045

102

 

 

 

 

3

 

 

 

 

 

IMOVETRANS

20091207

93500

1

4233

B00010000000000000000102

** this only happens on inbound to receiving facility

 

** this only happens on inbound to receiving facility

 

** this only happens on inbound to receiving facility

 

 

 

 

IMOVETRANS

20091207

93500

1

4235

B00010000000000000000134

 

 

 

 

IMOVETRANS

20091207

93500

1

4256

B00010000000000000000136

 

 

 

 

 

 

Shown below is an example of the actual CSV output file

 

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

*** 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,,,,,,

 

 

 


Copyright © 2023 Stratum Global, Inc.