Purchasing Document Versions
The Purchasing Document Versions view object contains version data for purchasing document.
Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentVersionExtractPVO
Primary Keys : VersionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
AcceptedDate | Date when the document version was accepted by the supplier. |
ApprovedDate | Date when the document version was approved by the buyer. |
B2bMessageId | Value that uniquely identifies the Business to Business message when a document is sent to Business to Business. |
BaseVersionId | Value that uniquely identifies the base version for a counter proposal document. |
CancelBackingReqFlag | Indicates whether the PO cancellation results in backing requisition cancellation. Possible values are Y, N, and null. This attribute doesn't have a default value. |
CancelDocFlag | Indicates whether the change order is created for canceling the purchase order. Possible values are Y, N, and null. This attribute doesn't have a default value. |
ChangeOrderDesc | Description of the change order. |
ChangeOrderStatus | Status of the change order. Valid values are: DRAFT, PENDING APPROVAL, PENDING ACCEPTANCE, PENDING SIGNATURE, PRE-APPROVED, and PROCESSED. |
ChangeOrderType | Indicates whether the change order needs to be communicated to supplier. For first approved document, the value of this attribute is always set to Y. |
CoCanceledByRole | Role of the user issuing the cancel action. |
CoCanceledByUserId | Value that uniquely identifies the person who canceled the change order. |
CoCanceledFlag | Indicates whether the change order was canceled in the end. Possible values are Y and N. This attribute doesn't have a default value. |
CoNum | Internal identifier for a change order for a document. It has to be unique per change order per document. There is a one-to-one relationship between CO_NUM and CO_SEQUENCE for each document. The change order number is null for the initial version of the document. |
CoSequence | Sequence number for each change order. This is internally generated, it starts with 0 and increment by 1 for each new change order created for the document. |
CommunicatedDate | Date when the document version was communicated to the supplier. |
CommunicatedToSupplier | Indicates if the document version should be communicated to the supplier. Possible values are Y, N, and null. This attribute doesn't have a default value. |
CounterproposalFlag | Indicates whether this version is a counter proposal before the document is implemented. Possible values are Y and N. The default value is Y. |
CreatedBy | User who created the purchasing document version. |
CreatedByProgramName | Name of the program that created the purchasing document version. |
CreationDate | Date and time when the purchasing document version was created. |
DocumentDate | Date on the document. |
EsignEnvOwnerEmailId | Email address of the envelope creator. |
EsignEnvelopeId | Value that uniquely identifies the DocuSign envelope. |
EsignEnvelopeOwner | User who created the DocuSign envelope. |
EsignEnvelopeStatus | Current status of the envelope. |
ExternalSystemFlag | Indicates if the document or change order came from an external system. Possible values are Y, N, and null. This attribute doesn't have a default value. |
FundsStatus | Budgetary Control Funds reservation status for a version row, draft or change order. |
LastUpdateDate | Date when the purchasing document version was last updated. |
LastUpdateLogin | Session login associated with the user who last updated the purchasing document version. |
LastUpdatedBy | User who last updated the purchasing document version. |
ModifiedFlag | Indicates whether the document gets modified after it's suspended or submitted for approval. Possible values are Y, N, and null. This attribute doesn't have a default value. |
ObjectVersionNumber | Number of times the purchasing document version row has been updated. |
OnlineReportId | Value that uniquely identifies the report to get the validation errors if change order got canceled in the end due to final submission check failure. |
OriginatorId | Value that uniquely identifies the user who initiated the change order. |
OriginatorRole | Type of the role that can initiate the change. Possible values are: REQUESTER, BUYER, SUPPLIER, CAT ADMIN, and OTHER. |
PendingResponseRole | Role of the user the change order is pending response from. This column will be populated when change order status is PENDING APPROVAL, PENDING ACCEPTANCE, or PENDING SIGNATURE. Possible values are: APPROVER, BUYER for signature case, and SUPPLIER for signature or acceptance case. |
PoHeaderId | Value that uniquely identifies the purchase order header. |
ProcessedDate | Date when the change order was processed. |
RejectedFlag | Indicates whether the change order is in rejected status or not. Possible values are Y, N, and null. This attribute doesn't have a default value. |
RequestDate | Date when the change order was initiated. |
RequestId | Value that uniquely identifies the Enterprise Service Scheduler job that created or last updated the row. |
RevisionNum | Revision number of the document when the change order was applied. |
SubmittedDate | Date when the document version was submitted for approval for the first time. |
VersionId | Value that uniquely identifies the purchasing document version. This is the primary key of the Purchasing Document Version view object. |
WithdrawnFlag | Indicates whether the change order is withdrawn from the approval process. Possible values are Y, N, and null. This attribute doesn't have a default value. |