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 | ||
Taiwan | ||||||||||
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 | ||
Thailand | ||||||||||
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 |