PAY_PAYMENT_COSTS
This table contains the results from the Costing of Payments process to enable reconciliation with the Financials Cash Accounts.
Details
-
Schema: FUSION
-
Object owner: PAY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PAY_PAYMENT_COSTS_PK |
PAYMENT_COST_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PAYMENT_COST_ID | NUMBER | 18 | Yes | Primary Key | |
PAYROLL_REL_ACTION_ID | NUMBER | 18 | Yes | PAYROLL_REL_ACTION_ID | |
PRE_PAYMENT_ID | NUMBER | 18 | Yes | Identifier for the Pre Payment process. | |
ACCOUNT_TYPE | VARCHAR2 | 30 | Yes | ACCOUNT_TYPE | |
COST_ALLOCATION_KEYFLEX_ID | NUMBER | Yes | COST_ALLOCATION_KEYFLEX_ID | ||
VALUE | NUMBER | Yes | Costed amount | ||
CURRENCY_CODE | VARCHAR2 | 30 | Yes | Currency code of costed amount | |
DEBIT_OR_CREDIT | VARCHAR2 | 30 | Yes | Debit or Credit. (UseLookup DEBIT_CREDIT) | |
ACCOUNTING_DATE | DATE | Yes | Payment Date or Cleared Date or Voided Date | ||
SOURCE_TYPE | VARCHAR2 | 30 | Yes | Pre-Payment or Cheque or Magnetic Tape or Void or External/Manual Payment | |
SOURCE_ACTION_ID | NUMBER | 18 | Yes | AAC ID of the source | |
PAYROLL_ID | NUMBER | 18 | Yes | PAYROLL_ID | |
TRANSFER_TO_GL_FLAG | VARCHAR2 | 30 | Transfer the cost to GL or not | ||
ENTERPRISE_ID | NUMBER | 18 | Yes | Foreign key to PER_ENTERPRISES. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PAY_PAYMENT_COSTS_N1 | Non Unique | Default | PAYROLL_REL_ACTION_ID |
PAY_PAYMENT_COSTS_N2 | Non Unique | Default | PRE_PAYMENT_ID |
PAY_PAYMENT_COSTS_N3 | Non Unique | Default | SOURCE_ACTION_ID |
PAY_PAYMENT_COSTS_PK | Unique | Default | PAYMENT_COST_ID |