DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_PWP_AP_INV_HDR

Object Details
Object Name: PA_PWP_AP_INV_HDR
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

PA.PA_PWP_AP_INV_HDR does not reference any database object

PA.PA_PWP_AP_INV_HDR is referenced by following:

SchemaAPPS
SynonymPA_PWP_AP_INV_HDR