| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FIWTIN_ACC_EXEM | Cumulative values for accounts payable/ account receivable | 3 | ACCNO | Vendor/customer account number | nvarchar | 10 | 0 | | |
2 | FIWTIN_TAN_EXEM | Table for mapping TAN and Exemption Number | 4 | ACCNO | Vendor/customer account number | nvarchar | 10 | 0 | | |
3 | GRACREQUSER | User Associated with Request | 9 | ACCNO | Accounting Number | nvarchar | 12 | 0 | | |
4 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 7 | ACCNO | HR payroll: Number | decimal | 15 | 2 | | |
5 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 7 | ACCNO | HR payroll: Number | decimal | 15 | 2 | | |
6 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 7 | ACCNO | HR payroll: Number | decimal | 15 | 2 | | |
7 | VIXCITCADAO | Temporary architectural object data | 102 | ACCNO | Account number | nvarchar | 10 | 0 | | |
TOPBasic Functions |
8 | GLACCREFI | G/L Account Master Record: Create with Reference | 5 | ACCNO | G/L Account Number | nvarchar | 10 | 0 | | |
TOPFlexible Real Estate Management |
9 | TIVXCITICIPARAM | ICI/IMU City parameter | 3 | ACCNO | Account number | nvarchar | 10 | 0 | | |
10 | VIXCITICIDATA | ICI master data | 12 | ACCNO | Account number | nvarchar | 10 | 0 | | |
TOPKorea |
11 | PA0881 | HR Master Record: Infotype 0881 | 108 | ACCNO | Account Number | nvarchar | 20 | 0 | | |
TOPLocalization |
12 | J_1AR_DTYPE | ARG - Gross Income Perception Customer Data | 4 | ACCNO | Vendor/customer account number | nvarchar | 10 | 0 | | |
13 | J_1AR_TPLIST | Information to Update Taxpayer List | 3 | ACCNO | Vendor/customer account number | nvarchar | 10 | 0 | | |
TOPMalaysia |
14 | T5LEP | Employee Provident fund for Malaysia | 11 | ACCNO | Company account number | nvarchar | 17 | 0 | | |
15 | T5LSP | Employer reference for SOCSO (Malaysia) | 8 | ACCNO | Company account number | nvarchar | 17 | 0 | | |
16 | T5LTK | Reference Number output attributes | 13 | ACCNO | Company account number | nvarchar | 17 | 0 | | |
17 | T5LTP | Employer reference for tax | 9 | ACCNO | Company account number | nvarchar | 17 | 0 | | |
TOPRadiology |
18 | N1MPPS | IS-H*MED RAD: RIS Modality Performed Procedure Step | 9 | ACCNO | RAD: Accession Number | nvarchar | 64 | 0 | | |
19 | N1QUERY | IS-H*MED: Radiology: QUERY | 4 | ACCNO | RAD: Accession Number | nvarchar | 64 | 0 | | |
TOPReporting |
20 | P05T_WCR_ER_INFO | WCR Info on Employer Level | 10 | ACCNO | General Ledger Account Number | nvarchar | 10 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
21 | NVVN | IS-H: Guarantors | 16 | ACCNO | IS-H: Account Number | nvarchar | 17 | 0 | | |
TOPThailand |
22 | T7THSB | Social Security Branches | 5 | ACCNO | Company account number for social security | nvarchar | 10 | 0 | | |