|
|
DTW Financials / Fixed Assets / Capitalization / Capitalization
API Asset Document Service / Asset Document
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocNum KEY UNIQUE | Document Number | Int | 11 | INDEX | Yes | |||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| PeriodCat | Period Category | nVarChar | 10 | |||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| PostDate | Posting Date | Date | 8 | |||||
| DocDate | Document Date | Date | 8 | |||||
| DocStatus | Document Status | VarChar | P) Posted D) Draft C) Canceled | 1 | P | |||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| Comments | Remarks | nVarChar | 127 | |||||
| Reference | Reference | nVarChar | 32 | |||||
| ObjType | Object Type | nVarChar | 20 | |||||
| Currency | Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| DocRate | Document Rate | Num | 20 | |||||
| SysRate | System Rate | Num | 20 | |||||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ||||
| DocTotal | Document Total | Num | 20 | |||||
| DocTotalFC | Document Total (FC) | Num | 20 | |||||
| DocTotalSy | Document Total (SC) | Num | 20 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Create Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| TransType KEY | Original Document | nVarChar | 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 | -1 | TRANS_TYPE | No | |
| CreatedBy | Original | Int | 11 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| AssetDate | Asset Value Date | Date | 8 | |||||
| CurSource | Base Currency | VarChar | L) Local Currency S) System Currency F) Foreign Currency | 1 | L | |||
| DocType | Document Type | nVarChar | PL) Ordinary Depreciation UP) Unplanned Depreciation SD) Special Depreciation AP) Appreciation TR) Asset Transfer NC) Sales SC) Scrapping TC) Asset Class Transfer | 15 | PL | |||
| PrjSmarz | Summarize by Project | VarChar | Y) Yes N) No | 1 | N | |||
| DstRlSmarz | Summarize by Distribution Rule | VarChar | Y) Yes N) No | 1 | N | |||
| ManDprType | Manual Depreciation Type | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| Handwrtten | Manual Numbering | VarChar | Y) Yes N) No | 1 | N | |||
| CancelDate | Cancelation Date | Date | 8 | |||||
| DprArea | Depreciation Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BaseRef | Base Reference | nVarChar | 11 | |||||
| LVARetire | Low Value Asset Retirement | VarChar | Y) Yes N) No | 1 | N | |||
| CancelOpt | Cancelation Option | Int | 6 | 1 | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VatRegNum | VAT Reg. Number | nVarChar | 32 | |||||
| GdsMovType | Goods Movement Type | nVarChar | 2 |
Table relationship map
SELECT statement
SELECT
OACQ.DocEntry AS 'Internal Number',
OACQ.DocNum AS 'Document Number',
OACQ.Series AS 'Series',
OACQ.PeriodCat AS 'Period Category',
OACQ.FinncPriod AS 'Posting Period',
OACQ.PostDate AS 'Posting Date',
OACQ.DocDate AS 'Document Date',
OACQ.DocStatus AS 'Document Status',
OACQ.TransId AS 'Transaction Number',
OACQ.Comments AS 'Remarks',
OACQ.Reference AS 'Reference',
OACQ.ObjType AS 'Object Type',
OACQ.Currency AS 'Currency',
OACQ.DocRate AS 'Document Rate',
OACQ.SysRate AS 'System Rate',
OACQ.PIndicator AS 'Period Indicator',
OACQ.DocTotal AS 'Document Total',
OACQ.DocTotalFC AS 'Document Total (FC)',
OACQ.DocTotalSy AS 'Document Total (SC)',
OACQ.DataSource AS 'Data Source',
OACQ.UserSign AS 'User Signature',
OACQ.LogInstanc AS 'Log Instance',
OACQ.CreateDate AS 'Create Date',
OACQ.UserSign2 AS 'Updating User',
OACQ.UpdateDate AS 'Date of Update',
OACQ.TransType AS 'Original Document',
OACQ.CreatedBy AS 'Original',
OACQ.JrnlMemo AS 'Journal Remarks',
OACQ.AssetDate AS 'Asset Value Date',
OACQ.CurSource AS 'Base Currency',
OACQ.DocType AS 'Document Type',
OACQ.PrjSmarz AS 'Summarize by Project',
OACQ.DstRlSmarz AS 'Summarize by Distribution Rule',
OACQ.ManDprType AS 'Manual Depreciation Type',
OACQ.Handwrtten AS 'Manual Numbering',
OACQ.CancelDate AS 'Cancelation Date',
OACQ.DprArea AS 'Depreciation Area',
OACQ.BPLId AS 'Branch',
OACQ.BaseRef AS 'Base Reference',
OACQ.LVARetire AS 'Low Value Asset Retirement',
OACQ.CancelOpt AS 'Cancelation Option',
OACQ.BPLName AS 'Branch Name',
OACQ.VatRegNum AS 'VAT Reg. Number',
OACQ.GdsMovType AS 'Goods Movement Type'
FROM OACQ AS OACQ
Related information
Asset Document AssetDocument Object· Table: OACQ
AssetDocument is a business object that represents the header data of asset documents in the Fixed Asset function of SAP Business One application.
With SAP Business One, you can carry out a series of transactions for your fixed assets as...
Parent: Asset Document Service AssetDocumentService Service· Table: OACQ Asset Document Service AssetDocumentService Service· Table: OACQ
The AssetDocumentService service enables you to add, look up, update, cancel, and remove asset documents.
Source table: OACQ.
OACQ 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
AssetDocumentService
Object
AssetDocument
Collection
Enumeration
Method
Property
AssetValueDate
DTW DB
BaseReference
DTW DB
BPLID
DTW DB
BPLName
DTW DB
CancellationDate
DTW DB
CancellationOption
DTW DB
DepreciationArea
DTW DB
DocEntry
DTW DB
DocNum
DTW DB
DocumentDate
DTW DB
DocumentRate
DTW DB
DocumentTotal
DTW DB
DocumentType
DTW DB
HandWritten
DTW DB
LowValueAssetRetirement
DTW DB
ManualDepreciationType
DTW DB
Origin
DTW DB
OriginalType
DTW DB
PostingDate
DTW DB
Reference
DTW DB
Remarks
DTW DB
Series
DTW DB
Status
DTW DB
SummerizeByDistributionRules
DTW DB
SummerizeByProjects
DTW DB
VATRegNum
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates