IMPORT_EXP_RPT_ADVANCE_PAYMENT 
Default Table Name  IMPORT_EXP_RPT_ADVANCE_PAYMENT 
Definition 
 Name: Expense Report Advances and Payments Import .     Description: This staging table contains valid expense report advance and payment records that will be imported to Deltek Time and Expense if validations are passed.
 

IMPORT_EXP_RPT_ADVANCE_PAYMENT Columns 
ColumnName  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR2(30)  NO 
Name: Domain. Description: Alias for database schema that will be updated.
 
S_IMPORT_CD    VARCHAR2(1)  NO 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add C - Change D - Delete B - Batch 
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 
EXTERNAL_USER    VARCHAR2(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
EMPL_ID    VARCHAR2(20)  YES 
Name: Employee ID. Description: The unique identifier of the employee for the advance.
 
REFERENCE_CD    VARCHAR2(20)  NO 
Name: Reference Code. Description: The reference number for the advance or payment. Usually it is the number of the check for the advance or payment.
 
S_METHOD_TYPE_CD    VARCHAR2(5)  NO 
Name: Payment Method. Description: The type of advance or method of payment. The valid values for an advance type are: CHECK – Check. EFT – Electronic Funds Transfer. OTHER – Other. The valid values for a payment method are:. AP – A/P Check/EFT. PR – Payroll Check/EFT. CR – Cash Receipt
 
PAY_CURRENCY_CD    VARCHAR2(3)  YES 
Name: Pay Currency. Description: The currency code the advance was paid in.
 
BASE_CURRENCY_CD    VARCHAR2(3)  YES 
Name: Base Currency. Description: The base currency code of the system.
 
PAY_AMT    NUMBER(15, 5)  NO 
Name: Pay Currency Amount. Description: The amount of the advance or payment in the employee’s pay currency.
 
BASE_AMT    NUMBER(15, 5)  NO 
Name: Base Currency Amount. Description: The amount of the advance or payment in the system’s base currency.
 
S_IMPORT_TYPE_CD    VARCHAR2(1)  NO 
Name: Transaction Type. Description: Indicates the type of record being imported. The valid values are: A – Advance. P - Payment
 
PAYMENT_DT    DATE  NO 
Name: Payment Date. Description: Date of the advance or payment.
 
EXP_RPT_ID    VARCHAR2(10)  YES 
Name: Expense Report ID. Description: The unique identifier of either the expense report or the expense authorization for an advance.
 
ADVANCE_ID    VARCHAR2(40)  YES 
Name: Advance ID  Description: The unique identifier for the advance.
 
DISPLAY_ADVANCE_ID    VARCHAR2(12)  YES 
Name: Advance ID  Description: The advance ID that user will see.
 

IMPORT_EXP_RPT_ADVANCE_PAYMENT Primary and Unique Keys 
Key Name  Key Type  Keys 

IMPORT_EXP_RPT_ADVANCE_PAYMENT Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable