DBA Data[Home] [Help] [Dependency Information]

TABLE: RLM.RLM_INTERFACE_LINES_ALL

Object Details
Object Name: RLM_INTERFACE_LINES_ALL
Object Type: TABLE
Owner: RLM
FND Design Data: TableRLM.RLM_INTERFACE_LINES_ALL
Subobject Name:
Status: VALID


This table stores the item and item detail level information associated with
customer planning, shipping, or production sequenced schedules. For
production sequence schedules, the item represents the feature, not the
configuration.
This table stores all details for scheduled items: dated demand,
authorizations, and customer shipment/receipt information. It has a child
relationship to RLM_INTERFACE_HEADERS.
Scope: public
Lifecycle: active
Display Name: Release Management Lines Interface
Product: RLM
Category: BUSINESS_ENTITY RLM_SCHEDULE


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RLM_LINES_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
ColumnHEADER_ID
RLM_INTERFACE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnCUSTOMER_ITEM_ID
ColumnITEM_DETAIL_SUBTYPE
RLM_INTERFACE_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnINVENTORY_ITEM_ID
RLM_INTERFACE_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnCUSTOMER_ITEM_EXT
RLM_INTERFACE_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnCUSTOMER_ITEM_ID
ColumnSHIP_FROM_ORG_ID
ColumnSHIP_TO_ADDRESS_ID
ColumnORDER_HEADER_ID
ColumnPROCESS_STATUS
RLM_INTERFACE_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnCUSTOMER_ITEM_ID
ColumnINVENTORY_ITEM_ID
ColumnSHIP_TO_ORG_ID
ColumnORDER_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes Sequence Generated Unique Identifier
HEADER_ID NUMBER
Yes Sequence Generated Unique Identifier foreign key to the RLM_INTERFACE_HEADERS_ALL.
AGREEMENT_ID NUMBER

Unique identifier for agreement on which customer purchase order is associated. FK to RA_AGREEMENTS
ATO_DATA_TYPE VARCHAR2 (30)
Code to describe what type of data is included for the ATO item (1=Model and Options, 2=Model, 3=Options.) Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_ITEM_METHOD_TYPE
BILL_TO_ADDRESS_1_EXT VARCHAR2 (35)
Bill To address line 1, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_2_EXT VARCHAR2 (35)
Bill To address line 2, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_3_EXT VARCHAR2 (35)
Bill To address line 3, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_4_EXT VARCHAR2 (35)
Bill To address line 4, as sent by the customer on the N3 segment.
BILL_TO_ADDRESS_ID NUMBER

Bill To address identifier. FK to RA_ADDRESSES.
INVOICE_TO_ORG_ID NUMBER

Unique identifier for invoice-to organization which relates to BILL_TO_ADDRESS_ID. FK to HR_ORGANIZATIONS
BILL_TO_CITY_EXT VARCHAR2 (30)
Bill To address city, as sent by the customer on the N4 segment.
BILL_TO_COUNTRY_EXT VARCHAR2 (3)
Bill To country, as sent by the customer on the N4 segment.
BILL_TO_COUNTY_EXT VARCHAR2 (25)
Bill To county, as sent by the customer on the N4 segment.
BILL_TO_NAME_EXT VARCHAR2 (60)
Bill To Name, as sent by the customer in the N1 and/or N2 segment.
BILL_TO_POSTAL_CD_EXT VARCHAR2 (15)
Bill To address postal code,as sent by the customer on the N4 segment.
BILL_TO_PROVINCE_EXT VARCHAR2 (10)
Bill To province, as sent by the customer on the N4 segment.
BILL_TO_SITE_USE_ID NUMBER

Bill To site use identifier. FK to RA_SITE_USES.
BILL_TO_STATE_EXT VARCHAR2 (10)
Bill To state, as sent by the customer on the N4 segment.
CARRIER_ID_CODE_EXT VARCHAR2 (35)
The carrier id, as sent by the customer on the TD5 segment.
CARRIER_QUALIFIER_EXT VARCHAR2 (3)
The carrier qualifier, as sent by the customer on the TD5 segment.
COMMODITY_EXT VARCHAR2 (35)
Customer specified commodity code
COUNTRY_OF_ORIGIN_EXT VARCHAR2 (35)
Customer-specified country of origin
CUST_ASSEMBLY_EXT VARCHAR2 (30)
The customer assembly identification, as sent on the LIN segment of the 866 txn.
CUST_ASSIGNED_ID_EXT VARCHAR2 (20)
Customer assigned identification for differentiation within a transaction set, from LIN01.
CUST_BILL_TO_EXT VARCHAR2 (35)
External Customer Bill To Cross Reference
CUST_CONTRACT_NUM_EXT VARCHAR2 (35)
The customer contract number, as sent on the LIN segment of the 830 txn.
CUSTOMER_DOCK_CODE VARCHAR2 (50)
Customer dock code.
CUST_INTRMD_SHIP_TO_EXT VARCHAR2 (35)
External Intermediate ship to Cross Reference
CUST_ITEM_PRICE_EXT NUMBER

Price included on the customer EDI transaction.
CUST_ITEM_PRICE_UOM_EXT VARCHAR2 (3)
UOM corresponding to the price included on teh customer EDI transaction.
CUSTOMER_ITEM_REVISION VARCHAR2 (3)
Customer part revision included on schedule
CUSTOMER_JOB VARCHAR2 (50)
Customer job number
CUST_MANUFACTURER_EXT VARCHAR2 (35)
The manufacturer, as sent by the customer on the LIN segment of the 866 txn.
CUST_MODEL_NUMBER_EXT VARCHAR2 (35)
Customer Model Number for this sequenced detail
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (35)
Customer Vehicle Identification Number for this sequenced detail, e.g. VIN or Chassis ID.
CUST_ORDER_NUM_EXT VARCHAR2 (35)
The order number as sent by the customer on the LIN segment of the 866 and 830 txn.
CUST_PROCESS_NUM_EXT VARCHAR2 (35)
The process number, as sent by the customer on the LIN segment of the 866 and 862 transaction.
CUST_PRODUCTION_LINE VARCHAR2 (50)
Customer production line
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (35)
Customer Production Sequence Number, or Delivery Number
CUST_SET_NUM_EXT VARCHAR2 (35)
The customer set number, as sent on the LIN segment of the 862 and 866 txns.
CUST_SHIP_FROM_ORG_EXT VARCHAR2 (80)
External Inventory Organization Cross Reference
CUST_SHIP_TO_EXT VARCHAR2 (35)
External Ship to address Cross Reference
CUST_UOM_EXT VARCHAR2 (10)
External Customer unit of measure cross reference
CUSTOMER_ITEM_EXT VARCHAR2 (50)
External Customer part number Cross Reference
CUSTOMER_ITEM_ID NUMBER

