PO
POAccrualInquiryResult
PX.Objects.PO44 of 44 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocumentNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
AccrualAmtNonexistent in DB | decimal | PO Accrued Amount | - | |
Description:No description available | ||||
AccruedByBillsTotal | decimal | - | ||
Description:No description available | ||||
AccruedByReceiptsCost | decimal | - | ||
Description:No description available | ||||
AccruedByReceiptsPPVAmt | decimal | - | ||
Description:No description available | ||||
AccruedByReceiptsTotal | decimal | - | ||
Description:No description available | ||||
AccruedCost | decimal(19, 6) | - | ||
Description:No description available | ||||
AccruedCostTotal | decimal | - | ||
Description:No description available | ||||
AcctID | int | Account | - | |
Description:No description available | ||||
APDocType | char(3) | - | ||
Description:No description available | ||||
APRefNbr | nvarchar(15) | APInvoice | ||
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
DocDate | datetime2 | Document Date | - | |
Description:No description available | ||||
DocumentNbrNonexistent in DB | nvarchar(MAX) | Document Number | - | |
Description:No description available | ||||
DocumentTypeNonexistent in DB | nchar(2) | Document Type | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
INDocType | nchar(1) | IN Document Type | - | |
Description:No description available | ||||
INRefNbr | nvarchar(15) | IN Document Ref. Nbr. | INRegister | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
IsReversed | bit | - | ||
Description:No description available | ||||
IsReversing | bit | - | ||
Description:No description available | ||||
NotAdjustedAmtNonexistent in DB | decimal | IN Adjustment Amount Not Released | - | |
Description:No description available | ||||
NotInvoicedAmtNonexistent in DB | decimal | Drop-Ship Amount Not Invoiced | - | |
Description:No description available | ||||
NotReceivedAmtNonexistent in DB | decimal | Not Received Amount | - | |
Description:No description available | ||||
NotReceivedQty | decimal | Qty. Not Received | - | |
Description:The unreceived quantity of goods in line of AP Bill, selected in the Document Nbr. column. Empty if the document is not AP Bill. | ||||
OrderNbr | nvarchar(15) | PO Ref. Nbr. | POOrder | |
Description:No description available | ||||
OrderQty | decimal | Order Qty. | - | |
Description:Base order quantity in related PO line, if any, else empty. | ||||
OrderType | char(2) | PO Type | - | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | POReceipt | ||
Description:No description available | ||||
POReceiptType | char(2) | - | ||
Description:No description available | ||||
PPVAdjPosted | bit | - | ||
Description:No description available | ||||
PPVAdjRefNbr | nvarchar(15) | PPV Adj. Ref. Nbr. | INRegister | |
Description:No description available | ||||
PPVAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
SubID | int | Subaccount | - | |
Description:No description available | ||||
TaxAdjAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
TaxAdjPosted | bit | - | ||
Description:No description available | ||||
TaxAdjRefNbr | nvarchar(15) | Tax Adj. Ref. Nbr. | INRegister | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
UnbilledAmtNonexistent in DB | decimal | Unbilled Amount | - | |
Description:No description available | ||||
UnbilledQty | decimal | Unbilled Qty. | - | |
Description:Quantity of goods in the purchase receipt or return selected in the Document Nbr. column for which no related AP bill has been prepared yet. Empty, if the document is not PO Receipt/Return. | ||||
VendorID | int | Vendor | - | |
Description:No description available | ||||
VendorNameNonexistent in DB | nvarchar(MAX) | Vendor Name | - | |
Description:No description available | ||||