Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Manufacturing Predefined Transaction Services | Receive Demand Schedule Service
 
Receive Demand Schedule Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: releaseManagement1227.intoOA.demandSchedule:receiveDemandSchedule.
This service imports demand schedules. You can use Oracle Release Management to automate the management and reconciliation of customer inbound schedules, and to enable a rapid response for changing demand requirements. The Demand Schedule interface or the Demand Processor takes an inbound demand schedule from the release management demand processor interface tables.
Database Scripts
This service uses the following database scripts:
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.
For more information about using database scripts, see Database Scripts.
Supporting Transaction Definitions
This service was built from the configured services defined in the following transaction definitions:
*setDemandScheduleTxn1227.txp
*DemandScheduleTxn1227.txp
For information about using the transaction definition files to customize this service, see Transaction Definitions.
Flow Control
This service uses the following flow steps to import demand schedules:
*specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
*specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.
*bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).
*getAddressId takes ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, POSTAL_CODE, STATE, PROVINCE, COUNTY, and COUNTRY as input, and queries the table HZ_CUST_ACCT_SITES_ALL to get ADDRESS_ID.
*getAgreementId takes AGREEMENT_NAME as input, and queries the table OE_AGREEMENTS_B to get AGREEMENT_ID.
*getDateTypeCode takes DATE_TYPE as input, and queries the table FND_LOOKUPS to get DATE_TYPE_CODE.
*getInvoiceOrgId takes BILL_TO_ADDRESS1, BILL_TO_ADDRESS2, BILL_TO_ADDRESS3, BILL_TO_ADDRESS4, BILL_TO_CITY, BILL_TO_POSTAL_CODE, BILL_TO_STATE, BILL_TO_PROVINCE, BILL_TO_COUNTY, BILL_TO_COUNTRY, and INVOICE_TO_ORGANIZATION as input, and queries the tables HZ_CUST_SITE_USES_ALL and HZ_CUST_ACCT_SITES_ALL to get INVOICE_TO_ORG_ID.
*getOrderHeaderId takes ORDER_NUMBER and ORG_NAME as input, and queries the tables OE_ORDER_HEADERS_ALL and HR_ORGANIZATION_UNITS to get ORDER_HEADER_ID.
*getPriceListId takes PRICE_LIST_NAME as input, and queries the table QP_LIST_HEADERS_V to get LIST_HEADER_ID.
*getShipFromOrgId takes ORG_NAME, SHIP_FROM_ADDRESS1, SHIP_FROM_ADDRESS2, SHIP_FROM_ADDRESS3, SHIP_FROM_CITY, SHIP_FROM_COUNTY, SHIP_FROM_STATE, SHIP_FROM_PROVINCE, SHIP_FROM_POSTAL_CODE, and SHIP_FROM_COUNTRY as input, and queries the tables HR_LOCATIONS and HR_ALL_ORGANIZATION_UNITS to get ORGANIZATION_ID.
*getShipToOrgId takes SHIP_TO_ORGANIZATION, SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4, SHIP_TO_CITY, SHIP_TO_POSTAL_CODE, SHIP_TO_STATE, SHIP_TO_PROVINCE, SHIP_TO_COUNTY, and SHIP_TO_COUNTRY as input, and queries the tables HZ_CUST_SITE_USES_ALL and HZ_CUST_ACCT_SITES_ALL to get SHIP_TO_ORG_ID.
*getCustomerId takes CUSTOMER_NAME as input, and queries the table HZ_CUST_ACCOUNTS to get CUSTOMER_ID.
*getCustItemIdFromAddrTmp takes CUSTOMER_ITEM_NUMBER, PARTY_NAME, and ADDRESS_ID as input, and queries the tables MTL_CUSTOMER_ITEMS_ALL_V and HZ_CUST_ACCOUNTS to get CUSTOMER_ITEM_ID.
*getCustItemIdFromAddr takes CUSTOMER_ITEM_NUMBER, PARTY_NAME, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, POSTAL_CODE, STATE, PROVINCE, COUNTY, and COUNTRY as input, and queries the HZ_CUST_SITE_USES_ALL table to get CUST_ACC_SITE_ID.
*setDemandScheduleTxn inserts data into the interface table. It extracts data from the IData structure that results from the bizDocMapping service, and puts the data into the interface table.
*importDemandSchedule imports data to the production table from the interface table. It calls the services execDemandScheduleConcProg, checkDemandScheduleImportStatus, and getDemandScheduleImport_ERR to execute the corresponding concurrent program that inserts data into the production table, and to generate the error/acknowledgement message. If the status of the execution is SUCCESS (returned by the service execDemandScheduleConcProg), it checks for the record in the interface table. If records are found, it then indicates an error during import. In this case, this service calls getDemandScheduleImport_ERR to retrieve the errors. If no records are found, it comes out of the flow, indicating success of the data import process. If the status of the execution is FAILED, it comes out of execution. There can be two types of action on the record to be imported: update and insert. This flow checks for the mode of action and accordingly calls the import program.
*execDemandScheduleConcProg invokes the stored procedure WM_RLM_DEMAND_IMP_HANDLER_PKG. WM_HANDLE_RLM_DEMAND. The procedure calls the corresponding concurrent subroutine to execute the data import process for Demand Schedule Transactions into Oracle Applications. This service returns Status ID, Request ID, Execution Status Message (for normal concurrent program completion), and database Stored Procedure error message (if an exception occurs in Stored Procedure execution).
*checkDemandScheduleImportStatus checks the status of the execution by checking the Interface Table for any rejected records corresponding to the current REQUEST_ID. If the query does not return rows, it indicates a successful import. If the query returns rows, it indicates that the concurrent program could not import data successfully in the production tables of Oracle Applications.
*getDemandScheduleImport_ERR gets the error message that occurs during the data import to the production table from the interface table. Based on the parameter REQUEST_ID, it scans tables RLM_DEMAND_EXCEPTIONS to get the corresponding message.
For more details on receive transactions, see Overview of Receive Service Transaction Processing.
Business Document Structure
This service uses the business document DemandScheduleBizDoc. Its structure is as follows:
*1.0. RLM_HEADERS
*1.1. RLM_LINES
1.0. RLM_HEADERS(Maps to RLM_INTERFACE_HEADERS_ALL)
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.
1.1. RLM_LINES (Maps to RLM_INTERFACE_LINES_ALL)
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