[Home] [Help] [Dependency Information]

TABLE: JE.JE_PT_JEPTVATR

Object Details

Object Name:	JE_PT_JEPTVATR
Object Type:	TABLE
Owner:	JE
FND Design Data:	JE.JE_PT_JEPTVATR
Subobject Name:
Status:	VALID

JE_PT_JEPTVATR contains information for Portuguese Payables and Receivables VAT
Recapitulative reporting. Oracle Payables and Oracle Receivables delete records from previous
processing before inserting new ones into this table, and then create a formatted output file from the stored information when you run the Portuguese Suppliers Recapitulative Extract File program or the Portuguese Customers Recapitulative Extract File program. There are one header record, one trailer record, and multiple detail records. The SEQUENCE_NUM column holds the numbering sequence for the records. The header record has the number "0" and the trailer record has the
number "999999". Detail records are numbered from "1" to "999998". The FI_NUM column holds the taxpayer identification number. Forheader and trailer records, this column holds the reporting
entity's taxpayer identification number. For detail records, FI_NUM
is the customer taxpayer identification number in Oracle
Receivables and the supplier taxpayer identification number in Oracle
Payables. The NET_INV_AMOUNTS column is null in the header record. For detail
records, this column is the sum of ACCTD_AMOUNT from
the RA_CUST_TRX_LINE_GL_DIST table in Oracle Receivables. This column is the sum of BASE_AMOUNT (AMOUNT if the BASE_AMOUNT is null) from the AP_INVOICE_DISTRIBUTIONS
table in Oracle Payables. NET_INV_AMOUNTS for the trailer
record is the sum of NET_INV_AMOUNTS in the detail records.
The COUNT column is null in the header record and detail records. For
the trailer record, COUNT is the total number of detail records.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT SEQUENCE_NUM
,      FI_NUM
,      NET_INV_AMOUNTS
,      COUNT
FROM JE.JE_PT_JEPTVATR;

Dependencies

[top of page]

JE.JE_PT_JEPTVATR does not reference any database object

JE.JE_PT_JEPTVATR is referenced by following:

APPS

JE_PT_JEPTVATR