| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CCEE/FISC_BS | Fiscalization Croatia: Business Space Master Data | 7 | POST_CODE | Postal Code | nvarchar | 12 | 0 | | |
2 | VIXCCHEGID | Localization Switzerland: EGID | 8 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPAddress ManagementBusiness Address |
3 | ADRCITYPRT | Postal districts | 5 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
4 | ADRDIF_CP | District Difference Table for Quarterly Adjustment | 12 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
5 | ADRDIF_PC | Postal Code Difference Table for Quarterly Adjustment | 11 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
6 | ADRDIF_PO | PO Box Difference Table for Quarterly Adjustment | 14 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
7 | ADRDIF_ST | Street Difference Table for Quarterly Adjustment | 22 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
8 | ADRPCDCITY | Postal code/city: Assignment table | 3 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
9 | ADRPOBOX | PO Boxes | 7 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
10 | ADRPSTCODE | Postal codes | 3 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
11 | ADRSTRPCD | Street (section)/postal code: Assignment | 9 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
TOPClaims Management |
12 | ICLCCEVENTZ | Claim Bundle - Postal Code - Assignment | 5 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
13 | ICSCCEVENTZ | Claim Bundle - Postal Code - Assignment | 5 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
14 | FOTRFDITM | VAT Refund Items | 49 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
15 | FOTRFDITMCHG | Change Documents, VAT Refund Item | 23 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPIntegration Customer Relationship Management |
16 | ESALES_PRODAVAIL | Availability of a Product | 4 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPInterfaces |
17 | VRTCP | Routing Info per Carrier/Country/Zip Code | 4 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
TOPJapan |
18 | T7JPCP_EXTINST | Define External Institution | 4 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
19 | T7JPCP_PENSION | Corporate Pension Plan | 20 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
TOPLoans Management |
20 | VDCBR_RES_PART | Partner Data Reported to Credit Bureau (Pro Loan) | 25 | POST_CODE | Postal Code (Metro2 Format) | nvarchar | 9 | 0 | | |
TOPMaintenance Orders |
21 | /MRSS/D_ADDRESS | Stores Primary/Secondary address | 9 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
22 | /MRSS/D_GEO_ZIP | Postal Codes for Georeferencing | 3 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPMaster Data |
23 | EBP_ADDR_SERVICE | Search Index for Business Partner Service Addresses | 10 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
24 | JVSOP | IS-M/SD Shipping Order Item | 10 | POST_CODE | IS-M: Postal Code | nvarchar | 10 | 0 | | |
TOPPortfolio Management |
25 | RPM_PROJ_LOCAT | Project Location | 8 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
TOPProcessing |
26 | EWA_WDOC_WA_PC | Selection Data from Work Area for Regional Structure | 4 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
TOPProject Management |
27 | DPR_LOCATION | Location | 8 | POST_CODE | Postal Code | nvarchar | 10 | 0 | | |
TOPStakeholder Relationship Management |
28 | USC_CONT_ADD | SRM Contact: Event Info | 14 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPStructures Workbench |
29 | /ISDFPS/CMDZONDT | Relocation Zone Determination | 5 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPTravel Expenses |
30 | PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management | 13 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
31 | T706_VAT_FLDS | Country-Dependent Field Control for Receipt Data | 16 | POST_CODE | City Postal Code | nvarchar | 1 | 0 | | |
TOPTravel Management |
32 | TA23ADR | Predefined Addresses in Travel Management | 7 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
TOPTravel Planning |
33 | FTPT_HOTEL_DATA | Hotel Data | 11 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
34 | FTPT_REQUEST | Travel Plan Requests | 28 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |
35 | TA23HOTELS | Hotel Data | 11 | POST_CODE | City postal code | nvarchar | 10 | 0 | | |