biuan SAP® BUSINESS ONE SDK
API ABOE
ABOE - Bill of Exchange for Payment - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BoeKey KEY UNIQUEBill of Exchange KeyInt
11
PRIMARYYes
BoeNum KEY UNIQUEBill of Exchange No.Int
11
BOE_NUMYes
BoeStatusBill of Exchange StatusVarChar
G) Generated
S) Sent
D) Deposited
P) Paid
C) Canceled
L) Closed
F) Failed
V) BoE to Vendor
1
BoeTypeBill of Exchange TypeVarChar
I) Incoming
O) Outgoing
1
I
DpsBankCodDeposit Bank CodenVarChar
30
DpsCntrCodDeposit Country CodenVarChar
3OCRY
Countries
DueDateBill of Exchange Due DateDate
8
DpstAcctBank Account No.nVarChar
50
DpstBranchBranch for PaymentsnVarChar
50
DetailsDetailsnVarChar
50
TransRefJournal Entry ReferencenVarChar
8
PmntDatePayment DateDate
8
PmntNum KEYPayment No.Int
11
VPM_NUMNo
BoeSumBill of Exchange AmountNum
20
BoeSumSCBill of Exchange Amount (SC)Num
20
BoeSumFCBill of Exchange Amount (FC)Num
20
CardCodeBP CodenVarChar
15OCRD
Business Partner
CardNameBP NamenVarChar
100
BoeAcctBP Account CodenVarChar
15OACT
G/L Accounts
CurrencyBill of Exchange CurrencynVarChar
3OCRN
Currency Codes
PrintedPrintedVarChar
N) No
Y) Yes
1
N
TotalWordsTotal in WordsnVarChar
100
SignatureSignaturenVarChar
127
TransNum KEYTransaction No.Int
11
0TRANS_NUMNo
LinesSumRow TotalsNum
20
DdctPrcnt% Withholding Tax Ded.Num
20
AddressAddressnVarChar
127
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
VatTotalTotal TaxNum
20
VatTotalSCTotal Tax (SC)Num
20
VatTotalFCTotal Tax (FC)Num
20
VatCalcultCalculate TaxVarChar
Y) Yes
N) No
1
N
TaxDateDocument DateDate
8
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
SumRfndClnDeduction Refund AmountNum
20
UserSignUser SignatureInt
6OUSR
Users
PrintedByPrinted ByInt
6
TransferedTransferred to next yearVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
BPBankCodBP Bank CodenVarChar
30
BPBankNamBP Bank NamenVarChar
127
BPBankActBP Bank AccountnVarChar
50
BPBankBrncBP Bank BranchnVarChar
50
BPBankCtrBP Bank CountrynVarChar
3OCRY
Countries
RefNumReference No.nVarChar
127
IsReconcldReconciledVarChar
N) No
Y) Yes
1
N
CommentsRemarksnVarChar
127
PayMethCodPayment Method CodenVarChar
15OPYM
Payment Methods for Payment Wizard
DepositNum KEYDeposit NumberInt
11
DPS_NUMNo
PymMethNamPayment Method NamenVarChar
100
DeductSumDeduction AmountNum
20
ControlKeyControl KeynVarChar
2
AgentCodeAgent CodenVarChar
32OAGP
Agent Name
ReconcilNuExternal Reconciliation No.Int
11
DepositTypDeposit TypeVarChar
C) Collection
D) Discounted
1
CreatStatuCreation StatusVarChar
G) Generated
S) Sent
1
Ref2Reference 2nVarChar
127
PayEngSt1Payment Engine Status 1VarChar
1
PayEngSt2Payment Engine Status 2VarChar
1
PayEngSt3Payment Engine Status 3nVarChar
3
StampTaxStamp Tax CodenVarChar
8OVTG
Tax Definition
StmpTxAmntStamp Tax AmountNum
20
DpsActKeyBank Account Internal IDInt
11DSC1
House Bank Accounts
OutBnkKeyOutgoing Bank Account KeyInt
11DSC1
House Bank Accounts
PortfolioPortfolionVarChar
8OPFT
Portfolio Definitions
VndCodeCEEVendor CodenVarChar
15OCRD
Business Partner
VndNameCEEVendor NamenVarChar
100
OurNumOur NumberInt
11
BarcodeNumBar Code NumbernVarChar
120
BarcodeRepBar Code RepresentationnVarChar
100
OurNumChkOur Number Check DigitVarChar
1
FolioPrefFolio Prefix StringnVarChar
4
FolioNumFolio NumberInt
11
LPgFolioNFolio No. for Last Page in Doc.Int
11
UserSign2Updating UserInt
6OUSR
Users
IntrstAmntInterest AmountNum
20
DiscAmntDiscount AmountNum
20
FineAmntFine AmountNum
20
IntrstDateBoE Interest DateDate
8
DiscDateBoE Discount DateDate
8
FineDateBoE Fine DateDate
8
PostTypePosting TypeVarChar
D) Default
A) Alternative
1
IOFAmntIOF AmountNum
20
ServFeeAmService Fee AmountNum
20
OtherExAmOther Expenses AmountNum
20
OtherInAmOther Incomes AmountNum
20

Table relationship map

SELECT statement

