Skip to main content

Window: Matched Purchase Orders

[Created: 05/09/2001 - Updated: 25/11/2005 ]
Description: View Matched Purchase Orders
Help: View detals of matched purchase order lines to invoice lines and material receipt lines

Tab: Match PO

[Created: 23/02/2002 - Updated: 25/11/2005 ]
Description: View matched Purchase Orders
Help: View detals of matched purchase order lines to invoice lines and material receipt lines
Tab Level: 0

Table 10: Match PO - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_matchpo.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_matchpo.AD_Org_ID numeric(10)
Table Direct
Document NoDocument sequence number of the documentThe document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).m_matchpo.DocumentNo character varying(30)
String
Transaction DateTransaction DateThe Transaction Date indicates the date of the transaction.m_matchpo.DateTrx timestamp without time zone
Date
DescriptionOptional short description of the recordA description is limited to 255 characters.m_matchpo.Description character varying(255)
String
Purchase Order LinePurchase Order LineThe Purchase Order Line is a unique identifier for a line in an order.m_matchpo.C_OrderLine_ID numeric(10)
Search
Referenced Match POm_matchpo.Ref_MatchPO_ID numeric(10)
Search
Invoice LineInvoice Detail LineThe Invoice Line uniquely identifies a single line of an Invoice.m_matchpo.C_InvoiceLine_ID numeric(10)
Search
Receipt LineLine on Receipt documentm_matchpo.M_InOutLine_ID numeric(10)
Search
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_matchpo.M_Product_ID numeric(10)
Search
Attribute Set InstanceProduct Attribute Set InstanceThe values of the actual Product Attribute Instances. The product level attributes are defined on Product level.m_matchpo.M_AttributeSetInstance_ID numeric(10)
Product Attribute
QuantityQuantityThe Quantity indicates the number of a specific product or item for this document.m_matchpo.Qty numeric
Quantity
Account DateAccounting DateThe Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.m_matchpo.DateAcct timestamp without time zone
Date
ApprovedIndicates if this document requires approvalThe Approved checkbox indicates if this document requires approval before it can be processed.m_matchpo.IsApproved character(1)
Yes-No
Price Match DifferenceDifference between Purchase and Invoice Price per matched lineThe difference between purchase and invoice price may be used for requiring explicit approval if a Price Match Tolerance is defined on Business Partner Group level.m_matchpo.PriceMatchDifference numeric
Amount
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.m_matchpo.Processed character(1)
Yes-No
PostedPosting statusThe Posted field indicates the status of the Generation of General Ledger Accounting Linesm_matchpo.Posted character(1)
Button
DeleteDelete PO Matching Recordm_matchpo.Processing character(1)
Button