Definition of table period

Period definition file. This defines the start/stop of each period for each fiscal year. , Table Dump Name period

Alphabetical Field Summary

credate: (DATE) Date of record creation

cur-year-flag: (LOGC) Set if this period is the 'current' year

eoy-phase-name: (CHAR) EOY Processing Phase Name (CREATE, ACTIVATE, END or "")

eoy-phase-state: (CHAR) State of current EOY Phase (BEGIN, RUN, END or "")

extern-guid: (CHAR) External Global Unique ID for this record

fiscal-year: (CHAR) Start year of fiscal year

fy-active: (LOGC) Set if current fiscal year is 'Active'

fy-end: (DATE) Last date of the fiscal year

fy-label: (CHAR) Label/name of this fiscal year

fy-start: (DATE) Start Date for fiscal year

ny-active: (LOGC) Set if the next fiscal year has been 'Activated'

per-closed[12]: (DATE) Date period was closed

per-count: (INTG) Number of periods in fiscal year (1-12)

per-end[12]: (DATE) Period end date

per-qtr[12]: (INTG) Quarter period is in (1-4)

per-start[12]: (DATE) Period start date

per-status[12]: (CHAR) Period Status (Open, Closed or Active)

primary-key: (INTG) Unique, Primary key for table/record

upddate: (DATE) Date of last record update

Alphabetical Index Summary

cur-year: cur-year-flag

extern-guid: extern-guid

fiscal-year: (UNIQUE, PRIMARY) -fiscal-year

fy-label: fy-label, fiscal-year

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-prd.p (SOURCE NOT AVAILABLE)

DELETE: Overridable, Procedure is tr-d-prd.p (SOURCE NOT AVAILABLE)

REPLICATION-CREATE: Procedure is rp-c-prd.p (SOURCE NOT AVAILABLE)

REPLICATION-DELETE: Procedure is rp-d-prd.p (SOURCE NOT AVAILABLE)

REPLICATION-WRITE: Procedure is rp-u-prd.p (SOURCE NOT AVAILABLE)

WRITE: Overridable, Procedure is tr-u-prd.p (SOURCE NOT AVAILABLE)

Other tables who reference period

acct - Accounts file.

acct-class - Account Class Definitions

acct-class-acct - Account Class Account List

acct-class-user - Account Class users

ap-line - AP Transaction Line/Account file

ap-tran - AP Transaction Header file.

ar-line - AR Line item files

ar-tran - Accounts Receivable transactions file

bank-acct - Definition of a banking account for a district. This may in

bi-desc - Invoice Line Descriptions

bi-line - Invoice Account Line Items

bi-tran - Billing Transactions file

billing-catalog - (no description available)

billing-group - (no description available)

billing-period - (no description available)

billing-period-item - (no description available)

bud-detail - Detail account budgeting

bud-phase - Identify each phase (or step) in the budgeting process

cash-acct - Cash Accounts definition file. This defines each possible

check-run - Contains one record for each possible check run for the fisc

ds-desc - Disbursment invoice description file

ds-line - Disbursment Line/Account file

ds-tran - Disbursment transaction file

ent-class - Vendor/Source classifications

entity - Definitions for vendors & customers

fa-class-code - Fixed Assets Item Class Table

fa-depreciate-schd - Depreciation Schedules for Fixed Asset Items

fa-item-group - Item Grouping table for fixed assets

fa-transaction-code - Transaction Codes for Fixed Asset Item History

fund - Description file for the funds

gl-line - GL Transaction Line items

gl-tran - GL Transaction headers

group-def - Definitions for the various account groups

inv-line - Invoice Line items file

invoice - Invoice file. This keeps a detail of vendor invoices.

item-acct - Account Distribution Table for Fixed Assets

item-history - Item History Table for Fixed Assets

item-tran - Fixed Assets Item

journal - Journal Codes file

level-desc - Account Level descriptions. There is one record for each

level-item - Name or description of each component of an account number a

po-desc - Description items for the PO

po-group - Defines logically named groups of PO activity. Can be used t

po-group-user - Records of which users are allowed into a PO group

po-line - Line/Account file for the PO

po-recv - Receiving detail of PO item

po-recv-item - PO Fixed Asset Item Linkage

po-tran - PO transaction/file entries

rc-desc - Receipt Invoice lines

rc-line - Receipts Line Item file

rc-tran - Receipts Transaction file

Detailed Alphabetical Field Listing
credate Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of record creation

cur-year-flag Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Set if this period is the 'current' year
Attributes: Index Component

eoy-phase-name Data type: CHARACTER
Format: x(8)
Description: EOY Processing Phase Name (CREATE, ACTIVATE, END or "")

eoy-phase-state Data type: CHARACTER
Format: x(8)
Description: State of current EOY Phase (BEGIN, RUN, END or "")

extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component

fiscal-year Data type: CHARACTER
Format: 9999
Description: Start year of fiscal year
Attributes: Index Component

fy-active Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Set if current fiscal year is 'Active'

fy-end Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Help: Last date of the fiscal year

fy-label Data type: CHARACTER
Format: x(9)
Help: Label/name of this fiscal year
Attributes: Index Component

fy-start Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Help: Start Date for fiscal year

ny-active Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Set if the next fiscal year has been 'Activated'

per-closed Data type: DATE (Extent: 12)
Format: 99/99/9999
Description: Date period was closed

per-count Data type: INTEGER
Format: >9 (Initial Value: 12)
Help: Number of periods in fiscal year (1-12)

per-end Data type: DATE (Extent: 12)
Format: 99/99/9999
Help: Period end date

per-qtr Data type: INTEGER (Extent: 12)
Format: 9
Help: Quarter period is in (1-4)

per-start Data type: DATE (Extent: 12)
Format: 99/99/9999
Help: Period start date

per-status Data type: CHARACTER (Extent: 12)
Format: x(6)
Help: Period Status (Open, Closed or Active)
Attributes: Mandatory

primary-key Data type: INTEGER
Format: zzzzzzzzz9
Help: Unique, Primary key for table/record

upddate Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of last record update

Created on 04/17/2012 by DBHTML V1.2