PM
ProformaEntry.RetainageOriginalARTran
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:No description available | ||||
AccrueCost | bit | Accrue Cost | - | |
Description:When set to "true", indicates that cost will be processed using expense accrual account. | ||||
AccruedCost | decimal | - | ||
Description:No description available | ||||
AllowControlAccountForModuleNonexistent in DB | string | - | ||
Description:No description available | ||||
AppointmentLineNbr | int | Appointment Line Nbr. | - | |
Description:Appointment line nbr | ||||
AppointmentRefNbr | nvarchar(20) | Appointment Nbr. | - | |
Description:Appointment ref nbr | ||||
AssociatedOrderLineNbr | int | Associated Order Line Nbr. | - | |
Description:The order line associated with the transaction. | ||||
AutomaticDiscountsDisabled | bit | Automatic Discounts Disabled | - | |
Description:A Boolean value that indicates whether the system does not need to calculate discounts, because they are already calculated. | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
BaseQty | decimal | Base Qty. | - | |
Description:No description available | ||||
BlanketLineNbr | int | - | ||
Description:No description available | ||||
BlanketNbr | nvarchar(15) | Blanket SO Ref. Nbr. | SOOrder | |
Description:No description available | ||||
BlanketSplitLineNbr | int | - | ||
Description:No description available | ||||
BlanketType | char(2) | SOBlanketOrderLink | ||
Description:No description available | ||||
BranchBaseCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CalculateDiscountsOnImportNonexistent in DB | bool? | Calculate automatic discounts on import | - | |
Description:No description available | ||||
Canceled | bit | - | ||
Description:When set to "true", indicates that the invoice was canceled or corrected. | ||||
CaseCD | nvarchar(15) | Case ID | CRCase | |
Description:No description available | ||||
CashDiscBal | decimal | - | ||
Description:No description available | ||||
Comment | varchar(MAX) | Equipment Action Comment | - | |
Description:No description available | ||||
Commissionable | bit | Commissionable | ARTran | |
Description:No description available | ||||
CommnAmt | decimal | - | ||
Description:No description available | ||||
CommnPct | decimal | - | ||
Description:No description available | ||||
ComponentID | int | Component ID | FSModelTemplateComponent | |
Description:Component ID | ||||
CostNonexistent in DB | decimal? | Cost | - | |
Description:No description available | ||||
CostBasis | char(1) | - | ||
Description:No description available | ||||
CostBasisNullNonexistent in DB | string | Cost Based On | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
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 | ||||
CuryAccruedCost | decimal | Cost Accrual | - | |
Description:No description available | ||||
CuryCashDiscBal | decimal | Cash Discount Balance | - | |
Description:No description available | ||||
CuryCommnAmt | decimal | - | ||
Description:No description available | ||||
CuryDiscAmt | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryExtPrice | decimal | Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryInventoryIDNonexistent in DB | int? | InventoryItemCurySettings | ||
Description:No description available | ||||
CuryOrigRetainageAmt | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryOrigTaxAmt | decimal | Tax Amount | - | |
Description:The amount of tax included into line balance. (Presented in the currency of the document, see ARRegister.CuryID) | ||||
CuryOrigTaxableAmt | decimal | Taxable Amount | - | |
Description:The line amount included into line balance. (Presented in the currency of the document, see ARRegister.CuryID) | ||||
CuryOrigTranAmt | decimal | Original Amount | - | |
Description:No description available | ||||
CuryPrepaymentAmt | decimal | Prepayment Amount | - | |
Description:Part of sales order amount which shall be paid in PPI document | ||||
CuryRetainageAmt | decimal | - | ||
Description:No description available | ||||
CuryRetainageBal | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxAmt | decimal | Retained Tax | - | |
Description:The amount of retained tax (VAT) associated with the line. (Presented in the currency of the document, see ARRegister.CuryID) | ||||
CuryRetainedTaxableAmt | decimal | Retained Taxable Amount | - | |
Description:The line amount that is subject to retained tax. (Presented in the currency of the document, see ARRegister.CuryID) | ||||
CuryTaxAmt | decimal | VAT | - | |
Description:No description available | ||||
CuryTaxableAmt | decimal | Net Amount | - | |
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryTranBal | decimal | Balance | - | |
Description:No description available | ||||
CuryUnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
CuryUnitPriceDR | decimal | Unit Price for DR | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
DRTermEndDate | datetime | Term End Date | - | |
Description:No description available | ||||
DRTermStartDate | datetime | Term Start Date | - | |
Description:No description available | ||||
Date | datetime | Expense Date | - | |
Description:Reference Date. May be an original expense date that is billed to the customer. | ||||
DefScheduleID | int | Original Deferral Schedule | DRSchedule | |
Description:No description available | ||||
DeferredCode | nvarchar(10) | Deferral Code | DRDeferredCode | |
Description:No description available | ||||
DisableAutomaticTaxCalculation | bit | Disable Automatic Tax Calculation | - | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscPct | decimal | Discount Percent | - | |
Description:No description available | ||||
DiscPctDR | decimal | Discount Percent for DR | - | |
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | - | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary | - | ||
Description:No description available | ||||
DocumentDiscountAmountNonexistent in DB | decimal? | Document Discount Amount | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
DrCr | char(1) | - | ||
Description:No description available | ||||
EmployeeID | int | - | ||
Description:No description available | ||||
EquipmentAction | char(2) | Equipment Action | - | |
Description:No description available | ||||
EquipmentComponentLineNbr | int | Component Line Nbr. | FSEquipmentComponent | |
Description:No description available | ||||
ExpenseAccountID | int | Expense Account | Account | |
Description:No description available | ||||
ExpenseAccrualAccountID | int | Expense Accrual Account | Account | |
Description:No description available | ||||
ExpenseAccrualSubID | int | Expense Accrual Subaccount | Sub | |
Description:No description available | ||||
ExpenseDate | datetime | - | ||
Description:No description available | ||||
ExpenseSubID | int | Expense Subaccount | Sub | |
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
ExtPrice | decimal | - | ||
Description:No description available | ||||
ExternalRef | nvarchar | - | ||
Description:External document ID that is needed to identify document for the integrations with external systems such as Commerce Edition | ||||
FinPeriodID | string | - | ||
Description:No description available | ||||
FreezeManualDiscNonexistent in DB | bool? | - | ||
Description:No description available | ||||
GiftMessage | nvarchar(200) | Gift Message | - | |
Description:The gift message for the order. | ||||
GrossSalesAmountNonexistent in DB | decimal? | Gross Sales Amount | - | |
Description:No description available | ||||
GroupDiscountAmountNonexistent in DB | decimal? | Group Discount Amount | - | |
Description:No description available | ||||
GroupDiscountRate | decimal | - | ||
Description:No description available | ||||
HasExpiredComplianceDocumentsNonexistent in DB | bool? | Expired Compliance | - | |
Description:No description available | ||||
HistoryLineIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtDocType | char(1) | Inventory Doc. Type | - | |
Description:No description available | ||||
InvtMult | smallint | Multiplier | - | |
Description:No description available | ||||
InvtRefNbr | nvarchar(15) | Inventory Ref. Nbr. | INRegister | |
Description:No description available | ||||
InvtReleased | bit | - | ||
Description:No description available | ||||
IsCancellation | bit | - | ||
Description:When set to "true", indicates that the invoice is a cancellation invoice (credit memo). | ||||
IsFSRelatedNonexistent in DB | bool? | - | ||
Description:Is FS related | ||||
IsFreeNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsStockItem | bit | Is stock | - | |
Description:No description available | ||||
IsTranCostFinal | bit | - | ||
Description:No description available | ||||
ItemHasResidualNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
LineType | char(2) | Line Type | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | CostCenter | |
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Price | - | |
Description:No description available | ||||
MarginNonexistent in DB | decimal? | Margin | - | |
Description:No description available | ||||
MarginPercentNonexistent in DB | decimal? | Margin Percent | - | |
Description:No description available | ||||
NetSalesAmountNonexistent in DB | decimal? | Net Sales Amount | - | |
Description:No description available | ||||
NewEquipmentLineNbr | int | Model Equipment Line Nbr. | ARTran | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigDocType | char(3) | Orig. Doc. Type | - | |
Description:The type of the original (source) document. Corresponds to the DocType field. | ||||
OrigDocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
OrigGroupDiscountRate | decimal | - | ||
Description:No description available | ||||
OrigInvoiceDate | datetime | Original Invoice date | - | |
Description:No description available | ||||
OrigInvoiceLineNbr | int | Orig. Inv. Line Nbr. | - | |
Description:No description available | ||||
OrigInvoiceNbr | nvarchar(15) | Orig. Inv. Nbr. | SOInvoice | |
Description:No description available | ||||
OrigInvoiceType | char(3) | Orig. Inv. Type | - | |
Description:No description available | ||||
OrigLineNbr | int | - | ||
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Ref. Nbr. | - | |
Description:The reference number of the original (source) document. Corresponds to the RefNbr field. | ||||
OrigRetainageAmt | decimal | - | ||
Description:No description available | ||||
OrigTaxAmt | decimal | - | ||
Description:The amount of tax included into line balance. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
OrigTaxableAmt | decimal | - | ||
Description:The line amount included into line balance. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
OrigTranAmt | decimal | - | ||
Description:No description available | ||||
PMDeltaOption | nvarchar | - | ||
Description:No description available | ||||
PlanID | bigint | - | ||
Description:No description available | ||||
PrepaymentAmt | decimal | - | ||
Description:Part of sales order amount which shall be paid in PPI document | ||||
PrepaymentPct | decimal | Prepayment Percent | - | |
Description:Percent of the Sales Order amount which shall be paid in PPI document | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | ARCashSale | |
Description:No description available | ||||
RelatedDocumentNonexistent in DB | string | Related Svc. Doc. Nbr. | - | |
Description:No description available | ||||
RelatedItemsNonexistent in DB | string | - | ||
Description:No description available | ||||
RelatedItemsRelationNonexistent in DB | int? | - | ||
Description:No description available | ||||
RelatedItemsRequiredNonexistent in DB | int? | - | ||
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ReleasedToVerifyNonexistent in DB | bool? | - | ||
Description:When set, on persist checks, that the document has the corresponded Released original value. When not set, on persist checks, that Released value is not changed. Throws an error otherwise. | ||||
ReplaceSMEquipmentID | int | Suspended Target Equipment ID | - | |
Description:No description available | ||||
RequireINUpdateNonexistent in DB | bool? | - | ||
Description:No description available | ||||
RequiresTermsNonexistent in DB | bool? | - | ||
Description:When set to "true", indicates that the DRTermStartDate and DRTermEndDate fields are enabled and should be filled for the line. The value of this field is set by the ARInvoiceEntry and ARCashSaleEntry graphs based on the settings of the item and the Deferral Code selected for the line. In other contexts it is not populated. See the attribute on the ARInvoiceEntry.ARTran_RequiresTerms_CacheAttached handler for details. | ||||
RetainageAmt | decimal | - | ||
Description:No description available | ||||
RetainageBal | decimal | - | ||
Description:No description available | ||||
RetainagePct | decimal | - | ||
Description:No description available | ||||
RetainedTaxAmt | decimal | - | ||
Description:The amount of retained tax (VAT) associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
RetainedTaxableAmt | decimal | - | ||
Description:The line amount that is subject to retained tax. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
SMEquipmentID | int | Target Equipment ID | ARTran | |
Description:No description available | ||||
SOOrderLineNbr | int | Order Line Nbr | SOLine | |
Description:No description available | ||||
SOOrderLineOperation | char(1) | - | ||
Description:No description available | ||||
SOOrderLineSign | smallint | - | ||
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderSortOrder | int | Order Sort Order | - | |
Description:No description available | ||||
SOOrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
SOShipmentLineGroupNbr | int | - | ||
Description:Number of the group of shipment lines referencing the same sales order line which are invoiced together in the single invoice line. | ||||
SOShipmentLineNbr | int | - | ||
Description:No description available | ||||
SOShipmentNbr | nvarchar(15) | Shipment Nbr. | SOOrderShipment | |
Description:No description available | ||||
SOShipmentType | char(1) | SOOrderShipment | ||
Description:No description available | ||||
SalesPersonID | int | Salesperson ID | SalesPerson | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ServiceContractPeriodID | int | Service Contract Period | - | |
Description:No description available | ||||
ServiceContractRefNbr | nvarchar(15) | Service Contract Nbr. | - | |
Description:No description available | ||||
ServiceOrderLineNbr | int | Service Order Line Nbr. | - | |
Description:No description available | ||||
ServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | - | |
Description:No description available | ||||
SiteID | int | INSite | ||
Description:No description available | ||||
SkipLineDiscounts | bit | Ignore Automatic Line Discounts | - | |
Description:Indicates (if selected) that the automatic line discounts are not applied to this line | ||||
SortOrder | int | Line Nbr. | - | |
Description:No description available | ||||
SrvOrdType | char(4) | Service Order Type | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SubstitutionRequired | bit | Substitution Required | - | |
Description:No description available | ||||
SuggestRelatedItemsNonexistent in DB | bool? | - | ||
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxAmt | decimal | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
Description:No description available | ||||
TaxableAmt | decimal | - | ||
Description:No description available | ||||
TranAmt | decimal | - | ||
Description:No description available | ||||
TranBal | decimal | Balance | - | |
Description:No description available | ||||
TranClass | char(1) | - | ||
Description:No description available | ||||
TranCost | decimal | Ext. Cost | - | |
Description:No description available | ||||
TranCostOrig | decimal | Orig. Ext. Cost | - | |
Description:No description available | ||||
TranDate | datetime | Document Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Transaction Descr. | - | |
Description:No description available | ||||
TranPeriodID | string | - | ||
Description:No description available | ||||
TranType | char(3) | Tran. Type | ARRegister | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnassignedQtyNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
UnitCostNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
UnitPrice | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||