| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRFNPOLICYRCPT | DB table for recipient information in policy management | 4 | RECIPIENT_TYPE | Policy Recipient Type | nvarchar | 10 | 0 | | |
TOPEnd User Technology |
2 | RSRA_ER_FOLLOWUP | Follow-Up Actions for Reporting Agent Exception Reporting | 9 | RECIPIENT_TYPE | Report Agent Information Receiver | nvarchar | 1 | 0 | | |
TOPOLAP Technology |
3 | RSRA_ER_LOG_ENTR | Log Entries for every Exception | 10 | RECIPIENT_TYPE | Report Agent Information Receiver | nvarchar | 1 | 0 | | |
4 | RSRA_ER_PROP | Details of Follow-up Actions | 4 | RECIPIENT_TYPE | Report Agent Information Receiver | nvarchar | 1 | 0 | | |
TOPPerishables Procurement |
5 | FIP_D_DRD | Relationships between supplying plant, material and recipien | 5 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
6 | FIP_D_MAT_RCPNT | Relationship Material and Recipients in FIP | 5 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
7 | FIP_D_ORDER_LINE | Order lines for FIP | 11 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
8 | FIP_D_RCPNT | Recipients for FIP | 4 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
9 | FIP_D_SP_MAT_RCP | Relationship supplying plant, material, recipient for FIP | 6 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
10 | FIP_D_SP_RCPNT | Relationship Supply Plant and Recipient | 5 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
11 | FIP_D_S_PRICES | Buffer table for sales prices information | 5 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
12 | FIP_D_S_PRICE_SP | Buffer table for sales prices of supplying plant to receipie | 3 | RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | nvarchar | 1 | 0 | | |
TOPRecords and Case Management |
13 | RMPSU_EVENT_MAIL | Mail recipient information for RMPS Event Notification | 5 | RECIPIENT_TYPE | Specification of recipient type | nvarchar | 1 | 0 | | |
TOPSAP Business Workflow |
14 | SWN_NOTIF | WF Notif: Notifications | 8 | RECIPIENT_TYPE | Recipient Type | nvarchar | 3 | 0 | | |
15 | SWN_SUBS | WF Notif: Subscriptions | 11 | RECIPIENT_TYPE | Recipient Type | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
16 | TCORC_ALOWED_BPG | (Obsolete)Allowed BP Groups for Deal Corr.activities | 7 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
17 | TCORC_BUS_ATTR | Business attributes | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
18 | TCORC_DEAL_ACTVT | Correspondence Deal's activity assignment | 7 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
19 | TCORC_INB_FUNC | Inbound correspondence function | 3 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
20 | TCORFC_CHN_ASG | Assignment of Channel to Profile and Service | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
21 | TCORFC_FORMT_ASG | Format Assignment | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
22 | TCORFC_FORM_ASG | (Obsolete) Format assignment to Service and Channel | 3 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
23 | TCORFC_RECTYP_T | Recipient Types - Text Table | 2 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
24 | TCORFC_REC_TYPE | Recipient Types | 2 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
25 | TCORFTS_RECTYP_T | (Obsolete) Recipient Types - Text Table | 1 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
26 | TCORFTS_REC_TYPE | (Obsolete) Recipient Types | 1 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
27 | TCORT_BP_BIC | BIC Codes/ Account numbers for Business partners | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
28 | TCORT_CO | Correspondence Administrative Data | 20 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
29 | TCORT_EXT_ASSIGN | Assignments of Profiles & BP groups to external recipients | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
30 | TCORT_INB_ASSIGN | BP group assignment for Inbound Correspondence | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
31 | TCORT_INB_FUNC | Inbound CO function assignment | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
32 | TCORT_INT_ASSIGN | Assignments of Profiles & BP groups to internal recipients | 4 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
33 | TCORT_SAT_ACTVT | Correspondence Security account transfer activity assignment | 6 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |
34 | TCORT_SAT_ALLBPG | (Obsolete) Allowed BP Groups for SAT Corresp. activities | 6 | RECIPIENT_TYPE | Recipient/Sender Type | nvarchar | 15 | 0 | | |