biuan SAP® BUSINESS ONE SDK
API ADPA
ADPA - Fixed Asset Depreciation Areas - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
15
PRIMARYYes
DescrDescriptionnVarChar
100
DirectDprDirect DepreciationVarChar
D) Direct Posting
I) Indirect Posting
1
D
RetMethRetirement MethodVarChar
G) Gross
N) Net
1
G
AreaTypeArea TypeVarChar
L) Posting to G/L
O) Additional Area
D) Derived Area
1
O
DrvdAreaDerived AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
DataSourceData SourceVarChar
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6
UpdateDateDate of UpdateDate
8
MainAreaMain Booking AreaVarChar
Y) Yes
N) No
1
N
CreditCtrlTax Credit ControlVarChar
Y) Yes
N) No
1
N
TaxTypeTax TypeInt
11OSTT
Sales Tax Authorities Type
DirRevPostDirect Revenue PostingVarChar
Y) Yes
N) No
1
N
SnapshotIdSnapshot IDInt
11
0
BpTaxCorrBP for Tax CorrectionnVarChar
15OCRD
Business Partner
ItmTaxCorrItem for Tax CorrectionnVarChar
20OITM
Items
UsgTaxCorrUsage for Tax CorrectionInt
11OUSG
Usage of Nota Fiscal

Table relationship map

SELECT statement

SELECT ADPA.Code AS 'Code', ADPA.Descr AS 'Description', ADPA.DirectDpr AS 'Direct Depreciation', ADPA.RetMeth AS 'Retirement Method', ADPA.AreaType AS 'Area Type', ADPA.DrvdArea AS 'Derived Area', ADPA.DataSource AS 'Data Source', ADPA.UserSign AS 'User Signature', ADPA.LogInstanc AS 'Log Instance', ADPA.CreateDate AS 'Creation Date', ADPA.UserSign2 AS 'Updating User', ADPA.UpdateDate AS 'Date of Update', ADPA.MainArea AS 'Main Booking Area', ADPA.CreditCtrl AS 'Tax Credit Control', ADPA.TaxType AS 'Tax Type', ADPA.DirRevPost AS 'Direct Revenue Posting', ADPA.SnapshotId AS 'Snapshot ID', ADPA.BpTaxCorr AS 'BP for Tax Correction', ADPA.ItmTaxCorr AS 'Item for Tax Correction', ADPA.UsgTaxCorr AS 'Usage for Tax Correction' FROM ADPA AS ADPA

Related information


Business Partner OCRD SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Items OITM SQL Table

Sales Tax Authorities Type OSTT SQL Table

Users OUSR SQL Table

Usage of Nota Fiscal OUSG 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