[Home] [Help] [Dependency Information]
Object Name: | AR_AGING_EXTRACT# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_ID | NUMBER | |||
CUSTOMER_NUMBER | VARCHAR2 | (200) | ||
SHORT_CUSTOMER_NAME | VARCHAR2 | (240) | ||
SORT_FIELD1 | VARCHAR2 | (500) | ||
SORT_FIELD2 | VARCHAR2 | (500) | ||
INV_TID_INV | VARCHAR2 | (30) | ||
CONTACT_SITE_ID | NUMBER | |||
CUSTOMER_STATE | VARCHAR2 | (60) | ||
CUSTOMER_CITY | VARCHAR2 | (60) | ||
CUST_ACCT_SITE_ID | NUMBER | |||
PAYMENT_SCHEDULE_ID | NUMBER | |||
CLASS | VARCHAR2 | (20) | ||
DUE_DATE | DATE | |||
AMT_DUE_REMAINING | NUMBER | |||
TRX_NUMBER | VARCHAR2 | (30) | ||
DAYS_PAST_DUE | NUMBER | |||
AMOUNT_ADJUSTED | NUMBER | |||
AMOUNT_APPLIED | NUMBER | |||
AMOUNT_CREDITED | NUMBER | |||
GL_DATE | DATE | |||
DATA_CONVERTED_FLAG | VARCHAR2 | (1) | ||
EXCHANGE_RATE | NUMBER | |||
BUCKET_0 | NUMBER | |||
BUCKET_1 | NUMBER | |||
BUCKET_2 | NUMBER | |||
BUCKET_3 | NUMBER | |||
BUCKET_4 | NUMBER | |||
BUCKET_5 | NUMBER | |||
BUCKET_6 | NUMBER | |||
BAL_SEGMENT_VALUE | VARCHAR2 | (25) | ||
INVOICE_TYPE | VARCHAR2 | (200) | ||
CONS_BILLING_NUMBER | VARCHAR2 | (200) | ||
CONTACT_NAME | VARCHAR2 | (360) | ||
CONTACT_PHONE | VARCHAR2 | (360) | ||
CATEGORY | VARCHAR2 | (30) | ||
PARENT_REQUEST_ID | NUMBER | |||
WORKER_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_ID
, CUSTOMER_NUMBER
, SHORT_CUSTOMER_NAME
, SORT_FIELD1
, SORT_FIELD2
, INV_TID_INV
, CONTACT_SITE_ID
, CUSTOMER_STATE
, CUSTOMER_CITY
, CUST_ACCT_SITE_ID
, PAYMENT_SCHEDULE_ID
, CLASS
, DUE_DATE
, AMT_DUE_REMAINING
, TRX_NUMBER
, DAYS_PAST_DUE
, AMOUNT_ADJUSTED
, AMOUNT_APPLIED
, AMOUNT_CREDITED
, GL_DATE
, DATA_CONVERTED_FLAG
, EXCHANGE_RATE
, BUCKET_0
, BUCKET_1
, BUCKET_2
, BUCKET_3
, BUCKET_4
, BUCKET_5
, BUCKET_6
, BAL_SEGMENT_VALUE
, INVOICE_TYPE
, CONS_BILLING_NUMBER
, CONTACT_NAME
, CONTACT_PHONE
, CATEGORY
, PARENT_REQUEST_ID
, WORKER_ID
FROM AR.AR_AGING_EXTRACT#;
|
|
|