D-14 Oracle Telecommunications Billing Integrator Implementation Guide
PARENT_RELATIO
NSHIP_TYPE
RELATIONSHIP_INF
O
HZ_RELATIONSHIP
S.
RELATIONSHIP_CO
DE
Either a forward or a
backward
relationship code
DATETIME RELATIONSHIP_INF
O
HZ_RELATIONSHIP
S.END_DATE
Date relationship
ends
CUSTOMER_CONT
ACT_INFO
CUSTOMER_INFO Customer Contact
Information
-
CONTACT_POINT_I
D
CUSTOMER_CONT
ACT
_INFO
HZ_CONTACT_POI
NTS.CONTACT_POI
NT_TYPE
Identifier for the
customer contact
point.
CONTACT_POINT_T
YPE
CUSTOMER_CONT
ACT
_INFO
HZ_CONTACT_POI
NTS.CONTACT_POI
NT_TYPE
Lookup:
CONTACT_POINT_T
YPE of phone, fax,
e-mail, web, telex, or
EDI
PRIMARY CUSTOMER_CONT
ACT
_INFO
HZ_CONTACT_POI
NTS.PRIMARY_FLA
G
Flag to Identify the
Primary Contact
Information.
EDI_TRANSACTION
_HANDLING
CUSTOMER_CONT
ACT
_INFO
HZ_CONTACT_POI
NTS.EDI_TRANSAC
TION_HANDLING
ANSI standard code
for EDI transaction
type
EDI_ID_NUMBER CUSTOMER_CONT
ACT
_INFO
HZ_CONTACT_POI
NTS.EDI_ID_NUMBE
R
EDI trading partner
number for the
supplier site
EDI_PAYMENT_ME
THOD
CUSTOMER_CONT
ACT
_INFO
HZ_CONTACT_POI
NTS.EDI_PAYMENT
_METHOD
Indicates how a
payment is to be
made through EDI.
Valid methods are
ACH and BOP.