📚 SAP Business One SDK Help

Table Name: OACQ

Table Description: Capitalization

Field Description Type Size Related Default Value Constraints
DocEntry Internal Number Int 11 -      
DocNum Document Number Int 11 -      
Series Series Int 11 NNM1      
PeriodCat Period Category nVarChar 10 -      
FinncPriod Posting Period Int 11 OFPR      
PostDate Posting Date Date 8 -      
DocDate Document Date Date 8 -      
DocStatus Document Status VarChar 1 - P P Posted
            D Draft
            C Canceled
TransId Transaction Number Int 11 OJDT      
Comments Remarks nVarChar 254 -      
Reference Reference nVarChar 32 -      
ObjType Object Type nVarChar 20 -      
Currency Currency nVarChar 3 OCRN      
DocRate Document Rate Num 19.6 -      
SysRate System Rate Num 19.6 -      
PIndicator Period Indicator nVarChar 10 OPID      
DocTotal Document Total Num 19.6 -      
DocTotalFC Document Total (FC) Num 19.6 -      
DocTotalSy Document Total (SC) Num 19.6 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
LogInstanc Log Instance Int 11 - 0    
CreateDate Create Date Date 8 -      
UserSign2 Updating User Int 6 OUSR      
UpdateDate Date of Update Date 8 -      
TransType Original Document nVarChar 20 - -1 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
CreatedBy Original Int 11 -      
JrnlMemo Journal Remarks nVarChar 254 -      
AssetDate Asset Value Date Date 8 -      
CurSource Base Currency VarChar 1 - L L Local Currency
            S System Currency
            F Foreign Currency
DocType Document Type nVarChar 15 - PL PL Ordinary Depreciation
            UP Unplanned Depreciation
            SD Special Depreciation
            AP Appreciation
            TR Asset Transfer
            NC Sales
            SC Scrapping
            TC Asset Class Transfer
PrjSmarz Summarize by Project VarChar 1 - N Y Yes
            N No
DstRlSmarz Summarize by Distribution Rule VarChar 1 - N Y Yes
            N No
ManDprType Manual Depreciation Type nVarChar 15 ODTP      
Handwrtten Manual Numbering VarChar 1 - N Y Yes
            N No
CancelDate Cancelation Date Date 8 -      
DprArea Depreciation Area nVarChar 15 ODPA      
BPLId Branch Int 11 OBPL      
BaseRef Base Reference nVarChar 11 -      
LVARetire Low Value Asset Retirement VarChar 1 - N Y Yes
            N No
CancelOpt Cancelation Option Int 6 - 1    
BPLName Branch Name nVarChar 200 -      
VatRegNum VAT Reg. Number nVarChar 32 -      
GdsMovType Goods Movement Type nVarChar 2 -      
            SI Opening Balance of Fixed Assets
            IM Initialization of Fixed Assets
            IP FA Use in Progress
            CI End of Fixed Assets Use
            MC Immobilization from Current Assets
PTICode POI Code nVarChar 5 OPTI      
Letter Letter VarChar 1 -      
FolNumFrom Folio Number From Int 11 -      
FolNumTo Folio Number To Int 11 -      
FolSeries Folio Series Int 11 OFNS      
VersionNum Version Number nVarChar 13 -      
Key Unique Field
PRIMARY Yes DocEntry
INDEX Yes DocNum
    PIndicator
TRANS_TYPE No TransType
    CreatedBy