PO
POLine
No summary is documented for this DAC in the release source.
View API Entity: PurchaseOrderDetail
/entity/Default/25.200.001/PurchaseOrderDetail| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccrueCost | bit | Accrue Cost | - | |
Description:When set to "true", indicates that cost will be processed using expense accrual account. | ||||
AllowComplete | bit | Allow Complete | - | |
Description:No description available | ||||
AllowEditUnitCostInPR | bit | Editable Unit Cost in Receipt | - | |
Description:No description available | ||||
AlternateID API | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
BLLineNbr | int | - | ||
Description:No description available | ||||
BLOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
BLOrderedCost | decimal | - | ||
Description:No description available | ||||
BLType | char(2) | - | ||
Description:No description available | ||||
BaseBilledQty | decimal | - | ||
Description:No description available | ||||
BaseCompletedQty | decimal | - | ||
Description:No description available | ||||
BaseOpenQty | decimal | - | ||
Description:No description available | ||||
BaseOrderQty | decimal | Base Order Qty. | - | |
Description:No description available | ||||
BaseOrderedQty | decimal | - | ||
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 | ||||
BranchID API | int | Branch | Branch | |
Description:No description available | ||||
bool? | Calculate automatic discounts on import | - | ||
Description:No description available | ||||
Cancelled API | bit | Cancelled | - | |
Description:No description available | ||||
ClearPlanIDNonexistent in DB | bool? | - | ||
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
CommitmentID | uniqueidentifier | - | ||
Description:No description available | ||||
CompletePOLine | char(1) | Close PO Line | - | |
Description:No description available | ||||
Completed API | bit | Completed | - | |
Description:No description available | ||||
CompletedQty | decimal | Received Qty. | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID API | 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 | ||||
CuryBLOrderedCost | decimal | Received Cost | - | |
Description:No description available | ||||
CuryBilledAmt | decimal | Billed Amount | - | |
Description:No description available | ||||
CuryDiscAmt | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryDiscCostNonexistent in DB | decimal? | Disc. Unit Cost | - | |
Description:No description available | ||||
CuryExtCost | decimal | Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmt API | decimal | Ext. Cost | - | |
Description:No description available | ||||
decimal? | - | |||
Description:No description available | ||||
CuryReqPrepaidAmt | decimal | Prepaid Amount | - | |
Description:No description available | ||||
CuryRetainageAmtNonexistent in DB | decimal? | Retainage Amount | - | |
Description:No description available | ||||
CuryUnbilledAmt | decimal | Unbilled Amount | - | |
Description:No description available | ||||
CuryUnitCost API | decimal | Unit Cost | - | |
Description:No description available | ||||
DRTermEndDate | datetime | Term End Date | - | |
Description:No description available | ||||
DRTermStartDate | datetime | Term Start Date | - | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscCostNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DiscPct | decimal | Discount Percent | - | |
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | APDiscount | |
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | VendorDiscountSequence | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary | - | ||
Description:No description available | ||||
DisplayReqPrepaidQtyNonexistent in DB | decimal? | Prepaid Qty. | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
DropshipExpenseRecording | nvarchar(1) | Record Drop-Ship Expenses | - | |
Description:No description available | ||||
DropshipReceiptProcessing | nvarchar(1) | Drop-Ship Receipt Processing | - | |
Description:No description available | ||||
ExpenseAcctID API | int | Account | Account | |
Description:No description available | ||||
ExpenseSubID API | 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 | ||||
HasExpiredComplianceDocumentsNonexistent in DB | bool? | Expired Compliance | - | |
Description:No description available | ||||
HasInclusiveTaxes | bit | - | ||
Description:No description available | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsKitNonexistent in DB | bool? | 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 | bool? | - | ||
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 | 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 | ||||
LineNbr API | int | Line Nbr. | - | |
Description:No description available | ||||
LineType API | 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 | datetime | - | ||
Description:No description available | ||||
OrderNbr API | nvarchar(15) | Order Nbr. | POOrder | |
Description:No description available | ||||
OrderNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderQty API | decimal | Order Qty. | - | |
Description:No description available | ||||
OrderType API | char(2) | Order Type | - | |
Description:No description available | ||||
OrderedQty API | decimal | Qty. On Orders | - | |
Description:No description available | ||||
OrderedQtyAlteredNonexistent in DB | bool? | - | ||
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 | string | - | ||
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 API | nvarchar(15) | Blanket PO Nbr. | POOrder | |
Description:No description available | ||||
POType API | char(2) | Blanket PO Type | POOrder | |
Description:No description available | ||||
PlanID | bigint | Plan ID | INItemPlan | |
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 API | int | Project | PMProject | |
Description:No description available | ||||
PromisedDate API | datetime | Promised | - | |
Description:No description available | ||||
RQReqLineNbr | int | RQRequisitionLine | ||
Description:No description available | ||||
RQReqNbr | nvarchar(15) | RQRequisition | ||
Description:No description available | ||||
RcptQtyAction API | char(1) | Receipt Action | - | |
Description:No description available | ||||
RcptQtyMax API | decimal | Max. Receipt (%) | - | |
Description:No description available | ||||
RcptQtyMin API | decimal | Min. Receipt (%) | - | |
Description:No description available | ||||
RcptQtyThreshold API | decimal | Complete On (%) | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | ReasonCode | ||
Description:No description available | ||||
ReceiptStatus | char(1) | - | ||
Description:No description available | ||||
ReceivedQty API | decimal | Qty. On Receipts | - | |
Description:No description available | ||||
ReqPrepaidAmt | decimal | - | ||
Description:No description available | ||||
ReqPrepaidQty | decimal | - | ||
Description:No description available | ||||
RequestedDate API | datetime | Requested | - | |
Description:No description available | ||||
RetainageAmt | decimal | - | ||
Description:No description available | ||||
RetainagePct | decimal? | Retainage Percent | - | |
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 | bool? | SO Linked | - | |
Description:No description available | ||||
SOOrderNbrNonexistent in DB | string | Sales Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderStatusNonexistent in DB | string | Sales Order Status | - | |
Description:No description available | ||||
SOOrderTypeNonexistent in DB | string | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShipToBAccountIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
ShipToLocationIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SubItemID API | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID API | int | Project Task | PMTask | |
Description:No description available | ||||
TaxCategoryID API | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
Description:No description available | ||||
TranDesc API | nvarchar(256) | Line Description | - | |
Description:No description available | ||||
UOM API | nvarchar(6) | UOM | INUnit | |
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 | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
VendorLocationIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
ViewDemandEnabledNonexistent in DB | bool? | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||