Table where the calculation of the sum of the unit value divided by the number of inputs is recorded, to calculate the purchase price of the product
Data model
Fields
| Field | Type | Description |
|---|---|---|
| aipp_entry_mov | INT | Number of inbound entries for the associated product |
| aipp_id* | INT | Unique identifier of the table |
| group_id | INT | Identifier of the location where the product is located. |
| prod_id | INT | Product identifier. |
Primary Key
| PK_AFLS_INVENTORY_PRODUCTS_PURCHASE |
|---|
| aipp_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| group_id | dbo.AFLS_INVENTORY_LOCATION_INFO | grou_id | FK01_AFLS_INVENTORY_PRODUCTS_PURCHASE |
| prod_id | dbo.AFLS_INVENTORY_PRODUCTS | prod_id | FK02_AFLS_INVENTORY_PRODUCTS_PURCHASE |