You are here: Reference Guide > Table Structures > Sales Orders > SO_Main

SO_Main

Purpose    

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

Path        

Sales Order, Main Form Tab

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)

0 = Entered;1 = Processed + Back orders;2 = Processed / Closed;3 = Unprocessed & invoice printed

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

0 = No; 1 = Yes

IN_LogicalID

Text (20)

IN_Logical.IN_LogicalID

BranchID

Text (20)

 

SOReference

Text (50)

 

JobCostID

Text (20)

 

ParentDebtorID

Text (20)

DB_Main1.DebtorID

BackOrderMode

Number (Integer)

0 = Normal;1 = Manual

DebtorContactName

Text (50)

 

DocType

Yes/No

0 = Order;1 = Invoice

GSTInvoice

Yes/No

 

ExpectedDeliveryDate

Date/Time

 

SourceQuoteHistoryID

Text (20)

 

PriceSchemeID

Text (20)

 

CreditReasonID

Text (20)

SO_CreditReasons.CreditReasonID

CreditIntoStock

Yes/No

0 = No; 1 = Yes

InvoiceEmailed

tinyint

 

Copyright © 2012 Jiwa Financials. All rights reserved.