SAP Business One SDK 10.0 - Database Tables Reference
-
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 |