You are here: Reference Guide > Table Structures > Creditors > CR_BatchPayLines

CR_BatchPayLines

Purpose

Line details for cheque payments including foreign currency information made for purchase and creditor invoices

Path    

Creditors   Payments  Cheque Payments

Name

Type

Linked To/Supplied

CR_BatchPayLinesID

Text (20)

 

CR_BatchPayID

Text (20)

CR_BatchPayment.CR_BatchPayID

CR_TransID

Text (20)

CR_Trans.TransID

HomePaymentMade

Number (Float)

 

BatchLineNo

Number (Integer)

 

HistoryText

Text (100)

 

PaymentTransID

Text (20)

CR_Trans.TransID

ChequeNo

Text (20)

 

LedgerID

Text (20)

GL_Ledger.GLLedgerID

HomePaymentExpected

Number (Float)

 

SuppliersPayment

Number (Float)

 

CurrencyRateUsed

Number (Float)

 

FXShortCode

Text (3)

FX_Currency.ShortDescription

DiscountAmount

Number (Float)

 

HomeDiscountAmount

Number (Float)

 

GSTID

Text (20)

 

GSTAmount

Number (Float)

 

GSTRate

Number (Float)

 

DiscountLedgerID

Text (20)

 

LastSavedDateTime

Date/Time

 

CurrencyID

Text (20)

 

UnrealisedGainLoss

Number (Float)

 

RealisedGainLoss

Number (Float)

 

PaymentFromBankFXAmount

Number (Float)

 

BankLedgerID

Text (20)

 

FeeAmount

Number (Float)

 

FeeGSTID

Text (20)

 

FeeGSTRate

Number (Float)

 

FeeGSTAmount

Number (Float)

 

FeeIncGSTAmount

Number (Float)

 

LineNumber

Number (Integer)

 

CR_TransOutstandingAmount

Number (Float)

 

CR_TransOutstandingFXAmount

Number (Float)

 

EFTReference

Text (255)

 


Copyright © 2012 Jiwa Financials. All rights reserved.