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	ALLOT_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 Hours	AVAIL_HRS_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
User Id	User_Id	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 Number	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	APVENLOC
Vendor Class	VEN_CLASS	APVENMAST
Vendor Status	VENDOR_STATUS	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
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
Enclosure	ENCLOSURE	APVENMAST
Match Table	MATCH_TABLE	APVENMAST
Rule Group	RULE_GROUP	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
Origin Date	ORIGIN_DATE	APVENMAST
Minimum Claim Amount	CB_MINIMUM_AMT	APVENMAST

Employee


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	EMPLOYEE	EMPLOYEE
Activity	ACTIVITY	EMPLOYEE
Employee Name	LAST_NAME	EMPLOYEE
Account Category	ACCT_CATEGORY	EMPLOYEE
Add Allowance Amount	ADD_ALLOW_AMT	EMPLOYEE
Add Allowance Hours	ADD_ALLOW_HRS	EMPLOYEE
Add Allowance Per	ADD_ALLOW_PER	EMPLOYEE
Address 1	ADDR1	EMPLOYEE
Address 2	ADDR2	EMPLOYEE
Address 3	ADDR3	EMPLOYEE
Adjusted Hire Date	ADJ_HIRE_DATE	EMPLOYEE
Alternate Rate Exist	ALT_RATE_EXIST	EMPLOYEE
Anniversary Date	ANNIVERS_DATE	EMPLOYEE
Auto Time Record	AUTO_TIME_REC	EMPLOYEE
Automatic Deposit	AUTO_DEPOSIT	EMPLOYEE
BSI Group	BSI_GROUP	EMPLOYEE
Bus Number Group	BUS_NBR_GRP	EMPLOYEE
City	CITY	EMPLOYEE
Country Code	COUNTRY_CODE	EMPLOYEE
Creation Date	CREATION_DATE	EMPLOYEE
Currency Code	CURRENCY_CODE	EMPLOYEE
Date Hired	DATE_HIRED	EMPLOYEE
Deceased	DECEASED	EMPLOYEE
Department	DEPARTMENT	EMPLOYEE
Effort Flag	EFFORT_FLAG	EMPLOYEE
EIC Status	EIC_STATUS	EMPLOYEE
Email Address	EMAIL_ADDRESS	EMPLOYEE
Employee OT Exempt	EXEMPT_EMP	EMPLOYEE
Employee Status	EMP_STATUS	EMPLOYEE
Encumber Flag	ENCUMBER_FLAG	EMPLOYEE
Est Remuneration	EST_REMUN	EMPLOYEE
First Name	FIRST_NAME	EMPLOYEE
First Name UC	FIRST_NAME_UC	EMPLOYEE
Fringe Account	FRNG_ACCOUNT	EMPLOYEE
Fringe Account Category	FRNG_ACCT_CAT	EMPLOYEE
Fringe Sub Account	FRNG_SUB_ACCT	EMPLOYEE
Fringe Rate	FRNG_RATE	EMPLOYEE
FTE Number	NBR_FTE	EMPLOYEE
FTE Total	FTE_TOTAL	EMPLOYEE
HICN	HICN	EMPLOYEE
Home Account	HM_ACCOUNT	EMPLOYEE
Home Acct Unit	HM_ACCT_UNIT	EMPLOYEE
Home Sub Account	HM_SUB_ACCT	EMPLOYEE
Home Dist Company	HM_DIST_CO	EMPLOYEE
HR11EmployeeKey	COMPANY	EMPLOYEE
Indirect Supervisor	SUPERVISOR_IND	EMPLOYEE
Job Code	JOB_CODE	EMPLOYEE
Labor Distribution Flag	LAB_DIST_FLAG	EMPLOYEE
Last Comment Sequence Number	LAST_CMT_SEQ	EMPLOYEE
Last Day Paid	LAST_DAY_PAID	EMPLOYEE
Last Deduction Sequence Number	LAST_DED_SEQ	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Last Name UC	LAST_NAME_UC	EMPLOYEE
Max Limit Override	MAX_LIMIT_OVRD	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Middle Name	MIDDLE_NAME	EMPLOYEE
Moving Expenses	MOVING_EXP	EMPLOYEE
Name Prefix	NAME_PREFIX	EMPLOYEE
Name Suffix	NAME_SUFFIX	EMPLOYEE
New Hire Date	NEW_HIRE_DATE	EMPLOYEE
Nick Name	NICK_NAME	EMPLOYEE
OT Plan Code	OT_PLAN_CODE	EMPLOYEE
Pay Frequency	PAY_FREQUENCY	EMPLOYEE
Pay Grade	PAY_GRADE	EMPLOYEE
Pay Step	PAY_STEP	EMPLOYEE
Pending Action Date	PEND_ACT_DATE	EMPLOYEE
Personal Email	EMAIL_PERSONAL	EMPLOYEE
Pin	PIN	EMPLOYEE
Position	R_POSITION	EMPLOYEE
Primary Certifier Company	PRMCERT_COMP	EMPLOYEE
Primary Certifier ID	PRMCERT_ID	EMPLOYEE
Process Level	PROCESS_LEVEL	EMPLOYEE
Public Sector Retirement	PUB_SEC_RETIRE	EMPLOYEE
Quebec Enterprise Number Group	QC_ENT_NBR_GRP	EMPLOYEE
Railroad code	RAILROAD_CODE	EMPLOYEE
Remote	REMOTE	EMPLOYEE
Reportable Insurance Cost	RPT_INS_COST	EMPLOYEE
Reporting Currency	RPT_CURR	EMPLOYEE
Salary Class	SALARY_CLASS	EMPLOYEE
Schedule	SCHEDULE	EMPLOYEE
Secondary Certifier ID	SNDCERT_ID	EMPLOYEE
Secondary Certifier Company	SNDCERT_COMP	EMPLOYEE
Security Level	SEC_LVL	EMPLOYEE
Security Location	SEC_LOCATION	EMPLOYEE
Shift	SHIFT	EMPLOYEE
Sick Pay	SICK_PAY	EMPLOYEE
Social Security Number	FICA_NBR	EMPLOYEE
SSN Last4	FICA_NBR_LAST4	EMPLOYEE
ST Status	ST_STATUS	EMPLOYEE
State	STATE	EMPLOYEE
Supervisor	SUPERVISOR	EMPLOYEE
Tax City	TAX_CITY	EMPLOYEE
Tax County	TAX_COUNTY	EMPLOYEE
Tax Province	TAX_PROVINCE	EMPLOYEE
Tax School	TAX_SCHOOL	EMPLOYEE
Tax State	TAX_STATE	EMPLOYEE
Tax Transport	TAX_TRANSPORT	EMPLOYEE
Term Date	TERM_DATE	EMPLOYEE
Tipped	TIPPED	EMPLOYEE
Union Code	UNION_CODE	EMPLOYEE
Updated By LTM	UPDATED_BY_LTM	EMPLOYEE
User Level	USER_LEVEL	EMPLOYEE
Warn Flag	WARN_FLAG	EMPLOYEE
WC State	WC_STATE	EMPLOYEE
WC Province	WC_PROVINCE	EMPLOYEE
Work County	WORK_COUNTY	EMPLOYEE
Work City	WORK_CITY	EMPLOYEE
Work School	WORK_SCHOOL	EMPLOYEE
Work Transport	WORK_TRANSPORT	EMPLOYEE
Work County	WORK_COUNTY	EMPLOYEE
Work Schedule	WORK_SCHED	EMPLOYEE
Zip	ZIP	EMPLOYEE
First Day Worked	FST_DAY_WORKED	EMPLOYEE
Process Level	PROCESS_LEVEL	EMPLOYEE
Last Prefix	LAST_NAME_PRE	EMPLOYEE
Last Prefix Suffix	LAST_NAME_PRE	EMPLOYEE
First Middle Initial	FIRST_NAME	EMPLOYEE
Last Suffix	LAST_NAME	EMPLOYEE
Annual Hours	ANNUAL_HOURS	EMPLOYEE
Emp Business Expense Amount	EBE_AMOUNT	EMPLOYEE
Pay Rate	PAY_RATE	EMPLOYEE
Pro rate Salary	PRO_RATE_A_SAL	EMPLOYEE
Pro rate Total	PRO_RATE_TOTAL	EMPLOYEE
Stand Amount	STAND_AMT	EMPLOYEE
Stand Hours	STAND_HOURS	EMPLOYEE

Employee Dependent


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMDEPEND
Employee	EMPLOYEE	EMDEPEND
Activity	ACTIVITY	EMDEPEND
Employee Name	LAST_NAME	EMDEPEND
Account Category	ACCT_CATEGORY	EMDEPEND
Add Allowance Amount	ADD_ALLOW_AMT	EMDEPEND
Add Allowance Hours	ADD_ALLOW_HRS	EMDEPEND
Add Allowance Per	ADD_ALLOW_PER	EMDEPEND
Address 1	ADDR1	EMDEPEND
Address 2	ADDR2	EMDEPEND
Address 3	ADDR3	EMDEPEND
Adjusted Hire Date	ADJ_HIRE_DATE	EMDEPEND
Alternate Rate Exist	ALT_RATE_EXIST	EMDEPEND
Anniversary Date	ANNIVERS_DATE	EMDEPEND
Auto Time Record	AUTO_TIME_REC	EMDEPEND
Automatic Deposit	AUTO_DEPOSIT	EMDEPEND
BSI Group	BSI_GROUP	EMDEPEND
Bus Number Group	BUS_NBR_GRP	EMDEPEND
City	CITY	EMDEPEND
Country Code	COUNTRY_CODE	EMDEPEND
Creation Date	CREATION_DATE	EMDEPEND
Currency Code	CURRENCY_CODE	EMDEPEND
Date Hired	DATE_HIRED	EMDEPEND
Deceased	DECEASED	EMDEPEND
Department	DEPARTMENT	EMDEPEND
Effort Flag	EFFORT_FLAG	EMDEPEND
EIC Status	EIC_STATUS	EMDEPEND
Email Address	EMAIL_ADDRESS	EMDEPEND
Employee OT Exempt	EXEMPT_EMP	EMDEPEND
Employee Status	EMP_STATUS	EMDEPEND
Encumber Flag	ENCUMBER_FLAG	EMDEPEND
Est Remuneration	EST_REMUN	EMDEPEND
First Name	FIRST_NAME	EMDEPEND
First Name UC	FIRST_NAME_UC	EMDEPEND
Fringe Account	FRNG_ACCOUNT	EMDEPEND
Fringe Account Category	FRNG_ACCT_CAT	EMDEPEND
Fringe Sub Account	FRNG_SUB_ACCT	EMDEPEND
Fringe Rate	FRNG_RATE	EMDEPEND
FTE Number	NBR_FTE	EMDEPEND
FTE Total	FTE_TOTAL	EMDEPEND
HICN	HICN	EMDEPEND
Home Account	HM_ACCOUNT	EMDEPEND
Home Acct Unit	HM_ACCT_UNIT	EMDEPEND
Home Sub Account	HM_SUB_ACCT	EMDEPEND
Home Dist Company	HM_DIST_CO	EMDEPEND
Indirect Supervisor	SUPERVISOR_IND	EMDEPEND
Job Code	JOB_CODE	EMDEPEND
Labor Distribution Flag	LAB_DIST_FLAG	EMDEPEND
Last Comment Sequence Number	LAST_CMT_SEQ	EMDEPEND
Last Day Paid	LAST_DAY_PAID	EMDEPEND
Last Deduction Sequence Number	LAST_DED_SEQ	EMDEPEND
Last Name	LAST_NAME	EMDEPEND
Last Name UC	LAST_NAME_UC	EMDEPEND
Max Limit Override	MAX_LIMIT_OVRD	EMDEPEND
Middle Initial	MIDDLE_INIT	EMDEPEND
Middle Name	MIDDLE_NAME	EMDEPEND
Moving Expenses	MOVING_EXP	EMDEPEND
Name Prefix	NAME_PREFIX	EMDEPEND
Name Suffix	NAME_SUFFIX	EMDEPEND
New Hire Date	NEW_HIRE_DATE	EMDEPEND
Nick Name	NICK_NAME	EMDEPEND
OT Plan Code	OT_PLAN_CODE	EMDEPEND
Pay Frequency	PAY_FREQUENCY	EMDEPEND
Pay Grade	PAY_GRADE	EMDEPEND
Pay Step	PAY_STEP	EMDEPEND
Pending Action Date	PEND_ACT_DATE	EMDEPEND
Personal Email	EMAIL_PERSONAL	EMDEPEND
Pin	PIN	EMDEPEND
Position	R_POSITION	EMDEPEND
Primary Certifier Company	PRMCERT_COMP	EMDEPEND
Primary Certifier ID	PRMCERT_ID	EMDEPEND
Process Level	PROCESS_LEVEL	EMDEPEND
Public Sector Retirement	PUB_SEC_RETIRE	EMDEPEND
Quebec Enterprise Number Group	QC_ENT_NBR_GRP	EMDEPEND
Railroad code	RAILROAD_CODE	EMDEPEND
Remote	REMOTE	EMDEPEND
Reportable Insurance Cost	RPT_INS_COST	EMDEPEND
Reporting Currency	RPT_CURR	EMDEPEND
Salary Class	SALARY_CLASS	EMDEPEND
Schedule	SCHEDULE	EMDEPEND
Secondary Certifier ID	SNDCERT_ID	EMDEPEND
Secondary Certifier Company	SNDCERT_COMP	EMDEPEND
Security Level	SEC_LVL	EMDEPEND
Security Location	SEC_LOCATION	EMDEPEND
Shift	SHIFT	EMDEPEND
Sick Pay	SICK_PAY	EMDEPEND
Social Security Number	FICA_NBR	EMDEPEND
SSN Last4	FICA_NBR_LAST4	EMDEPEND
ST Status	ST_STATUS	EMDEPEND
State	STATE	EMDEPEND
Supervisor	SUPERVISOR	EMDEPEND
Tax City	TAX_CITY	EMDEPEND
Tax County	TAX_COUNTY	EMDEPEND
Tax Province	TAX_PROVINCE	EMDEPEND
Tax School	TAX_SCHOOL	EMDEPEND
Tax State	TAX_STATE	EMDEPEND
Tax Transport	TAX_TRANSPORT	EMDEPEND
Term Date	TERM_DATE	EMDEPEND
Tipped	TIPPED	EMDEPEND
Union Code	UNION_CODE	EMDEPEND
Updated By LTM	UPDATED_BY_LTM	EMDEPEND
User Level	USER_LEVEL	EMDEPEND
Warn Flag	WARN_FLAG	EMDEPEND
WC State	WC_STATE	EMDEPEND
WC Province	WC_PROVINCE	EMDEPEND
Work County	WORK_COUNTY	EMDEPEND
Work City	WORK_CITY	EMDEPEND
Work School	WORK_SCHOOL	EMDEPEND
Work Transport	WORK_TRANSPORT	EMDEPEND
Work County	WORK_COUNTY	EMDEPEND
Work Schedule	WORK_SCHED	EMDEPEND
Zip	ZIP	EMDEPEND
First Day Worked	FST_DAY_WORKED	EMDEPEND
Process Level	PROCESS_LEVEL	EMDEPEND
Last Prefix	LAST_NAME_PRE	EMDEPEND
Last Prefix Suffix	LAST_NAME_PRE	EMDEPEND
First Middle Initial	FIRST_NAME	EMDEPEND
Last Suffix	LAST_NAME	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
Contact Name	Derived Field	PAEMERGCNT
Middle Initial	MIDDLE_INIT	PAEMERGCNT
Address 1	ADDR1	PAEMERGCNT
Address 2	ADDR2	PAEMERGCNT
Address 3	ADDR3	PAEMERGCNT
Address 4	ADDR4	PAEMERGCNT
City	CITY	PAEMERGCNT
State	STATE	PAEMERGCNT
ZIP	ZIP	PAEMERGCNT
Relationship	RELATIONSHIP	PAEMERGCNT
Home Phone Country	HM_PHONE_CNTRY	PAEMERGCNT
Home Phone Number	HM_PHONE_NBR	PAEMERGCNT
Work Phone Number	WK_PHONE_NBR	PAEMERGCNT
Work Phone Country	WK_PHONE_CNTRY	PAEMERGCNT
Work Phone Extension	WK_PHONE_EXT	PAEMERGCNT
Phone Country	CL_PHONE_CNTRY	PAEMERGCNT
Phone Number	CL_PHONE_NBR	PAEMERGCNT
Country Code	COUNTRY_CODE	PAEMERGCNT
Last Updated Date	DATE_STAMP	PAEMERGCNT
Time Stamp	TIME_STAMP	PAEMERGCNT
User Id	USER_ID	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
Create User Id	CREATE_USER_ID	PAMEDICAL
Last Updated Date	DATE_STAMP	PAMEDICAL
Time Stamp	TIME_STAMP	PAMEDICAL
User Id	USER_ID	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

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 Activity History


