|
| Created: 16 March 2009. Last Reviewed: 16 March 2012
|
|
|
| Enabler 4.74
|
|
|
|
|
|
| Explanation of LANTRAN Database files used by Enabler
|
|
|
|
|
|
| Name
| Description
|
|
|
| The LANTRAN folder contains all the Enabler transactional data. As the store server only contains transactional data, it is not appropriate to replace database files from another till, and replacing from UPGBASE will in most cases result in some form of data loss.It is highly recommended that Enabler is configured to perform database backups, so LANTRAN files can be recovered from backup in the event of corruption.
|
|
|
|
|
|
| clubpts
| Customer Club points
|
|
| clubptst
| Customer club point transactions - earning and redeeming points
|
|
| coalloc
| Customer Order Allocations table.
|
|
| custbal
| Customer Charge account balances
|
|
| custcomm
| Comments recorded against Customers. Comments in EEE but not exported to Enabler.
|
|
| custhist
| History of customer charge account transactions
|
|
| debtlog
| Debtors Interface Export log file
|
|
| dlybank
| Contains Daily Banking amount entered on the Daily Banking Screen in POS Administration menu. Writes DB HOS file record whenever amount changed.
|
|
| doorcnt
| Traffic count figures
|
|
| dropd
| Photopro Only
|
|
| droph
| Photopro Only
|
|
| dropscan
| Photopro Only
|
|
| dutycust
| Duty Free customers
|
|
| eftbal
| Temp. table used when writing out balancing G/L entries to work out individual balances based on tenderdetail tender sub code.
|
|
| fifo
| FIFO/LIFO Inventory valuation table
|
|
| genledg
| General Ledger transactions
|
|
| grech
| Goods Receipt Headers
|
|
| hostlog
| Transactions being sent to EEE or 3rd party host. Any transactions not already exported will not be available to EEE or 3rd party.
|
|
| hostlog2
| Holds copies of transactions being sent to EEE or 3rd party host until they are acknowledged. This is where HOS file data is resent from. Only used if acknowledgments turned on.
|
|
| hostloga
| Unacknowledged transactions to EEE or 3rd party host. Not able to confirm that all transactions sent to EEE/3rd party have been processed.
|
|
| ifacelog
| Log File used in old syBize debtors interface
|
|
| inventry
| Inventory file (SOH, etc)
|
|
| journal
| Temp table used to load jounrals when viewing electronic journal
|
|
| kathasn
| Client Code 15 (Kathmandu ASN file)
|
|
| kodaksum
| Photopro Only
|
|
| laybyd
| Products on laybys
|
|
| laybyh
| Layby header details such as customer, payment dates, due dates etc
|
|
| laybyi
| Layby Delivery Details
|
|
| laybyt
| Items already taken from Laybys
|
|
| nonsllog
| Details of non sale transactions
|
|
| orderd
| Customer Order details
|
|
| orderh
| Customer Order header
|
|
| ordert
| Details of items already taken from customer orders
|
|
| porderd
| E Centralised Purchase Order details
|
|
| porderh
| E Centralised Purchase Order header
|
|
| porderl
| E Centralised Purchase Order lines
|
|
| poscash
| Daily Balancing Cash counts - denominations
|
|
| posclear
| Cash Clearances
|
|
| poscsale
| Customer Sales Details for selection customer catgeory in sales updates.
|
|
| posdisc
| POS Discounts given both manual & promotions
|
|
| posdpend
| Inter Branch Transfer Details
|
|
| posdsale
| Details of all sales transactions
|
|
| posdtend
| Tender details for each sales transaction
|
|
| posevent
| Details of each event in the eventlog
|
|
| posfladj
| Float Adjustment Logs
|
|
| poshpend
| Inter Branch Transfer Header
|
|
| poshsale
| Header details for each sale
|
|
| pospurcd
| Purchase Order Details
|
|
| pospurch
| Purchase Order header
|
|
| posssal3
| Sales Summary table used for some reports. Client Code 16 only
|
|
| posssale
| Sales Summary table used for some reports (almalgamation of lantran\posdsales.dbf)
|
|
| posstend
| Balancing information
|
|
| pricechg
| Price Change History
|
|
| refunds
| Refund transactions - Refunds report
|
|
| repairs
| Register of repairs
|
|
| reqlog
| Not Used ??
|
|
| salecmnt
| Comments from repairs, returns, RTS, etc
|
|
| salelogd
| Sales details - used for reprinting dockets
|
|
| salelogh
| Sales header details - used for reprinting dockets
|
|
| salelogi
| Delivery Details for sale - used for reprinting dockets
|
|
| salelogn
| TradeIn details for sales - used for reprinting dockets
|
|
| salelogt
| Tender details for sales - used for reprinting dockets
|
|
| salesum3
| Sales Summary table used for some reports. Client Code 16 only
|
|
| salesumm
| Sales Summary table used for some reports
|
|
| seal
| Bag Seal Numbers for Balancing
|
|
| servplan
| Service Plan Details. Client Code 17 only
|
|
| shift
| Shift sign In/Out table
|
|
| skuparam
| Not Used
|
|
| staffsl
| Staff Sale Details
|
|
| stake
| Stocktake Master file
|
|
| staked
| Stocktake Detail file
|
|
| stakeh
| Stocktake Header File
|
|
| stckwarn
| Client Code 1 Only (No longer Used)
|
|
| stockled
| Stock Ledger (Stock Movements table)
|
|
| strdist
| Store Distribution table used by CPO's
|
|
| suspd
| Suspended Transaction details
|
|
| susph
| Suspended Transaction headers
|
|
| suspi
| Suspended Transaction delivery detail
|
|
| suspn
| Suspended Transaction tradein details
|
|
| target
| Sales targets per date
|
|
| taxhist
| GST transaction details
|
|
| tclock
| Not Used
|
|
| tclock2
| Time clock transactional data
|
|
| tillinfo
| Till information such as program/dll version numbers
|
|
| tlog
| Not Used??
|
|
| tradein
| Trade-In Register
|
|
| tsales
| Contains local sales totals from tills local\sales.dbf
|
|
| ustarget
| User sales targets per date
|
|
| ustatus
| Status of whether users are logged in for time clock system
|
|
| vouchreg
| Register of all vouchers
|
|
| wac
| Last Received Cost and Weighted Average costs. Costs can be exported from EEE.
|
|
| warranty
| Warranty Register (Serial # items or items with a warranty duration defined)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
