| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPPSSRM/SOS | Index-Table con. 'Governm. Proc.'-specific sources of supply | 22 | RECIPIENT_ID | Business Partner Number | nvarchar | 10 | 0 | | |
2 | BBPD_PD_INDEX | Index Table for Fast Access to Contracts and AVLs | 22 | RECIPIENT_ID | Business Partner Number | nvarchar | 10 | 0 | | |
3 | GRFNPOLICYRCPT | DB table for recipient information in policy management | 3 | RECIPIENT_ID | Policy Recipient ID | nvarchar | 50 | 0 | | |
4 | GRFNRCPTTASK | Table to store the relationship between plan usage and rcpt | 3 | RECIPIENT_ID | Recipient component ID | nvarchar | 20 | 0 | | |
5 | GRFNRECIPIENT | This table is used to store the information of the recipient | 2 | RECIPIENT_ID | Recipient component ID | nvarchar | 20 | 0 | | |
6 | GRFNRECIPIENT_T | This table is the text table for recipient | 3 | RECIPIENT_ID | Recipient component ID | nvarchar | 20 | 0 | | |
7 | SWWBCSSTATUS | Workflow: Demo for BCS Status - Confirmations | 3 | RECIPIENT_ID | GUID in 'RAW' format | varbinary | 16 | 0 | | |
TOPIncident Reporting |
8 | EHHSSD_IRT_RPT | Report | 12 | RECIPIENT_ID | Report Recipient | nvarchar | 13 | 0 | | |
TOPOffice Suite Program |
9 | SOSP_T_BKT_PERFM | Book Keeping table for Performance | 5 | RECIPIENT_ID | User Name | nvarchar | 12 | 0 | | |
TOPPerishables Procurement |
10 | FIP_D_ORDER_LINE | Order lines for FIP | 12 | RECIPIENT_ID | FIP Recipient Number | nvarchar | 10 | 0 | | |
TOPSAP Business Workflow |
11 | SWN_NOTIF | WF Notif: Notifications | 7 | RECIPIENT_ID | IP/Recipient Address | nvarchar | 241 | 0 | | |
12 | SWN_SUBS | WF Notif: Subscriptions | 10 | RECIPIENT_ID | IP/Recipient Address | nvarchar | 241 | 0 | | |