| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Outgoing Payments - Check Rows API Payments Checks / Accountt Num | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VPM1 - Outgoing Payments - Check Rows Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
VPM1.DocNum AS 'Document Number',
VPM1.LineID AS 'Row Number',
VPM1.DueDate AS 'Check Date',
VPM1.CheckNum AS 'Check Number',
VPM1.BankCode AS 'Account No.',
VPM1.Branch AS 'Branch Number',
VPM1.AcctNum AS 'Account Number',
VPM1.Details AS 'Details',
VPM1.Trnsfrable AS 'Negotiable',
VPM1.CheckSum AS 'Check Amount',
VPM1.Currency AS 'Check Currency',
VPM1.Flags AS 'Flags',
VPM1.ObjType AS 'Object Type',
VPM1.LogInstanc AS 'Log Instance',
VPM1.CountryCod AS 'Country Code',
VPM1.CheckAct AS 'Checking Account',
VPM1.CheckAbs AS 'Internal Check Number',
VPM1.BnkActKey AS 'Bank Account No.',
VPM1.ManualChk AS 'Manual Check'
FROM VPM1 AS VPM1 Related informationAccountt Num AccounttNum Property· Table: VPM1 Sets or returns the bank account number of the check.Field name: AcctNum.Length: 50 characters. · Table: RCT1 PDF1 VPM1 ![]() House Bank Accounts DSC1 SQL Table Checks for Payment OCHO SQL Table G/L Accounts OACT SQL Table Countries OCRY SQL Table Currency Codes OCRN SQL Table Outgoing Payments OVPM SQL Table Object Settings - History ADP1 SQL Table |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |