|
|
DTW Financials / Journal Entry
API OCFT
OCFT - Cash Flow Transactions - Rows Table
G/L Accounts OACT SQL Table
Cash Flow Line Item OCFW SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CFTId KEY UNIQUE | Cash Flow Transaction ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CFWId | Cash Flow Line Item ID | Int | 11 | OCFW Cash Flow Line Item | ||||
| Debit | Debit Amount | Num | 20 | |||||
| Credit | Credit Amount | Num | 20 | |||||
| SysCredit | System Credit Amount | Num | 20 | |||||
| SysDebit | System Debit Amount | Num | 20 | |||||
| FCDebit | FC Debit Amount | Num | 20 | |||||
| FCCredit | FC Credit Amount | Num | 20 | |||||
| FCCurrency | Foreign Currency | nVarChar | 3 | |||||
| Account | Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| BatchNum | Batch No. | Int | 11 | |||||
| JDTId | Journal Entry ID | Int | 11 | |||||
| JDTLineId | Journal Entry Line ID | Int | 11 | |||||
| TransType | Source Object | nVarChar | 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 | ||||
| BaseRef | Base Reference | nVarChar | 11 | |||||
| PaymentMen | Payment Means | nVarChar | 11 | |||||
| PaymentRef | Payment Reference | nVarChar | 11 | |||||
| PostDate | Posting Date | Date | 8 | |||||
| ValueDate | Value Date | Date | 8 | |||||
| Status | Status | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
