(local) FrontOff Tables dbo.Abrv dbo.ALRT dbo.ALRT_ASSGN dbo.ALRT_PROFILE_LNK dbo.ALRT_TRAN dbo.ALRT_TRGTS dbo.AMessages dbo.AppProfiles dbo.AppUserGroups dbo.AppUserProfiles dbo.AppUsers dbo.APPUSERS_MODULES dbo.AppUsersAudit dbo.AR_ACCT dbo.AUDIT dbo.AUDIT_DETAIL dbo.BAD_ACCT dbo.BAD_ACCT_ENH dbo.BANK dbo.BARCOD_DEF dbo.BARCODE_TYPES dbo.BASECTL dbo.BASKET_ANALYSIS dbo.BIN_DATA dbo.CARD dbo.CASHR_CHKBANK_ASSGN dbo.CDM_FILTER dbo.CDM_FILTER_LINES dbo.CDM_FILTER_USER dbo.CDM_LOG dbo.CDV dbo.CHKOUT_BNK dbo.CHKOUT_BNK_OPEN_LOAN dbo.CLB_CRD_SCHM dbo.CNTRL_CHCK dbo.COMUNTY_PRTNR dbo.Controls dbo.COST_PLUS dbo.COUPON dbo.CPN_PRN_MAINT dbo.CPN_PRT dbo.CPN_PRT_LINE dbo.CPN_VAL_CODE dbo.CRD_RNG dbo.CRD_VLD dbo.CRDT_PROG dbo.CTRL_CLASS dbo.CTRLS dbo.CUR_AR_DATA dbo.CUR_BASKET dbo.CUR_BOOK_KEEPING dbo.CUR_CHCK dbo.CUR_CHKBANK_PLU dbo.CUR_CONTROL dbo.CUR_CONTROL_DISCOUNT dbo.CUR_CONTROL_RTN_TYPE dbo.CUR_CONTROL_TAX dbo.CUR_DEP_DTL_SALES dbo.CUR_DEP_GRP_SALES dbo.CUR_DEP_HRLY_PRDCTVTY dbo.CUR_DEP_SALES dbo.CUR_EBT_WIC_CLAIM dbo.CUR_ECCA_SALES dbo.CUR_EMP_DATA dbo.CUR_EMP_DEP dbo.CUR_EMP_MEDIA dbo.CUR_EMP_TAX dbo.CUR_EWIC_DATA dbo.CUR_FUEL_PAP_LOGGING dbo.CUR_FUEL_SALES dbo.CUR_FUEL_TOT_SALES dbo.CUR_FUEL_TOT_TRANS_PUMP dbo.CUR_FUEL_VAL_TRANS_PUMP dbo.CUR_GRD_PRC_CHG dbo.CUR_HRLY_PRDCTVTY dbo.CUR_IMAGES dbo.CUR_MEDIA_SALES dbo.CUR_PLU_ONSALE dbo.CUR_PLU_SALES dbo.CUR_PLU_SALES_DELETED dbo.CUR_POS_SALES dbo.CUR_POST_DEC_TRS dbo.CUR_PROM_SALES dbo.CUR_REFUNDS dbo.CUR_SAVED_TRS dbo.CUR_SIGN_ON dbo.CUR_TANK_MON dbo.CUR_TER_DATA dbo.CUR_TER_DEP dbo.CUR_TER_MEDIA dbo.CUR_TER_PRDCTVTY_MEDIA dbo.CUR_TER_PRDCTVTY_SALES dbo.CUR_TER_Q_LEN dbo.CUR_TER_TAX dbo.CUR_TRAIN_EMP_DATA dbo.CUR_TRAIN_TER_DATA dbo.CUR_TTL dbo.CUR_VOIDS dbo.CUST_SURV_LNKD dbo.CUST_SURV_QST dbo.DAY_AR_DATA dbo.DAY_BASKET dbo.DAY_BOOK_KEEPING dbo.DAY_CHCK dbo.DAY_CHKBANK_PLU dbo.DAY_CONTROL dbo.DAY_CONTROL_DISCOUNT dbo.DAY_CONTROL_RTN_TYPE dbo.DAY_CONTROL_TAX dbo.DAY_DEP_DTL_SALES dbo.DAY_DEP_GRP_SALES dbo.DAY_DEP_HRLY_PRDCTVTY dbo.DAY_DEP_SALES dbo.DAY_DEP_TAX dbo.DAY_EBT_WIC_CLAIM dbo.DAY_ECCA_SALES dbo.DAY_EMP_DATA dbo.DAY_EMP_DEP dbo.DAY_EMP_MEDIA dbo.DAY_EMP_TAX dbo.DAY_EWIC_DATA dbo.DAY_FUEL_PAP_LOGGING dbo.DAY_FUEL_SALES dbo.DAY_FUEL_TOT_SALES dbo.DAY_FUEL_TOT_TRANS_PUMP dbo.DAY_FUEL_VAL_TRANS_PUMP dbo.DAY_GRD_PRC_CHG dbo.DAY_HRLY_PRDCTVTY dbo.DAY_IMAGES dbo.DAY_MEDIA_SALES dbo.DAY_PLU_ONSALE dbo.DAY_PLU_SALES dbo.DAY_PLU_SALES_DELETED dbo.DAY_POS_SALES dbo.DAY_POST_DEC_TRS dbo.DAY_PROM_SALES dbo.DAY_REFUNDS dbo.DAY_SAVED_TRS dbo.DAY_SIGN_ON dbo.DAY_SUB_DEP_SALES dbo.DAY_TANK_MON dbo.DAY_TER_DATA dbo.DAY_TER_DEP dbo.DAY_TER_MEDIA dbo.DAY_TER_PRDCTVTY_MEDIA dbo.DAY_TER_PRDCTVTY_SALES dbo.DAY_TER_Q_LEN dbo.DAY_TER_TAX dbo.DAY_trs_birthday_0x600x03 dbo.DAY_trs_book_plu_sale_0x600xD4 dbo.DAY_trs_coupon_0x08 dbo.DAY_trs_customer_survey_0x600x5E dbo.DAY_trs_dep_sale_0x02 dbo.DAY_trs_discount_0x03 dbo.DAY_trs_gift_card_act_0x600x7B dbo.DAY_trs_media_0x04 dbo.DAY_trs_plu_extended_0x11 dbo.DAY_trs_plu_nonfnd_0x600x01 dbo.DAY_trs_plu_sale_0x01 dbo.DAY_trs_price_override_0x600x14 dbo.DAY_trs_ticket_frame_0x21 dbo.DAY_trs_ticket_tax_0x06 dbo.DAY_trs_ticket_total_0x05 dbo.DAY_trs_times_0x0A dbo.DAY_VOIDS dbo.DDExclude dbo.DDFields dbo.DDObjects dbo.DDObjLog dbo.DDTables dbo.DEA_GRP dbo.DENOM dbo.DEP dbo.DEP_BUDGET dbo.DEP_GROUP dbo.DEPOSIT dbo.DISCOUNT dbo.DYNAMIC_ITM_ATTRIB dbo.DYNAMIC_ITM_ATTRIB_VAL dbo.E_TICKET dbo.EBT_WIC_APL dbo.EBT_WIC_CTGR dbo.EBT_WIC_HCL dbo.EBT_WIC_LNK dbo.EBT_WIC_RECONCILIATION dbo.EBT_WIC_RSN_CODE dbo.EBT_WIC_STATES dbo.ECCA dbo.EMAIL_SEND dbo.EMP dbo.ENTITY_TYPE dbo.EOD_AUTO_TIMES dbo.EOD_ERR_TITLE dbo.EOD_EXP_DATE dbo.EOD_PLU_BCK dbo.EOD_PROGRESS dbo.EXCISE_TAX dbo.FNCL_CLND dbo.FNCL_CLND_WEEKS dbo.FORM_MODULES dbo.FORMS dbo.FUEL_LCP dbo.FUEL_PRODUCT_CODES dbo.FUEL_PRODUCT_CODES_LNKD dbo.FuelAlliedConvertLayer dbo.FuelBrands dbo.FuelCarWash dbo.FuelDatabase dbo.FuelFldTypeRgs dbo.FuelFldTypeSql dbo.FuelGeneralParam dbo.FuelGrades dbo.FuelMaint dbo.FuelMaintHeader dbo.FuelMessages dbo.FuelModes dbo.FuelModeScheme dbo.FuelPosition dbo.FuelPumps dbo.FuelPureProducts dbo.FuelReceipt dbo.FuelSaleModeLinks dbo.FuelTanks dbo.GEN_BTCH_AR_ACCT dbo.GEN_BTCH_BAD_ACCT dbo.GEN_BTCH_BAD_ACCT_ENH dbo.GEN_BTCH_CRDT_PROG dbo.GEN_BTCH_DEP dbo.GEN_BTCH_DYNAMIC_ITM_ATTRIB dbo.GEN_BTCH_DYNAMIC_ITM_ATTRIB_VAL dbo.GEN_BTCH_EBT_WIC_LNK dbo.GEN_BTCH_ERROR dbo.GEN_BTCH_FuelGrades dbo.GEN_BTCH_HDR dbo.GEN_BTCH_LINKED_ITEMS_DTL dbo.GEN_BTCH_LINKED_ITEMS_HDR dbo.GEN_BTCH_LNKD_DYNAMIC_ATTRIB dbo.GEN_BTCH_LOYAL_CUST dbo.GEN_BTCH_LOYALTY_MMBR_PROM dbo.GEN_BTCH_LOYALTY_MMBR_PROM_CHKOUT_BNK dbo.GEN_BTCH_LOYALTY_MMBR_PROM_LNKD dbo.GEN_BTCH_LOYALTY_MMBR_PROM_REWARD_LEVELS dbo.GEN_BTCH_LOYALTY_MMBR_PROM_REWARD_LEVELS_CONDTION dbo.GEN_BTCH_MMBR_ACCT dbo.GEN_BTCH_MMBR_PROM dbo.GEN_BTCH_MMBR_PROM_CHKOUT_BNK dbo.GEN_BTCH_MMBR_PROM_LNKD dbo.GEN_BTCH_OBJ_SECURITY dbo.GEN_BTCH_PLU_GROUP dbo.GEN_BTCH_PLU_PRICES dbo.GEN_BTCH_PRICE_LIST dbo.GEN_BTCH_SEGMENTS dbo.GEN_BTCH_SUB_DEP dbo.GEN_BTCH_TYPE dbo.GenBatchFiles dbo.GenBatchInput dbo.GenBatchValid dbo.GRD_PRC_CHG_LOG dbo.HEADER_FOOTER dbo.HEADER_FOOTER_LINES dbo.HIERARCHY dbo.INSPECTION_TASKS dbo.INTEGRITY dbo.KBD_FUNC dbo.Languages dbo.LINKED_ITEMS_DTL dbo.LINKED_ITEMS_HDR dbo.LNKD_DYNAMIC_ATTRIB dbo.LOAN_PICKUP dbo.LOG_REF dbo.LOGO dbo.LOYAL_CUST dbo.LOYALTY_DYNAMIC_ITM_ATTRIB dbo.LOYALTY_DYNAMIC_ITM_ATTRIB_VAL dbo.LOYALTY_MMBR_PROM dbo.LOYALTY_MMBR_PROM_CHKOUT_BNK dbo.LOYALTY_MMBR_PROM_LNKD dbo.LOYALTY_MMBR_PROM_REWARD_LEVELS dbo.LOYALTY_MMBR_PROM_REWARD_LEVELS_CONDTION dbo.MAIN_SORT_ITEMS dbo.Maint dbo.MaintBuff dbo.MaintHeader dbo.MEDIA dbo.MEDIA_GROUP dbo.MenuObject dbo.MenuObjectChilds dbo.MenuObjectStrings dbo.MMBR_ACCT dbo.MMBR_CRD dbo.MMBR_PROM dbo.MMBR_PROM_CHKOUT_BNK dbo.MMBR_PROM_LNKD dbo.MODIFIED_TRACK dbo.MODULES dbo.MONTH_PLU_SALES dbo.MSG_CNTR dbo.MSG_QUE dbo.MsgAttrb dbo.MsgStyle dbo.MsgValue dbo.MULTIPLE_STAMP_SCHEMES dbo.OBJ_SECURITY dbo.OBJECT_DATA_MAP dbo.OBJECT_DATA_PRPRTY_MAP dbo.ObjectStrings dbo.OFFER dbo.PAID_RCPT dbo.PAID_RCPT_ENH dbo.PAID_ROA dbo.PAID_ROA_ENH dbo.PCinSystem dbo.PCMOPEN_LIST dbo.PersonalMenuObject dbo.PLU dbo.PLU_BTCH dbo.PLU_BTCH_ITM dbo.PLU_BTCH_VER dbo.PLU_BULK_TAX_GRP dbo.PLU_CTG dbo.PLU_CTG_FLD dbo.PLU_DYNAMIC_ATTRIB dbo.PLU_FLTR dbo.PLU_FLTR_CTG dbo.PLU_FLTR_VAL dbo.PLU_GROUP dbo.PLU_GROUP_ITEMS dbo.PLU_MASTER_ERROR dbo.PLU_MIXMATCH dbo.PLU_NOT_FOUND dbo.PLU_PRC_RSN dbo.PLU_PRICES dbo.PLU_RPT_ENV dbo.PLU_SALES_LOG dbo.POS_24HR_EOD_STATUS dbo.POS_EOD_LIST dbo.POS_GT dbo.POS_MENU dbo.POS_MENU_LINES dbo.POST_CFG dbo.POST_CHK_BANK dbo.POST_EMAIL dbo.POST_ITM_MSG dbo.PRC_GRP dbo.PRICE_LIST dbo.PROJECTS dbo.PROM_HDR dbo.PROM_ITEM dbo.Q_BUSTER dbo.QDX_FILE_CHECKSUM dbo.QdxType dbo.QueryCollection dbo.rdoTypes dbo.RecoveryHeader dbo.RecoveryProgress dbo.ReportArchive dbo.ReportAttributes dbo.ReportDetail dbo.ReportJobCommands dbo.ReportParameter dbo.ReportParamValues dbo.ReportSchedule dbo.ReportSource dbo.ReportStrings dbo.ReportType dbo.RPT_CTGR dbo.RPT_CTGR_OPT dbo.RPT_DEP_HR dbo.RPT_HSTR dbo.RPT_PLU_HR dbo.RPT_TYPES dbo.RSTRCT_SLS dbo.RTN_TYPE dbo.SAFE dbo.SAFE_DATA dbo.SAFE_DEF dbo.SAFE_TRANS dbo.SAFE_TRANSFER dbo.SAFE_TRANSFER_LINK dbo.SAVE_DEPOSIT dbo.SAVE_EMP_DATA dbo.SAVE_EMP_MEDIA dbo.SAVE_LOAN_PICKUP dbo.SAVE_PAID_ROA dbo.SAVE_PAID_ROA_ENH dbo.SAVE_POS_GT dbo.SAVE_SAFE dbo.SAVE_SAFE_DATA dbo.SAVE_SAFE_TRANS dbo.SAVE_SAFE_TRANSFER dbo.SAVE_TER_DATA dbo.SAVE_TER_MEDIA dbo.SECOND_SORT_ITEMS dbo.SEGMENTS dbo.SEGMENTS_PROM dbo.SHIFT_EMP_DATA dbo.SHIFT_EMP_MEDIA dbo.SHIFT_TER_DATA dbo.SHIFT_TER_MEDIA dbo.SPR_GRP dbo.SQLDataTypes dbo.STORE_PRM dbo.STORES dbo.STR_FULFIL dbo.Strings dbo.SUB_DEP dbo.SUB_DEP_RPT_ENV dbo.SUB_STORE dbo.SYS_PRM dbo.SYS_PRM_DEFAULT dbo.SysPrmStrings dbo.TARE_WGT dbo.TASKS dbo.TAX dbo.TBL_EXT dbo.TBL_EXT_FLD dbo.TER dbo.TICKET_DEP dbo.TMP_PLU_BTCH_ITM dbo.TMP_PLU_BTCH_ITM_STATUS dbo.TR_PR dbo.TRACE_LOG dbo.TRANS_IN_OUT dbo.TransDesc dbo.TransDescHeader dbo.TRS_TO_TBL_FIELDS dbo.TRS_TO_TBL_TRS_HEADERS dbo.UOM_PRICE_LOOKUP dbo.USER_ACCESS_LOG dbo.VER_DATA dbo.VER_FILES dbo.VER_STATUS dbo.VERSION dbo.WA_RPT_ENV dbo.WA_RPT_ENV_LNKD dbo.WA_RPT_FLD_SETUP dbo.WA_RPT_GRP_SETUP dbo.WA_RPT_MAN_TRANS_AUDIT dbo.WA_RPT_RPT_SETUP dbo.WA_RPT_STG dbo.WEEK_PLU_SALES dbo.WEEK_PLU_SALES_DELETED dbo.WICXLINK dbo.YEAR_PLU_SALES |  | [dbo].[MEDIA] Properties Columns Indexes Check Constraints Uses Used By Properties
Property | Value
--- | ---
Collation | SQL_Latin1_General_CP850_BIN
Row Count (~) | 0
Created | 9:42:49 AM Friday, April 11, 2003
Last Modified | 9:42:49 AM Friday, April 11, 2003
Columns
| Name | Data Type | Max Length (Bytes) | Allow Nulls | Default | Bound Default
--- | --- | --- | --- | --- | --- | ---
| TND_CD | smallint | 2 |  |  |
| CURR_ID | smallint | 2 |  |  |
| ACCEPT_FOR_SLS_FG | bit | 1 |  | (0) |
| CC_NBR | tinyint | 1 |  |  |
| TND_DESCR | varchar(16) | 16 |  |  |
| TND_GRP_ID | smallint | 2 |  |  |
| ACCEPT_FOR_RFND_FG | bit | 1 |  | (0) |
| AUTHORIZE_SLS_FG | bit | 1 |  | (0) |
| AUTHORIZE_RFND_FG | bit | 1 |  | (0) |
| LOAN_ALLOWED_FG | bit | 1 |  | (0) |
| AUTOMATIC_OPEN_LOAN_FG | bit | 1 |  | (0) |
| AMT_RQRD_FG | bit | 1 |  | (0) |
| ALLOW_MSR_FG | bit | 1 |  | (0) |
| ALLOW_MANUAL_FG | bit | 1 |  | (0) |
| LOCAL_CURRENCY_FG | bit | 1 |  | (0) |
| VALIDATE_FG | bit | 1 |  | (0) |
| TND_CNT_FG | bit | 1 |  | (0) |
| HOTLIST_FG | bit | 1 |  | (0) |
| FRANKING_RQRD_FG | bit | 1 |  | (0) |
| OPEN_DRAWER_OPT | tinyint | 1 |  |  |
| NEGOTIABLE_FG | bit | 1 |  | (0) |
| PRIM_CHANGE_TND | smallint | 2 |  |  |
| SERIAL_FG | bit | 1 |  | (0) |
| PRIM_CHANGE_THRESH | money | 8 |  |  |
| SEC_CHANGE_TND | smallint | 2 |  |  |
| MIN_AMT | money | 8 |  | (0) |
| OFFLINE_FLR_LMT | money | 8 |  |  |
| MAX_AMT | money | 8 |  |  |
| OVER_TND_AMT | money | 8 |  |  |
| MAX_RFND_AMT | money | 8 |  |  |
| FLOOR_AMT | money | 8 |  |  |
| AUTH_WAIT_DUR | smallint | 2 |  |  |
| SVR_CNCL_SBTRCT_FG | bit | 1 |  | (0) |
| CNCL_SBTRCT_INHBT_FG | bit | 1 |  | (0) |
| EXCH_FG | bit | 1 |  | (0) |
| ACCT_RQRD_FG | bit | 1 |  | (0) |
| RND_ALLOW_FG | bit | 1 |  | (0) |
| CDGT_RQRD_FG | bit | 1 |  | (0) |
| SIGN_RQRD_FG | bit | 1 |  | (0) |
| BANKABLE_ALLOWED_FG | bit | 1 |  | (0) |
| SVR_KEY_RQRD_FG | bit | 1 |  | (0) |
| PRNT_TMPLT_FG | bit | 1 |  | (0) |
| AUTHOR_RCPT_FG | bit | 1 |  | (0) |
| ST_CD_FG | bit | 1 |  | (0) |
| HIT_ENTR_FG | bit | 1 |  | (0) |
| FRGN_CHANGE_ALLOWED_FG | bit | 1 |  | (0) |
| ROA_PAIDOUT_ALLOWED_FG | bit | 1 |  | (0) |
| INVLD_PAY_FG | bit | 1 |  | (0) |
| VAL_NOT_RQRD_FOR_NEG_FG | bit | 1 |  | (0) |
| CRDT_DBT_OPT | [dbo].[DIGIT_ONE] | 1 |  |  | Zero
| ENDRSMT_TMPT_NBR | smallint | 2 |  |  |
| ENDRSMT_STRT_LINE | smallint | 2 |  |  |
| ENDRSMT_LINE_CNT | smallint | 2 |  |  |
| MUL_ENDRSMT_FG | bit | 1 |  | (0) |
| TMPT_NBR | tinyint | 1 |  |  |
| MCR_NBR | tinyint | 1 |  |  |
| ECA_TIMEOUT | smallint | 2 |  |  |
| ECA_FG | bit | 1 |  | (0) |
| ECA_LOG_FG | bit | 1 |  | (0) |
| AMOUNT_RQRD_CC | money | 8 |  |  |
| MAX_AMT_CC | tinyint | 1 |  |  |
| MIN_AMT_CC | tinyint | 1 |  |  |
| OVER_TND_CC | tinyint | 1 |  |  |
| FLOOR_AMT_CC | tinyint | 1 |  |  |
| DAILY_AMT_CC | tinyint | 1 |  |  |
| REPEAT_CC | tinyint | 1 |  |  |
| AUTH_CC | tinyint | 1 |  |  |
| REPCARD_CC | tinyint | 1 |  |  |
| RTLR_INFO | tinyint | 1 |  |  |
| LOAN_AMT | money | 8 |  |  |
| LOAN_AMT_CC | tinyint | 1 |  |  |
| MCR_TIMEOUT | smallint | 2 |  |  |
| MCR_MISREAD | tinyint | 1 |  |  |
| TND_CASH_EXCH_OPT | tinyint | 1 |  |  |
| CLR_AT_EOD_FG | bit | 1 |  | (0) |
| ECCA_FG | bit | 1 |  | (0) |
| USE_ENHNCE_HOTLIST_FG | bit | 1 |  | (0) |
| EFTPOS_FG | bit | 1 |  | (0) |
| CASH_IN_DRWR_CNT_FG | bit | 1 |  | (0) |
| TLL_CLRNCE_TYPE_OPT | tinyint | 1 |  |  |
| NON_DECLR_FG | bit | 1 |  | (0) |
| CARRY_OVER_FG | bit | 1 |  | (0) |
| ADD_FLOAT_ONLY_FG | bit | 1 |  | (0) |
| USE_CRD_RANGE_FG | bit | 1 |  | (0) |
| ECCA_TMPT_NO | tinyint | 1 |  |  |
| SCAN_BARCODE_AS_ACCT_OPT | tinyint | 1 |  |  |
| MPR_NBR | tinyint | 1 |  |  |
| POS_RPT_GRP_NO | tinyint | 1 |  |  |
| FEE_TABLE_NO | tinyint | 1 |  |  |
| FEE_TYPE_OPT | tinyint | 1 |  |  |
| SLCT_SUB_TND_FG | bit | 1 |  | (0) |
| DOC_MNL_BAL_FG | bit | 1 |  | (0) |
| CHK_RDR_IN_USE_FG | bit | 1 |  | (0) |
| PRST_AMT_OPT | tinyint | 1 |  |  |
| ACCT_NBR_LNGTH | tinyint | 1 |  |  |
| CDV_FRMLA_OPT | tinyint | 1 |  |  |
| VCHER_NBR_LNGTH | tinyint | 1 |  |  |
| CHK_FORMAT_OPT | tinyint | 1 |  |  |
| TND_TYP | tinyint | 1 |  |  |
| MICR_ACTIVE_FG | bit | 1 |  | (0) |
| MICR_ACCT_OPT | tinyint | 1 |  |  |
| EFT_DESC | varchar(16) | 16 |  |  |
| MPR_OPT | tinyint | 1 |  |  |
| ADDT_TND_INF_FG | bit | 1 |  | (0) |
| PRNT_RCPT_DENY_FG | bit | 1 |  | (0) |
| ACCT_OPT | tinyint | 1 |  |  |
| ACCT_PRMPT | varchar(16) | 16 |  |  |
| CURR_RATE | float | 8 |  |  |
| EFT_REP_GRP | tinyint | 1 |  |  |
| OVRTND_FG | bit | 1 |  | (0) |
| FRGN_CURR_FG | bit | 1 |  | (0) |
| DPST_ALLWED_FG | bit | 1 |  | (0) |
| PRT_DPST_VCHER_FG | bit | 1 |  | (0) |
| IMDT_BNK_FG | bit | 1 |  | (0) |
| SIGN_CHK_FG | bit | 1 |  | (0) |
| DOC_STRT_PRT_OFFSET | tinyint | 1 |  |  |
| DOC_PRT_SIZE | tinyint | 1 |  |  |
| MIN_DPST_VAL | money | 8 |  |  |
| MAX_DPST_VAL | money | 8 |  |  |
| MIN_DPST_CC | tinyint | 1 |  |  |
| MAX_DPST_CC | tinyint | 1 |  |  |
| MAX_TCKT_AMT | money | 8 |  |  |
| MAX_TCKT_CC | tinyint | 1 |  |  |
| MAX_TCKT_TIMES | tinyint | 1 |  |  |
| MAX_TCKT_TIMES_CC | tinyint | 1 |  |  |
| MAX_RFND_CC | tinyint | 1 |  |  |
| PRESET_AMT_1 | float | 8 |  | (0) |
| PRESET_AMT_2 | float | 8 |  | (0) |
| PRESET_AMT_3 | float | 8 |  | (0) |
| PRESET_AMT_4 | float | 8 |  | (0) |
| PRESET_AMT_5 | float | 8 |  | (0) |
| PRESET_AMT_6 | float | 8 |  | (0) |
| PRESET_AMT_7 | float | 8 |  | (0) |
| PRESET_AMT_8 | float | 8 |  | (0) |
| PRESET_AMT_9 | float | 8 |  | (0) |
| PRESET_AMT_10 | float | 8 |  | (0) |
| OVR_TND_AMT_RQRD | float | 8 |  | (0) |
| AUTH_CD_LEN_CC | tinyint | 1 |  |  |
| AUTO_DECLR_FG | bit | 1 |  | (0) |
| GIFT_CERT_FG | bit | 1 |  | (0) |
| AUTO_DECLR_EOD_FG | bit | 1 |  | (0) |
| DUP_RCPT_FG | bit | 1 |  | (0) |
| EXLUD_MDIA_FROM_RPT_FG | bit | 1 |  | (0) |
| FUEL_FG | bit | 1 |  | (0) |
| NOT_USE5_FG | bit | 1 |  | (0) |
| NOT_USE6_FG | bit | 1 |  | (0) |
| NOT_USE7_FG | bit | 1 |  | (0) |
| NOT_USE8_FG | bit | 1 |  | (0) |
| NOT_USE9_FG | bit | 1 |  | (0) |
| NOT_USE10_FG | bit | 1 |  | (0) |
| NOT_USE11_FG | bit | 1 |  | (0) |
| NOT_USE12_FG | bit | 1 |  | (0) |
| NOT_USE13_FG | bit | 1 |  | (0) |
| NOT_USE14_FG | bit | 1 |  | (0) |
| NOT_USE15_FG | bit | 1 |  | (0) |
| OPT_NOT_CLEAR_EOD | bit | 1 |  | (0) |
| OPT_NOT_INCLUDE_IN_POS_REPORT | bit | 1 |  | (0) |
| USE_CHECK_DEF_FILE_FG | bit | 1 |  | (0) |
| BANK_NUM_REQ_FG | bit | 1 |  | (0) |
| CHECK_NUM_REQ_FG | bit | 1 |  | (0) |
| ALLOW_OFFLINE_APPROVAL_FG | bit | 1 |  | (0) |
| OFFLINE_TENDER_LIMIT | money | 8 |  | (0) |
| CAPTURE_CASHBACK_AMT_AT_PINPAD_FG | bit | 1 |  | (0) |
| PINPAD_CASHBACK_DISPLAY_AMT_1 | money | 8 |  | (0) |
| PINPAD_CASHBACK_DISPLAY_AMT_2 | money | 8 |  | (0) |
| MAX_CASHBACK_LIMIT_AT_PINPAD | money | 8 |  | (0) |
| ALLOW_MANUAL_ACCOUNT_ENTRY_FG | bit | 1 |  | (0) |
| PRINT_ROUTING_NBR_FG | bit | 1 |  | (0) |
| PRINT_CHECK_NBR_FG | bit | 1 |  | (0) |
| PRINT_ACCT_NBR_FG | bit | 1 |  | (0) |
| DO_NOT_DISP_EXP_DT_FG | bit | 1 |  | (0) |
| ECC_FG | bit | 1 |  | (0) |
| SCN_TNDR_IMG_FG | bit | 1 |  | (0) |
| AUTO_TND_AVAIL_BAL_FG | bit | 1 |  | (0) |
Indexes
| Name | Columns | Unique | Fill Factor
--- | --- | --- | --- | ---
| PK_MEDIA_5AE4273 | TND_CD |  | 80
Check Constraints
Name | Checked | Constraint
--- | --- | ---
CK_MEDIA_1__112 |  | ([MAX_TCKT_CC] >= 0 and [MAX_TCKT_CC] <= 99)
CK_MEDIA_2__112 |  | ([MAX_TCKT_TIMES_CC] >= 0 and [MAX_TCKT_TIMES_CC] <= 99)
CK_MEDIA_3__112 |  | ([MAX_TCKT_TIMES] >= 0 and [MAX_TCKT_TIMES] <= 99)
CK__ENDRST_LINE_NT |  | ([ENDRSMT_LINE_CNT] >= 0 and [ENDRSMT_LINE_CNT] <= 999)
CK__ENDRST_STR_LINE |  | ([ENDRSMT_STRT_LINE] >= 0 and [ENDRSMT_STRT_LINE] <= 999)
CK__MEDIA__ACCT_NBR___EDD18F |  | ([ACCT_NBR_LNGTH] >= 0 and [ACCT_NBR_LNGTH] <= 99)
CK__MEDIA__ACT_PT |  | ([ACCT_OPT] >= 0 and [ACCT_OPT] <= 9)
CK__MEDIA__AUTH_CC__43B671 |  | ([AUTH_CC] >= 0 and [AUTH_CC] <= 99)
CK__MEDIA__CC_NBR__387070 |  | ([CC_NBR] >= 0 and [CC_NBR] <= 99)
CK__MEDIA__CDV_FRMLA__FD1D5C8 |  | ([CDV_FRMLA_OPT] >= 0 and [CDV_FRMLA_OPT] <= 99)
CK__MEDIA__CHK_FORMA__1BA1E3A |  | ([CHK_FORMAT_OPT] >= 0 and [CHK_FORMAT_OPT] <= 99)
CK__MEDIA__CRDT_DBT___9E294A9 |  | ([CRDT_DBT_OPT] >= 0 and [CRDT_DBT_OPT] <= 9)
CK__MEDIA__DAILY_AMT__F9B6DFF |  | ([DAILY_AMT_CC] >= 0 and [DAILY_AMT_CC] <= 99)
CK__MEDIA__ECCA_TMPT__830B400 |  | ([ECCA_TMPT_NO] >= 0 and [ECCA_TMPT_NO] <= 99)
CK__MEDIA__FEE_TABLE__C0144E4 |  | ([FEE_TABLE_NO] >= 0 and [FEE_TABLE_NO] <= 99)
CK__MEDIA__FEE_TYPE___CF5691D |  | ([FEE_TYPE_OPT] >= 0 and [FEE_TYPE_OPT] <= 99)
CK__MEDIA__FLOOR_AMT__EA749C6 |  | ([FLOOR_AMT_CC] >= 0 and [FLOOR_AMT_CC] <= 99)
CK__MEDIA__LOAN_AMT___460231C |  | ([LOAN_AMT_CC] >= 0 and [LOAN_AMT_CC] <= 99)
CK__MEDIA__MAX_AMT_C__BCADD1B |  | ([MAX_AMT_CC] >= 0 and [MAX_AMT_CC] <= 99)
CK__MEDIA__MCR_MISRE__5544755 |  | ([MCR_MISREAD] >= 0 and [MCR_MISREAD] <= 255)
CK__MEDIA__MCR_NBR__3A6B8E2 |  | ([MCR_NBR] >= 0 and [MCR_NBR] <= 99)
CK__MEDIA__MICR_ACCT_PT |  | ([MICR_ACCT_OPT] >= 0 and [MICR_ACCT_OPT] <= 9)
CK__MEDIA__MIN_AMT_C__CBF0154 |  | ([MIN_AMT_CC] >= 0 and [MIN_AMT_CC] <= 99)
CK__MEDIA__MPR_NBR__418FC72 |  | ([MPR_NBR] >= 0 and [MPR_NBR] <= 99)
CK__MEDIA__MPR_OP |  | ([MPR_OPT] >= 0 and [MPR_OPT] <= 9)
CK__MEDIA__OPEN_DRAWER_PT |  | ([OPEN_DRAWER_OPT] >= 0 and [OPEN_DRAWER_OPT] <= 3)
CK__MEDIA__OVER_TND___3B3258D |  | ([OVER_TND_CC] >= 0 and [OVER_TND_CC] <= 99)
CK__MEDIA__POS_RPT_G__4D20AB |  | ([POS_RPT_GRP_NO] >= 0 and [POS_RPT_GRP_NO] <= 99)
CK__MEDIA__PRST_AMT___4E98D56 |  | ([PRST_AMT_OPT] >= 0 and [PRST_AMT_OPT] <= 99)
CK__MEDIA__REPCARD_C__477DAAA |  | ([REPCARD_CC] >= 0 and [REPCARD_CC] <= 99)
CK__MEDIA__REPEAT_CC__48F9238 |  | ([REPEAT_CC] >= 0 and [REPEAT_CC] <= 99)
CK__MEDIA__RTLR_INFO__46BFEE3 |  | ([RTLR_INFO] >= 0 and [RTLR_INFO] <= 99)
CK__MEDIA__SCAN_BARC__424D839 |  | ([SCAN_BARCODE_AS_ACCT_OPT] >= 0 and [SCAN_BARCODE_AS_ACCT_OPT] <= 99)
CK__MEDIA__TLL_CLRNC__43C8FC7 |  | ([TLL_CLRNCE_TYPE_OPT] >= 0 and [TLL_CLRNCE_TYPE_OPT] <= 99)
CK__MEDIA__TND_CASH___4486B8E |  | ([TND_CASH_EXCH_OPT] >= 0 and [TND_CASH_EXCH_OPT] <= 99)
CK__MEDIA__VCHER_NBR__5C5FA01 |  | ([VCHER_NBR_LNGTH] >= 0 and [VCHER_NBR_LNGTH] <= 99)
Uses [dbo].[Zero] [dbo].[DIGIT_ONE] dbo Used By [dbo].[CHKOUT_BNK_OPEN_LOAN]