| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | J_1I_EXIM_AGT | EXIM : Agent Code | 2 | AGCOD | Agent Code | nvarchar | 4 | 0 | | |
2 | J_1I_EXIM_WF | EXIM : Workflow Levels and Approvers at Request Level | 7 | AGCOD | Agent Code | nvarchar | 4 | 0 | | |
3 | T7INPEW1 | P2E: Workflow Levels and Approvers at Request Level | 11 | AGCOD | Approver Code | nvarchar | 4 | 0 | | |
4 | T7INPEW2 | P2E: Follow On Actions for Request Level Workflows | 13 | AGCOD | Approver Code | nvarchar | 4 | 0 | | |
5 | T7INPEW3 | P2E: Agent Code | 2 | AGCOD | Approver Code | nvarchar | 4 | 0 | | |
6 | T7INPEW3T | P2E: Agent Code Text | 3 | AGCOD | Approver Code | nvarchar | 4 | 0 | | |
7 | T7INPEW4 | P2E: Group Code mapping table with agents | 6 | AGCOD | Approver Code | nvarchar | 4 | 0 | | |
8 | T7INPEW5 | P2E: Workflow Levels and Approvers at Policy Level | 10 | AGCOD | Approver Code | nvarchar | 4 | 0 | | |
9 | T7INPEW8 | P2E: Follow On Actions for Policy Level Workflows | 11 | AGCOD | Approver Code | nvarchar | 4 | 0 | | |
TOPBrazil |
10 | PA0736 | Alimony order for Brazil | 28 | AGCOD | Code for agency | nvarchar | 1 | 0 | | |
TOPCanada |
11 | PA0066 | HR Master data infotype 0066 - Canadian garnishment: order | 28 | AGCOD | Code for agency | nvarchar | 1 | 0 | | |
TOPMexico |
12 | PA0426 | Garnishment | 28 | AGCOD | Code for agency | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
13 | PA0476 | HR master record infotype 0476 (Deductions Spain) | 58 | AGCOD | Code for Garnishment Agency | nvarchar | 1 | 0 | | |
14 | T52G4 | Agency | 3 | AGCOD | Code for agency | nvarchar | 1 | 0 | | |
15 | T52G5 | Description of the agency | 4 | AGCOD | Code for agency | nvarchar | 1 | 0 | | |
16 | T53G2 | Agency | 3 | AGCOD | Code for Garnishment Agency | nvarchar | 1 | 0 | | |
17 | T53G2T | Description of the agency | 4 | AGCOD | Code for Garnishment Agency | nvarchar | 1 | 0 | | |