One imported corporate-card statement line: date, merchant, amount, and the expense category / expense GL account the employee tags it with, optionally linked to an ExpenseClaimLine and a receipt file. reconStatus tracks the pipeline (Unmatched, Tagged, Posted, Reconciled); the PostCompanyCardExpense action posts it Dr expense / Cr Credit Card Payable and stamps it Posted. Statement import reuses the banking statement-import path.
Fields
| Field | Label | Type | Required | What it does |
|---|
Amount | Amount | Currency | | |
BranchId | Branch | Lookup → Branch | | |
CompanyCardId | Company Card | Lookup → CompanyCard | Yes | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
ExpenseCategoryId | Expense Category | Lookup → ExpenseCategory | Yes | |
ExpenseClaimLineId | Expense Claim Line | Lookup → ExpenseClaimLine | | Optional link tying the statement line to the ExpenseClaimLine that reported the same spend - the matching key between the employee's claim and the card statement. Card spend posts from this transaction against the card payable; it is not re-posted through the claim. |
ExpenseGLAccountId | ExpenseGL Account | Lookup → GLAccount | | The expense head debited when the transaction posts - required by the posting action, which fails without it. Usually defaulted from the tagged expense category. |
GLAccountName | Name | Text, unique | Yes | |
GLId | GL | Lookup → Journal | | |
Id | Id | Guid | Yes | |
MerchantName | Merchant Name | Text | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | |
ReceiptFileAssetId | Receipt File Asset | Lookup | | |
ReconStatus | Recon Status | Text | | Statement-line pipeline: Unmatched (imported), Tagged (categorised by the employee), Posted (stamped by the posting action together with glId), Reconciled. A transaction with glId set cannot post again. |
RecordTypeId | Record Type | Guid, hidden | | |
TxnDate | Txn Date | Date | | |
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 | |
