| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FITHA_BRNCH | Branch details of Business Partner | 5 | BCODE | Branch Code | nvarchar | 5 | 0 | | |
2 | FITHA_BRNCH_T | Branch Code Text of Business Partner | 6 | BCODE | Branch Code | nvarchar | 5 | 0 | | |
3 | ZIDES_USR02 | Logon data of certain users | 3 | BCODE | Password Hash Key | varbinary | 8 | 0 | | |
4 | ZUSR02 | Users and passwords | 3 | BCODE | Password Hash Key | varbinary | 8 | 0 | | |
TOPArgentina |
5 | T7AR02 | Additional data by Company | 8 | BCODE | Bank for benefits-related deduction deposit | nvarchar | 15 | 0 | | |
TOPAuthentication and SSO |
6 | USH02 | Change history for logon data | 8 | BCODE | Password Hash Key | varbinary | 8 | 0 | | |
7 | USR02 | Logon Data (Kernel-Side Use) | 3 | BCODE | Password Hash Key | varbinary | 8 | 0 | | |
8 | USR40 | Table for illegal passwords | 1 | BCODE | Password Pattern or Individual Value | nvarchar | 40 | 0 | | |
9 | USRPWDHISTORY | Password History | 5 | BCODE | Password Hash Key | varbinary | 8 | 0 | | |
TOPCommunication |
10 | TN14M_SE_MAP | Map Treatment Program | 3 | BCODE | IS-H: Treatment Program | nvarchar | 1 | 0 | | |
TOPPatient Management |
11 | NBEW | IS-H: Movements for Case | 78 | BCODE | IS-H: Treatment Program | nvarchar | 1 | 0 | | |
12 | TN14M | IS-H: Treatment Program | 3 | BCODE | IS-H: Treatment Program | nvarchar | 1 | 0 | | |
13 | TN14N | IS-H: Texts for Treatment Codes (Medical Program) | 4 | BCODE | IS-H: Treatment Program | nvarchar | 1 | 0 | | |
TOPSwitzerland |
14 | T5C2P | WHT Geneva: Conversion of Pay Scale Indicator | 4 | BCODE | Pay Scale Key for File (GeTIS) | nvarchar | 3 | 0 | | |
TOPUser and Authorization Management |
15 | USH02_ARC_TMP | Change History for Logon Data: Last Entries from Archive | 8 | BCODE | Password Hash Key | varbinary | 8 | 0 | | |