Card File Special Purpose Fields ![]()
This section lists the fields reserved for special purposes for card files. Fields highlighted with an asterisk (*) are required for invoice transaction generation. (Do not include the * when entering the field's name.)
|
General Purpose Card File Fields | |
|
Datetoday |
The system date. |
|
Department |
Character type. The department code. |
|
PCode |
Character Type. Product code look-up. |
|
Customer Related Card File Fields | |
|
*Amount |
Numeric Type. This holds the value/amount of the transaction to generate. |
|
*CCode |
Character type. This holds the customer account code. |
|
*Date |
Date type. This holds the transaction date. |
|
Datedue |
Date type. The date the transaction falls due. |
|
DAddress |
Character type. The delivery address. |
|
DPostcode |
Character type. The delivery address postcode. |
|
DState |
Character type. The transaction's delivery state. |
|
DSuburb |
Character type. The transaction's delivery suburb. |
|
*Invoiceno |
Character type. The invoice/transaction number. Note: This is not mandatory but strongly recommended. |
|
Ourref |
Character type. Transaction other reference. |
|
Ourref2 |
Character type. The transaction 2nd other reference. |
|
Ourref3 |
Character type. The transaction 3rd other reference. |
|
Reference |
Character type. The transaction's reference. |
|
Shipped |
The transaction shipping address. |
|
State |
Character type. The transaction's state. |
|
Postcode |
Character type. The transaction's postcode. |
|
Address |
Character type. The transaction's first address line. |
|
Address2 |
Character type. The transaction's second address line. |
|
Suburb |
Character type. The transaction's suburb. |
|
Tax |
Character type. The tax rate. If not specified, the system wide default tax rate is used. |
|
Tran |
Character type. The transaction type. This may be between 1-8. Do not specify a transaction type that is a payment. If a transaction type is not specified or is illegal, the default transaction type becomes 1. |
|
Supplier Related Card File Fields | |
|
Allocno |
Character type. This is a transaction number. You can specify a transaction to credit/allocate by placing a number here. For example, if you entered 5000 in this field, transaction number 5000 would be credited with the value in the Amount field. CAPITAL will reject the processing of the transaction if the allocation cannot take place. (This could be because the transaction has already been allocated/credited, does not exist, etc.) |
|
*Amount |
Numeric type. This holds the value/amount of the transaction to generate. |
|
*Date |
Date type. This holds the transaction date. |
|
Details |
Character type. Hold's the transaction's reference details line. |
|
Expense |
Character type. The supplier invoice's expense or general ledger code. If not specified the expense code assigned to the supplier's account is used. Note: You must assign an expense code to either the EXPENSE field on the card file or to the supplier's account. CAPITAL will not be able to generate supplier invoices if neither is specified. (Applies to General Ledger.) |
|
GST |
Numeric type. The amount of GST to allocate to the supplier invoice. |
|
*Invoiceno |
Character type. The invoice/transaction number. When generating supplier invoices you should use the Tranno field instead of Invoiceno unless you wish to generate a customer invoice and supplier invoice simultaneously, from the same card file record. In this case, if Invoiceno exists, CAPITAL will attempt to assign the transaction number in Invoiceno to the supplier invoice/transaction as well. The actual transaction number issued is placed in Tranno. |
|
Reference |
Character type. The transaction's reference. |
|
*SCode |
Character type. This holds the supplier's account code. |
|
Tran |
Character type. The transaction type. This may be between 1-8. Do not specify a transaction type that is a payment. If a transaction type is not specified or is illegal, the default transaction type becomes 1. |
|
*Tranno |
Character type. The invoice/transaction number. Note: This is not mandatory but strongly recommended. |
|
Service Manager Related Card File Fields | |
|
Item |
Character type. The Service Manager item reference. |
|
Stage |
Character type. The Service Manager stage reference. |
|
Job |
Character type. The Service Manager job number. |
|
Jobrate |
Character type. The job rate code. |
Special Notes
Tax such as GST is calculated automatically for customer invoices if a GST tax rate is defined in the card file.
Tax is not calculated automatically for supplier invoices. The tax amount must be specified in the GST field.
____________________________
Related Topics:
![]() |