Customer item identifier. FK to MTL_CUSTOMER_ITEMS.
REQUEST_DATE DATE

The date and time the customer wants the material delivered or shipped, based on whether the requirements are delivery based or ship based
SCHEDULE_DATE DATE

Planned shipment date and time (request_date - delivery lead time if delivery based)
DATE_TYPE_CODE VARCHAR2 (30)
Type of start/end date, e.g. ship, deliver, Pull signal, Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_DATE_TYPE_CODE
DATE_TYPE_CODE_EXT VARCHAR2 (30)
External value from which DATE_TYPE_CODE was derived in EDI Gateway Code Conversion.
DELIVERY_LEAD_TIME NUMBER

For demand lines, the difference between arrival and shipment dates, based on default shipping method between the ship-from and ship-to locations. This is determined by the Calculate Ship Date routine and passed into Order Import.
END_DATE_TIME DATE

Customer-specified optional end date/time, applicable for flexible bucketed requirements, and cumulative information such as authorizations and shipped/received
EQUIPMENT_CODE_EXT VARCHAR2 (3)
The equipment code, as sent by the customer on the TD3 segment.
EQUIPMENT_NUMBER_EXT VARCHAR2 (35)
The equipment number, as sent by the customer on the TD3 segment.
HANDLING_CODE_EXT VARCHAR2 (3)
Special handling code as sent by the customer in the TD4 segment.
HAZARD_CODE_EXT VARCHAR2 (10)
Hazardous Material Code corresponding to the Hazardous Material Code Qualifier as sent by the customer in the TD4 segment.
HAZARD_CODE_QUAL_EXT VARCHAR2 (3)
Hazardous Material Code Qualifier as sent by the customer in the TD4 segment.
HAZARD_DESCRIPTION_EXT VARCHAR2 (80)
Hazardous Material Description as sent by the customer in the TD4 segment.
IMPORT_LICENSE_DATE_EXT DATE

Customer Import License Date
IMPORT_LICENSE_EXT VARCHAR2 (35)
Customer Import License for shipment destination country
INDUSTRY_ATTRIBUTE1 VARCHAR2 (150)
Record keeping or model year.
INDUSTRY_ATTRIBUTE10 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE11 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE12 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE13 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE14 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE15 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE2 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE3 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE4 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE5 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE6 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE7 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE8 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_ATTRIBUTE9 VARCHAR2 (150)
Industry Descriptive Flexfield
INDUSTRY_CONTEXT VARCHAR2 (30)
Industry Descriptive context Flexfield
INTRMD_SHIP_TO_ID NUMBER

Customer Intermediate Ship-to Destination unique identifier. FK to RA_ADDRESSES
SHIP_TO_ORG_ID NUMBER

Unique identifier for ship-to organization which relates to SHIP_TO_ADDRESS_ID. FK to HR_ORGANIZATIONS
INTRMD_ST_ADDRESS_1_EXT VARCHAR2 (35)
Intermediate Ship To address line 1, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_2_EXT VARCHAR2 (35)
Intermediate Ship To address line 2, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_3_EXT VARCHAR2 (35)
Intermediate Ship To address line 3, as sent by the customer on the N3 segment.
INTRMD_ST_ADDRESS_4_EXT VARCHAR2 (35)
Intermediate Ship To address line 4, as sent by the customer on the N3 segment.
INTRMD_ST_CITY_EXT VARCHAR2 (30)
Intermediate Ship To address city, as sent by the customer on the N4 segment.
INTRMD_ST_COUNTRY_EXT VARCHAR2 (3)
Intermediate Ship To country, as sent by the customer on the N4 segment.
INTRMD_ST_COUNTY_EXT VARCHAR2 (25)
Intermediate Ship To county, as sent by the customer on the N4 segment.
INTRMD_ST_NAME_EXT VARCHAR2 (60)
Intermediate Ship To Name, as sent by the customer in the N1 and/or N2 segment.
INTRMD_ST_POSTAL_CD_EXT VARCHAR2 (15)
Intermediate Ship To address postal code, as sent by the customer on the N4 segment.
INTRMD_ST_PROVINCE_EXT VARCHAR2 (10)
Intermediate Ship To province, as sent by the customer on the N4 segment.
INTRMD_ST_STATE_EXT VARCHAR2 (10)
Intermediate Ship To state, as sent by the customer on the N4 segment.
INTRMD_ST_SITE_USE_ID NUMBER

Intermediate Ship To site use identifier, FK to RA_SITE_USES
INVENTORY_ITEM_ID NUMBER

Inventory item identifier. FK to MTL_SYSTEM_ITEMS.
INVENTORY_ITEM_SEGMENT1 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT10 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT11 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT12 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT13 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT14 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT15 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT16 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT17 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT18 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT19 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT2 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT20 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT3 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT4 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT5 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT6 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT7 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT8 VARCHAR2 (40)
Accounting Flexfield
INVENTORY_ITEM_SEGMENT9 VARCHAR2 (40)
Accounting Flexfield
ITEM_CONTACT_CODE_1 VARCHAR2 (3)
Contact code 1 included in customer EDI transaction
ITEM_CONTACT_CODE_2 VARCHAR2 (3)
Contact code 2 included in customer EDI transaction
ITEM_CONTACT_VALUE_1 VARCHAR2 (80)
Values associated with Contact code 1: concatenation of name, communication code, and communication number
ITEM_CONTACT_VALUE_2 VARCHAR2 (80)
Values associated with Contact code 2 : concatenation of name, communication code, and communication number
ITEM_DESCRIPTION_EXT VARCHAR2 (80)
Item description included on schedule
ITEM_DETAIL_QUANTITY NUMBER

