FABCHKS FABINCK FABINVH FARINVA FARINVC FTVACCT FTVCOAS FTVFUND GTVCURR GURCURR GXRDIRD GXVBANK GXVDIRD PEBPAYM PHRDOCM PHRHIST STVNATN

Model Banking & Currency


Model Label : Banner General Banking and Currency
Path : BANNER DEV/General/ERD/Banking & Currency

List of Objects

Object Name Object Type Layer Name
FABCHKS TABLE Finance Tables
FABINCK TABLE Finance Tables
FABINVH TABLE Finance Tables
FARINVA TABLE Finance Tables
FARINVC TABLE Finance Tables
FTVACCT TABLE Finance Tables
FTVCOAS TABLE Finance Tables
FTVFUND TABLE Finance Tables
GTVCURR TABLE Default
GURCURR TABLE Default
GXRDIRD TABLE Default
GXVBANK TABLE Default
GXVDIRD TABLE Default
PEBPAYM TABLE Payroll Tables
PHRDOCM TABLE Payroll Tables
PHRHIST TABLE Payroll Tables
STVNATN TABLE Default

Comments

Model View

''

Table FABCHKS

Schema Name FIMSMGR
Label FABCHKS
Server name MALDEV8_B60
Creation Date 07/30/2003 15:21:32:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
FABCHKS_CHECK_NUM FABCHKS_CHECK_NUM VARCHAR2(8) No *
FABCHKS_BANK_CODE FABCHKS_BANK_CODE VARCHAR2(2) No *
FABCHKS_ACTIVITY_DATE FABCHKS_ACTIVITY_DATE DATE No
FABCHKS_USER_ID FABCHKS_USER_ID VARCHAR2(30) No
FABCHKS_CHECK_AMT FABCHKS_CHECK_AMT NUMBER(12,2) No
FABCHKS_CHECK_DATE FABCHKS_CHECK_DATE DATE No
FABCHKS_CANCEL_IND FABCHKS_CANCEL_IND VARCHAR2(1) Yes
FABCHKS_CANCEL_DATE FABCHKS_CANCEL_DATE DATE Yes
FABCHKS_CHECK_TYPE_IND FABCHKS_CHECK_TYPE_IND VARCHAR2(1) No
FABCHKS_RECON_IND FABCHKS_RECON_IND VARCHAR2(1) Yes
FABCHKS_ACH_IND FABCHKS_ACH_IND VARCHAR2(1) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
FABCHKS_CDATE_INDEX FABCHKS_CHECK_DATE
PK_FABCHKS Unique FABCHKS_BANK_CODE
PK_FABCHKS Unique FABCHKS_CHECK_NUM

Comments

Source Code Comments

Check Summary Table

Columns Comments for FABCHKS_CHECK_NUM (1)

Source Code Comments

CHECK NUMBER: The pre-printed check number.

Columns Comments for FABCHKS_BANK_CODE (2)

Source Code Comments

BANK CODE: The user-defined value which is used for identification purposes on all cash transactions.

Columns Comments for FABCHKS_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for FABCHKS_USER_ID (4)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for FABCHKS_CHECK_AMT (5)

Source Code Comments

CHECK AMOUNT: The amount of the check.

Columns Comments for FABCHKS_CHECK_DATE (6)

Source Code Comments

CHECK DATE: The date of issue for a check.

Columns Comments for FABCHKS_CANCEL_IND (7)

Source Code Comments

CANCELLATION INDICATOR: An indicator that the check was cancelled.

Columns Comments for FABCHKS_CANCEL_DATE (8)

Source Code Comments

CANCELLATION DATE: The date that the check was cancelled.

Columns Comments for FABCHKS_CHECK_TYPE_IND (9)

Source Code Comments

CHECK TYPE INDICATOR: An indicator establishing the type of check produced. M for manual, B for batch, O for online.

Columns Comments for FABCHKS_RECON_IND (10)

Source Code Comments

RECONCILITATION INDICATOR: The indicator of whether a check or deposit record has been reconciled.

Columns Comments for FABCHKS_ACH_IND (11)

Source Code Comments

ACH INDICATOR: If Y, indicates that the payment was made via direct deposit.

Table FABINCK

Schema Name FIMSMGR
Label FABINCK
Server name MALDEV8_B60
Creation Date 07/30/2003 15:21:34:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
FABINCK_INVH_CODE FABINCK_INVH_CODE VARCHAR2(8) No *
FABINCK_CHECK_NUM FABINCK_CHECK_NUM VARCHAR2(8) No *
FABINCK_BANK_CODE FABINCK_BANK_CODE VARCHAR2(2) No *
FABINCK_ACTIVITY_DATE FABINCK_ACTIVITY_DATE DATE No
FABINCK_USER_ID FABINCK_USER_ID VARCHAR2(30) No
FABINCK_CHECK_TYPE_IND FABINCK_CHECK_TYPE_IND VARCHAR2(1) No
FABINCK_CHECK_DATE FABINCK_CHECK_DATE DATE Yes
FABINCK_NET_AMT FABINCK_NET_AMT NUMBER(12,2) Yes
FABINCK_CANCEL_IND FABINCK_CANCEL_IND VARCHAR2(1) Yes
FABINCK_CANCEL_DATE FABINCK_CANCEL_DATE DATE Yes
FABINCK_RECON_IND FABINCK_RECON_IND VARCHAR2(1) No
FABINCK_INVH_TRANS_DATE FABINCK_INVH_TRANS_DATE DATE Yes
FABINCK_INVH_SUBMISSION_NUMBER FABINCK_INVH_SUBMISSION_NUMBER NUMBER(3,0) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
FABINCK_CHK_INDEX FABINCK_CHECK_NUM
FABINCK_CHK_INDEX FABINCK_BANK_CODE
PK_FABINCK Unique FABINCK_INVH_CODE
PK_FABINCK Unique FABINCK_CHECK_NUM
PK_FABINCK Unique FABINCK_BANK_CODE

Comments

Source Code Comments

Invoice/Check Table

Columns Comments for FABINCK_INVH_CODE (1)

Source Code Comments

INVOICE DOCUMENT CODE: The unique identifier of an invoice document. The code may be system generated by entering NEXT in the invoice header.

Columns Comments for FABINCK_CHECK_NUM (2)

Source Code Comments

CHECK NUMBER: The pre-printed check number.

Columns Comments for FABINCK_BANK_CODE (3)

Source Code Comments

BANK NAME: A user-defined value which is used for identification purposes on all transactions.

Columns Comments for FABINCK_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for FABINCK_USER_ID (5)

Source Code Comments

USER IDENTIFICATION: The unique identification code of the user.

Columns Comments for FABINCK_CHECK_TYPE_IND (6)

Source Code Comments

CHECK TYPE INDICATOR: Indicator which establishes the type of check produced. M-manual, B-batch, O-on-line.

Columns Comments for FABINCK_CHECK_DATE (7)

Source Code Comments

CHECK DATE: The date of issue for a check.

Columns Comments for FABINCK_NET_AMT (8)

Source Code Comments

NET AMOUNT: The net amount of an invoice.

Columns Comments for FABINCK_CANCEL_IND (9)

Source Code Comments

CANCELLATION INDICATOR: Indicates that the check was cancelled.

Columns Comments for FABINCK_CANCEL_DATE (10)

Source Code Comments

CANCELLATION DATE: The date that the check was cancelled.

Columns Comments for FABINCK_RECON_IND (11)

Source Code Comments

RECONCILIATION INDICATOR: The indicator of whether a check or deposit record has been reconciled.

Columns Comments for FABINCK_INVH_TRANS_DATE (12)

Source Code Comments

INVOICE TRANSACTION DATE : This is the transaction date of the invoice for which this check was created. It is updated by the posting process during check disbursement.

Columns Comments for FABINCK_INVH_SUBMISSION_NUMBER (13)

Source Code Comments

INVOICE SUBMISSION NUMBER: This is the submission number of the invoice for which this check was created.It is updated by the posting process during check disbursement.

Table FABINVH

Schema Name FIMSMGR
Label FABINVH
Server name MALDEV8_B60
Creation Date 07/30/2003 15:21:34:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
FABINVH_CODE FABINVH_CODE VARCHAR2(8) No * *
FABINVH_POHD_CODE FABINVH_POHD_CODE VARCHAR2(8) Yes
FABINVH_VEND_PIDM FABINVH_VEND_PIDM NUMBER(8,0) Yes
FABINVH_OPEN_PAID_IND FABINVH_OPEN_PAID_IND VARCHAR2(1) No
FABINVH_ACTIVITY_DATE FABINVH_ACTIVITY_DATE DATE No
FABINVH_USER_ID FABINVH_USER_ID VARCHAR2(30) No
FABINVH_VEND_INV_CODE FABINVH_VEND_INV_CODE VARCHAR2(15) Yes
FABINVH_INVOICE_DATE FABINVH_INVOICE_DATE DATE Yes
FABINVH_PMT_DUE_DATE FABINVH_PMT_DUE_DATE DATE Yes
FABINVH_TRANS_DATE FABINVH_TRANS_DATE DATE Yes
FABINVH_CR_MEMO_IND FABINVH_CR_MEMO_IND VARCHAR2(1) No
FABINVH_ADJT_CODE FABINVH_ADJT_CODE VARCHAR2(2) Yes *
FABINVH_ADJT_DATE FABINVH_ADJT_DATE DATE Yes
FABINVH_1099_IND FABINVH_1099_IND VARCHAR2(1) Yes
FABINVH_1099_ID FABINVH_1099_ID VARCHAR2(9) Yes
FABINVH_ITYP_SEQ_CODE FABINVH_ITYP_SEQ_CODE NUMBER(2,0) Yes
FABINVH_TEXT_IND FABINVH_TEXT_IND VARCHAR2(1) Yes
FABINVH_APPR_IND FABINVH_APPR_IND VARCHAR2(1) Yes
FABINVH_COMPLETE_IND FABINVH_COMPLETE_IND VARCHAR2(1) Yes
FABINVH_DISC_CODE FABINVH_DISC_CODE VARCHAR2(2) Yes
FABINVH_TRAT_CODE FABINVH_TRAT_CODE VARCHAR2(3) Yes
FABINVH_ADDL_CHRG_AMT FABINVH_ADDL_CHRG_AMT NUMBER(12,2) Yes
FABINVH_HOLD_IND FABINVH_HOLD_IND VARCHAR2(1) No
FABINVH_SUSP_IND FABINVH_SUSP_IND VARCHAR2(1) No
FABINVH_SUSP_IND_ADDL FABINVH_SUSP_IND_ADDL VARCHAR2(1) No
FABINVH_CANCEL_IND FABINVH_CANCEL_IND VARCHAR2(1) No
FABINVH_CANCEL_DATE FABINVH_CANCEL_DATE DATE Yes
FABINVH_POST_DATE FABINVH_POST_DATE DATE Yes
FABINVH_ATYP_CODE FABINVH_ATYP_CODE VARCHAR2(2) Yes
FABINVH_ATYP_SEQ_NUM FABINVH_ATYP_SEQ_NUM NUMBER(2,0) Yes
FABINVH_GROUPING_IND FABINVH_GROUPING_IND VARCHAR2(1) Yes
FABINVH_BANK_CODE FABINVH_BANK_CODE VARCHAR2(2) Yes
FABINVH_RUIV_IND FABINVH_RUIV_IND VARCHAR2(1) Yes
FABINVH_EDIT_DEFER_IND FABINVH_EDIT_DEFER_IND VARCHAR2(1) Yes
FABINVH_OVERRIDE_TAX_AMT FABINVH_OVERRIDE_TAX_AMT NUMBER(12,2) Yes
FABINVH_TGRP_CODE FABINVH_TGRP_CODE VARCHAR2(4) Yes
FABINVH_SUBMISSION_NUMBER FABINVH_SUBMISSION_NUMBER NUMBER(3,0) Yes
FABINVH_VEND_CHECK_PIDM FABINVH_VEND_CHECK_PIDM NUMBER(8,0) Yes
FABINVH_INVOICE_TYPE_IND FABINVH_INVOICE_TYPE_IND VARCHAR2(1) No
FABINVH_CURR_CODE FABINVH_CURR_CODE VARCHAR2(4) Yes
FABINVH_DISB_AGENT_IND FABINVH_DISB_AGENT_IND VARCHAR2(1) Yes
FABINVH_ATYP_CODE_VEND FABINVH_ATYP_CODE_VEND VARCHAR2(2) Yes
FABINVH_ATYP_SEQ_NUM_VEND FABINVH_ATYP_SEQ_NUM_VEND NUMBER(2,0) Yes
FABINVH_NSF_ON_OFF_IND FABINVH_NSF_ON_OFF_IND VARCHAR2(1) Yes
FABINVH_SINGLE_ACCTG_IND FABINVH_SINGLE_ACCTG_IND VARCHAR2(1) Yes
FABINVH_ONE_TIME_VEND_NAME FABINVH_ONE_TIME_VEND_NAME VARCHAR2(60) Yes
FABINVH_ONE_TIME_VEND_ADDR1 FABINVH_ONE_TIME_VEND_ADDR1 VARCHAR2(30) Yes
FABINVH_ONE_TIME_VEND_ADDR2 FABINVH_ONE_TIME_VEND_ADDR2 VARCHAR2(30) Yes
FABINVH_ONE_TIME_VEND_ADDR3 FABINVH_ONE_TIME_VEND_ADDR3 VARCHAR2(30) Yes
FABINVH_ONE_TIME_VEND_CITY FABINVH_ONE_TIME_VEND_CITY VARCHAR2(20) Yes
FABINVH_ONE_TIME_VEND_STATE FABINVH_ONE_TIME_VEND_STATE VARCHAR2(3) Yes
FABINVH_ONE_TIME_VEND_ZIP FABINVH_ONE_TIME_VEND_ZIP VARCHAR2(10) Yes
FABINVH_ONE_TIME_VEND_NATN FABINVH_ONE_TIME_VEND_NATN VARCHAR2(5) Yes
FABINVH_DELIVERY_POINT FABINVH_DELIVERY_POINT NUMBER(2,0) Yes
FABINVH_CORRECTION_DIGIT FABINVH_CORRECTION_DIGIT NUMBER(1,0) Yes
FABINVH_CARRIER_ROUTE FABINVH_CARRIER_ROUTE VARCHAR2(4) Yes
FABINVH_RUIV_INSTALLMENT_IND FABINVH_RUIV_INSTALLMENT_IND VARCHAR2(1) Yes
FABINVH_MULTIPLE_INV_IND FABINVH_MULTIPLE_INV_IND VARCHAR2(1) Yes
FABINVH_PHONE_AREA FABINVH_PHONE_AREA VARCHAR2(3) Yes
FABINVH_PHONE_NUMBER FABINVH_PHONE_NUMBER VARCHAR2(7) Yes
FABINVH_PHONE_EXT FABINVH_PHONE_EXT VARCHAR2(4) Yes
FABINVH_EMAIL_ADDR FABINVH_EMAIL_ADDR VARCHAR2(20) Yes
FABINVH_FAX_AREA FABINVH_FAX_AREA VARCHAR2(3) Yes
FABINVH_FAX_NUMBER FABINVH_FAX_NUMBER VARCHAR2(7) Yes
FABINVH_FAX_EXT FABINVH_FAX_EXT VARCHAR2(4) Yes
FABINVH_CANCEL_CODE FABINVH_CANCEL_CODE VARCHAR2(4) Yes
FABINVH_ATTENTION_TO FABINVH_ATTENTION_TO VARCHAR2(35) Yes
FABINVH_VENDOR_CONTACT FABINVH_VENDOR_CONTACT VARCHAR2(35) Yes
FABINVH_INVD_RE_ESTABLISH_IND FABINVH_INVD_RE_ESTABLISH_IND VARCHAR2(1) Yes
FABINVH_ACH_OVERRIDE_IND FABINVH_ACH_OVERRIDE_IND VARCHAR2(1) Yes
FABINVH_ORIGIN_CODE FABINVH_ORIGIN_CODE VARCHAR2(10) Yes
FABINVH_MATCH_REQUIRED FABINVH_MATCH_REQUIRED VARCHAR2(1) No

