The file name denotes time frame and how the data is totaled in any data file. The format of the filenames in RDATA and SDATA is as follows:
LD
: Register local daily files (functionally the same as RD)
RD
: Register daily files.
RP
: Register previous day files
SC
: Store consolidation files
SD
: Store current day files
SM
: Store monthly/fiscal period files
SP
: Store previous day files
SW
: Store weekly files
For example:
ld.txn
is the register daily transaction log file
sp.smv
is the consolidated previous day SKU movement file
Register or Local files are found in RDATA on any POS terminal while Store files are found only on the database server or backup server.
Data by drawer and shift are kept in these files:
xxdwr.eee
xxshftn.eee
Where:
xx
represents the first two characters discussed previously.
n
represents the shift number
eee
represents the extension
For example:
lddwr.tot is the current day totals file by drawer.
rpshft2.tot is the previous day totals file for that register for shift number 2