PO_LINES_GT
Purchase Order Lines Global Temporary table.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
PO_LINES_GT_PK |
PO_LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PO_LINE_ID | NUMBER | 18 | Yes | Document line unique identifier | |
DISCOUNT | NUMBER | Discount on Po Line | |||
DISCOUNT_TYPE | VARCHAR2 | 20 | Discount Type on Po Line (Percentage/Amount) | ||
DISCOUNT_REASON | VARCHAR2 | 240 | Description of the reason for the discount | ||
LIST_PRICE | NUMBER | The original price per unit of the item or service offered | |||
CONFIGURED_ITEM_FLAG | VARCHAR2 | 1 | (PO Only, CTO Only) Flag to indicate whether document should support model items and options. | ||
AGING_PERIOD_DAYS | NUMBER | 5 | Indicates the maximum number of days the material may be on consignment. Only positive values are allowed. Applicable only to BPA Lines. | ||
CONSIGNMENT_LINE_FLAG | VARCHAR2 | 1 | Indicates whether the item on line will be purchased under consignment arrangement from supplier. Values: Y/N. Applicable to both BPA and PO Lines. | ||
ENTITY_CHANGE_TYPE_CODE | VARCHAR2 | 1 | Indicates entity change type - added or updated | ||
PRC_BU_ID | NUMBER | 18 | Procurement Business Unit Id. This should be NOT NULL | ||
REQ_BU_ID | NUMBER | 18 | Requisitioning Business Unit Unique Identifier | ||
LINE_STATUS | VARCHAR2 | 25 | LIne Status | ||
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. | |
PO_HEADER_ID | NUMBER | 18 | Yes | Document header unique identifier. | |
LINE_TYPE_ID | NUMBER | 18 | Yes | Line type unique identifier | |
LINE_NUM | NUMBER | Yes | Line number | ||
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. | |
ITEM_ID | NUMBER | Item unique identifier. | |||
ITEM_REVISION | VARCHAR2 | 18 | Item revision. | ||
CATEGORY_ID | NUMBER | 18 | Item category unique identifier. | ||
ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description. ( | ||
PARENT_ITEM_ID | NUMBER | 18 | (BPA Only, CTO Only) The buying organization's identification number or code corresponding to the parent option class or model for the option/item or model. | ||
SUPPLIER_PARENT_ITEM | VARCHAR2 | 300 | (BPA Only, CTO Only) The supplier's identification number or code for the option class or model associated with the option/item or model. | ||
TOP_MODEL_ID | NUMBER | 18 | (BPA Only, CTO Only) The buying organization's identification number or code for the top model associated with the option/option class/submodel. | ||
SUPPLIER_TOP_MODEL | VARCHAR2 | 300 | (BPA Only, CTO Only) The supplier's identification number or code for the top model associated with the option/option class/submodel. | ||
BASE_MODEL_ID | NUMBER | 18 | (Purchase Order Only) The buying organization's identification number or code for the model on which the unique configuration is built. | ||
UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity ordered. (References INV_UNITS_OF_MEASURE.uom_code.) | ||
QUANTITY_COMMITTED | NUMBER | Blankets only: Quantity agreed for an agreement line | |||
COMMITTED_AMOUNT | NUMBER | Blankets only: Amount agreed for an agreement line | |||
ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | 1 | Blankets or planned POs only: Indicates whether you can change the price on release shipments | ||
NOT_TO_EXCEED_PRICE | NUMBER | Blankets or planned POs only: Price limit that you cannot exceed on a release shipment | |||
LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line | |||
BASE_MODEL_PRICE | NUMBER | (Purchase Order Only) Unit price of the base model only. | |||
UNIT_PRICE | NUMBER | Unit price for the line | |||
QUANTITY | NUMBER | Quantity ordered on shipment | |||
TAX_EXCLUSIVE_PRICE | NUMBER | The purchase order line price that is exclusive of all the taxes. | |||
UN_NUMBER_ID | NUMBER | 18 | UN number unique identifier. ( | ||
HAZARD_CLASS_ID | NUMBER | 18 | Hazard class unique identifier. | ||
NOTE_TO_VENDOR | VARCHAR2 | 1000 | Short note to supplier | ||
FROM_HEADER_ID | NUMBER | 18 | Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line. (References PO_HEADERS_ALL.po_header_id.) | ||
FROM_LINE_ID | NUMBER | 18 | Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line. (References PO_LINES_ALL.po_line_id.) | ||
MAX_ORDER_QUANTITY | NUMBER | Maximum Ordered Quantity | |||
QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | |||
OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | 25 | Indicates whether or not you reject receipts exceeding the tolerance | ||
MARKET_PRICE | NUMBER | Market price for the item on the line. (Defaulted from EGP_SYSTEM_ITEMS_B.market_price.) | |||
UNORDERED_FLAG | VARCHAR2 | 1 | Indicates whether or not the line was created from unordered receipts | ||
CLOSED_FLAG | VARCHAR2 | 1 | Indicates whether the line is closed or not | ||
USER_HOLD_FLAG | VARCHAR2 | 1 | Indicates whether the line is on hold or not (Unused since release version 5.0) | ||
CANCEL_FLAG | VARCHAR2 | 1 | Indicates whether the line is cancelled or not | ||
CANCELLED_BY | NUMBER | 18 | Unique identifier of the employee who cancelled the line. (References HR_EMPLOYEES.employee_id.) | ||
CANCEL_DATE | DATE | Cancellation date | |||
CANCEL_REASON | VARCHAR2 | 240 | Cancellation reason provided by employee | ||
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | 30 | Firming status of the line (Unused since release version 7.0) | ||
FIRM_DATE | DATE | Date the line becomes firmed (Unused since release version 7.0) | |||
VENDOR_PRODUCT_NUM | VARCHAR2 | 300 | Supplier item number | ||
CONTRACT_NUM | VARCHAR2 | 25 | Contract number referenced on the line. (Obsoleted in PO FPJ 11.5.10 - use CONTRACT_ID instead.) | ||
TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether the document line is taxable or not | ||
TAX_NAME | VARCHAR2 | 15 | Tax code applying to the line. (References AP_TAX_CODES_ALL.name.) | ||
TYPE_1099 | VARCHAR2 | 10 | 1099 type for the purchase order line | ||
CAPITAL_EXPENSE_FLAG | VARCHAR2 | 1 | Indicates whether the line is for a capital expense or not | ||
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | 1 | Indicates whether the buyer negotiated the price or not | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
REFERENCE_NUM | VARCHAR2 | 25 | Reference number (Unused since release version 7.0) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
MIN_RELEASE_AMOUNT | NUMBER | Blankets or planned POs only: Minimum amount that can be released against a planned or blanket agreement line. | |||
PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Price type of the line. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PRICE TYPE'.) | ||
CLOSED_CODE | VARCHAR2 | 25 | Describes closure status of the line | ||
PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | 25 | Blankets only: Pricing scheme for the price breaks of this line (cumulative or non-cumulative). | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | United States standard general ledger transaction code. (References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE.) | ||
GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column | ||
CLOSED_DATE | DATE | Date the line is closed | |||
CLOSED_REASON | VARCHAR2 | 240 | Describes why the line is closed | ||
CLOSED_BY | NUMBER | 18 | Unique identifier of the employee who closed the line. (References HR_EMPLOYEES.employee_id.) | ||
SOLDTO_BU_ID | NUMBER | 18 | Sold to Business Unit Unique Identifier | ||
QC_GRADE | VARCHAR2 | 25 | OPM: Stores the quality control grade wanted on the purchase order line | ||
BASE_UOM | VARCHAR2 | 25 | OPM: Stores the base unit of measure (UOM) for the item ordered | ||
BASE_QTY | NUMBER | OPM: Ordered quantity converted from transaction UOM to base UOM | |||
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. | ||
LINE_REFERENCE_NUM | VARCHAR2 | 25 | Audit Trail Reference (needed for 832 EDI transaction) | ||
EXPIRATION_DATE | DATE | Blanket, quotation, or RFQ only: Date after which the item on this catalog line can no longer be ordered | |||
TAX_CODE_ID | NUMBER | 18 | Unique identifier for the tax code. (References AP_TAX_CODES.tax_id.) | ||
OKE_CONTRACT_HEADER_ID | NUMBER | 18 | Contract identifier from Oracle Contracts. (References OKC_K_HEADERS_B.id.) | ||
OKE_CONTRACT_VERSION_ID | NUMBER | 18 | Version identifier for contract. | ||
SECONDARY_QUANTITY | NUMBER | OPM: Secondary Quantity ordered on the line | |||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | OPM: Secondary unit of measure for the quantity ordered | ||
PREFERRED_GRADE | VARCHAR2 | 150 | Preferred quality grade for the item ordered | ||
AUCTION_HEADER_ID | NUMBER | 18 | Reference to the negotiation id in sourcing. (References PON_AUCTION_HEADERS_ALL.auction_header_id.) | ||
AUCTION_DISPLAY_NUMBER | VARCHAR2 | 240 | Reference to the negotiation number in sourcing | ||
AUCTION_LINE_NUMBER | NUMBER | Reference to the negotiation line number in Sourcing | |||
BID_NUMBER | NUMBER | Reference to the bid number in sourcing | |||
BID_LINE_NUMBER | NUMBER | Reference to the Bid line in sourcing | |||
RETROACTIVE_DATE | DATE | Column used to store the timestamp of a retroactive price change | |||
AMOUNT | NUMBER | Budget Amout for temp labor standard PO lines | |||
CONTRACT_ID | NUMBER | 18 | Standard POs only: Contract PA reference of a line. (References PO_HEADERS_ALL.po_header_id.) | ||
MATCHING_BASIS | VARCHAR2 | 30 | Matching basis of the line type | ||
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Value basis of the line | ||
PURCHASE_BASIS | VARCHAR2 | 30 | Purchase basis of the line type | ||
START_DATE | DATE | Assignment start Date for the contingent worker | |||
WORK_ORDER_PRODUCT | VARCHAR2 | 300 | Indicates the finished good product of the contract manufacturing work order. | ||
MAX_RETAINAGE_AMOUNT | NUMBER | The maximum amount that can be withheld as Retainage against a contract line | |||
SHIPPING_UOM_CODE | VARCHAR2 | 3 | Unit of measure that the supplier is requested to ship in. (References INV_UNITS_OF_MEASURE.uom_code.) | ||
SHIPPING_UOM_QUANTITY | NUMBER | Quantity in shipping unit of measure | |||
TXN_AMOUNT | NUMBER | Budget Amout for temp labor standard PO lines. (Transaction all table) | |||
TXN_QUANTITY | NUMBER | Quantity ordered on shipment (Transaction table) | |||
TXN_LINE_STATUS | VARCHAR2 | 25 | LIne Status (Transaction all status) | ||
TXN_PURCHASE_BASIS | VARCHAR2 | 30 | Purchase basis of the line type (Transaction all table) | ||
TXN_ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | 1 | Blankets or planned POs only: Indicates whether you can change the price on release shipments (Transaction all table) | ||
CO_AMOUNT_CANCELLED | NUMBER | CO_AMOUNT_CANCELLED | |||
CO_QUANTITY_CANCELLED | NUMBER | CO_QUANTITY_CANCELLED | |||
TXN_QUANTITY_COMMITTED | NUMBER | Blankets only: Quantity agreed for an agreement line. (Transaction all table) | |||
MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | 1 | Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise. | ||
TXN_AMOUNT_RELEASED | NUMBER | The total value of goods and services ordered related to a purchase agreement. For lines where the line item is a model item, this value represents the amount of configurations purchased with this item as the base model.(Transaction all table) | |||
TXN_CONTRACT_ID | NUMBER | 18 | Standard POs only: Contract PA reference of a line. (References PO_HEADERS_ALL.po_header_id.) (Transaction all table) | ||
TXN_FROM_LINE_ID | NUMBER | 18 | Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line. (References PO_LINES_ALL.po_line_id.) (Transaction all table) | ||
TXN_PO_LINE_ID | NUMBER | 18 | Document line unique identifier (transaction table) | ||
TXN_PO_HEADER_ID | NUMBER | 18 | Document header unique identifier. (transaction table ) | ||
TXN_CONSIGNMENT_LINE_FLAG | VARCHAR2 | 1 | Indicates whether the item on line will be purchased under consignment arrangement from supplier. Values: Y/N. Applicable to both BPA and PO Lines. (Transaction table) | ||
TXN_LINE_NUM | NUMBER | Line num (Transaction Table) | |||
TXN_ITEM_ID | NUMBER | Item unique identifier. (Transaction Table) | |||
TXN_ITEM_REVISION | VARCHAR2 | 18 | Item revision. (Trasaction Table) | ||
TXN_CATEGORY_ID | NUMBER | 18 | Item category unique identifier. (Transaction all Table) | ||
TXN_PARENT_ITEM_ID | NUMBER | 18 | (BPA Only, CTO Only) The buying organization's identification number or code corresponding to the parent option class or model for the option/item or model. (Transaction all table) | ||
TXN_SUPPLIER_PARENT_ITEM | VARCHAR2 | 300 | (BPA Only, CTO Only) The supplier's identification number or code for the option class or model associated with the option/item or model. (Transaction all table) | ||
TXN_TOP_MODEL_ID | NUMBER | 18 | (BPA Only, CTO Only) The buying organization's identification number or code for the top model associated with the option/option class/submodel. (Transaction all Table) | ||
TXN_SUPPLIER_TOP_MODEL | VARCHAR2 | 300 | (BPA Only, CTO Only) The supplier's identification number or code for the top model associated with the option/option class/submodel.(Transaction all tables) | ||
TXN_QUANTITY_COMMITED | NUMBER | Blankets only: Quantity agreed for an agreement line (Transaction all table) | |||
TXN_COMMITTED_AMOUNT | NUMBER | Blankets only: Amount agreed for an agreement line (Transaction all table) | |||
TXN_UNIT_PRICE | NUMBER | Unit price for the line (Transaction all table) | |||
TXN_NOT_TO_EXCEED_PRICE | NUMBER | Blankets or planned POs only: Price limit that you cannot exceed on a release shipment (Transaction all table) | |||
TXN_VENDOR_PRODUCT_NUM | VARCHAR2 | 300 | Supplier item number (Transaction all tables) | ||
TXN_EXPIRATION_DATE | DATE | Blanket, quotation, or RFQ only: Date after which the item on this catalog line can no longer be ordered. (Transaction all table) | |||
TXN_MIN_RELEASE_AMOUNT | NUMBER | Blankets or planned POs only: Minimum amount that can be released against a planned or blanket agreement line. (Transaction all table) | |||
CREDIT_FLAG | VARCHAR2 | 1 | Indicates whether the line is a credit line. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
PO_LINES_GT_N1 | Non Unique | PO_HEADER_ID |
PO_LINES_GT_N2 | Non Unique | FROM_HEADER_ID |
PO_LINES_GT_N3 | Non Unique | CONTRACT_ID |
PO_LINES_GT_U1 | Unique | PO_LINE_ID |