PM
ProjectEntry.PMPOLine
PX.Objects.PM145 of 145 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | Order Nbr. | POOrder | |
Description:No description available | ||||
OrderType | char(2) | Order Type | - | |
Description:No description available | ||||
AccrueCost | bit | Accrue Cost | - | |
Description:No description available | ||||
AllowComplete | bit | Allow Complete | - | |
Description:No description available | ||||
AllowEditUnitCostInPR | bit | Editable Unit Cost in Receipt | - | |
Description:No description available | ||||
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
BaseBilledQty | decimal | - | ||
Description:No description available | ||||
BaseCompletedQty | decimal | - | ||
Description:No description available | ||||
BaseOpenQty | decimal | - | ||
Description:No description available | ||||
BaseOrderedQty | decimal | - | ||
Description:No description available | ||||
BaseOrderQty | decimal | Base Order Qty. | - | |
Description:No description available | ||||
BaseOverridenQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal | Base Received Qty. | - | |
Description:No description available | ||||
BaseReqPrepaidQty | decimal | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal | - | ||
Description:No description available | ||||
BilledAmt | decimal | - | ||
Description:No description available | ||||
BilledQty | decimal | Billed Qty. | - | |
Description:No description available | ||||
BLLineNbr | int | - | ||
Description:No description available | ||||
BLOrderedCost | decimal | - | ||
Description:No description available | ||||
BLOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
BLType | 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 | ||||
Cancelled | bit | Cancelled | - | |
Description:No description available | ||||
ClearPlanIDNonexistent in DB | bit | - | ||
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
CommitmentID | uniqueidentifier | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CompletedQty | decimal | Received Qty. | - | |
Description:No description available | ||||
CompletePOLine | char(1) | Close PO Line | - | |
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 | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryBilledAmt | decimal | Billed Amount | - | |
Description:No description available | ||||
CuryBLOrderedCost | decimal | Received Cost | - | |
Description:No description available | ||||
CuryDiscAmt | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryDiscCost | decimal | Disc. Unit Cost | - | |
Description:No description available | ||||
CuryExtCost | decimal | Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmt | decimal | Ext. Cost | - | |
Description:No description available | ||||
CuryLineCost | decimal | Project Amount | - | |
Description:No description available | ||||
CuryReceivedCostNonexistent in DBObsolete | decimal | - | ||
Description:No description available | ||||
CuryReqPrepaidAmt | decimal | Prepaid Amount | - | |
Description:No description available | ||||
CuryRetainageAmt | decimal | Retainage Amount | - | |
Description:No description available | ||||
CuryUnbilledAmt | decimal | Unbilled Amount | - | |
Description:No description available | ||||
CuryUnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscCost | decimal | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | APDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary | - | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | VendorDiscountSequence | |
Description:No description available | ||||
DiscPct | decimal | Discount Percent | - | |
Description:No description available | ||||
DisplayReqPrepaidQtyNonexistent in DB | decimal | Prepaid Qty. | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
DropshipExpenseRecording | varchar(1) | Record Drop-Ship Expenses | - | |
Description:No description available | ||||
DropshipReceiptProcessing | varchar(1) | Drop-Ship Receipt Processing | - | |
Description:No description available | ||||
DRTermEndDate | datetime2 | Term End Date | - | |
Description:No description available | ||||
DRTermStartDate | datetime2 | Term Start Date | - | |
Description:No description available | ||||
ExpenseAcctID | int | Account | Account | |
Description:No description available | ||||
ExpenseSubID | int | Sub. | Sub | |
Description:No description available | ||||
ExtCost | decimal | Amount | - | |
Description:No description available | ||||
ExtVolume | decimal | Volume | - | |
Description:No description available | ||||
ExtWeight | decimal | Weight | - | |
Description:No description available | ||||
GroupDiscountRate | decimal | - | ||
Description:No description available | ||||
HasInclusiveTaxes | bit | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsKitNonexistent in DB | bit | Is a Kit | - | |
Description:No description available | ||||
IsSpecialOrder | bit | Special Order | - | |
Description:No description available | ||||
IsStockItem | bit | Is stock | - | |
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 | ||||
LeftToReceiveBaseQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LeftToReceiveQtyNonexistent in DB | decimal | Open Qty. | - | |
Description:No description available | ||||
LineAmt | decimal | - | ||
Description:No description available | ||||
LineType | char(2) | Line Type | - | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot Serial Number | - | |
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Cost | - | |
Description:No description available | ||||
NonOrderedQtyNonexistent in DB | decimal | Blanket Open Qty. | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenQty | decimal | Open Qty. | - | |
Description:No description available | ||||
OrderDate | datetime2 | - | ||
Description:No description available | ||||
OrderedQty | decimal | Qty. On Orders | - | |
Description:No description available | ||||
OrderedQtyAlteredNonexistent in DB | bit | - | ||
Description:No description available | ||||
OrderNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderQty | decimal(25, 6) | Project Qty. | - | |
Description:No description available | ||||
OrigExtCost | decimal | - | ||
Description:No description available | ||||
OrigOrderQty | decimal | - | ||
Description:No description available | ||||
OverridenQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
OverridenUOMNonexistent in DB | nvarchar(6) | - | ||
Description:No description available | ||||
PlanID | bigint | Plan ID | INItemPlan | |
Description:No description available | ||||
POAccrualAcctID | int | Accrual Account | Account | |
Description:No description available | ||||
POAccrualSubID | int | Accrual Sub. | Sub | |
Description:No description available | ||||
POAccrualType | char(1) | Billing Based On | - | |
Description:No description available | ||||
POLineNbr | int | Blanket PO Line Nbr. | POLine | |
Description:No description available | ||||
PONbr | nvarchar(15) | Blanket PO Nbr. | POOrder | |
Description:No description available | ||||
POType | char(2) | Blanket PO Type | - | |
Description:No description available | ||||
ProcessNonStockAsServiceViaPR | bit | Process as Service via Purchase Receipt | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
PromisedDate | datetime2 | Promised | - | |
Description:No description available | ||||
RcptQtyAction | char(1) | Receipt Action | - | |
Description:No description available | ||||
RcptQtyMax | decimal | Max. Receipt (%) | - | |
Description:No description available | ||||
RcptQtyMin | decimal | Min. Receipt (%) | - | |
Description:No description available | ||||
RcptQtyThreshold | decimal | Complete On (%) | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | ReasonCode | ||
Description:No description available | ||||
ReceiptStatus | char(1) | - | ||
Description:No description available | ||||
ReceivedQty | decimal | Qty. On Receipts | - | |
Description:No description available | ||||
ReqPrepaidAmt | decimal | - | ||
Description:No description available | ||||
ReqPrepaidQty | decimal | - | ||
Description:No description available | ||||
RequestedDate | datetime2 | Requested | - | |
Description:No description available | ||||
RetainageAmt | decimal | - | ||
Description:No description available | ||||
RetainagePct | decimal | Retainage Percent | - | |
Description:No description available | ||||
RQReqLineNbr | int | RQRequisitionLine | ||
Description:No description available | ||||
RQReqNbr | nvarchar(15) | RQRequisition | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShipToBAccountIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ShipToLocationIDNonexistent in DB | int | - | ||
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SODeleted | bit | - | ||
Description:No description available | ||||
SOLineNbrNonexistent in DB | int | Sales Order Line Nbr. | - | |
Description:No description available | ||||
SOLinkActiveNonexistent in DB | bit | SO Linked | - | |
Description:No description available | ||||
SOOrderNbrNonexistent in DB | nvarchar(15) | Sales Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderStatusNonexistent in DB | nchar(1) | Sales Order Status | - | |
Description:No description available | ||||
SOOrderTypeNonexistent in DB | nchar(2) | - | ||
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Line Description | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnbilledAmt | decimal | - | ||
Description:No description available | ||||
UnbilledQty | decimal | Unbilled Qty. | - | |
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UnitVolume | decimal | Unit Volume | - | |
Description:No description available | ||||
UnitWeight | decimal | Unit Weight | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
VendorLocationIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ViewDemandEnabledNonexistent in DB | bit | - | ||
Description:No description available | ||||