PO
POReceiptLine2
PX.Objects.PO117 of 117 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) | Type | - | |
Description:No description available | ||||
AccrueCost | bit | Accrue Cost | - | |
Description:No description available | ||||
AllowCompleteNonexistent in DB | bit | Complete PO Line | - | |
Description:No description available | ||||
AllowEditUnitCost | bit | Editable Unit Cost | - | |
Description:No description available | ||||
AllowOpenNonexistent in DB | bit | Open PO Line | - | |
Description:No description available | ||||
AllowResetCorrectionLineNonexistent in DB | bit | - | ||
Description:No description available | ||||
AlternateID | nvarchar(50) | - | ||
Description:No description available | ||||
BaseMultReceiptQty | decimal | - | ||
Description:No description available | ||||
BaseOrigQty | decimal | - | ||
Description:No description available | ||||
BaseReceiptQty | decimal | Base Receipt Qty. | - | |
Description:No description available | ||||
BaseReturnedQty | decimal | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal | - | ||
Description:No description available | ||||
BillPPVAmt | decimal | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CanceledWithoutCorrection | bit | CanceledWithoutCorrection | - | |
Description:No description available | ||||
CostCenterID | int | INLocationStatusByCostCenter | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryDiscAmt | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal | Ext. Cost | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmtNonexistent in DBObsolete | decimal | - | ||
Description:No description available | ||||
CuryTranCost | decimal | - | ||
Description:No description available | ||||
CuryTranUnitCost | decimal | - | ||
Description:No description available | ||||
CuryUnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscPct | decimal | Discount Percent | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
DropshipExpenseRecording | varchar(1) | - | ||
Description:No description available | ||||
ExpenseAcctID | int | Account | Account | |
Description:No description available | ||||
ExpenseSubID | int | Sub. | Sub | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
ExtCost | decimal | - | ||
Description:No description available | ||||
ExtVolume | decimal | Volume | - | |
Description:No description available | ||||
ExtWeight | decimal | Weight | - | |
Description:No description available | ||||
GroupDiscountRate | decimal | - | ||
Description:No description available | ||||
INReleased | bit | - | ||
Description:No description available | ||||
IntercompanyShipmentLineNbr | int | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | Inventory Multiplier | - | |
Description:No description available | ||||
IsAdjusted | bit | Corrected | - | |
Description:No description available | ||||
IsAdjustedIN | bit | - | ||
Description:No description available | ||||
IsCorrectionNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsIntercompany | bit | - | ||
Description:No description available | ||||
IsKitNonexistent in DB | bit | Is a Kit | - | |
Description:No description available | ||||
IsLSEntryBlockedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsSpecialOrder | bit | - | ||
Description:No description available | ||||
IsStockItem | bit | Is stock | - | |
Description:No description available | ||||
IsUnassigned | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineType | char(2) | Line Type | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatus | |
Description:No description available | ||||
LotSerialNbrRequiredForDropship | bit | - | ||
Description:No description available | ||||
ManualPrice | bit | Manual Cost | - | |
Description:No description available | ||||
MaxTransferBaseQty | decimal | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenOrderQtyNonexistent in DB | decimal | Open Qty. | - | |
Description:No description available | ||||
OrigDocType | char(1) | - | ||
Description:No description available | ||||
OrigIsFixedInTransit | bit | - | ||
Description:No description available | ||||
OrigIsLotSerial | bit | - | ||
Description:No description available | ||||
OrigLineNbr | int | INTran | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigOrderQtyNonexistent in DB | decimal | Ordered Qty. | - | |
Description:No description available | ||||
OrigPlanType | char(2) | INPlanType | ||
Description:No description available | ||||
OrigReceiptLineNbr | int | PO Receipt Line Nbr. | POReceiptLine | |
Description:No description available | ||||
OrigReceiptLineType | char(2) | - | ||
Description:No description available | ||||
OrigReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:No description available | ||||
OrigReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | INRegister | ||
Description:No description available | ||||
OrigToLocationID | int | - | ||
Description:No description available | ||||
OrigTranType | char(3) | - | ||
Description:No description available | ||||
POAccrualAcctID | int | Accrual Account | Account | |
Description:No description available | ||||
POAccrualLineNbr | int | POAccrualStatus | ||
Description:No description available | ||||
POAccrualRefNoteID | uniqueidentifier | - | ||
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 | PO Line Nbr. | POLine | |
Description:No description available | ||||
PONbr | nvarchar(15) | PO Order Nbr. | POOrder | |
Description:No description available | ||||
POType | char(2) | PO Order Type | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
ReceiptDate | datetime2 | - | ||
Description:No description available | ||||
ReceiptQty | decimal | Receipt Qty. | - | |
Description:No description available | ||||
ReceivedToDateQty | decimal | Received to Date | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReturnedQtyNonexistent in DB | decimal | Returned Qty. | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SOOrderLineNbr | int | Transfer Line Nbr. | SOLine | |
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | Transfer Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderType | char(2) | Transfer Order Type | - | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SOShipmentNbr | nvarchar(15) | Transfer Shipment Nbr. | SOShipment | |
Description:No description available | ||||
SOShipmentType | char(1) | - | ||
Description:No description available | ||||
SpecialOrderCostCenterIDNonexistent in DB | int | Special Order Nbr. | INCostCenter | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TranCost | decimal | Estimated IN Ext. Cost | - | |
Description:No description available | ||||
TranCostFinal | decimal | Final IN Ext. Cost | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Transaction Descr. | - | |
Description:No description available | ||||
TranTypeNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
TranUnitCost | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal | Unassigned Qty. | - | |
Description:No description available | ||||
UnbilledQty | decimal | Unbilled Qty. | - | |
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UnitVolume | decimal | - | ||
Description:No description available | ||||
UnitWeight | decimal | Unit Weight | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||