Attribute or measure name	Table field	Archive source table
Company	COMPANY	PERSACTHST
Action Code	ACTION_CODE	PERSACTHST
Effect Date	EFFECT_DATE	PERSACTHST
Action Number	ACTION_NBR	PERSACTHST
Employee	EMPLOYEE	PERSACTHST
Anticipated End Date	ANT_END_DATE	PERSACTHST
User Id	USER_ID	PERSACTHST
Last Updated Date	DATE_STAMP	PERSACTHST
Action Type	ACTION_TYPE	PERSACTHST
Object Id	OBJ_ID	PERSACTHST
Reason 01	REASON_01	PERSACTHST
Reason 02	REASON_02	PERSACTHST
Position Level	POS_LEVEL	PERSACTHST
Error Flag	ERROR_FLAG	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

Grievance Disciplinary Actions


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

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

General Ledger Transaction History View 5


Attribute or measure name	Table field	Archive source table
Company	Transaction.company	GLTRANS
Account	Transaction.account	GLTRANS
Accounting Period	Transaction.acct_period	GLTRANS
Accounting Unit	Transaction.acct_unit	GLTRANS
System	Transaction.system	GLTRANS
Control Group	Transaction.control_group	GLTRANS
Journal Entry Type	Transaction.je_type	GLTRANS
Description	Transaction.description	GLTRANS
Fiscal Year	Transaction.fiscal_year	GLTRANS
Base Amount	Transaction.base_amount	GLTRANS

General Ledger Transaction History View 4


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLTRANS GLT
System	SYSTEM	GLTRANS GLT
Transaction Description	TRAN_DESC_DFLT	GLTRANS GLT
To Company	TO_COMPANY	GLTRANS GLT
Sub Account	SUB_ACCOUNT	GLTRANS GLT
Source Code	SOURCE_CODE	GLTRANS GLT
Journal Entry Type	JE_TYPE	GLTRANS GLT
Journal Entry Sequence	JE_SEQUENCE	GLTRANS GLT
Reference	REFERENCE	GLTRANS GLT
Posting Date	POSTING_DATE	GLTRANS GLT
Journal Book Sequence	JBK_SEQ_NBR	GLTRANS GLT
Fiscal Year	FISCAL_YEAR	GLTRANS GLT
Document Number	DOCUMENT_NBR	GLTRANS GLT
Description	DESCRIPTION	GLTRANS GLT
Control Group	CONTROL_GROUP	GLTRANS GLT
Base Zone	BASE_ZONE	GLTRANS GLT
Auto Reverse PD	AUTO_REV_PD	GLTRANS GLT
Activity	ACTIVITY	GLTRANS GLT
Account Rate	ACCT_RATE	GLTRANS GLT
Account Category	ACCT_CATEGORY	GLTRANS GLT
Auto Reverse	AUTO_REV	GLTRANS GLT
Accounting Unit	ACCT_UNIT	GLTRANS GLT
Accounting Period	ACCT_PERIOD	GLTRANS GLT
Account	ACCOUNT	GLTRANS GLT
Account Amount	ACCT_AMOUNT	GLTRANS GLT
Report One Amount	RPT_AMOUNT_1	GLTRANS GLT
Report Two Amount	RPT_AMOUNT_2	GLTRANS GLT
Transaction Amount	TRAN_AMOUNT	GLTRANS GLT
Units Amount	UNITS_AMOUNT	GLTRANS GLT

General Ledger Control


Attribute or measure name	Table field	Archive source table
Company	COMPANY	GLCONTROL
FISCAL YEAR	FISCAL_YEAR	GLCONTROL
SYSTEM	SYSTEM	GLCONTROL
CONTROL GROUP	CONTROL_GROUP	GLCONTROL
JOURNALENTRY SEQUENCE	JE_SEQUENCE	GLCONTROL
DESCRIPTION	DESCRIPTION	GLCONTROL
CONTROL AMOUNT	CNTRL_AMOUNT	GLCONTROL
ENTRY DB	ENTRY_DB	GLCONTROL
SOURCE CODE	SOURCE_CODE	GLCONTROL
REFERENCE	REFERENCE	GLCONTROL
AUTO REV PD	AUTO REV PD	GLCONTROL
GLControlKey	GLControlKey	GLCONTROL
DOCUMENT NBR	DOCUMENT NBR	GLCONTROL
POSTING DATE	POSTING DATE	GLCONTROL

Budget Detail


Attribute or measure name	Table field	Archive source table
Company	COMPANY	FBDETAIL
Chart Name	CHART_NAME	FBDETAIL
Acct Unit	ACCT_UNIT	GLAMOUNTS
Account	ACCOUNT	GLAMOUNTS
Sub Account	SUB_ACCOUNT	FBDETAIL
Fiscal Year	FISCAL_YEAR	GLAMOUNTS
Description	DESCRIPTION	FBHEADER
GL Period End Date	tmpEndDate	GLAMOUNTS
GL Actual Amount	From Formula	GLAMOUNTS
GL Actual Amount YTD	From Formula	GLAMOUNTS
GL Begin Amount	From Formula	GLAMOUNTS
GL End Amount	From Formula	GLAMOUNTS

General Ledger Transaction History View 3


