📚 SAP Business One SDK Help

Table Name: OPDF

Table Description: Payment Draft

Field Description Type Size Related Default Value Constraints
DocEntry Numerator Int 11 -      
DocNum Document Number Int 11 -      
DocType Document Type VarChar 1 -   C Customer
            A Account
            S Vendor
            P P.L.A
            D TDS
Canceled Canceled VarChar 1 -   Y Yes
            N No
            C Cancellation
Handwrtten Manual Numbering VarChar 1 -   Y Yes
            N No
Printed Printed VarChar 1 - N Y Copy
            N Original
DocDate Posting Date Date 8 -      
DocDueDate Value Date Date 8 -      
CardCode Customer/Vendor Code nVarChar 15 OCRD      
CardName Customer/Vendor Name nVarChar 200 -      
Address Address nVarChar 254 -      
DdctPrcnt Deduction Percent Num 19.6 -      
DdctSum Total Deductions Num 19.6 -      
DdctSumFC Total Deductions in FC Num 19.6 -      
CashAcct Cash Account nVarChar 15 OACT      
CashSum Cash Amount Num 19.6 -      
CashSumFC Cash Amount in FC Num 19.6 -      
CreditSum Credit Amount Num 19.6 -      
CredSumFC Credit Amount in FC Num 19.6 -      
CheckAcct Current Account nVarChar 15 OACT      
CheckSum Check Amount Num 19.6 -      
CheckSumFC Check Amount in FC Num 19.6 -      
TrsfrAcct Transfer Account nVarChar 15 OACT      
TrsfrSum Transfer Amount Num 19.6 -      
TrsfrSumFC Transfer Amount in FC Num 19.6 -      
TrsfrDate Transfer Date Date 8 -      
TrsfrRef Intended Purpose nVarChar 27 -      
PayNoDoc Non-Calculated Payment VarChar 1 - N Y Yes
            N No
NoDocSum Non-Calculated Amount Num 19.6 -      
NoDocSumFC Non-Calculated Amount in FC Num 19.6 -      
DocCurr Document Currency nVarChar 3 OCRN      
DiffCurr Enter in local currency VarChar 1 - N N No
            Y Yes
DocRate Document Rate Num 19.6 -      
SysRate System Price Num 19.6 -      
DocTotal Document Total Num 19.6 -      
DocTotalFC Document Total in FC Num 19.6 -      
Ref1 Reference 1 nVarChar 11 -      
Ref2 Reference 2 nVarChar 50 -      
CounterRef Counter Reference nVarChar 50 -      
Comments Remarks nVarChar 254 -      
JrnlMemo Journal Remarks nVarChar 254 -      
TransId Transaction Number Int 11 OJDT      
DocTime Generation Time Int 6 -      
ShowAtCard Display Customer Ref. No. VarChar 1 - N Y Yes
            N No
SpiltTrans Split Transaction Journal VarChar 1 - N Y Yes
            N No
CreateTran Create Journal Entry VarChar 1 - Y Y Yes
            N No
Flags Flags Int 11 - 0    
CntctCode Contact Person Int 11 OCPR      
DdctSumSy System Deduction Amount Num 19.6 -      
CashSumSy Cash Amount in SC Num 19.6 -      
CredSumSy System Credit Amount Num 19.6 -      
CheckSumSy Check Amount in SC Num 19.6 -      
TrsfrSumSy Transfer Amount in SC Num 19.6 -      
NoDocSumSy Non-Invoiced System Amount Num 19.6 -      
DocTotalSy Document Total in SC Num 19.6 -      
ObjType Object Type nVarChar 20 ADP1   24 Incoming Payment
            46 Outgoing Payments
StornoRate Cancellation Rate Num 19.6 -      
UpdateDate Update Date Date 8 -      
CreateDate Creation Date Date 8 -      
ApplyVAT Tax Definition VarChar 1 - N Y Yes
            N No
TaxDate Tax Date Date 8 -      
Series Series Int 11 NNM1      
confirmed Approved VarChar 1 - N Y Yes
            N No
ShowJDT Display Journal Entries VarChar 1 -   Y Yes
            N No
BankCode Bank Code for Bank Transfer nVarChar 30 -      
BankAcct Account for Bank Transfer nVarChar 50 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
            B BSP
UserSign User Signature Int 6 OUSR      
LogInstanc Log Instance Int 11 - 0    
VatGroup Tax Group nVarChar 8 OVTG      
VatSum Tax Amount Num 19.6 -      
VatSumFC Tax Amount (FC) Num 19.6 -      
VatSumSy Tax Amount (SC) Num 19.6 -      
FinncPriod Posting Period Int 11 OFPR      
VatPrcnt Tax % Num 19.6 -      
Dcount Discount % Num 19.6 -      
DcntSum Discount Amount Num 19.6 -      
DcntSumFC Discount Amount (FC) Num 19.6 -      
DcntSumSy Discount Amount (SC) Num 19.6 -      
SpltCredLn Split Vendor Credit Row VarChar 1 -   Y Yes
            N No
