[Home] [Help] [Dependency Information]
Object Name: | OP_INVC_CHG |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.OP_INVC_CHG |
Subobject Name: | |
Status: | VALID |
This table contains tax details for an order line. Tax calculated for an order using the OPM Tax applications is maintained in this table. The tax lines are initially inserted during tax computation in order entry and then updated/added upon shipment.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OP_INVC_CHG_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | LINECHARGE_ID |
OP_INVC_CHG_UK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INVOICE_ID
LINE_ID CHARGE_ID TAXAUTH_ID LINECHARGE_ID |
OP_INVC_CHG_I1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LINE_ID
TAXAUTH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHARGE_LINE_ID | NUMBER | (10) | Reference to charge line for which tax has been calculated; fk to op_ordr_chg | |
LINE_ID | NUMBER | (10) | Yes | In op_order_dtl. |
TAXABLE_AMOUNT | NUMBER | Yes | Amount of invoice to which tax rate was applied. | |
TAXRATE_ID | NUMBER | (10) | Yes | In tx_taxa_dtl or NULL if record is not for taxes. |
CHARGE_TYPE | NUMBER | (5) | Yes | 10=tax. |
INVOICE_ID | NUMBER | (10) | In opinvc_mst. May be NULL if taxes saved in order entry. | |
PLANNED_AMOUNT | NUMBER | Yes | Initial amount recorded/calculated. | |
ACTUAL_AMOUNT | NUMBER | Yes | Actual amount billed. | |
CHARGE_RATE | NUMBER | Yes | Rate for charge amount, tax rate, or 0. | |
TAX_STATUS | VARCHAR2 | (4) | Yes | In tx_taxa_sts. NULL if record is not for taxes. |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TRANS_CNT | NUMBER | (10) | Not currently used | |
CHARGE_LINE_AMOUNT | NUMBER | Flat charge amount for the line, or order, if the charge is a flat amount. | ||
CHARGE_UNIT_AMOUNT | NUMBER | Amount of the charge on a per unit basis, if the charge is assessed in that manner. Must be entered along with the charge_uom. | ||
CHARGE_UOM | VARCHAR2 | (4) | Unit of measure corresponding to the charge_qty and charge_unit_amount for per-unit charges. Fk to sy_uoms_mst. | |
BILLABLE_IND | NUMBER | (5) | Indicates if the charge is billed to the customer. Defaults from op_chrg_mst and can be changed by user. | |
CHARGE_ID | NUMBER | (10) | In op_chrg_mst or NULL if record is for taxes. | |
TAXAUTH_ID | NUMBER | (10) | Yes | In tx_taxa_mst. NULL if record is not for taxes. |
LINECHARGE_ID | NUMBER | (10) | Yes | Surrogate id. |
Cut, paste (and edit) the following text to query this object:
SELECT CHARGE_LINE_ID
, LINE_ID
, TAXABLE_AMOUNT
, TAXRATE_ID
, CHARGE_TYPE
, INVOICE_ID
, PLANNED_AMOUNT
, ACTUAL_AMOUNT
, CHARGE_RATE
, TAX_STATUS
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELETE_MARK
, TRANS_CNT
, CHARGE_LINE_AMOUNT
, CHARGE_UNIT_AMOUNT
, CHARGE_UOM
, BILLABLE_IND
, CHARGE_ID
, TAXAUTH_ID
, LINECHARGE_ID
FROM GML.OP_INVC_CHG;
GML.OP_INVC_CHG does not reference any database object
GML.OP_INVC_CHG is referenced by following:
|
|
|