OSHESTAB

REFERENCED BY
PA290 PA372 PA590 PA90.1 PA90.2 PA90.3
PA91.1


UPDATED BY
PA92.1 PA292 PA490

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTB-COMPANY
Element: Company Hr
Numeric 4
PA92.1
OTB-ESTABLISHMENT
Element: Establishment
Alpha 10
PA92.1
OTB-EST-NAME
Element: Est Name
Alpha 30 (Lower Case)
Establishment Name.
PA92.1
OTB-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag of the credit card type.
PA92.1
OTB-EST-ADDR1
Element: Est Addr1
Alpha 30 (Lower Case)
Establishment Address One.
PA92.1
OTB-EST-ADDR2
Element: Est Addr2
Alpha 30 (Lower Case)
Establishment address two.
PA92.1
OTB-EST-ADDR3
Element: Est Addr3
Alpha 30 (Lower Case)
PA92.1
OTB-EST-ADDR4
Element: Est Addr4
Alpha 30 (Lower Case)
PA92.1
OTB-EST-CITY
Element: Est City
Alpha 18 (Lower Case)
Establishment city.
PA92.1
OTB-EST-STATE
Element: Est State
Alpha 2
Establishment state.
PA92.1
OTB-EST-ZIP
Element: Est Zip
Alpha 10
Establishment zip.
PA92.1
OTB-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
PA92.1
OTB-CONTACT-LAST
Element: Contact Last
Alpha 30 (Lower Case)
PA92.1
OTB-CONTACT-FIRST
Element: Contact First
Alpha 15 (Lower Case)
PA92.1
OTB-CONTACT-MI
Element: Contact Mi
Alpha 1
PA92.1
OTB-PHONE-COUNTRY
Element: Phone Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
PA92.1
OTB-PHONE
Element: Phone
Alpha 15
Phone number.
PA92.1
OTB-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
PA92.1
OTB-FAX-COUNTRY
Element: Phone Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
PA92.1
OTB-FAX-NBR
Element: Fax Nbr
Alpha 15
PA92.1
OTB-FAX-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
PA92.1
OTB-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
PA92.1
OTB-USER1
Element: User1
Alpha 10
PA92.1
OTB-USER2
Element: User2
Alpha 10
PA92.1
OTB-NUMERIC1
Element: Numeric1
Signed 15.4
PA92.1
OTB-NUMERIC2
Element: Numeric2
Signed 15.4
PA92.1
OTB-SIC-CD
Element: Sic Cd
Alpha 6 (Lower Case)
PA92.1
OTB-INDUSTRY-DESC
Element: Industry Desc
Alpha 30 (Lower Case)
PA92.1
OTB-AVG-NBR-EMPS
Element: Avg Nbr Emps
Numeric 6
PA92.1
OTB-ADDL-NBR-EMPS
Element: Addl Nbr Emps
Numeric 6
PA92.1
OTB-TOT-HRS-WORKED
Element: Tot Hrs Worked
Numeric 10
PA92.1
OTB-ADDL-HRS-WRKED
Element: Addl Hrs Wrked
Numeric 10
PA92.1
OTB-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.
OTB-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
OTB-USER-ID
Element: User
Alpha 10 (Lower Case)


OSHESTAB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OTBSET1 COMPANY
ESTABLISHMENT
PA290 PA292
PA372 PA490
PA590 PA90.1
PA90.2 PA90.3
PA91.1 PA92.1
PA92.2


OSHESTAB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
OTB-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When OTB-COUNTRY-CODE !=Spaces
OTB-COUNTRY-CODE->INT-COUNTRY-CODE


OSHESTAB FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Osha OSHA Delete Cascades
OTB-COMPANY->OSH-COMPANY
OTB-ESTABLISHMENT->OSH-ESTABLISHMENT
  OSH-SEQ-NBR
  OSH-EMPLOYEE
Osha Detail OSHESTDTL Delete Cascades
OTB-COMPANY->ODT-COMPANY
OTB-ESTABLISHMENT->ODT-ESTABLISHMENT
  ODT-PROCESS-LEVEL
  ODT-DEPARTMENT
  ODT-LOCAT-CODE


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

Home
Contact Us



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