Home Up Contents

 Univ AttrDtlRpt
Back Next

 

Home
Up

University Global Data Model

Attribute Detail Report

Subject Area: ACCOUNTING

Attribute Description
  Entity KeyTp Data Type Length
1099 Category CDE A code defining the 1099 category as determined by the IRS.
  ACCOUNTS PAYABLE JOURNAL FK alphanumeric 2
A21 CDE A code defining the overhead allocations option for a particular expense.
  ACCOUNTS PAYABLE JOURNAL FK alphanumeric 2
Academic YR A 4 digit number, using the last calendar year in the academic calendar that delineates the entire academic year.
  TUITION RECEIVABLE JOURNAL FK alphanumeric 4
Account Allocation PCT The percentage of the interest earned to be allocated to the account.
  ACCOUNT INTEREST ACCOUNT   none 0
Account CDE A categorization used to arrange and classify dollars controlled by the university.
  ACCOUNT   real 99999.
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Account Custodian Type CDE A code representing a type of custodian. EXAMPLE: Principal Investigator, Account Custodian.
  ACCOUNT CUSTODIAN PFK alphanumeric 1
  ACCOUNT CUSTODIAN TYPE PK    
Account Custodian Type DSC A description of an account custodian type.
  ACCOUNT CUSTODIAN TYPE   alphanumeric 30
Account ID The identifier of the account.
  ACCOUNT CUSTODIAN PFK integer 999999999.
  ACCOUNT GUARANTOR PFK    
  ACCOUNT GUARANTOR PFK    
  ACCOUNT INTEREST ACCOUNT PFK    
  ACCOUNT INTEREST ACCOUNT PFK    
  ACCOUNT PK    
  REVENUE EXPENSE ACCOUNT I,PK    
  BALANCE SHEET ACCOUNT I,PK    
  REVENUE EXPENSE ACCOUNT FK    
Account Long DSC The description of the account.
  ACCOUNT   alphanumeric 150
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Account Object ID The unique method of identifying an account object code. This is just a surrogate key instead of all the elements that make up the candidate key.
  ACCOUNT BALANCE PFK integer 999999999.
  LEDGER TRANSACTION PFK    
  ACCOUNTS PAYABLE JOURNAL I,PFK    
  ACCOUNTS RECEIVABLE JOURNAL I,PFK    
  INVENTORY TRANSACTION I,PFK    
  TUITION RECEIVABLE JOURNAL I,PFK    
  DONATION I,PFK    
  GENERAL JOURNAL I,PFK    
  INTERNAL SERVICE CHARGE ADVICE I,PFK    
  PAYROLL JOURNAL I,PFK    
  RENT RECEIVABLE JOURNAL I,PFK    
  TRANSFER JOURNAL I,PFK    
  BALANCE SHEET LEDGER I,PFK    
  REVENUE EXPENSE LEDGER I,PFK    
  ACCOUNT OBJECT PK    
  ACCOUNT OBJECT      
Account Object NME The name or title of this account object combination.
  ACCOUNT OBJECT   alphanumeric 30
Account Object TXT The format of an account object number to use for display and printing purposes.
  ACCOUNT OBJECT   alphanumeric 17
Account Short NME The name of the account.
  ACCOUNT   alphanumeric 50
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Accounting Period CDE A listing of valid accounting periods, this loosely resembles a calendar month.
  ACCOUNT BALANCE PFK alphanumeric 2
  BALANCE SHEET LEDGER I,PFK    
  REVENUE EXPENSE LEDGER I,PFK    
  ACCOUNTING PERIOD PK    
  LEDGER TRANSACTION FK    
  ACCOUNTS PAYABLE JOURNAL I,FK    
  ACCOUNTS RECEIVABLE JOURNAL I,FK    
  INVENTORY TRANSACTION I,FK    
  TUITION RECEIVABLE JOURNAL I,FK    
  DONATION I,FK    
  GENERAL JOURNAL I,FK    
  INTERNAL SERVICE CHARGE ADVICE I,FK    
  PAYROLL JOURNAL I,FK    
  RENT RECEIVABLE JOURNAL I,FK    
  TRANSFER JOURNAL I,FK    
Accounting Period DSC The description of the accounting period.
  ACCOUNTING PERIOD   alphanumeric 30
Alpha Abbreviation ID An alphabetic abbreviation, unique to each organization. Can be used in place of the numeric identifier.
  ORGANIZATION   alphanumeric 5
Award NBR A number assigned to each project awarded.
  ACCOUNT OBJECT FK integer 999999999.
Begin DTE The first day of a fiscal year.
  FISCAL YEAR   Date 0
  SPONSOR      
  INTEREST ALLOCATION CODE      
  ORGANIZATION      
  ACCOUNT      
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Birth DTE The person's date of birth.
  PERSON   Date 0
  EMPLOYEE I    
Budget Position Control FLG Indicates whether or not the account must have a position approved by the budget office to pay salaries from
  REVENUE EXPENSE ACCOUNT   alphanumeric 1
Budget_Require_FTE_FLG Whether or not an FTE is required to budget money for the object type. This attribute applies to revenue and expense types which are members of the General Personal Services object class.
  REVENUE EXPENSE OBJECT TYPE   alphanumeric 1
Budget_Require_Job_Class_FLG Whether or not a Job Class is required to budget money for the object type. This attribute applies to revenue and expense types which are members of the General Personal Services object class.
  REVENUE EXPENSE OBJECT TYPE   alphanumeric 1
Budgetable FLG An indicator of whether or not the account is available to be budgeted.
  REVENUE EXPENSE ACCOUNT   alphanumeric 1
Charge CDE A code defining the type of a charge. EXAMPLE: personal, direct, indirect.
  CHARGE TYPE PK alphanumeric 2
  OBJECT CODE FK    
Charge DSC A description of the charge type.
  CHARGE TYPE   alphanumeric 30
Current FLG An indicator of whether or not the fund is current.
  FUND   alphanumeric 1
Current NME The name a person is currently using. Previous names are stored in PERSON NAME HISTORY. EXAMPLE: When a person marries and assumes their spouse's LAST NAME.
  PERSON   None  
  EMPLOYEE I    
Custodian Type Begin DTE The begin date of this custodian type.
  ACCOUNT CUSTODIAN TYPE   Date 0
Custodian Type End DTE The end date of this custodian type.
  ACCOUNT CUSTODIAN TYPE   Date 0
Debit Credit CDE A code used to identify the transaction as being a debit or a credit.
  LEDGER TRANSACTION   alphanumeric 1
  ACCOUNTS PAYABLE JOURNAL I    
  ACCOUNTS RECEIVABLE JOURNAL I    
  INVENTORY TRANSACTION I    
  TUITION RECEIVABLE JOURNAL I    
  DONATION I    
  GENERAL JOURNAL I    
  INTERNAL SERVICE CHARGE ADVICE I    
  PAYROLL JOURNAL I    
  RENT RECEIVABLE JOURNAL I    
  TRANSFER JOURNAL I    
Deceased FLG A flag indicating whether or not the person is deceased.
  PERSON   alphanumeric 1
  EMPLOYEE I    
Deficit Due DTE The due date upon which the deficit amount is no longer a deficit.
  BALANCE SHEET ACCOUNT   Date 0
Deficit Limit AMT Amount of money an account can go over budget.
  BALANCE SHEET ACCOUNT   real 999999999.99
Delete CDE A code used to define when the account is to be deleted.
  DELETE CODE PK alphanumeric 1
  ACCOUNT FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Delete DSC A description of the delete code. Which year it is to be deleted.
  DELETE CODE   alphanumeric 30
Dependant CNT A count of the number of dependents for an employee.
  EMPLOYEE   integer 99999.
DFSR CDE Development fund status report code.
  DFSR CODE PK alphanumeric 2
  BALANCE SHEET ACCOUNT FK    
DFSR DSC Development fund status report code description.
  DFSR CODE   alphanumeric 30
Display Account TXT The format of an account number to use for display and printing purposes.
  ACCOUNT   alphanumeric 12
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Drop FLG An indicator that the account is to be dropped.
  ACCOUNT   alphanumeric 1
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Earned Income Credit FLG A flag used to identify whether or not the employee has filed a W5 form.
  EMPLOYEE   alphanumeric 1
Employment Status CDE A code used to define the status of a person's employment.
  EMPLOYEE FK alphanumeric 2
End DTE The last day of a fiscal year.
  FISCAL YEAR   Date 0
  SPONSOR      
  INTEREST ALLOCATION CODE      
  ORGANIZATION      
  ACCOUNT      
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Ethnic CDE A code used when asking a person to classify his or her ethnic origin.
  PERSON FK alphanumeric 2
  EMPLOYEE I,FK    
