| 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 | 48 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
2 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 48 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
3 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 48 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
4 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 49 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
5 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 48 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
6 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 48 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
7 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 48 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
8 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 41 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
9 | /OPT/VT_USR | Reporting table: Users | 5 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
10 | TTS_PERSONNEL | TTS Approvers | 4 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
11 | ZSE_RSUSR100 | ZZRSUSR100 | 15 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
12 | ZZRSUSR100 | ZZRSUSR100 | 13 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
TOPAddress ManagementBusiness Address |
13 | ADRP | Persons (Business Address Services) | 8 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
14 | ADRPS | Shadow Table: Persons (Business Address Services) | 9 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
TOPBank Customer Accounts |
15 | BCA_US_BC_ADDR | Addresses Associated with Bank Cheques | 14 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
16 | BP000 | Business Partner Master (General Data) | 33 | NAME_LAST | Last Name | nvarchar | 40 | 0 | | |
TOPClaims Management |
17 | ICLX_PARTICIPANT | Error Table for Participants with XI Input | 11 | NAME_LAST | Participant: Participant Last Name | nvarchar | 40 | 0 | | |
TOPContract Accounts Receivable and Payable |
18 | DFKKNRP | NOC Returns Lot: Item Data | 33 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | | |
TOPMove-InOut |
19 | ECAMIOPRBUPA | IS-U: Parked Document: Business Partner Data | 11 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | | |
TOPPatient Accounting |
20 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 4 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | | |
TOPPortfolio |
21 | VDBILL_RES_HEAD | Bill Results Header | 26 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
22 | DFMCA_BRF590 | BRF: Process Business Partner (General Information) | 16 | NAME_LAST | BRF: Expression | nvarchar | 20 | 0 | | |
23 | DFMCA_BRF650 | BRF: Business Partner Reading | 18 | NAME_LAST | BRF: Expression | nvarchar | 20 | 0 | | |
24 | DFMCA_BRF890 | BRF: Business Partner Determination from Form | 19 | NAME_LAST | BRF: Expression | nvarchar | 20 | 0 | | |
TOPReal Estate Management |
25 | S401 | RE standard analysis partner | 30 | NAME_LAST | Last Name | nvarchar | 40 | 0 | | |
TOPUse AP-MD-BP Components |
26 | BUT000 | BP: General data I | 37 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | | |
27 | BUT000_TD | BP: General Data I, Shadow Table Time Dependency | 38 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | | |
28 | BUT000_TDS | BP: General Data I, Shadow Table Time Dependency | 39 | NAME_LAST | Last name of business partner (person) | nvarchar | 40 | 0 | | |
TOPUser and Authorization Management |
29 | USARC_CD | Not Required: Archived User Data -> Change Documents | 14 | NAME_LAST | Last name | nvarchar | 40 | 0 | | |