Z_EXP_EXPORT01 
Default Table Name  Z_EXP_EXPORT01 
Definition 
 Name: Expense Report worktables.     Description: These tables are used as temporary tables for expense report export.
 

Z_EXP_EXPORT01 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
BATCH_ID(PK)    VARCHAR(10)  NO 
Name: Batch ID. Description: The ID of the batch of which this record is a member.  The Batch ID defaults from user screen entry during the export process.
 
EXP_RPT_ID(PK)    VARCHAR(10)  NO 
Name: Expense Report ID. Description: The unique identifier for the expense report.
 
PARENT_EXPENSE_ID(PK)    NUMERIC(10, 0)  NO 
Name: Parent Expense ID. Description: The expense ID of the expense if this expense was generated from it.
 
EXPENSE_ID(PK)    NUMERIC(10, 0)  NO 
Name: Expense ID. Description: The unique identifier for the expense.
 
ALLOCATION_ID(PK)    NUMERIC(10, 0)  NO 
Name: Allocation ID. Description: Synthetic
 
S_TYPE_CD(PK)    VARCHAR(1)  NO 
Name: Batch ID. Description: The type of record. The valid values are  E – Expense. A – Advance. C – Credit
 
S_CHARGE_TYPE_CD(PK)    VARCHAR(2)  NO 
Name: Charge Type. Description: Values are: NA – Not Applicable. UC – Under Ceiling. OC – Over Ceiling. U – Unallowable. T1 – Tax 1. T2 – Tax 2
 
VENDOR_ID    VARCHAR(20)  NO 
Name: Vendor ID. Description: The identifying vendor ID for this employee.
 
EMPL_ID    VARCHAR(20)  NO 
Name: Employee ID. Description: The employee whose expense report it is.
 
LAST_NAME    VARCHAR(30)  NO 
Name: Last Name. Description: From the EMPL table.
 
FIRST_NAME    VARCHAR(30)  NO 
Name: First Name. Description: From the EMPL table.
 
INITIAL_NAME    VARCHAR(1)  YES 
Name: Middle Initial. Description: From the EMPL table.
 
EXP_RPT_DESC    VARCHAR(30)  NO 
Name: Expense Report Description. Description: Short description of the expense report.
 
INVOICE_DT    DATE  NO 
Name: Invoice Date. Description: System Assigned Invoice Date.
 
EXP_RPT_DT    DATE  NO 
Name: Expense Report Date. Description: User assigned date for expense report.
 
PURPOSE_TEXT    VARCHAR(4000)  YES 
Name: Purpose. Description: The purpose of the expenses on the report.
 
EXP_RPT_TYPE_CD    VARCHAR(10)  NO 
Name: Expense Report Type. Description: The type of expense report.
 
EXP_CLASS_CD    VARCHAR(20)  NO 
Name: Expense Class. Description: The expense class of the employee at the time of the expense report.
 
CP_COMPANY_CD    VARCHAR(10)  NO 
Name: Costpoint Company. Description: Costpoint Company Code of expense report. (Employee)
 
PAY_CURRENCY_CD    VARCHAR(3)  NO 
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in.
 
BASE_CURRENCY_CD    VARCHAR(3)  NO 
Name: Base Currency. Description: The base currency code of the system. 
 
AP_1099_FL    VARCHAR(1)  NO 
Name: 1099 Flag. Description: Logical as to whether this expense should be recorded as 1099 information
 
AP_1099_TYPE_CD    VARCHAR(6)  YES 
Name: 1099 Type. Description: Type of 1099 expense. 
 
EXP_CATEGORY_CD    VARCHAR(10)  NO 
Name: Expense Category. Description: The category of the expense.
 
EXP_TYPE_CD    VARCHAR(10)  NO 
Name: Expense Type. Description: The type of the expense.
 
EXPENSE_DT    DATE  NO 
Name: Expense Date. Description: The date the expense was incurred.
 
PROVIDER_CD    VARCHAR(20)  YES 
Name: Provider. Description: The provider of the service for the expense.
 
EXPENSE_TEXT    VARCHAR(120)  YES 
Name: Expense Description. Description: Description of expense.
 
PAY_METHOD_CD    VARCHAR(10)  NO 
Name: Pay Method. Description: User-specified unique identifier for the pay method
 
TRANS_CURRENCY_CD    VARCHAR(3)  NO 
Name: Transaction Currency. Description: The currency that the transaction was incurred in.
 
USER_EXCHANGE_RATE    NUMERIC(20, 10)  NO 
Name: User Provided Exchange Rate. Description: The exchange rate the user provided.
 
TRANS_PAY_EXCHANGE_RATE    NUMERIC(20, 10)  NO 
Name: Transaction to Pay Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency.
 
TRANS_BASE_EXCHANGE_RATE    NUMERIC(20, 10)  NO 
Name: Transaction to Base Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency.
 
UDT01_ID    VARCHAR(50)  YES 
Name: UDT01 ID. Description: The UDT01 identifier for the line.
 
UDT02_ID    VARCHAR(50)  YES 
Name: UDT02 ID. Description: The UDT02 identifier for the line.
 
UDT03_ID    VARCHAR(20)  YES 
Name: UDT03 ID. Description: The UDT03 identifier for the line.
 
UDT04_ID    VARCHAR(20)  YES 
Name: UDT04 ID. Description: The UDT04 identifier for the line.
 
UDT05_ID    VARCHAR(20)  YES 
Name: UDT05 ID. Description: The UDT05 identifier for the line.
 
UDT06_ID    VARCHAR(20)  YES 
Name: UDT06 ID. Description: The UDT06 identifier for the line.
 
UDT07_ID    VARCHAR(20)  YES 
Name: UDT07 ID. Description: The UDT07 identifier for the line.
 
