Low Level Documentation
 
Library Fieldpine Internals Replication Gds Security Fpos.dll Startup logic PosGreen Network PosGreen Install Process Multicast Protocol Data Structures Settings Logic Trace

Logic

Security Model Product Distribution Gateways Staff Login Stock Levels Shipping Addresses Agency Stores Remote Reports

PosGreen Engine This engine provides the bulk of the POS processing at checkouts. It can be used directly or via central servers as a remote service.

Contexts & Sessions

Advanced

Spill Database Debugging

Reference Data

refdata Country refdata SystemString

Shipping/Delivery Addresses

Shipping or delivery addresss can be maintained for sales to record where the item was shipped too.

Database

The field sale.deliveryphyskey links to sale_delivery.physkey

The table sale_delivery has a record for each sale, even if the same address is used multiple times. This duplication is intentional so that actual values can be historically retrieved.

The table contactdetails holds reference addresses that can be used as a search function. This table holds contact details for several areas, so that a customer and a supplier might both point to the same record.

To scan for all reference delivery addresses for a customer, use a query similiar to this

select ... from contactdetails, multilink_all
where contactdetails.physkey = multilink_all.physkeyc
and   multilink_all.physkeyp = { Customers Physkey }
and   multilink_all.linktype = 1

To retrieve all delivery addresses used by a customer

select ... from sales, sale_delivery
where sales.deliveryphyskey = sale_delivery.physkey
and   sales.cid = { Customers Id }