|
|
SQL Finance / Credit Memo - Rows
API ACD1
ACD1 - Credit Memo - Rows Table
G/L Accounts OACT SQL Table
Credit Memo OACD SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Items OITM SQL Table
Asset Classes OACS SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | OACD Credit Memo | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| AcctCode | Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| Quantity | Quantity | Num | 20 | |||||
| LineTotal | Line Total | Num | 20 | |||||
| TotalFrgn | Line Total (FC) | Num | 20 | |||||
| TotalSys | Line Total (SC) | Num | 20 | |||||
| DprArea | Depreciation Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| Remarks | Remarks | nVarChar | 100 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| NewItemCod | New Item Code | nVarChar | 20 | OITM Items | ||||
| Partial | Partial | VarChar | Y) Yes N) No | 1 | N | |||
| APC | APC | Num | 20 | |||||
| NewAstCls | New Asset Class | nVarChar | 20 | OACS Asset Classes | ||||
| ObjType | Object Type | nVarChar | 20 | |||||
| TransType | Transaction Type | nVarChar | 0 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 | 4 | ||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Distribution Rule 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes |
Table relationship map
SELECT statement
SELECT
ACD1.DocEntry AS 'Document Internal ID',
ACD1.LineNum AS 'Row Number',
ACD1.ItemCode AS 'Item Code',
ACD1.AcctCode AS 'Account Code',
ACD1.Quantity AS 'Quantity',
ACD1.LineTotal AS 'Line Total',
ACD1.TotalFrgn AS 'Line Total (FC)',
ACD1.TotalSys AS 'Line Total (SC)',
ACD1.DprArea AS 'Depreciation Area',
ACD1.Remarks AS 'Remarks',
ACD1.LogInstanc AS 'Log Instance',
ACD1.NewItemCod AS 'New Item Code',
ACD1.Partial AS 'Partial',
ACD1.APC AS 'APC',
ACD1.NewAstCls AS 'New Asset Class',
ACD1.ObjType AS 'Object Type',
ACD1.TransType AS 'Transaction Type',
ACD1.OcrCode AS 'Distribution Rule',
ACD1.OcrCode2 AS 'Distribution Rule 2',
ACD1.OcrCode3 AS 'Distribution Rule 3',
ACD1.OcrCode4 AS 'Distribution Rule 4',
ACD1.OcrCode5 AS 'Distribution Rule 5',
ACD1.Project AS 'Project Code'
FROM ACD1 AS ACD1
Related information
G/L Accounts OACT SQL Table
Credit Memo OACD SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Items OITM SQL Table
Asset Classes OACS SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
