Data Archive Reporting data archive reporting fields

Employee Absence Plan View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	TAEEMASTER
Plan	R_PLAN	TAEEMASTER
Employee Group	EMPLOYEE_GROUP	TAEEMASTER
Employee	EMPLOYEE	TAEEMASTER
Position	R_POSITION	TAEEMASTER
Master Override	MSTR_OVERRIDE	TAEEMASTER
Available Hours	AVAIL_HRS_BAL	TAEEMASTER
Accrued Hours	ACCR_HRS_BAL	TAEEMASTER
Allotment Hours	ALLOT_HRS_BAL	TAEEMASTER
Carryover Hours	CARRY_HRS_BAL	TAEEMASTER
Reserved Hours	RESRV_HRS_BAL	TAEEMASTER
Available Earnings	ERN_ERN_BAL	TAEEMASTER
Currency Code	CURRENCY_CODE	TAEEMASTER
Accrued Earnings	ACCR_ERN_BAL	TAEEMASTER
Allotment Earnings	ALLOT_ERN_BAL	TAEEMASTER
Carryover Earnings	CARRY_ERN_BAL	TAEEMASTER
Reserved Earnings	RESRV_ERN_BAL	TAEEMASTER
Master Entry Date	MASTR_ENTRY	TAEEMASTER
Service Begin Date	SRV_BEGIN_DT	TAEEMASTER
Allotment Begin Date	ALLOT_BEGIN_DT	TAEEMASTER
Limit Reset Point	RESET_POINT	TAEEMASTER
Last Eligibility Date	ELIG_LAST_DT	TAEEMASTER
Accrual End Date	MSTR_ELIG_END	TAEEMASTER
Accrual From Date	ACCR_BEGIN_DT	TAEEMASTER
Allotment Point	ALLOT_POINT	TAEEMASTER
Last Accrual Date	ACCR_LAST_DT	TAEEMASTER
Last Limit Date	RESET_LAST_DT	TAEEMASTER
Master End Date	MSTR_END	TAEEMASTER
Accrual Start Date	ACCR_START_DT	TAEEMASTER
Eligibility Begin Date	ELIG_BEGIN_DT	TAEEMASTER
Last Allotment date	ALLOT_LAST_DT	TAEEMASTER
Carryover End Date	CARRYOVER_END	TAEEMASTER
Structure End Date	STRUCTURE_END	TAEEMASTER
Hours Accrual Account CO	HRS_ACCR_CO	TAEEMASTER
Hours Accrual Unit	HRS_ACCR_UNIT	TAEEMASTER
Hours Accrual Account	HRS_ACCR_ACCT	TAEEMASTER
Hours Accrual Sub Account	HRS_ACCR_SUB	TAEEMASTER
Hours Expense Account CO	HRS_EXP_CO	TAEEMASTER
Hours Expense Unit	HRS_EXP_UNIT	TAEEMASTER
Hours Expense Sub Account	HRS_EXP_SUB	TAEEMASTER
Hours Expense Account	HRS_EXP_ACCT	TAEEMASTER
Earnings Accrual Account CO	ERN_ACCR_CO	TAEEMASTER
Earnings Accrual Unit	ERN_ACCR_UNIT	TAEEMASTER
Earnings Accrual Account	ERN_ACCR_ACCT	TAEEMASTER
Earnings Accrual Sub Account	ERN_ACCR_SUB	TAEEMASTER
Earnings Expense Account CO	ERN_EXP_CO	TAEEMASTER
Earnings Expense Unit	ERN_EXP_UNIT	TAEEMASTER
Earnings Expense Account	ERN_EXP_ACCT	TAEEMASTER
Earnings Expense Sub Account	ERN_EXP_SUB	TAEEMASTER
Hours Activity	HRS_ACTIVITY	TAEEMASTER
Hours Accrual Account Category	HRS_ACCT_CAT	TAEEMASTER
Earnings Activity	ERN_ACTIVITY	TAEEMASTER
Earnings Account Category	ERN_ACCT_CAT	TAEEMASTER
Hours Accrual Table	OV_ACCR_HRS	TAEEMASTER
Hours Allotment Table	OV_ALLOT_HRS	TAEEMASTER
Hours Balance Limit Table	OV_BAL_HRS	TAEEMASTER
Hours Accrual Limit Table	OV_ACRLIM_HRS	TAEEMASTER
Hours GL Liability Table	OV_HRS_LIA	TAEEMASTER
Earnings Accrual Table	OV_ACCR_ERN	TAEEMASTER
Earnings Allotment Table	OV_ALLOT_ERN	TAEEMASTER
Earnings Balance Limit Table	OV_BAL_ERN	TAEEMASTER
Earnings Accrual Limit Table	OV_ACRLIM_ERN	TAEEMASTER
Earnings GL Liability Table	OV_ERN_LIA	TAEEMASTER
Job Code	JOB_CODE	TAENROLL
Process Level	PROCESS_LEVEL	TAENROLL
Department	DEPARTMENT	TAENROLL
Enrollment stop date	ENRL_STOP_DT	TAENROLL
Enrollment Override	ENRL_OVERRIDE	TAENROLL
Plan Rule	PLAN_RULE	TALOSHRS
Accrual Type	ACCRUAL_TYPE	TALOSHRS
Year	R_YEAR	TALOSHRS
Hours	HOURS	TALOSHRS

Employee Transaction Detail View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	TAEMPTRANS
Plan	R_PLAN	TAEMPTRANS
Employee Group	EMPLOYEE_GROUP	TAEMPTRANS
Employee	EMPLOYEE	TAEMPTRANS
Tran Type	TRAN_TYPE	TAEMPTRANS
Balance Type	BALANCE_TYPE	TAEMPTRANS
Date	R_DATE	TAEMPTRANS
Currency Code	CURRENCY_CODE	TAEMPTRANS
Description	DESCRIPTION	TAEMPTRANS
EmployeeTransactionHistoryKey
HM Process Level	HM_PROC_LEVEL	TAEMPTRANS
Original Reset Dt	ORIG_RESET_DT	TAEMPTRANS
Position	R_POSITION	TAEMPTRANS
Reset Date	RESET_DATE	TAEMPTRANS
Sequence Number	SEQ_NBR	TAEMPTRANS
TA Type	TA_TYPE	TAEMPTRANS
Beginning Accrual Balance	BEG_ACCR_BAL	TATRANSUM
Beginning Allotment Balance	BEG_ALLOT_BAL	TATRANSUM
Beginning Available Balance	BEG_AVAIL_BAL	TATRANSUM
Beginning Carryover Balance	BEG_CARRY_BAL	TATRANSUM
Beginning Reserve Balance	BEG_RESV_BAL	TATRANSUM
Ending Accrual Balance	END_ACCR_BAL	TATRANSUM
Ending Allotment Balance	END_ALLOT_BAL	TATRANSUM
Ending Available Balance	END_AVAIL_BAL	TATRANSUM
Ending Carryover Balance	END_CARRY_BAL	TATRANSUM
Ending Reserve Balance	END_RESV_BAL	TAEMPTRANS
TA Earnings	TA_EARNINGS	TAEMPTRANS
TA Hours	TA_HOURS	TAEMPTRANS
YTD Accrual	YTD_ACCRUAL	TATRANSUM
YTD Accrual Transfer	YTD_ACCR_TRAN	TATRANSUM
YTD Allotment	YTD_ALLOT	TATRANSUM
YTD Allotment Transfer	YTD_ALLOT_TRAN	TATRANSUM
YTD Available Accrual	YTD_AVL_ACCR	TATRANSUM
YTD Available Adjustment	YTD_ADJ_AVAIL	TATRANSUM
YTD Available Allotment	YTD_AVL_ALLOT	TATRANSUM
YTD Available Purchase	YTD_PURC_AVL	TATRANSUM
YTD Available Sell	YTD_SELL_AVL	TATRANSUM
YTD Available Use	YTD_USE_AVAIL	TATRANSUM
YTD Carryover Adjustment	YTD_ADJ_CARRY	TATRANSUM
YTD Carryover Use	YTD_USE_CARRY	TATRANSUM
YTD Lost Accrual	YTD_LSTACCROL	TATRANSUM
YTD Lost Allotment Ongoing Limit	YTD_LSTALLOTOL	TATRANSUM
YTD Lost Available Carryover	YTD_LSTAVLCL	TATRANSUM
YTD Lost Available Carryover Period Limit	YTD_LSTAVLCP	TATRANSUM
YTD Lost Carryover Period Limit	YTD_LSTCARRYCL	TATRANSUM
YTD Reserve Adjustment	YTD_ADJ_RESV	TATRANSUM
YTD Reserve Use	YTD_USE_RESV	TATRANSUM

Absence Plan Structure View 1


Attribute or measure name	Table field	Archive source table
Company	Company	TASTRUCTUR
Plan	R_Plan	TASTRUCTUR
Description	Description	TAPAYROLL
Status	Status	TAPLAN
Balance Type	Balance_Type	TAPLAN
Table Basis	Table_Basis	TAPLAN
Enrollment Type	Enroll_Type	TAPLAN
Automatic Enrollment	Auto_Enroll	TAPLAN
Web Available	Web_Available	TAPLAN
Web Supervisor Available	Web_Avail_Supv	TAPLAN
Plan Category	Category	TAPLAN
Date Stamp	Date_Stamp	TASTRUCTUR
End Date	End_Date	TASTRUCTUR
Time Stamp	Time_Stamp	TASTRUCTUR
Begin Date	Begin_Date	TASTRUCTUR

Absence Plan Structure View 2


Attribute or measure name	Table field	Archive source table
Company	Company	TASTRUCTUR
Plan	R_Plan	TASTRUCTUR
Description	Description	TAPAYROLL
Employee Group	Employee_Group	TASTRUCTUR
Begin Date	Begin_Date	TASTRUCTUR
End Date	END_DATE	TASTRUCTUR
Accrual Option	Accrual_Option	TASTRUCTUR
Currency Code	Currency_Code	TASTRUCTUR
Service Rule	Service_Rule	TASTRUCTUR
Accrual Rule	Accrual_Rule	TASTRUCTUR
Eligible Rule	Eligible_Rule	TASTRUCTUR
Payroll Rule	Payroll_Rule	TASTRUCTUR
Gl Rule	Gl_Rule	TASTRUCTUR
Balance Transfer	Bal_Transfer	TASTRUCTUR
Hours Method	Round_Meth_Hrs	TASTRUCTUR
Round To Hours	Round_To_Hrs	TASTRUCTUR
Earnings Method	Round_Meth_Ern	TASTRUCTUR
Round To Earnings	Round_To_Ern	TASTRUCTUR
Date Stamp	Date_Stamp	TASTRUCTUR
Time Stamp	Time_Stamp	TASTRUCTUR
Table Basis	Table_Basis	TAPLAN
Earning Lia Type	Ern_Lia_Type	TAGENLEDGR
Earning Lia Table	Ern_Lia_Tbl	TAGENLEDGR
Earning Srv Cls	Ern_Srv_Cls	TAPAYROLL
Earning Pyo Srv CD	Ern_Pyo_Srv_CD	TAPAYROLL
Hours Lia Table	Hrs_Lia_Tbl	TAGENLEDGR
Hours Lia Type	Hrs_Lia_Type	TAGENLEDGR
Hours Pyo Srv CD	Hrs_Pyo_Srv_CD	TAPAYROLL
Hours Srv Cls	Hrs_Srv_Cls	TAPAYROLL
Carry Earning Table	Carry_Ern_Tbl	TALIMIT
Carry Hours Table	Carry_Hrs_Tbl	TALIMIT
Balance Type	Balance_Type	TAPLAN
Balance Limit Type	Bal_Limit_Type	TALIMIT
Balance Hours Table	Bal_Hrs_Tbl	TALIMIT
Balance Earning Table	Bal_Ern_Tbl	TALIMIT
Allot Occur	Allot_Occur	TAACCRUAL
Allot Hours Table	Allot_Hrs_Tbl	TAACCRUAL
Allot Eligible Rel	Allot_Elig_Rel	TAACCRUAL
Allot Earning Table	Allot_Ern_Tbl	TAACCRUAL
Acrlim Hours Table	Allot_Hrs_Tbl	TAACCRUAL
Acrlim Earning Table	Acrlim_Hrs_Tbl	TALIMIT
Acr Limit Type	Acr_Limit_Type	TALIMIT
Accr Hours Table	Accr_Hrs_Tbl	TAACCRUAL
Accr Earning Table	Accr_Ern_Tbl	TAACCRUAL

Service Rule


Attribute or measure name	Table field	Archive source table
Company	COMPANY	TASERVRULE
Service Rule	SERVICE_RULE	TASERVRULE
Service Rule Description	DESCRIPTION	TASERVRULE
Date	SRV_DT_CD	TASERVRULE
Date User Field	SRV_USER_DT	TASERVRULE
Calendar Date	SRV_DATE	TASERVRULE
Waiting Period Start	WAIT_START	TASERVRULE
Waiting Period	WAIT_PERIOD	TASERVRULE
Unit	WAIT_UNIT	TASERVRULE
Wait Service Class	WAIT_SRV_CLS	TASERVRULE
Hours Type	HOURS_TYPE	TASERVRULE
Date Flag	SRV_DT_FLAG	TASERVRULE
Nearest Point	NEAREST_POINT	TASERVRULE
Point 1	SRV_POINT_01	TASERVRULE
Point 2	SRV_POINT_02	TASERVRULE
Point 3	SRV_POINT_03	TASERVRULE
Point 4	SRV_POINT_04	TASERVRULE
Point 5	SRV_POINT_05	TASERVRULE
Point 6	SRV_POINT_06	TASERVRULE
Point 7	SRV_POINT_07	TASERVRULE
Point 8	SRV_POINT_08	TASERVRULE
Point 9	SRV_POINT_09	TASERVRULE
Point 10	SRV_POINT_10	TASERVRULE
Point 11	SRV_POINT_11	TASERVRULE
Point 12	SRV_POINT_12	TASERVRULE
Point 13	SRV_POINT_13	TASERVRULE
Pay Cycle Adjust	PAY_CYCLE_AD	TASERVRULE

Service Code Listing


Attribute or measure name	Table field	Archive source table
Company	Company	TASERVCODE
Service Code	Service_Code	TASERVCODE
Description	Description	TASERVCODE
Event	Event	TASERVCODE
Reason Code	Reason_Code	TASERVCODE
Currency Code	Currency_Code	TASERVCODE
Status	Status	TASERVCODE

Service Class and Code


Attribute or measure name	Table field	Archive source table
Company	COMPANY	TASERVICE
Service Code	SERVICE_CODE	TASERVICE
Service Code Description	ServiceCodeDescription	TASERVCODE
Service Class	SERVICE_CLASS	TASERVICE
Service Class Description	ServiceClassDescription	TASERVCLSS
Reason Code	REASON_CODE	TASERVCODE
Currency Code	CURRENCY_CODE	TASERVCODE

Vendor Group


Attribute or measure name	Table field	Archive source table
Vendor Group	VENDOR_GROUP	APVENGROUP
Vendor Description	DESCRIPTION	APVENGROUP
Vendor Values	NUM_VEN_NBR	APVENGROUP
Automatic Vendor Numbering	AUTO_VENDOR	APVENGROUP
Audit Vendor Changes	VENDOR_AUDIT	APVENGROUP
Manual Payment	MANP_HOLD	APVENGROUP
Credit Balance	CRED_HOLD	APVENGROUP
Prepayment	PREP_HOLD	APVENGROUP
Return on Investment	ROI_HOLD	APVENGROUP
Maximum Payment	MAXP_HOLD	APVENGROUP
Retainage	RET_HOLD	APVENGROUP
Minimum Payment	MINP_HOLD	APVENGROUP
Period Ending Date 1	PER_END_DATE_01	APVENGROUP
Period Ending Date 2	PER_END_DATE_02	APVENGROUP
Period Ending Date 3	PER_END_DATE_03	APVENGROUP
Period Ending Date 4	PER_END_DATE_04	APVENGROUP
Period Ending Date 5	PER_END_DATE_05	APVENGROUP
Period Ending Date 6	PER_END_DATE_06	APVENGROUP
Period Ending Date 7	PER_END_DATE_07	APVENGROUP
Period Ending Date 8	PER_END_DATE_08	APVENGROUP
Period Ending Date 9	PER_END_DATE_09	APVENGROUP
Period Ending Date 10	PER_END_DATE_10	APVENGROUP
Period Ending Date 11	PER_END_DATE_11	APVENGROUP
Period Ending Date 12	PER_END_DATE_12	APVENGROUP
Period Ending Date 13	PER_END_DATE_13	APVENGROUP
Vendor Class	VEN_CLASS	APVENCLASS
Vendor Class Description	VendorClassDescription	APVENCLASS
Currency Code	CURRENCY_CODE	APVENCLASS
Posting Option	POST_OPTION	APVENCLASS
Income Code	INCOME_CODE	APVENCLASS
Tax Code	TAX_CODE	APVENCLASS
Tax Usage Code	TAX_USAGE_CD	APVENCLASS
Tax Override	TAX_OVERRIDE	APVENCLASS
Distribution Code	DIST_CODE	APVENCLASS
Invoice Handling Code	HANDLING_CODE	APVENCLASS
Validate Purchase Order	VALIDATE_PO	APVENCLASS
Require Purchase Order	REQUIRE_PO	APVENCLASS
Cash Code	CASH_CODE	APVENCLASS
Payment Code	BANK_INST_CODE	APVENCLASS
Payment Priority	VEN_PRIORITY	APVENCLASS
Zero Payments Allowed	ZERO_CHECK	APVENCLASS
Zero Payment Code	ZERO_PMT_CODE	APVENCLASS
Maximum Payment Amount	MAX_PMT_AMT	APVENCLASS
Maximum Hold Code	MAX_PMT_HOLD	APVENCLASS
Minimum Payment Amount	MIN_PMT_AMT	APVENCLASS
Minimum Hold Code	MIN_PMT_HOLD	APVENCLASS
Enclosure	ENCLOSURE	APVENCLASS
Match Prepay	MTCH_PREPAY_FL	APVENCLASS
Match Prepay Method	MTCH_PREPAY_MT	APVENCLASS
MSCM Sync Flag	RETAIL_FLAG	APVENCLASS
EAM Vendor Flag	EAM_VEN_FL	APVENCLASS
Match Table	MATCH_TABLE	APVENCLASS
Rule Group	RULE_GROUP	APVENCLASS

Vendor Master Record


Attribute or measure name	Table field	Archive source table
Vendor Group	VENDOR_GROUP	APVENMAST
Vendor	VENDOR	APVENMAST
Vendor Vname	VENDOR_VNAME	APVENMAST
Location Code	LOCATION_CODE	APVENADDR
Location Type	LOC_TYPE	APVENLOC
Bank Code	BANK_CODE	APVENMAST
Bank Id	BANK_ID	APVENMAST
Vendor Class	VEN_CLASS	APVENMAST
Vendor Status	VENDOR_STATUS	APVENMAST
Processing Group	PROC_GRP	APVENMAST
Carrier Flag	CARRIER_FLAG	APVENMAST
Tax ID	TAX_ID	APVENMAST
Chk Dig Type	CHK_DIG_TYPE	APVENMAST
Pay Vendor	PAY_VENDOR	APVENMAST
Effective Date	EFFECTIVE_DATE	APVENADDR
Address Line 1	ADDR1	APVENADDR
Address Line 2	ADDR2	APVENADDR
Address Line 3	ADDR3	APVENADDR
Address Line 4	ADDR4	APVENADDR
City	CITY_ADDR5	APVENADDR
State Or Province	STATE_PROV	APVENADDR
Postal Code	POSTAL_CODE	APVENADDR
Country	COUNTRY	APVENADDR
Region	REGION	APVENADDR
Vendor Sname	VENDOR_SNAME	APVENMAST
Legal Name	LEGAL_NAME	APVENMAST
Vendor Contact	VENDOR_CONTCT	APVENMAST
Telephone Country Code	PHONE_PREFIX	APVENMAST
Telephone Number	PHONE_NUM	APVENMAST
Telephone Extension Number	PHONE_EXT	APVENMAST
Mobile Number	MOBILE_NUM	APVENMAST
Mobile Extension Number	MOBILE_EXT	APVENMAST
Fax Country Code	FAX_PREFIX	APVENMAST
Fax Machine Number	FAX_NUM	APVENMAST
Fax Extension	FAX_EXT	APVENMAST
Vendor Account	VEND_ACCT	APVENMAST
Gln Nbr	GLN_NBR	APVENMAST
Email Address	E_MAIL_ADDRESS	APVENMAST
URL Address	URL_ADDR	APVENMAST
Invoice Handling Code	HANDLING_CODE	APVENMAST
Term Code	TERM_CODE	APVENMAST
Invoice Accrual Code	ACCR_CODE	APVENMAST
Cash Code	CASH_CODE	APVENMAST
Ret Accr Code	RET_ACCR_CODE	APVENMAST
Payment Code	BANK_INST_CODE	APVENMAST
Distribution Code	DIST_CODE	APVENMAST
Discount Code	DISCOUNT_CODE	APVENLOC
Authority Code	AUTH_CODE	APVENMAST
Invoice Group	INVOICE_GROUP	APVENMAST
Income Code	INCOME_CODE	APVENMAST
Tax Code	TAX_CODE	APVENMAST
For Econ Code	FOR_ECON_CODE	APVENMAST
Activity	ACTIVITY	APVENMAST
Account Category	ACCT_CATEGORY	APVENMAST
Diverse Code	DIVERSE_CODE	APVENMAST
Balance Currency	BAL_CURRENCY	APVENMAST
Invoice Currency	INV_CURRENCY	APVENMAST
Currency Recalculation	CURR_RECALC	APVENMAST
Hold Code	CLAIM_HOLD_CD	APVENMAST
Vendor Priority	VEN_PRIORITY	APVENMAST
Chargeback Hold Code	CB_HOLD_CODE	APVENMAST
Active Status	ACTIVE_STATUS	APVENLOC
Enclosure	ENCLOSURE	APVENMAST
Match Table	MATCH_TABLE	APVENMAST
Rule Group	RULE_GROUP	APVENMAST
Discount Calculation Date	DISC_CALC_DATE	APVENMAST
Float Days	FLOAT_DAYS	APVENMAST
Validate Po	VALIDATE_PO	APVENMAST
Require Po	REQUIRE_PO	APVENMAST
Valid Cert Dt	VALID_CERT_DT	APVENMAST
Creation Date	CREATE_DATE	APVENMAST
Language Code	LANGUAGE_CODE	APVENMAST
Charge Code	CHARGE_CODE	APVENMAST
Origin Date	ORIGIN_DATE	APVENMAST
Minimum Claim Amount	CB_MINIMUM_AMT	APVENMAST
Write Off Amount	WRITE_OFF_AMT	APVENLOC

Employee


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
Employee Name	LAST_NAME, FIRST_NAME, MIDDLE_INIT	EMPLOYEE
Social Security Number	FICA_NBR	EMPLOYEE
Employee Status	EMP_STATUS	EMPLOYEE
Date Hired	DATE_HIRED	EMPLOYEE
Adjusted Hire Date	ADJ_HIRE_DATE	EMPLOYEE
Anniversary Date	ANNIVERS_DATE	EMPLOYEE
First Day Worked	FST_DAY_WORKED	EMPLOYEE
Last Day Paid	LAST_DAY_PAID	EMPLOYEE
Process Level	PROCESS_LEVEL	EMPLOYEE
Department	DEPARTMENT	EMPLOYEE
Work Country	WORK_COUNTRY	EMPLOYEE
Position	R_POSITION	EMPLOYEE
Job Code	JOB_CODE	EMPLOYEE
Supervisor	SUPERVISOR	EMPLOYEE
Salary Class	SALARY_CLASS	EMPLOYEE
Pay Frequency	PAY_FREQUENCY	EMPLOYEE
Pay Rate	PAY_RATE	EMPLOYEE
Schedule	SCHEDULE	EMPLOYEE
Pay Grade	PAY_GRADE	EMPLOYEE
Pay Step	PAY_STEP	EMPLOYEE
Annual Hours	ANNUAL_HOURS	EMPLOYEE
Shift	SHIFT	EMPLOYEE
Automatic Deposit	AUTO_DEPOSIT	EMPLOYEE
Home Acct Unit	HM_ACCT_UNIT	EMPLOYEE
Home Account	HM_ACCOUNT	EMPLOYEE
Home Sub Account	HM_SUB_ACCT	EMPLOYEE
Security Level	SEC_LVL	EMPLOYEE
City	CITY	EMPLOYEE
Work State	WORK_STATE	EMPLOYEE
Work City	WORK_CITY	EMPLOYEE
Stand Amount	STAND_AMT	EMPLOYEE
HICN	HICN	EMPLOYEE

Employee Dependent


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMDEPEND
Employee	EMPLOYEE	EMDEPEND
Sequence Number	SEQ_NBR	EMDEPEND
Dependent SSN Number	FICA_NBR	EMDEPEND
Dependent Name	LAST_NAME,FIRST_NAME,MIDDLE_INIT	EMDEPEND
Active Flag	ACTIVE_FLAG	EMDEPEND
Address Type	EMP_ADDRESS	EMDEPEND
Relation Code	REL_CODE	EMDEPEND
Consent	CONSENT	EMDEPEND
Address 1	ADDR1	EMDEPEND
City	CITY	EMDEPEND
State	STATE	EMDEPEND
Zip	ZIP	EMDEPEND
Country Code	COUNTRY_CODE	EMDEPEND
Home Phone Country	HM_PHONE_CNTRY	EMDEPEND
Home Phone Number	HM_PHONE_NBR	EMDEPEND
Work Phone Country	WK_PHONE_CNTRY	EMDEPEND
Work Phone Extension	WK_PHONE_EXT	EMDEPEND
Dependent Type	DEP_TYPE	EMDEPEND
Birth Date	BIRTHDATE	EMDEPEND
Adoption Date	ADOPTION_DATE	EMDEPEND
Placement Date	PLACEMENT_DATE	EMDEPEND
Gender	SEX	EMDEPEND
Smoker	SMOKER	EMDEPEND
HICN	HICN	EMDEPEND
Disabled	DISABLED	EMDEPEND
Deceased	DECEASED	EMDEPEND
Death Date	DEATH_DATE	EMDEPEND
Prior Months Coverage	PRIOR_COV_MO	EMDEPEND
Established Patient	ESTAB_PATIENT	EMDEPEND
Health Coverage	HL_COV_FLAG	EMDEPEND
Dental Coverage	DN_COV_FLAG	EMDEPEND
Dependent Life Coverage	DL_COV_FLAG	EMDEPEND
Vs Coverage Flag	VS_COV_FLAG	EMDEPEND

