biuan SAP® BUSINESS ONE SDK
API RTI1
RTI1 - Retirement - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11ORTI
Retirement
PRIMARYYes
LineNumRow NumberInt
11
ItemCodeItem CodenVarChar
20OITM
Items
AcctCodeAccount CodenVarChar
15OACT
G/L Accounts
QuantityQuantityNum
20
LineTotalLine TotalNum
20
TotalFrgnLine Total (FC)Num
20
TotalSysLine Total (SC)Num
20
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
RemarksRemarksnVarChar
100
LogInstancLog InstanceInt
11
0
NewItemCodNew Item CodenVarChar
20OITM
Items
PartialPartialVarChar
Y) Yes
N) No
1
N
APCAPCNum
20
NewAstClsNew Asset ClassnVarChar
20OACS
Asset Classes
ObjTypeObject TypenVarChar
20
TransTypeTransaction TypenVarChar
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
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Distribution Rule 2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule 3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule 4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule 5nVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes

Table relationship map

SELECT statement

SELECT RTI1.DocEntry AS 'Document Internal ID', RTI1.LineNum AS 'Row Number', RTI1.ItemCode AS 'Item Code', RTI1.AcctCode AS 'Account Code', RTI1.Quantity AS 'Quantity', RTI1.LineTotal AS 'Line Total', RTI1.TotalFrgn AS 'Line Total (FC)', RTI1.TotalSys AS 'Line Total (SC)', RTI1.DprArea AS 'Depreciation Area', RTI1.Remarks AS 'Remarks', RTI1.LogInstanc AS 'Log Instance', RTI1.NewItemCod AS 'New Item Code', RTI1.Partial AS 'Partial', RTI1.APC AS 'APC', RTI1.NewAstCls AS 'New Asset Class', RTI1.ObjType AS 'Object Type', RTI1.TransType AS 'Transaction Type', RTI1.OcrCode AS 'Distribution Rule', RTI1.OcrCode2 AS 'Distribution Rule 2', RTI1.OcrCode3 AS 'Distribution Rule 3', RTI1.OcrCode4 AS 'Distribution Rule 4', RTI1.OcrCode5 AS 'Distribution Rule 5', RTI1.Project AS 'Project Code' FROM RTI1 AS RTI1

Related information


G/L Accounts OACT SQL Table

Retirement ORTI 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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates