| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Accrual Account ID | Unique identifier for Accrual Account | Planned Purchase Order Scheduled Shipment Distributions.Accrual Account ID | ACCRUAL_ACCOUNT_ID | ACCRUAL_ACCOUNT_ID | 114297 |
| Accrual Account Num | | Planned Purchase Order Scheduled Shipment Distributions.Accrual Account Num | ACCRUAL_ACCOUNT_NUM | ACCRUAL_ACCOUNT_NUM | 276040 |
| Accrue On Receipt Flag | | Planned Purchase Order Scheduled Shipment Distributions.Accrue On Receipt Flag | ACCRUE_ON_RECEIPT_FLAG | ACCRUE_ON_RECEIPT_FLAG | 276032 |
| Accrued Flag | | Planned Purchase Order Scheduled Shipment Distributions.Accrued Flag | ACCRUED_FLAG | ACCRUED_FLAG | 276033 |
| Bill Of Material Resource | | Planned Purchase Order Scheduled Shipment Distributions.Bill Of Material Resource | BILL_OF_MATERIAL_RESOURCE | BILL_OF_MATERIAL_RESOURCE | 119839 |
| Bill Of Material Resource ID | Unique identifier for Bill Of Material Resource | Planned Purchase Order Scheduled Shipment Distributions.Bill Of Material Resource ID | BILL_OF_MATERIAL_RESOURCE_ID | BILL_OF_MATERIAL_RESOURCE_ID | 119846 |
| Billed Amount | | Planned Purchase Order Scheduled Shipment Distributions.Billed Amount | BILLED_AMOUNT | BILLED_AMOUNT | 119789 |
| Billed Quantity | | Planned Purchase Order Scheduled Shipment Distributions.Billed Quantity | BILLED_QUANTITY | BILLED_QUANTITY | 119797 |
| Budget Account ID | Unique identifier for Budget Account | Planned Purchase Order Scheduled Shipment Distributions.Budget Account ID | BUDGET_ACCOUNT_ID | BUDGET_ACCOUNT_ID | 120285 |
| Budget Account Num | | Planned Purchase Order Scheduled Shipment Distributions.Budget Account Num | BUDGET_ACCOUNT_NUM | BUDGET_ACCOUNT_NUM | 276039 |
| Cancelled Quantity | | Planned Purchase Order Scheduled Shipment Distributions.Cancelled Quantity | CANCELLED_QUANTITY | CANCELLED_QUANTITY | 121456 |
| Charge Account ID | Unique identifier for Charge Account | Planned Purchase Order Scheduled Shipment Distributions.Charge Account ID | CHARGE_ACCOUNT_ID | CHARGE_ACCOUNT_ID | 121916 |
| Charge Account Num | | Planned Purchase Order Scheduled Shipment Distributions.Charge Account Num | CHARGE_ACCOUNT_NUM | CHARGE_ACCOUNT_NUM | 276038 |
| Created By | | Planned Purchase Order Scheduled Shipment Distributions.Created By | CREATED_BY | CREATED_BY | 125228 |
| Created Date | | Planned Purchase Order Scheduled Shipment Distributions.Created Date | CREATED_DATE | CREATED_DATE | 125403 |
| Created Date - Day | | Planned Purchase Order Scheduled Shipment Distributions.Created Date | | CREATED_DATE_DAY | 171229 |
| Created Date - Month | | Planned Purchase Order Scheduled Shipment Distributions.Created Date | | CREATED_DATE_MONTH | 171383 |
| Created Date - Quarter | | Planned Purchase Order Scheduled Shipment Distributions.Created Date | | CREATED_DATE_QUARTER | 171537 |
| Created Date - Year | | Planned Purchase Order Scheduled Shipment Distributions.Created Date | | CREATED_DATE_YEAR | 171691 |
| Currency Conversion Rate | The currency exchange rate. | Planned Purchase Order Scheduled Shipment Distributions.Currency Conversion Rate | CURRENCY_CONVERSION_RATE | CURRENCY_CONVERSION_RATE | 127121 |
| Currency Conversion Rate Date | Date upon which to obtain the currency conversion rate | Planned Purchase Order Scheduled Shipment Distributions.Currency Conversion Rate Date | CURRENCY_CONVERSION_RATE_DATE | CURRENCY_CONVERSION_RATE_DATE | 127142 |
| Currency Conversion Rate Date - Day | | Planned Purchase Order Scheduled Shipment Distributions.Currency Conversion Rate Date | | CURRENCY_CONVERSION_RATE_DATE_DAY | 174026 |
| Currency Conversion Rate Date - Month | | Planned Purchase Order Scheduled Shipment Distributions.Currency Conversion Rate Date | | CURRENCY_CONVERSION_RATE_DATE_MONTH | 174066 |
| Currency Conversion Rate Date - Quarter | | Planned Purchase Order Scheduled Shipment Distributions.Currency Conversion Rate Date | | CURRENCY_CONVERSION_RATE_DATE_QUARTER | 174106 |
| Currency Conversion Rate Date - Year | | Planned Purchase Order Scheduled Shipment Distributions.Currency Conversion Rate Date | | CURRENCY_CONVERSION_RATE_DATE_YEAR | 174146 |
| Deliver To Location | | Planned Purchase Order Scheduled Shipment Distributions.Deliver To Location | DELIVER_TO_LOCATION | DELIVER_TO_LOCATION | 128996 |
| Deliver To Location ID | Unique identifier for Deliver To Location | Planned Purchase Order Scheduled Shipment Distributions.Deliver To Location ID | DELIVER_TO_LOCATION_ID | DELIVER_TO_LOCATION_ID | 129006 |
| Deliver To Person | | Planned Purchase Order Scheduled Shipment Distributions.Deliver To Person | DELIVER_TO_PERSON | DELIVER_TO_PERSON | 129017 |
| Deliver To Person ID | Unique identifier for Deliver To Person | Planned Purchase Order Scheduled Shipment Distributions.Deliver To Person ID | DELIVER_TO_PERSON_ID | DELIVER_TO_PERSON_ID | 129025 |
| Delivered Quantity | | Planned Purchase Order Scheduled Shipment Distributions.Delivered Quantity | DELIVERED_QUANTITY | DELIVERED_QUANTITY | 128946 |
| Dest Charge Account Id | | Planned Purchase Order Scheduled Shipment Distributions.Dest Charge Account Id | DEST_CHARGE_ACCOUNT_ID | DEST_CHARGE_ACCOUNT_ID | 276042 |
| Dest Variance Account Id | | Planned Purchase Order Scheduled Shipment Distributions.Dest Variance Account Id | DEST_VARIANCE_ACCOUNT_ID | DEST_VARIANCE_ACCOUNT_ID | 276044 |
| Destination Organization Code | | Planned Purchase Order Scheduled Shipment Distributions.Destination Organization Code | DESTINATION_ORGANIZATION_CODE | DESTINATION_ORGANIZATION_CODE | 129887 |
| Destination Organization ID | Unique identifier for Destination Organization | Planned Purchase Order Scheduled Shipment Distributions.Destination Organization ID | DESTINATION_ORGANIZATION_ID | DESTINATION_ORGANIZATION_ID | 129896 |
| Destination Organization Name | | Planned Purchase Order Scheduled Shipment Distributions.Destination Organization Name | DESTINATION_ORGANIZATION_NAME | DESTINATION_ORGANIZATION_NAME | 129905 |
| Destination Subinventory | | Planned Purchase Order Scheduled Shipment Distributions.Destination Subinventory | DESTINATION_SUBINVENTORY | DESTINATION_SUBINVENTORY | 129914 |
| Destination Type | | Planned Purchase Order Scheduled Shipment Distributions.Destination Type | DESTINATION_TYPE | DESTINATION_TYPE | 276037 |
| Distribution Number | Sequence number of the distribution | Planned Purchase Order Scheduled Shipment Distributions.Distribution Number | DISTRIBUTION_NUMBER | DISTRIBUTION_NUMBER | 130241 |
| Dst Chrg Account Num | | Planned Purchase Order Scheduled Shipment Distributions.Dst Chrg Account Num | DST_CHRG_ACCOUNT_NUM | DST_CHRG_ACCOUNT_NUM | 276043 |
| Dst Var Account Num | | Planned Purchase Order Scheduled Shipment Distributions.Dst Var Account Num | DST_VAR_ACCOUNT_NUM | DST_VAR_ACCOUNT_NUM | 276045 |
| Encumbered Amount | | Planned Purchase Order Scheduled Shipment Distributions.Encumbered Amount | ENCUMBERED_AMOUNT | ENCUMBERED_AMOUNT | 132679 |
| Encumbered Flag | | Planned Purchase Order Scheduled Shipment Distributions.Encumbered Flag | ENCUMBERED_FLAG | ENCUMBERED_FLAG | 276035 |
| Expenditure Item Date | Date upon which project work was incurred | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Item Date | EXPENDITURE_ITEM_DATE | EXPENDITURE_ITEM_DATE | 133988 |
| Expenditure Item Date - Day | | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Item Date | | EXPENDITURE_ITEM_DATE_DAY | 179225 |
| Expenditure Item Date - Month | | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Item Date | | EXPENDITURE_ITEM_DATE_MONTH | 179241 |
| Expenditure Item Date - Quarter | | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Item Date | | EXPENDITURE_ITEM_DATE_QUARTER | 179257 |
| Expenditure Item Date - Year | | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Item Date | | EXPENDITURE_ITEM_DATE_YEAR | 179273 |
| Expenditure Organization Code | | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Organization Code | EXPENDITURE_ORGANIZATION_CODE | EXPENDITURE_ORGANIZATION_CODE | 133999 |
| Expenditure Organization ID | Unique identifier for Expenditure Organization | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Organization ID | EXPENDITURE_ORGANIZATION_ID | EXPENDITURE_ORGANIZATION_ID | 134016 |
| Expenditure Organization Name | | Planned Purchase Order Scheduled Shipment Distributions.Expenditure Organization Name | EXPENDITURE_ORGANIZATION_NAME | EXPENDITURE_ORGANIZATION_NAME | 134023 |
| Funds Check Failure Type | | Planned Purchase Order Scheduled Shipment Distributions.Funds Check Failure Type | FUNDS_CHECK_FAILURE_TYPE | FUNDS_CHECK_FAILURE_TYPE | 276036 |
| GL Cancel Date | General Ledger Cancel Date | Planned Purchase Order Scheduled Shipment Distributions.GL Cancel Date | GL_CANCEL_DATE | GL_CANCEL_DATE | 135203 |
| GL Cancel Date - Day | | Planned Purchase Order Scheduled Shipment Distributions.GL Cancel Date | | GL_CANCEL_DATE_DAY | 180783 |
| GL Cancel Date - Month | | Planned Purchase Order Scheduled Shipment Distributions.GL Cancel Date | | GL_CANCEL_DATE_MONTH | 180793 |
| GL Cancel Date - Quarter | | Planned Purchase Order Scheduled Shipment Distributions.GL Cancel Date | | GL_CANCEL_DATE_QUARTER | 180803 |
| GL Cancel Date - Year | | Planned Purchase Order Scheduled Shipment Distributions.GL Cancel Date | | GL_CANCEL_DATE_YEAR | 180813 |
| GL Closed Date | General Ledger Closed Date | Planned Purchase Order Scheduled Shipment Distributions.GL Closed Date | GL_CLOSED_DATE | GL_CLOSED_DATE | 135210 |
| GL Closed Date - Day | | Planned Purchase Order Scheduled Shipment Distributions.GL Closed Date | | GL_CLOSED_DATE_DAY | 180823 |
| GL Closed Date - Month | | Planned Purchase Order Scheduled Shipment Distributions.GL Closed Date | | GL_CLOSED_DATE_MONTH | 180835 |
| GL Closed Date - Quarter | | Planned Purchase Order Scheduled Shipment Distributions.GL Closed Date | | GL_CLOSED_DATE_QUARTER | 180847 |
| GL Closed Date - Year | | Planned Purchase Order Scheduled Shipment Distributions.GL Closed Date | | GL_CLOSED_DATE_YEAR | 180859 |
| GL Encumbered Date | General Ledger Encumbered Date | Planned Purchase Order Scheduled Shipment Distributions.GL Encumbered Date | GL_ENCUMBERED_DATE | GL_ENCUMBERED_DATE | 135226 |
| GL Encumbered Date - Day | | Planned Purchase Order Scheduled Shipment Distributions.GL Encumbered Date | | GL_ENCUMBERED_DATE_DAY | 180913 |
| GL Encumbered Date - Month | | Planned Purchase Order Scheduled Shipment Distributions.GL Encumbered Date | | GL_ENCUMBERED_DATE_MONTH | 180925 |
| GL Encumbered Date - Quarter | | Planned Purchase Order Scheduled Shipment Distributions.GL Encumbered Date | | GL_ENCUMBERED_DATE_QUARTER | 180937 |
| GL Encumbered Date - Year | | Planned Purchase Order Scheduled Shipment Distributions.GL Encumbered Date | | GL_ENCUMBERED_DATE_YEAR | 180949 |
| GL Encumbered Period Name | General Ledger Encumbered Period Name | Planned Purchase Order Scheduled Shipment Distributions.GL Encumbered Period Name | GL_ENCUMBERED_PERIOD_NAME | GL_ENCUMBERED_PERIOD_NAME | 135232 |
| Last Updated By | | Planned Purchase Order Scheduled Shipment Distributions.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139808 |
| Last Updated Date | | Planned Purchase Order Scheduled Shipment Distributions.Last Updated Date | LAST_UPDATED_DATE | LAST_UPDATED_DATE | 139982 |
| Last Updated Date - Day | | Planned Purchase Order Scheduled Shipment Distributions.Last Updated Date | | LAST_UPDATED_DATE_DAY | 182912 |
| Last Updated Date - Month | | Planned Purchase Order Scheduled Shipment Distributions.Last Updated Date | | LAST_UPDATED_DATE_MONTH | 183074 |
| Last Updated Date - Quarter | | Planned Purchase Order Scheduled Shipment Distributions.Last Updated Date | | LAST_UPDATED_DATE_QUARTER | 183236 |
| Last Updated Date - Year | | Planned Purchase Order Scheduled Shipment Distributions.Last Updated Date | | LAST_UPDATED_DATE_YEAR | 183398 |
| Line Number | User-assigned bank statement line number to uniquely identifyindividual transactions. | Planned Purchase Order Scheduled Shipment Distributions.Line Number | LINE_NUMBER | LINE_NUMBER | 144745 |
| Oke Contract Deliverable Id | | Planned Purchase Order Scheduled Shipment Distributions.Oke Contract Deliverable Id | OKE_CONTRACT_DELIVERABLE_ID | OKE_CONTRACT_DELIVERABLE_ID | 276047 |
| Oke Contract Deliverable Num | | Planned Purchase Order Scheduled Shipment Distributions.Oke Contract Deliverable Num | OKE_CONTRACT_DELIVERABLE_NUM | OKE_CONTRACT_DELIVERABLE_NUM | 276049 |
| Oke Contract Line Id | | Planned Purchase Order Scheduled Shipment Distributions.Oke Contract Line Id | OKE_CONTRACT_LINE_ID | OKE_CONTRACT_LINE_ID | 276046 |
| Oke Contract Line Num | | Planned Purchase Order Scheduled Shipment Distributions.Oke Contract Line Num | OKE_CONTRACT_LINE_NUM | OKE_CONTRACT_LINE_NUM | 276048 |
| Operating Unit ID | Unique identifier for Operating Unit | Planned Purchase Order Scheduled Shipment Distributions.Operating Unit ID | OPERATING_UNIT_ID | OPERATING_UNIT_ID | 149544 |
| Operating Unit Name | | Planned Purchase Order Scheduled Shipment Distributions.Operating Unit Name | OPERATING_UNIT_NAME | OPERATING_UNIT_NAME | 149592 |
| Ordered Quantity | | Planned Purchase Order Scheduled Shipment Distributions.Ordered Quantity | ORDERED_QUANTITY | ORDERED_QUANTITY | 149764 |
| Planned Purchase Order Document Number | | Planned Purchase Order Scheduled Shipment Distributions.Planned Purchase Order Document Number | PLANNED_PO_DOCUMENT_NUMBER | PLANNED_PO_DOCUMENT_NUMBER | 154206 |
| Planned Purchase Order ID | Unique identifier for Planned Purchase Order | Planned Purchase Order Scheduled Shipment Distributions.Planned Purchase Order ID | PLANNED_PO_ID | PLANNED_PO_ID | 154212 |
| Planned Release ID | Unique identifier for Planned Release | Planned Purchase Order Scheduled Shipment Distributions.Planned Release ID | PLANNED_RELEASE_ID | PLANNED_RELEASE_ID | 154218 |
| Prevent Encumbrance Flag | | Planned Purchase Order Scheduled Shipment Distributions.Prevent Encumbrance Flag | PREVENT_ENCUMBRANCE_FLAG | PREVENT_ENCUMBRANCE_FLAG | 276034 |
| Project Expenditure Type | Expenditure type defined in Oracle Projects denoting expenditure category, revenue category, and expenditure type classes | Planned Purchase Order Scheduled Shipment Distributions.Project Expenditure Type | PROJECT_EXPENDITURE_TYPE | PROJECT_EXPENDITURE_TYPE | 156404 |
| Project ID | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Planned Purchase Order Scheduled Shipment Distributions.Project ID | PROJECT_ID | PROJECT_ID | 156506 |
| Project Name | | Planned Purchase Order Scheduled Shipment Distributions.Project Name | PROJECT_NAME | PROJECT_NAME | 156589 |
| Purchase Order Distribution ID | Unique identifier for Purchase Order Distribution | Planned Purchase Order Scheduled Shipment Distributions.Purchase Order Distribution ID | PO_DISTRIBUTION_ID | PO_DISTRIBUTION_ID | 155017 |
| Purchase Order Line ID | Unique identifier for Purchase Order Line | Planned Purchase Order Scheduled Shipment Distributions.Purchase Order Line ID | PO_LINE_ID | PO_LINE_ID | 155057 |
| Purchase Order Shipment ID | Unique identifier for Purchase Order Shipment | Planned Purchase Order Scheduled Shipment Distributions.Purchase Order Shipment ID | PO_SHIPMENT_ID | PO_SHIPMENT_ID | 155104 |
| Release Number | | Planned Purchase Order Scheduled Shipment Distributions.Release Number | RELEASE_NUMBER | RELEASE_NUMBER | 158459 |
| Requisition Distribution ID | Unique identifier for Requisition Distribution | Planned Purchase Order Scheduled Shipment Distributions.Requisition Distribution ID | REQUISITION_DISTRIBUTION_ID | REQUISITION_DISTRIBUTION_ID | 158816 |
| Requisition Distribution Number | | Planned Purchase Order Scheduled Shipment Distributions.Requisition Distribution Number | REQ_DISTRIBUTION_NUMBER | REQ_DISTRIBUTION_NUMBER | 158861 |
| Requisition Document Number | | Planned Purchase Order Scheduled Shipment Distributions.Requisition Document Number | REQ_DOCUMENT_NUMBER | REQ_DOCUMENT_NUMBER | 158867 |
| Requisition Line Number | | Planned Purchase Order Scheduled Shipment Distributions.Requisition Line Number | REQ_LINE_NUMBER | REQ_LINE_NUMBER | 158873 |
| Set Of Books ID | The unique identification number assigned to a set of books. | Planned Purchase Order Scheduled Shipment Distributions.Set Of Books ID | SET_OF_BOOKS_ID | SET_OF_BOOKS_ID | 161532 |
| Set Of Books Name | The set of books name. | Planned Purchase Order Scheduled Shipment Distributions.Set Of Books Name | SET_OF_BOOKS_NAME | SET_OF_BOOKS_NAME | 161592 |
| Shipment Number | | Planned Purchase Order Scheduled Shipment Distributions.Shipment Number | SHIPMENT_NUMBER | SHIPMENT_NUMBER | 161688 |
| Task ID | Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task. | Planned Purchase Order Scheduled Shipment Distributions.Task ID | TASK_ID | TASK_ID | 164606 |
| Task Number | User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. | Planned Purchase Order Scheduled Shipment Distributions.Task Number | TASK_NUMBER | TASK_NUMBER | 164679 |
| Unencumbered Amount | | Planned Purchase Order Scheduled Shipment Distributions.Unencumbered Amount | UNENCUMBERED_AMOUNT | UNENCUMBERED_AMOUNT | 166227 |
| Unencumbered Quantity | | Planned Purchase Order Scheduled Shipment Distributions.Unencumbered Quantity | UNENCUMBERED_QUANTITY | UNENCUMBERED_QUANTITY | 166232 |
| Ussgl Transaction Code | Transaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables). | Planned Purchase Order Scheduled Shipment Distributions.Ussgl Transaction Code | USSGL_TRANSACTION_CODE | USSGL_TRANSACTION_CODE | 167061 |
| Variance Account ID | Unique identifier for Variance Account | Planned Purchase Order Scheduled Shipment Distributions.Variance Account ID | VARIANCE_ACCOUNT_ID | VARIANCE_ACCOUNT_ID | 167392 |
| Variance Account Num | | Planned Purchase Order Scheduled Shipment Distributions.Variance Account Num | VARIANCE_ACCOUNT_NUM | VARIANCE_ACCOUNT_NUM | 276041 |
| WIP Entity ID | Unique identifier for Work in Process Entity | Planned Purchase Order Scheduled Shipment Distributions.WIP Entity ID | WIP_ENTITY_ID | WIP_ENTITY_ID | 167821 |
| WIP Job Name | Work in Process Job Name | Planned Purchase Order Scheduled Shipment Distributions.WIP Job Name | WIP_JOB_NAME | WIP_JOB_NAME | 167831 |
| WIP Line Code | Work in Process Line Code | Planned Purchase Order Scheduled Shipment Distributions.WIP Line Code | WIP_LINE_CODE | WIP_LINE_CODE | 167841 |
| WIP Line ID | Unique identifier for Work in Process Line | Planned Purchase Order Scheduled Shipment Distributions.WIP Line ID | WIP_LINE_ID | WIP_LINE_ID | 167851 |
| WIP Operation Sequence Number | Work in Process Operation Sequence Number | Planned Purchase Order Scheduled Shipment Distributions.WIP Operation Sequence Number | WIP_OPERATION_SEQUENCE_NUMBER | WIP_OPERATION_SEQUENCE_NUMBER | 167862 |
| WIP Repetitive Schedule ID | Unique identifier for Work in Process Repetitive Schedule | Planned Purchase Order Scheduled Shipment Distributions.WIP Repetitive Schedule ID | WIP_REPETITIVE_SCHEDULE_ID | WIP_REPETITIVE_SCHEDULE_ID | 167875 |
| WIP Resource Sequence Number | Work in Process Resource Sequence Number | Planned Purchase Order Scheduled Shipment Distributions.WIP Resource Sequence Number | WIP_RESOURCE_SEQUENCE_NUMBER | WIP_RESOURCE_SEQUENCE_NUMBER | 167884 |