Edit

Transactions

Internal Name Transaction. The details (transaction lines) are held in a separate file with the internal name Detail, with Detail.ParentSeq holding the sequence number of the parent transaction.

FieldTypeSizeNotes
AgingNThe aging cycle for the transaction
AmtPaidNThe amount of the invoice that has been paid
AmtWrittenOffNFor invoices, the amount written off in a write-off
AnalysisT9The analysis field.
ApprovedBy1T3Initials of first user to approve transaction. This field can only be set to the current user's initials (or blank) using a script.
ApprovedBy2T3Initials of second user to approve transaction. This field can only be set to the current user's initials (or blank) using a script.
BankJNSeqNThe sequence number of the journal which banked the receipt (using the Banking command)
ColourNThe colour, represented internally as a numeric index in the range 0-7 but rendered as a textual colour name
ContraT7For CP and CR transactions, this contains the account code of the bank that was selected in the bank pop-up menu. For invoices this is the accounts payable/receivable control acct.
DatePaidDThe date the last payment for an invoice was made
DeliveryAddressT255The delivery address for this transaction. Blank if default from name.
DescriptionT1000The description of the transaction.
Detail.AccountT14A text string containing the account code- (or account-department code) from the detail line
Detail.BackorderQtyNThe amount currently on backorder for an order
Detail.BaseCurrencyNetNThe detail.net amount converted to the base currency
Detail.CostPriceNThis is the base currency buy-price of the product. It is represented as dollars per buying unit for a purchase or as dollars per selling unit. for a sale. For a sale, the cost price is taken from the AverageValue of the product.
Detail.CreditNThe credit value of the detail line. This is the amount by which the account is credited when the transaction gets posted. It corresponds to the Net or Extension for a CP or CI.
Detail.DateDThe date on the detail line (also the expiry date for time-limited batches)
Detail.Custom1T31Scriptable text
Detail.Custom2T31Scriptable text
Detail.DebitNThe debit value of the detail line. This is the amount by which the account is debited when the transaction gets posted. It corresponds to the Net or Extension for a CR or DI.
Detail.DeptT5The department code
Detail.DescriptionT1020The description for the detail line.
Detail.DiscountNThe percent discount for the line.
Detail.ExpensedTaxNThe amount of non-claimable sales tax on the line (only set for transactions of type CI and CP that involve sales tax). When a line is saved, the net is adjusted up by this amount and the tax down; when the transaction is viewed, the reverse happens.
Detail.FlagsNSee Detail Flags table below, and detail.moreFlags
Detail.GrossNThe gross value of the detail line.
Detail.JobCodeT9This is the job code for the detail line.
Detail.MoreFlagsNFor more flags, see flags table below
Detail.NonInvRcvdNotInvoicedQtyNThe quantity of non-inventoried items on an order received but not invoiced
Detail.OrderQtyNThe original order quantity for an order
Detail.OrderStatusB0 if not shipped or part shipped, 1 if fully shipped
Detail.OriginalUnitCostNThe unit cost of an inventoried item before the transaction was posted (available for some lines involving stock replenishment)
Detail.ParentSeqNThe sequence number of the parent transaction
Detail.PeriodNSame as the transaction Period field
Detail.PeriodNSame as the transaction Period field
Detail.PostedQtyNFor stock purchase transactions, the buy quantity adjusted for the product conversion factor, gives the qty in sell units, which is the posted qty.
Detail.SaleUnitA3For product transaction detail lines, this is the selling unit of measure as copied from the product record.
Detail.SecurityLevelNThe security level of the line (inherited from the account's security level)
Detail.SerialNumberNThe items's serial/batch number
Detail.StatementNThe sequence number for the reconciliation record for which this detail line was reconciled. It is normally only used for detail lines which specify a bank account. If the item is not yet reconciled it contains a 0 (or a -1 if the reconciliation has been saved but not finalised).
Detail.StockCodeT19The product code for the detail line. This will be blank if the transaction is a service-type transaction.
Detail.StockLocationT15The item's location
Detail.StockQtyNThe quantity of the product specified by Detail.StockCode that is being purchased or sold. The units correspond to either the buyUnits for the product or the SellUnits for the product depending on whether this is a purchase (CP/CI) or a sale (CR/DI) transaction.
Detail.SortNThe order of the detail lines as displayed in a transaction.
Detail.TaggedTextT255Scriptable tag storage
Detail.TaxNThe tax (GST, VAT etc) amount of the detail line.
Detail.TaxCodeA5The tax code of the account.
Detail.TransactionTypeThe first two characters of the transaction type (i.e. CP, CR, CI, DI, JN, PO, SO, QU)
Detail.UnitPriceNFor a purchase, this is the same as the cost price. For a sale, this is the unit selling price of the product exclusive of GST and discount.
Detail.UserNumNScriptable number
Detail.UserTextT255Scriptable text
DueDateDThe date on which payment is due
EmailedNNon zero if transaction has been emailed
EnterDateDThe date on which the transaction was entered.
EnteredByA3Initials of user who entered the transaction
ExchangeRateNThe exchange rate (0 for base currency transactions)
FlagT5The flag field.
FlagsNSee Transaction Flags table below
FreightAmountNFreight amount of order
FreightCodeT15Freight code used for orders
FreightDetailsT255Details of freight for order
GrossNThe gross value of the transaction.
HoldBTrue if the transaction is on hold
LastModifiedTimeSThe date that the transaction was last changed.
MailingAddressT255Transaction's mailing address. Blank if default from name.
NameCodeT11Customer or Supplier Code
OrderDepositNThe accumulated deposit on an order
OrderShippedNThe amount shipped of an order
OrderTotalNThe total of the order
OriginatingOrderSeqNThe sequence number of the order that created the invoice through the ship or receive goods commands
OurRefT11The reference number of the transaction. For Cash Payments, this is the cheque number. For Cash Receipts it is the receipt number. For Debtor Invoices, it is the invoice number and for Creditor Invoices it is your order number. For Journals, it is the Journal number, prefixed with the type of journal (JN for general journal, JS for stock journal, BK for banking journal).
PayAmountNThe amount of the invoice that you have elected to pay a creditor in the next payment run.
PaymentMethodNThe payment method for the transaction (0 = None, 1 = Cash, 2 = Cheque, 3 = Electronic, 4 = Credit Card, 5-7 = user defined)
PeriodNA number representing the period of the transaction. This number will be (100 * year_number + period_number), where year_number is a number in the range 0-99, with year 1 being the first year of operation for your MoneyWorks document, and period_number is a number in the range 1-12, with 1 representing the first period of your financial year.
PostedByA3Initials of user who posted the transaction
PrintedN0 if not Printed; 1 if Printed
ProdPriceCodeT1Pricing code (A--F)
PromptPaymentAmtNThe amount of the eligible prompt payment discount
PromptPaymentDateDThe date the prompt payment discount expires
RecurringB"True" if the transaction is a recurring transaction. "False" if it isn't.
SalesPersonT5The salesperson for the transaction. If the transaction involves any products with the "Append Salesperson" attribute set, the value of this field will be appended to that products sales and/or cost of goods account code.
SecurityLevelNThe transaction's security level. This is set to the highest security level of the visible detail lines.
SequenceNumberNThe sequence number of the transaction.
SpecialAccountFor receipts, the bank account of the cheque
SpecialBankFor receipts, the bank number of the cheque
SpecialBranchFor receipts, the branch of the cheque
StatusT1This will be either a "U" (for unposted) or "P" (for posted).
TaggedTextT255Scriptable tag storage
TaxAmountNThe amount of GST involved for the transaction.
TaxCycleNA number representing the GST cycle in which the transaction was processed for GST. This is 0 for transactions not yet processed for GST.
TheirRefT21For debtor invoices, the customer's Order No. For creditor invoices, the supplier's invoice number. For receipts, the cheque number
TimePostedSDate and time transaction is posted.
ToFromT200For a payment, the To field. For a receipt, the From field.
TransDateDThe transaction date.
TransferredNNon zero if transaction has been sent as eInvoice
TypeT3The transaction type.--see following table.
User1T255User defined
User2T255User defined
User3T255User defined
User4T15User defined
User5T15User defined
User6T15User defined
User7T15User defined
User8T15User defined
UserNumNScriptable number
UserTextT255Scriptable text

The transaction type codes are:

CodeDescription
CICCreditor invoice--fully paid
CIICreditor invoice--incomplete
CPCash payment/purchase
CPCCash payment for a creditor invoice
CPDReturned refund to debtor
CRCash receipt/sale
CRCReceive refund from creditor
CRDReceipt for a debtor invoice
DICDebtor invoice--fully paid
DIIDebtor invoice--incomplete
JNGeneral journal
JNSStock journal
POCPurchase order (complete) = Bought
POIPurchase order (incomplete)
QUQuote
SOCSales order (complete) = Sold
SOISales order (incomplete)

Transaction Flags

Use TestFlags() to determine flags.

Was Cancelled0x00000001Is Job Invoice0x00002000
Is Cancellation0x00000002Changed After Posting0x00004000
Was Written Off0x00000004Prompt Discount Taken0x00008000
Creditor Reimburse0x00000008Funds Xfer0x00010000
Debtor Reimburse0x00000010Is Discount Credit Note0x00020000
Printed0x00000020Is Writeoff Credit Note0x00040000
Is WriteOff Dummy0x00000040Is New Style Sales Tax0x00080000
Is Contra Dummy0x00000080Has Scan0x00100000
Journal Type (3 bits)
  General = 0; Make = 1;
  Break = 2; WriteOff = 4;
  Create = 5; Transfer = 6;
  Revaluation = 7.
0x00000700Has Outstanding Stock Receipts0x00200000
Not On Statement0x00000800PPD Terms Locked0x00400000
Is Banking Journal0x00001000Is Deposit on Order0x00800000

Detail Flags

Flags for detail lines are contained in two fields, detail.flags and detail.moreFlags. Use TestFlags() to determine flags.

detail.flags
System line0x8000Line is a foreign currency 0x0100
Stock Journal Line 0x4000Balancing line for above 0x0200
Banking Journal Bank Line 0x2000Balancing line for contra 0x0400
Banking Journal Holding Line 0x1000Stock is ignored (for jobs) 0x0800
Tax Line 0x0008Tax line added by tax override 0x0010
Product Price is Tax Inclusive 0x0004Is time item 0x0020
Freight Item 0x0002Prompt Payment Discountable 0x0040
Dept in account is salesperson 0x0001
detail.moreFlags
Requires serial number 0x0001Batch expires 0x0004
Requires batch number 0x0002