BSW_HQ

Tables (50)

APIExportLog

  • clientID — nvarchar(20) — Primary key — NOT NULL
  • ObjectType — nvarchar(10) — Primary key — NOT NULL
  • StoreID — int — Primary key — NOT NULL
  • ObjectID — int — Primary key — NOT NULL
  • ExportDateTime — datetime — NOT NULL
  • Version — varbinary(8)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ARHistoryMirror

  • HQID — int — NOT NULL
  • ID — int — NOT NULL
  • StoreID — int — NOT NULL
  • LocalARHistoryType — int — NOT NULL
  • RemoteStoreID — int — NOT NULL
  • RemoteARID — int — NOT NULL
  • RemotePaymentID — int — NOT NULL
  • Payment — money — NOT NULL
  • IsProcessed — bit — NOT NULL
  • DBTimeStamp — timestamp — NOT NULL

AccountReceivable

  • ID — int — NOT NULL
  • StoreID — int — NOT NULL
  • CustomerID — int — NOT NULL
  • Date — datetime — NOT NULL
  • DueDate — datetime — NOT NULL
  • OriginalAmount — money — NOT NULL
  • TransactionNumber — int — NOT NULL
  • Type — smallint — NOT NULL
  • Balance — money — NOT NULL
  • DBTimeStamp — timestamp

AccountReceivableHistory

  • ID — int — NOT NULL
  • StoreID — int — NOT NULL
  • AccountReceivableID — int — NOT NULL
  • BatchNumber — int — NOT NULL
  • Amount — money — NOT NULL
  • PaymentID — int — NOT NULL
  • Comment — nvarchar(50) — NOT NULL — varchar(50) NOT NUL
  • CashierID — int — NOT NULL
  • Date — datetime — NOT NULL
  • DBTimeStamp — timestamp
  • HistoryType — int — NOT NULL
  • TransferArID — int — NOT NULL
  • ReasonCodeID — int — NOT NULL
  • RemoteStoreID — int — NOT NULL
  • RemotePaymentID — int — NOT NULL

AccountType

  • ID — int — Primary key — NOT NULL
  • Description — nvarchar(50) — NOT NULL
  • DateDueType — int — NOT NULL
  • GracePeriod — int — NOT NULL
  • MinimumFinanceCharge — money — NOT NULL
  • AnnualInterestRate — float — NOT NULL
  • ApplyFinanceChargesOnFinanceCharges — bit — NOT NULL
  • MinimumPayment — money — NOT NULL
  • DBTimeStamp — timestamp
  • Code — nvarchar(17) — NOT NULL
  • HQID — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Accounting

  • TableName — nvarchar(30) — NOT NULL
  • FieldName — nvarchar(30) — NOT NULL
  • DetailID — int — NOT NULL
  • Description — nvarchar(50) — NOT NULL
  • DebitAccount — nvarchar(100)
  • CreditAccount — nvarchar(100)
  • DBTimeStamp — timestamp
  • StoreID — int — NOT NULL
  • ID — int — NOT NULL
  • HQID — int — NOT NULL
  • DisplayPosition — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

AccountingBatchExport

  • ID — int — Primary key — NOT NULL
  • BatchNumber — int — NOT NULL
  • StoreID — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

AccountingTerms

  • ID — int — NOT NULL
  • HQID — int — NOT NULL
  • Name — nvarchar(50) — NOT NULL
  • DBTimeStamp — timestamp

Alias

  • ID — int — Primary key — NOT NULL
  • ItemID — int — NOT NULL
  • Alias — nvarchar(25) — NOT NULL
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Batch

  • AutoID — int — Primary key — NOT NULL
  • CustomerDepositMade — money — NOT NULL
  • CustomerDepositRedeemed — money — NOT NULL
  • LastUpdated — datetime — NOT NULL
  • StoreID — int — NOT NULL
  • BatchNumber — int — NOT NULL
  • Status — smallint — NOT NULL
  • RegisterID — int — NOT NULL
  • OpeningTime — datetime
  • ClosingTime — datetime
  • OpeningTotal — money — NOT NULL
  • ClosingTotal — money — NOT NULL
  • Sales — money — NOT NULL
  • Returns — money — NOT NULL
  • Tax — money — NOT NULL
  • SalesPlusTax — money — NOT NULL
  • Commission — money — NOT NULL
  • PaidOut — money — NOT NULL
  • Dropped — money — NOT NULL
  • PaidOnAccount — money — NOT NULL
  • PaidToAccount — money — NOT NULL
  • CustomerCount — int — NOT NULL
  • NoSalesCount — int — NOT NULL
  • AbortedTransCount — int — NOT NULL
  • TotalTendered — money — NOT NULL
  • TotalChange — money — NOT NULL
  • Discounts — money — NOT NULL
  • CostOf — ods — NOT NULL
  • LayawayPaid — money — NOT NULL
  • LayawayClosed — money — NOT NULL
  • Shipping — money — NOT NULL
  • DBTimeStamp — timestamp
  • TenderRoundingError — money — NOT NULL
  • ExportedFromHQ — bit
  • DebitSurcharge — money — NOT NULL
  • CashBackSurcharge — money — NOT NULL
  • Vouchers — money — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CalendarEvent

  • ID — int — NOT NULL
  • StoreID — int — NOT NULL
  • CashierID — int — NOT NULL
  • DateTime — datetime — NOT NULL
  • Text — nvarchar(255) — NOT NULL
  • ReminderEnabled — bit — NOT NULL
  • ReminderDate — datetime — NOT NULL
  • IsPersonal — bit — NOT NULL
  • DBTimeStamp — timestamp
  • AutoID — int — NOT NULL

Cashier

  • AutoID — int — Primary key — NOT NULL
  • HQID — int — NOT NULL
  • LastUpdated — datetime — NOT NULL
  • Number — nvarchar(9) — NOT NULL
  • StoreID — int — NOT NULL
  • ID — int — NOT NULL
  • Name — nvarchar(50) — NOT NULL
  • Password — nvarchar(512)
  • FloorLimit — money — NOT NULL
  • ReturnLimit — money — NOT NULL
  • CashDrawerNumber — smallint — NOT NULL
  • SecurityLevel — smallint — NOT NULL
  • Privileges — int — NOT NULL
  • EmailAddress — nvarchar(255) — NOT NULL
  • FailedLo — nAttempts — NOT NULL
  • DBTimeStamp — timestamp
  • MaxOverShortAmount — money — NOT NULL
  • MaxOverShortPercent — float — NOT NULL
  • OverShortLimitType — int — NOT NULL
  • Telephone — nvarchar(30) — NOT NULL
  • PasswordChangedDate — datetime
  • PasswordResetFlag — bit — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Category

  • ID — int — Primary key — NOT NULL
  • HQID — int — NOT NULL
  • DepartmentID — int — NOT NULL
  • Name — nvarchar(30) — NOT NULL
  • Code — nvarchar(17) — NOT NULL
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Check

  • AutoID — int — Primary key — NOT NULL
  • ID — int — NOT NULL
  • LookupCode — nvarchar(30) — NOT NULL
  • AccountName — nvarchar(30) — NOT NULL
  • StatusCode — smallint
  • DBTimeStamp — timestamp
  • StoreID — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Configuration

  • AutoID — int — Primary key — NOT NULL
  • AccountDefaultID — int — NOT NULL
  • AccountMonthlyClosingDay — smallint — NOT NULL
  • CostUpdateMethod — int — NOT NULL
  • HQCreationDate — datetime
  • LastBackupMessage — datetime
  • LastUpdated — datetime — NOT NULL
  • LayawayDeposit — real — NOT NULL
  • LimitItem — float — NOT NULL
  • LimitPurchase — money — NOT NULL
  • LimitTimeFrame — int — NOT NULL
  • LimitType — int — NOT NULL
  • SerialNumber — varchar(50)
  • StoreCountry — nvarchar(20) — NOT NULL
  • StoreID — int — NOT NULL
  • StoreState — nvarchar(20) — NOT NULL
  • SyncID — int — NOT NULL
  • TaxSystem — int — NOT NULL
  • VATRegistrationNumber — nvarchar(20) — NOT NULL
  • ID — int — NOT NULL
  • StoreName — nvarchar(30) — NOT NULL
  • StoreAddress1 — nvarchar(30) — NOT NULL
  • StoreAddress2 — nvarchar(30) — NOT NULL
  • StoreCity — nvarchar(30) — NOT NULL
  • StoreZip — nvarchar(15) — NOT NULL
  • StorePhone — nvarchar(14) — NOT NULL
  • StoreFax — nvarchar(14) — NOT NULL
  • QuoteExpirationDays — smallint — NOT NULL
  • BackOrderExpirationDays — smallint — NOT NULL
  • LayawayExpirationDays — smallint — NOT NULL
  • WorkOrderDueDays — smallint — NOT NULL
  • LayawayFee — money — NOT NULL
  • ReceiptCount — int — NOT NULL
  • ReceiptCount2 — int — NOT NULL
  • EDCTimeout — int — NOT NULL
  • WorkOrderDeposit — float — NOT NULL
  • PriceCalculationRule — int — NOT NULL
  • Options — int — NOT NULL
  • StoreEmail — nvarchar(255) — NOT NULL
  • TaxBasis — int — NOT NULL
  • TaxField — int — NOT NULL
  • ItemTaxID — int — NOT NULL
  • DBTimeStamp — timestamp
  • DefaultTenderID — int — NOT NULL
  • Options2 — int — NOT NULL
  • VoucherExpirationDays — int — NOT NULL
  • EnableGlobalCustomers — bit — NOT NULL
  • DefaultGlobalCustomer — bit — NOT NULL
  • SoftwareValidation1 — varchar(128)
  • SoftwareValidation2 — varchar(128)
  • SoftwareValidation3 — varchar(128)
  • SoftwareValidation4 — varchar(128)
  • SoftwareValidation5 — varchar(128)
  • VATDetailID — nvarchar(50) — NOT NULL
  • Options3 — int — NOT NULL
  • Options4 — int — NOT NULL
  • NextAutoAccountNumber — int — NOT NULL
  • AccountingInterface — int — NOT NULL
  • BillPostingAccount — nvarchar(100) — NOT NULL
  • AccountingFilename — nvarchar(150) — NOT NULL
  • … +19

Currency

  • ID — int — Primary key — NOT NULL
  • HQID — int — NOT NULL
  • ExchangeRate — float
  • Description — nvarchar(25) — NOT NULL
  • Code — nvarchar(17) — NOT NULL
  • LocaleID — int — NOT NULL
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CustomButtons

  • ID — int — Primary key — NOT NULL
  • Number — int — NOT NULL
  • Caption — nvarchar(50) — NOT NULL
  • Command — nvarchar(255) — NOT NULL
  • Description — nvarchar(50) — NOT NULL
  • Picture — image
  • Style — int — NOT NULL
  • DBTimeStamp — timestamp
  • HQID — int — NOT NULL
  • UseMask — bit — NOT NULL
  • MaskColor — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CustomCaption

  • ID — int — Primary key — NOT NULL
  • HQID — int — NOT NULL
  • Style — int — NOT NULL
  • Caption — nvarchar(50) — NOT NULL
  • DBTimeStamp — timestamp — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Customer

  • AutoID — int — Primary key — NOT NULL
  • AccountNumber — nvarchar(20) — NOT NULL
  • AccountTypeID — int — NOT NULL
  • Address2 — nvarchar(50) — NOT NULL
  • AssessFinanceCharges — bit — NOT NULL
  • Company — nvarchar(50) — NOT NULL
  • Country — nvarchar(20) — NOT NULL
  • CustomDate1 — datetime
  • CustomDate2 — datetime
  • CustomDate3 — datetime
  • CustomDate4 — datetime
  • CustomDate5 — datetime
  • CustomNumber1 — float — NOT NULL
  • CustomNumber2 — float — NOT NULL
  • CustomNumber3 — float — NOT NULL
  • CustomNumber4 — float — NOT NULL
  • CustomNumber5 — float — NOT NULL
  • CustomText1 — nvarchar(30) — NOT NULL
  • CustomText2 — nvarchar(30) — NOT NULL
  • CustomText3 — nvarchar(30) — NOT NULL
  • CustomText4 — nvarchar(30) — NOT NULL
  • CustomText5 — nvarchar(30) — NOT NULL
  • GlobalCustomer — bit — NOT NULL
  • HQID — int — NOT NULL
  • LastStartingDate — datetime
  • LastClosingDate — datetime
  • LastUpdated — datetime — NOT NULL
  • LimitPurchase — bit — NOT NULL
  • LastClosingBalance — money — NOT NULL
  • PrimaryShipToID — int — NOT NULL
  • State — nvarchar(20) — NOT NULL
  • StoreID — int — NOT NULL
  • ID — int — NOT NULL
  • LayawayCustomer — bit — NOT NULL
  • Employee — bit — NOT NULL
  • FirstName — nvarchar(30) — NOT NULL
  • LastName — nvarchar(50) — NOT NULL
  • Address — nvarchar(50) — NOT NULL
  • City — nvarchar(50) — NOT NULL
  • Zip — nvarchar(15) — NOT NULL
  • AccountBalance — money — NOT NULL
  • CreditLimit — money — NOT NULL
  • TotalSales — money — NOT NULL
  • AccountOpened — datetime — NOT NULL
  • LastVisit — datetime — NOT NULL
  • TotalVisits — int — NOT NULL
  • TotalSavings — money — NOT NULL
  • CurrentDiscount — real — NOT NULL
  • PriceLevel — smallint — NOT NULL
  • TaxExempt — bit — NOT NULL
  • Notes — ntext
  • Title — nvarchar(20) — NOT NULL
  • EmailAddress — nvarchar(255) — NOT NULL
  • DBTimeStamp — timestamp
  • TaxNumber — nvarchar(20) — NOT NULL
  • PictureName — nvarchar(50) — NOT NULL
  • DefaultShippingServiceID — int — NOT NULL
  • PhoneNumber — nvarchar(30) — NOT NULL
  • FaxNumber — nvarchar(30) — NOT NULL
  • CashierID — int — NOT NULL
  • … +6

