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

CR_BatchTranLines

Purpose

Details the line information on the creditor transactions sourced from the creditor Transaction Form Tab and the creditor menu options - Invoices and Payments

Path    

Creditor Receipts, Creditor Discounts, Creditor Invoices, Creditor Credit and Debit Journals and Notes

Name

Type

Linked To/Supplied

ReceiptLineID

Text (20)

 

ReceiptID

Text (20)

CR_BatchTrans.ReceiptID

LastSavedDateTime

Date/Time

 

AccountID

Text (20)

CR_Main1.CreditorID

LedgerID

Text (20)

GL_Ledger.GLLedgerID

LineReference

Text (50)

 

Remark

Text (50)

 

RemitNo

Text (50)

 

HomeTransAmount

Number (Float)

 

CRTransID

Text (20)

CR_Trans.TransID

LineNum

Number (Long)

 

OtherLedgerID

Text (20)

GL_Ledger.GLLedgerID

HomeDispAmount

Number (Float)

 

ReceiptDate

Date/Time

 

SupplierTransAmount

Number (Float)

 

SupplierDispAmount

Number (Float)

 

CurrencyRateUsed

Number (Float)

 

TaxID

Text (20)

TX_Main.TaxID

TaxRate

Number (Float)

 

TaxAmount

Number (Float)

 

TaxLedgerID

Number (Float)

GL_Ledger.GLLedgerID

DueDate

Date/Time

 

HomeDispAmountIncTax

Number (Float)

 

CurrencyID

Text (20)

 

JobNo

Text (20)

 

JobChargeAmount

Text (20)

 

Copyright © 2012 Jiwa Financials. All rights reserved.