Attribute or measure name	Table field	Archive source table
Account Period	Acct_Period	GLTRANS
Control Group	Control_Group	GLTRANS
Journal Entry Type	Je_Type]	GLTRANS
Journal Entry Sequence	Je_Sequence	GLTRANS
Line Number	Line_Nbr	GLTRANS
Account Amount	Acct_Amount	GLTRANS
Account Category	Acct_Category	GLTRANS
Account Currency	Acct_Currency	GLTRANS
Account Rate	Acct_Rate	GLTRANS
Activity	Activity	GLTRANS
Auto Reverse	Auto_Rev	GLTRANS
Base Amount	Base_Amount	GLTRANS
Base Nd	Base_Nd	GLTRANS
Base Zone	Base_Zone	GLTRANS
BaseRate	BaseRate	GLTRANS
Date	R_Date	GLTRANS
Effect Date	Effect_Date	GLTRANS
Object Id	Obj_Id	GLTRANS
Operator	Operator	GLTRANS
Origin Program	Orig_Program	GLTRANS
Posting Date	Posting_Date	GLTRANS
Reference	Reference	GLTRANS
Report Amount 1	Rpt_Amount_1	GLTRANS
Report Amount 2	Rpt_Amount_2	GLTRANS
Source Code	Source_Code	GLTRANS
Status	Status	GLTRANS
To Company	To_Company	GLTRANS
Transaction Amount	Tran_Amount	GLTRANS
Units Amount	Units_Amount	GLTRANS
Close Sequence	Close_Seq	GLCONTROL
Document Number	Document_Nbr	GLCONTROL
Credit Units	CR_Units_01	GLUNITS
Debit Units	DB_Units_01	GLUNITS
Base Accounting Unit	Bs_Acct_Unit	GLSYSTEM
Company Nd	Company_Nd	GLSYSTEM
Currency Exchange Flag	Curr_Conv_Flg	GLSYSTEM
Currency Code	Currency_Code	GLSYSTEM
Currency Table	Currency_Table	GLSYSTEM
Interlevel Balance Flag	Intlv_Bal_Flg	GLSYSTEM
Journal By Document	Journal_By_Doc	GLSYSTEM
Journal Book Required	Jrnl_Book_Req	GLSYSTEM
Level Depth	Level_Depth	GLSYSTEM
Number of Account Periods	Nbr_Acct_Pers	GLSYSTEM
Number of Digits	Nbr_Digits_01	GLSYSTEM
Period End Code	Per_End_Code_01	GLSYSTEM
Period End Date	Per_End_Date_01	GLSYSTEM
Updating	Updating	GLSYSTEM
Description	Description	GLNAMES
Person Responsible	Person_Resp	GLNAMES
Posting Flag	Posting_Flag	GLNAMES
Variable Level Display	Var_Level_Disp	GLNAMES
Chart Section	Chart_Section	GLNAMES
Address1	Addr1	ADDRDATA
Address5	Addr5	ADDRDATA
Country	Country	ADDRDATA
Country Code	Country_Code	ADDRDATA
Name	Name	ADDRDATA
Postal Code	Postal_Code	ADDRDATA
State Prov	State_Prov	ADDRDATA
Usage Count	Usage_Count	ADDRDATA
Address Code	Addr_Code	GLADDRESS
Account	Account	GLAMOUNTS
Chart Name	Chart_Name	GLAMOUNTS
Credit Amount	Cr_Amount_01	GLAMOUNTS
Sub Account	Sub_Account	GLAMOUNTS
Variable Levels	Var_Levels	GLAMOUNTS
Error Suspense Account	Es_Account	GLCHART
Error Suspense Sub Account	Es_Sub_Acct	GLCHART
Unretained Earnings Account	Ure_Account	GLCHART
Unretained Earnings Sub Account	Ure_Sub_Acct	GLCHART
GlobalKey	GlobalKey	GLSYSTEM
Address2	Addr2	GLSYSTEM
Address3	Addr3	GLSYSTEM
Address4	Addr4	GLSYSTEM
County	County	GLSYSTEM
Reconcile	Reconcile	GLSYSTEM
Error Suspense Journal Book	Error_Sp_Jbook	GLSYSTEM
Activity Flag	Proj_Acct_Flg	GLSYSTEM
Address Code	ADDR_CODE	GLADDRESS
Address 1	ADDR1	GLADDRESS
Address 5	ADDR5	GLADDRESS
Country	COUNTRY	GLADDRESS
Country Code	COUNTRY_CODE	GLADDRESS
Name	NAME	GLADDRESS
Postal Code	POSTAL_CODE	GLADDRESS
State Prov	STATE_PROV	GLADDRESS
Usage Count	USAGE_COUNT	GLADDRESS
Acct Period	ACCT_PERIOD	GLCONTROL
Base Nd	BASE_ND	GLCONTROL
Base Zone	BASE_ZONE	GLCONTROL
Base Rate	BASERATE	GLCONTROL
Control Group	CONTROL_GROUP	GLCONTROL
Currency Code	CURRENCY_CODE	GLCONTROL
Description	DESCRIPTION	GLCONTROL
Document Nbr	DOCUMENT_NBR	GLCONTROL
Fiscal Year	FISCAL_YEAR	GLCONTROL
JE Sequence	JE_SEQUENCE	GLCONTROL
Nbr Lines	NBR_LINES	GLCONTROL
Operator	OPERATOR	GLCONTROL
Posting Date	POSTING_DATE	GLCONTROL
Reference	REFERENCE	GLCONTROL
System	SYSTEM	GLCONTROL
Tran Nd	TRAN_ND	GLCONTROL
Var Levels	VAR_LEVELS	GLNAMES
Bs Acct Unit	BS_ACCT_UNIT	GLSYSTEM
Chart Name	CHART_NAME	GLSYSTEM
Close Seq 01	CLOSE_SEQ_01	GLSYSTEM
Company Nd	COMPANY_ND	GLSYSTEM
Currency Table	CURRENCY_TABLE	GLSYSTEM
Journal By Doc	JOURNAL_BY_DOC	GLSYSTEM
Journal Book Req	JRNL_BOOK_REQ	GLSYSTEM
Level Depth	LEVEL_DEPTH	GLSYSTEM
Nbr Acct Pers	NBR_ACCT_PERS	GLSYSTEM
Per End Code 01	PER_END_CODE_01	GLSYSTEM
Per End Date 01	PER_END_DATE_01	GLSYSTEM
Updating	UPDATING	GLSYSTEM
Company	COMPANY	GLTRANS
Account	ACCOUNT	GLTRANS
Acct Amount	ACCT_AMOUNT	GLTRANS
Acct Category	ACCT_CATEGORY	GLTRANS
Acct Nd	ACCT_ND	GLTRANS
Acct Rate	ACCT_RATE	GLTRANS
Acct Unit	ACCT_UNIT	GLTRANS
Activity	ACTIVITY	GLTRANS
Line Nbr	LINE_NBR	GLTRANS
Obj ID	OBJ_ID	GLTRANS
RPT Amount 1	RPT_AMOUNT_1	GLTRANS
RPT Amount 2	RPT_AMOUNT_2	GLTRANS
Source Code	SOURCE_CODE	GLTRANS
Sub Account	SUB_ACCOUNT	GLTRANS
To Base Amount	TO_BASE_AMT	GLTRANS
To Base Curr	TO_BASE_CURR	GLTRANS
To Base nd	TO_BASE_ND	GLTRANS
To Base rate	TO_BASERATE	GLTRANS
To Company	TO_COMPANY	GLTRANS
Tran Amount	TRAN_AMOUNT	GLTRANS
Units Amount	UNITS_AMOUNT	GLTRANS
Address 2	ADDR2	GLADDRESS
Address 3	ADDR3	GLADDRESS
Address 4	ADDR4	GLADDRESS
County	COUNTY	GLADDRESS
Hold Code	HOLD_CODE	GLADDRESS
Journal Book Nbr	JRNL_BOOK_NBR	GLADDRESS

General Ledger Transaction History


Attribute or measure name	Table field	Archive source table
Company	Company	GLTRANS
Fiscal Year	Fiscal_Year	GLTRANS
Account Period	Acct_Period	GLTRANS
Control Group	Control_Group	GLTRANS
System	System	GLTRANS
Journal Entry Sequence	Je_Sequence	GLTRANS
Journal Entry Type	Je_Type	GLTRANS
Line Number	Line_Nbr	GLTRANS
Account Amount	Acct_Amount	GLTRANS
Account Currency	Acct_Currency	GLTRANS
Account Rate	Acct_Rate	GLTRANS
Journal Book Trans Number	Jbk_Trns_Nbr	GLTRANS
Object Id	Obj_Id	GLTRANS
Originating Company	Orig_Company	GLTRANS
Program of Origin	Orig_Program	GLTRANS
Report Amount 1	Rpt_Amount_1	GLTRANS
Report Amount 2	Rpt_Amount_2	GLTRANS
Sequence Transaction Number	Seq_Trns_Nbr	GLTRANS
Base Amount	To_Base_Amt	GLTRANS
Base Currency	To_Base_Curr	GLTRANS
BaseRate	To_BaseRate	GLTRANS
Base Nd	To_Base_Nd	GLTRANS
Company	To_Company	GLTRANS
Transaction Amount	Tran_Amount	GLTRANS
Units Amount	Units_Amount	GLTRANS
Auto Journal Entry Number	Auto_Je_Nbr	GLSYSTEM
BackPost	BackPost_01	GLSYSTEM
Base Accounting Unit	Bs_Acct_Unit	GLSYSTEM
Budget Tolerance	Bud_Tolerance	GLSYSTEM
Change Post Tran	Chg_Post_Tran	GLSYSTEM
Change Rel Tran	Chg_Rel_Tran	GLSYSTEM
Currency Exchange Flag	Curr_Conv_Flg	GLSYSTEM
Currency Transaction Flag	Curr_Tran_Flg	GLSYSTEM
Close Sequence	Close_Seq_01	GLSYSTEM
Default Period	Default_Period	GLSYSTEM
Interlevel Balance Flag	Intlv_Bal_Flg	GLSYSTEM
Income Statement Account Unit	Is_Acct_Unit	GLSYSTEM
Journal By Document	Journal_By_Doc	GLSYSTEM
Run Date	GL190_Run_Dt	GLSYSTEM
Run Time	GL190_Run_Tm	GLSYSTEM
Journal Book Required	Jrnl_Book_Req	GLSYSTEM
Level Description	Level_Desc_01	GLSYSTEM
Number of Accounting Periods	Nbr_Acct_Pers	GLSYSTEM
Number of Digits	Nbr_Digits_01	GLSYSTEM
Period End Code	Per_End_Code_01	GLSYSTEM
Period End Date	Per_End_Date_01	GLSYSTEM
Posted Through Date	Posted_Th_Dt	GLSYSTEM
Reset Sequence Number	Reset_Seq_Nbr	GLSYSTEM
Sequence Trans Code	Seq_Trns_Cd	GLSYSTEM
Updating	Updating	GLSYSTEM
Level Depth	Level_Depth	GLSYSTEM
Workflow Flag	Workflow_Flag	GLSYSTEM
Credit Units	Cr_Units_01	GLUNITS
Debit Units	Db_Units_01	GLUNITS
Level Detail	Level_Detail_01	GLNAMES
Person Responsible	Person_Resp	GLNAMES
Posting Flag	Posting_Flag	GLNAMES
Variable Level Display	Var_Level_Disp	GLNAMES
Average Daily Balance	Avg_Daily_Bal	GLMASTER
Base Currency	Base_Currency	GLMASTER
Date Entered	Date_Entered	GLMASTER
Intercompany Status	Glintco_Stat	GLMASTER
Account Nd	Acct_Nd	GLMASTER
Act Post Date	Act_Post_Date	GLCONTROL
Auto Unit Credits	Auto_Unit_Cr	GLCONTROL
Auto Unit Debits	Auto_Unit_Db	GLCONTROL
Base Auto Credits	Base_Auto_cr	GLCONTROL
Base Auto Debits	Base_Auto_Db	GLCONTROL
Base Credits	Base_Credits	GLCONTROL
Base Debits	Base_Debits	GLCONTROL
BaseRate	BaseRate	GLCONTROL
Control Amount	Cntrl_Amount	GLCONTROL
Document Number	Document_Nbr	GLCONTROL
Last Comment Sequence Number	Last_Cmt_Seq	GLCONTROL
Last Logfile Sequence Number	Last_Log_Seq	GLCONTROL
Number of Detail Lines	Nbr_Lines	GLCONTROL
Release Operator	Rel_Operator	GLCONTROL
Released Flag	Released_Flag	GLCONTROL
Transaction Description	Tran_Desc_Dflt	GLCONTROL
Transaction Nd	Tran_Nd	GLCONTROL
Segment Group	Segment_Group	SLTRANS
Remote Site	Remote_Site_Fl	SYSTEMCODE
Address1	Addr1	ADDRDATA
Address5	Addr5	ADDRDATA
Country	Country	ADDRDATA
Country Code	Country_Code	ADDRDATA
Name	Name	ADDRDATA
Postal Code	Postal_Code	ADDRDATA
State or Province	State_Prov	ADDRDATA
Usage Count	Usage_Count	ADDRDATA
Address Code	Addr_Code	GLADDRESS
Activity Flag	Activity_Flag_01	GLAMOUNTS
Balance Account	Bal_Account	GLCHART
Balance Sub Account	Bal_Sub_Acct	GLCHART
Commitment Account	Comt_Account	GLCHART
Commitment Sub Account	Comt_Sub_Acct	GLCHART
Gain Account	Gain_Acct	GLCHART
Gain Sub Account	Gain_Sub_AccT	GLCHART
Loss Account	Loss_Acct	GLCHART
Loss Sub Account	Loss_Sub_Acct	GLCHART
Retained Earnings Account	Re_Account	GLCHART
Retained Earnings Sub Account	Re_Sub_Acct	GLCHART
Rounding Account	Rnd_Account	GLCHART
Rounding Sub Account	Rnd_Sub_Acct	GLCHART
Unretained Earnings Account	Ure_Account	GLCHART
Unretained Earnings Sub Account	Ure_Sub_Acct	GLCHART
Error Suspense Account	Es_Account	GLCHART
Error Suspense Sub Account	Es_Sub_Acct	GLCHART
Forms Expression	Forms_Exp	CUCODES
Iso Code	Iso_Code	CUCODES
Number of Decimals	Nbr_Decimals	CUCODES
Error Suspense Journal Book	Error_Sp_Jbook	GLSYSTEM
Year End Journal Book	Year_End_Jbook	GLSYSTEM
Option Field 1	Option_Fld_1	GLSYSTEM
Option Field 2	Option_Fld_2	GLSYSTEM
Option Field 3	Option_Fld_3	GLSYSTEM
Calculation Date	Calc_Date	ULPOST
Calculation Time	Calc_Time	ULPOST
Address3	Addr3	ADDRDATA
Address2	Addr2	ADDRDATA
Address4	Addr4	ADDRDATA
County	County	ADDRDATA

