Data Archive Reporting fields

These tables shows the attribute and measure names and their fields from the Lawson source tables:

HR 11 - 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

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

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

PA 13.2 - Multiple Position

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

PA15.2 - Employee Medical-Work Codes

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

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

PA 26 - 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

PA 54 - Personnel Action 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

PA 67 - Employee Rate History

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

BN56 - Compensation History

Attribute or measure name Table field Archive source table
Company COMPANY comphist
Employee EMPLOYEE comphist
User ID USER_ID comphist
Plan Code PLAN_CODE comphist
Plan Type PLAN_TYPE comphist
Plan Year PLAN_YEAR comphist
Date Stamp DATE_STAMP comphist
Time Stamp TIME_STAMP comphist
Create User ID CREATE_USER_ID comphist
Create Time CREATE_TIME comphist
Create Date CREATE_DATE comphist
CPH Compensation Amount COMP_AMOUNT comphist
CPH Hours Service HOURS_SERV comphist

PA59 - Grievance and Disciplinary Action

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

PA02 - Position

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

TR21 - Training History

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

BN32 - Employee Benefit Changes

Attribute or measure name Table field Archive source table
Company COMPANY BENEFIT BEN
Employee EMPLOYEE BENEFIT BEN
User ID USER_ID BENEFIT BEN
Plan Type PLAN_TYPE BENEFIT BEN
Plan Code PLAN_CODE BENEFIT BEN
Plan Option PLAN_OPTION BENEFIT BEN
Update Date UPD_DATE BENEFIT BEN
Time Stamp TIME_STAMP BENEFIT BEN
Start Date START_DATE BENEFIT BEN
Stop Date STOP_DATE BENEFIT BEN
Sequence Number TRAN_SEQ_NBR BENEFIT BEN
Premium Update Date PREM_UPD_DT BENEFIT BEN
STM Sequence STM_SEQ_NBR BENEFIT BEN
Premium Group PREM_GROUP BENEFIT BEN
Pre Tax Deduction sequence PRE_SEQ_NBR BENEFIT BEN
Percent Amount Indicator PCT_AMT_FLAG BENEFIT BEN
Pend Evidence PEND_EVIDENCE BENEFIT BEN
Pay Rate PAY_RATE BENEFIT BEN
Override Coverage Flag COV_OVER_FLG] BENEFIT BEN
Object Idenifier TA_OBJ_ID BENEFIT BEN
Multiple MULTIPLE BENEFIT BEN
Match Percentage MTCH_UP_TO BENEFIT BEN
Last Purchase Sequence LAST_SEQ_PURCH BENEFIT BEN
GL Update Date GL_UPD_DT BENEFIT BEN
Flex Plan FLEX_PLAN BENEFIT BEN
Flex Deduction Sequence FLEX_DED_SEQ BENEFIT BEN
Eligibility Update Date ELIG_UPD_DT BENEFIT BEN
Eligibility Group ELIG_GROUP BENEFIT BEN
Deduction Stop Date DED_STOP_DATE BENEFIT BEN
EFD Start Date EFD_START_DATE BENEFIT BEN
Deduction Start Date DED_START_DATE BENEFIT BEN
Cycles Remain CYCLES_REMAIN BENEFIT BEN
Currency Nd CURR_ND BENEFIT BEN
Currency Code CURRENCY_CODE BENEFIT BEN
Creation Date CREATION_DATE BENEFIT BEN
Create User ID CREATE_USER_ID BENEFIT BEN
Create Time CREATE_TIME BENEFIT BEN
Coverage Update Date COV_UPD_DT BENEFIT BEN
Coverage Salary Date COV_SAL_DATE BENEFIT BEN
Coverage Option COV_OPTION BENEFIT BEN
Coverage Group COV_GROUP BENEFIT BEN
Coverage Age Date COV_AGE_DATE BENEFIT BEN
Company Match Percent COMP_MATCH BENEFIT BEN
Company Deduction Sequence BENEFIT BEN
CNT Service Date CNT_SERV_DATE BENEFIT BEN
CNT Salary Date CNT_SAL_DATE BENEFIT BEN
CNT Age Date CNT_AGE_DATE BENEFIT BEN
AFT Sequence AFT_SEQ_NBR BENEFIT BEN

AFT Company Deductions

Sequence

 CMP_AFT_SEQ BENEFIT BEN
EBC Annual Amount ANNUAL_AMT BENEFIT BEN
EBC Bond Deduction Amount BOND_DED_AMT BENEFIT BEN
EBC Bonds NBR_PURCH BENEFIT BEN
EBC Company Contribution COMP_CONT BENEFIT BEN
EBC Company Flex Amount BENEFIT BEN
EBC Dependent Coverage Amount DEP_COVER_AMT BENEFIT BEN
EBC Employee AFT Contribution Amount EMP_AFT_CONT BENEFIT BEN
EBC Employee Pre Tax Contribution Amount EMP_PRE_CONT BENEFIT BEN
BENEFIT BEN
EBC Employee YTD Contribution EMP_YTD_CONT BENEFIT BEN
EBC Flat Amount COVER_AMT BENEFIT BEN
EBC Hours NBR_HOURS BENEFIT BEN
EBC Employee YTD Contribution EMP_YTD_CONT BENEFIT BEN
EBC YTD Contribution Amount YTD_CONT BENEFIT BEN
EBC YTD Flex Contribution Amount YTD_FLEX_CONT BENEFIT BEN

BN47 - Beneficiaries

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

PR12 - Bank Details

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

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

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

PR51 - Pay Stub Inquiry

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

PR260 - Payment Detail Listing

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

PR260 - Payroll Register

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

GL90 - Transactional Analysis

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

GL40 - Journal Entry

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

GL-45 Journal 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

GL95 - Account Analysis

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

GL290 - Global Ledger Report

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

GL190 - Journal Posting

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

GL291 - Trail Balance

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

GL165 - Transaction Interface

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

AC225 - Budget Control

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

AC290 - Transaction Listing

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

AC295 - Activity Commitment Summary

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

AC220 - Budget Listing

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

AC480 - Activity Balances

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

LP31 - Employee Absence Plan Master

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

LP64 - Employee Transaction Detail Inquiry

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

IC45 - Stock Status

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

IC50 - Transaction History

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

IC44 - Inventory Stock Status

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

IC42 - Stock By Detail

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

IC31 - Item Location Balances

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

IC55 - Transaction History Inquiry

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

IC30 - Item Search

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

AM85 - Activity Analysis

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

AM267 - Asset Register

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

AM277 - Activity Report

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

AM260 - Asset Report

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

AM278 - Leased Asset Report

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

PO54 - Purchase Order Inquiry

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

PO28 - Agreement Item Lookup

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

PO58 - Receipt Inquiry

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

PO220 - PO Status Report

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

AP57 - Amount Scripting

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

AP92 - Vendor Invoices

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

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

AP270 - Vendor Payment History

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

AP225 - Vendor Statements

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

AP255 - Bank Account Payment History

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

AP265 - Cash Payment Register

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

AP90 - Invoice Search By Vendor Invoice

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