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

RFDEIN2

Still need help? Create a Support Ticket with Stratum Support

Send comments on this topic.

← Previous Next →

 

 

Binding Function

RFDEIN2

 

Binding ID

EXTRACT_INV_TRANS_2

 

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. They layout mapping can be seen further below.

 

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

Inventory Location Transaction table RFDILVLT needs to be populated as shown below

 

Restrictions

None identified

Files Updated

RFDLOCIH (Inventory Transaction History)

Comments

 

Program Name

URI set to RFDEIN2

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 (Product Object)

 

Transaction use Case

Trans Type  RFDHSTACT

Trans date RFDHSTDTE

Trans Time RFDHSTTME

Trans Qty RFDLOCQTY

Cust location RFDERPLOC

Tag ID

RFDTAGUID

Lot #

RFDLOCLOT

Trans Ref RFDHSTREF

 Object ID       RFDIID

Container ID RFDBINID

Part #      UCCITMERP

Serial # RFDASSRLN

 

LOCIH

LOCIH

LOCIH

LOCIH

ILVLT

LOCIH

LOCIH

LOCIH

TGMAP

TGMAP

UCCRCIM

ASSM

Tag Import from External System

ADJ_IMPORT

20131115

111218

1

3539

E2008364641601962770037D

 

 

IT_4150

 

3CR870-95

 

Tag Commissioning - initial Inventory

NEW_RCPT

20131115

111218

1

3539

E2008364641601962770037D

 

 

IT_4150

 

3CR870-95

 

Fixed Reader Product location Move

IMOVETRANS

20130713

93501

-1

4233

FFA000000000000000010063

 

 

TRK001

 

FACF65.220

 

Fixed Reader Product location Move

IMOVETRANS

20130713

93501

1

4235

FFA000000000000000010063

 

 

TRK001

 

FACF65.220

 

Handheld Reader Physical Count

ADJ_PHYINV

20131118

102345

-1

3539

E2008364641601962770037D

 

302

IT_4150

 

3CR870-95

 

Handheld Reader Physical Count

ADJ_PHYINV

20131118

102345

1

2654

E2008364641601962770037D

 

302

IT_4150

 

3CR870-95

 

 

Export Mapping Example Layout (Asset Object)

 

Transaction use Case

Trans Type  RFDHSTACT

Trans date RFDHSTDTE

Trans Time RFDHSTTME

Trans Qty RFDLOCQTY

Cust location RFDERPLOC

Tag ID

RFDTAGUID

Lot #

RFDLOCLOT

Trans Ref RFDHSTREF

 Object ID

RFDIID

Container ID RFDBINID

Part #

UCCITMERP

Serial # RFDASSRLN

 

LOCIH

LOCIH

LOCIH

LOCIH

ILVLT

LOCIH

LOCIH

LOCIH

TGMAP

TGMAP

UCCRCIM

ASSM

Initial XLS Inventory Import - Asset

ADJ_IMPORT

20130621

115147

1

4233

FFA000000000000000010063

 

 

900501

 

T400s

83792SC7K12

Handheld initial Commissioning - Asset

NEW_RCPT

20131115

111218

1

3539

E2008364641601962770037D

 

 

900700

 

TC-42PX14

EV83792U789

Fixed Reader Asset location Move

IMOVETRANS

20130713

93501

-1

4233

FFA000000000000000010063

 

 

900513

 

VP2130B

8B37SS92763

Fixed Reader Asset location Move

IMOVETRANS

20130713

93501

1

4235

FFA000000000000000010063

 

 

900513

 

VP2130B

8B37SS92763

Handheld Reader Physical Count Adjustment

ADJ_PHYINV

20131118

102345

-1

3539

E2008364641601962770037D

 

302

900510

 

DX4200-09

8QS37V92724

Handheld Reader Physical Count Adjustment

ADJ_PHYINV

20131118

102345

1

2654

E2008364641601962770037D

 

302

900510

 

DX4200-09

8QS37V92724

 

Shown below is an example of the actual CSV output file

 

 

Shown below is an example of the Inventory Level Translation table (RFDILVLT) that needs to be populated

 

 

 


Copyright © 2022 Stratum Global, Inc.