| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | RANL | Contract Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 4 | S_REORGARCSTAT | Status of the Archiving/Reorganization for a Loan | char | 1 | 0 | | | | Allow NULL? |
| 5 | S_PROC_STAT | Number of Archiving Runs for a Loan | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | SANLF | Product Category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | GSART | Product Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | SANTWHR | Contract Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | SHWHR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | D_ARC_R | Specified Key Date for Last Loan Document Data Archiving | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | D_ARC_R_PAY | Spec. Key Date "Payment" of Last Document Data Archiving | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | D_ARC | Key Date of the Last Loan Document Data Archiving | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DVARC | Maximum Calculation Date of the Last Loan Document Archiving | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | DPARC | Maximum Posting Key Date of the Last Loan Document Archiving | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | DFARC | MAximum Due Date of the Last Loan Document Data Archiving | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | DDARC | Maximum Payment Date of the Last Loan Document Archiving | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | RERF | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | DERF | First Entered on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | TCODE | Transaction Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 21 | ARCHIVEKEY | Key for Archive File | nvarchar | 20 | 0 | | | | Allow NULL? |