📚 SAP Business One SDK Help

Table Name: OBOE

Table Description: Bill of Exchange for Payment

Field Description Type Size Related Default Value Constraints
BoeKey Bill of Exchange Key Int 11 -      
BoeNum Bill of Exchange No. Int 11 -      
BoeStatus Bill of Exchange Status VarChar 1 -   G Generated
            S Sent
            D Deposited
            P Paid
            C Canceled
            L Closed
            F Failed
            V BoE to Vendor
BoeType Bill of Exchange Type VarChar 1 - I I Incoming
            O Outgoing
DpsBankCod Deposit Bank Code nVarChar 30 -      
DpsCntrCod Deposit Country/Region Code nVarChar 3 OCRY      
DueDate Bill of Exchange Due Date Date 8 -      
DpstAcct Bank Account No. nVarChar 50 -      
DpstBranch Branch for Payments nVarChar 50 -      
Details Details nVarChar 50 -      
TransRef Journal Entry Reference nVarChar 8 -      
PmntDate Payment Date Date 8 -      
PmntNum Payment No. Int 11 -      
BoeSum Bill of Exchange Amount Num 19.6 -      
BoeSumSC Bill of Exchange Amount (SC) Num 19.6 -      
BoeSumFC Bill of Exchange Amount (FC) Num 19.6 -      
CardCode BP Code nVarChar 15 OCRD      
CardName BP Name nVarChar 200 -      
BoeAcct BP Account Code nVarChar 15 OACT      
Currency Bill of Exchange Currency nVarChar 3 OCRN      
Printed Printed VarChar 1 - N N No
            Y Yes
TotalWords Total in Words nVarChar 100 -      
Signature Signature nVarChar 155 -      
TransNum Transaction No. Int 11 - 0    
LinesSum Row Totals Num 19.6 -      
DdctPrcnt % Withholding Tax Ded. Num 19.6 -      
Address Address nVarChar 254 -      
UpdateDate Date of Update Date 8 -      
CreateDate Creation Date Date 8 -      
VatTotal Total Tax Num 19.6 -      
VatTotalSC Total Tax (SC) Num 19.6 -      
VatTotalFC Total Tax (FC) Num 19.6 -      
VatCalcult Calculate Tax VarChar 1 - N Y Yes
            N No
TaxDate Document Date Date 8 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Upgrade
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
SumRfndCln Deduction Refund Amount Num 19.6 -      
UserSign User Signature Int 6 OUSR      
PrintedBy Printed By Int 6 -      
Transfered Transferred to next year VarChar 1 - N Y Yes
            N No
Instance Instance Int 6 - 0    
LogInstanc Log Instance Int 11 - 0    
BPBankCod BP Bank Code nVarChar 30 -      
BPBankNam BP Bank Name nVarChar 250 -      
BPBankAct BP Bank Account nVarChar 50 -      
BPBankBrnc BP Bank Branch nVarChar 50 -      
BPBankCtr BP Bank Country/Region nVarChar 3 OCRY      
RefNum Reference No. nVarChar 254 -      
IsReconcld Reconciled VarChar 1 - N N No
            Y Yes
Comments Remarks nVarChar 254 -      
PayMethCod Payment Method Code nVarChar 15 OPYM      
DepositNum Deposit Number Int 11 -      
PymMethNam Payment Method Name nVarChar 100 -      
DeductSum Deduction Amount Num 19.6 -      
ControlKey Control Key nVarChar 2 -      
AgentCode Agent Code nVarChar 32 OAGP      
ReconcilNu External Reconciliation No. Int 11 -      
DepositTyp Deposit Type VarChar 1 -   C Collection
            D Discounted
CreatStatu Creation Status VarChar 1 -   G Generated
            S Sent
Ref2 Reference 2 nVarChar 254 -      
PayEngSt1 Payment Engine Status 1 VarChar 1 -      
PayEngSt2 Payment Engine Status 2 VarChar 1 -      
PayEngSt3 Payment Engine Status 3 nVarChar 3 -      
StampTax Stamp Tax Code nVarChar 8 OVTG      
StmpTxAmnt Stamp Tax Amount Num 19.6 -      
DpsActKey Bank Account Internal ID Int 11 DSC1      
OutBnkKey Outgoing Bank Account Key Int 11 DSC1      
Portfolio Portfolio nVarChar 8 OPFT      
VndCodeCEE Vendor Code nVarChar 15 OCRD      
VndNameCEE Vendor Name nVarChar 200 -      
OurNum Our Number Int 11 -      
BarcodeNum Bar Code Number nVarChar 120 -      
BarcodeRep Bar Code Representation nVarChar 100 -      
OurNumChk Our Number Check Digit VarChar 1 -      
FolioPref Folio Prefix String nVarChar 4 -      
FolioNum Folio Number Int 11 -      
LPgFolioN Folio No. for Last Page in Doc. Int 11 -      
UserSign2 Updating User Int 6 OUSR      
IntrstAmnt Interest Amount Num 19.6 -      
DiscAmnt Discount Amount Num 19.6 -      
FineAmnt Fine Amount Num 19.6 -      
IntrstDate BoE Interest Date Date 8 -      
DiscDate BoE Discount Date Date 8 -      
FineDate BoE Fine Date Date 8 -      
PostType Posting Type VarChar 1 -   D Default
            A Alternative
IOFAmnt IOF Amount Num 19.6 -      
ServFeeAm Service Fee Amount Num 19.6 -      
OtherExAm Other Expenses Amount Num 19.6 -      
OtherInAm Other Incomes Amount Num 19.6 -      
BPLId Branch Int 11 OBPL      
EnBPBnkAct Encryption of BP Bank Account Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
EnDpstAcct Encryption of Bank Account No. Text 16 -      
Key Unique Field
PRIMARY Yes BoeKey
VPM_NUM No PmntNum
TRANS_NUM No TransNum
DPS_NUM No DepositNum
BOE_NUM Yes BoeNum
    BoeType