You are here: Reference Guide > Table Structures > Purchase Invoice > PI_Main

PI_Main

Purpose    

Details the header records for purchase invoices including freight, duty and insurance charged on the total invoice.

Path         

Purchase Orders Purchase Invoices

Name

Type

Linked To/Supplied & Supplied Values

PI_MainID

Text (20)

 

LastSavedDateTime

Date/Time

 

InvoiceNo

Text (50)

 

CreditorID

Text (20)

CR_Main1.CreditorID

InvoiceDate

Date/Time

 

Status

Number (Integer)

0 = Entered Only;1 = Activated

Freight

Number (Float)

 

Duty

Number (Float)

 

Insurance

Number (Float)

 

DueDate

Date/Time

 

IN_LogicalID

Text (20)

IN_Logical.IN_LogicalID

TotalLineTax

Number (Float)

 

AdjTax

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)

 

CurrencyID

Text (20)

FX_Currency.CurrencyID

DecimalPlaces

Number (Integer)

 

FXDecimalPlaces

Number (Integer)

 

Copyright © 2012 Jiwa Financials. All rights reserved.