eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_DRAFT_INVOICES_ALL

Object Details

Object Name:	PA_DRAFT_INVOICES_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_DRAFT_INVOICES_ALL
Subobject Name:
Status:	VALID

PA_DRAFT_INVOICES_ALL stores the draft invoices generated
for a project.
.
The transfer status of a draft invoice is maintained as follows:
.
Generate Invoice - Create invoice; set to Pending (P)
.
Transfer Invoice - If successfully transferred to AR, set to
Transferred (T); Else rejected in transfer to AR, set to Rejected in
Transfer (X)
.
Tieback Invoice - If successfully tied back from AR, set to Accepted
(A). Else rejected by AR, set to Rejected (R) to be re-transferred
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_DRAFT_INVOICES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID DRAFT_INVOICE_NUM
PA_DRAFT_INVOICES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AGREEMENT_ID
PA_DRAFT_INVOICES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UER_SUMMARY_ID
PA_DRAFT_INVOICES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PJI_SUMMARIZED_FLAG
PA_DRAFT_INVOICES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
PA_DRAFT_INVOICES_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_TO_CUSTOMER_ID BILL_TO_ADDRESS_ID
PA_DRAFT_INVOICES_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_CUSTOMER_ID SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_STATUS_CODE
PA_DRAFT_INVOICES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPROVED_BY_PERSON_ID
PA_DRAFT_INVOICES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELEASED_BY_PERSON_ID
PA_DRAFT_INVOICES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID REQUEST_ID
PA_DRAFT_INVOICES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID GENERATION_ERROR_FLAG
PA_DRAFT_INVOICES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RA_INVOICE_NUMBER
PA_DRAFT_INVOICES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UBR_UER_PROCESS_FLAG
PA_DRAFT_INVOICES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UBR_SUMMARY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the invoice is generated
DRAFT_INVOICE_NUM	NUMBER	(15)	Yes	The sequential number that identifies the draft invoice within a project
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
TRANSFER_STATUS_CODE	VARCHAR2	(1)	Yes	The status of the invoice as it is transferred to Oracle Receivables
GENERATION_ERROR_FLAG	VARCHAR2	(1)	Yes	Flag that indicates that an error was encountered during the Generate Draft Invoices program that caused the draft invoice to not be successfully generated
AGREEMENT_ID	NUMBER	(15)	Yes	The identifier of the agreement that funds the invoice
PA_DATE	DATE			The end date of the PA period in which the invoice was generated. The PA period is the open or future PA period on or after the latest date of the expenditure item dates and the event completion dates included on the invoice.
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
CUSTOMER_BILL_SPLIT	NUMBER	(7)		The percentage of the total project invoice amount that the customer is billed on the draft invoice
BILL_THROUGH_DATE	DATE			The date through which to invoice the project. Expenditure items with the expenditure item date on or before the bill through date and events with completion dates on or before the bill through date may be included on an invoice.
INVOICE_COMMENT	VARCHAR2	(240)		Free text comments that can be printed on an invoice. The invoice comment is defaulted from the invoice comment defined for the project. This value can be overridden by a user for each draft invoice
APPROVED_DATE	DATE			The date on which the draft invoice is approved
APPROVED_BY_PERSON_ID	NUMBER	(9)		The identifier of the employee that approved the invoice
RELEASED_DATE	DATE			The date that the draft invoice was released for transfer
RELEASED_BY_PERSON_ID	NUMBER	(9)		The identifier of the employee that released the invoice
INVOICE_DATE	DATE			The invoice date passed to Oracle Receivables which is used to calculate the invoice due date. Upon release of the invoice, this date is defaulted from the released date. The user can override the invoice date at the time of release
RA_INVOICE_NUMBER	VARCHAR2	(20)		The Oracle Receivables invoice number that is determined upon release of the draft invoice and passed to Oracle Receivables upon transfer. This number can be user-entered or system-generated as defined in the implementation options.
TRANSFERRED_DATE	DATE			The date that the draft invoice was transferred to the Oracle Receivables interface tables
TRANSFER_REJECTION_REASON	VARCHAR2	(250)		The reason why the draft invoice was rejected by the Transfer Invoice program or rejected by Oracle Receivables AutoInvoice interface program
UNEARNED_REVENUE_CR	NUMBER	(22)		The amount of unearned revenue credited by the draft invoice. This amount is determined by the Transfer Invoice program
UNBILLED_RECEIVABLE_DR	NUMBER	(22)		The amount of unbilled receivables debited by the draft invoice. This amount is determined by the Transfer Invoice program
GL_DATE	DATE			The date within a GL accounting period to which the invoice transactions are posted. The GL date is set by the Transfer Invoice program and is the date of the first future or open GL period in Oracle Receivables of the invoice date.
SYSTEM_REFERENCE	NUMBER	(15)		The reference to the invoice created in Oracle Receivables from the draft invoice. The column is populated by Tieback Invoice and holds the RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
DRAFT_INVOICE_NUM_CREDITED	NUMBER	(15)		The draft invoice number that is credited by this draft invoice. The crediting invoice may be a credit memo or a write-off
CANCELED_FLAG	VARCHAR2	(1)		Flag that indicates that the draft invoice was credited by another draft invoice, a credit memo
CANCEL_CREDIT_MEMO_FLAG	VARCHAR2	(1)		Flag that indicates that the draft invoice is a credit memo, crediting or canceling another draft invoice
WRITE_OFF_FLAG	VARCHAR2	(1)		Flag that indicates that a draft invoice writes off another draft invoice
CONVERTED_FLAG	VARCHAR2	(1)		Flag indicating if the invoice is converted. 'Y' denotes a converted invoice with no detail in AR as PA expects. A value of 'N' or null denotes a non-converted invoice. A converted invoice cannot be cancelled or written off.
EXTRACTED_DATE	DATE			This column will be used to mark invoices that have been extracted into external systems. The column will get updated to prevent the same invoices from being extracted again. Currently not used.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
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
RETENTION_PERCENTAGE	NUMBER	(15)		Retention percentage for the invoice
INVOICE_SET_ID	NUMBER	(15)		Identifier of set of invoices created together in the same run which must be released at the same time
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
INV_CURRENCY_CODE	VARCHAR2	(15)		Invoice currency code for the draft invoice that is transferred to Oracle Receivables.
INV_RATE_TYPE	VARCHAR2	(30)		Invoice Currency exchange rate type for the draft invoice that is transferred to Oracle Receivables
INV_RATE_DATE	DATE			Invoice Currency exchange rate date for the draft invoice that is transferred to Oracle Receivables.
INV_EXCHANGE_RATE	NUMBER			Invoice Currency exchange rate for the draft invoice that is transferred to Oracle Receivables.
BILL_TO_ADDRESS_ID	NUMBER			Bill to Site identifier of the customer address
SHIP_TO_ADDRESS_ID	NUMBER			Ship to Site identifier of the customer address
PRC_GENERATED_FLAG	VARCHAR2	(1)		For future use
RECEIVABLE_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the receivables amount is charged This column is populated by the Transfer Invoices to Receivables process
ROUNDING_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the rounding amount is charged This column is populated by the Transfer Invoices to Receivables process
UNBILLED_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the unbilled receivable amount is charged This column is populated by the Transfer Invoices to Receivables process
UNEARNED_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the unearned revenue amount is chargedThis column is populated in Transfer Invoice to Receivable program from Release 115
WOFF_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the write-off amount is charged This column is populated by the Transfer Invoices to Receivables process
ACCTD_CURR_CODE	VARCHAR2	(15)		The currency code associated with the ledger attached to the responsibilty used to log into the application.
ACCTD_RATE_TYPE	VARCHAR2	(30)		Accounted currency rate type for the draft invoices generated for this project customer.
ACCTD_RATE_DATE	DATE			Accounted currency rate date for the draft invoices generated for this project customer.
ACCTD_EXCHG_RATE	NUMBER			Accounted currency exchange rate for the draft invoices generated for this project customer.
LANGUAGE	VARCHAR2	(30)		The customer language corresponding to the bill to address
CC_INVOICE_GROUP_CODE	VARCHAR2	(1)		Indicates whether the intercompany invoice is generated using invoice grouping by project
CC_PROJECT_ID	NUMBER			Identifier of cross charged project for intercompany invoices generated using the invoice grouping by project
IB_AP_TRANSFER_STATUS_CODE	VARCHAR2	(1)		Transfer Status code of the intercompany invoice for interface to Oracle Payables
IB_AP_TRANSFER_ERROR_CODE	VARCHAR2	(80)		Code indicating error encountered while transferring invoice to Oracle Payables
INVPROC_CURRENCY_CODE	VARCHAR2	(15)		Invoice processing currency code
PROJFUNC_INVTRANS_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from project functional currency to invoice transaction currency
PROJFUNC_INVTRANS_RATE_DATE	DATE			Exchange rate date to use for conversion from project functional currency to invoice transaction currency
PROJFUNC_INVTRANS_EX_RATE	NUMBER			Exchange rate to use for conversion from project functional currency to invoice transaction currency
PA_PERIOD_NAME	VARCHAR2	(15)		Project functional currency code
GL_PERIOD_NAME	VARCHAR2	(15)		Bill Amount in the project functional currency. This is calculated by applying the conversion rules set up for project functional currency during invoice generation.
UBR_SUMMARY_ID	NUMBER	(15)		The UBR summary ID.
UER_SUMMARY_ID	NUMBER	(15)		The UER summary ID
UBR_UER_PROCESS_FLAG	VARCHAR2	(1)		The UBR/UER process flag.
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)		PJI Summarized Flag
RETENTION_INVOICE_FLAG	VARCHAR2	(1)		This indicates whether the invoice is retention invoice or not. Valid values are Y or N
RETN_CODE_COMBINATION_ID	NUMBER			Retention account code combination id. This is generated based on the auto accounting rules.
PURGE_FLAG	VARCHAR2	(1)		Flag to indicate if underlying expenditure items of an intercompany invoice are purged.
CUSTOMER_ID	NUMBER	(15)		The identifier of the project for which the customer is entered
BILL_TO_CUSTOMER_ID	NUMBER	(15)		The identifier of the customer id to which invoices are sent
SHIP_TO_CUSTOMER_ID	NUMBER	(15)		The identifier of the customer id that is the project customer's default work site for the project
BILL_TO_CONTACT_ID	NUMBER	(15)		The identifier of the contact who is a representative for the bill to customer of the project
SHIP_TO_CONTACT_ID	NUMBER	(15)		The identifier of the contact who is a representative for the ship to customer of the project
CREDIT_MEMO_REASON_CODE	VARCHAR2	(30)		Reason code for releasing credit invoices
CONCESSION_FLAG	VARCHAR2	(1)		Flag indicating that the draft invoice is a concession of another invoice
RECORD_VERSION_NUMBER	NUMBER			Stores the locking sequence number
LAST_CREDIT_REQUEST_ID	NUMBER			Identifier of the last credit
PAYMENT_SET_ID	NUMBER	(15)		Indicates a unique reference for all the receipt from AR which are applied against the agreement.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      DRAFT_INVOICE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TRANSFER_STATUS_CODE
,      GENERATION_ERROR_FLAG
,      AGREEMENT_ID
,      PA_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CUSTOMER_BILL_SPLIT
,      BILL_THROUGH_DATE
,      INVOICE_COMMENT
,      APPROVED_DATE
,      APPROVED_BY_PERSON_ID
,      RELEASED_DATE
,      RELEASED_BY_PERSON_ID
,      INVOICE_DATE
,      RA_INVOICE_NUMBER
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      UNEARNED_REVENUE_CR
,      UNBILLED_RECEIVABLE_DR
,      GL_DATE
,      SYSTEM_REFERENCE
,      DRAFT_INVOICE_NUM_CREDITED
,      CANCELED_FLAG
,      CANCEL_CREDIT_MEMO_FLAG
,      WRITE_OFF_FLAG
,      CONVERTED_FLAG
,      EXTRACTED_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      RETENTION_PERCENTAGE
,      INVOICE_SET_ID
,      ORG_ID
,      INV_CURRENCY_CODE
,      INV_RATE_TYPE
,      INV_RATE_DATE
,      INV_EXCHANGE_RATE
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      PRC_GENERATED_FLAG
,      RECEIVABLE_CODE_COMBINATION_ID
,      ROUNDING_CODE_COMBINATION_ID
,      UNBILLED_CODE_COMBINATION_ID
,      UNEARNED_CODE_COMBINATION_ID
,      WOFF_CODE_COMBINATION_ID
,      ACCTD_CURR_CODE
,      ACCTD_RATE_TYPE
,      ACCTD_RATE_DATE
,      ACCTD_EXCHG_RATE
,      LANGUAGE
,      CC_INVOICE_GROUP_CODE
,      CC_PROJECT_ID
,      IB_AP_TRANSFER_STATUS_CODE
,      IB_AP_TRANSFER_ERROR_CODE
,      INVPROC_CURRENCY_CODE
,      PROJFUNC_INVTRANS_RATE_TYPE
,      PROJFUNC_INVTRANS_RATE_DATE
,      PROJFUNC_INVTRANS_EX_RATE
,      PA_PERIOD_NAME
,      GL_PERIOD_NAME
,      UBR_SUMMARY_ID
,      UER_SUMMARY_ID
,      UBR_UER_PROCESS_FLAG
,      PJI_SUMMARIZED_FLAG
,      RETENTION_INVOICE_FLAG
,      RETN_CODE_COMBINATION_ID
,      PURGE_FLAG
,      CUSTOMER_ID
,      BILL_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      CREDIT_MEMO_REASON_CODE
,      CONCESSION_FLAG
,      RECORD_VERSION_NUMBER
,      LAST_CREDIT_REQUEST_ID
,      PAYMENT_SET_ID
FROM PA.PA_DRAFT_INVOICES_ALL;

Dependencies

[top of page]

PA.PA_DRAFT_INVOICES_ALL does not reference any database object

PA.PA_DRAFT_INVOICES_ALL is referenced by following:

PA: PA_DRAFT_INVOICES_ALL#