| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | FRMAT | Preliminary Program DME: Salary Statement Format in Purpose | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PAY_DME_RSFORMAT | Allow NULL? |
| 3 | APPL | Preliminary Program DME: Subapplication for Purpose | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T596A | PAY_DME_RSAPPL | Allow NULL? |
| 4 | ROWNM | Preliminary Program DME: Max. Line Number for Sal. Statement | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PAY_DME_RSROWNM | Allow NULL? |
| 5 | COLNM | Preliminary Program DME: Column Number for Salary Statement | char | 1 | 0 | NUMC | (N'0') | Yes | | PAY_DME_RSCOLNM | Allow NULL? |
| 6 | COLLN | Preliminary Program DME: Column Length in Salary Statement | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PAY_DME_RSCOLLN | Allow NULL? |
| 7 | TXPOS | Preliminary Program DME: Start Position for WT Description | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PAY_DME_RSTXPOS | Allow NULL? |
| 8 | AMPOS | Preliminary Program DME: Start Position for Wage Type Value | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PAY_DME_RSAMPOS | Allow NULL? |
| 9 | AMLEN | Preliminary Program DME: Length of Wage Type Amount | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PAY_DME_RSAMLEN | Allow NULL? |
| 10 | VZPOS | Preliminary Program DME: Start Position for Plus/Minus Sign | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PAY_DME_RSVZPOS | Allow NULL? |