Requested quantity. If Item_Detail_Type = 0,1,2, this is the demand quantity. If Item_Detail_Type = 3, this is the authorization quantity. If Item_Detail_Type = 4, this is the shipped, received or cum quantity. If Item_Detail_Type = 5, this is a miscellaneous quantity, such as ahead/behind, inventory balance, etc.
ITEM_DETAIL_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction
ITEM_DETAIL_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
ITEM_DETAIL_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
ITEM_DETAIL_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
ITEM_DETAIL_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
ITEM_DETAIL_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ITEM_DETAIL_SUBTYPE VARCHAR2 (30)
Schedule item detail row sub-type:For form or forecast demand, Bucket type associated with the demand date/quantity; for authorizations, the type of authorization; for shipment/receipt, cumulative or last.
ITEM_DETAIL_SUBTYPE_EXT VARCHAR2 (30)
External value from which ITEM_DETAIL_SUBTYPE was derived in EDI Gateway Code Conversion.
ITEM_DETAIL_TYPE VARCHAR2 (30)
Schedule item detail row type: 0 = Past Due Firm1 = Firm Demand, 2 = Forecast Demand, 3 = Authorization, 4 = Shipment/Receipt Info, 5 = OtherValidated against FND_LOOKUPS.LOOKUP_TYPE =RLM_DETAIL_TYPE_CODE
ITEM_DETAIL_TYPE_EXT VARCHAR2 (30)
External value from which ITEM_DETAIL_TYPE was derived in EDI Gateway Code Conversion.
ITEM_ENG_CNG_LVL_EXT VARCHAR2 (35)
Customer part engineering change level included on schedule
ITEM_MEASUREMENTS_EXT VARCHAR2 (240)
Item measurement information as sent by the customer on the MEA segments.
ITEM_NOTE_TEXT VARCHAR2 (4000)
Free form item note text included in the schedule
ITEM_REF_CODE_1 VARCHAR2 (3)
Reference code 1 included in customer EDI transaction
ITEM_REF_CODE_2 VARCHAR2 (3)
Reference code 2 included in customer EDI transaction
ITEM_REF_CODE_3 VARCHAR2 (3)
Reference code 3 included in customer EDI transaction
ITEM_REF_VALUE_1 VARCHAR2 (35)
Value associated with Reference code 1
ITEM_REF_VALUE_2 VARCHAR2 (35)
Value associated with Reference code 2
ITEM_REF_VALUE_3 VARCHAR2 (35)
Value associated with Reference code 3
ITEM_RELEASE_STATUS_EXT VARCHAR2 (3)
Customer part release status included on schedule
LADING_QUANTITY_EXT NUMBER

The lading quantity as sent by the customer on the TD1 segment.
LETTER_CREDIT_EXPDT_EXT DATE

Customer letter of credit expiration date
LETTER_CREDIT_EXT VARCHAR2 (35)
Customer letter of credit with international bank guaranteeing payment for international shipments
LINE_REFERENCE VARCHAR2 (50)
Unique line identifier within an order for a transmission identifier.
LINK_TO_LINE_REF VARCHAR2 (50)
Link to Immediate Parent_line_reference within an order for a transmission identifier.
ORDER_HEADER_ID NUMBER

Order header identifier. FK to OE_ORDER_HEADERS.
ORG_ID NUMBER

Operating unit unique id. FK to HR_ORGANIZATION_UNITS.
OTHER_NAME_CODE_1 VARCHAR2 (3)
Other name code 1 included in customer EDI transaction
OTHER_NAME_CODE_2 VARCHAR2 (3)
Other name code 2 included in customer EDI transaction
OTHER_NAME_VALUE_1 VARCHAR2 (80)
Values associated with Other name code 1: concatenation of name, code, and number
OTHER_NAME_VALUE_2 VARCHAR2 (80)
Values associated with Other name code 2 : concatenation of name, code, and number
PACK_SIZE_EXT NUMBER

Size of supplier units in pack, as sent by the customer on the PO4 segment.
PACK_UNITS_PER_PACK_EXT NUMBER

Number of inner pack units per out pack unit, as sent by the customer on the PO4 segment.
PACK_UOM_CODE_EXT VARCHAR2 (3)
Unit of measure of supplier units in the pack, as sent by the customer in the PO4 segment.
PACKAGING_CODE_EXT VARCHAR2 (10)
The packaging code as sent by the customer on TD1 segment.
PARENT_LINK_LINE_REF VARCHAR2 (50)
Line reference of top model for a transmission identifier for an order
PRICE_LIST_ID NUMBER

Unique identifier for price list associated with customer item or agreement on which customer purchase order is associated. FK to RA_PRICE_LISTS
PRIMARY_QUANTITY NUMBER

Quantity in the primary UOM.
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure. FK to MTL_UNITS_OF_MEASURE
PRIME_CONTRCTR_PART_EXT VARCHAR2 (35)
The prime contractor part number, as sent by the customer on the LIN segment of the 862 segment.
PROCESS_STATUS NUMBER

Indicates The current processing status of a record (1=do not process, 2=waiting to be processed, 3=in process, 4=error, 5=processed, 6='processed with error(s)' for headers with lines in-error..)
CUST_PO_RELEASE_NUM VARCHAR2 (35)
Customer Purchase Order Release number included on schedule
CUST_PO_DATE DATE