Exempt CDE A code used to identify the employee as being subject or not subject to the Fair Labor Standards Act.
  EMPLOYEE FK alphanumeric 1
FAS Account NBR The old accounting system account number.
  ACCOUNT   alphanumeric 6
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
FAS Account Object NBR The old account number used in the old accounting system.
  ACCOUNT OBJECT   alphanumeric 10
Federal Withholding FLG A flag used to identify the employee as being subject to federal income tax withholding.
  EMPLOYEE   alphanumeric 1
FICA FLG A flag used to define an employee as being subject to FICA tax.
  EMPLOYEE   alphanumeric 1
First NME A person's first given name.
  PERSON   alphanumeric 30
  EMPLOYEE I    
Fiscal YR A listing of the accounting years.
  ACCOUNT BALANCE PFK alphanumeric 4
  ACCOUNTING PERIOD PFK    
  BALANCE SHEET LEDGER I,PFK    
  REVENUE EXPENSE LEDGER I,PFK    
  FISCAL YEAR PK    
  LEDGER TRANSACTION FK    
  ACCOUNTS PAYABLE JOURNAL I,FK    
  ACCOUNTS RECEIVABLE JOURNAL I,FK    
  INVENTORY TRANSACTION I,FK    
  TUITION RECEIVABLE JOURNAL I,FK    
  DONATION I,FK    
  GENERAL JOURNAL I,FK    
  INTERNAL SERVICE CHARGE ADVICE I,FK    
  PAYROLL JOURNAL I,FK    
  RENT RECEIVABLE JOURNAL I,FK    
  TRANSFER JOURNAL I,FK    
Fixed Price FLG An indicator that this account can only have fixed priced contracts applied against it.
  ACCOUNT   alphanumeric 1
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Freeze FLG An indicator that the account has been frozen to future activity.
  ACCOUNT   alphanumeric 1
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Freeze FLG A flag used to identify the account as being frozen to new transactions.
  ACCOUNT OBJECT   alphanumeric 1
Fund DSC The description of the fund type.
  FUND   alphanumeric 30
Fund NBR An identifier of the fund type.
  FUND OBJECT TYPE PFK alphanumeric 2
  FUND STATEMENT TYPE PFK    
  SUB FUND PFK    
  FUND PK    
  ACCOUNT FK    
  FUND FK    
  LETTER OF CREDIT FK    
  SUB FUND FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
HARCO Card NBR A number assigned by the HARCO system. HARCO is the vendor of student identification validiation hardware and software in use at the university.
  PERSON   integer 999999999.
  EMPLOYEE I    
Interest Allocation CDE A code used to define how to allocate interest to an account.
  INTEREST ALLOCATION CODE PK alphanumeric 2
  BALANCE SHEET ACCOUNT FK    
Interest Allocation DSC A description of the interest allocation method.
  INTEREST ALLOCATION CODE   alphanumeric 30
International Registration DTE The date the person received his or her alien registration number.
  PERSON   Date 0
  EMPLOYEE I    
International Registration NBR A number assigned to a person by the government if they are not a US citizen.
  PERSON   alphanumeric 10
  EMPLOYEE I    
Item ID The part, supply item, or service consumed by the university.
  INVENTORY TRANSACTION FK alphanumeric 9
Last NME A person's family (sur-) name.
  PERSON   alphanumeric 30
  EMPLOYEE I    
Letter Of Credit AMT The stated amount of this letter of credit.
  LETTER OF CREDIT   real 999999999.99
Letter Of Credit DSC The description of this letter of credit.
  LETTER OF CREDIT   alphanumeric 30
Letter Of Credit NBR The unique identifier of this letter of credit.
  LETTER OF CREDIT PK integer 999999999.
  ACCOUNT FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Mail CDE A code used to describe the destination of mail as delivered by mailing bureau.
  PERSON MAIL CODE PFK integer 99999.
  MAIL CODE PK    
  ORGANIZATION FK    
Mail Type CDE A listing of types of mail a person could be sent.
  PERSON MAIL CODE PFK alphanumeric 2
  PERSON MAIL TYPE PK    
Mail Type DSC A description of types of mail a person could be sent.
  PERSON MAIL TYPE   alphanumeric 30
Marital Status CDE The code used to identify the marital status of a person.
  PERSON FK alphanumeric 1
  EMPLOYEE I,FK    
Middle NME A person's given middle name.
  PERSON   alphanumeric 30
  EMPLOYEE I    
