ColumnName |
Domain |
Datatype |
NULL |
Definition |
ADVANCE_ID |
|
VARCHAR2(40) |
NO |
Name: Advance Key Description: The expense type unique identifier. |
DISPLAY_ADVANCE_ID |
|
VARCHAR2(12) |
NO |
Name: Advance ID Description: The advance ID that user will see. |
ADVANCE_DTT |
|
DATE |
NO |
Name: Advance Date and Time Description: The date and time advance was created. |
ADVANCE_DUE_DTT |
|
DATE |
NO |
Name: Advance Date and Time Description: The date and time advance must be received by. |
ADVANCE_EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Advance Resource Description: The resource for which advance is for. |
EXP_AUTH_ID |
|
VARCHAR2(10) |
YES |
Name: Associated EA Description: The expense authorization that advance is associated to if applicable. |
PAY_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
Name: Pay Currency Code Description: The currency in which the resource is being paid. |
BASE_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
Name: Base Currency Code Description: The system base currency at time of advance request. |
PAY_AMT |
|
NUMBER(15, 5) |
NO |
Name: Advance Amount in Resource's Pay Currency Description: The requested advance amount in resource's pay currency. |
BASE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Advance Amount in Base Currency Description: The requested advance amount in system's base currency. |
ADVANCE_REASON_TEXT |
|
VARCHAR2(254) |
NO |
Name: Advance Reason Description: . |
S_ADVANCE_STATUS_CD |
|
VARCHAR2(1) |
NO |
Name: Advance Status Description: . |
REVISION_NO |
|
NUMBER(10, 0) |
NO |
Name: Revision Description: The current revision of the advance. |
ADVANCE_UDT01_ID |
|
VARCHAR2(50) |
YES |
Name: Advance UDT01 ID Description: The UDT01 identifier for the line. |
ADVANCE_UDT02_ID |
|
VARCHAR2(50) |
YES |
Name: Advance UDT02 Description: The UDT02 identifier for the line. |
ADVANCE_UDT03_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT03 Description: The UDT03 identifier for the line. |
ADVANCE_UDT04_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT04 Description: The UDT04 identifier for the line. |
ADVANCE_UDT05_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT05 Description: The UDT05 identifier for the line. |
ADVANCE_UDT06_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT06 Description: The UDT06 identifier for the line. |
ADVANCE_UDT07_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT07 Description: The UDT07 identifier for the line. |
ADVANCE_UDT08_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT08 Description: The UDT08 identifier for the line. |
ADVANCE_UDT09_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT09 Description: The UDT09 identifier for the line. |
ADVANCE_UDT10_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT10 Description: The UDT10 identifier for the line. |
ADVANCE_UDT06_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
Name: Advance UDT06 Description: Costpoint Company Code for UDT06_ID field. |
ADVANCE_UDT07_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
Name: Advance UDT07 Description: Costpoint Company Code for UDT07_ID field. |
ADVANCE_UDT11_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT11 Description: The UDT11 identifier for the line. |
ADVANCE_UDT12_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT12 Description: The UDT12 identifier for the line. |
ADVANCE_UDT13_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT13 Description: The UDT13 identifier for the line. |
ADVANCE_UDT14_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT14 Description: The UDT14 identifier for the line. |
ADVANCE_UDT15_ID |
|
VARCHAR2(20) |
YES |
Name: Advance UDT15 ID Description: The UDT15 identifier for the line. |
ADVANCE_PAYMENT_S |
|
VARCHAR2(20) |
YES |
Name: Advance Payment Reference Code Description: The reference number for the advance. Usually it is the number of the check for the advance. |
PAYMENT_DT |
|
DATE |
YES |
Name: Advance Payment Date Description: Date of Advance. |
S_PAYMENT_METHOD_CD |
|
VARCHAR2(5) |
YES |
Name: Advance Payment Method Description: The method of advance. The valid values are: CHECK – Check EFT – Electronic Funds Transfer OTHER – Other. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
|
ROWVERSION |
|
NUMBER(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|
BATCH_ID |
|
VARCHAR2(10) |
YES |
|
UNAVAILABLE_FL |
|
VARCHAR2(1) |
NO |
|