Purchasing Document Header Details

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

Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentHeaderExtractPVO

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 supplier must accept the purchase order.
AcceptanceRequiredFlag	Indicates whether acceptance from the supplier is required.
AcceptanceWithinDays	Value that stores acknowledge within days.
AgentId	Value that uniquely identifies the buyer.
AgingOnsetPoint	Indicates the mutually agreed event point at which, consigned material begins to age. The possible values are None, Receipt, and Shipment. Applicable only to BPA.
AgingPeriodDays	Indicates the maximum number of days the material may be on consignment. It defaults a value for the same term on the document line. Only positive values are allowed. Applicable only to BPA.
AllowItemDescUpdateFlag	Value that indicates whether item descriptions can be updated on document lines.
AllowManulPriceUpdateOrder	Indicates if the price can be manually updated on fulfilled purchase orders.
AllowMultipleSitesFlag	Indicates whether an agreement can be used across all supplier sites for a given supplier.
AllowRetroPricing	Indicates whether retroactive pricing may be used.
AmountLimit	Value that identifies the maximum amount that can be released. Applicable only to Blanket, Contract, and Planned PO.
AmountReleased	Value that identifies the amount released against this agreement. It's the sum of all the approved standard PO amounts.
ApprovedDate	Date when the purchase order was last approved.
ApprovedFlag	Indicates whether the purchase order is approved or not. If value is Y, the purchase order is approved.
AwardApprovalEnabledFlag	Indicates whether to enable approval of award decision before it's completed. Possible values are Y or N.
BccEmailAddress	Value that uniquely identifies the email address to which a copy of the email is sent without letting other recipients know.
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 to for the planned or blanket purchase order.
BudgetControlEnabledFlag	Indicates whether budgetary control was enabled at the time of purchase order creation. Not applicable to agreements.
BuyerManagedTransportFlag	Indicates whether 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.
BypassApprovalFlag	Indicates whether the approval process needs to be bypassed on submission.
CarrierId	Value that uniquely identifies the company that transports the item.
CatAdminAuthEnabledFlag	Indicates that the BPA is enabled for catalog authoring.
CatAdminAuthoringAcceptance	Acceptance level of Catalog Administrator for agreement change.
CcEmailAddress	Value that uniquely identifies the email address to which a copy of the email is sent.
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.
ClosedDate	Date the document was closed.
Comments	Descriptive comments for the document.
ConfirmingOrderFlag	Indicates whether the purchase order is a confirming order.
ConsumptionAdviceFrequency	Value that identifies the default value of the frequency at which the Create Consumption Advice program will be run for all consumption transactions for consigned inventory purchased under this agreement. It defaults a value for the same term on the document line. The possible values are Daily, Weekly, and Monthly. Applicable only to BPA.
ConsumptionAdviceSummary	Value that identifies the granularity at which consumption advices will be generated. The possible values are Inventory Organization, Item and Transaction Date, Inventory Organization and Item, Inventory Organization, and All Inventory Organizations. Applicable only to BPA.
ContermsExistFlag	Value that identifies if a contract terms template is attached to the purchasing document. Applicable to Purchasing document of type Standard, Contract, and Blanket.
CpaReference	CPA reference to support the iP catalog upgrade for items that had a CPA reference prior to Release 12. This column is just for information purpose.
CreatedBy	User who created the purchasing document header details.
CreatedLanguage	Language code in which the GBPA was created.
CreationDate	Date and time when the purchasing document header details was created.
CurrencyCode	Code that identifies the purchase order currency.
CurrencyCode1	Code that identifies the purchase order currency.
DefaultBuyerId	Value that uniquely identifies the default buyer.
DefaultConsignmentLineFlag	Indicates the default value for the Consignment line attribute on the agreement line. Values: Y or N. Applicable only to BPA.
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.
DefaultPromiseDate	Date that indicates the default promise date from need-by date.
DefaultRateType	Default currency rate type for the purchasing document header details.
DefaultTaxationCountry	Default country for taxation for tax calculation purposes.
DoctypeId	Unique identifier for the document type.
DocumentCreationMethod	Method in which the document got created such as Autocreate and enter PO.
DocumentStatus	Value that identifies the header status.
EmailAddress	Value that identifies the email address of the supplier for communication.
EmailAttachmentFilename	Value that identifies the file name attached to the communication email sent to the supplier.
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 Yes or No.
EndDate	Value that identifies the expiration date of the document.
EnforceMinBidPrice	Check box that indicates whether to enforce supplier's previous round price as start price. Used by Sourcing.
EnforceVendorHoldFlag	Indicates whether you enforce supplier holds during purchase order approval.
Fax	Value that identifies the supplier fax number.
FirmDate	Date from which the purchase order is firmed.
FirstPtyRegId	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
FrozenFlag	Indicates whether the document is frozen.
FundsStatus	Status to indicate whether funds have been reserved on the document or not.
GenOrderForNegReqsFlag	Check box that indicates whether negotiated requisition lines having valid supplier information should be automatically processed to purchase orders even without any purchase agreement reference.
GenerateOrdersAutomatic	Indicates whether order generation should trigger automatically.
GroupRequisitionLines	Indicates whether requisition lines should be grouped together.
GroupRequisitions	Indicates whether requisitions should be grouped together.
InterfaceSourceCode	Value that identifies the upstream integrating module. Reserved for internal use.
InventoryOrganizationId	Value that uniquely identifies the default inventory organization for the procurement business unit.
InvoiceCloseTolerance	Default invoice close tolerance percent for business unit.
LanguageCode	Value that identifies the default user language for the procurement business unit.
LastBilledDate	Date when the consumption transaction on the agreement was last billed.
LastReleaseDate	Date when the purchase order was last implemented against the agreement.
LastUpdateDate	Date and time when the purchasing document was last updated
LastUpdatedBy	User who last updated the document header.
LineTypeId	Value that uniquely identifies the line type on your documents.
ManualReceiptNumType	Receipt number type for manual generation. Possible values are Alphanumeric or Numeric.
MasterContractId	Value that identifies the master contract identifier. The master contract refers to the general contract that primarily serves to set the terms and conditions between parties at a high level that govern subsequent, more specifically, contractual agreements.
MatchOption	Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt.
MaxAttachmentSize	Maximum allowed size of ZIP attachment file for the purchasing document header details.
MinReleaseAmount	Value that identifies the minimum amount that can be released against a blanket or planned purchase order.
ModeOfTransport	Mode of transport that the shipper uses to transport the item such as land, sea, and air.
ModeOfTransport1	Mode of transport that the shipper uses to transport the item such as land, sea, and air.
NegApprovalEnabledFlag	Indicates whether to enable approval of a negotiation before the purchasing document is published.
NoteToAuthorizer	Value that uniquely identifies a note to approver.
NoteToReceiver	Value that uniquely identifies a note to receiver.
NoteToVendor	Value that uniquely identifies a note to supplier.
ObjectVersionNumber	Number of times the purchasing document has been updated.
OrchestrationOrderFlag	Indicates 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	Indicates whether self-billing is enabled for consumption of consigned material. Values: Y or N. Applicable only to BPA.
PcardId	Value that uniquely identifies the procurement card used for the order.
PendingSignatureFlag	Check box 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.
PriceBreakLookupCode	Code that indicates the default price break type for catalog quotations and blanket agreements.
PriceChangeAmount	Price difference in amount you allow between requisition and purchase order price.
PriceUpdateTolerance	Value that identifies the maximum percentage increase allowed in a price or sales catalog update, 832 EDI transaction, sent by supplier.
ProcurementOptionsPrcBuId	Value that uniquely identifies the procurement business unit.
Rate	Value that uniquely identifies the currency conversion rate.
RateDate	Value that uniquely identifies the currency conversion date.
RateType	Value that uniquely identifies the currency conversion rate type.
ReceiveCloseCode	Value that uniquely identifies the default receipt close point.
ReceiveCloseTolerance	Value that uniquely identifies the default receipt close tolerance percent.
ReceivingFlag	Check box that indicates whether you require receipt for items you order or not.
ReleaseMethod	Release Method for ASL creation. This is applicable only for PA.
ReqBuId	Value that uniquely identifies the requisitioning business unit.
RetroPriceApplyUpdatesFlag	Indicates whether price updates on the agreement should be propagated to orders referencing the agreement.
RetroPriceCommUpdatesFlag	Indicates whether orders that were repriced because of a price change on the referenced agreement should be communicated to the supplier.
RetroPriceInitApprovalFlag	Indicates whether the retroactive price update background process should be initiated upon agreement approval.
RetroPriceOpenOrderFlag	Indicates whether the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement.
RevisedDate	Date the document was last revised.
RevisionNum	Value that uniquely identifies the document revision number.
Segment1	Value that uniquely identifies the order number.
ServiceLevel	Level that indicates the priority of transportation that affects how quickly goods are transported.
ServiceLevel1	Level that indicates the priority of transportation that affects how quickly goods are transported.
ShipToLocationId	Value that uniquely identifies the ship-to location.
ShippingControl	Indicator of who's responsible for arranging transportation.
SignatureRequiredFlag	Indicates if signatures are required on the document before it can be opened.
SkipElectronicCommFlag
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.
SourcingSuppEligibilityFlag	Check box that indicates whether to invite only sourcing eligible suppliers.
StartDate	Value that identifies the effective date of the document.
StyleId	Value that uniquely identifies the purchasing style of the document.
StyleId1	Value that uniquely identifies the purchasing style of the document.
SubmitApprovalAutomatic	Check box that indicates whether the document can be automatically submitted for approval.
SubmitDate	Date when the document was first submitted for approval.
SupplierAuthoringAcceptance	Supplier acceptance level for agreement change.
SupplierNotifMethod	Value that uniquely identifies the supplier communication method.
TaxAttributeUpdateCode	Code that keeps track of create or update actions on this entity.
TaxDocumentSubtype	Country Specific classification of the document used for tax calculation and reporting purposes.
TermsId	Value that uniquely identifies the payment terms.
TermsId1	Value that uniquely identifies the payment terms.
ThirdPtyRegId	Third party tax registration ID for the transaction.
TypeLookupCode	Value that identifies the type of the document. Combined with segment1 and BU to form unique key, References the PO_DOCUMENT_TYPES_ALL_B.document_subtype.
UseNeedByDate	Indicates whether the need-by date is used.
UseSalesOrderNumberFlag	Check box that indicates whether requisition lines should be grouped by sales order number to create distinct purchase order.
UseShipTo	Indicates whether the ship to organization and location is used.
UseShipToForGroupReqs	Check box that indicates whether to use ship-to organization and location when grouping requisitions.
UseShipToForGroupReqs1	Check box that indicates whether to use ship-to organization and location when grouping requisitions.
UserDefinedReceiptNumCode	Code that identifies the receipt numbering type.
UserDefinedReqNumCode	Code that identifies the requisition numbering type.
VendorContactId	Value that uniquely identifies the supplier contact.
VendorId	Value that uniquely identifies the supplier.
VendorOrderNum	Number that indicates the supplier document number.
VendorSiteId	Value that uniquely identifies the supplier site.