Customer-specified effectivity date of Purchase Order number included on schedule
CUST_PO_LINE_NUM VARCHAR2 (35)
Customer Purchase Order line number included on schedule
CUST_PO_NUMBER VARCHAR2 (50)
Customer purchase order number
QTY_TYPE_CODE VARCHAR2 (30)
Actual or Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE =RLM_QTY_TYPE_CODE
QTY_TYPE_CODE_EXT VARCHAR2 (30)
External value from which QTY_TYPE_CODE was derived in EDI Gateway Code Conversion.
RETURN_CONTAINER_EXT VARCHAR2 (35)
Returnable container specified by customer for item shipment
SCHEDULE_LINE_ID NUMBER

Schedule line unique identifier. FK to RLM_SCHEDULE_LINES, except for aggregated schedule lines.
ROUTING_DESC_EXT VARCHAR2 (35)
The routing description, as sent by the customer on the TD5 segment.
ROUTING_SEQ_CODE_EXT VARCHAR2 (3)
Code describing the relationship of a carrier to a specific shipment movement, as sent by the customer on the TD5 segment.
SCHEDULE_ITEM_NUM NUMBER

Schedule Item Number, the means to identify how item demand and information is grouped by the customer within the schedule. For sequenced schedules, it is equal to CUSTOMER_PROD_SEQ_NUM. For EDI planning and shipping schedules, it is incremented in the EDI Gateway when each 2000 record is encountered on an inbound SPSI or SSSI transaction. This number is assigned for manually entered schedules. All interface lines with the same Schedule Item number are validated together, and pass or fail validation as a group.
SHIP_DEL_PATTERN_EXT VARCHAR2 (3)
Customer ship delivery pattern code for this item; not integrated with delivery rules for date/qty calculation
SHIP_DEL_TIME_CODE_EXT VARCHAR2 (3)
Customer ship delivery time code for this item; not integrated with delivery rules for date/qty calculation
SHIP_DEL_RULE_NAME VARCHAR2 (30)
Shipment/delivery rule name for this schedule item. Initially populated only if a successful code conversion in the EDI Gateway has occurred. FK to RLM_SHIP_DELIVERY_CODES
SHIP_FROM_ADDRESS_1_EXT VARCHAR2 (35)
SHIP_FROM address line 1, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_2_EXT VARCHAR2 (35)
SHIP_FROM address line 2, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_3_EXT VARCHAR2 (35)
SHIP_FROM address line 3, as sent by the customer on the N3 segment.
SHIP_FROM_ADDRESS_4_EXT VARCHAR2 (35)
SHIP_FROM address line 4, as sent by the customer on the N3 segment.
SHIP_FROM_CITY_EXT VARCHAR2 (30)
SHIP_FROM address city, as sent by the customer on the N4 segment.
SHIP_FROM_COUNTRY_EXT VARCHAR2 (3)
SHIP_FROM country, as sent by the customer on the N4 segment.
SHIP_FROM_COUNTY_EXT VARCHAR2 (25)
SHIP_FROM county, as sent by the customer on the N4 segment.
SHIP_FROM_NAME_EXT VARCHAR2 (60)
SHIP_FROM Name, as sent by the customer in the N1 and/or N2 segment.
SHIP_FROM_ORG_ID NUMBER

Ship from organization identifier. FK to MTL_PARAMETERS and HR_ORGANIZATIONS.
SHIP_FROM_POSTAL_CD_EXT VARCHAR2 (15)
SHIP_FROM address postal code,as sent by the customer on the N4 segment.
SHIP_FROM_PROVINCE_EXT VARCHAR2 (10)
SHIP_FROM province, as sent by the customer on the N4 segment.
SHIP_FROM_STATE_EXT VARCHAR2 (10)
SHIP_FROM state, as sent by the customer on the N4 segment.
SHIP_LABEL_INFO_LINE_1 VARCHAR2 (80)
Pull signal bar-code label routing information - line 1
SHIP_LABEL_INFO_LINE_10 VARCHAR2 (80)
Pull signal bar-code label routing information - line 10
SHIP_LABEL_INFO_LINE_2 VARCHAR2 (80)
Pull signal bar-code label routing information - line 2
SHIP_LABEL_INFO_LINE_3 VARCHAR2 (80)
Pull signal bar-code label routing information - line 3
SHIP_LABEL_INFO_LINE_4 VARCHAR2 (80)
Pull signal bar-code label routing information - line 4
SHIP_LABEL_INFO_LINE_5 VARCHAR2 (80)
Pull signal bar-code label routing information - line 5
SHIP_LABEL_INFO_LINE_6 VARCHAR2 (80)
Pull signal bar-code label routing information - line 6
SHIP_LABEL_INFO_LINE_7 VARCHAR2 (80)
Pull signal bar-code label routing information - line 7
SHIP_LABEL_INFO_LINE_8 VARCHAR2 (80)
Pull signal bar-code label routing information - line 8
SHIP_LABEL_INFO_LINE_9 VARCHAR2 (80)
Pull signal bar-code label routing information - line 9
SHIP_TO_ADDRESS_1_EXT VARCHAR2 (35)
Ship to address line 1,as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_2_EXT VARCHAR2 (35)
Ship to address line 2, as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_3_EXT VARCHAR2 (35)
Ship to address line 3, as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_4_EXT VARCHAR2 (35)
Ship to address line 4, as sent by the customer on the N3 segment.
SHIP_TO_ADDRESS_ID NUMBER

Ship to address identifier. FK to RA_ADDRESSES.
DELIVER_TO_ORG_ID NUMBER

Unique identifier for ship-to organization which relates to SHIP_TO_ADDRESS_ID if there is no intermediate ship-to address, or to INTERMEDIATE_SHIP_TO_ID if intermediate ship-to address is specified. FK to HR_ORGANIZATIONS
SHIP_TO_CITY_EXT VARCHAR2 (30)
Ship to address city, as sent by the customer on the N4 segment.
SHIP_TO_COUNTRY_EXT VARCHAR2 (3)
Ship to country, as sent by the customer on the N4 segment.
SHIP_TO_COUNTY_EXT VARCHAR2 (25)
Ship to county, as sent by the customer on the N4 segment.
SHIP_TO_NAME_EXT VARCHAR2 (60)
Ship to name, as sent by the customer on the N1 or N2 segment.
SHIP_TO_POSTAL_CD_EXT VARCHAR2 (15)
Ship to address postal code, as sent by the customer on the N4 segment.
SHIP_TO_PROVINCE_EXT VARCHAR2 (10)
Ship to province, as sent by the customer on the N4 segment.
SHIP_TO_SITE_USE_ID NUMBER

