PO_HEADERS_DRAFT_ALL
PO_HEADERS_DRAFT_ALL stores draft changes to PO header that have not been accepted by buyer. A record in this table contains the proposed values for the corresponding record in the transaction table PO_HEADERS_ALL. When the draft changes are accepted, the record is moved to PO_HEADERS_ALL. Changes from buyer are automatically accepted. PO_HEADERS_DRAFT_ALL contains all columns from PO_HEADERS_ALL, as well as the following additional columns: DRAFT_ID: primary key of the table; foreign key to PO_DRAFTS; CHANGE_ACCEPTED_FLAG: acceptance status of the draft record; DELETE_FLAG: flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PO_HEADERS_DRAFT_ALL_PK |
PO_HEADER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
PO_HEADER_ID | NUMBER | 18 | Yes | Document header unique identifier | ||
SCHEDULE_GROUP | VARCHAR2 | 30 | User-defined value used as a criterion for scheduling order creation | |||
SIGNATURE_REQUIRED_FLAG | VARCHAR2 | 1 | Yes | Checkbox to indicate if signatures are required on the document before it can be opened. | ||
MODE_OF_TRANSPORT | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. | |||
SERVICE_LEVEL | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported | |||
BUYER_MANAGED_TRANSPORT_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate 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. The value is Y/N. | ||
FUNDS_STATUS | VARCHAR2 | 25 | status to indicate whether funds have been reserved on the document or not | |||
BILLTO_BU_ID | NUMBER | 18 | Bill-to Business Unit unique identifier. Indicates the business unit which vouches the supplier invoices received for this purchase order. | |||
SOLDTO_LE_ID | NUMBER | 18 | Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on this purchase order. | |||
DEFAULT_PO_TRADE_ORG_ID | NUMBER | 18 | Unique identifier for Purchasing Trade Organization. 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. | |||
ORCHESTRATION_ORDER_FLAG | VARCHAR2 | 1 | Indicates whether this purchase order is an orchestrated purchase order. Valid values are Y/N. A value of 'Y' implies that this is an orchestrated order. A value of 'N' implies that this is not an orchestrated order. | |||
AGING_PERIOD_DAYS | NUMBER | 5 | 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. | |||
AGING_ONSET_POINT | VARCHAR2 | 30 | Indicates the mutually agreed event point at which consigned material begins to age. The possible values are None / Receipt / Shipment. Values from Lookups. Applicable only to BPA. | |||
CONSUMPTION_ADVICE_FREQUENCY | VARCHAR2 | 30 | Indicates 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 / Monthly. Values from Lookups. Applicable only to BPA. | |||
CONSUMPTION_ADVICE_SUMMARY | VARCHAR2 | 30 | Indicates 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 / All Inventory Organizations. Values from Lookups. Applicable only to BPA. | |||
BILLING_CYCLE_CLOSING_DATE | DATE | Field to capture when the current billing period for an agreement ends. This is applicable only for a BPA with consignment terms enabled. | ||||
MANUAL_BCCD_OVERRIDE_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate if Billing Cycle Closing Date has been edited manually. | ||
DEFAULT_CONSIGNMENT_LINE_FLAG | VARCHAR2 | 1 | Yes | Indicates the default value for the Consignment line attribute on the agreement line. Values: Y/N. Applicable only to BPA. | ||
PAY_ON_USE_FLAG | VARCHAR2 | 1 | Yes | This checkbox will indicate whether self-billing is enabled for consumption of consigned material. Values: Y/N. Applicable only to BPA. | ||
CAT_ADMIN_AUTH_ENABLED_FLAG | VARCHAR2 | 1 | Cat Admin Auth Enabled Flag | |||
ACCEPTANCE_WITHIN_DAYS | NUMBER | Used for Acknowledge within days | ||||
GENERATE_ORDERS_AUTOMATIC | VARCHAR2 | 1 | Automatically Generate Orders flag | |||
EXTERNAL_CHANGE_FLAG | VARCHAR2 | 1 | indicates if the change is external(supplier facing or not | |||
SUBMIT_APPROVAL_AUTOMATIC | VARCHAR2 | 1 | Automatically Submit for Approval flag | |||
GROUP_REQUISITIONS | VARCHAR2 | 1 | Group Requisitions flag | |||
GROUP_REQUISITION_LINES | VARCHAR2 | 1 | Group Requisition Lines flag | |||
USE_NEED_BY_DATE | VARCHAR2 | 1 | Use need by date falg | |||
USE_SHIP_TO | VARCHAR2 | 1 | Use ship to organization and location flag | |||
CHECKLIST_ID | NUMBER | 18 | Value that uniquely identifies the checklist on a Purchasing Document. | |||
DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | The country for taxation for tax calculation purposes | |||
CANCEL_FLAG | VARCHAR2 | 1 | Cancel Flag | |||
TAX_DOCUMENT_SUBTYPE | VARCHAR2 | 240 | Country Specific classification of the document used for tax calculation and reporting putposes | |||
PRC_BU_ID | NUMBER | 18 | Yes | PRC_BU_ID | ||
REQ_BU_ID | NUMBER | 18 | REQ_BU_ID | |||
ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates if the row is new or changed. | |||
CHANGE_ACCEPTED_FLAG | VARCHAR2 | 1 | Acceptance status of the draft record. | |||
AGENT_ID | NUMBER | 18 | Yes | Buyer unique identifier. (References PO_AGENTS.agent_id) | ||
CARRIER_ID | NUMBER | 18 | Carrier ID (Party ID) | |||
TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Type of the document. (Combined with segment1and bu to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype) | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
SEGMENT1 | VARCHAR2 | 30 | Yes | Key Flexfield: segment of the key flexfield. | ||
SUMMARY_FLAG | VARCHAR2 | 1 | Yes | Key Flexfield summary flag | ||
ENABLED_FLAG | VARCHAR2 | 1 | Yes | Key Flexfield enabled flag | ||
SEGMENT2 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
SEGMENT3 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
SEGMENT4 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
SEGMENT5 | VARCHAR2 | 20 | Key Flexfield: segment of the key flexfield. | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
VENDOR_ID | NUMBER | 18 | Supplier unique identifier (References PO_VENDORS.vendor_id) | |||
VENDOR_SITE_ID | NUMBER | 18 | Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id) | |||
VENDOR_CONTACT_ID | NUMBER | 18 | Supplier contact unique identifier (References PO_VENDOR_CONTACTS.vendor_contact_id) | |||
SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to location unique identifier (References HR_LOCATIONS_ALL.location_id) | |||
BILL_TO_LOCATION_ID | NUMBER | 18 | Bill-to location unique identifier (References HR_LOCATIONS_ALL.location_id) | |||
TERMS_ID | NUMBER | 18 | Payment terms unique identifier (References to AP_TERMS_TL.term_id) | |||
FOB_LOOKUP_CODE | VARCHAR2 | 30 | Type of free-on-board terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB') | |||
FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | 30 | Type of freight terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS') | |||
CURRENCY_CODE | VARCHAR2 | 15 | Unique identifier for the currency (References FND_CURRENCIES.currency_code) | |||
RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type (References GL_DAILY_CONVERSION_TYPES.conversion_type) | |||
RATE_DATE | DATE | Currency conversion date | ||||
RATE | NUMBER | Currency conversion rate | ||||
FROM_HEADER_ID | NUMBER | 18 | Unique identifier of thedocument from whcih this document is copied or autocreated (References PO_HEADERS_ALL.po_header_id) | |||
FROM_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Document type of the document used to autocreate another document (References: PO_DOCUMENT_TYPES_ALL_B.document_subtype) | |||
START_DATE | DATE | Effective date of the document | ||||
END_DATE | DATE | Expiration date of the document | ||||
BLANKET_TOTAL_AMOUNT | NUMBER | Amount agreed for the planned or blanket purchase order | ||||
AMOUNT_LIMIT | NUMBER | Blanket, Planned PO or Contract only: Maximum amount that can be released | ||||
MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against a blanket or planned purchase order | ||||
NOTE_TO_AUTHORIZER | VARCHAR2 | 1000 | Not currently used | |||
NOTE_TO_VENDOR | VARCHAR2 | 1000 | Note to the supplier | |||
NOTE_TO_RECEIVER | VARCHAR2 | 1000 | Note to the receiver of the purchase order | |||
VENDOR_ORDER_NUM | VARCHAR2 | 25 | Indicates supplier document number, it gets copied from PO_HEADERS_INTERFACE.vendor_doc_num | |||
CONFIRMING_ORDER_FLAG | VARCHAR2 | 1 | Indicates whether the purchase order is a confirming order or not | |||
COMMENTS | VARCHAR2 | 240 | Descriptive comments for the document | |||
ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether acceptance from the supplier is required or not | |||
ACCEPTANCE_DUE_DATE | DATE | Date by which the supplier should accept the purchase order | ||||
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | 30 | Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application | |||
FIRM_DATE | DATE | Date from which the purchase order is firmed | ||||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Document Headers (PO_HEADERS) | |||
GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | |||
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 | |||
SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
INTERFACE_SOURCE_CODE | VARCHAR2 | 25 | Identifier for upstream integrating module. Reserved for internal use. | |||
REFERENCE_NUM | VARCHAR2 | 120 | Audit trail reference (needed for 832 EDI transaction) | |||
PCARD_ID | NUMBER | 18 | Unique identifer for the procurement card used for the order (References AP_CARDS_ALL.card_id) | |||
PRICE_UPDATE_TOLERANCE | NUMBER | Maximum percentage increase allowed in price/sales catalog update (832 EDI transaction) sent by supplier | ||||
PAY_ON_CODE | VARCHAR2 | 25 | Indicator of whether the purchase order will be paid upon receipt (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PAY ON CODE') | |||
XML_FLAG | VARCHAR2 | 3 | Indicator whether the delivery option is through XML. Y if so. | |||
CONSIGNED_CONSUMPTION_FLAG | VARCHAR2 | 1 | Flag indicates that the purchase order is a consumption advice | |||
CBC_ACCOUNTING_DATE | DATE | Column used to store the accounting action date for dual budgetary control functionality. | ||||
CONSUME_REQ_DEMAND_FLAG | VARCHAR2 | 1 | Used by Oracle Sourcing- Tells whether user wanted to consume the req demand when creating a blanket | |||
CHANGE_REQUESTED_BY | VARCHAR2 | 20 | Change Requested By will track changes to Purchase Document from Supplier/ Requester | |||
SHIPPING_CONTROL | VARCHAR2 | 30 | Indicator of who is responsible for arranging transportation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='SHIPPING CONTROL') | |||
CONTERMS_EXIST_FLAG | VARCHAR2 | 1 | Indicates if contract terms template is attached to the purchasing document or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |||
CONTERMS_ARTICLES_UPD_DATE | DATE | Timestamp for the last update to Contract Clauses. Applicable to Purchasing document of type Standard, Contract, Blanket | ||||
CONTERMS_DELIV_UPD_DATE | DATE | Timestamp for the last update to Contract Deliverables. Applicable to Purchasing document of type Standard, Contract, Blanket | ||||
ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | 1 | Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not | |||
PENDING_SIGNATURE_FLAG | VARCHAR2 | 1 | Indicates if the purchasing document is waiting for the signatures or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |||
CHANGE_SUMMARY | VARCHAR2 | 2000 | 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. | |||
DOCUMENT_CREATION_METHOD | VARCHAR2 | 30 | Method in which the document got created - Autocreate, enter PO , etc... | |||
SUBMIT_DATE | DATE | Date when document was first submitted for approval | ||||
SUPPLIER_NOTIF_METHOD | VARCHAR2 | 25 | Supplier Notification Method | |||
FAX | VARCHAR2 | 60 | Supplier Fax Number | |||
EMAIL_ADDRESS | VARCHAR2 | 2000 | Email address of the supplier for communication | |||
USE_ORDER_DATE_IN_PRICING_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the order date should be used to derive price on the orders referencing the agreement | |||
RETRO_PRICE_COMM_UPDATES_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not orders that were repriced because of a price change on the referenced agreement should be communicated to the supplier. | |||
RETRO_PRICE_APPLY_UPDATES_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not price updates on the agreement should be propagated to orders referencing the agreement. | |||
UPDATE_SOURCING_RULES_FLAG | VARCHAR2 | 1 | Update sourcing rules flag | |||
AUTO_SOURCING_FLAG | VARCHAR2 | 1 | Enable automatic sourcing flag | |||
CREATED_LANGUAGE | VARCHAR2 | 4 | Language code in which the GBPA was created. | |||
CPA_REFERENCE | NUMBER | 18 | This is to support the iP catalog upgrade for items that had a CPA reference prior to Release 12. This column is just for information purpose. | |||
STYLE_ID | NUMBER | 18 | Yes | Determines the Purchasing Style of the document. | ||
TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | 15 | Keeps track of create/update actions on this entity | |||
REASON_FOR_CHANGE | VARCHAR2 | 240 | Obsolete - This column documents the reason for changing this header | |||
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. | ||
MERGE_REQUEST_ID | NUMBER | 18 | Merge Request Id Unique Identifier(References POZ_SUPPLIER_MERGE_REQUESTS.merge_request_id) | |||
USE_SALES_ORDER_NUMBER_FLAG | VARCHAR2 | 1 | Indicates whether requisition lines should be grouped by Sales Order Number to create distinct purchase order. | |||
FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction. | |||
THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction. | |||
DISABLE_AUTOSOURCING_FLAG | VARCHAR2 | 1 | Disable Automatic Sourcing Flag | |||
PUNCHOUT_SOURCING_ONLY_FLAG | VARCHAR2 | 1 | Automatic Sourcing of Punchout Requests Only | |||
BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate if Budgetary conrol was enabled at the time of Purchase Order creation. Not applicable to Agreements. | ||
RETRO_PRICE_OPEN_ORDER_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement. | |||
RETRO_PRICE_INIT_APPROVAL_FLAG | VARCHAR2 | 1 | This flag on the agreement indicates whether or not the retroactive price update background process should be initiated upon agreement approval. | |||
ALLOW_MULTIPLE_SITES_FLAG | VARCHAR2 | 1 | Yes | A flag to indicate that an agreement can be used across all supplier sites for a given supplier. | ||
IS_DOC_IN_EDIT | VARCHAR2 | 1 | Column used only for technical purpose with in the code to check if we can mark any entity as dirty provided that entity row is modified. | |||
USE_SHIP_TO_FOR_GROUP_REQS | VARCHAR2 | 1 | Yes | Checkbox to indicate whether to use ship-to organization and location when grouping requisitions | ||
MASTER_CONTRACT_ID | NUMBER | 18 | 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 specific, contractual agreements. | |||
CC_EMAIL_ADDRESS | VARCHAR2 | 2000 | Email address to which a copy of the email is sent | |||
BCC_EMAIL_ADDRESS | VARCHAR2 | 2000 | Email address to which a copy of the email is sent without letting other recipients know | |||
OVERRIDING_APPROVER_ID | NUMBER | 18 | Overriding approver on purchase orders and change orders for approval routing. | |||
SKIP_ELECTRONIC_COMM_FLAG | VARCHAR2 | 1 | Indicates whether electronic communication should be skipped | |||
ALT_CONTACT_EMAIL_ADDRESS | VARCHAR2 | 2000 | Alternate Supplier Contact Email address of the supplier for communication | |||
SOURCING_PRIORITY | NUMBER | Indicates the numerical value to determine the sourcing priority. Applicable only to BPA. | ||||
SH_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Segment used to identify the special handling context for special handling purchase order headers. | |||
SH_ATTRIBUTE1 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE2 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE3 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE4 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE5 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE6 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE7 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE8 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE9 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE10 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE11 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE12 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE13 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE14 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE15 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE16 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE17 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE18 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE19 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE20 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | |||
SH_ATTRIBUTE_NUMBER1 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER2 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER3 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER4 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER5 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER6 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER7 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER8 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER9 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_NUMBER10 | NUMBER | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE1 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE2 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE3 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE4 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE5 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE6 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE7 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE8 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE9 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_DATE10 | DATE | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SH_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. | ||||
SPECIAL_HANDLING_TYPE_CODE | VARCHAR2 | 30 | Special Handling Descriptive Flexfield: segment of the special handling descriptive flexfield. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PO_HEADERS_DRAFT_ALL | poz_suppliers | VENDOR_ID |
PO_HEADERS_DRAFT_ALL | poz_supplier_merge_requests | MERGE_REQUEST_ID |
PO_HEADERS_DRAFT_ALL | poz_supplier_contacts | VENDOR_CONTACT_ID |
po_line_locations_draft_all | po_headers_draft_all | PO_HEADER_ID |
po_ga_org_assign_draft | po_headers_draft_all | PO_HEADER_ID |
po_notification_ctrl_draft | po_headers_draft_all | PO_HEADER_ID |
po_versions | po_headers_draft_all | PO_HEADER_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PO_HEADERS_DRAFT_N1 | Non Unique | Default | VENDOR_ID, VENDOR_SITE_ID |
PO_HEADERS_DRAFT_N10 | Non Unique | Default | STYLE_ID |
PO_HEADERS_DRAFT_N11 | Non Unique | Default | CARRIER_ID |
PO_HEADERS_DRAFT_N12 | Non Unique | Default | CHECKLIST_ID |
PO_HEADERS_DRAFT_N2 | Non Unique | Default | CREATION_DATE |
PO_HEADERS_DRAFT_N3 | Non Unique | Default | AGENT_ID, TYPE_LOOKUP_CODE |
PO_HEADERS_DRAFT_N4 | Non Unique | Default | FROM_HEADER_ID |
PO_HEADERS_DRAFT_N8 | Non Unique | Default | VENDOR_ORDER_NUM |
PO_HEADERS_DRAFT_N9 | Non Unique | Default | LAST_UPDATE_DATE |
PO_HEADERS_DRAFT_U1 | Unique | Default | PO_HEADER_ID |
PO_HEADERS_DRAFT_U2 | Unique | Default | SEGMENT1, TYPE_LOOKUP_CODE, CASE WHEN "TYPE_LOOKUP_CODE" = 'STANDARD' THEN "SOLDTO_LE_ID" ELSE "PRC_BU_ID" END |