AP_DISTRIBUTION_SETS_ALL
AP_DISTRIBUTION_SETS_ALL contains information about Distribution Sets you define to distribute invoices automatically. You need one row for each Distribution Set you use in your Oracle Payables application. When you enter an invoice, you can select a Distribution Set that you define in this table. When you select a Distribution Set for an invoice, your Oracle Payables application automatically creates invoice distribution lines according to the lines you define for the Distribution Set you select. A Distribution Set must have one or more Distribution Set lines. . This table corresponds to the Distribution Sets window.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_DISTRIBUTION_SETS_PK |
DISTRIBUTION_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| DISTRIBUTION_SET_ID | NUMBER | 18 | Yes | Invoice Distribution Set identifier | ||
| DISTRIBUTION_SET_NAME | VARCHAR2 | 50 | Yes | Name of invoice distribution set created. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| DESCRIPTION | VARCHAR2 | 240 | Description of invoice distribution set created. | |||
| TOTAL_PERCENT_DISTRIBUTION | NUMBER | 19 | Sum of distribution percents of each of the Distribution Set lines | |||
| INACTIVE_DATE | DATE | Date by when the distribution set will become inactive. | ||||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Distribution Sets (AP_DISTRIBUTION_SETS) | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| poz_site_assignments_all_m | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
| ap_invoice_lines_all | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
| ap_invoice_lines_interface | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
| ap_distribution_set_lines_all | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
| ap_invoices_all | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AP_DISTRIBUTION_SETS_U1 | Unique | DISTRIBUTION_SET_ID |
| AP_DISTRIBUTION_SETS_U2 | Unique | DISTRIBUTION_SET_NAME, ORG_ID |