Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: JL.JL_BR_AR_COMP_INV_ALL

Object Details
Object Name: JL_BR_AR_COMP_INV_ALL
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_BR_AR_COMP_INV_ALL
Subobject Name:
Status: VALID


JL_BR_AR_COMP_INV_ALL stores Billing complementary invoices. Billing complementary invoices are created and printed to correct mistakes in a previous invoice. You can correct tax rate, tax amount, unit and total amounts, and so on.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_AR_COMP_INV_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMP_INVOICE_ID
Columns
Name Datatype Length Mandatory Comments
COMP_INVOICE_ID NUMBER (15) Yes Complementary invoice identifier
CUSTOMER_TRX_ID NUMBER (15) Yes Customer Transaction identifier
TRX_NUMBER VARCHAR2 (20)
Transaction Number
QUANTITY_LINE NUMBER

Changed Quantity of Line
UNIT_AMOUNT_LINE NUMBER

Changed Unit Amount of Line
TOTAL_AMOUNT_LINE NUMBER

Changed Total Amount of Line
IPI_RATE NUMBER

Changed IPI Tax Rate
ICMS_RATE NUMBER

Changed ICMS Tax Rate
ICMS_ST_RATE NUMBER

Changed ICMS_ST Tax Rate
IR_RATE NUMBER

Changed IR Tax Rate
ISS_RATE NUMBER

Changed ISS Tax Rate
IPI_AMOUNT_LINE NUMBER

Changed IPI Tax Line Amount
IPI_TOTAL_AMOUNT NUMBER

Changed IPI Tax Total Amount
ICMS_TOTAL_AMOUNT NUMBER

Changed ICMS Tax Total Amount
ICMS_ST_TOTAL_AMOUNT NUMBER

Changed ICMS_ST Tax Total Amount
IR_TOTAL_AMOUNT NUMBER

Changed IR Tax Total Amount
ISS_TOTAL_AMOUNT NUMBER

Changed ISS Tax Total Amount
IPI_BASE_AMOUNT NUMBER

Changed IPI Tax Base Amount
ICMS_BASE_AMOUNT NUMBER

Changed ICMS Tax Base Amount
ICMS_ST_BASE_AMOUNT NUMBER

Changed ICMS_ST Tax Base Amount
IR_BASE_AMOUNT NUMBER

Changed IR Tax Base Amount
ISS_BASE_AMOUNT NUMBER

Changed ISS Tax Base Amount
FREIGHT_AMOUNT NUMBER

Changed Freight Expense Amount
INSURANCE_AMOUNT NUMBER

Changed Insurance Expense Amount
OTHER_EXPENSES_AMOUNT NUMBER

Changed Other Expense Amount
PRODUCT_TOTAL_AMOUNT NUMBER

Changed Product Total Amount
INVOICE_TOTAL_AMOUNT NUMBER

Changed Invoice Total Amount
PRINTING_COUNT NUMBER

This column shows the number of times this invoice has been printed. NULL means this invoice was not printed.
ISSUE_DATE DATE

Issue date of complementary invoice
CUSTOMER_TRX_LINE_ID NUMBER

Invoice line identifier
ORG_ID NUMBER (15)
Operating unit identifier
COMMENTS VARCHAR2 (240)
Comments
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT COMP_INVOICE_ID
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      QUANTITY_LINE
,      UNIT_AMOUNT_LINE
,      TOTAL_AMOUNT_LINE
,      IPI_RATE
,      ICMS_RATE
,      ICMS_ST_RATE
,      IR_RATE
,      ISS_RATE
,      IPI_AMOUNT_LINE
,      IPI_TOTAL_AMOUNT
,      ICMS_TOTAL_AMOUNT
,      ICMS_ST_TOTAL_AMOUNT
,      IR_TOTAL_AMOUNT
,      ISS_TOTAL_AMOUNT
,      IPI_BASE_AMOUNT
,      ICMS_BASE_AMOUNT
,      ICMS_ST_BASE_AMOUNT
,      IR_BASE_AMOUNT
,      ISS_BASE_AMOUNT
,      FREIGHT_AMOUNT
,      INSURANCE_AMOUNT
,      OTHER_EXPENSES_AMOUNT
,      PRODUCT_TOTAL_AMOUNT
,      INVOICE_TOTAL_AMOUNT
,      PRINTING_COUNT
,      ISSUE_DATE
,      CUSTOMER_TRX_LINE_ID
,      ORG_ID
,      COMMENTS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      LEGAL_MESSAGE_1
,      LEGAL_MESSAGE_2
,      LEGAL_MESSAGE_3
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM JL.JL_BR_AR_COMP_INV_ALL;

Dependencies

[top of page]

JL.JL_BR_AR_COMP_INV_ALL does not reference any database object

JL.JL_BR_AR_COMP_INV_ALL is referenced by following:

SchemaJL
ViewJL_BR_AR_COMP_INV_ALL#