UDT08_ID    VARCHAR(20)  YES 
Name: UDT08 ID. Description: The UDT08 identifier for the line.
 
UDT09_ID    VARCHAR(20)  YES 
Name: UDT09 ID. Description: The UDT09 identifier for the line.
 
UDT10_ID    VARCHAR(20)  YES 
Name: UDT10 ID. Description: The UDT10 identifier for the line.
 
UDT06_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field.
 
UDT07_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field.
 
EXPENSE_REF_CD    VARCHAR(20)  YES 
Name: Expense Reference. Description: User defined reference code.
 
TRANS_AMT    NUMERIC(15, 5)  NO 
Name: Transaction Amount. Description: The amount in transaction currency.
 
PAY_AMT    NUMERIC(15, 5)  NO 
Name: Pay Amount. Description: The amount in pay currency
 
BASE_AMT    NUMERIC(15, 5)  NO 
Name: Base Amount. Description: The amount in system base currency.
 
PAY_VENDOR_ID    VARCHAR(20)  YES 
 
UDT01_ABBRV_ID    VARCHAR(20)  YES 
Name: UDT01 Abbreviation ID. Description: Abbreviation for UDT01.
 
UDT02_ABBRV_ID    VARCHAR(20)  YES 
Name: UDT02 Abbreviation ID. Description: Abbreviation for UDT02.
 
UDT09_ABBRV_ID    VARCHAR(20)  YES 
Name: UDT09 Abbreviation ID. Description: Abbreviation for UDT09.
 
CODE1_CD    VARCHAR(20)  YES 
Name: Expense Type User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense type.
 
CODE2_CD    VARCHAR(20)  YES 
Name: Expense Type User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense type.
 
CODE3_CD    VARCHAR(20)  YES 
Name: Expense Type User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense type.
 
COMMENTS_TEXT    VARCHAR(254)  YES 
Name: Comments. Description: The User Comments about expense.
 
TAX_SCHEDULE_CD    VARCHAR(10)  YES 
Name: Tax Schedule. Description: The tax schedule unique identifier
 
TAX_LOCATION_S    VARCHAR(20)  YES 
Name: Tax Location. Description: The location used in tax schedule.
 
TAX_ID_S    VARCHAR(20)  YES 
Name: Tax ID. Description: The tax id of provider of service or goods.
 
TRANS_TAX_AMT    NUMERIC(15, 5)  NO 
Name: Transaction Tax Amount. Description: The combined total of tax amounts in transaction currency.
 
PAY_TAX_AMT    NUMERIC(15, 5)  NO 
Name: Pay Tax Amount. Description: The combined total of tax amounts in pay currency.
 
BASE_TAX_AMT    NUMERIC(15, 5)  NO 
Name: Base Tax Amount. Description: The combined total of tax amounts in base currency.
 
TAX_RECOVERY_RATE1_PCT    NUMERIC(3, 2)  NO 
Name: Tax Rate 1 Recovery Percentage. Description: The recovery percentage for the rate1 tax.
 
TAX_RECOVERY_RATE2_PCT    NUMERIC(3, 2)  NO 
Name: Tax Rate 2 Recovery Percentage. Description: The recovery percentage for the rate 2 tax.
 
TRANS_TAX_RECOVERY_RATE1_AMT    NUMERIC(15, 5)  NO 
Name: Tax Rate 1 Recovery Transaction Amount. Description: The amount of rate 1 tax that is recoverable in transaction currency.
 
TRANS_TAX_RECOVERY_RATE2_AMT    NUMERIC(15, 5)  NO 
Name: Tax Rate 2 Recovery Transaction Amount. Description: The amount of rate 2 tax that is recoverable in transaction currency.
 
PAY_TAX_RECOVERY_RATE1_AMT    NUMERIC(15, 5)  NO 
Name: Tax Rate 1 Recovery Pay Amount. Description: The amount of rate 1 tax that is recoverable in pay currency.
 
PAY_TAX_RECOVERY_RATE2_AMT    NUMERIC(15, 5)  NO 
Name: Tax Rate 2 Recovery Pay Amount. Description: The amount of rate 2 tax that is recoverable in pay currency.
 
BASE_TAX_RECOVERY_RATE1_AMT    NUMERIC(15, 5)  NO 
Name: Tax Rate 1 Recovery Base Amount. Description: The amount of rate 1 tax that is recoverable in base currency.
 
BASE_TAX_RECOVERY_RATE2_AMT    NUMERIC(15, 5)  NO 
Name: Tax Rate 2 Recovery Base Amount. Description: The amount of rate 2 tax that is recoverable in base currency.
 
UDT11_ID    VARCHAR(20)  YES 
Name: UDT11 ID. Description: The UDT11 identifier for the line.
 
UDT12_ID    VARCHAR(20)  YES 
Name: UDT12 ID. Description: The UDT12 identifier for the line.
 
UDT13_ID    VARCHAR(20)  YES 
Name: UDT13 ID. Description: The UDT13 identifier for the line.
 
UDT14_ID    VARCHAR(20)  YES 
Name: UDT14 ID. Description: The UDT14 identifier for the line.
 
UDT15_ID    VARCHAR(20)  YES 
Name: UDT15 ID. Description: The UDT15 identifier for the line.
 
CORRECTION_NO(PK)    NUMERIC(10, 0)  NO 
Name: Correction Number. Description: The current correction number of the expense report.
 

Z_EXP_EXPORT01 Keys 
Key Name  Key Type  Keys 
PI_0198  PrimaryKey  BATCH_ID, EXP_RPT_ID, PARENT_EXPENSE_ID, EXPENSE_ID, ALLOCATION_ID, S_TYPE_CD, S_CHARGE_TYPE_CD, CORRECTION_NO 

Z_EXP_EXPORT01 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