CA
CAReconEntry.CATranExt
PX.Objects.CA69 of 69 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TranID | bigint | Document Number | - | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Number | - | |
Description:No description available | ||||
BegBalNonexistent in DB | decimal | BegBal | - | |
Description:No description available | ||||
BranchID | int | - | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | - | |
Description:No description available | ||||
ClearDate | datetime2 | Clear Date | - | |
Description:No description available | ||||
Cleared | bit | Cleared | - | |
Description:No description available | ||||
CountCreditNonexistent in DB | int | - | ||
Description:No description available | ||||
CountDebitNonexistent in DB | int | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | varchar(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 | ||||
CuryEffClearedCreditAmtNonexistent in DB | decimal | Disbursement | - | |
Description:No description available | ||||
CuryEffClearedDebitAmtNonexistent in DB | decimal | Receipt | - | |
Description:No description available | ||||
CuryEffCreditAmtNonexistent in DB | decimal | Disbursement | - | |
Description:No description available | ||||
CuryEffDebitAmtNonexistent in DB | decimal | Receipt | - | |
Description:No description available | ||||
CuryEffTranAmtNonexistent in DB | decimal | Amount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryReconciledCreditNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CuryReconciledDebitNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
DayDescNonexistent in DB | nvarchar(20) | Day of Week | - | |
Description:No description available | ||||
DrCr | char(1) | Disb. / Receipt | - | |
Description:No description available | ||||
EffTranAmtNonexistent in DB | decimal | Tran. Amount | - | |
Description:No description available | ||||
EndBalNonexistent in DB | decimal | Ending Balance | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
IsPaymentChargeTran | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(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 | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Doc. Number | - | |
Description:No description available | ||||
OrigTranType | char(3) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigTranTypeUI | nvarchar(MAX) | Tran. Type | - | |
Description:No description available | ||||
PendingApproval | bit | - | ||
Description:No description available | ||||
Posted | bit | - | ||
Description:No description available | ||||
ProcessedFromFeedNonexistent in DB | bit | - | ||
Description:No description available | ||||
Reconciled | bit | Reconciled | - | |
Description:No description available | ||||
ReconciledCreditNonexistent in DB | decimal | - | ||
Description:No description available | ||||
ReconciledDebitNonexistent in DB | decimal | - | ||
Description:No description available | ||||
ReconDate | datetime2 | - | ||
Description:No description available | ||||
ReconNbr | nvarchar(15) | Reconciled Number | - | |
Description:No description available | ||||
ReferenceID | int | Business Account | - | |
Description:No description available | ||||
ReferenceNameNonexistent in DB | nvarchar(60) | Business Name | - | |
Description:No description available | ||||
RefSplitLineNbr | int | - | ||
Description:No description available | ||||
RefTranAccountID | int | ChildTran Account | - | |
Description:No description available | ||||
RefTranID | bigint | - | ||
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SkipCountNonexistent in DB | bit | - | ||
Description:No description available | ||||
StatusNonexistent in DB | nchar(11) | Status | - | |
Description:No description available | ||||
TranAmt | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranDate | datetime2 | Doc. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Voided | bit | Voided | - | |
Description:No description available | ||||
VoidedTranID | bigint | - | ||
Description:No description available | ||||
VoidingNotReleasedNonexistent in DB | bit | - | ||
Description:No description available | ||||
VoidingTranIDNonexistent in DB | bigint | - | ||
Description:No description available | ||||