biuan SAP® BUSINESS ONE SDK
API OCFL
OCFL - Cash Flow Additional Trans. Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
11
PRIMARYYes
DateIDDateDate
8
DscriptionDescriptionnVarChar
50
ProjectProject CodenVarChar
20
CreditIncoming TotalNum
20
CredCurEntrance CurrencynVarChar
3
DebitOutgoing AmountNum
20
DebCurIssue CurrencynVarChar
3
SecLevelSecurity LevelInt
1) Cash Account
5) Credit
2) Checks
3) Customer Liabilities
6) Bill of Exchange
4) Payable to Vendors
7) Customer Forecast
8) Vendor Forecast
6
1
UserIdUser IDInt
6
FrequencyFrequencyVarChar
D) Daily
W) Weekly
M) Monthly
Q) Quarterly
S) Semiannually
A) Annually
O) One Time
1
O
RemindSubfrequencyInt
-1)
1) On Sunday
2) On Monday
3) On Tuesday
4) On Wednesday
5) On Thursday
6) On Friday
7) On Saturday
101) Every 1
102) Every 2
103) Every 3
104) Every 4
105) Every 5
106) Every 6
107) Every 7
108) Every 8
109) Every 9
110) Every 10
115) Every 15
130) Every 30
145) Every 45
160) Every 60
1001) On 1
1002) On 2
1003) On 3
1004) On 4
1005) On 5
1006) On 6
1007) On 7
1008) On 8
1009) On 9
1010) On 10
1011) On 11
1012) On 12
1013) On 13
1014) On 14
1015) On 15
1016) On 16
1017) On 17
1018) On 18
1019) On 19
1020) On 20
1021) On 21
1022) On 22
1023) On 23
1024) On 24
1025) On 25
1026) On 26
1027) On 27
1028) On 28
1029) On 29
1030) On 30
1031) On 31
6
-1
EndDateExecution End DateDate
8

SELECT statement

SELECT OCFL.Code AS 'Code', OCFL.DateID AS 'Date', OCFL.Dscription AS 'Description', OCFL.Project AS 'Project Code', OCFL.Credit AS 'Incoming Total', OCFL.CredCur AS 'Entrance Currency', OCFL.Debit AS 'Outgoing Amount', OCFL.DebCur AS 'Issue Currency', OCFL.SecLevel AS 'Security Level', OCFL.UserId AS 'User ID', OCFL.Frequency AS 'Frequency', OCFL.Remind AS 'Subfrequency', OCFL.EndDate AS 'Execution End Date' FROM OCFL AS OCFL

Related information




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