biuan SAP® BUSINESS ONE SDK
API OCFW
OCFW - Cash Flow Line Item Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CFWId KEY UNIQUECash Flow Line Item IDInt
11
PRIMARYYes
CFWName KEY UNIQUECash Flow Line Item NamenVarChar
100
INDEX_KEYYes
LineNumCash Flow Line No.nVarChar
5
PostableCash Flow Item [Active/Title]VarChar
Y) Active Item
N) Header Item
1
Y
FatherNum KEYParent Item KeyInt
11OCFW
Cash Flow Line Item
INTER_KEYNo
LevelsCash Flow Item LevelInt
6
3
GroupMaskGroup MaskInt
6
1
GroupLineSerial No. in GroupInt
11
ExtrMatchExternal Reconciliation No.Int
11
IntrMatchInternal Reconciliation No.Int
11
RateDifCFWRate Differences CFWInt
11
DataSourceData SourceInt
6
AttrAttributeInt
6
DirectionDirectionInt
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



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