Home > Technical > Table Definitions > ALLOCHEADER

ALLOCHEADER

Not currently used.

An allocation consists of a header record to group the allocation details together (ALLOCHEADER), at least one record for each item to be allocated (ALLOCITEM) and at least one record showing how an item is allocated to various locations (ALLOCDETAIL).

Column

Type

Description

CTRCODE

INT

A unique code identifying the allocation. Assigned by the system.

STRWHO

VARCHAR(20)

The user who created the record.

DTMWHEN

DATETIME

The date the record was created.

STRSTATUS

VARCHAR(10)

The current status of the allocation:

New Order

A new allocation for ordering purposes.

Ordered

When purchase orders are created for a ‘New Order’ allocation, it is set to this status.

Distribute

A new allocation for distribution purposes.

Allocated

The status of a ‘Distribute’ allocation that has had transfer details created.

 

Primary Key: CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)