📚 SAP Business One SDK Help

Table Name: AOPR

Table Description: Opportunity

Field Description Type Size Related Default Value Constraints
OpprId Sequence No. Int 11 -      
CardCode BP Code nVarChar 15 OCRD      
SlpCode Main Sales Emp. Int 11 OSLP      
CprCode Contact Person Int 11 OCPR      
Source Source Int 11 OOSR      
IntCat1 Interest - Field 1 Int 11 OOIN      
IntCat2 Interest - Field 2 Int 11 OOIN      
IntCat3 Interest - Field 3 Int 11 OOIN      
IntRate Interest Level Int 11 OOIR      
OpenDate Start Date Date 8 -      
DifType Closing Type VarChar 1 - D M Months
            W Weeks
            D Days
PredDate Predicted Closing Date Date 8 -      
MaxSumLoc Local Potential Amount Num 19.6 -      
MaxSumSys System Potential Amount Num 19.6 -      
WtSumLoc Weighted Amount (LC) - Document Num 19.6 -      
WtSumSys Weighted Amount (SC) Num 19.6 -      
PrcnProf Gross Profit % Num 19.6 -      
SumProfL Gross Profit Total - Local Num 19.6 -      
SumProfS Gross Profit Total - System Num 19.6 -      
Memo Remarks Text 16 -      
Status Status VarChar 1 - O O Open
            L Lost
            W Won
StatusRem Status Remarks nVarChar 30 -      
Reason Reason for Closing Int 11 OOFR      
RealSumLoc Total Amount - Local Num 19.6 -      
RealSumSys Total Amount - System Num 19.6 -      
RealProfL Closing Gross Profit - Local Num 19.6 -      
RealProfS Closing Gross Profit - System Num 19.6 -      
CloPrcnt Closing Percentage Num 19.6 -      
StepLast Current Stage No. Int 6 OOST      
UserSign User Signature Int 6 OUSR      
Transfered Transferred to Next Year VarChar 1 - N Y Yes
            N No
Instance Instance Int 6 - 0    
CardName BP Name nVarChar 200 -      
CloseDate Closing Date Date 8 -      
LastSlp Last Sales Emp. Int 11 OSLP      
Name Opportunity Name nVarChar 100 -      
Territory Territory Int 11 OTER      
Industry Industry Int 11 OOND      
ChnCrdCode BP Channel Code nVarChar 15 OCRD      
ChnCrdName BP Channel Name nVarChar 200 -      
PrjCode Project Code nVarChar 20 OPRJ      
CardGroup BP Group Int 6 OCRD      
ChnCrdCon BP Channel Contact Int 11 OCPR      
Owner Data Ownership field Int 11 OHEM      
attachment Attachments Text 16 -      
DocType Linked Document Type nVarChar 9 - -1 -1  
            23 Quotations
            17 Sales Orders
            15 Delivery Notes
            13 Sales Invoices
            540000006 Purchase Quotations
            22 Purchase Orders
            20 Goods Receipt POs
            18 Purchase Invoices
DocNum Linked Document Number Int 11 -      
DocEntry Linked Document Entry Int 11 -      
DocChkbox Document Checkbox VarChar 1 -      
AtcEntry Attachment Entry Int 11 -      
LogInstanc Log Instance Int 11 - 0    
UserSign2 Updating User Int 6 OUSR      
UpdateDate Update Date Date 8 -      
OpprType Opportunity Type VarChar 1 - R R Sales
            P Purchasing
UpdateTS Update Full Time Int 11 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
CreateDate Creation Date Date 8 -      
EncryptIV Encrypt IV nVarChar 100 -      
DataVers Data Version Int 11 - 1    
VersionNum Version Number nVarChar 13 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Upgrade
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Auto Summary
            D Restore Wizard
            P Partner Implementation
            T Year of Transfer
Key Unique Field
PRIMARY Yes OpprId
    LogInstanc