biuan SAP® BUSINESS ONE SDK
API UIVL
UIVL - Whse Journal Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TransTypeTransaction TypeInt
15) Delivery
16) Returns
13) A/R Invoice
14) A/R Credit Memo
132) Correction Invoice
(-0) (-
20) Goods Receipt
21) Goods Return
18) A/P Invoice
19) A/P Credit Memo
(-1) (-
-2) Opening Balance
58) Inventory Update
59) Goods Receipt
60) Goods Issue
67) Inventory Transfer
68) Work Instructions
(-2) (-
-1) All Transactions
162) Inventory Revaluation
69) Landed Costs
11
-1
CreatedBy KEYDocument No. CreatedInt
11
DOCENTRYNo
BASE_REFBase ReferencenVarChar
11
DocLineNumRow Number in DocumentInt
11
DocDate KEYPosting DateDate
8
DOCDATENo
CreateTimeGeneration TimeInt
6
ItemCode KEYItem No.nVarChar
20UITM
Items
ITEMNo
InQtyReceipt QuantityNum
20
OutQtyIssue QuantityNum
20
PricePriceNum
20
Currency KEYPrice CurrencynVarChar
3
CURRENCYNo
RateCurrency PriceNum
20
TrnsfrActTransfer AccountnVarChar
15OACT
G/L Accounts
PriceDifAcPrice Difference AccountnVarChar
15OACT
G/L Accounts
VarianceAcVariance AccountnVarChar
15OACT
G/L Accounts
ReturnActReturning AccountnVarChar
15OACT
G/L Accounts
ExcRateActExchange Rate Differences AcctnVarChar
15OACT
G/L Accounts
ClearActGoods Clearing AccountnVarChar
15OACT
G/L Accounts
CostActCOGS AccountnVarChar
15OACT
G/L Accounts
WipActWIP Inventory AccountnVarChar
15OACT
G/L Accounts
OpenStockOpen Sum Inventory ValueNum
20
CreateDateCreation DateDate
8
PriceDiffPrice Difference ValueNum
20
TransSeq KEY UNIQUETransaction Sequence No.Int
11
0PRIMARYYes
InvntActInventory AccountnVarChar
15OACT
G/L Accounts
SubLineNumSubrow NumberInt
11
-1
AppObjLineApplied Object RowInt
11
-1
ExpensesInventory ExpensesNum
20
OpenExpOpen Expenses ValueNum
20
AllocationAllocation AmountNum
20
OpenAllocOpen Allocation ValueNum
20
ExpAllocExpenses Allocation ValueNum
20
OExpAllocOpen Expenses Allocation ValueNum
20
OpenPDiffOpen Price Diff. ValueNum
20
ExchDiffExchange Rate Difference ValueNum
20
OpenEDiffOpen Exchange Rate Diff. ValueNum
20
NegInvAdjsNegative Inventory Adjustment ValueNum
20
OpenNegInvOpen Negative AdjustmentNum
20
NegStckActNeg. Inventory Adjustment AcctnVarChar
15OACT
G/L Accounts
BTransValBase Transaction ValueNum
20
VarValVariance ValueNum
20
BExpValBase Freight ValueNum
20
CogsValCOGS ValueNum
20
BNegAValBase Negative Adjustment AmtNum
20
IOffIncAccInventory Offset Increase AcctnVarChar
15OACT
G/L Accounts
IOffIncValInv. Offset Increase ValueNum
20
DOffDecAccInventory Offset Decrease AcctnVarChar
15OACT
G/L Accounts
DOffDecValInv. Offset Decrease ValueNum
20
DecAccG/L Decrease AccountnVarChar
15OACT
G/L Accounts
DecValG/L Decrease ValueNum
20
WipValWIP Inventory ValueNum
20
WipVarAccWIP Variance AccountnVarChar
15OACT
G/L Accounts
WipVarValWIP Variance ValueNum
20
IncActG/L Increase AccountnVarChar
15
IncValG/L Increase ValueNum
20
ExpCAccExpense Clearing AccountnVarChar
15OACT
G/L Accounts
CostMethodCosting MethodVarChar
A) Moving Average
S) Standard
F) FIFO
N) None
1
N
MessageID KEYMessage IDInt
11UILM
IVI Inventory Log Message
MESSAGEIDNo
LocTypeLocation TypeInt
11
LocCodeWarehouse CodenVarChar
8
UserSignUser SignatureInt
6OUSR
Users
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Summary
D) Restore Wizard
P) Partner Implementation
Y) Year Transfer
1
N
PostStatusPosting StatusVarChar
N) None
P) Partial
C) Complete
1
N
SumStockSum Inventory ValueNum
20
OpenCogsOpen COGS ValueNum
20
OpenQtyOpen QuantityNum
20
TreeID KEYTree IDInt
11
-1TREEIDNo
ParentIDParent IDInt
11
-1
PAOffAccPurchase Offset AccountnVarChar
15OACT
G/L Accounts
PAOffValPurchase Offset ValueNum
20
OpenPAOffOpen Purchase Offset ValueNum
20
PAAccPurchase AccountnVarChar
15OACT
G/L Accounts
PAValPurchase Account ValueNum
20
OpenPAOpen Purchase ValueNum
20
LinkArcLinked To Archived DocVarChar
N) No
Y) Yes
1
N
VersionNumVersion NumbernVarChar
11
BSubLineNoBase Subrow NumberInt
11
-1
WipDebCredWIP Account: Debit/Credit SideVarChar
1

