You are here: Reference Guide > Table Structures > Landed Cost Tables Overview

Landed Cost Tables

The Jiwa Landed Cost system is for importers who have import costs associated with purchasing inventory. The system is an additional module to the main Jiwa product and covers imported costing, deferred GST and variances between the Value of the Taxable Import (VOTI) and the Suppliers invoice value.

When using the landed Cost system, the purchasing (purchase orders) part of Jiwa is the same, but each purchase order can be used by either the existing receivals and purchasing system or picked up by the Landed Cost system.

The landed cost system is a shipment-based system where a shipment is a container carrying goods or a truck containing goods. Each shipment can have goods from multiple suppliers, ordered on multiple purchase orders.

The landed cost system has two main data entry forms:

The master shipment form that maintains and controls all values and costings

The booking in form that is designed for warehouse use and allows the physical movement of the inventory

Table Details

There can be many booking in documents for each shipment.

The table SH_Main stores the header details for each shipment. SH_Lines records specific details about each line on that shipment.

The table SH_BookInMain is used to store the header details for the booking in documents. SH_BookInLines keeps track of the inventory part number, quantity and cost details for individual booking in lines. SH_BookInDetailLines maintains the serial number and bin location details.

Additional Information

Additional landed cost details are stored in:

SH_Costs – cost details for each shipment and creditor

SH_CostTypes – cost descriptions

SH_Invoices – invoice details for shipments

SH_PurchaseOrders – purchase order details for shipments

SH_ApportionedCostsAmounts- apportioned cost amounts for shipment lines

SH_ApportionedCostsOnPO – apportioned costs for purchases orders

SH_Voti - variances between the Value of the Taxable Import (VOTI) and the supplier invoice value for shipments

Copyright © 2012 Jiwa Financials. All rights reserved.

SH_ApportionedCostsAmounts

SH_ApportionedCostsOnPO

SH_BookInDetailLines

SH_BookInDetailLinesCostAudit

SH_BookInLines

SH_BookInMain

SH_Costs

SH_CostTypes

SH_Invoices

SH_Lines

SH_Main

SH_PurchaseOrders

SH_Voti