Interface Table (Invoice Import)


	Previous	Next		Contents	Index	Glossary	Library

Interface Table (Invoice Import)

The JL_BR_AP_EXP_REP_HEAD_EXT_ALL interface table stores invoice information. You use SQL*Loader to load invoice information into the interface table for each invoice that you create. When you initiate importing invoices, the Invoice Import open interface validates all required invoice data in this table. After the open interface validates the information, the open interface creates invoices from the information in the AP_EXPENSE_REPORT_HEADERS_ALL table and invoice distributions lines from the information in the AP_EXPENSE_REPORTS_LINES_ALL table.

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

In this column
Oracle Payables stores
For this location
REPORT_HEADER_ID
Expense report header identifier
AP_INVOICES_ALL
ORG_ID
The organization identifier. This value must exist in the HR_OPERATING_UNITS.
ORGANIZATION_ID table.
ORG_ID
INTEREST_TYPE
Interest type (rate, amount). If the validation fails, this field is set to null.
AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE1
INTEREST_RATE_
AMOUNT
The interest rate or amount depending on the interest type:
If the interest type is R (rate), this value must be between 0 and 100.
If the interest type is A (amount), this value must be at least zero.
If the validation fails, this field is null.
AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE2
PERIOD_DAYS
Period in days to calculate interest. If the interest type is not null, this value must be at least zero. If the validation fails, this field is set to null.
AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE3
INTEREST_FORMULA
Interest formula (simple, compound). If the interest formula is not null, this value must exist in the FND_LOOKUP_VALUES. LOOKUP_CODE table, where LOOKUP_TYPE = “JLBR_INTEREST_FORMULA,” and the current date is the active date. If the validation fails, this field is set to null.
AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE4
GRACE_DAYS
Grace days. This value must be at least zero.
AP_PAYMENT_SCHEDULES. GLOBAL_ATTRIBUTE5
PENALTY_TYPE
Penalty type (rate, amount). If the penalty type is not null, this value must exist in the FND_LOOKUP_VALUES. LOOKUP_CODE table, where LOOKUP_TYPE = “JLBR_INTEREST_PENALTY_TYPE,” and the current date is the active date.
AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE6
PENALTY_RATE_
AMOUNT
Penalty rate or amount depending on the penalty type. If the penalty type is R (rate), then this value must be between 0 and 100. If the penalty type is A (amount), this value must be at least zero.
AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE7
CFO_CODE
Operation Fiscal Code identifier. This value must exist in the JL_BR_AP_OPERATIONS.CFO_CODE table, or the field is set to null.
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE2
SERIES
Invoice series. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table, where LOOKUP_TYPE = “INVOICE SERIES,” or the field is set to null.
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE3
CLASS
Invoice class. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table, where LOOKUP_TYPE = “INVOICE CLASS,” or the field is set to null.
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE4
ICMS_BASE_AMOUNT
ICMS base amount
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE5
ICMS_TAX_NAME
ICMS tax name. This value must exist in the AP_TAX_CODES.NAME table, or this field, ICMS_BASE_AMOUNT, and ICMS_TAX_AMOUNT are set to null.
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE6
ICMS_TAX_AMOUNT
ICMS tax amount. The tax rate is applied to the base amount.
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE7
IPI_TAX_AMOUNT
IPI tax amount. If this value is not null, it must be greater than zero.
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE8
WHT_TAX_AMOUNT
Withholding base amount. If this value is not null, it must be greater than zero.
AP_INVOICES_ALL.
GLOBAL_ATTRIBUTE9
LAST_UPDATE_DATE
Standard who column. This value must be in valid date format.
None
LAST_UPDATED_BY
Standard who column
None
CREATION_DATE
Standard who column. This value must be in valid date format.
None
CREATED_BY
Standard who column
None
LAST_UPDATE_LOGIN
Standard who column
None

Contents

Index

Glossary

Library

In this column	Oracle Payables stores	For this location
REPORT_HEADER_ID	Expense report header identifier	AP_INVOICES_ALL
ORG_ID	The organization identifier. This value must exist in the HR_OPERATING_UNITS. ORGANIZATION_ID table.	ORG_ID
INTEREST_TYPE	Interest type (rate, amount). If the validation fails, this field is set to null.	AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE1
INTEREST_RATE_ AMOUNT	The interest rate or amount depending on the interest type: If the interest type is R (rate), this value must be between 0 and 100. If the interest type is A (amount), this value must be at least zero. If the validation fails, this field is null.	AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE2
PERIOD_DAYS	Period in days to calculate interest. If the interest type is not null, this value must be at least zero. If the validation fails, this field is set to null.	AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE3
INTEREST_FORMULA	Interest formula (simple, compound). If the interest formula is not null, this value must exist in the FND_LOOKUP_VALUES. LOOKUP_CODE table, where LOOKUP_TYPE = “JLBR_INTEREST_FORMULA,” and the current date is the active date. If the validation fails, this field is set to null.	AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE4
GRACE_DAYS	Grace days. This value must be at least zero.	AP_PAYMENT_SCHEDULES. GLOBAL_ATTRIBUTE5
PENALTY_TYPE	Penalty type (rate, amount). If the penalty type is not null, this value must exist in the FND_LOOKUP_VALUES. LOOKUP_CODE table, where LOOKUP_TYPE = “JLBR_INTEREST_PENALTY_TYPE,” and the current date is the active date.	AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE6
PENALTY_RATE_ AMOUNT	Penalty rate or amount depending on the penalty type. If the penalty type is R (rate), then this value must be between 0 and 100. If the penalty type is A (amount), this value must be at least zero.	AP_PAYMENT_SCHEDULES.GLOBAL_ATTRIBUTE7
CFO_CODE	Operation Fiscal Code identifier. This value must exist in the JL_BR_AP_OPERATIONS.CFO_CODE table, or the field is set to null.	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE2
SERIES	Invoice series. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table, where LOOKUP_TYPE = “INVOICE SERIES,” or the field is set to null.	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE3
CLASS	Invoice class. This value must exist in the JL_BR_LOOKUP_CODES. LOOKUP_CODE table, where LOOKUP_TYPE = “INVOICE CLASS,” or the field is set to null.	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE4
ICMS_BASE_AMOUNT	ICMS base amount	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE5
ICMS_TAX_NAME	ICMS tax name. This value must exist in the AP_TAX_CODES.NAME table, or this field, ICMS_BASE_AMOUNT, and ICMS_TAX_AMOUNT are set to null.	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE6
ICMS_TAX_AMOUNT	ICMS tax amount. The tax rate is applied to the base amount.	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE7
IPI_TAX_AMOUNT	IPI tax amount. If this value is not null, it must be greater than zero.	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE8
WHT_TAX_AMOUNT	Withholding base amount. If this value is not null, it must be greater than zero.	AP_INVOICES_ALL. GLOBAL_ATTRIBUTE9
LAST_UPDATE_DATE	Standard who column. This value must be in valid date format.	None
LAST_UPDATED_BY	Standard who column	None
CREATION_DATE	Standard who column. This value must be in valid date format.	None
CREATED_BY	Standard who column	None
LAST_UPDATE_LOGIN	Standard who column	None