User Tools

Site Tools


reports:acq_paths

Acquisitions Reports Source Paths

EDI

Daily EDI Purchase Orders

SOURCE: Purchase Order
FILTERS:

Source Path Name Data Type Operator Transform Filter Value
Purchase Order Order Date timestamp Greater than or equal to Date
Purchase Order > Provider > EDI Default EDI Account ID id Is not NULL Raw Data

DISPLAY FIELDS:

Source Path Column Label Data Type Transform
Purchase Order Purchase Order ID id Raw
Purchase Order State text Raw
Purchase Order > Provider Provider text Raw
Purchase Order Order Date timestamp Raw
Purchase Order > Ordering Agency Ordering Agency text Raw

Daily EDI Messages

SOURCE: EDI Message
FILTERS:

Source Path Name Column Data Type Operator Transform Filter Value
EDI Message > EDI Account > Owner Organizational Unit ID id org_unit In list Raw Data
EDI Message Time Created create_time timestamp Greater than or equal to Date

DISPLAY FIELDS:

Source Path Column Label Data Type Transform
EDI Message EDI Message ID id Raw
EDI Message Time Created timestamp Raw
EDI Message Message Type text Raw
EDI Message > EDI Account > Provider Provider text Raw
EDI Message > Purchase Order (child) Purchase Order ID id Raw
EDI Message > Purchase Order (child) PO Name text Raw
EDI Message > EDI Account EDI Account text Raw
EDI Message Status text Raw

Action Trigger Exceptions

SOURCE: Trigger Event Entry
FILTERS:

Source Path Name Column Data Type Operator Transform Filter Value
Trigger Event Entry > Event Definition Event Definition Equals Raw 23
Trigger Event Entry > Run Time Run Time Equals Date
Trigger Event Entry > State State Not in list Raw complete, invalid

DISPLAY FIELDS:

Source Path Column Label Data Type Transform
Trigger Event Entry Event ID
Trigger Event Entry > Target ID Purchase Order ID
Trigger Event Entry > State Event State
reports/acq_paths.txt · Last modified: 2019/04/18 15:12 by tlittle