biuan SAP® BUSINESS ONE SDK
API OFLT
OFLT - Report - Selection Criteria Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FormNum KEY UNIQUEForm NumbernVarChar
20
PRIMARYYes
QueryStrQuerynVarChar
127
ItmOrCrdItems or BPVarChar
Y) Yes
N) No
1
Y
CardIncludBP AreaVarChar
Y) Yes
N) No
1
Y
CardFrom1From BPnVarChar
15OCRD
Business Partner
CardTo1To BPnVarChar
15OCRD
Business Partner
CardExcludExcluding BPVarChar
Y) Yes
N) No
1
N
CardFrom2BP RejectednVarChar
15
CardTo2BP RejectednVarChar
15
ClienGroupCustomer GroupInt
6
VendGroupVendor GroupInt
6
ClntQryGrpCustomer PropertiesnVarChar
127
VeQryGroupVendor PropertiesnVarChar
127
ItmIncludItem RangeVarChar
Y) Yes
N) No
1
Y
ItmFrom1From ItemnVarChar
20OITM
Items
ItmTo1To ItemnVarChar
20OITM
Items
ItmExcludExcluding MaterialsVarChar
Y) Yes
N) No
1
N
ItmFrom2Item RejectednVarChar
20OITM
Items
ItmTo2Item RejectednVarChar
20OITM
Items
ItmGroupItem GroupInt
6OITB
Item Groups
ItQryGroupItem PropertiesnVarChar
127
WhsIncludeWarehouse RangeVarChar
Y) Yes
N) No
1
Y
WhsFrom1From WarehousenVarChar
8OWHS
Warehouses
WhsTo1To WarehousenVarChar
8OWHS
Warehouses
WhsExcludeExcluding WarehousesVarChar
Y) Yes
N) No
1
N
WhsFrom2Warehouse RejectednVarChar
8
WhsTo2Warehouse RejectednVarChar
8
FromAcctFrom AccountnVarChar
15
ToAcctTo AccountnVarChar
15
GroupMaskGroup MasknVarChar
12
FromDateFrom Posting DateDate
8
ToDateTo Posting DateDate
8
FrmDueDateDue Date FromDate
8
ToDueDateDue Date ToDate
8
FromDate3From Date 3Date
8
ToDate3To Date 3Date
8
FromDate4From Date 4Date
8
ToDate4To Date 4Date
8
SourceTypeOriginal JournalInt
15) Delivery
16) Returns
203) A/R Down Payment
13) A/R Invoice
14) A/R Credit Memo
132) Correction Invoice
(-0) (-
20) Goods Receipt
21) Goods Returns
204) A/P Down Payment
18) A/P Invoice
19) A/P Credit Memo
69) Landed Costs
163) A/P Correction Invoice
(-1) (-
24) Incoming Payment
25) Deposit
46) Vendor Payment
57) Checks for Payment
76) Postdated Deposit
(-2) (-
-2) Opening Balance
-3) Closing Balance
30) Journal Entry
(-3) (-
58) Stock Update
59) Goods Receipt
60) Goods Issue
67) Inventory Transfers
68) Work Instructions
162) Inventory Valuation
(-4) (-
-1) All Transactions
6
-1
FrmTrnsNumFrom Transaction No.Int
11
ToTrnsNumTo Transaction No.Int
11
FromRef1From Reference 1nVarChar
100
ToRef1To Reference 1nVarChar
100
FromRef2From Reference 2nVarChar
100
ToRef2To Reference 2nVarChar
100
FrmTrnsCodFrom Transaction CodenVarChar
4
ToTrnsCodTo Transaction CodenVarChar
4
FromSumFrom AmountNum
20
ToSumTo AmountNum
20
FrmFRNAmntFrom FC AmountNum
20
ToFRNAmntTo FC AmountNum
20
MemoInDetails ContainednVarChar
50
SortField1Sort Field 1Int
6
-1
Break1Subtotal by Sort 1VarChar
Y) Yes
N) No
1
N
SortField2Sort Field 2Int
6
-1
Break2Subtotal by Sort 2VarChar
Y) Yes
N) No
1
N
SortField3Sort Field 3Int
6
-1
Break3Subtotal by Sort 3VarChar
Y) Yes
N) No
1
N
DisplayDisplayVarChar
L) Postings Only
T) Totals Only
B) Postings + Totals
1
L
PrntCutDatPrint Date Selection CriteriaVarChar
Y) Yes
N) No
1
Y
CheckBox0Check box 0VarChar
Y) Yes
N) No
1
N
CheckBox1Check box 1VarChar
Y) Yes
N) No
1
N
CheckBox2Check box 2VarChar
Y) Yes
N) No
1
N
CheckBox3Check box 3VarChar
Y) Yes
N) No
1
N
CheckBox4Check box 4VarChar
Y) Yes
N) No
1
N
CheckBox5Check box 5VarChar
Y) Yes
N) No
1
N
CheckBox6Check box 6VarChar
Y) Yes
N) No
1
N
CheckBox7Check box 7VarChar
Y) Yes
N) No
1
N
CheckBox8Check box 8VarChar
Y) Yes
N) No
1
N
CheckBox9Check box 9VarChar
Y) Yes
N) No
1
N
ShowZeroDisplay Zero BalancesVarChar
Y) Yes
N) No
1
N
DateCheckConfirm Date RangeVarChar
Y) Yes
N) No
1
N
DueCheckConfirm Due Date RangeVarChar
Y) Yes
N) No
1
N
CutCheckConfirm Date Selectn CriteriaVarChar
Y) Yes
N) No
1
N
CutByObjSelection Criteria by ObjectVarChar
Y) Yes
N) No
1
N
ObjectC1C1VarChar
Y) Yes
N) No
1
N
ObjectC2C2VarChar
Y) Yes
N) No
1
N
ObjectC3C3VarChar
Y) Yes
N) No
1
N
ObjectC4C4VarChar
Y) Yes
N) No
1
N
ObjectC5C5VarChar
Y) Yes
N) No
1
N
ObjectC6C6VarChar
Y) Yes
N) No
1
N
ObjectC7C7VarChar
Y) Yes
N) No
1
N
ObjectC8C8VarChar
Y) Yes
N) No
1
N
ObjectC9C9VarChar
Y) Yes
N) No
1
N
ObjectC10C10VarChar
Y) Yes
N) No
1
N
ObjectC11C11VarChar
Y) Yes
N) No
1
N
ObjectC12C12VarChar
Y) Yes
N) No
1
N
ObjectC13C13VarChar
Y) Yes
N) No
1
N
ObjectC14C14VarChar
Y) Yes
N) No
1
N
ObjectC15C15VarChar
Y) Yes
N) No
1
N
ObjectC16C16VarChar
Y) Yes
N) No
1
N
FromAmountFrom AmountNum
20
ToAmountTo AmountNum
20
FrmSalsManFrom Sales EmployeeInt
6
ToSalsManTo Sales EmployeeInt
6
USER_CHK1User CheckBox 1VarChar
Y) Yes
N) No
1
N
USER_CHK2User CheckBox 2VarChar
Y) Yes
N) No
1
N
USER_CHK3User CheckBox 3VarChar
Y) Yes
N) No
1
N
USER_CHK4System CurrrencyVarChar
Y) Yes
N) No
1
N
USER_CHK5System and Local CurrencyVarChar
Y) Yes
N) No
1
N
UseSortSortVarChar
Y) Yes
N) No
1
N
Sort1UpSort1VarChar
Y) Ascending
N) Descending
1
Y
Sort2UpSort2VarChar
Y) Ascending
N) Descending
1
Y
Sort3UpSort3VarChar
Y) Ascending
N) Descending
1
Y
FromAmnt2From Quantity ReleaseNum
20
ToAmount2For Quantity ReleaseNum
20
TaxDateFroLower Limit for Tax DataDate
8
TaxDateToTop Limit for Document DatesDate
8
FinancYearStart of Fiscal YearDate
8
BdgtScenarBudget ScenarioInt
11
CompFolderCompany DatabasenVarChar
100
CheckBox10Exapan Check Box 1VarChar
Y) Yes
N) No
1
N
FROM_FCForeign Currency fromNum
20
TO_FCForeign Currency toNum
20
FCCurrencyForeign CurrencynVarChar
3
TaxCheckConfirm Document Date RangeVarChar
Y) Yes
N) No
1
N
DateTypeSelection Criteria TypeVarChar
R) Posting Date
D) Due Date
T) Document Date
1
R
DateType2Selection Criteria TypeVarChar
R) Posting Date
D) Due Date
T) Document Date
1
R
FromPrjectFrom ProjectnVarChar
20OPRJ
Project Codes
ToProjectTo ProjectnVarChar
20OPRJ
Project Codes
TemplateIdTemplateInt
11
0
ShowLeadsDisplay LeadsVarChar
Y) Yes
N) No
1
N
MthDateReconciliation DateVarChar
Y) Yes
N) No
1
N
AccntntCodExternal CodeVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
BlcNunFromBlock Number FromnVarChar
100
BlcNunToBlock Number TonVarChar
100
ImpLogFromImport Log FromnVarChar
20
ImpLogToImport Log TonVarChar
20
FolderNumFolder NumberVarChar
1
1
MainFieldMain FieldInt
6
23
TransModeTransaction ModeVarChar
Y) Yes
N) No
1
Y
MonthModeMonth Totals ModeVarChar
Y) Yes
N) No
1
N
CheckBox11Expan Check Box 11VarChar
Y) Yes
N) No
1
N
FromIdcIndicator FromnVarChar
2
ToIdcIndicator TonVarChar
2
IgnoreAdjIgnore AdjustmentsVarChar
Y) Yes
N) No
1
N
RefNumFromFrom Reference No.nVarChar
127
RefNumToTo Reference No.nVarChar
127
PymNumfromPayment No. FromInt
11
PymNumToTo Payment No.Int
11
BankFromFrom Bank CodenVarChar
30
BankToTo Bank CodenVarChar
30
DpstFromFrom Deposit CodeInt
11
DpstToTo Deposit CodeInt
11
DpstTypeDeposit TypeVarChar
1
ObjectC17Obj C17VarChar
Y) Yes
N) No
1
N
ObjectC18Obj C18VarChar
Y) Yes
N) No
1
N
ObjectC19Obj C19VarChar
Y) Yes
N) No
1
N
ObjAbsDocument Internal NumberInt
11
AddBTFAdd Journal VouchersVarChar
Y) Yes
N) No
1
N
FilePathFile PathText
16
DpsBnkActFFrom Deposit Bank AccountnVarChar
50
DpsBnkActTTo Deposit Bank AccountnVarChar
50
FromKeyFrom KeyInt
11
ToKeyTo KeyInt
11
ObjectC20Object C20VarChar
Y) Yes
N) No
1
N
ObjectC21Object C21VarChar
Y) Yes
N) No
1
N
ObjectC22Object C22VarChar
Y) Yes
N) No
1
N
ObjectC23Object C23VarChar
Y) Yes
N) No
1
N
ObjectC25Object C25VarChar
Y) Yes
N) No
1
N
USER_CHK6Include CB in P/L AccountsVarChar
Y) Yes
N) No
1
N
OcrChkDim2Checkbox for Dimension 2VarChar
Y) Yes
N) No
1
N
OcrChkDim3Checkbox for Dimension 3VarChar
Y) Yes
N) No
1
N
OcrChkDim4Checkbox for Dimension 4VarChar
Y) Yes
N) No
1
N
OcrChkDim5Checkbox for Dimension 5VarChar
Y) Yes
N) No
1
N
OcrFrom2From Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrFrom3From Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrFrom4From Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrFrom5From Costing Code 5nVarChar
8OOCR
Distribution Rule
OcrTo2To Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrTo3To Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrTo4To Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrTo5To Costing Code 5nVarChar
8OOCR
Distribution Rule
TaxAdjRepObject C24Text
16
ObjectC26Object C26VarChar
Y) Yes
N) No
1
N
CBFilterClosing Balances FilterVarChar
1) Closing Balance of Life-to-Date
2) Closing Balance Before Selected Period Only
1
2
OBIncludedAdd Opening Balance for PeriodVarChar
Y) Yes
N) No
1
N
OBFilterOpening Balances FilterVarChar
1) Opening Balance from Start of Company Activity
2) Opening Balance from Start of Fiscal Year
1
1
ExportCurrExport CurrencyVarChar
L) Local Currency
S) System Currency
1
L
CBIncludedAdd Closing BalancesVarChar
Y) Yes
N) No
1
N
SlpFromSlp FromnVarChar
127
SlpToSlp TonVarChar
127
CBUDFUser-Defined FieldsVarChar
Y) Yes
N) No
1
N
CBREFReference FieldsVarChar
Y) Yes
N) No
1
N
CheckBoxBCheckbox for BranchVarChar
Y) Yes
N) No
1
N
FilterNameFilter NamenVarChar
30
_
JDTFixedFJE Fixed FieldsInt
6
JDT1FixedFJE Line Fixed FieldsInt
6
JDTUserFJE User FieldsInt
6
JDT1UserFJE Line User FieldsInt
6
BPFilterBP Filter EnabledVarChar
Y) Yes
N) No
1
N
AcctFltrAccount Filter EnabledVarChar
Y) Yes
N) No
1
N
ZeroLCAmtShow Zero LC Amount LinesVarChar
Y) Yes
N) No
1
N
SplitByBinSplit By Bin LocationVarChar
Y) Yes
N) No
1
N
SplitBySnbSplit By Batch/SerialVarChar
Y) Yes
N) No
1
N
CheckBox12Check Box 12VarChar
Y) Yes
N) No
1
N
CheckBox13Check Box 13VarChar
Y) Yes
N) No
1
N
CheckBox14Check Box 14VarChar
Y) Yes
N) No
1
N
CheckBox15Check Box 15VarChar
Y) Yes
N) No
1
N
CheckBox16Check Box 16VarChar
Y) Yes
N) No
1
N
CheckBox17Check Box 17VarChar
Y) Yes
N) No
1
N
CheckBox18Check Box 18VarChar
Y) Yes
N) No
1
N
CheckBox19Check Box 19VarChar
Y) Yes
N) No
1
N
CheckBox20Check Box 20VarChar
Y) Yes
N) No
1
N
CheckBox21Check Box 21VarChar
Y) Yes
N) No
1
N
CheckBox22Check Box 22VarChar
Y) Yes
N) No
1
N
CheckBox23Check Box 23VarChar
Y) Yes
N) No
1
N
CheckBox24Check Box 24VarChar
Y) Yes
N) No
1
N
CheckBox25Check Box 25VarChar
Y) Yes
N) No
1
N
CheckBox26Check Box 26VarChar
Y) Yes
N) No
1
N
CheckBox27Check Box 27VarChar
Y) Yes
N) No
1
N
CheckBox28Check Box 28VarChar
Y) Yes
N) No
1
N
CheckBox29Check Box 29VarChar
Y) Yes
N) No
1
N
CheckBox30Check Box 30VarChar
Y) Yes
N) No
1
N
CheckBox31Check Box 31VarChar
Y) Yes
N) No
1
N
CheckBox32Check Box 32VarChar
Y) Yes
N) No
1
N
CheckBox33Check Box 33VarChar
Y) Yes
N) No
1
N
BatchFromBatch FromnVarChar
36
BatchToBatch TonVarChar
36
BatAttr1FBatch Attr. 1 FromnVarChar
36
BatAttr1TBatch Attr. 1 TonVarChar
36
BatAttr2FBatch Attr. 2 FromnVarChar
36
BatAttr2TBatch Attr. 2 TonVarChar
36
SerialNoFSerial Number FromnVarChar
36
SerialNoTSerial Number TonVarChar
36
MfrSerailFMfr Serial Number FromnVarChar
36
MfrSerailTMfr Serial Number TonVarChar
36
LotNumberFLot Number FromnVarChar
36
LotNumberTLot Number TonVarChar
36
BinLocFromBin Location FromnVarChar
127
BinLocToBin Location TonVarChar
127
AltSrtCodFAlternative Sort Code FromnVarChar
50
AltSrtCodTAlternative Sort Code TonVarChar
50
BinSbl1FBin Sublevel 1 FromnVarChar
50
BinSbl1ToBin Sublevel 1 TonVarChar
50
BinSbl2FBin Sublevel 2 FromnVarChar
50
BinSbl2ToBin Sublevel 2 TonVarChar
50
BinSbl3FBin Sublevel 3 FromnVarChar
50
BinSbl3ToBin Sublevel 3 TonVarChar
50
BinSbl4FBin Sublevel 4 FromnVarChar
50
BinSbl4ToBin Sublevel 4 TonVarChar
50
BinAttr1FBin Attribute 1 FromnVarChar
20
BinAttr1ToBin Attribute 1 TonVarChar
20
BinAttr2FBin Attribute 2 FromnVarChar
20
BinAttr2ToBin Attribute 2 TonVarChar
20
BinAttr3FBin Attribute 3 FromnVarChar
20
BinAttr3ToBin Attribute 3 TonVarChar
20
BinAttr4FBin Attribute 4 FromnVarChar
20
BinAttr4ToBin Attribute 4 TonVarChar
20
BinAttr5FBin Attribute 5 FromnVarChar
20
BinAttr5ToBin Attribute 5 TonVarChar
20
BinAttr6FBin Attribute 6 FromnVarChar
20
BinAttr6ToBin Attribute 6 TonVarChar
20
BinAttr7FBin Attribute 7 FromnVarChar
20
BinAttr7ToBin Attribute 7 TonVarChar
20
BinAttr8FBin Attribute 8 FromnVarChar
20
BinAttr8ToBin Attribute 8 TonVarChar
20
BinAttr9FBin Attribute 9 FromnVarChar
20
BinAttr9ToBin Attribute 9 TonVarChar
20
BinAttr10FBin Attribute 10 FromnVarChar
20
BinAttr10TBin Attribute 10 TonVarChar
20
EnfBinFltrEnforced Bin FilterVarChar
E) Enforced Bin Location
U) Unenforced Bin Location
B) Both
N) Bin not activated
1
N
ExItemFromExpand from ItemnVarChar
20OITM
Items
ExItemToExpand to ItemnVarChar
20OITM
Items
ExBPFromExpand from BPnVarChar
15OCRD
Business Partner
ExBPToExpand to BPnVarChar
15OCRD
Business Partner
CheckBox34Check Box 34VarChar
Y) Yes
N) No
1
N
CheckBox35Check Box 35VarChar
Y) Yes
N) No
1
N
BlAgreemCheckbox for Blanket AgreementVarChar
1
N
BAFromBlanket Agreement FromnVarChar
8
BAToBlanket Agreement TonVarChar
8
AdjTransAdjustment TransactionsVarChar
Y) Yes
N) No
1
N
TitAcctLvlTitle Account LevelInt
11
2
CCDFrom1CCD Number from condition 1nVarChar
40
CCDTo1CCD Number to Condition 1nVarChar
40
CCDFrom2CCD Number from Condition 2nVarChar
40
CCDTo2CCD Number to Condition 2nVarChar
40
ArchJrnalArchiving JournalVarChar
Y) Yes
N) No
1
N
CardFrom3From BPnVarChar
15
CardTo3To BPnVarChar
15

Table relationship map

SELECT statement

SELECT OFLT.FormNum AS 'Form Number', OFLT.QueryStr AS 'Query', OFLT.ItmOrCrd AS 'Items or BP', OFLT.CardInclud AS 'BP Area', OFLT.CardFrom1 AS 'From BP', OFLT.CardTo1 AS 'To BP', OFLT.CardExclud AS 'Excluding BP', OFLT.CardFrom2 AS 'BP Rejected', OFLT.CardTo2 AS 'BP Rejected', OFLT.ClienGroup AS 'Customer Group', OFLT.VendGroup AS 'Vendor Group', OFLT.ClntQryGrp AS 'Customer Properties', OFLT.VeQryGroup AS 'Vendor Properties', OFLT.ItmInclud AS 'Item Range', OFLT.ItmFrom1 AS 'From Item', OFLT.ItmTo1 AS 'To Item', OFLT.ItmExclud AS 'Excluding Materials', OFLT.ItmFrom2 AS 'Item Rejected', OFLT.ItmTo2 AS 'Item Rejected', OFLT.ItmGroup AS 'Item Group', OFLT.ItQryGroup AS 'Item Properties', OFLT.WhsInclude AS 'Warehouse Range', OFLT.WhsFrom1 AS 'From Warehouse', OFLT.WhsTo1 AS 'To Warehouse', OFLT.WhsExclude AS 'Excluding Warehouses', OFLT.WhsFrom2 AS 'Warehouse Rejected', OFLT.WhsTo2 AS 'Warehouse Rejected', OFLT.FromAcct AS 'From Account', OFLT.ToAcct AS 'To Account', OFLT.GroupMask AS 'Group Mask', OFLT.FromDate AS 'From Posting Date', OFLT.ToDate AS 'To Posting Date', OFLT.FrmDueDate AS 'Due Date From', OFLT.ToDueDate AS 'Due Date To', OFLT.FromDate3 AS 'From Date 3', OFLT.ToDate3 AS 'To Date 3', OFLT.FromDate4 AS 'From Date 4', OFLT.ToDate4 AS 'To Date 4', OFLT.SourceType AS 'Original Journal', OFLT.FrmTrnsNum AS 'From Transaction No.', OFLT.ToTrnsNum AS 'To Transaction No.', OFLT.FromRef1 AS 'From Reference 1', OFLT.ToRef1 AS 'To Reference 1', OFLT.FromRef2 AS 'From Reference 2', OFLT.ToRef2 AS 'To Reference 2', OFLT.FrmTrnsCod AS 'From Transaction Code', OFLT.ToTrnsCod AS 'To Transaction Code', OFLT.FromSum AS 'From Amount', OFLT.ToSum AS 'To Amount', OFLT.FrmFRNAmnt AS 'From FC Amount', OFLT.ToFRNAmnt AS 'To FC Amount', OFLT.MemoIn AS 'Details Contained', OFLT.SortField1 AS 'Sort Field 1', OFLT.Break1 AS 'Subtotal by Sort 1', OFLT.SortField2 AS 'Sort Field 2', OFLT.Break2 AS 'Subtotal by Sort 2', OFLT.SortField3 AS 'Sort Field 3', OFLT.Break3 AS 'Subtotal by Sort 3', OFLT.Display AS 'Display', OFLT.PrntCutDat AS 'Print Date Selection Criteria', OFLT.CheckBox0 AS 'Check box 0', OFLT.CheckBox1 AS 'Check box 1', OFLT.CheckBox2 AS 'Check box 2', OFLT.CheckBox3 AS 'Check box 3', OFLT.CheckBox4 AS 'Check box 4', OFLT.CheckBox5 AS 'Check box 5', OFLT.CheckBox6 AS 'Check box 6', OFLT.CheckBox7 AS 'Check box 7', OFLT.CheckBox8 AS 'Check box 8', OFLT.CheckBox9 AS 'Check box 9', OFLT.ShowZero AS 'Display Zero Balances', OFLT.DateCheck AS 'Confirm Date Range', OFLT.DueCheck AS 'Confirm Due Date Range', OFLT.CutCheck AS 'Confirm Date Selectn Criteria', OFLT.CutByObj AS 'Selection Criteria by Object', OFLT.ObjectC1 AS 'C1', OFLT.ObjectC2 AS 'C2', OFLT.ObjectC3 AS 'C3', OFLT.ObjectC4 AS 'C4', OFLT.ObjectC5 AS 'C5', OFLT.ObjectC6 AS 'C6', OFLT.ObjectC7 AS 'C7', OFLT.ObjectC8 AS 'C8', OFLT.ObjectC9 AS 'C9', OFLT.ObjectC10 AS 'C10', OFLT.ObjectC11 AS 'C11', OFLT.ObjectC12 AS 'C12', OFLT.ObjectC13 AS 'C13', OFLT.ObjectC14 AS 'C14', OFLT.ObjectC15 AS 'C15', OFLT.ObjectC16 AS 'C16', OFLT.FromAmount AS 'From Amount', OFLT.ToAmount AS 'To Amount', OFLT.FrmSalsMan AS 'From Sales Employee', OFLT.ToSalsMan AS 'To Sales Employee', OFLT.USER_CHK1 AS 'User CheckBox 1', OFLT.USER_CHK2 AS 'User CheckBox 2', OFLT.USER_CHK3 AS 'User CheckBox 3', OFLT.USER_CHK4 AS 'System Currrency', OFLT.USER_CHK5 AS 'System and Local Currency', OFLT.UseSort AS 'Sort', OFLT.Sort1Up AS 'Sort1', OFLT.Sort2Up AS 'Sort2', OFLT.Sort3Up AS 'Sort3', OFLT.FromAmnt2 AS 'From Quantity Release', OFLT.ToAmount2 AS 'For Quantity Release', OFLT.TaxDateFro AS 'Lower Limit for Tax Data', OFLT.TaxDateTo AS 'Top Limit for Document Dates', OFLT.FinancYear AS 'Start of Fiscal Year', OFLT.BdgtScenar AS 'Budget Scenario', OFLT.CompFolder AS 'Company Database', OFLT.CheckBox10 AS 'Exapan Check Box 1', OFLT.FROM_FC AS 'Foreign Currency from', OFLT.TO_FC AS 'Foreign Currency to', OFLT.FCCurrency AS 'Foreign Currency', OFLT.TaxCheck AS 'Confirm Document Date Range', OFLT.DateType AS 'Selection Criteria Type', OFLT.DateType2 AS 'Selection Criteria Type', OFLT.FromPrject AS 'From Project', OFLT.ToProject AS 'To Project', OFLT.TemplateId AS 'Template', OFLT.ShowLeads AS 'Display Leads', OFLT.MthDate AS 'Reconciliation Date', OFLT.AccntntCod AS 'External Code', OFLT.UserSign AS 'User Signature', OFLT.BlcNunFrom AS 'Block Number From', OFLT.BlcNunTo AS 'Block Number To', OFLT.ImpLogFrom AS 'Import Log From', OFLT.ImpLogTo AS 'Import Log To', OFLT.FolderNum AS 'Folder Number', OFLT.MainField AS 'Main Field', OFLT.TransMode AS 'Transaction Mode', OFLT.MonthMode AS 'Month Totals Mode', OFLT.CheckBox11 AS 'Expan Check Box 11', OFLT.FromIdc AS 'Indicator From', OFLT.ToIdc AS 'Indicator To', OFLT.IgnoreAdj AS 'Ignore Adjustments', OFLT.RefNumFrom AS 'From Reference No.', OFLT.RefNumTo AS 'To Reference No.', OFLT.PymNumfrom AS 'Payment No. From', OFLT.PymNumTo AS 'To Payment No.', OFLT.BankFrom AS 'From Bank Code', OFLT.BankTo AS 'To Bank Code', OFLT.DpstFrom AS 'From Deposit Code', OFLT.DpstTo AS 'To Deposit Code', OFLT.DpstType AS 'Deposit Type', OFLT.ObjectC17 AS 'Obj C17', OFLT.ObjectC18 AS 'Obj C18', OFLT.ObjectC19 AS 'Obj C19', OFLT.ObjAbs AS 'Document Internal Number', OFLT.AddBTF AS 'Add Journal Vouchers', OFLT.FilePath AS 'File Path', OFLT.DpsBnkActF AS 'From Deposit Bank Account', OFLT.DpsBnkActT AS 'To Deposit Bank Account', OFLT.FromKey AS 'From Key', OFLT.ToKey AS 'To Key', OFLT.ObjectC20 AS 'Object C20', OFLT.ObjectC21 AS 'Object C21', OFLT.ObjectC22 AS 'Object C22', OFLT.ObjectC23 AS 'Object C23', OFLT.ObjectC25 AS 'Object C25', OFLT.USER_CHK6 AS 'Include CB in P/L Accounts', OFLT.OcrChkDim2 AS 'Checkbox for Dimension 2', OFLT.OcrChkDim3 AS 'Checkbox for Dimension 3', OFLT.OcrChkDim4 AS 'Checkbox for Dimension 4', OFLT.OcrChkDim5 AS 'Checkbox for Dimension 5', OFLT.OcrFrom2 AS 'From Costing Code 2', OFLT.OcrFrom3 AS 'From Costing Code 3', OFLT.OcrFrom4 AS 'From Costing Code 4', OFLT.OcrFrom5 AS 'From Costing Code 5', OFLT.OcrTo2 AS 'To Costing Code 2', OFLT.OcrTo3 AS 'To Costing Code 3', OFLT.OcrTo4 AS 'To Costing Code 4', OFLT.OcrTo5 AS 'To Costing Code 5', OFLT.TaxAdjRep AS 'Object C24', OFLT.ObjectC26 AS 'Object C26', OFLT.CBFilter AS 'Closing Balances Filter', OFLT.OBIncluded AS 'Add Opening Balance for Period', OFLT.OBFilter AS 'Opening Balances Filter', OFLT.ExportCurr AS 'Export Currency', OFLT.CBIncluded AS 'Add Closing Balances', OFLT.SlpFrom AS 'Slp From', OFLT.SlpTo AS 'Slp To', OFLT.CBUDF AS 'User-Defined Fields', OFLT.CBREF AS 'Reference Fields', OFLT.CheckBoxB AS 'Checkbox for Branch', OFLT.FilterName AS 'Filter Name', OFLT.JDTFixedF AS 'JE Fixed Fields', OFLT.JDT1FixedF AS 'JE Line Fixed Fields', OFLT.JDTUserF AS 'JE User Fields', OFLT.JDT1UserF AS 'JE Line User Fields', OFLT.BPFilter AS 'BP Filter Enabled', OFLT.AcctFltr AS 'Account Filter Enabled', OFLT.ZeroLCAmt AS 'Show Zero LC Amount Lines', OFLT.SplitByBin AS 'Split By Bin Location', OFLT.SplitBySnb AS 'Split By Batch/Serial', OFLT.CheckBox12 AS 'Check Box 12', OFLT.CheckBox13 AS 'Check Box 13', OFLT.CheckBox14 AS 'Check Box 14', OFLT.CheckBox15 AS 'Check Box 15', OFLT.CheckBox16 AS 'Check Box 16', OFLT.CheckBox17 AS 'Check Box 17', OFLT.CheckBox18 AS 'Check Box 18', OFLT.CheckBox19 AS 'Check Box 19', OFLT.CheckBox20 AS 'Check Box 20', OFLT.CheckBox21 AS 'Check Box 21', OFLT.CheckBox22 AS 'Check Box 22', OFLT.CheckBox23 AS 'Check Box 23', OFLT.CheckBox24 AS 'Check Box 24', OFLT.CheckBox25 AS 'Check Box 25', OFLT.CheckBox26 AS 'Check Box 26', OFLT.CheckBox27 AS 'Check Box 27', OFLT.CheckBox28 AS 'Check Box 28', OFLT.CheckBox29 AS 'Check Box 29', OFLT.CheckBox30 AS 'Check Box 30', OFLT.CheckBox31 AS 'Check Box 31', OFLT.CheckBox32 AS 'Check Box 32', OFLT.CheckBox33 AS 'Check Box 33', OFLT.BatchFrom AS 'Batch From', OFLT.BatchTo AS 'Batch To', OFLT.BatAttr1F AS 'Batch Attr. 1 From', OFLT.BatAttr1T AS 'Batch Attr. 1 To', OFLT.BatAttr2F AS 'Batch Attr. 2 From', OFLT.BatAttr2T AS 'Batch Attr. 2 To', OFLT.SerialNoF AS 'Serial Number From', OFLT.SerialNoT AS 'Serial Number To', OFLT.MfrSerailF AS 'Mfr Serial Number From', OFLT.MfrSerailT AS 'Mfr Serial Number To', OFLT.LotNumberF AS 'Lot Number From', OFLT.LotNumberT AS 'Lot Number To', OFLT.BinLocFrom AS 'Bin Location From', OFLT.BinLocTo AS 'Bin Location To', OFLT.AltSrtCodF AS 'Alternative Sort Code From', OFLT.AltSrtCodT AS 'Alternative Sort Code To', OFLT.BinSbl1F AS 'Bin Sublevel 1 From', OFLT.BinSbl1To AS 'Bin Sublevel 1 To', OFLT.BinSbl2F AS 'Bin Sublevel 2 From', OFLT.BinSbl2To AS 'Bin Sublevel 2 To', OFLT.BinSbl3F AS 'Bin Sublevel 3 From', OFLT.BinSbl3To AS 'Bin Sublevel 3 To', OFLT.BinSbl4F AS 'Bin Sublevel 4 From', OFLT.BinSbl4To AS 'Bin Sublevel 4 To', OFLT.BinAttr1F AS 'Bin Attribute 1 From', OFLT.BinAttr1To AS 'Bin Attribute 1 To', OFLT.BinAttr2F AS 'Bin Attribute 2 From', OFLT.BinAttr2To AS 'Bin Attribute 2 To', OFLT.BinAttr3F AS 'Bin Attribute 3 From', OFLT.BinAttr3To AS 'Bin Attribute 3 To', OFLT.BinAttr4F AS 'Bin Attribute 4 From', OFLT.BinAttr4To AS 'Bin Attribute 4 To', OFLT.BinAttr5F AS 'Bin Attribute 5 From', OFLT.BinAttr5To AS 'Bin Attribute 5 To', OFLT.BinAttr6F AS 'Bin Attribute 6 From', OFLT.BinAttr6To AS 'Bin Attribute 6 To', OFLT.BinAttr7F AS 'Bin Attribute 7 From', OFLT.BinAttr7To AS 'Bin Attribute 7 To', OFLT.BinAttr8F AS 'Bin Attribute 8 From', OFLT.BinAttr8To AS 'Bin Attribute 8 To', OFLT.BinAttr9F AS 'Bin Attribute 9 From', OFLT.BinAttr9To AS 'Bin Attribute 9 To', OFLT.BinAttr10F AS 'Bin Attribute 10 From', OFLT.BinAttr10T AS 'Bin Attribute 10 To', OFLT.EnfBinFltr AS 'Enforced Bin Filter', OFLT.ExItemFrom AS 'Expand from Item', OFLT.ExItemTo AS 'Expand to Item', OFLT.ExBPFrom AS 'Expand from BP', OFLT.ExBPTo AS 'Expand to BP', OFLT.CheckBox34 AS 'Check Box 34', OFLT.CheckBox35 AS 'Check Box 35', OFLT.BlAgreem AS 'Checkbox for Blanket Agreement', OFLT.BAFrom AS 'Blanket Agreement From', OFLT.BATo AS 'Blanket Agreement To', OFLT.AdjTrans AS 'Adjustment Transactions', OFLT.TitAcctLvl AS 'Title Account Level', OFLT.CCDFrom1 AS 'CCD Number from condition 1', OFLT.CCDTo1 AS 'CCD Number to Condition 1', OFLT.CCDFrom2 AS 'CCD Number from Condition 2', OFLT.CCDTo2 AS 'CCD Number to Condition 2', OFLT.ArchJrnal AS 'Archiving Journal', OFLT.CardFrom3 AS 'From BP', OFLT.CardTo3 AS 'To BP' FROM OFLT AS OFLT

Related information


Business Partner OCRD SQL Table

Items OITM SQL Table

Project Codes OPRJ SQL Table

Item Groups OITB SQL Table

Distribution Rule OOCR SQL Table

Users OUSR SQL Table

Warehouses OWHS 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