Card Transaction — entity reference

One line from a company-card statement: date, merchant, amount, expense category and expense account. Created from the Related tab of the company card (New) or by data import; there is no statement-import feature for card lines. Post books it as debit expense account, credit the card payable account, links the journal and sets Recon Status to Posted. A transaction posts only once. Numbered from the CCT series.

Fields

Field	Label	Type	Required	What it does
`Amount`	Amount	Currency		The amount charged. Not on the create form, so enter it on the record page before posting. Must be greater than zero to post. Changing it after posting does not change the journal.
`BranchId`	Branch	Lookup → Branch		The branch the expense posts under, filtered to the chosen company. Stamped on both journal lines.
`CompanyCardId`	Company Card	Lookup → CompanyCard	Yes	The card the line belongs to. Filled in when you add the transaction from the card's Related tab. Inactive cards are offered too.
`CreatedById`	Created By	Lookup → UserAccount	Yes
`CreatedDateTime`	Created Date	DateAndTime	Yes
`ExpenseCategoryId`	Expense Category	Lookup → ExpenseCategory	Yes	The kind of spend. Required to save. It does not fill in the expense account; choose that yourself.
`ExpenseClaimLineId`	Expense Claim Line	Lookup → ExpenseClaimLine		Optional link to an expense claim line that reports the same spend. A note for reconciliation only: nothing reads it, and claim duplicate checks do not compare claims with card transactions.
`ExpenseGLAccountId`	ExpenseGL Account	Lookup → GLAccount		The expense account debited when the transaction posts. Required by Post, which stops with 'Card transaction needs an expense GL account.' when it is empty. Not defaulted from the expense category.
`GLAccountName`	Name	Text, unique	Yes	Not stored: a value written here is dropped.
`GLId`	GL	Lookup → Journal		The journal posted by Post. Once set, the transaction cannot be posted again, and nothing clears it if the journal is later reversed.
`Id`	Id	Guid	Yes
`MerchantName`	Merchant Name	Text		Where the card was used. Used as the journal reference and on the expense line's narration.
`ModifiedById`	Modified By	Lookup → UserAccount	Yes
`Name`	Name	Text		Set automatically from the CCT numbering series when the transaction is created.
`OwnerId`	Owner	Lookup → UserAccount	Yes
`PartnerAccountId`	Partner Account	Lookup → Account		The company the expense posts to. When empty, the card's company is used.
`ReceiptFileAssetId`	Receipt File Asset	Lookup		An optional receipt file for the line.
`ReconStatus`	Recon Status	Text		Unmatched when created and Posted after Post. Tagged and Reconciled are never set by the system; you may type them in by hand.
`RecordTypeId`	Record Type	Guid, hidden
`TxnDate`	Txn Date	Date		The date on the statement, used as the journal date. Today is used when it is empty.
`UIProps`	UI Props	Text
`UpdatedDateTime`	Modified Date	DateAndTime	Yes

Actions

Action	Label	Type	What it does
`BulkDelete`	Delete	Delete	Delete the selected records.
`Clone`	Clone	ServerAction (`Clone`)	Create a copy of this record
`Delete`	Delete	Delete	Delete this CompanyCardTransaction.
`DeleteRecord`	Delete	Delete	Delete
`Edit`	Edit	Edit	Edit this CompanyCardTransaction.
`EditInLine`	Edit	EditInline	Edit
`EditRecord`	Edit	Edit	Edit
`New`	New	New	Create a CompanyCardTransaction.
`PostCompanyCardExpense`	Post	ServerAction (`PostCompanyCardExpense`)	Posts the tagged statement line to the ledger: Dr its expense GL account / Cr Credit Card Payable (the card's account, falling back to the CreditCardPayable control account), stamping glId and reconStatus Posted. No employee payable is involved - card spend is a company liability. Requires an expense GL account, a positive amount, and a line not already posted.
`View`	View	View	View this CompanyCardTransaction.

Lookup filters

Filter	Lookup field	Notes
BranchFilter	`BranchId`
PartnerAccountFilter	`PartnerAccountId`

Journal — looks up via GLId
GLAccount — looks up via ExpenseGLAccountId
UserAccount — looks up via CreatedById
UserAccount — looks up via OwnerId
ExpenseCategory — looks up via ExpenseCategoryId
UserAccount — looks up via ModifiedById
ExpenseClaimLine — looks up via ExpenseClaimLineId
Branch — looks up via BranchId
UserAccount — looks up via ModifiedById
UserAccount — looks up via CreatedById
Account — looks up via PartnerAccountId
CompanyCard — looks up via CompanyCardId
UserAccount — looks up via OwnerId
Journal — referenced by via SourceRecordId

Card Transaction — entity reference

Fields

Actions

Lookup filters

Related entities

Related topics