biuan SAP® BUSINESS ONE SDK
DTW Financials / Journal Entry
API OCFT
OCFT - Cash Flow Transactions - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CFTId KEY UNIQUECash Flow Transaction IDInt
11
PRIMARYYes
CFWIdCash Flow Line Item IDInt
11OCFW
Cash Flow Line Item
DebitDebit AmountNum
20
CreditCredit AmountNum
20
SysCreditSystem Credit AmountNum
20
SysDebitSystem Debit AmountNum
20
FCDebitFC Debit AmountNum
20
FCCreditFC Credit AmountNum
20
FCCurrencyForeign CurrencynVarChar
3
AccountAccount CodenVarChar
15OACT
G/L Accounts
BatchNumBatch No.Int
11
JDTIdJournal Entry IDInt
11
JDTLineIdJournal Entry Line IDInt
11
TransTypeSource ObjectnVarChar
24) Incoming Payment
46) Vendor Payment
30) Journal Entry
140) Payment Draft
29) Journal Vouchers List
25) Deposit
76) Postdated Check Deposit
182) Bill of Exchange Transaction
42) Bank Statement
157) Payment Wizard
20
BaseRefBase ReferencenVarChar
11
PaymentMenPayment MeansnVarChar
11
PaymentRefPayment ReferencenVarChar
11
PostDatePosting DateDate
8
ValueDateValue DateDate
8
StatusStatusVarChar
1

Table relationship map

SELECT statement

SELECT OCFT.CFTId AS 'Cash Flow Transaction ID', OCFT.CFWId AS 'Cash Flow Line Item ID', OCFT.Debit AS 'Debit Amount', OCFT.Credit AS 'Credit Amount', OCFT.SysCredit AS 'System Credit Amount', OCFT.SysDebit AS 'System Debit Amount', OCFT.FCDebit AS 'FC Debit Amount', OCFT.FCCredit AS 'FC Credit Amount', OCFT.FCCurrency AS 'Foreign Currency', OCFT.Account AS 'Account Code', OCFT.BatchNum AS 'Batch No.', OCFT.JDTId AS 'Journal Entry ID', OCFT.JDTLineId AS 'Journal Entry Line ID', OCFT.TransType AS 'Source Object', OCFT.BaseRef AS 'Base Reference', OCFT.PaymentMen AS 'Payment Means', OCFT.PaymentRef AS 'Payment Reference', OCFT.PostDate AS 'Posting Date', OCFT.ValueDate AS 'Value Date', OCFT.Status AS 'Status' FROM OCFT AS OCFT

Related information


G/L Accounts OACT SQL Table

Cash Flow Line Item OCFW 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