PO
POReceiptLineS
PX.Objects.PO74 of 74 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
ReceiptNbr | nvarchar(15) | Receipt Nbr. | POReceipt | |
Description:No description available | ||||
ReceiptType | char(2) | Receipt Type | POReceipt | |
Description:No description available | ||||
AccrueCost | bit | - | ||
Description:No description available | ||||
AllowEditUnitCost | bit | - | ||
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseReceiptQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CompletePOLine | char(1) | - | ||
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID | int | PMCostCode | ||
Description:No description available | ||||
CuryExtCost | decimal(19, 4) | Order Line Amount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Order Currency | Currency | |
Description:No description available | ||||
CuryOrderDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryOrderLineAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryOrderUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
CuryReceiptDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryReceiptExtCost | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryReceiptUnitCost | decimal(19, 6) | Receipt Unit Cost | - | |
Description:No description available | ||||
CuryRetainageAmt | decimal(19, 4) | Retainage Amount | - | |
Description:No description available | ||||
CuryUnbilledAmt | decimal(19, 4) | Unbilled Amount | - | |
Description:No description available | ||||
DiscountID | nvarchar(10) | APDiscount | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | VendorDiscountSequence | ||
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 | ||
Description:No description available | ||||
ExpenseSubID | int | Sub | ||
Description:No description available | ||||
ExtCost | decimal(19, 4) | - | ||
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 | ||||
LineType | char(2) | Line Type | - | |
Description:No description available | ||||
OrderCuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
OrderDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OrderDiscPct | decimal(9, 6) | Discount Percent | - | |
Description:No description available | ||||
OrderLineAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OrderQty | decimal(25, 6) | Ordered Qty. | - | |
Description:No description available | ||||
OrderType | char(2) | - | ||
Description:No description available | ||||
OrderUnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
OrderUOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
POAccrualAcctID | int | Account | ||
Description:No description available | ||||
POAccrualLineNbr | int | POAccrualStatus | ||
Description:No description available | ||||
POAccrualRefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
POAccrualSubID | int | Sub | ||
Description:No description available | ||||
POAccrualType | char(1) | - | ||
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | POLine | |
Description:No description available | ||||
PONbr | nvarchar(15) | Order Nbr. | POOrder | |
Description:No description available | ||||
POType | char(2) | Order Type | - | |
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
ReceiptCuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
ReceiptDate | datetime2 | - | ||
Description:No description available | ||||
ReceiptDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
ReceiptDiscPct | decimal(9, 6) | Discount Percent | - | |
Description:No description available | ||||
ReceiptExtCost | decimal(19, 4) | - | ||
Description:No description available | ||||
ReceiptQty | decimal(25, 6) | Receipt Qty. | - | |
Description:No description available | ||||
ReceiptUnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
RetainageAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
RetainagePct | decimal(9, 6) | Retainage Percent | - | |
Description:No description available | ||||
ReturnInventoryCostMode | char(1) | Cost of Inventory Return From | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder | int | - | ||
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | 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) | Transaction Descr. | - | |
Description:No description available | ||||
UnbilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
UnbilledQty | decimal(25, 6) | Unbilled Qty. | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||