PO
POLineS
PX.Objects.PO74 of 74 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 | - | ||
Description:No description available | ||||
BaseBilledQty | decimal | - | ||
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | Base Order Qty. | - | |
Description:No description available | ||||
BaseReceivedQty | decimal | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
Billed | bit | - | ||
Description:No description available | ||||
BilledAmt | decimal | - | ||
Description:No description available | ||||
BilledCost | decimal | - | ||
Description:No description available | ||||
BilledDiscAmt | decimal | - | ||
Description:No description available | ||||
BilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BilledUOM | nvarchar(6) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
Cancelled | bit | Cancelled | - | |
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
CompletePOLine | char(1) | - | ||
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CuryBilledAmt | decimal | - | ||
Description:No description available | ||||
CuryBilledCost | decimal | - | ||
Description:No description available | ||||
CuryBilledDiscAmt | decimal | - | ||
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Discount Amount | - | |
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 | ||||
CuryRetainageAmt | decimal(19, 4) | - | ||
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 | ||||
DiscountID | nvarchar(10) | Discount Code | APDiscount | |
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | VendorDiscountSequence | |
Description:No description available | ||||
DiscPct | decimal(9, 6) | - | ||
Description:No description available | ||||
DocumentDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
DropshipExpenseRecording | char(1) | - | ||
Description:No description available | ||||
DRTermEndDate | datetime2 | - | ||
Description:No description available | ||||
DRTermStartDate | datetime2 | - | ||
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 | ||||
GroupDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsStockItem | bit | - | ||
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 | ||||
OrderDate | datetime2 | - | ||
Description:No description available | ||||
OrderNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderQty | decimal(25, 6) | Order Qty. | - | |
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) | - | ||
Description:No description available | ||||
PPVAmt | decimal | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ReceivedCost | decimal | - | ||
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
ReceivedUOM | nvarchar(6) | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RetainageAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
RetainagePct | decimal(9, 6) | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
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 | ||||
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 | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||