Foreign Key information

Column name is Foreign Key For Column on Table
FABINVH_ADJT_CODE FTVADJT_CODE FTVADJT
FABINVH_CODE FABINCK_INVH_CODE FABINCK

Index

Index Name Index Type Column Name
FABINVH_PO_INDEX FABINVH_POHD_CODE
FABINVH_VEND_INDEX FABINVH_VEND_PIDM
PK_FABINVH Unique FABINVH_CODE

Comments

Source Code Comments

Invoice Header Table

Columns Comments for FABINVH_CODE (1)

Source Code Comments

Invoice document number.

Columns Comments for FABINVH_POHD_CODE (2)

Source Code Comments

PURHCASE ORDER CODE: The date on which a purchase order was created.

Columns Comments for FABINVH_VEND_PIDM (3)

Source Code Comments

VENDOR PERSONAL IDENTIFCATION MASTER: The unique personal identification master of a vendor.

Columns Comments for FABINVH_OPEN_PAID_IND (4)

Source Code Comments

OPEN PAID INDICATOR: Indicates if a document is open or paid.

Columns Comments for FABINVH_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date when the information for this record on the table was entered or last updated.

Columns Comments for FABINVH_USER_ID (6)

Source Code Comments

USER IDENTIFICATION: The unique identification code of the user.

Columns Comments for FABINVH_VEND_INV_CODE (7)

Source Code Comments

VENDOR INVOICE CODE: The vendor's invoice code entered on the Invoice document.

Columns Comments for FABINVH_INVOICE_DATE (8)

Source Code Comments

INVOICE DATE: A user-defined or system generated invoice date.

Columns Comments for FABINVH_PMT_DUE_DATE (9)

Source Code Comments

PAYMENT DUE DATE: The date an invoice is due.

Columns Comments for FABINVH_TRANS_DATE (10)

Source Code Comments

TRANSACTION DATE: The date the transaction was processed.

Columns Comments for FABINVH_CR_MEMO_IND (11)

Source Code Comments

CREDIT MEMO INDICATOR: This indicator identifies the credit memo processing.

Columns Comments for FABINVH_ADJT_CODE (12)

Source Code Comments

ADJUSTMENT CODE: The date on which the adjustment was made.

Columns Comments for FABINVH_ADJT_DATE (13)

Source Code Comments

ADJUSTMENT DATE: The date on which the adjustment was made.

Columns Comments for FABINVH_1099_IND (14)

Source Code Comments

1099 INDICATOR: This indicator distinguishes taxable payments resulting from the payment processing of the invoice. If Y (yes) the payment will be recorded and accumulated for income tax reporting purposes.

Columns Comments for FABINVH_1099_ID (15)

Source Code Comments

1099 IDENTIFICATION: The taxpayer identification number (TIN) which uniquely identifies this vendor for Federal Income tax purposes. For an individual use the social security number.

Columns Comments for FABINVH_ITYP_SEQ_CODE (16)

Source Code Comments

INTERNAL SEQUENCE CODES: Predefined internal codes which represent transactions types i.e. budget adjustments, that direct theses data values to specific accumalators in the operating account ledger(OPAL).

Columns Comments for FABINVH_TEXT_IND (17)

Source Code Comments

TEXT INDICATOR: The indicator used on validation tables and transaction documents which informs the user that text exists for the record.

Columns Comments for FABINVH_APPR_IND (18)

Source Code Comments

APPROVAL INDICATOR: Indicates if the document has been approved for processing by the individual authorized (via the user hierarchy table) to approve the document.

Columns Comments for FABINVH_COMPLETE_IND (19)

Source Code Comments

COMPLETE INDICATOR: Indicates if the document has been completed.

Columns Comments for FABINVH_DISC_CODE (20)

Source Code Comments

DISCOUNT CODE: The value of the discount code established on the form FTVDISC.

Columns Comments for FABINVH_TRAT_CODE (21)

Source Code Comments

TAX RATE CODE: The value of the tax rate established on form FTVTRAT.

Columns Comments for FABINVH_ADDL_CHRG_AMT (22)

Source Code Comments

ADDITIONAL CHARGE AMOUNT: The dollar value of any additional charges, e.g. freight associated with this invoice.

Columns Comments for FABINVH_HOLD_IND (23)

Source Code Comments

INVOICE HOLD INDICATOR: An attribute used to place invoice reocrds on hold to prevent disbursement to a vendor.

Columns Comments for FABINVH_SUSP_IND (24)

Source Code Comments

SUSPENSE INDICATOR: An indicator to inform the user that a document is being held in suspense due to missing or erroneous data content.

Columns Comments for FABINVH_CANCEL_IND (26)

Source Code Comments

CANCELLATION IDENTIFICATION: This one-character indicator identifies that an invoice has been cancelled.

Columns Comments for FABINVH_CANCEL_DATE (27)

Source Code Comments

CANCELLATION DATE: The date that the check was cancelled.

Columns Comments for FABINVH_POST_DATE (28)

Source Code Comments

POSTING DATE: The date on which a transaction is posted.

Columns Comments for FABINVH_ATYP_CODE (29)

Source Code Comments

VENDOR ADDRESS TYPE CODE: Used to identify the vendor address type when creating the invoice. Defaults from the AP default address identified on the Vendor if the code is not entered. This is different from the ATYP_CODE_VEND in that the ATYP_CODE_VEND

Columns Comments for FABINVH_ATYP_SEQ_NUM (30)

