Import Process
DataPrivMaster
| Database Mapping | Lookup | |||||||
| Column | Description | Table | Field | DB Type | Table | Field | ||
| Code | Code | @XIS_DATAPRIV_STMT | Code | NVARCHAR(50) | ||||
| U_Type | Type ‘BP’ = Business Partner or ‘CP’ = Contact Person | @XIS_DATAPRIV_STMT | U_Type | NVARCHAR(8) | ||||
| U_BPCode | BP Code | @XIS_DATAPRIV_STMT | U_BPCode | NVARCHAR(50) | OCRD | CardCode | ||
DataPrivDetail
| Database Mapping | Lookup | |||||||
| Column | Description | Table | Field | DB Type | Table | Field | ||
| Code | Code | @XIS_DATAPRIV_STMT1 | Code | NVARCHAR(50) | @XIS_DATAPRIV_STMT | Code | ||
| LineId | Line Number | @XIS_DATAPRIV_STMT1 | LineId | INTEGER | ||||
| U_Type | Type D = Dealer Or M = Manufacturer | @XIS_DATAPRIV_STMT1 | U_Type | NVARCHAR(50) | ||||
| U_PhoneChannelState | Phone Channel State (Y/N) | @XIS_DATAPRIV_STMT1 | U_PhoneChannelState | NVARCHAR(1) | ||||
| U_PostChannelState | Post Channel State (Y/N) | @XIS_DATAPRIV_STMT1 | U_PostChannelState | NVARCHAR(1) | ||||
| U_EmailChannelState | Email Channel State (Y/N) | @XIS_DATAPRIV_STMT1 | U_EmailChannelState | NVARCHAR(1) | ||||
| U_SMSChannelState | SMS Channel State (Y/N) | @XIS_DATAPRIV_STMT1 | U_SMSChannelState | NVARCHAR(1) | ||||
| U_SignedPolicy | Signed Policy (Y/N) | @XIS_DATAPRIV_STMT1 | U_SignedPolicy | NVARCHAR(1) | ||||
Export Process
The exported data follows the same pattern as the imported data,
The Export GDPR Master contains the fields "Code", "U_Type", "U_BPCode" from table "@XIS_DATAPRIV_STMT" and the Export GDPR Detail contains the fields "Code", "LineId", "U_Type", "U_PhoneChannelState", "U_PostChannelState", "U_EmailChannelState", "U_SMSChannelState", "U_SignedPolicy" from table "@XIS_DATAPRIV_STMT1".
0 Comments