Employee Emergency Contact


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAEMERGCNT
Employee	EMPLOYEE	PAEMERGCNT
Sequence Number	SEQ_NBR	PAEMERGCNT
Last Name	LAST_NAME	PAEMERGCNT
First Name	FIRST_NAME	PAEMERGCNT
Address 1	ADDR1	PAEMERGCNT
City	CITY	PAEMERGCNT
State	STATE	PAEMERGCNT
ZIP	ZIP	PAEMERGCNT
Country Code	COUNTRY_CODE	PAEMERGCNT
Relationship	RELATIONSHIP	PAEMERGCNT
Home Phone Country	HM_PHONE_CNTRY	PAEMERGCNT
Home Phone Number	HM_PHONE_NBR	PAEMERGCNT
Work Phone Country	WK_PHONE_CNTRY	PAEMERGCNT
Work Phone Number	WK_PHONE_NBR	PAEMERGCNT
Last Updated Date	DATE_STAMP	PAEMERGCNT

Employee Multiple Positions and Jobs


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAEMPPOS
Employee	EMPLOYEE	PAEMPPOS
Position	R_POSITION	PAEMPPOS
Position Level	POS_LEVEL	PAEMPPOS
FTE Number	FTE	PAEMPPOS
Effect Date	EFFECT_DATE	PAEMPPOS
End Date	END_DATE	PAEMPPOS
Job Code	JOB_CODE	PAEMPPOS
Process Level	PROCESS_LEVEL	PAEMPPOS
Department	DEPARTMENT	PAEMPPOS
User Level	USER_LEVEL	PAEMPPOS
Location Code	LOCAT_CODE	PAEMPPOS
Supervisor	SUPERVISOR	PAEMPPOS
Supervisor Indirect	SUPERVISOR_IND	PAEMPPOS
Date Assign	DATE_ASSIGN	PAEMPPOS
Work Schedule	WORK_SCHED	PAEMPPOS
Schedule	SCHEDULE	PAEMPPOS
Pay Grade	PAY_GRADE	PAEMPPOS
Pay Step	PAY_STEP	PAEMPPOS
Expense Company	EXP_COMPANY	PAEMPPOS
Expense Acct Unit	EXP_ACCT_UNIT	PAEMPPOS
Expense Account	EXP_ACCOUNT	PAEMPPOS
Expense Sub Account	EXP_SUB_ACCT	PAEMPPOS
Activity	ACTIVITY	PAEMPPOS
Account Category	ACCT_CATEGORY	PAEMPPOS
Position Effective Date	POS_EFF_DT	PAEMPPOS
Last Updated Date	DATE_STAMP	PAEMPPOS
Time Stamp	TIME_STAMP	PAEMPPOS
User Id	USER_ID	PAEMPPOS
Currency Code	CURRENCY_CODE	PAEMPPOS
Currency Nd	CURR_ND	PAEMPPOS
Base Currency	BASE_CURRENCY	PAEMPPOS
Base Nd	BASE_ND	PAEMPPOS
Bargain Unit	BARGAIN_UNIT	PAEMPPOS
Union Code	UNION_CODE	PAEMPPOS
PEP Pay Rate	PAY_RATE	PAEMPPOS
PEP Annual Hours	ANNUAL_HOURS	PAEMPPOS
Prorated Salary	PRO_RATE_A_SAL	PAEMPPOS
Base Pay Rate	BASE_PAY_RATE	PAEMPPOS
User Amount	USER_AMOUNT	PAEMPPOS

Employee Medical and Work Description


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAMEDICAL
Employee	EMPLOYEE	PAMEDICAL
Type	TYPE	PAMEDICAL
Code	CODE	PAMEDICAL
Begin Date	BEG_DATE	PAMEDICAL
End Date	END_DATE	PAMEDICAL
Sequence Number	SEQ_NBR	PAMEDICAL
Create Date	CREATE_DATE	PAMEDICAL
Create Time	CREATE_TIME	PAMEDICAL
Last Updated Date	DATE_STAMP	PAMEDICAL
Time Stamp	TIME_STAMP	PAMEDICAL

Employee Codes


Attribute or measure name	Table field	Archive source table
Acquired Date	DATE_ACQUIRED	EMPCODES
Asset Number	PA_ASSET_NBR	EMPCODES
Base Currency	BASE_CURRENCY	EMPCODES
Base Nd	BASE_ND	EMPCODES
Co Sponsored	CO_SPONSORED	EMPCODES
Company	COMPANY	EMPCODES
Component	COMPONENT	EMPCODES
Currency Code	CURRENCY_CODE	EMPCODES
Currency Nd	CURR_ND	EMPCODES
Description	DESCRIPTION	EMPCODES
Employee	EMPLOYEE	EMPCODES
In Process Flag	IN_PRO_FLAG	EMPCODES
Instructor	INSTRUCTOR	EMPCODES
LIC Number	LIC_NUMBER	EMPCODES
Object Identifier	OBJ_ID	EMPCODES
State	STATE	EMPCODES
Employee Applicant Indicator	EMP_APP	EMPCODES
Per Rating	PER_RATING	EMPCODES
Priority Code	PRIORITY_CODE	EMPCODES
Proficiency Level	PROFIC_LEVEL	EMPCODES
Renew Date	RENEW_DATE	EMPCODES
Renewal Code	RENEWAL_CODE	EMPCODES
Returned Date	DATE_RETURNED	EMPCODES
Sequence Number	SEQ_NBR	EMPCODES
Skill Source	SKILL_SOURCE	EMPCODES
Subject	SUBJECT	EMPCODES
Type	TYPE	EMPCODES
User ID	USER_ID	EMPCODES
Verified Flag	VERIFIED_FLAG	EMPCODES
Base Amount	BASE_AMOUNT	EMPCODES
Cost	COST	EMPCODES
Property Value	PROP_VALUE	EMPCODES
Date Stamp	DATE_STAMP	EMPCODES
Code	CODE	EMPCODES

Employee Performance Review


Attribute or measure name	Table field	Archive source table
Review Date	ACTUAL_DATE	REVIEW
Reviewer	BY_EMPLOYEE	REVIEW
Review Type	CODE	REVIEW
Company	COMPANY	REVIEW
Last Updated Date	DATE_STAMP	REVIEW
Employee	EMPLOYEE	REVIEW
First Name	FIRST_NAME	REVIEW
Last Name	LAST_NAME	REVIEW
Last Review Date	LAST_REVIEW	REVIEW
Middle Initial	MIDDLE_INIT	REVIEW
Next Review Date	NEXT_REVIEW	REVIEW
Next Review Type	NEXT_REV_CODE	REVIEW
Rating	RATING	REVIEW
Review Schedule	REV_SCHEDULE	REVIEW
Scheduled Review Date	SCHED_DATE	REVIEW
Sequence Number	SEQ_NBR	REVIEW
Time Stamp	TIME_STAMP	REVIEW
User Id	USER_ID	REVIEW
Description	DESCRIPTION	REVIEW
Goal Score	GOAL_SCORE	REVIEW
Goal Weighting	GOAL_WEIGHTING	REVIEW
Percentile	PERCENTILE	REVIEW
Performance Score	PERF_SCORE	REVIEW
Performance Weighting	PERF_WEIGHTING	REVIEW
Total Score	TOTAL_SCORE	REVIEW

Personnel Action History


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PERSACTHST
Employee	EMPLOYEE	PERSACTHST
Action Code	ACTION_CODE	PERSACTHST
Action Number	ACTION_NBR	PERSACTHST
Action Type	ACTION_TYPE	PERSACTHST
Effect Date	EFFECT_DATE	PERSACTHST
Reason 01	REASON_01	PERSACTHST
Reason 02	REASON_02	PERSACTHST
Position Level	POS_LEVEL	PERSACTHST
Anticipated End Date	ANT_END_DATE	PERSACTHST
Error Flag	ERROR_FLAG	PERSACTHST
Last Updated Date	DATE_STAMP	PERSACTHST

Employee Rate History Report


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PRRATEHIST
Employee	EMPLOYEE	PRRATEHIST
Begin Date	BEG_DATE	PRRATEHIST
Sequence Number	SEQ_NBR	PRRATEHIST
Actual Obj Id	ACT_OBJ_ID	PRRATEHIST
User Id	USER_ID	PRRATEHIST
Last Updated Date	DATE_STAMP	PRRATEHIST
Time Stamp	TIME_STAMP	PRRATEHIST
Salary Class	SALARY_CLASS	PRRATEHIST
Position Level	POS_LEVEL	PRRATEHIST
Currency Code	CURRENCY_CODE	PRRATEHIST
Currency Nd	CURR_ND	PRRATEHIST
Base Currency	BASE_CURRENCY	PRRATEHIST
Base Nd	BASE_ND	PRRATEHIST
FTE Number	NBR_FTE	PRRATEHIST
Pay Rate	PAY_RATE	PRRATEHIST
Annual Salary	ANNUAL_SALARY	PRRATEHIST
Base Pay Rate	BASE_PAY_RATE	PRRATEHIST
Annual Hours	ANNUAL_HOURS	PRRATEHIST
Percentage change	ANNUAL_SALARY	PRRATEHIST

Grievance Disciplinary Actions


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAGRDI
Employee	EMPLOYEE	PAGRDI
Type	TYPE	PAGRDI
Action Number	GRIEV_DIS_NBR	PAGRDI
Description	DESCRIPTION	PAGRDI
Action Category	GRIEV_DIS_CAT	PAGRDI
Report Date	REPORT_DATE	PAGRDI
Report By Name	REPORT_BY_NAME	PAGRDI
Action Status	GRIEV_DIS_STAT	PAGRDI
Outcome	OUTCOME	PAGRDI
Outcome Date	OUTCOME_DATE	PAGRDI
GDA Days Out	DAYS_OUT	PAGRDI
GDA Cost	COST	PAGRDI
Comment	COMMENT	PAGRDI
Process Level	PROCESS_LEVEL	PAGRDI
Department	DEPARTMENT	PAGRDI
Job Code	JOB_CODE	PAGRDI
Employee Supervisor	SUPERVISOR_EMP	PAGRDI
Location Code	LOCAT_CODE	PAGRDI
Shift	SHIFT	PAGRDI
Contact Number	CONTACT_NBR	PAGRDI
Contact Name	CONTACT_NAME	PAGRDI
Phone	PHONE	PAGRDI
Phone Extension	PHONE_EXT	PAGRDI
GDA Base Amount	BASE_AMOUNT	PAGRDI
STATUS	STATUS	PAGRDISTEP
FOLLOW_CAT	FOLLOW_CAT	PAGRDISTEP
FOLLOW_TYPE	FOLLOW_TYPE	PAGRDISTEP
PERFORMED_BY	PERFORMED_BY	PAGRDISTEP
Action Date	R_DATE	PAGRDI
Time Stamp	TIME_STAMP	PAGRDI
Last Updated Date	DATE_STAMP	PAGRDI
Currency Nd	CURR_ND	PAGRDI
Base Nd	BASE_ND	PAGRDI

Positions


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAPOSITION
Position	R_POSITION	PAPOSITION
User ID	USER_ID	PAPOSITION
Position Status	POSIT_STATUS	PAPOSITION
Supervisor	SUPERVISOR	PAPOSITION
Supervisor Link	SUPERVISOR_LNK	PAPOSITION
Indirect Supervisor	SUPERVISOR_IND	PAPOSITION
Schedule	SCHEDULE	PAPOSITION
Work Schedule	WORK_SCHED	PAPOSITION
Shift	SHIFT	PAPOSITION
Salary Class	SALARY_CLASS	PAPOSITION
Security Level	SEC_LVL	PAPOSITION
Process Level	PROCESS_LEVEL	PAPOSITION
Job Code	JOB_CODE	PAPOSITION
Department	DEPARTMENT	PAPOSITION
Description	DESCRIPTION	PAPOSITION
Location Code	LOCAT_CODE	PAPOSITION
Account Category	ACCT_CATEGORY	PAPOSITION
Activity	ACTIVITY	PAPOSITION
Object ID	OBJ_ID	PAPOSITION
Update Flag	UPDATE_FLAG	PAPOSITION
Time Stamp	TIME_STAMP	PAPOSITION
Pay Step	PAY_STEP	PAPOSITION
Pay Grade	PAY_GRADE	PAPOSITION
Pay Frequency	PAY_FREQUENCY	PAPOSITION
Base Nd	BASE_ND	PAPOSITION
Change Reason	CHG_REASON	PAPOSITION
OT Plan Code	OT_PLAN_CODE	PAPOSITION
Last updated Date	L_ATPOS_SS_SW	PAPOSITION
Expense Sub Account	EXP_SUB_ACCT	PAPOSITION
Expense Company	EXP_COMPANY	PAPOSITION
Expense Account Unit	EXP_ACCT_UNIT	PAPOSITION
Expense Account	EXP_ACCOUNT	PAPOSITION
Exempt Employee	EXEMPT_EMP	PAPOSITION
End Date	END_DATE	PAPOSITION
Effect Date	EFFECT_DATE	PAPOSITION
Create User	CREATE_USER	PAPOSITION
Currency Nd	CURR_ND	PAPOSITION
CreateTime	CREATE_TIME	PAPOSITION
Create Date	CREATE_DATE	PAPOSITION
PAP Annual Hours	ANNUAL_HOURS	PAPOSITION
PAP Base Pay Rate	BASE_PAY_RATE	PAPOSITION
PAP Pay Rate	PAY_RATE	PAPOSITION

Training History Report


Attribute or measure name	Table field	Archive source table
Employee	EMPLOYEE	PATRNHIST
Company	COMPANY	PATRNHIST
Object ID	OBJ_ID	PATRNHIST
Rating	RATING	PATRNHIST
Course	COURSE	PATRNHIST
Completed Date	DATE_COMPLETED	PATRNHIST
Complete Status	COMPLETE_STATS	PATRNHIST
CEU Awarded	CEU_AWARDED	PATRNHIST

Employee ACH Account


Attribute or measure name	Table field	Archive source table
Account	EBNK_ACCT_NBR	EMACHDEPST
Account Type	ACCOUNT_TYPE	EMACHDEPST
ACH Distribution Number	ACH_DIST_NBR	EMACHDEPST
Bank	DESCRIPTION	EMACHDEPST
Begin Date	BEG_DATE	EMACHDEPST
Company	COMPANY	EMACHDEPST
Country	COUNTRY_CODE	EMACHDEPST
Deduction Cycle 01	DED_CYCLE_01	EMACHDEPST
Deduction Cycle 02	DED_CYCLE_02	EMACHDEPST
Deduction Cycle 03	DED_CYCLE_03	EMACHDEPST
Deduction Cycle 04	DED_CYCLE_04	EMACHDEPST
Deduction Cycle 05	DED_CYCLE_05	EMACHDEPST
Deduction Cycle 06	DED_CYCLE_06	EMACHDEPST
Deduction Cycle 07	DED_CYCLE_07	EMACHDEPST
Deduction Cycle 08	DED_CYCLE_08	EMACHDEPST
Deduction Cycle 09	DED_CYCLE_09	EMACHDEPST
Default ACH Account	DEFAULT_FLAG	EMACHDEPST
Distribution Order	ACH_DIST_ORDER	EMACHDEPST
Employee	EMPLOYEE	EMACHDEPST
End Date	END_DATE	EMACHDEPST
Payables To	PAYABLE_TO	EMACHDEPST
Payment Description	CHECK_DESC	EMACHDEPST
Prenotify Status	ACH_PRENOTIFY	EMACHDEPST
Receiving DFI	EBANK_ID	EMACHDEPST
Automatic Deposit	AUTO_DEPOSIT	EMPLOYEE
Flat Amount	DEPOSIT_AMT	EMACHDEPST
Percent of Net	NET_PERCENT	EMACHDEPST
Flat Amount	DEPOSIT_AMT	EMACHDEPST
Percent of Net	NET_PERCENT	EMACHDEPST

Employee Deductions


Attribute or measure name	Table field	Archive source table
Arrears	ARREARS	EMDEDMASTR
Balance Type	BALANCE_TYPE	EMDEDMASTR
Calculation Type	CALC_TYPE	DEDCODE
Company	COMPANY	EMDEDMASTR
Country	COUNTRY_CODE	DEDCODE
Deduction Code	DED_CODE	EMDEDMASTR
Deduction Cycle 01	DED_CYCLE_01	EMDEDMASTR
Deduction Cycle 02	DED_CYCLE_02	EMDEDMASTR
Deduction Cycle 03	DED_CYCLE_03	EMDEDMASTR
Deduction Cycle 04	DED_CYCLE_04	EMDEDMASTR
Deduction Cycle 05	DED_CYCLE_05	EMDEDMASTR
Deduction Cycle 06	DED_CYCLE_06	EMDEDMASTR
Deduction Cycle 07	DED_CYCLE_07	EMDEDMASTR
Deduction Cycle 08	DED_CYCLE_08	EMDEDMASTR
Deduction Cycle 09	DED_CYCLE_09	EMDEDMASTR
Deduction Priority	DED_PRIORITY	EMDEDMASTR
Employee	EMPLOYEE	EMDEDMASTR
End Date	END_DATE	EMDEDMASTR
Formula Number	FORMULA_NUMBER	EMDEDMASTR
Payment Description	CHECK_DESC	DEDCODE
Sequence Number	SEQ_NBR	EMDEDMASTR
Effective Date	EFFECT_DATE	EMDEDMASTR
Amount	NEXT_AMOUNT	EMDEDMASTR
Additional Amount	AMOUNT_2	EMDEDMASTR
Exclude Amount	EXCLUDE_AMT	EMDEDMASTR
Internal Amount	BALANCE_AMT	EMDEDMASTR
Monthly Limit	MONTHLY_LIMIT	EMDEDMASTR
Pay Period Limit	PAY_PRD_LIMIT	EMDEDMASTR

Employee Garnishments


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PREMPGARN
Employee	EMPLOYEE	PREMPGARN
Case Number	CASE_NUMBER	PREMPGARN
File Number	FILE_NUMBER	PREMPGARN
Description	R_DESC	PREMPGARN
Tax ID Code	TAX_ID_CODE	PREMPGARN
Type	TYPE	PREMPGARN
Deduction Code	DED_CODE	PREMPGARN
Sequence Number	SEQ_NBR	PREMPGARN
Fees Deduction Code	FEES_DED_CODE	PREMPGARN
Fees Sequence Number	FEES_SEQ_NBR	PREMPGARN
Fees Override	FEES_OVERRIDE	PREMPGARN
EGM Clearhouse Fee	CLEARHOUSE_FEE	PREMPGARN
Number of Dependents	NUM_OF_DEP	PREMPGARN
Second Family	SND_FAMILY	PREMPGARN
Head of Family	HEAD_OF_FAM	PREMPGARN
EGM Original Balance	ORIG_BALANCE	PREMPGARN
Vendor	VENDOR	PREMPGARN
EGM Amount	NEXT_AMOUNT	EMDEDMASTR
EGM Monthly Limit	MONTHLY_LIMIT	EMDEDMASTR
EGM Amount 2	AMOUNT_2	EMDEDMASTR
EGM Exclude Amount	EXCLUDE_AMT	EMDEDMASTR
Balance Type	BALANCE_TYPE	EMDEDMASTR
EGM Internal Amount	BALANCE_AMT	EMDEDMASTR
Deduction Priority	DED_PRIORITY	EMDEDMASTR
Sub priority	SUB_PRIORITY	EMDEDMASTR
Effective Date	EFFECT_DATE	EMDEDMASTR
End Date	END_DATE	EMDEDMASTR
Deduction Cycle 01	DED_CYCLE_01	EMDEDMASTR
Deduction Cycle 02	DED_CYCLE_02	EMDEDMASTR
Deduction Cycle 03	DED_CYCLE_03	EMDEDMASTR
Deduction Cycle 04	DED_CYCLE_04	EMDEDMASTR
Deduction Cycle 05	DED_CYCLE_05	EMDEDMASTR
Deduction Cycle 06	DED_CYCLE_06	EMDEDMASTR
Deduction Cycle 07	DED_CYCLE_07	EMDEDMASTR
Deduction Cycle 08	DED_CYCLE_08	EMDEDMASTR
Deduction Cycle 09	DED_CYCLE_09	EMDEDMASTR
Levy Year	LEVY_YEAR	EMDEDMASTR
Filing Status	FILING_STATUS	EMDEDMASTR
Levy Exempts	LEVY_EXEMPTS	EMDEDMASTR
Additional Standard Exemptions	ADDL_STD_DED	EMDEDMASTR
Remit To Code	REMIT_TO_CODE	PREMPGARN
Over 12 Weeks	OVER_12_WEEKS	EMDEDMASTR
Deduct from Garnishment	DED_FROM_GARN	EMDEDMASTR
Arrears Deduction Code	ARR_DED_CODE	PREMPGARN
Arrears Sequence Number	SEQ_NBR	EMDEDMASTR
Arrear Balance Amount	BAL_AMT(Arrear Type)	EMDEDMASTR
Arrears Balance Type	BAL_TYPE(Arrear Type)	EMDEDMASTR
Arrear Original Balance	ORIG_BAL(Arrear Type)	PREMPGARN
Arrear Amount	NEXT_AMT(Arrear Type)	EMDEDMASTR
Arrear Monthly Limit	MNTH_LMT(Arrear Type)	EMDEDMASTR
Arrear Amount 2	AMOUNT_2(Arrear Type)	EMDEDMASTR
Arrear Exclude Amount	EXCL_AMT(Arrear Type)	EMDEDMASTR

Employee Payment Master View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAYMASTR
Employee	EMPLOYEE	PAYMASTR
Check ID	CHECK_ID	PAYMASTR
Payment Date	CHECK_DATE	PAYMASTR
Payment Number	CHECK_NBR	PAYMASTR
Wage Amount	WAGE_AMOUNT	PRTIME
Hours	HOURS	PRTIME
Pay Units	PAY_UNITS	PRTIME
Deduction Code	DED_CODE	PAYDEDUCTN
Deduction Amount	DED_AMT	PAYDEDUCTN

Employee Payment Master View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAYMASTR
Employee	EMPLOYEE	PAYMASTR
Check ID	CHECK_ID	PAYMASTR
Payment Date	CHECK_DATE	PAYMASTR
Period End Date	PER_END_DATE	PAYMASTR
Payment Number	CHECK_NBR	PAYMASTR
Payroll Year	PAYROLL_YEAR	PAYMASTR
Gross Pay	GROSS_PAY	PAYMASTR
Net Pay	NET_PAY_AMT	PAYMASTR
Wage Amount	WAGE_AMOUNT	PRTIME
Hours	HOURS	PRTIME
Pay Units	PAY_UNITS	PRTIME
Deduction Code	DED_CODE	PAYDEDUCTN
Deduction Amount	DED_AMT	PAYDEDUCTN
PDL Tax Deductions	CASE WHEN dd.ADJUST_PAY='S' AND dd.CALC_TYPE='T' THEN coalesce(pd.DED_AMT,0.00) ELSE 0.00 END	PAYDEDUCTN
PDL Company Deductions	CASE WHEN dd.ADJUST_PAY='C' THEN coalesce(pd.DED_AMT,0.00) ELSE 0.00 END	PAYDEDUCTN
PDL Other Deductions	CASE WHEN dd.ADJUST_PAY='S' AND dd.CALC_TYPE <> 'T' THEN coalesce(pd.DED_AMT,0.00) ELSE 0.00 END	PAYDEDUCTN

Employee Payment Master View 3


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PAYMASTR
Payment Date	CHECK_DATE	PAYMASTR
Employee	EMPLOYEE	PAYMASTR
Employee Name	IF [DA_HR11Employee.LAST_NAME] IS NOT NULL THEN IF [DA_HR11Employee.FIRST_NAME] IS NOT NULL THEN [Employee Name] = trim([DA_HR11Employee.LAST_NAME] + ', '+ [DA_HR11Employee.FIRST_NAME] + ' ' + IFNULL([DA_HR11Employee.MIDDLE_INIT],'')) ELSE [Employee Name] = trim([DA_HR11Employee.LAST_NAME] + ' '+ IFNULL([DA_HR11Employee.MIDDLE_INIT],'')) END IF END IF	EMPLOYEE
Item Name	IF [DA_PR51PayStubInquiry.TYPE] <> 'Earnings' THEN [Item Name] = [DA_PR51PayStubInquiry.DED_CODE] + ' '+ [DA_PR51PayStubInquiry.CHECK_DESC] ELSE IF ([DA_PR51PayStubInquiry.CHECK_DESC] IS NULL) THEN [Item Name] = [DA_PR51PayStubInquiry.PAY_SUM_GRP] + ' ' + [DA_PR51PayStubInquiry.DESCRIPTION] ELSE [Item Name] = [DA_PR51PayStubInquiry.PAY_SUM_GRP] + ' ' + [DA_PR51PayStubInquiry.CHECK_DESC] END IF END IF	PAYDEDUCTN, PAYSUMGRP, DEDCODE
PSI Hours	ifnull([DA_PR51PayStubInquiry.HOURS],0.0)	PRTIME
PSI Deduction Amount	DED_AMT	PAYDEDUCTN
PSI Wage Amount	ifnull([DA_PR51PayStubInquiry.WAGE_AMOUNT],0.0)	PRTIME
PSI Taxable Wages	TAX_WAGES	PAYDEDUCTN
PSI Pay Units	ifnull([DA_PR51PayStubInquiry.PAY_UNITS],0.0)	PRTIME
PDL Gross Pay	GROSS_PAY	PAYMASTR
PDL Net Pay	NET_PAY_AMT	PAYMASTR

Activity Budget Header


Attribute or measure name	Table field	Archive source table
Activity Group	ACTIVITY_GRP	ACBUDHDR
Activity Group Description	AGP_DESC	ACACTGRP
Activity	ACTIVITY	ACBUDHDR
Activity Description	ACV_DESC	ACACTIVITY
Budget Number	BUDGET_NBR	ACBUDHDR
Begin Date	BEGIN_DATE	ACBUDHDR
End Date	END_DATE	ACBUDHDR
Calculation Date	CALC_DATE	ACBUDHDR
Maintenance Date	MAINT_DATE	ACBUDHDR
Lock	LOCK	ACBUDHDR
Life Only	LIFE_ONLY	ACBUDHDR
Round Type	ROUND_TYPE	ACBUDHDR
Active Status	ACTIVE_STATUS	ACACTGRP
Total Budget	TOTAL_BUDGET	ACBUDHDR
Var Levels	VAR_LEVELS	ACACTIVITY
Budget Header Description	BDH_DESC	ACBUDHDR
Security Code	SECURITY_CD	ACACTGRP
Posting Flag	POSTING_FLAG	ACACTIVITY
Level Depth	LEVEL_DEPTH	ACACTIVITY
Contract	CONTRACT	ACACTIVITY
Billable Flag	BILLABLE_FLAG	ACACTIVITY
Accounting Unit	ACCT_UNIT	ACACTIVITY
Active Budget	ACTIVE_BUD	ACACTIVITY

Activity Transaction View 1


Attribute or measure name	Table field	Archive source table
Acct Category	ACCT_CATEGORY	ACACCTCAT
Activity	ACTIVITY	ACTRANS
Billing Method	BILLING_METHOD	ACBILL
Company	COMPANY	ACTRANS
Fiscal Year	FISCAL_YEAR	ACTRANS
Acct Unit	ACCT_UNIT	ACTRANS
Activity Grp	ACTIVITY_GRP	ACTRANS
Begin Date	BEGIN_DATE	ACTRANS
Contract	CONTRACT	ACTRANS
Currency Code	CURRENCY_CODE	ACACTIVITY
End Date	END_DATE	ACACTIVITY
Obj Id	OBJ_ID	ACTRANS
Level Detail 01	LEVEL_DETAIL_01	ACACTIVITY
Level Detail 02	LEVEL_DETAIL_02	ACACTIVITY
Level Detail 03	LEVEL_DETAIL_03	ACACTIVITY
Level Detail 04	LEVEL_DETAIL_04	ACACTIVITY
Level Depth	LEVEL_DEPTH	ACACTIVITY
User Status	USR_STATUS	ACACTIVITY
Var Level Disp	VAR_LEVEl_DISP	ACACTIVITY
Var Levels	VAR_LEVELS	ACACTIVITY
Active Status	ACTIVE_STATUS	ACACTGRP
Security CD	SECURITY_CD	ACACTGRP
Level Size 01	LEVEL_SIZE_01	ACACTGRP
Level Size 02	LEVEL_SIZE_02	ACACTGRP
Level Size 03	LEVEL_SIZE_03	ACACTGRP
Level Size 04	LEVEL_SIZE_04	ACACTGRP
Level Size 05	LEVEL_SIZE_05	ACACTGRP
Account	ACCOUNT	ACTRANS
Act Amount	ACT_AMOUNT	ACTRANS
Act Base Rate	ACT_BASERATE	ACTRANS
Act Currency	ACT_CURRENCY	ACTRANS
Act ND	ACT_ND	ACTRANS
Ag Amount	AG_AMOUNT	ACTRANS
Ag Base Rate	AG_BASERATE	ACTRANS
Ag Currency	AG_CURRENCY	ACTRANS
Ag ND	AG_ND	ACTRANS
Control Grp	CONTROL_GROUP	ACTRANS
Posting Date	POSTING_DATE	ACTRANS
Reference	REFERENCE	ACTRANS
Rpt Amount 1	RPT_AMOUNT_1	ACTRANS
Rpt Amount 2	RPT_AMOUNT_2	ACTRANS
Source code	SOURCE_CODE	ACTRANS
Sub Account	SUB_ACCOUNT	ACTRANS
System	SYSTEM	ACTRANS
Tran Amount	TRAN_AMOUNT	ACTRANS
Tran Currency	TRAN_CURRENCY	ACTRANS
Tran ND	TRAN_ND	ACTRANS
Units Amount	UNITS_AMOUNT	ACTRANS
Capital Flag	CAPITAL_FLAG	ACACCTCATX
Mark Up Pct	MARK_UP_PCT	ACACCTCATX
Revenue Flag	REVENUE_FLAG	ACACCTCATX
Sum Acct Cat	SUM_ACCT_CAT	ACACCTCATX
Customer	CUSTOMER	ACTRANS
Asset	ASSET	ACTRANS
Asset Template	ASSET_TEMPLATE	ACTRANS
Account	ACCOUNT	ACTRANS
Sub Account	SUB_ACCOUNT	ACTRANS
Resource Type	RESOURCE_TYPE	ACASSIGN
Resource Code	RESOURCE_CODE	ACASSIGN
Description	DESCRIPTION	ACASSIGN
Po Number	PO_NBR	ADN
Document Number	DOCUMENT_NBR

Activity Transaction View 3


Attribute or measure name	Table field	Archive source table
Activity Group	ACTIVITY_GRP	ACTRANS
Activity	ACTIVITY	ACTRANS
Estimate	ESTIMATE	ACACTIVITY
Fiscal Year	FISCAL_YEAR	ACTRANS
Currency Code	CURRENCY_CODE	ACACTIVITY
Variable Level Display	VAR_LEVEl_DISP	ACACTIVITY
Usr Status	USR_STATUS	ACACTIVITY
Begin Date	BEGIN_DATE	ACACTIVITY
End Date	END_DATE	ACACTIVITY
Active Budget	ACTIVE_BUD	ACACTIVITY
Company	COMPANY	ACTRANS
Accounting Unit	ACCT_UNIT	ACTRANS
Account	ACCOUNT	ACTRANS
Sub Account	SUB_ACCOUNT	ACTRANS
Account Category	ACCT_CATEGORY	ACTRANS
Account Category Description	AccountCategoryDescription	ACACCTCAT
Active Status	ACTIVE_STATUS	ACACTGRP
Activity Group Currency	AG_CURRENCY	ACTRANS
System	SYSTEM	ACTRANS
Summary Account Category	SUM_ACCT_CAT	ACACCTCATX
Security Cd	SECURITY_CD	ACACTGRP
Revenue Flag	REVENUE_FLAG	ACTRANS
Resource Type	RESOURCE_TYPE	ACTRANS
Resource Code	RESOURCE_CODE	ACTRANS
Description	DESCRIPTION	ACASSIGN
Posting Flag	POSTING_FLAG	ACACTIVITY
Po Number	PO_NBR	ACADDLCNTR
Period	PERIOD	ACTRANS
Mark Up Percent	MARK_UP_PCT	ACACCTCATX
Level Depth	LEVEL_DEPTH	ACACTIVITY
Level Detail 1	LEVEL_DETAIL_01	ACACTIVITY
Document Number	DOCUMENT_NBR	ACCNTRACT
Customer	CUSTOMER	ACCNTRACT
Currency Table	Currency_Table	ACACTGRP
Contract	CONTRACT	ACACTIVITY
Category Type	CATEGORY_TYPE	ACACCTCAT
Capital Flag	CAPITAL_FLAG	ACACCTCATX
Calendar Name	Calendar_Name	ACACTGRP
Budget Tolerance	Bud_Tolerance	ACACTGRP
Billable Flag	BILLABLE_FLAG	ACACTIVITY
Billing Method	BILLING_METHOD	ACBILL
Base Nd	Base_Nd	ACACTGRP
Asset	ASSET	ACAMCODE
Asset Template	ASSET_TEMPLATE	ACAMCODE
Variable Levels	VAR_LEVELS	ACACTIVITY
Activity Group Amount	AG_AMOUNT	ACTRANS
Units Amount	UNITS_AMOUNT	ACTRANS
Posting Date	POSTING_DATE	ACTRANS
Status	STATUS	ACTRANS
Resource Description	RESOURCE_DESC	ACTRANS
Object Id	OBJ_ID	ACTRANS
Level Detail 2	LEVEL_DETAIL_02	ACACTIVITY
Level Detail 3	LEVEL_DETAIL_03	ACACTIVITY
Level Detail 4	LEVEL_DETAIL_04	ACACTIVITY

Activity Budget


Attribute or measure name	Table field	Archive source table
Activity group	ACTIVITY_GRP	ACBUDDTL
Activity	ACTIVITY	ACBUDDTL
Budget Nbr	BUDGET_NBR	ACBUDDTL
Begin Date	BEGIN_DATE	ACACTIVITY
End Date	END_DATE	ACACTIVITY
Lock	LOCK	ACBUDHDR
Total Budget	TOTAL_BUDGET	ACBUDHDR
Currency Code	CURRENCY_CODE	ACBUDHDR
Rate Value	RATE_VALUE	ACBUDHDR
Acct Category	ACCT_CATEGORY	ACBUDDTL
Balance	BALANCE	ACBUDDTL
Fiscal Year	FISCAL_YEAR	ACBUDDTL
Spread Code	SPREAD_CODE	ACBUDDTL
Compute Name	COMPUTE_NAME	ACBUDDTL
Fiscal Period	NA
Company	COMPANY	ACACTIVITY
Acct Unit	ACCT_UNIT	ACACTIVITY
AC Period End Date	NA
Active Status	ACTIVE_STATUS	ACACTGRP
Asset Template	ASSET_TEMPLATE	ACAMCODE
Asset	ASSET	ACAMCODE
Var Levels	VAR_LEVELS	ACACTIVITY
Base Nd	BASE_ND	ACACTGRP
Category Type	CATEGORY_TYPE	ACACCTCAT
Billable Flag	BILLABLE_FLAG	ACACTIVITY
Billing Method	BILLING_METHOD	ACBILL
Calendar Name	CALENDAR_NAME	ACACTGRP
Capital Flag	CAPITAL_FLAG	ACACCTCATX
Contract	CONTRACT	ACACTIVITY
Level Depth	LEVEL_DEPTH	ACACTIVITY
Level Detail 01	LEVEL_DETAIL_01	ACACTIVITY
Level Detail 02	LEVEL_DETAIL_02	ACACTIVITY
Level Detail 03	LEVEL_DETAIL_03	ACACTIVITY
Level Detail 04	LEVEL_DETAIL_04	ACACTIVITY
Level Size 01	LEVEL_SIZE_01	ACACTGRP
Level Size 02	LEVEL_SIZE_02	ACACTGRP
Level Size 03	LEVEL_SIZE_03	ACACTGRP
Level Size 04	LEVEL_SIZE_04	ACACTGRP
Level Size 05	LEVEL_SIZE_05	ACACTGRP
Mark Up Pct	MARK_UP_PCT	ACACCTCATX
Num Decimals	NUM_DECIMALS	ACBUDHDR
Posting Flag	POSTING_FLAG	ACACTIVITY
Revenue Flag	REVENUE_FLAG	ACACCTCATX
Security Id	SECURITY_CD	ACACTGRP
Sum Acct Cat	SUM_ACCT_CAT	ACACCTCATX
User Status	USR_STATUS	ACACTIVITY
Var Level Disp	VAR_LEVEl_DISP	ACACTIVITY
AC Budget Amount	PERIOD_AMT_1-13	ACBUDDTL
AC Budget Amount YTD	NA

Activity Transaction View 2


Attribute or measure name	Table field	Archive source table
Activity Group	ACTIVITY_GRP	ACACTIVITY
Activity	ACTIVITY	ACTRANS
Variable Level Display	VAR_LEVEL_DISP	ACACTIVITY
Currency Code	CURRENCY_CODE	ACACTIVITY
Category Type	CATEGORY_TYPE	ACTRANS
Account Category	ACCT_CATEGORY	ACTRANS
Fiscal Year	FISCAL_YEAR	ACTRANS
Period	PERIOD	ACTRANS
Company	COMPANY	ACTRANS
Accounting Unit	ACCT_UNIT	ACACTIVITY
Account	ACCOUNT	ACTRANS
Sub Account	SUB_ACCOUNT	ACTRANS
Activity Amount	ACT_AMOUNT	ACTRANS
Balance Unit	BALANCE_UNIT	ACCOMMIT
Balance Amount	BALANCE_AMOUNT	ACCOMMIT
Transaction Amount	TRAN_AMOUNT	ACTRANS
Units Amount	UNITS_AMOUNT	ACTRANS
Summary Account Category	SUM_ACCT_CAT	ACACCTCATX
Transaction Description	DESCRIPTION	ACTRANS
Asset Number	ASSET	ACAMCODE
Asset Template	ASSET_TEMPLATE	ACAMCODE
Billing Method	BILLING_METHOD	ACCNTRACT
System	SYSTEM	ACTRANS
User Status	USR_STATUS	ACACTIVITY
PO Number	PO_NBR	ACADDLCNTR
Resource Code	RESOURCE_CODE	ACTRANS
Active Status	ACTIVE_STATUS	ACACTGRP
Variable Levels	VAR_LEVELS	ACACTIVITY
Security Code	SECURITY_CD	ACACTGRP
Posting Flag	POSTING_FLAG	ACACTIVITY
Revenue Flag	REVENUE_FLAG	ACACCTCATX
Resource Type	RESOURCE_TYPE	ACTRANS
Customer	CUSTOMER	ACCNTRACT
Billable Flag	BILLABLE_FLAG	ACACTIVITY
Capitalization Flag	CAPITAL_FLAG	ACACCTCATX
Document Number	DOCUMENT_NBR	ACCNTRACT
Level Depth	LEVEL_DEPTH	ACACTIVITY
Level Size_01	LEVEL_SIZE_01	ACACTGRP
Level Size_02	LEVEL_SIZE_02	ACACTGRP
Level Size_03	LEVEL_SIZE_03	ACACTGRP
Level Size_04	LEVEL_SIZE_04	ACACTGRP
Level Size_05	LEVEL_SIZE_05	ACACTGRP
Mark up Percent	MARK_UP_PCT	ACACCTCATX
Level Detail_01	LEVEL_DETAIL_01	ACACTIVITY
Level Detail_02	LEVEL_DETAIL_02	ACACTIVITY
Level Detail_03	LEVEL_DETAIL_03	ACACTIVITY
Level Detail_04	LEVEL_DETAIL_04	ACACTIVITY
Level Detail_05	LEVEL_DETAIL_05	ACACTIVITY
Begin Date	BEGIN_DATE	ACACTIVITY
End Date	END_DATE	ACACTIVITY
Contract	CONTRACT	ACACTIVITY
Calendar Name	CALENDAR_NAME	ACACTGRP

Employee Absence Plan View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	TAEEMASTER
Employee	EMPLOYEE	TAEEMASTER
Plan	R_PLAN	TAEEMASTER
Employee Group	EMPLOYEE_GROUP	TAEEMASTER
Position	R_POSITION	TAEEMASTER
Master Entry	MASTR_ENTRY	TAEEMASTER
Master Elig End	MSTR_ELIG_END	TAEEMASTER
Master End	MSTR_END	TAEEMASTER
Master Override	MSTR_OVERRIDE	TAEEMASTER
Srv Begin Date	SRV_BEGIN_DT	TAEEMASTER
Accr Begin Date	ACCR_BEGIN_DT	TAEEMASTER
Accr Start Date	ACCR_START_DT	TAEEMASTER
Accr Last Date	ACCR_LAST_DT	TAEEMASTER
Allot Begin Date	ALLOT_BEGIN_DT	TAEEMASTER
Allot Last Date	ALLOT_LAST_DT	TAEEMASTER
Allot Point	ALLOT_POINT	TAEEMASTER
Elig Begin Date	ELIG_BEGIN_DT	TAEEMASTER
Elig Last Date	ELIG_LAST_DT	TAEEMASTER
Reset Last Date	RESET_LAST_DT	TAEEMASTER
Reset Point	RESET_POINT	TAEEMASTER
Lst Per Date Hrs	LST_PER_DT_HRS	TAEEMASTER
Lst Per Date Ern	LST_PER_DT_ERN	TAEEMASTER
Avail Hrs Bal	AVAIL_HRS_BAL	TAEEMASTER
Accr Hrs Bal	ACCR_HRS_BAL	TAEEMASTER
Allot Hrs Bal	ALLOT_HRS_BAL	TAEEMASTER
Resrv Hrs Bal	RESRV_HRS_BAL	TAEEMASTER
Avail Ern Bal	AVAIL_ERN_BAL	TAEEMASTER
Accr Ern Bal	ACCR_ERN_BAL	TAEEMASTER
Allot Ern Bal	ALLOT_ERN_BAL	TAEEMASTER
Resrv Ern Bal	RESRV_ERN_BAL	TAEEMASTER
Carryover End	CARRYOVER_END	TAEEMASTER
Carry Hrs Bal	CARRY_HRS_BAL	TAEEMASTER
Carry Ern Bal	CARRY_ERN_BAL	TAEEMASTER
OV Carry Hrs A	OV_CARRY_HRS_A	TAEEMASTER
OV Carry Ern A	OV_CARRY_ERN_A	TAEEMASTER
Hrs Accr Co	HRS_ACCR_CO	TAEEMASTER
Hrs Accr Unit	HRS_ACCR_UNIT	TAEEMASTER
Hrs Accr Acct	HRS_ACCR_ACCT	TAEEMASTER
Hrs Accr Sub	HRS_ACCR_SUB	TAEEMASTER
Hrs Exp Co	HRS_EXP_CO	TAEEMASTER
Hrs Exp Acct	HRS_EXP_ACCT	TAEEMASTER
Hrs Exp Sub	HRS_EXP_SUB	TAEEMASTER
Hrs Activity	HRS_ACTIVITY	TAEEMASTER
Hrs Acct Cat	HRS_ACCT_CAT	TAEEMASTER
Ern Accr Co	ERN_ACCR_CO	TAEEMASTER
Ern Accr Unit	ERN_ACCR_UNIT	TAEEMASTER
Ern Accr Acct	ERN_ACCR_ACCT	TAEEMASTER
Ern Accr Sub	ERN_ACCR_SUB	TAEEMASTER
Ern Exp Co	ERN_EXP_CO	TAEEMASTER
Ern Exp Acct	ERN_EXP_ACCT	TAEEMASTER
Ern Exp Unit	ERN_EXP_UNIT	TAEEMASTER
Ern Exp Sub	ERN_EXP_SUB	TAEEMASTER
Ern Activity	ERN_ACTIVITY	TAEEMASTER
Ern Acct Cat	ERN_ACCT_CAT	TAEEMASTER
OV Accr Hrs	OV_ACCR_HRS	TAEEMASTER
OV Accr Ern	OV_ACCR_ERN	TAEEMASTER
OV Allot Hrs	OV_ALLOT_HRS	TAEEMASTER
OV Allot Ern	OV_ALLOT_ERN	TAEEMASTER
OV Bal Hrs	OV_BAL_HRS	TAEEMASTER
OV Bal Ern	OV_BAL_ERN	TAEEMASTER
OV Acrlim Hrs	OV_ACRLIM_HRS	TAEEMASTER
OV Acrlim Ern	OV_ACRLIM_ERN	TAEEMASTER
OV Carry Hrs T	OV_CARRY_HRS_T	TAEEMASTER
OV Hrs Lia	OV_CARRY_HRS_T	TAEEMASTER
OV Ern Lia	OV_ERN_LIA,	TAEEMASTER
OV Hrs Neg Lmt	OV_HRS_NEG_LMT	TAEEMASTER
OV Hrs Link TB	OV_HRS_LINK_TB	TAEEMASTER
OV Hrs Pro Ord	OV_HRS_PRO_ORD,	TAEEMASTER
OV Hrs Neg Bal	OV_HRS_NEG_BAL	TAEEMASTER
OV Hrs Neg Web	OV_HRS_NEG_WEB	TAEEMASTER
OV Hrs Unpd CD	OV_HRS_UNPD_CD	TAEEMASTER
OV Ern Neg Lmt	OV_ERN_NEG_LMT	TAEEMASTER
OV Ern Link TB	OV_ERN_LINK_TB	TAEEMASTER
OV Ern Pro Ord	OV_ERN_PRO_ORD	TAEEMASTER
OV Ern Neg Bal	OV_ERN_NEG_BAL	TAEEMASTER
OV Ern Neg Web	OV_ERN_NEG_WEB	TAEEMASTER

Employee Transaction Detail View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	TAEMPTRANS
EMPLOYEE	EMPLOYEE	TAEMPTRANS
EMPLOYEE_GROUP	EMPLOYEE_GROUP	TAEMPTRANS
R_PLAN	R_PLAN	TAEMPTRANS
R_DATE	R_DATE	TAEMPTRANS
STATUS	STATUS	TAEMPTRANS
TRAN_TYPE	TRAN_TYPE	TAEMPTRANS
DESCRIPTION	DESCRIPTION	TAEMPTRANS
TA_TYPE	TA_TYPE	TAEMPTRANS
TA_LOS_CALC	TA_LOS_CALC	TAEMPTRANS
SEQ_NBR	SEQ_NBR	TAEMPTRANS
R_POSITION	R_POSITION	TAEMPTRANS
MASTR_ENTRY	MASTR_ENTRY	TAEEMASTER
MSTR_ELIG_END	MSTR_ELIG_END	TAEEMASTER
ACCR_LAST_DT	ACCR_LAST_DT	TAEEMASTER
MSTR_END	MSTR_END	TAEEMASTER
LST_PER_DT_HRS	LST_PER_DT_HRS	TAEEMASTER
LST_PER_DT_ERN	LST_PER_DT_ERN	TAEEMASTER
ACCR_HRS_BAL	ACCR_HRS_BAL	TAEEMASTER
ACCR_ERN_BAL	ACCR_ERN_BAL	TAEEMASTER
AVAIL_HRS_BAL	AVAIL_HRS_BAL	TAEEMASTER
AVAIL_ERN_BAL	AVAIL_ERN_BAL	TAEEMASTER
BEG_ACCR_BAL	BEG_ACCR_BAL	TATRANSUM
YTD_ADJ_AVAIL	YTD_ADJ_AVAIL	TATRANSUM
YTD_USE_AVAIL	YTD_USE_AVAIL	TATRANSUM
YTD_LSTACCROL	YTD_LSTACCROL	TATRANSUM
END_ACCR_BAL	END_ACCR_BAL	TATRANSUM

Warehouse Demand View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	ITEMLOC
Location	LOCATION	ITEMLOC
Item	ITEM	ITEMLOC
Stock On Hand Quantity	SOH_QTY	ITEMLOC
Warehouse Demand Quantity	QUANTITY	WHDEMAND
System Code	SYSTEM_CD	WHDEMAND
Document Number	DOC_NBR	WHDEMAND
Line Number	LINE_NBR	WHDEMAND
Expected Ship Date	EST_TRAN_DT	WHDEMAND
Requesting Location	REQ_LOCATION	WHDEMAND

Inventory Transaction View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	ITEMLOC
Location	LOCATION	ITEMLOC
Item	ITEM	ITEMLOC
Document Type	DOC_TYPE	ICTRANS
Bin	BIN	ICTRANS
Quantity	QUANTITY	ICTRANS
System CD	SYSTEM_CD	ICTRANS
Document	DOCUMENT	ICTRANS
Update Time	UPDATE_TIME	ICTRANS
Update Date	UPDATE_DATE	ICTRANS
Soh Qty	SOH_QTY	ICTRANS
Stock Uom	STOCK_UOM	ICTRANS
Unit Cost	UNIT_COST	ICTRANS
Trans Date	TRANS_DATE	ICTRANS
Secondary Qty	SECONDARY_QTY	ICTRANS
Gl Date	GL_DATE	ICTRANS
Reason Code	REASON_CODE	ICTRANS
Reference	REFERENCE	ICTRANS
From To Company	FROM_TO_CMPY	ICTRANS
From To Loc	FROM_TO_LOC	ICTRANS
From To Bin	FROM_TO_BIN	ICTRANS
From Document	FR_DOCUMENT	ICTRANS

Warehouse Demand View 1


Attribute or measure name	Table field	Archive source table
Company	company	ITEMLOC
Item	item	ITEMLOC
Location	location	ITEMLOC
Uom	uom	ITEMLOC
Unalloc Quantity	unalloc_qty	ITEMLOC
Hold Quantity	hold_qty	ITEMLOC
Soh Quantity	soh_qty	ITEMLOC
Alloc Quantity	alloc_qty	ITEMLOC
Onorder Quantity	onorder_qty	ITEMLOC
Secondary Quantity	secondary_qty	ITEMLOC
In Proc Quantity	in_proc_qty	ITEMLOC
Wip Quantity	wip_qty	ITEMLOC
Backord Quantity	backord_qty	ITEMLOC
Intrans Quantity	intrans_qty	ITEMLOC
System cd	system_cd	WHDEMAND
Line Number	Line_nbr	WHDEMAND
Tran Uom	tran_uom	WHDEMAND
Est tran date	est_tran_dt	WHDEMAND
Document Type	doc_type	WHDEMAND
Doc Nbr	doc_nbr	WHDEMAND
Component Sequence	component_seq	WHDEMAND

Item Location View 2


Attribute or measure name	Table field	Archive source table
Company	Company	ITEMLOC
Item	Item	ITEMLOC
location	location	ITEMLOC
Bin	Bin	SOHDETAIL
Line Stock On Hand	SOH_QTY	SOHDETAIL
UOM	UOM	SOHDETAIL
Line Hold Quantity	HOLD_QTY	SOHDETAIL
Lot	LOT	SOHDETAIL
Sublot	SUBLOT	SOHDETAIL
Freeze Flag	FREEZE_FL	SOHDETAIL
Expire Date	EXPIRE_DATE	ICLOT
Last Update Date	LAST_UPD_DT	ITEMLOC
Header Stock on Hand	SOH_QTY	ITEMLOC
Header Hold Quantity	HOLD_QTY	ITEMLOC

Item Location View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	TAEEMASTER
Item	ITEM	TAEEMASTER
Location	LOCATION	TAEEMASTER
Units Of Measure	UOM	TAEEMASTER
Stock On Hand	SOH_QTY	TAEEMASTER
Secondary On Hand	SECONDARY_QTY	TAEEMASTER
Unallocated Quantity	UNALLOC_QTY	TAEEMASTER
Allocated Quantity	ALLOC_QTY	TAEEMASTER
In Process Quantity	IN_PROC_QTY	TAEEMASTER
Backordered Quantity	BACKORD_QTY	TAEEMASTER
Inspection Hold	HOLD_QTY	TAEEMASTER
On Order	ONORDER_QTY	TAEEMASTER
Work In Process	WIP_QTY	TAEEMASTER
Intransit	INTRANS_QTY	TAEEMASTER
Last Update Date	LAST_UPD_DT	TAEEMASTER
Item Location Key	ItemLocationKey	TAEEMASTER

Inventory Transaction View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	ICCOMPANY
Location	LOCATION	ICTRANS
Update Date	UPDATE_DATE	ICTRANS
Transaction Date	TRANS_DATE	ICTRANS
Transaction UOM	TRAN_UOM	ICTRANS
Transaction Counter	TRAN_COUNTER	ICTRANS
Document Type	DOC_TYPE	ICTRANS
Item	ITEM	ICTRANS
Item Group	ITEM_GROUP	ICTRANS
Offset Accounting Unit	OFF_ACCT_UNIT	ICTRANS
Offset Account	OFF_ACCOUNT	ICTRANS
Offset Sub Account	OFF_SUB_ACCT	ICTRANS
Quantity	QUANTITY	ICTRANS
Unit Cost	UNIT_COST	ICTRANS
Bin	BIN	ICTRANS
From OR To Company	FROM_TO_CMPY	ICTRANS
From OR To Bin	FROM_TO_BIN	ICTRANS
Document	DOCUMENT	ICTRANS
GL Date	GL_DATE	ICTRANS
Inventory Account	INV_ACCOUNT	ICTRANS
Inventory Accounting Unit	INV_ACCT_UNIT	ICTRANS
Inventory Sub Account	INV_SUB_ACCT	ICTRANS
Line Number	LINE_NBR	ICTRANS
Reason Code	REASON_CODE	ICTRANS
Reference	REFERENCE	ICTRANS
Secondary Quantity	SECONDARY_QTY	ICTRANS
Shipment Number	SHIPMENT_NBR	ICTRANS
Stock On Hand Quantity	SOH_QTY	ICTRANS
Status	STATUS	ICTRANS
Stock UOM	STOCK_UOM	ICTRANS
Chargeable FL	CHARGEABLE_FL	ITEMLOC