Ship to site use identifier. FK to RA_SITE_USES.
SHIP_TO_STATE_EXT VARCHAR2 (10)
Ship to state, as sent by the customer on the N4 segment.
START_DATE_TIME DATE

Customer-specified date/time, as transmitted by the customer on the EDI transaction.
SUBLINE_ASSIGNED_ID_EXT VARCHAR2 (20)
Subline customer assigned identification from the SLN01. Related to but not necessarily equivalent to the baseline number, assigned identification from LIN01. For example, 1.1 or 1A might be used as a subline number to relate to baseline number 1.
SUBLINE_CONFIG_CODE_EXT VARCHAR2 (3)
The Subline Configuration Code, as sent by the customer on the SLN segment, indicating the relationship of the subline item to the baseline item.
SUBLINE_CUST_ITEM_EXT VARCHAR2 (50)
Subline customer item number, as sent by the customer on the SLN segment.
SUBLINE_CUST_ITEM_ID NUMBER

Customer Item unique identifier.
SUBLINE_MODEL_NUM_EXT VARCHAR2 (35)
Subline customer model number, as sent by the customer on the SLN segment.
SUBLINE_QUANTITY NUMBER

The subline quantity, as sent by the customer on the SLN segment.
SUBLINE_UOM_CODE VARCHAR2 (3)
The subline unit of measure (internal) cross-referenced from the UOM sent by the customer on the SLN segment. FK to MTL_UNITS_OF_MEASURE.
SUPPLIER_ITEM_EXT VARCHAR2 (35)
Supplier item number specified by customer
TRANSIT_TIME_EXT VARCHAR2 (22)
The transit time, as sent by the customer on the TD5 segment.
TRANSIT_TIME_QUAL_EXT VARCHAR2 (3)
The transit time qualifier, as sent by the customer on the TD-5 segment.
TRANSPORT_LOC_QUAL_EXT VARCHAR2 (3)
The shipping location qualifier, as sent by the customer on the TD5 segment. This identifies the type of location which specified in the corresponding shipping location.
TRANSPORT_LOCATION_EXT VARCHAR2 (35)
The specific shipping location (such as pool point or airport) corresponding to the shipping location qualifier, as sent by the customer on the TD5 segment. This corresponds to the shipping location qualifier.
TRANSPORT_METHOD_EXT VARCHAR2 (3)
The transportation method, as sent by the customer on the TD5 segment.
UOM_CODE VARCHAR2 (3)
Abbreviated unit of measure code. FK to MTL_UNITS_OF_MEASURE.
WEIGHT_EXT NUMBER

The weight, as sent by the customer on the TD1 segment.
WEIGHT_QUALIFIER_EXT VARCHAR2 (3)
The weight qualifier, as sent by the customer on the TD1 segment.
WEIGHT_UOM_EXT VARCHAR2 (3)
The unit of measure corresponding to shipment weight, as sent by the customer on the TD1 segment.
FBO_CONFIGURATION_KEY_1 VARCHAR2 (35)
For FBO Production Sequence schedules, the 1st sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_2 VARCHAR2 (35)
For FBO Production Sequence schedules, the 2nd sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_3 VARCHAR2 (35)
For FBO Production Sequence schedules, the 3rd sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_4 VARCHAR2 (35)
For FBO Production Sequence schedules, the 4th sort key for identifying configurations indicated by the customer
FBO_CONFIGURATION_KEY_5 VARCHAR2 (35)
For FBO Production Sequence schedules, the 5th sort key for identifying configurations indicated by the customer
MATCH_KEY_ACROSS VARCHAR2 (150)
Audit trail of match across key used when this schedule was processed.
MATCH_KEY_WITHIN VARCHAR2 (150)
Audit trail of match within key used when this schedule was processed.
CRITICAL_KEY_ATTRIBUTES VARCHAR2 (150)
Audit trail of critical attributes key used when this schedule was processed. An exception (warning) is generated if one of these is missing on Firm demand.
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner Flexfield segment column
TP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Trading Partner Flexfield context column
LINE_NUMBER NUMBER

Unique identifier of a line within a schedule
INTMED_SHIP_TO_ORG_ID NUMBER

Unique identifier for intermediate ship-to organization which relates to INTERMEDIATE_SHIP_TO_ID if intermediate ship-to address is specified. FK to HR_ORGANIZATIONS
LINE_SOURCE VARCHAR2 (30)
Schedule Source at line level since lines can also be manually entered.
PREFERRED_GRADE VARCHAR2 (4)
Preferred Grade
CUST_PRODUCTION_SEQ_NUM_BEG VARCHAR2 (35)
For future use
CUST_PRODUCTION_SEQ_NUM_END VARCHAR2 (35)
For future use
ITEM_DETAIL_QUANTITY_MIN_EXT NUMBER

For future use
ITEM_DETAIL_QUANTITY_MAX_EXT NUMBER

For future use
ITEM_DETAIL_QUANTITY_PRIOR_EXT NUMBER

For future use
REQUIREMENT_PRIORITY_EXT NUMBER

For future use
PROJECT_NUMBER_EXT VARCHAR2 (50)
For future use
RESP_LINE_NUMBER VARCHAR2 (35)
For future use
TASK_NUMBER_EXT VARCHAR2 (50)
For future use
UPC_EXT VARCHAR2 (50)
For future use
ITEM_ENG_CNG_LVL_DATE_EXT DATE

