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 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR(30)  NO 
Name: Domain. Description: Alias for database schema that will be updated.
 
S_IMPORT_CD    VARCHAR(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    VARCHAR(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
EMPL_ID    VARCHAR(20)  YES 
Name: Employee ID. Description: The unique identifier of the employee for the advance.
 
REFERENCE_CD    VARCHAR(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    VARCHAR(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    VARCHAR(3)  YES 
Name: Pay Currency. Description: The currency code the advance was paid in.
 
BASE_CURRENCY_CD    VARCHAR(3)  YES 
Name: Base Currency. Description: The base currency code of the system.
 
PAY_AMT    NUMERIC(15, 5)  NO 
Name: Pay Currency Amount. Description: The amount of the advance or payment in the employee’s pay currency.
 
BASE_AMT    NUMERIC(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    VARCHAR(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    VARCHAR(10)  YES 
Name: Expense Report ID. Description: The unique identifier of either the expense report or the expense authorization for an advance.
 
ADVANCE_ID    VARCHAR(40)  YES 
Name: Advance ID  Description: The unique identifier for the advance.
 
DISPLAY_ADVANCE_ID    VARCHAR(12)  YES 
Name: Advance ID  Description: The advance ID that user will see.
 

IMPORT_EXP_RPT_ADVANCE_PAYMENT Keys 
Key Name  Key Type  Keys 

IMPORT_EXP_RPT_ADVANCE_PAYMENT Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype