biuan SAP® BUSINESS ONE SDK
API ORTI
ORTI - Retirement Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
INDEXYes
SeriesSeriesInt
6NNM1
Documents Numbering - Series
PeriodCatPeriod CategorynVarChar
10
FinncPriodPosting PeriodInt
11OFPR
Posting Period
PostDatePosting DateDate
8
DocDateDocument DateDate
8
DocStatusDocument StatusVarChar
P) Posted
D) Draft
C) Canceled
1
P
TransIdTransaction NumberInt
11OJDT
Journal Entry
CommentsRemarksnVarChar
127
ReferenceReferencenVarChar
32
ObjTypeObject TypenVarChar
20
CurrencyCurrencynVarChar
3OCRN
Currency Codes
DocRateDocument RateNum
20
SysRateSystem RateNum
20
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
DocTotalDocument TotalNum
20
DocTotalFCDocument Total (FC)Num
20
DocTotalSyDocument Total (SC)Num
20
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
TransType KEYOriginal DocumentnVarChar
13) A/R Invoice
19) A/P Credit Memo
18) A/P Invoice
46) Outgoing Payment
163) A/P Correction Invoice
1470000049) Capitalization
1470000060) Fixed Assets Credit Memo
-1) All Transactions
1470000075) Manual Depreciation
1470000090) Fixed Assets Transfer
1470000094) Retirement
20
-1TRANS_TYPENo
CreatedByOriginalInt
11
JrnlMemoJournal RemarksnVarChar
50
AssetDateAsset Value DateDate
8
CurSourceBase CurrencyVarChar
L) Local Currency
S) System Currency
F) Foreign Currency
1
L
DocTypeDocument TypenVarChar
PL) Ordinary Depreciation
UP) Unplanned Depreciation
SD) Special Depreciation
AP) Appreciation
TR) Asset Transfer
NC) Sales
SC) Scrapping
TC) Asset Class Transfer
15
PL
PrjSmarzSummarize by ProjectVarChar
Y) Yes
N) No
1
Y
DstRlSmarzSummarize by Distribution RuleVarChar
Y) Yes
N) No
1
Y
ManDprTypeManual Depreciation TypenVarChar
15ODTP
Fixed Assets Depreciation Types
HandwrttenManual NumberingVarChar
Y) Yes
N) No
1
N
CancelDateCancelation DateDate
8
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
BPLIdBranchInt
11OBPL
Business Place
BaseRefBase ReferencenVarChar
11
LVARetireLow Value Asset RetirementVarChar
Y) Yes
N) No
1
N
CancelOptCancelation OptionInt
6
1
BPLNameBranch NamenVarChar
100
VatRegNumVAT Reg. NumbernVarChar
32
GdsMovTypeGoods Movement TypenVarChar
2

Table relationship map

SELECT statement

SELECT ORTI.DocEntry AS 'Internal Number', ORTI.DocNum AS 'Document Number', ORTI.Series AS 'Series', ORTI.PeriodCat AS 'Period Category', ORTI.FinncPriod AS 'Posting Period', ORTI.PostDate AS 'Posting Date', ORTI.DocDate AS 'Document Date', ORTI.DocStatus AS 'Document Status', ORTI.TransId AS 'Transaction Number', ORTI.Comments AS 'Remarks', ORTI.Reference AS 'Reference', ORTI.ObjType AS 'Object Type', ORTI.Currency AS 'Currency', ORTI.DocRate AS 'Document Rate', ORTI.SysRate AS 'System Rate', ORTI.PIndicator AS 'Period Indicator', ORTI.DocTotal AS 'Document Total', ORTI.DocTotalFC AS 'Document Total (FC)', ORTI.DocTotalSy AS 'Document Total (SC)', ORTI.DataSource AS 'Data Source', ORTI.UserSign AS 'User Signature', ORTI.LogInstanc AS 'Log Instance', ORTI.CreateDate AS 'Create Date', ORTI.UserSign2 AS 'Updating User', ORTI.UpdateDate AS 'Date of Update', ORTI.TransType AS 'Original Document', ORTI.CreatedBy AS 'Original', ORTI.JrnlMemo AS 'Journal Remarks', ORTI.AssetDate AS 'Asset Value Date', ORTI.CurSource AS 'Base Currency', ORTI.DocType AS 'Document Type', ORTI.PrjSmarz AS 'Summarize by Project', ORTI.DstRlSmarz AS 'Summarize by Distribution Rule', ORTI.ManDprType AS 'Manual Depreciation Type', ORTI.Handwrtten AS 'Manual Numbering', ORTI.CancelDate AS 'Cancelation Date', ORTI.DprArea AS 'Depreciation Area', ORTI.BPLId AS 'Branch', ORTI.BaseRef AS 'Base Reference', ORTI.LVARetire AS 'Low Value Asset Retirement', ORTI.CancelOpt AS 'Cancelation Option', ORTI.BPLName AS 'Branch Name', ORTI.VatRegNum AS 'VAT Reg. Number', ORTI.GdsMovType AS 'Goods Movement Type' FROM ORTI AS ORTI

Related information


ORTI SQL Table

Business Place OBPL SQL Table

Currency Codes OCRN SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Posting Period OFPR SQL Table

Fixed Assets Depreciation Types ODTP SQL Table

Period Indicator OPID SQL Table

Documents Numbering - Series NNM1 SQL Table

Journal Entry OJDT SQL Table

Users OUSR 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