| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | NPLR | Legal Representative | 3 | PARTNER2 | Patient Number | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
2 | /NAM/BUT9XZZSE | Block | 3 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
3 | JJCPFREESUB | IS-M: Free Subscription - Contact Person Relationship | 3 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
4 | JJCPRESPONSIB | IS-M: Responsibility in Contact Person Relationship | 3 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
TOPBusiness Partner |
5 | BPRBPCA | BPCA | 3 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
TOPBusiness Partners |
6 | NIPR | Addnl HC-Specific Ins. Prov. Relatshp Data for SAP BP | 6 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
7 | NNOK | Additional HC-Specific Next of Kin Data for SAP BP | 3 | PARTNER2 | Patient Number | nvarchar | 10 | 0 | | |
8 | NPEP | Addnl HC-Specific Pat-Employer Relatshp Data for SAP BP | 3 | PARTNER2 | Patient Number | nvarchar | 10 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
9 | DFMCA_BUPR_TA2 | Data Table for Tax Advisor | 3 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
TOPSAP Business Partner |
10 | BUT053 | BP Relationship: Company Interest | 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
11 | BUT054 | BP Relationship (not used yet) | 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
TOPUse AP-MD-BP Components |
12 | BUT050 | BP relationships/role definitions: General data | 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
13 | BUT050S | BP Relationships/Role Definitions: General Data | 5 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
14 | BUT050_CD | BP Rel./Role Determination:Index Table for Change Doc.Access | 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
15 | BUT051 | BP Relationship: Contact Person Relationship | 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
16 | BUT051S | Shadow Table BP Relationship: Contact Person Relationship | 5 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
17 | BUT052 | BP Relationship: Addresses | 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
18 | BUT052S | Shadow Table BP Relationship: Addresses | 5 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |
19 | BUT150 | BP relationship: Attribute table (test different.type TBUKR) | 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | | |