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 |