CA
CABankTranInvoiceMatch
PX.Objects.CA.BankStatementProtoHelpers27 of 27 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrigModule | char(2) | Module | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
OrigTranType | char(3) | Type | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | - | |
Description:No description available | ||||
CuryDiscAmt | decimal | Cash Discount | - | |
Description:The cash discount amount of the document. Given in the currency of the document. | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:The cash discount amount of the document. Given in the base currency of the company. | ||||
DiscDate | datetime2 | Discount Date | - | |
Description:The date when the cash discount can be taken in accordance with the credit terms of source document | ||||
DrCr | char(1) | Disb. / Receipt | - | |
Description:No description available | ||||
DueDate | datetime2 | Doc. Date | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
IsBestMatchNonexistent in DB | bit | Best Match | - | |
Description:No description available | ||||
IsMatchedNonexistent in DB | bit | Matched | - | |
Description:No description available | ||||
MatchRelevanceNonexistent in DB | decimal | Match Relevance | - | |
Description:No description available | ||||
MatchRelevancePercentNonexistent in DB | decimal | Match Relevance, % | - | |
Description:No description available | ||||
ReferenceCDNonexistent in DB | nvarchar(60) | Business Account | - | |
Description:No description available | ||||
ReferenceID | int | Business Account | - | |
Description:No description available | ||||
ReferenceNameNonexistent in DB | nvarchar(60) | Business Account Name | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
TranAmt | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranDate | datetime2 | Doc. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||