Source Code Comments

VENDOR ADDRESS TYPE SEQUENCE NUMBER: Used to identify the vendor address type sequence number when creating the invoice. Defaults from the AP default address sequence number identified on the Vendor if the code is not entered. This is different from th

Columns Comments for FABINVH_GROUPING_IND (31)

Source Code Comments

GROUPING INDICATOR: Indicates the relationship between the number of invoices processed and the number of checks written.

Columns Comments for FABINVH_BANK_CODE (32)

Source Code Comments

BANK CODE: A user-defined value which is used for identification purposes on all cash transactions.

Columns Comments for FABINVH_RUIV_IND (33)

Source Code Comments

RECURRING INVOICE INDICATOR: Indicates that an invoice will be processed on a recurring basis on a specific schedule.

Columns Comments for FABINVH_EDIT_DEFER_IND (34)

Source Code Comments

DEFER EDIT INDICATOR: This indicator is used to defer editing of the transaction until after posting.

Columns Comments for FABINVH_TGRP_CODE (36)

Source Code Comments

TAX GROUP CODE: The tax group code used with a ship-to-address to determine the taxes to be computed.

Columns Comments for FABINVH_SUBMISSION_NUMBER (37)

Source Code Comments

SUBMISSION NUMBER: The number of submissions allowable for a reusable/ recurring document.

Columns Comments for FABINVH_VEND_CHECK_PIDM (38)

Source Code Comments

VENDOR CHECK PERSONAL IDENTIFICATION MASTER: The unique personal identification master of a check vendor.

Columns Comments for FABINVH_INVOICE_TYPE_IND (39)

Source Code Comments

This one-character indicator designates whether an invoice is 'D' for Direct Pay or 'R' for Regular.

Columns Comments for FABINVH_CURR_CODE (40)

Source Code Comments

CURRENCY CODE: The currency code associated with this invoice.

Columns Comments for FABINVH_DISB_AGENT_IND (41)

Source Code Comments

DISBURSING AGENT INDICATOR: Used to identify this invoice as one using a disburing agent when check is written.

Columns Comments for FABINVH_ATYP_CODE_VEND (42)

Source Code Comments

DISBURSING VENDOR ADDRESS TYPE CODE: Used to identify the vendor address type when a disbursing agent is specified. Defaults from the AP default address identified in fabinvh_atyp_code.

Columns Comments for FABINVH_ATYP_SEQ_NUM_VEND (43)

Source Code Comments

DISBURSING VENDOR ADDRESS TYPE SEQUENCE NUMBER: Used to identify the vendor address type sequence number when disbursing agent is specified. Defaults from the AP default address sequence number identified in fabinvh_atyp_seq_num.

Columns Comments for FABINVH_NSF_ON_OFF_IND (44)

Source Code Comments

NSF ON OFF INDICATOR: If Y, available balance checking will be done at entry time for this particular invoice.

Columns Comments for FABINVH_SINGLE_ACCTG_IND (45)

Source Code Comments

SINGLE ACCTG DISTR INDICATOR: If Y, the document will have an accounting or accounting distributions for the document not for specific commodities

Columns Comments for FABINVH_ONE_TIME_VEND_NAME (46)

Source Code Comments

One Time Vendor name for One Time Vendors

Columns Comments for FABINVH_ONE_TIME_VEND_ADDR1 (47)

Source Code Comments

One Time Vendor address line one for One Time Vendors

Columns Comments for FABINVH_ONE_TIME_VEND_ADDR2 (48)

Source Code Comments

One Time Vendor address line two for One Time Vendors

Columns Comments for FABINVH_ONE_TIME_VEND_ADDR3 (49)

Source Code Comments

One Time Vendor address line three for One Time Vendors

Columns Comments for FABINVH_ONE_TIME_VEND_CITY (50)

Source Code Comments

One Time Vendor city for One Time Vendors

Columns Comments for FABINVH_ONE_TIME_VEND_STATE (51)

Source Code Comments

One Time Vendor state for One Time Vendors

Columns Comments for FABINVH_ONE_TIME_VEND_ZIP (52)

Source Code Comments

One Time Vendor zip code for One Time Vendors

Columns Comments for FABINVH_ONE_TIME_VEND_NATN (53)

Source Code Comments

One Time Vendor nation for One Time Vendors

Columns Comments for FABINVH_DELIVERY_POINT (54)

Source Code Comments

DELIVERY POINT: This field indicates the delivery point associated with the address.

Columns Comments for FABINVH_CORRECTION_DIGIT (55)

Source Code Comments

CORRECTION DIGIT: This field indicates the correction digit associated with the address.

Columns Comments for FABINVH_CARRIER_ROUTE (56)

Source Code Comments

CARRIER ROUTE: This field indicates the carrier route associated with the address.

Columns Comments for FABINVH_RUIV_INSTALLMENT_IND (57)

Source Code Comments

RECURRING PAYABLE INSTALLMENT INDICATOR: This user defined field indicates whether the recurring payable set up, is an installment option or not. It is used by the fixed asset module to determine the capitalization amount.

Columns Comments for FABINVH_MULTIPLE_INV_IND (58)

Source Code Comments

MULTIPLE VENDOR INVOICE INDICATOR: This user defined field indicates whether the Banner invoice document has multiple vendor invoices.

Columns Comments for FABINVH_PHONE_AREA (59)

Source Code Comments

PHONE AREA: Phone area code.

Columns Comments for FABINVH_PHONE_NUMBER (60)

