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

TABLE: GML.GML_GASNO_DETAIL_CHARGES

Object Details
Object Name: GML_GASNO_DETAIL_CHARGES
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.GML_GASNO_DETAIL_CHARGES
Subobject Name:
Status: VALID


GML_GASNO_DETAIL_CHARGES contains key charge data for a line that the shipment generated from to support the edi outbound transaction GASNO (OPM Outbound Advanced Ship Notice (856/DESADV)). The information in this table is based primarily on data stored in the OP_CHRG_MST and OP_ORDR_CHG tables of OPM Order Fulfillment.
All columns denoted with an "INT" represent Applications internal values. All columns with "EXT" represent the equivalent external values.
Each row in the GML_GASNO_DETAIL_CHARGES is purged after the data is written to the data file.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER

Run Id
LINE_ID NUMBER

Surrogate key for the line.
SAC_INDICATOR_INT VARCHAR2 (1)
Internal flag that indicates if the charge is billed to the customer.
SAC_INDICATOR_EXT1 VARCHAR2 (20)
External code 1 to indicate if the charge is billed to the customer.
SAC_INDICATOR_EXT2 VARCHAR2 (20)
External code 2 to indicate if the charge is billed to the customer.
SAC_INDICATOR_EXT3 VARCHAR2 (20)
External code 3 to indicate if the charge is billed to the customer.
SAC_INDICATOR_EXT4 VARCHAR2 (20)
External code 4 to indicate if the charge is billed to the customer.
SAC_INDICATOR_EXT5 VARCHAR2 (20)
External code 5 to indicate if the charge is billed to the customer.
SAC_CODE_INT VARCHAR2 (32)
Internal code that uniquely identifies a charge.
SAC_CODE_EXT1 VARCHAR2 (20)
External code 1 that uniquely identifies a charge.
SAC_CODE_EXT2 VARCHAR2 (20)
External code 2 that uniquely identifies a charge.
SAC_CODE_EXT3 VARCHAR2 (20)
External code 3 that uniquely identifies a charge.
SAC_CODE_EXT4 VARCHAR2 (20)
External code 4 that uniquely identifies a charge.
SAC_CODE_EXT5 VARCHAR2 (20)
External code 5 that uniquely identifies a charge.
SAC_METHOD_INT NUMBER

Internal code to grouping charges for reporting purposes. Values: 0 = miscellaneous; 1 = freight; 10 = taxes; 20 = discounts; 30 = allowances.
SAC_METHOD_CODE_EXT1 VARCHAR2 (20)
External code 1 to grouping charges.
SAC_METHOD_CODE_EXT2 VARCHAR2 (20)
External code 2 to grouping charges.
SAC_METHOD_CODE_EXT3 VARCHAR2 (20)
External code 3 to grouping charges.
SAC_METHOD_CODE_EXT4 VARCHAR2 (20)
External code 4 to grouping charges.
SAC_METHOD_CODE_EXT5 VARCHAR2 (20)
External code 5 to grouping charges.
CHARGE_LINE_AMOUNT NUMBER

Flat amount for a flat charge of the line.
CHARGE_RATE NUMBER

Rate or percentage for a percentage charge of the line. Valid values are 0 <= X <= 1.
CHARGE_UNIT_AMOUNT NUMBER

Amount of the charge on a per unit basis for the charge 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.
CHARGE_QTY NUMBER

Quantity from the line to which the per unit charge applies. Defaults from the total order qty. User may change the quantity.
SAC_DESCRIPTION VARCHAR2 (70)
Charge description.
TRANSACTION_RECORD_ID NUMBER

Unique identifier which links this table to its associated extension table GML_GASNO_DETAIL_CHARGES_X.
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
Query Text

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_GASNO_DETAIL_CHARGES;

Dependencies

[top of page]

GML.GML_GASNO_DETAIL_CHARGES does not reference any database object

GML.GML_GASNO_DETAIL_CHARGES is referenced by following:

SchemaGML
ViewGML_GASNO_DETAIL_CHARGES#