[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GPOAO_ORDER_CHARGES |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GPOAO_ORDER_CHARGES
|
| Subobject Name: | |
| Status: | VALID |
GML_GPOAO_ORDER_CHARGES contains sales order header charge data to support the OPM Outbound Purchase Order Acknowledgment (855/ORDRSP) EDI transaction.
This table is based primarily on data stored in the OP_ORDR_CHG and OP_CHRG_MST tables in OPM Order Fulfillment.
All columns denoted with an "INT" or "Internal" represent Oracle 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_GPOAO_ORDER_CHARGES is purged after the data is written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the GML_GPOAO_ORDER_CHARGES table to its corresponding extension table GML_GPOAO_ORDER_CHARGES_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RUN_ID | NUMBER | Transaction Run ID | ||
| ORDER_ID | NUMBER | Sales Order 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 order | ||
| CHARGE_RATE | NUMBER | Rate/percentage if the charge is a percentage of the order | ||
| CHARGE_UNIT_AMOUNT | NUMBER | Amount of the charge on a per unit basis if the charge is based on unit of the order. | ||
| CHARGE_UOM | VARCHAR2 | (4) | UOM for the charge if based on a per unit basis | |
| CHARGE_QTY | NUMBER | Quantity from the order 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
, ORDER_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_ORDER_CHARGES;
GML.GML_GPOAO_ORDER_CHARGES does not reference any database object
GML.GML_GPOAO_ORDER_CHARGES is referenced by following:
APPS
GML_GPOAO_ORDER_CHARGES
|
|
|
|