📚 SAP Business One SDK Help

Table Name: OFLT

Table Description: Report - Selection Criteria

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