biuan SAP® BUSINESS ONE SDK
API AIQI
AIQI - Inventory Opening Balance Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11
PRIMARYYes
CreateDate KEYCreation DateDate
8
CREATEDATENo
DocTimeGeneration TimeInt
6
IOffIncAccInventory Offset Increase AcctnVarChar
15OACT
G/L Accounts
DOffDecAccInventory Offset Decrease AcctnVarChar
15OACT
G/L Accounts
DocDate KEYPosting DateDate
8
DOC_DATENo
ReferenceReferencenVarChar
11
CommentsRemarksnVarChar
127
DocDueDateDue DateDate
8
DataSourceData SourceVarChar
1
N
UserSignUser SignatureInt
6OUSR
Users
VersionNumVersion NumbernVarChar
11
JdtNumJournal NumberInt
11
Reference2Reference 2nVarChar
11
ObjTypeObject TypenVarChar
20
310000001
DocNumDocument NumberInt
11
SeriesSeriesInt
6NNM1
Documents Numbering - Series
PriceSrcPrice SourceVarChar
1) By Price List
2) Last Evaluated Price
3) Item Cost
1
3
PriceListPrice ListInt
11
JrnlMemoJournal RemarksnVarChar
50
TaxDateDocument DateDate
8
StatusStatusVarChar
O) Open
C) Close
1
O
LogInsLog Instance - HistoryInt
11
UserSign2Update User - HistoryInt
6OUSR
Users
UpdateDateDate of Update - HistoryDate
8
WddStatusAuthorization StatusVarChar
-) Without
W) Pending
Y) Approved
N) Rejected
P) Generated
A) Generated by Authorizer
C) Canceled
1
DraftKeyDraft Document Internal IDInt
11OIOD
Inventory Opening Balance Draft
-1
PrintedPrintedVarChar
1
N
DocTotalDocument TotalNum
20
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
UpdateTSUpdate Full TimeInt
11
PIndicatorPeriod IndicatornVarChar
10
' '
FinncPriodPosting PeriodInt
11

Table relationship map

SELECT statement

SELECT AIQI.DocEntry AS 'Document Internal ID', AIQI.CreateDate AS 'Creation Date', AIQI.DocTime AS 'Generation Time', AIQI.IOffIncAcc AS 'Inventory Offset Increase Acct', AIQI.DOffDecAcc AS 'Inventory Offset Decrease Acct', AIQI.DocDate AS 'Posting Date', AIQI.Reference AS 'Reference', AIQI.Comments AS 'Remarks', AIQI.DocDueDate AS 'Due Date', AIQI.DataSource AS 'Data Source', AIQI.UserSign AS 'User Signature', AIQI.VersionNum AS 'Version Number', AIQI.JdtNum AS 'Journal Number', AIQI.Reference2 AS 'Reference 2', AIQI.ObjType AS 'Object Type', AIQI.DocNum AS 'Document Number', AIQI.Series AS 'Series', AIQI.PriceSrc AS 'Price Source', AIQI.PriceList AS 'Price List', AIQI.JrnlMemo AS 'Journal Remarks', AIQI.TaxDate AS 'Document Date', AIQI.Status AS 'Status', AIQI.LogIns AS 'Log Instance - History', AIQI.UserSign2 AS 'Update User - History', AIQI.UpdateDate AS 'Date of Update - History', AIQI.WddStatus AS 'Authorization Status', AIQI.DraftKey AS 'Draft Document Internal ID', AIQI.Printed AS 'Printed', AIQI.DocTotal AS 'Document Total', AIQI.BPLId AS 'Branch', AIQI.BPLName AS 'Branch Name', AIQI.UpdateTS AS 'Update Full Time', AIQI.PIndicator AS 'Period Indicator', AIQI.FinncPriod AS 'Posting Period' FROM AIQI AS AIQI

Related information


Business Place OBPL SQL Table

G/L Accounts OACT SQL Table

Inventory Opening Balance Draft OIOD SQL Table

Documents Numbering - Series NNM1 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