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	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