Definition of table acct

Accounts file. , Table Dump Name acct

Alphabetical Field Summary

acct-alias: (CHAR) Alias for account or blank

acct-closed: (LOGC) If Set, indicates the account was closed into next fiscal ye

acct-debit: (LOGC) Account balance type (Debit or Credit)

acct-desc: (CHAR) Description of account

acct-fund: (CHAR) Fund number

acct-group: (CHAR) Group (Asset,Liability,Equity,Expense,Revenue,etc)

acct-num: (CHAR) Account Number

acct-open: (LOGC) Account Status (Open/Closed)

acct-rationale: (CHAR) Rationale for account

acct-raw: (CHAR) Raw Account Number

begin-balance: (DECM) Starting balance for the fiscal year

cash-acct-num: (CHAR) Cash Account for this Expense/Revenue account (REQUIRED)

cre-date: (DATE) Date of record creation

cre-time: (CHAR) Time record was created

cre-user-name: (CHAR) Name of user who created the record

cur-balance: (DECM) Account activity for the year including the beginning balanc

cur-budget: (DECM) Current fiscal year budget amount

cur-encumbered: (DECM) All encumberances for current fiscal year

enforce-budget: (LOGC) Yes if budget should be enforced, No if overrides are allowe

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

fa-acct-num: (CHAR) Fixed Asset Account Number associated with this account

fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)

level[10]: (CHAR) Each part of the account level is placed in here

ny-acct-num: (CHAR) Next Year's account number

ny-activated: (LOGC) Set if the next years account has been activated

ny-budget: (DECM) Next Years budget amount

ny-created: (LOGC) Set if the next years account has been created

per-amount[12]: (DECM) Period account acivity

per-encumbered[12]: (DECM) Period Encumberances

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

py-acct-num: (CHAR) Previous Year's account

py-balance: (DECM) Previous Years final balance

py-begin-balance: (DECM) Previous years beginning balance

py-budget: (DECM) Previous Year's budget amount

terminal-acct: (LOGC) Yes if this account will not be carried to next fiscal year

upd-date: (DATE) Date of last record update

upd-time: (CHAR) Record last updated at

upd-user-name: (CHAR) Name of user record was updated by

user1: (CHAR) User defined field

user2: (CHAR) User defined field

user3: (CHAR) User defined field

user4: (CHAR) User defined field

user5: (CHAR) User defined field

user6: (CHAR) User defined field

Alphabetical Index Summary

acct-alias: fiscal-year, acct-alias

acct-desc: fiscal-year, acct-desc

acct-fund: (UNIQUE) fiscal-year, acct-fund, acct-group, acct-num

acct-group: fiscal-year, acct-group

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

acct-raw: (UNIQUE) fiscal-year, acct-raw

extern-guid: extern-guid

ny-acct-num: fiscal-year, ny-acct-num

py-acct-num: fiscal-year, py-acct-num

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference acct

acct-class-acct - Account Class Account List

ap-line - AP Transaction Line/Account file

ar-line - AR Line item files

bi-line - Invoice Account Line Items

billing-catalog - (no description available)

billing-period-item - (no description available)

bud-detail - Detail account budgeting

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

ds-line - Disbursment Line/Account file

entity - Definitions for vendors & customers

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

fund - Description file for the funds

gl-line - GL Transaction Line items

inv-line - Invoice Line items file

item-acct - Account Distribution Table for Fixed Assets

po-line - Line/Account file for the PO

rc-line - Receipts Line Item file

Tables acct references

acct-class-acct - Account Class Account List

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

fund - Description file for the funds

period - Period definition file. This defines the start/stop of each

Detailed Alphabetical Field Listing
acct-alias Data type: CHARACTER
Format: x(28)
Help: Alias for account or blank
Attributes: Index Component

acct-closed Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: If Set, indicates the account was closed into next fiscal ye

acct-debit Data type: LOGICAL
Format: Debit/Credit (Initial Value: yes)
Description: Account balance type (Debit or Credit)

acct-desc Data type: CHARACTER
Format: x(28)
Help: Description of account
Attributes: Index Component

acct-fund Data type: CHARACTER
Format: x(8)
Help: Fund number
Attributes: Index Component, Mandatory

acct-group Data type: CHARACTER
Format: x(12)
Help: Group (Asset,Liability,Equity,Expense,Revenue,etc)
Attributes: Index Component, Mandatory

acct-num Data type: CHARACTER
Format: x(30)
Help: Account Number
Attributes: Index Component, Mandatory

acct-open Data type: LOGICAL
Format: Open/Closed (Initial Value: Open)
Help: Account Status (Open/Closed)

acct-rationale Data type: CHARACTER
Format: x(28)
Help: Rationale for account

acct-raw Data type: CHARACTER
Format: x(30)
Description: Raw Account Number
Attributes: Index Component

begin-balance Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: Starting balance for the fiscal year

cash-acct-num Data type: CHARACTER
Format: x(30)
Help: Cash Account for this Expense/Revenue account (REQUIRED)

cre-date Data type: DATE
Format: 99/99/9999
Description: Date of record creation

cre-time Data type: CHARACTER
Format: x(8)
Help: Time record was created

cre-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who created the record

cur-balance Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: Account activity for the year including the beginning balanc

cur-budget Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Help: Current fiscal year budget amount

cur-encumbered Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: All encumberances for current fiscal year

enforce-budget Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if budget should be enforced, No if overrides are allowe

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

fa-acct-num Data type: CHARACTER
Format: x(30)
Help: Fixed Asset Account Number associated with this account
Attributes: Mandatory

fiscal-year Data type: CHARACTER
Format: 9999
Description: Start year of fiscal year (i.e. 1992 for FY 1992/1993)
Attributes: Index Component

level Data type: CHARACTER (Extent: 10)
Format: x(6)
Description: Each part of the account level is placed in here

ny-acct-num Data type: CHARACTER
Format: x(30)
Help: Next Year's account number
Attributes: Index Component

ny-activated Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Set if the next years account has been activated

ny-budget Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Help: Next Years budget amount

ny-created Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Set if the next years account has been created

per-amount Data type: DECIMAL (Extent: 12, Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: Period account acivity

per-encumbered Data type: DECIMAL (Extent: 12, Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: Period Encumberances

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

py-acct-num Data type: CHARACTER
Format: x(30)
Help: Previous Year's account
Attributes: Index Component

py-balance Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: Previous Years final balance

py-begin-balance Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: Previous years beginning balance

py-budget Data type: DECIMAL (Decimals: 2)
Format: (zzz,zzz,zz9.99) (Initial Value: 0)
Description: Previous Year's budget amount

terminal-acct Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this account will not be carried to next fiscal year

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

upd-time Data type: CHARACTER
Format: x(8)
Help: Record last updated at

upd-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user record was updated by

user1 Data type: CHARACTER
Format: x(8)
Help: User defined field

user2 Data type: CHARACTER
Format: x(8)
Help: User defined field

user3 Data type: CHARACTER
Format: x(8)
Help: User defined field

user4 Data type: CHARACTER
Format: x(8)
Help: User defined field

user5 Data type: CHARACTER
Format: x(8)
Help: User defined field

user6 Data type: CHARACTER
Format: x(30)
Help: User defined field

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