|
|
API OFLT
OFLT - Report - Selection Criteria Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FormNum KEY UNIQUE | Form Number | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| QueryStr | Query | nVarChar | 127 | |||||
| ItmOrCrd | Items or BP | VarChar | Y) Yes N) No | 1 | Y | |||
| CardInclud | BP Area | VarChar | Y) Yes N) No | 1 | Y | |||
| CardFrom1 | From BP | nVarChar | 15 | OCRD Business Partner | ||||
| CardTo1 | To BP | nVarChar | 15 | OCRD Business Partner | ||||
| CardExclud | Excluding BP | VarChar | Y) Yes N) No | 1 | N | |||
| CardFrom2 | BP Rejected | nVarChar | 15 | |||||
| CardTo2 | BP Rejected | nVarChar | 15 | |||||
| ClienGroup | Customer Group | Int | 6 | |||||
| VendGroup | Vendor Group | Int | 6 | |||||
| ClntQryGrp | Customer Properties | nVarChar | 127 | |||||
| VeQryGroup | Vendor Properties | nVarChar | 127 | |||||
| ItmInclud | Item Range | VarChar | Y) Yes N) No | 1 | Y | |||
| ItmFrom1 | From Item | nVarChar | 20 | OITM Items | ||||
| ItmTo1 | To Item | nVarChar | 20 | OITM Items | ||||
| ItmExclud | Excluding Materials | VarChar | Y) Yes N) No | 1 | N | |||
| ItmFrom2 | Item Rejected | nVarChar | 20 | OITM Items | ||||
| ItmTo2 | Item Rejected | nVarChar | 20 | OITM Items | ||||
| ItmGroup | Item Group | Int | 6 | OITB Item Groups | ||||
| ItQryGroup | Item Properties | nVarChar | 127 | |||||
| WhsInclude | Warehouse Range | VarChar | Y) Yes N) No | 1 | Y | |||
| WhsFrom1 | From Warehouse | nVarChar | 8 | OWHS Warehouses | ||||
| WhsTo1 | To Warehouse | nVarChar | 8 | OWHS Warehouses | ||||
| WhsExclude | Excluding Warehouses | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | 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 | |||
| 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 | 20 | |||||
| ToSum | To Amount | Num | 20 | |||||
| FrmFRNAmnt | From FC Amount | Num | 20 | |||||
| ToFRNAmnt | To FC Amount | Num | 20 | |||||
| MemoIn | Details Contained | nVarChar | 50 | |||||
| SortField1 | Sort Field 1 | Int | 6 | -1 | ||||
| Break1 | Subtotal by Sort 1 | VarChar | Y) Yes N) No | 1 | N | |||
| SortField2 | Sort Field 2 | Int | 6 | -1 | ||||
| Break2 | Subtotal by Sort 2 | VarChar | Y) Yes N) No | 1 | N | |||
| SortField3 | Sort Field 3 | Int | 6 | -1 | ||||
| Break3 | Subtotal by Sort 3 | VarChar | Y) Yes N) No | 1 | N | |||
| Display | Display | VarChar | L) Postings Only T) Totals Only B) Postings + Totals | 1 | L | |||
| PrntCutDat | Print Date Selection Criteria | VarChar | Y) Yes N) No | 1 | Y | |||
| CheckBox0 | Check box 0 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox1 | Check box 1 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox2 | Check box 2 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox3 | Check box 3 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox4 | Check box 4 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox5 | Check box 5 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox6 | Check box 6 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox7 | Check box 7 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox8 | Check box 8 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox9 | Check box 9 | VarChar | Y) Yes N) No | 1 | N | |||
| ShowZero | Display Zero Balances | VarChar | Y) Yes N) No | 1 | N | |||
| DateCheck | Confirm Date Range | VarChar | Y) Yes N) No | 1 | N | |||
| DueCheck | Confirm Due Date Range | VarChar | Y) Yes N) No | 1 | N | |||
| CutCheck | Confirm Date Selectn Criteria | VarChar | Y) Yes N) No | 1 | N | |||
| CutByObj | Selection Criteria by Object | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC1 | C1 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC2 | C2 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC3 | C3 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC4 | C4 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC5 | C5 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC6 | C6 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC7 | C7 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC8 | C8 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC9 | C9 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC10 | C10 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC11 | C11 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC12 | C12 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC13 | C13 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC14 | C14 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC15 | C15 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC16 | C16 | VarChar | Y) Yes N) No | 1 | N | |||
| FromAmount | From Amount | Num | 20 | |||||
| ToAmount | To Amount | Num | 20 | |||||
| FrmSalsMan | From Sales Employee | Int | 6 | |||||
| ToSalsMan | To Sales Employee | Int | 6 | |||||
| USER_CHK1 | User CheckBox 1 | VarChar | Y) Yes N) No | 1 | N | |||
| USER_CHK2 | User CheckBox 2 | VarChar | Y) Yes N) No | 1 | N | |||
| USER_CHK3 | User CheckBox 3 | VarChar | Y) Yes N) No | 1 | N | |||
| USER_CHK4 | System Currrency | VarChar | Y) Yes N) No | 1 | N | |||
| USER_CHK5 | System and Local Currency | VarChar | Y) Yes N) No | 1 | N | |||
| UseSort | Sort | VarChar | Y) Yes N) No | 1 | N | |||
| Sort1Up | Sort1 | VarChar | Y) Ascending N) Descending | 1 | Y | |||
| Sort2Up | Sort2 | VarChar | Y) Ascending N) Descending | 1 | Y | |||
| Sort3Up | Sort3 | VarChar | Y) Ascending N) Descending | 1 | Y | |||
| FromAmnt2 | From Quantity Release | Num | 20 | |||||
| ToAmount2 | For Quantity Release | Num | 20 | |||||
| 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 | 100 | |||||
| CheckBox10 | Exapan Check Box 1 | VarChar | Y) Yes N) No | 1 | N | |||
| FROM_FC | Foreign Currency from | Num | 20 | |||||
| TO_FC | Foreign Currency to | Num | 20 | |||||
| FCCurrency | Foreign Currency | nVarChar | 3 | |||||
| TaxCheck | Confirm Document Date Range | VarChar | Y) Yes N) No | 1 | N | |||
| DateType | Selection Criteria Type | VarChar | R) Posting Date D) Due Date T) Document Date | 1 | R | |||
| DateType2 | Selection Criteria Type | VarChar | R) Posting Date D) Due Date T) Document Date | 1 | R | |||
| FromPrject | From Project | nVarChar | 20 | OPRJ Project Codes | ||||
| ToProject | To Project | nVarChar | 20 | OPRJ Project Codes | ||||
| TemplateId | Template | Int | 11 | 0 | ||||
| ShowLeads | Display Leads | VarChar | Y) Yes N) No | 1 | N | |||
| MthDate | Reconciliation Date | VarChar | Y) Yes N) No | 1 | N | |||
| AccntntCod | External Code | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| 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 | Y) Yes N) No | 1 | Y | |||
| MonthMode | Month Totals Mode | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox11 | Expan Check Box 11 | VarChar | Y) Yes N) No | 1 | N | |||
| FromIdc | Indicator From | nVarChar | 2 | |||||
| ToIdc | Indicator To | nVarChar | 2 | |||||
| IgnoreAdj | Ignore Adjustments | VarChar | Y) Yes N) No | 1 | N | |||
| RefNumFrom | From Reference No. | nVarChar | 127 | |||||
| RefNumTo | To Reference No. | nVarChar | 127 | |||||
| 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 | Y) Yes N) No | 1 | N | |||
| ObjectC18 | Obj C18 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC19 | Obj C19 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjAbs | Document Internal Number | Int | 11 | |||||
| AddBTF | Add Journal Vouchers | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | Y) Yes N) No | 1 | N | |||
| ObjectC21 | Object C21 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC22 | Object C22 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC23 | Object C23 | VarChar | Y) Yes N) No | 1 | N | |||
| ObjectC25 | Object C25 | VarChar | Y) Yes N) No | 1 | N | |||
| USER_CHK6 | Include CB in P/L Accounts | VarChar | Y) Yes N) No | 1 | N | |||
| OcrChkDim2 | Checkbox for Dimension 2 | VarChar | Y) Yes N) No | 1 | N | |||
| OcrChkDim3 | Checkbox for Dimension 3 | VarChar | Y) Yes N) No | 1 | N | |||
| OcrChkDim4 | Checkbox for Dimension 4 | VarChar | Y) Yes N) No | 1 | N | |||
| OcrChkDim5 | Checkbox for Dimension 5 | VarChar | Y) Yes N) No | 1 | N | |||
| OcrFrom2 | From Costing Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrFrom3 | From Costing Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrFrom4 | From Costing Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrFrom5 | From Costing Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrTo2 | To Costing Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrTo3 | To Costing Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrTo4 | To Costing Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrTo5 | To Costing Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| TaxAdjRep | Object C24 | Text | 16 | |||||
| ObjectC26 | Object C26 | VarChar | Y) Yes N) No | 1 | N | |||
| CBFilter | Closing Balances Filter | VarChar | 1) Closing Balance of Life-to-Date 2) Closing Balance Before Selected Period Only | 1 | 2 | |||
| OBIncluded | Add Opening Balance for Period | VarChar | Y) Yes N) No | 1 | N | |||
| OBFilter | Opening Balances Filter | VarChar | 1) Opening Balance from Start of Company Activity 2) Opening Balance from Start of Fiscal Year | 1 | 1 | |||
| ExportCurr | Export Currency | VarChar | L) Local Currency S) System Currency | 1 | L | |||
| CBIncluded | Add Closing Balances | VarChar | Y) Yes N) No | 1 | N | |||
| SlpFrom | Slp From | nVarChar | 127 | |||||
| SlpTo | Slp To | nVarChar | 127 | |||||
| CBUDF | User-Defined Fields | VarChar | Y) Yes N) No | 1 | N | |||
| CBREF | Reference Fields | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBoxB | Checkbox for Branch | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | Y) Yes N) No | 1 | N | |||
| AcctFltr | Account Filter Enabled | VarChar | Y) Yes N) No | 1 | N | |||
| ZeroLCAmt | Show Zero LC Amount Lines | VarChar | Y) Yes N) No | 1 | N | |||
| SplitByBin | Split By Bin Location | VarChar | Y) Yes N) No | 1 | N | |||
| SplitBySnb | Split By Batch/Serial | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox12 | Check Box 12 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox13 | Check Box 13 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox14 | Check Box 14 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox15 | Check Box 15 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox16 | Check Box 16 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox17 | Check Box 17 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox18 | Check Box 18 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox19 | Check Box 19 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox20 | Check Box 20 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox21 | Check Box 21 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox22 | Check Box 22 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox23 | Check Box 23 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox24 | Check Box 24 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox25 | Check Box 25 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox26 | Check Box 26 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox27 | Check Box 27 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox28 | Check Box 28 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox29 | Check Box 29 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox30 | Check Box 30 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox31 | Check Box 31 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox32 | Check Box 32 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox33 | Check Box 33 | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | 127 | |||||
| BinLocTo | Bin Location To | nVarChar | 127 | |||||
| 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 | E) Enforced Bin Location U) Unenforced Bin Location B) Both N) Bin not activated | 1 | N | |||
| ExItemFrom | Expand from Item | nVarChar | 20 | OITM Items | ||||
| ExItemTo | Expand to Item | nVarChar | 20 | OITM Items | ||||
| ExBPFrom | Expand from BP | nVarChar | 15 | OCRD Business Partner | ||||
| ExBPTo | Expand to BP | nVarChar | 15 | OCRD Business Partner | ||||
| CheckBox34 | Check Box 34 | VarChar | Y) Yes N) No | 1 | N | |||
| CheckBox35 | Check Box 35 | VarChar | Y) Yes N) No | 1 | N | |||
| BlAgreem | Checkbox for Blanket Agreement | VarChar | 1 | N | ||||
| BAFrom | Blanket Agreement From | nVarChar | 8 | |||||
| BATo | Blanket Agreement To | nVarChar | 8 | |||||
| AdjTrans | Adjustment Transactions | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | Y) Yes N) No | 1 | N | |||
| CardFrom3 | From BP | nVarChar | 15 | |||||
| CardTo3 | To BP | nVarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
