Skip to main content
PO

POLineS

PX.Objects.PO
Field NameTypeDisplay NameForeign Key
LineNbr
intLine 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
BranchIDDefault Navigation
intBranchBranch
Description:No description available
Cancelled
bitCancelled-
Description:No description available
Closed
bitClosed-
Description:No description available
CompletePOLine
char(1)-
Description:No description available
CostCenterID
int-
Description:No description available
CostCodeIDDefault Navigation
intCost CodePMCostCode
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
bigintCurrencyInfo
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
DiscountIDDefault Navigation
nvarchar(10)Discount CodeAPDiscount
Description:No description available
DiscountSequenceID
nvarchar(10)Discount SequenceVendorDiscountSequence
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
ExpenseAcctIDDefault Navigation
intAccountAccount
Description:No description available
ExpenseSubIDDefault Navigation
intSub.Sub
Description:No description available
ExtCost
decimal(19, 4)Amount-
Description:No description available
GroupDiscountRate
decimal(21, 18)-
Description:No description available
InventoryIDDefault Navigation
intInventory IDInventoryItem
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
POAccrualAcctIDDefault Navigation
intAccrual AccountAccount
Description:No description available
POAccrualSubIDDefault Navigation
intAccrual Sub.Sub
Description:No description available
POAccrualType
char(1)-
Description:No description available
PPVAmt
decimal-
Description:No description available
ProjectIDDefault Navigation
intProjectPMProject
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
bitSelected-
Description:No description available
SiteIDDefault Navigation
intWarehouseINSite
Description:No description available
SortOrder
intLine Order-
Description:No description available
SubItemIDDefault Navigation
intSubitemINSubItem
Description:No description available
TaskIDDefault Navigation
intProject TaskPMTask
Description:No description available
TaxCategoryID
nvarchar(15)Tax CategoryTaxCategory
Description:No description available
TaxIDDefault Navigation
nvarchar(60)Tax IDTax
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
UOMDefault Navigation
nvarchar(6)UOM-
Description:No description available
VendorIDDefault Navigation
intVendorVendor
Description:No description available