FI AF View Desc 6

Document Sample
FI AF View Desc 6 Powered By Docstoc
					                            Finance
                           AF - Views

AF_ACCOUNT_DETAIL_VIEW            AF_INVOICE_ACCOUNTING
AF_ACCOUNT_HIERARCHY              AF_INVOICE_CHECK
AF_ACCTG_DISTRIBUTION_ANALYSIS    AF_INVOICE_ITEM
AF_ACCT_ATTRIBUTES_PROFILE        AF_INVOICE_TAX_RATE
AF_ACTV_ATTRIBUTES_PROFILE        AF_LOCATION_HIERARCHY
AF_ATTRIBUTE_SETS_PROFILE         AF_LOCN_ATTRIBUTES_PROFILE
AF_ATYP_ATTRIBUTES_PROFILE        AF_OPERATING_LEDGER
AF_BILLING_DETAIL_VIEW            AF_ORGANIZATION_HIERARCHY
AF_BUDGET_AVAILABILITY            AF_ORGN_ATTRIBUTES_PROFILE
AF_BUDGET_AVAILABILITY_LEDGER     AF_PERIODIC_BALANCE_SHEET
AF_BUDGET_DETAIL                  AF_PERIOD_OPERATING_STATEMENT
AF_BUDGET_DEVELOPMENT             AF_PROGRAM_HIERARCHY
AF_CHART_ATTRIBUTES_PROFILE       AF_PROG_ATTRIBUTES_PROFILE
AF_DISBURSEMENT_ANALYSIS          AF_PROPOSAL
AF_ENDOWMENT_DISTR_PROFILE        AF_PROPOSAL_VIEW
AF_ENDOWMENT_FUNDS_PROFILE        AF_PURCHASE_ORDER
AF_FOAPAL_NO_ATTRIBUTES           AF_PURCHASE_ORDER_ACCOUNTING
AF_FTYP_ATTRIBUTES_PROFILE        AF_PURCHASE_ORDER_ITEM
AF_FUND_ATTRIBUTES_PROFILE        AF_PURCHASE_ORDER_TAX_RATE
AF_FUND_HIERARCHY                 AF_RECEIVED_ITEM
AF_GENERAL_LEDGER                 AF_RECONCILIATION
AF_GRANT                          AF_TRANSACTION_DETAIL
AF_GRANT_BUDGET_DETAIL_TRANS      AF_TRANSACTION_HISTORY
AF_GRANT_BUDGET_STATUS            AF_VENDOR
AF_GRANT_BUDGET_TRANSACTION       AF_VENDOR_PERFORMANCE
AF_GRANT_COSTS                    AF_VENDOR_VOLUME
AF_GRANT_LEDGER                   AF_YEARLY_BALANCE_SHEET
AF_GRANT_VIEW                     AF_YEARLY_OPERATING_STATEMENT
AF_INVOICE
        Transaction_Detail                                           Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                    AF - Veiws

ColumnName                   ID       Data Type            Null? Comments

DOC_SEQ_CODE_KEY                  1   NUMBER (2)           N   This field is a two-digit unique identifier that internally defines document types
DOC_CODE_KEY                      2   VARCHAR2 (8 Byte)    N   The user-defined or system generated document number.
SUBMISSION_NUMBER_KEY             3   NUMBER (3)           N   The number of allowable submissions for a reusable/recurring document.
ITEM_NUMBER_KEY                   4   NUMBER (4)           N   This field uniquely identifies each commodity line item for procurement documents
SEQ_NUMBER_KEY                    5   NUMBER (4)           N   This field uniquely identifies each accounting line item for procurement documents.
SERIAL_NUMBER_KEY                 6   NUMBER (3)           N   The serial number for a fixed asset
REVERSAL_IND_KEY                  7   VARCHAR2 (1 Byte)    N   The indicator that directs the system whether to automatically reverse an automatic journal
                                                               voucher.
LEDGER_IND_KEY                    8 VARCHAR2 (1 Byte)      N   This is a one position field that indicates which ledger is updated by this transaction posting. E -
                                                               Encumbrance, G - General Ledger, O - Operating Account Ledger
FIELD_CODE_KEY                 9 VARCHAR2 (3 Byte)         Y   This is a three digit field that represents the particular ledger bucket being updated.
RULP_CODE_KEY                 10 VARCHAR2 (4 Byte)         N   This is a two digit field that nstructas the posting program as to the particular ledger bucket to
                                                               be updated
HEADER_RUCL_CODE              11      VARCHAR2 (4 Byte)    N   The four character alphanumeric code identifying an accounting transaction rule class.
USER_ID                       12      VARCHAR2 (30 Byte)   N   The unique identification code of the user who entered the transaction.
DOC_REFERENCE_NUMBER          13      VARCHAR2 (8 Byte)    Y   The user-defined number providing additional identification for the transaction.
TRANSACTION_DATE              14      DATE                 N   The date the transaction was processed.
TRANSACTION_DESC              15      VARCHAR2 (35 Byte)   Y   A brief description of the purpose of the transaction record being created.
BANK_CODE                     16      VARCHAR2 (2 Byte)    Y   A user-defined value that is used for identification purposes on all cash transactions.
DEPOSIT_NUMBER                17      VARCHAR2 (8 Byte)    Y   The deposit number assigned to this transaction.
ENCUMBRANCE_ACTION_IND        18      VARCHAR2 (1 Byte)    Y   This field identifies liquidation action on encumbrances. P - Partial T - Total.
PRJD_CODE                     19      VARCHAR2 (8 Byte)    Y   The project code on encumbrances related to work orders.
AUTO_JOURNAL_ID               20      VARCHAR2 (3 Byte)    Y   The user-defined value providing unique identification for a recurring journal voucher.
DISTRIBUTION_PERCENT          21      NUMBER (6,3)         Y   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.
BUDGET_DISPOSITION            22 VARCHAR2 (1 Byte)         Y   The indicator that determines the year-end processing or budget requested encumbrance
                                                               amounts.
ENCUMBRANCE_TYPE              23 VARCHAR2 (1 Byte)         Y   This field indicates whether a document is an encubrance (E), a purchase order (P), or a
                                                               requisition (R)
VENDOR_ID                     24 VARCHAR2 (9 Byte)         Y   This field defines the identification number used to access entities
VENDOR_NAME                   25 VARCHAR2 (60 Byte)        Y   This field is the vendor name
ENTITY_IND                    26 VARCHAR2 (1 Byte)         Y   This field identifies whether record is person or non-person record. It does not display on the
                                                               form. Valid values: P - person, C - non-person.
VENDOR_PIDM                   27 NUMBER (8)                Y   The unique personal identification master of a vendor.
        Transaction_Detail                                      Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                               AF - Veiws

BUDGET_PERIOD                28 VARCHAR2 (2 Byte)     Y   The numeric value of the budget period being entered if this is a budget journal.
ACCRUAL_IND                  29 VARCHAR2 (1 Byte)     Y   This indicator is used during the accrual period. If set to Y, the system automatically
                                                          generates transactions for both current and prior fiscal years.
AVAILABLE_BUDGET_OVERRIDE    30 VARCHAR2 (1 Byte)     Y   This indicator is used to override the availability of funds checking process, if the user has the
                                                          authority.
CURRENCY_CODE                31 VARCHAR2 (4 Byte)     Y   A code which uniquely identifies the type of currency represented in the amount field
CONVERT_AMOUNT               32 NUMBER (12,2)         Y   The base currency amount calculated for this accounting record. Used when a currency code
                                                          is established in this record.
EXCHANGE_AMOUNT              33 NUMBER (12,2)         Y   The exchange amount is the difference between the input transaction amount and the
                                                          converted amount. This field is used to balance the exchange accounts associated to each
                                                          currency code.
EXCHANGE_DIFFERENCE          34 NUMBER (12,2)         Y   The difference between the exchange amounts from when the invoice is recorded to when the
                                                          check is written. This field is also used to balance the exchange accounts associated to each
                                                          currency code.
SUM_POSTING_DOCUMENT_CODE    35 VARCHAR2 (8 Byte)     Y   Document number generated in a given posting run.
COAS_CODE_POOL               36 VARCHAR2 (1 Byte)     Y   The code that denodes the pool chart of account that the investment fund code is
                                                          participating.
FUND_CODE_POOL               37   VARCHAR2 (6 Byte)   Y   The code that denotes the pool fund that the investment fund code is participating.
DETAIL_RUCL_CODE             38   VARCHAR2 (4 Byte)   N   The four character alphanumeric code identifying an accounting transaction rule class.
DETAIL_DOCUMENT_SEQ_CODE     39   NUMBER (2)          N   The code that defines the type of document to the
DETAIL_DOCUMENT_CODE         40   VARCHAR2 (8 Byte)   N   The user-defined or system generated document number.
DETAIL_SUBMISSION_NUMBER     41   NUMBER (2)          N   The number of submissions allowable for a reusable/recurring document.
DETAIL_ITEM_NUMBER           42   NUMBER (4)          N   The unique sequence number directly associated to an item on the commodity record.
DETAIL_SEQ_NUMBER            43   NUMBER (4)          N   This number represents a predefined value within BANNER Finance that is used for operating
                                                          ledger classification and reporting purposes.
