| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2TN_SI | Payroll Structure Labor Insurance Taiwan | 15 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | |
2 | T7RUSC_BRCODE | Breach codes | 2 | BRCOD | Treatment Regime Breach Code | nvarchar | 2 | 0 | | |
3 | T7RUSC_BRCODET | Breach codes | 3 | BRCOD | Treatment Regime Breach Code | nvarchar | 2 | 0 | | |
TOPTaiwan |
4 | PA0354 | Labor Insurance Taiwan | 27 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | |
5 | T7TW0P | Personal Areas/Subareas (Taiwan) | 13 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | |
6 | T7TW1I | LI Occupational Risk Percentage | 2 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | |
7 | T7TW1IT | LI Occupational Risk Text | 3 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | |
8 | T7TW1K | LI Occupational Risk Percentage | 2 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | |
9 | T7TW1U | LI Occupational Risk Text | 3 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | |
TOPThailand |
10 | T7THBR | Company Branch Codes | 2 | BRCOD | Company Branch Code | nvarchar | 5 | 0 | | |
11 | T7THSB | Social Security Branches | 7 | BRCOD | Company Branch Code | nvarchar | 5 | 0 | | |
12 | T7THTM | Tax Calculation Method - TH | 7 | BRCOD | Company Branch Code | nvarchar | 5 | 0 | | |