Cash Book Receipts or PaymentsLine details for cash book receipts and payments including debtor and creditor linking and foreign exchange details.
General Ledger Cash Book Receipts or Payments
|
Name |
Type |
Linked To/Supplied |
|
CBBatchTranLineID |
Text (20) |
|
|
CBBatchID |
Text (20) |
CB_BatchTrans.CBBatchID |
|
OffsetLedgerID |
Text (20) |
GL_Ledger.GLLedgerID |
|
RemitNo |
Text (50) |
|
|
Ref |
Text (20) |
|
|
DebtorCreditor |
Number (Integer) |
1 = Debtor; 2 = Creditor; 0 = Neither |
|
DebtorCreditorID |
Text (20) |
DB_Main1.DebtorID or CR_Main1.CreditorID |
|
TransType |
Number (Integer) |
2 = Receipt; 10 = Payment; 0 = Neither |
|
Remark |
Text (200) |
|
|
LineNum |
Number (Integer) |
|
|
HomeAmount |
Number (Float) |
|
|
GroupNo |
Number (Integer) |
|
|
TranDate |
Date/Time |
|
|
DiscountLedgerID |
Text (20) |
GL_Ledger.GLLedgerID |
|
HomeDiscountTaken |
Number (Float) |
|
|
SupplierAmount |
Number (Float) |
|
|
CurrencyRateUsed |
Number (Float) |
|
|
SupplierDiscountTaken |
Number (Float) |
|
|
ParentDebtorID |
Text (20) |
DB_Main.DebtorID |
|
BankName |
Text (50) |
|
|
BankAcc |
Text (50) |
|
|
BSBN |
Text (20) |
|
|
AccountName |
Text (50) |
|
|
AllocatedAmount |
Number (Float) |
|
|
PaymentTypeID |
Text (20) |
SO_PaymentTypes.TypeID |
|
Approval |
Text (255) |
|
|
UpdateDebtorBankDetails |
Yes/No |
0 = No; 1 = Yes |
|
GSTRateID |
Text (20) |
|
|
GSTRate |
Number (Float) |
|
|
GSTAmount |
Number (Float) |
|
|
DiscountGSTRateID |
Text (20) |
|
|
DiscountGSTRate |
Number (Float) |
|
|
DiscountGSTAmount |
Number (Float) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.