|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Period-End Closing
Table Name: CCPD
Table Description: Period-End Closing
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| PerAbs | Period Code | Int | 11 | - | Â | Â | Â |
| Line_ID | Row Number | Int | 11 | - | 0 | Â | Â |
| ProfitAct | Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| Ref1 | Reference 1 | nVarChar | 11 | - | Â | Â | Â |
| Ref2 | Reference 2 | nVarChar | 11 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| RefDate | Posting Date | Date | 8 | - | Â | Â | Â |
| TaxDate | Document Date | Date | 8 | - | Â | Â | Â |
| Memo | Row Details | nVarChar | 254 | - | Â | Â | Â |
| MarkLine | Select | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ActKeyLine | Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| LocBalLine | Current Balance | Num | 19.6 | - | Â | Â | Â |
| FcBalLine | Balance (Account Currency) | Num | 19.6 | - | Â | Â | Â |
| SysBalLine | Balance (SC) | Num | 19.6 | - | Â | Â | Â |
| ToPerAbs | To Period Code | Int | 11 | - | Â | Â | Â |
| CtrlAct | Control Account | nVarChar | 15 | OACT | Â | Â | Â |
| PL_ACCOUNT | P/L Account | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Ref1_l | Reference 1 for line | nVarChar | 100 | - | Â | Â | Â |
| Ref2_l | Reference 2 for line | nVarChar | 100 | - | Â | Â | Â |
| Ref3_l | Reference 3 for line | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | PerAbs |
| Â | Â | Line_ID |