CA
CATran
A cash account transaction.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatchNbr | nvarchar(15) | Batch Number | Batch | |
Description:No description available | ||||
BegBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
BranchID | int | Branch | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
ClearDate | datetime | Clear Date | - | |
Description:No description available | ||||
Cleared | bit | Cleared | - | |
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 | ||||
CuryClearedCreditAmtNonexistent in DB | decimal? | Disbursement | - | |
Description:No description available | ||||
CuryClearedDebitAmtNonexistent in DB | decimal? | Receipt | - | |
Description:No description available | ||||
CuryCreditAmtNonexistent in DB | decimal? | Disbursement | - | |
Description:No description available | ||||
CuryDebitAmtNonexistent in DB | decimal? | Receipt | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
DayDescNonexistent in DB | string | Day of Week | - | |
Description:No description available | ||||
DrCr | char(1) | Disb. / Receipt | - | |
Description:No description available | ||||
EndBalNonexistent in DB | decimal? | Ending Balance | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:No description available | ||||
FinPeriodID | string | Post Period | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
IsPaymentChargeTran | bit | - | ||
Description:Indicates that CATran was created by ARPaymentChargeTran or APPaymentChargeTran | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigLineNbr | int | - | ||
Description:No description available | ||||
OrigModule | char(2) | Module | Batch | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Doc. Number | APPayment | |
Description:No description available | ||||
OrigTranType | char(3) | Orig. Doc. Type | APPayment | |
Description:No description available | ||||
OrigTranTypeUINonexistent in DB | string | Tran. Type | - | |
Description:The CATran type. The field can have one of the values described in PRCATranType.ListAttribute. | ||||
PendingApproval | bit | - | ||
Description:Indicates that CATran is pending approval | ||||
Posted | bit | - | ||
Description:No description available | ||||
ReconDate | datetime | - | ||
Description:No description available | ||||
ReconNbr | nvarchar(15) | Reconciled Number | CARecon | |
Description:No description available | ||||
Reconciled | bit | Reconciled | - | |
Description:No description available | ||||
RefSplitLineNbr | int | - | ||
Description:No description available | ||||
RefTranAccountID | int | ChildTran Account | CashAccount | |
Description:No description available | ||||
RefTranID | bigint | CATran | ||
Description:No description available | ||||
ReferenceID | int | Business Account | BAccount | |
Description:No description available | ||||
ReferenceNameNonexistent in DB | string | Business Name | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
StatusNonexistent in DB | string | Status | - | |
Description:No description available | ||||
TranAmt | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranDate | datetime | Doc. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
TranID | bigint | Document Number | - | |
Description:No description available | ||||
TranPeriodID | string | - | ||
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||
VoidedTranID | bigint | CATran | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||