Table relationship map

SELECT statement

SELECT UIVL.TransType AS 'Transaction Type', UIVL.CreatedBy AS 'Document No. Created', UIVL.BASE_REF AS 'Base Reference', UIVL.DocLineNum AS 'Row Number in Document', UIVL.DocDate AS 'Posting Date', UIVL.CreateTime AS 'Generation Time', UIVL.ItemCode AS 'Item No.', UIVL.InQty AS 'Receipt Quantity', UIVL.OutQty AS 'Issue Quantity', UIVL.Price AS 'Price', UIVL.Currency AS 'Price Currency', UIVL.Rate AS 'Currency Price', UIVL.TrnsfrAct AS 'Transfer Account', UIVL.PriceDifAc AS 'Price Difference Account', UIVL.VarianceAc AS 'Variance Account', UIVL.ReturnAct AS 'Returning Account', UIVL.ExcRateAct AS 'Exchange Rate Differences Acct', UIVL.ClearAct AS 'Goods Clearing Account', UIVL.CostAct AS 'COGS Account', UIVL.WipAct AS 'WIP Inventory Account', UIVL.OpenStock AS 'Open Sum Inventory Value', UIVL.CreateDate AS 'Creation Date', UIVL.PriceDiff AS 'Price Difference Value', UIVL.TransSeq AS 'Transaction Sequence No.', UIVL.InvntAct AS 'Inventory Account', UIVL.SubLineNum AS 'Subrow Number', UIVL.AppObjLine AS 'Applied Object Row', UIVL.Expenses AS 'Inventory Expenses', UIVL.OpenExp AS 'Open Expenses Value', UIVL.Allocation AS 'Allocation Amount', UIVL.OpenAlloc AS 'Open Allocation Value', UIVL.ExpAlloc AS 'Expenses Allocation Value', UIVL.OExpAlloc AS 'Open Expenses Allocation Value', UIVL.OpenPDiff AS 'Open Price Diff. Value', UIVL.ExchDiff AS 'Exchange Rate Difference Value', UIVL.OpenEDiff AS 'Open Exchange Rate Diff. Value', UIVL.NegInvAdjs AS 'Negative Inventory Adjustment Value', UIVL.OpenNegInv AS 'Open Negative Adjustment', UIVL.NegStckAct AS 'Neg. Inventory Adjustment Acct', UIVL.BTransVal AS 'Base Transaction Value', UIVL.VarVal AS 'Variance Value', UIVL.BExpVal AS 'Base Freight Value', UIVL.CogsVal AS 'COGS Value', UIVL.BNegAVal AS 'Base Negative Adjustment Amt', UIVL.IOffIncAcc AS 'Inventory Offset Increase Acct', UIVL.IOffIncVal AS 'Inv. Offset Increase Value', UIVL.DOffDecAcc AS 'Inventory Offset Decrease Acct', UIVL.DOffDecVal AS 'Inv. Offset Decrease Value', UIVL.DecAcc AS 'G/L Decrease Account', UIVL.DecVal AS 'G/L Decrease Value', UIVL.WipVal AS 'WIP Inventory Value', UIVL.WipVarAcc AS 'WIP Variance Account', UIVL.WipVarVal AS 'WIP Variance Value', UIVL.IncAct AS 'G/L Increase Account', UIVL.IncVal AS 'G/L Increase Value', UIVL.ExpCAcc AS 'Expense Clearing Account', UIVL.CostMethod AS 'Costing Method', UIVL.MessageID AS 'Message ID', UIVL.LocType AS 'Location Type', UIVL.LocCode AS 'Warehouse Code', UIVL.UserSign AS 'User Signature', UIVL.DataSource AS 'Data Source', UIVL.PostStatus AS 'Posting Status', UIVL.SumStock AS 'Sum Inventory Value', UIVL.OpenCogs AS 'Open COGS Value', UIVL.OpenQty AS 'Open Quantity', UIVL.TreeID AS 'Tree ID', UIVL.ParentID AS 'Parent ID', UIVL.PAOffAcc AS 'Purchase Offset Account', UIVL.PAOffVal AS 'Purchase Offset Value', UIVL.OpenPAOff AS 'Open Purchase Offset Value', UIVL.PAAcc AS 'Purchase Account', UIVL.PAVal AS 'Purchase Account Value', UIVL.OpenPA AS 'Open Purchase Value', UIVL.LinkArc AS 'Linked To Archived Doc', UIVL.VersionNum AS 'Version Number', UIVL.BSubLineNo AS 'Base Subrow Number', UIVL.WipDebCred AS 'WIP Account: Debit/Credit Side' FROM UIVL AS UIVL

Related information


UIVL SQL Table

G/L Accounts OACT SQL Table

Items UITM SQL Table

IVI Inventory Log Message UILM 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates