This table contains the import cost details for each shipment by creditor
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.