(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].[PLU] Properties Columns Indexes Check Constraints Uses Used By Properties
Property | Value
--- | ---
Collation | SQL_Latin1_General_CP850_BIN
Row Count (~) | 0
Created | 9:42:52 AM Friday, April 11, 2003
Last Modified | 9:42:52 AM Friday, April 11, 2003
Columns
| Name | Data Type | Max Length (Bytes) | Allow Nulls | Default | Bound Default
--- | --- | --- | --- | --- | --- | ---
| ITM_ID | [dbo].[PLU_NUM] | 8 |  |  |
| STR_HIER_ID | int | 4 |  |  |
| DFLT_RTN_LOC_ID | int | 4 |  |  |
| MSG_CD | tinyint | 1 |  |  |
| DSPL_DESCR | varchar(40) | 40 |  |  |
| SLS_RESTRICT_GRP | int | 4 |  |  |
| RCPT_DESCR | varchar(20) | 20 |  |  |
| TAXABILITY_CD | smallint | 2 |  |  |
| MDSE_XREF_ID | int | 4 |  |  |
| NON_MDSE_ID | int | 4 |  | (0) |
| UOM | char(4) | 4 |  | (' ') |
| UNT_QTY | tinyint | 1 |  | (1) |
| LIN_ITM_CD | smallint | 2 |  |  |
| MD_FG | bit | 1 |  | (0) |
| QTY_RQRD_FG | bit | 1 |  | (0) |
| SUBPRD_CNT | smallint | 2 |  |  |
| QTY_ALLOWED_FG | bit | 1 |  | (0) |
| SLS_AUTH_FG | bit | 1 |  | (0) |
| FOOD_STAMP_FG | bit | 1 |  | (0) |
| WIC_FG | bit | 1 |  | (0) |
| PERPET_INV_FG | bit | 1 |  | (0) |
| RTL_PRC | money | 8 |  | (0) |
| UNT_CST | money | 8 |  |  |
| MAN_PRC_LVL | tinyint | 1 |  |  |
| MIN_MDSE_AMT | money | 8 |  | (0) |
| RTL_PRC_DATE | datetime | 8 |  | (getdate()) |
| SERIALIZED_MDSE_FG | bit | 1 |  | (0) |
| CNTR_PRC | money | 8 |  |  |
| MAX_MDSE_AMT | money | 8 |  | (0) |
| CNTR_PRC_DATE | datetime | 8 |  | (getdate()) |
| NG_ENTRY_FG | bit | 1 |  | (0) |
| STR_CPN_FG | bit | 1 |  | (0) |
| VEN_CPN_FG | bit | 1 |  | (0) |
| MAN_PRC_FG | bit | 1 |  | (0) |
| WGT_ITM_FG | bit | 1 |  | (0) |
| NON_DISC_FG | bit | 1 |  | (0) |
| COST_PLUS_FG | bit | 1 |  | (0) |
| PRC_VRFY_FG | bit | 1 |  | (0) |
| PRC_OVRD_FG | bit | 1 |  | (0) |
| SPLR_PROM_FG | bit | 1 |  | (0) |
| SAVE_DISC_FG | bit | 1 |  | (0) |
| ITM_ONSALE_FG | bit | 1 |  | (0) |
| INHBT_QTY_FG | bit | 1 |  | (0) |
| DCML_QTY_FG | bit | 1 |  | (0) |
| SHELF_LBL_RQRD_FG | bit | 1 |  | (0) |
| TAX_RATE1_FG | bit | 1 |  | (0) |
| TAX_RATE2_FG | bit | 1 |  | (0) |
| TAX_RATE3_FG | bit | 1 |  | (0) |
| TAX_RATE4_FG | bit | 1 |  | (0) |
| TAX_RATE5_FG | bit | 1 |  | (0) |
| TAX_RATE6_FG | bit | 1 |  | (0) |
| TAX_RATE7_FG | bit | 1 |  | (0) |
| TAX_RATE8_FG | bit | 1 |  | (0) |
| COST_CASE_PRC | money | 8 |  |  |
| DATE_COST_CASE_PRC | datetime | 8 |  | (getdate()) |
| UNIT_CASE | float | 8 |  |  |
| MIX_MATCH_CD | int | 4 |  |  |
| RTN_CD | tinyint | 1 |  |  |
| FAMILY_CD | smallint | 2 |  |  |
| SUBDEP_ID | float | 8 |  |  |
| DISC_CD | tinyint | 1 |  |  |
| LBL_QTY | tinyint | 1 |  |  |
| SCALE_FG | bit | 1 |  | (0) |
| LOCAL_DEL_FG | bit | 1 |  | (0) |
| HOST_DEL_FG | bit | 1 |  | (0) |
| HEAD_OFFICE_DEP | int | 4 |  |  |
| WGT_SCALE_FG | bit | 1 |  | (0) |
| FREQ_SHOP_TYPE | tinyint | 1 |  |  |
| FREQ_SHOP_VAL | money | 8 |  |  |
| SEC_FAMILY | smallint | 2 |  |  |
| POS_MSG | tinyint | 1 |  |  |
| SHELF_LIFE_DAY | smallint | 2 |  |  |
| PROM_NBR | [dbo].[DIGIT_FOUR] | 2 |  |  | Zero
| BCKT_NBR | [dbo].[DIGIT_FOUR] | 2 |  |  | Zero
| EXTND_PROM_NBR | [dbo].[DIGIT_FOUR] | 2 |  |  | Zero
| EXTND_BCKT_NBR | [dbo].[DIGIT_FOUR] | 2 |  |  | Zero
| RCPT_DESCR1 | varchar(20) | 20 |  |  |
| RCPT_DESCR2 | varchar(20) | 20 |  |  |
| RCPT_DESCR3 | varchar(20) | 20 |  |  |
| RCPT_DESCR4 | varchar(20) | 20 |  |  |
| CPN_NBR | float | 8 |  |  |
| TAR_WGT_NBR | tinyint | 1 |  |  |
| RSTRCT_LAYOUT | tinyint | 1 |  |  |
| INTRNL_ID | [dbo].[PLU_NUM] | 8 |  | (0) |
| OLD_PRC | money | 8 |  | (0) |
| QDX_FREQ_SHOP_VAL | int | 4 |  |  |
| VND_ID | varchar(8) | 8 |  |  |
| VND_ITM_ID | float | 8 |  |  |
| VND_ITM_SZ | varchar(10) | 10 |  |  |
| CMPRTV_UOM | tinyint | 1 |  |  |
| CMPR_QTY | int | 4 |  |  |
| CMPR_UNT | int | 4 |  |  |
| BNS_CPN_FG | bit | 1 |  | (0) |
| EXCLUD_MIN_PURCH_FG | bit | 1 |  | (0) |
| FUEL_FG | tinyint | 1 |  | (0) |
| NU04_FG | bit | 1 |  | (0) |
| NU05_FG | bit | 1 |  | (0) |
| NU06_FG | bit | 1 |  | (0) |
| NU07_FG | bit | 1 |  | (0) |
| NU08_FG | bit | 1 |  | (0) |
| NU09_FG | bit | 1 |  | (0) |
| NU10_FG | bit | 1 |  | (0) |
| FREQ_SHOP_LMT | tinyint | 1 |  |  |
| DEA_GRP | smallint | 2 |  | (0) |
| BNS_BY_OPCODE | smallint | 2 |  | (4) |
| BNS_BY_DESCR | varchar(20) | 20 |  |  |
| COMP_TYPE | smallint | 2 |  |  |
| COMP_PRC | float | 8 |  |  |
| COMP_QTY | int | 4 |  |  |
| MAN_PRC_SAV_FG | bit | 1 |  | (0) |
| DEL_PLU_FG | bit | 1 |  | (0) |
| ASSUME_QTY_FG | bit | 1 |  | (0) |
| NOT_USE3_FG | bit | 1 |  | (0) |
| NOT_USE4_FG | bit | 1 |  | (0) |
| NOT_USE5_FG | bit | 1 |  | (0) |
| NOT_USE6_FG | bit | 1 |  | (0) |
| NOT_USE7_FG | bit | 1 |  | (0) |
| PRC_RSN_ID | smallint | 2 |  |  |
| EXCISE_TAX_NBR | int | 4 |  |  |
| COMP_DATE | datetime | 8 |  |  |
| ORIG_PRC | money | 8 |  |  |
| ORIG_UNT_QTY | tinyint | 1 |  |  |
| ITM_POINT | int | 4 |  |  |
| PRC_GRP_ID | smallint | 2 |  |  |
| SPR_AUTH_RQRD_FG | bit | 1 |  | (0) |
| SSP_PRDCT_FG | bit | 1 |  | (0) |
| SWW_CODE_FG | float | 8 |  | (0) |
| DELETE_DATE | datetime | 8 |  |  |
| SHELF_STOCK_FG | bit | 1 |  | (0) |
| UPD_ORIGIN | varchar(20) | 20 |  | ('UNKNOWN') |
| UPD_BATCH_ID | int | 4 |  |  |
| UPD_USER_ID | varchar(32) | 32 |  |  |
| PRNT_PLU_ID_RCPT_FG | bit | 1 |  | (0) |
| BLK_GRP | int | 4 |  | (0) |
| EXCHANGE_TENDER_ID | smallint | 2 |  | (0) |
| CAR_WASH_FG | bit | 1 |  | (0) |
| DT_PLU_LAST_UPDATE | datetime | 8 |  | (getdate()) |
| PACKAGE_UOM | tinyint | 1 |  |  |
| UNIT_FACTOR | int | 4 |  | (1) |
| PACKAGE_SIZE | float | 8 |  | (1) |
| FS_QTY | int | 4 |  | (0) |
| NON_RX_HEALTH_FG | bit | 1 |  | (0) |
| RX_FG | bit | 1 |  | (0) |
| EXEMPT_FROM_PROM_FG | bit | 1 |  | (0) |
| WIC_CVV_FG | bit | 1 |  | (0) |
| LNK_NBR | smallint | 2 |  |  |
| SNAP_HIP_FG | bit | 1 |  | (0) |
Indexes
| Name | Columns | Unique | Fill Factor
--- | --- | --- | --- | ---
| PK__PLU__F4A812 | ITM_ID |  | 80
| DEA_GRP | DEA_GRP |  | 80
| FUEL_IDX | FUEL_FG |  |
| IDX_EXCHANGE_TENDER_ID_PLU | EXCHANGE_TENDER_ID |  |
| PLU_DEP | STR_HIER_ID, ITM_ID |  | 80
| PLU_INTRNL_ID | INTRNL_ID |  | 80
| PLU_MIX_MATCH | MIX_MATCH_CD |  | 80
Check Constraints
Name | Checked | Constraint
--- | --- | ---
CK_PLU_1__251 |  | ([SLS_RESTRICT_GRP] >= 0 and [SLS_RESTRICT_GRP] <= 255)
CK__PLU__BCKT_NBR__C6E147 |  | ([BCKT_NBR] >= 0 and [BCKT_NBR] <= 9999)
CK__PLU__EXTND_BCKT___E565CE |  | ([EXTND_BCKT_NBR] >= 0 and [EXTND_BCKT_NBR] <= 9999)
CK__PLU__EXTND_PROM___D6238A |  | ([EXTND_PROM_NBR] >= 0 and [EXTND_PROM_NBR] <= 9999)
CK__PLU__ITM_ID__7A95F5 |  | ([ITM_ID] >= 1.0 and [ITM_ID] <= 99999999999999.0)
CK__PLU__MD_FG__991A7C |  | ([MD_FG] >= 0 and [MD_FG] <= 9999)
CK__PLU__PROM_NBR__B79F03 |  | ([PROM_NBR] >= 0 and [PROM_NBR] <= 9999)
CK__PLU__SUBPRD_CNT__A5CC0 |  | ([SUBPRD_CNT] >= 0 and [SUBPRD_CNT] <= 999)
CK__PLU__UNT_QTY__89D39 |  | ([UNT_QTY] >= 0 and [UNT_QTY] <= 99)
Uses [dbo].[Zero] [dbo].[PLU_NUM] [dbo].[DIGIT_FOUR] dbo Used By [dbo].[PLU_GROUP_ITEMS] [dbo].[PLU_MIXMATCH]