PO_DOCUMENT_TOTALS_GT

Global temporary table used in calculating document totals.

Details

• Schema: FUSION

• Object owner: PO

• Object type: TABLE

Primary Key

Name	Columns
PO_DOCUMENT_TOTALS_GT_PK	KEY

Columns

Name

KEYNUMBER18YesKey Identifier LINE_LOCATION_IDNUMBER18Document shipment schedule unique identifier AMOUNT_BASED_FLAGVARCHAR21Indicates whether the line is Amount Based or not. SHIPMENT_TYPEVARCHAR225Type of the shipment PAYMENT_TYPEVARCHAR230Type of Pay Item PRICENUMBERPrice QUANTITY_TOTALNUMBERStores the Total Quantity QUANTITY_BILLEDNUMBERQuantity invoiced by Oracle Payables, up until today QUANTITY_DELIVEREDNUMBERQuantity delivered against the distribution QUANTITY_FINANCEDNUMBERFor Financing Distributions, the number of units which have been pre-paid QUANTITY_RECOUPEDNUMBERFor Financing Distributions, the number of units for which prepayments have been liquidated QUANTITY_RECEIVEDNUMBERQuantity received until today QUANTITY_SHIPPEDNUMBERQuantity shipped AMOUNT_TOTALNUMBERStores the total Total Amount AMOUNT_BILLEDNUMBERStores the amount billed for service lines AMOUNT_DELIVEREDNUMBERStores the amount delivered for service lines AMOUNT_FINANCEDNUMBERFor Advances or Financing Pay Items, the amount which has been pre-paid AMOUNT_RECOUPEDNUMBERFor Advances or Financing Pay Items, the amount of the prepayments which has been liquidated AMOUNT_RECEIVEDNUMBERStores the amount received for service lines AMOUNT_SHIPPEDNUMBERShipped Amount RETAINAGE_WITHHELD_AMOUNTNUMBERThe total amount withheld as Retainage against this Distribution RETAINAGE_RELEASED_AMOUNTNUMBERThe amount of Retainage released for this Distribution

Indexes

Index	Uniqueness	Columns
PO_DOCUMENT_TOTALS_GT_U1	Unique	KEY