Item Master


Attribute or measure name	Table field	Archive source table
Item Group	ITEM_GROUP	ITEMMAST
Description	DESCRIPTION	ITEMMAST
User Field	USER_FIELD1	ITEMMAST
Generic Name	GENERIC	ITEMMAST
Inventory Major Class	INVEN_MAJCL	ITEMMAST
Inventory Minor Class	INVEN_MINCL	ITEMMAST
Item	ITEM	ITEMMAST
Secondary Description	DESCRIPTION2	ITEMMAST
Brand Name	BRAND_NAME	ICITEMGTIN
Parent GTIN	PARENT_GTIN	ICITEMGTIN
GTIN	GTIN	ICITEMGTIN
UOM	STOCK_UOM	ITEMMAST
Status	STATUS	ICITEMGTIN
Sales Minor Class	SALES_MINCL	ITEMMAST
Sales Major Class	SALES_MAJCL	ITEMMAST
GTIN Full Description	FULL_DESC	ICITEMGTIN
Active Status	ACTIVE_STATUS	ITEMMAST
Added Date	ADDED_DATE	ITEMMAST
Purchase Major Class	PURCH_MAJCL	ITEMMAST
Purchase Minor Class	PURCH_MINCL	ITEMMAST

Asset Transaction


Attribute or measure name	Table field	Archive source table
Company	COMPANY	AMTRANS
Lease Company	LEASE_COMPANY	AMTRANS
Lease	LEASE	AMTRANS
Activity	ACTIVITY	AMTRANS
Acct Category	ACCT_CATEGORY	AMTRANS
Book	BOOK	AMTRANS
Asset	ASSET	AMTRANS
Asset Process	ASSET_PROCESS	AMTRANS
Trans Date	TRANS_DATE	AMTRANS
Trans Amount	TRANS_AMOUNT	AMTRANS
Asset Type	ASSET_TYPE	AMTRANS
Sub Type	SUB_TYPE	AMTRANS
Asset Group	ASSET_GROUP	AMTRANS
Acct Unit	ACCT_UNIT	AMTRANS
Account	ACCOUNT	AMTRANS
Sub Acct	SUB_ACCT	AMTRANS
Acct Group	ACCT_GRP	AMTRANS
Creator Id	CREATOR_ID	AMASSET
Asset Owner	ASSET_OWNER	AMASSET

Asset Book History View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	AMASSET
Book	BOOK	AMASTBOOK
In-service Date	INSRV_DATE	AMASTBOOK
Location Name	LOCATION_NAME	AMASSET
Division	DIVISION	AMASSET
Accounting Unit	ACCT_UNIT	AMASSET
Asset Type	ASSET_TYPE	AMASSET
Sub Type	SUB_TYPE	AMASSET
Asset Group	ASSET_GROUP	AMASSET
Lease	LEASE	AMASSET
Asset	ASSET	AMASTBOOK
Description	DESCRIPTION	AMASSET
Life-to-Date Depreciation	DEPR_LTD	AMASTBOOK
Year-to-Date Depreciation	DEPR_YTD	AMASTBOOK
Account Group	ACCT_GRP	AMASSET
Accounting Unit Group	AU_GROUP	AMAUGROUP
Asset Accounting Unit	AST_ACCT_UNIT	AMAUGROUP
Asset Category	ASSET_CATEGORY	AMASSET
Asset Process	ASSET_PROCESS	AMASSET
Book Status	BOOK_STATUS	AMASTBOOK
Base Number Of Decimals	BASE_ND	AMASSET
Creation Date	CREATION_DATE	AMASSET
Disposal Asset	DSP_ASSET	AMASSET
Disposal Date	DSP_DATE	AMASSETDSP
Disposal Method	DSP_METHOD	AMASSETDSP
Disposal Property	DSP_PROPERTY	AMASSETDSP
Disposal Status	DSP_STATUS	AMASSETDSP
First or Last Flag	FIRST_LAST_FL	AMASTBOOK
Full Partial	FULL_PARTIAL	AMASSETDSP
Method	METHOD	AMASTBOOK
Method Table Year	METH_TABLE_YR	AMASTBOOK
Process Date	PROCESS_DATE	AMASSET
Simulated	SIMULATED	AMASSET
Status	STATUS	AMASSET
Tag Number	TAG_NBR	AMASSET
Tax Exempt	TAX_EXEMPT	AMASSET
Trans Number of Decimals	TRAN_ND	AMASTBOOK
Used	USED	AMASSET
Work-in-Process	WORK_IN_PROC	AMASSET
Salvage Value	SALVAGE_VALUE	AMASTBOOK
Book Basis	BOOK_BASIS	AMASTBOOK
Current Period Depreciation	DEPR_CP	AMASTBOOK
Disposal Depreciation	DSP_DEPR	AMASTBKDSP
Disposal Quantity	DSP_QUANTITY	AMASSETDSP
Item Total Cost Base	IT_TOT_CSTBASE	AMASSET

Asset Book Transactions


Attribute or measure name	Table field	Archive source table
Account	ACCOUNT	AMBKTRANS
Account Category	ACCT_CATEGORY	AMBKTRANS
Accounting Unit	ACCT_UNIT	AMBKTRANS
Activity	ACTIVITY	AMBKTRANS
Asset	ASSET	AMBKTRANS
Book	BOOK	AMBKTRANS
Company	COMPANY	AMBKTRANS
Reference	REFERENCE	AMBKTRANS
Sub Account	SUB_ACCT	AMBKTRANS
Transaction Amount	TRAN_AMOUNT	AMBKTRANS
Trans Number of Decimals	TRAN_ND	AMBKTRANS
Transaction Date	TRANS_DATE	AMBKTRANS
Disposal Date	DSP_DATE	AMASSETDSP
Disposal Property	DSP_PROPERTY	AMASSETDSP
Disposal Quantity	DSP_QUANTITY	AMASSETDSP
Disposal Status	DSP_STATUS	AMASSETDSP
Full Partial	FULL_PARTIAL	AMASSETDSP
Account Group	ACCT_GRP	AMASSET
Asset Group	ASSET_GROUP	AMASSET
Asset Process	ASSET_PROCESS	AMASSET
Asset Type	ASSET_TYPE	AMASSET
Accounting Unit Group	AU_GROUP	AMASSET
Creation Date	CREATION_DATE	AMASSET
Creator ID	CREATOR_ID	AMASSET
Division	DIVISION	AMASSET
Disposal Asset	DSP_ASSET	AMASSET
Lease	LEASE	AMASSET
Location Name	LOCATION_NAME	AMASSET
Activity Object ID	OBJ_ID	AMASSET
Asset Sub Type	SUB_TYPE	AMASSET
Tag Number	TAG_NBR	AMASSET
Currency Code	CURRENCY_CODE	AMASSET
Description	DESCRIPTION	AMASSET

Asset Book History View 1


Attribute or measure name	Table field	Archive source table
Book	BOOK	AMASTBOOK
In-service Date	INSRV_DATE	AMASTBOOK
Company	COMPANY	AMASSET
Location Name	LOCATION_NAME	AMASSET
Division	DIVISION	AMASSET
Asset Type	ASSET_TYPE	AMASSET
Sub Type	SUB_TYPE	AMASSET
Property	PROPERTY	AMASTTYPE
Accounting Unit	ACCT_UNIT	AMASSET
Lease	LEASE	AMASSET
Asset	ASSET	AMASTBOOK
Tag Number	TAG_NBR	AMASSET
Asset Group	ASSET_GROUP	AMASSET
Description	DESCRIPTION	AMASSET
Asset Category	ASSET_CATEGORY	AMASSET
Simulated	SIMULATED	AMASSET
Tax Exempt	TAX_EXEMPT	AMASSET
Used	USED	AMASSET
Convention	CONVENTION	AMASTBOOK
Life	LIFE	AMASTBOOK
Life Remaining	LIFE_REM	AMASTBOOK
Method	METHOD	AMASTBOOK
Book Basis	BOOK_BASIS	AMASTBOOK
Current Period Depreciation	DEPR_CP	AMASTBOOK
Year-to-Date Depreciation	DEPR_YTD	AMASTBOOK
Life-to-Date Depreciation	DEPR_LTD	AMASTBOOK
Method Switched	METH_SWITCHED	AMASTBOOK
Work-in-Process	WORK_IN_PROC	AMASSET
Accounting Unit Group	AU_GROUP	AMASSET
Disposal Date	DSP_DATE	AMASSETDSP
Account Group	ACCT_GRP	AMASSET
Asset Process	ASSET_PROCESS	AMASSET
Book Status	BOOK_STATUS	AMASTBOOK
Creation Date	CREATION_DATE	AMASSET
Current Period Life	LIFE_CP	AMASTBOOK
Disposal Asset	DSP_ASSET	AMASSET
Disposal Method	DSP_METHOD	AMASSETDSP
Disposal Property	DSP_PROPERTY	AMASSETDSP
Disposal Status	DSP_STATUS	AMASSETDSP
First or Last Flag	FIRST_LAST_FL	AMASTBOOK
Full Partial	FULL_PARTIAL	AMASSETDSP
Process Date	PROCESS_DATE	AMASSET
Status	STATUS	AMASSET
Trans Number Of Decimals	TRAN_ND	AMASTBOOK
Depreciation Override	DSP_DEPR_OVRRD	AMASTBKDSP
Disposal Quantity	DSP_QUANTITY	AMASSETDSP

Asset Book History View 3


Attribute or measure name	Table field	Archive source table
Book	BOOK	AMASTBOOK
Currency	CURRENCY_CODE	AMASSET
In-service Date	INSRV_DATE	AMASTBOOK
Lease Company	LEASE_COMPANY	AMASSET
Company	COMPANY	AMASSET
Classification	CLASSIFICATION	AMASSET
Lease	LEASE	AMASSET
Location Name	LOCATION_NAME	AMASSET
Division	DIVISION	AMASSET
Accounting Unit	ACCT_UNIT	AMASSET
Asset Type	ASSET_TYPE	AMASSET
Asset Subtype	SUB_TYPE	AMASSET
Property	PROPERTY	AMASSET
Asset	ASSET	AMASTBOOK
Tag Number	TAG_NBR	AMASSET
Asset Group	ASSET_GROUP	AMASSET
Description	DESCRIPTION	AMASSET
Asset Category	ASSET_CATEGORY	AMASSET
Simulated	SIMULATED	AMASSET
Tax Exempt	TAX_EXEMPT	AMASSET
Used	USED	AMASSET
Convention	CONVENTION	AMASTBOOK
Life	LIFE	AMASTBOOK
Life Remaining	LIFE_REM	AMASTBOOK
Method	METHOD	AMASTBOOK
Book Basis	BOOK_BASIS	AMASTBOOK
Book Value	BOOK_BASIS, DEPR_LTD	AMASTBOOK
Current Period Depreciation	DEPR_CP	AMASTBOOK
Year-to-Date Depreciation	DEPR_YTD	AMASTBOOK
Life-to-Date Depreciation	DEPR_LTD	AMASTBOOK
Method Switched	METH_SWITCHED	AMASTBOOK

Purchase Order Master View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PURCHORDER
PO Date	PO_DATE	PURCHORDER
Vendor	VENDOR	PURCHORDER
Purchase From Location	PURCH_FR_LOC	PURCHORDER
Buyer Code	BUYER_CODE	PURCHORDER
PO Code	PO_CODE	PURCHORDER
PO Number	PO_NUMBER	PURCHORDER
PO Release	PO_RELEASE	PURCHORDER
PO Line Number	Line_nbr	POLINE
Early Delivery Date	EARLY_DL_DATE	POLINE
PO Line Status	POLINE_STATUS	POLINE
Item	ITEM	POLINE
Purchase Majorclass	PURCH_MAJCL	POLINE
Purchase Minorclass	PURCH_MINCL	POLINE
Total Order Amount	TOT_ORDER_AMT	PURCHORDER
Currency Code	CURRENCY_CODE	PURCHORDER
Description	DESCRIPTION	POLINE
Quantity	QUANTITY	POLINE
Vendor Buy Unit Cost	VBUY_UNIT_CST	POLINE
Entered Buy Uom	ENT_BUY_UOM	POLINE
Extended Amount	EXTENDED_AMT	POLINE
Received Quantity	REC_QTY	POLINE
Vendor Item	VEN_ITEM	POLINE
Matched Quantity	MATCHED_QTY	POLINE
Manufacturer Number	MANUF_NBR	POLINE
Location	LOCATION	POLINE
Last Match Unit cost	LST_MATCH_UCST	POLINE
PO Revision	PO_REVISION	PURCHORDER
Default Delivery Date	DFLT_DL_DATE	POLINE
Taxable Flag	TAXABLE_FLAG	POLINE
Tax Code	TAX_CODE	POLINE
Tax Usage Code	TAX_USAGE_CD	POLINE
Taxable Unit Cost	TAXBL_UNT_CST	POLINE
Extended Taxable Amount	EXT_TAXBL_AMT	POLINE
Vendor price Uom	VPRI_UOM	POLINE
Cost Option	COST_OPTION	POLINE
Cancel Quantity	CXL_QTY	POLINE

Vendor Agreement


Attribute or measure name	Table field	Archive source table
Procurement Group	PROCURE_GROUP	POVAGRMTHD
Agreement Item	ITEM	POVAGRMTLN
Agreement Type	AGMT_TYPE	POVAGRMTHD
Line Status	STATUS	POVAGRMTLN
Vendor Agreement Reference	VEN_AGRMT_REF	POVAGRMTHD
Vendor	VENDOR	POVAGRMTHD
Purchase From Location	PURCH_FR_LOC	POVAGRMTHD
Current Net Cost	CURR_NET_CST	POVAGRMTLN
Units Of Measure	UOM	POVAGRMTLN
Currency Code	CURRENCY_CODE	POVAGRMTHD
Line Number	LINE_NBR	POVAGRMTLN
Vendor Item	VEN_ITEM	POVAGRMTLN
Base Cost	BASE_COST	POVAGRMTLN
Description	DESCRIPTION	POVAGRMTHD
Description2	DESCRIPTION2	POVAGRMTHD
Account	ACCOUNT	POVAGRMTLN
Sub Account	SUB_ACCT	POVAGRMTLN
Service Code	SERVICE_CODE	POVAGRMTLN
Requesting Location	REQ_LOCATION	POVAGRMTHD
Quantity	QUANTITY	POVAGRMTLN
Priority	PRIORITY	POVAGRMTHD
Agreement Max Amount	AGRMT_MAX_AMT	POVAGRMTHD
Tax Code	TAX_CODE	POVAGRMTHD
Rebate	REBATE	POVAGRMTHD
Rebate Percent	REBATE_PERCENT	POVAGRMTHD
Expire Date	EXPIRE_DT	POVAGRMTHD
Manufacturer Code	MANUF_CODE	POVAGRMTHD
Manufacturer Division	MANUF_DIVISION	POVAGRMTHD
Manufacturer Number	MANUF_NBR	POVAGRMTLN
Purchase Major Class	PURCH_MAJCL	POVAGRMTLN
Purchase Minor Class	PURCH_MINCL	POVAGRMTLN
Inventory Major Class	INVEN_MAJCL	POVAGRMTLN
Inventory Minor Class	INVEN_MINCL	POVAGRMTLN
Default Account Category	DFLT_ACCT_CAT	POVAGRMTHD
Default Account	DFLT_ACCOUNT	POVAGRMTHD
Default Sub Account	DFLT_SUB_ACCT	POVAGRMTHD
Default Bill Category	DFLT_BILL_CAT	POVAGRMTHD
Review Date	REVIEW_DATE	POVAGRMTHD
Po Number	PO_NUMBER	POVAGRMTHD
Po Code	PO_CODE	POVAGRMTHD
Effective Date	EFFECTIVE_DT	POVAGRMTHD
Buyer	BUYER	POVAGRMTHD
Agreement Admin	AGRMT_ADMIN	POVAGRMTHD

PO Line Item Receivings


Attribute or measure name	Table field	Archive source table
Original Received Quantity	ORIG_REC_QTY	PORECLINE
Reject Quantity	REJECT_QTY	PORECLINE
Purchase From Location	PURCH_FR_LOC	PORECEIVE
Manufacturer Code	MANUF_CODE	POLINE
Manufacturer Division	MANUF_DIVISION	POLINE
Rec Status	REC_STATUS	APINVOICE
Invoice	INVOICE	PORECLINE
Invoice Date	INVOICE_DTE	APINVOICE
Suffix	SUFFIX	PORECLINE
Return Number	RETURN_NUMBER	PORECLINE
Return Line Number	RET_LINE_NBR	PORECLINE
Rec Conversion Rate	REC_CNV_RATE	PORECEIVE
Base Nd	BASE_ND	POCOMPANY
Base Currency Cd	BASE_CURR_CD	POCOMPANY
Agreement Ref	AGREEMENT_REF	POLINE
Catch Wt Quantity	CATCH_WT_QTY	PORECLINE
Matched Quantity	MATCHED_QTY	PORECLINE
Quantity Ordered	QUANTITY	POLINE
Company	COMPANY	PORECLINE
Receiver	REC_NUMBER	PORECLINE
Po Number	PO_NUMBER	PORECLINE
Po Release	PO_RELEASE	PORECLINE
Po Code	PO_CODE	PORECLINE
Receipt Date	REC_DATE	PORECLINE
Item	ITEM	PORECLINE
Location	LOCATION	PORECLINE
Vendor	VENDOR	PORECLINE
Carrier	CARRIER	PORECEIVE
Reference Number	REFERENCE_NO	PORECLINE
Procure Group	PROCURE_GROUP	POCOMPANY
Vendor Item	VEN_ITEM	PORECLINE
Manufacturer Number	MANUF_NBR	POLINE
Buyer Code	BUYER_CODE	PORECEIVE
BOL Number	BOL_NBR	PORECEIVE
Gtin	GTIN	PORECLINE
Line Number	LINE_NBR	PORECLINE
Early Delivery Date	EARLY_DL_DATE	POLINE
Bin	BIN	PORECLINE
Item Type	ITEM_TYPE	PORECLINE
UOM	ENT_REC_UOM	PORECLINE
Cancel BO Flag	CANCEL_BO_FL	PORECLINE
Currency Code	CURRENCY_CODE	PORECEIVE
Match Dtl Key	MATCH_DTL_KEY	PORECLINE
Description	DESCRIPTION	PORECLINE
Match Ref Number	MATCH_REF_NBR	PORECEIVE
Extended Amount	EXTENDED_AMT	PORECLINE
Original Unit Cost	ORIG_UNIT_CST	PORECLINE
Received Quantity	ENT_REC_QTY	PORECLINE
Status	STATUS	POLINE
Operator	OPERATOR	APINVOICE

Purchase Order Master


Attribute or measure name	Table field	Archive source table
Company	Company	Poline
Location	Location	Poline
Buyer Code	Buyer_Code	PURCHORDER
Item	Item	Poline
PO Number	PO_Number	Poline
PO Release	PO_Release	Poline
PO Code	PO_Code	Poline
Early Dl Date	Early_Dl_Date	Poline
Late Dl Date	Late_Dl_Date	Poline
Vendor	Vendor	Poline
Purch Fr Loc	Purch_Fr_Loc	Poline
PliKey	PliKey	Poline
Quantity	Quantity	Poline

Invoice Payment View 3


Attribute or measure name	Table field	Archive source table
Company	COMPANY	APPAYMENT
Vendor Group	VENDOR_GROUP	APPAYMENT
Vendor	VENDOR	APPAYMENT
Invoice	INVOICE	APPAYMENT
Suffix	SUFFIX	APPAYMENT
Cancel Seq	CANCEL_SEQ	APPAYMENT
Check Date	CHECK_DATE	CBCHECK
Serial Number	SERIAL_NUM	CBCHECK
Check Type	CHECK_TYPE	CBCHECK
Void Sequence	VOID_SEQ	APPAYMENT
Trans Ident	TRANS_IDENT	APPAYMENT
Sequence Number	SEQ_NBR	APPAYMENT
Cash Code	CASH_CODE	APPAYMENT
Bank Inst Code	BANK_INST_CODE	APPAYMENT
Tran Chk Amount	TRAN_CHK_AMT	APPAYMENT

Accounts Payable Invoice


Attribute or measure name	Table field	Archive source table
Vendor Group	VENDOR_GROUP	APINVOICE
Description	Description	APINVOICE
Vendor	VENDOR	APINVOICE
Vendor Name	Vendor_Vname	APINVOICE
Invoice	INVOICE	APINVOICE
Suffix	SUFFIX	APINVOICE
Invoice Date	INVOICE_DTE	APINVOICE
Due Date	DUE_DATE	APINVOICE
Invoice Type	INVOICE_Type	APINVOICE
Tran Inv Amt	TRAN_INV_AMT	APINVOICE
Invoice Currency	INV_CURRENCY	APINVOICE
Rec Status	Rec_Status	APINVOICE
Company	COMPANY	APINVOICE
Pay Group	PAY_GROUP	APINVOICE
Process Level	Proc_Level	APINVOICE
Remit To Code	Remit_To_Code	APINVOICE
Purch From Location	Purch_Fr_Loc	APINVOICE
Vendor Values	Num_Ven_Nbr	APINVOICE
Transaction Payment Amount	Tran_Pmt_Amt	APPAYMENT

Invoice Distribution History


Attribute or measure name	Table field	Archive source table
Invoice Accrual Code	ACCR_CODE	APAPDHIST
Account Category	ACCT_CATEGORY	APAPDHIST
Activity	ACTIVITY	APAPDHIST
Base Number of Decimals	BASE_ND	APAPDHIST
Cancel Sequence	CANCEL_SEQ	APAPDHIST
Company	COMPANY	APAPDHIST
Account Category Description	DESCRIPTION	APAPDHIST
Distribution Acc Number	DIS_ACCOUNT	APAPDHIST
Distribution Acc Unit	DIS_ACCT_UNIT	APAPDHIST
Distribution Sub Acc	DIS_SUB_ACCT	APAPDHIST
Distribution Seq Number	DIST_SEQ_NBR	APAPDHIST
Post Date	DISTRIB_DATE	APAPDHIST
Batch Currency	INV_CURRENCY	APAPDHIST
Invoice	INVOICE	APAPDHIST
Base Distribution Amount	ORIG_BASE_AMT	APAPDHIST
Distribution Amount	ORIG_TRAN_AMT	APAPDHIST
Process Level	PROC_LEVEL	APAPDHIST
Invoice Status	REC_STATUS	APAPDHIST
Suffix	SUFFIX	APAPDHIST
Tax Code	TAX_CODE	APAPDHIST
Dist Company Base Amt	TO_BASE_AMT	APAPDHIST
To Base Number of Decimals	TO_BASE_ND	APAPDHIST
Transaction Number of Decimals	TRAN_ND	APAPDHIST
Unit Amount	UNT_AMOUNT	APAPDHIST
Vendor	VENDOR	APAPDHIST
Journal Book	JRNL_BOOK_NBR	APAPIHIST
Currency Number of Decimals	CURR_ND	APCOMPANY
Vendor Group	VENDOR_GROUP	APCOMPANY

AP Payment History View 2


Attribute or measure name	Table field	Archive source table
Company	Company	apapphist
Vendor Group	Vendor_Group	apapphist
Pay Group	Pay_Group	apapphist
Process Level	Proc_Level	apapphist
Cash Code	Cash_Code	apapphist
Vendor	Vendor	apapphist
Invoice Currency	Inv_Currency	apapphist
Transaction Number	Trans_Nbr	apapphist
Transaction Payment Amount	Tran_Pmt_Amt	apapphist
Suffix	Suffix	apapphist
Sequence Number	seq_Nbr	apapphist
Invoice	Invoice	apapphist
Due Date	Due_Date	apapphist
Discount Lost Flag	Disc_Lost_Flg	apapphist
Cancel Sequence	Cancel_Seq	apapphist
Base Amount	Base_Act_Amt	apapphist
Bank Inst Code	Bank_Inst_Code	apapphist
Purch From Location	Purch_fr_loc	apapihist
Invoice Date	Invoice_Dte	apapihist
Voucher Number	Voucher_Nbr	apapihist
Vendor class	Ven_class	apapihist
Check date	Check_date	apapihist

Invoice Payment View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	APPAYMENT
Vendor Group	VENDOR_GROUP	APINVOICE
Vendor	VENDOR	APPAYMENT
Invoice	INVOICE	APINVOICE
Suffix	SUFFIX	APINVOICE
Invoice Type	INVOICE_TYPE	APINVOICE
Transaction Payment Amount	TRAN_PMT_AMT	APPAYMENT
Invoice Currency	INV_CURRENCY	APINVOICE
Transaction ID	TRANS_IDENT	APPAYMENT
Reconcile Date	RECON_DATE	APINVOICE
Sequence Number	SEQ_NBR	APPAYMENT
Void Sequence	VOID_SEQ	APPAYMENT
Payment Number	TRANS_NBR	APPAYMENT
Payment Suffix Number	CHK_SUFFIX	APPAYMENT
Payment Date	CHECK_DATE	APPAYMENT
Payment Code	BANK_INST_CODE	APPAYMENT
Invoice Date	INVOICE_DTE	APINVOICE
Invoice Accrual Code	ACCR_CODE	APINVOICE
Due Date	DUE_DATE	APPAYMENT
Cash Code	CASH_CODE	APPAYMENT
Cancel Sequence	CANCEL_SEQ	APINVOICE
Cancel Date	CANCEL_DATE	APINVOICE
Base Invoice Amount	BASE_INV_AMT	APINVOICE
Base Payment Amount	BASE_PMT_AMT	APPAYMENT
Invoice Transaction Amount	TRAN_INV_AMT	APINVOICE

AP Payment History View 1


Attribute or measure name	Table field	Archive source table
Pay Group	PAY_GROUP	APAPPHIST
Base BOE Amount	BASE_ACT_AMT	APAPPHIST
Cash Code	CASH_CODE	APAPPHIST
Payment Code	BANK_INST_CODE	APAPPHIST
Payment Date	CHECK_DATE	APAPPHIST
Vendor	VENDOR	APAPPHIST
Invoice	INVOICE	APAPPHIST
Suffix	SUFFIX	APAPPHIST
Voucher	VOUCHER_NBR	APAPIHIST
Authority Code	AUTH_CODE	APAPIHIST
Process Level	PROC_LEVEL	APAPPHIST
Due Date	DUE_DATE	APAPPHIST
Discount Date	DISC_DATE	APAPPHIST
Company	COMPANY	APAPPHIST
Sequence Number	SEQ_NBR	APAPPHIST
Payment Number	TRANS_NBR	APAPPHIST
Discount Lost	DISC_LOST_FLG	APAPPHIST
Cancel Sequence	CANCEL_SEQ	APAPPHIST
Transaction Payment Amount	TRAN_PMT_AMT	APAPPHIST

Accounts Payable Cash Payment


Attribute or measure name	Table field	Archive source table
Payment Date	CHECK_DATE	CBCHECK
Post Company	POST_COMPANY	APPAYGROUP
Process Level	PROC_LEVEL	CBCHECK
Company	COMPANY	CBCHECK
Payment Currency	PAY_CURRENCY	CBCHECK
Bank Currency Amount	BANK_CURR_AMT	CBCHECK
Description	DESCRIPTION	CBCASHCODE
Cash Code	CASH_CODE	CBTRANS
Payment Record Origin	CHECK_TYPE	CBCHECK
Payment Code	BANK_INST_CODE	CBCHECK
Payment Number	TRANS_NBR	CBCHECK
Pay Vendor	PAID_VENDOR	CBCHECK
Remit Payment To	REMIT_TO_CODE	CBCHECK
Pay Vendor Name	PAID_NAME	CBCHECK
Reconcile Status	REC_STATUS	CBTRANS
City/Address	CITY_ADDR5	APPROCLEV
Vendor Group	VENDOR_GROUP	CBCHECK
Base Payment Amount	BASE_PMT_AMT	CBCHECK
Transaction Payment Amount	TRAN_PMT_AMT	CBCHECK

Account Payable Invoice View 2


Attribute or measure name	Table field	Archive source table
COMPANY	COMPANY	APINVOICE
PROC LEVEL	PROC_LEVEL	APINVOICE
VENDOR	VENDOR	APINVOICE
INVOICE	INVOICE	APINVOICE
SUFFIX	SUFFIX	APINVOICE
VOUCHER NBR	VOUCHER_NBR	APINVOICE
INVOICE TYPE	INVOICE_TYPE	APINVOICE
BASE INV AMT	BASE_INV_AMT	APINVOICE
CANCEL DATE	CANCEL_DATE	APINVOICE
INV CURRENCY	INV_CURRENCY	APINVOICE
INVOICE DATE	INVOICE_DTE	APINVOICE
DUE DATE	DUE_DATE	APINVOICE
LOCATION	LOCATION	APINVOICE
PO NUMBER	PO_NUMBER	APINVOICE
PO RELEASE	PO_RELEASE	APINVOICE
PO CODE	PO_CODE	APINVOICE
MATCH LEVEL	MATCH_LEVEL	APINVOICE
PAY GROUP	PAY_GROUP	APINVOICE
Payment Number	TRANS_NBR	CBCHECK
CASH CODE	CASH_CODE	APINVOICE
BANK INST CODE	BANK_INST_CODE	APPAYMENT
BASE PMT AMT	BASE_PMT_AMT	APPAYMENT
CHECK DATE	CHECK_DATE	APPAYMENT
PAID VENDOR	PAID_VENDOR	CBCHECK
VBANK IDENT	VBANK_IDENT	APVENMAST
VBANK ACCT NO	VBANK_ACCT_NO	APVENMAST
SERIAL NUM	SERIAL_NUM	CBCHECK
BASE ACT AMT	BASE_ACT_AMT	APPAYMENT
BASE DISC AMT	BASE_DISC_AMT	APPAYMENT
BAL CURRENCY	BAL_CURRENCY	APVENBAL
CUST GROUP	CUST_GROUP	APVENMAST
CUSTOMER	CUSTOMER	APVENMAST
TRAN INV AMT	TRAN_INV_AMT	APINVOICE
CURRENT BAL	CURRENT_BAL	APVENBAL
HIGHEST BAL	HIGHEST_BAL	APVENBAL
DRAFT BAL	DRAFT_BAL	APVENBAL

Invoice Payment View 2


Attribute or measure name	Table field	Archive source table
Company	Company	APPAYMENT
Pay Group	Pay_Group	APPAYMENT
Check date	Check_date	APPAYMENT
Vendor Group	Vendor_Group	APPAYMENT
Invoice Currency	Inv_Currency	APPAYMENT
Transaction Payment Amount	Tran_Pmt_Amt	APPAYMENT
Vendor	Vendor	APPAYMENT
Revalued Base Amount	Base_Act_Amt	APPAYMENT
Sequence Number	seq_Nbr	APPAYMENT
Invoice	Invoice	APPAYMENT
Suffix	Suffix	APPAYMENT
Voucher Number	Voucher_Nbr	APINVOICE
Process Level	Proc_Level	APPAYMENT
Invoice Date	Invoice_Dte	APINVOICE
Payment Number	Trans_Nbr	APPAYMENT
Payment Code	Bank_Inst_Code	APPAYMENT
Cash Code	Cash_Code	APPAYMENT
Discount Lost Flag	Disc_Lost_Flg	APPAYMENT
Due date	Due_date	APPAYMENT
Vendor class	Ven_class	APPAYMENT
Cancel Sequence	Cancel_Seq	APPAYMENT
Purchase from location	Purch_fr_loc	APINVOICE
PO Number	PO_number	APINVOICE
PO Code	PO_Code	APINVOICE
Operator Code	Operator	APINVOICE

Invoice Distribution


Attribute or measure name	Table field	Archive source table
Distribution Company	DIST_COMPANY	APDISTRIB
Process Level	PROC_LEVEL	APDISTRIB
Activity	ACTIVITY	APDISTRIB
Account Category	ACCT_CATEGORY	APDISTRIB
Account Category Description	DESCRIPTION	APDISTRIB
Distribution Sequence Number	DIST_SEQ_NBR	APDISTRIB
Company	COMPANY	APDISTRIB
Post Date	DISTRIB_DATE	APDISTRIB
Invoice Accrual Code	ACCR_CODE	APDISTRIB
Tax Code	TAX_CODE	APDISTRIB
Invoice	INVOICE	APDISTRIB
Suffix	SUFFIX	APDISTRIB
Invoice Type	INVOICE_TYPE	APDISTRIB
Dist Company Base Amt	TO_BASE_AMT	APDISTRIB
Unit Amount	UNT_AMOUNT	APDISTRIB
Vendor	VENDOR	APDISTRIB
Batch Currency	INV_CURRENCY	APDISTRIB
Distribution Amount	ORIG_TRAN_AMT	APDISTRIB
Distribution Account Unit	DIS_ACCT_UNIT	APDISTRIB
Distribution Account Number	DIS_ACCOUNT	APDISTRIB
Distribution Sub Account	DIS_SUB_ACCT	APDISTRIB
Vendor Group	VENDOR_GROUP	APCOMPANY
Currency Number of Decimals	CURR_ND	APCOMPANY
Transaction Number of Decimals	TRAN_ND	APDISTRIB
To Base Number of Decimals	TO_BASE_ND	APDISTRIB
Invoice Status	REC_STATUS	APDISTRIB
Cancel Sequence	CANCEL_SEQ	APDISTRIB
Base Number of Decimals	BASE_ND	APDISTRIB
Base Distribution Amount	ORIG_BASE_AMT	APDISTRIB

Employee Vesting Hours


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
Adj Hire Date	ADJ_HIRE_DATE	EMPLOYEE
Annivers Date	ANNIVERS_DATE	EMPLOYEE
Benefits Date 1	BEN_DATE_1	PAEMPLOYEE
Benefits Date 2	BEN_DATE_2	PAEMPLOYEE
Benefits Date 3	BEN_DATE_3	PAEMPLOYEE
Benefits Date 4	BEN_DATE_4	PAEMPLOYEE
Benefits Date 5	BEN_DATE_5	PAEMPLOYEE
Birthdate	BIRTHDATE	PAEMPLOYEE
Create Date	CREATE_DATE	VESTHOURS
Create Time	CREATE_TIME	VESTHOURS
Create User ID	CREATE_USER_ID	VESTHOURS
Date Hired	DATE_HIRED	EMPLOYEE
Date Stamp	DATE_STAMP	VESTHOURS
Description	R_DESC	R_PLAN
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Last Name Prefix	LAST_NAME_PRE	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
plan	PLAN_CODE	VESTHOURS
Process Level	PROCESS_LEVEL	EMPLOYEE
Sec Level	SEC_LVL	EMPLOYEE
Sec Location	SEC_LOCATION	EMPLOYEE
Senior Date	SENIOR_DATE	PAEMPLOYEE
Start Date	START_DATE	R_PLAN
Suffix	NAME_SUFFIX	EMPLOYEE
Team Date	TERM_DATE	EMPLOYEE
Time Stamp	TIME_STAMP	VESTHOURS
User ID	USER_ID	VESTHOURS
Vest Benefit Flag	VEST_BEF_FLG	R_PLAN
Vest Date	VEST_DATE	R_PLAN
Vest From Date	VEST_FROM_DATE	R_PLAN
Vest Schedule	VEST_SCHED	R_PLAN
Vested Percentage	PCT_VESTED	VESTSCHDDT
Vested plan Year	PLAN_YEAR	VESTHOURS
Serv Year	SERV_YEARS	VESTHOURS
Vested Hours	VEST_HOURS	VESTHOURS
Vested Age	VESTED_AGE	R_PLAN

Benefit Plan


Attribute or measure name	Table field	Archive source table
Company	Company	R_Plan
Plan Type	Plan_Type	R_Plan
Plan Code	Plan_Code	R_Plan
Start Date	Start_Date	R_Plan
Stop Date	Stop_date	R_Plan
Description	R_Desc	R_Plan

Stock Purchase Plan History


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
Benefit Plan Code	PLAN_CODE	BENEFIT
Benefit Start Date	START_DATE	BENEFIT
Contribution	YTD_CONT	BENEFIT
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Last Name Prefix	LAST_NAME_PRE	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Suffix	NAME_SUFFIX	EMPLOYEE
Process Level	PROCESS_LEVEL	EMPLOYEE
Sec Location	SEC_LOCATION	EMPLOYEE
Sec Level	SEC_LVL	EMPLOYEE
Date Purchased	DATE_PURCH	SPHIST
Number of Shares	NBR_SHARES	SPHIST
Prices Per Share	SHARE_PRICE	SPHIST
Benefit Type	PLAN_TYPE	BENEFIT

Employee Benefit View 4


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
plan	PLAN_CODE	BENEFIT
Benefit Type	PLAN_TYPE	BENEFIT
Benefit Start Date	START_DATE	BENEFIT
Benefit Stop Date	STOP_DATE	BENEFIT
Description	R_DESC	R_PLAN
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Name Suffix	NAME_SUFFIX	EMPLOYEE
Process Level	PROCESS_LEVEL	EMPLOYEE
Previous Last Name	LAST_NAME_PRE	EMPLOYEE
Security Level	SEC_LVL	EMPLOYEE
Security Location	SEC_LOCATION	EMPLOYEE

Savings Bond Beneficiary


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
Co-Owner Name	CO_OWNER	BONDBENIF
Date Purchased	DATE_PURCH	BONDBENIF
Description	R_DESC	R_PLAN
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Last Name Prefix	LAST_NAME_PRE	EMPLOYEE
Number Purchased	NBR_PURCH	BENEFIT
Owner Name	OWNER	BONDBENIF
Plan	PLAN_CODE	BONDBENIF
PLane Type	PLAN_TYPE	BENEFIT
Process Level	PROCESS_LEVEL	EMPLOYEE
Savings Bond Number	BOND_NBR	BONDBENIF
Sec Level	SEC_LVL	EMPLOYEE
Sec Location	SEC_LOCATION	EMPLOYEE
Start Date	START_DATE	BONDBENIF
Stop Date	STOP_DATE	BENEFIT
Suffix	NAME_SUFFIX	EMPLOYEE
Cost	BOND_COST	R_PLAN
Contribution	YTD_CONT	BENEFIT

Spending Account Transactions


Attribute or measure name	Table field	Archive source table
Employee Payment Number	CHECK_NBR	RESTRANS
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Reimbursement Date	R_DATE	RESTRANS
Process Level	PROCESS_LEVEL	EMPLOYEE
Start Date	START_DATE	RESTRANS
Plane Code	PLAN_CODE	RESTRANS
Security Level	SEC_LVL	EMPLOYEE
Security Location	SEC_LOCATION	EMPLOYEE
Reimbursement Description	R_DESC	RESTRANS
Reimbursement Amount	TRANS_AMT	RESTRANS

Participant Benefit


Attribute or measure name	Table field	Archive source table
Number of Hours	Nbr_Hours	BENEFIT
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
Plan Type	Plan_Type	PARTBEN
Plan Code	Plan_Code	PARTBEN
Participant	Participnt	PARTBEN
Name	Name	PRSYSTEM
Name Suffix	Name_Suffix	EMPLOYEE
Term Date	Term_Date	EMPLOYEE
Waive Flag	Waive_Flag	R_PLAN
Start Date	Start_Date	PARTBEN
Stop Date	Stop_Date	PARTBEN
Sec Location	Sec_Location	EMPLOYEE
Sec Level	Sec Level	EMPLOYEE
Process Level	Process_Level	EMPLOYEE
Premium Update Date	Prem_Upd_Dt	PARTBEN
Premium Group	Prem_Group	BENEFIT
Pct Amount Flag	Pct_Amt_Flag	BENEFIT
Multiple	Multiple	BENEFIT
Middle Init	Middle_Init	EMPLOYEE
Match Up To	Mtch_Up_To	BENEFIT
Last Name Pre	Last_Name_Pre	EMPLOYEE
Flex Plan	Flex_Plan	BENEFIT
First Name	First_Name	EMPLOYEE
Last Name	Last_Name	EMPLOYEE
Fica Number	Fica_Nbr	EMPLOYEE
Employee Sequence	Employee_Seq	PARTBEN
Display Description	Display_Desc	R_PLAN
Description	R_Desc	R_PLAN
Ded Start Date	Ded_Start_Date	BENEFIT
Ded Stop Date	Ded_Stop_Date	BENEFIT
Currency Flag	Currency_Flag	PARTBEN
Coverage Type	Coverage_Type	R_PLAN
Cover Option	Cov_Option	PARTBEN
Contribution Type	Contrib_Type	R_PLAN
Comp Match	Comp_Match	BENEFIT
Bond Cost	Bond_Cost	R_PLAN
Cover Amount	Cover_Amt	PARTBEN
Dep Cover Amount	Dep_Cover_Amt	BENEFIT
Exc Premium Amount	Exc_Prem_Am	PARTBEN
Pay Period Amount	Pay_Per_Amt	PARTBEN
Cmp Flex Cont]	Cmp_Flx_Cont	BENEFIT
Comp Cont	Comp_Cont	PARTBEN
Emp Aft Cont	Emp_Aft_Cont	BENEFIT
Emp Pre Cont	Emp_Pre_Cont	BENEFIT
Department	DEPARTMENT	EMPLOYEE

Employee Benefit View 5


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Previous Last Name	LAST_NAME_PRE	EMPLOYEE
Middle Initial	MIDDLE_INITIAL	EMPLOYEE
Name Suffix	NAME_SUFFIX	EMPLOYEE
Security Location	SEC_LOCATION	EMPLOYEE
Security Level	SEC_LVL	EMPLOYEE
Process Level	PROCESS_Level	EMPLOYEE
Contribe Type	CONTRIB_TYPE	R_Plan
Coverage Type	COVERAGE_TYPE	R_Plan
Display Desc	DISPLAY_DESC	R_Plan
Flex Pay Code	FLEX_PAY_CODE	R_Plan
Plan Code	PLAN_CODE	BENEFIT
Plan Type	PLAN_TYPE	BENEFIT
Start Date	START_DATE	BENEFIT
Stop Date	STOP_DATE	BENEFIT
After Tax Match Amt Deduction	AFT_DED_MTCH_A	R_Plan
After Tax Amt Deduction	AFT_DED_CODE_A	R_Plan
After Tax Match Per Deduction	AFT_DED_MTCH_P	R_Plan
After Tax Per Deduction	AFT_DED_CODE_P	R_Plan
Company Paid Amt Deduction	CMP_DED_CODE_A	R_Plan
Company Paid Per Deduction	CMP_DED_CODE_P	R_Plan
Pre Tax Amt Deduction	PRE_DED_CODE_A]	R_Plan
Pre Tax Per Decution	PRE_DED_CODE_P	R_Plan
Pre Tax Match Amt Deduction	PRE_DED_MTCH_A	R_Plan
Pre Tax Match Per Deduction	PRE_DED_MTCH_P	R_Plan
Annual Amount	ANNUAL_AMT	BENEFIT
Company Contribution	COMP_CONT	BENEFIT
Coverage Option	COV_OPTION	BENEFIT
Cycles Remain	CYCLES_REMAIN	BENEFIT
Dependent Coverage Amt	DEP_COVER_AMT	BENEFIT
Employee After Tax Contribution	EMP_AFT_CONT	BENEFIT
Employee Pre Tax Contribution	EMP_PRE_CONT	BENEFIT
Flex Contribution	CMP_FLX_CONT	BENEFIT
Cover Amount BN51	COVER_AMT	BENEFIT

Employee Benefit View 6


Attribute or measure name	Table field	Archive source table
Annual Amount	ANNUAL_AMT	BENEFIT
Flex Contribution	CMP_FLX_CONT	BENEFIT
Company Contribution	COMP_CONT	BENEFIT
Company	COMPANY	BENEFIT
Coverage Option	COV_OPTION	BENEFIT
Cover Amount 51	COVER_AMT	BENEFIT
Cycles Remain	CYCLES_REMAIN	BENEFIT
Dependent Coverage Amt	DEP_COVER_AMT	BENEFIT
Employee After Tax Contribution	EMP_AFT_CONT	BENEFIT
Employee Pre Tax Contribution	EMP_PRE_CONT	BENEFIT
Employee	EMPLOYEE	BENEFIT
NBR Hours	NBR_HOURS	BENEFIT
Plan Code	PLAN_CODE	BENEFIT
Plan Type	PLAN_TYPE	BENEFIT
Start Date	START_DATE	BENEFIT
Stop Date	STOP_DATE	BENEFIT
Contrib Type	CONTRIB_TYPE	R_PLAN
Coverage Type	COVERAGE_TYPE	R_PLAN
Display Desc	DISPLAY_DESC	R_PLAN
After Tax Amt Deduction	AFT_DED_CODE_A	R_PLAN
After Tax Per Deduction	AFT_DED_CODE_P	R_PLAN
After Tax Match Amt Deduction	AFT_DED_MTCH_A	R_PLAN
After Tax Match Per Deduction	AFT_DED_MTCH_P	R_PLAN
Company Paid Amt Deduction	CMP_DED_CODE_A	R_PLAN
Company Paid Per Deduction	CMP_DED_CODE_P	R_PLAN
Flex Pay Code	FLEX_PAY_CODE	R_PLAN
Pre Tax Amt Deduction	PRE_DED_CODE_A	R_PLAN
Pre Tax Per Decution	PRE_DED_CODE_P	R_PLAN
Pre Tax Match Amt Deduction	PRE_DED_MTCH_A	R_PLAN
Pre Tax Match Per Deduction	PRE_DED_MTCH_P	R_PLAN
AFT Sequence	AFT_SEQ_NBR	BENEFIT
AFT Company Deduction Sequence	CMP_AFT_SEQ	BENEFIT
Company Deduction Sequence	CMP_SEQ_NBR	BENEFIT
Deduction Start Date	DED_START_DATE	BENEFIT
Deduction Stop Date	DED_STOP_DATE	BENEFIT
Multiple	MULTIPLE	BENEFIT
Percent Amount Indicator	PCT_AMT_FLAG	BENEFIT
Pre Tax Deduction Sequence	PRE_SEQ_NBR	BENEFIT
Premium Update Date	PREM_UPD_DT	BENEFIT
Description	R_DESC	R_PLAN
Plan Option	PLAN_OPTION	R_PLAN
Waive Flag	WAIVE_FLAG	R_PLAN

Employee Benefit View 3


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	Employee	EMPLOYEE
Plan Code	PLAN_CODE	BENEFIT
Plan Type	PLAN_TYPE	BENEFIT
Start Date	START_DATE	BENEFIT
Stop Date	STOP_DATE	BENEFIT
Flex Plan	FLEX_PLAN	EMPFLEXDOL
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Name Suffix	NAME_SUFFIX	EMPLOYEE
Previous Last Name	LAST_NAME_PRE	EMPLOYEE
Process Level	PROCESS_LEVEL	EMPLOYEE
Security Location	SEC_LOCATION	EMPLOYEE
Security Level	SEC_LVL	EMPLOYEE
Flex Credits	CMP_FLX_CONT	BENEFIT
Pre Tax Contribution	EMP_PRE_CONT	BENEFIT
After Tax Contribution	EMP_AFT_CONT	BENEFIT

Employee Benefit View 1


Attribute or measure name	Table field	Archive source table
Company	Company	Employee
Employee	Employee	Employee
Plan Type	Plan_Type	BENEFIT
Plan Option	Plan_Option	R_PLAN
Plan Code	Plan_Code	BENEFIT
Process Level	Process_Level	EMPLOYEE
Flex Plan	Flex_Plan	R_PLAN
Supervisor	Supervisor	EMPLOYEE
Job Code	Job_Code	EMPLOYEE
Start Date	Start_Date	BENEFIT
Stop Date	Stop_Date	BENEFIT
Term Date	Term_Date	EMPLOYEE
Waive Flag	Waive_Flag	R_PLAN
Vest Schedule	Vest_Sched	R_PLAN
Vest Hours	Vest_Hours	R_PLAN
Vest From Date	Vest_From_Date	R_PLAN
Vest Date	Vest_Date	R_PLAN
Vest Benefit Flag	Vest_Bef_Flg	R_PLAN
User Level	User_Level	EMPLOYEE
Serv Calculation Date	Serv_Calc_Date	EMPFLEXDOL
Section Location	Sec_Location	EMPLOYEE
Section Level	Sec_Lvl	EMPLOYEE
Schedule	Schedule	EMPLOYEE
Salary Class	Salary_Class	EMPLOYEE
Salary Calculation Date	Sal_Calc_Date	EMPFLEXDOL
Pre Deduction Match A	Pre_Ded_Mtch_A	R_PLAN
Pre Deduction Match P	Pre_Ded_Mtch_P	R_PLAN
Pct Amount Flag	Pct_Amt_Flag	BENEFIT
Number of Hours	Nbr_Hours	BENEFIT
Pay Grade	Pay_Grade	EMPLOYEE
Number of Fte	Nbr_Fte	EMPLOYEE
Name Suffix	Name_Suffix	EMPLOYEE
Multiple	Multiple	BENEFIT
Middle Init	Middle_Init	EMPLOYEE
First Name	First_Name	EMPLOYEE
Last Name	Last_Name	EMPLOYEE
Last Name Pre	Last_Name_Pre	EMPLOYEE
Employee Status	Emp_Status	EMPLOYEE
Employee Sequence	Employee_Seq	PRSYSTEM
Employee App	Emp_App	EMSTATUS
Description	R_Desc	R_PLAN
Department	Department	EMPLOYEE
Date Hired	Date_Hired	EMPLOYEE
Coverage Update Date	Cov_Upd_Dt	BENEFIT
Coverage Type	Coverage_Type	R_PLAN
Coverage Option	Cov_Option	BENEFIT
Coverage Group	Cov_Group	BENEFIT
Cmp Deduction Code A	Cmp_Ded_Code_A	R_PLAN
Benefit Date	Ben_Date_1	PAEMPLOYEE
Annual Hours	Annual_Hours	EMPLOYEE
Anniversary Date	Annivers_Date	EMPLOYEE
Age Calculation Date	Age_Calc_Date	EMPFLEXDOL
After Limit Match P	Aft_Lmt_Mtch_P	R_PLAN
After Limit Match A	Aft_Lmt_Mtch_A	R_PLAN
After Deduction Match P	Aft_Ded_Mtch_P	R_PLAN
After Deduction Match A	Aft_Ded_Mtch_A	R_PLAN
Adjusted Hire Date	Adj_Hire_Date	EMPLOYEE
Benefit Salary	Ben_Salary_1	PAEMPLOYEE
Bond Cost	Bond_Cost	R_PLAN
Bond Value	Bond_Value	R_PLAN
Cover Amount	Cover_Amt	BENEFIT
Pay Rate	Pay_Rate	EMPLOYEE
Pro Rate Total	Pro_Rate_Total	EMPLOYEE
Salary	Salary	EMPFLEXDOL
Ytd Contribution	Ytd_Cont	BENEFIT

AR Distributions


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLSYSTEM
Account	Account	ARDISTRIB
Sub Account	Sub_Acct	ARDISTRIB
Accounting Unit	Acct_Unit	ARDISTRIB
Accum Type	Accum_Type	ARDISTRIB
Activity	Activity	ARDISTRIB
Status	Status	ARDISTRIB
Prog Sequence Number	Prog_Seq_Nbr	ARDISTRIB
Name	Name	ARCOMP
Description	R_Desc	ARDISTRIB
Invoice	Invoice	ARDISTRIB
Gl Date	Gl_Date	ARDISTRIB
Customer	Customer	ARDISTRIB
Customer Group	Cust_Group	ARCOMP
Currency Cd	Currency_Cd	ARCOMP
Create Time	Create_Time	ARDISTRIB
Create Date	Create_Date	ARDISTRIB
Batch Number	Batch_Nbr	ARDISTRIB
Base Nd	Base_Nd	ARCOMP
Atn Object Id	Atn_Obj_Id	ARDISTRIB
Units	Units	ARDISTRIB
Transaction Type	Trans_Type	ARDISTRIB
Transaction Amount	Tran_Amt	ARDISTRIB

