Payment method

You enter the methods of payment in this table.

Payment method texts for different languages can be defined in the Text table.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL namePmtMtThe table name in the database.
API identifierpaymentMethodThe API identifier used in GraphQL.
Table no.186The table number in the data model.

The following fields exist in this table:

Account for payment

The Account for payment which is used for cash orders.

When posting 3 - Cash order, the program debits the Account for payment for the Payment method instead of using the customer ledger. The Account for payment field refers to the General ledger account table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL namePmtAcThe database field name.
API identifierpaymentAccountNoThe API identifier used in GraphQL.
Number6716 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociatePaymentCustomer
  • Account for payment
AssociatePaymentSupplier
  • Account for payment
General ledger accountPaymentGeneralLedgerAccount
  • Account for payment
Capital assetPaymentCapitalAsset
  • Account for payment

Cash withdraw account no.

The cash withdrawal Account no.

This account is used for credits to customers.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWitAcThe database field name.
API identifiercashWithdrawAccountNoThe API identifier used in GraphQL.
Number16219 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCashWithdrawCustomer
  • Cash withdraw account no.
AssociateCashWithdrawSupplier
  • Cash withdraw account no.
General ledger accountCashWithdrawGeneralLedgerAccount
  • Cash withdraw account no.
Capital assetCashWithdrawCapitalAsset
  • Cash withdraw account no.

Cash withdraw account type

The cash withdrawal Account type.

A look-up in this field gives you the following list of possible values:
1 - Customer
The account number refer to a customer.
2 - Supplier
The account number refer to a supplier.
3 - General ledger account
The account number refer to a general ledger account.
4 - Capital asset
The account number refer to a capital asset.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount typeInteger
SQL nameWitAcClThe database field name.
API identifiercashWithdrawAccountTypeThe API identifier used in GraphQL.
Number16220 

Description

The description of the payment method that will appear in the Status bar as a check that you have entered the correct value.

This description can also appear in documents, or you can enter descriptions in several languages in the Text table, so that text can be presented in the language of the Cust. no. or Sup. no.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
SQL nameDescrThe database field name.
API identifierdescriptionThe API identifier used in GraphQL.
Number6715 

Payment account type

The account type for the payment method.

A look-up in this field gives you the following list of possible values:
1 - Customer
The account number refer to a customer.
2 - Supplier
The account number refer to a supplier.
3 - General ledger account
The account number refer to a general ledger account.
4 - Capital asset
The account number refer to a capital asset.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount typeInteger
SQL namePmtAcClThe database field name.
API identifierpaymentAccountTypeThe API identifier used in GraphQL.
Number16221 

Payment method

A unique number identifying the Payment method.

Payment method texts for different languages can be defined in the Text table. These texts has text type 7.
Note:
If you double-click or press * in this field, you can look up a Payment method in the Text table.
Note:
If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPayment methodInteger
Primary keyYesPayment method
SQL namePmtMtNoThe database field name.
API identifierpaymentMethodThe API identifier used in GraphQL.
Number6714 

Via ledger

Posting is also done via the customer ledger in addition to the posting to the Account for payment.

The transactions against the customer ledger even out. It affects only the Customer transaction table and not the Open customer entry table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameCustLedgThe database field name.
API identifierviaLedgerThe API identifier used in GraphQL.
Number6717 

Voucher type

The Voucher type which is used for postings if the Via ledger field is selected on the Payment method.

Used if you want to use a different Voucher type for an order with Order type 3 - Cash order than the one entered for the Cash invoice series in the Company information table. If you want the General ledger transaction for the invoice to affect turnover in Customer balance, it is important that you select a Voucher type that does not affect purchases and turnover. You must select the Via ledger field to make the program use the Voucher type from this table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher typeInteger
SQL nameCrVoTpThe database field name.
API identifiervoucherTypeThe API identifier used in GraphQL.
Number13789 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher typeVoucherType
  • Voucher type

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by provenance

The provenance for the record change.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Created by provenance

The provenance for the record creation.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 4. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.