PO
POLine
PX.Objects.POView API Entity: PurchaseOrder
/entity/Default/24.200.001/PurchaseOrder144 of 144 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
OrderNbr API | 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(25, 6) | - | ||
Description:No description available | ||||
BaseCompletedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOpenQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrderedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | Base Order Qty. | - | |
Description:No description available | ||||
BaseOverridenQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal(25, 6) | Base Received Qty. | - | |
Description:No description available | ||||
BaseReqPrepaidQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
BilledQty | decimal(25, 6) | Billed Qty. | - | |
Description:No description available | ||||
BLLineNbr | int | - | ||
Description:No description available | ||||
BLOrderedCost | decimal(19, 4) | - | ||
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(25, 6) | 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 | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryBilledAmt | decimal(19, 4) | Billed Amount | - | |
Description:No description available | ||||
CuryBLOrderedCost | decimal(19, 4) | Received Cost | - | |
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Discount Amount | - | |
Description:No description available | ||||
CuryDiscCost | decimal | Disc. Unit Cost | - | |
Description:No description available | ||||
CuryExtCost | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmt | decimal(19, 4) | Ext. Cost | - | |
Description:No description available | ||||
CuryReceivedCostNonexistent in DBObsolete | decimal | - | ||
Description:No description available | ||||
CuryReqPrepaidAmt | decimal(19, 4) | Prepaid Amount | - | |
Description:No description available | ||||
CuryRetainageAmt | decimal(19, 4) | Retainage Amount | - | |
Description:No description available | ||||
CuryUnbilledAmt | decimal(19, 4) | Unbilled Amount | - | |
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
DiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscCost | decimal | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | APDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary(MAX) | - | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | VendorDiscountSequence | |
Description:No description available | ||||
DiscPct | decimal(9, 6) | Discount Percent | - | |
Description:No description available | ||||
DisplayReqPrepaidQtyNonexistent in DB | decimal | Prepaid Qty. | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
DropshipExpenseRecording | char(1) | Record Drop-Ship Expenses | - | |
Description:No description available | ||||
DropshipReceiptProcessing | char(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(19, 4) | Amount | - | |
Description:No description available | ||||
ExtVolume | decimal(25, 6) | Volume | - | |
Description:No description available | ||||
ExtWeight | decimal(25, 6) | Weight | - | |
Description:No description available | ||||
GroupDiscountRate | decimal(21, 18) | - | ||
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:When set to "true", indicates that the DRTermStartDate and DRTermEndDate fields are enabled for the line. The value of this field is set by the POOrderEntry graph based on the settings of the item selected for the line. In other contexts it is not populated. See the attribute on the POOrderEntry.POLine_ItemRequiresTerms_CacheAttached handler for details. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | 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(19, 4) | - | ||
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(25, 6) | Open Qty. | - | |
Description:No description available | ||||
OrderDate | datetime2 | - | ||
Description:No description available | ||||
OrderedQty | decimal(25, 6) | 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) | Order Qty. | - | |
Description:No description available | ||||
OrigExtCost | decimal(19, 4) | - | ||
Description:No description available | ||||
OrigOrderQty | decimal(25, 6) | - | ||
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:When set to "true", indicates that non-stock item will be processed as service via Purchase Receipt. | ||||
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(9, 6) | Max. Receipt (%) | - | |
Description:No description available | ||||
RcptQtyMin | decimal(9, 6) | Min. Receipt (%) | - | |
Description:No description available | ||||
RcptQtyThreshold | decimal(9, 6) | Complete On (%) | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | ReasonCode | ||
Description:No description available | ||||
ReceiptStatus | char(1) | - | ||
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | Qty. On Receipts | - | |
Description:No description available | ||||
ReqPrepaidAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
ReqPrepaidQty | decimal(25, 6) | - | ||
Description:No description available | ||||
RequestedDate | datetime2 | Requested | - | |
Description:No description available | ||||
RetainageAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
RetainagePct | decimal(9, 6) | Retainage Percent | - | |
Description:No description available | ||||
RQReqLineNbr | int | RQRequisitionLine | ||
Description:No description available | ||||
RQReqNbr | nvarchar(20) | 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(19, 4) | - | ||
Description:No description available | ||||
UnbilledQty | decimal(25, 6) | Unbilled Qty. | - | |
Description:No description available | ||||
UnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
UnitVolume | decimal(19, 6) | Unit Volume | - | |
Description:No description available | ||||
UnitWeight | decimal(19, 6) | Unit Weight | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID API | int | Vendor | Vendor | |
Description:No description available | ||||
VendorLocationIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ViewDemandEnabledNonexistent in DB | bit | - | ||
Description:No description available | ||||