Source Code Comments

PHONE EXTENTION: Phone extention.

Columns Comments for FABINVH_EMAIL_ADDR (62)

Source Code Comments

EMAIL ADDRESS: Email address.

Columns Comments for FABINVH_FAX_AREA (63)

Source Code Comments

FAX AREA CODE: Fax number area code.

Columns Comments for FABINVH_FAX_NUMBER (64)

Source Code Comments

FAX NUMBER: Fax telephone number.

Columns Comments for FABINVH_FAX_EXT (65)

Source Code Comments

FAX EXTENTION: Fax number extention.

Columns Comments for FABINVH_ATTENTION_TO (67)

Source Code Comments

ATTENTION TO: Attention To line for ship to address.

Columns Comments for FABINVH_VENDOR_CONTACT (68)

Source Code Comments

VENDOR CONTACT: The vendor contact.

Columns Comments for FABINVH_INVD_RE_ESTABLISH_IND (69)

Source Code Comments

INVOICE RE ESTABLISH INDICATOR: This user defined field indicates whether the Banner invoice is re established at invoice cancellation time or not.

Columns Comments for FABINVH_ACH_OVERRIDE_IND (70)

Source Code Comments

ACH OVER RIDE INDICATOR: Active ACH status of the vendor can be over-riden at invoice level with this indicator.

Columns Comments for FABINVH_ORIGIN_CODE (71)

Source Code Comments

INVOICE ORIGININATION CODE: Where the Invoice source of creation came from.

Columns Comments for FABINVH_MATCH_REQUIRED (72)

Source Code Comments

Match Required: Used to indicate whether this Invoice requires Matching. Valid values are [N]o matching, [Y]es matching, [U]nterprise matching in effect.

Table FARINVA

Schema Name FIMSMGR
Label FARINVA
Server name MALDEV8_B60
Creation Date 04/15/2002 18:18:22:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
FARINVA_INVH_CODE FARINVA_INVH_CODE VARCHAR2(8) No *
FARINVA_INVH_CODE FARINVA_INVH_CODE VARCHAR2(8) No *
FARINVA_INVH_CODE FARINVA_INVH_CODE VARCHAR2(8) No *
FARINVA_POHD_CODE FARINVA_POHD_CODE VARCHAR2(8) Yes
FARINVA_ITEM FARINVA_ITEM NUMBER(4,0) No *
FARINVA_PO_ITEM FARINVA_PO_ITEM NUMBER(4,0) Yes
FARINVA_SEQ_NUM FARINVA_SEQ_NUM NUMBER(4,0) No
FARINVA_ACTIVITY_DATE FARINVA_ACTIVITY_DATE DATE No
FARINVA_USER_ID FARINVA_USER_ID VARCHAR2(30) No
FARINVA_FSYR_CODE FARINVA_FSYR_CODE VARCHAR2(2) Yes
FARINVA_PERIOD FARINVA_PERIOD VARCHAR2(2) Yes
FARINVA_EOY_ACCR_STATUS_IND FARINVA_EOY_ACCR_STATUS_IND VARCHAR2(1) Yes
FARINVA_RUCL_CODE FARINVA_RUCL_CODE VARCHAR2(4) No
FARINVA_DISC_RUCL_CODE FARINVA_DISC_RUCL_CODE VARCHAR2(4) Yes
FARINVA_TAX_RUCL_CODE FARINVA_TAX_RUCL_CODE VARCHAR2(4) Yes
FARINVA_ADDL_RUCL_CODE FARINVA_ADDL_RUCL_CODE VARCHAR2(4) Yes
FARINVA_COAS_CODE FARINVA_COAS_CODE VARCHAR2(1) Yes *
FARINVA_COAS_CODE FARINVA_COAS_CODE VARCHAR2(1) Yes *
FARINVA_COAS_CODE FARINVA_COAS_CODE VARCHAR2(1) Yes *
FARINVA_ACCI_CODE FARINVA_ACCI_CODE VARCHAR2(6) Yes
FARINVA_FUND_CODE FARINVA_FUND_CODE VARCHAR2(6) Yes *
FARINVA_ORGN_CODE FARINVA_ORGN_CODE VARCHAR2(6) Yes
FARINVA_ACCT_CODE FARINVA_ACCT_CODE VARCHAR2(6) Yes *
FARINVA_PROG_CODE FARINVA_PROG_CODE VARCHAR2(6) Yes
FARINVA_ACTV_CODE FARINVA_ACTV_CODE VARCHAR2(6) Yes
FARINVA_LOCN_CODE FARINVA_LOCN_CODE VARCHAR2(6) Yes
FARINVA_BANK_CODE FARINVA_BANK_CODE VARCHAR2(2) Yes *
FARINVA_INVD_AMT FARINVA_INVD_AMT NUMBER(12,2) Yes
FARINVA_DISC_AMT FARINVA_DISC_AMT NUMBER(12,2) Yes
FARINVA_TAX_AMT FARINVA_TAX_AMT NUMBER(12,2) Yes
FARINVA_ADDL_CHRG_AMT FARINVA_ADDL_CHRG_AMT NUMBER(12,2) Yes
FARINVA_APPR_AMT FARINVA_APPR_AMT NUMBER(12,2) Yes
FARINVA_PREV_PAID_AMT FARINVA_PREV_PAID_AMT NUMBER(12,2) Yes
FARINVA_NSF_OVERRIDE_IND FARINVA_NSF_OVERRIDE_IND VARCHAR2(1) Yes
FARINVA_ITYP_SEQ_CODE FARINVA_ITYP_SEQ_CODE NUMBER(2,0) Yes
FARINVA_PROJ_CODE FARINVA_PROJ_CODE VARCHAR2(8) Yes
FARINVA_SUSP_IND FARINVA_SUSP_IND VARCHAR2(1) No
FARINVA_NSF_SUSP_IND FARINVA_NSF_SUSP_IND VARCHAR2(1) No
FARINVA_PARTIAL_LIQ_IND FARINVA_PARTIAL_LIQ_IND VARCHAR2(1) Yes
FARINVA_APPR_IND FARINVA_APPR_IND VARCHAR2(1) Yes
FARINVA_OPEN_PAID_IND FARINVA_OPEN_PAID_IND VARCHAR2(1) Yes
FARINVA_CONVERT_AMT FARINVA_CONVERT_AMT NUMBER(12,2) Yes
FARINVA_CONVERT_DISC_AMT FARINVA_CONVERT_DISC_AMT NUMBER(12,2) Yes
FARINVA_CONVERT_TAX_AMT FARINVA_CONVERT_TAX_AMT NUMBER(12,2) Yes
FARINVA_CONVERT_ADDL_CHRG_AMT FARINVA_CONVERT_ADDL_CHRG_AMT NUMBER(12,2) Yes
FARINVA_APPR_AMT_PCT FARINVA_APPR_AMT_PCT NUMBER(7,4) Yes
FARINVA_DISC_AMT_PCT FARINVA_DISC_AMT_PCT NUMBER(7,4) Yes
FARINVA_ADDL_AMT_PCT FARINVA_ADDL_AMT_PCT NUMBER(7,4) Yes
FARINVA_TAX_AMT_PCT FARINVA_TAX_AMT_PCT NUMBER(7,4) Yes
FARINVA_CAP_AMT FARINVA_CAP_AMT NUMBER(12,2) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
FARINVA_INVH_CODE FARINVC_INVH_CODE FARINVC
FARINVA_ITEM FARINVC_ITEM FARINVC
FARINVA_INVH_CODE FABINCK_INVH_CODE FABINCK
FARINVA_INVH_CODE FABINVH_CODE FABINVH
FARINVA_COAS_CODE FTVCOAS_COAS_CODE FTVCOAS
FARINVA_COAS_CODE FTVFUND_COAS_CODE FTVFUND
FARINVA_FUND_CODE FTVFUND_FUND_CODE FTVFUND
FARINVA_COAS_CODE FTVACCT_COAS_CODE FTVACCT
FARINVA_ACCT_CODE FTVACCT_ACCT_CODE FTVACCT
FARINVA_BANK_CODE GXVBANK_BANK_CODE GXVBANK

