Extracting data from item transaction file

Use this report to extract data from the item transaction (ICTRANS) file.

Extract data from item transaction (ICTRANS) file

  1. Access IC Transactions CSV Create (IC504).
  2. Specify Job Name and Description.
  3. Select whether to extract data based on Update Dates or Transaction Dates. You must specify an Update or Transaction Date range.
  4. Select whether to Exclude Cost data in the Item Transaction extract. If you select Yes, then these cost fields are blank in the output:
    • ICT-UNIT-COST

    • ICT-UNIT-COST-CURR

    • ICT-ADD-UNIT-COST

    • ICT-BASE-COST

    • ICT-CURRENT-COST

    • ICT-UNIT-PRICE

    • ICT-TO-CO-B-UCOST

  5. Submit report.
  6. This CSV file is created in the $LAWDIR/productline/interface folder from the data files specified. File names and path can be renamed if desired.
Extracts data from CSV Default File Name Datafile extracted
Inventory Transactions IC504ICT ICTRANS

The PCR-PO-NUMBER, PCR-PO-RELEASE, PCR-PO-CODE, PCR-PO-DATE, PCR-VENDOR and PLI-LINE-NBR fields are appended to the end of the list of the ICTRANS fields

The ICT-COMPANY, ICT-LOCATION, ICT-DOC-TYPE= PO, ICT-SYSTEM-CODE = PO and ICT-DOCUMENT values are used to access the POR-PORECEIVE file.

The ICT-DOCUMENT value is the same as the POR-REC-NUMBER value.

The POR-PORECEIVE record is used to get the PURCHORDER and POLINE values.