[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GPOAO_DETAIL_CHARGES |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GPOAO_DETAIL_CHARGES
|
| Subobject Name: | |
| Status: | VALID |
GML_GPOAO_DETAIL_CHARGES contains order line detail charges to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP)).
This table is based primarily on data stored in the OP_ORDR_CHG and OP_CHRG_MST tables of OPM Order Fulfillment.
All columns denoted with an "INT" or "INTERNAL" represent Applications internal values. All columns with "EXT" or "External" represent the equivalent external values sourced from the ECE_XREF_DATA table if code conversion is enabled for the column.
Each row in the GML_GPOA_DETAIL_CHARGES is purged after the data is written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the GML_GPOAO_DETAIL_CHARGES table to its corresponding extension table GML_GPOAO_DETAIL_CHARGES_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RUN_ID | NUMBER | Transaction Run ID | ||
| LINE_ID | NUMBER | Line Id | ||
| SAC_INDICATOR_INT | VARCHAR2 | (1) | Charge Billable Indicator (Int) | |
| SAC_INDICATOR_EXT1 | VARCHAR2 | (20) | Charge Billable Indicator (Ext1) | |
| SAC_INDICATOR_EXT2 | VARCHAR2 | (20) | Charge Billable Indicator (Ext2) | |
| SAC_INDICATOR_EXT3 | VARCHAR2 | (20) | Charge Billable Indicator (Ext3) | |
| SAC_INDICATOR_EXT4 | VARCHAR2 | (20) | Charge Billable Indicator (Ext4) | |
| SAC_INDICATOR_EXT5 | VARCHAR2 | (20) | Charge Billable Indicator (Ext5) | |
| SAC_CODE_INT | VARCHAR2 | (32) | Charge Code (Int) | |
| SAC_CODE_EXT1 | VARCHAR2 | (20) | Charge Code (Ext1) | |
| SAC_CODE_EXT2 | VARCHAR2 | (20) | Charge Code (Ext2) | |
| SAC_CODE_EXT3 | VARCHAR2 | (20) | Charge Code (Ext3) | |
| SAC_CODE_EXT4 | VARCHAR2 | (20) | Charge Code (Ext4) | |
| SAC_CODE_EXT5 | VARCHAR2 | (20) | Charge Code (Ext5) | |
| SAC_METHOD_INT | NUMBER | Charge Type (Int) | ||
| SAC_METHOD_CODE_EXT1 | VARCHAR2 | (20) | Charge Type (Ext1) | |
| SAC_METHOD_CODE_EXT2 | VARCHAR2 | (20) | Charge Type (Ext2) | |
| SAC_METHOD_CODE_EXT3 | VARCHAR2 | (20) | Charge Type (Ext3) | |
| SAC_METHOD_CODE_EXT4 | VARCHAR2 | (20) | Charge Type (Ext4) | |
| SAC_METHOD_CODE_EXT5 | VARCHAR2 | (20) | Charge Type (Ext5) | |
| CHARGE_LINE_AMOUNT | NUMBER | Flat charge if the charge is a flat amount of the detail line | ||
| CHARGE_RATE | NUMBER | Rate/percentage if the charge is a percentage of the detail line | ||
| CHARGE_UNIT_AMOUNT | NUMBER | Amount of the charge on a per unit basis if the charge is based on unit of the detail line | ||
| CHARGE_UOM | VARCHAR2 | (4) | UOM for the charge if based on a per unit basis | |
| CHARGE_QTY | NUMBER | Quantity from the detail line for per unit charges | ||
| SAC_DESCRIPTION | VARCHAR2 | (70) | Charge Description | |
| TRANSACTION_RECORD_ID | NUMBER | Transaction Record ID | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| REQUEST_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_UPDATE_DATE | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT RUN_ID
, LINE_ID
, SAC_INDICATOR_INT
, SAC_INDICATOR_EXT1
, SAC_INDICATOR_EXT2
, SAC_INDICATOR_EXT3
, SAC_INDICATOR_EXT4
, SAC_INDICATOR_EXT5
, SAC_CODE_INT
, SAC_CODE_EXT1
, SAC_CODE_EXT2
, SAC_CODE_EXT3
, SAC_CODE_EXT4
, SAC_CODE_EXT5
, SAC_METHOD_INT
, SAC_METHOD_CODE_EXT1
, SAC_METHOD_CODE_EXT2
, SAC_METHOD_CODE_EXT3
, SAC_METHOD_CODE_EXT4
, SAC_METHOD_CODE_EXT5
, CHARGE_LINE_AMOUNT
, CHARGE_RATE
, CHARGE_UNIT_AMOUNT
, CHARGE_UOM
, CHARGE_QTY
, SAC_DESCRIPTION
, TRANSACTION_RECORD_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM GML.GML_GPOAO_DETAIL_CHARGES;
GML.GML_GPOAO_DETAIL_CHARGES does not reference any database object
GML.GML_GPOAO_DETAIL_CHARGES is referenced by following:
GML
GML_GPOAO_DETAIL_CHARGES#
|
|
|
|