For future use
AUTHORIZATION_CODE_EXT VARCHAR2 (50)
For future use
PACKAGING_DESC_EXT VARCHAR2 (80)
For future use
BILL_TO_ADDRESS_5_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_6_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_7_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_8_EXT VARCHAR2 (35)
For future use
BILL_TO_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_BILL_TO_FLAG_EXT VARCHAR2 (35)
For future use
BILL_TO_DESCRIPTION_EXT VARCHAR2 (50)
For future use
BILL_TO_FAX_EXT VARCHAR2 (35)
For future use
BILL_TO_REGION_EXT VARCHAR2 (35)
For future use
BILL_TO_JURISDICTION_EXT VARCHAR2 (35)
For future use
BILL_TO_TEL_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_5_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_6_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_7_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_8_EXT VARCHAR2 (35)
For future use
INTRMD_ST_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_INTRMD_ST_FLAG_EXT VARCHAR2 (35)
For future use
INTRMD_ST_DESCRIPTION_EXT VARCHAR2 (50)
For future use
INTRMD_ST_FAX_EXT VARCHAR2 (35)
For future use
INTRMD_ST_REGION_EXT VARCHAR2 (35)
For future use
INTRMD_ST_JURISDICTION_EXT VARCHAR2 (35)
For future use
INTRMD_ST_TEL_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_6_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SHIP_TO_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_SHIP_TO_FLAG_EXT VARCHAR2 (35)
For future use
SHIP_TO_DESCRIPTION_EXT VARCHAR2 (50)
For future use
SHIP_TO_FAX_EXT VARCHAR2 (35)
For future use
SHIP_TO_REGION_EXT VARCHAR2 (35)
For future use
SHIP_TO_JURISDICTION_EXT VARCHAR2 (35)
For future use
SHIP_TO_TEL_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_5_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_6_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_7_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_8_EXT VARCHAR2 (35)
For future use
SHIP_FROM_ADDRESS_9_EXT VARCHAR2 (35)
For future use
ONE_TIME_SHIP_FROM_FLAG_EXT VARCHAR2 (35)
For future use
SHIP_FROM_DESCRIPTION_EXT VARCHAR2 (50)
For future use
SHIP_FROM_FAX_EXT VARCHAR2 (35)
For future use
SHIP_FROM_REGION_EXT VARCHAR2 (35)
For future use
SHIP_FROM_JURISDICTION_EXT VARCHAR2 (35)
For future use
SHIP_FROM_TEL_EXT VARCHAR2 (35)
For future use
FLEX_BKT_CODE VARCHAR2 (30)
Holds the value of flex bucket code that comes in on an XML SPSI schedule
FLEX_BKT_FLAG VARCHAR2 (2)
If this is set to Y, indicates that FLEXBKTID value was sent on the XML SPSI schedule.
BLANKET_NUMBER NUMBER

Blanket Sales Agreement associated with interface line
DSP_CHILD_PROCESS_INDEX NUMBER

Stores the DSP Child Process Index the Line is associated with
SHIP_TO_CUSTOMER_ID NUMBER

