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

TABLE: XTR.XTR_PAYMENT_SCHEDULE

Object Details
Object Name: XTR_PAYMENT_SCHEDULE
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_PAYMENT_SCHEDULE
Subobject Name:
Status: VALID


XTR_PAYMENT_SCHEDULE contains payment schedule information for retail term money
deal transactions. Each row includes the deal subtype, product type, schedule code and
description. Payment frequency and calculation type are used to calculate the regular payments for
retail term money deal transactions.
This table corresponds to the Payment Schedules window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DEAL_TYPE VARCHAR2 (7) Yes Code for high level deals
PRODUCT_TYPE VARCHAR2 (10) Yes Code for products used in a deal type
DEAL_SUBTYPE VARCHAR2 (7) Yes Code for deal executions permissible within a deal type
PAYMENT_SCHEDULE_CODE VARCHAR2 (7) Yes Payment schedule code
DESCRIPTION VARCHAR2 (20)
Payment schedule description
DEFAULT_YN VARCHAR2 (1)
Flag to indicate if the payment schedule is the default one (Y), or not (N)
PAYMENT_FREQUENCY VARCHAR2 (12)
Payment frequency
POST_MONTHS_FORWARD VARCHAR2 (3)
Number of months from current date payment transactions are to be posted
CALC_TYPE VARCHAR2 (7)
Repayment calculation type
ADJUST_ON_SETTLE VARCHAR2 (1)
Not currently used
INTEREST_ACTION VARCHAR2 (8)
Not currently used (Treasury always defaults 'SETTLE')
JAN_YN VARCHAR2 (1)
Flag to indicate if January is part of the payment schedule (only applies if payment frequency is Ad Hoc)
FEB_YN VARCHAR2 (1)
Flag to indicate if February is part of the payment schedule (only applies if payment frequency is Ad Hoc)
MAR_YN VARCHAR2 (1)
Flag to indicate if March is part of the payment schedule (only applies if payment frequency is Ad Hoc)
APR_YN VARCHAR2 (1)
Flag to indicate if April is part of the payment schedule (only applies if payment frequency is Ad Hoc)
MAY_YN VARCHAR2 (1)
Flag to indicate if May is part of the payment schedule (only applies if payment frequency is Ad Hoc)
JUN_YN VARCHAR2 (1)
Flag to indicate if June is part of the payment schedule (only applies if payment frequency is Ad Hoc)
JUL_YN VARCHAR2 (1)
Flag to indicate if July is part of the payment schedule (only applies if payment frequency is Ad Hoc)
AUG_YN VARCHAR2 (1)
Flag to indicate if August is part of the payment schedule (only applies if payment frequency is Ad Hoc)
SEP_YN VARCHAR2 (1)
Flag to indicate if September is part of the payment schedule (only applies if payment frequency is Ad Hoc)
OCT_YN VARCHAR2 (1)
Flag to indicate if October is part of the payment schedule (only applies if payment frequency is Ad Hoc)
NOV_YN VARCHAR2 (1)
Flag to indicate if November is part of the payment schedule (only applies if payment frequency is Ad Hoc)
DEC_YN VARCHAR2 (1)
Flag to indicate if December is part of the payment schedule (only applies if payment frequency is Ad Hoc)
MIN_POSTINGS NUMBER

Minimum number of payment transactions posted
POSTING_FREQ NUMBER

Payment transaction posting frequency
NEXT_POSTING_DUE DATE

Next posting date of payment transactions
Query Text

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


SELECT DEAL_TYPE
,      PRODUCT_TYPE
,      DEAL_SUBTYPE
,      PAYMENT_SCHEDULE_CODE
,      DESCRIPTION
,      DEFAULT_YN
,      PAYMENT_FREQUENCY
,      POST_MONTHS_FORWARD
,      CALC_TYPE
,      ADJUST_ON_SETTLE
,      INTEREST_ACTION
,      JAN_YN
,      FEB_YN
,      MAR_YN
,      APR_YN
,      MAY_YN
,      JUN_YN
,      JUL_YN
,      AUG_YN
,      SEP_YN
,      OCT_YN
,      NOV_YN
,      DEC_YN
,      MIN_POSTINGS
,      POSTING_FREQ
,      NEXT_POSTING_DUE
FROM XTR.XTR_PAYMENT_SCHEDULE;

Dependencies

[top of page]

XTR.XTR_PAYMENT_SCHEDULE does not reference any database object

XTR.XTR_PAYMENT_SCHEDULE is referenced by following:

SchemaAPPS
SynonymXTR_PAYMENT_SCHEDULE