You are here: Reference Guide > Table Structures > Quotation > QO_Main

QO_Main

Purpose    

Details the header record for sales order and credit note information.

Path    

Sales Order Entry Quoting

Name

Type

Linked To/Supplied & Supplied Values

InvoiceID

Text (20)

 

LastSavedDateTime

Date/Time

 

DebtorID

Text (20)

DB_Main1.DebtorID

StaffID

Text (20)

HR_Staff.StaffID

InvoiceNo

Text (20)

 

InvoiceInitDate

Date/Time

 

InvoiceLastDate

Date/Time

 

OrderNo

Text (50)

 

TaxExemptNo

Text (20)

 

WholeSaleInvoice

Yes/No

0 = No; 1 = Yes

InvoiceTotal

Number (Float)

 

InvoicePrinted

Yes/No

0 = No; 1 = Yes

CurrentHistoryNo

Number (Integer)

 

Status

Number (Integer)

 

BillWhenComplete

Number (Integer)

0 = Ship & Bill;1 = Bill/Complete;
2 = Ship/Complete

CreditNote

Yes/No

 

InvoiceType

Number (Integer)

0 = Normal;<>0 = Back to  back

GroupSupplierID

Text (20)

IN_Creditor.CreditorID

GroupOrdered

Yes/No

 

IN_LogicalID

Text (20)

IN_Logical.IN_LogicalID

BranchID

Text (20)

SY_Branch.BranchID

QOReference

Text (50)

 

JobCostID

Text (20)

JC_Main

DocType

Yes/No

 

BackOrderMode

Number (Integer)

 

ExpectedDeliveryDate

Date/Time

 

DebtorContactName

Text (50)

 

ParentDebtorID

Text (20)

DB_Main.DebtorID

PriceSchemeID

Text (20)

 

Copyright © 2012 Jiwa Financials. All rights reserved.