Entity Definition

Logical Name : PeriodOpenTransaction
Physical Name : TR_PRD_OPN

A transaction that declares the start of a ReportingPeriod at the BusinessUnit where it is conducted. Reporting periods include DayPart, Shift, BusinessDay, Week, Month, Quarter and Year.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)


Parent Entity Verb Phrase Child Entity
PeriodOpenTransaction opens BusinessUnitGroupReportingPeriod
ControlTransaction can be a PeriodOpenTransaction

Logical Views containing PeriodOpenTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 02400 - Control Transaction Macro View
Logical 02430 - Control Transaction - Period Open Close View
Logical 03160 - Reporting - Store Operations - Till View
Logical 06100 - Calendar View