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

SO_Payments

Purpose    

Details the payments receipted in the Payments tab of a sales order

Path     

Sales Orders Payments tab   

Name

Type

Linked To/Supplied

PaymentID

Text (20)

 

InvoiceHistoryID

Text (20)

SO_History.InvoiceHistoryID

InvoiceID

Text (20)

SO_Main.InvoiceID

PaymentTypeID

Text (20)

SO_PaymentTypes.PaymentTypeID

PaymentRef

Text (255)

 

AmountPaid

Number (Float)

 

PaymentDate

Date/Time

 

AuthorisationStatus

Number (Integer)

 

AusthorisationNumber

Text (255)

 

ProcessPayment

Yes/No

0 = No; 1 = Yes

Processed

Yes/No

0 = No; 1 = Yes

DBTransID

Text (20)

DB_Trans.DBTransID

Copyright © 2012 Jiwa Financials. All rights reserved.