| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P01BN_BWXX | Data Record: Contribution Statement | 68 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
TOPBW Service API |
2 | ROVERCUSTA | Attributes for Customers in Verification Scenario | 5 | PLZ | Postal Code in Verification Scenario | nvarchar | 10 | 0 | | |
3 | ROVERFIEA | Field Number in Verification Scenario | 6 | PLZ | Postal Code in Verification Scenario | nvarchar | 10 | 0 | | |
TOPCompany Pension Scheme Germany |
4 | P01RBM_IM01 | Notification Data IM01 Pension Receipt Notif. Answer Tax ID | 25 | PLZ | Postal Code | nvarchar | 12 | 0 | | |
5 | P01RBM_MI01 | Notification Data MI01 Pension Receipt Notif. Query Tax ID | 37 | PLZ | Postal Code | nvarchar | 12 | 0 | | |
6 | P01RBM_MI01R | Confirmation MI01 Pension Receipt Notification Query Tax ID | 37 | PLZ | Postal Code | nvarchar | 12 | 0 | | |
TOPGermany |
7 | PD3DBAN | HR-DDU: Address Data Module | 6 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
8 | T5D4X_ZERTR | Certificate Request - Admin. Contrib. Statmt Certificates | 16 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
9 | JKTWBZIN | IS-M/SD: Clipboard for WBZ Records for Processing | 31 | PLZ | IS-M: WBZ, Postal Code | nvarchar | 8 | 0 | | |
10 | JKTWBZOUT | IS-M/SD: Clipboard for Processed WBZ Records | 19 | PLZ | IS-M: WBZ, Postal Code | nvarchar | 8 | 0 | | |
11 | JVTGEBINDE | IS-M/SD: Container (Acc.to ZEBU) | 6 | PLZ | IS-M: Postal code for ZEBU | nvarchar | 10 | 0 | | |
12 | JVTMODZEBU | IS-M/SD: Modified ZEBU Records | 4 | PLZ | IS-M: Postal code for ZEBU | nvarchar | 10 | 0 | | |
13 | JVTORGZEBU | IS-M/SD: Node Data for ZEBU Node | 3 | PLZ | IS-M: Postal code for ZEBU | nvarchar | 10 | 0 | | |
14 | JVTPLZZEBU | IS-M/SD: Postal Codes - ZEBU | 3 | PLZ | IS-M: Postal code for ZEBU | nvarchar | 10 | 0 | | |
TOPSAP Media |
15 | J_1SORGZEB | IS-M/SD CH/V: Node Data on a ZEBU Node | 4 | PLZ | IS-M: Postal code for ZEBU | nvarchar | 10 | 0 | | |
TOPSocial Insurance |
16 | P01BM_DBAN | Address Data Modules for PPO DEUEV Notifications | 4 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
17 | P01D3_DBAN | DEUEV Confirmation: Address Data Module | 4 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
18 | P01DS_DBAN | Data Modules Address of DEUEV Immediate Notifications | 4 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
19 | P01EE_DBAN | Data Module DBAN Address | 4 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
20 | P01EL_DBAN | Data Module Address of ELENA Notifications | 4 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
TOPStatements |
21 | P01W_DBAN | Data Module: Address | 8 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
TOPTravel Planning |
22 | TA21PH | Customer-Specific Hotel Catalog | 11 | PLZ | Postal Code | nvarchar | 10 | 0 | | |
23 | TA23OFFICE_ADR | Sales Office Addresses | 8 | PLZ | Sales Office Address: Postal Code (ZIP Code) | nvarchar | 10 | 0 | | |