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