| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 50 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
2 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 50 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
3 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 50 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
4 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 51 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
5 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 50 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
6 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 50 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
7 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 50 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
8 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 43 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
9 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 64 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
10 | CNVTDMS_11_SCADR | Scrambling Addresses | 26 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
11 | NWS_EXT_ADTE2 | Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt) | 7 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
12 | NWS_EXT_ADTEL | Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt) | 7 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPAddress ManagementBusiness Address |
13 | ADCP | Person/Address Assignment (Business Address Services) | 21 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
14 | ADCPS | Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) | 22 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
15 | ADR2 | Telephone Numbers (Business Address Services) | 10 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
16 | ADR2S | Shadow Table: Telephone Numbers (Business Address Services) | 11 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
17 | ADR2S2 | Shadow Table 2: Telephone Nos (Business Address Services) | 11 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
18 | ADRC | Addresses (Business Address Services) | 60 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
19 | ADRCS | Shadow Table: Addresses (Business Address Services) | 61 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
20 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 62 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPALE Integration Technology |
21 | EDIPHONE | Telephony Data for Partner Profiles | 10 | TEL_NUMBER | Telephone number | nvarchar | 30 | 0 | | |
TOPBank Customer Accounts |
22 | BCA_US_BC_ADDR | Addresses Associated with Bank Cheques | 51 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPBasis Components |
23 | /XFT/INV_Q_6 | PO details (header) for an invoice receipt process | 52 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
24 | /XFT/INV_Q_6_S | PO details (header) for an invoice receipt process | 52 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPClaims Management |
25 | ICLX_PARTICIPANT | Error Table for Participants with XI Input | 24 | TEL_NUMBER | Participant: Participant Phone Number | nvarchar | 30 | 0 | | |
TOPContract Accounts Receivable and Payable |
26 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 25 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPDSD Connector |
27 | /DSD/ME_CONTACT | DSD Connector: Contact Person | 23 | TEL_NUMBER | DSD Connector: Tel number | nvarchar | 30 | 0 | | |
TOPFinancial Accounting |
28 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 60 | TEL_NUMBER | Erste Telefon-Nr.: Vorwahl + Anschluß | nvarchar | 30 | 0 | | |
TOPGlobal Trade Services |
29 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 79 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPLoans Management |
30 | VDCBR_RES_DATA | Table of Data Reported to Credit Bureau (Per Loan) | 43 | TEL_NUMBER | Telephone Number (Metro2 Format) | nvarchar | 10 | 0 | | |
31 | VDCBR_RES_PART | Partner Data Reported to Credit Bureau (Pro Loan) | 17 | TEL_NUMBER | Telephone Number (Metro2 Format) | nvarchar | 10 | 0 | | |
TOPLocalization |
32 | J_1BNFCPD | Nota Fiscal one-time accounts | 91 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPMaster Data |
33 | EFISEL | Field Selection Control for Address Data | 20 | TEL_NUMBER | First Telephone No.: Area Code + Number | nvarchar | 1 | 0 | | |
TOPMove-InOut |
34 | ECAMIOPRTEL | IS-U: Pre-entry Document: Telephone Numbers | 6 | TEL_NUMBER | Telephone No.: Dialling Code + Number | nvarchar | 30 | 0 | | |
TOPPatient Accounting |
35 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 55 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
36 | DFMCA_BRF540 | BRF: Create Address for Business Partner | 27 | TEL_NUMBER | BRF: Expression | nvarchar | 20 | 0 | | |
TOPPurchasing |
37 | T024 | Purchasing Groups | 7 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPUse AP-MD-BP Components |
38 | BUT051 | BP Relationship: Contact Person Relationship | 15 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
39 | BUT051S | Shadow Table BP Relationship: Contact Person Relationship | 16 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
TOPWaste Management |
40 | EHSWAT_APPBP | MD: Waste Permit Partner | 48 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
41 | EHSWAT_MNBP | Waste Manifest/Delivery Note: Partners | 45 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | |
42 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 20 | TEL_NUMBER | First Telephone No.: Area Code + Number | nvarchar | 1 | 0 | | |
43 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 20 | TEL_NUMBER | First Telephone No.: Area Code + Number | nvarchar | 1 | 0 | | |