PrjCode Project nVarChar 20 OPRJ      
PaymentRef Payment Reference nVarChar 27 -      
Submitted Submitted VarChar 1 - N Y Yes
            N No
Status Created by Payment Run VarChar 1 - N Y Yes
            N No
            C BoE Canceled
PayMth Payment Method nVarChar 15 OPYM      
BankCountr Bank Country/Region nVarChar 3 OCRY      
FreightSum Freight Sum Num 19.6 -      
FreigtFC Freight Sum (FC) Num 19.6 -      
FreigtSC Freight Sum (SC) Num 19.6 -      
BoeAcc Boe Account nVarChar 15 OACT      
BoeNum Bill of Exchange No. Int 11 -      
BoeSum Bill of Exchange Amount Num 19.6 -      
BoeSumFc Bill of Exchange Amount (FC) Num 19.6 -      
BoeSumSc Bill of Exchange Amount (SC) Num 19.6 -      
BoeAgent Bill of Exchange Agent nVarChar 32 OAGP      
BoeStatus Bill of Exchange Status VarChar 1 -      
WtCode WT Code nVarChar 4 OWHT      
WtSum WT Amount Num 19.6 -      
WtSumFrgn WT Amount (FC) Num 19.6 -      
WtSumSys WT Amount (SC) Num 19.6 -      
WtAccount WT Account nVarChar 15 OACT      
WtBaseAmnt WT Taxable Amount Num 19.6 -      
Proforma Proforma VarChar 1 - N Y Yes
            N No
BoeAbs Boe Key Int 11 OBOE      
BpAct BP Account nVarChar 15 OACT      
BcgSum Bank Charge Amount Num 19.6 -      
BcgSumFC Bank Charge Amount in FC Num 19.6 -      
BcgSumSy Bank Charge Amount in SC Num 19.6 -      
PIndicator Period Indicator nVarChar 10 OPID ' '    
PaPriority Payment Priority VarChar 1 - 6 1  
            2  
            3  
            4  
            5  
            6  
PayToCode Pay To nVarChar 50 -      
IsPaytoBnk Is Pay to Bank VarChar 1 - N N No
            Y Yes
PBnkCnt Pay to Bank Country/Region nVarChar 3 OCRY      
PBnkCode Pay to Bank Code nVarChar 30 -      
PBnkAccnt Pay to Bank Account No. nVarChar 50 -      
PBnkBranch Pay to Bank Branch nVarChar 50 -      
WizDunBlck Wizard Dunning Block VarChar 1 - N N No.
            Y YES
WtBaseSum Wt Base Sum Num 19.6 -      
WtBaseSumF Wt Base Sum (FC) Num 19.6 -      
WtBaseSumS Wt Base Sum (SC) Num 19.6 -      
UndOvDiff Under/Overpayment Difference Num 19.6 -      
UndOvDiffS Under/Overpayment Diff. (SC) Num 19.6 -      
BankActKey Bank Account Internal ID Int 11 DSC1      
VersionNum Version Number nVarChar 13 -      
VatDate Tax Date Date 8 -      
TransCode Transaction Code nVarChar 4 OTRC      
PaymType Payment Type VarChar 1 - N N  
            E Electronic
            P Mail
            T Telegraph
            X Express
TfrRealAmt Transfer Real Amount Num 19.6 -      
CancelDate Cancelation Date Date 8 -      
OpenBal Open Balance Amount Num 19.6 -      
OpenBalFc Open Balance Amount (FC) Num 19.6 -      
OpenBalSc Open Balance Amount (SC) Num 19.6 -      
BcgTaxSum Bank Charge Tax Amount Num 19.6 -      
BcgTaxSumF Bank Charge Tax Amount(FC) Num 19.6 -      
BcgTaxSumS Bank Charge Tax Amount(SC) Num 19.6 -      
TpwID Tax Payment Wizard ID Int 11 - 0    
ChallanNo Challan No. nVarChar 32 -      
ChallanBak Challan Bank Name nVarChar 60 -      
ChallanDat Challan Received Date Date 8 -      
WddStatus Authorization Status VarChar 1 - - - Without
            W Pending
            Y Approved
            N Rejected
            P Generated
            A Generated by Authorizer
            C Canceled
