|
|
DTW Outgoing Payments
API Payments / Address
OVPM - Outgoing Payments Table
Address Address Property· Table: OVPM
Parent: Payments Payments Object· Table: ORCT OPDF OVPM
OVPM 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
Payment Draft OPDF 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocNum KEY UNIQUE | Document Number | Int | 11 | NUM | Yes | |||
| DocType | Document Type | VarChar | C) Customer A) Account S) Vendor P) P.L.A T) Tax D) TDS | 1 | S | |||
| Canceled KEY | Canceled | VarChar | Y) Yes N) No | 1 | N | CANCELED | No | |
| Handwrtten KEY | Manual Numbering | VarChar | Y) Yes N) No | 1 | N | HANDWRITEN | No | |
| Printed | Printed | VarChar | Y) Copy N) Original | 1 | N | |||
| DocDate | Posting Date | Date | 8 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| CardCode KEY | Customer/Vendor Code | nVarChar | 15 | CARD | No | |||
| CardName | Customer/Vendor Name | nVarChar | 100 | |||||
| Address | Address | nVarChar | 127 | |||||
| DdctPrcnt | Deduction Percent | Num | 20 | |||||
| DdctSum | Total Deductions | Num | 20 | |||||
| DdctSumFC | Total Deductions (FC) | Num | 20 | |||||
| CashAcct | Cash Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CashSum | Cash Amount | Num | 20 | |||||
| CashSumFC | Cash Amount (FC) | Num | 20 | |||||
| CreditSum | Credit Amount | Num | 20 | |||||
| CredSumFC | Credit Amount (FC) | Num | 20 | |||||
| CheckAcct | Current Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CheckSum | Check Amount | Num | 20 | |||||
| CheckSumFC | Check Amount (FC) | Num | 20 | |||||
| TrsfrAcct | Transfer Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TrsfrSum | Transfer Amount | Num | 20 | |||||
| TrsfrSumFC | Transfer Amount (FC) | Num | 20 | |||||
| TrsfrDate | Transfer Date | Date | 8 | |||||
| TrsfrRef | Intended Purpose | nVarChar | 27 | |||||
| PayNoDoc | Non-Calculated Payment | VarChar | Y) Yes N) No | 1 | N | |||
| NoDocSum | Non-Calculated Amount | Num | 20 | |||||
| NoDocSumFC | Non-Calculated Amount (FC) | Num | 20 | |||||
| DocCurr | Document Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| DiffCurr | Enter in local currency | VarChar | N) No Y) Yes | 1 | N | |||
| DocRate | Document Rate | Num | 20 | |||||
| SysRate | System Price | Num | 20 | |||||
| DocTotal | Document Total | Num | 20 | |||||
| DocTotalFC | Document Total (FC) | Num | 20 | |||||
| Ref1 | Reference 1 | nVarChar | 8 | |||||
| Ref2 | Reference 2 | nVarChar | 8 | |||||
| CounterRef | Counter Reference | nVarChar | 8 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| DocTime | Generation Time | Int | 6 | |||||
| ShowAtCard | Display Vendor Ref. No. | VarChar | Y) Yes N) No | 1 | N | |||
| SpiltTrans | Split Transaction Journal | VarChar | Y) Yes N) No | 1 | N | |||
| CreateTran | Create Journal Entry | VarChar | Y) Yes N) No | 1 | Y | |||
| Flags | Flags | Int | 11 | 0 | ||||
| CntctCode | Contact Person | Int | 11 | OCPR Contact Persons | ||||
| DdctSumSy | System Deduction Amount | Num | 20 | |||||
| CashSumSy | Cash Amount (SC) | Num | 20 | |||||
| CredSumSy | System Credit Amount | Num | 20 | |||||
| CheckSumSy | Check Amount (SC) | Num | 20 | |||||
| TrsfrSumSy | Transfer Amount (SC) | Num | 20 | |||||
| NoDocSumSy | Non-Invoiced System Amount | Num | 20 | |||||
| DocTotalSy | Document Total (SC) | Num | 20 | |||||
| ObjType | Object Type | nVarChar | 46) Outgoing Payments | 20 | ADP1 Object Settings - History | 46 | ||
| StornoRate | Cancellation Rate | Num | 20 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| ApplyVAT | Tax Definition | VarChar | Y) Yes N) No | 1 | N | |||
| TaxDate | Document Date | Date | 8 | |||||
| Series KEY | Series | Int | 6 | NNM1 Documents Numbering - Series | SERIES | No | ||
| confirmed | Approved | VarChar | Y) Yes N) No | 1 | N | |||
| ShowJDT | Display Journal Entries | VarChar | Y) Yes N) No | 1 | N | |||
| BankCode | Bank Code for Bank Transfer | nVarChar | 30 | |||||
| BankAcct | Account for Bank Transfer | nVarChar | 50 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| VatSum | Tax Amount | Num | 20 | |||||
| VatSumFC | Tax Amount (FC) | Num | 20 | |||||
| VatSumSy | Tax Amount (SC) | Num | 20 | |||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| VatPrcnt | Tax % | Num | 20 | |||||
| Dcount | Discount % | Num | 20 | |||||
| DcntSum | Discount Amount | Num | 20 | |||||
| DcntSumFC | Discount Amount (FC) | Num | 20 | |||||
| DcntSumSy | Discount Amount (SC) | Num | 20 | |||||
| SpltCredLn | Split Vendor Credit Row | VarChar | Y) Yes N) No | 1 | N | |||
| PrjCode | Project | nVarChar | 20 | OPRJ Project Codes | ||||
| PaymentRef | Payment Reference No. | nVarChar | 27 | |||||
| Submitted | Submitted | VarChar | Y) Yes N) No | 1 | N | |||
| Status | Created by Payment Run | VarChar | Y) Yes N) No C) BoE Canceled | 1 | N | |||
| PayMth | Payment Method | nVarChar | 15 | OPYM Payment Methods for Payment Wizard | ||||
| BankCountr | Bank Country | nVarChar | 3 | OCRY Countries | ||||
| FreightSum | Freight Sum | Num | 20 | |||||
| FreigtFC | Freight Sum (FC) | Num | 20 | |||||
| FreigtSC | Freight Sum (SC) | Num | 20 | |||||
| BoeAcc | Boe Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BoeNum | Bill of Exchange No. | Int | 11 | |||||
| BoeSum | Bill of Exchange Amount | Num | 20 | |||||
| BoeSumFc | Bill of Exchange Amount (FC) | Num | 20 | |||||
| BoeSumSc | Bill of Exchange Amount (SC) | Num | 20 | |||||
| BoeAgent | Bill of Exchange Agent | nVarChar | 32 | OAGP Agent Name | ||||
| BoeStatus | Bill of Exchange Status | VarChar | 1 | |||||
| WtCode | WTax Code | nVarChar | 4 | OWHT Withholding Tax | ||||
| WtSum | WTax Amount | Num | 20 | |||||
| WtSumFrgn | WTax Amount (FC) | Num | 20 | |||||
| WtSumSys | WTax Amount (SC) | Num | 20 | |||||
| WtAccount | WTax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WtBaseAmnt | WTax Taxable Amount | Num | 20 | |||||
| Proforma | Proforma | VarChar | Y) Yes N) No | 1 | N | |||
| BoeAbs | Boe Key | Int | 11 | OBOE Bill of Exchange for Payment | ||||
| BpAct | BP Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BcgSum | Bank Charges Amount | Num | 20 | |||||
| BcgSumFC | Bank Charges Amount (FC) | Num | 20 | |||||
| BcgSumSy | Bank Charges Amount (SC) | Num | 20 | |||||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ' ' | |||
| PaPriority | Payment Priority | VarChar | 1) 2) 3) 4) 5) 6) | 1 | 6 | |||
| PayToCode | Pay To | nVarChar | 50 | |||||
| IsPaytoBnk | Is Pay to Bank | VarChar | N) No Y) Yes | 1 | N | |||
| PBnkCnt | Pay to Bank Country | nVarChar | 3 | OCRY Countries | ||||
| 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 | N) No Y) Yes | 1 | N | |||
| WtBaseSum | WTax Base Sum | Num | 20 | |||||
| WtBaseSumF | WTax Base Sum (FC) | Num | 20 | |||||
| WtBaseSumS | WTax Base Sum (SC) | Num | 20 | |||||
| UndOvDiff | Under/Overpayment Difference | Num | 20 | |||||
| UndOvDiffS | Under/Overpayment Diff. (SC) | Num | 20 | |||||
| BankActKey | Bank Account No. | Int | 11 | DSC1 House Bank Accounts | ||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| VatDate | VAT Date | Date | 8 | |||||
| TransCode | Transaction Code | nVarChar | 4 | OTRC Journal Entry Codes | ||||
| PaymType | Payment Type | VarChar | N) E) Electronic P) Mail T) Telegraph X) Express | 1 | N | |||
| TfrRealAmt | Transfer Real Amount | Num | 20 | |||||
| CancelDate | Cancelation Date | Date | 8 | |||||
| OpenBal | Open Balance Amount | Num | 20 | |||||
| OpenBalFc | Open Balance Amount (FC) | Num | 20 | |||||
| OpenBalSc | Open Balance Amount (SC) | Num | 20 | |||||
| BcgTaxSum | Bank Charge Tax Amount | Num | 20 | |||||
| BcgTaxSumF | Bank Charge Tax Amount(FC) | Num | 20 | |||||
| BcgTaxSumS | Bank Charge Tax Amount(SC) | Num | 20 | |||||
| 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 | -) Without W) Pending Y) Approved N) Rejected P) Generated A) Generated by Authorizer C) Canceled | 1 | ||||
| BcgVatGrp | Bank Charge Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| BcgVatPcnt | Bank Charge Tax % | Num | 20 | |||||
| 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 Location | ||||
| WTOnhldPst | WTax On Hold, Posted | Num | 20 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| BuildDesc | Build Descriptor | nVarChar | 50 | |||||
| ResidenNum | Residence Number | VarChar | 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 | |||
| OperatCode | Operation Code | VarChar | 1 | |||||
| UndOvDiffF | Under/Overpayment Diff. (FC) | Num | 20 | |||||
| MIEntry | MI Entry Include this Payment | Int | 11 | 0 | ||||
| FreeText1 | Free Text 1 | nVarChar | 100 | |||||
| FreeText2 | Free Text 2 | nVarChar | 100 | |||||
| FreeText3 | Free Text 3 | nVarChar | 100 | |||||
| ShowDocNo | Display Document No. | VarChar | Y) Yes N) No | 1 | Y | |||
| TDSInterst | TDS Interest | Num | 20 | |||||
| TDSCharges | TDS Other Charges | Num | 20 | |||||
| CUP | Unique Code of Project | Int | 11 | OCUP CUP Codes | ||||
| CIG | Contract Code Identification | Int | 11 | OCIG CIG Codes | ||||
| MIType | MI Type Include this Payment | nVarChar | 270) A/R Monthly Invoice 140000014) A/P Monthly Invoice | 20 | ||||
| SupplCode | Supplementary Code | nVarChar | 127 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VATRegNum | VAT Reg. Number | nVarChar | 32 | |||||
| BPLCentPmt | Centralized Payment | VarChar | N) No Y) Yes | 1 | N | |||
| DraftKey | Payment Draft Internal ID | Int | 11 | OPDF Payment Draft | ||||
| TDSFee | TDS Fee | Num | 20 | |||||
| MinHeadCL | Minor Head of Challan | Int | 200) TDS Payable by Taxpayer 400) TDS Regular Assessment (Raised by IT Dept) | 11 | ||||
| SEPADate | Requested SEPA Pmt Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
OVPM.DocEntry AS 'Internal Number',
OVPM.DocNum AS 'Document Number',
OVPM.DocType AS 'Document Type',
OVPM.Canceled AS 'Canceled',
OVPM.Handwrtten AS 'Manual Numbering',
OVPM.Printed AS 'Printed',
OVPM.DocDate AS 'Posting Date',
OVPM.DocDueDate AS 'Due Date',
OVPM.CardCode AS 'Customer/Vendor Code',
OVPM.CardName AS 'Customer/Vendor Name',
OVPM.Address AS 'Address',
OVPM.DdctPrcnt AS 'Deduction Percent',
OVPM.DdctSum AS 'Total Deductions',
OVPM.DdctSumFC AS 'Total Deductions (FC)',
OVPM.CashAcct AS 'Cash Account',
OVPM.CashSum AS 'Cash Amount',
OVPM.CashSumFC AS 'Cash Amount (FC)',
OVPM.CreditSum AS 'Credit Amount',
OVPM.CredSumFC AS 'Credit Amount (FC)',
OVPM.CheckAcct AS 'Current Account',
OVPM.CheckSum AS 'Check Amount',
OVPM.CheckSumFC AS 'Check Amount (FC)',
OVPM.TrsfrAcct AS 'Transfer Account',
OVPM.TrsfrSum AS 'Transfer Amount',
OVPM.TrsfrSumFC AS 'Transfer Amount (FC)',
OVPM.TrsfrDate AS 'Transfer Date',
OVPM.TrsfrRef AS 'Intended Purpose',
OVPM.PayNoDoc AS 'Non-Calculated Payment',
OVPM.NoDocSum AS 'Non-Calculated Amount',
OVPM.NoDocSumFC AS 'Non-Calculated Amount (FC)',
OVPM.DocCurr AS 'Document Currency',
OVPM.DiffCurr AS 'Enter in local currency',
OVPM.DocRate AS 'Document Rate',
OVPM.SysRate AS 'System Price',
OVPM.DocTotal AS 'Document Total',
OVPM.DocTotalFC AS 'Document Total (FC)',
OVPM.Ref1 AS 'Reference 1',
OVPM.Ref2 AS 'Reference 2',
OVPM.CounterRef AS 'Counter Reference',
OVPM.Comments AS 'Remarks',
OVPM.JrnlMemo AS 'Journal Remarks',
OVPM.TransId AS 'Transaction Number',
OVPM.DocTime AS 'Generation Time',
OVPM.ShowAtCard AS 'Display Vendor Ref. No.',
OVPM.SpiltTrans AS 'Split Transaction Journal',
OVPM.CreateTran AS 'Create Journal Entry',
OVPM.Flags AS 'Flags',
OVPM.CntctCode AS 'Contact Person',
OVPM.DdctSumSy AS 'System Deduction Amount',
OVPM.CashSumSy AS 'Cash Amount (SC)',
OVPM.CredSumSy AS 'System Credit Amount',
OVPM.CheckSumSy AS 'Check Amount (SC)',
OVPM.TrsfrSumSy AS 'Transfer Amount (SC)',
OVPM.NoDocSumSy AS 'Non-Invoiced System Amount',
OVPM.DocTotalSy AS 'Document Total (SC)',
OVPM.ObjType AS 'Object Type',
OVPM.StornoRate AS 'Cancellation Rate',
OVPM.UpdateDate AS 'Date of Update',
OVPM.CreateDate AS 'Creation Date',
OVPM.ApplyVAT AS 'Tax Definition',
OVPM.TaxDate AS 'Document Date',
OVPM.Series AS 'Series',
OVPM.confirmed AS 'Approved',
OVPM.ShowJDT AS 'Display Journal Entries',
OVPM.BankCode AS 'Bank Code for Bank Transfer',
OVPM.BankAcct AS 'Account for Bank Transfer',
OVPM.DataSource AS 'Data Source',
OVPM.UserSign AS 'User Signature',
OVPM.LogInstanc AS 'Log Instance',
OVPM.VatGroup AS 'Tax Group',
OVPM.VatSum AS 'Tax Amount',
OVPM.VatSumFC AS 'Tax Amount (FC)',
OVPM.VatSumSy AS 'Tax Amount (SC)',
OVPM.FinncPriod AS 'Posting Period',
OVPM.VatPrcnt AS 'Tax %',
OVPM.Dcount AS 'Discount %',
OVPM.DcntSum AS 'Discount Amount',
OVPM.DcntSumFC AS 'Discount Amount (FC)',
OVPM.DcntSumSy AS 'Discount Amount (SC)',
OVPM.SpltCredLn AS 'Split Vendor Credit Row',
OVPM.PrjCode AS 'Project',
OVPM.PaymentRef AS 'Payment Reference No.',
OVPM.Submitted AS 'Submitted',
OVPM.Status AS 'Created by Payment Run',
OVPM.PayMth AS 'Payment Method',
OVPM.BankCountr AS 'Bank Country',
OVPM.FreightSum AS 'Freight Sum',
OVPM.FreigtFC AS 'Freight Sum (FC)',
OVPM.FreigtSC AS 'Freight Sum (SC)',
OVPM.BoeAcc AS 'Boe Account',
OVPM.BoeNum AS 'Bill of Exchange No.',
OVPM.BoeSum AS 'Bill of Exchange Amount',
OVPM.BoeSumFc AS 'Bill of Exchange Amount (FC)',
OVPM.BoeSumSc AS 'Bill of Exchange Amount (SC)',
OVPM.BoeAgent AS 'Bill of Exchange Agent',
OVPM.BoeStatus AS 'Bill of Exchange Status',
OVPM.WtCode AS 'WTax Code',
OVPM.WtSum AS 'WTax Amount',
OVPM.WtSumFrgn AS 'WTax Amount (FC)',
OVPM.WtSumSys AS 'WTax Amount (SC)',
OVPM.WtAccount AS 'WTax Account',
OVPM.WtBaseAmnt AS 'WTax Taxable Amount',
OVPM.Proforma AS 'Proforma',
OVPM.BoeAbs AS 'Boe Key',
OVPM.BpAct AS 'BP Account',
OVPM.BcgSum AS 'Bank Charges Amount',
OVPM.BcgSumFC AS 'Bank Charges Amount (FC)',
OVPM.BcgSumSy AS 'Bank Charges Amount (SC)',
OVPM.PIndicator AS 'Period Indicator',
OVPM.PaPriority AS 'Payment Priority',
OVPM.PayToCode AS 'Pay To',
OVPM.IsPaytoBnk AS 'Is Pay to Bank',
OVPM.PBnkCnt AS 'Pay to Bank Country',
OVPM.PBnkCode AS 'Pay to Bank Code',
OVPM.PBnkAccnt AS 'Pay to Bank Account No.',
OVPM.PBnkBranch AS 'Pay to Bank Branch',
OVPM.WizDunBlck AS 'Wizard Dunning Block',
OVPM.WtBaseSum AS 'WTax Base Sum',
OVPM.WtBaseSumF AS 'WTax Base Sum (FC)',
OVPM.WtBaseSumS AS 'WTax Base Sum (SC)',
OVPM.UndOvDiff AS 'Under/Overpayment Difference',
OVPM.UndOvDiffS AS 'Under/Overpayment Diff. (SC)',
OVPM.BankActKey AS 'Bank Account No.',
OVPM.VersionNum AS 'Version Number',
OVPM.VatDate AS 'VAT Date',
OVPM.TransCode AS 'Transaction Code',
OVPM.PaymType AS 'Payment Type',
OVPM.TfrRealAmt AS 'Transfer Real Amount',
OVPM.CancelDate AS 'Cancelation Date',
OVPM.OpenBal AS 'Open Balance Amount',
OVPM.OpenBalFc AS 'Open Balance Amount (FC)',
OVPM.OpenBalSc AS 'Open Balance Amount (SC)',
OVPM.BcgTaxSum AS 'Bank Charge Tax Amount',
OVPM.BcgTaxSumF AS 'Bank Charge Tax Amount(FC)',
OVPM.BcgTaxSumS AS 'Bank Charge Tax Amount(SC)',
OVPM.TpwID AS 'Tax Payment Wizard ID',
OVPM.ChallanNo AS 'Challan No.',
OVPM.ChallanBak AS 'Challan Bank Name',
OVPM.ChallanDat AS 'Challan Received Date',
OVPM.WddStatus AS 'Authorization Status',
OVPM.BcgVatGrp AS 'Bank Charge Tax Group',
OVPM.BcgVatPcnt AS 'Bank Charge Tax %',
OVPM.SeqCode AS 'Sequence Code',
OVPM.Serial AS 'Serial Number',
OVPM.SeriesStr AS 'Series String',
OVPM.SubStr AS 'Subseries String',
OVPM.BSRCode AS 'BSR Code',
OVPM.LocCode AS 'Location Code',
OVPM.WTOnhldPst AS 'WTax On Hold, Posted',
OVPM.UserSign2 AS 'Updating User',
OVPM.BuildDesc AS 'Build Descriptor',
OVPM.ResidenNum AS 'Residence Number',
OVPM.OperatCode AS 'Operation Code',
OVPM.UndOvDiffF AS 'Under/Overpayment Diff. (FC)',
OVPM.MIEntry AS 'MI Entry Include this Payment',
OVPM.FreeText1 AS 'Free Text 1',
OVPM.FreeText2 AS 'Free Text 2',
OVPM.FreeText3 AS 'Free Text 3',
OVPM.ShowDocNo AS 'Display Document No.',
OVPM.TDSInterst AS 'TDS Interest',
OVPM.TDSCharges AS 'TDS Other Charges',
OVPM.CUP AS 'Unique Code of Project',
OVPM.CIG AS 'Contract Code Identification',
OVPM.MIType AS 'MI Type Include this Payment',
OVPM.SupplCode AS 'Supplementary Code',
OVPM.BPLId AS 'Branch',
OVPM.BPLName AS 'Branch Name',
OVPM.VATRegNum AS 'VAT Reg. Number',
OVPM.BPLCentPmt AS 'Centralized Payment',
OVPM.DraftKey AS 'Payment Draft Internal ID',
OVPM.TDSFee AS 'TDS Fee',
OVPM.MinHeadCL AS 'Minor Head of Challan',
OVPM.SEPADate AS 'Requested SEPA Pmt Date'
FROM OVPM AS OVPM
Related information
Address Address Property· Table: OVPM
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 OVPM 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
Payment Draft OPDF 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
Payments
Property
Address
Enumeration
Method
Object
BillOfExchange OBOE
Payments_Accounts RCT4, PDF4, VPM4
Payments_Checks RCT1, PDF1, VPM1
Payments_CreditCards RCT3, PDF3, VPM3
Payments_Invoices RCT2, PDF2, VPM2
Property
Address
DTW DB
ApplyVAT
DTW DB
BankAccount
DTW DB
BankChargeAmount
DTW DB
BankChargeAmountInSC
DTW DB
BankCode
DTW DB
BillOfExchangeAgent
DTW DB
BillOfExchangeAmount
DTW DB
BillofExchangeStatus
DTW DB
BoeAccount
DTW DB
CardCode
DTW DB
CardName
DTW DB
CashAccount
DTW DB
CashSum
DTW DB
CashSumFC
DB
CashSumSys
DB
CheckAccount
DTW DB
ContactPersonCode
DTW DB
ControlAccount
DTW DB
CounterReference
DTW DB
DeductionPercent
DTW DB
DeductionSum
DTW DB
DocCurrency
DTW DB
DocDate
DTW DB
DocEntry
DB
DocNum
DTW DB
DocObjectCode
DTW DB
DocRate
DTW DB
DocType
DTW DB
DocTypte
DTW DB
DueDate
DTW DB
HandWritten
DTW DB
IsPayToBank
DTW DB
JournalRemarks
DTW DB
LocalCurrency
DTW DB
LocationCode
DTW DB
PaymentPriority
DTW DB
PaymentType
DTW DB
PayToBankAccountNo
DTW DB
PayToBankBranch
DTW DB
PayToBankCode
DTW DB
PayToBankCountry
DTW DB
PayToCode
DTW DB
Printed
DTW DB
Proforma
DTW DB
ProjectCode
DTW DB
Reference1
DTW DB
Reference2
DTW DB
Remarks
DTW DB
Series
DTW DB
TaxDate
DTW DB
TaxGroup
DTW DB
TransactionCode
DTW DB
TransferAccount
DTW DB
TransferDate
DTW DB
TransferRealAmount
DTW DB
TransferReference
DTW DB
TransferSum
DTW DB
VatDate
DTW DB
WTAccount
DB
WTAmount
DTW DB
WTAmountFC
DB
WTAmountSC
DB
WtBaseSum
DTW DB
WtBaseSumFC
DB
WtBaseSumSC
DB
WTCode
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
