Skip Headers
JD Edwards EnterpriseOne Applications Real-Time Events Implementation Guide
Release 9.1

Part Number E15080-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Working with Application Real-Time Events

This chapter contains the following topics:

See Also:

2.1 Address Book

This section discusses the real-time events generated by the Address Book system.

2.1.1 RTABOUT

RTABOUT is a container event generated by the JD Edwards EnterpriseOne system to notify third-party systems about changes to the address book record. RTABOUT is a container event for RTABHDR, RTABPHOUT, and RTABEAOUT.

Event Name

RTABOUT

Event Description

AB

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTABHDR (D0100085A)

  • RTABPHOUT (D0100085B)

  • RTABEAOUT (D0100085C)

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for information about the event fields, conceptual approach, and processes that can this event.

2.1.1.1 Special Setup

RTABOUT has some additional special setup requirements due to the logic in the real-time wrapper.

The processing options for version ZJDE0001 of the Address Book Master Real Time Event Wrapper Application program (P0100085) determine which phone and email records are sent. The purpose of these processing options is to enable filtering of the outbound event, RTABOUT.

This table explains the processing options:

Configure Contact Information

Enter a code to specify how you want to send contact information. Values are:

0, blank, or null: The system sends only primary contact information for an address book record as single fields. It sends the first telephone number, fax number, and email address of an address book record that matches the type specified in the other processing options.

1: Regardless of the types specified in the other processing options, the system sends the complete collection of contact information, including primary contact information, for an address book record in one group.

2: The system sends primary contact information in single fields, and the complete collection of contact information in a group. This value is a combination of values 0 and 1.

Phone Number Type

Indicate either the location or use of a telephone number. Values are defined in user-defined code (UDC) table 01/PH (Phone Type).

Fax Number Type

Specify the phone type for the telephone number to use for faxes. Values are defined in UDC table 01/PH (Phone Type).

Electronic Address Type

Specify the electronic address type that the system uses for an individual or an entity for internet communications. Values are defined in UDC table 01/ET (Electronic Address Type).

2.1.2 RTABHDR

RTABHDR is a single event that provides address book header information within the RTABOUT container event. RTABHDR is generated only when RTABOUT is generated.

Event Name

RTABHDR

Event Description

AB Header

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100085A: Address Book Master Real Time

Event Relationship

Included in container event RTABOUT

2.1.2.1 Event Fields

The RTABHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Type
AN8 mnAddressNumber Numeric 8 Address Number
ALPH szNameAlpha String 40 Alpha Name
AT1 szSearchType String 3 Search Type
MCU szBusinessUnit String 12 Business Unit
PA8 mnParentNumber Numeric 8 Parent Number
MLNM szMailingName String 40 Mailing Name
ADD1 szAddressLine1 String 40 Address Line 1
ADD2 szAddressLine2 String 40 Address Line 2
ADD3 szAddressLine3 String 40 Address Line 3
ADD4 szAddressLine4 String 40 Address Line 4
CTY1 szCity String 25 City
COUN szCountyAddress String 25 County Address
ADDS szState String 3 State
ADDZ szZipCodePostal String 12 Zip Code
CTR szCountry String 3 Country
EMAL szEmail String 256 Email
RMK szNameRemark String 30 Name - Remark
EDUS szEdiUserId String 10 EDI - User ID
EDBT szEdiBatchNumber String 15 EDI - Batch Number
EDTN szEdiTransactNumber String 22 EDI - Transaction Number
EDLN mnEdiLineNumber Numeric 7 EDI - Line Number
EDCT szEdiDocumentType String 2 EDI - Document Type
TYTN szTypeTransaction String 8 Type - Transaction
EDFT szEdiTranslationFormat String 10 EDI - Translation Format
EDDT jdEdiTransmissionDate Date 6 EDI - Transmission Date
DRIN cDirectionIndicator Char 1 Direction Indicator
EDDL mnEdiDetailLinesProcess Numeric 5 EDI - Detail Lines Processed
EDSP cEdiSuccessfullyProcess Char 1 EDI - Successfully Processed
PNID szTradingPartnerId String 15 Trading Partner ID
TNAC szTransactionAction String 2 Transaction Action
ALKY szAlternateAddressKey String 20 Long Address Number
TAX szTaxId String 20 Tax ID
DC szDescripCompressed String 40 Description - Compressed
SIC szStandardIndustryCode String 10 Industry Classification Code
LNGP szLanguagePreference String 2 Language
CM szCreditMessage String 2 Credit Message
TAXC cPersonCorporationCode Char 1 Person/Corporation Code
AT2 cAddressType2 Char 1 AR/AP Netting Indicator
AT3 cAddressType3 Char 1 HRM Records Exist
AT4 cAddressType4 Char 1 Address Type - 4
ATR cAddressTypeReceivables Char 1 Address Type - Receivables
AT5 cAddressType5 Char 1 Address Type - 5
ATP cAddressTypePayables Char 1 Address Type - Payables
ATPR cAddTypeCode4Purch Char 1 Address Type - Code, Purchaser
AB3 cMiscCode3 Char 1 Address Book - MiscellaneousCode(future)
ATE cAddressTypeEmployee Char 1 Address Type - Employee
SBLI cSubledgerInactiveCode Char 1 Subledger Inactive Code
EFTB jdDateBeginningEffective Date 6 Date - Beginning Effective
AN81 mnAddressNumber1st Numeric 8 Address Number - 1st
AN82 mnAddressNumber2nd Numeric 8 Address Number - 2nd
AN83 mnAddressNumber3rd Numeric 8 Address Number - 3rd
AN84 mnAddressNumber4th Numeric 8 Address Number - 4th
AN86 mnAddressNumber6th Numeric 8 Address Number - 5th
AN85 mnAddressNumber5th Numeric 8 Factor/Special Payee
AC01 szReportCodeAddBook001 String 3 Category Code - Address Book 01
AC02 szReportCodeAddBook002 String 3 Category Code - Address Book 02
AC03 szReportCodeAddBook003 String 3 Category Code - Address Book 03
AC04 szReportCodeAddBook004 String 3 Category Code - Address Book 04
AC05 szReportCodeAddBook005 String 3 Category Code - Address Book 05
AC06 szReportCodeAddBook006 String 3 Category Code - Address Book 06
AC07 szReportCodeAddBook007 String 3 Category Code - Address Book 07
AC08 szReportCodeAddBook008 String 3 Category Code - Address Book 08
AC09 szReportCodeAddBook009 String 3 Category Code - Address Book 09
AC10 szReportCodeAddBook010 String 3 Category Code - Address Book 10
AC11 szReportCodeAddBook011 String 3 Sales Region
AC12 szReportCodeAddBook012 String 3 Category Code - Address Book 12
AC13 szReportCodeAddBook013 String 3 Category Code - Address Book 13
AC14 szReportCodeAddBook014 String 3 Category Code - Address Book 14
AC15 szReportCodeAddBook015 String 3 Category Code - Address Book 15
AC16 szReportCodeAddBook016 String 3 Category Code - Address Book 16
AC17 szReportCodeAddBook017 String 3 Category Code - Address Book 17
AC18 szReportCodeAddBook018 String 3 Category Code - Address Book 18
AC19 szReportCodeAddBook019 String 3 Category Code - Address Book 19
AC20 szReportCodeAddBook020 String 3 Category Code - Address Book 20
AC21 szCategoryCodeAddressBook2 String 3 Category Code - Address Book 21
AC22 szCategoryCodeAddressBk22 String 3 Category Code - Address Book 22
AC23 szCategoryCodeAddressBk23 String 3 Category Code - Address Book 23
AC24 szCategoryCodeAddressBk24 String 3 Category Code - Address Book 24
AC25 szCategoryCodeAddressBk25 String 3 Category Code - Address Book 25
AC26 szCategoryCodeAddressBk26 String 3 Category Code - Address Book 26
AC27 szCategoryCodeAddressBk27 String 3 Category Code - Address Book 27
AC28 szCategoryCodeAddressBk28 String 3 Category Code - Address Book 28
AC29 szCategoryCodeAddressBk29 String 3 Category Code - Address Book 29
AC30 szCategoryCodeAddressBk30 String 3 Category Code - Address Book 30
GLBA szGlBankAccount String 8 G/L Bank Account
PTI mnTimeScheduledIn Numeric 6 Time - Scheduled In
PDI jdDateScheduledIn Date 6 Date - Scheduled In
MSGA cActionMessageControl Char 1 Action - Message Control
TXCT szCertificateTaxExempt String 20 Certificate, Tax Exemption
TX2 szTaxId2 String 20 Tax ID - Additional - Individual
ALP1 szKanjialpha String 40 Secondary Alpha Name
URCD szUserReservedCode String 2 User Reserved Code
URDT jdUserReservedDate Date 6 User Reserved Date
URAT mnUserReservedAmount Numeric 15 User Reserved Amount
URAB mnUserReservedNumber Numeric 8 User Reserved Number
URRF szUserReservedReference String 15 User Reserved Reference
MLN1 szSecondaryMailingName String 40 Secondary Mailing Name
AR2 szPhoneAreaCode2 String 6 Phone Prefix 2
PH2 szPhoneNumber1 String 20 Phone Number 2
PHT2 szPhoneNumberTyp2 String 4 Phone Number Type 2
TORG szTransactionOriginator String 10 Transaction Originator
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
JOBN szWorkStationId String 10 Work Station ID
UPMJ jdDateUpdated Date 6 Date - Updated
TDAY mnTimeOfDay Numeric 6 Time of Day
UPMT mnTimeLastUpdated Numeric 6 Time - Last Updated
AR1 szPhoneAreaCode1 String 6 Phone Prefix
PH1 szPhoneNumber String 20 Phone Number
PHT1 szPhoneNumberTyp1 String 20 Phone Number Type 1
ATTL SzContactTitle String 40 Professional Title

2.1.2.2 Conceptual Approach

An address book record added, modified, or deleted in the JD Edwards EnterpriseOne system creates, modifies, or deletes a record in the Address Book tables (Address Book Master, F0101; Address Book - Who's Who, F0111; Contact Information, F01111; Address Book - Contact Phone Numbers F0115; Electronic Address, F01151; Address by Date, F0116).

2.1.2.3 Objects that Can Initiate the Event

These objects can initiate the RTABHDR event:

  • N0100041 - Address Book MBF

  • P0111 - Who's Who application

  • P0115 - Phone application

  • P01111 - Contact Information E-mail application

  • B0100085 - Address Book Master Real-Time Event Notification Function

  • B0100073 - Electronic Address - Phones

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.1.3 RTABPHOUT

RTABPHOUT is a single event that provides address book phone information within the RTABOUT container event. RTABPHOUT is generated only when RTABOUT is generated.

Event Name

RTABPHOUT

Event Description

AB Phone

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100085B: Address Book Master Phones Wrapper Data Structure

Event Relationship

Included in container event RTABOUT.

2.1.3.1 Event Fields

The RTABPHOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
PHTP szPhoneNumberType String 4 Phone Number Type
AR1 szPhoneAreaCode1 String 6 Phone Prefix
PH1 szPhoneNumber String 20 Phone Number
AN8 mnAddressNumber Numeric 8 Address Number
IDLN mnLineNumberID Numeric 5 Who's Who Line Number - ID
RCK7 mnSequenceNumber70 Numeric 5 Line Number ID
CNLN mnContactID Numeric 5 Contact Line Number

2.1.3.2 Conceptual Approach

An address book phone record added, modified, or deleted in the JD Edwards EnterpriseOne system creates, updates, or deletes a record in the Address Book - Contact Phone Numbers (F0115).

2.1.3.3 Objects that Can Initiate the Event

These objects can initiate the RTABPHOUT event:

  • N0100041 - Address Book MBF

  • P0115 - Phone application

  • B0100085 - Address Book Master Real Time Event Notification Function

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.1.4 RTABEAOUT

RTABEAOUT is a single event that provides address book email information within the RTABOUT container event. RTABEAOUT is generated only when RTABOUT is generated.

Event Name

RTABEAOUT

Event Description

AB EA

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100085C: Address Book Master Email Wrapper Data Structure

Event Relationship

Included in container event RTABOUT.

2.1.4.1 Event Fields

The RTABEAOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 Address Number
IDLN mnLineNumberID Numeric 5 Who's Who Line Number - ID
ETP szElectronicAddressType String 4 Electronic Address Type
EMAL szEmailAddressow String 256 Email Address
RCK7 mnSequenceNumber70 Numeric 5 Line Number ID

2.1.4.2 Conceptual Approach

An address book email record added, modified, or deleted in the JD Edwards EnterpriseOne system creates a new record in the Electronic Address (F01151) table.

2.1.4.3 Objects that Can Initiate the Event

These objects can initiate the RTABEAOUT event:

  • N0100041 - Address Book MBF

  • P01111 - Contact Information E-mail application

  • B0100085 - Address Book Master Real-Time Event notification function

  • B0100089 - Electronic Address MBF

2.1.5 RTABOUT2

RTABOUT2 is a container event generated by the JD Edwards EnterpriseOne system to notify third-party systems about changes to the address book record. RTABOUT is a container event for RTABHDR2, RTABPHOUT2, and RTABEAOUT2.

Event Name

RTABOUT2

Event Description

AB

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTABHDR2 (D0100100A)

  • RTABPHOUT2 (D0100100B)

  • RTABEAOUT2 (D0100100C)

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for information about the event fields, conceptual approach, and processes that can this event.

2.1.5.1 Special Setup

RTABOUT2 has some additional special setup requirements due to the logic in the real-time wrapper.

The processing options for version ZJDE0001 of the Address Book Master Real Time Event Wrapper Application program (P0100100) determine which phone and email records are sent. The purpose of these processing options is to enable filtering of the outbound event, RTABOUT2.

This table explains the processing options:

Configure Contact Information

Enter a code to specify how you want to send contact information. Values are:

0, blank, or null: The system sends only primary contact information for an address book record as single fields. It sends the first telephone number, fax number, and email address of an address book record that matches the type specified in the other processing options.

1: Regardless of the types specified in the other processing options, the system sends the complete collection of contact information, including primary contact information, for an address book record in one group.

2: The system sends primary contact information in single fields, and the complete collection of contact information in a group. This value is a combination of values 0 and 1.

Phone Number Type

Indicate either the location or use of a telephone number. Values are defined in user-defined code (UDC) table 01/PH (Phone Type).

Fax Number Type

Specify the phone type for the telephone number to use for faxes. Values are defined in UDC table 01/PH (Phone Type).

Electronic Address Type

Specify the electronic address type that the system uses for an individual or an entity for internet communications. Values are defined in UDC table 01/ET (Electronic Address Type).

2.1.6 RTABHDR2

RTABHDR2 is a single event that provides address book header information within the RTABOUT2 container event. RTABHDR2 is generated only when RTABOUT2 is generated.

Event Name

RTABHDR2

Event Description

AB Header

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100100A: Address Book Master Real Time

Event Relationship

Included in container event RTABOUT

2.1.6.1 Event Fields

The RTABHDR2 event contains the same fields as the RTABHDR event. Additionaly, the RTABHDR2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
GAN8 szGlobalLocatorNumber String 13 Global Locator Number
GPA8 szParentAddressGLN String 13 Address Number Parent GLN
GAN8 szGlobalLocatorNumberString_1 String 13 Address Book Number GLN
GAN8 szGlobalLocatorNumberString_2 String 13 Address Book Number GLN
GAN8 szGlobalLocatorNumberString_3 String 13 Address Book Number GLN
GAN8 szGlobalLocatorNumberString_4 String 13 Address Book Number GLN
GAN8 szGlobalLocatorNumberString_5 String 13 Address Book Number GLN
GAN8 szPayeeAddressGLN String 13 Payee Address Number GLN

2.1.6.2 Conceptual Approach

An address book record added, modified, or deleted in the JD Edwards EnterpriseOne system creates, modifies, or deletes a record in the Address Book tables (Address Book Master, F0101; Address Book - Who's Who, F0111; Contact Information, F01111; Address Book - Contact Phone Numbers F0115; Electronic Address, F01151; Address by Date, F0116).

2.1.6.3 Objects that Can Initiate the Event

These objects can initiate the RTABHDR2 event:

  • N0100041 - Address Book MBF

  • P0111 - Who's Who application

  • P0115 - Phone application

  • P01111 - Contact Information E-mail application

  • B0100085 - Address Book Master Real-Time Event Notification Function

  • B0100073 - Electronic Address - Phones

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.1.7 RTABPHOUT2

RTABPHOUT2 is a single event that provides address book phone information within the RTABOUT2 container event. RTABPHOUT2 is generated only when RTABOUT2 is generated.

Event Name

RTABPHOUT2

Event Description

AB Phone

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100100B: Address Book Master Phones Wrapper Data Structure

Event Relationship

Included in container event RTABOUT.

2.1.7.1 Event Fields

The RTABPHOUT2 event contains the same fields as the RTABPHOUT event. Additionally, the RTABPHOUT2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
GAN8 szGlobalLocatorNumber String 13 Global Locator Number

2.1.7.2 Conceptual Approach

An address book phone record added, modified, or deleted in the JD Edwards EnterpriseOne system creates, updates, or deletes a record in the Address Book - Contact Phone Numbers (F0115).

2.1.7.3 Objects that Can Initiate the Event

These objects can initiate the RTABPHOUT2 event:

  • N0100041 - Address Book MBF

  • P0115 - Phone application

  • B0100085 - Address Book Master Real Time Event Notification Function

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.1.8 RTABEAOUT2

RTABEAOUT2 is a single event that provides address book email information within the RTABOUT2 container event. RTABEAOUT2 is generated only when RTABOUT2 is generated.

Event Name

RTABEAOUT2

Event Description

AB EA

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100100C: Address Book Master Email Wrapper Data Structure

Event Relationship

Included in container event RTABOUT.

2.1.8.1 Event Fields

The RTABEAOUT2 event contains the same fields as the RTABEAOUT event. Additionally, the RTABEAOUT2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
GAN8 szGlobalLocatorNumber String 13 Global Locator Number

2.1.8.2 Conceptual Approach

An address book email record added, modified, or deleted in the JD Edwards EnterpriseOne system creates a new record in the Electronic Address (F01151) table.

2.1.8.3 Objects that Can Initiate the Event

These objects can initiate the RTABEAOUT event:

  • N0100041 - Address Book MBF

  • P01111 - Contact Information E-mail application

  • B0100085 - Address Book Master Real-Time Event notification function

  • B0100089 - Electronic Address MBF

2.1.9 RTPCOUT

RTPCOUT is a single event generated by the JD Edwards EnterpriseOne system to provide parent/child information to third-party systems.

Event Name

RTPCOUT

Event Description

Parent Child

Event Type

RTE

Event Category

Container

Container event for:

RTPCOUTDS (D0100079A)

Product Code

H01

Reliable Delivery

1

Delivery Timeout Threshold

0

2.1.9.1 Conceptual Approach

A parent child record added, changed, or deleted in the JD Edwards EnterpriseOne system creates, modifies, or deletes a record in the Address Organization Structure Master table (F0150) (Parent/Child table).

2.1.9.2 Objects that Can Initiate the Event

A/B Org Structure Browse (P0150) calls the real-time event wrapper, Parent Child Structure Master Manage Notify (B0100079), to initiate the real-time event.

2.1.10 RTPCOUTDS

RTPCOUTDS is a single event within the RTPCOUT container event that provides parent/child information to third-party systems. RTPCOUTDS is generated only when RTPCOUT is generated.

Event Name

RTPCOUTDS

Event Description

RTPCOUT Data Structure

Event Type

RTE

Event Category

SINGLE

Product Code

H01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100079A: ParentChild Master Manage Notify Real Time Structure

Event Relationship

Included in container event RTPCOUT.

2.1.10.1 Event Fields

The RTPCOUTDS event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTI cActionCode Char 1 Action Code
AN8 mnAddressNumber Numeric 8 Address Number
PA8 mnAddressNumberParent Numeric 8 Address Number - Parent
OSTP szOrganizationTypeStructur[4] String 3 Organization Structure Type

2.1.11 RTPCOUT2

RTPCOUT2 is a single event generated by the JD Edwards EnterpriseOne system to provide parent/child information to third-party systems.

Event Name

RTPCOUT2

Event Description

Parent Child

Event Type

RTE

Event Category

Container

Container event for:

RTPCOUTDS2 (D0100102A)

Product Code

H01

Reliable Delivery

1

Delivery Timeout Threshold

0

2.1.11.1 Conceptual Approach

A parent child record added, changed, or deleted in the JD Edwards EnterpriseOne system creates, modifies, or deletes a record in the Address Organization Structure Master table (F0150) (Parent/Child table).

2.1.11.2 Objects that Can Initiate the Event

A/B Org Structure Browse (P0150) calls the real-time event wrapper, Parent Child Structure Master Manage Notify (B0100102), to initiate the real-time event.

2.1.12 RTPCOUTDS2

RTPCOUTDS2 is a single event within the RTPCOUT2 container event that provides parent/child information to third-party systems. RTPCOUTDS2 is generated only when RTPCOUT2 is generated.

Event Name

RTPCOUTDS2

Event Description

RTPCOUT2 Data Structure

Event Type

RTE

Event Category

SINGLE

Product Code

H01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100102A: ParentChild Master Manage Notify Real Time Structure

Event Relationship

Included in container event RTPCOUT.

2.1.12.1 Event Fields

The RTPCOUTDS2 event contains the same fields as the RTPCOUTDS event. Additoinally, the RTPCOUTDS2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
GPA8 szParentAddressGLN String 13 Address Number Parent GLN

2.1.13 RTSHPOUT

RTSHPOUT is a container event generated by the JD Edwards EnterpriseOne system to notify third-party systems about add or changes to the address book number of a branch plant record.

Event Name

RTSHPOUT

Event Description

Notify Ship to event

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTSHPHDR (D4102160A)

  • RTSHPPHOUT (D4102160B)

  • RTSHPEAOUT (D4102160C)

Product Code

H42

Reliable Delivery

blank

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for information about the event fields associated with this event.

2.1.13.1 Conceptual Approach

An address book number added changed in a Branch Plant Constant table (F41001) in the JD Edwards EnterpriseOne system sends out ship to real-time events with address book (F0101), phones (F0115) and email (F01151) information. All phones and email are sent for the first contact only.

2.1.13.2 Objects that Can Initiate the Event

The P41001 - Branch Plant Constants program can initiate the RTSHPOUT event.

2.1.14 RTSHPHDR

RTSHPHDR is a single event that is generated by the JD Edwards EnterpriseOne system to provide ship to header information for a given branch plant.

Event Name

RTSHPHDR

Event Description

Supports RTSHPOUT

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

blank

Delivery Timeout Threshold

0

Data Structure

D4102160A: Ship To Real Time Header

Event Relationship

Included in container event RTSHPOUT.

2.1.14.1 Event Fields

The RTSHPHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 Address Number
EFTB jdDateBeginningEffective Date 6 Effective Date
IDLN mnLineNumberID Numeric 5 Line Number ID
ALKY szAlternateAddressKey String 20 Alternate Address
TAX szTaxId String 20 Tax ID
ALPH szNameAlpha String 40 Alpha Name
DC szDescripCompressed String 40 Description Compressed
MCU szCostCenter String 12 Cost Center
SIC zStandardIndustryCode String 10 Std. Industry Code
LNGP szLanguagePreference String 2 Language Preference
AT1 szAddressType1 String 1 Search Type
CM szCreditMessage String 2 Credit Message
TAXC szPersonCorporationCode String 1 Person/Corporation Code
AT2 cAddressType2 String 1 Address Type 2
AT3 cAddressType3 String 1 Address Type 3
AT4 cAddressType4 String 1 Address Type 4
AT5 cAddressType5 String 1 Address Type 5
ATP cAddressTypePayables String 1 Address Type Payables
ATR AddressTypeReceivables String 1 Address Type Receivables
ATPR cAddTypeCode4Purch String 1 Address Type - Code, Purchaser
AB3 cMiscCode3 String 1 Miscellaneous Code
ATE cAddressTypeEmployee String 1 Address Type - Employee
AN81 mnAddressNumber1st Numeric 8 Address Number - 1st
AN82 mnAddressNumber2nd Numeric 8 Address Number - 2nd
AN83 mnAddressNumber3rd Numeric 8 Address Number - 3rd
AN84 mnAddressNumber4th Numeric 8 Address Number - 4th
AN86 mnAddressNumber6th Numeric 8 Address Number - 6th
AN85 mnAddressNumbert5h Numeric 8 Address Number - 5th
AC01 szReportCodeAddBook001 String 3 Category Code 01
AC02 szReportCodeAddBook002 String 3 Category Code 02
AC03 szReportCodeAddBook003 String 3 Category Code 03
AC04 szReportCodeAddBook004 String 3 Category Code 04
AC05 szReportCodeAddBook005 String 3 Category Code 05
AC06 szReportCodeAddBook006 String 3 Category Code 06
AC07 szReportCodeAddBook007 String 3 Category Code 07
AC08 szReportCodeAddBook008 String 3 Category Code 08
AC09 szReportCodeAddBook009 String 3 Category Code 09
AC10 szReportCodeAddBook010 String 3 Category Code 10
AC11 szReportCodeAddBook011 String 3 Sales Region
AC12 szReportCodeAddBook012 String 3 Category Code 12
AC13 szReportCodeAddBook013 String 3 Category Code 13
AC14 szReportCodeAddBook014 String 3 Category Code 14
AC15 szReportCodeAddBook015 String 3 Category Code 15
AC16 szReportCodeAddBook016 String 3 Category Code 16
AC17 szReportCodeAddBook017 String 3 Category Code 17
AC18 szReportCodeAddBook018 String 3 Category Code 18
AC19 szReportCodeAddBook019 String 3 Category Code 19
AC20 szReportCodeAddBook020 String 3 Category Code 20
AC21 szReportCodeAddBook021 String 3 Category Code 21
AC22 szReportCodeAddBook022 String 3 Category Code 22
AC23 szReportCodeAddBook023 String 3 Category Code 23
AC24 szReportCodeAddBook024 String 3 Category Code 24
AC25 szReportCodeAddBook025 String 3 Category Code 25
AC26 szReportCodeAddBook026 String 3 Category Code 26
AC27 szReportCodeAddBook027 String 3 Category Code 27
AC28 szReportCodeAddBook028 String 3 Category Code 28
AC29 szReportCodeAddBook029 String 3 Category Code 29
AC30 szReportCodeAddBook030 String 3 Category Code 30
GLBA szGlBankAccount String 8 GL Bank Account
PTI mnTimeScheduledIn Numeric 6 Time Scheduled In
PDI jdDateScheduledI Date 6 Date Scheduled In
MSGA cActionMessageControl String 1 Action Message Control
RMK szNameRemark String 30 Name Remark
TXCT szCertificateTaxExempt String 20 Certificate, Tax Exemption
TX2 szTaxId2 String 20 Tax ID - Additional - Individual
ALP1 szKanjialpha String 40 Secondary Alpha Name
URCD szUserReservedCode String 2 User Reserved Code
URDT jdUserReservedDate Date 6 User Reserved Date
URAT mnUserReservedAmount Number 15 User Reserved Amount
URAB mnUserReservedNumber Number 8 User Reserved Number
URRF UserReservedReference String 15 User Reserved Reference
PRGF cPurgeFlag String 1 Purge Flag
SCCLTP szShortcutClientType String 2 Shortcut Client Type
ADD1 szAddressLine1 String 40 Address Line 1
ADD2 szAddressLine2 String 40 Address Line 2
ADD3 szAddressLine3 String 40 Address Line 3
ADD4 szAddressLine4 String 40 Address Line 4
ADDZ szZipCodePostal String 12 Postal Code
CTY1 szCity String 25 City
COUN szCountyAddress String 25 County
ADDS szState String 3 State
CRTE szCarrierRoute String 4 Carrier Route
BKML szBulkMailingCenter String 2 Bulk Mailing Center (Future)
CTR szCountry String 3 Country
MLNM szMailingName String 40 Mailing Name
REM1 szRemark1 String 40 Remark 1
MLN1 szSecondaryMailingName String 40 Secondary Mailing Name
SBLI cSubledgerInactiveCode String 1 Subledger Inactive Code
ACTN cActionCode2 Char 1 Action Code

2.1.14.2 Conceptual Approach

A ship to address book number added or modified in a branch plant modifies the Branch Plant Constants table and this information is sent out in a real-time event: Address Book Master (F0101).

2.1.14.3 Objects that Can Initiate the Event

The P41001 - Branch Plant Constants program can initiate the PTSHPHDR event.

2.1.15 RTSHPPHOUT

RTSHPPHOUT is a single event generated by the JD Edwards EnterpriseOne system to provide address book phone information.

Event Name

RTSHPPHOUT

Event Description

supports RTSHPOUT

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

blank

Delivery Timeout Threshold

0

Data Structure

D4102160B: Ship To Real Time Phones

Event Relationship

Included in container event RTSHPOUT.

2.1.15.1 Event Fields

The RTSHPPHOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
PHTP szPhoneNumberType String 4 Phone Number Type
AR1 szPhoneAreaCode1 String 6 Phone Prefix
PH1 szPhoneNumber String 20 Phone Number
AN8 mnAddressNumber Numeric 8 Address Number
IDLN mnLineNumberID Numeric 5 Who's Who Line Number - ID
RCK7 mnSequenceNumber70 Numeric 5 Line Number ID - 5.0

2.1.15.2 Conceptual Approach

A ship to address book number added or modified in a branch plant modifies the Branch Plant Constants table and this information is sent out in a real-time event: all Address Book - Contact Phone Numbers (F0115) for the first contact.

2.1.15.3 Objects that Can Initiate the Event

The P41001 - Branch Plant Constants program can initiate the RTSHPPHOUT event.

2.1.16 RTSHPEAOUT

RTSHPEAOUT is a single event generated by the JD Edwards EnterpriseOne system to provide address book email information.

Event Name

RTSHPEAOUT

Event Description

Supports RTSHPOUT

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

blank

Delivery Timeout Threshold

0

Data Structure

D4102160C: Ship To Real Time Emails

Event Relationship

Included in container event RTSHPOUT.

2.1.16.1 Event Fields

The RTSHPEAOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 Address Number
IDLN mnLineNumberID Numeric 5 Who's Who Line Number - ID
ETP szElectronicAddressType String 4 Electronic Address Type
EMAL szEmailAddressow String 256 Email Address
RCK7 mnSequenceNumber70 Numeric 5 Line Number ID - 5.0

2.1.16.2 Conceptual Approach

A ship to address book number added or modified in a branch plant modifies the Branch Plant Constants table and this information is sent out in a real-time event: all Electronic Address (F01151) records for the first contact.

2.1.16.3 Objects that Can Initiate the Event

The P41001 - Branch Plant Constants program can initiate the RTSHPEAOUT event.

2.2 Business Unit

This section discusses the real-time event generated by changes to business units.

2.2.1 RTBUOUT

RTBUOUT tis a container event generated by the JD Edwards EnterpriseOne system to provide business unit information.

Event Name

RTBUOUT

Event Description

RTBUOUT

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTBUOUTA (D0000600B)

  • RTBUOUTB (D4101700B)

Product Code

H00

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for information about the event fields associated with this event.

2.2.1.1 Conceptual Approach

A business unit record added, modified, or deleted in the JD Edwards EnterpriseOne system creates, modifies, or deletes a record in the Business Unit table (F0006). If a business unit is added or modified, the information is sent to a third-party system for add or update. If a business unit is deleted, the pertinent information is sent to the third-party, which takes the appropriate action.

2.2.1.2 Objects that Can Initiate the Event

These objects can initiate the RTBUOUT event:

  • P0006 - Business Units

  • P41001 - Branch/Plant Constants

  • P00065 - Translate Business Units

  • R10480 - Journalize Consolidation Balances

  • R10862 - Refresh Consolidation

  • B0000105 - F0006D Update Business Unit Translation

  • B0000107 - F0006D Edit Business Unit Translation

  • B0000203 - F0006 Update Business Unit Category Codes from Address Book

  • B0900156 - Delete F0006 Business Unit and F0006D Translations

  • B1000012 - Business Unit Existence Check

  • B1000040 - Build Parent/Child Business Unit Cache

2.2.2 RTBUOUTA

RTBUOUTA is a single event within the RTBUOUT container event that provides business unit information. RTBUOUTA is generated only when RTBUOUT is generated.

Event Name

RTBUOUTA

Event Description

RTBUOUTA

Event Type

RTE

Event Category

SINGLE

Product Code

H00

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0000600B: Business Unit Real Time Notification Outbound Data

Event Relationship

Included in container event RTBUOUT

2.2.2.1 Event Fields

The RTBUOUTA event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTION cEventAction Char 1 Action Type
MCU szCostCenter String 12 Business Unit
STYL szCostCenterType String 2 Business Unit Type
DC szDescripCompressed String 40 Description - Compressed
LDM cLevelOfDetailCcCode Char 1 Level of Detail - Business Unit
CO szCompany String 5 Company
AN8 mnAddressNumber Numeric 8 Address Number
AN8O mnAddressNumberJobAr Numeric 8 Address Number - Job A/R
CNTY szCounty String 3 County
ADDS szState String 3 State
FMOD cModelAccountsandConsolid Char 1 Model Accounts and Consolidation
DL01 szDescription001 String 30 Description
DL02 szDescription002 String 30 Description 02
DL03 szDescription003 String 30 Description 03
DL04 szDescription004 String 30 Description 02
RP01 szDivision String 3 Division
RP02 szRegion String 3 Region
RP03 szGroup String 3 Group
RP04 szBranchOffice String 3 Branch Office
RP05 szDepartmentType String 3 Department Type
RP06 szPersonResponsible String 3 Person Responsible
RP07 szLineOfBusiness String 3 Line of Business
RP08 szCategoryCodeCostCt008 String 3 Category Code - Business Unit 08
RP09 szCategoryCodeCostCt009 String 3 Category Code - Business Unit 09
RP10 szCategoryCodeCostCt010 String 3 Category Code - Business Unit 10
RP11 szCategoryCodeCostCt011 String 3 Category Code - Business Unit 11
RP12 szCategoryCodeCostCt012 String 3 Category Code - Business Unit 12
RP13 szCategoryCodeCostCt013 String 3 Category Code - Business Unit 13
RP14 szCategoryCodeCostCt014 String 3 Category Code - Business Unit 14
RP15 szCategoryCodeCostCt015 String 3 Category Code - Business Unit 15
RP16 szCategoryCodeCostCt016 String 3 Category Code - Business Unit 16
RP17 szCategoryCodeCostCt017 String 3 Category Code - Business Unit 17
RP18 szCategoryCodeCostCt018 String 3 Category Code - Business Unit 18
RP19 szCategoryCodeCostCt019 String 3 Category Code - Business Unit 19
RP20 szCategoryCodeCostCt020 String 3 Category Code - Business Unit 20
RP21 szCategoryCodeCostCt021 String 10 Category Code - Business Unit 21
RP22 szCategoryCodeCostCt022 String 10 Category Code - Business Unit 22
RP23 szCategoryCodeCostCt023 String 10 Category Code - Business Unit 23
RP24 szCategoryCodeCostCenter24 String 10 Category Code - Business Unit 24
RP25 szCategoryCodeCostCenter25 String 10 Category Code - Business Unit 25
RP26 szCategoryCodeCostCenter26 String 10 Category Code - Business Unit 26
RP27 szCategoryCodeCostCenter27 String 10 Category Code - Business Unit 27
RP28 szCategoryCodeCostCenter28 String 10 Category Code - Business Unit 28
RP29 szCategoryCodeCostCenter29 String 10 Category Code - Business Unit 29
RP30 szCategoryCodeCostCenter30 String 10 Category Code - Business Unit 30
TA szTaxArea String 10 Tax Area
TXJS mnTaxEntity Numeric 8 Tax Entity
TXA1 szTaxArea1 String 10 Tax Rate/Area
EXR1 szTaxExplanationCode1 String 2 Tax Expl Code 1
TC01 szTaxDeductionCodes1 String 4 Tax/Deduction Codes 01
TC02 szTaxDeductionCodes2 String 4 Tax/Deduction Codes 02
TC03 szTaxDeductionCodes3 String 4 Tax/Deduction Codes 03
TC04 szTaxDeductionCodes4 String 4 Tax/Deduction Codes 04
TC05 szTaxDeductionCodes5 String 4 Tax/Deduction Codes 05
TC06 szTaxDeductionCodes6 String 4 Tax/Deduction Codes 06
TC07 szTaxDeductionCodes7 String 4 Tax/Deduction Codes 07
TC08 szTaxDeductionCodes8 String 4 Tax/Deduction Codes 08
TC09 szTaxDeductionCodes9 String 4 Tax/Deduction Codes 09
TC10 szTaxDeductionCodes10 String 4 Tax/Deduction Codes 10
ND01 cDistributeTaxCode001 Char 1 Tax Distributable/Non-Distr. Code 01
ND02 cDistributeTaxCode002 Char 1 Tax Distributable/Non-Distr. Code 02
ND03 cDistributeTaxCode003 Char 1 Tax Distributable/Non-Distr. Code 03
ND04 cDistributeTaxCode004 Char 1 Tax Distributable/Non-Distr. Code 04
ND05 cDistributeTaxCode005 Char 1 Tax Distributable/Non-Distr. Code 05
ND06 cDistributeTaxCode006 Char 1 Tax Distributable/Non-Distr. Code 06
ND07 cDistributeTaxCode007 Char 1 Tax Distributable/Non-Distr. Code 07
ND08 cDistributeTaxCode008 Char 1 Tax Distributable/Non-Distr. Code 08
ND09 cDistributeTaxCode009 Char 1 Tax Distributable/Non-Distr. Code 09
ND10 cDistributeTaxCode010 Char 1 Tax Distributable/Non-Distr. Code 10
CC01 cTaxOrDedCompStat01 Char 1 Tax or Deduction Compute Status Code 01
CC02 cTaxOrDedCompStat02 Char 1 Tax or Deduction Compute Status 02
CC03 cTaxOrDedCompStat03 Char 1 Tax or Deduction Compute Status 03
CC04 cTaxOrDedCompStat04 Char 1 Tax or Deduction Compute Status 04
CC05 cTaxOrDedCompStat05 Char 1 Tax or Deduction Compute Status 05
CC06 cTaxOrDedCompStat06 Char 1 Tax or Deduction Compute Status 06
CC07 cTaxOrDedCompStat07 Char 1 Tax or Deduction Compute Status 07
CC08 cTaxOrDedCompStat08 Char 1 Tax or Deduction Compute Status 08
CC10 cTaxOrDedCompStat10 Char 1 Tax or Deduction Compute Status 10
CC09 cTaxOrDedCompStat09 Char 1 Tax or Deduction Compute Status 09
PECC cPostingEditCostCenter Char 1 Posting Edit - Business Unit
ALS cAllocaSummarizaMeth Char 1 Allocation Summarization Method
ISS cInvstmtSummarizaMeth Char 1 Invoice/Stmt Summarization Method
GLBA szGlBankAccount String 8 G/L Bank Account
ALCL szAllocationLevel String 2 Allocation Level
LMTH cLaborLoadingMethod Char 1 Labor Distribution Method
LF mnLaborLoadingFactor Numeric 5 Labor Distribution Multiplier
OBJ1 szGlObjectAcctLabor String 6 Object Account - Labor Account
OBJ2 szGlObjctAcctLaborPrem String 6 Object Account - Premium Account
OBJ3 szGlObjAcctLaborBurden String 6 Object Account - Burden
SUB1 szSubsidiaryBurdnCstCode String 8 Subsidiary - Burden Cost Code
TOU mnUnitsTotal Numeric 15 Units - Total
SBLI cSubledgerInactiveCode Char 1 Subledger Inactive Code
ANPA mnSupervisor Numeric 8 Supervisor
CT szContractType1 String 4 Contract Type
CERT cCertifiedJob Char 1 Certified Job
MCUS szCostCenterSubsequent String 12 Business Unit - Subsequent
BTYP cBillingTypeCostCenter Char 1 Billing Type - Business Unit
PC mnPercentComplete Numeric 5 Percent Complete
PCA mnPerCompleteAggregate Numeric 5 Percent Complete - Aggregate Detail
PCC mnAmtCostToCompleteOb Numeric 15 Amount - Cost To Complete (Obsolete)
INTA szIntComputationCodeAr String 4 Interest Computation Code A/R
INTL szIntComputationCodeRev String 4 InterestComp - Late Revenue
D1J jdDatePlannedStartJ Date 6 Date - Planned Start
D2J jdDateActualStartJ Date 6 Date - Actual Start
D3J jdDatePlannedCompleteJ Date 6 Date - Planned Complete
D4J jdDateActualCompleteJ Date 6 Date - Actual Complete
D5J jdDateOther5J Date 6 Date - Other 5
D6J jdDateOther6J Date 6 Date - Other 6
FPDJ jdDteFinalPaymntJulian Date 6 Date - Final Payment (Julian)
CAC mnAmtCostAtCompletion Numeric 15 Amount - Cost at Completion
PAC mnAmtProfitAtCompletion Numeric 15 Amount - Profit at Completion
EEO cEqualEmploymentOpport Char 1 Equal Employment Opportunity
ERC szEquipmentRateCode String 2 Equipment Rate Code
EV01 cIsAnInventoryBranchPlant Char 1 J.D. Edwards EnterpriseOne Event Point 01
LNGP szLanguagePreference String 2 Language
DL01 szAlternativeDescription1 String 30 Description
DL02 szAlternativeDescription2 String 30 Description 02
DL03 szAlternativeDescription3 String 30 Description 03
DL04 szAlternativeDescription4 String 30 Description 02
DC szAlzAltDescripCompressed String 40 Description - Compressed
BPTP szBranchType String 15 Branch Type
APSB cAPSBusinessUnit Char 1 APS Business Unit
TSBU szTargetBusinessUnit String 12 Target Business Unit

2.2.3 RTBUOUTB

RTBUOUTB is a single event within the RTBUOUT container event that provides business unit information. RTBUOUTB is generated only when RTBUOUT is generated.

Event Name

RTBUOUTB

Event Description

RTBUOUTB

Event Type

RTE

Event Category

SINGLE

Product Code

H00

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4101700B: Business Unit Real Time Notification Outbound Data

Event Relationship

Included in container event RTBUOUT

2.2.3.1 Event Fields

The RTBUOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTION cEventAction Char 1 Action Type
MCU szCostCenter String 12 Business Unit
STYL szCostCenterType String 2 Business Unit Type
DC szDescripCompressed String 40 Description - Compressed
LDM cLevelOfDetailCcCode Char 1 Level of Detail - Business Unit
CO szCompany String 5 Company
AN8 mnAddressNumber Numeric 8 Address Number
AN8O mnAddressNumberJobAr Numeric 8 Address Number - Job A/R
CNTY szCounty String 3 County
ADDS szState String 3 State
FMOD cModelAccountsandConsolid Char 1 Model Accounts and Consolidation
DL01 szDescription001 String 30 Description
DL02 szDescription01002 String 30 Description 02
DL03 szDescription01003 String 30 Description 03
DL04 szDescription01004 String 30 Description 04
RP01 szDivision String 3 Division
RP02 szRegion String 3 Region
RP03 szGroup String 3 Group
RP04 szBranchOffice String 3 Branch Office
RP05 szDepartmentType String 3 Department Type
RP06 szPersonResponsible String 3 Person Responsible
RP07 szLineOfBusiness String 3 Line of Business
RP08 szCategoryCodeCostCt008 String 3 Category Code - Business Unit 08
RP09 szCategoryCodeCostCt009 String 3 Category Code - Business Unit 09
RP10 szCategoryCodeCostCt010 String 3 Category Code - Business Unit 10
RP11 szCategoryCodeCostCt011 String 3 Category Code - Business Unit 11
RP12 szCategoryCodeCostCt012 String 3 Category Code - Business Unit 12
RP13 szCategoryCodeCostCt013 String 3 Category Code - Business Unit 13
RP14 szCategoryCodeCostCt014 String 3 Category Code - Business Unit 14
RP15 szCategoryCodeCostCt015 String 3 Category Code - Business Unit 15
RP16 szCategoryCodeCostCt016 String 3 Category Code - Business Unit 16
RP17 szCategoryCodeCostCt017 String 3 Category Code - Business Unit 17
RP18 szCategoryCodeCostCt018 String 3 Category Code - Business Unit 18
RP19 szCategoryCodeCostCt019 String 3 Category Code - Business Unit 19
RP20 szCategoryCodeCostCt020 String 3 Category Code - Business Unit 20
RP21 szCategoryCodeCostCt021 String 10 Category Code - Business Unit 21
RP22 szCategoryCodeCostCt022 String 10 Category Code - Business Unit 22
RP23 szCategoryCodeCostCt023 String 10 Category Code - Business Unit 23
RP24 szCategoryCodeCostCenter24 String 10 Category Code - Business Unit 24
RP25 szCategoryCodeCostCenter25 String 10 Category Code - Business Unit 25
RP26 szCategoryCodeCostCenter26 String 10 Category Code - Business Unit 26
RP27 szCategoryCodeCostCenter27 String 10 Category Code - Business Unit 27
RP28 szCategoryCodeCostCenter28 String 10 Category Code - Business Unit 28
RP29 szCategoryCodeCostCenter29 String 10 Category Code - Business Unit 29
RP30 szCategoryCodeCostCenter30 String 10 Category Code - Business Unit 30
TA szTaxArea String 10 Tax Area
TXJS mnTaxEntity Numeric 8 Tax Entity
TXA1 szTaxArea1 String 10 Tax Rate/Area
EXR1 szTaxExplanationCode1 String 2 Tax Expl Code 1
TC01 szTaxDeductionCodes1 String 4 Tax/Deduction Codes 01
TC02 szTaxDeductionCodes2 String 4 Tax/Deduction Codes 02
TC03 szTaxDeductionCodes3 String 4 Tax/Deduction Codes 03
TC04 szTaxDeductionCodes4 String 4 Tax/Deduction Codes 04
TC05 szTaxDeductionCodes5 String 4 Tax/Deduction Codes 05
TC06 szTaxDeductionCodes6 String 4 Tax/Deduction Codes 06
TC07 szTaxDeductionCodes7 String 4 Tax/Deduction Codes 07
TC08 szTaxDeductionCodes8 String 4 Tax/Deduction Codes 08
TC09 szTaxDeductionCodes9 String 4 Tax/Deduction Codes 09
TC10 szTaxDeductionCodes10 String 4 Tax/Deduction Codes 10
ND01 cDistributeTaxCode001 Char 1 Tax Distributable/Non-Distr. Code 01
ND02 cDistributeTaxCode002 Char 1 Tax Distributable/Non-Distr. Code 02
ND03 cDistributeTaxCode003 Char 1 Tax Distributable/Non-Distr. Code 03
ND04 cDistributeTaxCode004 Char 1 Tax Distributable/Non-Distr. Code 04
ND05 cDistributeTaxCode005 Char 1 Tax Distributable/Non-Distr. Code 05
ND06 cDistributeTaxCode006 Char 1 Tax Distributable/Non-Distr. Code 06
ND07 cDistributeTaxCode007 Char 1 Tax Distributable/Non-Distr. Code 07
ND08 cDistributeTaxCode008 Char 1 Tax Distributable/Non-Distr. Code 08
ND09 cDistributeTaxCode009 Char 1 Tax Distributable/Non-Distr. Code 09
ND10 cDistributeTaxCode010 Char 1 Tax Distributable/Non-Distr. Code 10
CC01 cTaxOrDedCompStat01 Char 1 Tax Distributable/Non-Distr. Code 01
CC02 cTaxOrDedCompStat02 Char 1 Tax or Deduction Compute Status 02
CC03 cTaxOrDedCompStat03 Char 1 Tax or Deduction Compute Status 03
CC04 cTaxOrDedCompStat04 Char 1 Tax or Deduction Compute Status 04
CC05 cTaxOrDedCompStat05 Char 1 Tax or Deduction Compute Status 05
CC06 cTaxOrDedCompStat06 Char 1 Tax or Deduction Compute Status 06
CC07 cTaxOrDedCompStat07 Char 1 Tax or Deduction Compute Status 07
CC08 cTaxOrDedCompStat08 Char 1 Tax or Deduction Compute Status 08
CC09 cTaxOrDedCompStat09 Char 1 Tax or Deduction Compute Status 09
CC10 cTaxOrDedCompStat10 Char 1 Tax or Deduction Compute Status 10
PECC cPostingEditCostCenter Char 1 Posting Edit - Business Unit
ALS cAllocaSummarizaMeth Char 1 Allocation Summarization Method
ISS cInvstmtSummarizaMeth Char 1 Invoice/Stmt Summarization Meth
GLBA szGlBankAccount String 8 G/L Bank Account
ALCL szAllocationLevel String 2 Allocation Level
LMTH cLaborLoadingMethod Char 1 Labor Distribution Method
LF mnLaborLoadingFactor Numeric 5 Labor Distribution Multiplier
OBJ1 szGlObjectAcctLabor String 6 Object Account - Labor Account
OBJ2 szGlObjctAcctLaborPrem String 6 Object Account - Premium Account
OBJ3 szGlObjAcctLaborBurden String 6 Object Account - Burden
SUB1 szSubsidiaryBurdnCstCde String 8 Subsidiary - Burden Cost Code
TOU mnUnitsTotal Numeric 15 Units - Total
SBLI cSubledgerInactiveCode Char 1 Subledger Inactive Code
ANPA mnSupervisor Numeric 8 Supervisor
CT szContractType1 String 4 Contract Type
CERT cCertifiedJob Char 1 Certified Job
MCUS szCostCenterSubsequent String 12 Business Unit - Subsequent
BTYP cBillingTypeCostCenter Char 1 Billing Type - Business Unit
PC mnPercentComplete Numeric 5 Percent Complete
PCA mnPerCompleteAggregate Numeric 5 Percent Complete - Aggregate Detail
PCC mnAmtCostToCompleteOb Numeric 15 Amount - Cost To Complete (Obsolete)
INTA szIntComputationCodeAr String 4 Interest Computation Code A/R
INTL szIntComputationCodeRev String 4 InterestComp - Late Revenue
D1J jdDatePlannedStartJ Date 6 Date - Planned Start
D2J jdDateActualStartJ Date 6 Date - Actual Start
D3J jdDatePlannedCompleteJ Date 6 Date - Planned Complete
D4J jdDateActualCompleteJ Date 6 Date - Actual Complete
D5J jdDateOther5J Date 6 Date - Other 5
D6J jdDateOther6J Date 6 Date - Other 6
FPDJ jdDteFinalPaymntJulian Date 6 Date - Final Payment (Julian)
CAC mnAmtCostAtCompletion Numeric 15 Amount - Cost at Completion
PAC mnAmtProfitAtCompletion Numeric 15 Amount - Profit at Completion
EEO cEqualEmploymentOpport Char 1 Equal Employment Opportunity
ERC szEquipmentRateCode String 2 Equipment Rate Code
EV01 cIsAnInventoryBranchPlant Char 1 JD Edwards EnterpriseOne Event Point 01
LNGP szLanguagePreference String 2 Language
DL01 szAlternativeDescription1 String 30 Description
DL02 szAlternativeDescription2 String 30 Description 02
DL03 szAlternativeDescription3 String 30 Description 03
DL04 szAlternativeDescription4 String 30 Description 02
DC szAlzAltDescripCompressed String 40 Description - Compressed
EV01 cFutureUseFlag Char 1 J.D. Edwards EnterpriseOne Event Point 01
INT01 FutureUseInteger Integer 4 Integer 01 - JD Edwards EnterpriseOne
MATH01 mnFutureUseMathNumeric Numeric 15 Math Numeric 01
VC30A szFutureUseString String 30 Video Constant A - length 30

2.2.4 RTBUOUT2

RTBUOUT2 is a container event generated by the JD Edwards EnterpriseOne system to provide business unit information.

Event Name

RTBUOUT2

Event Description

RTBUOUT2

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTBUOUTA2 (D0000610B)

  • RTBUOUTB2 (D4101770B)

Product Code

H00

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for information about the event fields associated with this event.

2.2.4.1 Conceptual Approach

A business unit record added, modified, or deleted in the JD Edwards EnterpriseOne system creates, modifies, or deletes a record in the Business Unit table (F0006). If a business unit is added or modified, the information is sent to a third-party system for add or update. If a business unit is deleted, the pertinent information is sent to the third-party, which take the appropriate action.

2.2.4.2 Objects that Can Initiate the Event

These objects can initiate the RTBUOUT2 event:

  • P0006 - Business Units

  • P41001 - Branch/Plant Constants

  • P00065 - Translate Business Units

  • R10480 - Journalize Consolidation Balances

  • R10862 - Refresh Consolidation

  • B0000105 - F0006D Update Business Unit Translation

  • B0000107 - F0006D Edit Business Unit Translation

  • B0000203 - F0006 Update Business Unit Category Codes from Address Book

  • B0900156 - Delete F0006 Business Unit and F0006D Translations

  • B1000012 - Business Unit Existence Check

  • B1000040 - Build Parent/Child Business Unit Cache

2.2.5 RTBUOUTA2

RTBUOUTA2 is a single event within the RTBUOUT2 container event that provides business unit information. RTBUOUTA2 is generated only when RTBUOUT2 is generated.

Event Name

RTBUOUTA2

Event Description

RTBUOUTA2

Event Type

RTE

Event Category

SINGLE

Product Code

H00

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0000610B: Business Unit Real Time Notification Outbound Data

Event Relationship

Included in container event RTBUOUT

2.2.5.1 Event Fields

The RTBUOUTA2 event contains the same fields as the RTBUOUTA event. Additionally the RTBUOUTA2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
GAN8 szGlobalLocatorNumber String 13 Global Locator Number

2.2.6 RTBUOUTB2

RTBUOUTB2 is a single event within the RTBUOUT2 container event that provides business unit information. RTBUOUTB is generated only when RTBUOUT2 is generated.

Event Name

RTBUOUTB2

Event Description

RTBUOUTB2

Event Type

RTE

Event Category

SINGLE

Product Code

H00

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4101770B: Business Unit Real Time Notification Outbound Data

Event Relationship

Included in container event RTBUOUT

2.2.6.1 Event Fields

The RTBUOUTB2 contains the same fields as the RTBUOUTB event. Additionally, the RTBUOUTB2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
GAN8 szGlobalLocatorNumber String 13 Global Locator Number

2.3 Company

This section discusses the real-time event generated by changes to companies.

2.3.1 RTCOOUT

RTCOOUT is a single event generated by the JD Edwards EnterpriseOne system to provide company information.

Event Name

RTCOOUT

Event Description

RTCOOUT

Event Type

RTE

Event Category

SINGLE

Product Code

H00

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0000310B: Company Real Time Notification Outbound Data

2.3.1.1 Event Fields

The RTCOOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTI cActionCode Char 1 Action Code
CO szCompany String 5 Company
NAME szName String 30 Name
ALTC szAlternateCompanyName String 40 Alternate Company Name
DFYJ jdDatefiscalyearbeginsj Date 6 Date - Fiscal Year Begins
PNC mnPeriodNumberCurrent Numeric 2 Period Number - Current
DOT1 cMultiCurrencyIntercompany Char 1 Allow Multi-Currency Intercompany Trans.
CRYR cCurrencyConverYNAR Char 1 Currency Conversion Y/N/Z
CRYC cSearchTypeSecurity Char 1 Search Type Security - Y/N
DOT2 cComputationID Char 1 Computation ID
MCUA cUseCcFrAssetCstFlag Char 1 Default CC - Use for Asset Cost
MCUD cUseCcForDepreExpFlg Char 1 Default CC - Use for Depreciation Exp.
MCUC cUseCcFrAccumDepreFl Char 1 Default CC - Use for Accumulated Depre
MCUB cUseCcForRevBillFlag Char 1 Default CC - Use for Revenue - Billing
DPRC cComMethodItdOrRem1 Char 1 Voucher Redistribution Suspense
BKTX cBookToTax Char 1 Detailed Currency Restatement
TXBM mnTaxYearBeginMonth Numeric 2 Tax Year - Beginning Month
TXBO mnTaxYearBeginMonthOld Numeric 2 Tax Year - Beginning Month - Old OBSOLET
NWXJ jdDateNewTaxYearEndJ Date 6 Date - New Tax Year End
GLIE cGlInterfaceFlgPropEq Char 1 Display 10 Class Codes (Y/N)
ABIN cAddressBookInterface Char 1 Post Account Balances by Currency
CALD szNumberOfPeriodsNormal String 2 Number of Periods - Normal
DTPN cFisalDatePattern Char 1 Fiscal Date Pattern
PNF mnPeriodsNoFinancialRep Numeric 2 Period Number - Financial Reporting
DFF mnFinancialReportingYear Numeric 2 Financial Reporting Year
CRCD szCurrencyCodeFrom String 3 Currency Code - From
SMI cSymblUseToDefinPEI Char 1 Symbol Used to define Item Number
SMU cSymblUseToDefinPEU Char 1 Symbol Used to define Unit Number
SMS cSymblUseToDefinSeria Char 1 Symbol Used to define Serial Number
DNLT cDelinquencyLetter Char 1 Delinquency Notice (Y/N)
STMT cPrintStatementYN Char 1 Print Statement Y/N
ATCS cAutoCash Char 1 Auto Receipt (Y/N)
ALGM szAutocashAlgorithm String 2 Auto Receipt Algorithm Method
AGEM cAgingMethod Char 1 Aging Method (1,2,3)
CRDY mnAgingDaysARCurrent Numeric 3 Aging Days - A/R Current
AGR1 mnAgingDaysAR001 Numeric 3 Aging Days - A/R 1
AGR2 mnAgingDaysAR002 Numeric 3 Aging Days - A/R 2
AGR3 mnAgingDaysAR003 Numeric 3 Aging Days - A/R 3
AGR4 mnAgingDaysAR004 Numeric 3 Aging Days - A/R 4
AGR5 mnAgingDaysAR005 Numeric 3 Aging Days - A/R 5
AGR6 mnAgingDaysAR006 Numeric 3 Aging Days - A/R 6
AGR7 mnAgingDaysAR007 Numeric 3 Aging Days - A/R 7
FRY mnFinancialReportYear52 Numeric 2 52 Period Financial Report Year
FRP mnPeriodNoFinancial52 Numeric 2 52 Period Number - Financial Reporting
NNP mnNumberOfPeriods52 Numeric 2 52 Period Number of Periods - Normal
FP mnPercentageFactor Numeric 9 Percentage Factor
AGE cBaseAgingDate Char 1 Aging - Date Based On (I/D/G)
DAG jdDateAgeAsOf Date 6 Date - Age as of
ARPN mnPeriodNoAr Numeric 2 Period Number - Accounts Receivable
APPN mnPeriodNoAp Numeric 2 Period Number - Accounts Payable
ARFJ jdDateARFiscalYearBeginsJ Date 6 Date - A/R Fiscal Year Begins
APFJ jdDateAPFisalYearBeginsJ Date 6 Date - A/P Fiscal Year Begins
AN8 mnAddressNumber Numeric 8 Address Number
SGBK szSignatureBlock String 40 Signature Block
PTCO cPrintCompanyName Char 1 Print Company Name
X1 cForFutureUseFlag1 Char 1 For Future Use - Flag 1
X2 cForFutureUseFlag2 Char 1 For Future Use - Flag 2
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
UPMJ jdDateUpdated Date 6 Date - Updated
JOBN szWorkStationId String 10 Work Station ID
UPMT mnTimeLastUpdated Numeric 6 Time - Last Updated

2.3.1.2 Conceptual Approach

A new company added in the JD Edwards EnterpriseOne system creates a new record in the Company table (F0010). If a company is added or modified in a system, the information is sent to a third-party system for add or update. If a company is deleted, the pertinent information is sent to the third-party, which will take the appropriate action. If applicable, the third-party integration must update the cross-reference table in the process in order to tie together the key values from both systems.

2.3.1.3 Objects that Can Initiate the Event

These objects can initiate the RTCOOUT event:

  • P0000 - System Setup

  • P0010 - Companies

  • B0000132 - Update Currency Conversion

  • B0000024 - Global Update Company Period Number

  • B03B0026 - Retrieve/Update A/R Constants

2.4 Customer - RTCMOUT

This section discusses the real-time event generated by changes to customer records.

Note:

There are two customer-related RTEs, which include RTCMOUT and RTCMOUT2. RTCMOUT is documented in this section, and was the original customer RTE. RTCMOUT2 was created to handle additional customer-related changes for the JD Edwards EnterpriseOne integration with CRM On Demand. RTCMOUT2 is discussed in the next section.

2.4.1 RTCMOUT

RTCMOUT is used by the JD Edwards EnterpriseOne system to notify third-party systems of customer additions, changes, or deletions.

Event Name

RTCMOUT

Event Description

RTCMOUT

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTCMHDR (D0100077A)

  • RTCMPHOUT (D0100077B)

  • RTCMEAOUT (D0100077C)

  • RTCMCCOUT (D0100077D)

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for more information about the fields, conceptual approach, and processes that can initiate this event.

2.4.1.1 Special Setup

RTCMOUT has some additional special setup requirements due to the logic in the real-time wrapper.

The processing option for version ZJDE001 of the Customer Master Real Time Event Wrapper Application program (P0100077) determines whether RTCMOUT is always sent or is sent only if certain fields are changed. The purpose of the processing option is to enable filtering of the outbound event, RTCMOUT.

When the processing option is 0, blank, or null, no filtering occurs, and RTCMOUT is sent whenever a change is made to a customer master record. If the processing option is 1, an event is sent only if one of the five territory alignment fields have been changed. Events always occur on an Add or Delete. The five territory alignment fields are Industry Classification Code, City, State, Zip, and Country. If one of these fields have changed and the filter is turned off, a flag is set in a cTerritoryAlign parameter in the event data structure. This flag is a signal that something has changed in those five fields.

2.4.2 RTCMHDR

RTCMHDR is used by the JD Edwards EnterpriseOne system to notify third-party systems of customer additions, changes, or deletions.

Event Name

RTCMHDR

Event Description

CM Header

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100077A: Customer Master Real Time Record

Event Relationship

Included in container event RTCMOUT.

2.4.2.1 Event Fields

The RTCMHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Type
AN8 mnAddressNumber Numeric 8 Customer
CO szCompany String 5 Company
ALPH szNameAlpha String 40 Customer Name
MCU szBusinessUnit String 12 Business Unit
AT1 szSearchType String 3 Customer Type
BADT cShipToSoldToFlag Char 1 Billing Address Type
SIC szStandardIndustryCode String 10 Industry Classification Code
RMK szRemark String 30 Remark
LNGP szLanguageCode String 2 Language
POPN szCreatedBy String 10 Person who created record
MLNM szMailingName String 40 Mailing Name
ADD1 szAddressLine1 String 40 Address Line 1
ADD2 szAddressLine2 String 40 Address Line 2
ADD3 szAddressLine3 String 40 Address Line 3
ADD4 szAddressLine4 String 40 Address Line 4
CTY1 szCity String 25 City
COUN szCountyAddress String 25 County
ADDS szState String 3 State
ADDZ szZipCodePostal String 12 Zip Postal Code
CTR szCountry String 3 Country
PH1 szPhoneNumber String 20 Phone Number
PH1 szPhoneNumber_2 String 20 Phone Number
TXA1 szTaxArea String 10 Tax Rate/Area
EXR1 szTaxExplanationCode String 2 Tax Expl Code 1
TAX szTaxId String 20 Tax ID
CRCD szCurrencyCode String 4 Currency Code
PORQ cCustomerPORequiredYN Char 1 Customer PO Required (Y/N)
PA8 mnParentNumber Numeric 8 Parent
CM szCreditMessage String 2 Credit Message
EV01 cTerritoryAlign Char 1 Territory Alignment Flag for CRM
PID szProgramID String 10 Program ID
ALKY szAlternateAddressKey String 20 Alternate Address Key
TRAR szPaymentTermsA/R String 3 Payment Terms - A/R
HOLD szHoldOrderCode String 20 Hold Alternate Code
EFTB jdDateBeginningEffective Date 6 Date - Beginning Effective Date

2.4.2.2 Conceptual Approach

A customer record added, modified, or deleted in the JD Edwards EnterpriseOne system creates a new record in a number of tables such as Customer Master by Line of Business (F03012) and Address Book Master (F0101) tables. A real-time notification event is triggered in the Customer Master or Address Book Master Business Function after data is modified to any customer table.

2.4.2.3 Objects that Can Initiate the Event

These objects can initiate the RTCMHDR event:

  • N0100041 - Address Book MBF

  • N0100042 - Customer Master MBF

  • P0111 - Whos Who application

  • P0115 - Phones application

  • P01111 - Contact Information E-mail application

  • B0100073 - Electronic Address - Phones business function B0100077 - Customer Master Real-Time Event notification function

  • B0100077 - Customer Master Real Time Wrapper

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.4.3 RTCMPHOUT

RTCMPHOUT is used by the JD Edwards EnterpriseOne system to inform third-party systems of customer phone number changes.

Event Name

RTCMPHOUT

Event Description

CM Phone

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100077B: Customer Phones Wrapper Data Structure

Event Relationship

Included in container event RTCMOUT.

2.4.3.1 Event Fields

The RTCMPHOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
PHTP szPhoneNumberType String 4 Type of phone number (fax, home, work, etc)
PH1 szPhoneNumber String 20 Phone number
CNLN mnContactPersonID Numeric 5 Contact Line Number
RCK7 mnSequenceNumber Numeric 8 Sequence number in F0115 table of record

2.4.3.2 Conceptual Approach

A phone number is changed in the JD Edwards EnterpriseOne system for a customer. This change is sent out using real-time events. A given customer may have an infinite number of phone numbers.

2.4.3.3 Objects that Can Initiate the Event

These objects can initiate the RTCMPHOUT event:

  • N0100041 - Address Book MBF

  • N0100042 - Customer Master MBF

  • P0111 - Whos who application

  • P0115 - Phones application

  • P01111 - Contact Information E-mail application

  • B0100073 - Electronic Address - Phones business function

  • B0100077 - Customer Master Real-Time Event notification function

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.4.4 RTCMEAOUT

RTCMEAOUT is used by the JD Edwards EnterpriseOne system to inform third-party systems of customer email address changes.

Event Name

RTCMEAOUT

Event Description

Customer E-mail

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100077C: Customer Master Real Time Email Structure

Event Relationship

Included in container event RTCMOUT.

2.4.4.1 Event Fields

The RTCMEAOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 Address number of customer
IDLN mnLineNumberID Numeric 8 who's who number of customer
RCK7 mnSequenceNumber70 Numeric 8 Sequence number of record in F01151 table
ETP szElectronicAddressType String 4 Type of electronic address such as email or URL
EMAL szEmailAddressow String 256 Email address or URL

2.4.4.2 Conceptual Approach

An email address is added or changed in the JD Edwards EnterpriseOne system for a customer. This change is sent out using real-time events. A given customer may have an infinite number of email addresses.

2.4.4.3 Objects that Can Initiate the Event

These objects can initiate the RTCMEAOUT event:

  • N0100041 - Address Book MBF

  • N0100042 - Customer Master MBF

  • P0111 - Whos Who application

  • P0115 - Phones application

  • P01111 - Contact Information E-mail application

  • B0100073 - Electronic Address - Phones business function

  • B0100077 - Customer Master Real-Time Event notification function

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.4.5 RTCMCCOUT

RTCMCCOUT is used by the JD Edwards EnterpriseOne system to inform third-party systems of customer category code changes.

Event Name

RTCMCCOUT

Event Description

Customer Category Codes

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100077D: Customer Master Real Time Cat Codes Structure

Event Relationship

Included in container event RTCMOUT.

2.4.5.1 Event Fields

The RTCMCCOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 Customer Address Number
AC01 szReportCodeAddBook001 String 3 Customer Category Code
AC02 szReportCodeAddBook002 String 3 Customer Category Code
AC03 szReportCodeAddBook003 String 3 Customer Category Code
AC04 szReportCodeAddBook004 String 3 Customer Category Code
AC05 szReportCodeAddBook005 String 3 Customer Category Code
AC06 szReportCodeAddBook006 String 3 Customer Category Code
AC07 szReportCodeAddBook007 String 3 Customer Category Code
AC08 szReportCodeAddBook008 String 3 Customer Category Code
AC09 szReportCodeAddBook009 String 3 Customer Category Code
AC10 szReportCodeAddBook010 String 3 Customer Category Code
AC11 szReportCodeAddBook011 String 3 Customer Category Code
AC12 szReportCodeAddBook012 String 3 Customer Category Code
AC13 szReportCodeAddBook013 String 3 Customer Category Code
AC14 szReportCodeAddBook014 String 3 Customer Category Code
AC15 szReportCodeAddBook015 String 3 Customer Category Code
AC16 szReportCodeAddBook016 String 3 Customer Category Code
AC17 szReportCodeAddBook017 String 3 Customer Category Code
AC18 szReportCodeAddBook018 String 3 Customer Category Code
AC19 szReportCodeAddBook019 String 3 Customer Category Code
AC20 szReportCodeAddBook020 String 3 Customer Category Code
AC21 szCategoryCodeAddressBook2 String 3 Customer Category Code
AC22 szCategoryCodeAddressBk22 String 3 Customer Category Code
AC23 szCategoryCodeAddressBk23 String 3 Customer Category Code
AC24 szCategoryCodeAddressBk24 String 3 Customer Category Code
AC25 szCategoryCodeAddressBk25 String 3 Customer Category Code
AC26 szCategoryCodeAddressBk26 String 3 Customer Category Code
AC27 szCategoryCodeAddressBk27 String 3 Customer Category Code
AC28 szCategoryCodeAddressBk28 String 3 Customer Category Code
AC29 szCategoryCodeAddressBk29 String 3 Customer Category Code
AC30 szCategoryCodeAddressBk30 String 3 Customer Category Code

2.4.5.2 Conceptual Approach

A customers category code data is added or changed in the JD Edwards EnterpriseOne system. This change is sent out using real-time events.

2.4.5.3 Objects that Can Initiate the Event

These objects can initiate the RTCMCCOUT event:

  • N0100041 - Address Book MBF

  • N0100042 - Customer Master MBF

  • P0111 - Whos Who application

  • P0115 - Phones application

  • P01111 - Contact Information E-mail application

  • B0100073 - Electronic Address - Phones business function

  • B0100077 - Customer Master Real-Time Event notification function

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.5 Customer - RTCMOUT2

This section provides the details of the RTCMOUT2 RTE, which was created for use by the Lead to Order process integration pack (PIP) which integrates JD Edwards EnterpriseOne and CRM On Demand.

2.5.1 RTCMOUT2

The RTCMOUT2 RTE structure publishes customer data in a format that can be easily consumed by the Lead to Order customer integration. RTCMOUT2 is used by the JD Edwards EnterpriseOne system to notify third-party systems of customer additions, changes, or deletions.

Event Name

RTCMOUT2

Event Description

RTCMOUT2

Event Type

RTE

Event Category

Container

Container event for:

  • RTCMHDR2

  • RTCMEAOUT2

  • RTCMAAOUT

  • RTCMCCOUT2

  • RTABCCOUT

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

2.5.1.1 Special Setup - RTCMOUT2

RTCMOUT2 has some additional special setup requirements due to the logic in the real-time wrapper.

The processing option for version ZJDE0001 of the Customer Master Real Time Event Wrapper Application program (P0100077) determines whether RTCMOUT2 is always sent or is sent only if certain fields are changed. The purpose of the processing option is to enable filtering of the outbound event, RTCMOUT2.

When the processing option is 0, blank, or null, no filtering occurs, and RTCMOUT2 is sent whenever a change is made to a customer master record. If the processing option is 1, an event is sent only if one of the five territory alignment fields has been changed. Events always occur on an Add or Delete. The five territory alignment fields are Industry Classification Code, City, State, Zip, and Country. If one of these fields has changed and the filter is disabled, a flag is set in a cTerritoryAlign parameter in the event data structure. This flag is a signal that something has changed in those five fields.

2.5.2 RTCMHDR2

RTCMHDR2 is used by the JD Edwards EnterpriseOne system to notify third-party systems of customer additions, changes, or deletions.

Event Name

RTCMOUT2

Event Description

2CM Header

Event Type

RTE

Event Category

Single

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100096A

Evvent Relationship

Included in container event RTCMOUT2.

2.5.2.1 Event Fields

The RTCMHDR2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Type
AN8 mnAddressNumber Numeric 8 Customer
CO szCompany String 5 Company
ALPH szNameAlpha String 40 Customer Name
MCU szBusinessUnit String 12 Business Unit
AT1 szSearchType String 3 Customer Type
BADT cShipToSoldToFlag Char 1 Billing Address Type
SIC szStandardIndustryCode String 10 Industry Classification Code
RMK szRemark String 30 Remark
LNGP szLanguageCode String 2 Language
POPN szCreatedBy String 10 Person who created record
MLNM szMailingName String 40 Mailing Name
ADD1 szAddressLine1 String 40 Address Line 1
ADD2 szAddressLine2 String 40 Address Line 2
ADD3 szAddressLine3 String 40 Address Line 3
ADD4 szAddressLine4 String 40 Address Line 4
CTY1 szCity String 25 City
COUN szCountyAddress String 25 County
ADDS szState String 3 State
ADDZ szZipCodePostal String 12 Zip Postal Code
CTR szCountry String 3 Country
TXA1 szTaxArea String 10 Tax Rate/Area
EXR1 szTaxExplanationCode String 2 Tax Expl Code 1
TAX szTaxId String 20 Tax ID
CRCD szCurrencyCode String 4 Currency Code
PORQ cCustomerPORequiredYN Char 1 Customer PO Required (Y/N)
PA8 mnParentNumber Numeric 8 Parent
CM szCreditMessage String 2 Credit Message
EV01 cTerritoryAlign Char 1 Territory Alignment Flag for CRM
PID szProgramID String 10 Program ID
ALKY szAlternateAddressKey String 20 Alternate Address Key
TRAR szPaymentTermsA/R String 3 Payment Terms - A/R
HOLD szHoldOrderCode String 20 Hold Alternate Code
EFTB jdDateBeginningEffective Date 6 Date - Beginning Effective Date
DC szDescripCompressed String 40 DescriptionCompressed
TAXC cPersonCorporationCode Char 1 Person/CorporationCode
AT2 cAddressType2 Char 1 AR/APNettingIndicator
ATP cAddressTypePayables Char 1 AddressType–Payables
ATPR cAddTypeCode4Purch Char 1 AddressTypeCode–Purchaser
AB3 cMiscCode3 Char 1 AddressTypeMiscellaneous Code(future)
ATE cAddressTypeEmployee Char 1 AddressTypeEmployee
SBLI cSubledgerInactiveCode Char 1 SubledgerInactiveCode
AN81 mnAddressNumber1st Numeric 8 Customer
AN82 mnAddressNumber2nd Numeric 8 Customer
AN83 mnAddressNumber3rd Numeric 8 Customer
AN84 mnAddressNumber4th Numeric 8 Customer
AN85 mnAddressNumber5th Numeric 8 Factor–SpecialPayee
CUSTS cCustomerStatus Char 1 CustomerStatus
DAOJ jdDateAccountOpened Date 6 Date–AccountOpened
AT3 cAddressType3 Char 1 HCMRecordsExist
AT4 cAddressType4 Char 1 AddressType–4
AT5 cAddressType5 Char 1 AddressType–5
ATR cAddressTypeReceivables Char 1 AddressType–Receivables
AN86 mnAddressNumber6th Numeric 8 AddressNumber5th
TXCT szCertificateTaxExempt String 20 CertificateTaxExemption
TICKER szTicker String 10 Ticker
DUNS szDUNSNumber String 13 DUNSNumber
NOE mnNumberOfEmployee Numeric 15 NumberofEmployees
YEARSTAR szYearStarted String 15 YearStarted
ACL mcAmountCreditLimit Numeric 15 Amount–CreditLimit
HDAR cArHoldInvoices Char 1 HoldInvoices
STMT cPrintStatementYN Char 1 PrintStatementY/N
ATCS cAutoCash Char 1 AutoReceiptY/N
CKHC cCreditCkHandlingCode Char 1 CreditCheckHandlingCode
DLC jdDateLastCreditReview Date 6 Date–LastCreditReview
DB szDunBradstreetRating String 3 Dun&BradstreetRating
MAXO mnMaximumOrderValue Numeric 15 MaximumOrderValue
MINO mnMinimumOrderValue Numeric 15 MinimumOrderValue
FRTH szFreightHandlingCode String 3 FreightHandlingCode
APTS cParticalShipmentsAllowY Char 1 PartialLineShipmentsAllowed Y/N
SBAL cSubstitutesAllowedYN Char 1 SubstitutesAllowedY/N
BACK cBackordersAllowedYN Char 1 BackordersAllowedY/N
INVC mnInvoiceCopies Numeric 2 InvoiceCopies
ICON cInvoiceConsolidation Char 1 InvoiceConsolidation
BLFR cBillFrequency Char 1 BillingFrequency
VUMD szUnitOfMeasureVolDisp String 2 UnitofMeasure–Volume Display
WUMD szUnitOfMeasureWhtDisp String 2 UnitofMeasure–Weight Display
EDF1 cDeliveryNote Char 1 DeliveryNote
SIO1 cSpecialInstruction01 Char 1 PartialOrderShipmentAllowed Y/N
CRMD cCorrespondenceMethod Char 1 SendMethod
RQ01 cRequiresPackgingCode Char 1 RequiresPackagingCode
RQ02 cRequiresWeightCode Char 1 RequiresWeightCode
RQ05 cRequiresTransportationMe Char 1 RequiresTransportationMethod
RQ06 cRequiresRouting Char 1 RequiresRouting
AN8R mnRelatedAddressNo Numeric 8 RelatedAddressNumber

2.5.2.2 Conceptual Approach

A customer record added, modified, or deleted in the JD Edwards EnterpriseOne system creates a new record in a number of tables such as the Customer Master by Line of Business (F03012) and Address Book Master (F0101) tables. A real-time notification event is triggered in the Customer Master or Address Book Master Business Function after data is modified in any customer table.

2.5.2.3 Objects that Can Initiate the Event

These objects can initiate the RTCMHDR2 event:

  • N0100041 -Address Book MBF

  • N0100042 -Customer Master MBF

  • P0111 -Whos Who application

  • P0115 -Phones application

  • P01111 -Contact Information E-mail application

  • B0100073 -Electronic Address -Phones business function

  • B0100077 -Customer Master Real-Time Event notification function

  • B0100096 -Customer Master Real Time Wrapper

  • B0100089 -Electronic Address MBF

  • B0100090 -Phones MBF

  • P90CA080 -Customer

2.5.3 RTCMOUT3

RTCMOUT3 is used by the JD Edwards EnterpriseOne system to notify third-party systems of customer additions, changes, or deletions.

Event Name

RTCMOUT3

Event Description

RTCMOUT

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTCMHDR3 (D0100091A)

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for more information about the fields, conceptual approach, and processes that can initiate this event.

2.5.3.1 Special Setup

RTCMOUT3 has some additional special setup requirements due to the logic in the real-time wrapper.

The processing option for version ZJDE001 of the Customer Master Real Time Event Wrapper Application program (P0100077) determines whether RTCMOUT3 is always sent or is sent only if certain fields are changed. The purpose of the processing option is to enable filtering of the outbound event, RTCMOUT3.

When the processing option is 0, blank, or null, no filtering occurs, and RTCMOUT3 is sent whenever a change is made to a customer master record. If the processing option is 1, an event is sent only if one of the five territory alignment fields have been changed. Events always occur on an Add or Delete. The five territory alignment fields are Industry Classification Code, City, State, Zip, and Country. If one of these fields have changed and the filter is turned off, a flag is set in a cTerritoryAlign parameter in the event data structure. This flag is a signal that something has changed in those five fields.

2.5.4 RTCMHDR3

RTCMHDR3 is used by the JD Edwards EnterpriseOne system to notify third-party systems of customer additions, changes, or deletions.

Event Name

RTCMHDR3

Event Description

CM Header3

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100091A: Customer Master Real Time Record

Event Relationship

Included in container event RTCMOUT.

2.5.4.1 Event Fields

The RTCMHDR3 event contains the same fields as the RTCMHDR event. Additionally the RTCMHDR3 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
GAN8 szGlobalLocatorNumber String 13 Global Locator Number
GPA8 szParentAddressGLN String 13 Address Number Parent GLN

2.5.4.2 Conceptual Approach

A customer record added, modified, or deleted in the JD Edwards EnterpriseOne system creates a new record in a number of tables such as Customer Master by Line of Business (F03012) and Address Book Master (F0101) tables. A real-time notification event is triggered in the Customer Master or Address Book Master Business Function after data is modified to any customer table.

2.5.4.3 Objects that Can Initiate the Event

These objects can initiate the RTCMHDR3 event:

  • N0100041 - Address Book MBF

  • N0100042 - Customer Master MBF

  • P0111 - Whos Who application

  • P0115 - Phones application

  • P01111 - Contact Information E-mail application

  • B0100073 - Electronic Address - Phones business function B0100077 - Customer Master Real-Time Event notification function

  • B0100077 - Customer Master Real Time Wrapper

  • B0100089 - Electronic Address MBF

  • B0100090 - Phones MBF

2.5.5 RTCMPHOUT2

RTCMPHOUT2 is used by the JD Edwards EnterpriseOne system to inform third-party systems of customer phone number changes.

Event Name

RTCMPHOUT2

Event Description

CM Phone

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100096E

Event Relationship

Included in container event RTCMOUT2.

2.5.5.1 Event Fields

The RTCMPHOUT2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 AddressNumber
CO szCompany String 5 Company
ACTN cPhoneActionCode Char 1 ActionType
IDLN mnLineNumberID Numeric 5 LineNumberID
CNLN mnContactPersonID Numeric 5 ContactLineNumber
RCK7 mnSequenceNumber Numeric 8 SequencenumberinF0115table ofrecord
PID szProgramID String 10 ProgramID
GENLNG idEventID Identifier 11 GeneridLongID–EnterpriseOne
EV01 cErrorID Char 1 ErrorID
EV01 cErrorStatus Char 1 ErrorStatus
VER szVersionconsolidated String 10 Version
EV01 cTerritoryAlign Char 1 TerritoryAlignment
EV01 cErrorAPIEventReturn Char 1 ErrorAPIEventReturn

2.5.5.2 Conceptual Approach

A phone number is changed in the JD Edwards EnterpriseOne system for a customer. This change is sent using RTEs. A given customer may have an infinite number of phone numbers.

2.5.5.3 Objects that Can Initiate the Event

These objects can initiate the RTCMHDR2 event:

  • N0100041 -Address Book MBF

  • N0100042 -Customer Master MBF

  • P0111 -Whos Who application

  • P0115 -Phones application

  • P01111 -Contact Information E-mail application

  • B0100073 -Electronic Address -Phones business function

  • B0100096 -Customer Master Real Time Wrapper

  • B0100089 -Electronic Address MBF

  • B0100090 -Phones MBF

2.5.6 RTCMEAOUT2

RTCMEAOUT2 is used by the JD Edwards EnterpriseOne system to inform third-party systems of customer email address changes.

Event Name

RTCMEAOUT2

Event Description

Customer E-mail

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100096C

Event Relationship

Included in container event RTCMOUT2.

2.5.6.1 Event Fields

The RTCMEAOUT2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 Address number of customer
CO szCompany String 5 Company
IDLN mnLineNumberID Numeric 8 who's who number of customer
RCK7 mnSequenceNumber70 Numeric 8 Sequence number of record in F01151 table
ACTN cElectrAddressActionCode Char 1 ActionType
PID szProgramId String 10 ProgramID
GENLNG idEventID Identifier 11 GeneridLongID–EnterpriseOne
EV01 cErrorID Char 1 ErrorID
VER szVersionconsolidated String 10 Version
EV01 cErrorStatus Char 1 ErrorStatus
EV01 cTerritoryAlign Char 1 TerritoryAlignment
EV01 cErrorAPIEventReturn Char 1 ErrorAPIEventReturn

2.5.6.2 Conceptual Approach

An email address is added or changed in the JD Edwards EnterpriseOne system for a customer. This change is sent using RTEs. A given customer may have an infinite number of email addresses.

2.5.6.3 Objects that Can Initiate the Event

These are the objects that can initiate the event:

  • N0100041 -Address Book MBF

  • N0100042 -Customer Master MBF

  • P0111 -Whos Who application

  • P0115 -Phones application

  • P01111 -Contact Information E-mail application

  • B0100073 -Electronic Address -Phones business function

  • B0100096 -Customer Master Real Time Wrapper

  • B0100089 -Electronic Address MBF

  • B0100090 -Phones MBF

2.5.7 RTCMAAOUT

RTCMAAOUT is used by the JD Edwards EnterpriseOne system to inform third-party systems of alternate address data changes for customers.

Event Name

RTCMAAOUT

Event Description

Customer Alternate Address

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100096D

Event Relationship

Included in container event RTCMOUT2.

2.5.7.1 Event Fields

The RTCMAAOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 AddressNumber
IDLN mnLineNumberID Numeric 5 LineNumberID
CO szCompany String 5 Company
ATYPE szTypeAddress String 5 Type – Address
EFTB jdDateBeginningEffective Date 6 Date–BeginningEffective
ACTN cAlternateAddressActionCode Char 1 ActionType
PID szProgramId String 10 ProgramID
GENLNG idEventID Identifier 11 GeneridLongID–EnterpriseOne
EV01 cErrorID Char 1 ErrorID
VER szVersionconsolidation String 10 Version
EV01 cErrorStatus Char 1 ErrorStatus
EV01 TerritoryAlign Char 1 TerritoryAlignment
EV01 cErrorAPIEventReturn Char 1 ErrorAPIEventReturn

2.5.7.2 Conceptual Approach

An alternate address is added or changed in the JD Edwards EnterpriseOne system for a customer. This change is sent using RTEs. A given customer may have an infinite number of alternate addresses.

2.5.7.3 Objects that Can Initiate the Event

These objects can initiate the event:

  • N0100041 -Address Book MBF

  • N0100042 -Customer Master MBF

  • P0111 -Whos Who application

  • P0115 -Phones application

  • P01111 -Contact Information E-mail application

  • B0100073 -Electronic Address -Phones business function

  • B0100096 -Customer Master Real Time Wrapper

  • B0100089 -Electronic Address MBF

  • B0100090 -Phones MBF

2.5.8 RTCMCCOUT2

RTCMCCOUT2 is used by the JD Edwards EnterpriseOne system to inform third-party systems of customer category code changes.

Event Name

RTCMCCOUT2

Event Description

Customer Category Codes

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100096I

Event Relationship

Included in container event RTCMOUT2.

2.5.8.1 Event Fields

The RTCMCCOUT2 event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AN8 mnAddressNumber Numeric 8 Customer Address Number
AC01 szReportCodeAddBook001 String 3 Customer Category Code
AC02 szReportCodeAddBook002 String 3 Customer Category Code
AC03 szReportCodeAddBook003 String 3 Customer Category Code
AC04 szReportCodeAddBook004 String 3 Customer Category Code
AC05 szReportCodeAddBook005 String 3 Customer Category Code
AC06 szReportCodeAddBook006 String 3 Customer Category Code
AC07 szReportCodeAddBook007 String 3 Customer Category Code
AC08 szReportCodeAddBook008 String 3 Customer Category Code
AC09 szReportCodeAddBook009 String 3 Customer Category Code
AC10 szReportCodeAddBook010 String 3 Customer Category Code
AC11 szReportCodeAddBook011 String 3 Customer Category Code
AC12 szReportCodeAddBook012 String 3 Customer Category Code
AC13 szReportCodeAddBook013 String 3 Customer Category Code
AC14 szReportCodeAddBook014 String 3 Customer Category Code
AC15 szReportCodeAddBook015 String 3 Customer Category Code
AC16 szReportCodeAddBook016 String 3 Customer Category Code
AC17 szReportCodeAddBook017 String 3 Customer Category Code
AC18 szReportCodeAddBook018 String 3 Customer Category Code
AC19 szReportCodeAddBook019 String 3 Customer Category Code
AC20 szReportCodeAddBook020 String 3 Customer Category Code
AC21 szCategoryCodeAddressBook2 String 3 Customer Category Code
AC22 szCategoryCodeAddressBk22 String 3 Customer Category Code
AC23 szCategoryCodeAddressBk23 String 3 Customer Category Code
AC24 szCategoryCodeAddressBk24 String 3 Customer Category Code
AC25 szCategoryCodeAddressBk25 String 3 Customer Category Code
AC26 szCategoryCodeAddressBk26 String 3 Customer Category Code
AC27 szCategoryCodeAddressBk27 String 3 Customer Category Code
AC28 szCategoryCodeAddressBk28 String 3 Customer Category Code
AC29 szCategoryCodeAddressBk29 String 3 Customer Category Code
AC30 szCategoryCodeAddressBk30 String 3 Customer Category Code

2.5.8.2 Conceptual Approach

A customer's category code data is added or changed in the JD Edwards EnterpriseOne system. This change is sent out using RTEs.

2.5.8.3 Objects that Can Initiate the Event

These objects can initiate the event:

  • N0100041 -Address Book MBF

  • N0100042 -Customer Master MBF

  • P0111 -Whos Who application

  • P0115 -Phones application

  • P01111 -Contact Information E-mail application

  • B0100073 -Electronic Address -Phones business function

  • B0100096 -Customer Master Real Time Wrapper

  • B0100089 -Electronic Address MBF

  • B0100090 -Phones MBF

2.5.9 RTABCCOUT

RTABCCOUT is used by the JD Edwards EnterpriseOne system to inform third-party systems of address book category code changes.

Event Name

RTABCCOUT

Event Description

Address Book Category Codes

Event Type

RTE

Event Category

SINGLE

Product Code

01

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0100096H

Event Relationship

Included in container event RTCMOUT2.

2.5.9.1 Event Fields

The RTABCCOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
AC01 szReportCodeAddBook001 String 3 Customer Category Code
AC02 szReportCodeAddBook002 String 3 Customer Category Code
AC03 szReportCodeAddBook003 String 3 Customer Category Code
AC04 szReportCodeAddBook004 String 3 Customer Category Code
AC05 szReportCodeAddBook005 String 3 Customer Category Code
AC06 szReportCodeAddBook006 String 3 Customer Category Code
AC07 szReportCodeAddBook007 String 3 Customer Category Code
AC08 szReportCodeAddBook008 String 3 Customer Category Code
AC09 szReportCodeAddBook009 String 3 Customer Category Code
AC10 szReportCodeAddBook010 String 3 Customer Category Code
AC11 szReportCodeAddBook011 String 3 Customer Category Code
AC12 szReportCodeAddBook012 String 3 Customer Category Code
AC13 szReportCodeAddBook013 String 3 Customer Category Code
AC14 szReportCodeAddBook014 String 3 Customer Category Code
AC15 szReportCodeAddBook015 String 3 Customer Category Code
AC16 szReportCodeAddBook016 String 3 Customer Category Code
AC17 szReportCodeAddBook017 String 3 Customer Category Code
AC18 szReportCodeAddBook018 String 3 Customer Category Code
AC19 szReportCodeAddBook019 String 3 Customer Category Code
AC20 szReportCodeAddBook020 String 3 Customer Category Code
AC21 szCategoryCodeAddressBook2 String 3 Customer Category Code
AC22 szCategoryCodeAddressBk22 String 3 Customer Category Code
AC23 szCategoryCodeAddressBk23 String 3 Customer Category Code
AC24 szCategoryCodeAddressBk24 String 3 Customer Category Code
AC25 szCategoryCodeAddressBk25 String 3 Customer Category Code
AC26 szCategoryCodeAddressBk26 String 3 Customer Category Code
AC27 szCategoryCodeAddressBk27 String 3 Customer Category Code
AC28 szCategoryCodeAddressBk28 String 3 Customer Category Code
AC29 szCategoryCodeAddressBk29 String 3 Customer Category Code
AC30 szCategoryCodeAddressBk30 String 3 Customer Category Code

2.5.9.2 Conceptual Approach

A customer's address-book category-code data is added or changed in the JD Edwards EnterpriseOne system. This change is sent using real-time events.

2.5.9.3 Objects that Can Initiate the Event

These objects can initiate the event:

  • N0100041 -Address Book MBF

  • N0100042 -Customer Master MBF

  • P0111 -Whos Who application

  • P0115 -Phones application

  • P01111 -Contact Information E-mail application

  • B0100073 -Electronic Address -Phones business function

  • B0100096 -Customer Master Real Time Wrapper

  • B0100089 -Electronic Address MBF

  • B0100090 -Phones MBF

2.6 Direct Connect

This section provides information about the events that enable you to connect to a Direct Connect supplier's website in order to select items for a requisition.

Important:

In previous releases, the Direct Connect solution used RTEs to integrate with third-party systems. In 9.0, Direct Connect uses Service Oriented Architecture (SOA) integration technology, and does not use RTEs. The events remain in the current version of the software, but are no longer used for the Direct Connect process. Because the events remain in the software, the documentation for each of these events is included in this section.

For additional information about the current Direct Connect solution, review the current documentation for the JD Edwards Requisition Self Service product. If you are using these events to support the Direct Connect integration solution, refer to the 8.12 version of the Requisition Self Service documentation.

See Setting Up Direct Connect and Purchase Order Dispatch in the JD Edwards EnterpriseOne Applications Requisition Self Service Implementation Guide.

2.6.1 Prerequisite

If you are using these events to support Direct Connect, you must set up an XAPI subscriber for Direct Connect.

See JD Edwards EnterpriseOne Tools Interoperability Guide, "Using Guaranteed Events," Establishing Subscriber and Subscription Information, Adding a Subscriber.

2.6.2 RTEMPTYCRT

RTEMPTYCRT is a single event that is generated by the JD Edwards EnterpriseOne system to send a notification that JD Edwards EnterpriseOne has canceled the request to wait for an inbound shopping cart from the supplier.

Event Name

RTEMPTYCRT

Event Description

eReq - Notify Empty Cart RTE

Event Type

RTE

Event Category

SINGLE

Product Code

43E

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D43E0060A: eReq - Notify Empty Shopping Cart RTE

2.6.2.1 Event Fields

The RTEMPTYCRT event contains these field:

Data Item / Alias Structure Member Name Data Type Size Description
COOKIE szBuyerCookie_COOKIE String 200 Buyer Cookie

2.6.2.2 Conceptual Approach

The JD Edwards EnterpriseOne system generates this event when a user cancels a transaction from the JD Edwards EnterpriseOne Direct Connect Shopping Cart application.

2.6.2.3 Objects that Can Initiate the Event

The Direct Connect Application Interface program (P43E23) initiates the RTEMPTYCRT event.

2.6.2.4 Special Setup

You must set up a subscriber event for the RTEMPTYCRT real-time event.

See JD Edwards EnterpriseOne Tools Interoperability Guide, "Using Guaranteed Events," Establishing Subscriber and Subscription Information.

2.6.3 XAPIAUTHEN

XAPIAUTHEN is a container event generated by the JD Edwards EnterpriseOne system to request authentication from a Direct Connect supplier's website and to receive authentication response message.

Event Name

XAPIAUTHEN

Event Description

Authenticate User Credential

Event Type

XAPI

Event Category

CONTAINER

Contains these data structures:

  • D43E0040D - XAPI - User Authentication DS to XML

  • D43E0040E - XAPI Extrinsic Text Substitution

  • DXAPIROUTE - XAPI Call Routing Information

Product Code

43E

Reliable Delivery

1

Delivery Timeout Threshold

0

2.6.3.1 Event Fields for XAPIAUTHEN - D43E0040D

The D43E0040D data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
SIGNON szSenderIdentity_SIGNON String 30 Sign On ID
POEXTR cSendExtrinsicInfo_POEXTR Char 1 Send Extrinsic Information
COMMETHD cPunchOutCommMethd_COMMETHD Char 1 Direct Connect Communication Method
USER szUserID_USER String 10 User ID
FRMIDEN szFromIdentity_FRMIDEN String 31 Buyer organization's Credential Identity
TOIDEN szToIdentity_TOIDEN String 31 Supplier Credential Identity
SENDIDEN szSenderIdentity_SENDIDEN String 31 Sender's Credential Identity
MACALGO szMACAlgorithm_MACALGO String 31 MAC Algorithm
MACTYPE szIMACType_MACTYPE String 31 Credential MAC TYPE
MACVALUE szMACValue_MACVAL String 301 MAC Credential Value
XMLSCH szAuthenReqXMLDocName_XMLSCH String 30 XML Schema
XMLSCH1 szAuthenReqXMLDocName_XMLSCH1 String 30 XML Schema
XMLSCH2 szShpCrtResXMLDocName_XMLSCH2 String 30 XML Schema
XMLVERS szAuthenReqXMLDocVers_XMLVERS String 10 XML Version
XMLVERS1 szAuthenReqXMLDocVers_XMLVERS1 String 10 XML Version 1
XMLVERS2 szShpCrtResXMLDocVers_XMLVERS2 String 10 XML Version 2
COOKIE szBuyerCookie_COOKIE String 200 Buyer Cookie
ALPH szUserAgent_ALPH String 40 Name - Alpha
LNG szLanguageCode_LNG String 3 Language Code
VAL szOperationAllowed_VAL String 40 Values Allowed
PASSWD szSharedSecret_PASSWD String 50 Signon Password
AUTHURL szSupplierAuthenURL_AUTHURL String 3000 Authentication URL
AUTHMTD cPunchOutAuthenMethd_AUTHMTD Char 1 Direct Connect Authentication Method
TODMN szToDomain_TODMN String 31 Supplier Credential Domain
FRMDMN szFromDomain_FRMDMN String 31 Buyer organization's Credential Domain
SENDDMN szSenderDomain_SENDDMN String 31 Sender's Credential Domain
CREATEDT szMACCreationDate_CREATEDT String 30 Creation Date
EXPIREDT szMACExpirationDate_EXPIREDT String 30 Expiration Date

2.6.3.2 Event Fields for XAPIAUTHEN - D43E0040E

The D43E0040E data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
VC30A1 szElementName_VC30A1 String 30 Video Constant A1 - length 30
VC30A2 szElementName_VC30A2 String 30 Video Constant A2 - length 30

2.6.3.3 Conceptual Approach

When the user clicks on the supplier number on the Order Items form of the Direct Connection program (P43E23), the system launches the XAPIAUTHEN event to initiate authentication with the Direct Connect supplier's website.

2.6.3.4 Objects that Can Initiate the Event

The Direct Connect Application Interface program (P43E23) initiates the XAPIAUTHEN event.

2.6.4 XAPIGETCRT

XAPIGETCRT is a container event used to notify the JD Edwards EnterpriseOne Direct Connect Shopping Cart application that the contents of the shopping cart have been sent to JD Edwards EnterpriseOne.

Event Name

XAPIGETCRT

Event Description

XAPI - Get Shopping Cart

Event Type

XAPI

Event Category

CONTAINER

Contains these data structures:

  • D43E0090B - XAPI - Shopping Cart Response

  • DXAPIROUTE - XAPI Call Routing Information

Product Code

43E

Reliable Delivery

1

Delivery Timeout Threshold

0

2.6.4.1 Event Fields

The D43E0090B data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
USER szUserID_USER String 10 User ID
COOKIE szBuyerCookie_COOKIE String 200 Buyer Cookie
LNID mnLineNumber_LNID Numeric 6 Line Number

2.6.4.2 Conceptual Approach

The Get Shopping Cart Response integration service initiates the XAPIGETCRT response message. The system then retrieves the corresponding XAPI message information from the XAPIREQCRT message to communicate with the correct JD Edwards EnterpriseOne user session.

2.6.4.3 Objects that Can Initiate the Event

The convert_cXML_1_2_009_PunchOutOrderMessage_To_E1_XAPIGETCRT service initiates the XAPIGETCRT event.

Note:

This service is not supported as part of the Direct Connect solution in 9.0.

2.6.5 XAPIGETURL

XAPIGETURL is a container event used to receive a Direct Connect supplier's catalog URL.

Event Name

XAPIGETURL

Event Description

XAPI - Get Supp Catalog URL

Event Type

XAPI

Event Category

CONTAINER

Contains these data structures:

  • D43E0050B - XAPI - Populate Catalog URL DataStructure

  • DXAPIROUTE - XAPI Call Routing Information

Product Code

43E

Reliable Delivery

1

Delivery Timeout Threshold

0

2.6.5.1 Event Fields

The D43E0050B data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
COOKIE szBuyerCookie_COOKIE String 200 Buyer Cookie
STAT szResponseStatus_STAT String 3 Lease/Tract Status Code
DTAI szStatusDescription_DTAI String 10 Data Item
AUTHURL szSupplierCatalogURL_AUTHURL String 3000 Authentication URL

2.6.5.2 Conceptual Approach

The authentication integration service initiates the XAPIGETURL response message.

2.6.5.3 Objects that Can Initiate the Event

The convert_E1_XAPIAUTHEN_To_cXML_1_2_009_And_Response service initiates the XAPIGETCRT event.

Note:

This service is not supported as part of the Direct Connect solution in 9.0.

2.6.6 XAPIREQCRT

XAPIREQCRT is a container event used by the JD Edwards EnterpriseOne system to send a notification that JD Edwards EnterpriseOne is waiting for an inbound shopping cart request from a Direct Connect supplier's website.

Event Name

XAPIREQCRT

Event Description

XAPI - Request Shopping Cart

Event Type

XAPI

Event Category

CONTAINER

Contains these data structures:

  • D43E0080D - XAPI - Get Supplier Shopping Cart Response

  • DXAPIROUTE - XAPI Call Routing Information

Product Code

43E

Reliable Delivery

1

Delivery Timeout Threshold

0

2.6.6.1 Event Fields

The D43E0080D data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
USER szUserID_USER String 10 User ID
COOKIE szBuyerCookie_COOKIE String 200 Buyer Cookie
PEID mnProcessID_PEID Numeric 15 Process ID
TCID mnTransactionID_TCID Numeric 15 Transaction ID
JOBS mnJobNumber_JOBS Numeric 8 Job Number
CTID szComputerID_CTID String 15 Computer ID
AN8V mnSupplierNumber_AN8V Numeric 8 Address Number - Supplier

2.6.6.2 Conceptual Approach

After the Direct Connect supplier has authenticated a user's credentials, the JD Edwards EnterpriseOne system triggers this event to notify the Integration Server to listen for the XAPIGETCRT event that will come from the supplier's website.

Note:

This integration approach is not supported as part of the Direct Connect solution in 9.0.

2.6.6.3 Objects that Can Initiate the Event

The Direct Connect Application Interface program (P43E23) initiates the XAPIAUTHEN event.

2.7 Employee

This section discusses the real-time events generated by changes to employee records.

2.7.1 RTEMOUT

RTEMOUT is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to employee master records (F060116).

Event Name

RTEMOUT

Event Description

Employee Master RTE

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTEMOUTB (D0500873B)

  • RTEMOUTC (D0500873C)

  • RTEMOUTD (D0500873D)

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500873A: Employee Master RTE Notification A Structure

2.7.1.1 Event Fields

The RTEMOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
EV01 cEventCode Char 1 Event Point 01
VC10A szContainerEventName String 10 Video Constant A - length 10
VC10A szF060116EventName String 10 Video Constant A - length 10
VC10A szF060117EventName String 10 Video Constant A - length 10
VC10A szF060120EventName String 10 Video Constant A - length 10
GENLNG idEventID Identifier 11 Generid Long ID - JD Edwards EnterpriseOne
VC30A szCallingFunctionName String 30 Video Constant A - length 30
VC30A szEventScope String 30 Video Constant A - length 30
EV01 cSuppressError Char 1 Event Point 01
DTAI szErrorID String 10 Data Item
EV01 cActionCode Char 1 Event Point 01
AN8 mnAddressNumber Number 8 Address Number

2.7.1.2 Conceptual Approach

When a user adds, modifies, or deletes employee master data from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTEMOUT event is a container event activated on the F060116, F060117, and F060120 table triggers and contains all columns from the modified records and an action code specifying what action was performed on the data (added, changed, deleted). Whenever data from one of the tables handled by the container event (F060116, F060117, and F060120) is modified, the corresponding record from the other table is automatically fetched and included in the container.

2.7.1.3 Objects that Can Initiate the Event

These objects can initiate the RTEMOUTB event:

  • F060116 - Employee Master Information table trigger

  • F060117 - Employee Master - International Data table trigger

  • F060120 - Employee Master - Additional Information table trigger

  • B0500575 - Employee Master Business Function

  • B0500873 - Employee Master RTE Notification

2.7.2 RTEMOUTB

RTEMOUTB is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to employee master records (F060116).

Event Name

RTEMOUTB

Event Description

F060116 Detail

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500873B: Employee Master RTE Notification B Structure

Relationship

Included in container event RTEMOUT.

2.7.2.1 Event Fields

The RTEMOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
AN8 mnAddressNumber Number 8 Address Number
ALPH szAlphaName String 40 Name - Alpha
SSN szSocialSecurityNumber String 20 Employee Tax ID
OEMP szAdditionalEENumber String 8 Additional Employee No
SEX cGender Char 1 Gender (Male/Female)
MSTX cMaritalStatusTax Char 1 Marital Status - Tax
MSTI cMaritalStatusState Char 1 Marital Status - State Tax
EIC cEICStatus Char 1 Earned Income Credit Status
EST cEmploymentStatus Char 1 Employee Status
TARR szTaxAreaResidence String 10 Tax Area (Residence)
TARA szTaxAreaWork String 10 Tax Area (Work)
SCDC mnSchoolDistrictCode Number 5 School District Code
HMCO szHomeCompany String 5 Company - Home
MCU szBusinessUnit String 12 Business Unit
HMCU szHomeBusinessUnit String 12 Business Unit - Home
MAIL szRoutingCode String 10 Routing Code - Check
PAST cPayStatus Char 1 Employee Pay Status
PFRQ cPayFrequency Char 1 Pay Frequency
SALY cPayClass Char 1 Pay Class (H/S/P)
UN szUnionCode String 6 Union Code
JBCD szJobType String 6 Job Type (Craft) Code
JBST szJobStep String 4 Job Step
EEOJ szJobCategory String 3 Job Category (EEO)
EEOM szEthnicCode String 2 Ethnic Code
TRS szChangeReason String 3 Change Reason
WCMP szWokersCompCode String 4 Worker's Comp. Insurance Code
FLSA cFLSAExempt Char 1 FLSA Exempt Y/N
SHFT cShiftCode Char 1 Shift Code
SAL mnAnnualSalary Number 11 Rate - Salary, Annual
PHRT mnHourlyRate Number 9 Rate - Hourly
STDH mnStandardHoursPayPeriod Number 5 Hours - Standard per Payperiod
STDD mnStandardHoursDay Number 5 Hours - Standard pr Day
SDYY mnDaysStandardYear Number 5 Days - Standard per Year
IFN cFirstNameInitial Char 1 Initial - First Name (Govt Rpts)
IMN cMiddleNameInitial Char 1 Initial - Middle Name (Govt Rpts)
DOB jdDateOfBirth Date 6 Date - Birth
DSI jdDateOriginalEmployment Date 6 Date - Original Employment
DT jdDateTerminated Date 6 Date - Terminated
DST jdDateStarted Date 6 Data Item - Secondary
PSDT jdDatePayStarts  Date 6 Date - Pay Starts
PTDT jdDatePayStops Date 6 Date - Pay Stops
DR jdDateLastRaise Date 6 Date - Last Raise
LADT jdLOAExpirationDate Date 6 Date - LOA Expiration Date
CPDT jdDateCurrentPosition Date 6 Date - Current Position
P001 szCategoryCodePayroll001 String 3 Category Codes - Payroll1
P002 szCategoryCodePayroll002 String 3 Category Codes - Payroll2
P003 szCategoryCodePayroll003 String 3 Category Codes - Payroll3
P004 szCategoryCodePayroll004 String 3 Category Codes - Payroll4
P005 szCategoryCodePayroll005 String 3 Category Codes - Payroll5
P006 szCategoryCodePayroll006 String 3 Category Codes - Payroll6
P007 szCategoryCodePayroll007 String 3 Category Codes - Payroll7
P008 szCategoryCodePayroll008 String 3 Category Codes - Payroll8
P009 szCategoryCodePayroll009 String 3 Category Codes - Payroll9
P010 szCategoryCodePayroll010 String 3 Category Codes - Payroll10
P011 szCategoryCodePayroll011 String 3 Category Codes - Payroll11
P012 szCategoryCodePayroll012 String 3 Category Codes - Payroll12
P013 szCategoryCodePayroll013 String 3 Category Codes - Payroll13
P014 szCategoryCodePayroll014 String 3 Category Codes - Payroll14
P015 szCategoryCodePayroll015 String 3 Category Codes - Payroll15
P016 szCategoryCodePayroll016 String 3 Category Codes - Payroll16
P017 szCategoryCodePayroll017 String 3 Category Codes - Payroll17
P018 szCategoryCodePayroll018 String 3 Category Codes - Payroll18
P019 szCategoryCodePayroll019 String 3 Category Codes - Payroll19
P020 szCategoryCodePayroll020 String 3 Category Codes - Payroll20
SOCC szOccupationClassCode String 4 Standard Occupational Class Code
IH mnWorkHoursPerYear Number 7 Hours per Standard Year
CCPR szCountryCode String 3 Country Code
TCNF cThirdCtryNationalFlag Char 1 Third Country National Flag
RAF cResidentAlienFlag Char 1 Resident Alien Flag
WET cWCSubClass Char 1 Sub Class - Workers Comp
RMST cMaritalStatusResidentState Char 1 Marital Status - Resident State
LMST cMaritalStatusLocalArea Char 1 Local Area Marital Status
LSDT jdLOABeginDate Date 6 Date - LOA Beginning Date
PADT jdDateParticipation Date 6 Date - Participation
DTSP jdDateTimeStamp Date 6 Date - Time Stamp
DOBM mnBirthDateMonth Number 2 Birthday - Month
DSTM mnStartDateMonth Number 2 Startdate - Month
PSAL mnRatePreviousSalary Number 11 Rate - Previous Salary
LSAL mnRateLifeInsSalary Number 13 Rate - Life Ins. Annual Salary
DIVC szBenefitGroup String 6 Benefit Group
ANPA mnSupervisor Number 8 Supervisor
PGRD szPayGrade String 6 Pay Grade
PGRS szPayGradeStep String 4 Pay Grade Step
SLOC szSalaryDataLocality String 8 Salary Date Locality
NRVW jdDateNextReview Date 6 Date - Next Review
TINC cTypeOfIncreseNextRev Char 1 Type of Increase Next Review
HM01 cEEOI9Status Char 1 EEO - I9 Status
HM02 cEEOVeteran Char 1 Veteran
HM03 cEEODisabledVeteran Char 1 EEO - Disabled Veteran
HM04 cEEODisability Char 1 EEO - Disability
POS szPositionID String 8 Position ID
ED01 jdDateUserDefined01 Date 6 Date - User Defined1
ED02 jdDateUserDefined02 Date 6 Date - User Defined2
ED03 jdDateUserDefined03 Date 6 Date - User Defined3
ED04 jdDateUserDefined04 Date 6 Date - User Defined4
ED05 jdDateUserDefined05 Date 6 Date - User Defined5
ED06 jdDateUserDefined06 Date 6 Date - User Defined6
ED07 jdDateUserDefined07 Date 6 Date - User Defined7
ED08 jdDateUserDefined08 Date 6 Date - User Defined8
ED09 jdDateUserDefined09 Date 6 Date - User Defined9
ED10 jdDateUserDefined10 Date 6 Date - User Defined10
ED11 jdDateUserDefined11 Date 6 Date - User Defined11
ED12 jdDateUserDefined12 Date 6 Date - User Defined12
ED13 jdDateUserDefined13 Date 6 Date - User Defined13
ED14 jdDateUserDefined14 Date 6 Date - User Defined14
ED15 jdDateUserDefined15 Date 6 Date - User Defined15
ED16 jdDateUserDefined16 Date 6 Date - User Defined16
ED17 jdDateUserDefined17 Date 6 Date - User Defined17
ED18 jdDateUserDefined18 Date 6 Date - User Defined18
ED19 jdDateUserDefined19 Date 6 Date - User Defined19
ED20 jdDateUserDefined30 Date 6 Date - User Defined20
DEPT szDepartmentCode String 12 Department Code
FAGE mnAgeEmployee Number 3 Age - Employee
FSAL mnSalaryFixed Number 15 Rate - Life Ins. Annual Salary
CMPA mnCompaRatio Number 5 Compa-Ratio
JOBN szWorkStationID String 10 Work Station ID
USER szUserID String 10 User ID
PID szProgramID String 10 Program ID
UPMJ jdDateUpdated Date 6 Date - Updated
BENS cEmployeeBenefitStatus Char 1 Employee Benefit Status
FTE mnFullTimeEquivalents Number 9 Full Time Equivalents
SMOY mnMonthsStandardPerYear Number 5 Periods Paid Per Year

2.7.2.2 Conceptual Approach

When a user adds, modifies, or deletes employee master data, F060116 table only, from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTEMOUT event is a container event activated on the F060116 table trigger and contains all columns from the modified employee master record (F060116) and an action code specifying what action was performed on the data (added, changed, deleted). Whenever data from one of the tables handled by the container event (F060116, F060117, and F060120) is modified, the corresponding record from the other table is automatically fetched and included in the container.

2.7.2.3 Objects that Can Initiate the Event

These objects can initiate the RTEMOUTB event:

  • F060116 - Employee Master Information table trigger

  • B0500575 - Employee Master Business Function

  • B0500873 - Employee Master RTE Notification

2.7.3 RTEMOUTC

RTEMOUTC is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to employee master records (F060117).

Event Name

RTEMOUTC

Event Description

F060117 Detail

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500873C: Employee Master RTE Notification C Structure

Relationship

Included in container event RTEMOUT.

2.7.3.1 Event Fields

The RTEMOUTC event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
AN8 mnAddressNumber Number 8 Address Number
NAMP szEmployeeName String 50 Name - Employee
MALP szBirthName String 40 Name - Birth
LNGP szLanguage String 2 Language
SALU szSalutation String 5 Salutation
SUFF szSuffix String 5 Suffix
PRNM szPreferredName String 20 Preferred Name
CRCD szCurrencyCodeFrom String 3 Currency Code - From

2.7.3.2 Conceptual Approach

When a user adds, modifies, or deletes employee master data, F060117 table only, from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTEMOUT event is a container event activated on the F060117 table trigger and contains all columns from the modified employee master record (F060117) and an action code specifying what action was performed on the data (added, changed, deleted). Whenever data from one of the tables handled by the container event (F060116, F060117, and F060120) is modified, the corresponding record from the other table is automatically fetched and included in the container.

2.7.3.3 Objects that Can Initiate the Event

These objects can initiate the RTEMOUTC event:

  • F060117 - Employee Master - International Data table trigger

  • B0500575 - Employee Master Business Function

  • B0500873 - Employee Master RTE Notification

2.7.4 RTEMOUTD

RTEMOUTD is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to employee master records (F060120).

Event Name

RTEMOUTD

Event Description

F060120 Detail

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500873D: Employee Master RTE Notification D Structure

Relationship

Included in container event RTEMOUT.

2.7.4.1 Event Fields

The RTEMOUTD event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
AN8 mnAddressNumber Number 8 Address Number
MSA cActualMaritalStatus Char 1 Marital Status - Actual
CTBB szCountryBirth String 3 Country - Birth
CTB1 szNationality1st String 3 Nationality - 1st (Citizenship)
CTB2 szNationality2nd String 3 Nationality - 2nd
CTB3 szNationality3rd String 3 Nationality - 3rd
JBCX szJobTitle String 30 Job Title
CDIJ jdDateInCurrentJob Date 6 Date in Current Job
ORMCU szOrganizationalBusinessUnit String 12 Organizational Business Unit
LSRD jdLastSalaryReviewDate Date 6 Last Compensation Review Date
NSRD jdNextSalaryReviewDate Date 6 Next Compensation Review Date
PAPL mnPerformanceAppraisalLevel Number 6 Performance Appraisal Level
TIRNK mnTierRanking Number 5 Tier/Ranking
TRNKD jdLastTierRankDate Date 6 Last Tier/Rank date
JBPCTRQD mnTotalJobCompetencyPercent Number 15 Total Job Competency Percent Achieved
LTJCRW jdLastTotalJobCompetencyReview Date 6 Last Total Job Competency review date
DATRVW jdDateLastReviewed Date 6 Date Last Reviewed
RWTYP cReviewType Char 1 Review Type
TINCL cTypeIncreaseLastReview Char 1 Type of Increase Next Review

2.7.4.2 Conceptual Approach

When a user adds, modifies, or deletes employee master data, F060120 table only, from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTEMOUT event is a container event activated on the F060120 table trigger and contains all columns from the modified employee master record (F060120) and an action code specifying what action was performed on the data (added, changed, deleted). Whenever data from one of the tables handled by the container event (F060116, F060117, and F060120) is modified, the corresponding record from the other table is automatically fetched and included in the container.

2.7.4.3 Objects that Can Initiate the Event

These objects can initiate the RTEMOUTD event:

  • F060120 - Employee Master - Additional Information table trigger

  • B0500575 - Employee Master Business Function

  • B0500873 - Employee Master RTE Notification

2.7.5 RTPIOUT

RTPIOUT is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to employee master records (F060116). This message is similar to the message issued by RTEMOUT.

Event Name

RTPIOUT

Event Description

Person Information RTE

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTPIOUTB (D0500881B)

  • RTPIOUTC (D0500881C)

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500873A: Employee Master RTE Notification A Structure

2.7.5.1 Event Fields

The RTPIOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
EV01 cEventCode Char 1 Event Point 01
VC10A szContainerEventName String 10 Video Constant A - length 10
VC10A szF060116EventName String 10 Video Constant A - length 10
VC10A szF060117EventName String 10 Video Constant A - length 10
VC10A szF060120EventName String 10 Video Constant A - length 10
GENLNG idEventID Identifier 11 Generid Long ID - JD Edwards EnterpriseOne
VC30A szCallingFunctionName String 30 Video Constant A - length 30
VC30A szEventScope String 30 Video Constant A - length 30
EV01 cSuppressError Char 1 Event Point 01
DTAI szErrorID String 10 Data Item
EV01 cActionCode Char 1 Event Point 01
AN8 mnAddressNumber Number 8 Address Number

2.7.5.2 Conceptual Approach

When a user adds, modifies, or deletes employee master data from the JD Edwards EnterpriseOne system, the system publishes an event. The RTPIOUT event is a container event activated within the employee master business function and contains a specific subset of columns, and an action code specifying what action was performed on the data (added, changed, deleted). Whenever data from one of the tables handled by the container event (F060116 and F060117) is modified the corresponding record from the other table is automatically fetched and included in the container.

2.7.5.3 Objects that Can Initiate the Event

These objects can initiate the RTPIOUTB event:

  • B0500575 - Employee Master Business Function

  • B0500881 - Person Information RTE Notification

2.7.6 RTPIOUTB

RTPIOUTB is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to employee master records (F060116). This message is similar to the message issued by RTEMOUTB.

Event Name

RTPIOUTB

Event Description

F060116 Detail

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500881B: Person Information RTE Notification B Structure

Relationship

Included in container event RTPIOUT.

2.7.6.1 Event Fields

The RTPIOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
AN8 mnAddressNumber Number 8 Address Number
SEX cGender Char 1 Gender (Male/Female)
IFN cFirstNameInitial Char 1 Initial - First Name (Govt Rpts)
DOB jdDateOfBirth Date 6 Date - Birth
CCPR szCountryCode String 3 Country Code

2.7.6.2 Conceptual Approach

When a user adds, modifies, or deletes employee master data, F060116 table only, from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTPIOUT event is a container event activated within the employee master business function and contains a specific subset of columns, from the modified employee master record (F060116) and an action code specifying what action was performed on the data (added, changed, deleted). Whenever data from one of the tables handled by the container event (F060116 and F060117) is modified, the corresponding record from the other table is automatically fetched and included in the container.

2.7.6.3 Objects that Can Initiate the Event

These objects can initiate the RTPIOUTB event:

  • B0500575 - Employee Master Business Function

  • B0500881 - Person Information RTE Notification

2.7.7 RTPIOUTC

RTPIOUTC is a real-time event notification used by the JD Edwards EnterpriseOne system to notify external systems of changes to employee master records (F060117). This message is similar to the message issued by RTEMOUTC.

Event Name

RTPIOUTC

Event Description

F060117 Detail

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500881C: Person Information RTE Notification C Structure

Relationship

Included in container event RTPIOUT.

2.7.7.1 Event Fields

The RTPIOUTC event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
AN8 mnAddressNumber Number 8 Address Number
LNGP szLanguage String 2 Language
SALU szSalutation String 5 Salutation
SUFF szSuffix String 5 Suffix
PRNM szPreferredName String 20 Preferred Name

2.7.7.2 Conceptual Approach

When a user adds, modifies, or deletes employee master data, F060117 table only, from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTPIOUT event is a container event activated within the employee master business function and contains a specific subset of columns, from the modified employee master record (F060117) and an action code specifying what action was performed on the data (added, changed, deleted). Whenever data from one of the tables handled by the container event (F060116 and F060117) is modified the corresponding record from the other table is automatically fetched and included in the container.

2.7.7.3 Objects that Can Initiate the Event

These objects can initiate the RTPIOUTC event:

  • B0500575 - Employee Master Business Function

  • B0500881 - Person Information RTE Notification

2.8 Equipment

This section discusses the real-time events generated by the Equipment system.

2.8.1 RTEQPOUT

RTEQPOUT is a container event that is generated by the JD Edwards EnterpriseOne system to provide equipment information.

Event Name

RTEQPOUT

Event Description

Equipment

Event Type

RTE

Event Category

CONTAINER

Container event for RTEQPHDR (D1702940 ).

Product Code

H13

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the real-time event that is contained by this event for information about the fields, conceptual approach, and processes that can initiate this event.

2.8.2 RTEQPHDR

RTEQPHDR is a single event that is generated by the JD Edwards EnterpriseOne system to provide equipment information.

Event Name

RTEQPHDR

Event Description

Equipment Header

Event Type

RTE

Event Category

SINGLE

Product Code

H13

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D1702940: Equipment Real Time Template

Event Relationship

Included in container event RTEQPOUT.

2.8.2.1 Event Fields

The RTEQPHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cEventNotificationActionCode Char 1 Action Code
NUMB mnF1201NUMB Numeric 8 Asset Item Number
CO szF1201CO String 5 Company
APID szF1201APID String 12 Unit or Tag Number
AAID mnF1201AAID Numeric 8 Parent Number
ASID szF1201ASID String 25 Serial Number
SEQ mnF1201SEQ Numeric 6,6 Sequence Number
ACL1 szF1201ACL1 String 3 Major Accounting Class
ACL2 szF1201ACL2 String 3 Major Equipment Class
ACL3 szF1201ACL3 String 3 Manufacturer
ACL5 szF1201ACL5 String 3 Usage Miles or Hours
ACL4 szF1201ACL4 String 3 Model Year
MCU szF1201MCU String 12 Business Unit
DL01 szF1201DL01 String 30 Description
DL02 szF1201DL02 String 30 Description 02
DL03 szF1201DL03 String 30 Description 03
DSCC szF1201DSCC String 40 Description - Compressed
DAJ jdF1201DAJ Date 6 Date - Acquired
DSP jdF1201DSP Date 6 Date - Disposed or Retired
EQST szF1201EQST String 2 Equipment Status
NORU cF1201NORU Char 1 New or Used on Acquisition
AESV mnF1201AESV Numeric 15,15[2] Amount - Estimated Salvage Value
ARPC mnF1201ARPC Numeric 15,15[2] Amount - Replacement Cost
ALRC mnF1201ALRC Numeric 15.15[2] Amount - Last Years Replacement Cost
AMCU szF1201AMCU String 12 Asset Cost Account - Business Unit
AOBJ szF1201AOBJ String 6 Asset Cost Account - Object
ASUB szF1201ASUB String 8 Asset Cost Account - Subsidiary
DMCU szF1201DMCU String 12 Accumulated Depreciation Account - BU
DOBJ szF1201DOBJ String 6 Accumulated Depreciation Account - Objct
DSUB szF1201DSUB String 8 Accumulated Depreciation Account - Sub
XMCU szF1201XMCU String 12 Depreciation Expense - BU
XOBJ szF1201XOBJ String 6 Depreciation Expense - Object
XSUB szF1201XSUB String 8 Depreciation Expense - Subsidiary
ROBJ szF1201ROBJ String 6 Asset Revenue - Object
RMCU szF1201RMCU String 12 Asset Revenue - Business Unit
RSUB szF1201RSUB String 8 Asset Revenue - Subsidiary
ARCQ mnF1201ARCQ Numeric 15,15[2] Asset Item Current Quantity
AROQ mnF1201AROQ Numeric 15,15[2] Asset Item Original Quantity
TXJS mnF1201TXJS Numeric 8 Tax Entity
AITY mnF1201AITY Numeric 15,15[2] Amount - Investment Tax Credit
AITP mnF1201AITP Numeric 15,15[2] Amount - Investment Tax Credit PYE
FINC cF1201FINC Char 1 Financing Method
ITCO cF1201ITCO Char 1 ITC Owned - (Y/N)
PURO cF1201PURO Char 1 Purchase Option
APUR mnF1201APUR Numeric 15,15[2] Amount - Purchase Option Price
PURP mnF1201PURP Numeric 3,3[3] Purchase Option Credit Percentage
APOM mnF1201APOM Numeric 15,15[2] Amount - Purchase Option Maximum Credit
LANO mnF1201LANO Numeric 8 Address Number - Lessor/Rentor/Mortgagor
JCD jdF1201JCD Date 6 Date - Contract Date
DEXJ jdF1201DEXJ Date 6 Date - Expired (Julian)
AMF mnF1201AMF Numeric 15,15[2] Amount - Monthly Payment
RMK szF1201RMK String 30 Name - Remark
RMK2 szF1201RMK2 String 30 Name - Remark
INSP szF1201INSP String 25 Insurance Policy Number
INSC szF1201INSC String 25 Insurance Company
INSM mnF1201INSM Numeric 2 Policy Renewal Month
INSA mnF1201INSA Numeric 15,15[2] Amount - Insurance Premium
AIV mnF1201AIV Numeric 15,15[2] Amount - Insurance Value
INSI mnF1201INSI Numeric 7,7 Insurance Value Index (future use)
USER szF1201USER String 10 User ID
LCT jdF1201LCT Date 6 Date - Last Changed
LOC szF1201LOC String 12 Business Unit - Location
ADDS szF1201ADDS String 3 State
PID szF1201PID String 10 Program ID
EFTB jdF1201EFTB Date 6 Date - Beginning Effective
DER jdF1201DER Date 6 Date - Expected Return
MSGA cF1201MSGA Char 1 Action - Message Control
EX szF1201EX String 30 Name - Explanation
EXR szF1201EXR String 30 Name - Remark Explanation
AN8 mnF1201AN8 Numeric 8 Address Number
ACL6 szF1201ACL6 String 3 Category Code - F/A 6
ACL7 szF1201ACL7 String 3 Category Code - F/A 7
ACL8 szF1201ACL8 String 3 Category Code - F/A 8
ACL9 szF1201ACL9 String 3 Category Code - F/A 9
ACL0 szF1201ACL0 String 3 Category Code - F/A 10 (Rate Group)
SFC mnF1201SFC Numeric 15,15[2] Standard Fuel Consumption
DADC szF1201DADC String 12 Disposal Accumulated Depreciation - BU
DADO szF1201DADO String 6 Disposal Accumulated Depreciation - Obj
DADS szF1201DADS String 8 Disposal Accumulated Depreciation - Sub
UNIT szF1201UNIT String 8 Unit
KIT mnF1201KIT Numeric 8 Parent (short) Item Number
KITL szF1201KITL String 25 Kit - 2nd Item Number
AFE szF1201AFE String 12 AFE Number
JBCD szF1201JBCD String 6 Job Type (Craft) Code
JBST szF1201JBST String 4 Job Step
UN szF1201UN String 6 Union Code
SBLI cF1201SBLI Char 1 Subledger Inactive Code
UPMJ jdF1201UPMJ Date 6 Date - Updated
JOBN szF1201JOBN String 10 Work Station ID
UPMT mnF1201UPMT Numeric 6 Time - Last Updated
FA0 szF1201FA0 String 3 Category Code - F/A 20
FA1 szF1201FA1 String 3 Category Code - F/A 11
FA2 szF1201FA2 String 3 Category Code - F/A 12
FA3 szF1201FA3 String 3 Category Code - F/A 13
FA4 szF1201FA4 String 3 Category Code - F/A 14
FA5 szF1201FA5 String 3 Category Code - F/A 15
FA6 szF1201FA6 String 3 Category Code - F/A 16
FA7 szF1201FA7 String 3 Category Code - F/A 17
FA8 szF1201FA8 String 3 Category Code - F/A 18
FA9 szF1201FA9 String 3 Category Code - F/A 19
FA21 szF1201FA21 String 10 Category Code - F/A 21
FA22 szF1201FA22 String 10 Category Code - F/A 22
FA23 szF1201FA23 String 10 Category Code - F/A 23
WOYN cF1201WOYN Char 1 Allow Work Order (Y/N)
CRTL mnF1201CRTL Numeric 2 Criticality
WRFL cF1201WRFL Char 1 Warranty Flag
WARJ jdF1201WARJ Date 6 Date - Warranty Expiration (Julian)
CTR szF1217CTR String 3 Country
COOWN cF1217COOWN Char 1 Company Owned
MMCU szF1217MMCU String 12 Branch
DOCO mnF1217DOCO Numeric 8 Document (Order No, Invoice, etc.)
DCTO szF1217DCTO String 2 Order Type
KCOO szF1217KCOO String 5 Order Company (Order Number)
LNID mnF1217LNID Numeric 6,6[3] Line Number
ORDJ jdF1217ORDJ Date 6 Date - Ordered (Julian)
SHPJ jdF1217SHPJ Date 6 Date - Shipped (Julian)
ADDJ jdF1217ADDJ Date 6 Date - Actual Ship Date
SHAN mnF1217SHAN Numeric 8 Address Number - Ship To
PA8 mnF1217PA8 Numeric 8 Address Number - Parent
SLSM mnF1217SLSM Numeric 8 Salesperson 01
ANOB mnF1217ANOB Numeric 8 Address Number - Owner Billing
RORN szF1217RORN String 8 Related PO/SO/WO Number
RCTO szF1217RCTO String 2 Related PO/SO/WO Order Type
STRX jdF1217STRX Date 6 Date - Completion (Julian)
VEND mnF1217VEND Numeric 8 Primary / Last Supplier Number
OORN szF1217OORN String 8 Original Order Number
OCTO szF1217OCTO String 2 Original Order Type
OKCO szF1217OKCO String 5 Document Company (Original Order)
SFXO szF1217SFXO String 3 Order Suffix
OGNO mnF1217OGNO Numeric 7,7[3] Original Line Number
PRODF szF1217PRODF String 8 Product Family
PRODM szF1217PRODM String 8 Product Model
PRODC szF1217PRODC String 10 Product Component
CMOD szF1217CMOD String 25 Configured Model
SYEM szF1217SYEM String 36 Install Key
VINNU szF1217VINNU String 30 Vehicle Identification Number
REFN szF1217REFN String 30 Reference Number
ZE01 szF1217ZE01 String 10 Category Code - Equipment 01
ZE02 szF1217ZE02 String 10 Category Code - Equipment 02
ZE03 szF1217ZE03 String 10 Category Code - Equipment 03
ZE04 szF1217ZE04 String 10 Category Code - Equipment 04
ZE05 szF1217ZE05 String 10 Category Code - Equipment 05
ZE06 szF1217ZE06 String 10 Category Code - Equipment 06
ZE07 szF1217ZE07 String 10 Category Code - Equipment 07
ZE08 szF1217ZE08 String 10 Category Code - Equipment 08
ZE09 szF1217ZE09 String 10 Category Code - Equipment 09
ZE10 szF1217ZE10 String 10 Category Code - Equipment 10
URCD szF1217URCD String 2 User Reserved Code
URDT jdF1217URDT Date 6 User Reserved Date
URAT mnF1217URAT Numeric 15,15[2] User Reserved Amount
URAB mnF1217URAB Numeric 8 User Reserved Number
URRF szF1217URRF String 15 User Reserved Reference
CRTU szF1217CRTU String 10 Created by user
USER szF1217USER String 10 User ID
PID szF1217PID String 10 Program ID
JOBN szF1217JOBN String 10 Work Station ID
UPMJ jdF1217UPMJ Date 6 Date - Updated
UPMT mnF1217UPMT Numeric 6 Time - Last Updated
LOTN szF1217LOTN String 30 Lot/Serial Number
LOCN szF1217LOCN String 20 Location
WOD mnF1217WOD Numeric 8 Work Order Number
BREV szF1217BREV String 3 Bill Revision Level
EFFF jdF1217EFFF Date 6 Effective - From Date
AN8DL mnF1217AN8DL Numeric 8 Default Dealer
TERMYN cF1217TERMYN Char 1 Terms Accepted Flag
SATYP szF1217SATYP String 3 Sales Type
AN8AS mnF1217AN8AS Numeric 8 Assessor Number
INSDTE jdF1217INSDTE Date 6 In Service Date
MCU szF1217MCU String 12 Business Unit
MRRYN cF1217MRRYN Char 1 Meter Reading Required
REGSTS szF1217REGSTS String 3 Registration Status
VMRS31 szF1217VMRS31 String 2 Component Code - System
VMRS32 szF1217VMRS32 String 8 Component Code - Assembly
VMRS34 szF1217VMRS34 String 10 Manufacturer
AN8DR mnF1217AN8DR Numeric 8 Distributor
EQPN mnF1217EQPN Numeric 8 Equipment Parts Number

2.8.2.2 Conceptual Approach

An equipment record added, modified or deleted in the JD Edwards EnterpriseOne system creates, modifies, or deletes a record in the Asset Master File table (F1201) and the Equipment Master Extension table (F1217).

2.8.2.3 Objects that Can Initiate the Event

These objects can initiate the RTEQPHDR event:

  • N120010 - F1201 Process Master Data

  • N120090 - F1217 Process Master Data

2.9 Financials

This section discusses the real-time events generated by the Financial Management system.

2.9.1 RTAMOUT

RTAMOUT is used by the JD Edwards EnterpriseOne system to inform third-party systems of item additions, changes, or deletions of accounts in order to keep the two systems synchronized.

Event Name

RTAMOUT

Event Description

RTAMOUT

Event Type

RTE

Event Category

SINGLE

Product Code

H09

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0900170B: GL Account Real Time Event Notification Outbound Data

2.9.1.1 Event Fields

The RTAMOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
EV01 cEventAction Char 1 JD Edwards EnterpriseOne Event Point 01
CO szCompany String 5 Company
AID szAccountId String 8 Account ID
MCU szBusinessUnit String 12 Business Unit
OBJ szObjectAccount String 6 Object Account
SUB szSubsidiary String 8 Subsidiary
DL01 szDescription String 30 Description
PEC cPostingEditCode Char 1 Posting Edit
LNGP szLanguageCode String 2 Language
DL01 szAlternateDescription String 30 Description
EV01 cFutureUseFlag Char 1 J.D. JD Edwards EnterpriseOne Event Point 01
INT01 nFutureUseInteger Integer 4 Integer 01 - JD Edwards EnterpriseOne
MATH01 mnFutureUseMathNumeric Numeric 15 Math Numeric 01
VC30A szFutureUseString String 30 Video Constant A - length 30
ANS szAccountNumber3rd String 25 Account Number - 3rd
LDA cLevelOfDetailAcctCode Char 1 Account Level of Detail
BPC szBudgetPatternCode String 3 Budget Pattern Code
BILL vBillableYN Char 1 Billable (Y/N)
CRCD szCurrencyCodeFrom String 3 Currency Code - From
UM UnitOfMeasure String 2 Unit of Measure
R001 szCategoryCodeGl001 String 3 Category Code G/L1
R002 szCategoryCodeGl002 String 3 Category Code - G/L2
R003 szCategoryCodeGl003 String 3 Category Code G/L3
R004 szCategoryCodeGl004 String 3 Category Code G/L4
R005 szCategoryCodeGl005 String 3 Category Code G/L5
R006 szCategoryCodeGl006 String 3 Category Code G/L6
R007 szCategoryCodeGl007 String 3 Category Code G/L7
R008 szCategoryCodeGl008 String 3 Category Code G/L8
R009 szCategoryCodeGl009 String 3 Category Code G/L9
R010 szCategoryCodeGl010 String 3 Category Code G/L10
R011 szCategoryCodeGl011 String 3 Category Code G/L11
R012 szCategoryCodeGl012 String 3 Category Code G/L12
R013 szCategoryCodeGl013 String 3 Category Code G/L13
R014 szCategoryCodeGl014 String 3 Category Code G/L14
R015 szCategoryCodeGl015 String 3 Category Code G/L15
R016 szCategoryCodeGl016 String 3 Category Code G/L16
R017 szCategoryCodeGl017 String 3 Category Code G/L17
R018 szCategoryCodeGl018 String 3 Category Code G/L18
R019 szCategoryCodeGl019 String 3 Category Code G/L19
R020 szCategoryCodeGl020 String 3 Category Code G/L20
R021 szCategoryCodeGl021 String 10 Category Code G/L 021
R022 szCategoryCodeGl022 String 10 Category Code G/L 022
R023 szCategoryCodeGl023 String 10 Category Code G/L 023
OBJA szObjectAccountAlternate String 6 Object Account - Alternate
SUBA szSubsidiaryAlternate String 8 Subsidiary - Alternate
WCMP szWorkersCompInsurCode String 4 Worker's Comp. Insurance Code
CCT cMethodOfComputation Char 1 Method of Computation
ERC szEquipmentRateCode String 2 Equipment Rate Code
HTC cHeaderTypeCode Char 1 Header Type Code
QLDA cLodQuantityRollupCode Char 1 Quantity Roll-Up Level
CCC cCostCodeComplete Char 1 Cost Code Complete (Y/N)
FMOD cModelAccountsandConsolid Char 1 Model Accounts and Consolidation
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
JOBN szWorkStationId String 10 Work Station ID
UPMJ jdDateUpdated Date 6 Date - Updated
UPMT mnTimeLastUpdated Numeric 6 Time - Last Updated
CEC1 cCostObjectEditCode01 Char 1 Cost Object Edit Code 01
CEC2 cCostObjectEditCode02 Char 1 Cost Object Edit Code 02
CEC3 cCostObjectEditCode03 Char 1 Cost Object Edit Code 03
CEC4 cCostObjectEditCode04 Char 1 Cost Object Edit Code 04
IEC cItemEditCode Char 1 Item Edit Code
FPEC cFixeddAssetPostingEditCode Char 1 Fixed Asset Posting Edit Code
STPC cTypeCode9 Char 1 Type Code
TXGL cGLAccountTaxable Char 1 GL Account Taxable Flag
TOBJ szTargetObjectAccount String 6 Target Object Account
TSUB szTargetSubsidiary String 8 Target Subsidiary
PRGF cPurgeFlag Char 1 Purge Flag
TXA1 szTaxArea1 String 10 Tax Rate/Area
R024 szCategoryCodeGl024 String 10 Category Code G/L 024
R025 szCategoryCodeGl025 String 10 Category Code G/L 025
R026 szCategoryCodeGl026 String 10 Category Code G/L 026
R027 szCategoryCodeGl027 String 10 Category Code G/L 027
R028 szCategoryCodeGl028 String 10 Category Code G/L 028
R029 szCategoryCodeGl029 String 10 Category Code G/L 029
R030 szCategoryCodeGl030 String 10 Category Code G/L 030
R031 szCategoryCodeGl031 String 10 Category Code G/L 031
R032 szCategoryCodeGl032 String 10 Category Code G/L 032
R033 szCategoryCodeGl033 String 10 Category Code G/L 033
R034 szCategoryCodeGl034 String 10 Category Code G/L 034
R035 szCategoryCodeGl035 String 10 Category Code G/L 035
R036 szCategoryCodeGl036 String 10 Category Code G/L 036
R037 szCategoryCodeGl037 String 10 Category Code G/L 037
R038 szCategoryCodeGl038 String 10 Category Code G/L 038
R039 szCategoryCodeGl039 String 10 Category Code G/L 039
R040 szCategoryCodeGl040 String 10 Category Code G/L 040
R041 szCategoryCodeGl041 String 10 Category Code G/L 041
R042 szCategoryCodeGl042 String 10 Category Code G/L 042
R043 szCategoryCodeGl043 String 10 Category Code G/L 043

2.9.1.2 Conceptual Approach

A new general ledger account added in the JD Edwards EnterpriseOne system creates a new record in the Account Master (F0901) table. The user can create an alternate description for this account by language preference that is stored in the Account Master - Alternate Description (F0901D) table. If an account is added or modified in a system, the information is sent to a third-party system for add or update. If an account is deleted, the pertinent information is sent to the third-party, which will take the appropriate action. If applicable, the third-party integration must update the cross-reference table in the process in order to tie together the key values from both systems.

2.9.1.3 Objects that Can Initiate the Event

These objects can initiate the RTAMOUT event:

  • P0901 - Accounts

  • R0006QD - Update F0901 as Model Base on Table F0006

  • R09803 - Global Account Number Update

  • R09805 - Global Subsidiary Update

  • R09813 - Change Account Information

  • R09814 - Delete Account Master Records

  • R10861 - Delete Prior Consolidation

  • B0900053 - Duplicate Business Unit

  • B0900073 - Dynamic Account Creation

  • B0900075 - F0901D Update Account Translation

  • B0900077 - F0901D Edit Account Translation

  • B0900155 - Delete Account F0901/F0901D/F0902/F0911 Records

  • B1400009 - Global Budget Pattern Code Update

2.9.2 RTCROUT

RTCROUT is used by the JD Edwards EnterpriseOne system to notify third-party systems of currency exchange rate additions, changes, or deletions.

Event Name

RTCROUT

Event Description

RTCROUT

Event Type

RTE

Event Category

SINGLE

Product Code

H09

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0900200B: Currency Exchange Rates Real Time Event Notification - B

2.9.2.1 Event Fields

The RTCROUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
CRCD szCurrencyCodeFrom String 3 Currency Code From
CRDC szCurrencyCodeTo String 3 Currency Code To
AN8 mnAddressNumber Numeric 8 Address Number
RTTYP szCurrencyRateType String 2 Currency Rate Type
EFT jdDateEffective Date 6 Date Effective
CLMETH cCalculationMethod Char 1 Calculation Method
CRCM cCurrencyConversionMethod Char 1 Currency Conversion Method Y/Z
TRCR szTriangulationCurrency Char 3 Triangulation Currency Code
CRR mnCurrencyConverRateMultOv Numeric 15[7] Currency Conversion Rate - Multiplier
CRRD mnCurrencyConverRateDiv Numeric 15[7] Currency Conversion Rate - Divisor
CSR cCurrencySpotRate Char 1 Currency Spot Rate Flag
USER szUserID String 10 User ID
PID szProgramID String 10 Program ID
JOBN szWorkStationID String 10 Workstation ID
UPMJ jdDateUpdated Date 6 Data Updated
UPMT mnTimeLastUpdated Numeric 6 Time Last Updated

2.9.2.2 Conceptual Approach

When a user adds, modifies, or deletes a currency exchange rate in the JD Edwards EnterpriseOne system, the system updates the Currency Exchange Rate table (F0015) and publishes the RTCROUT event out to a third party system. This event contains all columns from the modified currency exchange rate record and an action code specifying what action was performed on the data (add, change, or delete).

2.9.2.3 Objects that Can Initiate the Event

These objects can initiate the RTCROUT event:

  • F0015 - Currency Exchange Rates table trigger

  • P0015A - Currency Exchange Rates

  • R11153 - Calculate Currency Cross Rate

  • B0900200 - Currency Exchange Rates Real Time Event Notification

2.9.3 RTRAOUT

RTRAOUT is a container event that provides AP Payment Remittance information to third-party system. RTRAOUT is an aggregate event that contains these single events:

RTRAHDR - contains AP Payment Remittance Advice header information that can be used by another system.

RTRADTL - contains AP Payment Remittance Advice detail information that can be used by another system.

Event Name

RTRAOUT

Event Description

RTRAOUT Header

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTRAHDR (D0400169A)

  • RTRADTL (D0400169B)

Product Code

04

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the appropriate real-time events that are contained by this event for information about the event fields.

2.9.3.1 Conceptual Approach

An payment made in the JD Edwards EnterpriseOne system updates new records in the Accounts Payable - Matching Document (F0413) and Accounts Payable Matching Document Detail (F0414) tables. A real-time notification event is triggered in the payments system after this payment is made in JD Edwards EnterpriseOne tables.

The Send Method field (A6CRMD) in the Supplier Master (F0401) table controls whether JD Edwards EnterpriseOne sends a RemittanceAdviceNotify real-time event notification when RTRAOUT is enabled. A real-time event notification is sent only if the supplier has a value of 5 in the Send Method field.

2.9.3.2 Objects that Can Initiate the Event

These objects can initiate the RTRAOUT event:

  • B0400016 - A/P Payments Master Business Function

  • B0400169 - Remittance Advice Real-Time Event Notification

  • B0400047 - Voucher Entry Master Business Function

  • P0413M - A/P Manual Payments

  • N0400061 - Remittance Advice Notification For Manual Payments

2.9.3.3 Special Setup

Suppliers who want to receive remittance advice notification must be set up to receive external events. To receive external events, set Send Methods equal to 5 (External Events) on the EDI information tab in the Supplier Master program (P04012).

2.9.4 RTRAHDR

RTRAHDR is a single event that contains payment remittance advice header information that can be used by another system.

Event Name

RTRAHDR

Event Description

RA Header

Event Type

RTE

Event Category

SINGLE

Product Code

04

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0400169A: Remittance Advice - Header

Event Relationship

Included in container event RTRAOUT.

2.9.4.1 Event Fields

The RTRAHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
PYID mnPaymentID Numeric 15 Payment
AN8 mnBillTo Numeric 8 Bill To
ALKY szBillToDescriptive String 20 Bill To Descriptive
PA8 mnParentPayee Numeric 8 Parent Payee
ALKY szParentPayeeDescriptive String 20 Parent Payee Descriptive
AN8 mnPayee String 8 Payee
ALKY szPayeeDescriptive String 20 Payee Descriptive
CRCD szCurrencyCode String 3 Currency Code
PAAP mnTotalPaymentAmount Numeric 15 Total Payment Amount
ADSA mnTotalDiscountAmount Numeric 15 Total Discount Amount
DGJ jdPaymentDate Date 6 Payment Date
DOCM mnCheckNumber Numeric 8 Check Number
CBNK szFromAccountNumber String 20 From Bank Account Number
TSNT szFromTransitNumber String 20 From Transit Number
PYIN cPaymentInstrument String 1 Payment Instrument
CBNK szToAccountNumber String 20 To Bank Account Number
TSNT szToTransitNumber String 20 To Transit Number

2.9.4.2 Conceptual Approach

A payment made in the JD Edwards EnterpriseOne system updates new records in the Accounts Payable - Matching Document (F0413) and Accounts Payable Matching Document Detail (F0414) tables. A real-time notification event is triggered in the payments system after payment is made in JD Edwards EnterpriseOne tables.

2.9.4.3 Objects that Can Initiate the Event

These objects can initiate the RTRAHDR event:

  • B0400016 - A/P Payments Master Business Function

  • B0400169 - Remittance Advice Real-Time Event Notification

  • B0400047 - Voucher Entry Master Business Function

  • P0413M - A/P Manual Payments

  • N0400061 - Remittance Advice Notification For Manual Payments

2.9.5 RTRADTL

RTRADTL is a single event that contains payment remittance advice detail information that can be used by another system.

Event Name

RTRADTL

Event Description

RA Detail

Event Type

RTE

Event Category

SINGLE

Product Code

04

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0400169B: Remittance Advice - Detail

Event Relationship

Included in container event RTRAOUT.

2.9.5.1 Event Fields

The RTRADTL event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
PYID mnPaymentID Numeric 15 Payment ID
RC5 mnPaymentLineNumber Numeric 5 Payment Line Number
VINV szSupplierInvoiceNumber String 25 Supplier Invoice Number
RMK szRemark String 30 Remark
DOC mnDocumentNumber Numeric 8 Document Number
DCT szDocumentType String 2 Document Type
KCO szDocumentCompany String 5 Document Co.
PAAP mnPaymentAmount Numeric 15 Payment Amount
ADSA mnDiscountAmount Numeric 15 Discount Amount
DGJ jdInvoiceDate Date 6 Date - For G/L (and Voucher) - Julian
MCU szBranchPlant Char 12 Business Unit

2.9.5.2 Conceptual Approach

A payment made in the JD Edwards EnterpriseOne system updates new records in the Accounts Payable - Matching Document (F0413) and Accounts Payable Matching Document Detail (F0414) tables. A detailed real-time notification event is triggered in the payments system after a payment is made in JD Edwards EnterpriseOne tables.

2.9.5.3 Objects that Can Initiate the Event

These objects can initiate the RTRADTL event:

  • B0400016 - A/P Payments Master Business Function

  • B0400169 - Remittance Advice Real Time Event Notification

  • B0400047 - Voucher Entry Master Business Function

  • P0413M - A/P Manual Payments

  • N0400061 - Remittance Advice Notification For Manual Payments

2.9.6 RTDAOUT

RTDAOUT is used by the JD Edwards EnterpriseOne system to provide Accounts Receivable deduction information to third-party systems.

Event Name

RTDAOUT

Event Description

RTDAOUT

Event Type

RTE

Event Category

CONTAINER

Container event for: RTDADTL (D03B0208B)

Product Code

H03B

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the real-time event that is contained by this event for information about the event fields.

2.9.6.1 Conceptual Approach

Deduction processing creates a new record in the A/R Deduction Management table (F03B40). The R45730 program is run to select the appropriate deduction records and to trigger a real-time notification out to a third party system. This event contains the recently selected deduction and its pertinent information.

2.9.6.2 Objects that Can Initiate the Event

Extract and Export Open Siebel Deductions (R45730) calls the real-time event wrapper, Deductions Activity Real Time Event Notification (B03B0208), to initiate the real-time event.

2.9.7 RTDADTL

RTDADTL is used by the JD Edwards EnterpriseOne system to provide Accounts Receivable deduction information to third-party systems.

Event Name

RTDADTL

Event Description

RTDADTL

Event Type

RTE

Event Category

SINGLE

Product Code

H03B

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D03B0208B: Deductions Activity Record

Event Relationship

Included in container event RTDAOUT.

2.9.7.1 Event Fields

The RTDADTL event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
DCID DeductionId Numeric 15 Deduction ID of record
DDDO Deduction Opened Date Date 6 Deduction Opened Date
DDOA Deduction Open Amount Numeric 15 Deduction Open Amount
CRCD Currency Code String 3 Currency Code
AN8 Address Book Number Numeric 8 Address Book Number
DDEX Deduction Reason Code String 2 Deduction Reason Code
SPHD Special Handling Reason Code String 10 Special Handling Code - User Def Codes
ACTN cActionCode Char 1 Action Code

2.9.7.2 Conceptual Approach

Deduction processing creates a new record in the A/R Deduction Management table (F03B40). The R45730 program is run to select the appropriate deduction records and to trigger a real-time notification out to a third party system. This event contains the recently selected deduction and its pertinent information.

2.9.7.3 Objects that Can Initiate the Event

Extract and Export Open Siebel Deductions (R45730) calls the real-time event wrapper, Deductions Activity Real Time Event Notification (B03B0208), to initiate the real-time event.

2.9.8 RTBJESOUT

RTBJESOUT is used by the JD Edwards EnterpriseOne system to notify third-party systems of the status of batch journal entries being processed through the Journal Entry Batch Processor (R09110Z).

Event Name

RTBJESOUT

Event Description

RTBJESOUT

Event Type

RTE

Event Category

SINGLE

Product Code

00

Reliable Delivery

Blank

Delivery Timeout Threshold

0

Data Structure

D0900210B: Batch Journal Entry Status RTE Notification Message

2.9.8.1 Event Fields

The RTBJESOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
EDUS szEDIUserID String 10 EDI - User ID
EDBT szEDIBatchNumber String 15 EDI - Batch Number
EDTN szEDITransactionNumber String 22 EDI - Transaction Number
R2 szReference2 String 8 Reference 2

Note: This field contains as many as eight characters of the business unit.

DL01 szEnterpriseAccountIDBatchID String 30 Description
DOC mnDocumentNumber Numeric 8 Document (Voucher, Invoice, etc.)
DGJ jdGLDate Date 6 Date - For G/L (and Voucher) - Julian
EV01 cStatus Char 1 Event Point 01

Note: This field contains a value of 2 if the batch journal entry contains errors, 1 if there are warnings, or 0 if there are no errors.


2.9.8.2 Conceptual Approach

This event delivers a real time event notification of the status of batch journal entries being processed through the Journal Entry Batch Processor (R09110Z). The status indicates whether the journal entry document was created successfully. The reason for the failure is not included. The notification also includes the journal entry document number and general ledger date if the document is successfully added to the Account Ledger table (F0911).

2.9.8.3 Objects that Can Initiate the Event

The B0900210 – Batch Journal Entry Status Real Time Event Notification business function can initiate the RTBJESOUT event.

2.9.9 RTPOSTOUT

RTPOSTOUT is used by the JD Edwards EnterpriseOne system to notify third-party systems when a batch has been successfully posted to the Account Balances table (F0902).

Event Name

RTPOSTOUT

Event Description

RTPOSTOUT

Event Type

RTE

Event Category

SINGLE

Product Code

00

Reliable Delivery

Blank

Delivery Timeout Threshold

0

Data Structure

D0900220B: Journal Entry Post RTE Notification Message

2.9.9.1 Event Fields

The RTPOSTOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code

Note: This field is hard-coded to a value of C for change.

ICU mnBatchNumber Numeric 8 Batch Number
ICUT szBatchType String 2 Batch Type
DL01 szEnterpriseAccountIDBatchID String 30 Description
EV01 cStatus Char 1 Event Point 01

Note: This field is hard-coded to a value of P for posted.


2.9.9.2 Conceptual Approach

This event delivers a real time event notification when a batch has been successfully posted to the Account Balances table (F0902) using the General Ledger Post program (R09801). The status indicates only that the batch of journal entries has been successfully posted. If the batch fails to post, this event is not generated.

2.9.9.3 Objects that Can Initiate the Event

The B0900220 – Journal Entry Post Real Time Event Notification business function can initiate the RTPOSTOUT event.

2.10 Human Resources

This section discusses the real-time events generated by the Human Resources system.

2.10.1 RTSLOUT

RTSLHDR is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to competency scales records.

Event Name

RTSLOUT

Event Description

Scales Real Time Event

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTSLHDR (D0500871B)

  • RTSLDTL (D0500871C)

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the related single events for lists of event fields.

2.10.1.1 Conceptual Approach

When a user adds, modifies, or deletes scales data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event out to a third party system. This container event, RTSLOUT, contains two single events RTSLHDR and RTSLDTL.

2.10.1.2 Objects that Can Initiate the Event

These objects can initiate the RTSLOUT event:

  • P05103 - Scale Information

  • B0500871 - Scales Real Time Event Notification

2.10.2 RTSLHDR

RTSLHDR is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to competency scales header records (F05103).

Event Name

RTSLHDR

Event Description

Scales Header

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500871B: Scales Real Time Event Notification B Structure (F05103)

Relationship

Included in container event RTSLOUT.

2.10.2.1 Event Fields

The RTSLHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
SCLE szScale String 10 Scale
SCLL mnLowValue Numeric 6 Low Value
SCLH mnHighValue Numeric 6 High Value
DL01 szDescription001 String 30 Description
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
JOBN szWorkStationId String 10 Workstation ID
UPMJ jdDateUpdated Date 6 Data Updated
UPMT mnTimeLastUpdated Numeric 6 Time Last Updated

2.10.2.2 Conceptual Approach

When a user adds, modifies, or deletes scales data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event to the WSG system. This container event, RTSLOUT, contains two single events RTSLHDR and RTSLDTL. The RTSLHDR event contains all columns from the modified scales header record (F05103) and an action code specifying what action was performed on the data (added, changed, deleted).

2.10.2.3 Objects that Can Initiate the Event

These objects can initiate the RTSLHDR event:

  • P05103 - Scale Information

  • B0500871 - Scales Real Time Event Notification

2.10.3 RTSLDTL

RTSLDTL is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to competency scales detail records (F05119).

Event Name

RTSLDTL

Event Description

Scales Detail

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500871C: Scales Real Time Event Notification C Structure (F05119)

Relationship

Included in container event RTSLOUT.

2.10.3.1 Event Fields

The RTSLDTL event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
SCLE szScale String 10 Scale
SCLL mnLowValue Numeric 6 Low Value
SCLH mnHighValue Numeric 6 High Value
DL01 szDescription001 String 30 Description
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
JOBN szWorkStationId String 10 Workstation ID
UPMJ jdDateUpdated Date 6 Data Updated
UPMT mnTimeLastUpdated Numeric 6 Time Last Updated

2.10.3.2 Conceptual Approach

When a user adds, modifies, or deletes scales data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event out to a third party system. The container event RTSLOUT contains two single events RTSLHDR and RTSLDTL. The RTSLDTL event contains all columns from the modified scales detail record (F05119) and an action code specifying what action was performed on the data.

2.10.3.3 Objects that Can Initiate the Event

These objects can initiate the RTSLDTL event:

  • P05103 - Scale Information

  • B0500871 - Scales Real Time Event Notification

2.10.4 RTRCOUT

RTRCOUT is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to resource competency header records.

Event Name

RTRCOUT

Event Description

Resource Comp. Real Time Event

Event Type

RTE

Event Category

CONTAINER

Container event for RTRCHDR (D0500872B ).

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.10.4.1 Conceptual Approach

When a user adds, modifies, or deletes resource competency data from the JD Edwards EnterpriseOne Human Resources system, the system publishes the RTRCOUT event out to a third party system. The container event RTRCOUT contains one single event RTRCHDR.

2.10.4.2 Objects that Can Initiate the Event

These objects can initiate the RTCROUT event:

  • F05100 - Resource Competency

  • B0500872 - Resource Competency Real Time Event Notification

2.10.5 RTRCHDR

RTRCHDR is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to resource competency header records (F05100).

Event Name

RTRCHDR

Event Description

Resource Competency Header

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500872B: Resource Competency Real Time Event Notification B Structure

Relationship

Included in container event RTRCOUT.

2.10.5.1 Event Fields

The RTRCHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
RRTY szResourceType String 2 Resource Type
AN8 mnAddressNumber Numeric 8 Address Number
CMPE szCompetencyType String 3 Competency Type
CMPC szCompetencyCode String 10 Competency Code
CMPV mnCompetencyLevel Numeric 6 Competency Level
CMPX jdExpirationDate Date 6 Expiration Date
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
JOBN szWorkStationId String 10 Workstation ID
UPMJ jdDateUpdated Date 6 Data Updated
UPMT mnTimeLastUpdated Numeric 6 Time Last Updated
ACTN cActionCode Char 1 Action Code

2.10.5.2 Conceptual Approach

When a user adds, modifies, or deletes resource competency data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event out to a third party system. The container event RTRCOUT contains one single event RTRCHDR. The RTRCHDR event contains all columns from the modified resource competency header record (F05100) and an action code specifying what action was performed on the data (added, changed, deleted). Current integrations do not require synchronization of detail data. However, real-time event business function (B0500872) has been designed to implement this functionality in the future if required.

2.10.5.3 Objects that Can Initiate the Event

These objects can initiate the RTRCHDR event:

  • F05100 - Resource Competency

  • B0500872 - Resource Competency Real Time Event Notification

2.10.6 RTCPOUT

RTCPOUTB is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to competency master records (F05104).

Event Name

RTCPOUT

Event Description

Competency Real Time Event

Event Type

RTE

Event Category

CONTAINER

Container event for RTCPOUTB (D0500870B ).

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.10.6.1 Conceptual Approach

When a user adds, modifies, or deletes competency master data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event out to a third party system. The container event RTCPOUT contains one single event RTCPOUTB.

2.10.6.2 Objects that Can Initiate the Event

These objects can initiate the RTCPOUT event:

  • F05104 - Competency Master

  • B0500870 - Competency Real Time Event Notification

2.10.7 RTCPOUTB

RTCPOUTB is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to competency master records (F05104).

Event Name

RTCPOUTB

Event Description

Competency Real Time Event

Event Type

RTE

Event Category

SINGLE

Product Code

05

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0500870B: Competency Real Time Event Notification Structure B

Relationship

Included in container event RTCPOUT.

2.10.7.1 Event Fields

The RTCPOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
CMPE szCompetencyType String 3 Competency Type
CMPC szCompetencyCode String 10 Competency Code
CCLS szCompetencyClass String 10 Competency Class
DL01 szDescription001 String 30 Description
SCLE szScale String 10 Scale
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
JOBN szWorkStationId String 10 Workstation ID
UPMJ jdDateUpdated Date 6 Data Updated
UPMT mnTimeLastUpdated Numeric 6 Time Last Updated
ACCOMP cAutoCalculateCompetency Char 1 Auto Calculate Competency

2.10.7.2 Conceptual Approach

When a user adds, modifies, or deletes competency master data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event out to a third party system. The container event RTCPOUT contains one single event RTCPOUTB. The RTCPOUTB event contains all columns from the modified competency master record (F05104) and an action code specifying what action was performed on the data (added, changed, deleted).

2.10.7.3 Objects that Can Initiate the Event

These objects can initiate the RTCPOUTB event:

  • F05104 - Competency Master

  • B0500870 - Competency Real Time Event Notification

2.10.8 RTJBOUT

RTJBOUT is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to job information records (F08001).

Event Name

RTJBOUT

Event Description

Jobs Real Time Event

Event Type

RTE

Event Category

CONTAINER

Container event for RTJBOUTB (D0800630B ).

Product Code

08

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.10.8.1 Conceptual Approach

When a user adds, modifies, or deletes job information data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event out to a third party system. The container event RTJBOUT contains one single event RTJBOUTB.

2.10.8.2 Objects that Can Initiate the Event

These objects can initiate the RTJBOUT event:

  • P08001 - Job Entry and Evaluation

  • P08JC - Category Codes Window

  • P08001US - Job Entry U.S. Legislative/Regulatory Data

  • P08001CA- Job Entry Canadian Legislative/Regulatory Data

  • P050011 - Job Evaluation

  • B0800630 - Jobs Real Time Event Notification

2.10.9 RTJBOUTB

RTJBOUTB is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to job information records (F08001).

Event Name

RTJBOUTB

Event Description

Jobs Real Time Event

Event Type

RTE

Event Category

SINGLE

Product Code

08

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0800630B: Jobs Real Time Event Notification Structure B

Relationship

Included in container event RTJBOUT.

2.10.9.1 Event Fields

The RTJBOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
JGRP szJobGroup String 6 Job Group
JBCD szJobCategory String 6 Job Type (Craft) Code
JBST szJobStep String 4 Job Step
DL01 szDescription001 String 30 Description
SALY cPayClassHSP Char 1 Pay Class (H/S/P)
PGRD szPayGrade String 6 Pay Grade
PFRQ cPayFrequency Char 1 Pay Frequency
EEOJ szJobCategoryEeo String 3 Job Category (EEO)
WCMP szWorkersCompInsurCode String 4 Worker's Comp. Insurance Code
WET cFloatCode Char 1 Sub Class - Workers Comp
FLSA cFlsaExemptYN Char 1 FLSA Exempt Y/N
DIVC szBenefitGroup String 6 Benefit Group
UN szUnionCode String 6 Union Code
EMET szJobEvaluationMethod String 4 Job Evaluation Method
EVD jdDateJobEvaluationPoints Date 6 Date - Job Evaluation (Julian)
EPNT mnJobEvaluationPoints Number 5 Job Evaluation Points
D001 mnEvalFactorDegrees001 Number 5 Job Evaluation Factor-Points in Degr 001
D002 mnEvalFactorDegrees002 Number 5 Job Evaluation Factor-Points in Degr 002
D003 mnEvalFactorDegrees003 Number 5 Job Evaluation Factor-Points in Degr 003
D004 mnEvalFactorDegrees004 Number 5 Job Evaluation Factor-Points in Degr 004
D005 mnEvalFactorDegrees005 Number 5 Job Evaluation Factor-Points in Degr 005
D006 mnEvalFactorDegrees006 Number 5 Job Evaluation Factor-Points in Degr 006
D007 mnEvalFactorDegrees007 Number 5 Job Evaluation Factor-Points in Degr 007
D008 mnEvalFactorDegrees008 Number 5 Job Evaluation Factor-Points in Degr 008
D009 mnEvalFactorDegrees009 Number 5 Job Evaluation Factor-Points in Degr 009
D010 mnEvalFactorDegrees010 Number 5 Job Evaluation Factor-Points in Degr 010
PT01 mnJobEvalFactorPnts001 Number 5 Job Evaluation Points per Factor 01
PT02 mnJobEvalFactorPnts002 Number 5 Job Evaluation Points per Factor 02
PT03 mnJobEvalFactorPnts003 Number 5 Job Evaluation Points per Factor 03
PT04 mnJobEvalFactorPnts004_2 Number 5 Job Evaluation Points per Factor 04
PT05 mnJobEvalFactorPnts005 Number 5 Job Evaluation Points per Factor 05
PT06 mnJobEvalFactorPnts006 Number 5 Job Evaluation Points per Factor 06
PT07 mnJobEvalFactorPnts007 Number 5 Job Evaluation Points per Factor 07
PT08 mnJobEvalFactorPnts008 Number 5 Job Evaluation Points per Factor 08
PT09 mnJobEvalFactorPnts009 Number 5 Job Evaluation Points per Factor 09
PT10 mnJobEvalFactorPnts010 Number 5 Job Evaluation Points per Factor 10
P001 szReportingCodesPayro001 String 3 Category Codes - Payroll1
P002 szReportingCodesPayro002 String 3 Category Codes - Payroll2
P003 szReportingCodesPayro003 String 3 Category Codes - Payroll3
P004 szReportingCodesPayro004 String 3 Category Codes - Payroll4
P005 szReportingCodesPayro005 String 3 Category Codes - Payroll5
P006 szReportingCodesPayro006 String 3 Category Codes - Payroll6
P007 szReportingCodesPayro007 String 3 Category Codes - Payroll7
P008 szReportingCodesPayro008 String 3 Category Codes - Payroll8
P009 szReportingCodesPayro009_2 String 3 Category Codes - Payroll9
P010 szReportingCodesPayro010 String 3 Category Codes - Payroll10
FE01 szFactorEvaluationCode01 String 10 Factor Evaluation Code 1
FE02 szFactorEvaluationCode02 String 10 Factor Evaluation Code 2
FE03 szFactorEvaluationCode03_2 String 10 Factor Evaluation Code 3
FE04 szFactorEvaluationCode04_2 String 10 Factor Evaluation Code 4
FE05 szFactorEvaluationCode05 String 10 Factor Evaluation Code 5
FE06 szFactorEvaluationCode06 String 10 Factor Evaluation Code 6
FE07 szFactorEvaluationCode07 String 10 Factor Evaluation Code 7
FE08 szFactorEvaluationCode08 String 10 Factor Evaluation Code 8
FE09 szFactorEvaluationCode09 String 10 Factor Evaluation Code 9
FE10 szFactorEvaluationCode010 String 10 Factor Evaluation Code 10
FW01 mnFactorWeightPercent01 Number 5 Factor Weight % 1
FW02 mnFactorWeightPercent02 Number 5 Factor Weight % 2
FW03 mnFactorWeightPercent03 Number 5 Factor Weight % 3
FW04 mnFactorWeightPercent04 Number 5 Factor Weight % 4
FW05 mnFactorWeightPercent05 Number 5 Factor Weight % 5
FW06 mnFactorWeightPercent06 Number 5 Factor Weight % 6
FW07 mnFactorWeightPercent07 Number 5 Factor Weight % 7
FW08 mnFactorWeightPercent08 Number 5 Factor Weight % 8
FW09 mnFactorWeightPercent09 Number 5 Factor Weight % 9
FW10 mnFactorWeightPercent10 Number 5 Factor Weight % 10
JSTA szJobStatusCode String 3 Job Status Code
EFTB jdDateBeginningEffective Date 6 Date - Beginning Effective
EFTE jdDateEndingEffective Date 6 Date - Ending Effective
USER szUserID String 10 User ID
PID szProgramID String 10 Program ID
JOBN szWorkStationID String 10 Work Station ID
UPMJ jdDateUpdated Date 6 Date - Updated
PGRS szPayGradeStep String 4 Job information
CENC szNOCCanEmpEquity String 4 NOC - Can Emp Equity
STCR szStatusChangeReason String 3 Status Change Reason

2.10.9.2 Conceptual Approach

When a user adds, modifies, or deletes job information data from the JD Edwards EnterpriseOne Human Resources system, the system publishes an event out to a third party system. The container event RTJBOUT contains one single event RTJBOUTB. The RTJBOUTB event contains all columns from the modified job information record (F08001) and an action code specifying what action was performed on the data (added, changed, deleted).

2.10.9.3 Objects that Can Initiate the Event

These objects can initiate the RTJBOUTB event:

  • P08001 - Job Entry and Evaluation

  • P08JC - Category Codes Window

  • P08001US - Job Entry U.S. Legislative/Regulatory Data

  • P08001CA- Job Entry Canadian Legislative/Regulatory Data

  • P050011 - Job Evaluation

  • B0800630 - Jobs Real Time Event Notification

2.10.10 RTJDOUT

RTJDOUT is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to competency based job description records.

Event Name

RTJDOUT

Event Description

Job Description RTE

Event Type

RTE

Event Category

CONTAINER

Container event for RTJDOUTB (D0800740B).

Product Code

08

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.10.10.1 Conceptual Approach

When a user adds, modifies, or deletes competency based job description data in the JD Edwards EnterpriseOne Human Resources system and then runs R080025, Incremental Job Description Changes Outbound Integration program, the system publishes an event out to a third party system. The container event RTJDOUT contains one single event RTJDOUTB.

2.10.10.2 Objects that Can Initiate the Event

The R080025 - Incremental Job Description Changes Outbound Integration object can initiate the RTJDOUT event.

2.10.11 RTJDOUTB

RTJDOUTB is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to competency based job description records.

Event Name

RTJDOUTB

Event Description

Job Description RTE

Event Type

RTE

Event Category

SINGLE

Product Code

08

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0800740B: Competency Based Job Desc RTE Notify

Relationship

Included in container event RTJDOUT.

2.10.11.1 Event Fields

The RTJDOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
OTPS szOrganizationType String 3 Organization Type
ORMCU szOrganizationalBusinessUnit String 12 Organizational Business Unit
JBCD szJobType String 6 Job Type
JBST szJobStep String 4 Job Step
JCC szJobCompetencyCode String 10 Job Competency Code
COPTN szOptionNumber String 3 Option Number
CMPE szCompetencyType String 3 Competency Type
CMPC szCompetencyCode String 10 Competency Code
LVWT mnCompetencyLevelRuleWeight Number 5 Competency Level Rule Weight
REQL mnRequiredLevel Number 6 Required Level
HIGHC mnCompLevelAcceptableHigh Number 6 Comp Level Acceptable High
LOWC mnCompLevelAcceptableLow Number 6 Comp Level Acceptable Low
RULEN mnRuleNumber Number 6 Rule Number
EFTB jdEffectiveBeginDate Date 6 Effective Begin Date
EFTE jdEffectiveEndDate Date 6 Effective End Date
PFMTH cPreferredMethod Char 1 Preferred Method
JCCS szJobCompetencyCodeSource String 63 Job Competency Code Source
OVREX cOverridesExistFlag Char 1 Overrides Exist Flag
INCLG mnIncludeInGapFlag Number 1 Include in Gap Flag
ACCOMP cAutoCalculateCompetency Char 1 Auto Calculate Competency
EFT jdEffectiveDate Date 6 Date - Effective

2.10.11.2 Conceptual Approach

When a user adds, modifies, or deletes competency based job description data in the JD Edwards EnterpriseOne Human Resources system and then runs R080025, Incremental Job Description Changes Outbound Integration program, the system publishes an event out to a third party system. The container event RTJDOUT contains one single event RTJDOUTB. The RTJDOUTB event contains all columns from the modified competency based job description record and an action code specifying what action was performed on the data (added, changed, deleted).

2.10.11.3 Objects that Can Initiate the Event

The R080025 - Incremental Job Description Changes Outbound Integration object can initiate the RTJDOUTB event.

2.10.12 RTJBUOUT

RTJBUOUT is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to the organizational business unit/jobs cross reference (F0800601).

Event Name

RTJBUOUT

Event Description

Jobs in Business Unit RTE

Event Type

RTE

Event Category

CONTAINER

Container event for RTJBUOUTB (D0800770B).

Product Code

08

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.10.12.1 Conceptual Approach

When a user adds, modifies, or deletes organizational business unit/jobs cross reference data (F0800601) from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTJBUOUT event is a container event activated on the F0800601 table trigger and contains the single event RTJBUOUTB.

2.10.12.2 Objects that Can Initiate the Event

These objects can initiate the RTJBUOUT event:

  • F0800601 - Organizational Business Unit/Job Cross Reference table trigger

  • B0800770 - Job in Business Unit Real Time Event Notification

2.10.13 RTJBUOUTB

RTJBUOUTB is a real-time event notification used by JD Edwards EnterpriseOne to notify external systems of changes to the organizational business unit/jobs cross reference (F0800601).

Event Name

RTJBUOUTB

Event Description

Jobs in Business Unit RTE

Event Type

RTE

Event Category

SINGLE

Product Code

08

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D0800770B: Data Structure for B0800770 RTE

Relationship

Included in container event RTJBUOUT.

2.10.13.1 Event Fields

The RTJBUOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode_ACTN Char 1 Action Code
ORMCU szOrgBusinessUnit_ORMCU String 12 Organizational Business Unit
JBCD szJobType_JBCD String 6 Job Type (Craft) Code
JBST szJobStep_JBST String 4 Job Step
EFTB jdDateBeginningEffective_EFTB Date 6 Date - Beginning Effective
EFTE jdDateEndingEffective_EFTE Date 6 Date - Ending Effective
OTPS szOrganizationType_OT String 3 Organization Type Structure
PID PS szProgramID_PID String 10 Program ID
JOBN szWorkStationID_JOBN String 10 Workstation ID
UPMJ jdDateUpdated_UPMJ Date 6 Data - Updated
UPMT mnTimeLastUpdated_UPMT Number 6 Time - Last Updated

2.10.13.2 Conceptual Approach

When a user adds, modifies, or deletes organizational business unit/jobs cross reference data (F0800601) from the JD Edwards EnterpriseOne system, the system publishes an event out to a third party system. The RTJBUOUT event is a container event activated on the F0800601 table trigger and contains the single event RTJBUOUTB. The RTJBUOUTB event contains all columns from the modified organizational business unit/jobs cross reference record (F0800601) and an action code specifying what action was performed on the data (added, changed, deleted).

2.10.13.3 Objects that Can Initiate the Event

These objects can initiate the RTJBUOUTB event:

  • F0800601 - Organizational Business Unit/Job Cross Reference table trigger

  • B0800770 - Job in Business Unit Real Time Event Notification

2.11 Inventory

This section discusses the real-time events generated by the Inventory Management system.

2.11.1 RTIMOUT

RTIMOUT is used by the JD Edwards EnterpriseOne system to notify third-party systems of item additions, changes, or deletions in order to keep the two systems synchronized.

Event Name

RTIMOUT

Event Description

Item Master Manage Notify

Event Type

RTE

Event Category

CONTAINER

Container event for RTIMOUTA (D4102150B).

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.11.1.1 Conceptual Approach

A new item master or item branch added in the JD Edwards EnterpriseOne system creates a new record in the Item Master (F4101) table or the Item Branch (F4102) table. A real-time notification event is triggered in the maintenance application after item master or item branch information is added to either table.

2.11.1.2 Objects that Can Initiate the Event

These objects can initiate the RTIMOUT event:

  • B4102150 - Item Master Real-Time Event Notify

  • B4102151 - Item Master Real Time Event Notify 2

  • N4101070 - Update Item Process Data

  • B4100340 - Update Item Branch Item

  • B4100290 - Insert Item Master Row

  • N4101130 - Workflow Update Approved Item Master Change

  • B4100840 - F4102 Update Item Branch Record

  • P4101N - Non Stock Item Master

  • R4101P - Item Master Purge (F4101)

  • P4690 - Warehouse Speed Group Maintenance

  • R4690 - Update Process and Item Dimens

  • XT4111Z1 - Inventory Transactions

2.11.2 RTIMOUTA

RTIMOUTA is used by the JD Edwards EnterpriseOne system to notify third-party systems of item additions, changes, or deletions in order to keep the two systems synchronized.

Event Name

RTIMOUTA

Event Description

ItemMasterManageNotify Detail

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4102150B: Item Master Real Time Event Notify Load Data

Relationship

Included in container event RTIMOUT.

2.11.2.1 Event Fields

The RTIMOUTA event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cOrderAction Char 1 Action Code
ITM mnShortItemNumber Numeric 8 Item Number
MCU szBusinessUnit String 12 Business Unit
STKT cStockingType Char 1 Stocking Type
LITM szProductItem String 25 Product Item Number
AITM szCatalogItem String 25 Catalog Item Number
DSC1 szDescription1 String 30 Item Description
DSC2 szDescription2 String 30 Item Description
UOM1 szPrimaryUnitofMeasure String 2 Unit of Measure
SRP1 szSalesReportingCode1 String 3 Sales Catalog Section
SRP2 szSalesReportingCode2 String 3 Sub Section
SRP3 szSalesReportingCode3 String 3 Sales Category Code 3
SRP4 szSalesReportingCode4 String 3 Sales Category Code 4
SRP5 szSalesReportingCode5 String 3 Sales Category Code 5
SRP6 szSalesReportingCode6 String 6 Category Code 6
SRP7 szSalesReportingCode7 String 6 Category Code 7
SRP8 szSalesReportingCode8 String 6 Category Code 8
SRP9 szSalesReportingCode9 String 6 Category Code 9
SRP0 szSalesReportingCode10 String 6 Category Code 10
PRP1 szPurchasingReportCode1 String 3 Commodity Class
PRP2 szPurchasingReportCode2 String 3 Commodity Sub Class
PRP3 szPurchasingReportCode3 String 3 Supplier Rebate Code
PRP4 szPurchasingReportCode4 String 3 Master Planning Family
PRP5 szPurchasingReportCode5 String 3 Purchasing Category Code 5
PRP6 szPurchReportingCode6 String 6 Group - Item Dimension
PRP7 szPurchReportingCode7 String 6 Group - Warehouse Process 1
PRP8 szPurchReportingCode8 String 6 Group - Warehouse Process 2
PRP9 szPurchReportingCode9 String 6 Group - Warehouse Process 3
PRP0 szPurchReportingCode10 String 6 Item Pool
GLPT szGlCateogry String 4 Category - G/L
SAFE mnSafetyStockDaysSupply Numeric 15 Safety Stock
SHCM szShippingCommodityClass String 3 Shipping Commodity Class
SHCN szShippingConditionsCode String 3 Shipping Conditions Code
LNTY szLineType String 2 Line Type
CYCL szCycleCountCateogry String 3 Cycle Count Category
CDCD szCommodityCode String 15 Commodity Code
PDGR szProductGroupFrom String 3 Product Group
DSGP szDispatchGrp String 3 Dispatch Group
VEND mnPrimaryLastVendorNo Numeric 8 Primary Last Vendor
ANPL mnAddressNumberPlanner Numeric 8 Address Number Planner
BUYR mnBuyer Numeric 8 Buyer
ORIG szCountryOfOrigin String 3 Country Of Origin
ROPI mnReorderPointInput Numeric 15 Reorder Point Input
ROQI mnReorderQuantityInput Numeric 15 Reorder Quantity Input
RQMN mnReorderQuantityMinimum Numeric 15 Reorder Quantity Minimum
RQMX mnReorderQuantityMaximum Numeric 15 Reorder Quantity Maximum
WOMO mnOrderMultiples Numeric 7 Order Multiples
SERV mnServiceLevel Numeric 7 Service Level
SLD mnShelfLifeDays Numeric 6 Shelf Life Days
CKAV cCheckAvailabilityYN Char 1 Check Availability
SRCE cLayerCodeSource Char 1 Layer Code Source
LOTS cLotStatusCode Char 1 Lot Status Code
OT1Y cConstantFutureUse1 Char 1 Constant Future Use 1
QT2Y cConstantFutureUse2 Char 1 Constant Future Use 2
STDP mnStandardPotency Numeric 7 Standard Potency
FRMP mnFromPotency Numeric 7 From Potency
THRP mnThruPotency Numeric 7 Thru Potency
STDG szStandardGrade String 3 Standard Grade
FRGD szFromGrade String 3 From Grade
THGD szThruGrade String 7 Thru Grade
COTY cComponentType Char 1 Component Type
MMPC mnMarginMaintenancePer Numeric 7 Margin Maintenance Per
PRGR szPricingCategory String 8 Pricing Category
RPRC szRepriceBasketPriceCat String 8 Reprice Basket Price
ORPR szOrderRepriceCategory String 8 Order Reprice Category
BACK cBackordersAllowedYN Char 1 Backorders Allowed
IFLA szItemFlashMessage String 2 Item Flash Message
ABCS cAbcCode1SalesInv Char 1 Abc Code 1 Sales Inv
ABCM cAbcCode2MarginInv Char 1 Abc Code 2 Margin Inv
ABCI cAbcCode3InvestInv Char 1 Abc Code 3 Invest Inv
OVR cAbcCodeOverrideIndica Char 1 Abc Code Override
CARS mnCarrier Numeric 8 Carrier
CARP mnPreferCarrierPurchasing Numeric 8 Prefer Carrier Purchasing
FIFO cFifoProcessing Char 1 Fifo Processing
INMG szPrintMessage1 String 10 Print Message 1
WARR szTypeWarranty String 8 Type Warranty
SRNR cSerialNumberRequired Char 1 Serial Number Required
PCTM mnPercentMargin Numeric 7 Percent Margin
CMCG szCommissionCategory String 8 Commission Category
FUF1 cApplyFrieght Char 1 Apply Freight
TX cTaxableYN1 Char 1 Purchasing Sales Taxable
TAX1 cTaxableYN Char 1 Sales Taxable
MPST cPlanningCode Char 1 Planning Code
MRPD cItemDisplayCode Char 1 Item Display Code
MRPC cNetChangeFlag Char 1 Net Change Flag
UPC mnUnitsPerContainer Numeric 15 Units Per Container
SNS cStockNonstock Char 1 Round to Whole Number
MERL szMeRevisionLevel String 3 Item Revision Level
LTLV mnLeadtimeLevel Numeric 5 Leadtime Level
LTMF mnLeadtimeMfg Numeric 5 Leadtime MFG
LTCM mnLeadtimeCum Numeric 5 Leadtime Cumulative
OPC cOrderPolicyCode Char 1 Order Policy Code
OPV mnOrderPolicyValue Numeric 15 Value - Order Policy
ACQ mnAcctingCostQty Numeric 15 Quantity - Accounting Cost
MLQ mnMfgLeadtimeQty Numeric 15 Quantity - MFG Leadtime
LTPU mnLeadtimePerUnit Numeric 5 Leadtime Per Unit
MPSP cPlanTimeFenceRule Char 1 Planning Time Fence Rule
MRPP cFixedVariableLeadtime Char 1 Fixed or Variable Leadtime
ITC cIssueTypeCode Char 1 Issue Type Code
ECO szEngineerChngOrderNo String 12 ECO Number
ECTY szEngineeringChngReason String 2 Engineering Change Reason
ECOD jdDateEngineerChgeDate Date 6 Date - Engineering Change Date
MTF1 mnPlanningTimeFenceDays Numeric 5 Planning Time Fence Days
MTF2 mnFreezeTimeFenceDays Numeric 5 Freeze Time Fence Days
MTF3 mnMsgTimeFenceDays Numeric 5 Message Time Fence Days
MTF4 mnTimeFence4 Numeric 5 MPS/MRP Time Fence 4
MTF5 mnTimeFence5 Numeric 5 Shipment Leadtime Offset
MOVD mnMoveHours Numeric 5 Move Hours - Standard
QUED mnQueueHours Numeric 5 Queue Hours - Standard
SETL mnSetupLaborHrsStdr Numeric 15 Setup Labor - Standard
SRNK mnShrinkFactor Numeric 15 Shrink Factor
SRKF cShrinkFactorMethod Char 1 Shrink Factor Method
TIMB cTimeBasisCode Char 1 Time Basis Code
BQTY mnUnitsBatchQuantity Numeric 15 Units - Batch Quantity
ORDW cOrderWithYN Char 1 Order With
EXPD mnExpediteDamperDays Numeric 5 Expedite Damper Days
DEFD mnDeferDamperDays Numeric 5 Defer Damper Days
MULT mnQtyOrderMultiples Numeric 15 Quantity - Order Multiples (MRP)
SFLT mnSafetyLeadtime Numeric 5 Safety Leadtime
MAKE cMakeBuyCode Char 1 Make/Buy Code
LFDJ jdDateLifo Date 6 Date - Future Use
LLX mnLowLevelCode Numeric 3 Low Level Code
CMGL cAllocateByLot Char 1 Commitment Method
URCD szUserReservedCode String 2 User Reserved Code
URDT jdUserReservedDate Date 6 User Reserved Date
URAT mnUserReservedAmount Numeric 15 User Reserved Amount
URAB mnUserReservedNumber Numeric 8 User Reserved Number
URRF szUserReservedReference String 15 User Reserved Reference
USER szUserId String 10 User ID
PID szProgramId String 10 Program ID
JOBN szWorkStationId String 10 Work Station ID
UPMJ jdDateUpdated Date 6 Date - Updated
TDAY mnTimeOfDay Numeric 6 Time of Day
TFLA szTemporaryItemFlashMessag String 2 Standard Unit of Measure Conversion
COMH mnCommitmentSpecificDays Numeric 3 Commitment - Specific (Days)
AVRT mnAverageQueueTimeHours Numeric 15 Replenishment Hours - Standard
POC cPayonconsumption Char 1 Issue and Receipt
AING cActiveIngredientFlag Char 1 Active Ingredient Flag
BBDD mnBestBeforeDefaultDays Numeric 6 Best Before Default Days
CMDM cCommitmentDateMethod Char 1 Commitment Date Method
LECM cLotExpirationDateCalculat Char 1 Lot Expiration Date Calculation Method
LEDD mnLotEffectiveDefaultDays Numeric 6 Lot Effective Default Days
MLOT cItemMultipleDates Char 1 Mix Dates / Lots (Y/N)
PEFD mnPurchasingEffectiveDays Numeric 6 Purchasing Effective Days
SBDD mnSellByDefaultDays Numeric 6 Sell By Default Days
U1DD mnUserLotDate1DefaultDays Numeric 6 User Lot Date 1 Default Days
U2DD mnUserLotDate2DefaultDays Numeric 6 User Lot Date 2 Default Days
U3DD mnUserLotDate3DefaultDays Numeric 6 User Lot Date 3 Default Days
U4DD mnUserLotDate4DefaultDays Numeric 6 User Lot Date 4 Default Days
U5DD mnUserLotDate5DefaultDays Numeric 6 User Lot Date 5 Default Days
XDCK cCrossDockFlag Char 1 Cross-Docking Flag
LAF cLotAuditFlag Char 1 Lot Audit Flag
LTFM cSpecialLotFormat Char 1 Special Lot Format
RWLA cRestrictWoLotAssignment Char 1 Restrict Work Order Lot Assignment
LNPA cLotNumberPreAsignment Char 1 Lot Number Pre-Assignment
LOTC szLotStatusCodeExpanded String 3 Lot Status Code Expanded
APSC cConstraintsFlag Char 1 Constraints Flag
PRI1 mnPriorityOneAlertLevel Numeric 15 Priority One Alert Level
PRI2 mnPriorityTwoAlertLevel Numeric 15 Priority Two Alert Level
LTCV mnLeadtimeConversionFactor Numeric 15 Leadtime Conversion Factor
ASHL cAllowShippingHeldLots Char 1 Allow Shipping of Held Lots

2.11.2.2 Conceptual Approach

A new item master or item branch added in the JD Edwards EnterpriseOne system creates a new record in the Item Master (F4101) table or the Item Branch (F4102) table. A real-time notification event is triggered in the maintenance application after item master or item branch information is added to either table.

2.11.2.3 Objects that Can Initiate the Event

These objects can initiate the RTIMOUTA event:

  • B4102150 - Item Master Real-Time Event Notify

  • B4102151 - Item Master Real Time Event Notify 2

  • N4101070 - Update Item Process Data

  • B4100340 - Update Item Branch Item

  • B4100290 - Insert Item Master Row

  • N4101130 - Workflow Update Approved Item Master Change

  • B4100840 - F4102 Update Item Branch Record

  • P4101N - Non Stock Item Master

  • R4101P - Item Master Purge (F4101)

  • P4690 - Warehouse Speed Group Maintenance

  • R4690 - Update Process and Item Dimens

  • XT4111Z1 - Inventory Transactions

2.11.3 RTIMOUT2

The JD Edwards EntepriseOne system uses RTIMOUT2 to notify third-party systems of item additions, changes, or deletions in order to keep the two systems synchronized.

Oracle designed this version to support information related to counry of origin and global location number.

Event Name

RTIMOUT2

Event Description

Item Master Manage Notify2

Event Type

RTE

Event Category

CONTAINER

Container event for RTIMOUTB (D4102152B).

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.11.3.1 Conceptual Approach

A new item master or item branch added in the JD Edwards EnterpriseOne system creates a new record in the Item Master (F4101) table or the Item Branch (F4102) table. A real-time notification event is triggered in the maintenance application after item master or item branch information is added to either table.

2.11.3.2 Objects that Can Initiate the Event

These objects can initiate the RTIMOUT2 event:

  • B4102150 - Item Master Real-Time Event Notify

  • B4102151 - Item Master Real Time Event Notify 2

  • N4101070 - Update Item Process Data

  • B4100340 - Update Item Branch Item

  • B4100290 - Insert Item Master Row

  • N4101130 - Workflow Update Approved Item Master Change

  • B4100840 - F4102 Update Item Branch Record

  • P4101N - Non Stock Item Master

  • R4101P - Item Master Purge (F4101)

  • P4690 - Warehouse Speed Group Maintenance

  • R4690 - Update Process and Item Dimens

  • XT4111Z1 - Inventory Transactions

2.11.4 RTIMOUTB

RTIMOUTB is used by the JD Edwards EnterpriseOne system to notify third-party systems of item additions, changes, or deletions in order to keep the two systems synchronized.

Event Name

RTIMOUTB

Event Description

ItemMasterManageNotify Detail

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4102152B: Item Master Real Time Event Notify Load Data

Relationship

Included in container event RTIMOUT.

2.11.4.1 Event Fields

The RTIMOUTB event contains the same fields as the RTIMOUTA event. In addition to those fields in the RTIMOUTA event, the RTIMOUTB event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
COORE cCountryOfOriginRequired Char 1 Country of Origin Required Flag
GVEND szVendorGLN String 13 Vendor GLN
GCARS szCarrierNumberGLN String 13 Carrier Number GLN
GAN8 szPlannerAddressGLN String 13 Planner Address GLN

2.11.4.2 Conceptual Approach

A new item master or item branch added in the JD Edwards EnterpriseOne system creates a new record in the Item Master (F4101) table or the Item Branch (F4102) table. A real-time notification event is triggered in the maintenance application after item master or item branch information is added to either table.

2.11.4.3 Objects that Can Initiate the Event

These objects can initiate the RTIMOUTB event:

  • B4102150 - Item Master Real-Time Event Notify

  • B4102151 - Item Master Real Time Event Notify 2

  • N4101070 - Update Item Process Data

  • B4100340 - Update Item Branch Item

  • B4100290 - Insert Item Master Row

  • N4101130 - Workflow Update Approved Item Master Change

  • B4100840 - F4102 Update Item Branch Record

  • P4101N - Non Stock Item Master

  • R4101P - Item Master Purge (F4101)

  • P4690 - Warehouse Speed Group Maintenance

  • R4690 - Update Process and Item Dimens

  • XT4111Z1 - Inventory Transactions

2.11.5 RTIBOUT

RTIBOUT is used by the JD Edwards EnterpriseOne system to notify third-party systems when an item location has been added, changed, or deleted in order to keep the two systems synchronized. Adding an Item Balance record that does not have quantity information or deleting an Item Balance record will not be published.

Event Name

RTIBOUT

Event Description

ItemBalanceManageNotify

Event Type

RTE

Event Category

CONTAINER

Container event for RTIBOUTA (D4101660A).

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4101660A: Item Balance Real Time Event Notification Template

Please see the associated single event for a list of event fields.

2.11.5.1 Conceptual Approach

An inventory location that has been added, changed, or deleted in the JD Edwards EnterpriseOne system updates the Item Location (F41021) table. When an item balance record is modified, an RTIBOUT real-time event notification is published.

Currently, this real-time event is used only by the APS integration.

2.11.5.2 Objects that Can Initiate the Event

These objects can initiate the RTIBOUT event:

  • B4101630 - Item Balance Real-Time Event Notify

  • XT4111Z1 - Inventory Transactions

  • XF41021 - Update F41021 Locations

  • B3100160 - Adjust Quantity on Work Order

  • B4100220 - Update Primary Location

  • B4100430 - Update Misc F41021 Fields

  • B4100630 - Update Item Commits To Zero

  • B4101370 - F41021 Update Quantities

  • B4200370 - Commit Sales Order to Inventory

  • N3101470 - R3190 Update Item Location and Parts List

  • N4202100 - F41021 Commitments Processing

  • R31420 - Automatic Work Order Inventory Issues

  • R3190 - Repost Open Work Orders

2.11.6 RTIBOUTA

RTIBOUTA is used by the JD Edwards EnterpriseOne system to notify third-party systems when an item location has been added, changed, or deleted in order to keep the two systems synchronized. Adding an Item Balance record that does not have quantity information or deleting an Item Balance record will not be published.

Event Name

RTIBOUTA

Event Description

ItemBalanceManageNotify A

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4101660A: Item Balance Real Time Event Notification Template

Relationship

Included in container event RTIBOUT

2.11.6.1 Event Fields

The RTIOUTA event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode Char 1 Action Code
LOCN szLocation String 20 Location
PBIN cPrimaryBinPS Char 1 Primary Location (P/S)
LOTS cLotStatusCode Char 1 Lot Status Code
PBCK mnQtyBackorderedInPri Numeric 15 Quantity on Backorder
PREQ mnQtyOnPurchaseOrderPr Numeric 15 Quantity on PO - Primary Units
QWBO mnQuantityOnWoReceipt Numeric 15 Quantity on WO Receipt
OT1P mnQty1OtherPrimaryUn Numeric 15 Quantity 1 - Other Primary Units
OT2P mnQty2OtherPrimaryUn Numeric 15 Quantity 2 - Other Primary Units
OT1A mnQtyOtherPurchasing1 Numeric 15 Quantity - Other Purchasing 1
HCOM mnQtyHardCommitted Numeric 15 Quantity - Hard Committed
PCOM mnQuantitySoftCommitted Numeric 15 Quantity - Soft Committed
FCOM mnQtyOnFutureCommit Numeric 15 Quantity on Future Commit
FUN1 mnWorkOrderSoftCommit Numeric 15 Quantity - WO Soft Commit
QOWO mnQuantityOnWorkorder Numeric 15 Quantity - WO Hard Commit
QTTR mnQtyInTranPrimaryUn Numeric 15 Units In Transit - Primary Units
QTIN mnQtyInInspPrimaryUn Numeric 15 Units In Inspection - Primary Units
QONL mnQuantityOnLoanToMa Numeric 15 Quantity on Loan to Manufacturing
QTRI mnQuantityInboundWareh Numeric 15 Quantity Inbound - Warehouse
QTRO mnQuantityOutboundWare Numeric 15 Quantity Outbound - Warehouse
QTY1 mnFutureUseQuantity Numeric 15 Future Use Quantity
QTY2 mnFutureUseQuantity2 Numeric 15 Future Use Quantity 2
TRQT mnPlanningQuantity Numeric 15 Used for APS
DCT szTransactionDocumentType String 2 Document Type
UPMJ jdDateUpdated Date 6 Used for APS
TDAY mnTimeUpdated Numeric 6 Used for APS
CMUM szPlanningUOM String 2 Used for APS
TRQT mnPlanningQuantity Numeric 15 Planning Quantity
EV01 cAPSFlag Char 1 Use 1 if it is an APS transaction
EV01 cAPSSupplyDemandFlag Char 1 Use 1 if it is verified through inclusion rules
ITM mnItemNumberShort Numeric 8 Populate with short item number
MCU szBranchPlant String 12 Business Unit
PQOH mnQtyOnHandPrimaryU Numeric 15 Quantity on Hand - Primary Units
QT01 mnQtyInOperation01 Numeric 15 Units in Operation 1 - Primary Units
QT02 mnQtyInOperation02 Numeric 15 Units in Operation 1 - Primary Units
LOTN szLotNumber String 30 Lot/Serial Number
DL01 szPlanningLotStatus String 30 Planning Lot Status

2.11.6.2 Conceptual Approach

An inventory location that has been added, changed, or deleted in the JD Edwards EnterpriseOne system updates the Item Location (F41021) table. When an item balance record is modified, an RTIBOUT real-time event notification is published. The RTIBOUT real-time event notification contains the RTIBOUTA event.

Currently, this real-time event is used only by the APS integration.

2.11.6.3 Objects that Can Initiate the Event

These objects can initiate the RTIBOUTA event:

  • B4101630 - Item Balance Real-Time Event Notify

  • XT4111Z1 - Inventory Transactions

  • XF41021 - Update F41021 Locations

  • B3100160 - Adjust Quantity on Work Order

  • B4100220 - Update Primary Location

  • B4100430 - Update Misc F41021 Fields

  • B4100630 - Update Item Commits To Zero

  • B4101370 - F41021 Update Quantities

  • B4200370 - Commit Sales Order to Inventory

  • N3101470 - R3190 Update Item Location and Parts List

  • N4202100 - F41021 Commitments Processing

  • R31420 - Automatic Work Order Inventory Issues

  • R3190 - Repost Open Work Orders

2.11.7 RTIBOUT2

RTIBOUT2 is used by the JD Edwards EnterpriseOne system to notify third-party systems when an item location has been added, changed, or deleted in order to keep the two systems synchronized. Adding an Item Balance record that does not have quantity information or deleting an Item Balance record will not be published.

Event Name

RTIBOUT2

Event Description

ItemBalanceManageNotify2

Event Type

RTE

Event Category

CONTAINER

Container event for RTIBOUTB (D4101661A).

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4101661A: Item Balance Real Time Event Notification Template

Please see the associated single event for a list of event fields.

2.11.7.1 Conceptual Approach

An inventory location that has been added, changed, or deleted in the JD Edwards EnterpriseOne system updates the Item Location (F41021) table. When an item balance record is modified, an RTIBOUT2 real-time event notification is published.

Currently, this real-time event is used only by the APS integration.

2.11.7.2 Objects that Can Initiate the Event

These objects can initiate the RTIBOUT event:

  • B4101630 - Item Balance Real-Time Event Notify

  • XT4111Z1 - Inventory Transactions

  • XF41021 - Update F41021 Locations

  • B3100160 - Adjust Quantity on Work Order

  • B4100220 - Update Primary Location

  • B4100430 - Update Misc F41021 Fields

  • B4100630 - Update Item Commits To Zero

  • B4101370 - F41021 Update Quantities

  • B4200370 - Commit Sales Order to Inventory

  • N3101470 - R3190 Update Item Location and Parts List

  • N4202100 - F41021 Commitments Processing

  • R31420 - Automatic Work Order Inventory Issues

  • R3190 - Repost Open Work Orders

2.11.8 RTIBOUTB

RTIBOUTB is used by the JD Edwards EnterpriseOne system to notify third-party systems when an item location has been added, changed, or deleted in order to keep the two systems synchronized. Adding an Item Balance record that does not have quantity information or deleting an Item Balance record will not be published.

Event Name

RTIBOUTB

Event Description

ItemBalanceManageNotify B

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4101661A: Item Balance Real Time Event Notification Template

Relationship

Included in container event RTIBOUT

2.11.8.1 Event Fields

The RTIBOUTB event contains the same fields as the RTIBOUTA event. Additionally, the RTIBOUTB event contains these fields:

data item/alias structure member name data type size desc

Data Item / Alias Structure Member Name Data Type Size Desc
ORIG szCountryOfOrigin Char 3 Lot Country of Origin

2.11.8.2 Conceptual Approach

An inventory location that has been added, changed, or deleted in the JD Edwards EnterpriseOne system updates the Item Location (F41021) table. When an item balance record is modified, an RTIBOUT2 real-time event notification is published. The RTIBOUT2 real-time event notification contains the RTIBOUTB event.

Currently, this real-time event is used only by the APS integration.

2.11.8.3 Objects that Can Initiate the Event

These objects can initiate the RTIBOUTB event:

  • B4101630 - Item Balance Real-Time Event Notify

  • XT4111Z1 - Inventory Transactions

  • XF41021 - Update F41021 Locations

  • B3100160 - Adjust Quantity on Work Order

  • B4100220 - Update Primary Location

  • B4100430 - Update Misc F41021 Fields

  • B4100630 - Update Item Commits To Zero

  • B4101370 - F41021 Update Quantities

  • B4200370 - Commit Sales Order to Inventory

  • N3101470 - R3190 Update Item Location and Parts List

  • N4202100 - F41021 Commitments Processing

  • R31420 - Automatic Work Order Inventory Issues

  • R3190 - Repost Open Work Orders

2.11.9 RTCOSTOUT

RTCOSTOUT is a container event generated by the JD Edwards EnterpriseOne system to notify third-party systems of changes to the unit cost of an item. Any adds or changes to a unit cost are generated as a change real-time event. Deletes are not supported.

Event Name

RTCOSTOUT

Event Description

RTE COST

Event Type

RTE

Event Category

CONTAINER

Contains the RTCOSTOUTA (D4102180B).

Product Code

41

Reliable Delivery

1

Delivery Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.11.9.1 Conceptual Approach

A unit cost is added or changed in the item cost table (F4105). The JD Edwards EnterpriseOne system sends out item cost real-time events with unit cost information.

2.11.9.2 Objects that Can Initiate the Event

The P4105 - Work with Item Cost program can initiate the RTCOSTOUT event.

2.11.10 RTCOSTOUTA

RTCOSTOUTA is a single event that is generated by the JD Edwards EnterpriseOne system to provide item information about changes to the unit cost of an item. Any adds or changes to a unit cost are generated as a change real-time event. Deletes are not supported.

Event Name

RTCOSTOUTA

Event Description

RTE COST

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4102180B: Item Cost Real Time Wrapper

Event Relationship

Included in container event RTCOSTOUT.

2.11.10.1 Event Fields

The RTCOSTOUTA event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTION cEventAction Char 1 Action Type
ITM mnIdentifierShortItem Math Numeric 8 Item Number - Short
LITM szIdentifier2ndItem String 25 2ndItem Number
AITM szIdentifer3rdItem String 25 3rdItem Number
MCU szBranchPlant String 12 Business Unit
LOCN szLocation String 20 Location
LOTN szLot String 30 Lot/Serial Number
LOTG szLotGrade String 3 Lot Grade
LEDG szCostMethod String 2 Cost Method
AA mnAmountUnitCost Math Numeric 15(2) Amount
CSPO cPurchasingCostingSelection Char 1 Costing Selection - Purchasing
CSIN cInventoryCostingSelection Char 1 Costing Selection - Inventory
CCFL cCostChangedFlag Char 1 Cost Changed Flag
CRCS mnCarryingCost Math Numeric 15(4) Carrying Cost
OSTC mnOverstockCost Math Numeric 15(4) Overstock Cost
STOC mnStockoutCost Math Numeric 15(4) Stockout Cost
CLEV cCostLevel Char 1 Level - Inventory Cost
LOC szPrimaryLocation String 12 Business Unit - Location

2.11.10.2 Conceptual Approach

A unit cost is added or changed in the item cost table (F4105). The JD Edwards EnterpriseOne system sends out item cost real-time events with unit cost information.

2.11.10.3 Objects that Can Initiate the Event

The P4105 - Work with Item Cost program can initiate the RTCOSTOUTA event.

2.11.11 RTUOMOUT

RTUOMOUT is a container event generated by the JD Edwards EnterpriseOne system to notify third-party systems of adds and changes to unit of measure conversions.

Event Name

RTUOMOUT

Event Description

Notify Item UOM event

Event Type

RTE

Event Category

CONTAINER

Container event for RTUOMDTL (D4102170A).

Product Code

H41

Reliable Delivery

Blank

Timeout Threshold

0

Please see the associated single event for a list of event fields.

2.11.11.1 Conceptual Approach

Unit of measure conversion information that is added or modified for a given item in the Unit of Measure table F41002 is sent out in a real-time event.

2.11.11.2 Special Setup

If the system constant Unit of Measure Conversion by Branch is Off, all unit of measure (UOM) conversions for the item and a blank branch plant are sent in the real-time event.

If the system constant Unit of Measure Conversion by Branch is On and the Default Branch Plant processing option on version ZJDE0001 of UOM Conversion Real Time Wrapper Application (P4102170) is blank, the UOM conversions for the item and all branch plants are sent in the real-time event.

If the system constant Unit of Measure Conversion by Branch is On and the Default Branch Plant processing option on version ZJDE0001 of UOM Conversion Real Time Wrapper Application (P4102170) is 1, the UOM conversions for the item and the current branch plant are sent in the real-time event.

2.11.11.3 Objects that Can Initiate the Event

The P41002 - Unit of Measure Conversions - Item program can initiate the RTUOMOUT event.

2.11.12 RTUOMDTL

RTUOMDTL is a single event that is generated by the JD Edwards EnterpriseOne system to provide unit of measure conversion information.

Event Name

RTUOMDTL

Event Description

UOM conversion single event

Event Type

RTE

Event Category

SINGLE

Product Code

H41

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4102170A: UOM Conversion Real Time Data

Event Relationship

Included in container event RTUOMOUT.

2.11.12.1 Event Fields

The RTUOMDTL event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cActionCode String 1 Action Code
ITM mnIdentifierShortItem Numeric 8 Short Item
MCU szCostCenter String 12 Cost Center
UOM1 szUnitOfMeasurePrimary String 3 Unit Of Measure Primary
UM szUnitOfMeasureFrom String 3 Unit Of Measure From
RUM szUnitOfMeasureTo String 3 Unit Of Measure To
USTR cUnitOfMeasureStructure String 1 Unit Of Measure Structure
CONV mnConversionFactor Numeric 15 Conversion Factor
CNV1 mnConvFactorToPrimary Numeric 15 Conv Factor To Primary
EXPO cExcludeFromPO String 1 Exclude From PO
EXSO cExcludeFromSO String 1 Exclude From SO
PUPC nPurchasePriceCode Integer 11 Purchase Price Code
SEPC nSalesPriceCode Integer 11 Sales Price Code
PID szCallingApplication String 10 Calling Application

2.11.12.2 Conceptual Approach

Unit of measure conversion information added or modified for a given item in the Unit of Measure table F41002 is sent out in a real-time event.

2.11.12.3 Objects that Can Initiate the Event

The P41002 - Unit of Measure Conversions - Item program can initiate the RTUOMDTL event.

2.12 Manufacturing

This section discusses the real-time events generated by the Manufacturing system.

2.12.1 RTWOOUT

RTWOOUT is used by the JD Edwards EnterpriseOne system to inform third-party systems when a work order has been added, changed, or deleted in order to keep the two systems synchronized.

Event Name

RTWOOUT

Event Description

Work Order

Event Type

RTE

Event Category

CONTAINER

Contains the RTWOHDR (D3102360A) event.

Product Code

H31

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D3102360A: Work Order Event Notification Canonical

Please see the associated single event for a list of event fields.

2.12.1.1 Conceptual Approach

A work order that has been added, changed, or deleted in the JD Edwards EnterpriseOne system updates the Work Order Header (F4801) table. When a work order record has been modified, a RTWOOUT real-time event notification is published.

2.12.1.2 Objects that Can Initiate the Event

These objects can initiate the RTWOOUT event:

  • B3102360 - Work Order Real-Time Event Notification

  • B3100790 - Work Order Inventory Issues

  • B3101030 - Purge Work Order Data

  • B3101060 - F3112, F31122 Super Backflush

  • N4202020 - F4211 Update Work Order Status

  • P31225 - Manufacturing Scheduling Workbench

  • X4801 - X4801 Work Order Entry

2.12.2 RTWOHDR

RTWOHDR is used by the JD Edwards EnterpriseOne system to pass work order information to third-party systems when a work order has been changed.

Event Name

RTWOHDR

Event Description

Work Order Header

Event Type

RTE

Event Category

SINGLE

Product Code

H31

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D3102360A: Work Order Event Notification Canonical

Event Relationship

Included in container event RTWOOUT.

2.12.2.1 Event Fields

The RTWOOUT event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cEventNotificationActionCode Char 1 Action Code
DOCO mnOrderNumber Numeric 8 Document (Order No, Invoice, etc.)
DCTO szOrderType String 3 Order Type
MMCU szBranchPlant String 12 Branch
SRST szWOStatus String 2 Status Code W.O.
STRT jdStartDate Date 6 Date - Start (Julian)
DRQJ jdRequestDate Date 6 Date - Requested
TRDJ jdTransactionDate Date 6 Date - Order/Transaction
ITM mnShortItemNumber Numeric 8 Item Number - Short
LITM szSecondItemNumber String 25 2nd Item Number
AITM szThirdItemNumber String 25 3rd Item Number
UORG mnQuantityOrdered Numeric 15 Units - Order/Transaction Quantity
SOQS mnQuantityCompletedShipped Numeric 15 Quantity Shipped
SOCN mnQuantityScrappedCanceled Numeric 15 Units - Quantity Canceled/Scrapped
SOBK mnQuantityBackorderedHeld Numeric 15 Units - Qty Backordered/Held
TRQT mnTransactionOpenQuantity Numeric 15 Quantity Available
UOM szTransactionUOM String 2 Unit Of Measure as Input
UNCD cFreezeCode Char 1 Work Order Freeze Code
SFXO szOrderSuffix String 3 Order Suffix
DCT szDocumentType String 3 Document Type
TYPS cTypeWO Char 1 Type - W.O.
PRTS cPriorityWO Char 1 Priority - W.O.
LOCN szLocation String 20 Location
LOTN szLotNumber String 30 Lot/Serial Number
SHNO szMessageNumber String 10 Message Number
VR01 szReference String 25 Reference
RORN szRelatedOrderNumber String 8 Related PO/SO/WO Number
RCTO szRelatedOrderType String 2 Related PO/SO/WO Order Type
RKCO szRelatedOrderCompany String 5 Company - Key (Related Order)
LNID mnRelatedLineNumber Numeric 6 Line Number
DL01 szWorkOrderDescription String 30 Description
PARS szParentOrderNumber String 8 Number - Parent WO Number
WR01 szWOCategoryCode001 String 4 Categories - Work Order 01
WR02 szWOCategoryCode002 String 4 Categories - Work Order 02
WR03 szWOCategoryCode003 String 4 Categories - Work Order 03
WR04 szWOCategoryCode004 String 4 Categories - Work Order 04
WR05 szWOCategoryCode005 String 4 Categories - Work Order 05
VFWO cFirmWorkOrder Char 1 Firm Work Order
UPJM jdDateUpdated Date 6 Date - Updated
TDAY mnTimeUpdated Numeric 6 Time of Day
CMUM szPlanningUOM Numeric 15 Future Use Unit of Measure
TRQT mnPlanningQuantity Numeric 15 Quantity Available
EV01 cWOChangeAllowed Char 1 Event Point 01
EV01 cWOStatusFlag Char 1 Event Point 01
EV01 cAPSFlag Char 1 Event Point 01

Note: Use 1 if it is an SCP transaction.

EV01 cAPSSupplyDemandFlag Char 1 Event Point 01

Note: Use 1 if it is verified through inclusion rules.

TBM szWorkOrderBillType String 3 Type Bill of Material
TRT szWorkOrderRoutingType String 3 Type of Routing
GS2A szPlanningOrderType String 20 Generic String x 20
MMCU szParentWOBranchPlant String 12 Branch

2.12.2.2 Conceptual Approach

This real-time event is triggered when a work order header is changed.

2.12.2.3 Objects that Can Initiate the Event

Any process that changes the event fields on a work order header can initiate the real-time event. For example:

  • Work Order Entry

  • Inventory Issues

  • Shop Floor Workbench

2.12.3 OPBOMROUT

OPBOMROUT is used by the JD Edwards EnterpriseOne system to inform third-party systems when a work orders parts list and routing is added, changed, or deleted.

Event Name

OPBOMROUT

Event Description

Transaction BOMR

Event Type

RTE

Event Category

CONTAINER

Contains these data structures:

  • D34A1140A: Transactional RLR Header Event Notification Canonical

  • D34A1140B: Transactional RLR Routing Event Notification Canonical

  • D34A1140C: Transactional RLR Resource List Event Notification Canonical

Product Code

34A

Reliable Delivery

1

Delivery Timeout Threshold

0

2.12.3.1 Event Fields - D34A1140A

The D34A1140A data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
EV01 cEventNotificationActionCode Char 1 Event Point 01

Note: 1 = Add (Needed for OP Commit) 2 = Update/Change 3 = Delete

DOCO mnOrderNumber Numeric 15 Document (Order No, Invoice, etc.)

Note: Value of 1, 2, or 3. 1 is Add 2 is Change 3 is Delete

DCTO szOrderType String 2 Order Type
EV01 cWOChangeAllowed Char 1 Event Point 01

Note: 0 = No 1 = Yes

MCU szBranchPlant String 12 Business Unit
ITM mnShortItemNumber Numeric 15 Item Number - Short
LITM szSecondItemNumber String 25 2nd Item Number
AITM szThirdItemNumber String 25 3rd Item Number
STRT jdDateStart Date 6 Date - Start (Julian)
DRQJ jdDateRequestedJulian Date 6 Date - Requested
UORG mnQuantityOrdered Numeric 15 Units - Order/Transaction Quantity
UOM szUnitOfMeasure String 2 Unit of Measure as Input
RORN szRelatedOrderNumber String 8 Related PO/SO/WO Number
RCTO szRelatedOrderType String 2 Related PO/SO/WO Order Type
RKCO szRelatedKeyCompany String 5 Company - Key (Related Order)
LNID mnRelatedLineNumber Numeric 15 Line Number
PARS szParentWoNumber String 8 Number - Parent WO Number
UM szPlanningUnitofMeasure String 2 Unit Of Measure
UORG mnQuantityPlanned Numeric 15 Units - Order/Transaction Quantity
UORG mnPlanningMultiple Numeric 15 Units - Order/Transaction Quantity
EV01 cPlanningEnabled Char 1 Event Point 01
EV01 cPlanningSupplyDemand Char 1 Event Point 01
GS2A szPlanningOrderType String 20 Generic String x 20
EV01 cPlanningOrderStatus Char 1 Event Point 01

2.12.3.2 Event Fields - D34A1140B

The D34A1140B data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
DOCO mnOrderNumber Numeric 15 Document (Order No, Invoice, etc.)
DCTO szOrderType String 2 Order Type
OPSQ mnOperationSequenceNumber Numeric 15 Sequence Number - Operations
MCU szWorkCenter String 12 Business Unit
OPSQ mnSuccessiveOperation Numeric 15 Sequence Number - Operations
SETL mnSetupHours Numeric 15 Setup Labor - Standard
MOVD mnMoveHours Numeric 15 Move Hours - Standard
QUED mnQueueHours Numeric 15 Queue Hours - Standard
POVR mnPercentOfOverlap Numeric 15 Percent - Overlap
DL01 szPrecedenceType String 30 Description
MATH01 mnPrecedenceOffset Numeric 15 Math Numeric 01
OPSC szTypeOperationCode String 3 Type Operation Code
EV01 cActionType Char 1 Event Point 01

Note: Value of 1, 2, or 3 1 is Add. 2 is Change. 3 is Delete.

DRQJ jdRequestedDate Date 6 Date - Requested
ASJ jdPlannedStartDate Date 6 Actual Start Date
DRQJ jdPlannedFinishDate Date 6 Date - Requested

2.12.3.3 Event Fields - D34A1140C

The D34A1140C data structure contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
DOCO mnOrderNumber Numeric 15 Docuemnt (Order No, Invoice, etc.)
DCTO szOrderType String 2 Order Type
OPSQ mnOperationSequenceNumber Numeric 15 Sequence Number - Operations
ATSQ szResourceID String 23 Configurator Sequence Number
DOCO mnSubassemblyWorkOrderNumber Numeric 15 Docuemnt (Order No, Invoice, etc.)
GS3A szResourceType String 30 Generic String x 30
CPIT mnShortItemNumber Numeric 15 Component Item Number - Short
CPIL szSecondItemNumber String 25 Component 2nd Item Number
CPIA szThirdItemNumber String 25 Component 3rd Item Number
GS1A szUnitOfMeasure String 10 Generic String x 10
UORG mnQuantityPer Numeric 15 Units - Order/Transaction Quantity
UORG mnQuantityPlanned Numeric 15 Units - Order/Transaction Quantity
UORG mnQuantityPerPlanned Numeric 15 Units - Order/Transaction Quantity
UORG mnPlanningMultiple Numeric 15 Units - Order/Transaction Quantity
OPSC szTypeOperationCode String 3 Type Operation Code
MCU szWorkCenter String 13 Business Unit
UORG mnExtendedQuantity Numeric 15 Units - Order/Transaction Quantity
EV01 cActionType Char 1 Event Point01
DESC szItemDescription String 30 Description
CMCU szComponentBranch String 12 Component Branch
RESCD szResourceCode String 12 Resource Code
GS1A szPlanningUnitOfMeasure String 10 Generic String x 10

2.12.3.4 Conceptual Approach

A work order parts list or routing that has been added, changed, or deleted in the JD Edwards EnterpriseOne system updates the Work Order Parts List (F3111) and the Work Order routing (F3112) tables. When a work order parts list or routing record is modified, an OPBOMROUT real-time event notification is published.

2.12.3.5 Objects that Can Initiate the Event

These objects can initiate the OPBOMROUT event:

  • B3101250 - Work Order Routings Master Business Function

  • B3101260 - F3111 Parts List Master Business Function

  • R31410 - Order Processing

2.13 Procurement

This section discusses the real-time events generated by the Procurement and Subcontract Management system.

2.13.1 RTPOOUT

RTPOOUT is a container event used by the JD Edwards EnterpriseOne system that notifies third-party systems when purchase order information changes.

Event Name

RTPOOUT

Event Description

Purchase Order

Event Type

RTE

Event Category

CONTAINER

Container event for:

  • RTPOHDR (D4302470A)

  • RTPODTL (D4302470B)

  • RTPODIST (D4302470C)

Note:

RTPODIST is included in RTPOOUT if the multiple accounts flag is selected for the order line.
Product Code

H43

Reliable Delivery

1

Delivery Timeout Threshold

0

2.13.1.1 Event Fields

Please see the appropriate single events (identified in the preceding table) for the fields.

2.13.1.2 Conceptual Approach

A new purchase order creates a new record in the Purchase Order Header table (F4301) and the Purchase Order Detail table (F4311). It also creates a new record in Purchase Order Multiple Accounts (F4316) file multiple account records are associated with the purchase order. A real-time notification is triggered whenever there is an insert in these tables. Also, this event is triggered whenever an exiting purchase order is updated and there is an update to the Purchase Order Header and Purchase Order Detail tables.

2.13.1.3 Objects that Can Initiate the Event

These objects can initiate the RTPOOUT event:

  • P43025 - PO Speed Status Update

  • P43060 - Blanket Order Release

  • P43081 - Purchase Order Approvals

  • P43100 - Purchasing Date Revisions

  • R43500 - Purchase Order Print

2.13.1.4 Special Setup

To activate the RTPOOUT event, these three important areas are required for data setup:

  • The Suppliers Correspondence Method (F0401.CRMD, sometimes called Send Method) must be set to 5.

  • The Document Type of the purchase order must be set up to publish externally. Use the P40040 application to inquire on a document type and select the publish externally check box on the Purchasing tab of the Document Type Revisions form.

  • Currently all procurement integrations that need processing options use the processing options for P43XPI-ZJDE0001. This event uses the first two processing options on the Order Statuses tab. With these options you can set the range of allowed order statuses that can be published externally. Order Status 999 is valid outside of the dictated range.

2.13.2 RTPOHDR

RTPOHDR is used by the JD Edwards EnterpriseOne system to notify third-party systems about purchase order changes.

Event Name

RTPOHDR

Event Description

Purchase Order Header

Event Type

RTE

Event Category

SINGLE

Product Code

H43

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4302470A: Purchase Order Header

Event Relationship

Included in container event RTPOOUT.

2.13.2.1 Event Fields

The RTPOHDR event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
ACTN cOrderAction Char 1 Action Code
DOCO mnOrderNumber Numeric 8 Document (Order No, Invoice, etc)
DCTO szOrderType String 2 Order Type
KCOO szOrderCompany String 5 Order Company (Order Number)
SFXO szOrderSuffix String 3 Order Suffix
MCU szBranchPlant String 12 Business Unit
AN8 mnSupplierAddressNumber Numeric 8 Address Number
SHAN mnShipToAddressNumber Numeric 8 Address Number - Ship to
MLNM szShipToMailingName String 40 Name - Mailing
ADD1 szShipToAddressLine1 String 40 Address Line1
ADD2 szShipToAddressLine2 String 40 Address Line2
ADD3 szShipToAddressLine3 String 40 Address Line3
ADD4 szShipToAddressLine4 String 40 Address Line4
CTY1 szShipToCity String 23 City
COUN szShipToCounty String 23 County
ADDS szShipToState String 3 State
ADDZ szShipToPostalCode String 12 Postal Code
CTR szShipToCountry String 3 Country
CRCD szCurrencyCode String 3 Currency Code - From
TRDJ jdOrderDate Date 6 Order Date
ORBY szOrderedBy String 10 Ordered By
TKBY szOrderTakenBy String 10 Order Taken By
OORN szOriginalPOSONumber String 8 Original Order Number
HOLD szHoldCode String 2 Hold Orders Code
CRR mnExchangeRate Numeric 15 Currency Conversion Rate - Spot Rate
PTC szPaymentTerms String 3 Payment Terms Code
TXA1 szTaxArea1 String 10 Tax Rate/Area
EXR1 szTaxExplanationCode String 2 Tax Expl Code 1
MLNM szSupplierMailingName String 40 Name - Mailing
ADD1 szSupplierAddressLine1 String 40 Address Line 1
ADD2 szSupplierAddressLine2 String 40 Address Line 2
ADD3 szSupplierAddressLine3 String 40 Address Line 3
ADD4 szSupplierAddressLine4 String 40 Address Line 4
CTY1 szSupplierCity String 25 City
COUN szSupplierCounty String 25 County
ADDS szSupplierState String 3 State
ADDZ szZipCodePostalCode String 12 Postal Code
CTR szSupplierCountry String 3 Country
URCD szUserReservedCode String 2 User Reserved Code
URDT jdUserReservedDate Date 6 User Reserved Date;
URAT mnUserReservedAmount Numeric 15 User Reserved Amount
URRF szUserReservedReference String 15 User Reserved Reference
URAB mnUserReservedNumber Numeric 8 User Reserved Number
CRRM cCurrencyMode Char 1 Currency Mode Foreign or Domestic Entry
CORD mnOrderRevisionNumber Numeric 3 Change Order Number
TXLN szOrderTextAttachment String 60 Message Text Line
TAX szShipToTaxID String 20 Tax ID
MLNM szBillToMailingName String 40 Name - Mailing
ADD1 szBillToAddressLine1 String 40 Address Line 1
ADD2 szBillToAddressLine2 String 40 Address Line 2
ADD3 szBillToAddressLine3 String 40 Address Line 3
ADD4 szBillToAddressLine4 String 40 Address Line 4
CTY1 szBillToCity String 25 City
COUN szBillToCounty String 25 County
ADDS szBillToState String 3 State
ADDZ szBillToPostalCode String 12 Postal Code
CTR szBillToCountry String 3 Country
DEL1 szDeliveryInstructLine1 String 30 Delivery Instructions Line 1
DEL2 szDeliveryInstructLine2 String 30 Delivery Instructions Line 2
FRTH szFreightHandlingCode String 3 Freight Handling Code
EV01 cExternalEventType Char 1 Event Point 01
ALKY szSupplierDescriptive String 20 Long Address Number
ALKY szShipToDescriptive String 20 Long Address Number
OKCO szOriginalDocumentCompany String 5 Document Company (Original Order)
OCTO szOriginalOrderType String 2 Original Order Type
RKCO szRelatedOrderCompany String 5 Company - Key (Related Order)
RORN szRelatedPoSoNumber String 8 Related PO/SO/WO Number
RCTO szRelatedOrderType String 2 Related PO/SO/WO Order Type
DRQJ jdDateRequested Date 6 Date - Requested
PDDJ jdScheduledPickDate Date 6 Date - Scheduled Pick
OPDJ jdOriginalPromisedDeliveryDate Date 6 Date - Original Promised Delivery
ADDJ jdActualShipDate Date 6 Date - Actual Ship Date
CNDJ jdCancelDate Date 6 Date - Cancel
PEFJ jdPriceEffectiveDate Date 6 Date - Price Effective Date
PPDJ jdPromisedShipDate Date 6 Date - Promised Shipment
PSDJ jdFutureDate2 Date 6 Date - Future Date 2
VR01 szReference1 String 25 Reference
VR02 szReference2Vendor String 25 Reference 2
RMK szNameRemark String 30 Name - Remark
DESC szDescription String 30 Description
TXLN szPrintMessageText String 60 Message Text Lin
TXCT szCertificateTaxExempt String 20 Certificate, Tax Exemption
CNID szContainerID String 20 Container I.D.
ANBY mnBuyerNumber Numeric 8 Buyer Number
ANCR mnCarrierNumber Numeric 8 Carrier Number
PCRT mnRetainagePercent Numeric 7 Percent - Retainage
PRP5 szLandedCostRule String 3 Purchasing Category Code 5
DOC1 mnDocumentOrderInvoice Numeric 8 Document (Order #, Invoice, etc.)
DCT4 szDocumentType String 2 Document Type
FAP mnAmountForeignOpen Numeric 15 Amount - Foreign Open
SIGNON szLogInID String 30 Sign On ID
PASSWD szSharedSecret String 50 Signon Password
AUTHURL szAuthenticationURL String 3000 Authentication URL
ALPH szUserAgent String 40 Name - Alpha
XMLSCH szXMLSchema String 30 XML Schema
FRMDMN szFromDomain String 31 Buyer organization's Credential Domain
FRMIDEN szFromIdentity String 31 Buyer organization's Credential Identity
TODMN szToDomain String 31 Supplier Credential Domain
TOIDEN szToIdentity String 31 Supplier Credential Identity
SENDDMN szSenderDomain String 31 Sender's Credential Domain
SENDIDEN szSenderIdentity String 31 Sender's Credential Identity
MACALGO szMACAlgorithm String 31 MAC Algorithm
MACTYPE szMACCredentialType String 31 Credential MAC TYPE
CREATEDT szDateCreated String 30 Creation Date
EXPIREDT szDateExpired String 30 Expiration Date
MACVALUE szMACValue String 301 MAC Credential Value
EMAL szShipToEmail String 256 Electronic Address
EMAL szBillToEmail String 256 Electronic Address

2.13.2.2 Conceptual Approach

This real-time event is contained in the RTPOOUT event and is triggered whenever that event is triggered. The RTPOHDR event contains information from the Purchase Order Header table (F4301).

2.13.2.3 Objects that Can Initiate the Event

These objects can initiate the RTPOHDR event:

  • P43025 - PO Speed Status Update

  • P43060 - Blanket Order Release

  • P43081 - Purchase Order Approvals

  • P43100 - Purchasing Date Revisions

  • P43360 - Release Open Quotations

  • R43500 - Purchase Order Print

  • R43510 - Purchase Receiver Print

  • R47021 - EDI Inbound PO Acknowledgement

  • R47132 - EDI Purchase Order Change Extraction

  • R47141 - EDI Inbound PO Change Acknowledgement

  • B3100200 - Update Routing Quantity and Date

  • B3100410 - Update Purchase Order Hold Code

  • B4300250 - Release Held Order

  • B4300330 - Update PO Next Status

  • B4301230 - F4311-Update Original PO Line

  • B4300870 - F43092, Update Disposition Information

  • N4002540 - F4211 Direct Ship Order Integrity

  • N4301240 - Reverse Matched Voucher

  • N4900330 - F4215 Approve Shipment

  • N4900570 - Update F4211 and F49211 with Shipment Number

  • N4900640 - F4215 Unapprove Shipment

  • N4901130 - F4311 Update Purchase Order Detail with Routing

  • XT4311Z1 - Purchase Order Entry Master Business Function

  • XT4312Z1 - Purchase Order Receipts Master Business Function

  • XT4314ZN - Voucher Match Master Business Function

2.13.3 RTPODTL

RTPODTL is used by the JD Edwards EnterpriseOne system to notify third-party systems about purchase order changes.

Event Name

RTPODTL

Event Description

Purchase Order Detail

Event Type

RTE

Event Category

SINGLE

Product Code

H43

Reliable Delivery

1

Delivery Timeout Threshold

0

Data Structure

D4302470B: Purchase Order Detail

Event Relationship

Included in container event RTPOOUT.

2.13.3.1 Event Fields

The RTPODTL event contains these fields:

Data Item / Alias Structure Member Name Data Type Size Description
DOCO mnOrderNumber Numeric 8 Document (Order No, Invoice, etc)
DCTO szOrderType String 2 Order Type
KCOO szOrderCompany String 5 Order Company (Order Number)
SFXO szOrderSuffix String 3 Order Suffix
LNID mnOrderLineNumber Numeric 6 Line Number
MCU szBranchPlant String 12 Business Unit
AN8 mnSupplierAddressNumber Numeric 8 Address Number
SHAN mnShipToAddressNumber Numeric 8 Address Number - Ship To
PRRC mnPurchasingUnitCost Numeric 15 Amount - Unit Cost
FRRC mnForeignPurchasingUnitCost Numeric 15 Amount - Foreign Unit Price
CRCD szCurrencyCode String 3 Currency Code - From
UORG mnTransactionQuantity Numeric 15 Units - Order/Transaction Quantity
UOM szTransactionUnitOfMeasure String 2 Unit of Measure as Input
UOM1 szPrimaryUnitOfMeasure String 2 Unit of Measure - Primary
UOM3 szPurchasingUnitOfMeasure String 2 Unit of Measure - Purchasing
DRQJ jdRequestedDate Date 6 Date - Requested
PDDJ jdPromisedDeliveryDate Date 6 Date - Scheduled Pick
DSVJ jdServiceTaxDate Date 6 Date - Service/Tax
DSC1 szItemDescription String 30 Description
UITM szItemNumber String 26 Item Number - Unknown Format Entered
ANI szAccountNumber String 29 Account Number - Input (Mode Unknown)
TX cTaxableYN Char 1 Purchasing Taxable (Y/N)
TXA1 szTaxRateArea String 10 Tax Rate/Area
EXR1 szTaxExplanationCode String 2 Tax Exp Code1
TORG szTransactionOriginator String 10 Transaction Originator
VR02 szReference2Vendor String 25 Reference 2
OORN szOriginalPOSONumber String 8 Original Order Number
VR01 szReference String 25 Reference
PPDJ jdPromisedShipDate Date 6 Date - Promised Shipment
AEXP mnExtendedCost Numeric 15 Amount - Extended Price
FEA mnForeignExtendedCost Numeric 15 Amount - Foreign Extended Price
ASID szAssetID String 25 Serial Number
SBL szSubledger String 8 Sub ledger - G/L
SBLT cSubledgerType Char 1 Sub ledger Type
MOT szModeOfTransport String 3 Mode of Transport
ANCR mnCarrier Numeric 8 Carrier Number
PDP5 szLandedCostRule String 3 Reporting Code 5 - Purchasing
OCTO szOriginalOrderType String 2 Original Order Type
OKCO szOriginalOrderCompany String 5 Document Company Original Order)
OGNO mnOriginalOrderLineNumber Numeric 7 Original Line Number
URCD szUserReservedCode String 2 User Reserved Code
URDT jdUserReservedDate Date 6 User Reserved Date
URAT mnUserReservedAmount Numeric 15 User Reserved Amount
URAB mnUserReservedNumber Numeric 8 User Reserved Number
URRF szUserReservedReference String 15 User Reserved Reference
OSFX szOriginalOrderSuffix String 3 Document Pay Item - Original
LITM