|
|
SQL Finance / Cash Flow Line Item
API OCFW
OCFW - Cash Flow Line Item Table
Cash Flow Line Item OCFW SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CFWId KEY UNIQUE | Cash Flow Line Item ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CFWName KEY UNIQUE | Cash Flow Line Item Name | nVarChar | 100 | INDEX_KEY | Yes | |||
| LineNum | Cash Flow Line No. | nVarChar | 5 | |||||
| Postable | Cash Flow Item [Active/Title] | VarChar | Y) Active Item N) Header Item | 1 | Y | |||
| FatherNum KEY | Parent Item Key | Int | 11 | OCFW Cash Flow Line Item | INTER_KEY | No | ||
| Levels | Cash Flow Item Level | Int | 6 | 3 | ||||
| GroupMask | Group Mask | Int | 6 | 1 | ||||
| GroupLine | Serial No. in Group | Int | 11 | |||||
| ExtrMatch | External Reconciliation No. | Int | 11 | |||||
| IntrMatch | Internal Reconciliation No. | Int | 11 | |||||
| RateDifCFW | Rate Differences CFW | Int | 11 | |||||
| DataSource | Data Source | Int | 6 | |||||
| Attr | Attribute | Int | 6 | |||||
| Direction | Direction | Int | 6 |
SELECT statement
SELECT
OCFW.CFWId AS 'Cash Flow Line Item ID',
OCFW.CFWName AS 'Cash Flow Line Item Name',
OCFW.LineNum AS 'Cash Flow Line No.',
OCFW.Postable AS 'Cash Flow Item [Active/Title]',
OCFW.FatherNum AS 'Parent Item Key',
OCFW.Levels AS 'Cash Flow Item Level',
OCFW.GroupMask AS 'Group Mask',
OCFW.GroupLine AS 'Serial No. in Group',
OCFW.ExtrMatch AS 'External Reconciliation No.',
OCFW.IntrMatch AS 'Internal Reconciliation No.',
OCFW.RateDifCFW AS 'Rate Differences CFW',
OCFW.DataSource AS 'Data Source',
OCFW.Attr AS 'Attribute',
OCFW.Direction AS 'Direction'
FROM OCFW AS OCFW
Related information
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