General Ledger Amounts


Attribute or measure name	Table field	Archive source table
Company	Company	GLUNITS
Fiscal Year	Fiscal_Year	GLUNITS
Accounting Unit	Acct_Unit	GLUNITS
Account	Account	GLUNITS
Sub Account	Sub_Account	GLUNITS
Credit Units	Cr_Units_01	GLUNITS
Debit Units	Db_Units_01	GLUNITS
Account Category Description	Description	GLNAMES
Level Depth	Level_Depth	GLNAMES
Level Detail	Level_Detail_01	GLNAMES
Person Responsible	Person_Resp	GLNAMES
Posting Flag	Posting_Flag	GLNAMES
Variable Level Display	Var_Level_Disp	GLNAMES
Address Code	Addr_Code	GLADDRESS
Address1	Addr1	ADDRDATA
Address5	Addr5	ADDRDATA
Country	Country]	ADDRDATA
Country Code	Country_Code	ADDRDATA
Name	Name	ADDRDATA
Postal Code	Postal_Code	ADDRDATA
State or Province	State_Prov	ADDRDATA
Usage Count]	Usage_Count	ADDRDATA
Accounting Period	Acct_Period	GLSYSTEM
Base Accounting Unit	Bs_Acct_Unit	GLSYSTEM
Chart Name	Chart_Name	GLSYSTEM
Close Sequence	Close_Seq_01	GLSYSTEM
Company Nd	Company_Nd	GLSYSTEM
Currency Exchange Flag	Curr_Conv_Flg	GLSYSTEM
Currency Table	Currency_Table	GLSYSTEM
Interlevel Balance Flag	Intlv_Bal_Flg	GLSYSTEM
Journal By Document	Journal_By_Doc	GLSYSTEM
Number of Accounting Periods	Nbr_Acct_Pers	GLSYSTEM
Number of Digits	Nbr_Digits_01	GLSYSTEM
Period End Code	Per_End_Code_01	GLSYSTEM
Period End Date	Per_End_Date_01	GLSYSTEM
Updating	Updating	GLSYSTEM
Error Suspense Account	Es_Account	GLCHART
Error Suspense Subaccount	Es_Sub_Acct	GLCHART
Unretained Earnings Account	Ure_Account	GLCHART
Unretained Earnings Subaccount	Ure_Sub_Acct	GLCHART
Address2	Addr2	ADDRDATA
Address3	Addr3	ADDRDATA
Address4	Addr4	ADDRDATA
County	County	ADDRDATA
Error Suspense Journal Book	Error_Sp_Jbook	ADDRDATA
Activity Flag	Proj_Acct_Flg	ADDRDATA

General Ledger Transaction History View 1


Attribute or measure name	Table field	Archive source table
Company	Company	GLCONTROL
System	SYSTEM	GLCONTROL
Fiscal Year	FISCAL_YEAR	GLCONTROL
Account Period	ACCT_PERIOD	GLCONTROL
Jbk Seq Nbr	JBK_SEQ_NBR	GLCONTROL
Line Nbr	LINE_NBR	GLTRANS
Posting Date	POSTING_DATE	GLTRANS
Effect Date	EFFECT_DATE	GLTRANS
Journal Book	JRNL_BOOK_NBR	GLTRANS
Hold Code	HOLD_CODE	GLTRANS
Base Amount CR	BASE_AMOUNT	GLTRANS
Base Amount DB	BASE_AMOUNT	GLTRANS
Units Amount CR	UNITS_AMOUNT	GLTRANS
Units Amount DB	UNITS_AMOUNT	GLTRANS

Activity Budget Header


Attribute or measure name	Table field	Archive source table
Company	COMPANY	ACASSIGN
Description	DESCRIPTION	ACASSIGN
Resource Code	RESOURCE_CODE	ACASSIGN
Capital Flag	CAPITAL_FLAG	ACACCTCATX
Revenue Flag	REVENUE_FLAG	ACACCTCATX
Mark Up Pct	MARK_UP_PCT	ACACCTCATX
Summary Account Category	SUM_ACCT_CAT	ACACCTCATX
Budget Number	BUDGET_NBR	CBUDHDR
Calculation Date	CALC_DATE	CBUDHDR
Maintenance Date	MAINT_DATE	CBUDHDR
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
Security Code	SECURITY_CD	ACACTGRP
Accounting Unit	ACCT_UNIT	ACACTIVITY
Active Budget	ACTIVE_BUD	ACACTIVITY
Activity Group	ACTIVITY_GRP	ACACTIVITY
Activity	ACTIVITY	ACACTIVITY
Begin Date	BEGIN_DATE	ACACTIVITY
Billable Flag	BILLABLE_FLAG	ACACTIVITY
Company 1	COMPANY 1	ACACTIVITY
Contract	CONTRACT	ACACTIVITY
End Date	END_DATE	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 Detail 05	LEVEL_DETAIL_05	ACACTIVITY
Var Levels	VAR_LEVELS	ACACTIVITY
Customer	CUSTOMER	ACCNTRACT
Document Number	DOCUMENT_NBR	ACCNTRACT
Account Category	ACCT_CATEGORY	ACACCTCAT
BUDGETCONTROLKEY	BUDGETCONTROLKEY	ACACCTCAT

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

Activity Budget


