You are here: Reference Guide > Table Structures > Landed Cost > SH_Costs

SH_Costs

Purpose    

This table contains the import cost details for each shipment by creditor

Path         

Landed Cost Import Costs

Name

Type

Linked To/Supplied

CostsID

Text (20)

 

ShipmentID

Text (20)

SH_Main.ShipmentID

CreditorID

Text (20)

 

CostType

Text (50)

 

FXAmount

Number (Float)

 

FXRate

Number (Float)

 

CurrencyID

Text (20)

 

HomeAmount

Number (Float)

 

GSTAmount

Number (Float)

 

GSTRate

Number (Float)

 

GSTID

Text (20)

 

TotalAmount

Number (Float)

 

ApportionMethod

Number (Integer)

 

Apportioned

Yes/No

 

Invoiced

Yes/No

 

CR_TransID

Text (20)

 

DueDate

Date/Time

 

InvoiceNo

Text (50)

 

Reference

Text (50)

 

CreditorLedgerID

Text (20)

 

LedgerID

Text (20)

 

ColumIncludeUserCaption

Text (50)

 

ColumnIncludeVisible

Yes/No

 

ColumnIncludeWidth

Number (Integer)

 

ColumnAmountUserCaption

Text (50)

 

ColumnAmountVisible

Yes/No

 

ColumnAmountWidth

Number (Integer)

 

UserField1 to UserField10

Text (255)

 

HomeClearedAmount

Number (Float)

 

LastSavedDateTime

Date/Time

 

AUDDecimalPlaces

Number (Integer)

 

FXDecimalPlaces

Number (Integer)

 

InvoiceDate

Date/Time

 

Copyright © 2012 Jiwa Financials. All rights reserved.