PO
POOrderAPDoc
PX.Objects.PO13 of 13 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | Type | - | |
Description:Type of the document. Possible values are: "INV" - Invoice, "ACR" - Credit Adjustment, "ADR" - Debit Adjustment, "CHK" - Payment, "VCK" - Voided Payment, "PPM" - Prepayment, "REF" - Refund, "QCK" - Cash Purchase, "VQC" - Voided Cash Purchase. | ||||
PONbr | nvarchar(15) | PO Number | POOrder | |
Description:The reference number of the corresponding PO Order. Together with POOrderType and POLineNbr links APTrans to the PO Orders and their lines. Corresponds to the POOrder.OrderNbr field. | ||||
POOrderType | char(2) | PO Type | - | |
Description:The type of the corresponding PO Order. Together with PONbr and POLineNbr links APTrans to the PO Orders and their lines. Corresponds to the POOrder.OrderType field. See its description for the list of allowed values. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | APInvoice | |
Description:Reference number of the document. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:Code of the Currency of the document. Defaults to the company's base currency. | ||||
DocDate | datetime2 | Date | - | |
Description:Date of the document. | ||||
Status | char(1) | Status | - | |
Description:Status of the document. The field is calculated based on the values of status flag. It can't be changed directly. The fields tht determine status of a document are: Hold, Released, Voided, Scheduled, Prebooked, Printed, Approved, Rejected. Possible values are: ""H"" - Hold, ""B"" - Balanced, ""V"" - Voided, ""S"" - Scheduled, ""N"" - Open, ""C"" - Closed, ""P"" - Printed, ""K"" - Prebooked, ""E"" - Pending Approval, ""R"" - Rejected, ""Z"" - Reserved. Defaults to Hold. | ||||
StatusTextNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
TotalAmtNonexistent in DB | decimal | Billed Amt. | - | |
Description:Billed Amount of the item or service associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
TotalPPVAmt | decimal | PPV Amt | - | |
Description:Purchase price variance amount associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
TotalQty | decimal | Billed Qty. | - | |
Description:No description available | ||||
TotalRetainageAmt | decimal | - | ||
Description:No description available | ||||
TotalTranAmt | decimal | - | ||
Description:No description available | ||||