📚 SAP Business One SDK Help

Table Name: OFRT

Table Description: Financial Report Templates

Field Description Type Size Related Default Value Constraints
AbsId Internal Number Int 11 -      
Name Name nVarChar 100 -      
DocType Template Type VarChar 1 - B B Balance Sheet
            P Profit and Loss
            C Trial Balance
            F Statement of Cash Flows
            S Sales Unit
            T Form 6111
            A Cost Accounting
            E Asset Devalue Provision
            R Shareholder's Rights and Interests Changing
            D Profit Distribution
            V VAT Payable Detail
            L e-Balance Sheet
            O e-Profit and Loss
            H Asset History Sheet
            G Others
            I Taxable Profit and Loss
            J Appropriation of Net Profit
            K E-Asset History Sheet
FRTCounter Financial Report Template Counter Int 6 -      
MoveChk1 Move Chk1 VarChar 1 - N Y Yes
            N No
MoveChk2 Move Chk2 VarChar 1 - N Y Yes
            N No
MoveTo_1 Move To 1 Int 6 - 0    
MoveTo_2 Move To 2 Int 6 - 0    
Title_1 Title 1 nVarChar 100 -      
Title_2 Title 2 nVarChar 100 -      
ShowMiss Display Missing Accounts VarChar 1 - N Y Yes
            N No
ToTitle_1 Move To Title 1 Int 6 - 0    
ToTitle_2 Move To Title 2 Int 6 - 0    
UserSign User Signature Int 6 OUSR      
DimCode In Which Dimension Int 11 ODIM      
Key Unique Field
PRIMARY Yes AbsId
SECOND Yes DocType
    Name