PO Line
- Last updated
- Save as PDF
A PO Line table is a dimension table that stores details about the PO and the PO Line. The PO line is the management unit of the order. Note that the fields under this dimension are not sorted alphabetically, but logically in most cases, ordered by their place in the PO line creation pages. Also note that this table includes fields for both physical and electronic items although some are relevant only to one of the types.
For more information about enhancements made to the PO Line, see the Analytics: PO Line Dimension Enhancements video (3:45 mins).
Field | Description | Field Location in Alma | Additional Information | Data Type | Data Size |
---|---|---|---|---|---|
Access Model | The public access model for the electronic resource. | The "Activation Information" section on the PO Line Summary page. | Available only for electronic resources. The values are configured in the Access Model code table. |
VARCHAR | 4000 |
Acquisition Method | The code of the method by which the PO Line is acquired, with the default value set as PURCHASE. This value may affect when the PO Line is sent. |
See the Acquisition Method Code table. | VARCHAR | 255 | |
Acquisition Method Description | The description (label) of the acquisition method. | The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Acquisition method". |
VARCHAR | 4000 | |
Additional Order Reference | An additional identifier for the PO line. | The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Additional PO Line Reference Field". |
VARCHAR | 255 | |
Application | Used for identifying migrated PO lines. | VARCHAR | 255 | ||
Assigned To | The user that the order is assigned to. | The top Summary section on the PO Line Summary page. | VARCHAR | 255 | |
Associated PO Line | The PO line associated with the current one. | The "PO Line Information" section on the PO Line Summary page. | VARCHAR | 255 | |
Association Type | The type of association between PO lines, such as defined by user or by a process or job. | In the "Associated PO Lines" tab. | Available when there is an associated PO line | VARCHAR | 255 |
Cancellation Reason | Code for the reason that a PO line is canceled Displays only on canceled lines. | The cancellation reason can be seen in the History tab. See also PO Line Cancellation Reasons Code table. |
VARCHAR | 255 | |
Cancellation Restriction | Indicates if a cancellation restriction note, containing a warning upon the cancellation of a PO line, is configured to be displayed. | The "PO Line Information" section on the PO Line Summary page. | VARCHAR | 4000 | |
Cancellation Restriction Note | The warning to be displayed when canceling a PO line. | The "PO Line Information" section on the PO Line Summary page. | When "Cancellation Restriction" is true. | VARCHAR | 4000 |
CKB ID | When clicking 'Order' from an Electronic Collections search, a CKB ID is stored as a reference to the electronic collection PID, rather than an MMS ID. | VARCHAR | 50 | ||
Claiming Date | The date on which the PO line is sent to the claims task list. | Determined by adding the number of days in the claiming grace period to the expected receipt/activation date. Calculated from the "Claiming grace period field (days)" field on the "Vendor Information" section on the PO Line Summary page. |
DATETIME | ||
Claiming Date (Calendar) | Claiming Date without a timestamp | DATE | |||
Currency | The currency of the transaction. | The "Pricing and Funding" section on the PO Line Summary page. | VARCHAR | 3 | |
Discount | The discount amount. | The "Pricing and Funding" section on the PO Line Summary page. The label in Alma is "Discount (amount)". |
DOUBLE | ||
ERP Number | The ERP number of the purchase order. | Used by customers that want the purchase order to be approved by an ERP system before it is sent to the vendor. | VARCHAR | 255 | |
Expected Activation Date | The expected date for the resource activation by vendor for electronic PO lines. | The "PO Line Information" section on the PO Line Summary page. | Only for electronic PO lines. | DATE | |
Expected Activation Interval | For electronic PO Lines, the number of days after ordering that you expect electronic orders to be activated. | The "Vendor Information" section on the PO Line Summary page. The label in Alma is "Activation due after ordering (days)". |
Only for electronic PO lines. | DOUBLE | |
Expected Receipt after Ordering Interval | For physical PO Lines, the number of days after ordering that you expect physical orders to be received. | The "Vendor information" section on the PO Line Summary page. The label in Alma is "Expected receipt after ordering (days)". |
Only for physical PO lines. | DOUBLE | |
Expected Receiving Date | For physical PO lines, the expected date for physical items to be received from the vendor. | The "Vendor information" section on the PO Line Summary page. The label in Alma is "Expected receipt (date)". |
Only for physical PO lines. | DATE | |
Expected Receiving Interval | Displays the interested users for the PO line. If more than one user is added to the PO line, values are concatenated. | The "Interested Users" section on the PO Line Summary page. | Note that to search for a specific user, you should use the contain filter to also find cases where more than one user was added to the PO. | DOUBLE | |
Interested Users | Displays the interested users for the PO line. If more than one user is added to the PO line, values are concatenated. | The "Interested Users" section on the PO Line Summary page. | Note that to search for a specific user, you should use the contain filter to also find cases where more than one user was added to the PO. | VARCHAR | 4000 |
Invoice Status | The status of the invoice. | The "PO Line Information" section on the PO Line Summary page. | VARCHAR | 4000 | |
Is Claimed | Flags the PO Line if there is an open claim to the vendor. A PO line is claimed if the items were not received or if the receiving/activation date of the PO line passed. | The marked "In Claim" in the Top Summary section on the PO Line Summary page. | VARCHAR | 3 | |
Item Description | Description of the item. | The "Ordered Items" section on the PO Line Summary page. | The description entered for the PO line. Note that this field is not taken from the bibliographic details. It is useful when no item is related to the PO line. Only for physical one-time PO lines. | VARCHAR | 4000 |
License ID | The ID of the license of the PO line that is relevant for electronic PO lines. | The ID of the "License" field in the "Activation Information" section on the PO Line Summary page. | Available only for electronic resources. | VARCHAR | 50 |
List Price | The list price for a single copy of the item. | The "Pricing and Funding" section on the PO Line Summary page. | DOUBLE | ||
Manual Renewal | An indication whether the PO line is renewed manually or automatically. | The "Renewal Information" section on the PO Line Summary page. | Yes for manual and No for automatic. | VARCHAR | 3 |
Material Supplier | The vendor supplying the material being ordered. | The "Vendor Information" section on the PO Line Summary page. | This is a concatenation of: name (name code)/account description (account code). | VARCHAR | 800 |
Material Type | The material type of the PO line. | The "PO Line Information" section on the PO Line Summary page. | For example: Book. | VARCHAR | 4000 |
Net Price | A calculation of the total price for the PO line based on the list price per copy, the discount, and the number of copies ordered. | The "Pricing and Funding" section on the PO Line Summary page. | DOUBLE | ||
No Charge | Indicates that there is no charge for the PO line. | The "Pricing and Funding" section on the PO Line Summary page. | Yes / No | VARCHAR | 10 |
Note To Vendor | Notes to the vendor. | The "Vendor Information" section on the PO Line Summary page. | VARCHAR | 2000 | |
Order Line Type | The order line type as it appears in the order in Alma. | Top Summary section on the PO Line Summary page. Does not have a label in the Alma UI. |
See the PO Line Type Code table. | VARCHAR | 4000 |
Order Line Type Code | The code for the Purchase Order line type. | See the PO Line Type Code table. | VARCHAR | 255 | |
PDA Code | The patron driven acquisition code. | Only if the PO line was created by a PDA process. | VARCHAR | 4000 | |
PDA Name | The patron driven acquisition name | Only if the PO line was created by a PDA process. | VARCHAR | 4000 | |
PO Approval Date | The date the PO was approved (the sent date). | The "Sent Date" field on the "PO Summary" page. | DATE | ||
PO Creation Date | The timestamp of the PO creation date. | Can be seen by clicking the information icon on the "PO Summary" page. The label in Alma is "Created on". |
TIMESTAMP | ||
PO Creation Date (Calendar) | PO creation date without a timestamp. | DATE | |||
PO Creator | The user that created the PO (user name). | Can be seen by clicking the information icon on the "PO Summary" page. The label in Alma is "Created by". |
VARCHAR | 255 | |
PO Line Binding During Receiving | Indicates that the PO line is marked for binding during receiving (for physical items). | The "Receiving Information" section on the PO Line Summary page. The label in Alma is "Binding during receiving". |
Relevant only for physical items. | VARCHAR | 4000 |
PO Line Creation Date | The timestamp of the PO line creation date. | Can be seen by clicking the info icon on the "History" tab. The label in Alma is "Created on". |
TIMESTAMP | ||
PO Line Creation Date (Calendar) | PO line creation date without a timestamp. | Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date. | DATE | ||
PO Line Creator | The user that created the PO line (user name). | Can be seen by clicking the information icon on the "History" tab. The label in Alma is "Last created by". |
VARCHAR | 255 | |
PO Line Identifier | The identifier of the ordered title. (ISSN or ISBN) |
The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Identifier". |
VARCHAR | 4000 | |
PO Line Inventory Active Library Code | The library code of the inventory (item). | VARCHAR | 4000 | ||
PO Line Inventory Library Code | The library code of the inventory (item). | VARCHAR | 4000 | ||
PO Line Manual Packaging | Indicates if the PO line was manually packaged into a PO. | The "PO Line Information" section on the PO Line Summary page. The label in Alma is "Manual packaging". |
VARCHAR | 4000 | |
PO Line Modification Date | The timestamp of the PO line modification date. | Can be seen by clicking the information icon on the "History" tab. The label in Alma is "Last updated on". |
TIMESTAMP | ||
PO Line Modification Date (Calendar) | PO line modification date without a timestamp. | Date | |||
PO Line Modified By | The user that modified the PO line (user name). | Can be seen by clicking the info icon on the "History" tab. The label in Alma is "Last updated by". |
VARCHAR | 255 | |
PO Line Notes | The notes on the PO line. | "Notes" section on the PO Line Summary page. The label in Alma is "Internal note". |
Multiple notes are separated by a semicolon. | VARCHAR | 4000 |
PO Line Owner Library Code | The code of the PO line owner library. | VARCHAR | 4000 | ||
PO Line Owner Library Name | The name of the PO line owner library. | Top Summary section on the PO Line Summary page. The label in Alma is "PO Line Owner". |
VARCHAR | 4000 | |
PO Line Reference | The business identifier of the PO line (PO Line number). | Top Summary section on the PO Line Summary page. The label in Alma is "PO Line". |
This is the PO line number in Alma. | VARCHAR | 255 |
PO Line Routing During Receiving | Indicates that the PO line is marked for routing during receiving (for physical items). | The "Receiving Information" section on the PO Line Summary page. The label in Alma is "Routing during receiving". |
Relevant only for physical items | VARCHAR | 4000 |
PO Line Title | The title of the PO line. | Appears in the top Summary section on the PO Line Summary page. | VARCHAR | 4000 | |
PO Line Vendor Title Number | The number of the PO line vendor title. | An identifier other than ISBN/ISSN for non-books inventory. | VARCHAR | 4000 | |
PO Modification Date | The timestamp of the PO modification date. | Can be seen by clicking the information icon on the "PO Summary" page. The label in Alma is "Last updated on". |
TIMESTAMP | ||
PO Modification Date (Calendar) | The PO modification date without the timestamp. | Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date. | DATE | ||
PO Modified By | The user that modified the PO (user name). | Can be seen by clicking the info icon on the "PO Summary" page. The label in Alma is "Last updated by". |
VARCHAR | 255 | |
PO Number | The business identifier of the PO related to the PO line. | Top Summary section on the PO Line Summary page. The label in Alma is "PO". |
VARCHAR | 255 | |
Quantity for Pricing | The number of items to be paid for. | The "Pricing and Funding" section on the PO Line Summary page. | The quantity for pricing and the number of items to create may be different in a case of discounted pricing through a deal such as "buy two items and get a third item at no additional charge". | DOUBLE | |
Receiving / Activation Note | Text with which the Purchasing Operator indicates to the Receiving Operator the intended location of serial order items in which no inventory items are created. | The "Receiving Information" / "Activation Information" section on the PO Line Summary page. | For physical - receiving note, for electronic - activation note. | VARCHAR | 4000 |
Receiving Date (Latest in POL) | This field allows you to retrieve the latest receiving date for an item in a PO line. | This is useful, since a PO line can have several items and each of the items may have a different receiving date. | DATE | ||
Receiving Status | An indication of whether or not all physical items were received in the receiving workbench. | VARCHAR | 10 | ||
Reclaim Interval (Days) | The interval number of days that Alma will send reclaim letters after the initial claim letter is sent. | The "Vendor Information" section on the PO Line Summary page. | NUMERIC | ||
Renewal Cycle | The cycle for the autorenewal job for continuous orders For example, if it is set to one year, the PO line is renewed in one year. | The "Renewal Information" section on the PO Line Summary page. | Defined in the RenewalCycle code table. | DOUBLE | |
Renewal Date | The date of the PO line’s next renewal for continuous orders. | The "Renewal Information" section on the PO Line Summary page. | Relevant only for continuous orders. | DATE | |
Renewal Note | The note of the PO line renewal for continuous orders. | The "Renewal Information" section on the PO Line Summary page. | Relevant only for continuous orders. | VARCHAR | 4000 |
Renewal Reminder Period | Determines how many days before renewal |
The "Renewal Information" section on the PO Line Summary page. The label in Alma is "Renewal reminder period (days)". |
Relevant only for manually renewed continuous orders. | DOUBLE | |
Reporting Code - 1-5 | Five fields that store the reporting codes. | The "Reporting Codes" section on the PO Line Summary page. | VARCHAR | 255 | |
Reporting Code Description -1-5 | Five fields that store the description of the five reporting code fields. | The "Reporting Codes" section on the PO Line Summary page. | As defined in the Reporting Codes code tables. | VARCHAR | 4000 |
Rush | Indicates whether the PO line is to be rushed. | The "Receiving Information" section on the PO Line Summary page. | VARCHAR | 4000 | |
Sent Date | The date that the PO/ PO line is sent to the vendor. | The "PO Line Information" section on the PO Line Summary page. For PO line - in the history tab. |
DATE | ||
Ship To Address City | The shipped to city address. | The "Contact Information" tab on Vendor Details page. | VARCHAR | 176 | |
Ship To Address Country | The shipped to country address. | The "Contact Information" tab on Vendor Details page. | VARCHAR | 320 | |
Ship to Address ID | Internal ID of the library shipping address that should be used by the vendor. | DOUBLE | |||
Ship To Address Line 1-5 | The shipped to address lines. | The "Contact Information" tab on Vendor Details page. | VARCHAR | 784 | |
Shipping Method | The method for the vendor to ship the order. | Per the values in Shipping Method code table defined in the acquisition configuration menu. | VARCHAR | 255 | |
Source ID | The source file ID used for the EOD lines. | VARCHAR | 255 | ||
Source Type | The source from which the PO line originated, for example, EOD, Manual, and Migration. | The "PO Line Information" section on the PO Line Summary page. | VARCHAR | 255 | |
Status | The business status of the PO line as Active, Canceled, or Closed There are a number of sub-statuses included in the business status "Active". See the Status (Active) field. |
Appears in the top Summary section on the PO Line Summary page. | VARCHAR | 255 | |
Status (Active) | Indicates the sub-status of the "Status" field. For example: Waiting for Invoice, Waiting for Manual Renewal, Recurring Renewal, Under Evaluation, Sent, In Review, Ready to Be Sent, Waiting for Packaging, and Manual Packaging. | Appears in the top Summary section on the PO Line Summary page. | When the status is active. | VARCHAR | 4000 |
Subscription From Date | The date for the beginning of a subscription for continuous orders. | The "Renewal Information" section on the PO Line Summary page. | Relevant only for continuous orders. | DATE | |
Subscription To Date | The date for the end of a subscription for continuous orders. | The "Renewal Information" section on the PO Line Summary page. | Relevant only for continuous orders. | DATE | |
Vendor Access Provider | The vendor that provides access to electronic resources. | The "Vendor Information" section on the PO Line Summary page. | The label in Alma is "Access provider". | VARCHAR | 255 |
Vendor Account Code | The vendor account code as defined in the Alma vendor account definitions. | The fourth section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page. |
VARCHAR | 784 | |
Vendor Account Description | The vendor account description as defined in the Alma vendor account definitions. | The third section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page. |
VARCHAR | 255 | |
Vendor Code | The vendor code as defined in the Alma vendor details definitions. | The second section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page. |
All the vendors that have been on the order, not just the active vendor. | VARCHAR | 255 |
Vendor Contact Person ID | The related vendor contact person ID. | On the vendor record. | Can be accessed by clicking on the Material Supplier in the Vendor Information section. | VARCHAR | 50 |
Vendor Name | The vendor name as defined in the Alma vendor details definitions. | The first section of the field. The "Account" field in the top Summary section on the PO Line Summary page. The "Material Supplier" field in the "Vendor Information" section on the PO Line Summary page. |
VARCHAR | 255 | |
Vendor Reference Number | The reference number for the PO line in Alma, as provided by the vendor Serves as a matching point for identifying a PO line in Alma. | The "Vendor Information" section on the PO Line Summary page. | VARCHAR | 255 | |
Vendor Reference Number Type | The type of the reference number. | The "Vendor Information" section on the PO Line Summary page. | VARCHAR | 255 |