Business days

Business days

tp_Archives - tp_Archives

Object: Business day

Field

Name

Description

arch_ID

Business day

Business days ID

arch_dvsn_ID

Division

Division. Link to tp_Divisions (Divisions)

arch_usr_ID_Open

Opened by

Employee who opened the business day. Link to tp_Users (Employees)

arch_usr_ID_Close

Closed by

Employee who closed the business day. Link to tp_Users (Employees)

arch_dev_ID_Open

Device

POS terminal on which the business day was opened. Link to tp_Devices (Devices)

arch_dev_ID_Close

Closing POS terminal

POS terminal on which the business day was closed. Link to tp_Devices (Devices)

arch_arst_ID

Status

Status. Link to tp_ArchiveStates (Business day statuses)

arch_DateOpen

Open date

Business day start date. A given division can only have one open day.

arch_DateClose

Close date

Business day close date. If the day is not closed, the field value is NULL. Only one business day can stay unclosed in a given division.

arch_Name

Name

Name Generated by the document number format.