Index

Index Name Index Type Column Name
FARINVA_CTRL_INDEX FARINVA_COAS_CODE
FARINVA_CTRL_INDEX FARINVA_FSYR_CODE
FARINVA_CTRL_INDEX FARINVA_OPEN_PAID_IND
FARINVA_CTRL_INDEX FARINVA_ACTIVITY_DATE
FARINVA_FOAPAL_INDEX FARINVA_COAS_CODE
FARINVA_FOAPAL_INDEX FARINVA_FUND_CODE
FARINVA_FOAPAL_INDEX FARINVA_ACCT_CODE
FARINVA_FOAPAL_INDEX FARINVA_ORGN_CODE
FARINVA_FOAPAL_INDEX FARINVA_PROG_CODE
FARINVA_KEY_INDEX Unique FARINVA_INVH_CODE
FARINVA_KEY_INDEX Unique FARINVA_ITEM
FARINVA_KEY_INDEX Unique FARINVA_SEQ_NUM

Comments

Source Code Comments

Invoice Accounting Table

Columns Comments for FARINVA_INVH_CODE (1)

Source Code Comments

DOCUMENT: The unique number of the document being updated.

Columns Comments for FARINVA_POHD_CODE (2)

Source Code Comments

PURHCASE ORDER CODE: The user-defined purchase order number issued to this vendor.

Columns Comments for FARINVA_ITEM (3)

Source Code Comments

ITEM NUMBER: The literal commodity or goods description associated with an invoice processing record. The unique sequence number directly associated an item on the commodity record.

Columns Comments for FARINVA_PO_ITEM (4)

Source Code Comments

PURCHASE ORDER ITEM: The sequence number of the commodity on the purchase order.

Columns Comments for FARINVA_SEQ_NUM (5)

Source Code Comments

SEQUENCE NUMBER: A system generated sequence number relating to transactions within a document.

Columns Comments for FARINVA_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for FARINVA_USER_ID (7)

Source Code Comments

USER IDENTIFICATION: The unique identification code of the user.

Columns Comments for FARINVA_FSYR_CODE (8)

Source Code Comments

FISCAL YEAR: A unique two digit numeric identifier code for the fiscal year being defined. Generally the last two digits of the second year of the accounting period are used.

Columns Comments for FARINVA_PERIOD (9)

Source Code Comments

PERIOD: Refers to a period within a fiscal year.

Columns Comments for FARINVA_EOY_ACCR_STATUS_IND (10)

Source Code Comments

END OF YEAR ACCRUAL: Refers to the accounting period's ability to post activity. Value choices for the accrual period are O-open, N-not open, or closed.

Columns Comments for FARINVA_RUCL_CODE (11)

Source Code Comments

RULE CLASS CODE: The four character alpha/numeric code identifying an accounting transaction rule class.