AR Customer Period Totals


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLSYSTEM
Company Name	NAME	GLSYSTEM
CUSTOMER	CUSTOMER	ARCUSTOMER
Acct Unit	BS_ACCT_UNIT	GLSYSTEM
Fiscal Year	FISCAL_YEAR	GLSYSTEM
Period	ACCT_PERIOD	GLSYSTEM
Report Currency 1	CURR_CODE_1	GLSYSTEM
Report Currency 2	CURR_CODE_2	GLSYSTEM
Chart Name	CHART_NAME	GLSYSTEM
Base Bal	AUTO_BASE_BAL	GLSYSTEM
ACTIVE STATUS	ACTIVE_STATUS	ARCUSTOMER
CONTACT	CONTACT	ARCUSTOMER
CREDIT LIM	CREDIT_LIM	ARCUSTOMER
CREDIT LIM DAT	CREDIT_LIM_DAT	ARCUSTOMER
CURR CSH DAYS	CURR_CSH_DAYS	ARCUSTOMER
DBT PR YR	DBT_PR_YR	ARCUSTOMER
DBT YTD DAYS	DBT_YTD_DAYS	ARCUSTOMER
Disp AMT	DISP_AMT	ARCUSTOMER
DISP NBR	DISP_NBR	ARCUSTOMER
HIGH BAL 01	HIGH_BAL_01	ARCUSTOMER
HOLD CODE	HOLD_CODE	ARCUSTOMER
OPEN ORDS	OPEN_ORDS	ARCUSTOMER
PERIOD Bill 01	PERIOD_Bill_01	ARCUSTPER
PERIOD Bill 02	PERIOD_Bill_02	ARCUSTPER
PERIOD Bill 03	PERIOD_Bill_03	ARCUSTPER
PERIOD Bill 04	PERIOD_Bill_04	ARCUSTPER
PERIOD Bill 05	PERIOD_Bill_05	ARCUSTPER
PERIOD Bill 06	PERIOD_Bill_06	ARCUSTPER
PERIOD Bill 07	PERIOD_Bill_07	ARCUSTPER
PERIOD Bill 08	PERIOD_Bill_08	ARCUSTPER
PERIOD Bill 09	PERIOD_Bill_09	ARCUSTPER
PERIOD Bill 10	PERIOD_Bill_10	ARCUSTPER
PERIOD Bill 11	PERIOD_Bill_11	ARCUSTPER
PERIOD Bill 12	PERIOD_Bill_12	ARCUSTPER
PERIOD Bill 13	PERIOD_Bill_13	ARCUSTPER
PERIOD CHGBKS 01	PERIOD_CHGBKS_01	ARCUSTPER
PERIOD CHGBKS 02	PERIOD_CHGBKS_02	ARCUSTPER
PERIOD CHGBKS 03	PERIOD_CHGBKS_03	ARCUSTPER
PERIOD CHGBKS 04	PERIOD_CHGBKS_04	ARCUSTPER
PERIOD CHGBKS 05	PERIOD_CHGBKS_05	ARCUSTPER
PERIOD CHGBKS 06	PERIOD_CHGBKS_06	ARCUSTPER
PERIOD CHGBKS 07	PERIOD_CHGBKS_07	ARCUSTPER
PERIOD CHGBKS 08	PERIOD_CHGBKS_08	ARCUSTPER
PERIOD CHGBKS 09	PERIOD_CHGBKS_09	ARCUSTPER
PERIOD CHGBKS 10	PERIOD_CHGBKS_10	ARCUSTPER
PERIOD CHGBKS 11	PERIOD_CHGBKS_11	ARCUSTPER
PERIOD CHGBKS 12	PERIOD_CHGBKS_12	ARCUSTPER
PERIOD CHGBKS 13	PERIOD_CHGBKS_13	ARCUSTPER
PERIOD CRDTS 01	PERIOD_CRDTS_01	ARCUSTPER
PERIOD CRDTS 02	PERIOD_CRDTS_02	ARCUSTPER
PERIOD CRDTS 03	PERIOD_CRDTS_03	ARCUSTPER
PERIOD CRDTS 04	PERIOD_CRDTS_04	ARCUSTPER
PERIOD CRDTS 05	PERIOD_CRDTS_05	ARCUSTPER
PERIOD CRDTS 06	PERIOD_CRDTS_06	ARCUSTPER
PERIOD CRDTS 07	PERIOD_CRDTS_07	ARCUSTPER
PERIOD CRDTS 08	PERIOD_CRDTS_08	ARCUSTPER
PERIOD CRDTS 09	PERIOD_CRDTS_09	ARCUSTPER
PERIOD CRDTS 10	PERIOD_CRDTS_10	ARCUSTPER
PERIOD CRDTS 11	PERIOD_CRDTS_11	ARCUSTPER
PERIOD CRDTS 12	PERIOD_CRDTS_12	ARCUSTPER
PERIOD CRDTS 13	PERIOD_CRDTS_13	ARCUSTPER
PERIOD EA DISC 01	PERIOD_EA_DISC_01	ARCUSTPER
PERIOD EA DISC 02	PERIOD_EA_DISC_02	ARCUSTPER
PERIOD EA DISC 03	PERIOD_EA_DISC_03	ARCUSTPER
PERIOD EA DISC 04	PERIOD_EA_DISC_04	ARCUSTPER
PERIOD EA DISC 05	PERIOD_EA_DISC_05	ARCUSTPER
PERIOD EA DISC 06	PERIOD_EA_DISC_06	ARCUSTPER
PERIOD EA DISC 07	PERIOD_EA_DISC_07	ARCUSTPER
PERIOD EA DISC 08	PERIOD_EA_DISC_08	ARCUSTPER
PERIOD EA DISC 09	PERIOD_EA_DISC_09	ARCUSTPER
PERIOD EA DISC 10	PERIOD_EA_DISC_10	ARCUSTPER
PERIOD EA DISC 11	PERIOD_EA_DISC_11	ARCUSTPER
PERIOD EA DISC 12	PERIOD_EA_DISC_12	ARCUSTPER
PERIOD EA DISC 13	PERIOD_EA_DISC_13	ARCUSTPER
PERIOD UE DISC 01	PERIOD_UE_DISC_01	ARCUSTPER
PERIOD UE DISC 02	PERIOD_UE_DISC_02	ARCUSTPER
PERIOD UE DISC 03	PERIOD_UE_DISC_03	ARCUSTPER
PERIOD UE DISC 04	PERIOD_UE_DISC_04	ARCUSTPER
PERIOD UE DISC 05	PERIOD_UE_DISC_05	ARCUSTPER
PERIOD UE DISC 06	PERIOD_UE_DISC_06	ARCUSTPER
PERIOD UE DISC 07	PERIOD_UE_DISC_07	ARCUSTPER
PERIOD UE DISC 08	PERIOD_UE_DISC_08	ARCUSTPER
PERIOD UE DISC 09	PERIOD_UE_DISC_09	ARCUSTPER
PERIOD UE DISC 10	PERIOD_UE_DISC_10	ARCUSTPER
PERIOD UE DISC 11	PERIOD_UE_DISC_11	ARCUSTPER
PERIOD UE DISC 12	PERIOD_UE_DISC_12	ARCUSTPER
PERIOD UE DISC 13	PERIOD_UE_DISC_13	ARCUSTPER
PERIOD WROFFS 01	PERIOD_WROFFS_01	ARCUSTPER
PERIOD WROFFS 02	PERIOD_WROFFS_02	ARCUSTPER
PERIOD WROFFS 03	PERIOD_WROFFS_03	ARCUSTPER
PERIOD WROFFS 04	PERIOD_WROFFS_04	ARCUSTPER
PERIOD WROFFS 05	PERIOD_WROFFS_05	ARCUSTPER
PERIOD WROFFS 06	PERIOD_WROFFS_06	ARCUSTPER
PERIOD WROFFS 07	PERIOD_WROFFS_07	ARCUSTPER
PERIOD WROFFS 08	PERIOD_WROFFS_08	ARCUSTPER
PERIOD WROFFS 09	PERIOD_WROFFS_09	ARCUSTPER
PERIOD WROFFS 10	PERIOD_WROFFS_10	ARCUSTPER
PERIOD WROFFS 11	PERIOD_WROFFS_11	ARCUSTPER
PERIOD WROFFS 12	PERIOD_WROFFS_12	ARCUSTPER
PERIOD WROFFS 13	PERIOD_WROFFS_13	ARCUSTPER
CURR BAL	CURR_BAL	ARCUSTOMER
DRAFT BAL	DRAFT_BAL	ARCUSTOMER
YTD CASH	YTD_CASH	ARCUSTOMER

AR Payment


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLSYSTEM
Customer	CUSTOMER	ARPYMNTHDR
Batch Number	BATCH_NBR	ARPYMNTHDR
PaymentNumber	TRANS_NBR	ARPAYMENT
Payment Sequence	PAYMENT_SEQ	ARPAYMENT
Aging Code	AGING_CODE	ARCUSTOMER
Aging 01	AGING_01	ARCUSTOMER
Aging 02	AGING_02	ARCUSTOMER
Aging 03	AGING_03	ARCUSTOMER
Aging 04	AGING_04	ARCUSTOMER
Aging 05	AGING_05	ARCUSTOMER
ActiveStatus	ACTIVE_STATUS	ARCUSTOMER
BankTransactionCode	BANK_INST_CODE	ARCUSTOMER
Cash Code	CASH_CODE	ARPYMNTHDR
Country	COUNTRY	CUSTDESC
City	CITY	CUSTDESC
County	COUNTY	CUSTDESC
Credit Analyst	CREDIT_ANLYST	ARCUSTGRP
Credit Limit	CREDIT_LIM	ARCUSTGRP
Credit Limit Date	CREDIT_LIM_DAT	ARCUSTGRP
Credit Review Days	CREDIT_REVDAYS	ARCUSTGRP
Currency	CURRENCY_CD	ARCOMP
CurrencyDecimalsNumber	ORIG_ND	ARPYMNTHDR
CurrencyRate	ORIG_RATE	ARPYMNTHDR
Customer Group	CUST_GROUP	ARCOMP
Customer Major Class	MAJ_CLASS	ARCUSTGRP
Customer Minor Class	MIN_CLASS	ARCUSTGRP
Customer Cash Report Key
CustomerNumberType	CUST_ALP_NB	ARCUSTGRP
Deposit Date	DEPOSIT_DATE	ARPYMNTHDR
Disputed Invoices	DISP_NBR	ARCUSTGRP
GeneralLedgerDate	GL_DATE	ARPYMNTHDR
Hold Code	HOLD_CODE	ARCUSTGRP
Journal Book	JRNL_BOOK_NBR	ARPYMNTHDR
Name	NAME	ARCOMP
OriginalCurrency	ORIG_CURRENCY	ARPYMNTHDR
Process Level	PROCESS_LEVEL	ARPYMNTHDR
ReceivableGeneralLedgerCode	AR_CODE	ARCUSTGRP
ReceivableLockBox	LOCK_BOX	ARPYMNTHDR
Region	REGION	CUSTDESC
Sales Representative	SALESMAN	ARCUSTGRP
State	STATE	STATE
Status	STATUS	ARCUSTOMER
Tax Code	TAX_CODE	ARCUSTGRP
Tax Exempt	TAX_EXEMPT_CD	ARCUSTGRP
Territory	TERRITORY	ARCUSTGRP
Transfer Date	TRANSFER_DATE	ARPAYMENT
TransferAmountTransactionCurrency	TRANSFER_AMT	ARPAYMENT
TransferredToCustomer	TRNS_CUST	ARPAYMENT
TypeOfPayment	TRANS_TYPE	ARPAYMENT
Zip	ZIP	STATE
AdjustAmountTransactionCurrency	ORIG_ADJ_AMT	ARPYMNTHDR
BaseAdjustAmount	ADJ_AMT	ARPYMNTHDR
BaseAmount	TRAN_AMT	ARPAYMENT
BaseAppliedAmount	APPLD_AMT	ARPYMNTHDR
BaseCreditAppliedAmount	CREDIT_APPLD	ARPYMNTHDR
CreditAppliedAmount	ORIG_CR_APPLD	ARPYMNTHDR
Current Balance	CURR_BAL	ARCUSTGRP
Disputed Invoice Amount	DISP_AMT	ARCUSTGRP
Open Order Amount	OPEN_ORDS	ARCUSTGRP
Transaction Amount	ORIG_AMT	ARPYMNTHDR

AR Transaction View 1


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLSYSTEM
Transaction Type	TRANS_TYPE	AROITEMS
Payment Sequence	PAYMENT_SEQ	AROITEMS
Customer	CUSTOMER	AROITEMS
Invoice	INVOICE	AROITEMS
Aging Code	AGING_CODE	ARCUSTOMER
Aging 01	AGING_01	ARCUSTOMER
Aging 02	AGING_02	ARCUSTOMER
Aging 03	AGING_03	ARCUSTOMER
Aging 04	AGING_04	ARCUSTOMER
Aging 05	AGING_05	ARCUSTOMER
ActiveStatus	ACTIVE_STATUS	ARCUSTOMER
BankTransactionCode	BANK_INST_CODE	ARCUSTOMER
Batch Number	BATCH_NBR	AROITEMS
City	CITY	CUSTDESC
Country	COUNTRY	CUSTDESC
County	COUNTY	CUSTDESC
Currency	CURRENCY_CD	ARCOMP
Currency Decimals Number	ORIG_ND	AROITEMS
Customer Group	CUST_GROUP	ARCOMP
Customer Major Class	MAJ_CLASS	ARCUSTOMER
Customer Minor Class	MIN_CLASS	ARCUSTOMER
Customer Number Type	CUST_ALP_NBR	ARCUSTGRP
Description	NAME	ARCOMP
Disputed Invoices	DISP_NBR	ARCUSTOMER
Draft Process	DRAFT_PROCESS	ARCUSTGRP
Due Date	DUE_DATE	AROITEMS
General Ledger Date	GL_DATE	ARPAYMENT
Hold Code	HOLD_CODE	ARCUSTOMER
Origin	ORIG_CODE	AROITEMS
Original Currency	ORIG_CURRENCY	AROITEMS
PaymentNumber	TRANS_NBR	ARPAYMENT
ReceivableGeneralLedgerCode	AR_CODE	ARCUSTOMER
Region	REGION	CUSTDESC
Sales Representative	SALESMAN	ARCUSTOMER
State	STATE	CUSTDESC
Status	STATUS	AROITEMS
Transaction Date	TRANS_DATE	AROITEMS
Transaction History Periods	HIST_PER	ARPAYMENT
Transfer Date	TRANSFER_DATE	ARPAYMENT
Zip	ZIP	CUSTDESC
Adjust Amount	ORIG_ADJ_AMT	AROITEMS
Applied Amount	ORIG_APP_AMT	AROITEMS
Base Adjust Amount	ADJ_AMT	AROITEMS
Base Amount	TRAN_AMT	AROITEMS
Base Applied Amount	APPLD_AMT	AROITEMS
Base Credit Applied Amount	CREDIT_APPLD	ARPAYMENT
Credit Applied Amount	ORIG_CR_APPLD	ARPAYMENT
Current Balance	CURR_BAL	ARCUSTOMER
Disputed Invoice Amount	DISP_AMT	ARCUSTOMER
Open Order Amount	OPEN_ORDS	ARCUSTOMER
Transaction Amount	ORIG_AMT	AROITEMS
TransferAmountTransactionCurrency	TRANSFER_AMT	ARPAYMENT

AR Distributions


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLSYSTEM
Account	Account	ARDISTRIB
Sub Account	Sub_Acct	ARDISTRIB
Name	Name	ARCOMP
Accounting Unit	Acct_Unit	ARDISTRIB
Account Category	Acct_Category	ARDISTRIB
Activity	Activity	ARDISTRIB
Status	Status	ARPYMNTHDR
Customer	Customer	ARDISTRIB
Customer Group	Cust_Group	ARCOMP
Process Level	Process_Level	ARPYMNTHDR
Progress Sequence Number	Prog_Seq_Nbr	ARDISTRIB
Payment Sequence	Payment_Seq	ARPYMNTHDR
Remit Sequence	Remit_Seq	ARPAYMENT
Reference	Reference	ARPYMNTHDR
Gl Date	Gl_Date	ARDISTRIB
Gl Company	Gl_Company	ARDISTRIB
Orig Rate	Orig_Rate	ARPYMNTHDR
Trans Customer	Trns_Cust	ARPAYMENT
Transfer Date	Transfer_Date	ARPAYMENT
Transaction Type	Trans_Type	ARDISTRIB
Transaction Number	Trans_Nbr	ARPAYMENT
Segment Block	Segment_Block	ARUDISTRIB
Orig Nd	Orig_Nd	ARDISTRIB
Opr Code	Opr_Code	ARPYMNTHDR
Multi Currency Flag	Multi_Curr_Fl	ARCOMP
Lock Box	Lock_Box	ARPYMNTHDR
Journal Book Number	Jrnl_Book_Nbr	ARDISTRIB
Invoice	Invoice	ARDISTRIB
Dst Type	Dst_Type	ARDISTRIB
Dist Sequence	Dist_Seq	ARDISTRIB
Detail Total	Detail_Total	ARPYMNTHDR
Detail Count	Detail_Count	ARPYMNTHDR
Description	R_Desc	ARDISTRIB
Deposit Date	Deposit_Date	ARPYMNTHDR
Currency Cd	Currency_Cd	ARCOMP
Create Time	Create_Time	ARDISTRIB
Create Date	Create_Date	ARDISTRIB
Cb User Field1	Cb_User_Field1	ARPYMNTHDR
Cb User Field2	Cb_User_Field2	ARPYMNTHDR
Cb User Field3	Cb_User_Field3	ARPYMNTHDR
Cb User Field4	Cb_User_Field4	ARPYMNTHDR
Cash Code	Cash_Code	ARPYMNTHDR
Cancel Date	Cancel_Date	ARPAYMENT
Batch Total	Batch_Total	ARPYMNTHDR
Batch Number	Batch_Nbr	ARDISTRIB
Batch Count	Batch_Count	ARPYMNTHDR
Bank Entity	Bank_Entity	ARPAYMENT
Bank Account Number	Bank_Acct_Nbr	ARPAYMENT
AR Reference	AR_Reference	ARPAYMENT
Additional Amount	Addtnl_Amt	ARPYMNTHDR
Adjusted Amount	Adj_Amt	ARPAYMENT
Applied Amount	Appld_Amt	ARPAYMENT
Credit Applied	Credit_Appld	ARPAYMENT
Transfer Amount	Transfer_Amt	ARPAYMENT
Transaction Amount	Tran_Amt	ARPAYMENT
Origin of Amount	Orig_Amt	ARDISTRIB

AR Transaction View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLSYSTEM
Vendor Group	Vendor_Group	CUSTDESC
Vendor	Vendor	CUSTDESC
Customer	Customer	AROITEMS
Customer Group	Cust_Group	ARCOMP
Customer PO Number	Cust_Po_Nbr	AROIHDR
Customer Alp Number	Cust_Alp_Nbr	ARCUSTGRP
Account Category	Acct_Category	AROITEMS
Activity	Activity	AROITEMS
Activity Group	Activity_Grp	AROITEMS
Process Level	Process_Level	ARPAYMENT
Invoice	Invoice	AROITEMS
Invoice Prefix	Invc_Prefix	FROPTIONS
Invoice Type	Invc_Type	FROPTIONS
Uom	Uom	FROPTIONS
Trns Customer	Trns_Cust	ARPAYMENT
Transfer Date	Transfer_Date	ARPAYMENT
Transaction Type	Trans_Type	AROITEMS
Transaction Number	Trans_Nbr	ARPAYMENT
Xreference Number	Xref_Nbr	AROIHDR
Trans User	Trans_User1	AROIHDR
Sum Line	Sum_Line	AROIHDR
Sales Flag	Sales_Fl	FROPTIONS
Sales by Date	Sales_By_Date	FROPTIONS
Reason Code	Reason_Code	FROPTIONS
Previous Year	Previous_Year	FROPTIONS
Payment Sequence	Payment_Seq	AROITEMS
Original Nd	Orig_Nd	AROITEMS
Original Currency	Orig_Currency	ARPAYMENT
Ob Draft Flag	Ob_Drf_Fl	ARCOMP
Next Year	Next_Year	FROPTIONS
Nat Flag	Nat_Flag	ARCUSTOMER
Name	Name	ARCOMP
Multi Currency Flag	Multi_Curr_Fl	ARCOMP
Location	Location	FROPTIONS
Last Invoice Number	Lst_Invc_Nbr	FROPTIONS
Last Credit Number	Lst_Cr_Nbr	FROPTIONS
Group Rate	Group_rate	ARPAYMENT
Group Mudv	Group_Mudv	ARPAYMENT
Grant	R_Grant	AROITEMS
Due Date	Due_Date	AROITEMS
Draft Process	Draft_Process	ARCUSTGRP
Dispute Sequence	Dispute_Seq	AROITEMS
Deposit Date	Deposit_Date	ARPAYMENT
Currency Display	Curr_Display	ARCOMP
Currency Code	Currency_Cd	ARCOMP
Curr Mudv	Curr_Mudv	ARPAYMENT
Credit Invoice Type	Cr_Invc_Type	FROPTIONS
Credit Invoice Prefix	Cr_Invc_Prefix	FROPTIONS
Contract	Contract	AROITEMS
Cash Code	Cash_Code	FROPTIONS
Cancel Date	Cancel_Date	ARPAYMENT
Calendar ID	Calendar_Id	FROPTIONS
Bill To	Bill_To	AROITEMS
Batch Number	Batch_Nbr	AROITEMS
Base Nd	Base_Nd	ARCOMP
Alt Type	Alt_Type	AROITEMS
Ac Customer ID	Ac_Customer_Id	AROIHDR
Adjusted Amount	Adj_Amt	AROITEMS
Applied Amount	Appld_Amt	AROITEMS
Credit Applied	Credit_Appld	ARPAYMENT
Current Balance	Curr_Bal	ARCUSTOMER
Draft Balance	Draft_Bal	ARCUSTOMER
Original Adjusted Amount	Orig_Adj_Amt	AROITEMS
Original Amount	Orig_Amt	AROITEMS
Original App Amount	Orig_App_Amt	AROITEMS
Original Credit Applied	Orig_Cr_Appld	ARPAYMENT
Sort Amount	Sort_Amount	AROITEMS
Transaction Amount	Tran_Amt	AROITEMS
Transfer Amount	Transfer_Amt	ARPAYMENT
Status	Status	AROITEMS

AR Payment Transactions


Attribute or measure name	Table field	Archive source table
Activity	ACTIVITY	ARACPIVOT
Activity Group	ACTIVITY_GRP	ARACPIVOT
Active Status	ACTIVE_STATUS	ARCUSTOMER
Company	COMPANY	GLSYSTEM
Account Category	ACCT_CATEGORY	ARACPIVOT
Aging Code	AGING_CODE	ARCUSTOMER
Aging 01	AGING_01	ARCUSTOMER
Aging 02	AGING_02	ARCUSTOMER
Aging 03	AGING_03	ARCUSTOMER
Aging 04	AGING_04	ARCUSTOMER
Aging 05	AGING_05	ARCUSTOMER
AR Code	AR_CODE	ARCUSTOMER
Bank Inst Code	BANK_INST_CODE	ARCUSTOMER
Base ND	BASE_ND	ARACPIVOT
Batch Number	BATCH_NBR	ARACPIVOT
Contract	CONTRACT	ARACPIVOT
Credit Analyst	CREDIT_ANLYST	ARCUSTOMER
Credit Limit Date	CREDIT_LIM_DAT	ARACPIVOT
Currency CD	CURRENCY_CD	ARCOMP
Currency Code	CURRENCY_CODE	ARACPIVOT
Cust Group	CUST_GROUP	ARCOMP
Customer	CUSTOMER	ARACPIVOT
Display Number	DISP_NBR	ARCUSTOMER
GL Date	GL_DATE	ARACPIVOT
Grant	R_GRANT	ARACPIVOT
Group Mudv	GROUP_MUDV	ARACPIVOT
Group Rate	GROUP_RATE	ARACPIVOT
Hold Code	HOLD_CODE	ARCUSTOMER
Major Class	MAJ_CLASS	ARCUSTOMER
Minor Class	MIN_CLASS	ARCUSTOMER
Name	NAME	ARCOMP
Orig Currency	ORIG_CURRENCY	ARACPIVOT
ORIG ND	ORIG_ND	ARACPIVOT
Payment Sequence	PAYMENT_SEQ	ARACPIVOT
Process Level	Process_Level	ARACPIVOT
Salesman	SALESMAN	ARCUSTOMER
Tax Code	TAX_CODE	ARCUSTOMER
Tax Exempt CD	TAX_EXEMPT_CD	ARCUSTOMER
Territory	TERRITORY	ARCUSTOMER
Transaction	R_TRANSACTION	ARACPIVOT
Transaction Date	TRANS_DATE	ARACPIVOT
Transaction Type	TRANS_TYPE	ARACPIVOT
Credit Limit	CREDIT_LIM	ARCUSTOMER
Credit RevDays	CREDIT_REVDAYS	ARCUSTOMER
Curr Bal	CURR_BAL	ARCUSTOMER
Display Amount	DISP_AMT	ARCUSTOMER
Open Orders	OPEN_ORDS	ARCUSTOMER
Orig Amount	ORIG_AMT	ARACPIVOT
Transaction Amount	TRAN_AMT	ARACPIVOT

Order Invoice


