CA
CATran
PX.Objects.CA53 of 53 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TranID | bigint | Document Number | - | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Number | Batch | |
Description:No description available | ||||
BegBalNonexistent in DB | decimal | BegBal | - | |
Description:No description available | ||||
BranchID | int | Branch | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
ClearDate | datetime2 | 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(19, 4) | 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 | ||||
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: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 | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Doc. Number | ARPayment | |
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 | ||||
Reconciled | bit | Reconciled | - | |
Description:No description available | ||||
ReconDate | datetime2 | - | ||
Description:No description available | ||||
ReconNbr | nvarchar(15) | Reconciled Number | CARecon | |
Description:No description available | ||||
ReferenceID | int | Business Account | BAccount | |
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 | CashAccount | |
Description:No description available | ||||
RefTranID | bigint | - | ||
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
Selected | bit | Selected | - | |
Description:No description available | ||||
StatusNonexistent in DB | nchar(1) | Status | - | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | 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 | - | ||
Description:No description available | ||||
VoidedTranID | bigint | CATran | ||
Description:No description available | ||||