DailySales

  • AutoID — int — Primary key — NOT NULL
  • ID — int — NOT NULL
  • Date — datetime — NOT NULL
  • Type — int — NOT NULL
  • TypeID — int — NOT NULL
  • Total — money — NOT NULL
  • DBTimeStamp — timestamp
  • StoreID — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Department

  • ID — int — Primary key — NOT NULL
  • HQID — int — NOT NULL
  • Name — nvarchar(30) — NOT NULL
  • code — nvarchar(17) — NOT NULL
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Dimension

  • Id — int — Primary key — NOT NULL
  • DimensionName — nvarchar(40) — NOT NULL
  • Description — nvarchar(40) — NOT NULL
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DimensionAttribute

  • Id — int — Primary key — NOT NULL
  • Attribute — nvarchar(60) — NOT NULL
  • Code — nvarchar(5) — NOT NULL
  • DisplayOrder — int
  • DimensionId — int — NOT NULL
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DropPayout

  • AutoID — int — Primary key — NOT NULL
  • ID — int — NOT NULL
  • StoreID — int — NOT NULL
  • BatchNumber — int — NOT NULL
  • Time — datetime — NOT NULL
  • CashierID — int — NOT NULL
  • Amount — money — NOT NULL
  • Comment — nvarchar(50) — NOT NULL — varchar(50) NOT NUL
  • Recipient — nvarchar(50) — NOT NULL
  • DBTimeStamp — timestamp
  • ReasonCodeID — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Exchange

  • ID — int — Primary key — NOT NULL
  • DBTimeStamp — timestamp — NOT NULL
  • DateCreated — datetime — NOT NULL
  • LastUpdated — datetime — NOT NULL
  • ProcessorCode — nvarchar(50) — NOT NULL
  • Data — ntext — NOT NULL
  • Status — int — NOT NULL
  • Comment — nvarchar(255) — NOT NULL — varchar(255) NOT NUL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

GlobalRequestlog

  • AutoID — numeric(18, 0)
  • 1) — NOT — NOT NULL
  • RequestID — numeric(18, 0)
  • RequestType — char(1)
  • VoucherOnlineID — numeric(18, 0)
  • Register — numeric(18, 0)
  • StoreID — numeric(18, 0)
  • Amount — money
  • Balance — money
  • ErrorCode — numeric(18, 0)
  • ItemHQID — numeric(18, 0)
  • SerialNumber — nvarchar(40)
  • LastUpdated — datetime
  • DBtimeStamp — timestamp — NOT NULL

HQConfiguration

  • ID — int — Primary key — NOT NULL
  • CreationDate — datetime
  • HQOptions — int — NOT NULL
  • AccountMonthlyClosingDay — int — NOT NULL
  • HQName — nvarchar(50)
  • HQAddress1 — nvarchar(50)
  • HQAddress2 — nvarchar(50)
  • HQCity — nvarchar(50)
  • HQCountry — nvarchar(20)
  • HQFaxNumber — nvarchar(14)
  • HQPhoneNumber — nvarchar(14)
  • HQState — nvarchar(20)
  • HQZip — nvarchar(15)
  • HQEmailAddress — nvarchar(50)
  • DBTimeStamp — timestamp
  • SerialNumber — nvarchar(50) — NOT NULL
  • AccountDefaultID — int — NOT NULL
  • NextAutoAccountNumber — int — NOT NULL
  • AccountingInterface — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

HQEventLog

  • ID — int — Primary key — NOT NULL
  • StoreID — int
  • HQEntry — bit — NOT NULL
  • EventClass — int
  • EventTime — datetime
  • EventMessage — nvarchar(255)
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

HQMessage

  • AutoID — int — Primary key — NOT NULL
  • ID — int — NOT NULL
  • Status — smallint — NOT NULL
  • Title — nvarchar(40) — NOT NULL
  • Message — nvarchar(255) — NOT NULL
  • Style — smallint — NOT NULL
  • FromStoreID — int — NOT NULL
  • ToStoreID — int — NOT NULL
  • AttachmentID — int — NOT NULL
  • DateSent — datetime
  • DateReceived — datetime
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

HQRecordDeletedLog

  • ID — int — Primary key — NOT NULL
  • TableName — nvarchar(30) — NOT NULL
  • IDFieldName — nvarchar(30) — NOT NULL
  • RecordID — int — NOT NULL
  • WhenDeleted — datetime — NOT NULL
  • StoreID — int — NOT NULL
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

HQVersionHistory

  • ID — int — Primary key — NOT NULL
  • Version — nvarchar(10)
  • Description — nvarchar(255)
  • Date — datetime
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

HQVersionMatrix

  • ID — int — Primary key — NOT NULL
  • HQVersion — nvarchar(10)
  • QSVersion — nvarchar(10)
  • DBTimeStamp — timestamp
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ibp_ItemImportedLog_rmsh

  • id — int — NOT NULL
  • ItemId — int
  • Itemlookupcode — nvarchar(25)
  • Description — nvarchar(30)
  • UserID — int
  • Imported — datetime — NOT NULL

ibp_ItemImportedLog_rmshu

  • id — int — NOT NULL
  • Itemlookupcode — nvarchar(25)
  • Imported — datetime — NOT NULL

ibp_cashier_rmsh

  • id — int
  • pass — nvarchar(200)

ibp_cashier_rmshu

  • id — int
  • pass — nvarchar(500)

ibp_importfields_rmsh

  • id — int
  • filename — nvarchar(150)
  • cashierid — int
  • datecreated — datetime — NOT NULL
  • fieldname — nvarchar(150)
  • im_id — int

ibp_importfields_rmshu

  • id — int
  • filename — nvarchar(150)
  • cashierid — int
  • datecreated — datetime — NOT NULL
  • fieldname — nvarchar(150)
  • im_id — int

ibp_importmatch_rmsh

  • id — int
  • iname — nvarchar(100)
  • idb — nvarchar(100)
  • ilimit — int
  • order_by — int

ibp_importmatch_rmshu

  • id — int
  • iname — nvarchar(100)
  • idb — nvarchar(100)
  • ilimit — int
  • order_by — int
  • itype — int

ibp_itemstoimport_rmsh

  • id — int
  • filename — nvarchar(150)
  • cashierid — int
  • datecreated — datetime — NOT NULL
  • status — int — NOT NULL
  • fdata0 — nvarchar(200)
  • ldata0 — int
  • fdata1 — nvarchar(200)
  • ldata1 — int
  • fdata2 — nvarchar(200)
  • ldata2 — int
  • fdata3 — nvarchar(200)
  • ldata3 — int
  • fdata4 — nvarchar(200)
  • ldata4 — int
  • fdata5 — nvarchar(200)
  • ldata5 — int
  • fdata6 — nvarchar(200)
  • ldata6 — int
  • fdata7 — nvarchar(200)
  • ldata7 — int
  • fdata8 — nvarchar(200)
  • ldata8 — int
  • fdata9 — nvarchar(200)
  • ldata9 — int
  • fdata10 — nvarchar(200)
  • ldata10 — int
  • fdata11 — nvarchar(200)
  • ldata11 — int
  • fdata12 — nvarchar(200)
  • ldata12 — int
  • fdata13 — nvarchar(200)
  • ldata13 — int
  • fdata14 — nvarchar(200)
  • ldata14 — int
  • fdata15 — nvarchar(200)
  • ldata15 — int
  • fdata16 — nvarchar(200)
  • ldata16 — int
  • fdata17 — nvarchar(200)
  • ldata17 — int
  • fdata18 — nvarchar(200)
  • ldata18 — int
  • fdata19 — nvarchar(200)
  • ldata19 — int
  • fdata20 — nvarchar(200)
  • ldata20 — int
  • fdata21 — nvarchar(200)
  • ldata21 — int
  • fdata22 — nvarchar(200)
  • ldata22 — int
  • fdata23 — nvarchar(200)
  • ldata23 — int
  • fdata24 — nvarchar(200)
  • ldata24 — int

ibp_itemstoimport_rmshu

  • id — int
  • filename — nvarchar(150)
  • cashierid — int
  • datecreated — datetime — NOT NULL
  • status — int — NOT NULL
  • fdata0 — nvarchar(500)
  • ldata0 — int
  • fdata1 — nvarchar(500)
  • ldata1 — int
  • fdata2 — nvarchar(500)
  • ldata2 — int
  • fdata3 — nvarchar(500)
  • ldata3 — int
  • fdata4 — nvarchar(500)
  • ldata4 — int
  • fdata5 — nvarchar(500)
  • ldata5 — int
  • fdata6 — nvarchar(500)
  • ldata6 — int
  • fdata7 — nvarchar(500)
  • ldata7 — int
  • fdata8 — nvarchar(500)
  • ldata8 — int
  • fdata9 — nvarchar(500)
  • ldata9 — int
  • fdata10 — nvarchar(500)
  • ldata10 — int
  • fdata11 — nvarchar(500)
  • ldata11 — int
  • fdata12 — nvarchar(500)
  • ldata12 — int
  • fdata13 — nvarchar(500)
  • ldata13 — int
  • fdata14 — nvarchar(500)
  • ldata14 — int
  • fdata15 — nvarchar(500)
  • ldata15 — int
  • fdata16 — nvarchar(500)
  • ldata16 — int
  • fdata17 — nvarchar(500)
  • ldata17 — int
  • fdata18 — nvarchar(500)
  • ldata18 — int
  • fdata19 — nvarchar(500)
  • ldata19 — int
  • fdata20 — nvarchar(500)
  • ldata20 — int
  • fdata21 — nvarchar(500)
  • ldata21 — int
  • fdata22 — nvarchar(500)
  • ldata22 — int
  • fdata23 — nvarchar(500)
  • ldata23 — int
  • fdata24 — nvarchar(500)
  • ldata24 — int

ibp_license_rmsh

  • lkey — nvarchar(800)

ibp_license_rmshu

  • lkey — nvarchar(800)

ibp_sessions_rmsh

  • ip — nvarchar(150)
  • texpire — datetime — NOT NULL
  • cashier — nvarchar(150)

ibp_sessions_rmshu

  • ip — nvarchar(150)
  • texpire — datetime — NOT NULL
  • cashier — nvarchar(150)

ibp_settings_rmsh

  • keya — nvarchar(100)
  • val — int
  • valc — nvarchar(100)

ibp_settings_rmshu

  • keya — nvarchar(100)
  • val — int
  • valc — nvarchar(100)

ibp_signout_rmsh

  • id — int

ibp_signout_rmshu

  • id — int