| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPPerishables Procurement |
| 1 | FIP_D_DRD | Relationships between supplying plant, material and recipien | 4 | RECIPIENT_NUM | FIP Recipient Number | nvarchar | 10 | 0 | | |
| 2 | FIP_D_MAT_RCPNT | Relationship Material and Recipients in FIP | 4 | RECIPIENT_NUM | FIP Recipient Number | nvarchar | 10 | 0 | | |
| 3 | FIP_D_RCPNT | Recipients for FIP | 3 | RECIPIENT_NUM | FIP Recipient Number | nvarchar | 10 | 0 | | |
| 4 | FIP_D_SP_MAT_RCP | Relationship supplying plant, material, recipient for FIP | 5 | RECIPIENT_NUM | FIP Recipient Number | nvarchar | 10 | 0 | | |
| 5 | FIP_D_SP_RCPNT | Relationship Supply Plant and Recipient | 4 | RECIPIENT_NUM | FIP Recipient Number | nvarchar | 10 | 0 | | |
| 6 | FIP_D_S_PRICES | Buffer table for sales prices information | 4 | RECIPIENT_NUM | FIP Recipient Number | nvarchar | 10 | 0 | | |
| 7 | FIP_D_S_PRICE_SP | Buffer table for sales prices of supplying plant to receipie | 4 | RECIPIENT_NUM | FIP Recipient Number | nvarchar | 10 | 0 | | |
