REFERENCED BY
PA290 | PA372 | PA590 | PA90.1 | PA90.2 | PA90.3 |
PA91.1 |
PA92.1 | PA292 | PA490 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
OTB-COMPANY Element: Company Hr | Numeric 4 |
|
||
OTB-ESTABLISHMENT Element: Establishment | Alpha 10 |
|
||
OTB-EST-NAME Element: Est Name | Alpha 30 (Lower Case) Establishment Name. |
|
||
OTB-ACTIVE-FLAG Element: Active Flag | Alpha 1 The Active flag of the credit card type. |
|
||
OTB-EST-ADDR1 Element: Est Addr1 | Alpha 30 (Lower Case) Establishment Address One. |
|
||
OTB-EST-ADDR2 Element: Est Addr2 | Alpha 30 (Lower Case) Establishment address two. |
|
||
OTB-EST-ADDR3 Element: Est Addr3 | Alpha 30 (Lower Case) |
|
||
OTB-EST-ADDR4 Element: Est Addr4 | Alpha 30 (Lower Case) |
|
||
OTB-EST-CITY Element: Est City | Alpha 18 (Lower Case) Establishment city. |
|
||
OTB-EST-STATE Element: Est State | Alpha 2 Establishment state. |
|
||
OTB-EST-ZIP Element: Est Zip | Alpha 10 Establishment zip. |
|
||
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). |
|
||
OTB-CONTACT-LAST Element: Contact Last | Alpha 30 (Lower Case) |
|
||
OTB-CONTACT-FIRST Element: Contact First | Alpha 15 (Lower Case) |
|
||
OTB-CONTACT-MI Element: Contact Mi | Alpha 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. |
|
||
OTB-PHONE Element: Phone | Alpha 15 Phone number. |
|
||
OTB-PHONE-EXT Element: Phone Ext | Alpha 5 This field contains the telephone extension number. |
|
||
OTB-FAX-COUNTRY Element: Phone Country | Alpha 6 This field contains the prefix of the telephone number. For example, the country or city code. |
|
||
OTB-FAX-NBR Element: Fax Nbr | Alpha 15 |
|
||
OTB-FAX-EXT Element: Phone Ext | Alpha 5 This field contains the telephone extension number. |
|
||
OTB-EMAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) e-mail address. |
|
||
OTB-USER1 Element: User1 | Alpha 10 |
|
||
OTB-USER2 Element: User2 | Alpha 10 |
|
||
OTB-NUMERIC1 Element: Numeric1 | Signed 15.4 |
|
||
OTB-NUMERIC2 Element: Numeric2 | Signed 15.4 |
|
||
OTB-SIC-CD Element: Sic Cd | Alpha 6 (Lower Case) |
|
||
OTB-INDUSTRY-DESC Element: Industry Desc | Alpha 30 (Lower Case) |
|
||
OTB-AVG-NBR-EMPS Element: Avg Nbr Emps | Numeric 6 |
|
||
OTB-ADDL-NBR-EMPS Element: Addl Nbr Emps | Numeric 6 |
|
||
OTB-TOT-HRS-WORKED Element: Tot Hrs Worked | Numeric 10 |
|
||
OTB-ADDL-HRS-WRKED Element: Addl Hrs Wrked | Numeric 10 |
|
||
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) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OTBSET1 |
COMPANY ESTABLISHMENT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||
Country | INSTCTRYCD |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Osha | OSHA |
Delete Cascades
| |||||||||||||||
Osha Detail | OSHESTDTL |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.