📚 SAP Business One SDK Help

Table Name: OTSH

Table Description: Time Sheet - Header

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Key Int 11 -      
ProjectID Project No. Int 11 OPMG      
DocNum Document Number Int 11 -      
Type Type VarChar 1 - E E Employee
            U User
            O External
UserID Employee/User ID Int 11 OHEM      
LastName Last Name nVarChar 50 -      
FirstName First Name nVarChar 50 -      
Department Department Int 6 -      
DateFrom Date From Date 8 -      
DateTo Date To Date 8 -      
LogInstanc Log Instance Int 11 - 0    
UpdateDate Date of Update Date 8 -      
UserSign User Signature Int 6 -      
UserSign2 Updating User Int 6 -      
CreateDate Production Date Date 8 -      
UpdateTS Update Full Time Int 11 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
SAPPassprt Extended SAP Passport Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
UserCode Employee/User Code nVarChar 50 -      
DataVers Data Version Int 11 - 1    
OwnerCode Owner Int 11 OHEM      
Key Unique Field
PRIMARY Yes AbsEntry