📚 SAP Business One SDK Help

Table Name: OITT

Table Description: Product Tree

Field Description Type Size Related Default Value Constraints
Code Parent Item nVarChar 50 OITM      
TreeType BOM Type VarChar 1 - P A Assembly
            S Sales
            P Production
            T Template
PriceList Price List Int 6 OPLN 0    
Qauntity No. of Units Num 19.6 -      
CreateDate Creation Date Date 8 -      
UpdateDate Date of Update Date 8 -      
Transfered Postponed to Next Year VarChar 1 - N Y Yes
            N No
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      
SCNCounter SCN Counter Int 6 -      
DispCurr Display Currency nVarChar 3 -      
ToWH Whse for Finished Product nVarChar 8 -      
Object Object Type nVarChar 20 - 66    
LogInstac Log Instance - History Int 11 -      
UserSign2 Updating User Int 11 OUSR      
OcrCode Distribution Rule nVarChar 8 OOCR      
HideComp Hide Components in Printing VarChar 1 - N Y Yes
            N No
OcrCode2 Distribution Rule2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule5 nVarChar 8 OOCR      
UpdateTime Time of Update Int 11 -      
Project Project Code nVarChar 20 OPRJ      
PlAvgSize Planned Average Production Size Num 19.6 - 1    
Name Product Description nVarChar 200 -      
CreateTS Create Time - Incl. Secs Int 11 -      
UpdateTS Update Full Time Int 11 -      
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachments Text 16 -      
Key Unique Field
PRIMARY Yes Code
PRICE_LIST No PriceList