Military Reserve CDE A code used to identify the status of a person in the military reserves.
  EMPLOYEE FK alphanumeric 2
Month To Date AMT The summation of transactions for the specified period.
  REVENUE EXPENSE LEDGER   real 9999999999.99
NACUBO Class CDE The identifier of the National Association of Colleges and University Business Officers.
  NACUBO CLASS PK alphanumeric 2
  ACCOUNT FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
NACUBO Class DSC The description of the NACUBO class.
  NACUBO CLASS   alphanumeric 30
NACUBO Function CDE A code used to define the NACUBO classifications.
  NACUBO FUNCTION PK alphanumeric 4
  NACUBO CLASS FK    
NACUBO Function DSC A description of the NACUBO functions as NACUBO has defined them.
  NACUBO FUNCTION   alphanumeric 30
Object CDE A further classification of the account.
  OBJECT CODE PK alphanumeric 4
Object Class CDE The code to indentify an object class. For example, ICM for Income, CS for Cost of Sales, NPS for Non Personal Services, and so forth.
  OBJECT_CLASS PK alphanumeric 3
  REVENUE EXPENSE OBJECT TYPE FK    
Object Class NME The Name of the object class. Examples inlcude Income, Cost of Sales, General Personal Services, and so forth.
  OBJECT_CLASS   alphanumeric 40
Object Type CDE A code used to group accounts into related areas.
  FUND OBJECT TYPE PFK real 99.
  OBJECT CODE PFK    
  OBJECT TYPE HIERARCHY PFK    
  OBJECT TYPE HIERARCHY PFK    
  OBJECT TYPE PK    
  BALANCE SHEET OBJECT TYPE I,PK    
  REVENUE EXPENSE OBJECT TYPE I,PK    
Object Type Long DSC A description of the object type.
  OBJECT TYPE   alphanumeric 40
  BALANCE SHEET OBJECT TYPE I    
  REVENUE EXPENSE OBJECT TYPE I    
Object Type Short NME The description of the account object type.
  OBJECT TYPE   alphanumeric 18
  BALANCE SHEET OBJECT TYPE I    
  REVENUE EXPENSE OBJECT TYPE I    
Org Structure Type CDE A code representing a type of organizational roll-up (Hierarchy). Example: FI = Financial Roll-up, BU = Budget Roll-up
  ORGANIZATION STRUCTURE PFK alphanumeric 2
  ORGANIZATION STRUCTURE TYPE PK    
Org Structure Type DSC A textual description of an organizational structure (roll-up or hierarchy) code.
  ORGANIZATION STRUCTURE TYPE   alphanumeric 30
Organization ID A sequential number assigned by the system to a university organization for the ppurposes of identification. Each organization across the university has a unique identifying number.
  ORGANIZATION STRUCTURE PFK alphanumeric 5
  ORGANIZATION STRUCTURE PFK    
  ORGANIZATION PK    
  ACCOUNT FK    
  EMPLOYEE FK    
  EMPLOYEE FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Organization NME The name of the organization (key shop, English department, etc.).
  ORGANIZATION   alphanumeric 50
Organization Type CDE A code used to define the various types of an organization.
  ORGANIZATION TYPE PK alphanumeric 4
  ORGANIZATION FK    
Organization Type DSC The description of the organization type.
  ORGANIZATION TYPE   alphanumeric 30
Orphan CDE A code used to define a student as being an orphan or a ward of the state.
  PERSON FK alphanumeric 2
  EMPLOYEE I,FK    
Other Ethnic Category NME An ethnic category a person indicates he or she is a member of that is not part of the ETHNIC CATEGORY table.
  PERSON   alphanumeric 20
  EMPLOYEE I    
Overhead CDE A code used to identify the overhead level for a specific charge.
  OVERHEAD RATE PK alphanumeric 2
  ACCOUNT FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Overhead Class CDE A code used to identify the type of overhead.
  OVERHEAD CLASS PK alphanumeric 2
  OVERHEAD RATE FK    
Overhead Class DSC A description of the overhead class.
  OVERHEAD CLASS   alphanumeric 30
Overhead RTE The rate (as a percentage) that is charged to a given transaction for overhead purposes.
  OVERHEAD RATE   real 999.9999
Pay CDE The code used to identify the type of pay of deduction.
  PAYROLL JOURNAL PFK alphanumeric 2