Related Ship To Customer ID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_ID
,      HEADER_ID
,      AGREEMENT_ID
,      ATO_DATA_TYPE
,      BILL_TO_ADDRESS_1_EXT
,      BILL_TO_ADDRESS_2_EXT
,      BILL_TO_ADDRESS_3_EXT
,      BILL_TO_ADDRESS_4_EXT
,      BILL_TO_ADDRESS_ID
,      INVOICE_TO_ORG_ID
,      BILL_TO_CITY_EXT
,      BILL_TO_COUNTRY_EXT
,      BILL_TO_COUNTY_EXT
,      BILL_TO_NAME_EXT
,      BILL_TO_POSTAL_CD_EXT
,      BILL_TO_PROVINCE_EXT
,      BILL_TO_SITE_USE_ID
,      BILL_TO_STATE_EXT
,      CARRIER_ID_CODE_EXT
,      CARRIER_QUALIFIER_EXT
,      COMMODITY_EXT
,      COUNTRY_OF_ORIGIN_EXT
,      CUST_ASSEMBLY_EXT
,      CUST_ASSIGNED_ID_EXT
,      CUST_BILL_TO_EXT
,      CUST_CONTRACT_NUM_EXT
,      CUSTOMER_DOCK_CODE
,      CUST_INTRMD_SHIP_TO_EXT
,      CUST_ITEM_PRICE_EXT
,      CUST_ITEM_PRICE_UOM_EXT
,      CUSTOMER_ITEM_REVISION
,      CUSTOMER_JOB
,      CUST_MANUFACTURER_EXT
,      CUST_MODEL_NUMBER_EXT
,      CUST_MODEL_SERIAL_NUMBER
,      CUST_ORDER_NUM_EXT
,      CUST_PROCESS_NUM_EXT
,      CUST_PRODUCTION_LINE
,      CUST_PRODUCTION_SEQ_NUM
,      CUST_SET_NUM_EXT
,      CUST_SHIP_FROM_ORG_EXT
,      CUST_SHIP_TO_EXT
,      CUST_UOM_EXT
,      CUSTOMER_ITEM_EXT
,      CUSTOMER_ITEM_ID
,      REQUEST_DATE
,      SCHEDULE_DATE
,      DATE_TYPE_CODE
,      DATE_TYPE_CODE_EXT
,      DELIVERY_LEAD_TIME
,      END_DATE_TIME
,      EQUIPMENT_CODE_EXT
,      EQUIPMENT_NUMBER_EXT
,      HANDLING_CODE_EXT
,      HAZARD_CODE_EXT
,      HAZARD_CODE_QUAL_EXT
,      HAZARD_DESCRIPTION_EXT
,      IMPORT_LICENSE_DATE_EXT
,      IMPORT_LICENSE_EXT
,      INDUSTRY_ATTRIBUTE1
,      INDUSTRY_ATTRIBUTE10
,      INDUSTRY_ATTRIBUTE11
,      INDUSTRY_ATTRIBUTE12
,      INDUSTRY_ATTRIBUTE13
,      INDUSTRY_ATTRIBUTE14
,      INDUSTRY_ATTRIBUTE15
,      INDUSTRY_ATTRIBUTE2
,      INDUSTRY_ATTRIBUTE3
,      INDUSTRY_ATTRIBUTE4
,      INDUSTRY_ATTRIBUTE5
,      INDUSTRY_ATTRIBUTE6
,      INDUSTRY_ATTRIBUTE7
,      INDUSTRY_ATTRIBUTE8
,      INDUSTRY_ATTRIBUTE9
,      INDUSTRY_CONTEXT
,      INTRMD_SHIP_TO_ID
,      SHIP_TO_ORG_ID
,      INTRMD_ST_ADDRESS_1_EXT
,      INTRMD_ST_ADDRESS_2_EXT
,      INTRMD_ST_ADDRESS_3_EXT
,      INTRMD_ST_ADDRESS_4_EXT
,      INTRMD_ST_CITY_EXT
,      INTRMD_ST_COUNTRY_EXT
,      INTRMD_ST_COUNTY_EXT
,      INTRMD_ST_NAME_EXT
,      INTRMD_ST_POSTAL_CD_EXT
,      INTRMD_ST_PROVINCE_EXT
,      INTRMD_ST_STATE_EXT
,      INTRMD_ST_SITE_USE_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_SEGMENT1
,      INVENTORY_ITEM_SEGMENT10
,      INVENTORY_ITEM_SEGMENT11
,      INVENTORY_ITEM_SEGMENT12
,      INVENTORY_ITEM_SEGMENT13
,      INVENTORY_ITEM_SEGMENT14
,      INVENTORY_ITEM_SEGMENT15
,      INVENTORY_ITEM_SEGMENT16
,      INVENTORY_ITEM_SEGMENT17
,      INVENTORY_ITEM_SEGMENT18
,      INVENTORY_ITEM_SEGMENT19
,      INVENTORY_ITEM_SEGMENT2
,      INVENTORY_ITEM_SEGMENT20
,      INVENTORY_ITEM_SEGMENT3
,      INVENTORY_ITEM_SEGMENT4
,      INVENTORY_ITEM_SEGMENT5
,      INVENTORY_ITEM_SEGMENT6
,      INVENTORY_ITEM_SEGMENT7
,      INVENTORY_ITEM_SEGMENT8
,      INVENTORY_ITEM_SEGMENT9
,      ITEM_CONTACT_CODE_1
,      ITEM_CONTACT_CODE_2
,      ITEM_CONTACT_VALUE_1
,      ITEM_CONTACT_VALUE_2
,      ITEM_DESCRIPTION_EXT
,      ITEM_DETAIL_QUANTITY
,      ITEM_DETAIL_REF_CODE_1
,      ITEM_DETAIL_REF_CODE_2
,      ITEM_DETAIL_REF_CODE_3
,      ITEM_DETAIL_REF_VALUE_1
,      ITEM_DETAIL_REF_VALUE_2
,      ITEM_DETAIL_REF_VALUE_3
,      ITEM_DETAIL_SUBTYPE
,      ITEM_DETAIL_SUBTYPE_EXT
,      ITEM_DETAIL_TYPE
,      ITEM_DETAIL_TYPE_EXT
,      ITEM_ENG_CNG_LVL_EXT
,      ITEM_MEASUREMENTS_EXT
,      ITEM_NOTE_TEXT
,      ITEM_REF_CODE_1
,      ITEM_REF_CODE_2
,      ITEM_REF_CODE_3
,      ITEM_REF_VALUE_1
,      ITEM_REF_VALUE_2
,      ITEM_REF_VALUE_3
,      ITEM_RELEASE_STATUS_EXT
,      LADING_QUANTITY_EXT
,      LETTER_CREDIT_EXPDT_EXT
,      LETTER_CREDIT_EXT
,      LINE_REFERENCE
,      LINK_TO_LINE_REF
,      ORDER_HEADER_ID
,      ORG_ID
,      OTHER_NAME_CODE_1
,      OTHER_NAME_CODE_2
,      OTHER_NAME_VALUE_1
,      OTHER_NAME_VALUE_2
,      PACK_SIZE_EXT
,      PACK_UNITS_PER_PACK_EXT
,      PACK_UOM_CODE_EXT
,      PACKAGING_CODE_EXT
,      PARENT_LINK_LINE_REF
,      PRICE_LIST_ID
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      PRIME_CONTRCTR_PART_EXT
,      PROCESS_STATUS
,      CUST_PO_RELEASE_NUM
,      CUST_PO_DATE
,      CUST_PO_LINE_NUM
,      CUST_PO_NUMBER
,      QTY_TYPE_CODE
,      QTY_TYPE_CODE_EXT
,      RETURN_CONTAINER_EXT
,      SCHEDULE_LINE_ID
,      ROUTING_DESC_EXT
,      ROUTING_SEQ_CODE_EXT
,      SCHEDULE_ITEM_NUM
,      SHIP_DEL_PATTERN_EXT
,      SHIP_DEL_TIME_CODE_EXT
,      SHIP_DEL_RULE_NAME
,      SHIP_FROM_ADDRESS_1_EXT
,      SHIP_FROM_ADDRESS_2_EXT
,      SHIP_FROM_ADDRESS_3_EXT
,      SHIP_FROM_ADDRESS_4_EXT
,      SHIP_FROM_CITY_EXT
,      SHIP_FROM_COUNTRY_EXT
,      SHIP_FROM_COUNTY_EXT
,      SHIP_FROM_NAME_EXT
,      SHIP_FROM_ORG_ID
,      SHIP_FROM_POSTAL_CD_EXT
,      SHIP_FROM_PROVINCE_EXT
,      SHIP_FROM_STATE_EXT
,      SHIP_LABEL_INFO_LINE_1
,      SHIP_LABEL_INFO_LINE_10
,      SHIP_LABEL_INFO_LINE_2
,      SHIP_LABEL_INFO_LINE_3
,      SHIP_LABEL_INFO_LINE_4
,      SHIP_LABEL_INFO_LINE_5
,      SHIP_LABEL_INFO_LINE_6
,      SHIP_LABEL_INFO_LINE_7
,      SHIP_LABEL_INFO_LINE_8
,      SHIP_LABEL_INFO_LINE_9
,      SHIP_TO_ADDRESS_1_EXT
,      SHIP_TO_ADDRESS_2_EXT
,      SHIP_TO_ADDRESS_3_EXT
,      SHIP_TO_ADDRESS_4_EXT
,      SHIP_TO_ADDRESS_ID
,      DELIVER_TO_ORG_ID
,      SHIP_TO_CITY_EXT
,      SHIP_TO_COUNTRY_EXT
,      SHIP_TO_COUNTY_EXT
,      SHIP_TO_NAME_EXT
,      SHIP_TO_POSTAL_CD_EXT
,      SHIP_TO_PROVINCE_EXT
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_STATE_EXT
,      START_DATE_TIME
,      SUBLINE_ASSIGNED_ID_EXT
,      SUBLINE_CONFIG_CODE_EXT
,      SUBLINE_CUST_ITEM_EXT
,      SUBLINE_CUST_ITEM_ID
,      SUBLINE_MODEL_NUM_EXT
,      SUBLINE_QUANTITY
,      SUBLINE_UOM_CODE
,      SUPPLIER_ITEM_EXT
,      TRANSIT_TIME_EXT
,      TRANSIT_TIME_QUAL_EXT
,      TRANSPORT_LOC_QUAL_EXT
,      TRANSPORT_LOCATION_EXT
,      TRANSPORT_METHOD_EXT
,      UOM_CODE
,      WEIGHT_EXT
,      WEIGHT_QUALIFIER_EXT
,      WEIGHT_UOM_EXT
,      FBO_CONFIGURATION_KEY_1
,      FBO_CONFIGURATION_KEY_2
,      FBO_CONFIGURATION_KEY_3
,      FBO_CONFIGURATION_KEY_4
,      FBO_CONFIGURATION_KEY_5
,      MATCH_KEY_ACROSS
,      MATCH_KEY_WITHIN
,      CRITICAL_KEY_ATTRIBUTES
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      TP_ATTRIBUTE_CATEGORY
,      LINE_NUMBER
,      INTMED_SHIP_TO_ORG_ID
,      LINE_SOURCE
,      PREFERRED_GRADE
,      CUST_PRODUCTION_SEQ_NUM_BEG
,      CUST_PRODUCTION_SEQ_NUM_END
,      ITEM_DETAIL_QUANTITY_MIN_EXT
,      ITEM_DETAIL_QUANTITY_MAX_EXT
,      ITEM_DETAIL_QUANTITY_PRIOR_EXT
,      REQUIREMENT_PRIORITY_EXT
,      PROJECT_NUMBER_EXT
,      RESP_LINE_NUMBER
,      TASK_NUMBER_EXT
,      UPC_EXT
,      ITEM_ENG_CNG_LVL_DATE_EXT
,      AUTHORIZATION_CODE_EXT
,      PACKAGING_DESC_EXT
,      BILL_TO_ADDRESS_5_EXT
,      BILL_TO_ADDRESS_6_EXT
,      BILL_TO_ADDRESS_7_EXT
,      BILL_TO_ADDRESS_8_EXT
,      BILL_TO_ADDRESS_9_EXT
,      ONE_TIME_BILL_TO_FLAG_EXT
,      BILL_TO_DESCRIPTION_EXT
,      BILL_TO_FAX_EXT
,      BILL_TO_REGION_EXT
,      BILL_TO_JURISDICTION_EXT
,      BILL_TO_TEL_EXT
,      INTRMD_ST_ADDRESS_5_EXT
,      INTRMD_ST_ADDRESS_6_EXT
,      INTRMD_ST_ADDRESS_7_EXT
,      INTRMD_ST_ADDRESS_8_EXT
,      INTRMD_ST_ADDRESS_9_EXT
,      ONE_TIME_INTRMD_ST_FLAG_EXT
,      INTRMD_ST_DESCRIPTION_EXT
,      INTRMD_ST_FAX_EXT
,      INTRMD_ST_REGION_EXT
,      INTRMD_ST_JURISDICTION_EXT
,      INTRMD_ST_TEL_EXT
,      SHIP_TO_ADDRESS_5_EXT
,      SHIP_TO_ADDRESS_6_EXT
,      SHIP_TO_ADDRESS_7_EXT
,      SHIP_TO_ADDRESS_8_EXT
,      SHIP_TO_ADDRESS_9_EXT
,      ONE_TIME_SHIP_TO_FLAG_EXT
,      SHIP_TO_DESCRIPTION_EXT
,      SHIP_TO_FAX_EXT
,      SHIP_TO_REGION_EXT
,      SHIP_TO_JURISDICTION_EXT
,      SHIP_TO_TEL_EXT
,      SHIP_FROM_ADDRESS_5_EXT
,      SHIP_FROM_ADDRESS_6_EXT
,      SHIP_FROM_ADDRESS_7_EXT
,      SHIP_FROM_ADDRESS_8_EXT
,      SHIP_FROM_ADDRESS_9_EXT
,      ONE_TIME_SHIP_FROM_FLAG_EXT
,      SHIP_FROM_DESCRIPTION_EXT
,      SHIP_FROM_FAX_EXT
,      SHIP_FROM_REGION_EXT
,      SHIP_FROM_JURISDICTION_EXT
,      SHIP_FROM_TEL_EXT
,      FLEX_BKT_CODE
,      FLEX_BKT_FLAG
,      BLANKET_NUMBER
,      DSP_CHILD_PROCESS_INDEX
,      SHIP_TO_CUSTOMER_ID
FROM RLM.RLM_INTERFACE_LINES_ALL;

Dependencies

[top of page]

RLM.RLM_INTERFACE_LINES_ALL does not reference any database object

RLM.RLM_INTERFACE_LINES_ALL is referenced by following:

SchemaRLM
ViewRLM_INTERFACE_LINES_ALL#