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