BcgVatGrp Bank Charge Tax Group nVarChar 8 OVTG      
BcgVatPcnt Bank Charge Tax % Num 19.6 -      
SeqCode Sequence Code Int 6 -      
Serial Serial Number Int 11 -      
SeriesStr Series String nVarChar 3 -      
SubStr Subseries String nVarChar 3 -      
BSRCode BSR Code nVarChar 25 -      
LocCode Location Code Int 11 OLCT      
WTOnhldPst WTax On Hold, Posted Num 19.6 -      
UserSign2 Updating User Int 6 OUSR      
BuildDesc Build Descriptor nVarChar 50 -      
ResidenNum Residence Number VarChar 1 - 1 1 Spanish Fiscal ID
            2 VAT Registration Number
            3 Passport
            4 Fiscal ID Issued by the Residence Country/Region
            5 Certificate of Fiscal Residence
            6 Other Document
OperatCode Operation Code VarChar 1 -      
            A Summary Invoices Entry
            B Summary Receipts Entry
            C Invoice with Several VAT Rates
            D Correction Invoice
            E Due VAT Pending Invoice Issuance
            F Expenses Incurred by Travel Agent for Customers
            G Special Regulation for VAT Group
            H Special Regulation for Gold Investment
            I Reverse Charge Procedure
            J Unsummarized Receipts
            K Identification of Error Transactions
            X Transactions with Entrepreneurs Issuing Receipts for Agricultural Compensation
            N Service Invoicing by Travel Agencies on Behalf of Third Parties
            R Business Office Rental
            S Subsidies
            T Incoming Payments for Industrial and Intellectual Property Rights
            U Insurance Transactions
            V Purchases from Travel Agencies
            W Transactions Subject to Production, Service and Import Taxes in Ceuta and Melilla
UndOvDiffF Under/Overpayment Diff. (FC) Num 19.6 -      
MIEntry MI Entry Include this Payment Int 11 - 0    
FreeText1 Free Text 1 nVarChar 254 -      
FreeText2 Free Text 2 nVarChar 254 -      
FreeText3 Free Text 3 nVarChar 254 -      
ShowDocNo Display Document No. VarChar 1 - Y Y Yes
            N No
TDSInterst TDS Interest Num 19.6 - 0    
TDSCharges TDS Other Charges Num 19.6 - 0    
CUP Unique Code of Project Int 11 OCUP      
CIG Contract Code Identification Int 11 OCIG      
MIType MI Type Include this Payment nVarChar 20 -   270 A/R Monthly Invoice
            140000014 A/P Monthly Invoice
SupplCode Supplementary Code nVarChar 254 -      
BPLId Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
VATRegNum VAT Reg. Number nVarChar 32 -      
BPLCentPmt Centralized Payment VarChar 1 - N N No
            Y Yes
DraftKey Payment Draft Internal ID Int 11 OPDF      
TDSFee TDS Fee Num 19.6 -      
MinHeadCL Minor Head of Challan Int 11 -   200 TDS Payable by Taxpayer
            400 TDS Regular Assessment (Raised by IT Dept)
SEPADate Requested SEPA Pmt Date Date 8 -      
OwnerCode Payment Owner Int 11 OHEM      
AgrNo Agreement No. Int 11 OOAT      
CreateTS Create Time - Incl. Secs Int 11 -      
UpdateTS Update Full Time Int 11 -      
TDSType TDS Type VarChar 1 -   E eTDS
            D GST TDS
            C GST TCS
DrNo Dr. No. nVarChar 32 -      
PmntWTCert Payment by WT Certificate Only VarChar 1 - N Y Yes
            N No
EnPBnkAcct Encryption of Pay to Bank Acct Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
PriceMode Price Mode VarChar 1 -   N Net
            G Gross
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
EnblDpmTax Enable Tax Calculation in Down Payment Invoices VarChar 1 - N Y Yes
            N No
SignMsg Signature Input Message Text 16 -      
SignDigest Signature Digest Text 16 -      
CertifNum Certification Number nVarChar 50 -      
KeyVersion Private Key Version Int 11 -      
QRCodeSPGn QR Code Source Generated from Stored Procedure Text 16 -      
DataVers Data Version Int 11 - 1    
EDocExpFrm Electronic Doc. Export Format Int 11 -      
ElCoStatus Elec. Comm. Status nVarChar 10 -   0 Approved
            1 Pending Approval
            2 Rejected
ElCoMsg Elec. Comm. Message nVarChar 254 -      
DigPayment Digital Payments VarChar 1 - N Y Yes
            N No
AllocNum Allocation Number nVarChar 50 -      
BaseType Base Document Type Int 11 - -1 24 Incoming Payment
            46 Outgoing Payment
BaseEntry Base Document Internal ID Int 11 -      
Key Unique Field
PRIMARY Yes DocEntry
NUM No DocNum
    PIndicator
CARD No CardCode
HANDWRITEN No Handwrtten
CANCELED No Canceled
SERIES No Series