CA
CASplit
PX.Objects.CA36 of 36 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjRefNbr | nvarchar(15) | AdjRefNbr | - | |
Description:The reference number of the parent document. This field is a part of the compound key of the document. Corresponds to the value of the CAAdj.AdjRefNbr field. | ||||
AdjTranType | char(3) | Type | CAAdj | |
Description:The type of the parent document. This field is a part of the compound key of the document. Corresponds to the value of the CAAdj.AdjTranType field. | ||||
LineNbr | int | Line Nbr. | - | |
Description:The number of the line in details of the CAAdj document. The value of this field affects the counter of the parent document. | ||||
AccountID | int | Offset Account | Account | |
Description:The account to be updated by the transaction. By default, this is the offset account that is defined by the entry type selected for the cash account. | ||||
BranchID | int | Branch | Branch | |
Description:The identifier of the branch of the parent document. Corresponds to the value of the CAAdj.branchID field. | ||||
CashAccountID | nvarchar(10) | 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:The identifier of the exchange rate record for the line. Corresponds to the CAAdj.CuryInfoID field. | ||||
CuryTaxableAmt | decimal(19, 4) | - | ||
Description:The line total that is subjected to all taxes with calculation rule "Inclusive Line-Level" (see TaxBaseAttribute.TaxSetLineDefault) in the selected currency. | ||||
CuryTaxAmt | decimal(19, 4) | - | ||
Description:The amount of tax (VAT) associated with the line in the selected currency. | ||||
CuryTranAmt | decimal(19, 4) | Amount | - | |
Description:The total amount of this line in the selected currency. | ||||
CuryUnitPrice | decimal(19, 6) | Price | - | |
Description:The unit price for the item in the selected currency. | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
InventoryID | int | Item ID | InventoryItem | |
Description:The user-friendly identifier of the non-stock item specified as the transaction subject. Corresponds to the value of the InventoryItem.InventoryID field. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NonBillable | bit | Non Billable | - | |
Description:Specifies (if set to "true") that this transaction is non-billable in the project. This column appears only if the Projects module has been enabled in your system and integrated with the Cash Management module. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:The project with which this transaction is associated, or the code indicating that this transaction is not associated with any project; the non-project code is specified on the Projects Preferences (PM101000) form. This field appears in the UI only if the Projects module has been enabled in your system and integrated with the Cash Management module. Corresponds to the PMProject. | ||||
Qty | decimal(19, 6) | Quantity | - | |
Description:The quantity of the item. | ||||
ReclassificationProhibitedNonexistent in DB | bit | - | ||
Description:It is used only to pass ReclassificationProhibited flag to GL tran on Cash-in-Transit Account. It is not persisted. | ||||
SubID | int | Offset Subaccount | Account | |
Description:The subaccount to be used for the transaction. | ||||
TaskID | int | Project Task | PMTask | |
Description:The particular task of the project with which this transaction is associated. This field appears in the UI only if the Projects module has been enabled in your system and integrated with the Cash Management module. Corresponds to the value of the PMTask.TaskID field. | ||||
TaxableAmt | decimal(19, 4) | - | ||
Description:The line total that is subjected to all taxes with calculation rule "Inclusive Line-Level" (see TaxBaseAttribute.TaxSetLineDefault) in the base currency. | ||||
TaxAmt | decimal(19, 4) | - | ||
Description:The amount of tax (VAT) associated with the line in the base currency. | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | Tran. Amount | - | |
Description:The total amount this line in the base currency. | ||||
TranDesc | nvarchar(512) | Description | - | |
Description:The description provided for the item. | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitPrice | decimal(19, 6) | - | ||
Description:The unit price for the item in the base currency. | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||