biuan SAP® BUSINESS ONE SDK
DTW Payment Draft
API Payments / Address
OPDF - Payment Draft Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUENumeratorInt
11
PRIMARYYes
DocNum KEYDocument NumberInt
11
NUMNo
DocTypeDocument TypeVarChar
C) Customer
A) Account
S) Vendor
P) P.L.A
D) TDS
1
Canceled KEYCanceledVarChar
Y) Yes
N) No
1
CANCELEDNo
Handwrtten KEYManual NumberingVarChar
Y) Yes
N) No
1
HANDWRITENNo
PrintedPrintedVarChar
Y) Copy
N) Original
1
N
DocDatePosting DateDate
8
DocDueDateValue DateDate
8
CardCode KEYCustomer/Vendor CodenVarChar
15
CARDNo
CardNameCustomer/Vendor NamenVarChar
100
AddressAddressnVarChar
127
DdctPrcntDeduction PercentNum
20
DdctSumTotal DeductionsNum
20
DdctSumFCTotal Deductions in FCNum
20
CashAcctCash AccountnVarChar
15OACT
G/L Accounts
CashSumCash AmountNum
20
CashSumFCCash Amount in FCNum
20
CreditSumCredit AmountNum
20
CredSumFCCredit Amount in FCNum
20
CheckAcctCurrent AccountnVarChar
15OACT
G/L Accounts
CheckSumCheck AmountNum
20
CheckSumFCCheck Amount in FCNum
20
TrsfrAcctTransfer AccountnVarChar
15OACT
G/L Accounts
TrsfrSumTransfer AmountNum
20
TrsfrSumFCTransfer Amount in FCNum
20
TrsfrDateTransfer DateDate
8
TrsfrRefIntended PurposenVarChar
27
PayNoDocNon-Calculated PaymentVarChar
Y) Yes
N) No
1
N
NoDocSumNon-Calculated AmountNum
20
NoDocSumFCNon-Calculated Amount in FCNum
20
DocCurrDocument CurrencynVarChar
3OCRN
Currency Codes
DiffCurrEnter in local currencyVarChar
N) No
Y) Yes
1
N
DocRateDocument RateNum
20
SysRateSystem PriceNum
20
DocTotalDocument TotalNum
20
DocTotalFCDocument Total in FCNum
20
Ref1Reference 1nVarChar
8
Ref2Reference 2nVarChar
8
CounterRefCounter ReferencenVarChar
8
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarksnVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
DocTimeGeneration TimeInt
6
ShowAtCardDisplay Customer Ref. No.VarChar
Y) Yes
N) No
1
N
SpiltTransSplit Transaction JournalVarChar
Y) Yes
N) No
1
N
CreateTranCreate Journal EntryVarChar
Y) Yes
N) No
1
Y
FlagsFlagsInt
11
0
CntctCodeContact PersonInt
11OCPR
Contact Persons
DdctSumSySystem Deduction AmountNum
20
CashSumSyCash Amount in SCNum
20
CredSumSySystem Credit AmountNum
20
CheckSumSyCheck Amount in SCNum
20
TrsfrSumSyTransfer Amount in SCNum
20
NoDocSumSyNon-Invoiced System AmountNum
20
DocTotalSyDocument Total in SCNum
20
ObjTypeObject TypenVarChar
24) Incoming Payment
46) Outgoing Payments
20ADP1
Object Settings - History
StornoRateCancellation RateNum
20
UpdateDateUpdate DateDate
8
CreateDateCreation DateDate
8
ApplyVATTax DefinitionVarChar
Y) Yes
N) No
1
N
TaxDateTax DateDate
8
Series KEYSeriesInt
6NNM1
Documents Numbering - Series
SERIESNo
confirmedApprovedVarChar
Y) Yes
N) No
1
N
ShowJDTDisplay Journal EntriesVarChar
Y) Yes
N) No
1
BankCodeBank Code for Bank TransfernVarChar
30
BankAcctAccount for Bank TransfernVarChar
50
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
B) BSP
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
VatSumTax AmountNum
20
VatSumFCTax Amount (FC)Num
20
VatSumSyTax Amount (SC)Num
20
FinncPriodPosting PeriodInt
11OFPR
Posting Period
VatPrcntTax %Num
20
DcountDiscount %Num
20
DcntSumDiscount AmountNum
20
DcntSumFCDiscount Amount (FC)Num
20
DcntSumSyDiscount Amount (SC)Num
20
SpltCredLnSplit Vendor Credit RowVarChar
Y) Yes
N) No
1
PrjCodeProjectnVarChar
20OPRJ
Project Codes
PaymentRefPayment ReferencenVarChar
27
SubmittedSubmittedVarChar
Y) Yes
N) No
1
N
StatusCreated by Payment RunVarChar
Y) Yes
N) No
C) BoE Canceled
1
N
PayMthPayment MethodnVarChar
15OPYM
Payment Methods for Payment Wizard
BankCountrBank CountrynVarChar
3OCRY
Countries
FreightSumFreight SumNum
20
FreigtFCFreight Sum (FC)Num
20
FreigtSCFreight Sum (SC)Num
20
BoeAccBoe AccountnVarChar
15OACT
G/L Accounts
BoeNumBill of Exchange No.Int
11
BoeSumBill of Exchange AmountNum
20
BoeSumFcBill of Exchange Amount (FC)Num
20
BoeSumScBill of Exchange Amount (SC)Num
20
BoeAgentBill of Exchange AgentnVarChar
32OAGP
Agent Name
BoeStatusBill of Exchange StatusVarChar
1
WtCodeWT CodenVarChar
4OWHT
Withholding Tax
WtSumWT AmountNum
20
WtSumFrgnWT Amount (FC)Num
20
WtSumSysWT Amount (SC)Num
20
WtAccountWT AccountnVarChar
15OACT
G/L Accounts
WtBaseAmntWT Taxable AmountNum
20
ProformaProformaVarChar
Y) Yes
N) No
1
N
BoeAbsBoe KeyInt
11OBOE
Bill of Exchange for Payment
BpActBP AccountnVarChar
15OACT
G/L Accounts
BcgSumBank Charge AmountNum
20
BcgSumFCBank Charge Amount in FCNum
20
BcgSumSyBank Charge Amount in SCNum
20
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
' '
PaPriorityPayment PriorityVarChar
1)
2)
3)
4)
5)
6)
1
6
PayToCodePay tonVarChar
50
IsPaytoBnkIs Pay to BankVarChar
N) No
Y) Yes
1
N
PBnkCntPay to Bank CountrynVarChar
3OCRY
Countries
PBnkCodePay to Bank CodenVarChar
30
PBnkAccntPay to Bank Account No.nVarChar
50
PBnkBranchPay to Bank BranchnVarChar
50
WizDunBlckWizard Dunning BlockVarChar
N) No.
Y) YES
1
N
WtBaseSumWt Base SumNum
20
WtBaseSumFWt Base Sum (FC)Num
20
WtBaseSumSWt Base Sum (SC)Num
20
UndOvDiffUnder/Overpayment DifferenceNum
20
UndOvDiffSUnder/Overpayment Diff. (SC)Num
20
BankActKeyBank Account Internal IDInt
11DSC1
House Bank Accounts
VersionNumVersion NumbernVarChar
11
VatDateTax DateDate
8
TransCodeTransaction CodenVarChar
4OTRC
Journal Entry Codes
PaymTypePayment TypeVarChar
N)
E) Electronic
P) Mail
T) Telegraph
X) Express
1
N
TfrRealAmtTransfer Real AmountNum
20
CancelDateCancelation DateDate
8
OpenBalOpen Balance AmountNum
20
OpenBalFcOpen Balance Amount (FC)Num
20
OpenBalScOpen Balance Amount (SC)Num
20
BcgTaxSumBank Charge Tax AmountNum
20
BcgTaxSumFBank Charge Tax Amount(FC)Num
20
BcgTaxSumSBank Charge Tax Amount(SC)Num
20
TpwIDTax Payment Wizard IDInt
11
0
ChallanNoChallan No.nVarChar
32
ChallanBakChallan Bank NamenVarChar
60
ChallanDatChallan Received DateDate
8
WddStatusAuthorization StatusVarChar
-) Without
W) Pending
Y) Approved
N) Rejected
P) Generated
A) Generated by Authorizer
C) Canceled
1
BcgVatGrpBank Charge Tax GroupnVarChar
8OVTG
Tax Definition
BcgVatPcntBank Charge Tax %Num
20
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
BSRCodeBSR CodenVarChar
25
LocCodeLocation CodeInt
11OLCT
Location
WTOnhldPstWTax On Hold, PostedNum
20
UserSign2Updating UserInt
6OUSR
Users
BuildDescBuild DescriptornVarChar
50
ResidenNumResidence NumberVarChar
1) Spanish Fiscal ID
2) VAT Registration Number
3) Passport
4) Fiscal ID Issued by the Residence Country
5) Certificate of Fiscal Residence
6) Other Document
1
1
OperatCodeOperation CodeVarChar
1
UndOvDiffFUnder/Overpayment Diff. (FC)Num
20
MIEntryMI Entry Include this PaymentInt
11
0
FreeText1Free Text 1nVarChar
100
FreeText2Free Text 2nVarChar
100
FreeText3Free Text 3nVarChar
100
ShowDocNoDisplay Document No.VarChar
Y) Yes
N) No
1
Y
TDSInterstTDS InterestNum
20
0
TDSChargesTDS Other ChargesNum
20
0
CUPUnique Code of ProjectInt
11OCUP
CUP Codes
CIGContract Code IdentificationInt
11OCIG
CIG Codes
MITypeMI Type Include this PaymentnVarChar
270) A/R Monthly Invoice
140000014) A/P Monthly Invoice
20
SupplCodeSupplementary CodenVarChar
127
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VATRegNumVAT Reg. NumbernVarChar
32
BPLCentPmtCentralized PaymentVarChar
N) No
Y) Yes
1
N
DraftKeyPayment Draft Internal IDInt
11OPDF
Payment Draft
TDSFeeTDS FeeNum
20
MinHeadCLMinor Head of ChallanInt
200) TDS Payable by Taxpayer
400) TDS Regular Assessment (Raised by IT Dept)
11
SEPADateRequested SEPA Pmt DateDate
8

