Home > Technical > Table Definitions > 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. |
One record created for each unique item for each supplier. This record links back to ALLOCPOSUPP. |
|
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. |
|
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 |
INT |
The code of the allocation this record belongs to. |
|
VARCHAR(10) |
The supplier that this record is for. |
Primary Key: LINTALLOCCODE+STRSUPPLIERCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |