This appendix provides information on the XML messages in TBI.
This appendix covers the following topics:
TBI uses XML Gateway to generate XML messages. The XML messages in TBI conform to the Open Applications Group Integration Specifications (OAGIS) standard and are published as OAG Business Object Documents (BODs) to the external billing applications.
A BOD contains the following:
Control Area (CNTROLAREA): This is the header area defining the identification of the message, the purpose, the sender details, and the time stamp information. All BODs have the same structure for the Control Area.
Data Area (DATAAREA): The data area contains the business specific data that is being communicated by the BOD. This area defines the actual business object, such as the TCA account or the OM Sales Order. The structure and content of this area varies based on the DTD for each message.
TBI provides the XML DTDs for all the messages exchanged between E-Business Suite and the external billing applications. These DTDs must be used to define BODs in the messaging middleware. TBI generates outbound BODs corresponding to:
TCA Account (Add and Update)
OM Sales Order
Inventory Item
Grouped Sales Order
There is only one inbound BOD for TBI. This is the ConfirmBOD (CBOD). The CBOD is used by the billing application to return the status of processing the outbound BODs.
Note: The DTDs for BODs must be used along with the OAG based DTDs to define the business objects in the messaging middleware. The OAG based DTDs are modified to include extensions for TBI.
Oracle XML Gateway generates the TBI outbound messages and they are delivered as Advanced Queue payloads. The inbound messages (CBOD messages) from a billing application must contain information that the E-Business Suite can use to track success or failure of a published outbound message.
The outbound messages publish information on the Oracle E-Business Suite objects, such as customers, products, sales orders, and so on to the external billing applications. Messages are delivered to the Outbound AQ: XNB_JMS_OUTBOUND queue and are picked up by the middleware adapters from the queue.
The table below lists the structure of the JMS standard message.
| HEADER | Main Header |
| HEADER.REPLYTO | Reply to Information |
| HEADER.REPLYTO.NAME | Name of the Application Replied To |
| HEADER.REPLYTO.ADDRESS | Address of the Application Replied To |
| HEADER.REPLYTO.PROTOCOL | Protocol Used in Replying |
| HEADER.USERID | User Id |
| HEADER.APPID | Application Id |
| HEADER.GROUPID | Group Id |
| HEADER.GROUPSEQ | Group Sequence |
| HEADER.PROPERTIES | Properties |
| TEXT_LEN | Length of the Payload |
| TEXT_VC | Has the Payload If TEXT_LEN < 4000 bytes |
| LOB | Has the Payload If TEXT_LEN > 4000 bytes |
The message properties contains fields that identify the type of message, the standard it uses, the entity that the message refers to, the sender details, the transportation, and the authentication information. In CBOD messages, XML Gateway refers these properties to identify the correct map to execute.
The following table explains the properties that are published in the Advanced Queue message.
| Field | Value |
|---|---|
| ECX_MESSAGE_TYPE | XML |
| ECX_MESSAGE_STANDARD | OAG |
| ECX_TRANSACTION_TYPE | BOD |
| ECX_TRANSACTION_SUBTYPE | CONFIRM |
| ECX_PARTY_SITE_ID | Sender Billing application |
| BES_EVENT_NAME | oracle.apps.ecx.jms.receive (Seeded) |
| BES_EVENT_KEY | Unique key for every run |
Inbound messages contain acknowledgements for the published messages or information on the bill summary.
The Confirm BOD message generated by a billing application is another BOD and follows the OAG definition for a BOD. This message contains a control area as well as a data area.
The value of CNTROLAREA.SENDER.COMPONENT in the inbound messages should correspond to the XML Gateway hub user identification (Hub Entity Code) that is set for the respective external billing application. TBI uses this field to identify the billing application that sent a given confirm BOD.
The DATAAREA.CONFIRM_BOD.CONFIRM.CNTROLAREA field should contain the control area of the message being confirmed. For example, if a CBOD is confirming a TCA account message, this field should contain the control area of the account message. The SENDER.REFERENCEID field is used by the XML Gateway to identify the message being confirmed. The control area of the message being confirmed can be copied exactly in this field.
The DATAAREA.CONFIRM_BOD.CONFIRM.STATUSLVL field contains the status of the processing done on the message being confirmed. If the status is ‘00', it indicates that the processing was successful. If the status is ‘99', it indicates that the processing was a failure.
Structure of the CBOD XML Message
<?xml version = ''1.0'' standalone = ''no''?>
<!DOCTYPE CONFIRM_BOD_004 SYSTEM "xnb_002_confirm_bod_004.dtd">
<CONFIRM_BOD_004>
<CNTROLAREA>
<BSR>
<VERB value="CONFIRM">CONFIRM</VERB>
<NOUN value="BOD">BOD</NOUN>
<REVISION value="004">004</REVISION>
</BSR>
<SENDER>
<LOGICALID>NO_VALUE(SNDR)</LOGICALID>
<COMPONENT>BILLAPP_1</COMPONENT>
<TASK>CONFIRM</TASK>
<REFERENCEID>NO_VALUE(REF)</REFERENCEID>
<CONFIRMATION>0</CONFIRMATION>
<LANGUAGE>en</LANGUAGE>
<CODEPAGE>ISO 8859-1</CODEPAGE>
<AUTHID>NO_VALUE(AUTHID)</AUTHID>
</SENDER>
<DATETIME qualifier="CREATION">
<YEAR>2004</YEAR>
<MONTH>05</MONTH>
<DAY>12</DAY>
<HOUR>11</HOUR>
<MINUTE>12</MINUTE>
<SECOND>39</SECOND>
<SUBSECOND>1010</SUBSECOND>
<TIMEZONE>+0000</TIMEZONE>
</DATETIME>
</CNTROLAREA>
<DATAAREA>
<CONFIRM_BOD>
<CONFIRM>
<CNTROLAREA>
<BSR>
<VERB value="ADD">ADD</VERB>
<NOUN value="ACCOUNT">ACCOUNT</NOUN>
<REVISION value="001">001</REVISION>
</BSR>
<SENDER>
<LOGICALID>ORACLE</LOGICALID>
<COMPONENT>XNB</COMPONENT>
<TASK>AAO</TASK>
<REFERENCEID>C12X4MST.US.ORACLE.COM:oracle.apps.xnb.salesorder.create:XNB:SALESORDER_LINE : 43125:294654</REFERENCEID>
<CONFIRMATION>2</CONFIRMATION>
<LANGUAGE>US</LANGUAGE>
<CODEPAGE>UTF8</CODEPAGE>
<AUTHID>APPS</AUTHID>
</SENDER>
<DATETIME qualifier="CREATION">
<YEAR>2005</YEAR>
<MONTH>01</MONTH>
<DAY>04</DAY>
<HOUR>21</HOUR>
<MINUTE>06</MINUTE>
<SECOND>06</SECOND>
<SUBSECOND>0000</SUBSECOND>
<TIMEZONE>+0000</TIMEZONE>
</DATETIME>
</CNTROLAREA>
<STATUSLVL>00</STATUSLVL>
<DESCRIPTN>THE BOD WAS PROCESSED SUCCESSFULLY</DESCRIPTN>
</CONFIRM>
</CONFIRM_BOD>
</DATAAREA>
</CONFIRM_BOD_004>
TBI provides seeded XML messages for the following:
Account information
Sales order information
Item information
GSO
The following table lists the message specifications for account information.
| XML Tag | XML Parent Tag | Field in E-Business Suite | Description |
| ACCOUNT_INFO | DATAAREA | Account information | |
| CUST_ACCOUNT_ID | ACCOUNT_INFO | HZ_CUST_ACCOUNTS. CUST_ACCOUNT_ID | Customer account identifier. |
| ACCOUNT_NUMBER | ACCOUNT_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NUMBER | Account Number. |
| STATUS | ACCOUNT_INFO | HZ_CUST_ACCOUNTS. STATUS | Customer status flag. |
| ACCOUNT_NAME | ACCOUNT_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NAME | Description chosen by external party. |
| DATETIME | ACCOUNT_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_ESTABLISHED_DATE | Date when the customer account was originally established. |
| TAX_CODE | ACCOUNT_INFO | HZ_CUST_ACCOUNTS. TAX_CODE | Tax code for this customer. |
| TAX_HEADER_LEVEL _FLAG |
ACCOUNT_INFO | HZ_CUST_ACCOUNTS. TAX_HEADER_LEVEL_FLAG | Indicate if item is tax header or a line item. |
| HOLD_BILL_FLAG | ACCOUNT_INFO | HZ_CUST_ACCOUNTS. HOLD_BILL_FLAG | Indicates if the bill receivable should be held or not. |
| ACCOUNT_EXT _ATTRIBUTES |
ACCOUNT_INFO | Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | ACCOUNT_EXT_ ATTRIBUTES |
HZ_CUST_ACCOUNTS. ATTRIBUTE1 to HZ_CUST_ACCOUNTS. ATTRIBUTE15 | Descriptive Flexfield segment for Account. |
| RELATED_ACCOUNTS | DATAAREA | Related Accounts Information | - |
| RELATED_CUST _ACCOUNT_ID |
RELATED_ACCOUNTS | HZ_CUST_ACCT_RELATE_ALLRELATED_CUST_ACCOUNT_ID | Related Customer Account Id |
| RELATED_CUST _ACCOUNT_NUMBER |
RELATED_ACCOUNTS | HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER | Related Customer Account Number. |
| RELATED_CUST _ACCOUNT_NAME |
RELATED_ACCOUNTS | HZ_CUST_ACCOUNTS.ACCOUNT_NAME | Related Customer Account Name |
| RELATIONSHIP_TYPE | RELATED_ACCOUNTS | HZ_CUST_ACCT_RELATE_ALL. RELATIONSHIP_TYPE | Relationship Type |
| ORG_ID | RELATED_ACCOUNTS | HZ_CUST_ACCT_RELATE_ALL.ORG_ID | Organization Id |
| BILL_TO_FLAG | RELATED_ACCOUNTS | HZ_CUST_ACCT_RELATE_ALL.BILL_TO_FLAG | Bill To Relationship Flag |
| SHIP_TO_FLAG | RELATED_ACCOUNTS | HZ_CUST_ACCT_RELATE_ALL.SHIP_TO_FLAG | Ship To Relationship Flag |
| TAX_EXEMPTIONS | DATAAREA | Tax Data | - |
| EXEMPTION_TYPE | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. EXEMPTION_TYPE | Exemptions can be for customers at a location, or for items at a location. |
| STATUS | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. STATUS | Approval status for this exemption. |
| TAX_CODE | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. TAX_CODE | Tax code that this exemption applies to. |
| PERCENT_EXEMPT | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. PERCENT_EXEMPT | Percentage that is exempt from tax. |
| CUSTOMER_EXEMPTION _NUMBER |
TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. CUSTOMER_EXEMPTION _NUMBER |
Exemption certificate number. |
| DATETIME | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. END_DATE | Last date that this exemption is effective. |
| DATETIME | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. START_DATE | First date that this exemption is effective. |
| REASON_CODE | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. REASON_CODE | The reason for this exemption. |
| EXEMPT_PERCENT1 | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. EXEMPT_PERCENT1 | Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield. |
| EXEMPT_PERCENT2 | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. EXEMPT_PERCENT2 | Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield. |
| EXEMPT_PERCENT3 | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. EXEMPT_PERCENT3 | Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield. |
| EXEMPT_PERCENT4 | TAX_EXEMPTIONS | RA_TAX_EXEMPTIONS_ALL. EXEMPT_PERCENT4 | Percentage of the exemption to apply to this portion of the Sales Tax Location Flexfield. |
| RECEIPT_METHODS | DATAAREA | Various Receipt Methods | - |
| CUST_RECEIPT_METHOD _ID |
RECEIPT_METHODS | RA_CUST_RECEIPT_METHODS.CUST_RECEIPT_METHOD_ID | Uniquely identifies the customer receipt method. |
| RECEIPT_METHOD_ID | RECEIPT_METHODS | RA_CUST_RECEIPT_METHODS.RECEIPT_METHOD_ID | Identifies the receipt method identifier. |
| RECEIPT_METHOD_NAME | RECEIPT_METHODS | AR_RECEIPT_METHODS. RECEIPT_METHOD_NAME | Receipt Method Name |
| PRIMARY_FLAG | RECEIPT_METHODS | RA_CUST_RECEIPT_METHODS.PRIMARY_FLAG | Indicates if customer receipt method is primary. |
| DATETIME | RECEIPT_METHODS | RA_CUST_RECEIPT_METHODS.START_DATE | Start date of the customer receipt methods |
| DATETIME | RECEIPT_METHODS | RA_CUST_RECEIPT_METHODS.END_DATE | End date of the customer receipt methods |
| CUSTOMER_INFO | DATAAREA | Customer Personal Information | - |
| PARTY_NUMBER | CUSTOMER_INFO | HZ_PARTIES.PARTY_NUMBER | Unique identification number for the customer |
| PARTY_NAME | CUSTOMER_INFO | HZ_PARTIES.PARTY_NAME | Customer Name |
| PARTY_TYPE | CUSTOMER_INFO | HZ_PARTIES.PARTY_TYPE | The party type can only be Person, Organization, Group or Relationship. |
| TAX_REFERENCE | CUSTOMER_INFO | HZ_PARTIES.TAX_REFERENCE | Taxpayer registration number, also known as the VAT number. |
| JGZZ_FISCAL_CODE | CUSTOMER_INFO | HZ_PARTIES.JGZZ_FISCAL_CODE | Taxpayer identification number, a unique identifier of person or organization. This can be: SSN or income taxpayer ID in the US, fiscal code or NIF in Europe. |
| EMAIL_ADDRESS | CUSTOMER_INFO | HZ_PARTIES.EMAIL_ADDRESS | Email Address |
| CUSTOMER_NAME | CUSTOMER_INFO | Name of the Customer | - |
| PERSON_IDENTIFIER | CUSTOMER_NAME | HZ_PARTIES.PERSON_IDENTIFIER | Personal identifier, such as driver's license or passport number. |
| PERSON_TITLE | CUSTOMER_NAME | HZ_PARTIES.PERSON_TITLE | A professional or family title. For example, Don or The Right Honorable. |
| PERSON_PRE_NAME_ ADJUNCT |
CUSTOMER_NAME | HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT | Salutary introduction, such as Mr. or Herr. |
| PERSON_FIRST_NAME | CUSTOMER_NAME | HZ_PARTIES.PERSON_FIRST_NAME | First name of the person |
| PERSON_MIDDLE_ NAME |
CUSTOMER_NAME | HZ_PARTIES.PERSON_MIDDLE_NAME | Middle name of the person |
| PERSON_LAST_NAME | CUSTOMER_NAME | HZ_PARTIES.PERSON_LAST_NAME | Last or surname of the person |
| PERSON_NAME_SUFFIX | CUSTOMER_NAME | HZ_PARTIES.PERSON_NAME_SUFFIX | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. |
| SALUTATION | CUSTOMER_INFO | HZ_PARTIES.SALUTATION | Phrase used to address a party in any correspondence. |
| ADDRESS | CUSTOMER_INFO | Identifying Address | - |
| ADDRLINE | ADDRESS | CONTACT( HZ_PARTIES.ADDRESS1; HZ_PARTIES.ADDRESS2; HZ_PARTIES.ADDRESS3; HZ_PARTIES.ADDRESS4) |
Identifying Address Line of the Customer |
| CITY | ADDRESS | HZ_PARTIES.CITY | City |
| COUNTRY | ADDRESS | HZ_PARTIES.COUNTRY | Country |
| COUNTY | ADDRESS | HZ_PARTIES.COUNTY | County |
| STATEPROVN | ADDRESS | HZ_PARTIES.STATE | State |
| POSTALCODE | ADDRESS | HZ_PARTIES.POSTAL_CODE | Postal code |
| CUSTOMER_EXT_ATTRIBUTES | CUSTOMER_INFO | Customer Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | CUSTOMER_EXT_ ATTRIBUTES |
HZ_PARTIES.ATTRIBUTE1 to HZ_PARTIES.ATTRIBUTE15 | Descriptive Flexfield segment for Customer |
| RELATIONSHIP_INFO | CUSTOMER_INFO | Customer Relationship Information | -- |
| PARENT_PARTY_ID | RELATIONSHIP_INFO | HZ_PARTIES.PARTY_ID | Parent Customer Id |
| PARENT_PARTY_NAME | RELATIONSHIP_INFO | HZ_PARTIES.PARTY_NAME | Parent Customer Name |
| PARENT_RELATIONSHIP_TYPE | RELATIONSHIP_INFO | HZ_RELATIONSHIPS. RELATIONSHIP_CODE | Either a forward or a backward relationship code |
| DATETIME | RELATIONSHIP_INFO | HZ_RELATIONSHIPS.END_DATE | Date relationship ends |
| CUSTOMER_CONTACT_INFO | CUSTOMER_INFO | Customer Contact Information | - |
| CONTACT_POINT_ID | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.CONTACT_POINT_TYPE | Identifier for the customer contact point. |
| CONTACT_POINT_TYPE | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.CONTACT_POINT_TYPE | Lookup: CONTACT_POINT_TYPE of phone, fax, e-mail, web, telex, or EDI |
| PRIMARY | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.PRIMARY_FLAG | Flag to Identify the Primary Contact Information. |
| EDI_TRANSACTION _HANDLING |
CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.EDI_TRANSACTION_HANDLING | ANSI standard code for EDI transaction type |
| EDI_ID_NUMBER | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.EDI_ID_NUMBER | EDI trading partner number for the supplier site |
| EDI_PAYMENT_METHOD | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.EDI_PAYMENT_METHOD | Indicates how a payment is to be made through EDI. Valid methods are ACH and BOP. |
| EDI_PAYMENT_FORMAT | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.EDI_PAYMENT_FORMAT | Indicates type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CHZ, CTX, PPD, and PPP. |
| EMAIL_ADDRESS | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.EMAIL_ADDRESS | E-mail address of the contact point |
| URL | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.URL | Uniform resource locator |
| PHONE_LINE_TYPE | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.PHONE_LINE_TYPE | Lookup code for the type of phone line. For example, general, fax, inbound, or outbound. |
| PHONE_NUMBER | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.PHONE_NUMBER | A telephone number formatted in the local format. The number should not include area code, country code, or extension |
| PHONE_COUNTRY_CODE | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE | International country code for a telephone number. For example, 33 for France. |
| PHONE_AREA_CODE | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.PHONE_AREA_CODE | The area code within a country code. |
| PHONE_EXTENSION | CUSTOMER_CONTACT _INFO |
HZ_CONTACT_POINTS.PHONE_AREA_CODE | - |
| PARTY_GROUP | CUSTOMER_CONTACT _INFO |
Party Group Code | - |
| GROUP | PARTY_GROUP | AST_PARTY_CLASSIFICATION_V.CLASS_CODE | Classification code |
| BANK_ACCOUNT_INFO | DATAAREA | Bank Account Information | - |
| BANK_ACCOUNT _NUMBER |
BANK_ACCOUNT_INFO | IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM | Bank Account Number |
| BANK_ACCOUNT_NAME | BANK_ACCOUNT_INFO | IBY_EXT_BANK_ACCOUNTS. BANK_ACCOUNT_NAME | Bank Account Name |
| BANK_BRANCH_ID | BANK_ACCOUNT_INFO | IBY_EXT_BANK_ACCOUNTS. BRANCH_ID | Bank Branch Identifier |
| CURRENCY_CODE | BANK_ACCOUNT_INFO | IBY_EXT_BANK_ACCOUNTS. CURRENCY_CODE | Currency Code |
| ACCOUNT_HOLDER _NAME |
BANK_ACCOUNT_INFO | HZ_PARTIES. PARTY_NAME | Account Holder Name |
| DATETIME | BANK_ACCOUNT_INFO | IBY_PMT_INSTR_USES_ALL. END_DATE | Inactive Date |
| BANK_NUMBER | BANK_ACCOUNT_INFO | HZ_ORGANIZATION_PROFILES. BANK_OR_BRANCH_NUMBER | Bank Number |
| ADDRESS | DATAAREA | Bill To Address | - |
| ADDRLINE | ADDRESS | CONTACT( HZ_LOCATIONS.ADDRESS1;HZ_LOCATIONS.ADDRESS2;HZ_LOCATIONS.ADDRESS3;HZ_LOCATIONS. ADDRESS4) |
Bill To Address Line of the Account |
| CITY | ADDRESS | HZ_LOCATIONS.CITY | City |
| COUNTRY | ADDRESS | HZ_LOCATIONS.COUNTRY | Country |
| COUNTY | ADDRESS | HZ_LOCATIONS.COUNTY | County |
| STATEPROVN | ADDRESS | HZ_LOCATIONS.STATE | State |
| POSTALCODE | ADDRESS | HZ_LOCATIONS. POSTAL_CODE |
Postalcode |
| CUST_PROFILE_AMTS_INFO | DATAAREA | Customer Profile Amounts Information | - |
| CUST_ACCT_PROFILE_AMT_ID | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. CUST_ACCT_PROFILE_AMT_ID | Profile Amount Identifier |
| CURRENCY_CODE | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. CURRENCY_CODE | Currency code |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. TRX_CREDIT_LIMIT | Transaction Credit Limit |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. OVERALL_CREDIT_LIMIT | Over All Credit limit |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. MIN_DUNNING_AMOUNT | Minimum dunning amount |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. MIN_DUNNING_INVOICE_AMOUNT | Minimum invoice amount |
| MAX_INTEREST_CHARGE | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. MAX_INTEREST_CHARGE | Maximum interest charge |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. MIN_STATEMENT_AMOUNT | Minimum statement amount |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. AUTO_REC_MIN_RECEIPT_AMOUNT | Minimum receipt amount |
| INTEREST_RATE | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. INTEREST_RATE | Interest rate |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. MIN_FC_BALANCE_AMOUNT | Minimum balance amount |
| AMOUNT | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. MIN_FC_INVOICE_AMOUNT | Minimum invoice amount |
| DATETIME | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. EXPIRATION_DATE | Expiration date |
| ATTRIBUTE_CATEGORY | CUST_PROFILE_AMTS_INFO | HZ_CUST_PROFILE_AMTS. ATTRIBUTE_CATEGORY | Attribute category |
| PROFILE_AMTS_EXTENDED_ATTRIBUTES | CUST_PROFILE_AMTS_INFO | Profile Amounts Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | PROFILE_AMTS_EXTENDED_ATTRIBUTES | HZ_CUST_PROFILE_AMTS. ATTRIBUTE1 to ATTRIBUTE15 | Extended Attributes |
| CREDIT_CLASSIFICATION_INFO | DATAAREA | Credit classification information | - |
| CUST_ACCOUNT_PROFILE_ID | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. CUST_ACCOUNT_PROFILE_ID | Credit Classification identifier |
| CREDIT_CHECKING | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. CREDIT_CHECKING | Credit checking flag |
| DATETIME | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. NEXT_CREDIT_REVIEW_DATE | Next credit review date |
| TOLERANCE | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. TOLERANCE | Tolerance |
| CREDIT_HOLD | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. CREDIT_HOLD | Credit hold flag |
| CREDIT_RATING | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. CREDIT_RATING | Credit rating |
| STANDARD_TERMS | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. STANDARD_TERMS | Standard terms |
| OVERRIDE_TERMS | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. OVERRIDE_TERMS | Override terms |
| DATETIME | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. LAST_CREDIT_REVIEW_DATE | Last credit review date |
| CREDIT_CLASSIFICATION | CREDIT_CLASSIFICATION_INFO | HZ_CUSTOMER_PROFILES. CREDIT_CLASSIFICATION | Credit classification |
| CREDIT_EXTENDED_ATTRIBUTES | CREDIT_CLASSIFICATION_INFO | Credit classification extended attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | CREDIT_EXTENDED_ATTRIBUTES | HZ_CUSTOMER_PROFILES. ATTRIBUTE1 to ATTRIBUTE15 | Extended attributes |
The following table lists the specifications for sales order line information.
| XML TagT | XML Parent Tag | Field in E-Business Suite | Description |
| ORDER_LINE_INFO | DATAAREA | Sales order line information | - |
| ORDER_LINE_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. LINE_ID |
Primary Key to identify the Order Line |
| TOP_MODEL_LINE_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. TOP_MODEL_LINE_ID |
Identifier of configuration top parent line |
| LINK_TO_LINE_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. LINK_TO_LINE_ID |
Identifier of immediate parent component line |
| ORDER_NUMBER | ORDER_HEADER_INFO | OE_ORDER_HEADERS_ALL.ORDER_NUMBER | Unique Identifier for Order |
| SOLD_TO_PARTY_ NUMBER |
ORDER_HEADER_INFO | HZ_PARTIES. PARTY_NUMBER |
Unique Identifier for Customer |
| SOLD_TO_ PARTY_NAME | ORDER_HEADER_INFO | HZ_PARTIES.PARTY_NAME | Customer Name |
| SOLD_TO_ACCOUNT_ NUMBER |
ORDER_HEADER_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NUMBER |
Unique Identifier for Account |
| SOLD_TO_ACCOUNT_ NAME |
ORDER_HEADER_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NAME |
Account Name |
| PRICE_LIST_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. PRICE_LIST_ID |
Price List |
| PRICE_LIST_NAME | ORDER_LINE_INFO | QP_LIST_HEADERS_VL.DESCRIPTION | Price List Name used to identify the Price List Name |
| INVENTORY_ITEM_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. INVENTORY_ITEM_ID |
Inventory Item Id |
| INVENTORY_ITEM_NAME | ORDER_LINE_INFO | MTL_SYSTEM_ITEMS_VL.SEGMENT1 | Name of the Product |
| INVENTORY_ITEM_DESCRIPTION | ORDER_LINE_INFO | MTL_SYSTEM_ITEMS_VL.DESCRIPTION | Description of the Product |
| ORG_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. ORG_ID |
Operating Unit which performed this transaction |
| DATETIME | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. PRICING_DATE |
Determines effective list and price modifiers |
| UNIT_SELLING_PRICE | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. UNIT_SELLING_PRICE |
Actual price charged to customer |
| UNIT_LIST_PRICE | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. UNIT_LIST_PRICE |
Price List price for the item |
| QUANTITY | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. ORDERED_QUANTITY |
Quantity Ordered |
| QUANTITY | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. PRICING_QUANTITY |
Quantity based on pricing unit of measure |
| INVOICE_TO_ORG_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. INVOICE_TO_ORG_ID |
Invoice To Organization ID |
| SHIP_TO_ORG_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. SHIP_TO_ORG_ID |
Ship To Organization ID |
| ACTION | ORDER_LINE_INFO | OE_TRANSACTION_TYPES_TL.ACTION | Type of Service performed on the Order |
| CURRENCY_CODE | ORDER_LINE_INFO | QP_LIST_HEADERS_VL.CURRENCY_CODE | Currency Code |
| CHARGE_PERIODICITY_CODE | ORDER_LINE_INFO | OE_ORDER_LINES_ALL.CHARGE_PERIODICITY_CODE | Charge Periodicity Code |
| CHARGE_PERIODICITY_CODE_DESC | ORDER_LINE_INFO | MTL_UOM_CONVERSIONS.UNIT_OF_MEASURE | Charge Periodicity Code Description |
| ADDRESS | ORDER_LINE_INFO | OE_ORDER_LINES_ALL .SHIP_TO_ORG_ID | Ship To Address |
| ADDRLINE | ADDRESS | CONCAT( HZ_LOCATIONS.ADDRESS1;HZ_LOCATIONS.ADDRESS2;HZ_LOCATIONS.ADDRESS3;HZ_LOCATIONS. ADDRESS4) |
Ship To Address Line of the Account |
| CITY | ADDRESS | HZ_LOCATIONS.CITY | City |
| COUNTRY | ADDRESS | HZ_LOCATIONS.COUNTRY | Country |
| COUNTY | ADDRESS | HZ_LOCATIONS.COUNTY | County |
| STATEPROVN | ADDRESS | HZ_LOCATIONS.STATE | State |
| POSTALCODE | ADDRESS | HZ_LOCATIONS. POSTAL_CODE |
Postalcode |
| TAX_INFO | ORDER_LINE_INFO | Tax Information | - |
| TAX_CODE | TAX_INFO | OE_ORDER_LINES_ALL. TAX_CODE |
Tax code for the line |
| TAX_RATE | TAX_INFO | OE_ORDER_LINES_ALL. TAX_RATE |
Tax rate in percentage |
| DATETIME | TAX_INFO | OE_ORDER_LINES_ALL. TAX_DATE |
Date for tax calculation |
| AMOUNT | TAX_INFO | OE_ORDER_LINES_ALL. TAX_VALUE |
Tax amount in order currency |
| PAYMENT_TERM_INFO | ORDER_LINE_INFO | Payment term Information | - |
| PAYMENT_TERM_ID | PAYMENT_TERM_INFO | OE_ORDER_LINES_ALL.PAYMENT_TERM_ID | Payment Term Identifier |
| PAYMENT_TERM_NAME | PAYMENT_TERM_INFO | RA_TERMS_VL.NAME | Payment Term Name |
| DESCRIPTION | PAYMENT_TERM_INFO | RA_TERMS_VL.DESCRIPTION | Payment Term Description |
| EXT_ATTRIBUTES | ORDER_LINE_INFO | Order Line Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | EXT_ATTRIBUTES | OE_ORDER_LINES_ALL. ATTRIBUTE1 to ATTRIBUTE15 |
Descriptive Flexfield segments for Order Line |
| INSTALL_BASE_INFO | DATAAREA | INSTALL_BASE_INFO | - |
| INSTANCE_ID | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTANCE_ID |
Unique ID that identifies an item unit instance |
| INSTANCE_NAME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES.INSTANCE_DESCRIPTION | Used to describe the Instance Id |
| DATETIME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTALL_DATE |
Installation Date for an Instance. |
| DATETIME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. ACTIVE_START_DATE |
Activation Start Date |
| DATETIME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. ACTIVE_END_DATE |
Activation End Date |
| QUANTITY | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. QUANTITY |
Quantity |
| INSTALL_LOCATION_ID | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTALL_LOCATION_ID |
Install Location Identifier |
| LAST_OE_ORDER_LINE_ID | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. LAST_OE_ORDER_LINE_ ID |
Last Order Line Identifier that touched the instance |
| ADDRESS | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTALL_AT_ADDRESS |
Install At Address |
| ATTRIBUTE_VALUES | INSTALL_BASE_INFO | Attribute Value Pairs of Install Base | - |
| ATTRIBUTE_INFO | ATTRIBUTE_VALUES | Attribute Information | - |
| ATTRIBUTE_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_ID | Attribute Identifier |
| ATTRIBUTE_LEVEL | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_LEVEL | Attribute Level |
| MASTER_ORGANIZATION_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.MASTER_ORGANIZATION_ID | Master Organization Identifier |
| INVENTORY_ITEM_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.INVENTORY_ITEM_ID | Inventory Item Identifier |
| ITEM_CATEGORY_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ITEM_CATEGORY_ID | Item Category Identifier |
| ATTRIBUTE_CODE | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_CODE | Attribute Code |
| ATTRIBUTE_NAME | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_NAME | Attribute Name |
| ATTRIBUTE_CATEGORY | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_CATEGORY | Attribute Category |
| DESCRIPTION | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.DESCRIPTION | Description |
| ACTIVE_START_DATE | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ACTIVE_START_DATE | Activation Start Date |
| ACTIVE_END_DATE | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ACTIVE_END_DATE | Activation End Date |
| SECURITY_GROUP_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.SECURITY_GROUP_ID | Security Group Identifier |
| VALUE_INFO | ATTRIBUTE_VALUES | Value Information | - |
| ATTRIBUTE_VALUE_ID | VALUE_INFO | CSI_IEA_VALUES.ATTRIBUTE_VALUE_ID | Instance Extended Attribute Value Identifier. |
| ATTRIBUTE_VALUE | VALUE_INFO | CSI_IEA_VALUES.ATTRIBUTE_VALUE | Instance Extended Attribute Value. |
| ACTIVE_START_DATE | VALUE_INFO | CSI_IEA_VALUES.ACTIVE_START_DATE | Activation Start Date |
| ACTIVE_END_DATE | VALUE_INFO | CSI_IEA_VALUES.ACTIVE_END_DATE | Activation End Date |
| BILL_TO_PARTY_INFO | DATAAREA | BILL_TO_PARTY_INFO | - |
| BILL_TO_OWNER_FLAG | BILL_TO_PARTY_INFO | HZ_PARTIES.BILL_TO_OWNER_FLAG | Bill To Owner Flag |
| PRIMARY_BILL_TO_FLAG | BILL_TO_PARTY_INFO | HZ_PARTIES.PRIMARY_BILL_TO_FLAG | Primary Bill To Flag |
| BILL_TO_PARTY_NUMBER | BILL_TO_PARTY_INFO | HZ_PARTIES.PARTY_NUMBER | Unique Identifier of the Customer |
| BILL_TO_PARTY_NAME | BILL_TO_PARTY_INFO | HZ_PARTIES.PARTY_NAME | Customer Name |
| BILL_TO_ACCOUNT_NUMBER | BILL_TO_PARTY_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NUMBER |
Unique Identifier of the Account |
| BILL_TO_ACCOUNT_NAME | BILL_TO_PARTY_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NAME |
Account Name |
| ADDRESS | BILL_TO_PARTY_INFO | Bill To Address | - |
| ADDRLINE | ADDRESS | CONCAT( HZ_LOCATIONS.ADDRESS1;HZ_LOCATIONS.ADDRESS2;HZ_LOCATIONS.ADDRESS3;HZ_LOCATIONS. ADDRESS4) |
Bill To Address Line of the Account |
| CITY | ADDRESS | HZ_LOCATIONS.CITY | City |
| COUNTRY | ADDRESS | HZ_LOCATIONS.COUNTRY | Country |
| COUNTY | ADDRESS | HZ_LOCATIONS.COUNTY | County |
| STATEPROVN | ADDRESS | HZ_LOCATIONS.STATE | State |
| POSTALCODE | ADDRESS | HZ_LOCATIONS. POSTAL_CODE |
Postal code |
| PARTY_EXT_ATTRIBUTES | BILL_TO_PARTY_INFO | Party Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | PARTY_EXT_ATTRIBUTES | HZ_PARTIES.ATTRIBUTE1 to HZ_PARTIES.ATTRIBUTE15 | Descriptive Flexfield segment for Customer |
| ACCOUNT_EXT_ATTRIBUTES | BILL_TO_PARTY_INFO | Account Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | ACCOUNT_EXT_ATTRIBUTES | HZ_CUST_ACCOUNTS. ATTRIBUTE1 to ATTRIBUTE15 |
Descriptive Flexfield segment for Account |
| SHIP_TO_CONTACT_INFO | DATAAREA | Ship to Contact Information | - |
| CONTACT_NAME | SHIP_TO_CONTACT_INFO | Ship to Contact Name | - |
| PERSON_IDENTIFIER | CONTACT_NAME | HZ_PARTIES.PERSON_IDENTIFIER | Person Identifier |
| PERSON_TITLE | CONTACT_NAME | HZ_PARTIES.PERSON_TITLE | Title |
| PERSON_PRE_NAME_ADJUNCT | CONTACT_NAME | HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT | Pre Name Adjunct |
| PERSON_MIDDLE_NAME | CONTACT_NAME | HZ_PARTIES.PERSON_MIDDLE_NAME | Middle Name |
| PERSON_LAST_NAME | CONTACT_NAME | HZ_PARTIES.PERSON_LAST_NAME | Last Name |
| PERSON_NAME_SUFFIX | CONTACT_NAME | HZ_PARTIES.PERSON_NAME_SUFFIX | Suffix |
| SALUTATION | SHIP_TO_CONTACT_INFO | HZ_PARTIES.SALUTATION | Salutation |
| CONTACT_INFO | SHIP_TO_CONTACT_INFO | Ship to Contact Information | - |
| CONTACT_POINT_TYPE | CONTACT_INFO | HZ_CONTACT_POINTS.CONTACT_POINT_TYPE | Contact Point Type |
| EMAIL_ADDRESS | CONTACT_INFO | HZ_CONTACT_POINTS.EMAIL_ADDRESS | Email Address |
| PHONE_LINE_TYPE | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_LINE_TYPE | Phone Purpose |
| PHONE_COUNTRY_CODE | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE | Country Code |
| PHONE_AREA_CODE | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_AREA_CODE | Area Code |
| PHONE_NUMBER | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_NUMBER | Phone Number |
| PHONE_EXTENSION | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_EXTENSION | Extension |
| URL | CONTACT_INFO | HZ_CONTACT_POINTS.URL | Url |
The following table lists the specifications for product.
| XML Tag | Parent Component | Field in E-Business Suite | Description |
| ITEM_INFO | DATAAREA | Item Information | - |
| ITEMID | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. INVENTORY_ITEM_ID | EBS Inventory Item Identifier |
| ITEM_NAME | ITEM_INFO | MTL_SYSTEM_ITEMS_VL.SEGMENT1 | EBS Inventory item |
| ITEM_TYPE | ITEM_INFO | MTL_SYSTEM_ITEMS_VL.ITEM_TYPE | Inventory Item Type |
| ITEM_TYPE_DESC | ITEM_INFO | FND_LOOKUP_VALUES_VL.MEANING | Inventory Item Type Description |
| BOM_ITEM_TYPE | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. BOM_ITEM_TYPE | E-Business Suite BOM item type code. |
| BOM_ITYPE_DESC | ITEM_INFO | MFG_LOOKUPS.MEANING | E-Business Suite BOM item type description. |
| UOM | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. PRIMARY_UNIT_OF_MEASURE | Primary Unit of Measure for the item in inventory |
| ITEM_DESCRIPTION | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. DESCRIPTION | Item/ Product description |
| ITEM_STATUS | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. INVENTORY_ITEM_STATUS_CODE |
Inventory Item status code |
| ITEM_STATUS_DESC | ITEM_INFO | MTL_ITEM_STATUS.DESCRIPTION | Inventory Item status description |
| DATETIME | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. START_DATE_ACTIVE |
Start date for the item |
| DATETIME | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. END_DATE_ACTIVE |
End date for the item |
| ITEM_CLASS | ITEM_INFO | MTL_SYSTEM_ITEMS_VL. PRIMARY_UOM_CODE |
Derive from the UOM CLASS. As this is not stored in any entity and it is derived from UOM we need to know all the distinct values of UOM |
| ATTRIBUTE1 to ATTRIBUTE15 | ITEM_INFO | MTL_SYSTEM_ITEMS_VL.ATTRIBUTE1 to ATTRIBUTE15 | Descriptive Flexfield segment for Item |
The following table lists the message specifications for Group Sales Order Line.
| XML Tag | XML Parent tag | Field in E-Business Suite | Description |
| ORDER_HEADER_INFO | DATAAREA | Order Header Information | - |
| ORDER_NUMBER | ORDER_HEADER_INFO | OE_ORDER_HEADERS_ALL.ORDER_NUMBER | Unique Identifier for Order |
| SOLD_TO_ACCOUNT_ NUMBER |
ORDER_HEADER_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NUMBER |
Unique Identifier for Account |
| SOLD_TO_ACCOUNT_ NAME |
ORDER_HEADER_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NAME |
Account Name |
| SOLD_TO_PARTY_ NUMBER |
ORDER_HEADER_INFO | HZ_PARTIES. PARTY_NUMBER |
Unique Identifier for Customer |
| SOLD_TO_ PARTY_NAME | ORDER_HEADER_INFO | HZ_PARTIES.PARTY_NAME | Customer Name |
| ORDER_LINE | ORDER_HEADER_INFO | Salesorder Line Informations | - |
| ORDER_LINE_INFO | ORDER_LINE | Sales order line information | - |
| ORDER_LINE_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. LINE_ID |
Primary Key to Identify the Order Line |
| TOP_MODEL_LINE_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. TOP_MODEL_LINE_ID |
Identifier of configuration top parent line |
| LINK_TO_LINE_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. LINK_TO_LINE_ID |
Identifier of immediate parent component line |
| PRICE_LIST_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. PRICE_LIST_ID |
Price List |
| PRICE_LIST_NAME | ORDER_LINE_INFO | QP_LIST_HEADERS_VL.DESCRIPTION | Price List Name used to identify the Price List Name |
| INVENTORY_ITEM_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. INVENTORY_ITEM_ID |
Inventory Item Id |
| INVENTORY_ITEM_NAME | ORDER_LINE_INFO | MTL_SYSTEM_ITEMS_VL.SEGMENT1 | Name of the Product |
| INVENTORY_ITEM_DESCRIPTION | ORDER_LINE_INFO | MTL_SYSTEM_ITEMS_VL.DESCRIPTION | Description of the Product |
| ORG_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. ORG_ID |
Operating Unit which performed this transaction |
| DATETIME | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. PRICING_DATE |
Determines effective list and price modifiers |
| UNIT_SELLING_PRICE | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. UNIT_SELLING_PRICE |
Actual price charged to customer |
| UNIT_LIST_PRICE | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. UNIT_LIST_PRICE |
Price List price for the item |
| QUANTITY | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. ORDERED_QUANTITY |
Quantity Ordered |
| QUANTITY | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. PRICING_QUANTITY |
Quantity based on pricing unit of measure |
| INVOICE_TO_ORG_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. INVOICE_TO_ORG_ID |
Invoice To Organization ID |
| SHIP_TO_ORG_ID | ORDER_LINE_INFO | OE_ORDER_LINES_ALL. SHIP_TO_ORG_ID |
Ship To Organization ID |
| ACTION | ORDER_LINE_INFO | OE_TRANSACTION_TYPES_TL.ACTION | Type of Service performed on the Order |
| CURRENCY_CODE | ORDER_LINE_INFO | QP_LIST_HEADERS_VL.CURRENCY_CODE | Currency Code |
| CHARGE_PERIODICITY_CODE | ORDER_LINE_INFO | OE_ORDER_LINES_ALL.CHARGE_PERIODICITY_CODE | Charge Periodicity Code |
| CHARGE_PERIODICITY_CODE_DESC | ORDER_LINE_INFO | MTL_UOM_CONVERSIONS.UNIT_OF_MEASURE | Charge Periodicity Code Description |
| ADDRESS | ORDER_LINE_INFO | OE_ORDER_LINES_ALL .SHIP_TO_ORG_ID | Ship To Address |
| ADDRLINE | ADDRESS | CONCAT( HZ_LOCATIONS.ADDRESS1;HZ_LOCATIONS.ADDRESS2;HZ_LOCATIONS.ADDRESS3;HZ_LOCATIONS. ADDRESS4) |
Ship To Address Line of the Account |
| CITY | ADDRESS | HZ_LOCATIONS.CITY | City |
| COUNTRY | ADDRESS | HZ_LOCATIONS.COUNTRY | Country |
| COUNTY | ADDRESS | HZ_LOCATIONS.COUNTY | County |
| STATEPROVN | ADDRESS | HZ_LOCATIONS.STATE | State |
| POSTALCODE | ADDRESS | HZ_LOCATIONS. POSTAL_CODE |
Postalcode |
| TAX_INFO | ORDER_LINE_INFO | Tax Information | - |
| TAX_CODE | TAX_INFO | OE_ORDER_LINES_ALL. TAX_CODE |
Tax code for the line |
| TAX_RATE | TAX_INFO | OE_ORDER_LINES_ALL. TAX_RATE |
The tax rate in percentage |
| DATETIME | TAX_INFO | OE_ORDER_LINES_ALL. TAX_DATE |
It will store the date for tax calculation |
| AMOUNT | TAX_INFO | OE_ORDER_LINES_ALL. TAX_VALUE |
The Tax amount in order currency |
| PAYMENT_TERM_INFO | ORDER_LINE_INFO | Payment term Information | - |
| PAYMENT_TERM_ID | PAYMENT_TERM_INFO | OE_ORDER_LINES_ALL.PAYMENT_TERM_ID | Payment Term Identifier |
| PAYMENT_TERM_NAME | PAYMENT_TERM_INFO | RA_TERMS_VL.NAME | Payment Term Name |
| DESCRIPTION | PAYMENT_TERM_INFO | RA_TERMS_VL.DESCRIPTION | Payment Term Description |
| EXT_ATTRIBUTES | ORDER_LINE_INFO | Order Line Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | EXT_ATTRIBUTES | OE_ORDER_LINES_ALL. ATTRIBUTE1 |
Descriptive Flexfield segment for Order Line |
| INSTALL_BASE_INFO | ORDER_LINE | INSTALL_BASE_INFO | - |
| INSTANCE_ID | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTANCE_ID |
Unique ID that identifies an item unit instance |
| INSTANCE_NAME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES.INSTANCE_DESCRIPTION | Used to describe the Instance Id |
| DATETIME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTALL_DATE |
Installation Date for an Instance. |
| DATETIME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. ACTIVE_START_DATE |
Activation Start Date |
| DATETIME | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. ACTIVE_END_DATE |
Activation End Date |
| QUANTITY | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. QUANTITY |
Quantity |
| INSTALL_LOCATION_ID | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTALL_LOCATION_ID |
Install Location Identifier |
| LAST_OE_ORDER_LINE_ID | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. LAST_OE_ORDER_LINE_ ID |
Last Order Line Identifier that touched the Instance |
| ADDRESS | INSTALL_BASE_INFO | CSI_ITEM_INSTANCES. INSTALL_AT_ADDRESS |
Install At Address |
| ATTRIBUTE_VALUES | INSTALL_BASE_INFO | Attribute Value Pairs of Install Base | - |
| ATTRIBUTE_INFO | ATTRIBUTE_VALUES | Attribute Information | - |
| ATTRIBUTE_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_ID | Attribute Identifier |
| ATTRIBUTE_LEVEL | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_LEVEL | Attribute Level |
| MASTER_ORGANIZATION_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.MASTER_ORGANIZATION_ID | Master Organization Identifier |
| INVENTORY_ITEM_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.INVENTORY_ITEM_ID | Inventory Item Identifier |
| ITEM_CATEGORY_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ITEM_CATEGORY_ID | Item Category Identifier |
| ATTRIBUTE_CODE | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_CODE | Attribute Code |
| ATTRIBUTE_NAME | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_NAME | Attribute Name |
| ATTRIBUTE_CATEGORY | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ATTRIBUTE_CATEGORY | Attribute Category |
| DESCRIPTION | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.DESCRIPTION | Description |
| ACTIVE_START_DATE | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ACTIVE_START_DATE | Activation Start Date |
| ACTIVE_END_DATE | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.ACTIVE_END_DATE | Activation End Date |
| SECURITY_GROUP_ID | ATTRIBUTE_INFO | CSI_I_EXTENDED_ATTRIBS.SECURITY_GROUP_ID | Security Group Identifier |
| VALUE_INFO | ATTRIBUTE_VALUES | Value Information | - |
| ATTRIBUTE_VALUE_ID | VALUE_INFO | CSI_IEA_VALUES.ATTRIBUTE_VALUE_ID | Instance Extended Attribute Value Identifier. |
| ATTRIBUTE_VALUE | VALUE_INFO | CSI_IEA_VALUES.ATTRIBUTE_VALUE | Instance Extended Attribute Value. |
| ACTIVE_START_DATE | VALUE_INFO | CSI_IEA_VALUES.ACTIVE_START_DATE | Activation Start Date |
| ACTIVE_END_DATE | VALUE_INFO | CSI_IEA_VALUES.ACTIVE_END_DATE | Activation End Date |
| BILL_TO_PARTY_INFO | ORDER_LINE | BILL_TO_PARTY_INFO | - |
| BILL_TO_OWNER_FLAG | BILL_TO_PARTY_INFO | HZ_PARTIES.BILL_TO_OWNER_FLAG | Bill To Owner Flag |
| PRIMARY_BILL_TO_FLAG | BILL_TO_PARTY_INFO | HZ_PARTIES.PRIMARY_BILL_TO_FLAG | Primary Bill To Flag |
| BILL_TO_PARTY_NUMBER | BILL_TO_PARTY_INFO | HZ_PARTIES.PARTY_NUMBER | Unique Identifier of the Customer |
| BILL_TO_PARTY_NAME | BILL_TO_PARTY_INFO | HZ_PARTIES.PARTY_NAME | Customer Name |
| BILL_TO_ACCOUNT_NUMBER | BILL_TO_PARTY_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NUMBER |
Unique Identifier of the Account |
| BILL_TO_ACCOUNT_NAME | BILL_TO_PARTY_INFO | HZ_CUST_ACCOUNTS. ACCOUNT_NAME |
Account Name |
| ADDRESS | BILL_TO_PARTY_INFO | Bill To Address | - |
| ADDRLINE | ADDRESS | CONCAT( HZ_LOCATIONS.ADDRESS1;HZ_LOCATIONS.ADDRESS2;HZ_LOCATIONS.ADDRESS3;HZ_LOCATIONS. ADDRESS4) |
Bill To Address Line of the Account |
| CITY | ADDRESS | HZ_LOCATIONS.CITY | City |
| COUNTRY | ADDRESS | HZ_LOCATIONS.COUNTRY | Country |
| COUNTY | ADDRESS | HZ_LOCATIONS.COUNTY | County |
| STATEPROVN | ADDRESS | HZ_LOCATIONS.STATE | State |
| POSTALCODE | ADDRESS | HZ_LOCATIONS. POSTAL_CODE |
Postalcode |
| PARTY_EXT_ATTRIBUTES | BILL_TO_PARTY_INFO | Party Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | PARTY_EXT_ATTRIBUTES | HZ_PARTIES.ATTRIBUTE1 to HZ_PARTIES.ATTRIBUTE15 | Descriptive Flexfield segment for Customer |
| ACCOUNT_EXT_ATTRIBUTES | BILL_TO_PARTY_INFO | Account Extended Attributes | - |
| ATTRIBUTE1 to ATTRIBUTE15 | ACCOUNT_EXT_ATTRIBUTES | HZ_CUST_ACCOUNTS. ATTRIBUTE1 to ATTRIBUTE15 |
Descriptive Flexfield segment for Account |
| SHIP_TO_CONTACT_INFO | ORDER_LINE | Ship to Contact Information | - |
| CONTACT_NAME | SHIP_TO_CONTACT_INFO | Ship to Contact Name | - |
| PERSON_IDENTIFIER | CONTACT_NAME | HZ_PARTIES.PERSON_IDENTIFIER | Person Identifier |
| PERSON_TITLE | CONTACT_NAME | HZ_PARTIES.PERSON_TITLE | Title |
| PERSON_PRE_NAME_ADJUNCT | CONTACT_NAME | HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT | Pre Name Adjunct |
| PERSON_MIDDLE_NAME | CONTACT_NAME | HZ_PARTIES.PERSON_MIDDLE_NAME | Middle Name |
| PERSON_LAST_NAME | CONTACT_NAME | HZ_PARTIES.PERSON_LAST_NAME | Last Name |
| PERSON_NAME_SUFFIX | CONTACT_NAME | HZ_PARTIES.PERSON_NAME_SUFFIX | Suffix |
| SALUTATION | SHIP_TO_CONTACT_INFO | HZ_PARTIES.SALUTATION | Salutation |
| CONTACT_INFO | SHIP_TO_CONTACT_INFO | Ship to Contact Information | - |
| CONTACT_POINT_TYPE | CONTACT_INFO | HZ_CONTACT_POINTS.CONTACT_POINT_TYPE | Contact Point Type |
| EMAIL_ADDRESS | CONTACT_INFO | HZ_CONTACT_POINTS.EMAIL_ADDRESS | Email Address |
| PHONE_LINE_TYPE | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_LINE_TYPE | Phone Purpose |
| PHONE_COUNTRY_CODE | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE | Country Code |
| PHONE_AREA_CODE | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_AREA_CODE | Area Code |
| PHONE_NUMBER | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_NUMBER | Phone Number |
| PHONE_EXTENSION | CONTACT_INFO | HZ_CONTACT_POINTS.PHONE_EXTENSION | Extension |
| URL | CONTACT_INFO | HZ_CONTACT_POINTS.URL | Url |