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

TABLE: FV.FV_SF1081_TEMP

Object Details
Object Name: FV_SF1081_TEMP
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_SF1081_TEMP
Subobject Name:
Status: VALID


FV_SF1081_TEMP stores transaction information from RA_CUSTOMER_TRX, HZ_CUST_ACCOUNTS, HZ_PARTIES, HZ_CUST_SITE_USES, and HZ_LOCATIONS that has been selected based on the parameters passed for generation of the SF 1081 Voucher and Schedule of Withdrawals and Credits.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes Invoice identifier
TRX_NUMBER VARCHAR2 (20) Yes Transaction number
CUSTOMER_NAME VARCHAR2 (360) Yes Customer name
CUST_ADDRESS1 VARCHAR2 (240) Yes First line of customer address
CUST_ADDRESS2 VARCHAR2 (240)
Second line of customer address
CUST_ADDRESS3 VARCHAR2 (240)
Third line of customer address
CUST_CITY VARCHAR2 (60)
City
CUST_STATE VARCHAR2 (60)
State
CUST_POSTAL_CODE VARCHAR2 (60)
Postal Code
TAX_REFERENCE VARCHAR2 (50)
Taxpayer Identification Number
TREASURY_SYMBOL VARCHAR2 (35)
Treasury symbol of fund value
AMOUNT NUMBER

Amount
BILL_TO_CUSTOMER_ID NUMBER (15)
Customer identifier
TRX_DATE DATE

Invoice date
ALC_CODE VARCHAR2 (30)
Not currently used
Query Text

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


SELECT CUSTOMER_TRX_ID
,      TRX_NUMBER
,      CUSTOMER_NAME
,      CUST_ADDRESS1
,      CUST_ADDRESS2
,      CUST_ADDRESS3
,      CUST_CITY
,      CUST_STATE
,      CUST_POSTAL_CODE
,      TAX_REFERENCE
,      TREASURY_SYMBOL
,      AMOUNT
,      BILL_TO_CUSTOMER_ID
,      TRX_DATE
,      ALC_CODE
FROM FV.FV_SF1081_TEMP;

Dependencies

[top of page]

FV.FV_SF1081_TEMP does not reference any database object

FV.FV_SF1081_TEMP is referenced by following:

SchemaAPPS
SynonymFV_SF1081_TEMP