PO
POAccrualStatus
PX.Objects.PO60 of 60 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Type | char(1) | - | ||
Description:No description available | ||||
AcctID | int | Account | Account | |
Description:No description available | ||||
BaseBilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrigQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BillCuryID | nvarchar(5) | Currency | ||
Description:No description available | ||||
BilledAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
BilledCost | decimal(19, 6) | - | ||
Description:No description available | ||||
BilledDiscAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
BilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BilledTaxAdjCost | decimal(19, 6) | - | ||
Description:No description available | ||||
BilledUOM | nvarchar(6) | - | ||
Description:No description available | ||||
ClosedFinPeriodID | char(6) | - | ||
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 | ||||
CuryBilledAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryBilledCost | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryBilledDiscAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryBilledTaxAdjCost | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryOrigAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryOrigCost | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryOrigDiscAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
DropshipExpenseRecording | char(1) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsAccountAffectedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsClosed | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineType | char(2) | - | ||
Description:No description available | ||||
MaxFinPeriodID | char(6) | - | ||
Description:No description available | ||||
OrderLineNbr | int | POLine | ||
Description:No description available | ||||
OrderNbr | nvarchar(15) | POOrder | ||
Description:No description available | ||||
OrderType | char(2) | - | ||
Description:No description available | ||||
OrigAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
OrigCost | decimal(19, 6) | - | ||
Description:No description available | ||||
OrigCuryID | nvarchar(5) | Currency | ||
Description:No description available | ||||
OrigDiscAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
OrigQty | decimal(25, 6) | - | ||
Description:No description available | ||||
OrigUOM | nvarchar(6) | - | ||
Description:No description available | ||||
PayToVendorID | int | Pay-to Vendor | Vendor | |
Description:No description available | ||||
PPVAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
ReceiptNbr | nvarchar(15) | POReceipt | ||
Description:No description available | ||||
ReceiptType | char(2) | - | ||
Description:No description available | ||||
ReceivedCost | decimal(19, 6) | - | ||
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
ReceivedTaxAdjCost | decimal(19, 6) | - | ||
Description:No description available | ||||
ReceivedUOM | nvarchar(6) | - | ||
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnreleasedPPVAdjCntr | int | - | ||
Description:No description available | ||||
UnreleasedReceiptCntr | int | - | ||
Description:No description available | ||||
UnreleasedTaxAdjCntr | int | - | ||
Description:No description available | ||||
UOMNonexistent in DBObsolete | nvarchar(6) | - | ||
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||