Attribute or measure name	Table field	Archive source table
Company	Company	GLSYSTEM
Vendor	Vendor	CUSTDESC
Vat Registration Number	Vat_Reg_Nbr	ARCUSTOMER
Vat Registration Country	Vat_Reg_Ctry	ARCUSTOMER
Url Address	Url_Addr	ARCUSTOMER
Title	Title	CUSTDESC
Territory	Territory	ARCUSTOMER
GI Date	Gl_Date	OEINVOICE
Terms Cd	Terms_Cd	ARCUSTOMER
Telex Number	Telex_Nbr	Telex_Nbr
Tax Id	Tax_Id	CUSTDESC
Tax Exempt Code	Tax_Exempt_Cd	ARCUSTOMER
Tax Code	Tax_Code	ARCUSTOMER
Status	Status	OEINVOICE
State	State	ARCOMP
Start Date	Start_Date	ARCUSTOMER
Ship To	Ship_To	OEINVOICE
Ship Comp Flag	Ship_Comp_Fl	OECUST
Sgl Order Limit	Sgl_Ord_Lim	OECUST
Sgl Hold Code	Sgl_Hold_Code	OECUST
Search Name	Search_Name	ARCUSTOMER
Salesman 1	Salesman	ARCUSTOMER
Salesman 2	Salesman_2	OECUST
Risk Cd	Risk_Cd	ARCUSTOMER
Region	Region	CUSTDESC
Rate Over Flag	Rate_Ovr_Fl	ARCOMP
Prt Check Flag	Prt_Check_Fl	OECUST
Process Level	Process_Level	OEINVOICE
Price List	Price_Lst	OECUST
Pre Pay Code	Pre_Pay_Code	OECUST
Pod Required Flag	Pod_Req_Fl	OECUST
Po Required Flag	Po_Req_Fl	OECUST
Pl Excl Flag	Pl_Excl_Fl	OECUST
Pk Priority	Pk_Priority	OECUST
Phone Number	Phone_Nmbr	CUSTDESC
Phone Extension	Phone_Ext	CUSTDESC
Over Address Flag	Ovr_Addr_Fl	CUSTDESC
Order Number	Order_Nbr	OEINVOICE
Order Limit	Order_Lim	OECUST
Order Discount Code	Ord_Disc_Code	OECUST
Or Limit Hold	Or_Limit_Hold	OECUST
Open Ords	Open_Ords	OECUST
Offset Flag	Offset_Fl	OECUST
Nat Flag	Nat_Flag	OECUST
Name	Name	OEINVOICE
Multi Curr Flag	Multi_Curr_Fl	OECUST
Minimum	Minimum	OECUST
Minimum Class	Min_Class	OECUST
Memo Term	Memo_Term	OECUST
Maj Class	Maj_Class	OECUST
Lock Box	Lock_Box	OECUST
Line Item Required	Line_Item_Req	OECUST
Last Payment Date	Last_Pmt_Date	OECUST
Last Invoice Date	Last_Inv_Date	OECUST
Language Code	Language_Code	OECUST
Invoice Update Flag	Invc_Upd_Fl	OECOMPANY
Invoice Prefix	Invc_Prefix	OECOMPANY
Invoice Option Flag	Invc_Opt_Fl	OECOMPANY
Invoice Number	Invc_Number	OEINVOICE
Invoice Edit Flag	Invc_Edit_Fl	OECOMPANY
Invoice Date	Invoice_Date	OEINVOICE
Invoice Credit Flag	Invc_Cr_Fl	OECOMPANY
Invoice Currency Over	Invoice_Currency_over	OEINVOICE
Int Prefix	Int_Prefix	OECUST
Incomplete Flag	Incomplete_Fl	OECUST
Hold Code	Hold_Code	OECUST
Grace Per	Grace_Per	OECUST
Front Charge Base	Frt_Charge_B	OEINVOICE
Freight Code	Freight_Code	OECUST
Fin Rev Code	Fin_Rev_Code	OECUST
Fin Exp Code	Fin_Exp_Code	OECUST
Fin Cycle	Fin_Cycle	OECUST
Fax Number	Fax_Nmbr	CUSTDESC
Fax Extension	Fax_Ext	CUSTDESC
Entry Check Flag	Ent_Check_Fl	OECUST
Edi Number	Edi_Nbr	CUSTDESC
E-Mail Address	E_Mail_Address	ARCUSTOMER
Dunn Number	Dunn_Number	CUSTDESC
Dunn Date	Dunn_Date	CUSTDESC
Dunn Cd	Dunn_Cd	CUSTDESC
Dun Cycle	Dun_Cycle	ARCUSTOMER
Date Accpt Code	Dt_Accpt_Code	CUSTDESC
Display Number	Disp_Nbr	ARCUSTOMER
Display Amount	Disp_Amt	ARCUSTOMER
Discount Tax Rcv	Disc_Tax_Rcv	ARCOMP
Dis Exp Code	Dis_Exp_Code	CUSTDESC
Default Code	Default_Code	ARCUSTOMER
Default Ship To	Def_Ship_To	OECUST
Default Method	Def_Method	OECUST
Default Location	Def_Location	OECUST
Customer Group	Cust_Group	ARCUSTOMER
Customer Code	Customer_Code	OECUST
Customer	Customer	ARCUSTOMER
Currency Code	Currency_Code	OECOMPANY
Currency Cd	Currency_Cd	ARCUSTOMER
Curr Balance	Curr_Bal	ARCUSTOMER
Credit RevDays	Credit_RevDays	ARCUSTOMER
Credit Limit Hold	Cr_Limit_Hold	OECUST
Credit Limit Date	Credit_Lim_Dat	ARCUSTOMER
Credit Limit	Credit_Lim	ARCUSTOMER
Credit Analyst	Credit_Anlyst	ARCUSTOMER
County	County	ARCUSTOMER
Country Code	Country_Code	CUSTDESC
Country	Country	ARCUSTOMER
Contact	Contact	ARCUSTOMER
Comm Split	Comm_Split	OECUST
Cod Limit	Cod_Lim	OECUST
Cod Hold Code	Cod_Hold_Code	OECUST
Cia Pct	Cia_Pct	OECUST
City	City	ARCUSTOMER
Cia Flag	Cia_Fl	OECUST
Carrier	Carrier	OECUST
Brkn Cs Charging	Brkn_Cs_Chrg	OECUST
Base Nd	Base_Nd	OECOMPANY
Bank Risk Opt	Bank_Risk_Opt	ARCUSTOMER
Bank Inst Code	Bank_Inst_Code	ARCUSTOMER
Back Order Flag	Back_Ord_Fl	OECUST
Auto Method	Auto_Method	ARCUSTOMER
Auto App Flag	Auto_App_Fl	ARCUSTOMER
Audit App Flag	Audit_App_Fl	ARCUSTOMER
Ar Code	Ar_Code	ARCUSTOMER
Allow Returns	Allow_Returns	OECUST
Allow Return Date	Allow_Rtn_Date	OECUST
Aging Code	Aging_Code	ARCUSTOMER
Aging 1	Aging_01	ARCUSTOMER
Aging 2	Aging_02	ARCUSTOMER
Aging 3	Aging_03	ARCUSTOMER
Aging 4	Aging_04	ARCUSTOMER
Aging 5	Aging_05	ARCUSTOMER
Age Periods 01	Age_Periods_01	ARCUSTOMER
Age Periods 02	Age_Periods_02	ARCUSTOMER
Age Periods 03	Age_Periods_03	ARCUSTOMER
Age Periods 04	Age_Periods_04	ARCUSTOMER
Age Hold Cd 01	Age_Hold_Cd_01	OECUST
Age Hold Cd 02	Age_Hold_Cd_02	OECUST
Age Hold Cd 03	Age_Hold_Cd_03	OECUST
Age Hold Cd 04	Age_Hold_Cd_04	OECUST
Age Hold Cd 05	Age_Hold_Cd_05	OECUST
Age Current	Age_Current	ARCUSTOMER
Age Cred Pct 01	Age_Cred_Pct_01	OECUST
Age Cred Pct 02	Age_Cred_Pct_02	OECUST
Age Cred Pct 03	Age_Cred_Pct_03	OECUST
Age Cred Pct 04	Age_Cred_Pct_04	OECUST
Age Cred Pct 05	Age_Cred_Pct_05	OECUST
Address 1	Addr1	ARCUSTOMER
Address 2	Addr2	ARCUSTOMER
Address 3	Addr3	ARCUSTOMER
Address 4	Addr4	ARCUSTOMER
Add On Discount	Add_On_Disc	OEINVOICE
Active Status	Active_Status	ARCUSTOMER
Acknowledge Flag	Acknow_Fl	OECUST
Draft Balance	Draft_Bal	ARCUSTOMER
High Balance 01	High_Bal_01	ARCUSTOMER
High Balance 02	High_Bal_02	ARCUSTOMER
High Balance 03	High_Bal_03	ARCUSTOMER
High Balance 04	High_Bal_04	ARCUSTOMER
High Balance 05	High_Bal_05	ARCUSTOMER
High Balance 06	High_Bal_06	ARCUSTOMER
High Balance 07	High_Bal_07	ARCUSTOMER
High Balance 08	High_Bal_08	ARCUSTOMER
High Balance 09	High_Bal_09	ARCUSTOMER
High Balance 10	High_Bal_10	ARCUSTOMER
High Balance 11	High_Bal_11	ARCUSTOMER
High Balance 12	High_Bal_12	ARCUSTOMER
High Balance 13	High_Bal_13	ARCUSTOMER
Invoice Goods Base	Inv_Goods_Bse	OEINVOICE
Misc Total Base	Misc_Tot_Base	OEINVOICE
Non Invoice Goods Base	Non_Inv_Gds_B	OEINVOICE
Order Discount Base	Ord_Disc_Bse	OEINVOICE
Tax Total Base	Tax_Total_Bse	OEINVOICE

Invoice Inquiry Status


Attribute or measure name	Table field	Archive source table
Company	Company	GLSYSTEM
Billing Invoice Line	LINE_NBR	OEINVCLINE
Billing Invoice Number	INVC_NUMBER	OEINVOICE
Billing Invoice Prefix	INVC_PREFIX	OEINVCLINE
Billing Invoice Source	INVC_SOURCE	OEINVOICE
Billing Invoice Type	INVC_TYPE	OEINVOICE
Active Status	ACTIVE_STATUS	ARCUSTOMER
Bill To	BILL_TO	OEINVOICE
Customer	CUSTOMER	OEINVOICE
Customer Order	ORDER_NBR	OEINVOICE
Description	DESCRIPTION	OEINVCLINE
General Ledger Chart Account	ISS_ACCOUNT	ICCATEGORY
Inventory Sub Account	INV_SUB_ACCT	ICCATEGORY
Invoice Date	ORDER_NBR	OEINVOICE
Invoice Print	INVC_PRT_FL	OECOMPANY
Invoice Update	INVC_UPD_FL	OEINVCUOM
ISO Country	ISO_CTRY_NBR	OECOMPANY
Issue Account Accounting Unit	ISS_ACCT_UNIT	ICCATEGORY
Issue Sub Account	ISS_SUB_ACCT	ICCATEGORY
Item	ITEM	ITEMLOC
Major Inventory Class	INVEN_MAJCL	ITEMMAST
Minor Inventory Class	INVEN_MINCL	ITEMMAST
Name	NAME	OECOMPANY
Sales Account	ACTIVITY	OEINVCLINE
Status	STATUS	ARCUSTOMER
UOM 01	UOM_01	OEINVCUOM
UOM 02	UOM_02	OEINVCUOM
UOM 03	UOM_03	OEINVCUOM
UOM 04	UOM_04	OEINVCUOM
UOM 05	UOM_05	OEINVCUOM
UOM 06	UOM_06	OEINVCUOM
UOM 07	UOM_07	OEINVCUOM
UOM 08	UOM_08	OEINVCUOM
UOM 09	UOM_09	OEINVCUOM
UOM 10	UOM_10	OEINVCUOM
URL Address	URL_ADDR	ARCUSTOMER
Unit Price 01	UNIT_PRICE_01	OEINVCUOM
Unit Price 02	UNIT_PRICE_02	OEINVCUOM
Unit Price 03	UNIT_PRICE_03	OEINVCUOM
Unit Price 04	UNIT_PRICE_04	OEINVCUOM
Unit Price 05	UNIT_PRICE_05	OEINVCUOM
Unit Price 06	UNIT_PRICE_06	OEINVCUOM
Unit Price 07	UNIT_PRICE_07	OEINVCUOM
Unit Price 08	UNIT_PRICE_08	OEINVCUOM
Unit Price 09	UNIT_PRICE_09	OEINVCUOM
Unit Price 10	UNIT_PRICE_10	OEINVCUOM
Quantity	QUANTITY	OEINVCLINE
Total Inventory Goods Amount	INV_GOODS	OEINVOICE
Total Inventory Goods Base Amount	INV_GOODS_BSE	OEINVOICE

Order Entry GL Distribution


Attribute or measure name	Table field	Archive source table
Company	Company	GLSYSTEM
Name	NAME	OECOMPANY
Acct Unit	ACCT_UNIT	OEDIST
Customer	CUSTOMER	OEDIST
Account	ACCOUNT	OEDIST
Sub Account	SUB_ACCOUNT	OEDIST
Base Nd	BASE_ND	OECOMPANY
Invoice Number	INVC_NUMBER	OEDIST
Invoice Prefix	INVC_PREFIX	OEDIST
Line Nbr	LINE_NBR	OEDIST
Process Level	PROCESS_LEVEL	OEDIST
GL Date	GL_DATE	OEDIST
Posting Type	POSTING_TYPE	OEDIST
Currency Code	CURRENCY_CODE	OEDIST
Currency Amount	AMOUNT_CURR	OEDIST
Base Amount	AMOUNT_BASE	OEDIST

Order Entry Price List Item


Attribute or measure name	Table field	Archive source table
Company	Company	GLSYSTEM
Customer	CUSTOMER	ARCUSTOMER
Item	ITEM	OEPLITEM
Address 1	ADDR1	ARCOMP
Address 2	ADDR2	ARCOMP
Age Cred Pct 01	AGE_CRED_PCT_01	OECUST
Age Cred Pct 02	AGE_CRED_PCT_02	OECUST
Age Cred Pct 03	AGE_CRED_PCT_03	OECUST
Age Cred Pct 04	AGE_CRED_PCT_04	OECUST
Age Cred Pct 05	AGE_CRED_PCT_05	OECUST
Age Hold Cd 01	AGE_HOLD_CD_01	OECUST
Age Hold Cd 02	AGE_HOLD_CD_02	OECUST
Age Hold Cd 03	AGE_HOLD_CD_03	OECUST
Age Hold Cd 04	AGE_HOLD_CD_04	OECUST
Age Hold Cd 05	AGE_HOLD_CD_05	OECUST
Age Periods 01	AGE_PERIODS_01	ARCOMP
Age Periods 02	AGE_PERIODS_02	ARCOMP
Age Periods 03	AGE_PERIODS_03	ARCOMP
Age Periods 04	AGE_PERIODS_04	ARCOMP
Aging 01	AGING_01	ARCUSTOMER
Aging 02	AGING_02	ARCUSTOMER
Aging 03	AGING_03	ARCUSTOMER
Aging 04	AGING_04	ARCUSTOMER
Aging 05	AGING_05	ARCUSTOMER
Aging Code	AGING_CODE	ARCUSTOMER
Allow Returns	ALLOW_RETURNS	OECUST
Bank Transaction Code	BANK_INST_CODE	ARCUSTOMER
Base Number Of Decimals	BASE_ND	OECOMPANY
Begin Date	BEG_DATE	OEPLITEM
Broken Case Charge	BRKN_CS_CHRG	OECUST
Carrier	CARRIER	OECUST
Cash In Advance Required	CIA_FL	OECUST
Cash In Advance Required Percent	CIA_PCT	OECUST
City	CITY	ARCOMP
COD Order Hold Code	COD_HOLD_CODE	OECUST
Commission Split Percentage	COMM_SPLIT	OECUST
Contact	CONTACT	ARCUSTOMER
Country	COUNTRY	ARCOMP
County	COUNTY	ARCOMP
Credit Analyst	CREDIT_ANLYST	ARCUSTOMER
Credit Limit Date	CREDIT_LIM_DAT	ARCUSTOMER
Credit Limit Hold	CR_LIMIT_HOLD	OECOMPANY
Currency	CURRENCY_CODE	OECOMPANY
Currency Rate	CURR_RATE	OEPRCLIST
Customer Group	CUST_GROUP	CUST_GROUP
Default Customer ShipTo	DEF_SHIP_TO	OECUST
Default Shipping Location	DEF_LOCATION	OECUST
Default Shipping Method	DEF_METHOD	OECUST
Description	DESCRIPTION	OEPRCLIST
Last Return Authorization Date	ALLOW_RTN_DATE	OECUST
List Name	LIST_NAME	OEPLITEM
Price Base	BASE_NAME	OEPRCLIST
Promotion	PROMOTION	OEPLITEM
Receivable General Ledger Code	AR_CODE	ARCUSTOMER
Break Price 01	BRK_PRICE_01	OEPLITEM
Break Price 02	BRK_PRICE_02	OEPLITEM
Break Price 03	BRK_PRICE_03	OEPLITEM
Break Price 04	BRK_PRICE_04	OEPLITEM
Break Price 05	BRK_PRICE_05	OEPLITEM
Break Price 06	BRK_PRICE_06	OEPLITEM
Break Price 07	BRK_PRICE_07	OEPLITEM
Break Price 08	BRK_PRICE_08	OEPLITEM
Break Price 09	BRK_PRICE_09	OEPLITEM
Break Price 10	BRK_PRICE_10	OEPLITEM
Break Quantity 01	BRK_QTY_01	OEPLITEM
Break Quantity 02	BRK_QTY_02	OEPLITEM
Break Quantity 03	BRK_QTY_03	OEPLITEM
Break Quantity 04	BRK_QTY_04	OEPLITEM
Break Quantity 05	BRK_QTY_05	OEPLITEM
Break Quantity 06	BRK_QTY_06	OEPLITEM
Break Quantity 07	BRK_QTY_07	OEPLITEM
Break Quantity 08	BRK_QTY_08	OEPLITEM
Break Quantity 09	BRK_QTY_09	OEPLITEM
Break Quantity 10	BRK_QTY_10	OEPLITEM
Credit Limit	CREDIT_LIM	ARCUSTOMER
Credit Review Days	CREDIT_REVDAYS	ARCUSTOMER
Current Balance	CURR_BAL	ARCUSTOMER
Unit Price 01	UNIT_PRICE_01	OEPLITEM
Unit Price 02	UNIT_PRICE_02	OEPLITEM
Unit Price 03	UNIT_PRICE_03	OEPLITEM
Unit Price 04	UNIT_PRICE_04	OEPLITEM
Unit Price 05	UNIT_PRICE_05	OEPLITEM
Unit Price 06	UNIT_PRICE_06	OEPLITEM
Unit Price 07	UNIT_PRICE_07	OEPLITEM
Unit Price 08	UNIT_PRICE_08	OEPLITEM
Unit Price 09	UNIT_PRICE_09	OEPLITEM
Unit Price 10	UNIT_PRICE_10	OEPLITEM
Total COD Order Limit

Invoice Line Status


Attribute or measure name	Table field	Archive source table
Age Cred Pct 01	AGE_CRED_PCT_01	OECUST
Age Cred Pct 02	AGE_CRED_PCT_02	OECUST
Age Cred Pct 03	AGE_CRED_PCT_03	OECUST
Age Cred Pct 04	AGE_CRED_PCT_04	OECUST
Age Cred Pct 05	AGE_CRED_PCT_05	OECUST
Age Periods 01	AGE_PERIODS_01	ARCOMP
Age Periods 02	AGE_PERIODS_02	ARCOMP
Age Periods 03	AGE_PERIODS_03	ARCOMP
Age Periods 04	AGE_PERIODS_04	ARCOMP
Aging 01	AGING_01	ARCUSTOMER
Aging 02	AGING_02	ARCUSTOMER
Aging 03	AGING_03	ARCUSTOMER
Aging 04	AGING_04	ARCUSTOMER
Aging 05	AGING_05	ARCUSTOMER
Aging Code	AGING_CODE	ARCUSTOMER
Aging Hold Cd 01	AGE_HOLD_CD_01	OECUST
Aging Hold Cd 02	AGE_HOLD_CD_02	OECUST
Aging Hold Cd 03	AGE_HOLD_CD_03	OECUST
Aging Hold Cd 04	AGE_HOLD_CD_04	OECUST
Aging Hold Cd 05	AGE_HOLD_CD_05	OECUST
Allow Returns	ALLOW_RETURNS	OECUST
Backorder Allowed	BACK_ORD_FL	OECUST
Bank Transaction Code	BANK_INST_CODE	ARCUSTOMER
Batch Number	BATCH_NBR	OEINVOICE
Bill Of Exchange Balance	DRAFT_BAL	ARCUSTOMER
Billing Invoice	INVC_NUMBER	OEINVOICE
Billing Invoice Line	LINE_NBR	OEINVCLINE
Billing Invoice Prefix	INVC_PREFIX	OEINVOICE
Billing Line Item Required	LINE_ITEM_REQ	OECUST
Broken Case Charge	BRKN_CS_CHRG	OECUST
Carrier	CARRIER	OECUST
Cash In Advance Required	CIA_FL	OECUST
Cash In Advance Required Percent	CIA_PCT	OECUST
Cash On Delivery Order Hold Code	COD_HOLD_CODE	OECUST
Check Credit On Order Add	ENT_CHECK_FL	OECUST
Commission Split Percentage	COMM_SPLIT	OECUST
Company	Company	GL Company
Credit Analyst	CREDIT_ANLYST	ARCUSTOMER
Credit Limit	CREDIT_LIM	ARCUSTOMER
Credit Limit Date	CREDIT_LIM_DAT	ARCUSTOMER
Credit Limit Hold Code	CR_LIMIT_HOLD	OECUST
Credit Review Days	CREDIT_REVDAYS	ARCUSTOMER
Currency	CURRENCY_CD	ARCOMP
Current Aging Period	AGE_CURRENT	ARCOMP
Current Balance	CURR_BAL	ARCUSTOMER
Customer	CUSTOMER	ARCUSTOMER
Customer Major Class	MAJ_CLASS	ARCUSTOMER
Customer Minor Class	MIN_CLASS	ARCUSTOMER
Customer Order Acknowledgments	ACKNOW_FL	OECUST
Default Customer Ship To	DEF_SHIP_TO	OECUST
Default Shipping Method	DEF_METHOD	OECUST
Description	DESCRIPTION	OEINVCLINE
Disputed Invoice Amount	DISP_AMT	ARCUSTOMER
Disputed Invoices	DISP_NBR	ARCUSTOMER
Dsc Amt 01	DSC_AMT_01	OEINVCLINE
Dsc Amt 02	DSC_AMT_02	OEINVCLINE
Dsc Amt 03	DSC_AMT_03	OEINVCLINE
Entered Discount	ENTERED_DISC	OEINVOICE
Entered Discount Base Amount	ADD_ON_DISC	OEINVOICE
Entered Price	ENTERED_PRICE	OEINVCLINE
Freight Charge	FRT_CHARGE	OEINVOICE
Freight Charge Base Amount	FRT_CHARGE_B	OEINVOICE
Freight Code	FREIGHT_CODE	OECUST
Hold Code	HOLD_CODE	OEINVOICE
Incomplete	INCOMPLETE_FL	OECUST
Invoice Date	INVOICE_DATE	OEINVOICE
Item	ITEM	OEINVCLINE
Last Invoice Date	LAST_INV_DATE	ARCUSTOMER
Last Payment Date	LAST_PMT_DATE	ARCUSTOMER
Last Return Authorization Date	ALLOW_RTN_DATE	OECUST
Line Gross Amount	LINE_GRS_CURR	OEINVCLINE
Line Type	LINE_TYPE	OEINVCLINE
Proof Of Delivery Grace Period	GRACE_PER	OECUST
Receivable General Ledger Code	AR_CODE	ARCUSTOMER
Total COD Order Limit	COD_LIM	OECUST
Total Inventory Goods Amount	INV_GOODS	OEINVOICE
Total Inventory Goods Base Amount	INV_GOODS_BSE	OEINVOICE

Requisition Details


Attribute or measure name	Table field	Archive source table
Company	COMPANY	REQHEADER
Header Requesting Location	REQ_LOCATION	REQHEADER
Line Requesting Location	REQ_LOCATION	REQLINE
Requesting Location Name	NAME	RQLOC
Requester	REQUESTER	REQHEADER
Requester Name	NAME	REQUESTER
Requisition number	REQ_NUMBER	REQHEADER
Header Delivering Location	FROM_LOCATION	REQHEADER
Line Delivering Location	FROM_LOCATION	REQLINE
Header From Company	FROM_COMPANY	REQHEADER
Line From Company	FROM_COMPANY	REQLINE
Header Requested Delivery Date	REQ_DEL_DATE	REQHEADER
Line Requested Delivery Date	REQ_DEL_DATE	REQLINE
Item	ITEM	REQLINE
Requisition Status	STATUS	REQHEADER
Line Number	LINE_NBR	REQLINE
Requested Quantity	QUANTITY	REQLINE
UOM	ENTERED_UOM	REQLINE
PO Code	PO_CODE	REQLINE
Requisition Description	REQ_DESC	REQHEADER
Deliver To	DELIVER_TO	REQHEADER
Buyer	BUYER_CODE	REQHEADER
Item Type	ITEM_TYPE	REQLINE
Item Description	DESCRIPTION	REQLINE
Requested Vendor	VENDOR	REQLINE
Approval Level Attained	APRV_LEVEL	REQHEADER
Date Approved	LAST_APRV_DT	REQHEADER
Approval Level to Attain	ATTAIN_LEVEL	REQHEADER
Returned Quantity	RETURN_QTY	REQLINE
Purchase From Location	PURCH_FR_LOC	REQLINE
Interface Cancel Quantity	PIF_CXL_QTY	REQLINE
Unit Cost	UNIT_COST	REQLINE
Transaction Unit Cost	TRAN_UNIT_COST	REQLINE
Transaction Currency code	TRAN_CURR_CODE	REQLINE
Conversion Rate	CNV_RATE	REQLINE

Activity Transaction View 4


Attribute or measure name	Table field	Archive source table
Control Group	CONTROL_GROUP	ACCTLGRPHD
Control Group Description	DESCRIPTION	ACCTLGRPHD
Batch Date	BATCH_DATE	ACCTLGRPHD
Transaction Type	TRANS_TYPE	ACCTLGRPHD
Debit Total	DEBIT_TOTAL	ACCTLGRPHD
Credit Total	CREDIT_TOTAL	ACCTLGRPHD
Unit Debits	UNIT_DEBITS	ACCTLGRPHD
Unit Credits	UNIT_CREDITS	ACCTLGRPHD
Sequence Number	SEQUENCE_NBR	ACTRANS
Activity	ACTIVITY	ACTRANS
Activity Description	DESCRIPTION	ACACTIVITY
Account Category	ACCT_CATEGORY	ACTRANS
Account Category Description	DESCRIPTION	ACACCTCAT
System Code	SYSTEM	ACTRANS
Source Code	SOURCE_CODE	ACTRANS
Object ID	OBJ_ID	ACTRANS
Transaction Amount	TRAN_AMOUNT	ACTRANS
Units Amount	UNITS_AMOUNT	ACTRANS
Transaction Currency	TRAN_CURRENCY	ACTRANS
Description	DESCRIPTION	ACTRANS
Company	COMPANY	ACTRANS
Accounting Unit	ACCT_UNIT	ACTRANS
Account	ACCOUNT	ACTRANS
Subaccount	SUB_ACCOUNT	ACTRANS
Reference	REFERENCE	ACTRANS
Transaction Date	TRAN_DATE	ACTRANS
Activity Group Amount	AG_AMOUNT	ACTRANS
Activity Group Currency	AG_CURRENCY	ACTRANS
Activity Group Base Rate	AG_BASERATE	ACTRANS
Activity Amount	ACT_AMOUNT	ACTRANS
Activity Currency	ACT_CURRENCY	ACTRANS
Activity Base Rate	ACT_BASERATE	ACTRANS
Rpt Amount 1	RPT_AMOUNT_1	ACTRANS
Currency Code 1	CURR_CODE_1	GLSYSTEM
Rpt Rate 1	RPT_RATE_1	ACTRANS
Rpt Amount 2	RPT_AMOUNT_2	ACTRANS
Currency Code 2	CURR_CODE_2	GLSYSTEM
Rpt Rate 2	RPT_RATE_2	ACTRANS
Currency Code	CURRENCY_CODE	GLSYSTEM
Activity Group	ACTIVITY_GRP	ACTRANS
Name	NAME	GLSYSTEM
Posting Date	POSTING_DATE	ACTRANS
Status	STATUS	ACTRANS
Fiscal Year	FISCAL_YEAR	ACTRANS

Job Relationships


Attribute or measure name	Table field	Archive source table
Company	COMPANY	JOBRELATE
Job Code	JOB_CODE	JOBRELATE
Job Code Description	DESCRIPTION	JOBCODE
Position	R_POSITION	JOBRELATE
Position Description	DESCRIPTION	PAPOSITION
Type	TYPE	JOBRELATE
Pers Code	PERS_CODE	JOBRELATE
HR Code Description	DESCRIPTION	PCODES
Wght	WGHT	JOBRELATE
Essential	REQUIRED_FLAG	JOBRELATE
Percent of Time	PCT_OF_TIME	JOBRELATE
Profic Level	PROFIC_LEVEL	JOBRELATE
Educ Level	EDUC_LEVEL	PCODES
Subject	SUBJECT_CODE	JOBRELATE
Process Level	PROCESS_LEVEL	JOBRELATE

OSHA Incident History


