PO_VERSIONS
The version data for a purchasing document.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_VERSIONS_PK |
VERSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CHECKLIST_ID | NUMBER | 18 | Value that uniquely identifies the checklist on a Purchasing Document. | ||
| RELATED_RCO_VERSION_ID | NUMBER | 18 | Indicates if the current version has a related requester proposal. | ||
| REQUESTER_PROPOSAL_FLAG | VARCHAR2 | 1 | Indicates if the version is for a requester proposal. | ||
| OVERRIDE_USER_ID | NUMBER | 18 | The ID of the user capable of performing funds override on the document. | ||
| BASE_VERSION_ID | NUMBER | 18 | The base version ID for a counter proposal document. | ||
| ESIGN_ENV_OWNER_EMAIL_ID | VARCHAR2 | 240 | The email address of the envelope creator. | ||
| ESIGN_ENVELOPE_STATUS | VARCHAR2 | 25 | Holds current status of the envelope. | ||
| ESIGN_ENVELOPE_OWNER | NUMBER | 18 | Not currently used. | ||
| ESIGN_ENVELOPE_ID | VARCHAR2 | 45 | Unique identifier for the DocuSign envelope. | ||
| APPROVAL_INSTANCE_ID | NUMBER | 18 | BPEL instance ID for the current document submission. | ||
| ACCEPTED_DATE | DATE | The date when the document version is accepted by the supplier. | |||
| SUBMITTED_DATE | DATE | The date when the document version is submitted for approval for the first time. | |||
| APPROVED_DATE | DATE | The date when the document version is approved by the buyer. | |||
| COMMUNICATED_DATE | DATE | The date when the document version is communicated to the supplier. | |||
| COMMUNICATED_TO_SUPPLIER | VARCHAR2 | 1 | COMMUNICATED_TO_SUPPLIER | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| VERSION_ID | NUMBER | 18 | Yes | The surrogate key of this table. | |
| PO_HEADER_ID | NUMBER | 18 | Yes | The foreign key of the document. | |
| CO_SEQUENCE | NUMBER | Yes | The sequence number for each change order. This is internally generated (start with 0) and increment by 1 for each new change order created for the document. | ||
| CO_NUM | VARCHAR2 | 80 | The internal identifier for a change order for a document. The identifier must be unique per change order per document. There's a one-to-one relationship between CO_NUM and CO_SEQUENCE for each document. CO_NUM is null for the initial version of the document. | ||
| REVISION_NUM | NUMBER | The revision of the document when the change order is applied. | |||
| CHANGE_ORDER_DESC | VARCHAR2 | 2000 | The change order description. | ||
| CHANGE_ORDER_TYPE | VARCHAR2 | 1 | Indicates whether the change order needs to be communicated to supplier. For first approved document, this flag is always set to Y. | ||
| CHANGE_ORDER_STATUS | VARCHAR2 | 25 | Yes | Status of the change order. Valid values are DRAFT, PENDING APPROVAL, PENDING ACCEPTANCE, PENDING SIGNATURE, PRE-APPROVED, or PROCESSED. | |
| ONLINE_REPORT_ID | NUMBER | 18 | If change order was canceled in because of a final submission check failure, this column indicates the ID to get the validation errors. | ||
| MODIFIED_FLAG | VARCHAR2 | 1 | Indicates whether the document gets modified after it is suspended or submitted for approval. | ||
| REJECTED_FLAG | VARCHAR2 | 1 | Indicates whether the change order is in rejected status. | ||
| WITHDRAWN_FLAG | VARCHAR2 | 1 | A flag to indicate that the change order is withdrawn from approval process. | ||
| EXTERNAL_SYSTEM_FLAG | VARCHAR2 | 1 | Indicates if the document or change order came from an external system. | ||
| ORIGINATOR_ID | NUMBER | 18 | The identifier of the user initiating the change order. | ||
| ORIGINATOR_ROLE | VARCHAR2 | 25 | Yes | The type of the role initiating the change. Possible values are REQUESTER, BUYER, SUPPLIER, CAT ADMIN, or OTHER. | |
| CO_CANCELED_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate whether the change order was canceled in the end. | |
| CANCEL_BACKING_REQ_FLAG | VARCHAR2 | 1 | Indicates whether the PO cancellation results in backing req cancellation. | ||
| CO_CANCELED_BY_ROLE | VARCHAR2 | 25 | The role of the user issuing the cancel action. | ||
| CO_CANCELED_BY_USER_ID | NUMBER | 18 | The user ID of the person canceling the change order. | ||
| REQUEST_DATE | DATE | Yes | The date on which the change order is initiated. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | PROGRAM_NAME | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | PROGRAM_APP_NAME | ||
| CANCEL_DOC_FLAG | VARCHAR2 | 1 | The value is set to Y if the change order is created for canceling the purchase order. | ||
| PROCESSED_DATE | DATE | The date on which the change order is processed. | |||
| PENDING_RESPONSE_ROLE | VARCHAR2 | 25 | The role of the user the change order is pending response from. This column is populated when the change order status is PENDING APPROVAL, PENDING ACCEPTANCE, or PENDING SIGNATURE. Possible values are APPROVER, BUYER (for signature case), or SUPPLIER (for signature or acceptance case). | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY_PROGRAM_NAME | VARCHAR2 | 30 | The module that creates this particular version. | ||
| DOCUMENT_DATE | DATE | DOCUMENT_DATE | |||
| B2B_MESSAGE_ID | VARCHAR2 | 50 | When a document is sent to B2B, this column will be populated with a B2B message ID. | ||
| LAST_SUBMITTER_ID | NUMBER | 18 | The identifier of the user person submitting the document last. | ||
| FUNDS_STATUS | VARCHAR2 | 25 | The budgetary control funds reservation status for a version row, draft, or change order. | ||
| COUNTERPROPOSAL_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate whether this version is a counterproposal before the document is implemented. Counterproposals have a value of Y. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_VERSIONS | po_headers_draft_all | PO_HEADER_ID |
| po_recent_activities | po_versions | PO_VERSION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_VERSIONS_N1 | Non Unique | Default | PO_HEADER_ID, CO_NUM |
| PO_VERSIONS_N2 | Non Unique | Default | ORIGINATOR_ID, ORIGINATOR_ROLE |
| PO_VERSIONS_N3 | Non Unique | Default | CHANGE_ORDER_STATUS |
| PO_VERSIONS_N4 | Non Unique | Default | B2B_MESSAGE_ID |
| PO_VERSIONS_N5 | Non Unique | Default | LAST_UPDATE_DATE |
| PO_VERSIONS_N6 | Non Unique | Default | CHECKLIST_ID |
| PO_VERSIONS_U1 | Unique | Default | VERSION_ID |
| PO_VERSIONS_U2 | Unique | Default | PO_HEADER_ID, CO_SEQUENCE |