Columns Comments for FARINVA_DISC_RUCL_CODE (12)

Source Code Comments

DISCOUNT RULE CLASS CODE: The Rule Class Code which is used for posting discounts to the ledgers.

Columns Comments for FARINVA_TAX_RUCL_CODE (13)

Source Code Comments

TAX RULE CLASS CODE: The Rule Class Code for posting the accounting event for taxes.

Columns Comments for FARINVA_ADDL_RUCL_CODE (14)

Source Code Comments

ADDITIONAL RULE CLASS CODE: The Rule Class Code which will be used to post the additional charges as a result of purchasing and account payable activity.

Columns Comments for FARINVA_COAS_CODE (15)

Source Code Comments

CHART OF ACCOUNTS CODE: The primary identification code for any chart of accounts which is used to uniquely identify that chart from any other in a multi-chart environment.

Columns Comments for FARINVA_ACCI_CODE (16)

Source Code Comments

ACCOUNT INDEX CODE: The user-defined value representing a summerization of any combination of user-defined FOAPAL elements.

Columns Comments for FARINVA_FUND_CODE (17)

Source Code Comments

FUND CODE: Identifies the fund code that appears on a transaction.

Columns Comments for FARINVA_ORGN_CODE (18)

Source Code Comments

ORGANIZATION CODE: Identifies the organization code that appears on a transaction.

Columns Comments for FARINVA_ACCT_CODE (19)

Source Code Comments

ACCOUNT CODE: The user defined value representing an account.

Columns Comments for FARINVA_PROG_CODE (20)

Source Code Comments

PROGRAM CODE: The user-defined value to the program classification structure code or a subset or that structure as defined by the National Council of Higher Education Management Systems.

Columns Comments for FARINVA_ACTV_CODE (21)

Source Code Comments

ACTIVITY CODE: The activity that is primarily associated with this organization.

Columns Comments for FARINVA_LOCN_CODE (22)

Source Code Comments

LOCATION CODE: The physical location of the installment's financial manager. For i.e., Vice President, Suite 10, Adams Hall, Main Campus. Refer to FTVLOCN.

Columns Comments for FARINVA_BANK_CODE (23)

Source Code Comments

BANK CODE: A user-defined value that is used for identification purposes on cash transactions. All bank codes and other attributes are displayed on form FTMBANK.

Columns Comments for FARINVA_INVD_AMT (24)

Source Code Comments

INVOICE AMOUNT: The dollar amount invoiced by the vendor.

Columns Comments for FARINVA_DISC_AMT (25)

Source Code Comments

DISCOUNT AMOUNT: The dollar value of the discount being taken on the invoice.

Columns Comments for FARINVA_TAX_AMT (26)

Source Code Comments

TAX AMOUNT: The dollar value of the sales/use tax being charged on this invoice.

Columns Comments for FARINVA_ADDL_CHRG_AMT (27)

Source Code Comments

ADDITIONAL CHARGE AMOUNT: The dollar value of any additional charges associated with this invoice.

Columns Comments for FARINVA_APPR_AMT (28)

Source Code Comments

APPROVAL AMOUNT: The dollar value of the payment.

Columns Comments for FARINVA_PREV_PAID_AMT (29)

Source Code Comments

PREVIOUSLY PAID AMOUNT: The amount previously paid on an invoice.

Columns Comments for FARINVA_NSF_OVERRIDE_IND (30)

Source Code Comments

INSUFFICIENT FUNDS OVERRIDE INDICATOR: This indicator permits authorized users to by-pass funding deficiencies.

Columns Comments for FARINVA_ITYP_SEQ_CODE (31)

Source Code Comments

INTERNAL SEQUENCE CODE: Internal, pre-defined sequence number which designates which activity should be updated on the Operating Ledger (OPAL).

Columns Comments for FARINVA_PROJ_CODE (32)

Source Code Comments

PROJECT CODE: A unique code which identifies a cost accounting project.

Columns Comments for FARINVA_SUSP_IND (33)

Source Code Comments

SUSPENSE INDICATOR: An indicator which informs the user that a document is being held in suspense due to missing or erroneous data content.

Columns Comments for FARINVA_NSF_SUSP_IND (34)

Source Code Comments

NONSUFFICIENT FUNDS SUSPENSE INDICATOR: An indicator which informs the user that a transaction has been suspended due to lack of budget.

Columns Comments for FARINVA_PARTIAL_LIQ_IND (35)

Source Code Comments

PARTIAL LIQUIDATION INDICATOR: A one character field indicating whether an invoice is partially or totally liquidating an encumbrance.

Columns Comments for FARINVA_APPR_IND (36)

Source Code Comments

APPROVAL INDICATOR: Indicates if the document has been approved for processing by the individual authorized to approve the document.

Columns Comments for FARINVA_OPEN_PAID_IND (37)

Source Code Comments

OPEN PAID INDICATOR: The indicator that a document is open or paid.

Columns Comments for FARINVA_CONVERT_AMT (38)

Source Code Comments

CONVERTED AMOUNT: The base amount calculated for this accounting record. Used when a currency code is established at the header record.

Columns Comments for FARINVA_CONVERT_DISC_AMT (39)

Source Code Comments

CONVERTED DISCOUNT AMOUNT: The base discount amount calculated for this accounting record. Used when a currency code is established at the header record.

Columns Comments for FARINVA_CONVERT_TAX_AMT (40)

Source Code Comments

CONVERTED TAX AMOUNT: The base tax amount calculated fo