POSTING_PERIOD               44 VARCHAR2 (2 Byte)     Y   The code that identifies the period in which a transaction was accounted. Usually between 00
                                                          and 14.
ACTIVITY_DATE                45 DATE                  N   The date that information for this record in the table was entered or last updated.
DETAIL_USER_ID               46 VARCHAR2 (30 Byte)    N   The unique identification code of the user who entered the transaction.
DETAIL_PROCESS_CODE          47 VARCHAR2 (4 Byte)     N
                                                          The code that identifies the particular posting process routine invoked on this transaction.
COAS_CODE                    48 VARCHAR2 (1 Byte)     N   This field is the primary identification for any chart of accounts which is used to uniquely
                                                          identify that chart from any other in a multi-chart environment
COAS_DESC                    49 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the chart of accounts
COAS_STATUS_IND              50 VARCHAR2 (1 Byte)     Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
FSYR_CODE                    51 VARCHAR2 (4 Byte)     Y   A unique numeric identifier code for the fiscal year being defined.
        Transaction_Detail                                      Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                               AF - Veiws

ACCI_CODE                    52 VARCHAR2 (6 Byte)     Y   The user-defined value representing a summarization of any combination of user-defined
                                                          FOAPAL elements.
ACCI_DESC                    53 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the account index
ACCI_STATUS_IND              54 VARCHAR2 (30 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
FUND_CODE                    55 VARCHAR2 (6 Byte)     N   This field is the primary identification for the fund on the transaction
FUND_DESC                    56 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the transaction fund
FUND_STATUS_IND              57 VARCHAR2 (30 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
ORGN_CODE                    58 VARCHAR2 (6 Byte)     Y   This field is the primary identification for the organization on the transaction
ORGN_DESC                    59 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the transaction organization
ORGN_STATUS_IND              60 VARCHAR2 (30 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
ACCT_CODE                    61 VARCHAR2 (6 Byte)     N   This field is the primary identification for the account on the transaction
ACCT_DESC                    62 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the transaction account
ACCT_STATUS_IND              63 VARCHAR2 (30 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
PROG_CODE                    64 VARCHAR2 (6 Byte)     Y   This field is the primary identification for the program on the transaction
PROG_DESC                    65 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the transaction program
PROG_STATUS_IND              66 VARCHAR2 (30 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
ACTV_CODE                    67 VARCHAR2 (6 Byte)     Y   This field is the primary identification for the activity on the transaction
ACTV_DESC                    68 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the transaction activity
ACTV_STATUS_IND              69 VARCHAR2 (30 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
LOCN_CODE                    70 VARCHAR2 (6 Byte)     Y   This field is the primary identification for the location on the transaction
LOCN_DESC                    71 VARCHAR2 (30 Byte)    Y   This field specifies a free-format description of the transaction location
LOCN_STATUS_IND              72 VARCHAR2 (30 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                          I=inactive.
BUDGET_ID                    73 VARCHAR2 (6 Byte)     Y   The user defined unique identification of the budget identifier. Generally identifies the fiscal
                                                          year for which the budget is being prepared.
DETAIL_BUDGET_PERIOD         74 VARCHAR2 (2 Byte)     Y
                                                          The numeric value of the budget period being entered by this entry if this is a budget journal.
ENCUMBRANCE_NUMBER           75   VARCHAR2 (8 Byte)   Y   The unique number of the document being posted.
ENCUMBRANCE_ITEM_NUMBER      76   NUMBER (4)          Y   The number associated with each individual commodity on the encumbering document.
ENCUMBRANCE_SEQ_NUMBER       77   NUMBER (4)          Y   The number associated with each accounting distribution on an encumbering document.
TRANSACTION_AMOUNT           78   NUMBER (12,2)       N   The dollar amount of the transaction associated with this particular account distribution.
        Transaction_Detail                                     Finance                                  6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                              AF - Veiws

DEBIT_CREDIT_IND             79 VARCHAR2 (1 Byte)    N   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.
OTHER_DATA                   80 VARCHAR2 (30 Byte)   Y   This is a user-defined free-form description.
RECONCILIATION_IND           81 VARCHAR2 (1 Byte)    Y   The indicator of whether a check or deposit record has been reconciled.
DETAIL_REVERSAL_IND          82 VARCHAR2 (1 Byte)    N   The indicator that directs the system whether to automatically reverse an automatic journal
                                                         voucher.
DETAIL_SERIAL_NUMBER         83 NUMBER (3)           N   The serial number for a fixed asset.
AMOUNT_IND                   84 VARCHAR2 (1 Byte)    N
                                                         To identify which amount will be posted, which are C for converted amount, I for input amount,
                                                         E for exchange amount, and D for exchange difference amount and Default is C.
DETAIL_PRJD_CODE             85 VARCHAR2 (8 Byte)    Y   This is the project code on the transaction.
DETAIL_SUM_POST_DOC_CODE     86 VARCHAR2 (8 Byte)    Y
                                                         This is the document number generated in a given posting run. Format is MMDDHHMM.
COMMIT_TYPE                  87 VARCHAR2 (1 Byte)    Y   This field indicates whether a line item represents funds committed from the prior year budget.
                                                         U = Uncommitted, C = Committed.
COMMIT_PERCENT               88 NUMBER (6,3)         Y   This field represents the percetage of budget to be rolled into the next fiscal year as
                                                         committed funds
        Transaction_History                                      Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                AF - Veiws

ColumnName                    ID       Data Type            Null? Comments

DOCUMENT                           1   VARCHAR2 (8 Byte)    N   The user-defined or system generated document number.
DOCUMENT_TYPE                      2   NUMBER (2)           N   This field is a two-digit unique identifier that internally defines document types.
DOCUMENT_TYPE_DESC                 3   VARCHAR2 (35 Byte)   Y   This is the description for the two-digit document type.
DOCUMENT_DATE                      4   DATE                 Y   This field identifies the document date.
SUBMISSION_NUMBER                  5   NUMBER (3)           N   The number of allowable submissions for a reusable/recurring document.
ITEM                               6   NUMBER (4)           N   This field uniquely identifies each commodity line item for procurement documents.
SEQUENCE_NUMBER                    7   NUMBER (4)           N   This field uniquely identifies each accounting line item for procurement documents.
SERIAL_NUMBER                      8   NUMBER (3)           N   The serial number for a fixed asset.
REVERSAL_IND                       9   VARCHAR2 (1 Byte)    N   The indicator that directs the system whether to automatically reverse an automatic journal
                                                                voucher.
LEDGER_IND                     10 VARCHAR2 (1 Byte)         N   This is a one position field that indicates which ledger is updated by this transaction
                                                                posting. Valid values are E=Encumbrance or G=General Ledger or O=Operating Account
                                                                Ledger.
FIELD_CODE                     11 VARCHAR2 (2 Byte)         N   This is a three digit field that represents the particular ledger bucket being updated.
RULE_PROCESS                   12 VARCHAR2 (4 Byte)         N   This is a two digit field that instructs the posting program as to the particular ledger bucket
                                                                to be updated.
RULE_CLASS                     13 VARCHAR2 (4 Byte)         N
                                                                The four character alphanumeric code identifying an accounting transaction rule class.
RULE_CLASS_DESC                14      VARCHAR2 (35 Byte)   Y   The unique title assigned to a rule class.
USER_ID                        15      VARCHAR2 (30 Byte)   N   The unique identification code of the user who entered the transaction.
DOC_REFERENCE_NUMBER           16      VARCHAR2 (8 Byte)    Y   The user-defined number providing additional identification for the transaction.
DOC_REFERENCE_NUMBER2          17      VARCHAR2 (0 Byte)    Y   The second user-defined number providing additional identification for the transaction.
TRANSACTION_DATE               18      DATE                 N   The date the transaction was processed.
TRANSACTION_DESC               19      VARCHAR2 (35 Byte)   Y   A brief description of the purpose of the transaction record being created.
BANK                           20      VARCHAR2 (2 Byte)    Y   A user-defined value that is used for identification purposes on all cash transactions.
BANK_NAME                      21      VARCHAR2 (60 Byte)   Y   The name of the banking institution where the installlment has accounts.
BANK_DESC                      22      VARCHAR2 (35 Byte)   Y   The name of the banking institution where the installlment has accounts.
DEPOSIT_NUMBER                 23      VARCHAR2 (8 Byte)    Y   The deposit number assigned to this transaction.
ENCUMBRANCE_ACTION_IND         24      VARCHAR2 (1 Byte)    Y   This field identifies liquidation action on encumbrances. P=Partial or T=Total.
PROJECT                        25      VARCHAR2 (8 Byte)    Y   The project code on encumbrances related to work orders.
AUTO_JOURNAL_ID                26      VARCHAR2 (3 Byte)    Y   The user-defined value providing unique identification for a recurring journal voucher.
DISTRIBUTION_PERCENT           27      NUMBER (6,3)         Y
                                                                Percentage of the total encumbrance assigned to this accounting distribution. If percentage
                                                                is entered then system calculates the amount. Otherwise an amount must be entered.
        Transaction_History                                    Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                              AF - Veiws

BUDGET_DISPOSITION              28 VARCHAR2 (1 Byte)      Y   The indicator that determines the year-end processing or budget requested encumbrance
                                                              amounts.
ENCUMBRANCE_TYPE                29 VARCHAR2 (1 Byte)      Y   This field indicates whether a document is an encumbrance (E) or a purchase order (P) or
                                                              a requisition (R).
VENDOR_UID                      30 NUMBER (8)             Y   The unique personal identification master of a vendor.
BUDGET_PERIOD                   31 VARCHAR2 (2 Byte)      Y   This is the numeric value of the budget period being entered if this is a budget journal.
ACCRUAL_IND                     32 VARCHAR2 (1 Byte)      Y   This indicator is used during the accrual period. If set to Y, the system automatically
                                                              generates transactions for both current and prior fiscal years.
AVAILABLE_BUDGET_OVERRIDE       33 VARCHAR2 (1 Byte)      Y   This indicator is used to override the availability of funds checking process when the user
                                                              has the authority.
CURRENCY                        34 VARCHAR2 (4 Byte)      Y   This code uniquely identifies the type of currency represented in the amount field.
CURRENCY_DESC                   35 VARCHAR2 (35 Byte)     Y   The description or title for this currency code.
CONVERT_AMOUNT                  36 NUMBER (12,2)          Y   This is the base currency amount calculated for this accounting record. Used when a
                                                              currency code is established in this record.
EXCHANGE_AMOUNT                 37 NUMBER (12,2)          Y   The exchange amount is the difference between the input transaction amount and the
                                                              converted amount. This field is used to balance the exchange accounts associated to each
                                                              currency code.
EXCHANGE_DIFFERENCE             38 NUMBER (12,2)          Y
                                                              Difference between the exchange amounts when the invoice is recorded to when the check
                                                              is written. Also used to balance the exchange accounts associated to each currency code.
SUM_POSTING_DOCUMENT_CODE       39 VARCHAR2 (8 Byte)      Y   Document number generated in a given posting run.
CHART_OF_ACCOUNTS_POOL          40 VARCHAR2 (1 Byte)      Y   The code that denotes the pool chart of account that the investment fund code is
                                                              participating.
CHART_OF_ACCOUNTS_POOL_DESC     41   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the chart of accounts.
CHART_OF_ACCOUNTS_POOL_STATUS   42   VARCHAR2 (1 Byte)    Y   Field representing the current status of a system code. A=active or I=inactive.
FUND_POOL                       43   VARCHAR2 (6 Byte)    Y   The code that denotes the pool fund that the investment fund code is participating.
FUND_POOL_DESC                  44   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the transaction fund.
FUND_POOL_STATUS                45   VARCHAR2 (30 Byte)   Y   The current status of the associated fund.
POSTING_PERIOD                  46   VARCHAR2 (2 Byte)    Y   The code that identifies the period in which a transaction was accounted. Usually between
                                                              00 and 14.
ACTIVITY_DATE                   47 DATE                   Y   The date that information for this record in the table was entered or last updated.
DETAIL_USER_ID                  48 VARCHAR2 (30 Byte)     Y   The unique identification code of the user who entered the transaction.
DETAIL_POSTING_PROCESS          49 VARCHAR2 (4 Byte)      Y
                                                              The code that identifies the particular posting process routine invoked on this transaction.
DETAIL_POSTING_PROCESS_DESC     50 VARCHAR2 (30 Byte)     Y   Description of the Process Name Code.
CHART_OF_ACCOUNTS               51 VARCHAR2 (1 Byte)      Y   This field is the primary identification for any chart of accounts which is used to uniquely
                                                              identify that chart from any other in a multi-chart environment.
        Transaction_History                                  Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                            AF - Veiws

CHART_OF_ACCOUNTS_DESC        52 VARCHAR2 (35 Byte)     Y   This field specifies a free-format description of the chart of accounts.
CHART_OF_ACCOUNTS_STATUS      53 VARCHAR2 (1 Byte)      Y   Field representing the current status of a system code. A=active or I=inactive.
FISCAL_YEAR                   54 VARCHAR2 (4 Byte)      Y   A unique numeric identifier code for the fiscal year being defined. Function fofyncv returns
                                                            a four-digit year when supplied a two-digit year.
ACCOUNT_INDEX                 55 VARCHAR2 (6 Byte)      Y   The user-defined value representing a summarization of any combination of user-defined
                                                            FOAPAL elements.
ACCOUNT_INDEX_DESC            56   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the account index.
ACCOUNT_INDEX_STATUS          57   VARCHAR2 (30 Byte)   Y   The current status of the associated account index.
FUND                          58   VARCHAR2 (6 Byte)    Y   This field is the primary identification for the fund on the transaction.
FUND_DESC                     59   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the transaction fund.
FUND_STATUS                   60   VARCHAR2 (30 Byte)   Y   The current status of the associated fund.
ORGANIZATION_CODE             61   VARCHAR2 (6 Byte)    Y   This field is the primary identification for the organization on the transaction.
ORGANIZATION_DESC             62   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the transaction organization.
ORGANIZATION_STATUS           63   VARCHAR2 (30 Byte)   Y   The current status of the associated organization.
ACCOUNT                       64   VARCHAR2 (6 Byte)    Y   This field is the primary identification for the account on the transaction.
ACCOUNT_DESC                  65   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the transaction account.
ACCOUNT_STATUS                66   VARCHAR2 (30 Byte)   Y   The current status of the associated account.
PROGRAM                       67   VARCHAR2 (6 Byte)    Y   This field is the primary identification for the program on the transaction.
PROGRAM_DESC                  68   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the transaction program.
PROGRAM_STATUS                69   VARCHAR2 (30 Byte)   Y   The current status of the associated program.
ACTIVITY                      70   VARCHAR2 (6 Byte)    Y   This field is the primary identification for the activity on the transaction.
ACTIVITY_DESC                 71   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the transaction activity.
ACTIVITY_STATUS               72   VARCHAR2 (30 Byte)   Y   The current status of the associated activity.
LOCATION                      73   VARCHAR2 (6 Byte)    Y   This field is the primary identification for the location on the transaction.
LOCATION_DESC                 74   VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the transaction location.
LOCATION_STATUS               75   VARCHAR2 (30 Byte)   Y   The current status of the associated location.
BUDGET_ID                     76   VARCHAR2 (6 Byte)    Y   This is the user-defined unique identification of the budget identifier. Generally identifies the
                                                            fiscal year for which the budget is being prepared.
DETAIL_BUDGET_PERIOD          77 VARCHAR2 (2 Byte)      Y   This is the numeric value of the budget period being entered by this entry if this is a budget
                                                            journal.
ENCUMBRANCE_NUMBER            78 VARCHAR2 (8 Byte)      Y   This is the unique number of the document being posted.
ENCUMBRANCE_ITEM_NUMBER       79 NUMBER (4)             Y   This is the number associated with each individual commodity on the encumbering
                                                            document.
ENCUMBRANCE_SEQ_NUMBER        80 NUMBER (4)             Y   This is the number associated with each accounting distribution on an encumbering
                                                            document.
TRANSACTION_AMOUNT            81 NUMBER (12,2)          Y   This is the dollar amount of the transaction associated with this particular account
                                                            distribution.
        Transaction_History                                 Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                           AF - Veiws

DEBIT_CREDIT_IND              82 VARCHAR2 (1 Byte)     Y   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.
OTHER_DATA                    83 VARCHAR2 (30 Byte)    Y   This is a user-defined free-form description.
RECONCILIATION_IND            84 VARCHAR2 (1 Byte)     Y   This indicates whether a check or deposit record has been reconciled.
DETAIL_REVERSAL_IND           85 VARCHAR2 (1 Byte)     Y
                                                           This indicates whether the system will automatically reverse an automatic journal voucher.
DETAIL_SERIAL_NUMBER          86 NUMBER (3)            Y   This is the serial number for a fixed asset.
AMOUNT_IND                    87 VARCHAR2 (1 Byte)     Y   Identifies which amount will be posted. C=Converted amount or I=Input amount or
                                                           E=Exchange amount or D=Exchange difference amount. The default is C.
DETAIL_PROJECT                88 VARCHAR2 (8 Byte)     Y   This is the project code on the transaction.
DETAIL_SUM_POST_DOC_CODE      89 VARCHAR2 (8 Byte)     Y
                                                           This is the document number generated in a given posting run. Format is MMDDHHMM.
COMMIT_TYPE                   90 VARCHAR2 (1 Byte)     Y   This field indicates whether a line item represents funds committed from the prior year
                                                           budget. U=Uncommitted or C=Committed.
COMMIT_PERCENT                91 NUMBER (6,3)          Y   This field represents the percentage of budget to be rolled into the next fiscal year as
                                                           committed funds.
LIQUIDATION_AMOUNT            92   NUMBER              Y   This field specifies the liquidation amount.
DIRECT_INDIRECT_IND           93   VARCHAR2 (0 Byte)   Y   This field specifies the direct/indirect indicator.
TRANSACTION_TYPE              94   VARCHAR2 (1 Byte)   Y   Function returning the type of transaction.
INDIRECT_COST_RATE            95   NUMBER (7,4)        Y   The indirect cost rate percentage.
INDIRECT_COST_MEMO_RATE       96   NUMBER (7,4)        Y   The indirect cost memo rate percentage.
COST_SHARE_RATE               97   NUMBER (7,4)        Y   The cost shart rate percentage.
CURRENT_DATE                  98   DATE                Y   This is the current date.
        Vendor                                                    Finance                               6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                 AF - Veiws

ColumnName                       ID    Data Type            Null? Comments

VENDOR_UID                         1   NUMBER (8)           Y   This field is the internal identification number of the vendor.
ID_NUMBER                          2   VARCHAR2 (9 Byte)    N   This field defines the identification number used to access the vendor.
NAME                               3   VARCHAR2 (60 Byte)   N   This field defines the name of the vendor.
ENTITY_TYPE                        4   VARCHAR2 (1 Byte)    Y   This field identifies whether record is person or non-person record.
VENDOR_TYPE                        5   VARCHAR2 (2 Byte)    Y   This is the type of vendor which classifies the vendor by various demographic criteria.
VENDOR_TYPE_DESC                   6   VARCHAR2 (35 Byte)   Y   The description or title of the type of vendor.
CONTACT_NAME                       7   VARCHAR2 (35 Byte)   Y   The name or title of the primary contact for the vendor.
ADDRESS_TYPE                       8   VARCHAR2 (2 Byte)    Y   The address type of the vendor.
ADDRESS_TYPE_DESC                  9   VARCHAR2 (30 Byte)   Y   The description for the address type of the vendor.
PHONE_NUMBER_COMBINED             10   VARCHAR2 (14 Byte)   Y   The combined phone number for the vendor.
PHONE_AREA                        11   VARCHAR2 (3 Byte)    Y   The phone area code for the vendor.
PHONE_NUMBER                      12   VARCHAR2 (7 Byte)    Y   The phone number for the vendor.
PHONE_EXT                         13   VARCHAR2 (4 Byte)    Y   The phone extension for the vendor.
CAMPUS                            14   VARCHAR2 (0 Byte)    Y   The campus of the vendor.
CAMPUS_DESC                       15   VARCHAR2 (0 Byte)    Y   The campus description for the campus of the vendor.
FEDERAL_TAX_IND                   16   VARCHAR2 (1 Byte)    Y   This field identifies the federal tax indicator.
FEDERAL_TAX_ID                    17   VARCHAR2 (9 Byte)    Y   This field identifies the federal tax id.
NUMBER_OF_TAX_ID_NOTICES          18   VARCHAR2 (0 Byte)    Y   This field specifies the number of tax id notices the vendor has received.
MOST_RECENT_TAX_ID_NOTICE_YEAR    19   VARCHAR2 (0 Byte)    Y   This field identifies the year the most recent tax id notice was received.
CURRENT_DATE                      20   DATE                 Y   This is the current date.
        Vendor_Performance                                          Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                   AF - Veiws

ColumnName                   ID    Data Type             Null? Comments

RECEIPT_CODE_KEY                  1 VARCHAR2 (8 Byte)    N   Ths field is the receiver document code which identifies the document in the
PO_NUMBER_KEY                     2 VARCHAR2 (8 Byte)    Y   The user-defined purchase order number issued to this vendor.
PACKING_SLIP_KEY                  3 VARCHAR2 (15 Byte)   Y
                                                             This field contains the user-defined alphanumeric fifteen character packing slip number
                                                             generally found on the packing slip attached to goods received in the purchasing process.
RECEIVED_ITEM_KEY                 4 NUMBER (4)           Y   The system generated item number associated with the purchase order commodity.
RETURN_DOC_CODE_KEY               5 VARCHAR2 (8 Byte)    Y   The system generated or user specified number associated with this return to a vendor.
RETURN_DOC_SEQ_NO_KEY             6 NUMBER (3)           Y   Refers to and is the numerical value of each accounting line item associated with the return
                                                             document
PURCHASE_ORDER_DATE            7   DATE                  Y   The date on which a purchase order was created.
PURCHASE_ORDER_PRINT_DATE      8   DATE                  Y   The date on which a purchase order was printed.
DELIVER_BY_DATE                9   DATE                  Y   The date given to the vendor as a required deliver by date.
RECEIVED_DATE                 10   DATE                  Y   The date on which the item was received.
DELIVERY_DAYS_DIFFERENCE      11   NUMBER                Y   This field is caluclates as the difference in days between received date and required deliver
                                                             by date.
RECEIVING_METHOD              12   VARCHAR2 (4 Byte)     Y   This identifies the method used to ship from the vendor.
RECEIVING_METHOD_DESC         13   VARCHAR2 (35 Byte)    Y   The description or title of method used to ship from the vendor.
COMM_CODE                     14   VARCHAR2 (10 Byte)    Y   The user-defined commodity code associated with this commodity.
COMM_DESC                     15   VARCHAR2 (50 Byte)    Y   The description or title of the commodity. This is derived from the commodity validation table
                                                             on commodities stored in the system, or from the document line item on one-time
                                                             commodities.
CARRIER_ID                    16   VARCHAR2 (9 Byte)     Y   This field defines the identification number used to access the carrier.
CARRIER_NAME                  17   VARCHAR2 (60 Byte)    Y   This field defines the name of the carrier.
CARRIER_PIDM                  18   NUMBER (8)            Y   This field is the internal identification number of the carrier.
QUANTITY_RECEIVED             19   NUMBER (8,2)          Y   The quantity received of an ordered commodity.
QUANTITY_REJECTED             20   NUMBER (8,2)          Y   The quantity rejected of an ordered commodity.
QUANTITY_RETURNED             21   NUMBER (8,2)          Y   The quantity being returned on an ordered commodity.
UOMS_RETURNED                 22   VARCHAR2 (3 Byte)     Y   The unit-of-measure applicable to the returned commodity.
UOMS_DESC                     23   VARCHAR2 (35 Byte)    Y   The description or title of the unit-of-measure.
RETURN_REASON                 24   VARCHAR2 (4 Byte)     Y
                                                             User specified code which defines the reason for the return, i.e., (DG) for damaged goods.
RETURN_REASON_DESC            25 VARCHAR2 (35 Byte)      Y   The description or title of the return reason, i.e., damaged goods.
VENDOR_ID                     26 VARCHAR2 (9 Byte)       Y   This field defines the identification number used to access the vendor.
VENDOR_NAME                   27 VARCHAR2 (60 Byte)      Y   This field defines the name of the vendor.
        Vendor_Performance                                        Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                 AF - Veiws

ENTITY_IND                   28 VARCHAR2 (1 Byte)      Y   This field identifies whether record is person or non-person record. It does not display on the
                                                           form. Valid values: P - person, C - non-person.
VENDOR_PIDM                  29   NUMBER (8)           Y   This field is the internal identification number of the vendor.
VENDOR_STREET_LINE1          30   VARCHAR2 (30 Byte)   Y   This field maintains the first line of the address associated with the vendor.
VENDOR_STREET_LINE2          31   VARCHAR2 (30 Byte)   Y   This field maintains the second line of the address associated with the vendor.
VENDOR_STREET_LINE3          32   VARCHAR2 (30 Byte)   Y   This field maintains the third line of the address associated with the vendor.
VENDOR_CITY                  33   VARCHAR2 (20 Byte)   Y   This field maintains the city associated with the address of the vendor.
VENDOR_STATE                 34   VARCHAR2 (3 Byte)    Y   This field maintains the state associated with the address of the vendor.
VENDOR_ZIP_CODE              35   VARCHAR2 (10 Byte)   Y   This field maintains the zip code associated with the address of the vendor.
VENDOR_COUNTY                36   VARCHAR2 (5 Byte)    Y   This field maintains the county associated with the address of the vendor.
VENDOR_COUNTY_DESC           37   VARCHAR2 (30 Byte)   Y   This field specifies the county name associated with the county code.
VENDOR_NATION                38   VARCHAR2 (5 Byte)    Y   This field maintains the nation/country associated with the address of the vendor.
VENDOR_NATION_DESC           39   VARCHAR2 (30 Byte)   Y   This field specifies the nation/country associated with the nation code of the vendor.
VENDOR_TELEPHONE_NUMBER      40   VARCHAR2 (7 Byte)    Y   Phone number for the vendor.
VENDOR_AREA_CODE             41   VARCHAR2 (3 Byte)    Y   The telephone area code for this particular record.
VENDOR_EXTENSION             42   VARCHAR2 (4 Byte)    Y   The telephone extension number for this particular record.
VENDOR_CONTACT_NAME          43   VARCHAR2 (35 Byte)   Y   The name or title of the primary contact for the vendor.
VENDOR_TYPE                  44   VARCHAR2 (2 Byte)    Y   This is the type of vendor, which classifies the vendor by various demographic criteria.
VENDOR_TYPE_DESC             45   VARCHAR2 (35 Byte)   Y   The description or title of the type of vendor.
        Vendor_Volumn                                             Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                 AF - Veiws

ColumnName                ID       Data Type            Null? Comments

PIDM_KEY                       1   NUMBER (8)           Y   This field is the internal identification number of the vendor.
INVOICE_CODE_KEY               2   VARCHAR2 (8 Byte)    N   This is the invoice document number.
SUBMISSION_NUMBER_KEY          3   NUMBER (3)           Y   The number of submissions allowable for a reusable/recurring document.
INVOICE_ITEM_KEY               4   NUMBER (4)           Y
                                                            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.
VENDOR_ID                      5 VARCHAR2 (9 Byte)      Y   This field defines the identification number used to access the vendor.
VENDOR_NAME                    6 VARCHAR2 (60 Byte)     Y   This field defines the name of the vendor.
ENTITY_IND                     7 VARCHAR2 (1 Byte)      Y   This field identifies whether record is person or non-person record. It does not display on the
                                                            form. Valid values: P - person, C - non-person.
VENDOR_STREET_LINE1         8      VARCHAR2 (30 Byte)   Y   This field maintains the first line of the address associated with the vendor.
VENDOR_STREET_LINE2         9      VARCHAR2 (30 Byte)   Y   This field maintains the second line of the address associated with the vendor.
VENDOR_STREET_LINE3        10      VARCHAR2 (30 Byte)   Y   This field maintains the third line of the address associated with the vendor.
VENDOR_CITY                11      VARCHAR2 (20 Byte)   Y   This field maintains the city associated with the address of the vendor.
VENDOR_STATE               12      VARCHAR2 (3 Byte)    Y   This field maintains the state associated with the address of the vendor.
VENDOR_ZIP_CODE            13      VARCHAR2 (10 Byte)   Y   This field maintains the zip code associated with the address of the vendor.
VENDOR_COUNTY              14      VARCHAR2 (5 Byte)    Y   This field maintains the county associated with the address of the vendor.
VENDOR_COUNTY_DESC         15      VARCHAR2 (30 Byte)   Y   This field specifies the county name associated with the county code.
VENDOR_NATION              16      VARCHAR2 (5 Byte)    Y   This field maintains the nation/country associated with the address of the vendor.
VENDOR_NATION_DESC         17      VARCHAR2 (30 Byte)   Y   This field specifies the nation/country associated with the nation code of the vendor.
VENDOR_TELEPHONE_NUMBER    18      VARCHAR2 (7 Byte)    Y   Phone number for the vendor.
VENDOR_AREA_CODE           19      VARCHAR2 (3 Byte)    Y   The telephone area code for this particular record.
VENDOR_EXTENSION           20      VARCHAR2 (4 Byte)    Y   The telephone extension number for this particular record.
VENDOR_CONTACT_NAME        21      VARCHAR2 (35 Byte)   Y   The name or title of the primary contact for the vendor.
VENDOR_TYPE                22      VARCHAR2 (2 Byte)    Y   This is the type of vendor, which classifies the vendor by various demographic criteria.
VENDOR_TYPE_DESC           23      VARCHAR2 (35 Byte)   Y   The description or title of the type of vendor.
PURCHASE_ORDER_NUMBER      24      VARCHAR2 (8 Byte)    Y   The document number for the purchase order.
VENDOR_INVOICE_NUMBER      25      VARCHAR2 (15 Byte)   Y   The vendors invoice code entered on the Invoice document.
INVOICE_DATE               26      DATE                 Y   A user-defined or system generated invoice date.
PAYMENT_DUE_DATE           27      DATE                 Y   The date an invoice is due.
TRANSACTION_DATE           28      DATE                 Y   The date the transaction was processed.
CANCEL_DATE                29      DATE                 Y   The date that the check was cancelled.
FISCAL_YEAR                30      VARCHAR2 (4 Byte)    Y   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.
FISCAL_PERIOD              31 VARCHAR2 (2 Byte)         Y   A unique two digit numeric identifier code for the fiscal period. Usually 00 through 14.
         Vendor_Volumn                                          Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                               AF - Veiws

THIRD_PARTY_VENDOR_ID       32   VARCHAR2 (9 Byte)    Y   This field defines the identification number used to access the check vendor.
THIRD_PARTY_VENDOR_NAME     33   VARCHAR2 (60 Byte)   Y   This field defines the name of the check vendor.
THIRD_PARTY_PIDM            34   NUMBER (8)           Y   The unique personal identification master of a check vendor.
OPEN_PAID_IND               35   VARCHAR2 (1 Byte)    N   This field indicates if a document is open or paid.
APPROVAL_IND                36   VARCHAR2 (1 Byte)    Y   This filed indicates if the document has been approved for processing by the individual
                                                          authorized (via the user hierarchy table) to approve the document.
CREDIT_MEMO_IND             37 VARCHAR2 (1 Byte)      N   This indicator identifies invoices for which a credit memo has been processed.
INVOICE_1099_IND            38 VARCHAR2 (1 Byte)      Y   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.
INVOICE_1099_ID             39 VARCHAR2 (9 Byte)      Y   The taxpayer identification number (TIN) which uniquely identifies this vendor for Federal
                                                          Income tax purposes. For an individual use the social security number.
HOLD_IND                    40 VARCHAR2 (1 Byte)      N   An attribute used to place invoice records on hold to prevent disbursement to a vendor.
INVOICE_TYPE_IND            41 VARCHAR2 (1 Byte)      N   This one-character indicator designates whether an invoice is (D) for Direct Pay or (R) for
                                                          Regular.
COMM_CODE                   42 VARCHAR2 (10 Byte)     Y
                                                          The unique sequence number directly associated with an item on the commodity record.
COMM_DESC                   43 VARCHAR2 (50 Byte)     Y   The description or title of the commodity. This is derived from the commodity validation table
                                                          on commodities stored in the system, or from the document line item on one-time
                                                          commodities.
COMMODITY_HOLD_IND          44   VARCHAR2 (1 Byte)    Y   An attribute used to place invoice records on hold to prevent disbursement to a vendor.
COMMODITY_UOMS              45   VARCHAR2 (4 Byte)    Y   The unit-of-measure applicable to the selected commodity.
COMMODITY_UOMS_DESC         46   VARCHAR2 (35 Byte)   Y   The description or title of the unit-of-measure.
APPROVED_QUANTITY           47   NUMBER (8,2)         Y   The number of items approved for payment processing on this invoice item.
APPROVED_UNIT_PRICE         48   NUMBER (11,4)        Y   The unit dollar value approved for payment on this invoice item.
ADDITIONAL_CHARGES_AMOUNT   49   NUMBER (12,2)        Y   The amount of additional charges for this invoice item.
TAX_AMOUNT                  50   NUMBER (12,2)        Y   The amount of tax computed or entered for this invoice item.
DISCOUNT_AMOUNT             51   NUMBER (12,2)        Y   The dollar value of the discount being taken on the invoice item.
APPROVED_ITEM_AMOUNT        52   NUMBER               Y   This is the approved item amount and is calculated by multiplying the quantity by the
                                                          approved unit price, adding additional charge amounts and tax amounts, and then subtracting
                                                          any discount amounts. Approved item amounts for credit memos w
CURRENCY_CODE               53 VARCHAR2 (4 Byte)      Y   The currency code associated with this invoice.
CONVERTED_UNIT_PRICE        54 NUMBER (11,4)          Y   The base unit price calculated for this commodity record. Used when a currency code is
                                                          established at the header record.
CONVERTED_DISCOUNT_AMOUNT   55 NUMBER (12,2)          Y   The base discount 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.
       Vendor_Volumn                                           Finance                                  6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                              AF - Veiws

CONVERTED_TAX_AMOUNT        56 NUMBER (12,2)         Y   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.
CONVERTED_ADDITNAL_AMOUNT   57 NUMBER (12,2)         Y   The base additional charges amount calculated for this commodity record. Used when a
                                                         currency code is established at the header record.
TGRP_CODE                   58   VARCHAR2 (4 Byte)   Y   The tax group code to be used for this invoice commodity record.
TAX_RATE_CODE_1             59   VARCHAR2 (4 Byte)   Y   The first level of the tax rate code.
REBATE_TAX_AMOUNT_1         60   NUMBER              Y   This will contain the rebate amount due to the institution for a specific tax rate.
CONVERT_REBATE_AMOUNT_1     61   NUMBER              Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                                         rate when dealing with currency conversion.
TAX_RATE_CODE_2             62 VARCHAR2 (4 Byte)     Y   The second level of the tax rate code.
REBATE_TAX_AMOUNT_2         63 NUMBER                Y   This will contain the rebate amount due to the institution for a specific tax rate.
CONVERT_REBATE_AMOUNT_2     64 NUMBER                Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                                         rate when dealing with currency conversion.
TAX_RATE_CODE_3             65 VARCHAR2 (4 Byte)     Y   The third level of the tax rate code.
REBATE_TAX_AMOUNT_3         66 NUMBER                Y   This will contain the rebate amount due to the institution for a specific tax rate.
CONVERT_REBATE_AMOUNT_3     67 NUMBER                Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                                         rate when dealing with currency conversion.
TAX_RATE_CODE_4             68 VARCHAR2 (4 Byte)     Y   The fourth level of the tax rate code.
REBATE_TAX_AMOUNT_4         69 NUMBER                Y   This will contain the rebate amount due to the institution for a specific tax rate.
CONVERT_REBATE_AMOUNT_4     70 NUMBER                Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                                         rate when dealing with currency conversion.
TAX_RATE_CODE_5             71 VARCHAR2 (4 Byte)     Y   The fifth level of the tax rate code.
REBATE_TAX_AMOUNT_5         72 NUMBER                Y   This will contain the rebate amount due to the institution for a specific tax rate.
CONVERT_REBATE_AMOUNT_5     73 NUMBER                Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                                         rate when dealing with currency conversion.
TAX_RATE_CODE_6             74 VARCHAR2 (4 Byte)     Y   The sixth level of the tax rate code.
REBATE_TAX_AMOUNT_6         75 NUMBER                Y   This will contain the rebate amount due to the institution for a specific tax rate.
CONVERT_REBATE_AMOUNT_6     76 NUMBER                Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                                         rate when dealing with currency conversion.
TAX_RATE_CODE_7             77 VARCHAR2 (4 Byte)     Y   The seven level of the tax rate code.
REBATE_TAX_AMOUNT_7         78 NUMBER                Y   This will contain the rebate amount due to the institution for a specific tax rate.
CONVERT_REBATE_AMOUNT_7     79 NUMBER                Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                                         rate when dealing with currency conversion.
TAX_RATE_CODE_8             80 VARCHAR2 (4 Byte)     Y   The eigth level of the tax rate code.
REBATE_TAX_AMOUNT_8         81 NUMBER                Y   This will contain the rebate amount due to the institution for a specific tax rate.
       Vendor_Volumn                            Finance                                  6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                               AF - Veiws

CONVERT_REBATE_AMOUNT_8   82 NUMBER   Y   This field will contain the base currency rebate amount due to the institution for a specific tax
                                          rate when dealing with currency conversion.
        Yearly_Balance_Sheet                                             Finance                                  6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                        AF - Veiws

ColumnName                     ID    Data Type             Null? Comments

FSYR_CODE_KEY                       1 VARCHAR2 (4 Byte)    Y   This field is a unique numeric identifier code for the fiscal year.
COAS_CODE_KEY                       2 VARCHAR2 (1 Byte)    N   This field is the primary identification for any chart of accounts which is used to uniquely identify that
                                                               chart from any other in a multi-chart environment
COAS_DESC                           3 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the chart of accounts
COAS_STATUS                         4 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                               I=inactive.
FUND_CODE_KEY                       5 VARCHAR2 (6 Byte)    N   This field is the primary identification for the ledger fund
FUND_DESC                           6 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the ledger fund
FUND_STATUS                         7 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                               I=inactive.
ACCT_CODE_KEY                    8 VARCHAR2 (6 Byte)       N   This field is the primary identification for the ledger account
ACCT_DESC                        9 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the ledger account
ACCT_STATUS                     10 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                               I=inactive.
FUND_CODE_1                     11 VARCHAR2 (6 Byte)       Y   This field is the level 1 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_1                     12 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the level 1 fund code within the fund code hierarchy
                                                               for the ledger fund code
FUND_STATUS_1                   13 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                               I=inactive.
FUND_CODE_2                     14 VARCHAR2 (6 Byte)       Y   This field is the level 2 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_2                     15 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the level 2 fund code within the fund code hierarchy
                                                               for the ledger fund code
FUND_STATUS_2                   16 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                               I=inactive.
FUND_CODE_3                     17 VARCHAR2 (6 Byte)       Y   This field is the level 3 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_3                     18 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the level 3 fund code within the fund code hierarchy
                                                               for the ledger fund code
FUND_STATUS_3                   19 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                               I=inactive.
FUND_CODE_4                     20 VARCHAR2 (6 Byte)       Y   This field is the level 4 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_4                     21 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the level 4 fund code within the fund code hierarchy
                                                               for the ledger fund code
FUND_STATUS_4                   22 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                               I=inactive.
FUND_CODE_5                     23 VARCHAR2 (6 Byte)       Y   This field is the level 5 fund code within the fund code hierarchy for the ledger fund code
        Yearly_Balance_Sheet                                         Finance                                  6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                    AF - Veiws

FUND_DESC_5                    24 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 5 fund code within the fund code hierarchy
                                                           for the ledger fund code
FUND_STATUS_5                  25 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
FTYP_CODE_1                    26 VARCHAR2 (6 Byte)    Y
                                                           This field is the level 1 fund type code within the fund type code hierarchy for the ledger fund code
FTYP_DESC_1                    27 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 fund type within the fund type hierarchy for
                                                           the ledger fund code
FTYP_STATUS_1                  28 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
FTYP_CODE_2                    29 VARCHAR2 (6 Byte)    Y   This field is the level 2 fund code for the ledger fund code
FTYP_DESC_2                    30 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 2 fund type for the ledger fund code
FTYP_STATUS_2                  31 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
ACCT_CODE_1                    32 VARCHAR2 (6 Byte)    Y
                                                           This field is the level 1 account code within the account code hierarchy for the ledger account code
ACCT_DESC_1                    33 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 account for the ledger account code
ACCT_STATUS_1                  34 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
ACCT_CODE_2                    35 VARCHAR2 (6 Byte)    Y
                                                           This field is the level 2 account code within the account code hierarchy for the ledger account code
ACCT_DESC_2                    36 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 2 account for the ledger account code
ACCT_STATUS_2                  37 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
ACCT_CODE_3                    38 VARCHAR2 (6 Byte)    Y
                                                           This field is the level 3 account code within the account code hierarchy for the ledger account code
ACCT_DESC_3                    39 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 3 account for the ledger account code
ACCT_STATUS_3                  40 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
ACCT_CODE_4                    41 VARCHAR2 (6 Byte)    Y
                                                           This field is the level 4 account code within the account code hierarchy for the ledger account code
ACCT_DESC_4                    42 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 4 account for the ledger account code
ACCT_STATUS_4                  43 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
ATYP_CODE_1                    44 VARCHAR2 (6 Byte)    Y   This field is the level 1 account type code within the account type code hierarchy for the ledger
                                                           account code
        Yearly_Balance_Sheet                                         Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                    AF - Veiws

ATYP_DESC_1                    45 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 account type within the account type
                                                           hierarchy for the ledger account code
ATYP_STATUS_1                  46 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
ATYP_CODE_2                    47 VARCHAR2 (6 Byte)    Y   This field is the level 2 account type code for the ledger account code
ATYP_DESC_2                    48 VARCHAR2 (35 Byte)   Y
                                                           This field specifies a free-format description of the level 2 account type for the ledger account code
ATYP_STATUS_2                  49 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
GRNT_CODE                      50 VARCHAR2 (9 Byte)    Y   This field is the grant code for the ledger fund code
GRNT_DESC                      51 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the grant
GRNT_STATUS                    52 VARCHAR2 (2 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                           I=inactive.
SUM_PERIODIC_DEBITS            53 NUMBER               Y   The sum of all debit transactions for a given period of time.
SUM_PERIODIC_CREDITS           54 NUMBER               Y   The sum of all credit transactions for a given period of time.
BEGINNING_BALANCE              55 NUMBER               Y   This balance is derived by calculating the sum of FGBGENL_SUM_PERIODIC_DR minus
                                                           FGBGENL_SUM_PERIODIC_CR from FGBGENL of previous fiscal year.
ENDING_BALANCE                 56 NUMBER               Y   This balance is derived by calculating the sum of FGBGENL_SUM_PERIODIC_DR minus
                                                           FGBGENL_SUM_PERIODIC_CR.
BEGIN_BALANCE_DR_CR_IND        57 VARCHAR2 (1 Byte)    Y   This indicator is derived based on the sign of the Beginning Balance attribute. A positive amount
                                                           returns a D. A negative amount returns a C. A zero amount returns 0.
ENDING_BALANCE_DR_CR_IND       58 VARCHAR2 (1 Byte)    Y   This indicator is derived based on the sign of the Ending Balance attribute. A positive amount
                                                           returns a D. A negative amount returns a C. A zero amount returns 0.
NORMAL_BALANCE_IND             59 VARCHAR2 (1 Byte)    Y   This indicator is derived based on the sign of the Beginning Balance attribute. A positive amount
                                                           returns a D. A negative amount returns a C. A zero amount returns 0.
        Yearly_Operating_Statement                                       Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                        AF - Veiws

ColumnName                           ID    Data Type             Null? Comments

FSYR_CODE_KEY                             1 VARCHAR2 (4 Byte)    Y   This field is a unique numeric identifier code for the fiscal year.
COAS_CODE_KEY                             2 VARCHAR2 (1 Byte)    N   This field is the primary identification for any chart of accounts which is used to uniquely
                                                                     identify that chart from any other in a multi-chart environment
COAS_DESC                                 3 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the chart of accounts
COAS_STATUS                               4 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                     I=inactive.
FUND_CODE_KEY                             5 VARCHAR2 (6 Byte)    N   This field is the primary identification for the ledger fund
FUND_DESC                                 6 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the ledger fund
FUND_STATUS                               7 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                     I=inactive.
ORGN_CODE_KEY                          8 VARCHAR2 (6 Byte)       N   This field is the primary identification for the ledger org
ORGN_DESC                              9 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the ledger organization
ORGN_STATUS                           10 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                     I=inactive.
ACCT_CODE_KEY                         11 VARCHAR2 (6 Byte)       N   This field is the primary identification for the ledger account
ACCT_DESC                             12 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the ledger account
ACCT_STATUS                           13 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                     I=inactive.
PROG_CODE_KEY                         14 VARCHAR2 (6 Byte)       N   This field specifies a free-format description of the ledger program
PROG_DESC                             15 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the ledger program
PROG_STATUS                           16 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                     I=inactive.
ACTV_CODE_KEY                         17 VARCHAR2 (6 Byte)       N   This field specifies a free-format description of the ledger activity
ACTV_DESC                             18 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the ledger activity
ACTV_STATUS                           19 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                     I=inactive.
LOCN_CODE_KEY                         20 VARCHAR2 (6 Byte)       N   This field specifies a free-format description of the ledger location
LOCN_DESC                             21 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the ledger location
COMMIT_IND_KEY                        22 VARCHAR2 (1 Byte)       N   This field indicates whether a line item represents funds committed from the prior year
                                                                     budget. U = Uncommitted, C = Committed.
FUND_CODE_1                           23 VARCHAR2 (6 Byte)       Y   This field is the level 1 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_1                           24 VARCHAR2 (35 Byte)      Y   This field specifies a free-format description of the level 1 fund code within the fund code
                                                                     hierarchy for the ledger fund code
FUND_STATUS_1                         25 VARCHAR2 (1 Byte)       Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                     I=inactive.
        Yearly_Operating_Statement                                  Finance                                  6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                   AF - Veiws

FUND_CODE_2                          26 VARCHAR2 (6 Byte)    Y   This field is the level 2 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_2                          27 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 2 fund code within the fund code
                                                                 hierarchy for the ledger fund code
FUND_STATUS_2                        28 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
FUND_CODE_3                          29 VARCHAR2 (6 Byte)    Y   This field is the level 3 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_3                          30 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 3 fund code within the fund code
                                                                 hierarchy for the ledger fund code
FUND_STATUS_3                        31 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
FUND_CODE_4                          32 VARCHAR2 (6 Byte)    Y   This field is the level 4 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_4                          33 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 4 fund code within the fund code
                                                                 hierarchy for the ledger fund code
FUND_STATUS_4                        34 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
FUND_CODE_5                          35 VARCHAR2 (6 Byte)    Y   This field is the level 5 fund code within the fund code hierarchy for the ledger fund code
FUND_DESC_5                          36 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 5 fund code within the fund code
                                                                 hierarchy for the ledger fund code
FUND_STATUS_5                        37 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
FTYP_CODE_1                          38 VARCHAR2 (6 Byte)    Y   This field is the level 1 fund type code within the fund type code hierarchy for the ledger fund
                                                                 code
FTYP_DESC_1                          39 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 fund type within the fund type
                                                                 hierarchy for the ledger fund code
FTYP_STATUS_1                        40 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
FTYP_CODE_2                          41 VARCHAR2 (6 Byte)    Y   This field is the level 2 fund type code within the fund type code hierarchy for the ledger fund
                                                                 code
FTYP_DESC_2                          42 VARCHAR2 (35 Byte)   Y
                                                                 This field specifies a free-format description of the level 2 fund type for the ledger fund code
FTYP_STATUS_2                        43 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
ACCT_CODE_1                          44 VARCHAR2 (6 Byte)    Y   This field is the level 1 account code within the account code hierarchy for the ledger account
                                                                 code
ACCT_DESC_1                          45 VARCHAR2 (35 Byte)   Y
                                                                 This field specifies a free-format description of the level 1 account for the ledger account code
        Yearly_Operating_Statement                                  Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                   AF - Veiws

ACCT_STATUS_1                        46 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
ACCT_CODE_2                          47 VARCHAR2 (6 Byte)    Y   This field is the level 2 account code within the account code hierarchy for the ledger account
                                                                 code
ACCT_DESC_2                          48 VARCHAR2 (35 Byte)   Y
                                                                 This field specifies a free-format description of the level 2 account for the ledger account code
ACCT_STATUS_2                        49 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
ACCT_CODE_3                          50 VARCHAR2 (6 Byte)    Y   This field is the level 3 account code within the account code hierarchy for the ledger account
                                                                 code
ACCT_DESC_3                          51 VARCHAR2 (35 Byte)   Y
                                                                 This field specifies a free-format description of the level 3 account for the ledger account code
ACCT_STATUS_3                        52 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
ACCT_CODE_4                          53 VARCHAR2 (6 Byte)    Y   This field is the level 4 account code within the account code hierarchy for the ledger account
                                                                 code
ACCT_DESC_4                          54 VARCHAR2 (35 Byte)   Y
                                                                 This field specifies a free-format description of the level 4 account for the ledger account code
ACCT_STATUS_4                        55 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
ATYP_CODE_1                          56 VARCHAR2 (6 Byte)    Y   This field is the level 1 account type code within the account type code hierarchy for the
                                                                 ledger account code
ATYP_DESC_1                          57 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 account type within the account
                                                                 type hierarchy for the ledger account code
ATYP_STATUS_1                        58 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
ATYP_CODE_2                          59 VARCHAR2 (6 Byte)    Y   This field is the level 2 account type code within the account type code hierarchy for the
                                                                 ledger account code
ATYP_DESC_2                          60 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 2 account type for the ledger account
                                                                 code
ATYP_STATUS_2                        61 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                 I=inactive.
ORGN_CODE_1                          62 VARCHAR2 (6 Byte)    Y   This field is the level 1 organization code within the organization code hierarchy for the ledger
                                                                 organization code
ORGN_DESC_1                          63 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 account for the ledger organization
                                                                 code
       Yearly_Operating_Statement                                  Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                  AF - Veiws

ORGN_STATUS_1                       64 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
ORGN_CODE_2                         65 VARCHAR2 (6 Byte)    Y   This field is the level 2 organization code within the organization code hierarchy for the ledger
                                                                organization code
ORGN_DESC_2                         66 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 2 account for the ledger organization
                                                                code
ORGN_STATUS_2                       67 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
ORGN_CODE_3                         68 VARCHAR2 (6 Byte)    Y   This field is the level 3 organization code within the organization code hierarchy for the ledger
                                                                organization code
ORGN_DESC_3                         69 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 3 account for the ledger organization
                                                                code
ORGN_STATUS_3                       70 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
ORGN_CODE_4                         71 VARCHAR2 (6 Byte)    Y   This field is the level 4 organization code within organization code hierarchy for the ledger
                                                                organization code
ORGN_DESC_4                         72 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 4 account for the ledger organization
                                                                code
ORGN_STATUS_4                       73 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
ORGN_CODE_5                         74 VARCHAR2 (6 Byte)    Y   This field is the level 5 organization code within the organization code hierarchy for the ledger
                                                                organization code
ORGN_DESC_5                         75 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 5 account for the ledger organization
                                                                code
ORGN_STATUS_5                       76 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
ORGN_CODE_6                         77 VARCHAR2 (6 Byte)    Y   This field is the level 6 organization code within the organization code hierarchy for the ledger
                                                                organization code
ORGN_DESC_6                         78 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 6 account for the ledger organization
                                                                code
ORGN_STATUS_6                       79 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
ORGN_CODE_7                         80 VARCHAR2 (6 Byte)    Y   This field is the level 7 organization code within the organization code hierarchy for the ledger
                                                                organization code
ORGN_DESC_7                         81 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 7 account for the ledger organization
                                                                code
       Yearly_Operating_Statement                                  Finance                                 6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                  AF - Veiws

ORGN_STATUS_7                       82 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
ORGN_CODE_8                         83 VARCHAR2 (6 Byte)    Y   This field is the level 8 organization code within the organization code hierarchy for the ledger
                                                                organization code
ORGN_DESC_8                         84 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 8 account for the ledger organization
                                                                code
ORGN_STATUS_8                       85 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
PROG_CODE_1                         86 VARCHAR2 (6 Byte)    Y   This field is the level 7 program code within the program code hierarchy for the ledger
                                                                program code
PROG_DESC_1                         87 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 program for the ledger program
                                                                code
PROG_STATUS_1                       88 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
PROG_CODE_2                         89 VARCHAR2 (6 Byte)    Y   This field is the level 2 program code within the program code hierarchy for the ledger
                                                                program code
PROG_DESC_2                         90 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 1 program for the ledger program
                                                                code
PROG_STATUS_2                       91 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
PROG_CODE_3                         92 VARCHAR2 (6 Byte)    Y   This field is the level 3 program code within the program code hierarchy for the ledger
                                                                program code
PROG_DESC_3                         93 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 3 program for the ledger program
                                                                code
PROG_STATUS_3                       94 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
PROG_CODE_4                         95 VARCHAR2 (6 Byte)    Y   This field is the level 4 program code within the program code hierarchy for the ledger
                                                                program code
PROG_DESC_4                         96 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 4 program for the ledger program
                                                                code
PROG_STATUS_4                       97 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                I=inactive.
PROG_CODE_5                         98 VARCHAR2 (6 Byte)    Y   This field is the level 5 program code within the program code hierarchy for the ledger
                                                                program code
PROG_DESC_5                         99 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the level 5 program for the ledger program
                                                                code
        Yearly_Operating_Statement                                   Finance                                  6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                    AF - Veiws

PROG_STATUS_5                        100 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                  I=inactive.
LOCN_CODE_1                          101 VARCHAR2 (6 Byte)    Y   This field is the level 1 location code within the location code hierarchy for the ledger location
                                                                  code
LOCN_DESC_1                          102 VARCHAR2 (35 Byte)   Y
                                                                  This field specifies a free-format description of the level 1 location for the ledger location code
LOCN_STATUS_1                        103 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                  I=inactive.
LOCN_CODE_2                          104 VARCHAR2 (6 Byte)    Y   This field is the level 2 location code within the location code hierarchy for the ledger location
                                                                  code
LOCN_DESC_2                          105 VARCHAR2 (35 Byte)   Y
                                                                  This field specifies a free-format description of the level 2 location for the ledger location code
LOCN_STATUS_2                        106 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                  I=inactive.
LOCN_CODE_3                          107 VARCHAR2 (6 Byte)    Y   This field is the level 3 location code within the location code hierarchy for the ledger location
                                                                  code
LOCN_DESC_3                          108 VARCHAR2 (35 Byte)   Y
                                                                  This field specifies a free-format description of the level 3 location for the ledger location code
LOCN_STATUS_3                        109 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                  I=inactive.
LOCN_CODE_4                          110 VARCHAR2 (6 Byte)    Y   This field is the level 4 location code within the location code hierarchy for the ledger location
                                                                  code
LOCN_DESC_4                          111 VARCHAR2 (35 Byte)   Y   This field is the level 4 location code within the location code hierarchy for the ledger location
                                                                  code
LOCN_STATUS_4                        112 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                  I=inactive.
LOCN_CODE_5                          113 VARCHAR2 (6 Byte)    Y   This field is the level 5 location code within the location code hierarchy for the ledger location
                                                                  code
LOCN_DESC_5                          114 VARCHAR2 (35 Byte)   Y   This field is the level 5 location code within the location code hierarchy for the ledger location
                                                                  code
LOCN_STATUS_5                        115 VARCHAR2 (1 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                  I=inactive.
GRNT_CODE                            116 VARCHAR2 (9 Byte)    Y   This field is the grant code for the ledger fund code
GRNT_DESC                            117 VARCHAR2 (35 Byte)   Y   This field specifies a free-format description of the grant
GRNT_STATUS                          118 VARCHAR2 (2 Byte)    Y   This field is a required indicator representing the current status of a system code. A=active or
                                                                  I=inactive.
        Yearly_Operating_Statement                                     Finance                                6a16b308-29af-43ef-8300-8a63ab0c9494.xls

                                                                      AF - Veiws

SUM_ADOPTED_BUDGET                   119 NUMBER (12,2)          Y   This is the cumulative adopted budget using amounts calculated up through and including the
                                                                    current period.
SUM_BUDGET_ADJUSTMENTS               120 NUMBER (12,2)          Y   This is the cumulative budget adjustments using amounts calculated up through and including
                                                                    the current period.
SUM_YEAR_TO_DATE_ACTIVITY            121 NUMBER (12,2)          Y   This is the cumulative year to date activity using amounts calculated up through and including
                                                                    the current period.
SUM_ENCUMBRANCES                     122 NUMBER (12,2)          Y   This is the cumulative encumbrances using amounts calculated up through and including the
                                                                    current period.
SUM_BUDGET_RESERVATIONS              123 NUMBER (12,2)          Y   This is the cumulative budget reservations using amounts calculated up through and including
                                                                    the current period.
SUM_ACCOUNTED_BUDGET                 124 NUMBER (12,2)          Y   This is the cumulative accounted budget using amounts calculated up through and including
                                                                    the current period.
SUM_TEMPORARY_BUDGET                 125 NUMBER (12,2)          Y   This is the cumulative temporary budget using amounts calculated up through and including
                                                                    the current period.
SUM_REMAINING_BALANCE                126 NUMBER                 Y   This is the fiscal year remaining balance, and is calculated using (ADOPT_BUD +
                                                                    BUD_ADJT) - (YTD_ACTV + ENCUMB + BUD_RSRV).
FINANCIAL_MGR_PIDM_ORGN              127 NUMBER (8)             Y   Personal identification for the financial manager associated with the specific organization.
                                                                    Financial Manager is maintained on FTVFMGR. PIDM is maintained on SPRIDEN.
FINANCIAL_MGR_ID_ORGN                128   VARCHAR2 (9 Byte)    Y   This field defines the identification number used to access the org financial manager.
FINANCIAL_MGR_LASTNAME_ORGN          129   VARCHAR2 (60 Byte)   Y   This field defines the last name of the org financial manager.
FINANCIAL_MGR_FIRSTNAME_ORGN         130   VARCHAR2 (15 Byte)   Y   This field identifies the first name of the org financial manager.
FINANCIAL_MGR_MID_NAME_ORGN          131   VARCHAR2 (15 Byte)   Y   This field identifies the middle name of the org financial manager.
FINANCIAL_MGR_PIDM_FUND              132   NUMBER (8)           Y   Personal identification for the financial manager associated with the specific fund. Financial
                                                                    Manager is maintained on FTVFMGR. PIDM is maintained on SPRIDEN.
FINANCIAL_MGR_ID_FUND                133   VARCHAR2 (9 Byte)    Y   This field defines the identification number used to access the fund financial manager.
FINANCIAL_MGR_LASTNAME_FUND          134   VARCHAR2 (60 Byte)   Y   This field defines the last name of the fund financial manager.
FINANCIAL_MGR_FIRSTNAME_FUND         135   VARCHAR2 (15 Byte)   Y   This field identifies the first name of the fund financial manager.
FINANCIAL_MGR_MID_NAME_FUND          136   VARCHAR2 (15 Byte)   Y   This field identifies the middle name of the fund financial manager.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:6/6/2012
language:
pages:26