Script | Description |
wm_install_into_rlmdemand.sql | Runs the scripts listed below, except the uninstall script. |
wm_into_rlmdemand_pkg.sql | Installs WM_RLM_DEMAND_IMP_HANDLER_PKG. WM_HANDLE_RLM_DEMAND, which calls the WM_CONC_REQUEST. WM_REQUEST_SUBMIT procedure to submit the Quality Collection Import process. The process in the QA module is Collection Import. |
wm_into_rlmdemand_seq.sql | Creates the following components: WM_RLM_INTERFACE_HEADER_S, which creates the HEADER_ID WM_RLM_INTERFACE_LINE_S, which create the LINE_ID |
wm_drop_into_rlmdemand.sql | Uninstalls all components created by wm_install_into_rlmdemand.sql. |
Field Name | Maps to Column | Description |
CUST_ADDRESS_ 1_EXT | CUST_ ADDRESS_ 1_EXT | Customer address line 1, as sent by the customer. |
CUST_ADDRESS_ 2_EXT | CUST_ ADDRESS_ 2_EXT | Customer address line 2, as sent by the customer. |
CUST_ADDRESS_ 3_EXT | CUST_ ADDRESS_ 3_EXT | Customer address line 3, as sent by the customer. |
CUST_ADDRESS_ 4_EXT | CUST_ ADDRESS_ 4_EXT | Customer address line 4, as sent by the customer. |
CUST_CITY_ EXT | CUST_ CITY_ EXT | Customer address city, as sent by the customer. |
CUST_COUNTRY_ EXT | CUST_ COUNTRY_ EXT | Customer country, as sent by the customer. |
CUST_COUNTY_ EXT | CUST_ COUNTY_ EXT | Customer county, as sent by customer. |
CUSTOMER_ EXT | CUSTOMER_ EXT | Trading partner designator cross reference. |
CUST_NAME_ EXT | CUST_ NAME_ EXT | Customer name as sent by customer. |
CUST_POSTAL_ CD_EXT | CUST_ POSTAL_ CD_EXT | Customer address postal code, as sent by the customer. |
CUST_PROVINCE_ EXT | CUST_ PROVINCE_ EXT | Customer province, as sent by customer. |
CUST_STATE_ EXT | CUST_ STATE_ EXT | Customer state, as sent by customer. |
ECE_ ADDRESS1 | ECE_ PRIMARY_ ADDRESS_ID | Customer primary address ID, populated by the e- commerce gateway. |
ECE_ ADDRESS2 | ||
ECE_ ADDRESS3 | ||
ECE_ ADDRESS4 | ||
ECE_ CITY | ||
ECE_POSTAL_ CODE | ||
ECE_ STATE | ||
ECE_ PROVINCE | ||
ECE_ COUNTY | ||
ECE_ COUNTRY | ||
ECE_TP_LOCATION_ CODE_EXT | ECE_TP_ LOCATION_ CODE_EXT | For EDI Transactions only. e- commerce gateway trading partner code assigned to the transaction. |
EDI_CONTROL_ NUM_1 | EDI_CONTROL_ NUM_1 | EDI Control Number (ISA) assigned by the customer’s EDI translator for audit. |
EDI_CONTROL_ NUM_2 | EDI_CONTROL_ NUM_2 | EDI Control Number (ISA) assigned by the Customer’s EDI translator for audit. |
EDI_TEST_ INDICATOR | EDI_TEST_ INDICATOR | EDI test/production indicator. |
HEADER_CONTACT_ CODE_1 | HEADER_ CONTACT_ CODE_1 | Contact code 1 included in customer’s EDI transaction. |
HEADER_CONTACT_ CODE_2 | HEADER_ CONTACT_ CODE_2 | Contact code 2 included in the customer’s EDI transaction. |
HEADER_CONTACT_ VALUE_1 | HEADER_ CONTACT_ VALUE_1 | Value for contact code 1. |
HEADER_CONTACT_ VALUE_2 | HEADER_ CONTACT_ VALUE_2 | Value for contact code 2. |
HEADER_NOTE_ TEXT | HEADER_ NOTE_ TEXT | Notes about schedule. |
HEADER_REF_ CODE_1 | HEADER_ REF_ CODE_1 | Reference code 1 includes in customer’s EDI transaction. |
HEADER_REF_ CODE_2 | HEADER_ REF_ CODE_2 | Reference code 2 includes in customer’s EDI transaction. |
HEADER_REF_ CODE_3 | HEADER_ REF_ CODE_3 | Reference code 3 included in the customer’s EDI transaction. |
HEADER_REF_ VALUE_1 | HEADER_ REF_ VALUE_1 | Value associated with reference code 1. |
HEADER_REF_ VALUE_2 | HEADER_ REF_ VALUE_2 | Value associated with reference code 2. |
HEADER_REF_ VALUE_3 | HEADER_ REF_ VALUE_3 | Value associated with reference code 3. |
ORGANIZATION_ NAME | ORG_ID | Derived from ORG_ ORGANIZATION_ DEFINITIONS. |
SCHEDULE_ TYPE | SCHEDULE_ TYPE | |
SCHEDULE_TYPE_ EXT | SCHEDULE_ TYPE_EXT | External value that derives RLM_SCHEDULE_TYPE in EDI gateway conversion. |
SCHED_GENERATION_ DATE | SCHED_ GENERATION_ DATE | Date customer generated either the schedule or planning information on the schedule. |
SCHED_HORIZON_ START_DATE | SCHED_ HORIZON_ START_DATE | Schedule horizon start date; derived from demand in the schedule, if not specified. |
SCHED_HORIZON_ END_DATE | SCHED_ HORIZON_ END_DATE | Schedule horizon end date; derived from demand in the schedule, if not specified. |
SCHEDULE_ PURPOSE | SCHEDULE_ PURPOSE | |
SCHEDULE_PURPOSE_ EXT | SCHEDULE_ PURPOSE_ EXT | External value that derives SCHEDULE_PURPOSE. |
SCHEDULE_REFERENCE_ NUM | SCHEDULE_ REFERENCE_ NUM | Customer assigned schedule reference or release number. |
SCHEDULE_ SOURCE | SCHEDULE_ SOURCE | EDI or Manual transaction source. |
Field Name | Maps to Column | Description |
AGREEMENT_NAME | AGREEMENT_ID | Derives AGREEMENT_ID from OE_AGREEMENTS_B. |
ATO_DATA_TYPE | ATO_DATA_TYPE | |
BILL_TO_ADDRESS_1_EXT | BILL_TO_ ADDRESS_1_EXT | |
BILL_TO_ADDRESS_2_EXT | BILL_TO_ ADDRESS_2_EXT | |
BILL_TO_ADDRESS_3_EXT | BILL_TO_ ADDRESS_3_EXT | |
BILL_TO_ADDRESS_4_EXT | BILL_TO_ ADDRESS_4_EXT | |
INVOICE_TO_ ORGANIZATION | INVOICE_TO_ ORG_ID | Derived from HZ_CUST_SITE_USES_ALL and RA_ADDRESSES, using ADDRESS_ID as the join between them. INVOICE_TO_ORGANIZATION is the location in HZ_CUST_SITE_USES_ALL. The other address lines are taken from the BILL_TO address columns. |
BILL_TO_CITY_EXT | BILL_TO_ CITY_EXT | |
BILL_TO_COUNTRY_EXT | BILL_TO_ COUNTRY_EXT | |
BILL_TO_COUNTY_EXT | BILL_TO_ COUNTY_EXT | |
BILL_TO_NAME_EXT | BILL_TO_ NAME_EXT | |
BILL_TO_POSTAL_CD_EXT | BILL_TO_ POSTAL_CD_EXT | |
BILL_TO_PROVINCE_EXT | BILL_TO_ PROVINCE_EXT | |
BILL_TO_STATE_EXT | BILL_TO_ STATE_EXT | |
CARRIER_QUALIFIER_ EXT | CARRIER_ QUALIFIER_ EXT | |
COMMODITY_EXT | COMMODITY_ EXT | Customer-specified commodity code. |
CUST_ASSEMBLY_EXT | CUST_ ASSEMBLY_ EXT | Customer assembly identification. |
CUST_ASSIGNED_ID_EXT | CUST_ ASSIGNED_ ID_EXT | Customer-assigned identification within a transaction set from LIN01. |
CUST_BILL_TO_EXT | CUST_BILL_ TO_EXT | External customer bill to cross reference. |
CUST_CONTRACT_ NUM_EXT | CUST_ CONTRACT_ NUM_EXT | Customer contract number, as sent on the LIN segment of the 830 transaction. |
CUSTOMER_DOCK_ CODE | CUSTOMER_ DOCK_CODE | |
CUST_INTERMD_SHIP_ TO_EXT | CUST_INTERMD_ SHIP_TO_EXT | External intermediate ship to cross reference. |
CUST_ITEM_PRICE_ EXT | CUST_ITEM_ PRICE_EXT | Customer price on the EDI transaction. |
CUST_ITEM_PRICE_ UOM_EXT | CUST_ITEM_ PRICE_UOM_EXT | Unit of measure for the price on the customer’s EDI transaction. |
CUSTOMER_ITEM_REVISION | CUSTOMER_ ITEM_REVISION | |
CUSTOMER_JOB | CUSTOMER_ JOB | Customer job number. |
CUST_MANUFACTURER_ EXT | CUST_ MANUFACTURER_ EXT | The manufacturer as sent by the customer on the LIN segment of the 866 transaction. |
CUST_MODEL_NUMBER_ EXT | CUST_MODEL_ NUMBER_ EXT | Customer model number. |
CUST_ORDER_ NUM_EXT | CUST_ORDER_ NUM_ EXT | Order number of the customer. |
CUST_PROCESS_ NUM_EXT | CUST_PROCESS_ NUM_ EXT | Customer process number. |
CUST_PRODUCTION_ LINE | CUST_ PRODUCTION_ LINE | Customer production line. |
CUSTOMER_PROD_ SEQ_NUM | CUSTOMER_PROD_ SEQ_NUM | Customer production sequence number or delivery number. |
CUST_SET_ NUM_EXT | CUST_SET_ NUM_EXT | Customer’s set number. |
CUST_SHIP_FROM_ ORG_EXT | CUST_SHIP_FROM_ ORG_EXT | External inventory organization cross reference. |
CUST_SHIP_TO_EXT | CUST_SHIP_ TO_EXT | External Ship To address cross reference. |
CUST_UOM_EXT | CUST_UOM_ EXT | External customer unit of measure cross reference. |
CUSTOMER_ITEM_EXT | CUSTOMER_ ITEM_EXT | External customer item cross reference. |
CUSTOMER_ITEM_NUMBER | CUSTOMER_ ITEM_ID | Derived from MTL_CUSTOMER_ITEMS. |
REQUEST_DATE | REQUEST_ DATE | Date and time customer wants material delivered or shipped. |
SCHEDULE_DATE | SCHEDULE_ DATE | Planned shipment date and time. |
DATE_TYPE | DATE_TYPE_ CODE | Validated against FND_ LOOKUPS. LOOKUP_ TYPE=RLM_DATE_ TYPE_CODE . |
DATE_TYPE_CODE_EXT | DATE_TYPE_ CODE_EXT | External value from which date type code was derived. |
DELIVERY_LEAD_TIME | DELIVERY_LEAD_ TIME | For demand line. The time between arrival date and shipment date, based on the default shipping and method. |
END_DATE_TIME | END_DATE_ TIME | |
EQUIPMENT_CODE_EXT | EQUIPMENT_ CODE_EXT | |
EQUIPMENT_NUMBER_EXT | EQUIPMENT_ NUMBER_EXT | Equipment number from the customer. |
HANDLING_CODE_EXT | HANDLING_ CODE_EXT | Special handling code. |
HAZARD_CODE_EXT | HAZARD_ CODE_EXT | Hazardous material code. |
IMPORT_LICENSE_DATE_EXT | IMPORT_ LICENSE_ DATE_EXT | Customer’s import license date. |
IMPORT_LICENSE_EXT | IMPORT_ LICENSE_ EXT | Customer’s import license for shipment destination country. |
INTRMD_ST_ADDRESS_1_EXT | INTRMD_ST_ ADDRESS_1_ EXT | Intermediate Ship To address line 1. |
INTRMD_ST_ADDRESS_2_EXT | INTRMD_ST_ ADDRESS_2_ EXT | Intermediate Ship To address line 2. |
INTRMD_ST_ADDRESS_3_EXT | INTRMD_ST_ ADDRESS_3_ EXT | Intermediate Ship To address line 3. |
INTRMD_ST_ADDRESS_4_EXT | INTRMD_ST_ ADDRESS_4_ EXT | Intermediate Ship To address line 4. |
INTRMD_ST_CITY_EXT | INTRMD_ST_ CITY_EXT | Intermediate Ship To city. |
INTRMD_ST_COUNTRY_EXT | INTRMD_ST_ COUNTRY_EXT | Intermediate Ship To country. |
INTRMD_ST_COUNTY_EXT | INTRMD_ST_ COUNTY_EXT | Intermediate Ship To county. |
INTRMD_ST_POSTAL_CD_EXT | INTRMD_ST_ POSTAL_ CD_EXT | Intermediate postal code of Ship To address. |
INTRMD_ST_PROVINCE_EXT | INTRMD_ST_ PROVINCE_ EXT | Intermediate Ship To province. |
INTERMD_ST_STATE_EXT | INTERMD_ST_ STATE_EXT | Intermediate Ship To state. |
ITEM_NUMBER | INVENTORY_ ITEM_ID | Derived from MTL_SYSTEM_ITEMS_B_KFV for the Organization. |
ITEM_CONTACT_CODE_1 | ITEM_CONTACT_ CODE_1 | |
ITEM_CONTACT_CODE_2 | ITEM_CONTACT_ CODE_2 | |
ITEM_CONTACT_VALUE_1 | ITEM_CONTACT_ VALUE_1 | Value associated with contact code 1. |
ITEM_CONTACT_VALUE_2 | ITEM_CONTACT_ VALUE_2 | Value associated with contact code 2. |
ITEM_DETAIL_QUANTITY | ITEM_DETAIL_ QUANTITY | If Item_Detail_Type is 0, 1, or 2, then field is demand quantity. If Item_Detail_Type is 3, then field is authorization quantity. If Item_Detail_Type is 4, then field is shipped, received, or cumulative quantity. If Item_Detail_Type is 5, then field is miscellaneous quantity. |
ITEM_DETAIL_REF_CODE_1 | ITEM_DETAIL_ REF_CODE_1 | Item Detail Reference Code 1. |
ITEM_DETAIL_REF_CODE_2 | ITEM_DETAIL_ REF_CODE_2 | Item Detail Reference Code 2. |
ITEM_DETAIL_REF_CODE_3 | ITEM_DETAIL_ REF_CODE_3 | Item Detail Reference Code 3. |
ITEM_DETAIL_REF_VALUE_1 | ITEM_DETAIL_ REF_VALUE_1 | Value associated with Reference Code 1. |
ITEM_DETAIL_REF_VALUE_2 | ITEM_DETAIL_ REF_VALUE_2 | Value associated with Reference Code 2. |
ITEN_DETAIL_REF_VALUE_3 | ITEN_DETAIL_ REF_VALUE_3 | Value associated with Reference Code 3. |
ITEM_DETAIL_SUBTYPE | ITEM_DETAIL_ SUBTYPE | |
ITEM_DETAIL_TYPE | ITEM_DETAIL_ TYPE | |
ITEM_ENG_CNG_LVL_EXT | ITEM_ENG_CNG_ LVL_EXT | Customer part engineering change level. |
ITEM_MEASUREMENTS_EXT | ITEM_ MEASUREMENTS_ EXT | Item measurement information. |
ITEM_NOTE_EXT | ITEM_ NOTE_EXT | Free form item note. |
ITEM_REF_CODE_1 | ITEM_REF_ CODE_1 | Item Reference Code 1. |
ITEM_REF_CODE_2 | ITEM_REF_ CODE_2 | Item Reference Code 2. |
ITEM_REF_CODE_3 | ITEM_REF_ CODE_3 | Item Reference Code 3. |
ITEM_REF_VALUE_1 | ITEM_REF_ VALUE_1 | Value associated with item reference value 1. |
ITEM_REF_VALUE_2 | ITEM_REF_ VALUE_2 | Value associated with reference value 2. |
ITEM_REF_VALUE_3 | ITEM_REF_ VALUE_3 | Value associated with reference value 3. |
ITEM_RELEASE_STATUS_EXT | ITEM_RELEASE_ STATUS_EXT | Customer part release status. |
LADING_QUANTITY_EXT | LADING_QUANTITY_ EXT | |
LETTER_CREDIT_EXPDT_EXT | LETTER_CREDIT_ EXPDT_EXT | Letter of credit expiration date. |
LETTER_CREDIT_EXT | LETTER_ CREDIT_EXT | Letter of credit. |
LINE_REFERENCE | LINE_ REFERENCE | Unique line identifier within an order for a transmission identifier. |
LINK_TO_LINE_REF | LINK_TO_ LINE_REF | Link to immediate Parent_Line_reference within an order for a transmission identifier. |
ORDER_NUMBER | ORDER_ HEADER_ID | Derived from OE_ORDER_HEADERS_ALL. |
OTHER_NAME_CODE_1 | OTHER_NAME_ CODE_1 | |
OTHER_NAME_CODE_2 | OTHER_NAME_ CODE_2 | |
OTHER_NAME_VALUE_1 | OTHER_NAME_ VALUE_1 | Other name value for code 1. |
OTHER_NAME_VALUE_2 | OTHER_NAME_ VALUE_2 | Other name value for code 2. |
PACK_SIZE_EXT | PACK_SIZE_ EXT | Size of supplier units in pack. |
PACK_UNITS_PER_PACK_EXT | PACK_UNITS_ PER_PACK_EXT | Number of inner pack units per pack unit. |
PACK_UOM_CODE_EXT | PACK_UOM_ CODE_EXT | Unit of measure of supplier units. |
PACKAGING_CODE_EXT | PACKAGING_CODE_ EXT | Packaging code. |
PARENT_LINE_LINE_REF | PARENT_LINE_ LINE_REF | Line reference of top model for a transmission identifier. |
PRICE_LIST_NAME | PRICE_LIST_ID | |
PRIMARY_QUANTITY | PRIMARY_ QUANTITY | Quantity for the primary unit of measure. |
PRIMARY_UOM_CODE | PRIMARY_ UOM_CODE | Primary unit of measure code. |
PRIME_CONTRCTR_PART_EXT | PRIME_CONTRCTR_ PART_EXT | Prime contractor part number. |
CUST_PO_RELEASE_NUM | CUST_PO_ RELEASE_ NUM | PO Release Number. |
CUST_PO_DATE | CUST_PO_ DATE | PO Date. |
CUST_PO_LINE_NUM | CUST_PO_ LINE_NUM | PO Line Number. |
QTY_TYPE_CODE | QTY_TYPE_ CODE | Validated against FND_LOOKUPS. LOOKUP_TYPE= RLM_QTY_ TYPE_CODE. |
RETURN_CONTAINER_EXT | RETURN_ CONTAINER_ EXT | Returnable container. |
ROUTING_DESC_EXT | ROUTING_DESC_ EXT | Routing description from the customer. |
ROUTING_SEQ_CODE_EXT | ROUTING_SEQ_ CODE_EXT | Routing sequence code. |
SCHEDULE_ITEM_NUM | SCHEDULE_ ITEM_NUM | Schedule item number. |
SHIP_DEL_PATTERN_EXT | SHIP_DEL_ PATTERN_EXT | Customer ship delivery pattern code. |
SHIP_DEL_TIME_CODE_EXT | SHIP_DEL_ TIME_CODE_EXT | Customer ship delivery time code |
SHIP_DEL_RULE_NAME | SHIP_DEL_ RULE_NAME | Delivery rule name. |
SHIP_FROM_ADDRESS_1_EXT | SHIP_FROM_ ADDRESS_1 _EXT | Ship from address line 1. |
SHIP_FROM_ADDRESS_2_EXT | SHIP_FROM_ ADDRESS_2 _EXT | Ship from address line 2. |
SHIP_FROM_ADDRESS_3_EXT | SHIP_FROM_ ADDRESS_3 _EXT | Ship from address line 3. |
SHIP_FROM_ADDRESS_4_EXT | SHIP_FROM_ ADDRESS_4 _EXT | Ship from address line 4. |
SHIP_FROM_CITY_EXT | SHIP_FROM_ CITY_EXT | Ship from city address. |
SHIP_FROM_COUNTRY_EXT | SHIP_FROM_ COUNTRY_EXT | Ship from address country. |
SHIP_FROM_COUNTY_EXT | SHIP_FROM_ COUNTY_ EXT | Ship from address county. |
SHIP_FROM_ORGANIZATION | SHIP_FROM_ ORG_ID | Derived from HR_ALL_ORGANIZATION_ UNITS and HR_LOCATIONS, using LOCATION_ID as the join between them. Assign NAME to the Organization name and a SHIP_FROM address columns to the address columns in HR_LOCATIONS. |
SHIP_FROM_POSTAL_CD_EXT | SHIP_FROM_ POSTAL_CD_EXT | Ship from address postal code. |
SHIP_FROM_PROVINCE_EXT | SHIP_FROM_ PROVINCE EXT | Ship from address province. |
SHIP_FROM_STATE_EXT | SHIP_FROM_ STATE EXT | Ship from address state. |
SHIP_LABEL_INFO_LINE1 through SHIP_LABEL_INFO_LINE10 | SHIP_LABEL_ INFO_LINE1 through SHIP_LABEL_ INFO_LINE10 | Pull signal barcode label routing information line 1 through line 10. |
SHIP_TO_ADDRESS_1_EXT | SHIP_TO_ ADDRESS_1_ EXT | Ship to address line 1. |
SHIP_TO_ADDRESS_2_EXT | SHIP_TO_ ADDRESS_3_ EXT | Ship to address line 2. |
SHIP_TO_ADDRESS_3_EXT | SHIP_TO_ ADDRESS_1_ EXT | Ship to address line 3. |
SHIP_TO_ADDRESS_4_EXT | SHIP_TO_ ADDRESS_4_ EXT | Ship to address line 4. |
SHIP_TO_CITY_EXT | SHIP_TO_ CITY_EXT | Ship to city. |
DELIVER_TO_ORGANIZATION | ||
SHIP_TO_COUNTRY_EXT | SHIP_TO_ COUNTRY_EXT | Ship to country. |
SHIP_TO_COUNTY_EXT | SHIP_TO_ COUNTY_EXT | Ship to county. |
SHIP_TO_NAME_EXT | SHIP_TO_ NAME_EXT | Ship to name. |
SHIP_TO_POSTAL_CD_EXT | SHIP_TO_ POSTAL_CD_ EXT | Ship to postal code. |
SHIP_TO_STATE_EXT | SHIP_TO_ STATE_EXT | Ship to state. |
SHIP_TO_PROVINCE_EXT | DELIVER_TO_ ORG_ID | Derived from HZ_CUST_SITE_USES_ALL and RA_ADDRESSES, using ADDRESS_ID as the join between them. INVOICE_TO_ ORGANIZATION is the Location in HZ_CUST_SITE_USES_ALL. The other address lines are taken from the SHIP_TO address columns. |
START_DATE_TIME | START_DATE_TIME | Start date and time. |
SUBLINE_ASSIGNED_ID_EXT | SUBLINE_ ASSIGNED_ ID_EXT | Subline assigned identification. |
SUBLINE_CONFIG_CODE_EXT | SUBLINE_ CONFIG_ CODE_EXT | Subline configuration code. |
SUBLINE_CUST_ITEM_EXT | SUBLINE_ CUST_ ITEM_EXT | Subline customer assigned number. |
SUBLINE_MODEL_NUM_EXT | SUBLINE_ MODEL_ NUM_EXT | Subline customer model number. |
SUBLINE_QUANTITY | SUBLINE_ QUANTITY | Subline quantity. |
SUBLINE_UOM_CODE | SUBLINE_ UOM_CODE | Subline unit of measure code. |
SUPPLIER_ITEM_EXT | SUPPLIER_ITEM_ EXT | Supplier item number. |
TRANSIT_TIME_EXT | TRANSIT_TIME_ EXT | Transit time. |
TRANSPORT_LOC_QUAL_EXT | TRANSPORT_ LOC_QUAL_EXT | Transit time qualifier. |
TRANSPORT_LOCATION_EXT | TRANSPORT_ LOCATION_EXT | Specific shipping location. |
TRANSPORT_METHOD_EXT | TRANSPORT_ METHOD_EXT | Transportation method. |
UOM_CODE | UOM_CODE | Unit of measure code. |
WEIGHT_EXT | WEIGHT_EXT | Weight from the customer. |
WEIGHT_QUALIFIER_EXT | WEIGHT_ QUALIFIER_EXT | Weight qualifier. |
WEIGHT_UOM_EXT | WEIGHT_ UOM_EXT | Weight unit of measure. |
FBO_CONFIGURATION_KEY_1 | FBO_ CONFIGURATION_ KEY_1 | For FBO Production Schedules, the first sort key for identifying configurations indicated by the customer. |
FBO_CONFIGURATION_KEY_2 | FBO_ CONFIGURATION_ KEY_2 | For FBO Production Schedules, the second sort key for identifying configurations indicated by the customer. |
FBO_CONFIGURATION_KEY_3 | FBO_ CONFIGURATION_ KEY_3 | For FBO Production Schedules, the third sort key for identifying configurations indicated by the customer. |
FBO_CONFIGURATION_KEY_4 | FBO_ CONFIGURATION_ KEY_4 | For FBO Production Schedules, the fourth sort key for identifying configurations indicated by the customer. |
FBO_CONFIGURATION_KEY_5 | FBO_ CONFIGURATION_ KEY_5 | For FBO Production Schedules, the fifth sort key for identifying configurations indicated by the customer. |
LINE_NUMBER | LINE_NUMBER | Unique identifier of a line within a schedule. |
INTMED_SHIP_TO_ORGANIZATION | INTMED_ SHIP_TO_ ORG_ID | Derived from HZ_CUST_SITE_USES_ALL and RA_ADDRESSES, using ADDRESS_ID as the join between them. INTMED_SHIP_TO_ ORGANIZATION is the Location in HZ_CUST_SITE_USES_ALL.The other address lines are taken from the INTRMED_SHIP_TO address columns. |
LINE_SOURCE | LINE_SOURCE | |
PREFERRED_GRADE | PREFERRED_ GRADE |