| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Accepted Quantity | | Planned Purchase Order Line Shipments.Accepted Quantity | ACCEPTED_QUANTITY | ACCEPTED_QUANTITY | 114045 |
| Accrue On Receipt Flag | | Planned Purchase Order Line Shipments.Accrue On Receipt Flag | ACCRUE_ON_RECEIPT_FLAG | ACCRUE_ON_RECEIPT_FLAG | 275974 |
| Acknowledgement Date | | Planned Purchase Order Line Shipments.Acknowledgement Date | ACKNOWLEDGEMENT_DATE | ACKNOWLEDGEMENT_DATE | 275985 |
| Acknowledgement Type | | Planned Purchase Order Line Shipments.Acknowledgement Type | ACKNOWLEDGEMENT_TYPE | ACKNOWLEDGEMENT_TYPE | 275984 |
| Actual Price | Price override for the shipment | Planned Purchase Order Line Shipments.Actual Price | ACTUAL_PRICE | ACTUAL_PRICE | 114893 |
| Allow Substitute Receipt | | Planned Purchase Order Line Shipments.Allow Substitute Receipt | ALLOW_SUBSTITUTE_RECEIPT | ALLOW_SUBSTITUTE_RECEIPT | 275975 |
| Approval Date | | Planned Purchase Order Line Shipments.Approval Date | APPROVAL_DATE | APPROVAL_DATE | 116324 |
| Approval Date - Day | | Planned Purchase Order Line Shipments.Approval Date | | APPROVAL_DATE_DAY | 169035 |
| Approval Date - Month | | Planned Purchase Order Line Shipments.Approval Date | | APPROVAL_DATE_MONTH | 169069 |
| Approval Date - Quarter | | Planned Purchase Order Line Shipments.Approval Date | | APPROVAL_DATE_QUARTER | 169103 |
| Approval Date - Year | | Planned Purchase Order Line Shipments.Approval Date | | APPROVAL_DATE_YEAR | 169137 |
| Approved Flag | | Planned Purchase Order Line Shipments.Approved Flag | APPROVED_FLAG | APPROVED_FLAG | 275969 |
| Billed Quantity | | Planned Purchase Order Line Shipments.Billed Quantity | BILLED_QUANTITY | BILLED_QUANTITY | 119795 |
| Cancel Date | | Planned Purchase Order Line Shipments.Cancel Date | CANCEL_DATE | CANCEL_DATE | 121469 |
| Cancel Date - Day | | Planned Purchase Order Line Shipments.Cancel Date | | CANCEL_DATE_DAY | 170277 |
| Cancel Date - Month | | Planned Purchase Order Line Shipments.Cancel Date | | CANCEL_DATE_MONTH | 170297 |
| Cancel Date - Quarter | | Planned Purchase Order Line Shipments.Cancel Date | | CANCEL_DATE_QUARTER | 170317 |
| Cancel Date - Year | | Planned Purchase Order Line Shipments.Cancel Date | | CANCEL_DATE_YEAR | 170337 |
| Cancel Flag | | Planned Purchase Order Line Shipments.Cancel Flag | CANCEL_FLAG | CANCEL_FLAG | 275970 |
| Cancel Reason | | Planned Purchase Order Line Shipments.Cancel Reason | CANCEL_REASON | CANCEL_REASON | 121480 |
| Cancelled Quantity | | Planned Purchase Order Line Shipments.Cancelled Quantity | CANCELLED_QUANTITY | CANCELLED_QUANTITY | 121454 |
| Closed Date | | Planned Purchase Order Line Shipments.Closed Date | CLOSED_DATE | CLOSED_DATE | 122181 |
| Closed Date - Day | | Planned Purchase Order Line Shipments.Closed Date | | CLOSED_DATE_DAY | 170525 |
| Closed Date - Month | | Planned Purchase Order Line Shipments.Closed Date | | CLOSED_DATE_MONTH | 170563 |
| Closed Date - Quarter | | Planned Purchase Order Line Shipments.Closed Date | | CLOSED_DATE_QUARTER | 170601 |
| Closed Date - Year | | Planned Purchase Order Line Shipments.Closed Date | | CLOSED_DATE_YEAR | 170641 |
| Closed Reason | | Planned Purchase Order Line Shipments.Closed Reason | CLOSED_REASON | CLOSED_REASON | 122198 |
| Closure Status | | Planned Purchase Order Line Shipments.Closure Status | CLOSURE_STATUS | CLOSURE_STATUS | 275971 |
| Context | | Planned Purchase Order Line Shipments.Context | CONTEXT | CONTEXT | 275981 |
| Created By | | Planned Purchase Order Line Shipments.Created By | CREATED_BY | CREATED_BY | 125225 |
| Created Date | | Planned Purchase Order Line Shipments.Created Date | CREATED_DATE | CREATED_DATE | 125400 |
| Created Date - Day | | Planned Purchase Order Line Shipments.Created Date | | CREATED_DATE_DAY | 171223 |
| Created Date - Month | | Planned Purchase Order Line Shipments.Created Date | | CREATED_DATE_MONTH | 171377 |
| Created Date - Quarter | | Planned Purchase Order Line Shipments.Created Date | | CREATED_DATE_QUARTER | 171531 |
| Created Date - Year | | Planned Purchase Order Line Shipments.Created Date | | CREATED_DATE_YEAR | 171685 |
| EDI Type | | Planned Purchase Order Line Shipments.EDI Type | EDI_TYPE | EDI_TYPE | 275987 |
| ETD | | Planned Purchase Order Line Shipments.ETD | ETD | ETD | 275982 |
| Early Receipt Allowed Days | Maximum acceptable number of days items can be received early | Planned Purchase Order Line Shipments.Early Receipt Allowed Days | EARLY_RECEIPT_ALLOWED_DAYS | EARLY_RECEIPT_ALLOWED_DAYS | 130689 |
| Encumbered Date | | Planned Purchase Order Line Shipments.Encumbered Date | ENCUMBERED_DATE | ENCUMBERED_DATE | 132684 |
| Encumbered Date - Day | | Planned Purchase Order Line Shipments.Encumbered Date | | ENCUMBERED_DATE_DAY | 178209 |
| Encumbered Date - Month | | Planned Purchase Order Line Shipments.Encumbered Date | | ENCUMBERED_DATE_MONTH | 178219 |
| Encumbered Date - Quarter | | Planned Purchase Order Line Shipments.Encumbered Date | | ENCUMBERED_DATE_QUARTER | 178229 |
| Encumbered Date - Year | | Planned Purchase Order Line Shipments.Encumbered Date | | ENCUMBERED_DATE_YEAR | 178239 |
| Encumbered Flag | | Planned Purchase Order Line Shipments.Encumbered Flag | ENCUMBERED_FLAG | ENCUMBERED_FLAG | 275973 |
| Enforce Ship To Location | | Planned Purchase Order Line Shipments.Enforce Ship To Location | ENFORCE_SHIP_TO_LOCATION | ENFORCE_SHIP_TO_LOCATION | 275976 |
| Error Message | | Planned Purchase Order Line Shipments.Error Message | ERROR_MESSAGE | ERROR_MESSAGE | 275986 |
| Firm Status | | Planned Purchase Order Line Shipments.Firm Status | FIRM_STATUS | FIRM_STATUS | 275972 |
| Invoice Close Tolerance | Percentage tolerance within which a shipment is automatically closed for invoicing when billed | Planned Purchase Order Line Shipments.Invoice Close Tolerance | INVOICE_CLOSE_TOLERANCE | INVOICE_CLOSE_TOLERANCE | 137388 |
| Invoice Matching | | Planned Purchase Order Line Shipments.Invoice Matching | INVOICE_MATCHING | INVOICE_MATCHING | 275977 |
| Last Updated By | | Planned Purchase Order Line Shipments.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139805 |
| Last Updated Date | | Planned Purchase Order Line Shipments.Last Updated Date | LAST_UPDATED_DATE | LAST_UPDATED_DATE | 139979 |
| Last Updated Date - Day | | Planned Purchase Order Line Shipments.Last Updated Date | | LAST_UPDATED_DATE_DAY | 182906 |
| Last Updated Date - Month | | Planned Purchase Order Line Shipments.Last Updated Date | | LAST_UPDATED_DATE_MONTH | 183068 |
| Last Updated Date - Quarter | | Planned Purchase Order Line Shipments.Last Updated Date | | LAST_UPDATED_DATE_QUARTER | 183230 |
| Last Updated Date - Year | | Planned Purchase Order Line Shipments.Last Updated Date | | LAST_UPDATED_DATE_YEAR | 183392 |
| Late Receipt Allowed Days | Maximum acceptable number of days items can be received late | Planned Purchase Order Line Shipments.Late Receipt Allowed Days | LATE_RECEIPT_ALLOWED_DAYS | LATE_RECEIPT_ALLOWED_DAYS | 141700 |
| Latest Acceptable Date | Latest acceptable receipt date of the shipment | Planned Purchase Order Line Shipments.Latest Acceptable Date | LATEST_ACCEPTABLE_DATE | LATEST_ACCEPTABLE_DATE | 141686 |
| Latest Acceptable Date - Day | | Planned Purchase Order Line Shipments.Latest Acceptable Date | | LATEST_ACCEPTABLE_DATE_DAY | 185216 |
| Latest Acceptable Date - Month | | Planned Purchase Order Line Shipments.Latest Acceptable Date | | LATEST_ACCEPTABLE_DATE_MONTH | 185230 |
| Latest Acceptable Date - Quarter | | Planned Purchase Order Line Shipments.Latest Acceptable Date | | LATEST_ACCEPTABLE_DATE_QUARTER | 185244 |
| Latest Acceptable Date - Year | | Planned Purchase Order Line Shipments.Latest Acceptable Date | | LATEST_ACCEPTABLE_DATE_YEAR | 185258 |
| Line Number | User-assigned bank statement line number to uniquely identifyindividual transactions. | Planned Purchase Order Line Shipments.Line Number | LINE_NUMBER | LINE_NUMBER | 144743 |
| ModusLink Line ID | | Planned Purchase Order Line Shipments.ModusLink Line ID | MODUSLINK_LINE_ID | MODUSLINK_LINE_ID | 275983 |
| Need By Date | | Planned Purchase Order Line Shipments.Need By Date | NEED_BY_DATE | NEED_BY_DATE | 147863 |
| Need By Date - Day | | Planned Purchase Order Line Shipments.Need By Date | | NEED_BY_DATE_DAY | 186422 |
| Need By Date - Month | | Planned Purchase Order Line Shipments.Need By Date | | NEED_BY_DATE_MONTH | 186440 |
| Need By Date - Quarter | | Planned Purchase Order Line Shipments.Need By Date | | NEED_BY_DATE_QUARTER | 186458 |
| Need By Date - Year | | Planned Purchase Order Line Shipments.Need By Date | | NEED_BY_DATE_YEAR | 186476 |
| Operating Unit ID | Unique identifier for Operating Unit | Planned Purchase Order Line Shipments.Operating Unit ID | OPERATING_UNIT_ID | OPERATING_UNIT_ID | 149541 |
| Operating Unit Name | | Planned Purchase Order Line Shipments.Operating Unit Name | OPERATING_UNIT_NAME | OPERATING_UNIT_NAME | 149589 |
| Ordered Quantity | | Planned Purchase Order Line Shipments.Ordered Quantity | ORDERED_QUANTITY | ORDERED_QUANTITY | 149762 |
| Planned Purchase Order Document Number | | Planned Purchase Order Line Shipments.Planned Purchase Order Document Number | PLANNED_PO_DOCUMENT_NUMBER | PLANNED_PO_DOCUMENT_NUMBER | 154203 |
| Planned Purchase Order ID | Unique identifier for Planned Purchase Order | Planned Purchase Order Line Shipments.Planned Purchase Order ID | PLANNED_PO_ID | PLANNED_PO_ID | 154209 |
| Preferred Grade | | Planned Purchase Order Line Shipments.Preferred Grade | PREFERRED_GRADE | PREFERRED_GRADE | 275990 |
| Promised Date | | Planned Purchase Order Line Shipments.Promised Date | PROMISED_DATE | PROMISED_DATE | 156732 |
| Promised Date - Day | | Planned Purchase Order Line Shipments.Promised Date | | PROMISED_DATE_DAY | 189028 |
| Promised Date - Month | | Planned Purchase Order Line Shipments.Promised Date | | PROMISED_DATE_MONTH | 189038 |
| Promised Date - Quarter | | Planned Purchase Order Line Shipments.Promised Date | | PROMISED_DATE_QUARTER | 189048 |
| Promised Date - Year | | Planned Purchase Order Line Shipments.Promised Date | | PROMISED_DATE_YEAR | 189058 |
| Purchase Order Line ID | Unique identifier for Purchase Order Line | Planned Purchase Order Line Shipments.Purchase Order Line ID | PO_LINE_ID | PO_LINE_ID | 155055 |
| Purchase Order Shipment ID | Unique identifier for Purchase Order Shipment | Planned Purchase Order Line Shipments.Purchase Order Shipment ID | PO_SHIPMENT_ID | PO_SHIPMENT_ID | 155102 |
| Qty Received Exception | | Planned Purchase Order Line Shipments.Qty Received Exception | QTY_RECEIVED_EXCEPTION | QTY_RECEIVED_EXCEPTION | 275978 |
| Quantity Received Tolerance | Maximum over-receipt tolerance percentage | Planned Purchase Order Line Shipments.Quantity Received Tolerance | QUANTITY_RECEIVED_TOLERANCE | QUANTITY_RECEIVED_TOLERANCE | 157318 |
| Receipt Days Exception | | Planned Purchase Order Line Shipments.Receipt Days Exception | RECEIPT_DAYS_EXCEPTION | RECEIPT_DAYS_EXCEPTION | 275979 |
| Received Quantity | | Planned Purchase Order Line Shipments.Received Quantity | RECEIVED_QUANTITY | RECEIVED_QUANTITY | 158045 |
| Receiving Close Tolerance | Percentage tolerance within which a shipment is automatically closed for receiving | Planned Purchase Order Line Shipments.Receiving Close Tolerance | RECEIVING_CLOSE_TOLERANCE | RECEIVING_CLOSE_TOLERANCE | 158071 |
| Receiving Routing ID | Unique identifier for Receiving Routing | Planned Purchase Order Line Shipments.Receiving Routing ID | RECEIVING_ROUTING_ID | RECEIVING_ROUTING_ID | 158080 |
| Receiving Routing Name | | Planned Purchase Order Line Shipments.Receiving Routing Name | RECEIVING_ROUTING_NAME | RECEIVING_ROUTING_NAME | 158089 |
| Rejected Quantity | | Planned Purchase Order Line Shipments.Rejected Quantity | REJECTED_QUANTITY | REJECTED_QUANTITY | 158418 |
| Secondary Quantity | | Planned Purchase Order Line Shipments.Secondary Quantity | SECONDARY_QUANTITY | SECONDARY_QUANTITY | 275988 |
| Secondary Unit Of Measure | | Planned Purchase Order Line Shipments.Secondary Unit Of Measure | SECONDARY_UNIT_OF_MEASURE | SECONDARY_UNIT_OF_MEASURE | 275989 |
| Ship To Location | | Planned Purchase Order Line Shipments.Ship To Location | SHIP_TO_LOCATION | SHIP_TO_LOCATION | 161920 |
| Ship To Location ID | Unique identifier for Ship To Location | Planned Purchase Order Line Shipments.Ship To Location ID | SHIP_TO_LOCATION_ID | SHIP_TO_LOCATION_ID | 161947 |
| Ship To Organization Code | | Planned Purchase Order Line Shipments.Ship To Organization Code | SHIP_TO_ORGANIZATION_CODE | SHIP_TO_ORGANIZATION_CODE | 161963 |
| Ship To Organization ID | Unique identifier for Ship To Organization | Planned Purchase Order Line Shipments.Ship To Organization ID | SHIP_TO_ORGANIZATION_ID | SHIP_TO_ORGANIZATION_ID | 161970 |
| Ship To Organization Name | | Planned Purchase Order Line Shipments.Ship To Organization Name | SHIP_TO_ORGANIZATION_NAME | SHIP_TO_ORGANIZATION_NAME | 161978 |
| Shipment Number | Sequence number of the shipment | Planned Purchase Order Line Shipments.Shipment Number | SHIPMENT_NUMBER | SHIPMENT_NUMBER | 161686 |
| Shipped Quantity | | Planned Purchase Order Line Shipments.Shipped Quantity | SHIPPED_QUANTITY | SHIPPED_QUANTITY | 161720 |
| Tax Name | Tax code for the shipment | Planned Purchase Order Line Shipments.Tax Name | TAX_NAME | TAX_NAME | 164779 |
| Taxable Flag | | Planned Purchase Order Line Shipments.Taxable Flag | TAXABLE_FLAG | TAXABLE_FLAG | 275980 |
| UOM Class | Unit of measure Class | Planned Purchase Order Line Shipments.UOM Class | UOM_CLASS | UOM_CLASS | 166388 |
| UOM Description | Unit of measure Description | Planned Purchase Order Line Shipments.UOM Description | UOM_DESCRIPTION | UOM_DESCRIPTION | 166423 |
| US Standard GL Transaction Code | Transaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables). | Planned Purchase Order Line Shipments.US Standard GL Transaction Code | USSGL_TRANSACTION_CODE | USSGL_TRANSACTION_CODE | 167058 |
| Unit Of Measure | | Planned Purchase Order Line Shipments.Unit Of Measure | UNIT_OF_MEASURE | UNIT_OF_MEASURE | 166285 |