📚 SAP Business One SDK Help

Table Name: OPR1

Table Description: Opportunity - Rows

Field Description Type Size Related Default Value Constraints
OpprId Sequence No. Int 11 OOPR      
Line Row No. Int 6 -      
SlpCode Sales Employee Int 11 OSLP      
CntctCode Contact Person Int 11 OCPR      
OpenDate Start Date Date 8 -      
CloseDate Closing Date Date 8 -      
Step_Id Stage Key Int 11 OOST      
ClosePrcnt Percentage Rate Num 19.6 -      
MaxSumLoc Max. Local Total Num 19.6 -      
MaxSumSys Max. System Total Num 19.6 -      
Memo Remarks Text 16 -      
DocId Object Code Int 11 -      
ObjType Object Type nVarChar 9 - -1 -1  
            0  
            23 Sales Quotations
            17 Sales Orders
            15 Delivery Notes
            13 Sales Invoices
            540000006 Purchase Quotations
            22 Purchase Orders
            20 Goods Receipt POs
            18 Purchase Invoices
Status Status VarChar 1 - O O Open
            C Closed
Linked Activity VarChar 1 - N Y Yes
            N No
WtSumLoc Weighted Amount (LC) - Rows Num 19.6 -      
WtSumSys Weighted Amount (SC) Num 19.6 -      
UserSign User Signature Int 6 OUSR      
ChnCrdCode BP Channel Code nVarChar 15 OCRD      
ChnCrdName BP Channel Name nVarChar 200 -      
ChnCrdCon BP Channel Contact Int 11 OCPR      
DocChkbox Document Checkbox VarChar 1 -   Y Yes
            N No
Owner Data Ownership Field Int 11 OHEM      
DocNumber Document Number Int 11 -      
EncryptIV Encrypt IV nVarChar 100 -      
Key Unique Field
PRIMARY Yes OpprId
    Line