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

RFDXLOC

Still need help? Create a Support Ticket with Stratum Support

Send comments on this topic.

← Previous Next →

 

 

Binding Function

RFDXLOC

 

Binding ID

EXTRACT_TRANS_LOCN

 

Binding Description

Extract Transactions in LOCIH to flat file

 

Purpose

This Binding extracts inventory transactions from TagNet and formats into the Clear Spider (hosted VMI Inventory) text file format.  This is run on a scheduled basis using the TagNet Scheduled Task Manager.

Logic

At selected intervals as specified by the Scheduled Task Manager (typically every 10 minutes), this function performs the following logic:

Selects all unprocessed inventory transactions in RFDLOCIH (where RFDHSTFLG = ' '), and then looking at Clear Spider transaction type X-reference file RFDEXTRN sorts transactions by Employee Badge / Transaction Type and outputs to Text file as shown further below.

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

Sends out file executing the Command prompt directive of C:\TagNet\rfid\sp5500\tagnet_send_extract.bat  

 

Restrictions

Not intended to be used with any Reader Schedule, it is a standalone binding function independent of Reader activity

Files Updated

RFDLOCIH (Inventory Transaction History)

Comments

 

Program Name

URI set to RFDXLOC

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. The Clear Spider executable (SP5500.exe) is embedded in the .BAT file.

 

 

Clear Spider Transactions

The below table holds the transaction type mapping between TagNet and Clear Spider. The ‘From’ and ‘To’ locations are the last levels in the Ellsworth location matrix and will create a CS record type as shown during the extract.

 

Maintainable TagNet Mapping Table of Clear Spider Transactions

 

Transaction Type

From Location (-)

To Location (+)

CS Record Type

Multiply Qty by (-1)

Reason Code

Receipt

Intransit

Storage

R1

Consumption

Storage

Consumed

C1

Return

Consumed

Storage

A1

Return To Stock

Scrap

Storage

Scrap

A1

yes

Scrap - Expired

Reverse Scrap

Scrap

Storage

A1

Return To Stock

No Charge Material

Storage

NoChgMatl

A1

yes

Implementation or Return To Ellsworth

Reverse No Charge

NoChgMatl

Storage

A1

Receive in Product

PI Count Adjustment (not found)

Storage

Reconcile

A1

yes

Cycle Count

 

Example Clear Spider Transaction Set

 

 

 

 


Copyright © 2023 Stratum Global, Inc.