|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Cash Flow Transactions - Rows
Table Name: OCFT
Table Description: Cash Flow Transactions - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CFTId | Cash Flow Transaction ID | Int | 11 | - | Â | Â | Â |
| CFWId | Cash Flow Line Item ID | Int | 11 | OCFW | Â | Â | Â |
| Debit | Debit Amount | Num | 19.6 | - | Â | Â | Â |
| Credit | Credit Amount | Num | 19.6 | - | Â | Â | Â |
| SysCredit | System Credit Amount | Num | 19.6 | - | Â | Â | Â |
| SysDebit | System Debit Amount | Num | 19.6 | - | Â | Â | Â |
| FCDebit | FC Debit Amount | Num | 19.6 | - | Â | Â | Â |
| FCCredit | FC Credit Amount | Num | 19.6 | - | Â | Â | Â |
| FCCurrency | Foreign Currency | nVarChar | 3 | - | Â | Â | Â |
| Account | Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| BatchNum | Batch No. | Int | 11 | - | Â | Â | Â |
| JDTId | Journal Entry ID | Int | 11 | - | Â | Â | Â |
| JDTLineId | Journal Entry Line ID | Int | 11 | - | Â | Â | Â |
| TransType | Source Object | nVarChar | 20 | - | Â | 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 |
| 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 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CFTId |