ADVANCE_ID 
ColumnName  ADVANCE_ID 
Definition 
Name: Advance Key   Description: The expense type unique identifier.
 

DISPLAY_ADVANCE_ID 
ColumnName  DISPLAY_ADVANCE_ID 
Definition 
Name: Advance ID  Description: The advance ID that user will see.
 

ADVANCE_DTT 
ColumnName  ADVANCE_DTT 
Definition 
Name: Advance Date and Time Description: The date and time advance was created.
 

ADVANCE_DUE_DTT 
ColumnName  ADVANCE_DUE_DTT 
Definition 
Name: Advance Date and Time  Description: The date and time advance must be received by.
 

ADVANCE_EMPL_ID 
ColumnName  ADVANCE_EMPL_ID 
Definition 
Name: Advance Resource  Description: The resource for which advance is for.
 

EXP_AUTH_ID 
ColumnName  EXP_AUTH_ID 
Definition 
Name: Associated EA  Description: The expense authorization that advance is associated to if applicable.
 

PAY_CURRENCY_CD 
ColumnName  PAY_CURRENCY_CD 
Definition 
Name: Pay Currency Code  Description: The currency in which the resource is being paid.
 

BASE_CURRENCY_CD 
ColumnName  BASE_CURRENCY_CD 
Definition 
Name: Base Currency Code  Description: The system base currency at time of advance request.
 

PAY_AMT 
ColumnName  PAY_AMT 
Definition 
Name: Advance Amount in Resource's Pay Currency  Description: The requested advance amount in resource's pay currency.
 

BASE_AMT 
ColumnName  BASE_AMT 
Definition 
Name: Advance Amount in Base Currency  Description: The requested advance amount in system's base currency.
 

ADVANCE_REASON_TEXT 
ColumnName  ADVANCE_REASON_TEXT 
Definition 
Name: Advance Reason  Description: .
 

S_ADVANCE_STATUS_CD 
ColumnName  S_ADVANCE_STATUS_CD 
Definition 
Name: Advance Status  Description: .
 

REVISION_NO 
ColumnName  REVISION_NO 
Definition 
Name: Revision  Description: The current revision of the advance.
 

ADVANCE_UDT01_ID 
ColumnName  ADVANCE_UDT01_ID 
Definition 
Name: Advance UDT01 ID  Description: The UDT01 identifier for the line.
 

ADVANCE_UDT02_ID 
ColumnName  ADVANCE_UDT02_ID 
Definition 
Name: Advance UDT02  Description: The UDT02 identifier for the line.
 

ADVANCE_UDT03_ID 
ColumnName  ADVANCE_UDT03_ID 
Definition 
Name: Advance UDT03  Description: The UDT03 identifier for the line.
 

ADVANCE_UDT04_ID 
ColumnName  ADVANCE_UDT04_ID 
Definition 
Name: Advance UDT04  Description: The UDT04 identifier for the line.
 

ADVANCE_UDT05_ID 
ColumnName  ADVANCE_UDT05_ID 
Definition 
Name: Advance UDT05  Description: The UDT05 identifier for the line.
 

ADVANCE_UDT06_ID 
ColumnName  ADVANCE_UDT06_ID 
Definition 
Name: Advance UDT06  Description: The UDT06 identifier for the line.
 

ADVANCE_UDT07_ID 
ColumnName  ADVANCE_UDT07_ID 
Definition 
Name: Advance UDT07  Description: The UDT07 identifier for the line.
 

ADVANCE_UDT08_ID 
ColumnName  ADVANCE_UDT08_ID 
Definition 
Name: Advance UDT08  Description: The UDT08 identifier for the line.
 

ADVANCE_UDT09_ID 
ColumnName  ADVANCE_UDT09_ID 
Definition 
Name: Advance UDT09  Description: The UDT09 identifier for the line.
 

ADVANCE_UDT10_ID 
ColumnName  ADVANCE_UDT10_ID 
Definition 
Name: Advance UDT10  Description: The UDT10 identifier for the line.
 

ADVANCE_UDT06_CP_COMPANY_CD 
ColumnName  ADVANCE_UDT06_CP_COMPANY_CD 
Definition 
Name: Advance UDT06  Description: Costpoint Company Code for UDT06_ID field.
 

ADVANCE_UDT07_CP_COMPANY_CD 
ColumnName  ADVANCE_UDT07_CP_COMPANY_CD 
Definition 
Name: Advance UDT07  Description: Costpoint Company Code for UDT07_ID field.
 

ADVANCE_UDT11_ID 
ColumnName  ADVANCE_UDT11_ID 
Definition 
Name: Advance UDT11  Description: The UDT11 identifier for the line.
 

ADVANCE_UDT12_ID 
ColumnName  ADVANCE_UDT12_ID 
Definition 
Name: Advance UDT12  Description: The UDT12 identifier for the line.
 

ADVANCE_UDT13_ID 
ColumnName  ADVANCE_UDT13_ID 
Definition 
Name: Advance UDT13  Description: The UDT13 identifier for the line.
 

ADVANCE_UDT14_ID 
ColumnName  ADVANCE_UDT14_ID 
Definition 
Name: Advance UDT14  Description: The UDT14 identifier for the line.
 

ADVANCE_UDT15_ID 
ColumnName  ADVANCE_UDT15_ID 
Definition 
Name: Advance UDT15 ID  Description: The UDT15 identifier for the line.
 

ADVANCE_PAYMENT_S 
ColumnName  ADVANCE_PAYMENT_S 
Definition 
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 
ColumnName  PAYMENT_DT 
Definition 
Name: Advance Payment Date  Description: Date of Advance.
 

S_PAYMENT_METHOD_CD 
ColumnName  S_PAYMENT_METHOD_CD 
Definition 
Name: Advance Payment Method  Description: The method of advance. The valid values are: CHECK – Check EFT – Electronic Funds Transfer OTHER – Other.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
 

BATCH_ID 
ColumnName  BATCH_ID 
Definition 
 

UNAVAILABLE_FL 
ColumnName  UNAVAILABLE_FL 
Definition