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