Inventory Log Message - SAP B1 SDK Help

Table Name: OILM

Table Description: Inventory Log Message

Field	Description	Type	Size	Related	Default Value	Constraints
MessageID	Message ID	Int	11	-
DocEntry	Doc Abs Entry	Int	11	-
TransType	Transaction Type	Int	11	-	-1
DocLineNum	Doc Line Number	Int	11	-
Quantity	Quantity in Doc	Num	19.6	-
EffectQty	Stock Effect Qty	Num	19.6	-
LocType	Location Type	Int	6	-
LocCode	Location Code	nVarChar	8	-
TotalLC	Inventory Total LC	Num	19.6	-
TotalFC	Inventory Total FC	Num	19.6	-
TotalSC	Inventory Total SC	Num	19.6	-
BaseAbsEnt	Abs Entry of Base Doc	Int	11	-
BaseType	Base Transaction 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
BaseCurr	Base Currency	nVarChar	3	-
Currency	Doc Currency	nVarChar	3	OCRN
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
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
						19	TRANSACTION_BIN_TRANSFER_IN
						20	TRANSACTION_BIN_TRANSFER_OUT
ExpensesLC	Expenses (LC)	Num	19.6	-
ExpensesFC	Expenses (FC)	Num	19.6	-
ExpensesSC	Expenses (SC)	Num	19.6	-
DocDueDate	Doc. Due Date	Date	8	-
ItemCode	Item Code	nVarChar	50	OITM
BPCardCode	Business Partner Code	nVarChar	15	OCRD
DocDate	Doc Date	Date	8	-
DocRate	Doc. Rate	Num	19.6	-
Comment	Comment	nVarChar	254	-
JrnlMemo	Journal Remarks	nVarChar	50	-
Ref1	Reference 1	nVarChar	11	-
Ref2	Reference 2	nVarChar	100	-
BaseLine	Base Line Number	Int	11	-	-1
SnBType	Serials and Batches Type	Int	11	-	-1	4	Item
						10000044	Batch Numbers Management
						10000045	Serial Numbers Management
CreateTime	Generation Time	Int	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
CreateDate	Creation Date	Date	8	-
OcrCode	Distribution Rule	nVarChar	8	OOCR
OcrCode2	Distribution Rule2	nVarChar	8	OOCR
OcrCode3	Distribution Rule3	nVarChar	8	OOCR
OcrCode4	Distribution Rule4	nVarChar	8	OOCR
OcrCode5	Distribution Rule5	nVarChar	8	OOCR
DocPrice	Doc Price	Num	19.6	-
CardName	BP Name	nVarChar	200	-
Dscription	Item Description	nVarChar	200	-
TreeType	BOM Type	VarChar	1	-	N	N	Not a BOM
						A	Assembly
						S	Sales
						I	BOM Component Item
						P	Production
						T	Template
ApplObj	Applied Object	Int	11	-	-1
AppObjAbs	Applied Object Abs Entry	Int	11	-	-1
AppObjType	Applied Object Type	VarChar	1	-
AppObjLine	Applied Object Line	Int	11	-	-1
BASE_REF	Base Reference	nVarChar	11	-
TransSeqRf	Transaction Sequence Ref	Int	11	-	-1
LayerIDRef	Layer ID Reference	Int	11	-	-1
VersionNum	Version Number	nVarChar	13	-
PriceRate	Price Rate	Num	19.6	-
PriceCurr	Price Currency	nVarChar	3	OCRN
DocTotal	Document Total	Num	19.6	-
Price	Price	Num	19.6	-
CIShbQty	Corr. Inv. Doc. Should Be Qty	Num	19.6	-
SubLineNum	Sub Line Number	Int	11	-	-1
PrjCode	Project code	nVarChar	20	OPRJ
SlpCode	Sales Employee	Int	11	OSLP	-1
TaxDate	Document Date	Date	8	-
UseDocPric	Use Document Price	VarChar	1	-	N	Y	Yes
						N	No
VendorNum	Vendor Catalog No.	nVarChar	50	-
SerialNum	Serial Number	nVarChar	17	-
BlockNum	Block Number	nVarChar	100	-
ImportLog	Import Log	nVarChar	20	-
Location	Location	Int	11	OLCT
DocPrcRate	Document Price Rate	Num	19.6	-
DocPrcCurr	Document Price Currency	nVarChar	3	OCRN
CgsOcrCod	COGS Distribution Rule	nVarChar	8	OOCR
CgsOcrCod2	COGS Distribution Rule 2	nVarChar	8	OOCR
CgsOcrCod3	COGS Distribution Rule 3	nVarChar	8	OOCR
CgsOcrCod4	COGS Distribution Rule 4	nVarChar	8	OOCR
CgsOcrCod5	COGS Distribution Rule 5	nVarChar	8	OOCR
BSubLineNo	Base Subrow Number	Int	11	-	-1
AppSubLine	Applied Subrow Number	Int	11	-	-1
UserSign	User Signature	Int	6	OUSR
SysRate	System Rate	Num	19.6	-
ExFromRpt	Exclude from Report	VarChar	1	-	N	Y	Yes
						N	No
Ref3	Reference 3	nVarChar	100	-
EnSetCost	Enable Set Item Cost in Return	VarChar	1	-	N	Y	Yes
						N	No
RetCost	Return Cost in A/R Return	Num	19.6	-
DocAction	Document Action Type	Int	11	-
UseShpdGd	Use Shipped Goods Account	VarChar	1	-	N	N	No
						Y	Yes
AddTotalLC	Additional Total LC	Num	19.6	-
AddExpLC	Additional Expenses LC	Num	19.6	-
IsNegLnQty	Negative Line Quantity	VarChar	1	-	N
StgSeqNum	Stage Sequence Number	Int	11	-
StgEntry	Stage Entry	Int	11	-
StgDesc	Stage Description	nVarChar	100	-

Key	Unique	Field
PRIMARY	Yes	MessageID
CARD	No	BPCardCode
DocLine	No	TransType
		DocEntry
		DocLineNum
		SubLineNum
APPOBJ	No	ApplObj
		AppObjAbs
		AppObjType
		AppObjLine
BASEOBJ	No	BaseType
		BaseAbsEnt
		BaseLine
		BSubLineNo