Purchase order lines

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • Purchase order lines provide information of the individual lines under a purchase requisition or a sourcing request for the referenced supplier.

    sn_shop_purchase_order_line table

    You can add or associate a purchase order with a purchase order line.

    Tableau 1. sn_shop_purchase_order_line table fields
    Field Data type Description
    Purchase order Reference ERP PO number as unique identifier of the purchase order.
    Supplier Reference Supplier for which the shopper places the order.
    Product name String Name of the product or service purchased from a supplier.
    Product type Choice list Defines whether product purchased is classified as goods or services. The values are:
    • Good
    • Service
    • Handling fee
    Goods receipt required Choice list Applicable only if product type is “Good”. The values are:
    • Yes
    • No
    Acknowledgement type Choice list Applicable only if product type is “Service” or “Handling fee”. The values are:
    • Milestones
    • Service acknowledgement
    • Two way match
    Expected delivery date Date Applicable only if product type is “Good".
    ERP line number String A unique identifier generated within an ERP system for the purchase order line.
    Start date Date The date on which service is expected to be rendered. This is applicable only if Product type is “Service”.
    End date Date The date on which service is expected to end. This is applicable only if Product type is “Service”.
    Purchase quantity String The quantity of the goods or service purchased.
    Unit Choice list The unit of rate at which product or service is sold by supplier. The values are:
    • Fixed fee
    • Individual unit
    Unit price currency The price of each individual unit purchased.
    Total line amount currency Total amount of purchased goods and services including estimated tax and shipping.
    Recipient Reference The person to whom goods or services are being delivered.
    Address Street address where goods will be shipped or where services will be provided.
    City City where goods will be shipped or where the services are provided.
    State or Province State or Province where goods will be shipped or where the services are provided.
    Country Country where goods will be shipped or where the services are provided.
    Zip or Postal code Zip or Postal code where goods will be shipped or where the services are provided.
    General Ledger Account The account to which capital or operational expenses will be posted.