| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PRDOC | Parked Document Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | PRGUID | GUID for Parked Document Error Handling | varbinary | 16 | 0 | | | | |
| 5 | CRM_PRODUCT | Template for Creating Contract | nvarchar | 40 | 0 | | | | Allow NULL? |
| 6 | PRODID | Node to Describe Master Data Template | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | STATUS | Parked Document Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | SPARTE | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | VERTRAG | Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | XMOVEIN | Indicator: Create Move-In | char | 1 | 0 | | | | Allow NULL? |
| 11 | XMOVEOUT | Indicator: Create Move-Out | char | 1 | 0 | | | | Allow NULL? |
| 12 | XMOVEOUTPRED | End Previous Contract with Move-Out | char | 1 | 0 | | | | Allow NULL? |
| 13 | XBBPCREATE | Indicator: Create Budget Billing Plan or Payment Plan | char | 1 | 0 | | | | Allow NULL? |
| 14 | ABSBETRW | Budget billing amount in transaction currency | decimal | 13 | 2 | | | | |
| 15 | WAERS | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | STARTYEAR | Beginning year of payment plan | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | CHGRSN | Reason for Change to Budget Billing Amount | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | SEC_TOT_AMOUNT | Requested Amount for Security Deposit | decimal | 11 | 2 | | | | |
| 19 | SEC_REASON | Reason for Requesting a Security Deposit | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | SECWAIVEREAS | Reason for exemption from security | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | INVOICING_PARTY | Service Provider That Invoices the Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | SERVPROV_PAY | Payment Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | PYPLT | Payment plan type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | PYPLS | Starting month of payment plan | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | PYPLA | Alternative start month of payment plan | nvarchar | 2 | 0 | | | | Allow NULL? |