Table relationship map

SELECT statement

SELECT OPDF.DocEntry AS 'Numerator', OPDF.DocNum AS 'Document Number', OPDF.DocType AS 'Document Type', OPDF.Canceled AS 'Canceled', OPDF.Handwrtten AS 'Manual Numbering', OPDF.Printed AS 'Printed', OPDF.DocDate AS 'Posting Date', OPDF.DocDueDate AS 'Value Date', OPDF.CardCode AS 'Customer/Vendor Code', OPDF.CardName AS 'Customer/Vendor Name', OPDF.Address AS 'Address', OPDF.DdctPrcnt AS 'Deduction Percent', OPDF.DdctSum AS 'Total Deductions', OPDF.DdctSumFC AS 'Total Deductions in FC', OPDF.CashAcct AS 'Cash Account', OPDF.CashSum AS 'Cash Amount', OPDF.CashSumFC AS 'Cash Amount in FC', OPDF.CreditSum AS 'Credit Amount', OPDF.CredSumFC AS 'Credit Amount in FC', OPDF.CheckAcct AS 'Current Account', OPDF.CheckSum AS 'Check Amount', OPDF.CheckSumFC AS 'Check Amount in FC', OPDF.TrsfrAcct AS 'Transfer Account', OPDF.TrsfrSum AS 'Transfer Amount', OPDF.TrsfrSumFC AS 'Transfer Amount in FC', OPDF.TrsfrDate AS 'Transfer Date', OPDF.TrsfrRef AS 'Intended Purpose', OPDF.PayNoDoc AS 'Non-Calculated Payment', OPDF.NoDocSum AS 'Non-Calculated Amount', OPDF.NoDocSumFC AS 'Non-Calculated Amount in FC', OPDF.DocCurr AS 'Document Currency', OPDF.DiffCurr AS 'Enter in local currency', OPDF.DocRate AS 'Document Rate', OPDF.SysRate AS 'System Price', OPDF.DocTotal AS 'Document Total', OPDF.DocTotalFC AS 'Document Total in FC', OPDF.Ref1 AS 'Reference 1', OPDF.Ref2 AS 'Reference 2', OPDF.CounterRef AS 'Counter Reference', OPDF.Comments AS 'Remarks', OPDF.JrnlMemo AS 'Journal Remarks', OPDF.TransId AS 'Transaction Number', OPDF.DocTime AS 'Generation Time', OPDF.ShowAtCard AS 'Display Customer Ref. No.', OPDF.SpiltTrans AS 'Split Transaction Journal', OPDF.CreateTran AS 'Create Journal Entry', OPDF.Flags AS 'Flags', OPDF.CntctCode AS 'Contact Person', OPDF.DdctSumSy AS 'System Deduction Amount', OPDF.CashSumSy AS 'Cash Amount in SC', OPDF.CredSumSy AS 'System Credit Amount', OPDF.CheckSumSy AS 'Check Amount in SC', OPDF.TrsfrSumSy AS 'Transfer Amount in SC', OPDF.NoDocSumSy AS 'Non-Invoiced System Amount', OPDF.DocTotalSy AS 'Document Total in SC', OPDF.ObjType AS 'Object Type', OPDF.StornoRate AS 'Cancellation Rate', OPDF.UpdateDate AS 'Update Date', OPDF.CreateDate AS 'Creation Date', OPDF.ApplyVAT AS 'Tax Definition', OPDF.TaxDate AS 'Tax Date', OPDF.Series AS 'Series', OPDF.confirmed AS 'Approved', OPDF.ShowJDT AS 'Display Journal Entries', OPDF.BankCode AS 'Bank Code for Bank Transfer', OPDF.BankAcct AS 'Account for Bank Transfer', OPDF.DataSource AS 'Data Source', OPDF.UserSign AS 'User Signature', OPDF.LogInstanc AS 'Log Instance', OPDF.VatGroup AS 'Tax Group', OPDF.VatSum AS 'Tax Amount', OPDF.VatSumFC AS 'Tax Amount (FC)', OPDF.VatSumSy AS 'Tax Amount (SC)', OPDF.FinncPriod AS 'Posting Period', OPDF.VatPrcnt AS 'Tax %', OPDF.Dcount AS 'Discount %', OPDF.DcntSum AS 'Discount Amount', OPDF.DcntSumFC AS 'Discount Amount (FC)', OPDF.DcntSumSy AS 'Discount Amount (SC)', OPDF.SpltCredLn AS 'Split Vendor Credit Row', OPDF.PrjCode AS 'Project', OPDF.PaymentRef AS 'Payment Reference', OPDF.Submitted AS 'Submitted', OPDF.Status AS 'Created by Payment Run', OPDF.PayMth AS 'Payment Method', OPDF.BankCountr AS 'Bank Country', OPDF.FreightSum AS 'Freight Sum', OPDF.FreigtFC AS 'Freight Sum (FC)', OPDF.FreigtSC AS 'Freight Sum (SC)', OPDF.BoeAcc AS 'Boe Account', OPDF.BoeNum AS 'Bill of Exchange No.', OPDF.BoeSum AS 'Bill of Exchange Amount', OPDF.BoeSumFc AS 'Bill of Exchange Amount (FC)', OPDF.BoeSumSc AS 'Bill of Exchange Amount (SC)', OPDF.BoeAgent AS 'Bill of Exchange Agent', OPDF.BoeStatus AS 'Bill of Exchange Status', OPDF.WtCode AS 'WT Code', OPDF.WtSum AS 'WT Amount', OPDF.WtSumFrgn AS 'WT Amount (FC)', OPDF.WtSumSys AS 'WT Amount (SC)', OPDF.WtAccount AS 'WT Account', OPDF.WtBaseAmnt AS 'WT Taxable Amount', OPDF.Proforma AS 'Proforma', OPDF.BoeAbs AS 'Boe Key', OPDF.BpAct AS 'BP Account', OPDF.BcgSum AS 'Bank Charge Amount', OPDF.BcgSumFC AS 'Bank Charge Amount in FC', OPDF.BcgSumSy AS 'Bank Charge Amount in SC', OPDF.PIndicator AS 'Period Indicator', OPDF.PaPriority AS 'Payment Priority', OPDF.PayToCode AS 'Pay to', OPDF.IsPaytoBnk AS 'Is Pay to Bank', OPDF.PBnkCnt AS 'Pay to Bank Country', OPDF.PBnkCode AS 'Pay to Bank Code', OPDF.PBnkAccnt AS 'Pay to Bank Account No.', OPDF.PBnkBranch AS 'Pay to Bank Branch', OPDF.WizDunBlck AS 'Wizard Dunning Block', OPDF.WtBaseSum AS 'Wt Base Sum', OPDF.WtBaseSumF AS 'Wt Base Sum (FC)', OPDF.WtBaseSumS AS 'Wt Base Sum (SC)', OPDF.UndOvDiff AS 'Under/Overpayment Difference', OPDF.UndOvDiffS AS 'Under/Overpayment Diff. (SC)', OPDF.BankActKey AS 'Bank Account Internal ID', OPDF.VersionNum AS 'Version Number', OPDF.VatDate AS 'Tax Date', OPDF.TransCode AS 'Transaction Code', OPDF.PaymType AS 'Payment Type', OPDF.TfrRealAmt AS 'Transfer Real Amount', OPDF.CancelDate AS 'Cancelation Date', OPDF.OpenBal AS 'Open Balance Amount', OPDF.OpenBalFc AS 'Open Balance Amount (FC)', OPDF.OpenBalSc AS 'Open Balance Amount (SC)', OPDF.BcgTaxSum AS 'Bank Charge Tax Amount', OPDF.BcgTaxSumF AS 'Bank Charge Tax Amount(FC)', OPDF.BcgTaxSumS AS 'Bank Charge Tax Amount(SC)', OPDF.TpwID AS 'Tax Payment Wizard ID', OPDF.ChallanNo AS 'Challan No.', OPDF.ChallanBak AS 'Challan Bank Name', OPDF.ChallanDat AS 'Challan Received Date', OPDF.WddStatus AS 'Authorization Status', OPDF.BcgVatGrp AS 'Bank Charge Tax Group', OPDF.BcgVatPcnt AS 'Bank Charge Tax %', OPDF.SeqCode AS 'Sequence Code', OPDF.Serial AS 'Serial Number', OPDF.SeriesStr AS 'Series String', OPDF.SubStr AS 'Subseries String', OPDF.BSRCode AS 'BSR Code', OPDF.LocCode AS 'Location Code', OPDF.WTOnhldPst AS 'WTax On Hold, Posted', OPDF.UserSign2 AS 'Updating User', OPDF.BuildDesc AS 'Build Descriptor', OPDF.ResidenNum AS 'Residence Number', OPDF.OperatCode AS 'Operation Code', OPDF.UndOvDiffF AS 'Under/Overpayment Diff. (FC)', OPDF.MIEntry AS 'MI Entry Include this Payment', OPDF.FreeText1 AS 'Free Text 1', OPDF.FreeText2 AS 'Free Text 2', OPDF.FreeText3 AS 'Free Text 3', OPDF.ShowDocNo AS 'Display Document No.', OPDF.TDSInterst AS 'TDS Interest', OPDF.TDSCharges AS 'TDS Other Charges', OPDF.CUP AS 'Unique Code of Project', OPDF.CIG AS 'Contract Code Identification', OPDF.MIType AS 'MI Type Include this Payment', OPDF.SupplCode AS 'Supplementary Code', OPDF.BPLId AS 'Branch', OPDF.BPLName AS 'Branch Name', OPDF.VATRegNum AS 'VAT Reg. Number', OPDF.BPLCentPmt AS 'Centralized Payment', OPDF.DraftKey AS 'Payment Draft Internal ID', OPDF.TDSFee AS 'TDS Fee', OPDF.MinHeadCL AS 'Minor Head of Challan', OPDF.SEPADate AS 'Requested SEPA Pmt Date' FROM OPDF AS OPDF

Related information


Address Address Property· Table: OPDF
Sets or returns the Bill To address of the business partner.Field name: Address.Length: 254 characters.
· Table: ORCT OPDF OVPM    Parent: Payments Payments Object· Table: ORCT OPDF OVPM
Payment Draft OPDF SQL Table

House Bank Accounts DSC1 SQL Table

Countries OCRY SQL Table

Tax Definition OVTG SQL Table

Bill of Exchange for Payment OBOE SQL Table

G/L Accounts OACT SQL Table

Agent Name OAGP SQL Table

Business Place OBPL SQL Table

CIG Codes OCIG SQL Table

Contact Persons OCPR SQL Table

CUP Codes OCUP SQL Table

Currency Codes OCRN SQL Table

Posting Period OFPR SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Period Indicator OPID SQL Table

Project Codes OPRJ SQL Table

Documents Numbering - Series NNM1 SQL Table

Journal Entry Codes OTRC SQL Table

Journal Entry OJDT SQL Table

Users OUSR SQL Table

Withholding Tax OWHT 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