SELECT ABOE.BoeKey AS 'Bill of Exchange Key', ABOE.BoeNum AS 'Bill of Exchange No.', ABOE.BoeStatus AS 'Bill of Exchange Status', ABOE.BoeType AS 'Bill of Exchange Type', ABOE.DpsBankCod AS 'Deposit Bank Code', ABOE.DpsCntrCod AS 'Deposit Country Code', ABOE.DueDate AS 'Bill of Exchange Due Date', ABOE.DpstAcct AS 'Bank Account No.', ABOE.DpstBranch AS 'Branch for Payments', ABOE.Details AS 'Details', ABOE.TransRef AS 'Journal Entry Reference', ABOE.PmntDate AS 'Payment Date', ABOE.PmntNum AS 'Payment No.', ABOE.BoeSum AS 'Bill of Exchange Amount', ABOE.BoeSumSC AS 'Bill of Exchange Amount (SC)', ABOE.BoeSumFC AS 'Bill of Exchange Amount (FC)', ABOE.CardCode AS 'BP Code', ABOE.CardName AS 'BP Name', ABOE.BoeAcct AS 'BP Account Code', ABOE.Currency AS 'Bill of Exchange Currency', ABOE.Printed AS 'Printed', ABOE.TotalWords AS 'Total in Words', ABOE.Signature AS 'Signature', ABOE.TransNum AS 'Transaction No.', ABOE.LinesSum AS 'Row Totals', ABOE.DdctPrcnt AS '% Withholding Tax Ded.', ABOE.Address AS 'Address', ABOE.UpdateDate AS 'Date of Update', ABOE.CreateDate AS 'Creation Date', ABOE.VatTotal AS 'Total Tax', ABOE.VatTotalSC AS 'Total Tax (SC)', ABOE.VatTotalFC AS 'Total Tax (FC)', ABOE.VatCalcult AS 'Calculate Tax', ABOE.TaxDate AS 'Document Date', ABOE.DataSource AS 'Data Source', ABOE.SumRfndCln AS 'Deduction Refund Amount', ABOE.UserSign AS 'User Signature', ABOE.PrintedBy AS 'Printed By', ABOE.Transfered AS 'Transferred to next year', ABOE.Instance AS 'Instance', ABOE.LogInstanc AS 'Log Instance', ABOE.BPBankCod AS 'BP Bank Code', ABOE.BPBankNam AS 'BP Bank Name', ABOE.BPBankAct AS 'BP Bank Account', ABOE.BPBankBrnc AS 'BP Bank Branch', ABOE.BPBankCtr AS 'BP Bank Country', ABOE.RefNum AS 'Reference No.', ABOE.IsReconcld AS 'Reconciled', ABOE.Comments AS 'Remarks', ABOE.PayMethCod AS 'Payment Method Code', ABOE.DepositNum AS 'Deposit Number', ABOE.PymMethNam AS 'Payment Method Name', ABOE.DeductSum AS 'Deduction Amount', ABOE.ControlKey AS 'Control Key', ABOE.AgentCode AS 'Agent Code', ABOE.ReconcilNu AS 'External Reconciliation No.', ABOE.DepositTyp AS 'Deposit Type', ABOE.CreatStatu AS 'Creation Status', ABOE.Ref2 AS 'Reference 2', ABOE.PayEngSt1 AS 'Payment Engine Status 1', ABOE.PayEngSt2 AS 'Payment Engine Status 2', ABOE.PayEngSt3 AS 'Payment Engine Status 3', ABOE.StampTax AS 'Stamp Tax Code', ABOE.StmpTxAmnt AS 'Stamp Tax Amount', ABOE.DpsActKey AS 'Bank Account Internal ID', ABOE.OutBnkKey AS 'Outgoing Bank Account Key', ABOE.Portfolio AS 'Portfolio', ABOE.VndCodeCEE AS 'Vendor Code', ABOE.VndNameCEE AS 'Vendor Name', ABOE.OurNum AS 'Our Number', ABOE.BarcodeNum AS 'Bar Code Number', ABOE.BarcodeRep AS 'Bar Code Representation', ABOE.OurNumChk AS 'Our Number Check Digit', ABOE.FolioPref AS 'Folio Prefix String', ABOE.FolioNum AS 'Folio Number', ABOE.LPgFolioN AS 'Folio No. for Last Page in Doc.', ABOE.UserSign2 AS 'Updating User', ABOE.IntrstAmnt AS 'Interest Amount', ABOE.DiscAmnt AS 'Discount Amount', ABOE.FineAmnt AS 'Fine Amount', ABOE.IntrstDate AS 'BoE Interest Date', ABOE.DiscDate AS 'BoE Discount Date', ABOE.FineDate AS 'BoE Fine Date', ABOE.PostType AS 'Posting Type', ABOE.IOFAmnt AS 'IOF Amount', ABOE.ServFeeAm AS 'Service Fee Amount', ABOE.OtherExAm AS 'Other Expenses Amount', ABOE.OtherInAm AS 'Other Incomes Amount' FROM ABOE AS ABOE

Related information


Agent Name OAGP SQL Table

G/L Accounts OACT SQL Table

Countries OCRY SQL Table

Business Partner OCRD SQL Table

Currency Codes OCRN SQL Table

House Bank Accounts DSC1 SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Portfolio Definitions OPFT SQL Table

Tax Definition OVTG SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates