Inventory Opening Balance Draft

Table Name: OIOD

Table Description: Inventory Opening Balance Draft

Field	Description	Type	Size	Related	Default Value	Constraints
DocEntry	Document Internal ID	Int	11	-
CreateDate	Creation Date	Date	8	-
DocTime	Generation Time	Int	6	-
IOffIncAcc	Inventory Offset Increase Acct	nVarChar	15	OACT
DOffDecAcc	Inventory Offset Decrease Acct	nVarChar	15	OACT
DocDate	Posting Date	Date	8	-
Reference	Reference	nVarChar	11	-
Comments	Remarks	nVarChar	254	-
DocDueDate	Due Date	Date	8	-
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
VersionNum	Version Number	nVarChar	13	-
JdtNum	Journal Number	Int	11	-
Reference2	Reference 2	nVarChar	11	-
ObjType	Object Type	nVarChar	20	-	310000001
DocNum	Document Number	Int	11	-
Series	Series	Int	11	NNM1
PriceSrc	Price Source	VarChar	1	-	3	1	By Price List
						2	Last Evaluated Price
						3	Item Cost
PriceList	Price List	Int	11	-
JrnlMemo	Journal Remarks	nVarChar	254	-
TaxDate	Document Date	Date	8	-
Status	Status	VarChar	1	-	O	O	Open
						C	Close
LogIns	Log Instance - History	Int	11	-
UserSign2	Update User - History	Int	6	OUSR
UpdateDate	Date of Update - History	Date	8	-
WddStatus	Authorization Status	VarChar	1	-	-	-	Without
						W	Pending
						Y	Approved
						N	Rejected
						P	Generated
						A	Generated by Authorizer
						C	Canceled
DraftKey	Draft Document Internal ID	Int	11	OIOD	-1
Printed	Printed	VarChar	1	-	N
DocTotal	Document Total	Num	19.6	-
BPLId	Branch	Int	11	OBPL
BPLName	Branch Name	nVarChar	200	-
UpdateTS	Update Full Time	Int	11	-
PIndicator	Period Indicator	nVarChar	10	-	' '
FinncPriod	Posting Period	Int	11	-
AtcEntry	Attachment Entry	Int	11	OATC
Attachment	Attachment	Text	16	-