📚 SAP Business One SDK Help

Table Name: ADS1

Table Description: House Bank Accounts

Field Description Type Size Related Default Value Constraints
BankCode Bank Code nVarChar 30 -      
Account Acct No. nVarChar 50 -      
Branch Branch nVarChar 50 -      
NextCheck Next Check No. Int 11 -      
GLAccount G/L Account nVarChar 15 OACT      
Free Free VarChar 1 -      
Street Street nVarChar 100 -      
Block Block nVarChar 100 -      
ZipCode Zip Code nVarChar 20 -      
City City nVarChar 100 -      
County County nVarChar 100 -      
Country Country/Region nVarChar 3 OCRY      
State State nVarChar 3 OCST      
BISR BISR VarChar 1 - N Y Yes
            N No
ControlKey Control Key nVarChar 2 -      
UsrNumber1 User No. 1 nVarChar 25 -      
UsrNumber2 User No. 2 nVarChar 25 -      
UsrNumber3 User No. 3 nVarChar 25 -      
UsrNumber4 User No. 4 nVarChar 25 -      
IBAN IBAN nVarChar 50 -      
DscountBOE Debt of Discounted BoE nVarChar 15 OACT      
TolrnceDay Tolerance Days Int 11 -      
MinAmntBOE Min. Amount of Bill of Exchange Num 19.6 -      
MaxAmntBOE Max. Amount of Bill of Exchange Num 19.6 -      
DscntLimit Discount Limit Num 19.6 -      
DaysInAdva Days in Advance Int 11 -      
BankCollec Bank on Collection nVarChar 15 OACT      
BankDiscou Bank on Discounted nVarChar 15 OACT      
BranchName Branch Name nVarChar 50 -      
AliasName Alias Name nVarChar 50 -      
CompanyCod Company Code nVarChar 10 -      
AcctType Account Type VarChar 1 -      
Building Building/Floor/Room Text 16 -      
BIK BIK nVarChar 15 -      
AcctName Bank Account Name nVarChar 250 -      
CorresAcct Correspondent Account nVarChar 30 -      
Phone Telephone No. nVarChar 50 -      
Fax Fax nVarChar 50 -      
GLIntriAct G/L Interim Account nVarChar 15 OACT      
ChkPaper Paper Type VarChar 1 - D B Blank Paper
            S Overflow Prenumbered Check Stock
            P Overflow Blank Paper
            D Default
MaxChkLine Maximum Lines Int 6 -      
TmpltName Template Name nVarChar 8 -      
AbsEntry Internal Number Int 11 -      
BankKey Bank ID Int 11 ODSC      
LockChk Lock Checks Printing VarChar 1 - N Y Yes
            N No
OurNum Our Number in Next Boleto Int 11 -      
AgreeNum Agreement Number nVarChar 10 -      
AccountChk Account Check Digit VarChar 1 -      
ISRType ISR Type Int 6 - 2 1 ISR
            2 BISR
            3 ISR+
            4 BISR+
ISRBillerI ISR Biller ID nVarChar 9 -      
CustIdNum Customer ID Number nVarChar 10 - 0    
InSeri Incoming Payment Series Int 11 NNM1 -1    
OutSeri Outgoing Payment Series Int 11 NNM1 -1    
JDTSeri Journal Entry Series Int 11 NNM1 -1    
FilePlug Import File Name nVarChar 50 -      
ImpStmt Imported Bank Statement VarChar 1 - N Y Create New - From File
            N Create New - Manually
PreNumber Prenumbered Check VarChar 1 - Y Y Yes
            N No
AddrType Address Type nVarChar 100 -      
StreetNo Street No. nVarChar 100 -      
LogInstanc Log Instance Int 11 - 0    
UpdateDate Date of Update Date 8 -      
UsrLogSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
SwiftNum BIC/SWIFT Code nVarChar 50 -      
FineAcct Fine Account nVarChar 15 OACT      
IntrstAcct Interest Account nVarChar 15 OACT      
DscntAcct Discount Account nVarChar 15 OACT      
SvcFeeAcct Service Fee Account nVarChar 15 OACT      
BranchChk Branch Check Digit nVarChar 5 -      
RetFile Retorno File Format nVarChar 50 -      
IOFTaxAcct IOF Tax Account nVarChar 15 -      
OthExpAcct Other Expenses Account nVarChar 15 OACT      
OthIncAcct Other Incomes Account nVarChar 15 OACT      
CollCode Collection Code nVarChar 50 -      
FileSeqNNo File Sequence Next Number Int 11 -      
RefCoLevel Reference Control Level VarChar 1 - H S Soft Control
            H Hard Control
            V Hard Control with variable length
            F Hard Control with fixed length
RefFixLen1 Reference fixed length 1 Int 6 -      
RefFixLen2 Reference fixed length 2 Int 6 -      
Currency Currency nVarChar 3 OCRN      
NoValidBal No Validation for Starting/Ending Balance VarChar 1 - N Y Yes
            N No
ECheck E-Check VarChar 1 - N Y Yes
            N No
EnAccount Encryption of Acct No. Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
Key Unique Field
PRIMARY Yes AbsEntry
    LogInstanc