AM
CTPProcess.CTPLine
PX.Objects.AM194 of 194 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | Order Nbr. | SOOrder | |
Description:No description available | ||||
OrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
AMCTPOrderType | char(2) | Prod. Order Type | - | |
Description:No description available | ||||
AutoCreateIssueLine | bit | Auto Create Issue | - | |
Description:No description available | ||||
AutomaticDiscountsDisabled | bit | Automatic Discounts Disabled | - | |
Description:No description available | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
AvgCostNonexistent in DB | decimal | Average Cost | - | |
Description:No description available | ||||
BaseBilledQty | decimal | - | ||
Description:No description available | ||||
BaseClosedQty | decimal | - | ||
Description:No description available | ||||
BaseOpenQty | decimal | Base Open Qty. | - | |
Description:No description available | ||||
BaseOrderQty | decimal | Base Order Qty. | - | |
Description:No description available | ||||
BaseQtyOnOrders | decimal | - | ||
Description:No description available | ||||
BaseShippedQty | decimal | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal | - | ||
Description:No description available | ||||
Behavior | char(2) | - | ||
Description:No description available | ||||
BilledAmt | decimal | - | ||
Description:No description available | ||||
BilledQty | decimal | Billed Quantity | - | |
Description:No description available | ||||
BlanketLineNbr | int | BlanketSOLine | ||
Description:No description available | ||||
BlanketNbr | nvarchar(15) | Blanket SO Ref. Nbr. | SOBlanketOrderLink | |
Description:No description available | ||||
BlanketOpenQty | decimal | Blanket Open Qty. | - | |
Description:No description available | ||||
BlanketSplitLineNbr | int | BlanketSOLineSplit | ||
Description:No description available | ||||
BlanketType | char(2) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CalculateDiscountsOnImportNonexistent in DB | bit | Calculate automatic discounts on import | - | |
Description:No description available | ||||
CancelDate | datetime2 | Cancel By | - | |
Description:No description available | ||||
Cancelled | bit | - | ||
Description:No description available | ||||
ChildLineCntr | int | - | ||
Description:No description available | ||||
ClosedQty | decimal | - | ||
Description:No description available | ||||
Commissionable | bit | Commissionable | - | |
Description:No description available | ||||
CommnAmt | decimal | - | ||
Description:No description available | ||||
CommnPct | decimal | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CompleteQtyMax | decimal | Overship Threshold (%) | - | |
Description:No description available | ||||
CompleteQtyMin | decimal | Undership Threshold (%) | - | |
Description:No description available | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CTPDate | datetime2 | CTP Date | - | |
Description:No description available | ||||
CuryBilledAmt | decimal | - | ||
Description:No description available | ||||
CuryCommnAmt | decimal | - | ||
Description:No description available | ||||
CuryDiscAmt | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryDiscPrice | decimal | Disc. Unit Price | - | |
Description:No description available | ||||
CuryExtCost | decimal | Extended Cost | - | |
Description:No description available | ||||
CuryExtPrice | decimal | Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryMarginAmt | decimal | Est. Margin Amount | - | |
Description:No description available | ||||
CuryNetSales | decimal | - | ||
Description:No description available | ||||
CuryOpenAmt | decimal | Open Amount | - | |
Description:No description available | ||||
CuryTaxableAmt | decimal | - | ||
Description:No description available | ||||
CuryUnbilledAmt | decimal | Unbilled Amount | - | |
Description:No description available | ||||
CuryUnitCost | decimal | Unit Cost | - | |
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 | ||
Description:No description available | ||||
CustomerLocationID | int | Ship-To Location | Location | |
Description:No description available | ||||
CustomerOrderNbr | nvarchar(40) | Customer Order Nbr. | - | |
Description:No description available | ||||
DefaultOperation | char(1) | SOOrderTypeOperation | ||
Description:No description available | ||||
DefScheduleID | int | DRSchedule | ||
Description:No description available | ||||
DisableAutomaticTaxCalculation | bit | Disable Automatic Tax Calculation | - | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary | - | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | DiscountSequence | |
Description:No description available | ||||
DiscPct | decimal | Discount Percent | - | |
Description:No description available | ||||
DiscPctDR | decimal | Discount Percent for DR | - | |
Description:No description available | ||||
DiscPrice | decimal | - | ||
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
DRTermEndDate | datetime2 | Term End Date | - | |
Description:No description available | ||||
DRTermStartDate | datetime2 | Term Start Date | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
ExtCost | decimal | - | ||
Description:No description available | ||||
ExtPrice | decimal | - | ||
Description:No description available | ||||
ExtVolume | decimal | Ext. Volume | - | |
Description:No description available | ||||
ExtWeight | decimal | Ext. Weight | - | |
Description:No description available | ||||
FOBPoint | nvarchar(15) | FOB | FOBPoint | |
Description:No description available | ||||
FreezeManualDiscNonexistent in DB | bit | - | ||
Description:No description available | ||||
GroupDiscountRate | decimal | - | ||
Description:No description available | ||||
IntercompanyPOLineNbr | int | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:No description available | ||||
InvoiceDate | datetime2 | Original Sale Date | - | |
Description:No description available | ||||
InvoiceLineNbr | int | Invoice Line Nbr. | ARTran | |
Description:No description available | ||||
InvoiceNbr | nvarchar(15) | Invoice Nbr. | SOInvoice | |
Description:No description available | ||||
InvoiceType | char(3) | Invoice Type | - | |
Description:No description available | ||||
InvoiceUOM | nvarchar(6) | - | ||
Description:No description available | ||||
InvtMult | smallint | Inventory Multiplier | - | |
Description:No description available | ||||
IsBeingCopiedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsCostUpdatedOnPO | bit | Update Cost On PO | - | |
Description:No description available | ||||
IsCutNonexistent in DBObsolete | bit | - | ||
Description:No description available | ||||
IsFree | bit | Free Item | - | |
Description:No description available | ||||
IsKitNonexistent in DB | bit | Is a Kit | - | |
Description:No description available | ||||
IsLegacyDropShip | bit | - | ||
Description:No description available | ||||
IsOrchestratedLine | bit | Orchestrated | - | |
Description:No description available | ||||
IsPOLinkAllowedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPromotionalPrice | bit | Promotional Price | - | |
Description:No description available | ||||
IsSpecialOrder | bit | Special Order | - | |
Description:No description available | ||||
IsStockItem | bit | Is stock | - | |
Description:No description available | ||||
ItemHasResidualNonexistent in DB | bit | - | ||
Description:No description available | ||||
ItemRequiresTermsNonexistent in DB | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineAmt | decimal | - | ||
Description:No description available | ||||
LineQtyAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LineQtyHardAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LineSign | smallint | - | ||
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. | INLotSerialStatus | |
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Price | - | |
Description:No description available | ||||
ManualProdOrdIDNonexistent in DB | nvarchar(15) | Manual Order Nbr. | AMProdItem | |
Description:No description available | ||||
MarginAmt | decimal | - | ||
Description:No description available | ||||
MarginPct | decimal | Est. Margin (%) | - | |
Description:No description available | ||||
NetSales | decimal | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenAmt | decimal | - | ||
Description:No description available | ||||
OpenChildLineCntr | int | - | ||
Description:No description available | ||||
OpenLine | bit | Open Line | - | |
Description:No description available | ||||
OpenQty | decimal | Open Qty. | - | |
Description:No description available | ||||
Operation | char(1) | Operation | SOOrderTypeOperation | |
Description:No description available | ||||
OrchestrationOriginalLineNbr | int | - | ||
Description:No description available | ||||
OrchestrationOriginalSiteID | int | - | ||
Description:No description available | ||||
OrchestrationPlanID | nvarchar(15) | Orchestration Plan | SOOrchestrationPlan | |
Description:No description available | ||||
OrderDate | datetime2 | - | ||
Description:No description available | ||||
OrderQty | decimal | Quantity | - | |
Description:No description available | ||||
OrigIsSpecialOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
OrigLineNbr | int | SOLine | ||
Description:No description available | ||||
OrigOrderNbr | nvarchar(15) | Orig. Order Nbr. | SOOrder | |
Description:No description available | ||||
OrigOrderType | char(2) | Orig. Order Type | SOOrderType | |
Description:No description available | ||||
OrigPlanTypeObsolete | char(2) | INPlanType | ||
Description:No description available | ||||
OrigShipmentType | char(1) | - | ||
Description:No description available | ||||
PlanTypeNonexistent in DB | nchar(2) | - | ||
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POCreated | bit | - | ||
Description:No description available | ||||
POCreateDate | datetime2 | PO Creation Date | - | |
Description:No description available | ||||
POLineNbrNonexistent in DB | int | Drop-Ship PO Line Nbr. | - | |
Description:No description available | ||||
POLinkActiveNonexistent in DB | bit | PO Linked | - | |
Description:No description available | ||||
POOrderNbrNonexistent in DB | nvarchar(15) | Drop-Ship PO Nbr. | POOrder | |
Description:No description available | ||||
POOrderStatusNonexistent in DB | nchar(2) | Drop-Ship PO Status | - | |
Description:No description available | ||||
POOrderTypeNonexistent in DB | nchar(2) | - | ||
Description:No description available | ||||
POSiteID | int | Purchase Warehouse | INSite | |
Description:No description available | ||||
POSource | varchar(MAX) | PO Source | - | |
Description:No description available | ||||
PriceType | char(1) | Price Type | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Prod. Order Nbr. | AMProdItem | |
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
QtyOnOrders | decimal | Qty. On Orders | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
RequestDate | datetime2 | Requested On | - | |
Description:No description available | ||||
RequireAllocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireLocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireReasonCodeNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireShippingNonexistent in DB | bit | - | ||
Description:No description available | ||||
SalesAcctID | int | Account | Account | |
Description:No description available | ||||
SalesPersonID | int | Salesperson ID | SalesPerson | |
Description:No description available | ||||
SalesSubID | int | Subaccount | Sub | |
Description:No description available | ||||
SchedOrderDate | datetime2 | Sched. Order Date | - | |
Description:No description available | ||||
SchedShipDate | datetime2 | Sched. Shipment Date | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
ShipDate | datetime2 | Ship On | - | |
Description:No description available | ||||
ShippedQty | decimal | Qty. On Shipments | - | |
Description:No description available | ||||
ShipTermsID | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
ShipVia | nvarchar(15) | Ship Via | Carrier | |
Description:No description available | ||||
ShipZoneID | nvarchar(15) | Shipping Zone | ShippingZone | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SkipDiscNonexistent in DB | bit | - | ||
Description:No description available | ||||
SkipLineDiscounts | bit | Ignore Automatic Line Discounts | - | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SubstitutionRequired | bit | Substitution Required | - | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxableAmt | decimal | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Line Description | - | |
Description:No description available | ||||
TranTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UnbilledAmt | decimal | - | ||
Description:No description available | ||||
UnbilledQty | decimal | Unbilled Quantity | - | |
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
UnitVolume | decimal | - | ||
Description:No description available | ||||
UnitWeigth | decimal | Unit Weight | - | |
Description:No description available | ||||
UnshippedQtyNonexistent in DB | decimal | Unshipped Qty. | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
VerifyOrderQty | decimal | - | ||
Description:No description available | ||||