Table: PO_ACCEPTANCES
| Description: | Purchase order acceptances |
|---|
Primary Key: PO_ACCEPTANCES_PK
- ACCEPTANCE_ID
Foreign Keys from this table:
| Foreign Key Column | Foreign Table |
|---|---|
| PO_ACCEPTANCES.PO_HEADER_ID | PO_HEADERS_ALL |
| PO_ACCEPTANCES.PO_RELEASE_ID | PO_RELEASES_ALL |
| PO_ACCEPTANCES.PO_LINE_LOCATION_ID | PO_LINE_LOCATIONS_ALL |
Comments
PO_ACCEPTANCES contains information about purchase order acceptances
or follow-ups you receive from your suppliers. Each row in this table
corresponds to a specific revision of a purchase order or release you
sent to a supplier. You can define as many rows as you want in this
table for a revision of a purchase order or release.
.
Oracle Purchasing uses this table to store descriptive information
about the supplier acceptance or follow-up. Oracle Purchasing
determines
that a supplier accepted a purchase order or release if the value
ACCEPTED_FLAG is 'Y'.
.
You enter acceptances using the Acceptances window.
.
Indexes
| Index | Type | Tablespace | Column |
|---|---|---|---|
| PO_ACCEPTANCES_U1 | UNIQUE | APPS_TS_TX_IDX | ACCEPTANCE_ID |
| SYS_IL0000044861C00036$$ | UNIQUE | APPS_TS_TX_DATA | |
| PO_ACCEPTANCES_N1 | NONUNIQUE | APPS_TS_TX_IDX | PO_HEADER_ID |
| PO_ACCEPTANCES_N2 | NONUNIQUE | APPS_TS_TX_IDX | PO_RELEASE_ID |
| PO_ACCEPTANCES_N3 | NONUNIQUE | APPS_TS_TX_IDX | EMPLOYEE_ID |
| PO_ACCEPTANCES_N4 | NONUNIQUE | APPS_TS_TX_IDX | PO_LINE_LOCATION_ID REVISION_NUM |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCEPTANCE_ID | NUMBER | Y | Acceptance unique identifier | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| PO_HEADER_ID | NUMBER | Document header unique identifier | ||
| PO_RELEASE_ID | NUMBER | Release unique identifier | ||
| ACTION | VARCHAR2 | (240) | Description of the follow-up action performed with the supplier | |
| ACTION_DATE | DATE | Date of follow-up action | ||
| EMPLOYEE_ID | NUMBER | (9) | Employee unique identifier | |
| REVISION_NUM | NUMBER | Document revision number | ||
| ACCEPTED_FLAG | VARCHAR2 | (1) | Indicates whether the customer accepted the purchase order | |
| ACCEPTANCE_LOOKUP_CODE | VARCHAR2 | (25) | Type of acceptance | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| PO_LINE_LOCATION_ID | NUMBER | Line Location unique identifier | ||
| NOTE | CLOB | (4000) | Long description of the result of the follow-up action | |
| ACCEPTING_PARTY | VARCHAR2 | (1) | Indicates if the purchasing document is signed by the Buyer or Supplier. For the manual signatures Accepting party will always be Buyer. | |
| ROLE | VARCHAR2 | (240) | Role of the person who is signing the document. | |
| ERECORD_ID | NUMBER | Stores the Id of the eRecord if the signature is done electronically.This field references DOCUMENT_ID column of the EDR_PSIG_DOCUMENTS table. | ||
| SIGNATURE_FLAG | VARCHAR2 | (1) | Indicates if the acceptance is Signature or Not. | |
| DRAFT_ID | NUMBER | Draft Id | ||
| VENDOR_CONTACT_ID | NUMBER | Vendor contact id | ||
| VENDOR_CONTACT_NAME | VARCHAR2 | (240) | Name of the Vendor contact accepted and signed the document | |
| VENDOR_CONTACT_TITLE | VARCHAR2 | (240) | Title of the Vendor contact accepted and signed the document | |
| VENDOR_SIGNED_DATE | DATE | Date of signature by the vendor contact |
PO.PO_ACCEPTANCES does not reference any database object
