[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PWP_AP_INV_HDR |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_PWP_AP_INV_HDR
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PA_PWP_AP_HDR_ID | NUMBER | (15) | Yes | A unique sequence number |
| PROJECT_ID | NUMBER | (15) | Project Id | |
| INVOICE_ID | NUMBER | (15) | Vendor invoice Id | |
| INVOICE_NUM | VARCHAR2 | (50) | Vendor invoice number | |
| SUPPLIER_NUM | VARCHAR2 | (30) | Vendor number | |
| VENDOR_ID | NUMBER | (15) | Vendor Id | |
| SUPPLIER_NAME | VARCHAR2 | (240) | Vendor name | |
| SUPPLIER_SITE_CODE | VARCHAR2 | (15) | Vendor site code | |
| LINKED_DRAFT_INVOICE_NUM | VARCHAR2 | (2000) | Concatinated draft invoice number contains all the draft invoices mapped to this invoice | |
| LINKED_DRFAT_INV_TYPE | VARCHAR2 | (2000) | Concatinated draft invoice link type is used to identify whether the draft invoice is linked manually or automatically to the invoice | |
| INVOICE_DATE | DATE | Invoice date | ||
| INVOICE_AMOUNT | NUMBER | Invoice amount | ||
| INVOICE_CURRENCY | VARCHAR2 | (30) | Invoice currency | |
| HOLD_REASON | VARCHAR2 | (4000) | Concatinated hold reason | |
| PWP_HOLD_FLAG | VARCHAR2 | (1) | Pay when paid hold flag | |
| DLV_HOLD_FLAG | VARCHAR2 | (1) | Deliverable hold flag | |
| PAYMENT_STATUS | VARCHAR2 | (1) | Payment status(P-Partially Paid, Y-Fully Paid, N-Not Paid) | |
| RELHOLD_REJ_REASON | VARCHAR2 | (2000) | Release hold rejection reason | |
| PO_NUMBER | VARCHAR2 | (2000) | Concatinated PO numbers are the PO numbers matched to the invoice | |
| DESCRIPTION | VARCHAR2 | (4000) | This column stores the description of the Supplier Invoice | |
| EXCHANGE_RATE | NUMBER | This column stores the exchange rate of the Supplier Invoice | ||
| EXCHANGE_DATE | DATE | This column stores the exchange date of the Supplier Invoice | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (20) | This column stores the exchange rate type of the Supplier Invoice | |
| GL_DATE | DATE | This column stores the gl date of the Supplier Invoice | ||
| EARLIEST_PAY_DUE_DATE | DATE | This column stores the earliest payment due date of the Supplier Invoice. | ||
| INVOICE_TYPE | VARCHAR2 | (30) | This column stores the supplier invoice type. | |
| PREPAID_AMOUNT | NUMBER | This column stores the pre-payment amount of the Supplier Invoice | ||
| HOLD_APPLIED_YN | VARCHAR2 | (1) | ||
| HOLD_FLAG | VARCHAR2 | (1) | Hold Flag |
Cut, paste (and edit) the following text to query this object:
SELECT PA_PWP_AP_HDR_ID
, PROJECT_ID
, INVOICE_ID
, INVOICE_NUM
, SUPPLIER_NUM
, VENDOR_ID
, SUPPLIER_NAME
, SUPPLIER_SITE_CODE
, LINKED_DRAFT_INVOICE_NUM
, LINKED_DRFAT_INV_TYPE
, INVOICE_DATE
, INVOICE_AMOUNT
, INVOICE_CURRENCY
, HOLD_REASON
, PWP_HOLD_FLAG
, DLV_HOLD_FLAG
, PAYMENT_STATUS
, RELHOLD_REJ_REASON
, PO_NUMBER
, DESCRIPTION
, EXCHANGE_RATE
, EXCHANGE_DATE
, EXCHANGE_RATE_TYPE
, GL_DATE
, EARLIEST_PAY_DUE_DATE
, INVOICE_TYPE
, PREPAID_AMOUNT
, HOLD_APPLIED_YN
, HOLD_FLAG
FROM PA.PA_PWP_AP_INV_HDR;
PA.PA_PWP_AP_INV_HDR does not reference any database object
PA.PA_PWP_AP_INV_HDR is referenced by following:
PA
PA_PWP_AP_INV_HDR#
|
|
|
|