| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | System Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | Code | Period Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | Name | Period Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | F_RefDate | Posting Date From | date | 8 | 0 | | | | |
| 5 | T_RefDate | Posting Date To | date | 8 | 0 | | | | |
| 6 | F_DueDate | Due Date From | date | 8 | 0 | | | | |
| 7 | T_DueDate | Due Date To | date | 8 | 0 | | | | |
| 8 | F_TaxDate | Document Date From | date | 8 | 0 | | | | |
| 9 | T_TaxDate | Document Date To | date | 8 | 0 | | | | |
| 10 | Free2 | Free | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 11 | Free3 | Free | char | 1 | 0 | | N | C=Closing Period, N=Unlocked, S=Unlocked Except Sales, Y=Locked | Allow NULL? |
| 12 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 13 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 14 | SubNum | No. of Sub-Period | int | 11 | 0 | | | | Allow NULL? |
| 15 | Free | Free | char | 1 | 0 | | | | Allow NULL? |
| 16 | Free1 | Free1 | char | 1 | 0 | | | | Allow NULL? |
| 17 | Addition | Additional Sub-Periods | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 18 | AddNum | No. of Additional | int | 11 | 0 | | | | Allow NULL? |
| 19 | Category | Category | nvarchar | 10 | 0 | OACP | | | Allow NULL? |
| 20 | Indicator | Period Indicator | nvarchar | 10 | 0 | OPID | | | Allow NULL? |
| 21 | LogInstanc | Log Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 22 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 23 | WasStatChd | Status Was Checked | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 24 | PeriodStat | Period Status | char | 1 | 0 | | N | A=Archived, C=Closing Period, N=Unlocked, S=Unlocked Except Sales, Y=Locked | Allow NULL? |
| 25 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |