|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Credit Memo - Rows
Table Name: ACD1
Table Description: Credit Memo - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OACD | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| AcctCode | Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| LineTotal | Line Total | Num | 19.6 | - | Â | Â | Â |
| TotalFrgn | Line Total (FC) | Num | 19.6 | - | Â | Â | Â |
| TotalSys | Line Total (SC) | Num | 19.6 | - | Â | Â | Â |
| DprArea | Depreciation Area | nVarChar | 15 | ODPA | Â | Â | Â |
| Remarks | Remarks | nVarChar | 100 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| NewItemCod | New Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| Partial | Partial | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| APC | APC | Num | 19.6 | - | Â | Â | Â |
| NewAstCls | New Asset Class | nVarChar | 20 | OACS | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | Â | Â | Â |
| TransType | Transaction Type | nVarChar | 4 | - | Â | 0 | Unknown |
| Â | Â | Â | Â | Â | Â | 110 | Acquisition |
| Â | Â | Â | Â | Â | Â | 115 | Subacquisition |
| Â | Â | Â | Â | Â | Â | 120 | Credit Memo |
| Â | Â | Â | Â | Â | Â | 130 | APC Write-Up |
| Â | Â | Â | Â | Â | Â | 210 | Full Retirement |
| Â | Â | Â | Â | Â | Â | 220 | Full Scrapping |
| Â | Â | Â | Â | Â | Â | 230 | Partial Retirement |
| Â | Â | Â | Â | Â | Â | 240 | Partial Scrapping |
| Â | Â | Â | Â | Â | Â | 310 | Full Transfer |
| Â | Â | Â | Â | Â | Â | 320 | Partial Transfer |
| Â | Â | Â | Â | Â | Â | 410 | Manual Ordinary Depreciation |
| Â | Â | Â | Â | Â | Â | 420 | Manual Unplanned Depreciation |
| Â | Â | Â | Â | Â | Â | 430 | Manual Special Depreciation |
| Â | Â | Â | Â | Â | Â | 440 | Appreciation |
| Â | Â | Â | Â | Â | Â | 510 | Change of Depreciation Type |
| Â | Â | Â | Â | Â | Â | 520 | Change of Useful Life |
| Â | Â | Â | Â | Â | Â | 530 | Change of Depreciation Start Date |
| Â | Â | Â | Â | Â | Â | 540 | Change of Salvage Value |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode2 | Distribution Rule 2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule 5 | nVarChar | 8 | OOCR | Â | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |