Draft Purchasing Document Header Details

The Draft Purchasing Document Header Details view object contains information about purchase order and purchase agreement headers.

Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.DraftPurchasingDocumentHeaderExtractPVO

Primary Keys : PoHeaderId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AcceptanceDueDate	Date that the application requests the supplier to acknowledge the document.
AcceptanceRequiredFlag	Indicates whether a supplier acknowledgment is required on the document and if required, what level it's required.
AcceptanceWithinDays	Number of days the supplier can decide to accept or reject the document.
AgentId	Value that uniquely identifies the buyer.
AgingOnsetPoint	Value that identifies the mutually agreed event point at which consigned material begins to age. The possible values for aging onset point are None, Receipt, and Shipment.
AgingPeriodDays	Value that identifies the maximum number of days the material may be on consignment.
AmountLimit	Value that identifies the amount limit on an agreement beyond which releases can't be created against the agreement.
BillToLocationId	Value that uniquely identifies the bill-to location.
BillingCycleClosingDate	Date when the current billing period for an agreement ends. This is applicable only for a BPA with consignment terms enabled.
BilltoBuId	Value that uniquely identifies the business unit that processes supplier invoices for the purchase order.
BlanketTotalAmount	Value that identifies the amount agreed on an agreement line between the buying and selling organization.
BudgetControlEnabledFlag	Value that identifies whether budgetary control is enabled on the purchase order or not.
BuyerManagedTransportFlag	Value that identifies that the buying company is responsible for arranging the transportation, from picking up the requested goods to delivering to ship-to locations specified on the order.
CarrierId	Value that uniquely identifies the company that transports the item.
CbcAccountingDate	Value that identifies the accounting action date for dual budgetary control functionality.
ChangeAcceptedFlag	Value that identifies whether the draft change has been accepted or not
ChangeRequestedBy	User who requested change to the purchase document.
ChangeSummary	Description of changes made. This information is entered by the buyer when submitting the document for approval and may be used in generating an amendment document.
Comments	Text describing an order or an agreement.
ConfirmingOrderFlag	Value that identifies whether the document is a confirmation of an order the supplier may already be aware of.
ConsumptionAdviceFrequency	Value that identifies the default value of the frequency at which the consumption advice will be generated for all consumption transactions for consigned inventory purchased under this agreement. The possible values for consumption advice frequency are Daily, Weekly, and Monthly.
ConsumptionAdviceSummary	Value that identifies the default value of the frequency at which the consumption advice will be generated for all consumption transactions for consigned inventory purchased under this agreement. The possible values for consumption advice frequency are Daily, Weekly, and Monthly.
ContermsArticlesUpdDate	Date and time the contract clauses were last updated. Applicable to purchasing document of type Standard, Contract, Blanket.
ContermsDelivUpdDate	Date and time the contract deliverables were last updated. Applicable to purchasing document of type Standard, Contract, Blanket.
ContermsExistFlag	Value that identifies if the document has contract terms and conditions associated with it or not.
CpaReference	Value that identifies the CPA reference to support the IP catalog upgrade for items that had a CPA reference prior to Release 12. This column is for information purpose.
CreatedBy	User who created the purchasing document header details.
CreatedLanguage	Value that identifies the language code in which the global blanket purchase agreement was created.
CreationDate	Date and time when the purchasing document header details was created.
CurrencyCode	Value that identifies the code that identifies the purchase order currency.
DefaultConsignmentLineFlag	Value that identifies whether the lines added on this blanket agreement should be marked as consigned lines by default.
DefaultPoTradeOrgId	Value that uniquely identifies the purchasing trade organization. The purchasing trade organization is the inventory organization reporting to the sold-to legal entity identified in a purchase order. This organization is used for cost accounting the transactions in the sold-to legal entity.
DefaultTaxationCountry	Value that identifies the default country for taxation for tax calculation purposes.
DocumentCreationMethod	Value that identifies the method in which the document got created such as Autocreate, and enter PO.
EmailAddress	Value that identifies the email address specified on the document to which the document will be communicated after approval.
EnabledFlag	Indicates whether the key flexfield enabled is enabled or not. Possible values are Y or N.
EncumbranceRequiredFlag	Indicates whether the document is to be encumbered or not. Possible values are N or NULL.
EndDate	Date after which the purchase agreement is no longer valid.
EntityChangeTypeCode	Value that identifies if the row is new or changed.
ExternalChangeFlag	Value that indicates if the change is external, supplier facing, or not
Fax	Value that identifies the fax number specified on the document to which the document after approval will be communicated.
FirmDate	Date from which the purchase order is firmed.
FirmStatusLookupCode	Value that indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application
FirstPtyRegId	Value that identifies the first party tax registration ID for the transaction.
FobLookupCode	Code that identifies the type of free-on-board terms for the document.
FreightTermsLookupCode	Code that identifies the type of freight terms for the document
FromHeaderId	Value that uniquely identifies the document from which this document is copied.
FromTypeLookupCode	Value that identifies the document type that the template is created for. Possible values are STANDARD, BLANKET, or CONTRACT.
FundsStatus	Value that identifies whether funds have been reserved on the document or not.
GenerateOrdersAutomatic	Value that indicates whether an order should be automatically created for a requisition line referencing the agreement or not.
GovernmentContext	United States standard general ledger descriptive flexfield context column.
GroupRequisitionLines	Value that indicates whether or not requisition lines referencing the same agreement line should be grouped when creating an order.
GroupRequisitions	Value that indicates whether or not requisition lines of different requisitions referencing the same agreement line should be grouped when creating an order.
InterfaceSourceCode	Value that identifies the source application from which the transaction was imported.
JobDefinitionName	Value that identifies the name of the job that created or last updated the row.
JobDefinitionPackage	Value that identifies the package name of the job that created or last updated the row.
LastUpdateDate	Date and time when the purchasing document was last updated.
LastUpdateLogin	Session login associated with the user who last updated the row.
LastUpdatedBy	User who last updated the row.
ManualBccdOverrideFlag	Value that indicates if the billing cycle closing date has been edited manually.
MinReleaseAmount	Value that identifies the minimum amount that can be released against an agreement.
ModeOfTransport	Value that identifies the mode of transport that the shipper uses to transport the item such as land, sea, and air.
NoteToAuthorizer	Text comments to the approver included as needed when submitting a document for approval.
NoteToReceiver	Special text instructions to the receiver in the docking area to be reviewed while performing the receipt.
NoteToVendor	Special text instructions to the supplier to be reviewed while completing your order.
ObjectVersionNumber	Number of times the purchasing document has been updated.
OrchestrationOrderFlag	Value that identifies whether the purchase order is an orchestrated purchase order. Valid values are Y or N. If Y, then the PO is an orchestrated order. If N, then the PO isn't an orchestrated order.
OverridingApproverId	Value that uniquely identifies the user specified on the purchase order as the overriding approver for approval routing.
PayOnCode	Code that identifies whether the purchase order will be paid upon receipt.
PayOnUseFlag	Value that identifies whether to generate invoices automatically on behalf of the supplier when supplier owned material stocked in buying organization's premise is consumed by the buying organization.
PcardId	Value that uniquely identifies the procurement card used for the order.
PendingSignatureFlag	Value that indicates whether the purchasing document is pending signatures or not. Applicable to Purchasing document of type Standard, Contract, and Blanket.
PoHeaderId	Value that uniquely identifies the purchase order.
PrcBuId	Value that uniquely identifies the business unit that manages and owns the purchase order.
PriceUpdateTolerance	Value that identifies the tolerance in percent above which if the price changes on an agreement line, the line should be highlighted to the user making the change.
ProgramAppName	Value that identifies the application name of the concurrent program.
ProgramName	Value that identifies the concurrent program. Concurrent programs are system batch jobs that retrieve and push data between Oracle applications and the database
Rate	Value that identifies the conversion rate to use when converting the currency.
RateDate	Date to use for the conversion rate when converting an amount into another currency. The conversion rate varies depending on date.
RateType	Value that identifies the rate type that the application uses to determine the currency conversion rate for the purchase order.
ReferenceNum	Number used for EDI transaction audit trail reference.
ReqBuId	Value that uniquely identifies the requisitioning business unit.
RequestId	Value that uniquely identifies the request ID of the job that created or last updated the row.
RetroPriceApplyUpdatesFlag	Value that identifies whether or not price updates on the agreement should be propagated to orders referencing the agreement.
RetroPriceCommUpdatesFlag	Value that identifies whether or not orders that were repriced because of a price change on the referenced agreement should be communicated to the supplier.
RetroPriceInitApprovalFlag	Value that identifies whether or not the retroactive price update background process should be initiated upon agreement approval.
RetroPriceOpenOrderFlag	Value that identifies whether or not the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement.
Segment1	Segment of the key flexfield. It's a system-assigned number used to identify the document in forms and reports.
Segment2	Segment of the key flexfield. Key flexfields are used to store internally defined codes unique to a particular business, specifying part numbers, general ledger accounts, and other business entities.
Segment3	Segment of the key flexfield. Key flexfields are used to store internally defined codes unique to a particular business, specifying part numbers, general ledger accounts, and other business entities.
Segment4	Segment of the key flexfield. Key flexfields are used to store internally defined codes unique to a particular business, specifying part numbers, general ledger accounts, and other business entities.
Segment5	Segment of the key flexfield. Key flexfields are used to store internally defined codes unique to a particular business, specifying part numbers, general ledger accounts, and other business entities.
ServiceLevel	Value that identifies the level that indicates the priority of transportation that affects how quickly goods are transported.
ShipToLocationId	Value that uniquely identifies the ship-to location.
ShippingControl	Value that identifies who's responsible for arranging transportation.
SignatureRequiredFlag	Value that identifies if signatures are required on the purchasing document before it can be implemented. Possible values are Yes, No.
SoldtoLeId	Value that uniquely identified the sold-to legal entity. It Indicates the party that's financially responsible for the purchases on a purchase order.
StartDate	Date on which the agreement becomes effective.
StyleId	Value that uniquely identifies the purchasing style of the document.
SubmitApprovalAutomatic	Value that identifies whether the document can be automatically submitted for approval.
SubmitDate	Date when the document was first submitted for approval.
SupplierNotifMethod	Value that identifies how the document should be communicated to the supplier such as e-mail, fax.
TaxAttributeUpdateCode	Code that keeps track of create or update actions on this entity.
TaxDocumentSubtype	Value that identifies the country specific classification of the document used for tax calculation and reporting purposes.
TermsId	Value that uniquely identifies the payment terms.
ThirdPtyRegId	Value that identifies the third party tax registration ID for the transaction.
TypeLookupCode	Value that identifies the document type associated with a change order template.
UseNeedByDate	Value that identifies whether to use the date on requisition lines that the buying company requests the supplier to deliver the goods when trying to group requisitions while creating an order.
UseSalesOrderNumberFlag	Value that identifies whether requisition lines should be grouped by sales order number to create distinct purchase order.
UseShipTo	Value that identifies whether to enable grouping requisitions by the requisition line ship-to location when creating orders.
VendorContactId	Value that uniquely identifies the supplier contact.
VendorId	Value that uniquely identifies the supplier.
VendorOrderNum	Number that indicates the supplier document number.
VendorSiteId	Number that Indicates the supplier document number.
XmlFlag	Value that uniquely identifies the supplier site.