Tables and Views for FIMSMGR as of 21-JUN-2004 08:13am
Date: 21-JUN-2004 Page: 1
TABLE: CONV1099
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
CONV1099_VEND_PIDM NUMBER 8 YES
CONV1099_RPT_ID VARCHAR2 9 YES
CONV1099_FRS_ACCOUNT VARCHAR2 11 YES
CONV1099_NAME VARCHAR2 30 YES
CONV1099_TAX_YEAR VARCHAR2 2 YES
CONV1099_BANK_CODE VARCHAR2 2 YES
CONV1099_AMT_RENT NUMBER 12 2 YES
CONV1099_AMT_ROYALTIES NUMBER 12 2 YES
CONV1099_AMT_OTHER NUMBER 12 2 YES
CONV1099_AMT_FED_TAX_WITH NUMBER 12 2 YES
CONV1099_AMT_FISHING NUMBER 12 2 YES
CONV1099_AMT_MEDICAL_HEALTH NUMBER 12 2 YES
CONV1099_AMT_NONEMPLOYEE NUMBER 12 2 YES
CONV1099_AMT_SUB_PAYMENTS NUMBER 12 2 YES
CONV1099_AMT_DIRECT_SALES NUMBER 12 2 YES
CONV1099_AMT_CROP_INSURANCE NUMBER 12 2 YES
CONV1099_AMT_GOLDEN_PARACHUTE NUMBER 12 2 YES
CONV1099_AMT_LEGAL_SERVICES NUMBER 12 2 YES
CONV1099_AMT_ST_TAX_WITH NUMBER 12 2 YES
Date: 21-JUN-2004 Page: 2
TABLE: EXCEPTIONS
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ROW_ID ROWID 10 YES
OWNER VARCHAR2 30 YES
TABLE_NAME VARCHAR2 30 YES
CONSTRAINT VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 3
TABLE: FAB1099
CREATOR: FIMSMGR
1099 Tax Detail Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FAB1099_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION MASTER: The unique
personal identification master of a vendor.
FAB1099_RPT_ID VARCHAR2 9 NO REPORTING ID: The 1099 reporting ID that is associated
with the entity or person that received 1099 payments.
FAB1099_RPT_YR VARCHAR2 2 NO
FAB1099_CHECK_NUM VARCHAR2 8 NO CHECK NUMBER: The pre-printed check number.
FAB1099_BANK_CODE VARCHAR2 2 NO BANK CODE: A user-defined value which is used for
identification purposes on all cash transactions.
FAB1099_INVH_CODE VARCHAR2 8 NO DOCUMENT: The unique number of the document being
updated.
FAB1099_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FAB1099_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FAB1099_RPT_AMT NUMBER 12 2 YES
FAB1099_ITYP_SEQ_CODE NUMBER 2 YES INTERNAL SEQUENCE CODES: Predefined internal codes
which represent transaction types that direct these
data values to specific accumulators in the operating
account ledger (OPAL).
FAB1099_CHECK_DATE DATE 7 YES CHECK DATE: The date of issue for a check.
FAB1099_FED_WHOLD_AMT NUMBER 12 2 YES FEDERAL WITHHOLDING PERCENTAGE: The amount witheld
from a 1099 disbursement for remittance to the
government.
FAB1099_ST_WHOLD_AMT NUMBER 12 2 YES STATE WITHOLDING AMOUNT: The amount witheld for state
taxes from an entitles 1099 payment.
FAB1099_FED_PAID_OVER_AMT NUMBER 12 2 YES FEDERAL PAID OVER AMOUNT: The amount that has been
paid over to the federal government reference in the
Letter of Credit processing.
FAB1099_ST_PAID_OVER_AMT NUMBER 12 2 YES STATE PAID OVER AMOUNT: The amount paid over to the
state or taxing authority as a result of 1099 state
witholdings.
FAB1099_FED_CHECK_NUM VARCHAR2 8 YES FEDERAL CHECK NUMBER:
FAB1099_ST_CHECK_NUM VARCHAR2 8 YES
FAB1099_CANCEL_IND VARCHAR2 1 YES CANCEL INDICATOR: The indicator associated with the
check cancelling processing.
FAB1099_CANCEL_DATE DATE 7 YES CANCELLATION DATE: The date that the check was
cancelled.
Date: 21-JUN-2004 Page: 4
TABLE: FABBKTP
CREATOR: FIMSMGR
Bank Tape Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABBKTP_BANK_CODE VARCHAR2 2 NO BANK CODE: A user-defined value which is used for
identification purposes on all cash transactions.
FABBKTP_CHECK_DEPOSIT_CODE VARCHAR2 8 NO CHECK DEPOSIT CODE: The unique code for a check or
deposit.
FABBKTP_CHECK_DEPOSIT_IND VARCHAR2 1 NO CHECK DEPOSIT INDICATOR: The indicator that specifies
the type of document (transaction) being corrected.
FABBKTP_TRANS_DATE DATE 7 NO TRANSACTION DATE: The date the transaction was
processed.
FABBKTP_TAPE_DATE DATE 7 YES BANK TAPE DATE: The date of the tape received from the
bank for bank reconciliation processing.
FABBKTP_AMT NUMBER 12 2 NO AMOUNT: The bank amount used to reconcile checks and
deposits.
FABBKTP_DESC VARCHAR2 35 YES DESCRIPTION: The description or title of the
encumbrance.
FABBKTP_RECON_IND VARCHAR2 1 YES RECONCILITATION INDICATOR: The indicator of whether a
check or deposit record has been reconciled.
FABBKTP_INTERNAL_DOC_CODE VARCHAR2 8 YES INTERNAL DOCUMENT CODE: The internal code assigned to
each document type for use in identification and
processing of financial activity.
Date: 21-JUN-2004 Page: 5
TABLE: FABBRCC
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABBRCC_ACCT_CODE VARCHAR2 8 YES ACCOUNT CODE: The user-defined value representing an
account.
FABBRCC_DOC_CODE VARCHAR2 8 YES DOCUMENT CODE: The user-defined or system generated
document number.
FABBRCC_TRANS_CODE VARCHAR2 8 NO TRANSACTION CODE: The deposit number assigned to this
transaction.
FABBRCC_TRANS_IND VARCHAR2 1 NO TRANSACTION INDICATOR:
FABBRCC_TRANS_TYPE VARCHAR2 1 NO TRANSACTION TYPE: The unique code for a check or
deposit.
FABBRCC_DR_CR_IND VARCHAR2 1 YES DEBIT/CREDIT INDICATOR: This debit or credit indicator
is used for all general ledger transactions. The plus
(+) or minus (-) indicators are used for all operating
account ledger (OPAL) transactions.
FABBRCC_TRANS_DATE DATE 7 NO TRANSACTION DATE : The date the transaction was
processed.
FABBRCC_AMT NUMBER 12 2 NO AMOUNT : The dollar amount of the transaction.
FABBRCC_TRANS_DESC VARCHAR2 35 YES TRANSACTION DESCRIPTION : A brief description of the
purpose of this record being created.
FABBRCC_ROWID VARCHAR2 26 NO ROW IDENTIFICATION NUMBER:
Date: 21-JUN-2004 Page: 6
TABLE: FABCHKA
CREATOR: FIMSMGR
Batch Check/Invoice Detail Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABCHKA_CHECK_NUM VARCHAR2 8 NO CHECK NUMBER: The pre-printed check number.
FABCHKA_CHECK_DATE DATE 7 NO CHECK DATE: The date of issue for a check.
FABCHKA_BANK_CODE VARCHAR2 2 NO BANK CODE: The user-defined value which is used for
identification purposes on all cash transactions.
FABCHKA_INV_CODE VARCHAR2 8 NO DOCUMENT: The unique number of the document being
updated.
FABCHKA_ITEM NUMBER 4 NO COMMODITY ITEM NUMBER: The literal commodity or goods
description associated with an invoice processing
record. The unique sequence number directly
associated with an item used on the commodity record.
FABCHKA_SEQ_NUM NUMBER 4 NO OPERATING LEDGER SEQUENCE NUMBER: This number
represents a predefined value within BANNER which is
used for operating ledger classification and reporting
purposes.
FABCHKA_FSYR_CODE VARCHAR2 2 NO FISCAL YEAR: A unique two digit numeric identifier
code for the fiscal year being defined. Generally,
the last two digits of the second year of the
accounting period are used.
FABCHKA_PERIOD VARCHAR2 2 NO PERIOD: Refers to a period within a fiscal year.
FABCHKA_GROSS_AMT NUMBER 12 2 YES GROSS AMOUNT: The gross amount of a check.
FABCHKA_TAX_AMT NUMBER 12 2 YES TAX AMOUNT: The dollar value of the sales/use tax
being charged on this invoice.
FABCHKA_DISC_AMT NUMBER 12 2 YES DISCOUNT AMOUNT: The dollar value of the discount
being taken on the invoice.
FABCHKA_ADDL_AMT NUMBER 12 2 YES ADDITIONAL AMOUNT: The amount of additional charges
related to a purchase order or invoice.
FABCHKA_FED_WHOLD_AMT NUMBER 12 2 YES FEDERAL WITHOLDING AMOUNT: The amount witheld from a
1099 disbursement for remittance to the government.
FABCHKA_ST_WHOLD_AMT NUMBER 12 2 YES STATE WITHOLDING AMOUNT: The amount withheld for state
taxes from an entities 1099 payment.
FABCHKA_CR_MEMO_IND VARCHAR2 1 YES CREDIT MEMO INDICATOR: The indicator that the invoice
document is a credit memo.
FABCHKA_CHECK_TYPE_IND VARCHAR2 1 YES CHECK TYPE INDICATOR: An indicator establishing the
type of check produced. M for manual, B for batch, O
for online.
FABCHKA_CANCEL_DATE DATE 7 YES CANCELLATION DATE: The date that the check was
cancelled.
FABCHKA_DISB_AGENT_IND VARCHAR2 1 YES DISBURSING AGENT INDICATOR: Used to identify these
invoice records as one using a disburing agent to
write a check.
FABCHKA_CONVERT_AMT NUMBER 12 2 YES CONVERTED AMOUNT: The base amount calculated for this
accounting record. Used when a currency code is
established at the header record.
FABCHKA_CONVERT_DISC_AMT NUMBER 12 2 YES CONVERTED DISCOUNT AMOUNT: The base discount amount
calculated for this accounting record. Used when a
currency code is established at the header record.
Date: 21-JUN-2004 Page: 7
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABCHKA_CONVERT_TAX_AMT NUMBER 12 2 YES CONVERTED TAX AMOUNT: The base tax amount calculated
for this accounting record. Used when a currency code
is established at the header record.
FABCHKA_CONVERT_ADDL_CHRG_AMT NUMBER 12 2 YES CONVERTED ADDITIONAL CHARGES AMOUNT: The base
additional charges amount calculated for this
accounting record. Used when a currency code is
established at the header record.
Date: 21-JUN-2004 Page: 8
TABLE: FABCHKS
CREATOR: FIMSMGR
Check Summary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABCHKS_CHECK_NUM VARCHAR2 8 NO CHECK NUMBER: The pre-printed check number.
FABCHKS_BANK_CODE VARCHAR2 2 NO BANK CODE: The user-defined value which is used for
identification purposes on all cash transactions.
FABCHKS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FABCHKS_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FABCHKS_CHECK_AMT NUMBER 12 2 NO CHECK AMOUNT: The amount of the check.
FABCHKS_CHECK_DATE DATE 7 NO CHECK DATE: The date of issue for a check.
FABCHKS_CANCEL_IND VARCHAR2 1 YES CANCELLATION INDICATOR: An indicator that the check
was cancelled.
FABCHKS_CANCEL_DATE DATE 7 YES CANCELLATION DATE: The date that the check was
cancelled.
FABCHKS_CHECK_TYPE_IND VARCHAR2 1 NO CHECK TYPE INDICATOR: An indicator establishing the
type of check produced. M for manual, B for batch, O
for online.
FABCHKS_RECON_IND VARCHAR2 1 YES RECONCILITATION INDICATOR: The indicator of whether a
check or deposit record has been reconciled.
FABCHKS_ACH_IND VARCHAR2 1 YES ACH INDICATOR: If Y, indicates that the payment was
made via direct deposit.
Date: 21-JUN-2004 Page: 9
TABLE: FABCKMC
CREATOR: FIMSMGR
MATCHING REPORT COLLECTOR TABLE: Used when running the report fabmatc to group the processed invoices for reporting
purposes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABCKMC_INVH_CODE VARCHAR2 8 NO INVOICE CODE: The invoice document number.
FABCKMC_VENDOR_PIDM NUMBER 8 NO VENDOR PIDM: The pidm of the vendor on the invoice.
FABCKMC_INVOICE_DATE DATE 7 NO INVOICE DATE: The date of the invoice.
FABCKMC_PMT_DUE_DATE DATE 7 NO PAYMENT DUE DATE: The date the invoice payment is due.
FABCKMC_DOC_TOTAL NUMBER 12 2 NO INVOICE_TOTAL: The total approved value of the
invoice.
FABCKMC_MATCH_TYPE NUMBER 1 NO MATCH TYPE INDICATOR: Indicates whether the invoice
matches the receipts. 1-matched. 2 non-matched.
Receiving is in suspense. 3 non-matched. Not enough
receipts.
Date: 21-JUN-2004 Page: 10
TABLE: FABFEDC
CREATOR: FIMSMGR
Fed Credit Card Transaction Control Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABFEDC_CAMPUS_CODE VARCHAR2 8 NO CAMPUS CODE: A unique code that determines a company
within the Institution. Some Institutions may have a
different Company Code to represent each Campus.
Valid values are stored in FTVSDAT.
FABFEDC_CARD_TYPE_CODE VARCHAR2 8 NO CREDIT CARD TYPE: A unique code that determines which
credit card type this the card number is issued under.
Valid values are stored in FTVSDAT and can be VISA,
MC, AMEX, DISCOVER, etc.
FABFEDC_BANK_POST_DATE DATE 7 NO BANK POST DATE: The date the bank posted the
transaction to their system. Informational only.
FABFEDC_SUBMISSION_NUMBER NUMBER 2 NO SUBMISSION NUMBER: A one up number used to control
multiple feeds of the bank posting date. The initial
stored value is zero. If a bank post date duplication
edit is overridden, this number has a 1
added to it
to represent a second submission for the same posting
date. In theory, the detail records for additional
submissions are really a continuation of records not
processed the first time the bank flat file was sent.
However a conscious decision
is made by the client to
do this after reviewing the transactions.
FABFEDC_TOTAL_AMT NUMBER 12 2 NO TOTAL AMOUNT: Summary of all transactions for this
bank posting date for this company/campus for this
submission. Basically pulled from record type 1 of
FATCARD.
FABFEDC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record on the table was entered or last updated.
FABFEDC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user usually defined in table fobprof.
Date: 21-JUN-2004 Page: 11
TABLE: FABINCK
CREATOR: FIMSMGR
Invoice/Check Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINCK_INVH_CODE VARCHAR2 8 NO INVOICE DOCUMENT CODE: The unique identifier of an
invoice document. The code may be system generated by
entering NEXT in the invoice header.
FABINCK_CHECK_NUM VARCHAR2 8 NO CHECK NUMBER: The pre-printed check number.
FABINCK_BANK_CODE VARCHAR2 2 NO BANK NAME: A user-defined value which is used for
identification purposes on all transactions.
FABINCK_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FABINCK_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FABINCK_CHECK_TYPE_IND VARCHAR2 1 NO CHECK TYPE INDICATOR: Indicator which establishes the
type of check produced. M-manual, B-batch, O-on-line.
FABINCK_CHECK_DATE DATE 7 YES CHECK DATE: The date of issue for a check.
FABINCK_NET_AMT NUMBER 12 2 YES NET AMOUNT: The net amount of an invoice.
FABINCK_CANCEL_IND VARCHAR2 1 YES CANCELLATION INDICATOR: Indicates that the check was
cancelled.
FABINCK_CANCEL_DATE DATE 7 YES CANCELLATION DATE: The date that the check was
cancelled.
FABINCK_RECON_IND VARCHAR2 1 NO RECONCILIATION INDICATOR: The indicator of whether a
check or deposit record has been reconciled.
FABINCK_INVH_TRANS_DATE DATE 7 YES INVOICE TRANSACTION DATE : This is the transaction
date of the invoice for which this check was created.
It is updated by the posting process during check
disbursement.
FABINCK_INVH_SUBMISSION_NUMBER NUMBER 3 YES INVOICE SUBMISSION NUMBER: This is the submission
number of the invoice for which this check was
created.It is updated by the posting process during
check disbursement.
Date: 21-JUN-2004 Page: 12
TABLE: FABINVH
CREATOR: FIMSMGR
Invoice Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINVH_CODE VARCHAR2 8 NO Invoice document number.
FABINVH_POHD_CODE VARCHAR2 8 YES PURHCASE ORDER CODE: The date on which a purchase
order was created.
FABINVH_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFCATION MASTER: The unique
personal identification master of a vendor.
FABINVH_OPEN_PAID_IND VARCHAR2 1 NO OPEN PAID INDICATOR: Indicates if a document is open
or paid.
FABINVH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FABINVH_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FABINVH_VEND_INV_CODE VARCHAR2 15 YES VENDOR INVOICE CODE: The vendor's invoice code entered
on the Invoice document.
FABINVH_INVOICE_DATE DATE 7 YES INVOICE DATE: A user-defined or system generated
invoice date.
FABINVH_PMT_DUE_DATE DATE 7 YES PAYMENT DUE DATE: The date an invoice is due.
FABINVH_TRANS_DATE DATE 7 YES TRANSACTION DATE: The date the transaction was
processed.
FABINVH_CR_MEMO_IND VARCHAR2 1 NO CREDIT MEMO INDICATOR: This indicator identifies the
credit memo processing.
FABINVH_ADJT_CODE VARCHAR2 2 YES ADJUSTMENT CODE: The date on which the adjustment was
made.
FABINVH_ADJT_DATE DATE 7 YES ADJUSTMENT DATE: The date on which the adjustment was
made.
FABINVH_1099_IND VARCHAR2 1 YES 1099 INDICATOR: This indicator distinguishes taxable
payments resulting from the payment processing of the
invoice. If Y (yes) the payment will be recorded and
accumulated for income tax reporting purposes.
FABINVH_1099_ID VARCHAR2 9 YES 1099 IDENTIFICATION: The taxpayer identification
number (TIN) which uniquely identifies this vendor for
Federal Income tax purposes. For an individual use
the social security number.
FABINVH_ITYP_SEQ_CODE NUMBER 2 YES INTERNAL SEQUENCE CODES: Predefined internal codes
which represent transactions types i.e. budget
adjustments, that direct theses data values to
specific accumalators in the operating account
ledger(OPAL).
FABINVH_TEXT_IND VARCHAR2 1 YES TEXT INDICATOR: The indicator used on validation
tables and transaction documents which informs the
user that text exists for the record.
FABINVH_APPR_IND VARCHAR2 1 YES APPROVAL INDICATOR: Indicates if the document has been
approved for processing by the individual authorized
(via the user hierarchy table) to approve the
document.
FABINVH_COMPLETE_IND VARCHAR2 1 YES COMPLETE INDICATOR: Indicates if the document has been
completed.
Date: 21-JUN-2004 Page: 13
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINVH_DISC_CODE VARCHAR2 2 YES DISCOUNT CODE: The value of the discount code
established on the form FTVDISC.
FABINVH_TRAT_CODE VARCHAR2 3 YES TAX RATE CODE: The value of the tax rate established
on form FTVTRAT.
FABINVH_ADDL_CHRG_AMT NUMBER 12 2 YES ADDITIONAL CHARGE AMOUNT: The dollar value of any
additional charges, e.g. freight associated with this
invoice.
FABINVH_HOLD_IND VARCHAR2 1 NO INVOICE HOLD INDICATOR: An attribute used to place
invoice reocrds on hold to prevent disbursement to a
vendor.
FABINVH_SUSP_IND VARCHAR2 1 NO SUSPENSE INDICATOR: An indicator to inform the user
that a document is being held in suspense due to
missing or erroneous data content.
FABINVH_SUSP_IND_ADDL VARCHAR2 1 NO
FABINVH_CANCEL_IND VARCHAR2 1 NO CANCELLATION IDENTIFICATION: This one-character
indicator identifies that an invoice has been
cancelled.
FABINVH_CANCEL_DATE DATE 7 YES CANCELLATION DATE: The date that the check was
cancelled.
FABINVH_POST_DATE DATE 7 YES POSTING DATE: The date on which a transaction is
posted.
FABINVH_ATYP_CODE VARCHAR2 2 YES VENDOR ADDRESS TYPE CODE: Used to identify the vendor
address type when creating the invoice. Defaults from
the AP default address identified on the Vendor if the
code is not entered. This is different from the
ATYP_CODE_VEND in that the ATYP_CODE_VEND
FABINVH_ATYP_SEQ_NUM NUMBER 2 YES VENDOR ADDRESS TYPE SEQUENCE NUMBER: Used to identify
the vendor address type sequence number when creating
the invoice. Defaults from the AP default address
sequence number identified on the Vendor if the code
is not entered. This is different from th
FABINVH_GROUPING_IND VARCHAR2 1 YES GROUPING INDICATOR: Indicates the relationship between
the number of invoices processed and the number of
checks written.
FABINVH_BANK_CODE VARCHAR2 2 YES BANK CODE: A user-defined value which is used for
identification purposes on all cash transactions.
FABINVH_RUIV_IND VARCHAR2 1 YES RECURRING INVOICE INDICATOR: Indicates that an invoice
will be processed on a recurring basis on a specific
schedule.
FABINVH_EDIT_DEFER_IND VARCHAR2 1 YES DEFER EDIT INDICATOR: This indicator is used to defer
editing of the transaction until after posting.
FABINVH_OVERRIDE_TAX_AMT NUMBER 12 2 YES
FABINVH_TGRP_CODE VARCHAR2 4 YES TAX GROUP CODE: The tax group code used with a
ship-to-address to determine the taxes to be computed.
FABINVH_SUBMISSION_NUMBER NUMBER 3 YES SUBMISSION NUMBER: The number of submissions allowable
for a reusable/ recurring document.
FABINVH_VEND_CHECK_PIDM NUMBER 8 YES VENDOR CHECK PERSONAL IDENTIFICATION MASTER: The
unique personal identification master of a check
vendor.
FABINVH_INVOICE_TYPE_IND VARCHAR2 1 NO This one-character indicator designates whether an
invoice is 'D' for Direct Pay or 'R' for Regular.
Date: 21-JUN-2004 Page: 14
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINVH_CURR_CODE VARCHAR2 4 YES CURRENCY CODE: The currency code associated with this
invoice.
FABINVH_DISB_AGENT_IND VARCHAR2 1 YES DISBURSING AGENT INDICATOR: Used to identify this
invoice as one using a disburing agent when check is
written.
FABINVH_ATYP_CODE_VEND VARCHAR2 2 YES DISBURSING VENDOR ADDRESS TYPE CODE: Used to identify
the vendor address type when a disbursing agent is
specified. Defaults from the AP default address
identified in fabinvh_atyp_code.
FABINVH_ATYP_SEQ_NUM_VEND NUMBER 2 YES DISBURSING VENDOR ADDRESS TYPE SEQUENCE NUMBER: Used
to identify the vendor address type sequence number
when disbursing agent is specified. Defaults from the
AP default address sequence number identified in
fabinvh_atyp_seq_num.
FABINVH_NSF_ON_OFF_IND VARCHAR2 1 YES NSF ON OFF INDICATOR: If Y, available balance checking
will be done at entry time for this particular
invoice.
FABINVH_SINGLE_ACCTG_IND VARCHAR2 1 YES SINGLE ACCTG DISTR INDICATOR: If Y, the document will
have an accounting or accounting distributions for the
document not for specific commodities
FABINVH_ONE_TIME_VEND_NAME VARCHAR2 60 YES One Time Vendor name for One Time Vendors
FABINVH_ONE_TIME_VEND_ADDR1 VARCHAR2 30 YES One Time Vendor address line one for One Time Vendors
FABINVH_ONE_TIME_VEND_ADDR2 VARCHAR2 30 YES One Time Vendor address line two for One Time Vendors
FABINVH_ONE_TIME_VEND_ADDR3 VARCHAR2 30 YES One Time Vendor address line three for One Time
Vendors
FABINVH_ONE_TIME_VEND_CITY VARCHAR2 20 YES One Time Vendor city for One Time Vendors
FABINVH_ONE_TIME_VEND_STATE VARCHAR2 3 YES One Time Vendor state for One Time Vendors
FABINVH_ONE_TIME_VEND_ZIP VARCHAR2 10 YES One Time Vendor zip code for One Time Vendors
FABINVH_ONE_TIME_VEND_NATN VARCHAR2 5 YES One Time Vendor nation for One Time Vendors
FABINVH_DELIVERY_POINT NUMBER 2 YES DELIVERY POINT: This field indicates the delivery
point associated with the address.
FABINVH_CORRECTION_DIGIT NUMBER 1 YES CORRECTION DIGIT: This field indicates the correction
digit associated with the address.
FABINVH_CARRIER_ROUTE VARCHAR2 4 YES CARRIER ROUTE: This field indicates the carrier route
associated with the address.
FABINVH_RUIV_INSTALLMENT_IND VARCHAR2 1 YES RECURRING PAYABLE INSTALLMENT INDICATOR: This user
defined field indicates whether the recurring payable
set up, is an installment option or not. It is used
by the fixed asset module to determine the
capitalization amount.
FABINVH_MULTIPLE_INV_IND VARCHAR2 1 YES MULTIPLE VENDOR INVOICE INDICATOR: This user defined
field indicates whether the Banner invoice document
has multiple vendor invoices.
FABINVH_PHONE_AREA VARCHAR2 3 YES PHONE AREA: Phone area code.
FABINVH_PHONE_NUMBER VARCHAR2 7 YES PHONE EXTENTION: Phone extention.
FABINVH_PHONE_EXT VARCHAR2 4 YES
FABINVH_EMAIL_ADDR VARCHAR2 20 YES EMAIL ADDRESS: Email address.
FABINVH_FAX_AREA VARCHAR2 3 YES FAX AREA CODE: Fax number area code.
FABINVH_FAX_NUMBER VARCHAR2 7 YES FAX NUMBER: Fax telephone number.
FABINVH_FAX_EXT VARCHAR2 4 YES FAX EXTENTION: Fax number extention.
FABINVH_CANCEL_CODE VARCHAR2 4 YES
FABINVH_ATTENTION_TO VARCHAR2 35 YES ATTENTION TO: Attention To line for ship to address.
Date: 21-JUN-2004 Page: 15
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINVH_VENDOR_CONTACT VARCHAR2 35 YES VENDOR CONTACT: The vendor contact.
FABINVH_INVD_RE_ESTABLISH_IND VARCHAR2 1 YES INVOICE RE ESTABLISH INDICATOR: This user defined
field indicates whether the Banner invoice is re
established at invoice cancellation time or not.
FABINVH_ACH_OVERRIDE_IND VARCHAR2 1 YES ACH OVER RIDE INDICATOR: Active ACH status of the
vendor can be over-riden at invoice level with this
indicator.
FABINVH_ORIGIN_CODE VARCHAR2 10 YES INVOICE ORIGININATION CODE: Where the Invoice source
of creation came from.
FABINVH_MATCH_REQUIRED VARCHAR2 1 NO Match Required: Used to indicate whether this Invoice
requires Matching. Valid values are [N]o matching,
[Y]es matching, [U]nterprise matching in effect.
Date: 21-JUN-2004 Page: 16
TABLE: FABINVT
CREATOR: FIMSMGR
Purchase Card Transactions Header Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINVT_SYSTEM_ID VARCHAR2 8 NO SYSTEM IDENTIFICATION: Contains the system identifier
from which the transaction originated. Must be
identified in FTVSDAT. Values PCARD, etc
FABINVT_SYSTEM_TIME_STAMP VARCHAR2 14 NO SYSTEM DATE AND TIMESTAMP: The date the bank flat file
is processed at the Institution, indicating when the
job creating this file was run. Format is
YYYYMMDDHH24MISS. Each new system time stamp
re
presents a different flat file that was processed.
One my process 5 flat files in the same day, however
the time stamp on the day is what differentiates each
of the batches
FABINVT_TRAN_NUM NUMBER 4 NO TRANSACTION NUMBER: A one up number assigned to make
the transaction unique within SYSTEM_ID, and
SYSTEM_TIME_STAMP.
FABINVT_CARD_TYPE_CODE VARCHAR2 8 NO CREDIT CARD TYPE: A unique code that determines a
credit card type. Valid values are stored in FTVSDAT
and can be VISA, MC, DISCOVER,AMEX etc.
FABINVT_CARD_CODE VARCHAR2 16 NO CREDIT CARD NUMBER: The unique number assigned to a
credit card.
FABINVT_CAMPUS_CODE VARCHAR2 8 NO CAMPUS CODE: A unique code that determines a company
within the Institution. Some Institutions may have a
different Company Code to represent each Campus.
Valid values are stored in FTVSDAT.
FABINVT_FEED_IND VARCHAR2 1 NO FEED INDICATOR: Indicator used to determine if the
transaction has been fed to Finance or waiting to be
fed. Values are (F)ed and (N)ot fed which is the
default.
FABINVT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record on the table was entered or last updated.
FABINVT_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user usually defined in table fobprof.
FABINVT_CARDHOLDER_PIDM NUMBER 8 YES CARDHOLDER PERSONAL IDENTIFICATION: The system
generated personal identification number for the
individual who has the credit card. This person must
be an employee and is responsible for the card unle
ss
the Sponsor is indicated as being responsible for the
card. User id identified in spriden.
FABINVT_DR_CR_IND VARCHAR2 1 YES DEBIT CREDIT INDICATOR: Determines the sign on the
input transaction. Value is either a (+) or a (-).
Sets the credit memo indicator on the FABINVH record
if the value is a minus.
FABINVT_ORIG_TRANS_AMT NUMBER 12 2 YES TRANSACTION AMOUNT: The amount of the purchase card
original transaction.
FABINVT_TRANS_REF_NUM VARCHAR2 25 YES INTERCHANGE TRANSACTION REFERENCE NUMBER: Number given
to a bank to track any given transaction.
FABINVT_VEND_NAME VARCHAR2 30 YES VENDOR NAME: The name of the Vendor or Merchant where
the purchase card transaction took place.
Date: 21-JUN-2004 Page: 17
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINVT_VEND_STREET1 VARCHAR2 30 YES VENDOR ADDRESS STREET1: The first street line address
of the Vendor or Merchant where the purchase card
transaction took place.
FABINVT_VEND_STREET2 VARCHAR2 30 YES VENDOR ADDRESS STREET2: The second street line address
of the Vendor or Merchant where the purchase card
transaction took place.
FABINVT_VEND_STREET3 VARCHAR2 30 YES VENDOR ADDRESS STREET3: The third street line address
of the Vendor or Merchant where the purchase card
transaction took place.
FABINVT_VEND_CITY VARCHAR2 20 YES VENDOR CITY: The City of the Vendor or Merchant where
the purchase card transaction took place.
FABINVT_VEND_STATE VARCHAR2 3 YES VENDOR STATE: The State Code of the Vendor or Merchant
where the purchase card transaction took place.
Validated against STVSTAT.
FABINVT_VEND_ZIP VARCHAR2 10 YES VENDOR ZIP CODE: The Zip Code of the Vendor or
Merchant where the purchase card transaction took
place. Validated against GTVZIPC.
FABINVT_VEND_NATN VARCHAR2 5 YES
FABINVT_SIC_CODE VARCHAR2 4 YES MERCHANT SIC CODE: An even more granular merchant
category code that dictates the type of merchant.
Informational only.
FABINVT_INVOICE_DATE DATE 7 YES VENDOR TRANSACTION DATE: The date that the transaction
took place at the point of sale location. Display
purposes only.
FABINVT_BANK_POST_DATE DATE 7 YES BANK POSTING DATE: The date that the vendors
transaction posted at the bank. Information only The
banking post date from the source transaction.
FABINVT_FEED_SWEEP_DATE DATE 7 YES FEED SWEEP DATE: The date that the invoice
transactions are to be pushed into Banner Finance via
the FAPINVT process. The date is calculated as the
date the fatcard table was processed plus a specifie
d
number of lag business days that gives the account
managers enough time to review and make any correcting
entries. The lag days are identified on ftvcard.
This becomes the Invoice Transaction Date used to post
the Invoice in Finance.
FABINVT_PMT_DUE_DATE DATE 7 YES PAYMENT DUE DATE: The date that the invoice should be
paid with a check or direct deposit. Calculated from
ftvpcsh with a payment cutoff day plus a predetermined
number of cycle days established in ftvsd
at
FABINVT_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION: The personal
identification number for the vendor. Place holder
for future enhancement capability or for client to be
able to use in the event that they can perform a
merchan
t match from incoming bank flat files. At
this time there is no unique identifier for the vendor
on the MasterCard incoming file.
FABINVT_VEND_CHECK_PIDM NUMBER 8 YES VENDOR CHECK PERSONAL IDENTIFICATION: The personal
identification number for the check vendor. Place
holder for future enhancement capability or for client
to be able to use in the event that they can
perform
a merchant match from incoming bank flat files and
utilize a third party pay feature.
Date: 21-JUN-2004 Page: 18
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABINVT_VEND_ATYP_CODE VARCHAR2 2 YES VENDOR ADDRESS TYPE CODE: Address type for the vendor
to whom the checks are written. This value must exist
on SATURN.STVATYP and must exist if a real vendor pidm
is matched in this file.
FABINVT_VEND_ATYP_SEQNO NUMBER 2 YES VENDOR ADDRESS TYPE SEQUENCE NUMBER: Address sequence
number for the vendor to whom the checks are written.
Value with Address type value combination must exist
on SPRADDR and must exist if a real ven
dor pidm is
matched in this file.
FABINVT_TRANS_TYPE_CODE VARCHAR2 2 YES TRANSACTION TYPE CODE: A code noting the type of
transaction being fed in by the bank. Banner Finance
will not use this field but clients may use this field
to perform additional functions. Informat
ional only.
This is a one character field coming in from MC but a
two charater field coming in from AMEX. Some MC
values may be Cash (A)dvance, Miscellaneous (C)redit,
Miscellaneous (D)ebit, (M)iscellaneous, (P)urchase,
Pa(Y)ment. Some values for AMEX
may be (01)
adjustment, (03) remit regular, (06) annual feed, etc.
FABINVT_MERCHANT_CODE VARCHAR2 30 YES MERCHANT CODE: A unique identifier for a merchant that
is known to only VISA, MC, or AMEX, etc. Right now,
only AMEX provides this number. For future use to be
able to eventually provide a crosswalk to
a real
vendor pidm in order to add normal vendors on the
invoice instead of pushing through one-time vendors.
FABINVT_FEED_DOC_CODE VARCHAR2 8 YES FEED DOCUMENT CODE: The invoice document number
assigned to this transaction as it was fed into Banner
Finance.
FABINVT_COMMODITY_CODE VARCHAR2 10 YES COMMODITY CODE: This indicates commodity code of any
particular service or goods purchased.
FABINVT_COMMODITY_DESC_NOTES VARCHAR2 50 YES COMMODITY CODE DESCRIPTION: This indicates commodity
description about any particular purchase card
transaction, such as more detailed information about
goods or services purchased.
FABINVT_JV_DOC_NUM VARCHAR2 35 YES JOURNAL VOUCHER DOCUMENT NUMBER: This indicates the
journal voucher document number.
Date: 21-JUN-2004 Page: 19
TABLE: FABREBT
CREATOR: FIMSMGR
Tax Rebate Maintenance Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABREBT_TRAT_CODE VARCHAR2 3 NO TAX RATE CODE: The tax rate to which these tax rebates
apply.
FABREBT_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The Chart of Accounts on which
these tax rebates are valid.
FABREBT_PCT_REBATE NUMBER 6 3 NO REBATE PERCENT: The percent of the tax to be rebated.
FABREBT_EFF_DATE DATE 7 NO EFFECTIVE DATE: The date as of which the rebate on
this record is effective.
FABREBT_NCHG_DATE DATE 7 NO NEXT CHANGE DATE: The date on which the information on
this record was changed.
FABREBT_TERM_DATE DATE 7 YES TERMINATION DATE: The date on which the rebate on this
record is no longer in effect.
FABREBT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
Direct Cash Receipt record was entered or last
updated.
FABREBT_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user
who entered or last updated this record.
FABREBT_COAS_CODE_REBATE VARCHAR2 1 YES CHART OF ACCOUNTS: The Chart of Accounts on which the
rebate will be received.
FABREBT_FUND_CODE_REBATE VARCHAR2 6 YES FUND_CODE: The Fund that will receive the rebate.
FABREBT_ACCT_CODE_AR_REBATE VARCHAR2 6 YES ACCOUNT CODE: The Account that will receive the
rebate.
Date: 21-JUN-2004 Page: 20
TABLE: FABRUIV
CREATOR: FIMSMGR
Reusable Invoice Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FABRUIV_CODE VARCHAR2 8 NO REUSABLE INVOICE CODE: The unique code for a reusable
invoice.
FABRUIV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that information for this record
on the table was entered or last updated.
FABRUIV_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FABRUIV_NEXT_SUB_DATE DATE 7 NO NEXT SUBMISSION DATE: The date of the next scheduled
submission of a reusable document.
FABRUIV_MAX_SUB NUMBER 4 YES MAXIMUM SUBMISSSIONS: The maximum number of
submissions for a reusable document.
FABRUIV_SUB_TO_DATE NUMBER 4 YES SUBMISSION TO DATE: The day to which the reusable
invoice may be submitted.
FABRUIV_SUB_DAYS NUMBER 3 YES SUBMISSION DAYS: The number of days between
submissions of a reusable invoice.
FABRUIV_SUB_IND VARCHAR2 1 YES SUBMISSION INDICATOR: An indicator as to when the
reusable invoice should be submitted. M-monthly,
Q-Quarterly, Y-Yearly, S-Semiannual, B-bimonthly, and
W-weekly.
Date: 21-JUN-2004 Page: 21
TABLE: FARBKTH
CREATOR: FIMSMGR
Bank Tape History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARBKTH_BANK_CODE VARCHAR2 2 NO BANK CODE: A user-defined value which is used for
identification purposes on all cash transactions.
FARBKTH_CHECK_DEPOSIT_CODE VARCHAR2 8 NO CHECK DEPOSIT CODE:L
FARBKTH_CHECK_DEPOSIT_IND VARCHAR2 1 NO CHECK DEPOSIT INDICATOR: The indicator which specifies
the type of document (transaction) being "corrected."
FARBKTH_TRANS_DATE DATE 7 NO TRANSACTION DATE: The date the transaction was
processed.
FARBKTH_TAPE_DATE DATE 7 YES BANK TAPE DATE: The date when the tape was received
from the bank. Used for bank reconciliation
processing.
FARBKTH_AMT NUMBER 12 2 NO AMOUNT: The bank amount used to reconcile checks and
deposits.
FARBKTH_DESC VARCHAR2 35 YES DESCRIPTION: The description or title of the
encumbrance.
FARBKTH_RECON_IND VARCHAR2 1 YES RECONCILIATION INDICATOR: Indicates whether a check or
deposit record has been reconciled.
FARBKTH_INTERNAL_DOC_CODE VARCHAR2 8 YES INTERNAL DOCUMENT CODE: An internal code assigned to
each document type for use in identification and
processing of financial activity.
FARBKTH_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FARBKTH_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification code of
the user.
FARBKTH_ACTION_IND VARCHAR2 1 NO
Date: 21-JUN-2004 Page: 22
TABLE: FARCKMC
CREATOR: FIMSMGR
MATCHING REPORT COLLECTOR TABLE: Used in the matching report fabmatc to group invoice commodity records for
reporting purposes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARCKMC_INVH_CODE VARCHAR2 8 NO INVOICE CODE: The invoice document number.
FARCKMC_INVC_ITEM NUMBER 4 NO INVOICE ITEM: The item number from the invoice.
FARCKMC_POHD_CODE VARCHAR2 8 NO PO CODE: The purchase order number for the invoiced
item.
FARCKMC_PODT_ITEM NUMBER 4 NO PO ITEM: The purchase order item number for the
invoiced item.
FARCKMC_PO_QTY NUMBER 8 2 NO PO ORDER QTY: The quantity ordered on the PO for the
invoiced item.
FARCKMC_ACCEPTED_QTY NUMBER 8 2 NO ACCEPTED QTY: Total received - rejected from the
receiving detail records that are not in suspense.
FARCKMC_PREV_INVC_QTY NUMBER 8 2 NO PREVIOUSLY INVOICED QTY: The quantity previously
invoiced for the PO and PO item.
FARCKMC_RTRN_QTY NUMBER 8 2 NO RETURNED QTY: The sum of the returned quantity for the
PO and PO item.
FARCKMC_INVC_QTY NUMBER 8 2 NO INVOICED QTY: The approved invoice quantity.
FARCKMC_PO_UNIT_PRICE NUMBER 11 4 NO PO UNIT PRICE: The purchase order unit price for the
invoiced item.
FARCKMC_INV_UNIT_PRICE NUMBER 11 4 NO INVOICED UNIT PRICE: The invoiced approved unit price.
FARCKMC_MATCH_TYPE NUMBER 1 NO MATCH TYPE INDICATOR: Indicates whether the invoice
matches the receipts. 2 non-matched. Receiving is in
suspense. 3 non-matched. Not enough receipts.
FARCKMC_COMM_DESC VARCHAR2 30 YES COMMODITY DESCRIPTION: The commodity description for
the invoiced item.
Date: 21-JUN-2004 Page: 23
TABLE: FARDIRD
CREATOR: FIMSMGR
Direct Deposit Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARDIRD_BANK_CODE VARCHAR2 2 NO BANK CODE : A user-defined value which is used for
identification purposes on all cash transactions.
FARDIRD_ACH_DATE DATE 7 NO ACH Date : Check date entered on Batch Check Print
Form FAABATC.
FARDIRD_COMPANY_NAME VARCHAR2 25 NO COMPANY NAME : Name of the Company making payment.
FARDIRD_ITEM_CNT NUMBER 8 NO ITEM COUNT : Number of transactions in the ACH file.
FARDIRD_DOLLAR_AMT NUMBER 12 2 NO NET AMOUNT : Net dollar amount transacted.
FARDIRD_HASH_TOTAL NUMBER 10 NO HASH TOTAL : Hash total of first eight (8) numbers of
bank routing numbers.
FARDIRD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE : Date of last activity on this record.
FARDIRD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION : The unique identification code
of the user.
Date: 21-JUN-2004 Page: 24
TABLE: FARINTX
CREATOR: FIMSMGR
Invoice Tax Allocation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINTX_INVH_CODE VARCHAR2 8 NO INVOICE DOCUMENT CODE: The unique identifier of an
invoice document. The code may be system generated by
entering NEXT in the invoice header.
FARINTX_TRAT_CODE VARCHAR2 4 NO TAX RATE CODE: The value of the tax rate established
on form: FTVTRAT.
FARINTX_TAX_AMT NUMBER 12 2 NO TAX AMOUNT: The amount of tax computed or entered for
a document.
FARINTX_PAY_TAX_TO VARCHAR2 1 NO PAY TAX TO IDENTIFICATION: Indicates who should be
paid taxes either the vendor or the taxing authority.
FARINTX_ITEM NUMBER 4 YES COMMODITY ITEM NUMBER: The literal commodity or goods
associaited with an invoice processing record. The
unique sequence number directly associated an item on
the commodity record.
FARINTX_SEQ_NUM NUMBER 4 YES RULE CLASS CODE: The four character alpha/numeric code
attached to the said to code indicating a route for
the delivery of purchased commodities. Entered on
form FTMSHIP.
FARINTX_RUCL_CODE VARCHAR2 4 YES RULE CLASS CODE: The four character alpha/numeric code
identifying an accounting transaction rule class.
FARINTX_PRIORITY_NUM NUMBER 2 NO PRIORITY_NUMBER: A number to establish the order in
which taxes are to be compounded for a taxed
commodity.
FARINTX_TAXABLE_AMT NUMBER 12 2 YES TAXABLE AMOUNT: The amount which is multiplied by the
tax rate to give tax amount.
FARINTX_REBATE_IND VARCHAR2 1 YES REBATE INDICATOR: To identify if this need the rebate
processing or not. The default is no - N.
FARINTX_CONVERT_TAX_AMT NUMBER 12 2 YES CONVERTED TAX AMOUNT: The converted tax amount for
taxes when currency conversion is in effect.
FARINTX_TRAT_DESCRIP VARCHAR2 35 YES TAX RATE DESCRIPTION: The Tax Rate title for the
Compensating Use Tax Process
FARINTX_REBATE_AMT NUMBER 12 2 YES REBATE AMOUNT: Will contain the rebate amount due to
the institution for a specific tax rate.
FARINTX_CONVERT_REBATE_AMT NUMBER 12 2 YES CONVERT REBATE AMOUNT: Will contain the base currency
rebate amount due to the institution for a specific
tax rate when dealing with currency conversion.
FARINTX_REBATE_PERCENT NUMBER 6 3 YES REBATE PERCENT: The percent of the tax to be rebated.
FARINTX_COAS_CODE_REBATE VARCHAR2 6 YES CHART OF ACCOUNTS: The Chart of Accounts on which the
rebate will be received.
FARINTX_FUND_CODE_REBATE VARCHAR2 6 YES FUND_CODE: The Fund receivng the rebate.
FARINTX_ACCT_CODE_AR_REBATE VARCHAR2 6 YES ACCOUNT CODE: The Account receiving the rebate.
Date: 21-JUN-2004 Page: 25
TABLE: FARINVA
CREATOR: FIMSMGR
Invoice Accounting Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVA_INVH_CODE VARCHAR2 8 NO DOCUMENT: The unique number of the document being
updated.
FARINVA_POHD_CODE VARCHAR2 8 YES PURHCASE ORDER CODE: The user-defined purchase order
number issued to this vendor.
FARINVA_ITEM NUMBER 4 NO ITEM NUMBER: The literal commodity or goods
description associated with an invoice processing
record. The unique sequence number directly
associated an item on the commodity record.
FARINVA_PO_ITEM NUMBER 4 YES PURCHASE ORDER ITEM: The sequence number of the
commodity on the purchase order.
FARINVA_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: A system generated sequence number
relating to transactions within a document.
FARINVA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FARINVA_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FARINVA_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR: A unique two digit numeric identifier
code for the fiscal year being defined. Generally the
last two digits of the second year of the accounting
period are used.
FARINVA_PERIOD VARCHAR2 2 YES PERIOD: Refers to a period within a fiscal year.
FARINVA_EOY_ACCR_STATUS_IND VARCHAR2 1 YES END OF YEAR ACCRUAL: Refers to the accounting period's
ability to post activity. Value choices for the
accrual period are O-open, N-not open, or closed.
FARINVA_RUCL_CODE VARCHAR2 4 NO RULE CLASS CODE: The four character alpha/numeric code
identifying an accounting transaction rule class.
FARINVA_DISC_RUCL_CODE VARCHAR2 4 YES DISCOUNT RULE CLASS CODE: The Rule Class Code which is
used for posting discounts to the ledgers.
FARINVA_TAX_RUCL_CODE VARCHAR2 4 YES TAX RULE CLASS CODE: The Rule Class Code for posting
the accounting event for taxes.
FARINVA_ADDL_RUCL_CODE VARCHAR2 4 YES ADDITIONAL RULE CLASS CODE: The Rule Class Code which
will be used to post the additional charges as a
result of purchasing and account payable activity.
FARINVA_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FARINVA_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: The user-defined value
representing a summerization of any combination of
user-defined FOAPAL elements.
FARINVA_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the fund code that appears on a
transaction.
Date: 21-JUN-2004 Page: 26
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVA_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FARINVA_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user defined value representing an
account.
FARINVA_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure code or a subset or that
structure as defined by the National Council of Higher
Education Management Systems.
FARINVA_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity that is primarily
associated with this organization.
FARINVA_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
installment's financial manager. For i.e., Vice
President, Suite 10, Adams Hall, Main Campus. Refer
to FTVLOCN.
FARINVA_BANK_CODE VARCHAR2 2 YES BANK CODE: A user-defined value that is used for
identification purposes on cash transactions. All
bank codes and other attributes are displayed on form
FTMBANK.
FARINVA_INVD_AMT NUMBER 12 2 YES INVOICE AMOUNT: The dollar amount invoiced by the
vendor.
FARINVA_DISC_AMT NUMBER 12 2 YES DISCOUNT AMOUNT: The dollar value of the discount
being taken on the invoice.
FARINVA_TAX_AMT NUMBER 12 2 YES TAX AMOUNT: The dollar value of the sales/use tax
being charged on this invoice.
FARINVA_ADDL_CHRG_AMT NUMBER 12 2 YES ADDITIONAL CHARGE AMOUNT: The dollar value of any
additional charges associated with this invoice.
FARINVA_APPR_AMT NUMBER 12 2 YES APPROVAL AMOUNT: The dollar value of the payment.
FARINVA_PREV_PAID_AMT NUMBER 12 2 YES PREVIOUSLY PAID AMOUNT: The amount previously paid on
an invoice.
FARINVA_NSF_OVERRIDE_IND VARCHAR2 1 YES INSUFFICIENT FUNDS OVERRIDE INDICATOR: This indicator
permits authorized users to by-pass funding
deficiencies.
FARINVA_ITYP_SEQ_CODE NUMBER 2 YES INTERNAL SEQUENCE CODE: Internal, pre-defined sequence
number which designates which activity should be
updated on the Operating Ledger (OPAL).
FARINVA_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: A unique code which identifies a cost
accounting project.
FARINVA_SUSP_IND VARCHAR2 1 NO SUSPENSE INDICATOR: An indicator which informs the
user that a document is being held in suspense due to
missing or erroneous data content.
FARINVA_NSF_SUSP_IND VARCHAR2 1 NO NONSUFFICIENT FUNDS SUSPENSE INDICATOR: An indicator
which informs the user that a transaction has been
suspended due to lack of budget.
FARINVA_PARTIAL_LIQ_IND VARCHAR2 1 YES PARTIAL LIQUIDATION INDICATOR: A one character field
indicating whether an invoice is partially or totally
liquidating an encumbrance.
FARINVA_APPR_IND VARCHAR2 1 YES APPROVAL INDICATOR: Indicates if the document has been
approved for processing by the individual authorized
to approve the document.
FARINVA_OPEN_PAID_IND VARCHAR2 1 YES OPEN PAID INDICATOR: The indicator that a document is
open or paid.
Date: 21-JUN-2004 Page: 27
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVA_CONVERT_AMT NUMBER 12 2 YES CONVERTED AMOUNT: The base amount calculated for this
accounting record. Used when a currency code is
established at the header record.
FARINVA_CONVERT_DISC_AMT NUMBER 12 2 YES CONVERTED DISCOUNT AMOUNT: The base discount amount
calculated for this accounting record. Used when a
currency code is established at the header record.
FARINVA_CONVERT_TAX_AMT NUMBER 12 2 YES CONVERTED TAX AMOUNT: The base tax amount calculated
for this accounting record. Used when a currency code
is established at the header record.
FARINVA_CONVERT_ADDL_CHRG_AMT NUMBER 12 2 YES CONVERTED ADDITIONAL CHARGES AMOUNT: The base
additional charges amount calculated for this
accounting record. Used when a currency code is
established at the header record.
FARINVA_APPR_AMT_PCT NUMBER 7 4 YES Approved amount percent: The percentage which was
entered in the approved amount field on the Invoice
FARINVA_DISC_AMT_PCT NUMBER 7 4 YES Discount amount percent: The percentage which was
entered in the discount amount field on the Invoice
FARINVA_ADDL_AMT_PCT NUMBER 7 4 YES Additional amount percent: The percentage which was
entered in the additional amount field on the Invoice
FARINVA_TAX_AMT_PCT NUMBER 7 4 YES Tax amount percent: The percentage which was entered
in the tax amount field on the Invoice
FARINVA_CAP_AMT NUMBER 12 2 YES CAPITALIZATION AMOUNT: The dollar amount that gets
capitalized for this accounting record.
Date: 21-JUN-2004 Page: 28
TABLE: FARINVA_22BKUP
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVA_INVH_CODE VARCHAR2 8 NO
FARINVA_POHD_CODE VARCHAR2 8 YES
FARINVA_ITEM NUMBER 4 NO
FARINVA_PO_ITEM NUMBER 4 YES
FARINVA_SEQ_NUM NUMBER 4 NO
FARINVA_ACTIVITY_DATE DATE 7 NO
FARINVA_USER_ID VARCHAR2 30 NO
FARINVA_FSYR_CODE VARCHAR2 2 YES
FARINVA_PERIOD VARCHAR2 2 YES
FARINVA_EOY_ACCR_STATUS_IND VARCHAR2 1 YES
FARINVA_RUCL_CODE VARCHAR2 4 NO
FARINVA_DISC_RUCL_CODE VARCHAR2 4 YES
FARINVA_TAX_RUCL_CODE VARCHAR2 4 YES
FARINVA_ADDL_RUCL_CODE VARCHAR2 4 YES
FARINVA_COAS_CODE VARCHAR2 1 YES
FARINVA_ACCI_CODE VARCHAR2 6 YES
FARINVA_FUND_CODE VARCHAR2 6 YES
FARINVA_ORGN_CODE VARCHAR2 6 YES
FARINVA_ACCT_CODE VARCHAR2 6 YES
FARINVA_PROG_CODE VARCHAR2 6 YES
FARINVA_ACTV_CODE VARCHAR2 6 YES
FARINVA_LOCN_CODE VARCHAR2 6 YES
FARINVA_BANK_CODE VARCHAR2 2 YES
FARINVA_INVD_AMT NUMBER 12 2 YES
FARINVA_DISC_AMT NUMBER 12 2 YES
FARINVA_TAX_AMT NUMBER 12 2 YES
FARINVA_ADDL_CHRG_AMT NUMBER 12 2 YES
FARINVA_APPR_AMT NUMBER 12 2 YES
FARINVA_PREV_PAID_AMT NUMBER 12 2 YES
FARINVA_NSF_OVERRIDE_IND VARCHAR2 1 YES
FARINVA_ITYP_SEQ_CODE NUMBER 2 YES
FARINVA_PROJ_CODE VARCHAR2 8 YES
FARINVA_SUSP_IND VARCHAR2 1 NO
FARINVA_NSF_SUSP_IND VARCHAR2 1 NO
FARINVA_PARTIAL_LIQ_IND VARCHAR2 1 YES
FARINVA_APPR_IND VARCHAR2 1 YES
FARINVA_OPEN_PAID_IND VARCHAR2 1 YES
FARINVA_CONVERT_AMT NUMBER 12 2 YES
FARINVA_CONVERT_DISC_AMT NUMBER 12 2 YES
FARINVA_CONVERT_TAX_AMT NUMBER 12 2 YES
FARINVA_CONVERT_ADDL_CHRG_AMT NUMBER 12 2 YES
FARINVA_APPR_AMT_PCT NUMBER 7 4 YES
FARINVA_DISC_AMT_PCT NUMBER 7 4 YES
FARINVA_ADDL_AMT_PCT NUMBER 7 4 YES
FARINVA_TAX_AMT_PCT NUMBER 7 4 YES
FARINVA_CAP_AMT NUMBER 12 2 YES
Date: 21-JUN-2004 Page: 29
TABLE: FARINVA_EXP
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVA_INVH_CODE VARCHAR2 8 NO
FARINVA_POHD_CODE VARCHAR2 8 YES
FARINVA_ITEM NUMBER 4 NO
FARINVA_PO_ITEM NUMBER 4 YES
FARINVA_SEQ_NUM NUMBER 4 NO
FARINVA_ACTIVITY_DATE DATE 7 NO
FARINVA_USER_ID VARCHAR2 30 NO
FARINVA_FSYR_CODE VARCHAR2 2 YES
FARINVA_PERIOD VARCHAR2 2 YES
FARINVA_EOY_ACCR_STATUS_IND VARCHAR2 1 YES
FARINVA_RUCL_CODE VARCHAR2 4 NO
FARINVA_DISC_RUCL_CODE VARCHAR2 4 YES
FARINVA_TAX_RUCL_CODE VARCHAR2 4 YES
FARINVA_ADDL_RUCL_CODE VARCHAR2 4 YES
FARINVA_COAS_CODE VARCHAR2 1 YES
FARINVA_ACCI_CODE VARCHAR2 6 YES
FARINVA_FUND_CODE VARCHAR2 6 YES
FARINVA_ORGN_CODE VARCHAR2 6 YES
FARINVA_ACCT_CODE VARCHAR2 6 YES
FARINVA_PROG_CODE VARCHAR2 6 YES
FARINVA_ACTV_CODE VARCHAR2 6 YES
FARINVA_LOCN_CODE VARCHAR2 6 YES
FARINVA_BANK_CODE VARCHAR2 2 YES
FARINVA_INVD_AMT NUMBER 12 2 YES
FARINVA_DISC_AMT NUMBER 12 2 YES
FARINVA_TAX_AMT NUMBER 12 2 YES
FARINVA_ADDL_CHRG_AMT NUMBER 12 2 YES
FARINVA_APPR_AMT NUMBER 12 2 YES
FARINVA_PREV_PAID_AMT NUMBER 12 2 YES
FARINVA_NSF_OVERRIDE_IND VARCHAR2 1 YES
FARINVA_ITYP_SEQ_CODE NUMBER 2 YES
FARINVA_PROJ_CODE VARCHAR2 8 YES
FARINVA_SUSP_IND VARCHAR2 1 NO
FARINVA_NSF_SUSP_IND VARCHAR2 1 NO
FARINVA_PARTIAL_LIQ_IND VARCHAR2 1 YES
FARINVA_APPR_IND VARCHAR2 1 YES
FARINVA_OPEN_PAID_IND VARCHAR2 1 YES
FARINVA_CONVERT_AMT NUMBER 12 2 YES
FARINVA_CONVERT_DISC_AMT NUMBER 12 2 YES
FARINVA_CONVERT_TAX_AMT NUMBER 12 2 YES
FARINVA_CONVERT_ADDL_CHRG_AMT NUMBER 12 2 YES
FARINVA_APPR_AMT_PCT NUMBER 7 4 YES
FARINVA_DISC_AMT_PCT NUMBER 7 4 YES
FARINVA_ADDL_AMT_PCT NUMBER 7 4 YES
FARINVA_TAX_AMT_PCT NUMBER 7 4 YES
FARINVA_CAP_AMT NUMBER 12 2 YES
Date: 21-JUN-2004 Page: 30
TABLE: FARINVC
CREATOR: FIMSMGR
Invoice Commodity Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVC_INVH_CODE VARCHAR2 8 NO DOCUMENT INVOICE CODE: The unique number of the
document being updated.
FARINVC_POHD_CODE VARCHAR2 8 YES PURCHASE ORDER CODE: The user-defined purchase order
number issued to this vendor.
FARINVC_ITEM NUMBER 4 NO COMMODITY ITEM NUMBER: The literal commodity or goods
description associated with an invoice processing
record. The unique sequence number directly
associated with an item on the commodity record.
FARINVC_PO_ITEM NUMBER 4 YES PURHCASE ORDER ITEM: The sequence number of the
commodity on the purchase order.
FARINVC_OPEN_PAID_IND VARCHAR2 1 NO OPEN PAID INDICATOR: Indicates whether a document is
open or paid.
FARINVC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FARINVC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FARINVC_COMM_CODE VARCHAR2 10 YES COMMODITY CODE: The user-defined commodity code
associated with this commodity.
FARINVC_COMM_DESC VARCHAR2 50 YES COMMODITY DESCRIPTION: The user-defined commodity
name/classification or category for this commodity.
FARINVC_UOMS_CODE VARCHAR2 4 YES UNIT OF MEASURE CODE: The unit-of-measure applicable
to the selected commodity.
FARINVC_ADJT_CODE VARCHAR2 2 YES ADJUSTMENT CODE: The code which identifies the type of
adjustment being made.
FARINVC_ADJT_DATE DATE 7 YES ADJUSTMENT DATE: The date when the adjustment was
made.
FARINVC_PART_PMT_IND VARCHAR2 1 YES PARTIAL PAYMENT INDICATOR: The total or partial
payment indicator.
FARINVC_PREV_PAID_QTY NUMBER 8 2 YES Cumulative quantity of previously paid items from the
purchase order.
FARINVC_RECVD_QTY NUMBER 8 2 YES QUANTITY RECEIVED: The quantity of a particular
commodity that was received in a specific delivery.
FARINVC_INVD_UNIT_PRICE NUMBER 11 4 YES INVOICED UNIT PRICE: The invoiced unit dollar value
processed for payment on this invoice.
FARINVC_INVD_QTY NUMBER 8 2 YES INVOICED QUANTITY: The invoiced quantity which is
being processed for payment on this invoice.
FARINVC_ACCEPT_QTY NUMBER 8 2 YES This is a calculated number which is displayed if the
commodity was received in the receiving process
(FPARCVD). It is the received quantity minus the
rejected quantity.
FARINVC_ACCEPT_UNIT_PRICE NUMBER 11 4 YES This price will be display for items which were
received in the receiving process (FPARCVD). It will
equal the Purchase Order unit price.
FARINVC_DISC_AMT NUMBER 12 2 YES DISCOUNT AMOUNT: The dollar value of the discount
being taken on the invoice.
Date: 21-JUN-2004 Page: 31
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVC_TAX_AMT NUMBER 12 2 YES TAX AMOUNT: The amount of tax computed or entered for
a document.
FARINVC_APPR_QTY NUMBER 8 2 YES APPROVED QUANTITY: The number of items approved for
payment processing on this invoice.
FARINVC_APPR_UNIT_PRICE NUMBER 11 4 YES APPROVED UNIT PRICE: The unit dollar value approved
for payment on this invoice.
FARINVC_TOL_OVERRIDE_IND VARCHAR2 1 YES This one character field can be used to override the
tolerance percent set for the user on FOMPROF.
FARINVC_HOLD_IND VARCHAR2 1 NO INVOICE HOLD INDICATOR: An attribute used to place
invoice records on hold to prevent disbursement to a
vendor.
FARINVC_SUSP_IND VARCHAR2 1 NO SUSPENSE INDICATOR: An indicator which informs the
user that a document is being held in suspense due to
missing or erroneous data content.
FARINVC_TTAG_NUM VARCHAR2 9 YES This is the temporary tag number which has been
generated for the invoiced item. Temporary tag
numbers are automatically generated if the fixed
assets indicator on the commodity code is set to 'Y'.
FARINVC_ADDL_CHRG_AMT NUMBER 12 2 YES ADDITIONAL CHARGES AMOUNT: The amount of additional
charges for this commodity record.
FARINVC_CONVERT_UNIT_PRICE NUMBER 11 4 YES CONVERTED UNIT PRICE: The base unit price calculated
for this commodity record. Used when a currency code
is established at the header record.
FARINVC_CONVERT_DISC_AMT NUMBER 12 2 YES CONVERTED DISCOUNT AMOUNT: The base discount amount
calculated for this commodity record. Used when a
currency code is established at the header record.
FARINVC_CONVERT_TAX_AMT NUMBER 12 2 YES CONVERTED TAX AMOUNT: The base tax amount calculated
for this commodity record. Used when a currency code
is established at the header record. Used when a
currency code is established at the header record.
FARINVC_CONVERT_ADDL_CHRG_AMT NUMBER 12 2 YES CONVERTED ADDITIONAL CHARGES AMOUNT: The base
additional charges amount calculated for this
commodity record. Used when a currency code is
established at the header record.
FARINVC_TGRP_CODE VARCHAR2 4 YES TAX GROUP CODE: The tax group code to be used for this
invoice commodity record.
FARINVC_TAG_CAP_CODE VARCHAR2 1 YES TEMPORARY TAG-CAPITALIZATION CODE: The code which
identifies whether the commodity is tagged, tagged and
capitalized, or not tagged.
FARINVC_VEND_INV_CODE VARCHAR2 15 YES VENDOR INVOICE CODE: The vendors invoice code entered
on the Banner Invoice document.
FARINVC_VEND_INV_DATE DATE 7 YES VENDOR INVOICE DATE: User defined vendor invoice date.
FARINVC_VEND_INV_ITEM NUMBER 4 YES VENDOR INVOICE ITEM NUMBER: The line item number of
the commodity in the vendor invoice.
FARINVC_PREV_AMT NUMBER 12 2 YES PREVIOUS AMOUNT: Previously invoiced amount.
FARINVC_DESC_CHGE_IND VARCHAR2 1 YES DESCRIPTION CHANGED INDICATOR: Indicates when the
default commodity description has been overwritten in
the invoice.
FARINVC_LAST_RCVR_IND VARCHAR2 1 YES LAST RECIEVER INDICATOR: Indicates whether the status
of the last reciever for an PO on it lastest invoice.
Date: 21-JUN-2004 Page: 32
TABLE: FARINVT
CREATOR: FIMSMGR
Purchase Card Transactions Accounting Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVT_SYSTEM_ID VARCHAR2 8 NO SYSTEM IDENTIFICATION: Contains the system identifier
from which the transaction originated. Must be
identified in FTVSDAT. Values PCARD, etc
FARINVT_SYSTEM_TIME_STAMP VARCHAR2 14 NO SYSTEM DATE AND TIMESTAMP: The date the bank flat file
is processed at the Institution, indicating when the
job creating this file was run. Format is
YYYYMMDDHH24MISS.
FARINVT_TRAN_NUM NUMBER 4 NO TRANSACTION NUMBER: A one up number assigned to make
the transaction unique within SYSTEM_ID,
SYSTEM_TIME_STAMP.
FARINVT_SEQ_NUM NUMBER 4 NO TRANSACTION NUMBER: A one up number assigned to allow
for a split accounting distribution within a
transaction. After original population, the first
accounting sequence line can never be deleted.
FARINVT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record on the table was entered or last updated.
FARINVT_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user usually defined in table fobprof.
FARINVT_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The chart of accounts code
used to default into the purchase transaction.
Validated against ftvcoas and used with the other
chart elements to validate.
FARINVT_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: A user-defined value used as a
quick key method to default one or more o the six
FOAPAL elements in the account distribution line.
Validated against ftvacci.
FARINVT_FUND_CODE VARCHAR2 6 YES FUND CODE: A code which uniquely identifies a fiscal
entity. Validated against ftvfund.
FARINVT_ORGN_CODE VARCHAR2 6 YES ORGANZIATION CODE: A code which uniquely identifies an
organization or department. Validated against
ftvorgn.
FARINVT_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: A code which uniquely identifies an
account. Accounts are either Assets, Liabilities,
Control Accounts, Fund Balance, Revenue, Labor,
Expense, Transfers. Validated against ftvacct.
FARINVT_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: A code which uniquely identifies a
program classification structure or a subset or that
structure as defined by the National Council of Higher
Education Management Systems. Validated
against
ftvprog.
FARINVT_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: A code which uniquely identifies
accounting data by activity. Validated against
ftvactv.
FARINVT_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Typically a code which uniquely
identifies the physical location for an asset or a
financial manager. Validated against ftvlocn.
Date: 21-JUN-2004 Page: 33
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARINVT_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: A code which uniquely identifies the
cost accounting project to which an expense is
charged. Validated against ftvproj.
FARINVT_BANK_CODE VARCHAR2 2 YES PROJECT CODE: A code which uniquely identifies the
bank used for cash type transactions. The
Institutions bank from which they pay their invoices.
Validated against gxvbank.
FARINVT_AMT_PCT NUMBER 8 5 YES TRANSACTION AMOUNT PERCENT: The percentage entered to
assist in dividing the amounts between accounting
transactions. Automatically calculated if percent not
entered.
FARINVT_TRANS_AMT NUMBER 12 2 YES TRANSACTION AMOUNT: The amount of the purchase card
transaction after it may have been split. This is the
one fed into Finance.
Date: 21-JUN-2004 Page: 34
TABLE: FARREBT
CREATOR: FIMSMGR
Multiple Tax Rebate Maintenance Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARREBT_TRAT_CODE VARCHAR2 3 NO TAX RATE CODE: The tax rate to which these tax rebates
apply.
FARREBT_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The Chart of Accounts on which
these tax rebates are valid.
FARREBT_PCT_REBATE NUMBER 6 3 NO REBATE PERCENT: The percent of the tax to be rebated
for this FOAP.
FARREBT_EFF_DATE DATE 7 NO EFFECTIVE DATE: The date as of which the rebate
percentage and FOAPs on this record are effective.
FARREBT_KEY_CODE VARCHAR2 48 NO KEY CODE: An internal key maintained by the system for
proper retrieval of the various tax rates in this
table.
FARREBT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
Direct Cash Receipt record was entered or last
updated.
FARREBT_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user
who entered or last updated this record.
FARREBT_FUND_CODE_FROM VARCHAR2 6 YES FROM-FUND CODE: The lowest transaction fund associated
with the rebate percentage on this record.
FARREBT_FUND_CODE_TO VARCHAR2 6 YES TO-FUND CODE: The highest transaction fund associated
with the rebate percentage on this record.
FARREBT_ORGN_CODE_FROM VARCHAR2 6 YES FROM-ORGANIZATION CODE: The lowest transaction
organization associated with the rebate percentage on
this record.
FARREBT_ORGN_CODE_TO VARCHAR2 6 YES TO-ORGANIZATION CODE: The highest transaction
organization associated with the rebate percentage on
this record.
FARREBT_ACCT_CODE_FROM VARCHAR2 6 YES FROM-ACCOUNT CODE: The lowest transaction account
associated with the rebate percentage on this record.
FARREBT_ACCT_CODE_TO VARCHAR2 6 YES TO-ACCOUNT CODE: The highest transaction account
associated with the rebate percentage on this record.
FARREBT_PROG_CODE_FROM VARCHAR2 6 YES FROM-PROGRAM CODE: The lowest transaction program
associated with the rebate percentage on this record.
FARREBT_PROG_CODE_TO VARCHAR2 6 YES TO-PROGRAM CODE: The highest transaction program
associated with the rebate percentage on this record.
Date: 21-JUN-2004 Page: 35
TABLE: FARVICM
CREATOR: FIMSMGR
Multiple Vendor Invoice Commodity Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARVICM_INVH_CODE VARCHAR2 8 NO INVOICE NUMBER: The Banner invoice number associated
with the vendor invoice number.
FARVICM_VEND_INV_CODE VARCHAR2 15 NO VENDOR INVOICE CODE: The unique vendors invoice code
for a vendor entered on the Banner Invoice document.
FARVICM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FARVICM_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FARVICM_ITEM NUMBER 4 YES ITEM NUMBER: The line item number of the commodity in
the table.
FARVICM_VEND_INV_ITEM NUMBER 4 YES VENDOR INVOICE ITEM NUMBER: The line item number of
the commodity in the vendor invoice.
FARVICM_PO_ITEM NUMBER 4 YES PURCHASE ORDER ITEM NUMBER: The line item number of
the commodity in the purchase order.
FARVICM_COMM_CODE VARCHAR2 10 YES COMMODITY CODE: The user-defined commodity code
associated with this commodity.
FARVICM_COMM_DESC VARCHAR2 50 YES COMMODITY DESCRIPTION: The user-defined commodity
name/classification or category for this commodity.
FARVICM_UOMS_CODE VARCHAR2 4 YES UNIT OF MEASURE CODE: The unit-of-measure applicable
to the selected commodity.
FARVICM_ACCEPT_QTY NUMBER 8 2 YES ACCEPTED QUANTITY: This is a calculated number which
is displayed if the commodity was received in the
receiving process (FPARCVD). It is the received
quantity minus the rejected quantity.
FARVICM_APPR_QTY NUMBER 8 2 YES APPROVED QUANTITY: The number of items approved for
payment processing on this invoice.
FARVICM_PREV_PAID_QTY NUMBER 8 2 YES PREVIOUSLY PAID QUANTITY: Cumulative quantity of
previously paid items from the purchase order.
FARVICM_APPR_UNIT_PRICE NUMBER 11 4 YES APPROVED UNIT PRICE: The unit dollar value approved
for payment on this invoice for the commodity.
FARVICM_DISC_AMT NUMBER 12 2 YES DISCOUNT AMOUNT: The dollar value of the discount
being taken on the invoice for this commodity.
FARVICM_ADDL_CHRG_AMT NUMBER 12 2 YES ADDITIONAL CHARGES AMOUNT: The amount of additional
charges for this commodity record.
FARVICM_TGRP_CODE VARCHAR2 4 YES TAX GROUP CODE: The tax group code to be used for this
invoice commodity record.
FARVICM_TAX_AMT NUMBER 12 2 YES TAX AMOUNT: The amount of tax computed or entered for
a document.
FARVICM_PART_PMT_IND VARCHAR2 1 YES PARTIAL PAYMENT INDICATOR: The total or partial
payment indicator.
FARVICM_TOL_OVERRIDE_IND VARCHAR2 1 YES TOLERENCE OVERRIDE INDICATOR: This one character field
can be used to override the tolerance percent set for
the user on FOMPROF.
FARVICM_DISPOSITION_IND VARCHAR2 1 YES DISPOSITION INDICATOR: This a system maintained
indicator to maintain the status of the record. It
determines if the row is either in insert/update or
delete mode.
Date: 21-JUN-2004 Page: 36
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARVICM_CONVERT_UNIT_PRICE NUMBER 11 4 YES CONVERTED UNIT PRICE: The base unit price calculated
for this commodity record. Used when a currency code
is established at the header record.
FARVICM_CONVERT_DISC_AMT NUMBER 12 2 YES CONVERTED DISCOUNT AMOUNT: The base discount amount
calculated for this commodity record. Used when a
currency code is established at the header record.
FARVICM_CONVERT_TAX_AMT NUMBER 12 2 YES CONVERTED TAX AMOUNT: The base tax amount calculated
for this commodity record. Used when a currency code
is established at the header record. Used when a
currency code is established at the header rec
ord.
FARVICM_CONVERT_ADDL_CHRG_AMT NUMBER 12 2 YES CONVERTED ADDITIONAL CHARGES AMOUNT: The base
additional charges amount calculated for this
commodity record. Used when a currency code is
established at the header record.
FARVICM_ACCEPT_UNIT_PRICE NUMBER 11 4 YES UNIT PRICE: This price will be displayed for items
which were received in the receiving process.
(FPARCVD). It will equal the Purchase Order unit
price.
FARVICM_PREV_AMT NUMBER 12 2 YES PREVIOUS AMOUNT: Previously invoiced amount.
FARVICM_DESC_CHGE_IND VARCHAR2 1 YES DESCRIPTION CHANGED INDICATOR: Indicates when the
default commodity description has been overwritten in
the invoice.
FARVICM_LAST_RCVR_IND VARCHAR2 1 YES LAST RECIEVER INDICATOR: Indicates whether the status
of the last reciever for an PO on it lastest invoice.
FARVICM_SUSP_IND VARCHAR2 1 YES SUSPENSE INDICATOR: An indicator which informs the
user that a document is being held in suspense due to
erroneous data content.
Date: 21-JUN-2004 Page: 37
TABLE: FARVINV
CREATOR: FIMSMGR
Multiple Vendor Invoice Cross Reference Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FARVINV_INVH_CODE VARCHAR2 8 NO INVOICE NUMBER: The Banner invoice number associated
with the vendor invoice number.
FARVINV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FARVINV_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FARVINV_VEND_INV_CODE VARCHAR2 15 NO VENDOR INVOICE CODE: The unique vendors invoice code
for a vendor entered on the Banner Invoice document.
FARVINV_VEND_INV_DATE DATE 7 YES VENDOR INVOICE DATE: User defined vendor invoice date.
FARVINV_VEND_INV_TOTAL NUMBER 12 2 YES VENDOR INVOICE TOTAL: The total dollar amount of
commodities per vendor invoice.
FARVINV_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION MASTER: The unique
personal identification of the vendor in Banner
invoice document.
FARVINV_VEND_INV_TAXL_AMT NUMBER 12 2 YES VENDOR INVOICE CODE TAX LIABILITY AMOUNT: The tax
liabilty amount paid to a taxing authority for the
vendor invoice.
Date: 21-JUN-2004 Page: 38
TABLE: FATCARD
CREATOR: FIMSMGR
Temporary Purchase Card Transactions Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCARD_SYSTEM_ID VARCHAR2 8 NO SYSTEM IDENTIFICATION: Contains the system identifier
from which the transaction originated. Must be
identified in FTVSDAT. Values PCARD, etc
FATCARD_SYSTEM_TIME_STAMP VARCHAR2 14 NO SYSTEM DATE AND TIMESTAMP: The date the bank flat file
is processed at the Institution, indicating when the
job creating this file was run. Format is
YYYYMMDDHHMMSS. All records on the bank flat fi
le
are assigned this value which really represents a
grouping of several transactions and is used as a
batched file identifier.
FATCARD_CAMPUS_CODE VARCHAR2 8 NO CAMPUS CODE: A unique code that determines a company
within the Institution. Some Institutions may have a
different Company Code to represent each Campus.
Valid values are stored in FTVSDAT.
FATCARD_CARD_TYPE_CODE VARCHAR2 8 NO CREDIT CARD TYPE: A unique code that determines a
credit card type. Valid values are stored in FTVSDAT
and can be VISA, MC, DISCOVER,AMEX etc.
FATCARD_REC_TYPE VARCHAR2 1 NO RECORD TYPE: The type of record being processed from
the bank. Header Summary records are set to 1, detail
records are set to 2.
FATCARD_DUP_OVERRIDE_IND VARCHAR2 1 NO DUPLICATE OVERRIDE INDICATOR: (Y)es tells the FAPCARD
process to ignore the duplication edit checks and to
process this grouping of summary detail records.
Supports functionality where the bank may
send a
continuation of bank postings in a different file on
subsequent day to the client. Valid values are (N)o,
the default value and (Y)es.when the bank post date
duplication edit needs to be overridden.
FATCARD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record on the table was entered or last updated.
FATCARD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user usually defined in table fobprof.
FATCARD_CARD_CODE VARCHAR2 16 YES CREDIT CARD NUMBER: The unique number assigned to a
credit card.
FATCARD_BANK_POST_DATE DATE 7 YES BANK POSTING DATE: The date that the vendors
transaction posted at the bank. Informational only.
FATCARD_TRANS_TYPE_CODE VARCHAR2 2 YES TRANSACTION TYPE CODE: A code noting the type of
transaction being fed in by the bank. Banner Finance
will not use this field but clients may use this field
to perform additional functions. Informat
ional only.
This is a one character field coming in from MC but a
two charater field coming in from AMEX. Some MC
values may be Cash (A)dvance, Miscellaneous (C)redit,
Miscellaneous (D)ebit, (M)iscellaneous, (P)urchase,
Pa(Y)ment. Some values for AMEX
may be (01)
adjustment, (03) remit regular, (06) annual feed, etc.
Date: 21-JUN-2004 Page: 39
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCARD_TRANS_AMT NUMBER 12 2 YES TRANSACTION AMOUNT: The amount of the purchase card
transaction.
FATCARD_DR_CR_IND VARCHAR2 1 YES DEBIT CREDIT INDICATOR: Determines the sign on the
input transaction. Value is either a (+) or a (-).
FATCARD_TRANS_REF_NUM VARCHAR2 25 YES INTERCHANGE TRANSACTION REFERENCE NUMBER: Number given
to a bank to track any given transaction.
FATCARD_VEND_NAME VARCHAR2 60 YES VENDOR NAME: The name of the Vendor or Merchant where
the purchase card transaction took place.
FATCARD_VEND_STREET1 VARCHAR2 30 YES VENDOR ADDRESS STREET1: The first street line address
of the Vendor or Merchant where the purchase card
transaction took place.
FATCARD_VEND_STREET2 VARCHAR2 30 YES VENDOR ADDRESS STREET2: The second street line address
of the Vendor or Merchant where the purchase card
transaction took place.
FATCARD_VEND_STREET3 VARCHAR2 30 YES VENDOR ADDRESS STREET3: The third street line address
of the Vendor or Merchant where the purchase card
transaction took place.
FATCARD_VEND_CITY VARCHAR2 20 YES VENDOR CITY: The City of the Vendor or Merchant where
the purchase card transaction took place.
FATCARD_VEND_STATE VARCHAR2 3 YES VENDOR STATE: The State Code of the Vendor or Merchant
where the purchase card transaction took place.
Validated against STVSTAT.
FATCARD_VEND_ZIP VARCHAR2 10 YES VENDOR ZIP CODE: The Zip Code of the Vendor or
Merchant where the purchase card transaction took
place. Validated against GTVZIPC.
FATCARD_VEND_NATN_CODE VARCHAR2 5 YES VENDOR NATION CODE: The Nation Code of the Vendor or
Merchant where the purchase card transaction took
place. Validate against STVNATN. Any incoming data
will have to be translated to STVNATN Codes.
FATCARD_SIC_CODE VARCHAR2 4 YES MERCHANT SIC CODE: An even more granular merchant
category code that dictates the type of merchant.
Informational only.
FATCARD_VEND_TRANS_DATE DATE 7 YES VENDOR TRANSACTION DATE: The date that the transaction
took place at the point of sale location. Used to
represent the Vendors Invoice Date.
FATCARD_SUM_DEBITS_NUM NUMBER 9 YES SUMMARY DEBITS NUMBER: The total number of Debit
transactions.
FATCARD_SUM_DEBITS_AMT NUMBER 15 2 YES SUMMARY DEBITS AMOUNT: The total amount of the summary
of all Debit transactions.
FATCARD_SUM_CREDITS_NUM NUMBER 9 YES SUMMARY CREDITS NUMBER: The total number of Credit
transactions.
FATCARD_SUM_CREDITS_AMT NUMBER 15 2 YES SUMMARY CREDITS AMOUNT: The total amount of the
summary of all Credit transactions.
FATCARD_MERCHANT_CODE VARCHAR2 30 YES MERCHANT CODE: A unique identifier for a merchant that
is known to only VISA, MC, or AMEX, etc. Right now,
only AMEX provides this number. For future use to be
able to eventually provide a crosswalk to
a real
vendor pidm in order to add normal vendors on the
invoice instead of pushing through one-time vendors.
FATCARD_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION: The personal
identification number for the vendor. Place holder
for future enhancement capability or for client to be
able to use in the event that they can perform a
merchan
t match from incoming bank flat files. At
this time there is no unique identifier for the vendor
on the MasterCard incoming file.
Date: 21-JUN-2004 Page: 40
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCARD_VEND_ATYP_CODE VARCHAR2 2 YES VENDOR ADDRESS TYPE CODE: Address type for the vendor
to whom the checks are written. This value must exist
on SATURN.STVATYP and must exist if a real vendor pidm
is matched in this file.
FATCARD_VEND_ATYP_SEQNO NUMBER 2 YES VENDOR ADDRESS TYPE SEQUENCE NUMBER: Address sequence
number for the vendor to whom the checks are written.
Value with Address type value combination must exist
on SPRADDR and must exist if a real ven
dor pidm is
matched in this file.
Date: 21-JUN-2004 Page: 41
TABLE: FATCKDT
CREATOR: FIMSMGR
Batch Check/Invoice Detail Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCKDT_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFCATION MASTER: The unique
identification master of a vendor.
FATCKDT_ADDR_TYPE VARCHAR2 2 YES ADDRESS TYPE: The user-defined contact address which
is associated with a specific record.
FATCKDT_ADDR_SEQNO NUMBER 2 YES ADDRESS SEQUENCE NUMBER: The user-defined sequence
number associated with the address.
FATCKDT_CHECK_NUM VARCHAR2 8 YES CHECK NUMBER: The pre-printed check number.
FATCKDT_CHECK_DATE DATE 7 YES CHECK DATE: The date of the issue for a check.
FATCKDT_BANK_CODE VARCHAR2 2 YES BANK CODE: The user-defined value which is used for
identification purposes on all cash transactions.
FATCKDT_INV_CODE VARCHAR2 8 YES DOCUMENT INVENTORY CODE: The unique number of the
document being updated.
FATCKDT_ITEM NUMBER 4 YES COMMODITY ITEM NUMBER: The literal commodity or goods
description associated with processing record. The
unique sequence number associated with an item on the
commodity record.
FATCKDT_SEQ_NUM NUMBER 4 YES OPERATING LEDGER SEQUENCE NUMBER: This number
represents a predefined value within the BANNER
Finance which is used for operating ledger
classification and reporting purposes.
FATCKDT_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR CODE: A user-defined code to identify a
fiscal year.
FATCKDT_PERIOD VARCHAR2 2 YES PERIOD: Refers to an accounting period with a
user-defined fiscal year. Expressed as a numeric
value 01, 06, 12, 13.
FATCKDT_GROSS_AMT NUMBER 12 2 YES GROSS AMOUNT: The gross number of dollars associated
with the invoices included in the check.
FATCKDT_TAX_AMT NUMBER 12 2 YES TAX AMOUNT: The amount of tax computed or entered for
a document.
FATCKDT_DISC_AMT NUMBER 12 2 YES DISCOUNT AMOUNT: The value of the discount code
established on the form FTVDISC.
FATCKDT_ADDL_AMT NUMBER 12 2 YES ADDITIONAL AMOUNT: The dollar value of any additional
charges associated with this invoice.
FATCKDT_FED_WHOLD_AMT NUMBER 12 2 YES FEDERAL WITHHOLDING AMOUNT: The amount withheld from a
1099 disbursement for remittance to the government.
FATCKDT_ST_WHOLD_AMT NUMBER 12 2 YES STATE WITHHOLDING AMOUNT: The amount withheld for
state taxes from an entity's 1099 payment.
FATCKDT_NET_AMT NUMBER 12 2 YES NET AMOUNT: The net amount of an invoice.
FATCKDT_CR_MEMO_IND VARCHAR2 1 YES CREDIT MEMO INDICATOR: This indicator identifies
credit memo processing.
FATCKDT_CHECK_TYPE_IND VARCHAR2 1 YES CHECK TYPE INDICATOR: An indicator establishing the
type of check produced. M-manual, B-batch, and
O-online.
Date: 21-JUN-2004 Page: 42
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCKDT_CANCEL_DATE DATE 7 YES CANCEL INDICATOR: The indicator associated with the
check cancellation processing.
FATCKDT_GROUPING_IND VARCHAR2 1 YES GROUPING INDICATOR: Indicates the relationship between
the number of invoices processed and the number of
checks. A value of '1' will create one check per
invoice whereas a value of 'M' will combine many
invoices on one check.
FATCKDT_VEND_CHECK_PIDM NUMBER 8 YES VENDOR CHECK PERSONAL IDENTIFICATION MASTER: The
unique personal identification master of a check
vendor.
FATCKDT_CONVERT_GROSS_AMT NUMBER 12 2 YES CONVERTED GROSS AMOUNT: The base gross amount
calculated for this detail record. Used when a
currency code is established at the invoice header
record.
FATCKDT_CONVERT_TAX_AMT NUMBER 12 2 YES CONVERTED TAX AMOUNT: The base tax amount calculated
for this detail record. Used when a currency code is
established at the invoice header record.
FATCKDT_CONVERT_DISC_AMT NUMBER 12 2 YES CONVERTED DISCOUNT AMOUNT: The base discount amount
calculated for this detail record. Used when a
currency code is established at the invoice header
record.
FATCKDT_CONVERT_ADDL_AMT NUMBER 12 2 YES CONVERTED ADDITIONAL CHARGES AMOUNT: The base
additional charges amount calculated for this detail
record. Used when a currency code is established at
the invoice header record.
FATCKDT_CONVERT_NET_AMT NUMBER 12 2 YES CONVERTED NET AMOUNT: The base net amount calculated
for this detail record. Used when a currency code is
established at the invoice header record.
FATCKDT_ONE_TIME_VEND_NAME VARCHAR2 60 YES One Time Vendor name for One Time Vendors
FATCKDT_ONE_TIME_VEND_ADDR1 VARCHAR2 30 YES One Time Vendor address line one for One Time Vendors
FATCKDT_ONE_TIME_VEND_ADDR2 VARCHAR2 30 YES One Time Vendor address line two for One Time Vendors
FATCKDT_ONE_TIME_VEND_ADDR3 VARCHAR2 30 YES One Time Vendor address line three for One Time
Vendors
FATCKDT_ONE_TIME_VEND_CITY VARCHAR2 20 YES One Time Vendor city for One Time Vendors
FATCKDT_ONE_TIME_VEND_STATE VARCHAR2 3 YES One Time Vendor state for One Time Vendors
FATCKDT_ONE_TIME_VEND_ZIP VARCHAR2 10 YES One Time Vendor zip code for One Time Vendors
FATCKDT_ONE_TIME_VEND_NATN VARCHAR2 5 YES One Time Vendor nation for One Time Vendors
FATCKDT_RUIV_IND VARCHAR2 1 YES Recurring Invoice Indicator: Indicates that an invoice
will be processed on a recurring basis on a specific
schedule.
FATCKDT_DELIVERY_POINT NUMBER 2 YES DELIVERY POINT: This field indicates the delivery
point associated with the address.
FATCKDT_CORRECTION_DIGIT NUMBER 1 YES CORRECTION DIGIT: This field indicates the correction
digit associated with the address.
FATCKDT_CARRIER_ROUTE VARCHAR2 4 YES CARRIER ROUTE: This field indicates the carrier route
associated with the address.
FATCKDT_PAYMT_TYPE_IND VARCHAR2 1 YES PAYMENT TYPE INDICATOR: The kind of payment being made
to the vendor - (C)heck or (D)irect Deposit.
Date: 21-JUN-2004 Page: 43
TABLE: FATCKIN
CREATOR: FIMSMGR
Batch Check/Invoice Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCKIN_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION MASTER: The unique
personal identification master of a vendor.
FATCKIN_INVH_DATE DATE 7 YES INVOICE DATE: The date of an invoice.
FATCKIN_INVH_CODE VARCHAR2 8 YES DOCUMENT INVOICE CODE: The unique number of the
document being updated. The code may be system
generated by entering NEXT in the invoice header.
FATCKIN_VEND_INV VARCHAR2 15 YES VENDORS INVOICE NUMBER: This is an optional field on
the invoice form but will print o the check stub if it
is supplied.
FATCKIN_ADDR_TYPE VARCHAR2 2 YES ADDRESS TYPE: The user-defined contact address which
is associated with a specific record.
FATCKIN_ADDR_SEQNO NUMBER 2 YES ADDRESS SEQUENCE NUMBER: A user-defined sequence
number associated with the address.
FATCKIN_CR_MEMO_IND VARCHAR2 1 YES CREDIT MEMO INDICATOR: Indicates if the invoice
document is a credit memo.
FATCKIN_ITYP_SEQ_CODE NUMBER 2 YES INTERNAL SEQUENCE CODES: Predefined internal codes
which represent trans- action types such as; permanent
budget, encumbrances, etc., that direct these values
to specific accumulators in the operating account
ledger (OPAL).
FATCKIN_1099_IND VARCHAR2 1 YES 1099 INDICATOR: This indicator distinguishes taxable
payments resulting from the payment processing of the
invoice. If yes Y, the payment will be recorded and
accumulated for income tax reporting purposes.
FATCKIN_1099_ID VARCHAR2 9 YES 1099 ID: The taxpayer identification number (TIN)
which uniquely identifies this vendor for Federal
Income Tax purposes. For individuals use the social
security number.
FATCKIN_GROSS_AMT NUMBER 12 2 YES GROSS AMOUNT: The gross number of dollars associated
with the invoices included in the check.
FATCKIN_TAX_AMT NUMBER 12 2 YES TAX AMOUNT: The amount of tax computed or entered for
a document.
FATCKIN_DISC_AMT NUMBER 12 2 YES DISCOUNT AMOUNT: The dollar value of the discount
being taken on the invoice.
FATCKIN_ADDL_AMT NUMBER 12 2 YES ADDITIONAL AMOUNT: The dollar value of any additional
charges associated with this invoice.
FATCKIN_FED_WHOLD_AMT NUMBER 12 2 YES FEDERAL WITHHOLDING AMOUNT: The amount withheld for a
1099 disbursement for remittance to the government.
FATCKIN_ST_WHOLD_AMT NUMBER 12 2 YES STATE WITHHOLDING TAX: The amount withheld for state
taxes from an entity's 1099 payment.
FATCKIN_NET_AMT NUMBER 12 2 YES NET AMOUNT: The net amount of an invoice.
FATCKIN_BANK_CODE VARCHAR2 2 YES BANK CODE: A user-defined value which is used for
identification purposes on all cash transactions.
FATCKIN_CHECK_NUM VARCHAR2 8 YES CHECK NUMBER: The pre-printed check number.
Date: 21-JUN-2004 Page: 44
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCKIN_CHECK_DATE DATE 7 YES CHECK DATE: The date of issue for a check.
FATCKIN_CHECK_DUE_IND VARCHAR2 1 YES CHECK DUE INDICATOR: Once an invoice has been selected
for payment, this field is set to 'Y' to indicate that
the check is due to be paid.
FATCKIN_GROUPING_IND VARCHAR2 1 YES GROUPING INDICATOR: Indicates the relationship between
the number of invoices processed and the number of
checks. A value of '1' will create one check per
invoice whereas a value of 'M' will combine many
invoices on one check.
FATCKIN_VEND_CHECK_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION MASTER: The unique
personal identification master of a vendor to whom the
check is issued. This could differ from the vendor on
the invoice.
FATCKIN_DISB_AGENT_IND VARCHAR2 1 YES DISBURSING AGENT INDICATOR: Used to identify this
invoice as one using a disburing agent to write a
check.
FATCKIN_VEND_FULL_NAME VARCHAR2 90 YES VENDOR FULL NAME: Last name, first name, and middle
initial of the Vendor.
FATCKIN_ATYP_CODE_VEND VARCHAR2 2 YES
FATCKIN_ATYP_SEQ_NUM_VEND NUMBER 2 YES
FATCKIN_CURR_CODE VARCHAR2 4 YES
FATCKIN_CONVERT_GROSS_AMT NUMBER 12 2 YES CONVERTED GROSS AMOUNT: The base gross amount
calculated for this header record. Used when a
currency code is established at the invoice header
record.
FATCKIN_CONVERT_TAX_AMT NUMBER 12 2 YES CONVERTED TAX AMOUNT: The base tax amount calculated
for this header record. Used when a currency code is
established at the invoice header record.
FATCKIN_CONVERT_DISC_AMT NUMBER 12 2 YES CONVERTED DISCOUNT AMOUNT: The base discount amount
calculated for this header record. Used when a
currency code is established at the invoice header
record.
FATCKIN_CONVERT_ADDL_AMT NUMBER 12 2 YES CONVERTED ADDITIONAL CHARGES AMOUNT: The base
additional charges amount calculated for this header
record. Used when a currency code is established at
the invoice header record.
FATCKIN_CONVERT_NET_AMT NUMBER 12 2 YES CONVERTED NET AMOUNT: The base net amount calculated
for this header record. Used when a currency code is
established at the invoice header record.
FATCKIN_ONE_TIME_VEND_NAME VARCHAR2 60 YES One Time Vendor name for One Time Vendors
FATCKIN_ONE_TIME_VEND_ADDR1 VARCHAR2 30 YES One Time Vendor address line one for One Time Vendors
FATCKIN_ONE_TIME_VEND_ADDR2 VARCHAR2 30 YES One Time Vendor address line two for One Time Vendors
FATCKIN_ONE_TIME_VEND_ADDR3 VARCHAR2 30 YES One Time Vendor address line three for One Time
Vendors
FATCKIN_ONE_TIME_VEND_CITY VARCHAR2 20 YES One Time Vendor city for One Time Vendors
FATCKIN_ONE_TIME_VEND_STATE VARCHAR2 3 YES One Time Vendor state for One Time Vendors
FATCKIN_ONE_TIME_VEND_ZIP VARCHAR2 10 YES One Time Vendor zip code for One Time Vendors
FATCKIN_ONE_TIME_VEND_NATN VARCHAR2 5 YES One Time Vendor nation for One Time Vendors
FATCKIN_RUIV_IND VARCHAR2 1 YES Recurring Invoice Indicator: Indicates that an invoice
will be processed on a recurring basis on a specific
schedule.
FATCKIN_DELIVERY_POINT NUMBER 2 YES DELIVERY POINT: This field indicates the delivery
point associated with the address.
FATCKIN_CORRECTION_DIGIT NUMBER 1 YES CORRECTION DIGIT: This field indicates the correction
digit associated with the address.
Date: 21-JUN-2004 Page: 45
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCKIN_CARRIER_ROUTE VARCHAR2 4 YES CARRIER ROUTE: This field indicates the carrier route
associated with the address.
FATCKIN_PAYMT_TYPE_IND VARCHAR2 1 YES PAYMENT TYPE INDICATOR: The kind of payment being made
to the vendor - (C)heck or (D)irect Deposit.
FATCKIN_ACH_FORMAT VARCHAR2 3 YES DIRECT DEPOSIT FORMAT: CTX Format used for corporate
vendors and PPD Format used for one time vendors such
as students and employees.
Date: 21-JUN-2004 Page: 46
TABLE: FATCKNO
CREATOR: FIMSMGR
Batch Check Number Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATCKNO_CHECK_NUM VARCHAR2 8 YES CHECK NUMBER: The pre-printed check number.
FATCKNO_CHECK_TYPE VARCHAR2 1 YES Defines what type of check is associated with the
check number. Values are 'T' for test, 'S' for
starting number, 'E' for ending number, 'M' for manual
and 'O' for online.
FATCKNO_SEQ_NO NUMBER 2 YES OPERATING LEDGER SEQUENCE NUMBER: This number
represents a predefined value within the BANNER
Finance which is used for operating ledger
classification and reporting purposes.
FATCKNO_CHECK_DATE DATE 7 YES This is the check date entered on the batch check
print form FAABATC.
FATCKNO_BANK_CODE VARCHAR2 2 YES BANK CODE: A user-defined value which is used for
identification purposes on all cash transactions.
FATCKNO_CHECK_COUNT NUMBER 3 YES Total number of check numbers produced in the batch
check run.
FATCKNO_FABCHKD_RUN_IND VARCHAR2 1 YES FABCHKD RUN INDICATOR: Set to Y on max check number
after fabchkd rpt has been run during the check
writing process.
FATCKNO_PAYMT_MODE_IND VARCHAR2 1 YES PAYMENT MODE INDICATOR: The type of vendor payments -
(C)heck Vendors, (D)irect Deposit Vendors, or (B)oth.
Date: 21-JUN-2004 Page: 47
TABLE: FATTAXB
CREATOR: FIMSMGR
Magnetic 1099 Record B
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATTAXB_REC_TYPE VARCHAR2 1 YES
FATTAXB_RPT_YR VARCHAR2 2 YES
FATTAXB_DOC_SPEC_CODE VARCHAR2 2 YES
FATTAXB_BLANK_1 VARCHAR2 1 YES
FATTAXB_CORRECTED_IND VARCHAR2 1 YES
FATTAXB_PAYEE_NAME_CONTROL VARCHAR2 4 YES
FATTAXB_TYPE_OF_RPT_ID VARCHAR2 1 YES
FATTAXB_RPT_ID VARCHAR2 9 YES
FATTAXB_PAYEE_PIDM VARCHAR2 20 YES
FATTAXB_PCT_OF_DIST VARCHAR2 3 YES
FATTAXB_BLANK_2 VARCHAR2 4 YES
FATTAXB_PAYMENT_AMT_1 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_2 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_3 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_4 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_5 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_6 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_7 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_8 VARCHAR2 12 YES
FATTAXB_PAYMENT_AMT_9 VARCHAR2 12 YES
FATTAXB_BLANK_3 VARCHAR2 20 YES
FATTAXB_FOREIGN_CORP_IND VARCHAR2 1 YES
FATTAXB_FIRST_PAYEE_NAME VARCHAR2 40 YES
FATTAXB_SECOND_PAYEE_NAME VARCHAR2 40 YES
FATTAXB_PAYEE_MAIL_ADDR VARCHAR2 40 YES
FATTAXB_PAYEE_CITY VARCHAR2 29 YES
FATTAXB_PAYEE_ST VARCHAR2 3 YES
FATTAXB_PAYEE_ZIP VARCHAR2 10 YES
FATTAXB_BLANK_4 VARCHAR2 28 YES
FATTAXB_SPECIAL_DATA VARCHAR2 67 YES
FATTAXB_STATE_CODE VARCHAR2 3 YES LOCATION STATE: The state or provincial address of a
particular location.
FATTAXB_BLANK_5 VARCHAR2 2 YES
FATTAXB_DELIVERY_POINT NUMBER 2 YES DELIVERY POINT: This field indicates the delivery
point associated with the address.
FATTAXB_CORRECTION_DIGIT NUMBER 1 YES CORRECTION DIGIT: This field indicates the correction
digit associated with the address.
FATTAXB_CARRIER_ROUTE VARCHAR2 4 YES CARRIER ROUTE: This field indicates the carrier route
associated with the address.
FATTAXB_PAYMENT_AMT_10 VARCHAR2 12 YES PAYEE AMOUNT TYPE A - This column accumulates amounts
of income type Crop insurance proceeds.
FATTAXB_PAYMENT_AMT_11 VARCHAR2 12 YES PAYEE AMOUNT TYPE B - This column accumulates amounts
of income type Excess golden parachute payments.
FATTAXB_PAYMENT_AMT_12 VARCHAR2 12 YES PAYEE AMOUNT TYPE C - This column accumulates amounts
of income type Gross proceeds paid to an attorney in
connection with legal services.
Date: 21-JUN-2004 Page: 48
TABLE: FATTAXT
CREATOR: FIMSMGR
Temporary 1099 Magnetic Tape DATA
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FATTAXT_RECORD_NUMBER NUMBER 2 YES Record Number : Will have value 1 for the T record, 2
for the A record, 3 for all the B records, 4 for the C
record and 5 for the F record. To create the magnetic
tape select all data and order by record
number.
FATTAXT_IRS_MAGNETIC_TAPE_DATA VARCHAR2 750 YES ONE MAGNETIC TAPE RECORD : Each row holds one complete
record to be inserted into the magnetic tape. Each
record can either be a T, A, B, C or F record.
Date: 21-JUN-2004 Page: 49
TABLE: FBBBLIN
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBBBLIN_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user defined unique
identifier of a budget identifier.
FBBBLIN_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBBBLIN_ACCT_CODE VARCHAR2 6 NO ACCOUNT CODE: The user-defined value representing an
account.
FBBBLIN_FUND_CODE VARCHAR2 6 NO FUND CODE: A code that uniquely identifies a fiscal
entity.
FBBBLIN_OBPH_CODE VARCHAR2 6 NO OPERATION BUDGET PHASE CODE: User specified code which
defines a phase of the budget.
FBBBLIN_BUDG_DUR_CODE VARCHAR2 1 NO BUDGET DURATION CODE:
FBBBLIN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered of last updated.
FBBBLIN_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBBBLIN_BUDG_MEAS_TYPE VARCHAR2 1 NO BUDGET MEASURE TYPE: The type of measurement for a
particular phase within a budget ID. May be defined
as dollars, hours, or a user-defined unit.
FBBBLIN_BUDG_PRD_TYPE VARCHAR2 1 NO BUDGET PERIOD TYPE: Indicator of the type of period
for this phase of the budget. Values may be A for
annual, P for period, or Q for quarter.
FBBBLIN_SEQ_DISPLAY_NUM NUMBER 2 NO SEQUENCE TO DISPLAY NUMBER:
FBBBLIN_BUDG_AMT NUMBER 12 2 NO
FBBBLIN_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
which appears on a transaction.
FBBBLIN_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value for the program
classification structure as defined by the National
Council of Higher Education Management Systems.
FBBBLIN_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The user-defined default activity code
used on transactions for this fund, if the activity
code is not supplied by the transaction.
FBBBLIN_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institution's financial manager. For example, Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FBBBLIN_TEXT_IND VARCHAR2 1 YES TEXT INDICATOR: The view text or enter text indicator.
FBBBLIN_TEXT_SEQ_NUM VARCHAR2 15 YES TEXT SEQUENCE NUMBER:
FBBBLIN_ADJT_AMT NUMBER 12 2 YES ADJUSTED AMOUNT: Cumulative amount of adjustment from
the Budget Maintenance Forms.
FBBBLIN_ROLL_AMT NUMBER 12 2 YES ROLLED AMOUNT: Amount rolled into General Ledger to
date.
FBBBLIN_ADOPT_BUD_AMT NUMBER 12 2 YES ADOPTED BUDGET AMOUNT: Adopted budget(Original Budget)
amount from Operating Ledger at the time of budget
build.
FBBBLIN_TEMP_ADOPT_AMT NUMBER 12 2 YES TEMPORARY ADOPTED AMOUNT: Temporary adopted amount.
FBBBLIN_TEMP_ADJT_AMT NUMBER 12 2 YES TEMPORARY ADJUSTMENT AMOUNT: Temporary adjustment
amount.
Date: 21-JUN-2004 Page: 50
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBBBLIN_ADJT_BUD_AMT NUMBER 12 2 YES ADJUSTED BUDGET AMOUNT: Adjustments to budget from
Operating Ledger at the time of budget build.
FBBBLIN_AUDIT_EXISTS_IND VARCHAR2 1 NO AUDIT TRAIL EXISTS INDICATOR: Used to indicate whether
a row has any audit trail records in the audit table
or not. Valid values are Y and N.
FBBBLIN_BASE_COAS_CODE VARCHAR2 1 YES BASE CHART OF ACCOUNTS: The source Chart of Accounts
from which the budget was rolled.
FBBBLIN_BASE_FSYR_CODE VARCHAR2 2 YES BASE FISCAL YEAR: The source fiscal year from which
the budget was rolled.
FBBBLIN_BASE_BUDG_AMT NUMBER 12 2 YES BASE BUDGET AMOUNT: Base budget amount at the time
budget build.
FBBBLIN_ORIGIN_POINT VARCHAR2 4 YES ORIGINAL POINT: Used to hold the origin of the FOAPAL.
Valid values are OPAL for rolled from OPAL, NEW for
Newly created budget line and POSN for Position
Control.
Date: 21-JUN-2004 Page: 51
TABLE: FBBBPRC
CREATOR: FIMSMGR
Budget Process Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBBBPRC_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user-defined unique
identifier of a budget identifier.
FBBBPRC_OBPH_CODE VARCHAR2 6 NO
FBBBPRC_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBBBPRC_ACTION_IND VARCHAR2 1 NO ACTION INDICATOR:
FBBBPRC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FBBBPRC_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of ther user.
FBBBPRC_COAS_CODE_OPAL VARCHAR2 1 YES
FBBBPRC_FSYR_CODE_OPAL VARCHAR2 2 YES
FBBBPRC_OBUD_CODE_BASE VARCHAR2 6 YES OPERATING BUDGET BASE CODE: The identification of the
base budget ID for this budget.
FBBBPRC_OBPH_CODE_BASE VARCHAR2 6 YES OPERATING BUDGET BASE PHASE CODE: The identification
of the base budget phase.
FBBBPRC_COAS_CODE_BASE VARCHAR2 1 YES
FBBBPRC_OPT_INCLUDE_ADOP VARCHAR2 1 YES
FBBBPRC_OPT_INCLUDE_ADJT VARCHAR2 1 YES
FBBBPRC_OPT_INCLUDE_TEMP VARCHAR2 1 YES
FBBBPRC_OPT_BUILD_DIST VARCHAR2 1 YES OPERATING
FBBBPRC_OPT_PURGE_UNMATCH VARCHAR2 1 YES OPERATING
FBBBPRC_OPT_ADD_UNMATCH VARCHAR2 1 YES OPERATING
FBBBPRC_RUCL_CODE_ACTV_PERM VARCHAR2 4 YES
FBBBPRC_RUCL_CODE_ACTV_TEMP VARCHAR2 4 YES
FBBBPRC_PCT_ROLLED_ACTV NUMBER 6 3 YES
FBBBPRC_DESCRIPTION_ACTV VARCHAR2 30 YES
FBBBPRC_REPEAT_ROLL_IND VARCHAR2 1 YES REPEAT BUDGET ROLL INDICATOR: Parameter for activating
a budget phase. Set to 'R' when rerunning the budget
roll, otherwise field is null.
FBBBPRC_OPT_INCLUDE_LABOR VARCHAR2 1 YES OPTION TO INCLUDE LABOR ACCOUNTS: Enter (Y) if you
want accounts with a labor account type to be rolled
from opal or a base budget to the new phase. Enter
(N) to exclude the labor accounts from being rolled.
Date: 21-JUN-2004 Page: 52
TABLE: FBBCHGP
CREATOR: FIMSMGR
MASS CHANGE PARAMETER TABLE
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBBCHGP_OBUD_CODE VARCHAR2 6 NO OPERAING BUDGET CODE: The user-defined unique
identifier of a budget identifier.
FBBCHGP_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBBCHGP_OBPH_CODE VARCHAR2 6 NO OPERATING BUDGET PHASE CODE.
FBBCHGP_BUDG_DUR_CODE VARCHAR2 1 NO BUDGET DURATION CODE.
FBBCHGP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FBBCHGP_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBBCHGP_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
which appears on a transaction.
FBBCHGP_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account.
FBBCHGP_FUND_CODE VARCHAR2 6 YES FUND CODE: A code that uniquely identifies a fiscal
entity.
FBBCHGP_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure as defined by the National
Council of Higher Education Management Systems.
FBBCHGP_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The user-defined default activity code
used on transactions for this fund, if the activity
code is not supplied by the transaction.
FBBCHGP_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institution's financial manager. For example; Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FBBCHGP_RUCL_CODE VARCHAR2 4 YES RULE CLASS CODE: The four character alphanumeric code
identifying an accounting transaction rule class.
FBBCHGP_CHG_BUDG_WITHIN VARCHAR2 1 YES CHANGE BUDGET WITHIN.
FBBCHGP_BUDG_CHG_AMT NUMBER 12 2 YES BUDGET CHANGE AMOUNT.
FBBCHGP_BUDG_CHG_PCT NUMBER 6 3 YES BUDGET CHANGE PERCENT.
Date: 21-JUN-2004 Page: 53
TABLE: FBBLOCK
CREATOR: FIMSMGR
Organization Lock Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBBLOCK_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBBLOCK_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user defined unique
identifier of a budget identifier.
FBBLOCK_OBPH_CODE VARCHAR2 6 NO BUDGET PHASE CODE: User specified code which defines a
phase of the budget.
FBBLOCK_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBBLOCK_LOCK_STATUS_IND VARCHAR2 1 NO
FBBLOCK_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered of last updated.
FBBLOCK_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
Date: 21-JUN-2004 Page: 54
TABLE: FBRATHC
CREATOR: FIMSMGR
ACCT HIERARCHY Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRATHC_SESS_ID NUMBER 8 NO SESSION IDENTIFICATION:
FBRATHC_ACCT_CODE VARCHAR2 6 NO ACCOUNT CODE: The user-defined value representing an
account.
FBRATHC_LEVEL VARCHAR2 1 NO LEVEL
FBRATHC_ACCT_LEVEL_1 VARCHAR2 6 NO ACOUNTING LEVEL 1
FBRATHC_ACCT_LEVEL_2 VARCHAR2 6 YES ACCOUNTING LEVEL 2
FBRATHC_ACCT_LEVEL_3 VARCHAR2 6 YES ACCOUNTING LEVEL 3
FBRATHC_ACCT_LEVEL_4 VARCHAR2 6 YES ACCOUNTING LEVEL 4
Date: 21-JUN-2004 Page: 55
TABLE: FBRAUDT
CREATOR: FIMSMGR
Budget Line Audit History Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRAUDT_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBRAUDT_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user defined unique
identifier of a budget identifier.
FBRAUDT_OBPH_CODE VARCHAR2 6 NO BUDGET PHASE CODE: User specified code which defines a
phase of the budget.
FBRAUDT_SEQ_NUM NUMBER NO SEQUENCE NUMBER: Sequence number on Chart, Budget ID
and Phase.
FBRAUDT_BUDG_DUR_CODE VARCHAR2 1 NO BUDGET DURATION: The budget duration code.
FBRAUDT_BUDG_MEAS_TYPE VARCHAR2 1 NO BUDGET MEASURE TYPE: The type of measurement for a
particular phase within a budget ID. May be defined
as dollars, hours, or a user-defined unit.
FBRAUDT_BUDG_PRD_TYPE VARCHAR2 1 NO BUDGET PERIOD TYPE: Indicator of the type of period
for this phase of the budget. Values may be A for
annual, P for period, or Q for quarter.
FBRAUDT_DELETED_IND VARCHAR2 1 NO DELETE INDICATOR: Used to indicate if this row was
deleted. Valid values are Y - if the row is deleted,
N - for not deleted.
FBRAUDT_SEQ_DISPLAY_NUM NUMBER 2 NO SEQUENCE TO DISPLAY NUMBER: The sequence display
number.
FBRAUDT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered of last updated.
FBRAUDT_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBRAUDT_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the fund code that appears on a
transaction.
FBRAUDT_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBRAUDT_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account.
FBRAUDT_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure as defined by the National
Council of Higher Education Management Systems.
FBRAUDT_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity that is primarily
associated with this organization.
FBRAUDT_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institutions financial manager.
FBRAUDT_TEXT_SEQ_NUM VARCHAR2 15 YES TEXT SEQUENCE NUMBER: Used to indicate the sequence
number for text.
FBRAUDT_ADOPT_BUD_AMT NUMBER 12 2 YES ADOPTED BUDGET AMOUNT:
Adopted budget amount from OPAL
at the time of build.
FBRAUDT_TEMP_ADOPT_AMT NUMBER 12 2 YES TEMPORARY ADOPTED AMOUNT:
Temporary Adopted Amount.
FBRAUDT_TEMP_ADJT_AMT NUMBER 12 2 YES TEMPORARY ADJUSTED AMOUNT:
Temporary Adjusted Amount.
Date: 21-JUN-2004 Page: 56
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRAUDT_ADJT_BUD_AMT NUMBER 12 2 YES ADJUSTED BUDGET AMOUNT: Adjustments to budget from
OPAL at the time of budget build.
FBRAUDT_BASE_BUDG_AMT NUMBER 12 2 YES BASE BUDGET AMOUNT: Base budget amount at the time
budget build.
FBRAUDT_BASE_COAS_CODE VARCHAR2 1 YES BASE CHART OF ACCOUNTS: The source Chart of Accounts
from which the budget was rolled.
FBRAUDT_BASE_FSYR_CODE VARCHAR2 2 YES BASE FISCAL YEAR: Fiscal Year Code from which budget
was build.
FBRAUDT_ORIGIN_POINT VARCHAR2 4 YES ORIGIN POINT: Used to indica te the origin of the
FOAPAL. Valid values are OPAL- for rolled from OPAL,
NEW- for Newly created budget line and POSN- for
Position Control.
FBRAUDT_PRIOR_AMT NUMBER 12 2 YES PRIOR AMOUNT: Prior Amount.
FBRAUDT_CHANGE_AMT NUMBER 12 2 YES CHANGE AMOUNT: Amount by which the Budget amount got
changed.
Date: 21-JUN-2004 Page: 57
TABLE: FBRBDLC
CREATOR: FIMSMGR
Organization Lock Collector Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRBDLC_PIDM NUMBER 8 NO PIDM: Internal identification number of the person.
FBRBDLC_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBRBDLC_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user defined unique
identifier of a budget identifier.
FBRBDLC_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBRBDLC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered of last updated.
FBRBDLC_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBRBDLC_ORGN_CODE_PRED VARCHAR2 6 YES PREDECESSOR ORGANIZATION CODE: The value of the next
higher organizational level unless this is level 1.
FBRBDLC_OBPH1_CODE VARCHAR2 6 YES BUDGET PHASE CODE1: User specified code which defines
a phase of the budget.
FBRBDLC_OBPH2_CODE VARCHAR2 6 YES BUDGET PHASE CODE2: User specified code which defines
a phase of the budget.
FBRBDLC_OBPH3_CODE VARCHAR2 6 YES BUDGET PHASE CODE2: User specified code which defines
a phase of budget.
FBRBDLC_OBPH1_LOCK_STATUS VARCHAR2 1 YES BUDGET1 LOCK STATUS: Used to indicate the status of
the organization in phase 1.
FBRBDLC_OBPH1_LOCK_TYPE VARCHAR2 1 YES BUDGET1 LOCK TYPE: Used to indicate the type of lock
status. Valid values are I for Inferred and P for
physical.
FBRBDLC_OBPH1_HIER_STATUS VARCHAR2 1 YES BUDGET1 HIER STATUS: Used to indicate if the status of
any successor orgn is Unlocked while the phase 1
organization has a status of Locked.
FBRBDLC_OBPH1_CHNG_STATUS VARCHAR2 1 YES BUDGET1 CHANGED STATUS: Used to indicate whether the
phase 1 status was changed.
FBRBDLC_OBPH2_LOCK_STATUS VARCHAR2 1 YES BUDGET2 LOCK STATUS: Used to indicate the status of
the organization in phase 2.
FBRBDLC_OBPH2_LOCK_TYPE VARCHAR2 1 YES BUDGET2 LOCK TYPE: Used to indicate the type of lock
status. Valid values are I for Inferred and P for
physical.
FBRBDLC_OBPH2_HIER_STATUS VARCHAR2 1 YES BUDGET2 HIER STATUS: Used to indicate if the status of
any successor orgn is Unlocked while the phase 2
organization has a status of Locked.
FBRBDLC_OBPH2_CHNG_STATUS VARCHAR2 1 YES BUDGET2 CHANGED STATUS: Used to indicate whether the
phase 2 status was changed.
FBRBDLC_OBPH3_LOCK_STATUS VARCHAR2 1 YES BUDGET3 LOCK STATUS: Used to indicate the status of
the organization in phase 3.
FBRBDLC_OBPH3_LOCK_TYPE VARCHAR2 1 YES BUDGET3 LOCK TYPE: Used to indicate the type of lock
status. Valid values are I for Inferred and P for
physical.
Date: 21-JUN-2004 Page: 58
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRBDLC_OBPH3_HIER_STATUS VARCHAR2 1 YES BUDGET3 HIER STATUS: Used to indicate if the status of
any successor orgn is Unlocked while the phase 2
organization has a status of Locked.
FBRBDLC_OBPH3_CHNG_STATUS VARCHAR2 1 YES BUDGET3 CHANGED STATUS: Used to indicate whether the
phase 3 status was changed.
FBRBDLC_ORGN_TITLE VARCHAR2 35 YES ORGANIZATION TITLE: Organization Title.
Date: 21-JUN-2004 Page: 59
TABLE: FBRBDPR
CREATOR: FIMSMGR
Budget Process Delete Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRBDPR_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user-defined unique
identifier of a budget identifier.
FBRBDPR_OBPH_CODE VARCHAR2 6 NO OPERATING
FBRBDPR_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts that uniquely
identifies that chart from any other in a multi-chart
environment.
FBRBDPR_TYPE_INDICATOR VARCHAR2 1 NO TYPE INDICATOR:
FBRBDPR_TYPE_CODE VARCHAR2 2 NO TYPE CODE: Unique identifier.
FBRBDPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FBRBDPR_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
Date: 21-JUN-2004 Page: 60
TABLE: FBRBDQC
CREATOR: FIMSMGR
BUDGET QUERY Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRBDQC_SESSION NUMBER 8 NO SESSION:
FBRBDQC_KEY1 VARCHAR2 6 YES KEY ONE:
FBRBDQC_KEY2 VARCHAR2 6 YES KEY TWO:
Date: 21-JUN-2004 Page: 61
TABLE: FBRBDWC
CREATOR: FIMSMGR
Budget Worksheet Colletor Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRBDWC_PIDM NUMBER 8 NO PIDM: Internal identification number of the person.
FBRBDWC_SEQ_NUM NUMBER 3 NO SEQUENCE NUMBER: Sequence number on Chart, Budget ID
and Phase.
FBRBDWC_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBRBDWC_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user defined unique
identifier of a budget identifier.
FBRBDWC_OBPH_CODE VARCHAR2 6 NO BUDGET PHASE CODE: User specified code which defines a
phase of the budget.
FBRBDWC_BUDG_DUR_CODE VARCHAR2 1 NO BUDGET DURATION: The budget duration code.
FBRBDWC_BUDG_MEAS_TYPE VARCHAR2 1 NO BUDGET MEASURE TYPE: The ty pe of measurement for a
particular phase within a budget ID. May be defined
as dollars, hours, or a user-defined unit.
FBRBDWC_BUDG_PRD_TYPE VARCHAR2 1 NO BUDGET PERIOD TYPE: Indicato r of the type of period
for this phase of the budget. Values may be A for
annual, P for period, or Q for quarter.
FBRBDWC_DELETED_IND VARCHAR2 1 NO DELETE INDICATOR: Used to indicate if this row was
deleted. Valid values are Y - if the row is deleted,
N - for not deleted.
FBRBDWC_SEQ_DISPLAY_NUM NUMBER 2 NO SEQUENCE TO DISPLAY NUMBER: The sequence display
number.
FBRBDWC_ROW_CHNGE_STATUS VARCHAR2 1 NO ROW CHANGE STATUS: Change staus - A for added new row,
D for deleted, R for reinstate, E for existing.
FBRBDWC_AUDT_EXISTS_IND VARCHAR2 1 NO AUDIT TRAIL EXISTS INDICATOR: Used to indicate whether
a row has any audit trail records in the audit table
or not. Valid values are Y and N.
FBRBDWC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered of last updated.
FBRBDWC_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBRBDWC_TEXT_SEQ_NUM VARCHAR2 15 YES TEXT SEQUENCE NUMBER: Used to indicate the sequence
number for text.
FBRBDWC_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the fund code that appears on a
transaction.
FBRBDWC_FUND_TITLE VARCHAR2 35 YES FUND TITLE: The hierarchy description or title
appropriate for this level.
FBRBDWC_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBRBDWC_ORGN_TITLE VARCHAR2 35 YES ORGANIZATION TITLE: The hierarchy description or title
appropriate for this level.
FBRBDWC_ATYP_CODE VARCHAR2 2 YES ACCOUNT TYPE CODE: Classifies an account type i.e.,
liabilities, control, fund balance, revenue,labor
expenses, which are used for reporting purposes.
Date: 21-JUN-2004 Page: 62
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRBDWC_ATYP_TITLE VARCHAR2 35 YES ACCOUNT TYPE TITLE: The hierarchy description or title
appropriate for this level.
FBRBDWC_INTERNAL_ATYP_CODE VARCHAR2 2 YES INTERNAL ACCOUNT TYPE: The pre-defined values
representing account types(revenue, expenses, asset,
liability, etc.) linked to level one account types and
used to identify transactional data for proc
essing
and reporting purposes.
FBRBDWC_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account.
FBRBDWC_ACCT_TITLE VARCHAR2 35 YES ACCOUNT TITLE: The hierarchy description or title
appropriate for this level.
FBRBDWC_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure as defined by the National
Council of Higher Education Management Systems.
FBRBDWC_PROG_TITLE VARCHAR2 35 YES PROGRAM TITLE: The hierarchy description or title
appropriate for this level.
FBRBDWC_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity that is primarily
associated with this organization.
FBRBDWC_ACTV_TITLE VARCHAR2 35 YES ACTIVITY TITLE: The hierachy description or title
appropriate for this level.
FBRBDWC_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institutions financial manager.
FBRBDWC_LOCN_TITLE VARCHAR2 35 YES LOCATION TITLE: The hierarchy description or title
appropriate for this level.
FBRBDWC_ADOPT_BUD_AMT NUMBER 12 2 YES ADOPTED BUDGET AMOUNT: Adopted budget amount from OPAL
at the time of build.
FBRBDWC_ADJT_BUD_AMT NUMBER 12 2 YES ADJUSTED BUDGET AMOUNT: Adjustments to budget from
OPAL at the time of budget build.
FBRBDWC_TEMP_ADOPT_AMT NUMBER 12 2 YES TEMPORARY ADOPTED AMOUNT: Temporary Adopted Amount.
FBRBDWC_TEMP_ADJT_AMT NUMBER 12 2 YES TEMPORARY ADJUSTED AMOUNT: Temporary Adjusted Amount.
FBRBDWC_BASE_COAS_CODE VARCHAR2 1 YES BASE CHART OF ACCOUNTS: The source Chart of Accounts
from which the budget was rolled.
FBRBDWC_BASE_FSYR_CODE VARCHAR2 2 YES BASE FISCAL YEAR: Fiscal Year Code from which budget
was build.
FBRBDWC_BASE_BUDG_AMT NUMBER 12 2 YES BASE BUDGET AMOUNT: Base budget amount at the time
budget build.
FBRBDWC_ORIGIN_POINT VARCHAR2 4 YES ORIGIN POINT: Used to indicate the origin of the
FOAPAL. Valid values are OPAL- for rolled from OPAL,
NEW- for Newly created budget line and POSN- for
Position Control.
FBRBDWC_BUDG_AMT NUMBER 12 2 YES BUDGET AMOUNT: Budget Amount at the time budget build.
FBRBDWC_NEW_AMT NUMBER 12 2 YES NEW ANOUNT: New Amount.
FBRBDWC_CUM_CHANGE_AMT NUMBER 12 2 YES CHANGE AMOUNT: The difference between current budget
in this working session (including the changes made in
the session that have not yet been posted to the
Budget Line Table) and the base budget.
Date: 21-JUN-2004 Page: 63
TABLE: FBRDISP
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRDISP_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE:.
FBRDISP_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBRDISP_OBPH_CODE VARCHAR2 6 NO OPERATING BUDGET PHASE CODE:.
FBRDISP_BUDG_DUR_CODE VARCHAR2 1 NO BUDGET DURATION CODE:.
FBRDISP_START_BUDG_PERIOD NUMBER 2 NO START BUDGET PERIOD:.
FBRDISP_NO_BUDG_PERIODS NUMBER 2 NO NUMBER OF BUDGET PERIODS:.
FBRDISP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FBRDISP_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBRDISP_DIST_BUDG_WITHIN VARCHAR2 1 NO DISTRIBUTE BUDGET WITHIN ACCOUNT:.
FBRDISP_BUDG_MEAS_TYPE VARCHAR2 1 NO BUDGET MEASURE TYPE:.
FBRDISP_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBRDISP_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account.
FBRDISP_FUND_CODE VARCHAR2 6 YES FUND CODE: A code which uniquely identifies a fiscal
entity.
FBRDISP_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure code or a subset or that
structure as defined by the National Council of Higher
Education Management Systems.
FBRDISP_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity that is primarily
associated with this organization.
FBRDISP_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institution's financial manager. For example, Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FBRDISP_UNDIST_BUDG_AMT NUMBER 12 2 YES UNDISTRIBUTED BUDGET AMOUNT:.
FBRDISP_BUDG_AMT NUMBER 12 2 YES BUDGET AMOUNT:.
FBRDISP_BUDG_PERCENT NUMBER 6 3 YES BUDGET PERCENT:.
FBRDISP_REDIST_IND VARCHAR2 1 YES REDISTRIBUTION INDICATOR:.
Date: 21-JUN-2004 Page: 64
TABLE: FBRDIST
CREATOR: FIMSMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRDIST_OBUD_CODE VARCHAR2 6 NO BUDGET CODE:
FBRDIST_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBRDIST_OBPH_CODE VARCHAR2 6 NO OPERATING BUDGET PHASE CODE:
FBRDIST_BUDG_DUR_CODE VARCHAR2 1 NO BUDGET DURATION CODE:
FBRDIST_BUDG_PERIOD NUMBER 2 NO BUDGET PERIOD:
FBRDIST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FBRDIST_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBRDIST_BUDG_MEAS_TYPE VARCHAR2 1 NO BUDGET MEASURE TYPE:
FBRDIST_BUDG_AMT NUMBER 12 2 NO BUDGET AMOUNT:
FBRDIST_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBRDIST_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account.
FBRDIST_FUND_CODE VARCHAR2 6 YES FUND CODE: A code that uniquely identifies a fiscal
entity.
FBRDIST_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure code or a subset or that
structure as defined by the National Council of Higher
Education Management Systems.
FBRDIST_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity that is primarily
associated with this organization.
FBRDIST_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institution's financial manager. For example; Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FBRDIST_ADJT_AMT NUMBER 12 2 YES ADJUSTMENT AMOUNT:
FBRDIST_ROLL_AMT NUMBER 12 2 YES ROLL AMOUNT:
FBRDIST_LAST_ROLL_AMT NUMBER 12 2 YES LAST ROLL AMOUNT: Cumulative amount rolled as of the
last time fbrbdrl was run. Used for calcuating
transaction amounts when re-running the budget roll.
Date: 21-JUN-2004 Page: 65
TABLE: FBRFDHC
CREATOR: FIMSMGR
FUND HIER Table for Budget Distrib
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRFDHC_SESS_ID NUMBER 8 NO SESSION IDENTIFIER:
FBRFDHC_FUND_CODE VARCHAR2 6 NO FUND CODE: A code that uniquely identifies a fiscal
entity.
FBRFDHC_LEVEL VARCHAR2 1 NO LEVEL:
FBRFDHC_FUND_LEVEL_1 VARCHAR2 6 NO FUND CODE LEVEL 1: Represents the data entry level
sub-division within a fund hierarchy. This code
represents a self-balancing set of accounts and is a
unique balance sheet identifier.
FBRFDHC_FUND_LEVEL_2 VARCHAR2 6 YES FUND CODE LEVEL 2: Represents the data entry level
sub-division within a fund hierarchy. This code
represents a self-balancing set of accounts and is a
unique balance sheet identifier.
FBRFDHC_FUND_LEVEL_3 VARCHAR2 6 YES FUND CODE LEVEL 3: Represents the data entry level
sub-division within a fund hierarchy. This code
represents a self-balancing set of accounts and is a
unique balance sheet identifier.
FBRFDHC_FUND_LEVEL_4 VARCHAR2 6 YES FUND CODE LEVEL 4: Represents the data entry level
sub-division within a fund hierarchy. This code
represents a self-balancing set of accounts and is a
unique balance sheet identifier.
FBRFDHC_FUND_LEVEL_5 VARCHAR2 6 YES FUND CODE LEVEL 5: Represents the data entry level
sub-division within a fund hierarchy. This code
represents a self-balancing set of accounts and is a
unique balance sheet identifier.
Date: 21-JUN-2004 Page: 66
TABLE: FBRFEDC
CREATOR: FIMSMGR
Position Control Budget Update Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRFEDC_SYSTEM_ID VARCHAR2 8 NO SYSTEM ID: Always literal POSNBUD.
FBRFEDC_SYSTEM_TIME_STAMP VARCHAR2 14 NO SYSTEM TIME STAMP: When batch was created.
Date: 21-JUN-2004 Page: 67
TABLE: FBRLNBP
CREATOR: FIMSMGR
Budget Build FOAPAL Options Parameter Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRLNBP_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The Chart of Accounts of the
Budget ID.
FBRLNBP_OBUD_CODE VARCHAR2 6 NO BUDGET ID: The user defined code which represents the
budget identification.
FBRLNBP_OBPH_CODE VARCHAR2 6 NO BUDGET PHASE CODE: User specified code which defines a
phase of the budget.
FBRLNBP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record on the table was entered or last updated.
FBRLNBP_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FBRLNBP_ACTION_IND VARCHAR2 1 NO ACTION INDICATOR: The type of Action that is to be
performed by the budget build process. Valid values
are C - to copy for another budget; R - to delete the
FOAPAL from the existing budget.
FBRLNBP_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: The user- defined value
representing a summerization of any combination of
user-defined FOAPAL elements.
FBRLNBP_FUND_CODE VARCHAR2 6 YES FUND CODE: A code that uniquely identifies a fiscal
entity.
FBRLNBP_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
which appears on a transaction.
FBRLNBP_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account.
FBRLNBP_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value for the program
classification structure as defined by the National
Council of Higher Education Management Systems.
FBRLNBP_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The user-defined default activity code
used on transactions for this fund, if the activity
code is not supplied by the transaction.
FBRLNBP_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institutions financial manager.
FBRLNBP_FTYP_CODE VARCHAR2 2 YES FUND TYPE CODE: The user-defined value assigned to
level one and two fund types.
FBRLNBP_ATYP_CODE VARCHAR2 2 YES ACCOUNT TYPE CODE: Classifies an account type i.e.,
asset, liabilities, control, fund balance, revenue,
and labor expense are used for reporting purposes.
FBRLNBP_OBUD_CODE_BASE VARCHAR2 6 YES OPERATING BUDGET BASE CODE: The identification of the
base budget ID for this budget.
FBRLNBP_OBPH_CODE_BASE VARCHAR2 6 YES OPERATING BUDGET BASE PHASE CODE: The identification
of the base budget phase.
FBRLNBP_COAS_CODE_BASE VARCHAR2 1 YES OPERATING BASE CHART OF ACCOUNTS: Chart of accounts of
the base budget.
FBRLNBP_OPT_INCLUDE_ADOP VARCHAR2 1 YES OPTION TO INCLUDE ADOPTED BUDGET: Used to indicate
whether to include adopted budget or not. Valid
values are Y and N.
Date: 21-JUN-2004 Page: 68
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRLNBP_OPT_INCLUDE_ADJT VARCHAR2 1 YES OPTION TO INCLUDE ADJUSTED BUDGET: Used to indicate
whether to nclude adjusted budget or not. Valid
values are Y and N.
FBRLNBP_OPT_INCLUDE_TEMP VARCHAR2 1 YES OPTION TO INCLUDE TEMPORARY BUDGET: Used to indicate
whether to include temporary budget or not. Valid
values are Y and N.
FBRLNBP_OPT_UPDATE_MATCH VARCHAR2 1 YES OPTION UPDATE: Used to indicate whether to update any
duplicate rows found. Valid values are Y and N.
FBRLNBP_OPT_ADD_UNMATCH VARCHAR2 1 YES OPTION ADD: Used to indicate whether to insert any new
unmatched rows. Valid values are Y and N.
FBRLNBP_OPT_INCLUDE_LABOR VARCHAR2 1 YES OPTION TO INCLUDE LABOR ACCOUNTS: Used to indicate
whether to include labor accounts or not. Valid
values are Y and N.
Date: 21-JUN-2004 Page: 69
TABLE: FBRLOHC
CREATOR: FIMSMGR
LOCN HIER Table for Budget Distrib
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRLOHC_SESS_ID NUMBER 8 NO SESSION IDENTIFIER:
FBRLOHC_LOCN_CODE VARCHAR2 6 NO LOCATION CODE: The physical location of the
institution's financial manager. For example; Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FBRLOHC_LEVEL VARCHAR2 1 NO LEVEL:
FBRLOHC_LOCN_LEVEL_1 VARCHAR2 6 NO LOCATION CODE LEVEL 1: The user-defined location in
the location code hierarchy which represents a
physical location. This field is used in conjunction
with tracking capitalized assets in the fixed asset
sub-system.
FBRLOHC_LOCN_LEVEL_2 VARCHAR2 6 YES LOCATION CODE LEVEL 2: Specifies a user-defined
location in the location code hierarchy which
represents a physical location. This field is used in
conjunction with tracking capitalized assets in the
fixed asset sub-system.
FBRLOHC_LOCN_LEVEL_3 VARCHAR2 6 YES LOCATION CODE LEVEL 3: Specifies a user-defined
location in the location code hierarchy which
represents a physical location. This field is used in
conjunction with tracking capitalized assets in the
fixed asset sub-system.
FBRLOHC_LOCN_LEVEL_4 VARCHAR2 6 YES LOCATION CODE LEVEL 4: Specifies a user-defined
location in the location code hierarchy which
represents a physical location. This field is used in
conjunction with tracking capitalized assets in the
fixed asset sub-system.
FBRLOHC_LOCN_LEVEL_5 VARCHAR2 6 YES LOCATION CODE LEVEL 5: Specifies a user-defined
location in the location code hierarchy which
represents a physical location. This field is used in
conjunction with tracking capitalized assets in the
fixed asset sub-system.
Date: 21-JUN-2004 Page: 70
TABLE: FBRORHC
CREATOR: FIMSMGR
ORGN HIER Collector Table for Budget Distribution
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRORHC_SESS_ID NUMBER 8 NO SESSION IDENTIFIER:
FBRORHC_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBRORHC_LEVEL VARCHAR2 1 NO LEVEL:
FBRORHC_ORGN_LEVEL_1 VARCHAR2 6 NO ORGANIZATION CODE LEVEL 1: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept ID). This
code is required for all
revenue/expense/transfer/budgetary transactions.
FBRORHC_ORGN_LEVEL_2 VARCHAR2 6 YES ORGANIZATION CODE LEVEL 2: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept id). This
code is required for all
revenue/expense/transfer/budgetary transactions.
FBRORHC_ORGN_LEVEL_3 VARCHAR2 6 YES ORGANIZATION CODE LEVEL 3: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept id). This
code is required for all
revenue/expense/transfer/budgetary transactions.
FBRORHC_ORGN_LEVEL_4 VARCHAR2 6 YES ORGANIZATION CODE LEVEL 4: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept id). This
code is required for all
revenue/expense/transfer/budgetary transactions.
FBRORHC_ORGN_LEVEL_5 VARCHAR2 6 YES ORGANIZATION CODE LEVEL 5: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept id). This
code is required for all
revenue/expense/transfer/budgetary transactions.
FBRORHC_ORGN_LEVEL_6 VARCHAR2 6 YES ORGANIZATION CODE LEVEL 6: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept ID). This
code is required for all
revenue/expense/transfer/budgetary transactions.
FBRORHC_ORGN_LEVEL_7 VARCHAR2 6 YES ORGANIZATION CODE LEVEL 7: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept ID). This
code is required for all
revenue/expense/transfer/budgetary transactions.
FBRORHC_ORGN_LEVEL_8 VARCHAR2 6 YES ORGANIZATION CODE LEVEL 8: The code within the
hierarchial organization structure which represents an
administrative and/or budgetary unit (dept ID). This
code is required for all
revenue/expense/transfer/budgetary transactions.
Date: 21-JUN-2004 Page: 71
TABLE: FBRPGHC
CREATOR: FIMSMGR
PROG HIER Table for Budget Distrib
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRPGHC_SESS_ID NUMBER 8 NO SESSION IDENTIFIER:
FBRPGHC_PROG_CODE VARCHAR2 6 NO PROGRAM CODE: A user-defined value to the program
classification structure code or a subset or that
structure as defined by the National Council of Higher
Education Management Systems.
FBRPGHC_LEVEL VARCHAR2 1 NO LEVEL:
FBRPGHC_PROG_LEVEL_1 VARCHAR2 6 NO PROGRAM CODE LEVEL 1: The first level program code in
the five level program code hierarchy.
FBRPGHC_PROG_LEVEL_2 VARCHAR2 6 YES PROGRAM CODE LEVEL 2: The second level program code in
the five level program code hierarchy.
FBRPGHC_PROG_LEVEL_3 VARCHAR2 6 YES PROGRAM CODE LEVEL 3: The third level program code in
the five level program code hierarchy.
FBRPGHC_PROG_LEVEL_4 VARCHAR2 6 YES PROGRAM CODE LEVEL 4: The fourth level program code in
the five level program code hierarchy.
FBRPGHC_PROG_LEVEL_5 VARCHAR2 6 YES PROGRAM CODE LEVEL 5: The fifth level program code in
the five level program code hierarchy.
Date: 21-JUN-2004 Page: 72
TABLE: FBRWKSH
CREATOR: FIMSMGR
FBRWKSH REPORT Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBRWKSH_SESS_ID NUMBER 8 NO SESSION IDENTIFIER: Identifies a session in order to
group rows together
FBRWKSH_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FBRWKSH_FUND_CODE VARCHAR2 6 YES FUND CODE: A code that uniquely identifies a fiscal
entity.
FBRWKSH_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user defined value to the program
classification structure code or a subset or that
structure as defined by the National Council of Higher
Education Management Systems.
FBRWKSH_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity which is primarily
associated with this organization.
FBRWKSH_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institution's financial manager. For example, Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FBRWKSH_LINE_ITEM VARCHAR2 6 NO LINE ITEM: The user defined value for the account
classification
FBRWKSH_SUM_CURR_YEAR_BUDG NUMBER 12 2 YES SUMMARY CURRENT YEAR BUDGET: budget amount
FBRWKSH_SUM_PRIOR_YEAR_BUDG NUMBER 12 2 YES SUMMARY PRIOR YEAR BUDGET: budget amount
FBRWKSH_SUM_BUDG_YEAR_PHASE1 NUMBER 12 2 YES SUMMARY BUDGET YEAR PHASE 1: budget amount
FBRWKSH_SUM_BUDG_YEAR_PHASE2 NUMBER 12 2 YES SUMMARY BUDGET YEAR PHASE 2: budget amount
FBRWKSH_SUM_BUDG_YEAR_PHASE3 NUMBER 12 2 YES SUMMARY BUDGET YEAR PHASE 3: budget amount
FBRWKSH_BUDG_PERIOD NUMBER 2 YES BUDGET PERIOD: Financial period amount will be rolled
into when the budget is rolled to the operating ledger
Date: 21-JUN-2004 Page: 73
TABLE: FBTBLIN
CREATOR: FIMSMGR
TEMPORARY BUDGET LINE ITEM TABLE
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBTBLIN_SESSION_ID NUMBER 8 NO SESSION ID: The urrent session id.
FBTBLIN_WORKBOOK VARCHAR2 255 NO WORKBOOK NAME: The workbook name.
FBTBLIN_WORKSHEET VARCHAR2 255 NO WORKSHEET: The worksheet name.
FBTBLIN_ROW_NUMBER NUMBER 8 NO ROW NUMBER: The row number of the spreadsheet.
FBTBLIN_OBUD_CODE VARCHAR2 6 NO OPERATING BUDGET CODE: The user defined unique
identifier of a budget identifier.
FBTBLIN_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FBTBLIN_ACCT_CODE VARCHAR2 6 NO ACCOUNT CODE: The user-defined value representing an
account.
FBTBLIN_FUND_CODE VARCHAR2 6 NO FUND CODE: A code that uniquely identifies a fiscal
entity.
FBTBLIN_OBPH_CODE VARCHAR2 6 NO OPERATION BUDGET PHASE ID: This indicates phase id of
the budget.
FBTBLIN_BUDG_DUR_CODE VARCHAR2 1 NO BUDGET DURATION CODE:this indiates duration of the
budget.
FBTBLIN_BUDG_MEAS_TYPE VARCHAR2 1 NO BUDGET MEASURE TYPE: The type of measurement for a
particular phase within a budget ID. May be defined
as dollars, hours, or a user-defined unit.
FBTBLIN_BUDG_PRD_TYPE VARCHAR2 1 NO BUDGET PERIOD TYPE: Indicator of the type of period
for this phase of the budget. Values may be A for
annual, P for period, or Q for quarter.
FBTBLIN_SEQ_DISPLAY_NUM NUMBER 2 NO SEQUENCE TO DISPLAY NUMBER:This sequence number is
used to display in.
FBTBLIN_BUDG_AMT NUMBER 12 2 NO
FBTBLIN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered of last updated.
FBTBLIN_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FBTBLIN_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
which appears on a transaction.
FBTBLIN_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value for the program
classification structure as defined by the National
Council of Higher Education Management Systems.
FBTBLIN_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The user-defined default activity code
used on transactions for this fund, if the activity
code is not supplied by the transaction.
FBTBLIN_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institutions financial manager. For example, Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FBTBLIN_TEXT_IND VARCHAR2 1 YES TEXT INDICATOR: The view text or enter text indicator.
FBTBLIN_TEXT_SEQ_NUM VARCHAR2 15 YES TEXT SEQUENCE NUMBER: This is text sequence number.
FBTBLIN_ADJT_AMT NUMBER 12 2 YES
Date: 21-JUN-2004 Page: 74
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FBTBLIN_ROLL_AMT NUMBER 12 2 YES
Date: 21-JUN-2004 Page: 75
TABLE: FCBEMPL
CREATOR: FIMSMGR
Employee Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCBEMPL_PIDM NUMBER 8 NO CUSTOMER PERSONAL IDENTIFICATION MASTER: The unique
customer personal identification master number.
FCBEMPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FCBEMPL_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FCBEMPL_WAGES NUMBER 12 2 YES WAGES:
FCBEMPL_BENEFIT_AMT NUMBER 12 2 YES BENEFITS:
FCBEMPL_DL_HRS_AVAIL NUMBER 6 2 YES DIRECT HOURS AVAILABLE:
FCBEMPL_INDL_HRS_AVAIL NUMBER 6 2 YES INDIRECT HOURS AVAILABLE:
FCBEMPL_VAC_HRS NUMBER 6 2 YES VACATION HOURS:
FCBEMPL_SICK_HRS NUMBER 6 2 YES SICK HOURS:
FCBEMPL_HOLIDAY_HRS NUMBER 6 2 YES HOLIDAY HOURS:
FCBEMPL_OTHER_HRS NUMBER 6 2 YES OTHER HOURS:
FCBEMPL_DL_HRS_ACTUAL NUMBER 6 2 YES DIRECT HOURS ACTUAL:
FCBEMPL_INDL_HRS_ACTUAL NUMBER 6 2 YES INDIRECT HOURS ACTUAL:
Date: 21-JUN-2004 Page: 76
TABLE: FCBPARM
CREATOR: FIMSMGR
Cost Accounting Batch Parameter Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCBPARM_PROCESS VARCHAR2 4 NO PROCESS CODE:
FCBPARM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FCBPARM_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FCBPARM_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FCBPARM_ORGN_CODE VARCHAR2 6 YES ORGAINIZATION CODE: Identifies the organization code
that appears on a transaction.
FCBPARM_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: A unique code to identify a cost
accounting project.
FCBPARM_START_DATE DATE 7 YES START DATE: The exact day, month, and year in the
format DDMMMYY that defines the beginning of the
fiscal year.
FCBPARM_END_DATE DATE 7 YES END DATE: The exact day, month, and year expressed in
the format DDMMMYYY that defines the end of the fiscal
year.
FCBPARM_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR: A unique two digit numeric identifier
code, for the fiscal year being set up. This code is
usually the last two digits of the second year of the
accounting period.
FCBPARM_RUCL_CODE VARCHAR2 4 YES RULE CLASS CODE: The four character alphanumeric code
identifying an accounting transaction rule class.
FCBPARM_DOC_NUMBER VARCHAR2 8 YES DOCUMENT: The unique number of the document being
updated.
FCBPARM_ATYP_CODE_1 VARCHAR2 2 YES CUSTOMER ADDRESS TYPE CODES: These are the
user-defined values of the address codes set up on
table STVATYP.
FCBPARM_ATYP_CODE_2 VARCHAR2 2 YES CUSTOMER ADDRESS TYPE CODES: These are the
user-defined values of the address codes set up on
table STVATYP.
FCBPARM_ATYP_CODE_3 VARCHAR2 2 YES CUSTOMER ADDRESS TYPE CODES: These are the
user-defined values of the address codes set up on
table STVATYP.
FCBPARM_ATYP_CODE_4 VARCHAR2 2 YES CUSTOMER ADDRESS TYPE CODES: Thes are the user-defined
values of the address codes set up on the table
STVATYP.
FCBPARM_ATYP_CODE_5 VARCHAR2 2 YES CUSTOMER ADDRESS TYPE CODES: These are the
user-defined values of the address codes set up on
table STVATYP.
FCBPARM_UPDT_IND VARCHAR2 1 YES UPDATE DATABASE:
FCBPARM_BILLING_RPT_IND VARCHAR2 1 YES BILLING REPORT:
FCBPARM_BILLING_DTL_RPT_IND VARCHAR2 1 YES BILLING DETAIL REPORT INDICATOR:
FCBPARM_DL_RATE_CALC_IND VARCHAR2 1 YES DIRECT LABOR RATE CALCULATION INDICATOR: This field
indicates that a direct labor rate should be
calculated by the rate calculation process.
Date: 21-JUN-2004 Page: 77
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCBPARM_IL_RATE_CALC_IND VARCHAR2 1 YES INDIRECT LABOR RATE CALCULATION:
FCBPARM_EQ_RATE_CALC_IND VARCHAR2 1 YES EQUIVALENT RATE CALCULATION INDICATOR: This field
indicates that equipment rates are to be included in
the rates calculated by the rate calculation process.
FCBPARM_IH_RATE_CALC_IND VARCHAR2 1 YES INVENTORY HANDLING RATE CALCULATION:
FCBPARM_MM_RATE_CALC_IND VARCHAR2 1 YES MATERIALL MANAGEMENT RATE CALCULATION:
FCBPARM_TRANS_DATE DATE 7 YES TRANSACTION DATE: Date used to post the billing
transactions to the ledgers. This is required for all
billing parameter records.
Date: 21-JUN-2004 Page: 78
TABLE: FCBPHST
CREATOR: FIMSMGR
Project History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCBPHST_PROJ_CODE VARCHAR2 8 NO PROJECT CODE: A unique code to identify a cost
accounting project.
FCBPHST_BILLING_DATE DATE 7 NO BILLING DATE:
FCBPHST_INRT_CODE VARCHAR2 4 NO INTERNAL RATE CODE: A user-defined internal rate code
used in cost accounting projects for entering charges.
FCBPHST_INVT_CODE VARCHAR2 8 YES DOCUMENT: The unique number of the document being
updated.
FCBPHST_EQPT_CODE VARCHAR2 9 YES EQUIPMENT CODE:
FCBPHST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FCBPHST_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FCBPHST_TRANS_DATE DATE 7 NO TRANSACTION DATE: The date the transaction was
processed.
FCBPHST_INRT_RATE NUMBER 6 3 YES INTERNAL RATE:
FCBPHST_UNITS NUMBER 12 2 YES UNITS: The number of units of goods and or services.
Date: 21-JUN-2004 Page: 79
TABLE: FCBPRJC
CREATOR: FIMSMGR
Project/Customer Charges Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCBPRJC_PROJ_CODE VARCHAR2 8 NO PROJECT:
FCBPRJC_CUST_PIDM NUMBER 8 NO CUSTOMER
FCBPRJC_RTYP_SEQNO NUMBER 2 NO SEQUENCE NUMBER:
FCBPRJC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FCBPRJC_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FCBPRJC_UNITS NUMBER 12 2 YES UNITS:
FCBPRJC_TOT_COST NUMBER 12 2 YES TOTAL COSTS:
Date: 21-JUN-2004 Page: 80
TABLE: FCBPRJD
CREATOR: FIMSMGR
Project Detail Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCBPRJD_PROJ_CODE VARCHAR2 8 NO PROJECT:
FCBPRJD_EMPL_PIDM NUMBER 8 YES EMPLOYEE
FCBPRJD_CTYP_CODE VARCHAR2 2 NO CUSTOMER TYPE CODE:
FCBPRJD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FCBPRJD_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FCBPRJD_INVT_CODE VARCHAR2 8 YES INVENTORY CODE:
FCBPRJD_EQPT_CODE VARCHAR2 9 YES EQUIPMENT CODE:
FCBPRJD_TRANS_DATE DATE 7 NO TRANSACTION DATE: The date the transaction was
processed.
FCBPRJD_UNITS NUMBER 12 2 YES UNITS:
FCBPRJD_DOC_NUM VARCHAR2 15 YES DOCUMENT NUMBER: Is the document number of the invoice
or journal voucher.
FCBPRJD_DOC_CODE NUMBER 2 YES DOCUMENT CODE: The code that is associated with a
particular document.
Date: 21-JUN-2004 Page: 81
TABLE: FCBRATE
CREATOR: FIMSMGR
Internal Rates Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCBRATE_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FCBRATE_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FCBRATE_INRT_CODE VARCHAR2 4 NO INTERNAL RATE CODE: The user-defined internal rate
code used in cost accounting projects for entering
charges.
FCBRATE_EFF_DATE DATE 7 NO EFFECTIVE DATE: The effective date of this particular
record.
FCBRATE_NCHG_DATE DATE 7 NO NEXT CHANGE DATE: The date when the next change can
occur for this record.
FCBRATE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FCBRATE_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FCBRATE_RATE NUMBER 6 3 NO RATE:
FCBRATE_INVT_CODE VARCHAR2 8 YES INVENTORY CODE: The code used to identify an item of
inventory used in cost accounting projects.
FCBRATE_EQPT_CODE VARCHAR2 9 YES EQUIPMENT CODE: The equipment tag number being used by
an organization for a cost accounting project.
FCBRATE_TERM_DATE DATE 7 YES TERMINATION DATE: The date when this particular record
is no longer it effect.
Date: 21-JUN-2004 Page: 82
TABLE: FCREMPO
CREATOR: FIMSMGR
Employee/Org/Classification Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCREMPO_PIDM NUMBER 8 NO CUSTOMER PERSONAL IDENTIFICATION MASTER: The unique
customer personal identification master number.
FCREMPO_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FCREMPO_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FCREMPO_CLAS_CODE VARCHAR2 4 NO RULE CLASSIFICATION CODE: The user-defined rule code
that identifies the editing, balancing, and accounting
process for a transaction.
FCREMPO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FCREMPO_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
Date: 21-JUN-2004 Page: 83
TABLE: FCTBDTR
CREATOR: FIMSMGR
Temporary Billing Detail Report Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCTBDTR_REC_TYPE VARCHAR2 1 NO RECORD TYPE INDICATOR: The indicator of the type of
record contained in the table.
FCTBDTR_INST_NAME VARCHAR2 35 YES INSTITUTION NAME:
FCTBDTR_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR: A unique two digit numeric identifier
code for the fiscal year being set up. Generally, the
last two digits of the second year of the accounting
period are used.
FCTBDTR_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: A unique code used to identify a cost
accounting project.
FCTBDTR_PROJ_DESC VARCHAR2 35 YES PROJECT DESCRIPTION: Additional project information,
more descriptive than the fund title.
FCTBDTR_CTYP_CODE VARCHAR2 2 YES
FCTBDTR_CTYP_DESC VARCHAR2 10 YES DESCRIPTION:
FCTBDTR_TRANS_DATE DATE 7 YES TRANSACTION DATE: The date the transaction was
processed.
FCTBDTR_EMPL_ID VARCHAR2 9 YES EMPLOYEE ID:
FCTBDTR_INVT_CODE_1 VARCHAR2 8 YES INVENTORY CODE 1: Inventory code for which units will
be applied after billing is executed.
FCTBDTR_EQPT_CODE_1 VARCHAR2 9 YES EQUIPMENT CODE 1:
FCTBDTR_UNITS NUMBER 12 2 YES UNITS: The number of units of goods and or services.
FCTBDTR_INRT_CODE VARCHAR2 4 YES INTERNAL RATE CODE: The user-defined internal rate
code used in cost accounting projects for entering
charges.
FCTBDTR_INRT_DESC VARCHAR2 10 YES
FCTBDTR_INRT_RATE NUMBER 6 3 YES
FCTBDTR_CUST_CODE VARCHAR2 9 YES CUSTOMER CODE:
FCTBDTR_EXRT_CODE VARCHAR2 3 YES EXTERNAL RATE CODE: The user-defined external rate
code used with a cost accounting project to apply
charges for the project.
FCTBDTR_EXRT_DESC VARCHAR2 10 YES EXTERNAL RATE DESCRIPTION:
FCTBDTR_EXRT_RATE NUMBER 6 3 YES EXTERNAL RATE:
FCTBDTR_CHRG_PCT NUMBER 6 3 YES CHARGET PERCENT:
FCTBDTR_MAX_BILL NUMBER 12 2 YES MAXIMUM BILL:
FCTBDTR_BILLED_AMT NUMBER 12 2 YES BILLED AMOUNT: The amount billed for a project in cost
accounting.
FCTBDTR_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS INDICATOR: The primary
identification code for any chart of accounts which
uniquely identifies that chart from any other in a
multi-chart environment.
FCTBDTR_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the individual
organization code which is associated with the project
transaction.
FCTBDTR_EMPL_PIDM NUMBER 8 YES EMPLOYEE PIDM: Personal identification number
associated with the employee.
Date: 21-JUN-2004 Page: 84
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FCTBDTR_CUST_PIDM NUMBER 8 YES CUSTOMER PIDM: Personal identification number
associated with the customer.
FCTBDTR_BILLED_DATE DATE 7 YES BILLED DATE: Date billing update was executed.
FCTBDTR_DOC_NUM VARCHAR2 15 YES DOCUMENT NUMBER: Is the document number of the invoice
or journal voucher.
FCTBDTR_DOC_CODE NUMBER 2 YES DOCUMENT CODE: The code that is associated with a
particular document.
Date: 21-JUN-2004 Page: 85
TABLE: FEABATC
CREATOR: FIMSMGR
EDI BATCH PROCESSING TABLE
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FEABATC_BEG_TIME NUMBER 4 NO BEGINNING TIME: Beginning time of day for EDI Batch
Processing based on 24 hour clock.
FEABATC_END_TIME NUMBER 4 NO ENDING TIME: Ending time of day for EDI Batch
Processing based on 24 hour clock.
FEABATC_INTERVAL NUMBER 4 NO SLEEP/WAKE INTERVAL: The time interval in minutes that
the EDI extract process should sleep and not process
records.
FEABATC_EDI_SMART_DIR VARCHAR2 50 NO EDI SMART DIRECTORY: The directory name where EDI
Smart is installed.
FEABATC_BANNER_EDI_DIR VARCHAR2 50 NO BANNER EDI DIRECTORY: The directory on the PC where
the Banner EDI programs are installed.
FEABATC_SW_IND VARCHAR2 1 NO SLEEP/WAKE INDICATOR: This indicates whether or not
the Sleep/Wake process is being used. Valid values
are Y or N.
FEABATC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the table row was last
updated.
FEABATC_USER_ID VARCHAR2 30 NO USER ID: The user id of the last user that updated the
table row.
FEABATC_LAST_EXTRACT DATE 7 YES LAST EXTRACT DATE TIME: The date and time that the
last extract file was created for transmission via
EDI.
Date: 21-JUN-2004 Page: 86
TABLE: FEBEDIC
CREATOR: FIMSMGR
EDI Control File: This file contains one record with flags indicating if a Banner Finance module is EDI enabled.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FEBEDIC_PURCHASE_EDI_IND VARCHAR2 1 NO PURCHASING MODULE EDI INDICATOR: Indicates if EDI
capability is enabled in the Purchasing Module.
FEBEDIC_PURCHASE_PRINT_IND VARCHAR2 1 NO PURCHASING MODULE PRINT INDICATOR: Indicates if
documents should be printed when EDI capability is
enabled in the Purchasing Module.
FEBEDIC_ACCTS_PAY_EDI_IND VARCHAR2 1 NO ACCOUNTS PAYABLE MODULE EDI INDICATOR: Indicates if
EDI capability is enabled in the Accounts Payable
Module.
FEBEDIC_ACCTS_PAY_PRINT_IND VARCHAR2 1 NO ACCOUNTS PAYABLE MODULE PRINT INDICATOR: Indicates if
documents should be printed when EDI capability is
enabled in the Accounts Payable Module.
FEBEDIC_BUDGET_EDI_IND VARCHAR2 1 NO BUDGET MODULE EDI INDICATOR: Indicates if EDI
capability is enabled in the Budget Module.
FEBEDIC_BUDGET_PRINT_IND VARCHAR2 1 NO BUDGET MODULE PRINT INDICATOR: Indicates if documents
should be printed when EDI capability is enabled in
the Budget Module.
FEBEDIC_FIXD_ASSET_EDI_IND VARCHAR2 1 NO FIXED ASSETS MODULE EDI INDICATOR: Indicates if EDI
capability is enabled in the Fixed Assets Module.
FEBEDIC_FIXD_ASSET_PRT_IND VARCHAR2 1 NO FIXED ASSETS MODULE PRINT INDICATOR: Indicates if
documents should be printed when EDI capability is
enabled in the Fixed Assets Module.
FEBEDIC_STORES_INV_EDI_IND VARCHAR2 1 NO STORES MODULE EDI INDICATOR: Indicates if EDI
capability is enabled in the Stores Module.
FEBEDIC_STORES_INV_PRINT_IND VARCHAR2 1 NO STORES MODULE PRINT INDICATOR: Indicates if documents
should be printed when EDI capability is enabled in
the Stores Module.
FEBEDIC_COST_ACCTG_EDI_IND VARCHAR2 1 NO COST ACCOUNTING MODULE EDI INDICATOR: Indicates if EDI
capability is enabled in the Cost Accounting Module.
FEBEDIC_COST_ACCTG_PRINT_IND VARCHAR2 1 NO COST ACCOUNTING MODULE PRINT INDICATOR: Indicates if
documents should be printed when EDI capability is
enabled in the Cost Accounting Module.
FEBEDIC_RSCH_ACCTG_EDI_IND VARCHAR2 1 NO RESEARCH ACCOUNTING EDI INDICATOR : Indicates if EDI
capability is enabled in the Research Accounting
Module.
FEBEDIC_RSCH_ACCTG_PRINT_IND VARCHAR2 1 NO RESEARCH ACCOUNTING PRINT INDICATOR : Indicates if
documents should be printed when EDI capability is
enabled in the Research Accounting Module.
FEBEDIC_INVEST_MGMT_EDI_IND VARCHAR2 1 NO INVESTMENT MANAGEMENT MODULE EDI INDICATOR: Indicates
if EDI capability is enabled in the Investment
Management Module.
FEBEDIC_INVEST_MGMT_PRINT_IND VARCHAR2 1 NO INVESTMENT MANAGEMENT MODULE PRINT INDICATOR:
Indicates if documents should be printed when EDI
capability is enabled in the Investment Management
Module.
FEBEDIC_ACCTS_RECV_EDI_IND VARCHAR2 1 NO ACCOUNTS RECEIVABLE MODULE EDI INDICATOR: Indicates if
EDI capability is enabled in the Accounts Receivable
Module.
Date: 21-JUN-2004 Page: 87
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FEBEDIC_ACCTS_RECV_PRINT_IND VARCHAR2 1 NO ACCOUNTS RECEIVABLE MODULE PRINT INDICATOR: Indicates
if documents should be printed if EDI capability is
enabled in the Accounts Receivable Module.
FEBEDIC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The last date the record was updated.
FEBEDIC_USER_ID VARCHAR2 30 NO USER ID: The user id of the last user that updated the
row.
Date: 21-JUN-2004 Page: 88
TABLE: FEREDIC
CREATOR: FIMSMGR
EDI Transaction Control File.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FEREDIC_MODULE_CODE VARCHAR2 1 NO MODULE CODE: A one character code designating the
Banner Finance Module being referred to. Codes
correspond with the naming conventions for position 2.
FEREDIC_TRANS_TYPE VARCHAR2 2 NO EDI TRANSACTION TYPE: A valid two character EDI
Transaction Type as defined in table FEVTTYP.
FEREDIC_TRANS_STATUS VARCHAR2 1 NO EDI TRANSACTION STATUS: Indicates if the EDI
Transaction Type is Active or Inactive for the
designated Banner Finance Module.
FEREDIC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the record was last updated.
FEREDIC_USER_ID VARCHAR2 30 NO USER ID: The user id of the last user that updated the
record.
Date: 21-JUN-2004 Page: 89
TABLE: FERPHST
CREATOR: FIMSMGR
EDI PO History Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FERPHST_POCODE VARCHAR2 8 NO PURCHASE ORDER NUMBER: The Purchase Order Number sent
via EDI.
FERPHST_VEND_PIDM NUMBER 8 NO VENDOR PIDM: The PIDM of the Vendor associated with
the PO.
FERPHST_TRAN_ID VARCHAR2 6 NO EDI TRANSACTION ID: The EDI X12 or EDIFACT
Transaction/Message Type.
FERPHST_SEND_IND VARCHAR2 1 NO SEND INDICATOR: Indicates if the transaction was
designated to be sent immediately (I) or in batch (B).
FERPHST_EXTRACT_IND VARCHAR2 1 NO EDI EXTRACT INDICATOR: Indicates if the transaction
has been sent via EDI.
FERPHST_CTRL_NO NUMBER 9 NO EDI TRANSACTION CONTROL NUMBER: The EDI control number
assigned to the transaction.
FERPHST_PARTNER_ID VARCHAR2 15 NO EDI TRADING PARTNER ID: The EDI Trading Partner ID
associated with the Vendor.
FERPHST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the row was last updated.
FERPHST_USER_ID VARCHAR2 30 NO USER ID: The user id of the last user that updated the
row.
FERPHST_CHANGE_SEQ_NUM NUMBER 3 YES CHANGE SEQUENCE NUMBER: The change sequence number
associated with the Purchase Order Number.
FERPHST_ATYP_CODE VARCHAR2 2 YES ADDRESS TYPE CODE: The address type code associated
with the Vendor PIDM.
FERPHST_ADDR_SEQNO VARCHAR2 2 YES ADDRESS SEQUENCE NUMBER: The address sequence number
associated with the Vendor PIDM and address type code.
FERPHST_EXTRACT_DATE DATE 7 YES EDI EXTRACT DATE/TIME: The date and time the record
was extracted to be send via EDI.
FERPHST_ACK_RECD_DATE DATE 7 YES EDI ACKNOWLEDGEMENT RECEIVED DATE/TIME: The date and
time the EDI acknowledgement was received.
Date: 21-JUN-2004 Page: 90
TABLE: FFBADJH
CREATOR: FIMSMGR
Adjustment to Fixed Assets Header Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBADJH_CODE VARCHAR2 8 NO ADJUSTMENT DOCUMENT CODE: The unique user-defined or
system generated adjustment document code.
FFBADJH_DESC VARCHAR2 35 NO ADJUSTMENT DESCRIPTION: A brief description to
identify the adjustment being made.
FFBADJH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFBADJH_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique indentification code
of the last user to create or modify this record.
FFBADJH_TRANS_DATE DATE 7 NO TRANSACTION DATE: The date the transaction was
processed and posted to the general ledger if this
adjustment required a general ledger posting.
FFBADJH_NSF_ON_OFF_IND VARCHAR2 1 YES NON-SUFFICIENT FUNDS ON OFF INDICATOR: If Y, available
balance checking will be done at entry time for this
adjustment. So far no function has been identified
that would require non-sufficient funds checking.
This is here in case in future function may
FFBADJH_FUNCTION_CODE VARCHAR2 4 YES FUNCTION CODE: The function code of the adjustment
action used in the document.
FFBADJH_APPR_IND VARCHAR2 1 YES APPROVAL INDICATOR: An indicator that indicates if the
document has met final approval. This indicator is
set to Y on final approval.
FFBADJH_COMPLETE_IND VARCHAR2 1 YES COMPLETE INDICATOR: Indicates if the document has been
completed. The indicator is set to Y upon completion.
FFBADJH_DOC_REF_NUM VARCHAR2 15 YES DOCUMENT REFERENCE NUMBER: A uder-defined id further
identifying this adjustment and linking it to an
external reference number.
FFBADJH_DEPR_ADJ_DATE DATE 7 YES DEPRECIATION ADJUSTMENT DATE: Depreciation adjustment
date defaults from the adjustment transaction date for
every function processed. It is not stored with a
time stamp. If the transaction date is equal to the
last depreciation date , the depreciation
Date: 21-JUN-2004 Page: 91
TABLE: FFBDSMC
CREATOR: FIMSMGR
Fixed Asset Depreciation Summary Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBDSMC_SESS_ID VARCHAR2 8 NO SESSION IDENTIFICATION: The unique session
identification code of the user.
FFBDSMC_FUND_CODE VARCHAR2 6 NO FUND CODE: The fund code used for posting
depreciation.
FFBDSMC_ACCT_CODE VARCHAR2 6 NO ACCOUNT CODE: The account code used for posting
depreciation.
FFBDSMC_AMT NUMBER 12 2 YES AMOUNT: Sum of depreciation dollar amount .
Date: 21-JUN-2004 Page: 92
TABLE: FFBDTGH
CREATOR: FIMSMGR
Fixed asset DTAG header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBDTGH_DOC_CODE VARCHAR2 8 NO DOCUMENT CODE: The non-invoice document number such as
Journal Voucher used to post Year to Date transactions
to the operating ledger. Copied from the document
source tables or FGBTRNH when the DTAG is create
d
during the asset extract process.
FFBDTGH_DTYP_NUM NUMBER 2 NO DOCUMENT TYPE CODE: The document type of the source
document.
FFBDTGH_SUBMISSION_NUM NUMBER 2 NO SUBMISSION NUMBER: The number of submissions allowable
for a reusable recurring document.
FFBDTGH_TRANS_DATE DATE 7 NO TRANSACTION DATE: The transaction date on the document
that was used by the posting process.
FFBDTGH_DTAG_EXTRACT_DATE DATE 7 NO FFBDTGH_DTAG_EXTRACT_DATE: DTAG EXTRACT DATE: The date
on which the extract process is run and the original
dtags are created.
FFBDTGH_COMPLETE_IND VARCHAR2 1 NO COMPLETE INDICATOR: A value of (Y) indicates that the
document is complete and all DTAGS have been resolved.
A value of (N) indicates that the document is open and
either some or all DTAGS needs to be res
olved.
FFBDTGH_ACTIVITY_DATE DATE 7 NO
FFBDTGH_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
Date: 21-JUN-2004 Page: 93
TABLE: FFBMAST
CREATOR: FIMSMGR
Fixed Asset Master table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBMAST_OTAG_CODE VARCHAR2 9 NO ASSET ORIGINATION CODE: The unique system generated
identification number of the asset in the fixed asset
system.
FFBMAST_OTAG_DATE DATE 7 NO ORIGINATION TAG DATE: The system defined date on which
tag is created.
FFBMAST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FFBMAST_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FFBMAST_SYSTEM_STATUS_CODE VARCHAR2 1 NO SYSTEM STATUS CODE: The current system status of the
fixed asset master tag updated automatically by one of
the processs. For example, (R)eceived or (I)nvoiced
when the tag is created by receiving or invoicing.
(D)isposed, when the tag is disposed using
FFBMAST_CONTROL_TAG_IND VARCHAR2 1 YES CONTROL TAG INDICATOR: If this field is set to Y it
indicates that this tag is a control tag. A control
tag is the first tag created for this asset. The
extract process updates receiving data only to control
tags created from a prior invoice. When it is
s
FFBMAST_PTAG_CODE VARCHAR2 9 YES PERMANENT TAG CODE: A unique user defined or system
generated one-up number for this asset, usually
visibly seen on the tag of the asset.
FFBMAST_PTAG_DATE DATE 7 YES PERMANENT TAG DATE: The date on which a fixed asset is
tagged as a permanent fixed asset.
FFBMAST_OTAG_CODE_PRIMARY VARCHAR2 9 YES ORIGINATION TAG CODE PRIMARY: The origination tag code
of the owner of this asset.
FFBMAST_SUBORDINATE_TYPE VARCHAR2 1 YES SUBORDINATE TYPE: The relationship type of the
subordinate tag to the primary asset tag. For
example, (C)omponent of or (A)ttached to.
FFBMAST_WORK_IN_PROG_IND VARCHAR2 1 YES WORK IN PROGRESS INDICATOR: For assets such as
building, this field is set to Y, if work is in
progress.
FFBMAST_GIFT_IND VARCHAR2 1 YES GIFT INDICATOR: Indicates whether the asset is a
donated asset or not. It is set to Y if it is a
Donated or Gift item.
FFBMAST_USER_STATUS_CODE VARCHAR2 1 YES ASSET USER STATUS CODE: The user defined status code
which describes the status of the asset. The user
defined codes must be defined as valid codes on
FTVSDAT.For example (L) for on Loan.
FFBMAST_TAG_IN_USE_IND VARCHAR2 1 YES TAG IN USE INDICATOR: The system set indicator
specifying if the tag is being adjusted in an
adjustment document or not. It is set to (Y) by the
adjustment form and reset to (N) after posting
FFBMAST_CAP_DATE DATE 7 YES CAPITALIZATION DATE: The date on which the
capitalization amount is posted to in the general
ledger either after invoice or adjustment occurs.
Date: 21-JUN-2004 Page: 94
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBMAST_ADJ_DATE DATE 7 YES ADJUSTMENT DATE: The date on which last adjustment
information for this asset occured.
FFBMAST_COMM_CODE VARCHAR2 10 YES COMMODITY CODE: The unique number of the commodity
assigned to this asset in FTVCOMM.
FFBMAST_ASSET_DESC VARCHAR2 60 YES ASSET DESCRIPTION: The description of the asset.
FFBMAST_UOMS_CODE VARCHAR2 3 YES UNIT OF MEASURE: A user specified code which
designates the unit of Measure applicable to this
asset.
FFBMAST_ASTY_CODE VARCHAR2 2 YES ASSET TYPE CODE: user defined code which describes an
asset category for depreciation purposes, validated
against FTVASTY table.
FFBMAST_INS_AMT NUMBER 12 2 YES INSURANCE AMOUNT: The user defined amount that is
reported to the insuarnce company in the event of
total loss.
FFBMAST_REPL_AMT NUMBER 12 2 YES REPLACEMENT AMOUNT: The user defined replacement value
in dollars of a fixed asset.
FFBMAST_MARKET_AMT NUMBER 12 2 YES MARKET AMOUNT: The user defined market value in
dollars of a fixed asset.
FFBMAST_BOOK_AMT NUMBER 12 2 YES BOOK AMOUNT: The user defined book value in dollars of
the fixed asset.
FFBMAST_ACQM_CODE VARCHAR2 2 YES ACQUSITION METHOD CODE: User defined code which
describes the method by which an asset was acquired,
validated against FTVACQM table.
FFBMAST_ACQD_DATE DATE 7 YES ACQUSITION DATE: The user defined date on which the
asset is acquired.
FFBMAST_MAKE VARCHAR2 35 YES MAKE: The user defined make of the asset.
FFBMAST_MODEL VARCHAR2 30 YES MODEL: The user defined model number of the asset.
FFBMAST_MANUFACTURER VARCHAR2 35 YES MANUFACTURER: The user defined manufacturer of the
asset.
FFBMAST_BARCODE_NUM VARCHAR2 12 YES BARCODE NUMBER: The user defined barcode number
assigned to this asset.
FFBMAST_SERIAL_NUM_VIN VARCHAR2 40 YES SERIAL NUMBER or VEHICLE IDENTIFICATION NUMBER: The
user defined serial number or the vehicle
identification number associated to this asset.
FFBMAST_PART_NUM_VEHICLE_TAG VARCHAR2 40 YES PART NUMBER or VEHICLE TAG: The user defined part
number or vehicle tag number associated or assigned to
this asset.
FFBMAST_EXT_REF_NUM VARCHAR2 35 YES EXTERNAL REFERENCE NUMBER: User defined number used
for ad-hoc referencing purposes providing additional
identification for the asset.
FFBMAST_ACON_CODE VARCHAR2 3 YES CONDITION CODE: The user code which describes the
asset condition category, validated against FTVACON
table.
FFBMAST_TTST_CODE VARCHAR2 2 YES TITLE TO CODE: User defined code which represents the
title-to designation, validated against FTVTTST table.
FFBMAST_IN_SERV_DATE DATE 7 YES IN SERVICE DATE: User defined date on which this asset
is put in service.
FFBMAST_LAST_INVENTORY_DATE DATE 7 YES LAST INVENTORY DATE: User defined date on which this
asset was last inventoried.
FFBMAST_PCT_USED NUMBER 5 2 YES PERCENTAGE USED: The user defined number quantifying
the percentage of the asset used.
FFBMAST_DISP_CODE VARCHAR2 2 YES DISPOSAL METHOD CODE: The user-defined disposal method
code which may be associated with an asset, validated
against FTVDISP table.
Date: 21-JUN-2004 Page: 95
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBMAST_DISP_DATE DATE 7 YES DISPOSAL DATE: The date on which the asset is
disposed.
FFBMAST_POHD_CODE VARCHAR2 8 YES PURCHASE ORDER NUMBER: The unique purchase order
number associated with this avsset created in
procurements.
FFBMAST_PODT_ITEM NUMBER 4 YES PURCHASE ORDER LINE ITEM: The line item number of the
commodity in the purchase order number associated with
this asset.
FFBMAST_INVH_CODE VARCHAR2 8 YES INVOICE NUMBER: The unique number of the invoice
number associated with this asset created in accounts
payables.
FFBMAST_INVC_ITEM NUMBER 4 YES INVOICE NUMBER LINE ITEM: The line item number of the
commodity in the invoice number associated with this
asset.
FFBMAST_INVH_DATE DATE 7 YES INVOICE DATE: Invoice document date.
FFBMAST_INVH_SUBMISSION_NUM NUMBER 3 YES SUBMISSION NUMBER: The most recent submission number
of the invoice.
FFBMAST_INVH_CR_MEMO_IND VARCHAR2 1 YES CREDIT MEMO INDICATOR: An indicator specifying if this
record is created from regular invoice or credit memo.
(Y) = created from cedit memo. (N) from Invoice.
FFBMAST_INVH_CANCEL_DATE DATE 7 YES INVOICE CANCEL DATE: The date on which the invoice
cancellation occurs.
FFBMAST_RCHD_CODE VARCHAR2 8 YES RECEIVING DOCUMENT NUMBER: The unique number of the
receiving document number number associated with this
asset created in receiving.
FFBMAST_RCHD_DATE DATE 7 YES RECEIVE DATE: The date on which this item is received.
FFBMAST_VEND_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION MASTER: The unique
personal identification of a vendor this asset was
ordered from.
FFBMAST_TRANSFER_DATE DATE 7 YES TRANSFER DATE: The date on which the asset transfer is
done.
FFBMAST_COAS_CODE_RESP VARCHAR2 1 YES CHART OF ACCOUNTS RESPONSIBLE:The chart of accounts
which is responsible for the asset.
FFBMAST_ORGN_CODE_RESP VARCHAR2 6 YES ORGANIZATION CODE RESPONSIBLE: The organization code
that is responsible for the asset.
FFBMAST_LOCN_CODE_RESP VARCHAR2 6 YES LOCATION CODE RESPONSIBLE: The code of the location of
the asset.
FFBMAST_CUSTODIAN_PIDM NUMBER 8 YES CUSTODIAN PERSONAL IDENTIFICATION NUMBER: The personal
identification number of the person who is responsible
for the asset.
FFBMAST_EQUIP_MGR_PIDM NUMBER 8 YES EQUIPMENT MANAGER PERSONAL IDENTIFICATION NUMBER: The
personal identification number of the person who
manages the asset.
FFBMAST_GRNT_CODE VARCHAR2 9 YES GRANT CODE: The code of the grant which paid for the
asset.
FFBMAST_DEPR_CODE VARCHAR2 2 YES DEPRECIATION CODE: The user defined depreciation
method code which may be associated with an asset,
validated against FTVDEPR table.
FFBMAST_DEPR_FREQ VARCHAR2 1 YES DEPRECIATION FREQUENCY: The user defined frequency
(monthly, annualy etc) for the calculation of
depreciation for this asset.
FFBMAST_EST_LIFE_YEARS NUMBER 4 YES ESTIMATED LIFE YEARS: The user defined estimated life
of the asset.
Date: 21-JUN-2004 Page: 96
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBMAST_ADJ_EST_LIFE_QTY NUMBER 4 YES ADJUSTED ESTIMATED LIFE QUANTITY: The system
maintained life of the asset after cost is adjusted.
FFBMAST_REM_LIFE_QTY NUMBER 4 YES REMAINING LIFE QUANTITY: The system maintained
remaining life of the asset yet to be depreciated.
FFBMAST_OLD_REM_LIFE_QTY NUMBER 4 YES OLD REMAINING LIFE QUANTITY: The system maintained old
remaining life of the asset in case of depreciation
rollback.
FFBMAST_DEPR_START_DATE DATE 7 YES DEPRECIATION START DATE: The user defined date on
which the asset starts to depreciate.
FFBMAST_SALVAGE_AMT NUMBER 12 2 YES SALVAGE AMOUNT: The user defined salvage amount in
dollars.
FFBMAST_LAST_DEPR_DATE DATE 7 YES LAST DEPRECIATION DATE: The system updated date on
which the depreciation calculation is last performed.
FFBMAST_OLD_LAST_DEPR_DATE DATE 7 YES OLD LAST DEPRECIATION DATE: The old system updated
date on which the depreciation calculation is last
performed.
FFBMAST_OTAG_CODE_OLD VARCHAR2 9 YES OLD ASSET ORIGINATION CODE: The old unique system
generated identification number of the asset in the
fixed asset system.
FFBMAST_OLD_ADJ_EST_LIFE_QTY NUMBER 4 YES OLD ADJUSTED ESTIMATED LIFE QUANTITY: The system
maintained adjusted life of the asset for posting
rollback purposes after depreciation process.
FFBMAST_OTHER_SRC_DOC_CODE VARCHAR2 8 YES OTHER SOURCE DOCUMENT CODE: The document number of the
original non invoice document that created the otag.
FFBMAST_OTHER_SRC_DTYP_NUM NUMBER 2 YES OTHER SOURCE DOCUMENT TYPE: The document type of the
original non invoice document that created the otag.
FFBMAST_OTHER_SRC_SUB_NUM NUMBER 2 YES OTHER SOURCE DOCUMENT SUBMISSION NUMBER: The
submission number, if applicable, of the document that
created the otag.
FFBMAST_OTHER_SRC_SEQ_NUM NUMBER 4 YES OTHER SOURCE DOCUMENT SEQUENCE NUMBER: The sequence
number of the other source (JV or Cash receipt) that
created the otag.
FFBMAST_OTAG_CANCEL_DATE DATE 7 YES ORIGINATION TAG CANCEL DATE - The transaction date of
the document that is used for cancellation becomes the
otag cancel date. A tag may be cancelled using credit
memo or inactivate action on FFAJTGP
form.
FFBMAST_DTAG_ACTIVITY_DATE DATE 7 YES DTAG ACTIVITY DATE: The date when the dtag information
for this record on the table was entered or last
updated.
Date: 21-JUN-2004 Page: 97
TABLE: FFBOTAG
CREATOR: FIMSMGR
Fixed Asset Origination Tag Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBOTAG_DOC_CODE VARCHAR2 8 NO DOCUMENT CODE: The document number of the
corresponding Invoice or Receiving document.
FFBOTAG_DOC_TYPE NUMBER 2 NO DOCUMENT TYPE: The type of document causing a
Origination tag to be created.
FFBOTAG_DOC_ITEM NUMBER 4 NO DOCUMENT ITEM: The commodity line item number from the
respective document from which this record is created.
FFBOTAG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Activity date of the invoice/receiving
document.
FFBOTAG_DELETE_IND VARCHAR2 1 NO DELETE INDICATOR: Indicator to specify if the document
has been cancelled or deleted.
FFBOTAG_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FFBOTAG_CAP_IND VARCHAR2 1 NO CAPITLIZATION INDICATOR: The indicator specifying if
the document commodity or sequence got capitalized
when posted. It is set to (Y) if capitalized and (N)
if not.
FFBOTAG_SUBMISSION_NUM NUMBER 2 YES SUBMISSION NUMBER: The submission number of the dtag
creating document.
FFBOTAG_DOC_SEQ_NUM NUMBER 4 YES SEQUENCE NUMBER: One-up number of the transactions
within a document that is creating the dtag.
Date: 21-JUN-2004 Page: 98
TABLE: FFBSYSC
CREATOR: FIMSMGR
Fixed Assets System Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBSYSC_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The user-defined chart of
accounts code to be used with the capitalization
transaction entries if the defaults defined here on
this record are used. Chart and effective date is the
primary key to this record.
FFBSYSC_EFF_DATE DATE 7 NO EFFECTIVE DATE: The effective date and key to this
particular record.
FFBSYSC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FFBSYSC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code
for the user.
FFBSYSC_NCHG_DATE DATE 7 NO NEXT CHANGE DATE: The change date for this particular
record. If the record included a termination date,
the next change date would be the date that the
termination date was entered. Requires a future
change record.
FFBSYSC_STATUS_IND VARCHAR2 1 NO STATUS INDICATOR: Indicates the status of the
associated record. Valid values are (A)ctive and
(I)nactive.
FFBSYSC_TERM_DATE DATE 7 YES TERMINATION DATE: The date when this record is no
longer valid.
FFBSYSC_FUND_CODE_CAP VARCHAR2 6 YES CAPITALIZATION FUND CODE: The default user-defined
fund to be used for capitalization of capital outlay
expenditures. This is the top hierarchical search
default. The prior levels are fund type and fund in
that order.
FFBSYSC_ACCT_CODE_GAIN VARCHAR2 6 YES GAIN ACCOUNT CODE: The default user-defined account
code used to define monetary gains when selling an
asset. Account type must be either 40, 50, 60, 70,
90, or 95. This is the top hierarchical search
default. The prior levels are fund type and fund
i
FFBSYSC_ACCT_CODE_LOSS VARCHAR2 6 YES LOSS ACCOUNT CODE: The default user-defined account
code used to define monetary losses when selling an
asset. Account type must be either 40, 50, 60, 70,
90, or 95. This is the top hierarchical search
default. The prior levels are fund type and fund
FFBSYSC_ACCT_CODE_CAP_EQUITY VARCHAR2 6 YES CAPITALIZTION EQUITY ACCOUNT CODE: The default
user-defined fund balance account code used to record
the equity resulting from the capitalization entries.
The account type must be a fund balance account type
of either 40, 90, or 95.This is the top hier
FFBSYSC_DEPR_EXP_EQ_DEF_IND VARCHAR2 1 YES DEPRECIATION EXPENSE/EQUITY DEFAULT INDICATOR: An
indicator specifying the type of account code to be
used for defaulting depreciation expense during the
Fixed asset extraction process. (E) defaults the
equity account, (X) defaults the depreciation expen
FFBSYSC_DEPR_POST_CODE VARCHAR2 1 YES DEPRECIATION POSTING CODE: A code used during the
depreciation process to determine what to do with the
depreciation amount. (P)ost updates the fixed assets
ledger and posts to the accounting ledgers. (M)emo
updates just the fixed assets ledger, and (N
Date: 21-JUN-2004 Page: 99
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFBSYSC_ORGN_CODE_CAP_DEF VARCHAR2 6 YES CAPITALIZATION FUND ORGANIZATION CODE DEFAULT: The
user assigned default organization code to be used on
transactions for the associated capitalization fund.
This code is also set at the fund and fund type level.
FFBSYSC_PROG_CODE_CAP_DEF VARCHAR2 6 YES CAPITALIZATION FUND PROGRAM CODE DEFAULT: The user
assigned default program code to be used on
transactions for the associated capitalization fund.
This code is also set at the fund and fund type level.
FFBSYSC_ACTV_CODE_CAP_DEF VARCHAR2 6 YES CAPITALIZATION FUND ACTIVITY CODE DEFAULT: The user
assigned default activity code to be used on
transactions for the associated capitalization fund.
This codes is also set at the fund and fund type
level.
FFBSYSC_LOCN_CODE_CAP_DEF VARCHAR2 6 YES CAPITALIZATION FUND LOCATION CODE DEFAULT: The user
assigned default location code to be used on
transactions for the associated capitalization fund.
This code is also set at the fund and fund type level.
Date: 21-JUN-2004 Page: 100
TABLE: FFRADJA
CREATOR: FIMSMGR
Fixed Assets Adjustment Accounting Detail Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRADJA_ADJH_CODE VARCHAR2 8 NO ADJUSTMENT DOCUMENT CODE: The unique user-defined or
system generated adjustment document code.
FFRADJA_ITEM NUMBER 4 NO ITEM NUMBER: A system-generated one-up number
associated with an asset that is being adjusted in
this document.
FFRADJA_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: A system-generated one-up number
related to transactions within this document.
FFRADJA_MASA_SEQ_NUM NUMBER 4 NO MASTER ACCOUNTING SEQUENCE NUMBER: A system maintained
number related to transactions with FFRMASA table.
FFRADJA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFRADJA_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique indentification code
of the last user to create or modify this record.
FFRADJA_SUSP_IND VARCHAR2 1 NO SUSPENSE INDICATOR: An indicator used to inform the
user that a document is being held in suspense due to
missing or erroneous data. This indicator is checked
at time of completion to ensure data validity.
FFRADJA_NSF_SUSP_IND VARCHAR2 1 NO NONSUFFICIENT FUNDS SUSPENSE INDICATOR: An indicator
used to inform the user that a transaction has been
suspended due to a lack of budget. A (Y) indicates
that the transactions has been suspended.
FFRADJA_NSF_OVERRIDE_IND VARCHAR2 1 NO INSUFFICIENT FUNDS OVERRIDE INDICATOR: An indicator
which permits authorized users to by-pass funding
deficiencies. A (Y) indicates by-pass funding
deficiencies.
FFRADJA_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR CODE: A user-defined code to identify the
fiscal years and periods within a fiscal year. Used
with chart of accounts. The fiscal year is system
determined based upon the date entered in the
transaction date of the adjustment.
FFRADJA_PERIOD VARCHAR2 2 YES FISCAL YEAR PERIOD: Refers to an accounting period
within a fiscal year which is expressed as a numeric
value. (01, 06, 12, or 13). The period is system
determined based upon the date entered in the
transaction date of the adjustment.
FFRADJA_RUCL_CODE VARCHAR2 4 YES RULE CLASS CODE: The four character alpha/numeric code
identifying an accounting transaction rule to post to
the ledgers. This is system determined based upon a
combination of function code being processed and if
depreciation is utilized within fixed a
FFRADJA_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification of
any chart of accounts which is used to uniquely
identify that chart from any other in a multi-chart
environment. A required field used with the fiscal
year and foapal attributes to use with effective
Date: 21-JUN-2004 Page: 101
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRADJA_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: A user-defined value used as a
quick key method to default one or more of the six
foapal elements into the account distribution line.
It usually defaults from the asset master accounting
record ffrmasa.
FFRADJA_FUND_CODE VARCHAR2 6 YES FUND CODE: A code which uniquely identifies a fiscal
entity. Most of the time this field is system set
depending upon the type of adjustment function being
processed. It defaults from the asset master
accounting record ffrmasa capitalization fund. It
FFRADJA_ORGN_CODE VARCHAR2 6 YES ORGANZIATION CODE: Identifies the individual
organization that appears on the accounting
transaction. This field may be optional and defaults
from the asset master accounting record ffrmasa. It
cannot be changed.
FFRADJA_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account. Most of the time this field is system set
depending upon the type of adjustment function being
processed. It defaults from the asset master
accounting record ffrmasa from either the asset a
FFRADJA_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure as defined by the National
Council of Higher Education Management Systems. This
field may be optional and defaults from the asset
master accounting record ffrmasa. It cannot
b
FFRADJA_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The user-defined value representing the
activity that is primarily associated with this
organization. This is an optional field and defaults
from the asset master accounting record ffrmasa. It
cannot be changed.
FFRADJA_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The user-defined value representing the
physical location of the institutions financial
manager. For example, Vice Predident, Finance, Suite
10 Adams Hall, Main Campus. This is an optional field
and defaults from the asset master accou
FFRADJA_PROJ_CODE VARCHAR2 6 YES PROJECT CODE: A unique code to identify a cost
accounting project. Strictly informational and
optional. This field defaults from the asset master
accounting record ffrmasa and cannot be changed.
FFRADJA_BANK_CODE VARCHAR2 2 YES BANK CODE: A user-defined value that is used for
identification purposes on all cash transactions.
Bank code attributes are displayed in form FTMBANK.
This field defaults from the asset master accounting
record ffrmasa and cannot be changed.
FFRADJA_AMT NUMBER 12 2 YES TRANSACTION AMOUNT: The dollar amount of the
transaction associated with this particular account
distribution. This field is system calculated for all
function types except the Change Everything function.
The field may be changed on the change everyth
FFRADJA_PCT NUMBER 7 4 YES DISTRIBUTION PERCENTAGE: The percentage of the amount
of the transction for this asset adjustment assigned
to this accounting distribution. This field always
defaults from the asset master accounting distribution
table ffrmasa percentage and is system c
Date: 21-JUN-2004 Page: 102
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRADJA_ADJ_AMT NUMBER 12 2 YES TRANSACTION ADJUSTMENT AMOUNT: The actual adjustment
dollar amount used with functions for Write-offs
(WRIT) and Sale of Assets (DISP). This is used when a
gain or loss may be expected on the sale or write-off
of an asset. This field is system calcula
FFRADJA_ACCT_CODE_CAP_EQUITY VARCHAR2 6 YES CAPITALIZATION EQUITY ACCOUNT CODE: This is an account
used to populated one or more of the accounting hits
to the ledgers. It is used and defaults from the
asset master accounting distribution table ffrmasa
capitalization equity account code only for
t
Date: 21-JUN-2004 Page: 103
TABLE: FFRADJD
CREATOR: FIMSMGR
Adjustment to Fixed Assets Detail Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRADJD_ADJH_CODE VARCHAR2 8 NO ADJUSTMENT DOCUMENT CODE: The unique user-defined or
system generated adjustment document code.
FFRADJD_ITEM NUMBER 4 NO ITEM NUMBER: A system-generated one-up number
associated with an asset that is being adjusted in
this document.
FFRADJD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFRADJD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique indentification code
of the last user to create or modify this record.
FFRADJD_OTAG_CODE VARCHAR2 9 NO ORIGINATION TAG: The unique system assigned identifier
code of the asset. When the PTAG is entered in the
online system, its equivalent OTAG is stored in the
database.
FFRADJD_DISP_CODE VARCHAR2 2 YES DISPOSAL CODE: A user defined code that identifies the
method of disposal used in disposal of an asset. An
example might be Involuntary Conversion, Hazard
Disposal waste, or SOld to someone else.
FFRADJD_ACQM_CODE VARCHAR2 2 YES ACQUISITION METHOD CODE: A user defined code that
identifies the method used to acquire the asset. An
example might be Donated, Loaned, or Purchased with
Federal Funds.
FFRADJD_SUSP_IND VARCHAR2 1 YES SUSPENSE INDICATOR: An indicator used to inform the
user that a document is being held in suspense due to
missing or erroneous data content. This indicator is
checked at completion to ensure data validity.
FFRADJD_AMT NUMBER 12 2 YES AMOUNT: An amount entered by the user to determine the
sale price of an asset. It is also used for other
functions within the adjustment form depending on the
type of function being processed and is required based
upon the type of function.
FFRADJD_NET_BOOK_VALUE_AMT NUMBER 12 2 YES NET BOOK VALUE AMOUNT: The net book value of the asset
calculated by the system as asset cost, less
depreciation , plus or minus any asset adjustments.
This amount is used to determine any gain or loss on
the asset when it is sold.
Date: 21-JUN-2004 Page: 104
TABLE: FFRDEMC
CREATOR: FIMSMGR
Fixed Asset Depreciation Error Message Collector table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRDEMC_OTAG_CODE VARCHAR2 9 NO ASSET ORIGINATION CODE: The unique system generated
identification number of the asset in the fixed asset
system.
FFRDEMC_SESS_ID VARCHAR2 8 NO SESSION IDENTIFICATION: The unique session
identification code of the user.
FFRDEMC_ERROR_MSG VARCHAR2 255 YES ERROR MESSAGE: Error message associated with the asset
tag.
Date: 21-JUN-2004 Page: 105
TABLE: FFRDEPR
CREATOR: FIMSMGR
Fixed Asset Depreciation History table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRDEPR_OTAG_CODE VARCHAR2 9 NO ASSET ORIGINATION CODE: The unique system generated
identification number of the asset in the fixed asset
system.
FFRDEPR_CHANGE_SEQ_NUM NUMBER 3 NO CHANGE SEQUENCE NUMBER: System generated one up number
maintaining the history of changes for a specific
asset.
FFRDEPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FFRDEPR_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FFRDEPR_DEPR_ADJ_DATE DATE 7 NO ORIGINATION TAG DATE: The system defined date used to
signal the depreciation process of adjustment to life
of the asset and salvage amount.
FFRDEPR_DEPR_CODE VARCHAR2 2 NO OLD DEPRECIATION METHOD CODE: The old depreciation
method code before adjustment.
FFRDEPR_EST_LIFE_YEARS NUMBER 4 YES ESTIMATED LIFE YEARS: The old estimated life of the
asset in months before adjustment.
FFRDEPR_REM_LIFE_QTY NUMBER 4 YES REMAINING LIFE QUANTITY: The remaining life of the
asset in months before adjustment.
FFRDEPR_SALVAGE_AMT NUMBER 12 2 YES SALVAGE AMOUNT: The salvage amount before adjustment.
FFRDEPR_LAST_DEPR_DATE DATE 7 YES LAST DEPRECIATION DATE: The date of last depreciation
before adjustment.
Date: 21-JUN-2004 Page: 106
TABLE: FFRDTGA
CREATOR: FIMSMGR
Fixed asset DTAG Accounting Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRDTGA_DOC_CODE VARCHAR2 8 NO DOCUMENT CODE: The non-invoice document number such as
Journal Voucher used to post Year to Date transactions
to the operating ledger. Copied from the document
source tables or FGBTRNH when the DTAG is create
d
during the asset extract process.
FFRDTGA_DTYP_NUM NUMBER 2 NO DOCUMENT TYPE CODE: The document type of the source
document.
FFRDTGA_SUBMISSION_NUM NUMBER 2 NO SUBMISSION NUMBER: The number of submissions allowable
for a reusable recurring document.
FFRDTGA_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: System maintained one-up number of
the expense transactions within a document. Copied
from the respective accounting source record tables of
the document when the DTAG is created during the
as
set extract process.
FFRDTGA_ACCT_STATUS_IND VARCHAR2 1 NO ACCOUNTING SEQUENCE INDICATOR: A value of (C)
indicates that the sequence is completed and all DTAGS
have been processed. A value of (O) indicates that
the sequence is open and either some or all DTAGS
needs to be processed.
FFRDTGA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFRDTGA_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
FFRDTGA_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR: A unique two digit numeric identifier
code for the fiscal year as defined in the original
document.
FFRDTGA_RUCL_CODE VARCHAR2 4 YES RULE CLASS CODE: The four character alphanumeric codes
identifying an accounting transaction rule class as
defined in the original document.
FFRDTGA_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: The value representing a
summarization of any combination of user-defined
FOAPAL elements as defined in the original document.
FFRDTGA_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The unique chart of accounts
code that exists in the FTVCOAS table that represents
an institution and copied from the original
transaction.
FFRDTGA_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the fund code that appears on
the transaction and copied from the original
transaction.
FFRDTGA_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on the transaction and copied from the
original transaction.
FFRDTGA_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Identifies the account code that appears
on the transaction and copied from the original
transaction.
FFRDTGA_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Identifies the program classification
structure as defined by the National Council of Higher
Education Management Systems code and copied from the
original transaction.
Date: 21-JUN-2004 Page: 107
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRDTGA_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity that is primarily
associated with this organization and copied from the
original transaction.
FFRDTGA_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institutions financial manager and copied from the
original transaction.
FFRDTGA_TRANS_DESC VARCHAR2 60 YES TRANSACTION DESCRIPTION: The description of the
document and copied from the original transaction or
FGBTRNH. Person entering the transaction may input
messages that can be used by the Fixed asset
manager
while processing dtags on FFADTGP form.
FFRDTGA_TRANS_AMT NUMBER 14 2 YES TRANSACTION AMOUNT: The dollar amount of the
transaction associated with this particular account
distribution and copied from the original transaction.
FFRDTGA_LEDG_TRANS_AMT NUMBER 14 2 YES The amount as it would have been posted to the
operating ledger.
FFRDTGA_DR_CR_IND VARCHAR2 1 NO DEBIT/CREDIT INDICATOR: The debit or credit indicator
(+) or minus (-) indicators copied from the original
transaction.
FFRDTGA_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE NUMBER: The encumbrance number referenced
if the journal voucher or cash receipt affects an
existing encumbrance. Copied from FGBTRNH when the
DTAG is created.
FFRDTGA_DOC_REF_NUM VARCHAR2 8 YES DOCUMENT REFERENCE NUMBER: The user-defined number
providing additional identification for the
encumbrance. Copied from FGBTRNH when the DTAG is
created.
FFRDTGA_DEP_NUM VARCHAR2 8 YES DEPOSIT NUMBER: The deposit number assigned to the
journal voucher or cash receipt transaction. Copied
from FGBTRNH when the DTAG is created.
Date: 21-JUN-2004 Page: 108
TABLE: FFRDTGD
CREATOR: FIMSMGR
Fixed asset DTAG detail Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRDTGD_DOC_CODE VARCHAR2 8 NO DOCUMENT CODE: The non-invoice document number such as
Journal Voucher used to post Year to Date transactions
to the operating ledger. Copied from the document
source tables or FGBTRNH when the DTAG is create
d
during the asset extract process.
FFRDTGD_DTYP_NUM NUMBER 2 NO DOCUMENT TYPE CODE: The document type of the source
document.
FFRDTGD_SUBMISSION_NUM NUMBER 2 NO SUBMISSION NUMBER: The number of submissions allowable
for a reusable recurring document.
FFRDTGD_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: System maintained one-up number of
the transactions within a document. Copied from the
respective accounting source record tables of the
document when the DTAG is created during the asset
extr
act process from the capital expense
transactions.
FFRDTGD_DTAG_SEQ_NUM NUMBER 4 NO TAG SEQUENCE NUMBER: System maintained one-up number
of the DTAGS within a transaction within a document.
FFRDTGD_DTAG_CODE VARCHAR2 9 NO DTAG CODE: System maintained one-up Document Tag
Number of working file entries regarding adjustments
to Fixed Asset accounts. Created during the asset
extract process or FFADTGP maintenance. The working
fil
e is a collection of capital expense transactions
to the operating ledger that were recorded on
non-invoice document form or transactions entered
using the General Interface Table (GURFEED).
FFRDTGD_DTAG_DATE DATE 7 NO DTAG DATE: The system maintained date on which DTAG is
created.
FFRDTGD_DTAG_STATUS_CODE VARCHAR2 1 NO DTAG STATUS: The system maintained status code of the
DTAG. Values are (P)ending, (I)n progress, or
(R)esolved. If the DTAG has been resolved then its
link to the Otag/Ptag/clearing dtag has been
esta
blished.
FFRDTGD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFRDTGD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
FFRDTGD_OTAG_CODE VARCHAR2 9 YES ASSET ORIGINATION CODE: The unique identification
number of the asset in the fixed asset system and
entered by the user while processing this DTAG.
Either otag or Ptag is required for action
update,inactivat
e. Otag is also required for delete
and generated for create.
FFRDTGD_PTAG_CODE VARCHAR2 9 YES PERMANENT TAG CODE: A unique user defined or system
generated one-up number for the asset, usually visibly
seen on the tag of the asset that is associated with
this DTAG. Entered by the user while processing
the
DTAG. Either otag or Ptag is required for action
update, inactivate.
Date: 21-JUN-2004 Page: 109
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRDTGD_CLEARING_DTAG_CODE VARCHAR2 9 YES CLEARING DTAG CODE: An existing DTAG that will not be
fed to the Fixed Asset
system. This is required field
for action clear.
FFRDTGD_DTAG_DESC VARCHAR2 60 YES DOCUMENT TAG DESCRIPTION: The description of the asset
copied from document sequence description. Tag
description from otag or ptag gets defaulted when they
are entered on FFADTGP form.
FFRDTGD_AMT NUMBER 14 2 YES DTAG AMOUNT: The cost of the DTAG.
FFRDTGD_CAP_IND VARCHAR2 1 NO CAPITLIZATION INDICATOR: The system set indicator
specifying if the DTAG is capitalized or not when the
document is posted. It is set to (Y) if capitalized
and (N) if not.
FFRDTGD_ACTION_CODE VARCHAR2 4 YES ACTION CODE: The code of the action taken while
processing the DTAG to feed the information to the
Fixed Asset system. They are Create new otag, update
to existing Otag/Ptag, clear with another DTAG or
del
ete/inactivate existing Otag/Ptag.
FFRDTGD_ACTION_DATE DATE 7 YES ACTION DATE: The date when the DTAG got created,
updated, cleared or deleted.
FFRDTGD_POHD_CODE VARCHAR2 8 YES PURCHASE ORDER NUMBER: The unique purchase order
number created in procurements associated with this
asset. Manually entered or copied from source table
encumbrance number for JV and cash receipt if it is
v
alid or populated when associated tag is entered.
FFRDTGD_PODT_ITEM NUMBER 4 YES PURCHASE ORDER LINE ITEM: The line item number of the
commodity in the purchase order number associated with
this asset.
FFRDTGD_INVH_CODE VARCHAR2 8 YES INVOICE NUMBER: The unique number of the invoice
number created in accounts payables associated with
this asset. Manually entered or populated when
associated tag is entered.
FFRDTGD_INVC_ITEM NUMBER 4 YES INVOICE NUMBER LINE ITEM: The line item number of the
commodity in the invoice number associated with this
asset.
FFRDTGD_OTHER_SRC_DOC_CODE VARCHAR2 8 YES OTHER SOURCE DOCUMENT NUMBER: The document number of
the other source (JV or Cash receipt or stores issue)
that created the otag.
FFRDTGD_OTHER_SRC_DTYP_NUM NUMBER 3 YES OTHER SOURCE DOCUMENT TYPE: The document type of the
other source that created the otag.
FFRDTGD_OTHER_SRC_SUB_NUM NUMBER 2 YES OTHER SOURCE DOCUMENT SUBMISSION NUMBER: The
submission number of the other source (JV or Cash
receipt) that created the otag.
FFRDTGD_OTHER_SRC_SEQ_NUM NUMBER 4 YES OTHER SOURCE DOCUMENT SEQUENCE NUMBER: The sequence
number of the other source (JV or Cash receipt) that
created the otag.
Date: 21-JUN-2004 Page: 110
TABLE: FFREXTC
CREATOR: FIMSMGR
Fixed Asset Origination Tag Extraction Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFREXTC_SESS_ID VARCHAR2 8 NO SESSION IDENTIFICATION: The unique session
identification code of the user.
FFREXTC_OTAG_CODE VARCHAR2 9 NO OTAG CODE: The origination tag used for origination
tag extraction.
FFREXTC_DOC_CODE VARCHAR2 8 NO DOC CODE: The document code used for origination tag
extraction.
FFREXTC_DOC_ITEM NUMBER 4 NO DOC ITEM: The document item used for origination tag
extraction.
FFREXTC_DOC_TYPE NUMBER 2 NO DOC TYPE: The document type used for origination tag
extraction.
FFREXTC_SEQ_NUM NUMBER 4 NO SEQ NUM: The sequence number used for origination tag
extraction.
FFREXTC_SINGLE_ACCT_IND VARCHAR2 1 YES SINGLE ACCT IND: The single accounting indicator for
original tag extraction.
FFREXTC_DIRECT_ASSET_IND VARCHAR2 1 YES DIRECT ASSET IND: The direct asset indicator for
original tag extraction.
FFREXTC_CAP_DIF_IND VARCHAR2 1 YES CAP DIF IND: The indicator for adjustment calculation
FFREXTC_CR_MEMO_IND VARCHAR2 1 YES CR MEMO IND: The credit memo indicator used for
origination tag extraction.
FFREXTC_COMM_CODE VARCHAR2 10 YES COMM CODE: The commodity code used for origination tag
extraction.
FFREXTC_ASSET_DESC VARCHAR2 60 YES ASSET DESC: The description of the asset used for
origination tag extraction.
FFREXTC_POHD_CODE VARCHAR2 8 YES POHD CODE: The purchase order code used for
origination tag extraction.
FFREXTC_AMT NUMBER 12 2 YES AMOUNT: Original Tag amount used for origination tag
extraction.
FFREXTC_TAG_CAP_CODE VARCHAR2 1 YES TAG CAP CODE: The tag capitalization code used for
origination tag extraction.
FFREXTC_MESSAGE VARCHAR2 60 YES MESSAGE: The message for the tag created from used for
origination tag extraction.
FFREXTC_SUBMISSION_NUM NUMBER 2 YES SUBMISSION NUMBER: The submission number of the dtag
creating document.
FFREXTC_DOC_SEQ_NUM NUMBER 4 YES SEQUENCE NUMBER: One-up number of the transactions
within a document that is creating the dtag.
Date: 21-JUN-2004 Page: 111
TABLE: FFRFUSN
CREATOR: FIMSMGR
Fixed Assset User Defined Attributes Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRFUSN_OTAG_CODE VARCHAR2 9 NO ASSET ORIGINATION CODE: The unique system generated
identification number of the asset in the fixed asset
system.
FFRFUSN_SDAT_CODE_ATTR VARCHAR2 30 NO FFRFUSN SEED DATA CODE ATTRIBUTE: User defined titles
for the attributes. user defined titles must be
defined in FTVSDAT.
FFRFUSN_SDAT_CODE_OPT_1 VARCHAR2 8 NO FFRFUSN SEED DATA CODE OPTION_1: User defined
attributes used for ad-hoc reporting purposes. The
user defined attributes must be defined as valid
options in FTVSDAT.
FFRFUSN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FFRFUSN_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
Date: 21-JUN-2004 Page: 112
TABLE: FFRMASA
CREATOR: FIMSMGR
Fixed Assets Capitalization and Depreciation Accounting Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRMASA_OTAG_CODE VARCHAR2 9 NO ORIGINATION TAG: The unique system-generated one-up
identifier code of the asset. Used to be called
temporary tag in the old fixed assets system. If this
came from the assets extract process a code is
generated for each individual item ordered. For Ex
FFRMASA_CHANGE_SEQ_NUM NUMBER 3 NO CHANGE SEQUENCE NUMBER: A system-generated one-up
number used to track historical changes in the assets
accounting changes. Initial creation begins with
change sequence number of 00. The latest change is
represented by the highest change sequence numbe
FFRMASA_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: A system-generated one-up number
copied from the invoice accouting source record
farinva or created at time of asset creation in the
asset master for acquisitions not acquired through
Banner.
FFRMASA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFRMASA_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique indentification code
of the last user to create or modify this record.
FFRMASA_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification of
any chart of accounts which is used to uniquely
identify that chart from any other in a multi-chart
environment. A required field used with the fiscal
year and foapal attributes to use with effective
FFRMASA_BANK_CODE VARCHAR2 2 YES BANK CODE: A user-defined value which is used for cash
transactions. This field defaults from the invoice
bank code if this asset was created during the asset
extract process. Otherwise it defaults from the fund
code table.
FFRMASA_AMT NUMBER 12 2 YES TRANSACTION AMOUNT: The dollar amount of the
transaction associated with this particular account
distribution representing asset cost at time of
acquisition. Copied from the invoice accounting
record farinva and re-calculated based upon the
quantity pa
FFRMASA_ADJ_AMT NUMBER 12 2 YES TRANSACTION ADJUSTMENT AMOUNT: The dollar amount of
the transaction associated with this particular
account distribution representing the amount adjusted
against the cost of this asset. Represents the gain
or loss amount when the asset is sold or writt
FFRMASA_AMT_PCT NUMBER 7 4 YES DISTRIBUTION PERCENTAGE: The percentage of the amount
of the transction for this asset assigned to this
accounting distribution. Copied from the invoice
accounting record farinva if the asset was created
during the asset extract process.
FFRMASA_FUND_CODE_CAP VARCHAR2 6 YES CAPITALIZATION FUND CODE: A code which uniquely
identifies the fiscal entity to record capitalization
of this asset. Defaults from the source expense fund
in table ftvfund and if not found then the Fixed
Assets system control table. It may only be cha
Date: 21-JUN-2004 Page: 113
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRMASA_ACCT_CODE_ASSET VARCHAR2 6 YES ASSET ACCOUNT CODE: The user-defined value
representing the account to record capitalization of
this asset. Defaults from the capitalization (plant)
funds asset account in table ftvfund. It may be
changed on the depreciation form until depreciation
be
FFRMASA_ACCT_CODE_CAP_EQUITY VARCHAR2 6 YES CAPITALIZATION EQUITY ACCOUNT CODE: The user-defined
value representing the account code to record asset
equity. This field defaults from the capitalization
(plant) funds equity account in table ftvfund or if
not found then from the Fixed Assets system
FFRMASA_ACCT_CODE_DEPR_ACCUM VARCHAR2 6 YES ACCUMULATED DEPRECIATION ACCOUNT CODE: The
user-defined value representing the account to record
accumulated depreciation for this asset. This field
defaults from the asset accounts accumulated
depreciation account field in table ftvacct. It may
be ch
FFRMASA_DEPR_ACCUM_AMT NUMBER 12 2 YES ACCUMULATED DEPRECIATION AMOUNT: The total
depreciation dollar amount taken during the life of
the asset as of this date.
FFRMASA_DISP_SALE_AMT NUMBER 12 2 YES DISPOSAL SALE AMOUNT: The sales dollar amount of the
transaction associated with this particular account
distribution when an asset is sold. This field is
updated by posting as a result of initiating a Sale of
Asset Function within the Fixed Assets Adj
FFRMASA_ACCI_CODE_DEPR VARCHAR2 6 YES DEPRECIATION ACCOUNT INDEX CODE: A user-defined value
used as a quick key method to default one or more of
the six foapal elements into the account distribution
line. This field defaults from the source expense
account index on farinva if the asset was
FFRMASA_ORGN_CODE_DEPR VARCHAR2 6 YES DEPRECIATION ORGANZIATION CODE: Identifies the
individual organization that is used to record
depreciation for this asset. This field defaults from
the source expense organization on farinva if the
asset was created during the asset extract process.
I
FFRMASA_ACCT_CODE_DEPR VARCHAR2 6 YES DEPRECIATION ACCOUNT CODE: The user-defined value
representing the account to record depreciation
expense for this asset. This field defaults from the
asset accounts depreciation expense account identified
on table ftvacct if the asset was created duri
FFRMASA_PROG_CODE_DEPR VARCHAR2 6 YES DEPRECIATION PROGRAM CODE: The user-defined value to
the program classification structure as defined by the
National Council of Higher Education Management
Systems. This field defaults from the expense program
on farinva if the asset was created during
FFRMASA_ACTV_CODE_DEPR VARCHAR2 6 YES DEPRECIATION ACTIVITY CODE: The user-defined value
representing the activity that is primarily associated
with this organization. This field defaults from the
expense activity on farinva if the asset was created
during the asset extract process. It m
FFRMASA_LOCN_CODE_DEPR VARCHAR2 6 YES DEPRECIATION LOCATION CODE: The user-defined value
representing the physical location of the institutions
financial manager. For example, Vice Predident,
Finance, Suite 10 Adams Hall, Main Campus. This field
defaults from the expense location on farin
Date: 21-JUN-2004 Page: 114
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRMASA_DEPR_POST_CODE VARCHAR2 1 YES DEPRECIATION POSTING CODE: A code used during the
depreciation process to determine what to do with the
depreciation amount. (P)ost updates the fixed assets
ledger and posts to the accounting ledgers. (M)emo
updates just the fixed assets ledger, and (
FFRMASA_OLD_NET_DEPR_AMT NUMBER 12 2 YES OLD NET DEPRECIATION AMOUNT: The depreciation dollar
amount from the last time depreciation was run. The
depreciation process updates this field with the last
new_net_depr_amt. This is used in the event that
posting may have to roll back the transacti
FFRMASA_NEW_NET_DEPR_AMT NUMBER 12 2 YES NEW NET DEPRECIATION AMOUNT: The current depreciation
dollar amount generated from the depreciation process.
This amount is calculated in the depreciation process
based upon type of depreciation being used and is
updated into the most recent set of ffr
FFRMASA_OTAG_CODE_ATTACHMENT VARCHAR2 9 YES ATTACHMENT ORIGINATION CODE: The unique
system-generated one-up identifier code for the asset
created at time of the fixed assets extract process.
This is used to represent the code of the attachment
when one asset is attached to another asset. The ff
FFRMASA_DIRECT_ASSET_IND VARCHAR2 1 YES DIRECT ASSET INDICATOR: Indicates that the invoice has
an asset account as the input account.
Date: 21-JUN-2004 Page: 115
TABLE: FFRMASF
CREATOR: FIMSMGR
Fixed Assets Accounting Source Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRMASF_OTAG_CODE VARCHAR2 9 NO ORIGINATION TAG: The unique system-generated one-up
identifier code of the asset created at time of the
fixed assets extract process. Used to be called
temporary tag in the old fixed assets system. A code
is generated for each individual item ordered.
FFRMASF_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: A system-generated one-up number
copied from the invoice accouting source record
farinva.
FFRMASF_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFRMASF_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique indentification code
of the last user to create or modify this record.
FFRMASF_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification of
any chart of accounts which is used to uniquely
identify that chart from any other in a multi-chart
environment. A required field used with the fiscal
year and foapal attributes to use with effective
FFRMASF_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: A user-defined value used as a
quick key method to default one or more of the six
foapal elements into the account distribution line.
Copied from the invoice accounting source record
farinva and can be changed in the asset.
FFRMASF_FUND_CODE VARCHAR2 6 YES FUND CODE: A code which uniquely identifies a fiscal
entity that paid for this asset. Copied from the
invoice accounting source record farinva and can be
changed in the asset.
FFRMASF_ORGN_CODE VARCHAR2 6 YES ORGANZIATION CODE: Identifies the individual
organization that appears on the accounting
transaction that paid for this asset. Copied from the
invoice accounting source record farinva and can be
changed in the asset.
FFRMASF_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing the
account that paid for this asset. Copied from the
invoice accounting source record farinva and can be
changed in the asset.
FFRMASF_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure as defined by the National
Council of Higher Education Management Systems.
Copied from the invoice accounting source record
farinva that paid for this asset. This can be chan
FFRMASF_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The user-defined value representing the
activity that is primarily associated with this
organization. Copied from the invoice accounting
source record farinva that paid for this asset. This
can be changed in the asset.
FFRMASF_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The user-defined value representing the
physical location of the institutions financial
manager. For example, Vice Predident, Finance, Suite
10 Adams Hall, Main Campus. Copied from the invoice
accounting source record farinva that paid
f
Date: 21-JUN-2004 Page: 116
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRMASF_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: A unique code to identify a cost
accounting project. Strictly informational and
optional in Fixed Assets. Copied from the invoice
accounting source record farinva that paid for this
asset. This can be changed in the asset.
FFRMASF_AMT NUMBER 12 2 YES TRANSACTION AMOUNT: The dollar amount of the
transaction associated with this particular account
distribution. Represents the cost of the asset.
Copied from the invoice accounting record farinva and
re-calculated based upon the quantity paid per item
i
FFRMASF_AMT_PCT NUMBER 7 4 YES DISTRIBUTION PERCENTAGE: The percentage of the amount
of the transction for this asset assigned to this
accounting distribution. Copied from the invoice
accounting record farinva. This can be changed in the
asset.
FFRMASF_OTAG_CODE_ATTACHMENT VARCHAR2 9 YES ATTACHMENT ORIGINATION CODE: The unique
system-generated one-up identifier code for the asset
created at time of the fixed assets extract process.
This is used to represent the code of the attachment
when one asset is attached to another asset. The ff
FFRMASF_ORIG_DOC_CODE VARCHAR2 8 YES ORIGINAL_DOCUMENT CODE: The document number of the
original document that created the funding source.
Date: 21-JUN-2004 Page: 117
TABLE: FFRTRAN
CREATOR: FIMSMGR
Fixed Asset Transfer table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRTRAN_OTAG_CODE VARCHAR2 9 NO ASSET ORIGINATION CODE: The unique system generated
identification number of the asset in the fixed asset
system.
FFRTRAN_PTAG_CODE VARCHAR2 9 NO PERMANENT TAG CODE: A unique user defined
identification number for this asset, usually visibly
seen on the tag of the asset.
FFRTRAN_SYSTEM_STATUS_CODE VARCHAR2 1 NO SYSTEM STATUS CODE: The current system status of the
fixed asset master tag updated automatically by one of
the processs. For example, (R)eceived or (I)nvoiced
when the tag is created by receiving
or invoicing.
(D)isposed, when the tag is disposed using adjustments
process.
FFRTRAN_USER_STATUS_CODE VARCHAR2 1 YES ASSET USER STATUS CODE: The user defined status code
which describes the status of the asset. The user
defined codes must be defined as valid codes on
FTVSDAT.For example (L) for on Loan.
FFRTRAN_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FFRTRAN_USER_ID VARCHAR2 30 YES USER ID: The unique identification code of the user.
FFRTRAN_SEQ_NUM NUMBER 5 YES SEQUENCE NUMBER: System maintained one up number for
each origination tag.
FFRTRAN_TRF_DOC_NUM VARCHAR2 8 YES TRANSFER DOCUMENT NUMBER: The user defined document
number that is associated with this transfer.
FFRTRAN_TRF_DATE DATE 7 YES TRANSFER DATE: This is the user defined transfer
document date or the system date on which transfer
occurs.
FFRTRAN_TRF_REASON VARCHAR2 150 YES TRANSFER REASON: The reason for the transfer of the
asset.
FFRTRAN_CUSTODIAN_PIDM_FROM NUMBER 8 YES CUSTODIAN PERSONAL IDENTIFICATION NUMBER FROM: The
personal identification number of the person who is
responsible for the asset from whom the asset is being
transferred.
FFRTRAN_COAS_CODE_FROM VARCHAR2 1 YES CHART OF ACCOUNTS RESPONSIBLE FROM : The responsible
chart of accounts from which the asset is being
transferred.
FFRTRAN_ORGN_CODE_FROM VARCHAR2 6 YES ORGANIZATION CODE RESPONSIBLE FROM : The responsible
organization code from which the asset is being
transferred.
FFRTRAN_LOCN_CODE_FROM VARCHAR2 6 YES LOCATION CODE RESPONSIBLE FROM : The responsible
location code from which the asset is being
transferred.
FFRTRAN_GRNT_CODE_FROM VARCHAR2 9 YES GRANT CODE FROM : The responsible grant code from
which the asset is being transferred.
FFRTRAN_CUSTODIAN_PIDM_TO NUMBER 8 YES CUSTODIAN PERSONAL IDENTIFICATION NUMBER TO: The
personal identification number of the person who is
responsible for the asset to whom the asset is being
transferred.
Date: 21-JUN-2004 Page: 118
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFRTRAN_COAS_CODE_TO VARCHAR2 1 YES CHART OF ACCOUNTS RESPONSIBLE TO: The responsible
chart of accounts to which the asset is being
transferred.
FFRTRAN_ORGN_CODE_TO VARCHAR2 6 YES ORGANIZATION CODE RESPONSIBLE TO: The responsible
organization code to which the asset is being
transferred.
FFRTRAN_LOCN_CODE_TO VARCHAR2 6 YES LOCATION CODE RESPONSIBLE TO: The responsible location
code to which the asset is being transferred.
FFRTRAN_GRNT_CODE_TO VARCHAR2 9 YES GRANT CODE TO: The responsible grant code to which the
asset is being transferred.
FFRTRAN_EQUIP_MGR_PIDM NUMBER 8 YES EQUIPMENT MANAGER PERSONAL IDENTIFICATION NUMBER: The
personal identification number of the person who
manages the asset.
FFRTRAN_ACON_CODE VARCHAR2 3 YES CONDITION CODE: The user code which describes the
asset condition category, validated against FTVACON
table.
FFRTRAN_TTST_CODE VARCHAR2 2 YES TITLE TO CODE: User defined code which represents the
title-to designation, validated against FTVTTST table.
FFRTRAN_OTAG_CODE_PRIMARY VARCHAR2 9 YES ORIGINATION TAG CODE PRIMARY: The origination tag code
of the owner of this asset.
FFRTRAN_SUBORDINATE_TYPE VARCHAR2 1 YES SUBORDINATE TYPE: The relationship type of the
subordinate tag to the primary asset tag. For
example, (C)omponent of or (A)ttached to.
FFRTRAN_DISP_CODE VARCHAR2 2 YES DISPOSAL METHOD CODE: The system updated disposal
method code which is used in the adjustment form to
dispose the asset.
FFRTRAN_DISP_DATE DATE 7 YES DISPOSAL DATE: The system updated date on which the
asset is disposed.
Date: 21-JUN-2004 Page: 119
TABLE: FFVACON
CREATOR: FIMSMGR
Fixed Asset Condition Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFVACON_CODE VARCHAR2 3 NO ASSET CONDITION CODE: The user specified code which
defines an asset condition category, i.e., (A1) for
Perfect Condition.
FFVACON_ACTIVITY_DATE DATE 7 NO ACTVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFVACON_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FFVACON_DESC VARCHAR2 35 NO DESCRIPTION: The description appropriate for this
condition code.
Date: 21-JUN-2004 Page: 120
TABLE: FFVACQM
CREATOR: FIMSMGR
Fixed Asset Acquisition Method Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFVACQM_CODE VARCHAR2 2 NO ACQUISITION METHOD CODE: User specified code which
describes the method by which an asset was acquired,
like, (PO) for Purchased.
FFVACQM_ACTIVITY_DATE DATE 7 NO ACTVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFVACQM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FFVACQM_DESC VARCHAR2 35 NO DESCRIPTION: The description appropriate for this
acquisition method.
Date: 21-JUN-2004 Page: 121
TABLE: FFVDISP
CREATOR: FIMSMGR
Fixed Asset Disposal Method Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFVDISP_CODE VARCHAR2 2 NO ASSET DISPOSAL METHOD CODE: User specified code
designating the disposal method, like, (SC) for Sold
for Scrap.
FFVDISP_ACTIVITY_DATE DATE 7 NO ACTVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFVDISP_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FFVDISP_DESC VARCHAR2 35 NO DESCRIPTION: The description appropriate for this
disposal method code.
Date: 21-JUN-2004 Page: 122
TABLE: FFVSDAT
CREATOR: FIMSMGR
Fixed Asset User Defined Attributes Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFVSDAT_SDAT_CODE_ATTR VARCHAR2 30 NO ATTRIBUTE: User defined attribute.
FFVSDAT_SDAT_CODE_OPT_1 VARCHAR2 8 NO VALUE: Value of user defined attribute.
FFVSDAT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
FFVSDAT_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
FFVSDAT_TITLE VARCHAR2 35 NO TITLE: The title of the attribute.
FFVSDAT_SHORT_TITLE VARCHAR2 20 YES SHORT TITLE: The short title of the attribute.
FFVSDAT_DATA VARCHAR2 15 YES DATA: Additional user defined data values for the
attribute.
Date: 21-JUN-2004 Page: 123
TABLE: FFVTTST
CREATOR: FIMSMGR
Fixed Asset Title-To Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FFVTTST_CODE VARCHAR2 2 NO ASSET TITLE-TO CODE: User specified code which
represents the title-to designation, like, (FG) for
Federal Government.
FFVTTST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
FFVTTST_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
FFVTTST_DESC VARCHAR2 35 NO DESCRIPTION: The description appropriate for this
title-to designation code.
Date: 21-JUN-2004 Page: 124
TABLE: FGADOCB
CREATOR: FIMSMGR
Document Balancing Temp Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGADOCB_DOC_NUM VARCHAR2 8 NO DOCUMENT NUMBER: The unique number of the document
being updated.
FGADOCB_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts which is used to
uniquely identify that chart from any other in a
multi-chart environment.
FGADOCB_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the fund code that appears on a
transaction.
FGADOCB_BALANCE_METHOD VARCHAR2 1 YES BALANCE METHOD: Balancing method determined for the
input transaction.
FGADOCB_DR_AMT NUMBER 12 2 YES
FGADOCB_CR_AMT NUMBER 12 2 YES CREDIT AMOUNT:
Date: 21-JUN-2004 Page: 125
TABLE: FGBARCD
CREATOR: FIMSMGR
Archived Documents Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBARCD_DOC_CODE VARCHAR2 8 NO DOCUMENT: The user-defined or system generated
document number.
FGBARCD_DOC_SEQ_CODE NUMBER 2 NO DOCUMENT SEQUENCE NUMBER:
FGBARCD_SUBMISSION_NUMBER NUMBER 3 NO SUBMISSION NUMBER: The number of allowable submissions
for a reusable/ recurring document.
FGBARCD_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts that is used to
uniquely identify that chart from any other in a
multi-chart environment.
FGBARCD_FSYR_CODE VARCHAR2 2 NO FISCAL YEAR: A unique two digit numeric identifier
code for the fiscal year being defined. Generally,
the last two digits of the second year of the
accounting period are used.
FGBARCD_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FGBARCD_USER_ID VARCHAR2 30 YES USER ID: The unique identification code of the user.
Date: 21-JUN-2004 Page: 126
TABLE: FGBAUTO
CREATOR: FIMSMGR
Automatic Journal Voucher Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBAUTO_AUTO_JRNL_ID VARCHAR2 3 NO AUTOMATIC JOURNAL ID: A user-defined value providing
unique identification for a recurring journal voucher.
FGBAUTO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FGBAUTO_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FGBAUTO_AUTO_JRNL_TITLE VARCHAR2 35 NO AUTOMATIC JOURNAL VOUCHER: The title or brief
description of the purpose for a recurring journal
voucher.
FGBAUTO_SUB_CYCLE VARCHAR2 1 NO SUBMISSION CYCLE: The periodic basis on which the
automatic journal will be submitted. For example, on
demand, monthly, quartly, annually.
FGBAUTO_SUB_DAY_PERIOD VARCHAR2 2 YES SUBMISSION DAY PERIOD: The day of the month that the
automatic journal is submitted. Choices are 01
through 31 and L.
FGBAUTO_SUBMISSION_PERIOD VARCHAR2 2 YES SUBMISSION PERIOD: The definition of the period
according to the submission cycle.
FGBAUTO_SUB_TOTAL NUMBER 4 NO SUBMISSION TOTAL: The total number of periodic
submissions of the automatic journal.
FGBAUTO_SUB_TO_DATE NUMBER 4 NO SUBMISSION TO DATE: The date to which the reusable
invoice may be submitted. This is a display only
field and is system-generated.
FGBAUTO_NEXT_SUBMISSION_DATE DATE 7 YES NEXT SUBMISSION DATE:The date in DDMMMYY format when
the first or next occurrence of the submission of the
autojournal must coincide with the submission schedule
day.
FGBAUTO_REVERSAL_IND VARCHAR2 1 NO REVERSAL INDICATOR: The indicator which directs the
system whether to automatically reverse an automatic
journal voucher.
FGBAUTO_REVERSAL_PERIOD_TYPE VARCHAR2 1 YES REVERSAL PERIOD TYPE: Code indicating whether the
reversal of an automatic journal should take place in
the next accounting period or next cycle.
FGBAUTO_REVERSAL_DAY VARCHAR2 2 YES REVERSAL DAY: The day of the specified period on which
an automatic reversal of an automatic journal voucher
will take place.
FGBAUTO_REVERSAL_PERIOD VARCHAR2 2 YES REVERSAL PERIOD: The period (month, quarter, etc.) in
which the automatic reversal of an automatic journal
voucher will take place.
FGBAUTO_LAST_SUBMIT_DATE DATE 7 YES LAST SUBMITTED DATE:
FGBAUTO_LAST_REVERSAL_DATE DATE 7 YES LAST REVERSAL DATE:
FGBAUTO_REVERSAL_TOTAL NUMBER 4 NO REVERSAL TOTAL: This is a user defined field and is
required if reversal
indicator is set to Y. If left
null and reversal indicator is Y, will
default to 1.
FGBAUTO_REVERSAL_TO_DATE NUMBER 4 NO REVERSAL TO DATE: This field is calculated by the
fgbtrni process.
Date: 21-JUN-2004 Page: 127
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBAUTO_NEXT_REVERSAL_DATE DATE 7 YES NEXT REVERSAL DATE: This field is required and will be
updated by the system
if _reversal_ind = Y for all
submission cycles.
FGBAUTO_STATUS_IND VARCHAR2 1 YES STATUS: This field is not required. Values are H or
null.
if status_ind = H, fgrtrni will not process the
auto journal voucher.
Date: 21-JUN-2004 Page: 128
TABLE: FGBBAVC
CREATOR: FIMSMGR
Budget Availability Ledger Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBBAVC_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accoun ts that is used to
uniquely identify that chart from any other in a
multi-chart environment.
FGBBAVC_FSYR_CODE VARCHAR2 2 NO FISCAL YEAR: A unique two digit numeric identifier
code, for the fiscal year being setup. Generally the
last two digits of the second year of the accounting
period are used.
FGBBAVC_FUND_CODE VARCHAR2 6 NO FUND CODE: Identifies the fund code that appears on a
transaction.
FGBBAVC_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FGBBAVC_ACCT_CODE VARCHAR2 6 NO ACCOUNT CODE: The user-defined value representing an
account.
FGBBAVC_PROG_CODE VARCHAR2 6 NO PROGRAM CODE:The user-defined value to the program
classification structure cod e or a subset or that
structure as defined by the National Council of Higher
Ed ucation Management Systems.
FGBBAVC_PERIOD VARCHAR2 2 NO PERIOD: Refers to a period within a fiscal year.
FGBBAVC_CMT_TYPE VARCHAR2 1 NO COMMIT TYPE : U = Uncommitted, C = Committed
FGBBAVC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was enter ed or last updated.
FGBBAVC_SUM_UNBUDGET_APPROP NUMBER 12 2 YES SUMMARY UNBUDGET APPROPRIATION :
FGBBAVC_SUM_ADOPT_BUD NUMBER 12 2 YES SUMMARY ADOPTED BUDGET AMOUNT: Sum of the adopted
budget for a given query.
FGBBAVC_SUM_BUD_ADJT NUMBER 12 2 YES SUMMARY ADJUSTED BUDGET AMOUNT:
FGBBAVC_SUM_YTD_ACTV NUMBER 12 2 YES SUMMARY YEAR TO DATE ACTIVITY AMOUNT: The sum of all
year-to-date activity for a parti cular account,
organization, etc.
FGBBAVC_SUM_ENCUMB NUMBER 12 2 YES SUMMARY ENCUMBRANCE AMOUNT:
FGBBAVC_SUM_BUD_RSRV NUMBER 12 2 YES SUMMARY BUDGET RESERVATION AMOUNT: Sum of the budget
reservations and encumbran ces for a given query.
Date: 21-JUN-2004 Page: 129
TABLE: FGBBAVL
CREATOR: FIMSMGR
Budget Availability Ledger Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBBAVL_COAS_CODE VARCHAR2 1 NO
FGBBAVL_FSYR_CODE VARCHAR2 2 NO
FGBBAVL_FUND_CODE VARCHAR2 6 NO
FGBBAVL_ORGN_CODE VARCHAR2 6 NO
FGBBAVL_ACCT_CODE VARCHAR2 6 NO
FGBBAVL_PROG_CODE VARCHAR2 6 NO
FGBBAVL_PERIOD VARCHAR2 2 NO
FGBBAVL_CMT_TYPE VARCHAR2 1 NO COMMITMENT TYPE: U = Uncommitted, C = Committed
FGBBAVL_ACTIVITY_DATE DATE 7 NO
FGBBAVL_SUM_UNBUDGET_APPROP NUMBER 12 2 YES
FGBBAVL_SUM_ADOPT_BUD NUMBER 12 2 YES
FGBBAVL_SUM_BUD_ADJT NUMBER 12 2 YES
FGBBAVL_SUM_YTD_ACTV NUMBER 12 2 YES
FGBBAVL_SUM_ENCUMB NUMBER 12 2 YES
FGBBAVL_SUM_BUD_RSRV NUMBER 12 2 YES
Date: 21-JUN-2004 Page: 130
TABLE: FGBCSHD
CREATOR: FIMSMGR
Direct Cash Receipt Detail Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBCSHD_DOC_NUM VARCHAR2 8 NO DOCUMENT NUMBER: The unique number identifying the
Direct Cash Receipt.
FGBCSHD_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: A number identifying the individual
detail transactions within this document.
FGBCSHD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
Direct Cash Receipt detail record was entered or last
updated.
FGBCSHD_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user
who entered or last updated this record.
FGBCSHD_RUCL_CODE VARCHAR2 4 NO RULE CLASS CODE: The four-character alphanumeric code
identifying an accounting transaction rule class used
for posting this transaction.
FGBCSHD_TGRP_CODE VARCHAR2 4 YES TAX GROUP CODE: The unique identifier of the tax group
associated with this Direct Cash Receipt detail
record.
FGBCSHD_TRANS_AMT NUMBER 12 2 YES TRANSACTION AMOUNT: The dollar amount of the
transaction associated with this particular account
distribution.
FGBCSHD_TRANS_DESC VARCHAR2 35 YES TRANSACTION DESCRIPTION: A brief description of the
purpose of the Direct Cash Receipt detail record.
FGBCSHD_DR_CR_IND VARCHAR2 1 YES DEBIT/CREDIT INDICATOR: Indicates if the transaction
amount of this Direct Cash Receipt detail record is a
debit or a credit.
FGBCSHD_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR: A unique two-digit numeric identifier
code for the fiscal year during which this transaction
occurred.
FGBCSHD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: The user-defined value
representing a summarization of any combination of
FOAPAL elements.
FGBCSHD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The unique identification code
for the chart of accounts of this detail transaction.
FGBCSHD_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the fund associated with this
detail transaction.
FGBCSHD_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization
associated with this detail transaction.
FGBCSHD_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Identifies the account associated with
this detail transaction.
FGBCSHD_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Identifies the program associated with
this detail transaction.
FGBCSHD_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Identifies the activity associated with
this detail transaction.
FGBCSHD_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Identifies the location associated with
this detail transaction.
FGBCSHD_BANK_CODE VARCHAR2 2 YES BANK CODE: Identifies the bank associated with this
detail transaction.
FGBCSHD_DOC_REF_NUM VARCHAR2 8 YES DOCUMENT REFERENCE NUMBER: The user-defined number
providing additional identification for this detail
transaction.
Date: 21-JUN-2004 Page: 131
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBCSHD_VENDOR_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION MASTER: The unique
personal identification master of the vendor who
transmitted the cash in this detail transaction.
FGBCSHD_DEP_NUM VARCHAR2 8 YES DEPOSIT NUMBER: Deposit number associated with this
detail transaction.
FGBCSHD_DIST_PCT NUMBER 6 3 YES DISTRIBUTION PERCENTAGE: The percentage of total cash
receipt to be assigned to this accounting
distribution. If a percentage is entered, the system
calculates the amount; otherwise, an amount must be
entered.
FGBCSHD_POSTING_PERIOD VARCHAR2 2 YES POSTING PERIOD: Fiscal Year period of this detail
transaction.
FGBCSHD_STATUS_IND VARCHAR2 1 YES STATUS INDICATOR: Indicates if this Direct Cash
Receipt detail transaction is Postable, has a
Non-Sufficient Funds condition, or another Error
condition.
FGBCSHD_ABAL_OVERRIDE VARCHAR2 1 YES AVAILABLE BUDGET OVERRIDE: This indicator is used to
override the availability-of-funds checking process,
if the user has the authority.
FGBCSHD_POST_BAVL VARCHAR2 1 YES POST BUDGET AVAILABILITY: This indicator is used to
post budget and update budget availability.
FGBCSHD_APPR_IND VARCHAR2 1 YES APPROVAL INDICATOR: Indicates if the document has been
approved for processing by the individual authorized
(via the hierarchy table) to approve the document.
FGBCSHD_CURR_CODE VARCHAR2 4 YES CURRENCY CODE: The currency code associated with this
detail record.
FGBCSHD_CONVERTED_AMT NUMBER 12 2 YES CONVERTED AMOUNT: The base amount calculated for this
detail record. Used when a currency code is
established for this detail record.
Date: 21-JUN-2004 Page: 132
TABLE: FGBCSHH
CREATOR: FIMSMGR
Direct Cash Receipt Header Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBCSHH_DOC_NUM VARCHAR2 8 NO DOCUMENT NUMBER: The unique number identifying the
Direct Cash Receipt.
FGBCSHH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
Direct Cash Receipt record was entered or last
updated.
FGBCSHH_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user
who entered or last updated this record.
FGBCSHH_TRANS_DATE DATE 7 NO TRANSACTION DATE: The date this transaction was
processed.
FGBCSHH_DOC_DESCRIPTION VARCHAR2 35 YES DOCUMENT DESCRIPTION: The unique user-defined
descriptive title of this Direct Cash Receipt.
FGBCSHH_DOC_AMT NUMBER 12 2 YES DOCUMENT AMOUNT: The total value of the Direct Cash
Receipt being recorded.
FGBCSHH_STATUS_IND VARCHAR2 1 YES STATUS INDICATOR: Indicates if the document is
complete or incomplete.
FGBCSHH_APPROVAL_IND VARCHAR2 1 YES APPROVAL INDICATOR: Indicates if the document has been
approved for processing by the individual authorized
(via the user hierarchy table) to approve the
document.
FGBCSHH_NSF_ON_OFF_IND VARCHAR2 1 YES NSF ON OFF INDICATOR: If Y, available balance checking
will be done at entry time for this particular Direct
Cash Receipt.
FGBCSHH_VEND_PIDM NUMBER 8 YES VENDOR PIDM: The unique system id of the vendor who
sent the cash being recorded by this document.
FGBCSHH_ONE_TIME_VEND_NAME VARCHAR2 60 YES ONE-TIME VENDOR NAME: Name of vendor who sent the cash
being recorded by this document, if it is a one-time
vendor.
FGBCSHH_COLLECT_TAX VARCHAR2 1 YES TAX COLLECTION: Indicates if the vendor collects all,
some, or no taxes.
Date: 21-JUN-2004 Page: 133
TABLE: FGBENCD
CREATOR: FIMSMGR
Encumbrance Distribution Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBENCD_NUM VARCHAR2 8 NO NUMBER: The unique number of a document.
FGBENCD_ITEM NUMBER 4 NO COMMODITY ITEM NUMBER: The literal commodity or goods
description associated with an invoice processing
record.
FGBENCD_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: A system generated sequence number
relating to transactions within a document.
FGBENCD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The code that information for this
record in the table was entered or last updated.
FGBENCD_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FGBENCD_RUCL_CODE VARCHAR2 4 NO RULE CLASS CODE: The four character alphanumeric code
identifying an accounting transaction rule class.
FGBENCD_FSYR_CODE VARCHAR2 2 YES FISCAL YEAR: A unique two digit numeric identifier
code, for the fiscal year being set up. Generally,
the last two digits of the second year of the
accounting period are used.
FGBENCD_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts that uniquely
identifies that chart from any other in a multi-chart
environment.
FGBENCD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: The user-defined value
representing a summerization of any combination of
user-defined FOAPAL elements.
FGBENCD_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the fund code that appears on a
transaction.
FGBENCD_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the organization code
that appears on a transaction.
FGBENCD_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The user-defined value representing an
account.
FGBENCD_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: The user-defined value to the program
classification structure code or a subset or that
structure as defined by the National Council of Higher
Education Management Systems.
FGBENCD_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: The activity that is primarily
associated with this organization.
FGBENCD_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: The physical location of the
institution's financial manager. For example, Vice
President, Finance, Suite 10 Adams Hall, Main Campus.
FGBENCD_POSTING_PERIOD VARCHAR2 2 YES POSTING PERIOD:
FGBENCD_STATUS_IND VARCHAR2 1 YES STATUS INDICATOR: The current status of the associated
validation table records for various documents.
FGBENCD_PRJD_CODE VARCHAR2 8 YES PROJECT CODE: If the encumbrance is related to a
project (work order) from cost accounting, enter the
project code.
Date: 21-JUN-2004 Page: 134
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBENCD_PEND_AMT NUMBER 12 2 YES ENCUMBRANCE PENDING AMOUNT: The dollar amount of the
encumbrance being charged to this accounting
distribution.
FGBENCD_DIST_PCT NUMBER 6 3 YES DISTRIBUTION PERCENTAGE: The percentage of the total
encumbrance to be assigned to this accounting
distribution. If a percentage is entered, the system
calculates the amount, otherwise, an amount must be
entered.
FGBENCD_OPAL_FIELD_CODE VARCHAR2 2 YES
FGBENCD_STATUS VARCHAR2 1 YES STATUS:
FGBENCD_ABAL_OVERRIDE VARCHAR2 1 YES AVAILABLE BUDGET OVERRIDE: This indicator is used to
override the availability of funds checking process,
if the user has the authority.
FGBENCD_POST_BAVL VARCHAR2 1 YES Rule based transaction posting point at which budgeted
funds are reserved.
FGBENCD_APPR_IND VARCHAR2 1 YES APPROVAL INDICATOR: Indicates if the document has been
approved for processing by the individual authorized
(via the user hierarchy table) to approve the
document.
FGBENCD_CMT_TYPE VARCHAR2 1 NO COMMITMENT TYPES: U = Uncommitted, C = Committed
FGBENCD_CMT_PCT NUMBER 6 3 YES
Date: 21-JUN-2004 Page: 135
TABLE: FGBENCH
CREATOR: FIMSMGR
Encumbrance Ledger Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBENCH_NUM VARCHAR2 8 NO DOCUMENT NUMBER: The unique number of the document
being updated.
FGBENCH_DOC_CHANGE_NUM VARCHAR2 8 YES DOCUMENT CHANGE NUMBER: The user-defined number
identifies and provides and audit trail of any changes
made to the original document. This number is
actually used as the document code to post the
encumbrance change to the ledgers.
FGBENCH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FGBENCH_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
FGBENCH_DESC VARCHAR2 35 YES DESCRIPTION: The description or title of the
encumbrance.
FGBENCH_CHANGE_DESC VARCHAR2 35 YES CHANGE DESCRIPTION: The title or a brief description
of any change made to an existing encumbrance.
FGBENCH_TRANS_DATE DATE 7 NO TRANSACTION DATE: The date the transaction was
processed.
FGBENCH_DOC_REF_NUM VARCHAR2 8 YES DOCUMENT REFERENCE NUMBER: The user-defined number
providing additional identification for the
encumbrance.
FGBENCH_DOC_AMT NUMBER 12 2 YES DOCUMENT AMOUNT: The total value of the encumbrance
being recorded.
FGBENCH_TYPE VARCHAR2 1 NO ENCUMBRANCE TYPE: Indicates the type of encumbrance or
the source of the encumbrance. Values are
(E)ncumbrance, (M)emo, (L)abor , (R)equisition, and
(P)urchase Order.
FGBENCH_STATUS_IND VARCHAR2 1 NO ENCUMBRANCE STATUS INDICATOR: Indicates the status of
the encumbrance for various documents. Values are
(C)losed and (O)pen.
FGBENCH_STATUS VARCHAR2 1 YES ENCUMBRANCE COMPLETION STATUS: Indicates the status of
the encumbrance document. A (C)omplete indicates that
the document has been completed. A null value
indicates the document is awaiting completion.
FGBENCH_COMT_TYPE VARCHAR2 1 YES ENCUMBRANCE COMMITTMENT TYPE: The encumbrance roll
indicator.
FGBENCH_COMT_PCT NUMBER 6 3 YES ENCUMBRANCE COMMITTED PERCENTAGE: If the encumbrance
is committed, this is the percentage of value to
commit. The default is 100%.
FGBENCH_BUD_DISPN VARCHAR2 1 YES BUDGET DISPOSITION: The indicator that determines the
year-end processing or budget requested encumbrance
amounts.
FGBENCH_PROCESSING_IND VARCHAR2 1 YES PROCESSING INDICATOR: Not being used at this time.
FGBENCH_EDIT_DEFERRAL VARCHAR2 1 YES EDIT DEFERRAL: The indicator that defers editing until
the transaction is posted, the default is N, do not
defer editing.
Date: 21-JUN-2004 Page: 136
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBENCH_TEXT_IND VARCHAR2 1 YES TEXT INDICATOR: The view text or enter text indicator.
FGBENCH_ESTAB_DATE DATE 7 NO ENCUMBRANCE ESTABLISHMENT DATE: the date the
encumbrance was originally established.
FGBENCH_VENDOR_PIDM NUMBER 8 YES VENDOR PERSONAL IDENTIFICATION MASTER: The unique
personal identification master of a vendor.
FGBENCH_SOURCE_IND VARCHAR2 1 YES ENCUMBRANCE SOURCE INDICATOR: Indicates the actual
document type source for the encumbrance. Values are
(R)equisition, (P)urchase Order, and null for
encumbrance documents. If the indicator is null, then
the encumbrance is allowed to be viewed and edit
FGBENCH_APPR_IND VARCHAR2 1 YES APPROVAL INDICATOR: Indicates if the document has been
approved for processing by the individual authorized
(via the user hierarchy table) to approve the
document.
FGBENCH_NSF_ON_OFF_IND VARCHAR2 1 YES NSF ON OFF INDICATOR: If Y, available balance checking
will be done at entry time for this particular
encumbrance.
Date: 21-JUN-2004 Page: 137
TABLE: FGBENCP
CREATOR: FIMSMGR
Encumbrance Period Detail Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBENCP_NUM VARCHAR2 8 NO DOCUMENT NUMBER: The unique number of the document.
FGBENCP_ITEM NUMBER 4 NO COMMODITY ITEM NUMBER: The literal commodity or goods
description associated with an invoice processing
record.
FGBENCP_SEQ_NUM NUMBER 4 NO SEQUENCE NUMBER: This number represents a predefined
value within BANNER Finance that is used for operating
ledger classification and reporting purposes.
FGBENCP_FSYR_CODE VARCHAR2 2 NO FISCAL YEAR: A unique two digit numeric identifier
code for the fiscal year being set up. Generally the
last two digits of the second year of the accounting
period are used.
FGBENCP_PERIOD VARCHAR2 2 NO PERIOD: Refers to a period within a fiscal year.
FGBENCP_ORIG_ENCB_AMT NUMBER 12 2 YES ORIGINAL ENCUMBRANCE AMOUNT:
FGBENCP_SUM_ENCB_ADJT NUMBER 12 2 YES SUMMARY ENCUMBRANCE ADJUSTMENTS: The sum of
encumbrance adjustments for a given period.
FGBENCP_SUM_ENCB_LIQ NUMBER 12 2 YES SUMMARY ENCUMBRANCE LIQUIDATIONS: The sum of
encumbrance liquidation for a given query.
Date: 21-JUN-2004 Page: 138
TABLE: FGBGENL
CREATOR: FIMSMGR
General Ledger Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBGENL_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts that is used to
uniquely identify that chart from any other in a
multi-chart environment.
FGBGENL_FSYR_CODE VARCHAR2 2 NO FISCAL YEAR: A unique two digit numeric identifier
code for the fiscal year being set-up. Generally the
last two digits of the second year in the accounting
period are used.
FGBGENL_FUND_CODE VARCHAR2 6 NO FUND CODE: Identifies the fund code that appears on a
transaction.
FGBGENL_ACCT_CODE VARCHAR2 6 NO ACCOUNT CODE: The user-defined value representing an
account.
FGBGENL_PERIOD VARCHAR2 2 NO PERIOD: Refers to a period within a fiscal year.
FGBGENL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
FGBGENL_SUM_PERIODIC_DR NUMBER 12 2 YES SUMMARY PERIODIC DEBITS: The sum of all debit
transactions for a given period of time.
FGBGENL_SUM_PERIODIC_CR NUMBER 12 2 YES SUMMARY PERIODIC CREDITS: The sum of all credit
transactions for a given period of time.
Date: 21-JUN-2004 Page: 139
TABLE: FGBGPFC
CREATOR: FIMSMGR
FGBGPFC Opal Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
FGBGPFC_SESS_ID NUMBER 8 NO SESSION ID: Session Id identifies the run session.
FGBGPFC_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS: The chart of accounts used for the
report.
FGBGPFC_FSYR_CODE VARCHAR2 2 NO FISCAL YEAR: The fiscal year code.
FGBGPFC_FUND_CODE VARCHAR2 6 NO FUND CODE: The Fund code from the operating ledger.
FGBGPFC_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: The organization code from the