Payment Type CDE A code used to define the type of a payment.
  LEDGER TRANSACTION FK alphanumeric 2
  ACCOUNTS PAYABLE JOURNAL I,FK    
  ACCOUNTS RECEIVABLE JOURNAL I,FK    
  INVENTORY TRANSACTION I,FK    
  TUITION RECEIVABLE JOURNAL I,FK    
  DONATION I,FK    
  GENERAL JOURNAL I,FK    
  INTERNAL SERVICE CHARGE ADVICE I,FK    
  PAYROLL JOURNAL I,FK    
  RENT RECEIVABLE JOURNAL I,FK    
  TRANSFER JOURNAL I,FK    
Payroll DTE The date of a payroll.
  PAYROLL JOURNAL PFK Date 0
Pension Plan FLG A flag used to identify the employee as belonging to a private pension plan.
  EMPLOYEE   alphanumeric 1
Person ID A sequential number assigned to a person by the system for purposes of identification. Each individual who has a relationship with the university has a unique identifier.
  ACCOUNT CUSTODIAN PFK integer 999999999.
  PAYROLL JOURNAL PFK    
  PERSON MAIL CODE PFK    
  PERSON PK    
  EMPLOYEE I,PK    
  ACCOUNT FK    
  ACCOUNT OBJECT FK    
  ACCOUNTS RECEIVABLE JOURNAL FK    
  LEDGER TRANSACTION FK    
  ORGANIZATION FK    
  ORGANIZATION FK    
  ACCOUNTS PAYABLE JOURNAL I,FK    
  ACCOUNTS RECEIVABLE JOURNAL I,FK    
  INVENTORY TRANSACTION I,FK    
  TUITION RECEIVABLE JOURNAL I,FK    
  DONATION I,FK    
  GENERAL JOURNAL I,FK    
  INTERNAL SERVICE CHARGE ADVICE I,FK    
  PAYROLL JOURNAL I,FK    
  RENT RECEIVABLE JOURNAL I,FK    
  TRANSFER JOURNAL I,FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Personal Identification NBR A number assigned to a person by the system which he or she uses as verification for permission to act in the systems.
  PERSON   alphanumeric 6
  EMPLOYEE I    
Point In Time AMT The actual transaction amount accumulated at a specific point in time.
  BALANCE SHEET LEDGER   real 9999999999.99
Posted TS A time-stamp indicating when the transaction was posted to the account balances.
  LEDGER TRANSACTION   Timestamp 0
  ACCOUNTS PAYABLE JOURNAL I    
  ACCOUNTS RECEIVABLE JOURNAL I    
  INVENTORY TRANSACTION I    
  TUITION RECEIVABLE JOURNAL I    
  DONATION I    
  GENERAL JOURNAL I    
  INTERNAL SERVICE CHARGE ADVICE I    
  PAYROLL JOURNAL I    
  RENT RECEIVABLE JOURNAL I    
  TRANSFER JOURNAL I    
Preferred NME The name a person prefers to be referred to as.
  PERSON   alphanumeric 30
  EMPLOYEE I    
Profession Type CDE A code used to define the type of organization.
  PERSON FK alphanumeric 2
  EMPLOYEE I,FK    
Project To Date AMT The amount of money accumulated for this account from its inception.
  REVENUE EXPENSE LEDGER   real 9999999999.99
Proposal ID A unique identifier of a project.
  ACCOUNT OBJECT FK integer 999.
  ACCOUNT OBJECT FK    
Restricted FLG An indicator that the account has been restricted to further processing against it.
  ACCOUNT   alphanumeric 1
  REVENUE EXPENSE ACCOUNT I    
  BALANCE SHEET ACCOUNT I    
Salutation CDE A code used to define a salutation prefix for a letter of greeting for a person.
  PERSON FK alphanumeric 2
  EMPLOYEE I,FK    
Sex CDE The code for the sex descriptor.
  PERSON FK alphanumeric 2
  EMPLOYEE I,FK    
Social Security NBR The number the government assigns a citizen of the US.
  PERSON   alphanumeric 9
  EMPLOYEE I    
Sponsor ID The identifier of the contract or grant.
  SPONSOR PK alphanumeric 9
  ACCOUNT FK    
  LETTER OF CREDIT FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
State Withholding FLG A flag used to identify the employee as being subject to state withholding tax.
  EMPLOYEE   alphanumeric 1
