[Home] [Help] [Dependency Information]
Object Name: | PA_PWP_AP_INV_HDR |
---|---|
Object Type: | TABLE |
Owner: | PA |
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 |
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
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:
|
|
|