Interface Table (Customer)


	Previous	Next		Contents	Index	Glossary	Library

Interface Table (Customer)

The RA_CUSTOMERS_INTERFACE interface table stores customer information. You use SQL*Loader to load customer information into the interface table. When you initiate importing customer information, the Customer open interface validates global attribute columns in the RA_CUSTOMERS_INTERFACE table before creating customer and customer addresses in Oracle Receivables.

This section describes the columns in the RA_CUSTOMERS_INTERFACE interface table for Oracle Financials for Brazil and shows where the values are stored.

In this column
Oracle Receivables stores
For this location
GLOBAL_ATTRIBUTE1
Inscription type (CPF, CGC, other). This value is mandatory.
RA_ADDRESSES.GLOBAL_
ATTRIBUTE2
GLOBAL_ATTRIBUTE2
Inscription number. This value is mandatory if the inscription type is CGC or CPF.
The inscription number and inscription subsidiary are validated against the inscription digit with a standard algorithm.
RA_ADDRESSES.GLOBAL_
ATTRIBUTE3
GLOBAL_ATTRIBUTE3
Inscription subsidiary. This value is mandatory if the inscription type is CGC or CPF.
The inscription number and inscription subsidiary are validated against the inscription digit with a standard algorithm. If the inscription type is CPF, the inscription subsidiary must be 0000.
RA_ADDRESSES.GLOBAL_
ATTRIBUTE4
GLOBAL_ATTRIBUTE4
Inscription digit. This value is mandatory if the inscription type is CGC or CPF. The inscription number and inscription subsidiary are validated against the inscription digit with a standard algorithm.
RA_ADDRESSES.GLOBAL_
ATTRIBUTE5
GLOBAL_ATTRIBUTE5
State inscription
RA_ADDRESSES.GLOBAL_
ATTRIBUTE6
GLOBAL_ATTRIBUTE6
Municipal inscription
RA_ADDRESSES.GLOBAL_
ATTRIBUTE7
GLOBAL_ATTRIBUTE7
Contributor type. This value is mandatory. This value must exist in the JL_BR_LOOKUP_CODES.
LOOKUP_CODE table and LOOKUP_TYPE = “CONTRIBUTOR_TYPE.”
The current date is the active date.
RA_ADDRESSES.GLOBAL_
ATTRIBUTE8

Contents

Index

Glossary

Library

In this column	Oracle Receivables stores	For this location
GLOBAL_ATTRIBUTE1	Inscription type (CPF, CGC, other). This value is mandatory.	RA_ADDRESSES.GLOBAL_ ATTRIBUTE2
GLOBAL_ATTRIBUTE2	Inscription number. This value is mandatory if the inscription type is CGC or CPF. The inscription number and inscription subsidiary are validated against the inscription digit with a standard algorithm.	RA_ADDRESSES.GLOBAL_ ATTRIBUTE3
GLOBAL_ATTRIBUTE3	Inscription subsidiary. This value is mandatory if the inscription type is CGC or CPF. The inscription number and inscription subsidiary are validated against the inscription digit with a standard algorithm. If the inscription type is CPF, the inscription subsidiary must be 0000.	RA_ADDRESSES.GLOBAL_ ATTRIBUTE4
GLOBAL_ATTRIBUTE4	Inscription digit. This value is mandatory if the inscription type is CGC or CPF. The inscription number and inscription subsidiary are validated against the inscription digit with a standard algorithm.	RA_ADDRESSES.GLOBAL_ ATTRIBUTE5
GLOBAL_ATTRIBUTE5	State inscription	RA_ADDRESSES.GLOBAL_ ATTRIBUTE6
GLOBAL_ATTRIBUTE6	Municipal inscription	RA_ADDRESSES.GLOBAL_ ATTRIBUTE7
GLOBAL_ATTRIBUTE7	Contributor type. This value is mandatory. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table and LOOKUP_TYPE = “CONTRIBUTOR_TYPE.” The current date is the active date.	RA_ADDRESSES.GLOBAL_ ATTRIBUTE8