Key Map GL

This field will hold the unique Reference trace id used for drill back/forward and traceability purposes

This field will store Reference trace type information used for drill back purposes.

This field contains the row id of each record from IF_TRAN_DATA table which is used to drill back the records processed by fifgldn1.pc batch program.

This field will hold the item number.

This field will hold the dept number.

This field will hold the class number.

This field will hold the subclass number.

This field will hold the transaction date for records processed by fifgldn1 or the post date if processed by other financial download batch.

This filed will hold the transaction code.

This field will hold the location number (store/wh).

This field will hold the type of the location (either Store or Warehouse).

This field will hold the deal_no of the fixed deal record stored in the FIXED_DEAL table.

This field contains the reference number associated with a transaction. It is used for defining the General Ledger account relationship along with dept, class, subclass, location, and tran_code, etc. For example: if tran_code is 22 or 23, then this field contains an Inventory Adjustment Reason Code; if tran_code is 37 or 38, then this field contains From_loc or To_loc for the Intercompany Transfer; if tran_code is 63 or 64, then this field contains Work Order Activity ID; if tran_code is 87 or 88, then this field contains the VAT code associated with the transaction.

Contains the cost or retail value of the transaction.

Identifies the Oracle Retail module where the record was written.

Business date when transaction was processed by financial jobs.