Home > Technical > Table Definitions > ALLOCPOSUPP

ALLOCPOSUPP

Not currently used.

When an order allocation has been completed, and the user tries to create a purchase order, the system moves the allocation details into some temporary tables. The user maniplulates these temporary tables and when complete the system will create the final purchase order records (POHEADER and PODETAIL).

There are four temporary tables used:

ALLOCPOSUPP  

One record created for each unique supplier in the allocation.

ALLOCPOITEM

One record created for each unique item for each supplier. This record links back to ALLOCPOSUPP.

ALLOCPODELIVERY   

At least one record for each supplier. This stores the various dates that we can expect the items to be delivered. This record links back to ALLOCPOSUPP. By default the system will create a record being tomorrow’s date plus the supplier’s order lead days.

ALLOCPOQTY  

At least one record containing the number of items to be delivered on a specific date. This is a link between the ALLOCPOITEM and ALLOCPODELIVERY record. By default the system will create one record for the full order quantity to be delivered on the default ALLOCPODELIVERY record.

 

Column

Type

Description

LINTALLOCCODE

INT

The code of the allocation this record belongs to.

ALLOCHEADER.ctrCode

STRSUPPLIERCODE

VARCHAR(10)

The supplier that this record is for.

SUPPLIER.strSupplierCode

 

Primary Key: LINTALLOCCODE+STRSUPPLIERCODE

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