Statement Type CDE A code used to define an account as being a general ledger or subsidiary ledger.
  FUND STATEMENT TYPE PFK alphanumeric 1
  STATEMENT TYPE CODE PK    
  ACCOUNT FK    
  OBJECT TYPE FK    
  BALANCE SHEET OBJECT TYPE I,FK    
  REVENUE EXPENSE OBJECT TYPE I,FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Statement Type DSC A description of the general ledger/subsidiary ledger code.
  STATEMENT TYPE CODE   alphanumeric 30
Sub Fund ID The identifier of an independent fiscal and accounting entity with a self-balancing set of accounts. The typical fund is of eight different funds and two groups of accounts. Each fund is defined by the fund type.
  SUB FUND PK real 99.
  ACCOUNT FK    
  SUB FUND FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Sub Fund NME The name of the fund.
  SUB FUND   alphanumeric 30
Suffix NME A suffix that is appended to the end of a person's name. EXAMPLE: Esquire, III
  PERSON   alphanumeric 20
  EMPLOYEE I    
Term CDE A code used to define the term. EXAMPLE: quarter or semester.
  TUITION RECEIVABLE JOURNAL FK alphanumeric 2
Transaction AMT The amount of this transaction for this account.
  LEDGER TRANSACTION   real 999999999.99
  ACCOUNTS PAYABLE JOURNAL I    
  ACCOUNTS RECEIVABLE JOURNAL I    
  INVENTORY TRANSACTION I    
  TUITION RECEIVABLE JOURNAL I    
  DONATION I    
  GENERAL JOURNAL I    
  INTERNAL SERVICE CHARGE ADVICE I    
  PAYROLL JOURNAL I    
  RENT RECEIVABLE JOURNAL I    
  TRANSFER JOURNAL I    
Transaction AMT75 The amount of transaction.
  PAYROLL JOURNAL   real 999999999.99
Transaction DSC A textual description of this specific transaction.
  LEDGER TRANSACTION   alphanumeric 30
  ACCOUNTS PAYABLE JOURNAL I    
  ACCOUNTS RECEIVABLE JOURNAL I    
  INVENTORY TRANSACTION I    
  TUITION RECEIVABLE JOURNAL I    
  DONATION I    
  GENERAL JOURNAL I    
  INTERNAL SERVICE CHARGE ADVICE I    
  PAYROLL JOURNAL I    
  RENT RECEIVABLE JOURNAL I    
  TRANSFER JOURNAL I    
Transaction TS The transaction time stamp.
  LEDGER TRANSACTION PK Timestamp 0
  ACCOUNTS PAYABLE JOURNAL I,PK    
  ACCOUNTS RECEIVABLE JOURNAL I,PK    
  INVENTORY TRANSACTION I,PK    
  TUITION RECEIVABLE JOURNAL I,PK    
  DONATION I,PK    
  GENERAL JOURNAL I,PK    
  INTERNAL SERVICE CHARGE ADVICE I,PK    
  PAYROLL JOURNAL I,PK    
  RENT RECEIVABLE JOURNAL I,PK    
  TRANSFER JOURNAL I,PK    
Veteran CDE The code defining the type of a veteran.
  PERSON FK alphanumeric 50
  EMPLOYEE I,FK    
Veteran Chapter CDE The code used to identify the veteran status.
  PERSON FK alphanumeric 2
  EMPLOYEE I,FK    
VISA CDE The identifier of the visa type.
  PERSON FK alphanumeric 2
  EMPLOYEE I,FK    
VISA Expiration DTE The date this person's visa expires.
  EMPLOYEE   Date 0
VISA Original Issue DTE The date this person's visa was issued.
  EMPLOYEE   Date 0
Voucher NBR The number assigned to the voucher.
  ACCOUNTS PAYABLE JOURNAL FK alphanumeric 10
Year End Processing CDE The identifier of the type of processing to occur at year end based on a specified account.
  YEAR END PROCESSING CODE PK alphanumeric 1
  ACCOUNT FK    
  REVENUE EXPENSE ACCOUNT I,FK    
  BALANCE SHEET ACCOUNT I,FK    
Year End Processing DSC The description of the processing code.
  YEAR END PROCESSING CODE   alphanumeric 30
Year To Date AMT The actual amount of transactions accumulated year-to-date.
  REVENUE EXPENSE LEDGER   real 9999999999.99
 

 

[ Back ] [ Home ] [ Up ] [ Next ]

Send mail to caseware@cwti.com with questions or comments about this web site.
Copyright © 2000 CASEware Technology Inc.
Last modified: June 13, 2007