📚 SAP Business One SDK Help

Table Name: AOAT

Table Description: Blanket Agreement

Field Description Type Size Related Default Value Constraints
AbsID Agreement No. Int 11 -      
BpCode BP Code nVarChar 15 OCRD      
BpName BP Name nVarChar 200 -      
CntctCode Contact Person Int 11 OCPR      
StartDate Start Date Date 8 -      
EndDate End Date Date 8 -      
TermDate Termination Date Date 8 -      
Descript Description nVarChar 254 -      
Type Agreement Type VarChar 1 - G G General
            S Specific
Status Agreement Status VarChar 1 - D A Approved
            F On Hold
            D Draft
            T Terminated
            C Canceled
            X To Be Terminated
            P To Be On Hold
Owner Owner Int 11 OHEM      
Renewal Renewal VarChar 1 - N Y Yes
            N No
UseDiscnt Use BP Special Price VarChar 1 - Y Y Yes
            N No
RemindVal Reminder Int 6 -      
RemindUnit Reminder Unit VarChar 1 - D D Day(s)
            W Week(s)
            M Month(s)
Remarks Remarks Text 16 -      
AtchEntry Attachment Entry Int 11 OATC      
LogInstanc Log Instance Int 11 - 0    
UserSign User Signature Int 6 OUSR      
UserSign2 User Signature 2 Int 6 OUSR      
UpdtDate Update Date Date 8 -      
CreateDate Create Date Date 8 -      
Cancelled Canceled VarChar 1 - N Y Yes
            N No
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
Transfered Year Transfer VarChar 1 - N Y Yes
            N No
RemindFlg Reminder Sent VarChar 1 - N Y Yes
            N No
Fulfilled Fulfilled VarChar 1 - N Y Fulfilled
            N Not Fulfilled
Attachment Attachments Text 16 -      
SettleProb Settlement Probability % Num 19.6 -      
UpdtTime Update Time Int 11 -      
Method Agreement Method VarChar 1 - I I Items Method
            M Monetary Method
GroupNum Payment Terms Code Int 6 OCTG      
ListNum Price List No. Int 6 OPLN      
SignDate Signing Date Date 8 -      
AmendedTo Amendment To Int 11 -      
Series Series Int 11 NNM1      
Number Number Int 11 -      
ObjType Object Type nVarChar 20 ADP1 1250000025    
Handwrtten Manual Numbering VarChar 1 - N    
PIndicator Period Indicator nVarChar 10 OPID ' '    
BpType BP Type VarChar 1 - C C Customer
            S Vendor
Instance Instance Int 6 - 0    
PayMethod Payment Method nVarChar 15 OPYM      
NumAtCard Customer/Vendor Ref. No. nVarChar 200 -      
BPCurr BP Currency nVarChar 3 OCRN      
FixedRate Exchange Rate Num 19.6 -      
TrnspCode Shipping Type Int 6 OSHP      
Project Project Code nVarChar 20 OPRJ      
PriceMode Price Mode VarChar 1 - N N Net
            G Gross
WddStatus Authorization Status VarChar 1 - - - Without
            W Pending
            Y Approved
            N Rejected
            P Generated
            A Generated by Authorizer
            C Canceled
FromStat From Status VarChar 1 - D F On Hold
            D Draft
            A Approved
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
SAPPassprt Extended SAP Passport Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
VersionNum Version Number nVarChar 13 -      
Key Unique Field
PRIMARY Yes AbsID
    LogInstanc