PAINCICOST

Contains incident cost information. This file is maintained primarily by PA90.3 (Incident Costs).
UPDATED BY
PA290 PA372 PA490 PA590 PA90.1 PA90.3
HR00.1 HR01.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAI-COMPANY
Element: Company Hr
Numeric 4
PA590 PA90.3
PAI-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
PA590 PA90.3
PAI-ESTABLISHMENT
Element: Establishment
Alpha 10
Contains the establishment where the incident occurred.
PA590 PA90.3
PAI-INCIDENT-NBR
Element: Incident Nbr
Numeric 4
Contains the incident report number.
PA590 PA90.3
PAI-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
PA590 PA90.3
PAI-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date for the incident cost.
PA590 PA90.3
PAI-COST-CAT
Element: Cost Cat
Alpha 10
Contains the user-defined incident cost category.
PA590 PA90.3
PAI-COST-TYPE
Element: Cost Type
Alpha 10
Contains the user-defined incident cost type.
PA590 PA90.3
PAI-COST
Element: Cost
Signed 11.2
Contains the incident cost.
PA590 PA90.3
PAI-EXP-COMPANY
Element: Company
Numeric 4
Contains the distribution expense company where the cost should be posted.
PA590 PA90.3
PAI-EXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the expense accounting unit where the incident cost should be posted.
PA590 PA90.3
PAI-EXP-ACCOUNT
Element: Account
Numeric 6
Contains the expense account where the incident cost should be posted.
PA590 PA90.3
PAI-EXP-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the expense sub account where the incident costs should be posted.
PA590 PA90.3
PAI-COMMENT
Element: Comment
Alpha 40 (Lower Case)
This field contains the comment narrative.
PA590 PA90.3
PAI-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
PA590 PA90.3
PAI-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA590 PA90.3
PAI-USER-ID
Element: User
Alpha 10 (Lower Case)
PA590 PA90.3
PAI-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the incident cost is recorded.
PA590 PA90.3
PAI-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA590 PA90.3
PAI-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the company's base currency.
PA590 PA90.3
PAI-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
PA590 PA90.3
PAI-BASE-AMOUNT
Element: Base Amt
Signed 15.2
Contains the incident cost in the company's base currency.
PA590 PA90.3


PAINCICOST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAISET1 COMPANY
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR
SEQ-NBR
HR00.1 HR01.1
HR11.1 PA115
PA290 PA372
PA490 PA590
PA90.1 PA90.3
PAISET2 COMPANY
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR*
EFFECT-DATE*
SEQ-NBR*
KeyChange
PA290 PA90.3


PAINCICOST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
When (PAI-CURRENCY-CODE !=Spaces )
PAI-BASE-CURRENCY->CUC-CURRENCY-CODE
Company PRSYSTEM Required
PAI-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Cost Category PCODES Required
When (PAI-COST-CAT !=Spaces )
"OC"->PCO-TYPE
PAI-COST-CAT->PCO-CODE
Cost Type PCODES Required
When (PAI-COST-TYPE !=Spaces )
"OT"->PCO-TYPE
PAI-COST-TYPE->PCO-CODE
Currency CUCODES Required
When (PAI-CURRENCY-CODE !=Spaces )
PAI-CURRENCY-CODE->CUC-CURRENCY-CODE
Employee EMPLOYEE Required
PAI-COMPANY->EMP-COMPANY
PAI-EMPLOYEE->EMP-EMPLOYEE
Establishment OSHESTAB Required
When (PAI-ESTABLISHMENT !=Spaces )
PAI-COMPANY->OTB-COMPANY
PAI-ESTABLISHMENT->OTB-ESTABLISHMENT
Expense Acct GLMASTER Required
When (PAI-EXP-ACCT-UNIT !=Spaces )
Or(PAI-EXP-ACCOUNT !=Zeroes )
PAI-EXP-COMPANY->GLM-COMPANY
PAI-EXP-ACCT-UNIT->GLM-ACCT-UNIT
PAI-EXP-ACCOUNT->GLM-ACCOUNT
PAI-EXP-SUB-ACCT->GLM-SUB-ACCOUNT
Incident OSHA Required
PAI-COMPANY->OSH-COMPANY
PAI-EMPLOYEE->OSH-EMPLOYEE
PAI-ESTABLISHMENT->OSH-ESTABLISHMENT
PAI-INCIDENT-NBR->OSH-SEQ-NBR
Paemployee PAEMPLOYEE Required
PAI-COMPANY->PEM-COMPANY
PAI-EMPLOYEE->PEM-EMPLOYEE


File created: Wed Jun 08 20:50:24 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.