CA
CABankTranDetail
A CA transaction detail for the bank transaction for which a CA document will be created.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Offset Account | Account | |
Description:No description available | ||||
BankTranID | int | CABankTran | ||
Description:No description available | ||||
BankTranType | char(1) | Type | CABankTran | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CashAccountIDNonexistent in DB | int? | Offset Cash Account | CashAccount | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryTaxAmt | decimal | - | ||
Description:The amount of tax (VAT) associated with the line in the selected currency. | ||||
CuryTaxableAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryUnitPrice | decimal | Price | - | |
Description:No description available | ||||
InventoryID | int | Item ID | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
NonBillable | bit | Non Billable | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
ReferenceID | int | BAccount | ||
Description:No description available | ||||
SubID | int | Offset Subaccount | Account | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxAmt | decimal | - | ||
Description:The amount of tax (VAT) associated with the line in the base currency. | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxableAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
TranAmt | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
UnitPrice | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||