| 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 | * | MANDT | Allow NULL? |
| 2 | DPBUKRS | Company Code of Security Deposit Agreement | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | RECNDPBUKRS | Allow NULL? |
| 3 | DPNO | Number of Security Deposit Agreement | nvarchar | 13 | 0 | CHAR | (N' ') | No | | RECNDPNO | Allow NULL? |
| 4 | DPACTUALNO | Sequential Number of Actual Security Deposit | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RECNDPACTUALNO | Allow NULL? |
| 5 | DPACTUALFROM | Actual Security Deposit Made On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDPACTUALFROM | Allow NULL? |
| 6 | DPACTUALTYPE | Security Deposit Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCNDPTYPE | RECNDPTYPE | Allow NULL? |
| 7 | DPACTUALINFONUM | Informational Number for Actual Security Deposit | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | RECNDPACTUALINFONUM | Allow NULL? |
| 8 | DPACTUALPLACE | Place of Deposit for Actual Security Deposit | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | RECNDPACTUALPLACE | Allow NULL? |
| 9 | DPACTUALPARTNER | Partner for Actual Security Deposit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | RECNDPACTUALPARTNER | Allow NULL? |
| 10 | DPACPARTNERROLE | Partner Role for Actual Security Deposit | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TB003 | RECNDPACPARTNERROLE | Allow NULL? |
| 11 | DPACTUALTO | Validity of Actual Security Deposit Ends On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDPACTUALTO | Allow NULL? |
| 12 | DPACTUALCOMPL | Processing of Actual Security Deposit Completed | char | 1 | 0 | CHAR | (N' ') | Yes | | RECNDPACTUALCOMPL | Allow NULL? |
| 13 | DPACTUALRECEIVED | Amount Received/Paid for Actual Security Deposit | decimal | 15 | 2 | CURR | ((0)) | Yes | | RECNDPACTUALRECEIVEDAMOUNT | |
| 14 | DPACTUALRETOURED | Amount of Actual Security Deposit Paid Back/Received Back | decimal | 15 | 2 | CURR | ((0)) | Yes | | RECNDPACTUALRETOUREDAMOUNT | |
| 15 | DPACTUALRETODATE | Amount of Actual Security Deposit Returned On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECNDPACTUALRETOUREDDATE | Allow NULL? |
| 16 | DPACTUALRETAINED | Amount of Actual Security Deposit Retained | decimal | 15 | 2 | CURR | ((0)) | Yes | | RECNDPACTUALRETAINEDAMOUNT | |
| 17 | DPACTUALCURR | Currency of Actual Security Deposit | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | RECNDPACTUALCURR | Allow NULL? |
