INV_CST_SALES_CREDITS_GT
This table holds the sales credits data returned by getOrderDetails service.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | References the application which holds the inventory details. The value FUSION indicates Fusion Applications. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | External system reference idenfier | |
| INV_TRANSACTION_ID | NUMBER | 18 | Yes | Inventory transaction identifier | |
| HEADER_ID | NUMBER | 18 | Yes | Header identifier | |
| LINE_ID | NUMBER | 18 | Line identifier | ||
| SALES_PERSON_ID | NUMBER | 18 | Yes | Sales person identifier | |
| CREDIT_PERCENTAGE | NUMBER | Yes | This column is credit percentage. |