PO_LINE_TYPES_B
PO_LINE_TYPES_B contains information about the line types you use in your business. You need each row for each line type you use. . Oracle Purchasing uses this information to provide default information when you create a document line using a line type. Oracle Purchasing also uses this information to control how you enter information on your document lines according to the line type you choose. ORDER_TYPE_LOOKUP_CODE is 'AMOUNT' for an amount-based line type or 'QUANTITY' for a quantity-based line type. . .
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
PO_LINE_TYPES_B_PK |
LINE_TYPE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
LINE_TYPE_ID | NUMBER | 18 | Yes | Line type unique identifier | ||
UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity ordered. (Referencces INV_UNITS_OF_MEASURE.uom_code) | |||
OUTSIDE_OPERATION_FLAG | VARCHAR2 | 1 | OUTSIDE_OPERATION_FLAG | |||
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. | ||
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Type of order line | ||
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. | ||
CATEGORY_ID | NUMBER | 18 | Item class | |||
UNIT_OF_MEASURE | VARCHAR2 | 25 | Default unit of measure | |||
UNIT_PRICE | NUMBER | Default unit price | ||||
RECEIVING_FLAG | VARCHAR2 | 1 | Default receipt required flag | |||
INACTIVE_DATE | DATE | Inactive date for record | ||||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
RECEIVE_CLOSE_TOLERANCE | NUMBER | Receive close tolerance | ||||
PURCHASE_BASIS | VARCHAR2 | 30 | Yes | Purchase basis lookup type | ||
MATCHING_BASIS | VARCHAR2 | 30 | Yes | Matching basis lookup type | ||
INSPECTION_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether shipment must be inspected before the invoice is paid | |||
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. | ||
MATCH_OPTION | VARCHAR2 | 25 | Possible values are P,R, and Null; P for Purchase Order and R for Receipt | |||
LINE_TYPE_CODE | VARCHAR2 | 30 | Yes | Stores a unique code to identify the line type. These code values are used to uniquely identify the rows as an alternate key for setup migrator as line_type_id is a surrogate key and can not be used for this purpose. | ||
SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
PRODUCT_TYPE | VARCHAR2 | 30 | This value on the line type is used to default Product Type on PO Schedules. | |||
ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | ||
CREDIT_FLAG | VARCHAR2 | 1 | Indicates whether the line type can be used to create credit lines. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PO_LINE_TYPES_B | egp_categories_b | CATEGORY_ID |
po_lines_archive_all | po_line_types_b | LINE_TYPE_ID |
por_req_bu_options_all | po_line_types_b | LINE_TYPE_ID |
po_lines_all | po_line_types_b | LINE_TYPE_ID |
po_lines_draft_all | po_line_types_b | LINE_TYPE_ID |
pon_auction_item_prices_all | po_line_types_b | LINE_TYPE_ID |
po_system_parameters_all | po_line_types_b | LINE_TYPE_ID |
po_line_types_tl | po_line_types_b | LINE_TYPE_ID |
por_smart_forms_all_b | po_line_types_b | LINE_TYPE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PO_LINE_TYPES_B_U1 | Unique | Default | LINE_TYPE_ID, ORA_SEED_SET1 |
PO_LINE_TYPES_B_U11 | Unique | Default | LINE_TYPE_ID, ORA_SEED_SET2 |
PO_LINE_TYPES_B_U2 | Unique | Default | LINE_TYPE_CODE, ORA_SEED_SET1 |
PO_LINE_TYPES_B_U21 | Unique | Default | LINE_TYPE_CODE, ORA_SEED_SET2 |