Serial Numbers and Batch Valuation Log

Table Name: OBVL

Table Description: Serial Numbers and Batch Valuation Log

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal Number	Int	11	-
DocEntry	Doc Abs. Entry	Int	11	-
DocLineNum	Doc Line Number	Int	11	-
DocType	Transact. Type	Int	11	-	-1
BaseType	Base Document Type	Int	11	-	-1	-1
						0
						13	A/R Invoice
						15	Delivery
						16	Returns
						17	Sales Order
						18	A/P Invoice
						20	Goods Receipt PO
						21	Goods Return
						22	Purchase Order
						23	Sales Quotation
						59	Goods Receipt
						67	Inventory Transfer
						69	Landed Costs
						163	A/P Correction Invoice
						164	A/P Correction Invoice Reversal
						165	A/R Correction Invoice
						166	A/R Correction Invoice Reversal
						202	Production Order
						203	A/R Down Payment
						204	A/P Down Payment
ActionType	Action Type	Int	11	-	5	0	TRANSACTION_UNKNOWN
						1	TRANSACTION_IN
						2	TRANSACTION_OUT
						3	TRANSACTION_SET
						4	TRANSACTION_COMPLETE
						5	EMPTY_TRANSACTION
						6	TRANSACTION_REVALUATION
						7	TRANSACTION_REVALUATION_INCREASE
						8	TRANSACTION_REVALUATION_DECREASE
						9	TRANSACTION_CLOSE_IN
						10	TRANSACTION_CLOSE_OUT
						11	TRANSACTION_NEGATIVE_REVALUATION
						12	TRANSACTION_NULLIFY
						13	TRANSACTION_RESERVE_CI_IN
						14	TRANSACTION_RESERVE_CI_OUT
						15	TRANSACTION_RESERVE_CI_REVAL_INC
						16	TRANSACTION_RESERVE_CI_REVAL_DEC
						17	TRANSACTION_REVAL_PRICE_CHANGE_INCREASE
						18	TRANSACTION_REVAL_PRICE_CHANGE_DECREASE
AccumType	Accumulator Type	Int	11	-	0	0	ACCUM_EMPTY
						1	ACCUM_ON_HAND
						2	ACCUM_COMMITTED
						3	ACCUM_ON_ORDER
						4	ACCUM_CONSIGNATION
						5	ACCUM_COUNTED
ManagedBy	Managed By	Int	11	-	-1	10000044	Batch Numbers
						10000045	Serial Numbers
						-1
CreateDate	Generation Date	Date	8	-
CreateTime	Generation Time	Int	6	-
ItemCode	Item No.	nVarChar	50	-
SysNumber	System Number	Int	11	-
DistNumber	Batch Number	nVarChar	36	-
MdAbsEntry	MD Abs. Entry	Int	11	-
TrValApply	Apply Transaction Value	VarChar	1	-	Y	Y	Yes
						N	No
TransValue	Transaction Value	Num	19.6	-
InvValue	Inventory Value	Num	19.6	-
CogsValue	Cogs Value	Num	19.6	-
Quantity	Quantity	Num	19.6	-
OverlapQty	Overlap Quantity	Num	19.6	-
CogsQty	Cogs Quantity	Num	19.6	-
CalcPrice	Calculated Price	Num	19.6	-
PriceDiff	Price Difference	Num	19.6	-
InvDiff	Inventory Difference	Num	19.6	-
Balance	Batch Balance	Num	19.6	-
AccTotal	Total Accumulator	Num	19.6	-
AccQty	Quantity-In Accumulator	Num	19.6	-
AccNegQ	Quantity-Out Accumulator	Num	19.6	-
ILMEntry	ILM Entry	Int	11	-
ITLEntry	ITL Entry	Int	11	-
CostQty	Cost Quantity	Num	19.6	-
Cost	Cost	Num	19.6	-
BaseDocEn	Base Doc. Abs. Entry	Int	11	-
BaseLnNum	Base Doc. Line Number	Int	11	-
DeltaAccT	Delta Total Accumulator	Num	19.6	-
RowAction	Row Action Type	Int	11	-		0	TRANSACTION_UNKNOWN
						1	TRANSACTION_IN
						2	TRANSACTION_OUT
						3	TRANSACTION_SET
						4	TRANSACTION_COMPLETE
						5	EMPTY_TRANSACTION
						6	TRANSACTION_REVALUATION
						7	TRANSACTION_REVALUATION_INCREASE
						8	TRANSACTION_REVALUATION_DECREASE
						9	TRANSACTION_CLOSE_IN
						10	TRANSACTION_CLOSE_OUT
						11	TRANSACTION_NEGATIVE_REVALUATION
						12	TRANSACTION_NULLIFY
						13	TRANSACTION_RESERVE_CI_IN
						14	TRANSACTION_RESERVE_CI_OUT
						15	TRANSACTION_RESERVE_CI_REVAL_INC
						16	TRANSACTION_RESERVE_CI_REVAL_DEC
						17	TRANSACTION_REVAL_PRICE_CHANGE_INCREASE
						18	TRANSACTION_REVAL_PRICE_CHANGE_DECREASE

Key	Unique	Field
PRIMARY	Yes	AbsEntry
ILM_ENT	No	ILMEntry