Attribute or measure name	Table field	Archive source table
Activity group	ACTIVITY_GRP	ACACTIVITY
Budget Nbr	BUDGET_NBR	ACACTIVITY
Currency Code	CURRENCY_CODE	ACACTIVITY
Fiscal Year	FISCAL_YEAR	ACACTIVITY
Activity	ACTIVITY	ACACTIVITY
Acct Category	ACCT_CATEGORY]	ACACTIVITY
Billing Method	BILLING_METHOD	ACACTIVITY
Acct Unit	ACCT_UNIT	ACACTIVITY
Contract	CONTRACT	ACACTIVITY
End Date	END_DATE	ACACTIVITY
Obj Id	OBJ_ID	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 Depth	LEVEL_DEPTH	ACACTIVITY
Var Level Disp	VAR_LEVEl_DISP	ACACTIVITY
Var Levels	VAR_LEVELS	ACACTIVITY
Num Decimals	NUM_DECIMALS	ACACTGRP
Rate Value	RATE_VALUE	ACACTGRP
Total Budget	TOTAL_BUDGET	ACACTGRP
Balance	BALANCE	ACACTGRP
Compute Name	COMPUTE_NAME	ACACTGRP
Spread Code	SPREAD_CODE	ACACTGRP
Security Id	SECURITY_CD	ACACTGRP
Base Nd	BASE_ND	ACACTGRP
Calendar Name	CALENDAR_NAME	ACACTGRP
Level Size 01	LEVEL_SIZE_01	ACBUDDTL
Level Size 02	LEVEL_SIZE_02	ACBUDDTL
Level Size 03	LEVEL_SIZE_03	ACBUDDTL
Level Size 04	LEVEL_SIZE_04	ACBUDDTL
Level Size 05	LEVEL_SIZE_05	ACBUDDTL
Sum Acct Cat	SUM_ACCT_CAT	ACAMCODE
Asset	ASSET	ACAMCODE
Asset Template	ASSET_TEMPLATE	ACAMCODE
ACCUAMTKEY	ACBTLKEY	ACAMCODE
Begin Date	BEGIN_DATE	ACAMCODE
User Status	USR_STATUS	ACAMCODE
Var Level Disp	VAR_LEVEl_DISP	ACAMCODE
Var Levels	VAR_LEVELS	ACAMCODE
Lock	LOCK	ACAMCODE
Num Decimals	NUM_DECIMALS	ACBUDHDR
Rate Value	RATE_VALUE	ACBUDHDR
Total Budget	TOTAL_BUDGET	ACBUDHDR
Balance	BALANCE	ACBUDHDR
Compute Name	COMPUTE_NAME	ACBUDHDR
Spread Code	SPREAD_CODE	ACBUDHDR

Activity Transaction View 2


Attribute or measure name	Table field	Archive source table
Company	COMPANY	ACASSIGN
Account Category Description	DESCRIPTION	ACASSIGN
Resource Code	RESOURCE_CODE	ACASSIGN
Account Category	ACCT_CATEGORY	ACACCTCAT
Category Type	CATEGORY_TYPE	ACACCTCAT
Activity	ACTIVITY	ACBILL
Billing Method	BILLING_METHOD	ACBILL
Accounting Unit	ACCT_UNIT	ACACTIVITY
Activity Group	ACTIVITY_GRP	ACACTIVITY
Begin Date	BEGIN_DATE	ACACTIVITY
Billable Flag	BILLABLE_FLAG	ACACTIVITY
Contract	CONTRACT	ACACTIVITY
Currency Code	CURRENCY_CODE	ACACTIVITY
End Date	END_DATE	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 Detail_05	LEVEL_DETAIL_05	ACACTIVITY
Activity Object ID	OBJ_ID	ACACTIVITY
Posting Flag	POSTING_FLAG	ACACTIVITY
Variable Level Display	VAR_LEVEL_DISP	ACACTIVITY
Variable Levels	VAR_LEVELS	ACACTIVITY
PO Number	PO_NBR	ACADDLCNTR
Active Status	ACTIVE_STATUS	ACACTGRP
Calendar Name	CALENDAR_NAME	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
Capitalization Flag	CAPITAL_FLAG	ACACCTCATX
Mark up Percent	MARK_UP_PCT	ACACCTCATX
Revenue Flag	REVENUE_FLAG	ACACCTCATX
Customer	CUSTOMER	ACCNTRACT
Summary Account Category	SUM_ACCT_CAT	ACACCTCATX
Document Number	DOCUMENT_NBR	ACCNTRACT
Asset Number	ASSET	ACAMCODE
Asset Template	ASSET_TEMPLATE	ACAMCODE

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
SOH QTY	SOH_QTY	ITEMLOC
SYSTEM CD	SYSTEM_CD	WHDEMAND
DOC NBR	DOC_NBR	WHDEMAND
LINE NBR	LINE_NBR	WHDEMAND
EST TRAN DT	EST_TRAN_DT	WHDEMAND
REQ LOCATION	REQ_LOCATION	WHDEMAND
NAME	NAME	APCOMPANY

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
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
Doc Nbr	doc_nbr	whdemand
Tran Uom	tran_uom	whdemand
Est tran date	est_tran_dt	whdemand
Document Type	doc_type	whdemand
Component Sequence	component_seq	whdemand
Currency Code	Currency_Code	glsystem
Uom	uom	ITEMLOC

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
Stock On Hand	SOH_QTY	SOHDETAIL
UOM	UOM	SOHDETAIL
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

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	ITEM	ICITEMGTIN
User Field	USER_FIELD1	ICITEMGTIN
UOM	UOM	ICITEMGTIN
GTIN	GTIN	ICITEMGTIN
Status	STATUS	ICITEMGTIN
Parent GTIN	PARENT_GTIN	ICITEMGTIN
Full Description	FULL_DESC	ICITEMGTIN
Brand Name	BRAND_NAME	ICITEMGTIN
Generic	GENERIC	ITEMMAST
Item Group	ITEM_GROUP	ITEMMAST
Purchase Major Class	PURCH_MAJCL	ITEMMAST
Purchase Minor Class	PURCH_MINCL	ITEMMAST
Inventory Major Class	INVEN_MAJCL	ITEMMAST
Inventory Minor Class	INVEN_MINCL	ITEMMAST
Sales Major Class	SALES_MAJCL	ITEMMAST
Sales Minor Class	SALES_MINCL	ITEMMAST
Added Date	ADDED_DATE	ITEMMAST
Description	DESCRIPTION	ITEMMAST
Active Status	ACTIVE_STATUS	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
Asset	ASSET	AMASTBOOK
Book	BOOK	AMASTBOOK
Book Basis	BOOK_BASIS	AMASTBOOK
Current Period Depreciation	DEPR_CP	AMASTBOOK
Life-to-Date Depreciation	DEPR_LTD	AMASTBOOK
Year-to-Date Depreciation]	DEPR_YTD	AMASTBOOK
First or Last Flag	FIRST_LAST_FL	AMASTBOOK
In-service Date	INSRV_DATE	AMASTBOOK
Method Table Year	METH_TABLE_YR	AMASTBOOK
Method	METHOD	AMASTBOOK
Salvage Value	SALVAGE_VALUE	AMASTBOOK
Trans Number of Decimals	TRAN_ND	AMASTBOOK
Account Group	ACCT_GRP	AMASSET
Accounting Unit	ACCT_UNIT	AMASSET
Status	STATUS	AMASSET
Asset Group	ASSET_GROUP	AMASSET
Asset Process	ASSET_PROCESS	AMASSET
Asset Type	ASSET_TYPE	AMASSET
Base Number Of Decimals	BASE_ND	AMASSET
Company	COMPANY	AMASSET
Creation Date	CREATION_DATE	AMASSET
Creator ID	CREATOR _ID	AMASSET
Description	DESCRIPTION	AMASSET
Division	DIVISION	AMASSET
Disposal Asset	DSP_ASSET	AMASSET
Item Total Cost Base]	IT_TOT_CSTBASE	AMASSET
Lease	LEASE	AMASSET
Location Name	LOCATION_NAME]	AMASSET
Process Date	PROCESS_DATE	AMASSET
Sub Type	SUB_TYPE]	AMASSET
Tag Number	TAG_NBR	AMASSET
Depreciation Period Close	DEPR_PD_CLS	AMCALENDAR
Depreciation Run Close	DEPR_RUN_CLS	AMCALENDAR
Periods Per Year	PD_PER_YR	AMCALENDAR
Year-Begin Date	YR_BEG_DATE	AMCALENDAR
Year-End Date	YR_END_DATE	AMCALENDAR
Disposal Date]	DSP_DATE	AMASSETDSP
Disposal Method	DSP_METHOD	AMASSETDSP
Disposal Property	DSP_PROPERTY	AMASSETDSP
Disposal Quantity	DSP_QUANTITY	AMASSETDSP
Disposal Status	DSP_STATUS	AMASSETDSP
Asset Accounting Unit	AST_ACCT_UNIT	AMAUGROUP
Accounting Unit Group	AU_GROUP	AMAUGROUP
Disposal Depreciation	DSP_DEPR	AMASTBKDSP

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
Depreciation Calculation Flag	DEPR_CALC_FL	AMCALENDAR
Depreciation Period Close	DEPR_PD_CLS	AMCALENDAR
Depreciation Run Close	DEPR_RUN_CLS	AMCALENDAR
Year-Begin Date	YR_BEG_DATE	AMCALENDAR
Year-End Date	YR_END_DATE	AMCALENDAR
Asset	ASSET	AMASTBOOK
Book	BOOK	AMASTBOOK
Book Basis	BOOK_BASIS	AMASTBOOK
Current Period Depreciation	DEPR_CP	AMASTBOOK
Life-to-Date Depreciation	DEPR_LTD]	AMASTBOOK
Year-to-Date Depreciation	DEPR_YTD	AMASTBOOK
First or Last Flag	FIRST_LAST_FL	AMASTBOOK
In-service Date	INSRV_DATE	AMASTBOOK
Life	LIFE	AMASTBOOK
Current Period Life	LIFE_CP	AMASTBOOK
Life Remaining	LIFE_REM	AMASTBOOK
Method Switched	METH_SWITCHED	AMASTBOOK
Method	METHOD	AMASTBOOK
Trans Number Of Decimals	TRAN_ND	AMASTBOOK
Account Group	ACCT_GRP	AMASSET
Accounting Unit	ACCT_UNIT	AMASSET
Asset Group	ASSET_GROUP	AMASSET
Asset Process	ASSET_PROCESS	AMASSET
Asset Type	ASSET_TYPE	AMASSET
Company	COMPANY	AMASSET
Creation Date	CREATION_DATE	AMASSET
Creator ID	CREATOR_ID	AMASSET
Description	DESCRIPTION	AMASSET
Division	DIVISION	AMASSET
Disposal Asset	DISPOSAL_ASSET	AMASSET
Lease	LEASE	AMASSET
Location Name	LOCATION_NAME	AMASSET
Process Date	PROCESS_DATE	AMASSET
Sub Type	SUB_TYPE	AMASSET
Tag Number	TAG_NBR	AMASSET
Accounting Unit Group	AU_GROUP	AMASSET
Depreciation Override	DSP_DEPR_OVRRD	AMASTBKDSP
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

Asset Book History View 3


Attribute or measure name	Table field	Archive source table
Year-Begin Date	YR_BEG_DATE	AMCALENDAR
Year-End Date	YR_END_DATE	AMCALENDAR
Asset	ASSET	AMASTBOOK
Book	BOOK	AMASTBOOK
Book Basis	BOOK_BASIS	AMASTBOOK
Current Period Depreciation	DEPR_CP	AMASTBOOK
Life-to-Date Depreciation	DEPR_LTD	AMASTBOOK
Year-to-Date Depreciation	DEPR_YTD	AMASTBOOK
In-service Date	INSRV_DATE	AMASTBOOK
Life	LIFE	AMASTBOOK
Life Remaining	LIFE_REM	AMASTBOOK
Method	METHOD	AMASTBOOK
Accounting Unit	ACC_UNIT	AMASSET
Currency	CURRENCY_CODE	AMASSET
Description	DESCRIPTION	AMASSET
Division	DIVISION	AMASSET
Lease	LEASE	AMASSET
Lease Company	LEASE_COMPANY	AMASSET
Location Name	LOCATION_NAME	AMASSET
Asset Subtype	SUB_TYPE	AMASSET
Tag Number	TAG_NBR	AMASSET
Book Value	Book Value	AMASTBOOK

Purchase Order Master


Attribute or measure name	Table field	Archive source table
PO Date	PO_DATE	PURCHORDER
PO Release	PO_RELEASE	PURCHORDER
PO Code	PO_CODE	PURCHORDER
Tot Order Amt	TOT_ORDER_AMT	PURCHORDER
Buyer Code	BUYER_CODE	PURCHORDER
PO Revision	PO_REVISION	PURCHORDER
Purch Fr Loc	PURCH_FR_LOC	PURCHORDER
Dflt Dl Date	DFLT_DL_DATE	PURCHORDER
Currency Code	CURRENCY_CODE	PURCHORDER
Company	COMPANY	PURCHORDER
Description	DESCRIPTION	POLINE
Quantity	QUANTITY	POLINE
VBuy Unit Cst	VBUY_UNIT_CST	POLINE
Ent Buy Uom	ENT_BUY_UOM	POLINE
PO Number	PO_NUMBER	POLINE
Early Dl Date	EARLY_DL_DATE	POLINE
Item	ITEM	POLINE
Rec Qty	REC_QTY	POLINE
Ven Item	VEN_ITEM	POLINE
Matched Qty	MATCHED_QTY	POLINE
Vendor	VENDOR	POLINE
Purch Fr Loc 1	PURCH_FR_LOC 1	POLINE
Extended Amt	EXTENDED_AMT	POLINE
Gtin	GTIN	POLINE
Location	LOCATION	POLINE
Lst Match Ucst	LST_MATCH_UCST	POLINE
Taxable Flag	TAXABLE_FLAG	POLINE
Taxbl Unt Cst	TAXBL_UNT_CST	POLINE
Ext Taxbl Amt	EXT_TAXBL_AMT	POLINE
Vpri Uom	VPRI_UOM	POLINE
Extended Amt 1	EXTENDED_AMT 1	POLINE
Cost Option	COST_OPTION	POLINE
Cxl Qty	CXL_QTY	POLINE

Vendor Agreement


Attribute or measure name	Table field	Archive source table
LINE NBR	LINE_NBR	POVAGRMTLN
VEN ITEM	VEN_ITEM	POVAGRMTLN
ITEM	ITEM	POVAGRMTLN
VENDOR	VENDOR	POVAGRMTLN
BASE COST	BASE_COST	POVAGRMTLN
COST OPTION	COST_OPTION	POVAGRMTLN
PURCH FR LOC	PURCH_FR_LOC	POVAGRMTLN
CURR NET CST	CURR_NET_CST	POVAGRMTLN
ITEM DESCRIPTION	DESCRIPTION	POVAGRMTLN
ITEM DESCRIPTION2	DESCRIPTION2	POVAGRMTLN
REQ COMPANY	REQ_COMPANY	POVAGRMTLN
SS EVENT NBR	SS_EVENT_NBR	POVAGRMTLN
ACCT UNIT	ACCT_UNIT	POVADIST
ACCOUNT	ACCOUNT	POVADIST
SUB ACCT	SUB_ACCT	POVADIST
Company	DIST_COMPANY	POVADIST
ACTIVITY	ACTIVITY	POVADIST
ACCT CATEGORY	ACCT_CATEGORY	POVADIST
PVDKEY	PVDKEY	POVADIST
REC UPD DT	REC_UPD_DT	POVADIST
UOM	UOM	POVADIST
LINE SEQ	LINE_SEQ	POVADIST
REQ LOCATION	REQ_LOCATION	POVAGRMTLN
BILL CATEGORY	BILL_CATEGORY	POVAGRMTLN

PO Line Item Receiving


Attribute or measure name	Table field	Archive source table
Company	COMPANY	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
Gtin	GTIN	PORECLINE
Reference Number	REFERENCE_NO	PORECLINE
Vendor Item	VEN_ITEM	PORECLINE
Description	DESCRIPTION	PORECLINE
Receiver	REC_NUMBER	PORECLINE
Bin	BIN	PORECLINE
Item Type	ITEM_TYPE	PORECLINE
UOM	ENT_REC_UOM	PORECLINE
Cancel BO Flag	CANCEL_BO_FLAG	PORECLINE
Item Detail	MATCH_DTL_KEY	PORECLINE
Extended Amount	EXTENDED_AMT	PORECLINE
Original Unit Cost	ORIG_UNIT_CST	PORECLINE
Received Quantity	ENT_REC_QTY	PORECLINE
Original Received Quantity	ORIG_REC_QTY	PORECLINE
Reject Quantity	REJECT_QTY]	PORECLINE
Invoice	INVOICE	PORECLINE
Manufacturer Number	MANUF_NBR	POLINE
Early Delivery Date	EARLY_DL_DATE	POLINE
Manufacturer Code	MANUF_CODE	POLINE
Manufacturer Division	MANUF_DIVISION	POLINE
Operator	OPERATOR	PORECLINE
Invoice Date	INVOICE_DTE	PORECLINE
Line Number	LINE_NBR	PORECLINE
Buyer Code	BUYER_CODE	PORECEIVE
BOL Number	BOL_NBR	PORECEIVE
Currency Code	CURRENCY CODE	PORECEIVE
Match Ref Number	MATCH_REF_NBR	PORECEIVE
Purchase From Location	PURCH_FR_LOC	PORECEIVE
Rec Conversion Rate	REC_CNV_RATE	PORECEIVE
Line Number	LINE_NBR	PORECLINE
Matched Quantity	MATCHED_QTY	PORECLINE
Suffix	SUFFIX	PORECLINE
Return Number	RETURN_NUMBER	PORECLINE
Return Line Number	RET_LINE_NBR	PORECLINE
Reject Quantity	REJECT_QTY	PORECLINE
Catch Wt Quantity	CATCH_WT_QTY	PORECLINE
Quantity	QUANTITY	POLINE
Rec Quantity	REC_QTY	POLINE
Agreement Ref	AGREEMENT_REF	POLINE
Base Currency Cd	BASE_CURR_CD	POCOMPANY
Base Nd	BASE_ND	POCOMPANY
Procure Group	PROCURE_GROUP	POCOMPANY
Carrier	CARRIER	PORECEIVE

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
Bank Inst Code	BANK_INST_CODE	APPAYMENT
Cash Code	CASH_CODE	APPAYMENT
Trans Ident	TRANS_IDENT	APPAYMENT
Check Date	CHECK_DATE	CBCHECK
Check Type	CHECK_TYPE	CBCHECK
Serial Number	SERIAL_NUM	CBCHECK
Company	COMPANY	APPAYMENT
Vendor Group	VENDOR_GROUP	APPAYMENT
Vendor	VENDOR	APPAYMENT
Invoice	INVOICE	APPAYMENT
Suffix	SUFFIX	APPAYMENT
Cancel Seq	CANCEL_SEQ	APPAYMENT
Sequence Number	SEQ_NBR	APPAYMENT
Void Sequence	VOID_SEQ	APPAYMENT
Tran Chk Amount	TRAN_CHK_AMT	APPAYMENT

