Card File Special Purpose Fields generate/en72.jpg


 

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

____________________________

Related Topics:

Card Files

Card File Invoice Generation



Help Topic Map