📚 SAP Business One SDK Help

Table Name: OFPR

Table Description: Posting Period

Field Description Type Size Related Default Value Constraints
AbsEntry System Number Int 11 -      
Code Period Code nVarChar 20 -      
Name Period Name nVarChar 20 -      
F_RefDate Posting Date From Date 8 -      
T_RefDate Posting Date To Date 8 -      
F_DueDate Due Date From Date 8 -      
T_DueDate Due Date To Date 8 -      
F_TaxDate Document Date From Date 8 -      
T_TaxDate Document Date To Date 8 -      
Free2 Free VarChar 1 - Y Y Yes
            N No
Free3 Free VarChar 1 - N N Unlocked
            S Unlocked Except Sales
            C Closing Period
            Y Locked
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
SubNum No. of Sub-Period Int 11 -      
Free Free VarChar 1 -      
Free1 Free1 VarChar 1 -      
Addition Additional Sub-Periods VarChar 1 - N Y Yes
            N No
AddNum No. of Additional Int 11 -      
Category Category nVarChar 10 OACP      
Indicator Period Indicator nVarChar 10 OPID      
LogInstanc Log Instance Int 11 - 0    
UpdateDate Date of Update Date 8 -      
WasStatChd Status Was Checked VarChar 1 - N N No
            Y Yes
PeriodStat Period Status VarChar 1 - N N Unlocked
            S Unlocked Except Sales
            C Closing Period
            Y Locked
            A Archived
UserSign2 Updating User Int 6 OUSR      
Key Unique Field
PRIMARY Yes AbsEntry
CODE Yes Code
NAME Yes Name