Element | Element Name | Table or File | SQL or Focus |
---|---|---|---|
VB003 | BATCH KEY | VBFILE | BATCH_ID |
VB004 | BATCH REFERENCE | VBFILE | BATCH_REF |
VB019 | BATCH DATE | VBFILE | BATCH_DT |
VB020 | BATCH DATE-6 | VBFILE | BATCH_DT_6 |
VB021 | BATCH YEAR | VBFILE | BATCH_YY |
VB022 | BATCH MONTH | VBFILE | BATCH_MM |
VB023 | BATCH DAY | VBFILE | BATCH_DD |
VB030 | DROP FLAG | VBFILE | DROP_FLAG |
VB031 | CPU DATE | VBFILE | CPU_DT |
VB032 | CPU DATE-6 | VBFILE | CPU_DT_6 |
VB033 | CPU YEAR | VBFILE | CPU_YY |
VB034 | CPU MONTH | VBFILE | CPU_MM |
VB035 | CPU DAY | VBFILE | CPU_DD |
VB040 | BATCH DOLLAR | VBFILE | BATCH_AMT |
VB042 | BATCH COUNT | VBFILE | BATCH_COUNT |
VB044 | DESCRIPTION | VBFILE | BATCH_DESC |
VB048 | SYSTEM FLAGS | VBFILE | SYSTEM_FLAGS |
VB050 | HOLD FLAG | VBFILE | HOLD_FLAG |
VB052 | ACCOUNTING FEED FLAG | VBFILE | FA_FEED_FLAG |
VB054 | VOUCHER FLAG | VBFILE | VOUCHER_FEED_FLAG |
VB056 | ACCEPT OUT-OF-BAL FG | VBFILE | ACCEPT_OUT_OF_BAL |
VB058 | LIST TRANSACTIONS | VBFILE | LIST_BATCH |
VB070 | PROCESSED AMOUNT | VBFILE | PROC_AMT |
VB072 | PROCESSED COUNT | VBFILE | PROC_COUNT |
VB074 | REJECTED COUNT | VBFILE | REJECT_CNT |
VB076 | BANK NUMBER | VBFILE | BANK_NUM |
VB078 | TEMP NUMBER | VBFILE | TEMP_VENDOR_NUM |
VB080 | FISCAL YEAR | VBFILE | FISCAL_YR |
VB082 | CAMPUS CODE | VBFILE | CAMPUS_CODE |
VB086 | BATCH TRAN SEQ COUNT | VBFILE | TRANS_COUNT |
VB103 | DISCOUNT KEY | VBFILE | DISC_KEY |
VB105 | DISCOUNT TABLE | VBFILE | DISC_TABLE |
VB106 | DISCOUNT CODE | VBFILE | DISC_CODE |
VB110 | DISCOUNT DROP FLAG | VBFILE | DROP_FLAG |
VB112 | DISCOUNT PERCENT | VBFILE | DISC_PERCENT |
VB114 | DISCOUNT DAYS | VBFILE | DISC_DAYS |
VB203 | TAX/CURR KEY | VBFILE | TAX_CURR_KEY |
VB205 | TC TABLE TYPE | VBFILE | TABLE_TYPE |
VB206 | TC TABLE CODE | VBFILE | TAX_CODE |
VB210 | TC DROP FLAG | VBFILE | DROP_FLAG |
VB212 | TC PERCENT | VBFILE | TAX_PERCENT |
VB213 | TC ACCOUNT | VBFILE | TAX_ACCOUNT_NUM |
VB214 | TC ACCT DIGIT 1 | VBFILE | ACCOUNT_DIGIT_1 |
VB233 | TAX/CURR KEY | VBFILE | TAX_CURR_KEY |
VB235 | TC TABLE TYPE | VBFILE | TABLE_TYPE |
VB236 | TC TABLE CODE | VBFILE | TABLE_CODE |
VB238 | TC TAX TABLE CODE | VBFILE | TAX_CODE |
VB240 | TC DROP FLAG | VBFILE | DROP_FLAG |
VB242 | TC PERCENT | VBFILE | TAX_PERCENT |
VB245 | TC ACCOUNT CC | VBFILE | TAX_CAMPUS_CODE |
VB247 | TC ACCOUNT | VBFILE | TAX_ACCOUNT_NUM |
VB248 | TC ACCT DIGIT 1 | VBFILE | ACCOUNT_DIGIT_1 |
VB249 | TC TAX CAP | VBFILE | TAX_CAP |
VB250 | TC DESCRIPTION | VBFILE | TAX_DESC |
VB403 | POT KEY | VBFILE | PO_TYPE_KEY |
VB406 | POT TABLE | VBFILE | PO_TYPE_TBL |
VB408 | POT TYPE | VBFILE | PO_TYPE |
VB410 | POT DROP FLAG | VBFILE | DROP_FLAG |
VB430 | POT THREE-WAY MATCH | VBFILE | THREE_WAY_MATCH |
VB432 | POT ENCUMBRANCE FEED | VBFILE | FEED_ENCUMB |
VB434 | POT REQUISITION FEED | VBFILE | FEED_REQUISITION |
VB436 | POT AUTHORIZATION CH | VBFILE | CHECK_AUTH_ID |
VB438 | POT ACCOUNT VERIFY | VBFILE | CHECK_ACCOUNT_NUM |
VB440 | POT BUDGET CHECK | VBFILE | CHECK_BBA |
VB442 | POT FOREIGN CURRENCY | VBFILE | CURRENCY_ALLOWED |
VB444 | POT COMMODITY CHECK | VBFILE | CHECK_COMMODITY |
VB446 | UNIT PRICE THRESHOLD | VBFILE | UNIT_PRICE_CTL |
VB448 | EXT PRICE THRESHOLD | VBFILE | EXTEND_PRICE_CTL |
VB450 | ABOVE UNIT PRICE % | VBFILE | UP_ABOVE_PERCENT |
VB452 | BELOW UNIT PRICE % | VBFILE | UP_BELOW_PERCENT |
VB454 | ABOVE QUANTITY % | VBFILE | QTY_ABOVE_PERCENT |
VB456 | BELOW QUANTITY % | VBFILE | QTY_BELOW_PERCENT |
VB458 | ABOVE EXT PRICE % | VBFILE | XP_ABOVE_PERCENT |
VB460 | BELOW EXT PRICE % | VBFILE | XP_BELOW_PERCENT |
VB462 | ABOVE EXT LINE CAP | VBFILE | ABOVE_CAP |
VB464 | BELOW EXT LINE CAP | VBFILE | BELOW_CAP |
VB466 | POT ACCOUNT SECURITY | VBFILE | CHECK_SECURITY |
VB803 | CR KEY | VBFILE | CR_KEY |
VB806 | CR ONE | VBFILE | CR_ONE |
VB810 | CR DROP FLAG | VBFILE | DROP_FLAG |
VB812 | NEXT TEMP VENDOR # | VBFILE | NEXT_VENDOR_NUM |
VB814 | NEXT AUTO VENDOR # | VBFILE | NEXT_AUTO_VEND_NUM |
VB816 | NEXT AUTO PO # | VBFILE | NEXT_AUTO_NUM |
VB818 | NEXT AUTO VOUCHER # | VBFILE | NEXT_AUTO_VCHR_NUM |
VB820 | NEXT AUTO REQUIS # | VBFILE | NEXT_AUTO_REQ_NUM |
VB826 | INSTITUTION CURRENCY | VBFILE | LOCAL_CURRENCY |
VB828 | ACCOUNT VERIFY SWITC | VBFILE | CHECK_ACCOUNT_NUM |
VB830 | BUDGET BALANCE SWITC | VBFILE | CHECK_BBA |
VB832 | AUTHORIZATION SWITCH | VBFILE | CHECK_AUTH_ID |
VB834 | ENCUMB FEED SWITCH | VBFILE | FEED_ENCUMB |
VB836 | REQUISITION FEED SWI | VBFILE | FEED_REQUISITION |
VB838 | COMMODITY CODE SWITC | VBFILE | CHECK_COMMODITY |
VB839 | VALID EXPENSE BEGIN | VBFILE | FIRST_EXPENSE_CODE |
VB840 | SYSTEM CONTROL DESC | VBFILE | SYSTEM_DESC |
VB850 | BID MODULE SWITCH | VBFILE | CHECK_BID |
VB852 | REQ APPROVAL SWITCH | VBFILE | REQ_APRVL_SW |
VB854 | PO APPROVAL SWITCH | VBFILE | PO_APRVL |
VB856 | PO TAX MODULE | VBFILE | CHECK_TAX |
VB903 | CR KEY | VBFILE | CR_KEY |
VB906 | CR TWO | VBFILE | CR_TWO |
VB910 | CR DROP FLAG | VBFILE | DROP_FLAG |
VB912 | CUR YR FA BAT REF | VBFILE | CURR_FA_BATCH |
VB913 | CUR YR FA REF-ALPHA | VBFILE | CURR_FA_BATCH |
VB914 | CUR YR FA REF-NUMBER | VBFILE | CURR_FA_BATCH |
VB916 | FUT YR FA BAT REF | VBFILE | FUTURE_YR_FA_BATCH |
VB917 | FUT YR FA REF-ALPHA | VBFILE | FUTURE_YR_FA_BATCH |
VB918 | FUT YR FA REF-NUMBER | VBFILE | FUTURE_YR_FA_BATCH |
VB920 | PO TO AP BAT REF | VBFILE | CURR_AP_BATCH |
VB921 | PO TO AP REF-ALPHA | VBFILE | TO_AP_REF_ALPHA |
VB922 | PO TO AP REF-NUMBER | VBFILE | TO_AP_REF_NUM |
VB924 | CURRENT FISCAL YEAR | VBFILE | CURR_FISCAL_YR |
VB926 | FIRST MONTH OF FISYR | VBFILE | FIRST_MONTH_FY |
VB928 | CURRENT FY END 2ND | VBFILE | CURR_FISCAL_YR_2 |
VB930 | FIRST MONTH FY 2ND | VBFILE | FIRST_MONTH_FY |
VB932 | VALUE BASED SECURITY | VBFILE | CHECK_VBS |
VB934 | WORD WRAP SW | VBFILE | WORD_WRAP_SW |
VB936 | ONLINE CHECK TYPE | VBFILE | ONLINE_CK_TYPE |
VB938 | CHECK ADJ HORIZ DIR | VBFILE | CHECK_ADJ_HORIZ_DI |
VB940 | CHECK ADJ HORIZ INC | VBFILE | CHECK_ADJ_HORIZ_IN |
VB942 | CHECK ADJ VERT DIR | VBFILE | CHECK_ADJ_VERT_DIR |
VB944 | CHECK ADJ VERT INC | VBFILE | CHECK_ADJ_VERT_INC |
VB946 | INVOICE FY IND | VBFILE | INVOICE_FY_IND |
VB948 | PR PRINTER TYPE | VBFILE | PR_PRINTER_TYPE |
©2000 All Rights Reserved