Purpose
Details all debtor transactions sourced from both Sales Order processing - sales orders and credit notes; and from debtor transactions - receipts, discounts, debtor invoices, debit and credit journals and notes
Path
Process Sales Orders, Cash Receipts and Cash Book Payments, Debtor sourced transcations - invoices and adjustments
| Name | Type | Linked To/Supplied & Supplied Values |
|---|---|---|
| DebtorID | Text (20) | DB_Main1.DebtorID |
| DebitCredit | Yes/No | 0 = Credit;1 = Debit |
| Source | Number (Integer) | 0 = Sales Orders;1 = Debtor Sourced Transactions;2 = Cash Book |
| Ref | Text (20) | |
| TransID | Text (20) | |
| Remark | Text (200) | |
| TranDate | Date/Time | |
| InvRemitNo | Text (50) | |
| Amount | Number (Float) | |
| DiscountedAmount | Number (Float) | |
| AgedOut | Yes/No | 0 = No; 1 = Yes |
| SourceID | Text (20) | DB_BatchTrans.ReceiptID; DB_BatchTrans.CBBatchID; SO_Main.InvoiceID |
| AllocatedAmount | Number (Float) | |
| InitDateTime | Date/Time | |
| LastSavedDateTime | Date/Time | |
| SubType | Number (Integer) | 1 = Invoice;2 = Debit Note;3 = Debit Journal;10 = Payment;11 = Credit Note;12 = Credit Journal; 99 = Import transactions |
| BatchNo | Text (20) | |
| ChildDebtorID | Text (20) | DB_Main1.DebtorID |
| GSTAmount | Number (Float) | |
| DueDate | Date/Time | |
| FXAmount | Number (Float) | |
| FXAllocAmount | Number (Float) | |
| CurrencyRateUsed | Number (Float) | |
| RealisedGainLoss | Number (Float) | |
| UnRealisedGainLoss | Number (Float) | |
| CurrencyID | Text (20) | FX_Currency.CurrencyID |
| Cartage1Amount | Number (Float) | |
| Cartage1TaxAmount | Number (Float) | |
| Cartage2Amount | Number (Float) | |
| Cartage2TaxAmount | Number (Float) | |
| Cartage3Amount | Number (Float) | |
| Cartage3TaxAmount | Number (Float) | |
| FXDecimalPlaces | Number (Integer) | |
| DecimalPlaces | Number (Integer) |
Copyright © 2012 Jiwa Financials. All rights reserved.