CA
CABankTransactionsImport.CABankTran2
PX.Objects.CA121 of 121 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TranID | int | ID | - | |
Description:No description available | ||||
AcctNameNonexistent in DB | int | Business Account Name | BAccount | |
Description:No description available | ||||
AllowedOperations | nvarchar(2) | Allowed Operations | - | |
Description:No description available | ||||
ApplyRuleEnabledNonexistent in DB | bit | Create Rule Enabled | - | |
Description:No description available | ||||
CardNumber | varchar(25) | Card Number | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
ChargeDrCr | char(1) | - | ||
Description:No description available | ||||
ChargeTaxCalcMode | nchar(1) | Charge Tax Calculation Mode | - | |
Description:No description available | ||||
ChargeTaxZoneID | nvarchar(10) | Charge Tax Zone | TaxZone | |
Description:No description available | ||||
ChargeTypeID | nvarchar(10) | Charge Type | CAEntryType | |
Description:No description available | ||||
ClearDateNonexistent in DB | datetime | - | ||
Description:No description available | ||||
ClearedNonexistent in DB | bit | - | ||
Description:No description available | ||||
CountAdjustments | int | - | ||
Description:No description available | ||||
CountExpenseReceiptDetailMatchesNonexistent in DB | int | CountExpenseReceiptDetailMatches | - | |
Description:No description available | ||||
CountInvoiceMatchesNonexistent in DB | int | CountInvoiceMatches | - | |
Description:No description available | ||||
CountMatchesNonexistent in DB | int | CountMatches | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CreateDocument | bit | Create | - | |
Description:No description available | ||||
CuryApplAmt | decimal | Application Amount | - | |
Description:No description available | ||||
CuryApplAmtCA | decimal | Detail Total | - | |
Description:No description available | ||||
CuryApplAmtMatch | decimal | Matched Amount | - | |
Description:No description available | ||||
CuryApplAmtMatchToInvoiceNonexistent in DB | decimal | Matched Amount | - | |
Description:No description available | ||||
CuryApplAmtMatchToPaymentNonexistent in DB | decimal | Matched Amount | - | |
Description:No description available | ||||
CuryChargeAmt | decimal | Charge Amount | - | |
Description:No description available | ||||
CuryChargeTaxAmt | decimal | Charge Tax Amount | - | |
Description:No description available | ||||
CuryCreditAmtNonexistent in DB | decimal | Disbursement | - | |
Description:No description available | ||||
CuryDebitAmtNonexistent in DB | decimal | Receipt | - | |
Description:No description available | ||||
CuryDetailsWithTaxesTotal | decimal | Amount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryTaxRoundDiff | decimal | Rounding Diff. | - | |
Description:No description available | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:No description available | ||||
CuryTotalAmtNonexistent in DB | decimal | Total Amount | - | |
Description:No description available | ||||
CuryTotalAmtCopyNonexistent in DB | decimal | Transaction Amount | - | |
Description:No description available | ||||
CuryTotalAmtDisplayNonexistent in DB | decimal | Transaction Amount | - | |
Description:No description available | ||||
CuryTranAmt | decimal | CuryTranAmt | - | |
Description:No description available | ||||
CuryUnappliedBalNonexistent in DB | decimal | Unapplied Balance | - | |
Description:No description available | ||||
CuryUnappliedBalCA | decimal | Discrepancy | - | |
Description:No description available | ||||
CuryUnappliedBalMatchNonexistent in DB | decimal | Unmatched Amount | - | |
Description:No description available | ||||
CuryUnappliedBalMatchToInvoiceNonexistent in DB | decimal | Unmatched Amount | - | |
Description:No description available | ||||
CuryUnappliedBalMatchToPaymentNonexistent in DB | decimal | Unmatched Amount | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | VAT Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | VAT Taxable Total | - | |
Description:No description available | ||||
CuryWOAmtNonexistent in DB | decimal | Write-Off Amount | - | |
Description:No description available | ||||
DetailErrorCount | int | - | ||
Description:No description available | ||||
DetailsWithTaxesTotal | decimal | - | ||
Description:No description available | ||||
DocTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
DocumentMatched | bit | Matched | - | |
Description:No description available | ||||
DrCr | char(1) | DrCr | - | |
Description:No description available | ||||
EntryTypeID | nvarchar(10) | Entry Type ID | CAEntryType | |
Description:No description available | ||||
EntryTypeID1Nonexistent in DB | nvarchar(10) | Entry Type ID | CAEntryType | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
ExtTranID | nvarchar(255) | Ext. Tran. ID | - | |
Description:No description available | ||||
HasAdjustmentsObsolete | bit | - | ||
Description:No description available | ||||
HeaderRefNbr | nvarchar(15) | Statement Nbr. | CABankTranHeader | |
Description:No description available | ||||
Hidden | bit | Hidden | - | |
Description:No description available | ||||
HistMatchedToInvoice | bit | Matched to Invoice | - | |
Description:No description available | ||||
InvoiceInfo | nvarchar(256) | Invoice Nbr. | - | |
Description:No description available | ||||
InvoiceInfo1Nonexistent in DB | nvarchar(256) | Invoice Nbr. | - | |
Description:No description available | ||||
InvoiceNotFound | bit | - | ||
Description:No description available | ||||
LastAutoMatchDate | datetime2 | Last Auto-Match Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineCntrCA | int | - | ||
Description:No description available | ||||
LineCntrMatch | int | - | ||
Description:No description available | ||||
MatchedToExistingNonexistent in DB | bit | Matched | - | |
Description:No description available | ||||
MatchedToExpenseReceiptNonexistent in DB | bit | Matched To Expense Receipt | - | |
Description:No description available | ||||
MatchedToInvoiceNonexistent in DB | bit | Matched to Invoice | - | |
Description:No description available | ||||
MatchingFinPeriodID | char(6) | Fin. Period | - | |
Description:No description available | ||||
MatchingPaymentDate | datetime2 | Payment Date | - | |
Description:No description available | ||||
MatchReason | nvarchar(1) | Match Reason | - | |
Description:No description available | ||||
MatchReceiptsAndDisbursements | bit | Match to Receipts and Disbursements | - | |
Description:No description available | ||||
MatchStatsInfoNonexistent in DB | nvarchar(MAX) | MatchStatsInfo | - | |
Description:No description available | ||||
MultipleMatching | bit | Match to Multiple Documents | - | |
Description:No description available | ||||
MultipleMatchingToPayments | bit | Match to Multiple Payments | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigCuryID | nvarchar(5) | Orig. Currency | Currency | |
Description:No description available | ||||
OrigModule | char(2) | Module | - | |
Description:No description available | ||||
OrigModule1Nonexistent in DB | nchar(2) | Module | - | |
Description:No description available | ||||
PayeeAddress1 | nvarchar(256) | Payee Address1 | - | |
Description:No description available | ||||
PayeeBAccountID | int | Business Account | BAccount | |
Description:No description available | ||||
PayeeBAccountID1Nonexistent in DB | int | Business Account | BAccount | |
Description:No description available | ||||
PayeeBAccountIDCopyNonexistent in DB | int | Business Account | BAccount | |
Description:No description available | ||||
PayeeCity | nvarchar(256) | Payee City | - | |
Description:No description available | ||||
PayeeLocationID | int | Location | Location | |
Description:No description available | ||||
PayeeLocationID1Nonexistent in DB | int | Location | Location | |
Description:No description available | ||||
PayeeLocationIDCopyNonexistent in DB | int | Location | Location | |
Description:No description available | ||||
PayeeName | nvarchar(256) | Payee/Payer | - | |
Description:No description available | ||||
PayeePhone | nvarchar(256) | Payee Phone | - | |
Description:No description available | ||||
PayeePostalCode | nvarchar(256) | Payee Postal Code | - | |
Description:No description available | ||||
PayeeState | nvarchar(256) | Payee State | - | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentMethodID1Nonexistent in DB | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentMethodIDCopyNonexistent in DB | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:No description available | ||||
PMInstanceIDCopyNonexistent in DB | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:No description available | ||||
Processed | bit | Processed | - | |
Description:No description available | ||||
RuleAppliedNonexistent in DB | bit | Rule Applied | - | |
Description:No description available | ||||
RuleID | int | Applied Rule | CABankTranRule | |
Description:No description available | ||||
SortOrderNonexistent in DB | int | - | ||
Description:No description available | ||||
StatusNonexistent in DB | nchar(1) | Match Type | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxRoundDiff | decimal | - | ||
Description:No description available | ||||
TaxTotal | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
TranCode | nvarchar(35) | Tran. Code | - | |
Description:No description available | ||||
TranDate | datetime2 | Tran. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(512) | Tran. Desc | - | |
Description:No description available | ||||
TranEntryDate | datetime2 | Tran. Entry Date | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranType | char(1) | Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnappliedBalCA | decimal | - | ||
Description:No description available | ||||
UserDesc | nvarchar(512) | Custom Tran. Desc. | - | |
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
WOAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||