Accounts Payable Invoice


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

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	APINVOICE
Invoice Accrual Code	ACCR_CODE	APINVOICE
Base Invoice Amount	BASE_INV_AMT	APINVOICE
Cancel Date	CANCEL_DATE	APINVOICE
Cancel Sequence	CANCEL_SEQ	APINVOICE
Batch Currency	INV_CURRENCY	APINVOICE
Invoice	INVOICE	APINVOICE
Invoice Date	INVOICE_DTE	APINVOICE
Reconcile Date	RECON_DATE	APINVOICE
Suffix	SUFFIX	APINVOICE
Lease Currency Invoice Amount	TRAN_INV_AMT	APINVOICE
Vendor	VENDOR	APINVOICE
Vendor Group	VENDOR_GROUP	APINVOICE
Payment Code	BANK_INST_CODE	APPAYMENT
Base Payment Amount	BASE_PMT_AMT	APPAYMENT
Cash Code	CASH_CODE	APPAYMENT
Payment Date	CHECK_DATE	APPAYMENT
Payment Suffix Number	CHK_SUFFIX	APPAYMENT
Due Date	DUE_DATE	APPAYMENT
Transaction Payment Amount	TRAN_PMT_AMT	APPAYMENT
Transaction ID	TRANS_IDENT	APPAYMENT
Payment Number	TRANS_NBR	APPAYMENT

AP Payment History View 1


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

Accounts Payable Cash Payment


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

Invoice Payment View 4


Attribute or measure name	Table field	Archive source table
Company	COMPANY	APINVOICE
VENDOR	VENDOR	APINVOICE
INVOICE	INVOICE	APINVOICE
SUFFIX	SUFFIX	APINVOICE
VOUCHER NBR	VOUCHER_NBR	APINVOICE
TRAN INV AMT	TRAN_INV_AMT	APINVOICE
BASE INV AMT	BASE_INV_AMT	APINVOICE
CANCEL DATE	CANCEL_DATE	APINVOICE
INV CURRENCY	INV_CURRENCY	APINVOICE
INVOICE DATE	INVOICE_DATE	APINVOICE
DUE DATE	DUE_DATE	APINVOICE
PO NUMBER	PO_NUMBER	APINVOICE
PO RELEASE	PO_RELEASE	APINVOICE
PO CODE	PO_CODE	APINVOICE
LOCATION	LOCATION	APINVOICE
MATCH LEVEL	MATCH_LEVEL	APINVOICE
PAY GROUP	PAY_GROUP	CBCHECK
PROC LEVEL	PROC_LEVEL	CBCHECK
PAID VENDOR	PAID_VENDOR	CBCHECK
SERIAL NUM	SERIAL_NUM	CBCHECK
BASE PMT AMT	BASE_PMT_AMT	CBCHECK
BANK INST CODE	BANK_INST_CODE	CBCHECK
CASH CODE	CASH_CODE	CBCHECK
SERIAL NUM 1	SERIAL_NUM_1
VBANK ACCT NO	VBANK _ACCT_NO	APVENMAST
VBANK IDENT	VBANK_IDENT	APVENMAST
BASE ACT AMT	BASE _ACT_AMT
BASE DISC AMT	BASE _DISC_AMT
CHECK DATE	CHECK _DATE
CUSTOMER	CUSTOMER	APVENMAST
CUST GROUP	CUST_GROUP	APVENMAST
BAL CURRENCY	BAL_CURRENCY	APVENBAL
CURRENT BAL	CURRENT_BAL	APVENBAL
HIGHEST BAL	HIGHEST_BAL	APVENBAL
DRAFT BAL	DRAFT_BAL	APVENBAL
CP PURCH	CP_PURCH_01	APVENBAL
CP PAYMENT	CP_PAYMENT_01	APVENBAL
CP NBR PMTS	CP_NBR PMTS_01	APVENBAL
CP DSCTAKE	CP_DSCTAKE_01	APVENBAL
CP DSCLOST	CP_DSCLOST_01	APVENBAL
CP GAINLOS	CP_GAINLOS_01	APVENBAL
CY INC WH	CY_INC_WH_01	APVENBAL

Invoice Payment View 2


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

Invoice Distribution


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

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

COBRA 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

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
Last Perfix	LAST_PERFIX	EMPLOYEE
Middle Initial	MIDDLE_INITIAL	EMPLOYEE
Name Suffix	NAME_SUFFIX	EMPLOYEE
Sec Location	SEC_LOCATION	EMPLOYEE
Sec 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

Employee Benefit View 6


Attribute or measure name	Table field	Archive source table
Company	COMPANY	EMPLOYEE
Employee	Employee	EMPLOYEE
Employee Status	EMP_STATUS	EMPLOYEE
Supervisor	SUPERVISOR	EMPLOYEE
Department	DEPARTMENT	EMPLOYEE
First Name	FIRST_NAME	EMPLOYEE
Last Name	LAST_NAME	EMPLOYEE
Last Prefix	LAST_NAME_PRE	EMPLOYEE
Middle Initial	MIDDLE_INIT	EMPLOYEE
Name Suffix	NAME_SUFFIX	EMPLOYEE
Description	R_DESC	R_Plan
Process Level	PROCESS_LEVEL	EMPLOYEE
Security Level	SEC_LVL	EMPLOYEE
Security Location	SEC_LOCATION	EMPLOYEE
Contrib Type	CONTRIB_TYPE	R_Plan
Coverage Type	COVERAGE_TYPE	R_Plan
Plan Code	PLAN_CODE	BENEFIT
Plan Type	PLAN_TYPE	BENEFIT
Term Date	TERM_DATE	EMPLOYEE
Start Date	START_DATE	BENEFIT
Stop Date	STOP_DATE	BENEFIT
User Level	USER_LEVEL	EMPLOYEE
Deduction Start Date	DED_START_DATE	BENEFIT
Deduction Stop Date	DED_STOP_DATE	BENEFIT
Premium Update Date	PREM_UPD_DT	BENEFIT
Percent Amount Indicator	PCT_AMT_FLAG	BENEFIT
Pre Tax Deduction Sequence	PRE_SEQ_NBR	BENEFIT
AFT Sequence	AFT_SEQ_NBR	BENEFIT
Plan Option	PLAN_OPTION	R_Plan
AFT Company Deduction Sequence	CMP_AFT_SEQ	BENEFIT
Company Deduction Sequence	CMP_SEQ_NBR	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 Match Amt Deduction	PRE_DED_MTCH_A	R_Plan
Pre Tax Match Per Deduction	PRE_DED_MTCH_P	R_Plan
Pre Tax Per Decution	PRE_DED_CODE_P	R_Plan
Annual Amount	ANNUAL_AMT	BENEFIT
Waive Flag	WAIVE_FLAG	R_Plan
Coverage Option	COV_OPTION	BENEFIT
NBR Hours	NBR_HOURS	BENEFIT
Dependent Coverage Amt	DEP_COVER_AMT	BENEFIT
Multiple	MULTIPLE	BENEFIT
Cover Amount	COVER_AMT	BENEFIT

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

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 Activity 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

General Ledger Transaction History View 5

General Ledger Transaction History View 4

General Ledger Control

Budget Detail

General Ledger Transaction History View 3

General Ledger Transaction History

General Ledger Amounts

General Ledger Transaction History View 1

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

Vendor Agreement

PO Line Item Receiving

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

Invoice Payment View 4

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

COBRA Participant Benefit

Employee Benefit View 5

Employee Benefit View 6

Employee Benefit View 3

Employee Benefit View 1