Attribute or measure name	Table field	Archive source table
Company	COMPANY	OSHA
Employee	EMPLOYEE	OSHA
Establishment	ESTABLISHMENT	OSHA
Seq Nbr	SEQ_NBR	OSHA
Description	DESCRIPTION	OSHA
Incid Status	INCID_STATUS	OSHA
Date	R_DATE	OSHA
Age	AGE	OSHA
Sex	SEX	OSHA
Incid Cat	INCID_CAT	OSHA
Ill Inj	ILL_INJ	OSHA
Incident	INCIDENT	OSHA
Illness Type	ILLNESS_TYPE	OSHA
Illness	ILLNESS	OSHA
Outcome	OUTCOME	OSHA
Death	DEATH	OSHA
Dead Date	DEAD_DATE	OSHA
Wc Flag	WC_FLAG	OSHA
Wc Claim	WC_CLAIM	OSHA
Govt Flag	GOVT_FLAG	OSHA
Govt Case	GOVT_CASE	OSHA
Prior Estab	PRIOR_ESTAB	OSHA
Prior Seq Nbr	PRIOR_SEQ_NBR	OSHA
Osha Flag	OSHA_FLAG	OSHA
How	HOW_01,HOW_02	OSHA
Body Part Cd	BODY_PART_CD	OSHA
Body Part	BODY_PART	OSHA
Obj Subs	OBJ_SUBS	OSHA
Sharp Device	SHARP_DEVICE	OSHA
Brnd Sharp Dev	BRND_SHARP_DEV	OSHA
Reports To	REPORTS_TO	OSHA
Report To Name	REPORT_TO_NAME	OSHA
Reports By	REPORTS_BY	OSHA
Report By Name	REPORT_BY_NAME	OSHA
Emp Status	EMP_STATUS	OSHA
Process Level	PROCESS_LEVEL	OSHA
Department	DEPARTMENT	OSHA
Locat Code	LOCAT_CODE	OSHA
Job Code	JOB_CODE	OSHA
Shift	SHIFT	OSHA
Supervisor Emp	SUPERVISOR_EMP	OSHA
Cmp Prem	CMP_PREM	OSHA
Addr1	ADDR1	OSHA
City	CITY	OSHA
State	STATE	OSHA
Zip	ZIP	OSHA
Country Code	COUNTRY_CODE	OSHA
First Aid By	FIRST_AID_BY	OSHA
First Aid Name	FIRST_AID_NAME	OSHA
Severity	SEVERITY	OSHA
Physician	PHYSICIAN	OSHA
Phy Fst Name	PHY_FST_NAME	OSHA
Phy Lst Name	PHY_LST_NAME	OSHA
Phy Mid Init	PHY_MID_INIT	OSHA
Patient Flag	PATIENT_FLAG	OSHA
Hospital	HOSPITAL	OSHA
Hosp Name	HOSP_NAME	OSHA
Time Start Wk	TIME_START_WK	OSHA
Time End Wk	TIME_END_WK	OSHA
Date Injury	DATE_INJURY	OSHA
Time Injury	TIME_INJURY	OSHA
Date Last Work	DATE_LAST_WORK	OSHA
Time Last Work	TIME_LAST_WORK	OSHA
Date Out	DATE_OUT	OSHA
Date 1	DATE_1	OSHA
Time 1	TIME_1	OSHA
Date 2	DATE_2	OSHA
Time 2	TIME_2	OSHA
Date Returned	DATE_RETURNED	OSHA
Time Returned	TIME_RETURNED	OSHA
Date Notified1	DATE_NOTIFIED1	OSHA
Time Notified1	TIME_NOTIFIED1	OSHA
Date Notified2	DATE_NOTIFIED2	OSHA
Time Notified2	TIME_NOTIFIED2	OSHA
Hours Flag	HOURS_FLAG	OSHA
Days Out	DAYS_OUT	OSHA
Work Flag	WORK_FLAG	OSHA
Days Rest	DAYS_REST	OSHA
Wages Flag	WAGES_FLAG	OSHA
Cost	COST	OSHA
Currency Code	CURRENCY_CODE	OSHA
Witness	WITNESS	OSHA
Wit Name	WIT_NAME	OSHA
Wit Addr1	WIT_ADDR1	OSHA
Wit City	WIT_CITY	OSHA
Wit State	WIT_STATE	OSHA
Wit Zip	WIT_ZIP	OSHA
Wit Cntry Cd	WIT_CNTRY_CD	OSHA
Wit Phn Cntry	WIT_PHN_CNTRY	OSHA
Wit Phone Nbr	WIT_PHONE_NBR	OSHA
Wit Phone Ext	WIT_PHONE_EXT	OSHA
User Field1	USER_FIELD1	OSHA
User2	USER2	OSHA
User3	USER3	OSHA
Incident Nbr	INCIDENT_NBR	PAFOLLOWUP
Effect Date	EFFECT_DATE	PAFOLLOWUP
Follow Stat	FOLLOW_STAT	PAFOLLOWUP
Follow Cat	FOLLOW_CAT	PAFOLLOWUP
Follow Type	FOLLOW_TYPE	PAFOLLOWUP
Performed By	PERFORMED_BY	PAFOLLOWUP
Comment	COMMENT	PAFOLLOWUP
Base Currency	BASE_CURRENCY	PAINCICOST
Cost Cat	COST_CAT	PAINCICOST
Cost Type	COST_TYPE	PAINCICOST
Expense Company	EXP_COMPANY	PAINCICOST
Expense Accounting Unit	EXP_ACCT_UNIT	PAINCICOST
Expense Account	EXP_ACCOUNT	PAINCICOST
Expense Sub Account	EXP_SUB_ACCT	PAINCICOST
Base Amount	BASE_AMOUNT	PAINCICOST

Employee Tax Details


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMDEDMASTR
Employee	EMPLOYEE	EMDEDMASTR
Effective Date	EFFECT_DATE	EMDEDMASTR
End Date	END_DATE	EMDEDMASTR
Deduction Code	DED_CODE	EMDEDMASTR
Res Code	RES_CODE	EMDEDMASTR
Marital Status	MARITAL_STATUS	EMDEDMASTR
Exemptions	EXEMPTIONS	EMDEDMASTR
Exempt Amount	EXEMPT_AMOUNT	EMDEDMASTR
Tax Exmemption Flag	TAX_EXEMPT_FLG	EMDEDMASTR
Cert Code	CERT_CODE	EMDEDMASTR
Pers Exempts	PERS_EXEMPTS	EMDEDMASTR
Depend Exempts	DEPEND_EXEMPTS	EMDEDMASTR
Addl Exempts	ADDL_EXEMPTS	EMDEDMASTR
Addl Exemp Amt	ADDL_EXEMP_AMT	EMDEDMASTR
Addl Tax Code	ADDL_TAX_CODE	EMDEDMASTR
Addl Rate	ADDL_RATE	EMDEDMASTR
Addl Amount	ADDL_AMOUNT	EMDEDMASTR
Formula Number	FORMULA_NUMBER	EMDEDMASTR
Net Claim Amt	NET_CLAIM_AMT	EMDEDMASTR
Prescribedarea	PRESCRIBEDAREA	EMDEDMASTR
Approved Stock	APPROVED_STOCK	EMDEDMASTR
Auth Tax Cred	AUTH_TAX_CRED	EMDEDMASTR
Auth Tax Ded	AUTH_TAX_DED	EMDEDMASTR
Married Equiv	MARRIED_EQUIV	EMDEDMASTR
Age 65 Over	AGE_65_OVER	EMDEDMASTR
Emp Disability	EMP_DISABILITY	EMDEDMASTR
Dep Under 18	DEP_UNDER_18	EMDEDMASTR
Dep Dis Ovr 17	DEP_DIS_OVR_17	EMDEDMASTR
Non Ind Cl Amt	NON_IND_CL_AMT	EMDEDMASTR
Student Pen Ex	STUDENT_PEN_EX	EMDEDMASTR
Td1 Filing Dat	TD1_FILING_DAT	EMDEDMASTR
Td1 Adjust Dat	TD1_ADJUST_DAT	EMDEDMASTR
Tot Clm Amt Fl	TOT_CLM_AMT_FL	EMDEDMASTR
Claim Code	CLAIM_CODE	EMDEDMASTR
Trans Ytd Wage	TRANS_YTD_WAGE	EMDEDMASTR
Trans Ytd Tax	TRANS_YTD_TAX	EMDEDMASTR
Trans Year	TRANS_YEAR	EMDEDMASTR
Locat Code	LOCAT_CODE	PRTAXLOC
Sequence Number	SEQ_NBR	EMDEDMASTR

AP Payment History View 3


Attribute or measure name	Table field	Archive source table
Pay Group	PAY_GROUP	APPAYMENT
Base BOE Amount	BASE_ACT_AMT	APPAYMENT
Cash Code	CASH_CODE	APPAYMENT
Payment Code	BANK_INST_CODE	APPAYMENT
Payment Date	CHECK_DATE	APPAYMENT
Vendor	VENDOR	APPAYMENT
Invoice	INVOICE	APPAYMENT
Suffix	SUFFIX	APPAYMENT
Voucher	VOUCHER_NBR	APINVOICE
Authority Code	AUTH_CODE	APINVOICE
Process Level	PROC_LEVEL	APPAYMENT
Due Date	DUE_DATE	APPAYMENT
Discount Date	DISC_DATE	APPAYMENT
Company	COMPANY	APPAYMENT
Sequence Number	SEQ_NBR	APPAYMENT
Payment Number	TRANS_NBR	APPAYMENT
Discount Lost	DISC_LOST_FLG	APPAYMENT
Cancel Sequence	CANCEL_SEQ	APPAYMENT
Transaction Payment Amount	TRAN_PMT_AMT	APPAYMENT

Bank History


Attribute or measure name	Table field	Archive source table
Company	COMPANY	CBTRANS
Cash Code	CASH_CODE	CBTRANS
Description	DESCRIPTION	CBCASHCODE
TransactionDescription	DESCRIPTION	CBTRANS
Transaction Number	TRANS_NBR	CBTRANS
Transaction ID	TRANS_IDENT	CBTRANS
Transaction Code Description	BANK_INST_DESC	CBBANKINST
Reconciliation Date	RECON_DATE	CBTRANS
Posting Date	DIST_DATE	CBTRANS
Journal Book	JRNL_BOOK_NBR	CBTRANS
Issued Date	ISSUE_DATE	CBTRANS
Bank Transaction Code	BANK_INST_CODE	CBTRANS
Bank Account Currency	CURRENCY_CODE	CBCASHCODE
Acc Currency Reconciled Amount	RECON_BNK_AMT	CBTRANS
Base Currency Reconciled Amount	RECON_BASE_AMT	CBTRANS
Base Currency Issued Amount	ISSUE_BASE_AMT	CBTRANS

Cash Receipts


Attribute or measure name	Table field	Archive source table
Cash Code	CASH_CODE	CBRECPTHDR
Description	DESCRIPTION	CBCASHCODE
Currency Code	CURRENCY_CODE	CBCASHCODE
Transaction Code	BANK_INST_CODE	CBRECPTHDR
Deposit Number	TRANS_NBR	CBRECPTHDR
Company	COMPANY	CBRECPTHDR
Deposit Date	DEPOSIT_DATE	CBRECPTHDR
Deposit Amount	DEPOSIT_AMOUNT	CBRECPTHDR
Record Status	REC_STATUS	CBRECPTHDR
Journal Book	JRNL_BOOK_NBR	CBRECPTHDR
Cash Receipt Category	PROD_TAX_CAT	CBRECPTDTL
To Company	RCPT_COMPANY	CBRECPTDTL
GL Accounting Unit	RCPT_ACCT_UNIT	CBRECPTDTL
GL Account Number	RCPT_ACCOUNT	CBRECPTDTL
GL Subaccount	RCPT_SUB_ACCT	CBRECPTDTL
Receipt Amount	RECEIPT_AMOUNT	CBRECPTDTL
Tax Code	TAX_CODE	CBRECPTDTL
Taxable Amount	TAXABLE_AMT	CBRECPTDTL
Tax Amount	TAX_AMOUNT	CBRECPTDTL

Beneficiary


Attribute or measure name	Table field	Archive source table
Benefit Type	BENEF_TYPE	BENEFICRY
Company	COMPANY	BENEFICRY
Create Date	CREATE_DATE	BENEFICRY
Create Time	CREATE_TIME	BENEFICRY
Date Stamp	DATE_STAMP	BENEFICRY
Employee	EMPLOYEE	BENEFICRY
First Name	FIRST_NAME	BENEFICRY
Last Name	LAST_NAME	BENEFICRY
Percent Amount Indicator	PCT_AMT_FLAG	BENEFICRY
Plan Code	PLAN_CODE	BENEFICRY
Plan Type	PLAN_TYPE	BENEFICRY
BNF Payment Amount	PMT_AMT	BENEFICRY
Primary Contigent Indicator	PRIM_CNTGNT	BENEFICRY
Relationship Code	REL_CODE	BENEFICRY
Social Number	FICA_NBR	BENEFICRY
Comment Text	CMT_TEXT	BENEFICRY
Sequence Number	SEQ_NBR	BENEFICRY
Time Stamp	TIME_STAMP	BENEFICRY
Trust	TRUST	BENEFICRY

Employee Benefit View 2


Attribute or measure name	Table field	Archive source table
Aft Sequence	AFT_SEQ_NBR	BENEFIT
EBC Annual Amount	ANNUAL_AMT	BENEFIT
EBC Bond Deduction Amount	BOND_DED_AMT	BENEFIT
AFT Company Deduction Sequence	CMP_AFT_SEQ	BENEFIT
EBC Company Flex Amount	CMP_FLX_CONT	BENEFIT
Company Deduction Sequence	CMP_SEQ_NBR	BENEFIT
CNT Age Date	CNT_AGE_DATE	BENEFIT
CNT Salary Date	CNT_SAL_DATE	BENEFIT
CNT Service Date	CNT_SERV_DATE	BENEFIT
Company	COMPANY	BENEFIT
EBC Company Contribution Amount	COMP_CONT	BENEFIT
Company Match Percent	COMP_MATCH	BENEFIT
EBC Flat Amount	COVER_AMT	BENEFIT
Coverage Age Date	COV_AGE_DATE	BENEFIT
Coverage Group	COV_GROUP	BENEFIT
Coverage option	COV_OPTION	BENEFIT
Override Cover Flag	COV_OVER_FLG	BENEFIT
Coverage Salary Date	COV_SAL_DATE	BENEFIT
Coverage Update Date	COV_UPD_DT	BENEFIT
Create Time	CREATE_TIME	BENEFIT
Create User ID	CREATE_USER_ID	BENEFIT
Creation Date	CREATION_DATE	BENEFIT
Currency Code	CURRENCY_CODE	BENEFIT
Currency Nd	CURR_ND	BENEFIT
Cycles Remain	CYCLES_REMAIN	BENEFIT
Deduction Start Date	DED_START_DATE	BENEFIT
Deduction Stop Date	DED_STOP_DATE	BENEFIT
EBC Dependent Coverage Amount	DEP_COVER_AMT	BENEFIT
EFD Start Date	EFD_START_DATE	BENEFIT
Eligibility Group	ELIG_GROUP	BENEFIT
Eligibility Update Date	ELIG_UPD_DT	BENEFIT
Employee	EMPLOYEE	BENEFIT
EBC Employee AFT Contribution Amoun	EMP_AFT_CONT	BENEFIT
EBC Employee Pre Tax contribution Amount	EMP_PRE_CONT	BENEFIT
EBC Employee YTD contribution	EMP_YTD_CONT	BENEFIT
Flex Deduction Sequence	FLEX_DED_SEQ	BENEFIT
Flex Plan	FLEX_PLAN	BENEFIT
GL Update Date	GL_UPD_DT	BENEFIT
Last Purchase Sequence	LAST_SEQ_PURCH	BENEFIT
Match Percentage	MTCH_UP_TO	BENEFIT
Multiple	MULTIPLE	BENEFIT
EBC Hours	NBR_HOURS	BENEFIT
EBC Bonds	NBR_PURCH	BENEFIT
Pay Rate	PAY_RATE	BENEFIT
Percent Amount Indicator	PCT_AMT_FLAG	BENEFIT
Pend Evidence	PEND_EVIDENCE	BENEFIT
Plan Code	PLAN_CODE	BENEFIT
Plan Option	PLAN_OPTION	BENEFIT
Plan Type	PLAN_TYPE	BENEFIT
Premium Group	PREM_GROUP	BENEFIT
Premium Update Date	PREM_UPD_DT	BENEFIT
Prem AFT Flag	PRE_AFT_FLAG	BENEFIT
Pre Tax Deduction Sequence	PRE_SEQ_NBR	BENEFIT
Start Date	START_DATE	BENEFIT
STM Sequence	STM_SEQ_NBR	BENEFIT
Stop Date	STOP_DATE	BENEFIT
Object Identifier	TA_OBJ_ID	BENEFIT
Time Stamp	TIME_STAMP	BENEFIT
Sequence Number	TRAN_SEQ_NBR	BENEFIT
Update Date	UPD_DATE	BENEFIT
User ID	USER_ID	BENEFIT
EBC YTD Contribution Amount	YTD_CONT	BENEFIT
EBC YTD Flex Contribution Amount	YTD_FLEX_CONT	BENEFIT

Employee Compensation History


Attribute or measure name	Table field	Archive source table
Company	COMPANY	COMPHIST
Employee	EMPLOYEE	COMPHIST
Plan Type	PLAN_TYPE	COMPHIST
Plan Code	PLAN_CODE	COMPHIST
Description	R_DESC	R_Plan
Start Date	START_DATE	R_Plan
Plan Year	PLAN_YEAR	COMPHIST
CPH Hours Service	HOURS_SERV	COMPHIST
CPH Compensation Amount	COMP_AMOUNT	COMPHIST
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Last Prefix	trim([DA_HR11Employee.LAST_NAME_PRE] + ' ' + [DA_HR11Employee.LAST_NAME])	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Name Suffix	NAME_SUFFIX	EMPLOYEE
Process Level	PROC_LEVEL	EMPLOYEE
Security Level	SEC_LVL	EMPLOYEE
Security Location	SEC_LOCATION	EMPLOYEE
Stop Date	STOP_DATE	R_Plan
Date Stamp	DATE_STAMP	COMPHIST
Time Stamp	TIME_STAMP	COMPHIST
Create Time	CREATE_TIME	COMPHIST
Create Date	CREATE_DATE	COMPHIST

Genera Ledger Amounts and Units


Attribute or measure name	Table field	Archive source table
Company	Company	GLSYSTEM
Account	Account `	GLMASTER
Fiscal Year	Fiscal_Year	GLTRANS
Chart Name	Chart_Name	GLSYSTEM
Accounting Unit	Acct_Unit	GLMASTER
Sub Account	Sub_Account	GLCHARTDTL
Fiscal Period	NA	NA
Variable Levels	Var_Levels	GLMASTER
Description	Description	GLNAMES
Level Depth	Level_Depth	GLNAMES
Level Detail 01	Level_Detail_01	GLNAMES
Level Detail 02	Level_Detail_02	GLNAMES
Level Detail 03	Level_Detail_03	GLNAMES
Level Detail 04	Level_Detail_04	GLNAMES
Level Detail 05	Level_Detail_05	GLNAMES
Person Responsible	Person_Resp	GLNAMES
Posting Flag	Posting_Flag	GLNAMES
Variable Levels Display	Var_Levels_Disp	GLNAMES
Base Accounting Unit	Bs_Acct_Unit	GLSYSTEM
Close Sequence	Close_Seq_01	GLSYSTEM
Number of Decimals	Company_Nd	GLSYSTEM
Currency Exchange	Curr_Conv_Flag	GLSYSTEM
Currency Table Name	Curreny_Table	GLSYSTEM
Error Suspense Journal Book	Error_Sp_Jbook	GLSYSTEM
Interlevel Balance Flag	Intlv_Bal_Flag	GLSYSTEM
Journal by Doc	Journal_By_Doc	GLSYSTEM
Number of Accounting Periods	Nbr_Acct_Pers	GLSYSTEM
GL Actual Amount	Db_Amount_01 to 10, Cr_Amount_01 to 10	GLAMOUNTS
GL Actual Amount YTD	Db_Amount_01 to 10, Cr_Amount_01 to 10	GLAMOUNTS
GL Begin Amount	Db_Amount_01 to 10, Cr_Amount_01 to 10, Db_Beg_Bal, Cr_Beg_Bal	GLAMOUNTS
GL End Amount	Db_Amount_01 to 10, Cr_Amount_01 to 10, Db_Beg_Bal, Cr_Beg_Bal	GLAMOUNTS
GL Actual Units	Db_Units_01 to 10, Cr_Units_01 to 10	GLUNITS
GL Actual Units YTD	Db_Units_01 to 10, Cr_Units_01 to 10	GLUNITS
GL Begin Units	Db_Beg_Bal, Cr_Beg_Bal, Db_Units_01 to 10, Cr_Units_01 to 10	GLUNITS
GL End Units	Db_Beg_Bal, Cr_Beg_Bal, Db_Units_01 to 10, Cr_Units_01 to 10	GLUNITS

General Ledger Budget History


Attribute or measure name	Table field	Archive source table
Budget Number	Budget_Number	FBHEADER
Fiscal Year	Fiscal_Year	GLTRANS
Company	Company	GLSYSTEM
Chart Name	Chart_Name	FBDETAIL
Accounting Unit	Acct_Unit	GLMASTER
Account	Account	FBDETAIL
Sub Account	Sub_Account	FBDETAIL
Fiscal Period	NA	NA
GL Budget Beginning Balance	Db_Beg_Bal, Cr_Beg_Bal, Db_Amount_01 to 10, Cr_Amount_01 to 10	FBDETAIL
GL Budget Amount	Db_Amount_01 to 10, Cr_Amount_01 to 10	FBDETAIL
GL Budget Amount YTD	Db_Amount_01 to 10, Cr_Amount_01 to 10	FBDETAIL
GL Budget Ending Balance	Db_Beg_Bal, Cr_Beg_Bal, Db_Amount_01 to 10, Cr_Amount_01 to 10	FBDETAIL
GL Beginning Balance Units	Db_Beg_Bal_Unt, Cr_Beg_Bal_Unt, Db_Units_01 to 10, Cr_Units_01 to 10	FBDETAIL
GL Budget Units	Db_Units_01 to 10, Cr_Units_01 to 10	FBDETAIL
GL Budget Units YTD	Db_Units_01 to 10, Cr_Units_01 to 10	FBDETAIL
GL Ending Balance Units	Db_Beg_Bal_Unt, Cr_Beg_Bal_Unt, Db_Units_01 to 10, Cr_Units_01 to 10	FBDETAIL

Actuals vs Budgets


Attribute or measure name	Table field	Archive source table
Company	Company	GLSYSTEM
Account	Account	GLMASTER
Fiscal Year	Fiscal_Year	GLTRANS
Chart Name	Chart_Name	GLCHARTDTL
Accounting Unit	Acct_Unit	GLMASTER
Sub Account	Sub_Account	GLCHARTDTL
Chart Section	Chart_Section	GLCHARTDTL
Fiscal Period	NA	NA
GL Actual Amount	Db_Amount_01 to 10, Cr_Amount_01 to 10	GLAMOUNTS
GL Budget Amount	Db_Amount_01 to 10, Cr_Amount_01 to 10	FBDETAIL
GL Actual Amount YTD	Db_Amount_01 to 10, Cr_Amount_01 to 10	GLAMOUNTS
GL Budget Amount YTD	Db_Amount_01 to 10, Cr_Amount_01 to 10	FBDETAIL

General Ledger Transaction History


Attribute or measure name	Table field	Archive source table
Company	Company	GLSYSTEM
Accounting Unit	Acct_Unit	GLTRANS
Fiscal Year	Fiscal_Year	GLTRANS
Account	Account	GLTRANS
Sequence Transaction Number	SEQ_TRANS_NBR	GLTRANS
Line Number	Line_Nbr	GLTRANS
System	System	GLCONTROL
Originating Program	Orig_Program	GLTRANS
Control Group	Control_Group	GLTRANS
Journal Entry	Je_Type	GLCONTROL
Person Responsible	Person_Resp	GLNAMES
Description	Description	GLTRANS
Account Period	Acct_Period	GLCONTROL
Released Flag	Released_Flag	GLCONTROL
Journal Book Sequence Number	Jbk_Seq_Nbr	GLCONTROL
Variable Levels Display	Var_Level_Disp	GlNAMES
Update Date	Update_Date	GLTRANS
To Company	To_Company	GLTRANS
Sub Account	Sub_Account	GLTRANS
Status	Status	GLTRANS
Posting Date	Posting_Date	GLTRANS
Last Update Date	Last_Updt_Date	GLTRANS
Effective Date	Effect_Date	GLTRANS
Currency Code	Currency_Code	GLTRANS
Control Group	Control_Group	GLTRANS
Base Rate	Baserate	GLTRANS
Accounting Category	Acct_Category	GLTRANS
Account Currency Amount	Acct_Amount	GLTRANS
Base Currency Amount	Base_Amount	GLTRANS
Transaction Currency Amount	Tran_Amount	GLTRANS
Units Amount	Units_Amount	GLTRANS

Data Archive Reporting fields

Employee Absence Plan View 1

Employee Transaction Detail View 1

Absence Plan Structure View 1

Absence Plan Structure View 2

Service Rule

Service Code Listing

Service Class and Code

Vendor Group

Vendor Master Record

Employee

Employee Dependent

Employee Emergency Contact

Employee Multiple Positions and Jobs

Employee Medical and Work Description

Employee Codes

Employee Performance Review

Personnel Action History

Employee Rate History Report

Grievance Disciplinary Actions

Positions

Training History Report

Employee ACH Account

Employee Deductions

Employee Garnishments

Employee Payment Master View 2

Employee Payment Master View 1

Employee Payment Master View 3

Activity Budget Header

Activity Transaction View 1

Activity Transaction View 3

Activity Budget

Activity Transaction View 2

Employee Absence Plan View 2

Employee Transaction Detail View 2

Warehouse Demand View 2

Inventory Transaction View 1

Warehouse Demand View 1

Item Location View 2

Item Location View 1

Inventory Transaction View 2

Item Master

Asset Transaction

Asset Book History View 2

Asset Book Transactions

Asset Book History View 1

Asset Book History View 3

Purchase Order Master View 1

Vendor Agreement

PO Line Item Receivings

Purchase Order Master

Invoice Payment View 3

Accounts Payable Invoice

Invoice Distribution History

AP Payment History View 2

Invoice Payment View 1

AP Payment History View 1

Accounts Payable Cash Payment

Account Payable Invoice View 2

Invoice Payment View 2

Invoice Distribution

Employee Vesting Hours

Benefit Plan

Stock Purchase Plan History

Employee Benefit View 4

Savings Bond Beneficiary

Spending Account Transactions

Participant Benefit

Employee Benefit View 5

Employee Benefit View 6

Employee Benefit View 3

Employee Benefit View 1

AR Distributions

AR Customer Period Totals

AR Payment

AR Transaction View 1

AR Distributions

AR Transaction View 2

AR Payment Transactions

Order Invoice