You are here: Reference Guide > Table Structures > Receipts > RE_Lines

RE_Lines

Purpose

Stores the line details for receiving slips that detail goods and services received, including freight, duty and insurance costings.

Path         

Purchase Orders Receive Inventory

Name

Type

Linked To/Supplied & Supplied Values

OrdersPSLinesID

Text (20)

 

PackSlipID

Text (20)

 

OrderID

Text (20)

PO_Main.OrderID

OrderLineID

Text (20)

PO_Lines.OrderLineID

Quantity

Number (Float)

 

HomeLandedCost

Number (Float)

 

SuppliersCost

Number (Float)

 

InventoryID

Text (20)

IN_Main.InventoryID

Freight

Number (Float)

 

Duty

Number (Float)

 

PartNo

Text (50)

 

Description

Text (255)

 

SuppPartNo

Text (50)

 

LineType

Number (Integer)

1 = Normal;2 = Non stock

DecimalPlaces

Number (Integer)

 

LastSavedDateTime

Date/Time

 

Insurance

Number (Float)

 

ClassificationID

Text (20)

IN_Classification.ClassificationID

ClassDescription

Text (50)

 

TaxAmount

Number (Float)

 

TaxID

Text (20)

TX_Main.TaxID

TaxRate

Number (Float)

 

TaxInc

Number (Integer)

 

JobCostID

Text (20)

 

JobConnectorID

Text (20)

 

HomeSuppliersCost

Number (Float)

 

CurrencyRateUsed

Number (Float)

 

POClassID

Text (20)

PO_Classification.POClassificationID

UsesStdCost

Yes/No

 

StandardHomeCost

Number (Float)

 

FreightTaxID

Text (20)

 

FreightTaxRate

Number (Float)

 

FreightTaxAmount

Number (Float)

 

DutyTaxID

Text (20)

 

DutyTaxRate

Number (Float)

 

DutyTaxAmount

Number (Float)

 

InsuranceTaxID

Text (20)

 

InsuranceTaxRate

Number (Float)

 

InsuranceTaxAmount

Number (Float)

 

PostedtoWIP

bit

 

JobCharge

decimal

 

Copyright © 2012 Jiwa Financials. All rights reserved.