Jde World A7.3 Data Models Peoplebook 1d3w6p

World A7.3 Data Models PeopleBook

June 1996

J.D. Edwards World Source Company 7601 Technology Way Denver, CO 80237

Copyright J.D. Edwards World Source Company, 1998 All Rights Reserved SKU A73E

The information in this guide is confidential and a proprietary trade secret of J.D. Edwards & Company. It may not be copied, distributed, or disclosed without prior written permission. This guide is subject to change without notice and does not represent a commitment on the part of J.D. Edwards & Company. The software described in this guide is furnished under a license agreement and may be used or copied only in accordance with the of the agreement. J.D. Edwards & Company uses an automatic software disabling routine to monitor the license agreement. For more details about this routine, please refer to the Technical Foundation Guide.

Table of Contents

Technical Foundations +#/2-" "-.&+* ",+.&/+-4 / & /&+*-4

Financials "*"-( +0*/&*$ !!-".. ++' (" /-+*& &( +0*/. 4(" +0*/. " "&1(" &3"! .."/.

Manufacturing -+!0 / / *$")"*/ +-" ./&*$ %+, (++- +*/-+( +*#&$0-/&+* *$")"*/ , &/4 *$")"*/ *0# /0-&*$ *! &./-&0/&+* (**&*$ ")*! &!" *0# /0-&*$ *! &./-&0/&+* (**&*$ 0,,(4 &!"

Distribution 0- %." *$")"*/ (". -!"- *$")"*/ *1"*/+-4 *$")"*/ -"%+0." *$")"*/

Architecture, Engineering & Construction + +./ +-' -!"-. +*/- / &((&*$ "/0, +*/- / &((&*$ +-'#&(" "*"-/&+* +*/- / &((&*$ *1+& " +-)/ "#&*&/&+* +*/- / &((&*$ "1"*0" " +$*&/&+*

Release A7.3 (June 1996)

Data Models Contract Billing Base . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Service Billing Base . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Service Billing Workfile Generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Service Billing Revenue Recognition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Service Billing Invoice Format Definition . . . . . . . . . . . . . . . . . . . . . . . . . . Contract Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Change Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Equipment Billing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Plant and Equipment Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Plant and Equipment Maintenance (continued) . . . . . . . . . . . . . . . . . . . . . Property Management Base . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Expense Participation and Escalation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Sales Overage and Sales Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

26 27 28 29 30 31 32 33 34 35 36 37 38

Human Resource Management Pay Cycle Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Payroll History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Payroll Journal Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Canadian Pay Cycle Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Canadian Payroll History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Canadian Journal Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Benefits istration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Employee History and Turnover . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Job Specifications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Applicants, Requisitions, and Positions . . . . . . . . . . . . . . . . . . . . . . . . . . . . Supplemental Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Pay Grade Step . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .


39 40 41 42 43 44 45 46 47 48 49 50 51

Data Models

Technical Foundations


Data Models


Software Version Repository

Software Version Repository Software Inventory F9801

1

Member Locations F9802

M

DREAM Writer 1

DREAM Writer Print Overrides F98312

1 1

Member Source Lib. Source Name

Description Member ID Function

DREAM Writer Master F98301 Program Name Version Type Prompt Line

M

Menus

1 1

Version Identifier F98311

1

1

Menu Header Info. F0082

Program Name Version Print Queue Lines Per Inch Font ID

M

Menu Selection Info. F00821 Selection Marking

Header Marking

1 M

Menu Selection Language F0083

1

1

1

1

M

1

Data Selection F9831 Program Version Prompt Line

Heading By Language F98303 Program Name Version Language Prompt Line

M

M

Program Name Version Prompt Line

M

Processing Options F98302 Program Name Version Language Option Number Table Relationships 1 = 1 record M = many records

–1

–2

Data Dictionary M

Field Specification F9201

Error Message Only F9205

Size Decimals Program Name

Data Item Program Name 1

Master F9200

1

Vocabulary Overrides M

M

Data Item Language Pref. Reporting Code

1

Text Master F9220

1

1

Video Screen Language Pref. Reporting Syst.

Function Key Translation Master F9601 Screen Name Key Trans. Selected Trans.

Data Aliases F9204

1

1 1

Data Display F9202

M

Data Item Field Name Alias Type

Data Item 1

M

1

Defined Codes M

Alpha Description F9203

General Text F9816

Data Item Language Pref. Reporting Code Screen Name

Serial Number Line Number Text

M

M

Code Record Types F0004 System Code Code Title Code Length Numeric (Y/N)

1

M

Code Values F0005 System Code Description Code Value

Table Relationships 1 = 1 record M = many records

Data Models

Financials


Data Models



General ing Fiscal Date Patterns F0008

1

M

Date Pattern Code Fiscal Year Begin Date Period Ending Dates 1 –14

1

1

Company Constants F0010 Company No. Company Desc. Date Pattern Code Fiscal Year Begin Date Current G/L Period Number Current A/R Period Number Current A/P Period Number

1

Business Unit Master F0006

1

1

1

M

Defined Data

1

M

Master F0901 No. Desc. Level of Detail Posting Edit Code Category Codes 1–23 Budget Pattern Code

1

Balances F0902 No. Fiscal Year Ledger Type Subledger Subledger Type Originating Currency Balance Forward Period Balances 1–14 Requested Annual Budget Approved Annual Budget Final Annual Budget

1

Document Type Document No. G/L Date JE Line Number Ledger Type Posted Code Batch Type Number Subledger Subledger Type Currency Code Currency Exchange Rate Amount Units Explanation 1 M

Extended Text F0016, F00163 Free–Form Text


3

Data Models

Supplemental Database F00690, 92, 93

Business Unit No. Business Unit Desc. Business Unit Type Company Level of Detail Category Codes 1–30

M

M

M

Address Number Name Phone Number Address Category Codes

M

Company Object Description Level of Detail Posting Edit Code

1

Address Book Master F0101

Journal Entries F0911

Chart of s F0909

Names (Who’s Who) F0111

M

1 1 M

Address Number Line ID (zero Line ID = legal entity) Alpha Name Mailing Name Salutation Name Surname Given Name Title Who’s Who Type Category Codes

M

1

M

Parent/Child Relationships F0150 Structure Type Address Number Child Address Number Display Sequence Begin Date End Date Remark

1

Address Number Effective Date Address Lines Postal Code City State County Country

M

Address Number Line ID Sequence Number Phone Type Area Code Phone Number Display Sequence

M

1 Address Number Search Type 1 Long Address Number Tax ID Number Person/Corporation Category Codes

Addresses (by date) F0116

1

Phones F0115

Address Book (legal entities) F0101

Customer Master F0301 Address Number Customer Master Information Billing Instructions

M 1 1

Zip Codes F0117


Postal Code City State County

Vendor Master F0401 Address Number Vendor Master Information Purchasing Instructions


Data Models

4

Address Book


Electronic Mail Address Book Master F0101 1 1 1


1

1

1

M

Filters of Incoming Mail F01136 Parent Number Address Number Mailbox Designator

M

M

Bulletin Board Enrollment F01134

Message Header F01131

ID Address Number Display Sequence Class Lang.

M

M

Time Log Ledger F0112

Flash Schedule Master F0126

Serial Number Parent Number From Address Tickler Date

Calendar

Time In Time Out

1

M

Message Distribution F01133

Message Text F01132 Serial Number Generic Text Line Number


5

Data Models

Serial Number Address Number Mailbox Designater Tickler Date Message Status

1

6

s Payable M 1

A/P Ledger F0411

Supplier Master F0401 Address Number Alternate Payee YTD Vouchered

1

1

Address Book F0101

As Of A/P Ledger F0411A

1

1

M

M 1

Document Type Document Number 1 Document Company Pay Item Address Number Invoice Date G/L Date Gross Amount Open Amount Payee Company 1

1

Document Type Document Number Document Company Pay Item Address Number Invoice Date G/L Date Gross Amount Open Amount Payee Company M

M Address Number Alpha Name Category Codes Tax ID 1

Extended Text F0016 F00163

A/P Matching Document Detail F0414

Free–Form Text

1 Release A7.3 (June 1996)

M

M

A/P Matching Document F0413 Matching Document Type Payment Item Number Payee Payment Date Void Date G/L Bank Payment

As Of A/P Payment Detail F0414A

M

Matching Document Type Document Company Document Type Document Number Pay Item Payment Amount Company Address Number

M

1


1

Matching Document Type Document Company Document Type Document Number Pay Item Payment Amount Company Address Number

Ledger F0911 ID Ledger Type Document Type Document Number Document Company G/L Date Amount Units Address Number

M

As Of Payment F0413A

1

1

1

1

Matching Document Type Payment Item Number Payee Payment Date Void Date G/L Bank Payment

1


s Receivable Customer Master F0301

1

Credit Collections Mgmt. F0315

1 1

Parent Number Address Number Company Open Aging Buckets Amount Over Credit Line Parent/Child Relationship

Address Number Credit Limit Invoiced This Year

M 1

Address Book F0101

1


M

A/R Ledger F0311 Document Type Dcoument No. Pay Item Address Number Invoice Date G/L Date Gross Amount Open Amount

A/R Ledger ”As Of” F0311A

M

1

1

M

Document Type Document No. Pay Item Address Number Invoice Date G/L Date Gross Amount Open Amount

1


Extended Text F0016 F00163

Ledger F0911

7

ID Ledger Type Document Type Document No. Document Co. G/L Date Amount Units

Data Models

Free–form Text

M

Company Constants F0010

M

1

Asset No. Prefix: Item Unit or Tag Serial Acct. Setup Defaults: Cost A/D Expense Revenue

Item Master F1201

M

Asset Number Description Parent Number Location Major Class Sub Class Resp. Cost Cntr. Date Acquired Date Disposed Cost Accumulated Depr. Acct Expense Acct. Revenue Acct. Company

M

Default ing Constants F12002

1

Company Cost Object Cost Subsidiary Accumulated Depr. Expense Acct. Revenue Acct. Major Class Sub Class

Default Depreciation Cnst. F12003 Release A7.3 (June 1996)

Company Cost Object Cost Subsidiary Accumulated Depr. Expense Acct. Revenue Acct. Major Class Sub Class

1

M

1

1

M

1

Item Balances F1202

Depriciation Rule Header F12851

Depriciation Formula F12853

Asset Number Number Ledger Type Fiscal Year Acct. Balances Depreciation Rule ”Header” Date Pattern Annual Rule Formulas Spread Pattern GL Journal Entries

Description Method Life Initial Term Apportion Computation Direction In–Service Dates Effective Dates Conventions

Formula ID Description Formula Depriciation Formulat Amount

Location Master F1204 Asset Number Location Start Date Ending Date

1 M 1

1

Supplemental Database F12090, 92, 93

1 M

Asset Number Location Start Date Ending Date

Defined Data 1 M

Specification Data F1216 Asset Number Data Items Page Number

Specification Cross Reference F1215 Category Code Language Description Page Number

Parent History F1212

M

Annual Depreciation Rule F12852 Header Key Life Year In–Service Month Annual Multiplier Period Pattern Depreciation Formula Basis Formula Base Amount Formula Limit Amount Formula Salvage Value Formula

Depreciation Spread Formula F12854 Spread Pattern Reference Description Percent of Budget by Period

Location History F1210 Next Number Log Text Line Number Log Text

Item Messages F1205 Message Text


Data Models

8

Fixed Assets

Data Models

Manufacturing


Data Models



Product Data Management M

M

Routing Master F3003

M

Work Center ID Hours Effective Dates Operation No.

Item Master F4101 Item Number Description Units of Measure Category Codes

1

M

Item Branch F4102 Item Number Description Units of Measure Category Codes Branch

1

M

Work Center Master F30006 Work Center Definition Frozen Rates Simulated Rates Work Center Location

Bills Of Materials Master F3002 Component Item/Branch Effective Dates Quantity Per Assembly Parent/Compon. Relationship Def.

1

Business Unit Master F0006 Cost Center No. Cost Center Desc. Cost Center Type Company Level of Detail Category Codes 1–23

Manufacturing Constants F3009

1

Log Bill of Material Online BOM Validation Master Routing Work Center Rates

1 M

1

Item Cost Components F30026

1

1

Direct Labor Setup Labor Machine Run

Cost Type Frozen Costs Simulated Costs 1

Work Center Rate F30008

1

9

Co–Product Branch Process Feature Planner Percent


Data Models

Co–Products Planning/ Costing F3404

Data Models

10

Forecasting Inclusion Rules F34004 Sales Order F4211

1

Order Type Business Unit Company Requested Date Item Number Master Planning Family Unit of Measure Quantity Unit Price Extended Price

1

Sales History F42119 Order Type Business Unit Company Requested Date Item Number Master Planning Family Unit of Measure Quantity Unit Price Extended Price M

M

Inclusion Version Order Type 1 Line Type Status Code

1

M

1

1

1

M M

Item Number Business Unit Forecast Type Date Requested Year Branch Forecast Quantity Forecast Amount 1

Summary Forecast F3400

1

Summary Work F34006

Detail Forecast F3460

1

Item Number 1 Business Unit M Forecast Type Date Requested Year Branch Forecast Quantity Forecast Amount Summary Codes Category Codes

1

Summary Code Forecast Type Category Codes By Forcing Forecast Quantity Forecast Amount

M

1

1

Fiscal Date Pattern F0008 Fiscal Date Pattern Year Date Fiscal Year Begins Date Pattern Type End of Period Century



Item Number Business Unit Master Planning Family Planner Number

M

1

Summary Constants F4091 Summary Code Location Category Codes Master Planning Family

1

Fiscal Date Pattern Year Date Fiscal Year Begins Date Pattern Type End of Period Century 1

M

1

Branch/Plant Master F4102

Fiscal Date Pattern 5.2 Period ing F0008B

M

Address Book F0101 Address Number Business Units Description


Shop Floor Control Item Master F4101

1

Cost Center F0006

Item Number Description Units of Measure Category Codes

Address Number Company Tax Area Category Codes G/L Bank Acct. Labor Distrib. Subledger Inactive

1 M

M

Item Location F4102 Branch/Plant Location Lot Quantities Cost/Price Category Codes 1


M 1

Work Order Header F4801

M

1

M

1

M

Item/Branch Quantitiy Start Date Requested Date

Work Order Text F4802 Text

1

Work Order Hours/Qty’s F31122

M

Work Order Routing F3112 Work Center ID Hours Start Date Completion Date Operation No.

1

1

1

1

1

M

M Actual Hours Actual Quantities Operation

M

Item Quantity Location Requested Date

1

M

Work Order Variances F3102

M 1

11

M

Cost Type Quantities Hours Amounts

M

M

Journal Entries F0911 Document Type Document No. G/L Date JE Line Number Posted Code Batch Type Number Subledger SUbledger Type Ledger Type Currency Code Currency Exchange Rate Amount Units Explanation

Data Models

Work Order Parts List F3111

M

Configurator Constants F3209 Controls: Subsystem Availability Quotes WO Status for changes Calculated segments Segment delimiter


1

Item Master F4101

Business Unit No. 1 1 Business Unit Desc. Business Unit Type Company Level of Detail Category Codes 1–23

Configured String ID’s by item and level


1

M

1

Rules Table Value Definition F32821 Holds multiple values for calculated segments

M

1

1

Configured Item Cross Reference F3282

1


M

Keys to the table Table Values

1

1

1

1

1

1

Cross Segment Editing Rules F3292

M

Configured String/Detail F32942

If Statements Then Statements

Configured String ID’s by segment 1 values

1

1

Config. * Values F32922

Assembly Inclusion Rules F3293

M

Rule Table Keys F3283

Config. * Range F32921

M

1

Table type Description Number of Segments Number of Return Values

M

1

Segment Def. Segment Values Segment Print Controls M

Rules Table Definition F3281


Configured Item Segments F3291

Define segments that use table lookups

1

Configured String/Mask F32941

If Statements Then Statements Rule Types: C – Calculation P – Parts Lists Q – WO Component R – Routing X – Price/Cost Adjustments

M

1

1 M

1

1

M

1

Configured String History F3294

Sales Order Detail F4211

Sales Order Info. Configured String ID’s

Order ID Item ID Qty. Shipped Qty. Backordered Unit Price Unit Cost Discount Req’d Date Promised Date

Configurator Level/ Sequence F3296 Level and sequence of configured parts on a Sales Order

Work Order Header F4801 Related WO. generated from Sales Order

Data Models

12

Configuration Management


Capacity Management


1

Work Center Master F30006

1

Business Unit No. Business Unit Desc. Business Unit Type Company Level of Detail Category Codes 1–23

1

Work Center Definition Frozen Rates Simulated Rates Work Center Location 1

Work Center Resource Units F3007 Resource Units Unit of Measure

1

Table Relationships 1 = 1 record M = many record

1

1 M

1

Work Order Routing F3112

1 1 1

Work Center ID Hours Date (Start & Complete) Operation No.

M

Capacity Messages F3311 M

1

1

M

Work Center ID Work Order No. Hours Date

M

Period Summary F3312 M M

Work Center ID Date Hours Percents

M

Capacity Load F3313 M M

13

Data Models

Work Center ID Date Hours Percents

Data Models

14

Manufacturing and Distribution Planning – Demand Side Business Unit Master F0006 Address Number 1 Company Tax Area Category Codes 1 G/L Bank Acct. Labor Distrib. Subledger Inactive

M

Message Detail F3411 Item Message Quanitity Dates

Pegging Detail F3412 Parent Item Work Order No. Date Quantity M

Item Master F4104

Time Series F3413


1

M

1

Item Number Date Quantity

Forecast Consomption Period F3405 Period Date

Work Order Parts List F3111

Pegging Detail F3412

Order Number BOM Type Component Type Operations Seq. Quantity

Item Number Leadtime Offset Parent Item ID Related Order Number

Sales Order Detail F4211

Forecast Detail F3460

M

Order ID Item ID Qty. Shipped Qty Backorder Unit Price Unit Cost Discount Req’d Date Promised Date

M Release A7.3 (June 1996)

M

Forecast Detail F3460 Item Forecast Type Date Quantity Amount


Item Forecast Type Date Quantity Amount


Manufacturing and Distribution Planning – Supply Side Cost Center Master F0006 Address Number 1 Company Tax Area Category Codes 1 G/L Bank Acct. Labor Distrib. Subledger Inactive

M

Message Detail F3411 Item Message Quantity Dates

Purchase Order Detail F4311

Pegging Detail F3412 Parent Item Work Order No. Date Quantity M

Item Master F4104

Time Series F3413


1

M

Item Number Date Quantity

Forecast Consumption Periods F3405 Period Date

M

Work Order Master F4801

Order ID Item ID Quantity Unit Cost Discount Required Date Promised Date

Work Order NO. Address Number Job Phase Scheduled Date

Rate Schedule F3104

Item Location F4102

Effective Dates Scheduled Priority Scheduled Quantity

Branch/Plant Location Lot Quantities Cost/Price Category Codes

1

M M

Forecast Detail F3460

Data Models

15

Item Forecast Type Date Quantity Amount


Data Models


16

Data Models

Distribution


Data Models



Purchase Management

Sales Orders Heading F4201 Order ID Customer ID Shipping Addr. Order Total Freight Order Date

Item Master F4101 1

Address Book F0101

1

1

1

Item ID Branch/Plant Location Lot Quantities

1

1

M

M

Document Type Document No. G/L Date Entry Line No. Posted Code Number Amount Units

Item Ledger F4111 Document No. Document Type Transaction Quantity Transaction Amount

M

M 1

P.O. Detail F4311

Supplier ID Shipping Addr. Order Amount Freight Originator ID Order Date

1

M M

1

1

1

1

1 M

1

M

1

Order Minimum Order Maximum Order Hold Price Rule

Supplier Price F41061 Supplier ID Item ID Unit of Measure Item Price Effective Date

M

P.O. Detail Text F4314 Order ID Description

P.O. Detail Ledger F43199

16

Order ID Item ID Status Code Quantity Date Updated ID Program ID

P.O. Receipts F43121 Order ID Item ID Qty Received Unit Cost Receipt Date Amt. Received Quantity Paid By Date Amount Paid By Date

s Payable Ledger F0411 Document Type Document No. Pay Item Address Number Invoice Date G/L Date Gross Amount Open Amount

Data Models

Supplier Master F0401

No. Fiscal Year Ledger Type Period Balances Requested Budget Approved Budget

M

M

1

Balances F0902

M

Order ID Item ID Quantity Unit Cost Discount Required Date Promised Date

M

1

Order ID Supplier Address

Item ID Branch/Plant Category Codes

P.O. Header F4301

1


Order Address F4006

1 M


M

Work Order Master F4801 Order ID Address No. Job Phase Scheduled Date

Item ID Description Units of Measure

Item Location F41021

Item Branch F4102

File Relationships 1 = 1 file M = many files

Item Master F4101


Branch/Plant Location Lot Quantities Cost/Price Category Codes

Item Ledger F4111

1 1

Document No. Document Type Transaction Qty. Transaction Amt.

Sales Order Detail Text F4314 Order ID Description

Sales Order Heading F4201 M

M

Order ID Customer ID Cust. Address Ship Address Order Total Freight Order Date

M

Sales Order Detail F4211 1

Order ID Item ID Qty Shipped Qty Backordered Unit Price Unit Cost Discount Required Date Promised Date

M

1

1 1 1

M

M

Sales Order Detail Ledger F42199

1 1

1 M


Order Minumum Order Maximum Order Hold Price Rule

Sales Order Detail History F42119

S.O. Heading History F42019 1

Order ID Customer ID Cust. Address Ship Address Order Total Freight Order Date

1

Sales/Use/ VAT Tax F0018 Order Number Line Number Extended Amt. Tax Rate Tax Explanation Tax Authority

M

1

Billing Instructions F4205


Item Location F4102

M


Address Book F0101

1

1

Order ID Item ID Qty Shipped Qty Backordered Unit Price Unit Cost Discount Required Date Promised Date

Order ID Item ID Status Code Quantity Date Updated ID Program ID

1

s Receivable Ledger F0311 Document TYpe Document No. Pay Item Address No. Invoice Date G/L Date Gross Amount Open Amount

Journal Entries F0911 Document Type Document No. G/L Date JE Line Number Posted Code Batch Type No. Subledger Subledger Type Ledger Type Currency Code Currency Exchange Rate Amount

Data Models

17

Sales Order Management


Inventory Management 1

Item Master F4101

1

Item Number

Branch/Plant Constants F41001 Branch

1 M

Item Branch F4102

M

1 Item Number Branch

1

1

1

1

1 M 1 1

1

1

Pricing F4106

M 1 M

Item Number Branch Location Lot

Price Adjustment Detail F4072 Adjustment Type Item Number Address Number

Item Branch M Lot Location Primary Bin

1

Cost Components F30026

1

Branch Location

M

Item Number Branch Location Lot Ledger Type Cost Method

M 1

1

1

Cost Ledger F4105 Item Number Branch Location Lot Ledger Type

Location Detail F4602 Item Branch Location Lot Sequence No.

18

Data Models

Item Number Branch Lot

1

Location Master F4100

1

M

M 1

Lot Master F4108

File Relationships 1 = 1 file M = many files


Data Models

19

Warehouse Management Company Constants F0010 Company No. Company Desc. Date Pattern Code Fiscal Year Begin Current G/L, A/R, A/P Period No.

Branch/Plant Constants F41001

Cost Center Master F0006 1

M

Location Control Warehouse Control 1 Allocation Method Inclusion Version Location Specs. Warehouse Specs. Receiving Location Shipping Location

Cost Center No. Cost Center Desc. 1 Cost Center Type Company Level of Detail Category Codes

Sales Order Detail F4211 Order ID Item ID Qty. Shipped Qty. Backordered Unit Price/Cost Discount Required Date Promised Date

Warehouse Requests F4600


Order ID Item ID Qty. Received Unit Cost Receipts Date Amt. Received Qty. Paid By Date Amt. Paid By Date

P.O. Detail F4311 Order ID Item ID Quantity Unit Cost Discount Required Date Promised Date

M Warehouse Code Request Batch/Seq Suggestion Batch/ Seq. Wave/Task/Trip M Order ID Structure Info. From/To Location Status

1

1

Order ID Item ID Location Lot Transaction Qty. Structure Info M Reserved Space Status

1 1

Task No. Warehouse Code No. of Trips Cost Center Assigned To Priority

1

M

1

Item Profile F46010

Branch/Plant Location Lot No. Quantities

1

1

1

Item ID Location Lot Storage Unit Structure Info. 1 Receipts/Lot Dates Used Cubes/ Weight Res. Cubes/ Weight

Item Ledger F4111 M

Document No. Document Type Transaction Qty. Transaction Amt.

Standard Unit of Measure Conversions M

M

Item/U of M Profile F46011

M


Item No. Mix/Split Info. Phase Info. Default Locations Base Locations Tax Code 1

Location Detail F4602 M

Std U of M Conversions F41003

Unit of Measure Conversions Unit of Measure Structure

1

M

Warehouse Task Header F4601 1

M

Item Branch F4102

Warehouse Suggestions F4611

Warehouse Reservations F46130

1

M

1

Warehouse Code Order ID Item ID 1 Request Batch/Seq Request Qty./U or M 1 1 From Locations To Location Status

P.O. Receipts F43121

M

Level of Detail Dimensions Characteristics Move Sequences Move Zones Coordinates

1

Item No. Item Description Units of Measure Category Codes


1

U of M Conversions F41002

Item Master F4101

Item/Group ID Unit of Measure Process Rules Capacity Requirements

M

Branch/Plant Location Lot No. Quantities

Data Models

Architecture, Engineering & Construction


Data Models



Job Cost Job Cost Co. Constant F0026

Job Master F0006

M

Company No. Projections Y/N Audit Trails Y/N Commitment Constant

Job Number Job Name Company No. Tax Info. Posting Edit Code 1

1

1

1

Company Master F0010

1

M

Master F0901

1

Extended Master F51901

1

ID Name Job Number Cost Code Cost Type Alternate Cost Code Category Codes 1 Level of Detail Method of Computation Posting Edit Code


ID Start Dates Finish Dates Schedule No.

M

Balances F0902

1

Company No. Company Name Fiscal Pattern Current Period

M

ID Orig. Budget Prior Year Amt. Period Balances Century Fiscal Year Ledger Type 1

M 1

M

Profit Recog. Detail F5144

Job Number Budget ”From” Year Budget ”Thru” Year

Job Number Subledger Budgets Projected Finals Prior Earned Amounts

M

Draw Reporting Master F51911

Ledger Detail F0911

M

M

ID Ledger Type Docu. Number G/L Date Amount

1

1

ID Docu. Number G/L Date Draw Status Amount

Data Models

20

Extended Job Master F5108

Data Models

21

Work Orders Work Order Default Coding File F48001

Work Order Approval F4828 Work Order Number Approval Status Address Number

Category Codes Manager Supervisor

1

M

Work Order Instructions File F4802

Work Order Master File F4801 Work Order No. Type Priority Description Branch Address Nos.

1

1

1 1

M

Work Order Approval Routing F4827

Work Order No. Type Text

M

Work Order Document Type Work Order Type Approval Type Status

M

M Work Order Document Type Work Order Type Status

Work Order Record Types File F48002 Release A7.3 (June 1996)

Work Order No. Type Descriptions

Work Order Status Action Table F4826



Contract Billing Setup

Contract Log Text F52034

Retainage Rules Table F5204

Owner Pay Item Text F52024

Contract Number Text

Rule Description Retainage Percent Percent Complete

Contract Number Owner Pay Item Line Number Text

M

1

1

1

M

Contract Number Owner Description Project Host Parent Contract Tax Rate/Area

M

M

Rate Code Definition Information F52131

Contract Number M Owner Pay Item M Description Line Number Pricing Type Schedule of Values

1

Rate Code Description Line Number Dates Markup Percent

1

M 1

1 Contract Number M Owner Pay Item 1 Line Number Schedule of Values Quantity 1 Pricing Type Tax Rate/Area

Pay Item Component Code Cross Reference Table F5214

1

Contract Number Owner Pay Item Line Number Component Code

Contract Revenue Summary File F5280

22

Contract Number Owner Pay Item Line Number G/L Date Current Amount Current Units Cumulative Amount Cumulative Units

M

Milestone/ Progress Billing Information F5216 Contract Number 1 Line Number Event Percent Complete Dates Batch Number

M

Pay Item Cross Reference File Component Lines F5215 Contract Number Owner Pay Item Line Number Component Code Line Number Cross Reference

Milestone/ Progress Billing Cross Reference Information F52161 M Contract Number Line Number Line Number Cross Reference Batch Number

Data Models


1

Contract Number Owner Pay Item Line Number s

Pay Item Markup Cross Reference F5213

M

Owner Pay Item Detail F5202

Contract Billing Master File F5201

T & M Cross Reference s F5212

Component Table Master F4860 Component Table Description Dates

Component Table Detail F4861 1

M

Component Table Dates Component Code Sequence Percent

Component Cross Reference F4862 1

M

Component Table Dates Component Code

1 M

Cost Plus Markup Information F48096

Journal Entries F0911 Document Type Document Number s Amounts G/L Date

M

1

1

M 1



Contract Number Dates Amounts Customer Employee Number Hours Billing Control ID

1

Time Card History F0618 1

1

M

Key Type Key Value Tax Explanation Code Tax Rate/Area

Employee Number Pay Type Hours Rate Dates Gross Pay Transaction Number

1

Tax Derivation Information F48127

T & M Cross Reference s F5212 Contract No Owner Pay Item Line Number s

M

Key Type Key Value Amounts Dates

M

1

Service Billing Work File F4812

Time Cards F06116 1

Employee Number Pay Type Hours Rate Date Gross Pay Transaction Number

Data Models

23

Contract Billing Workfile Generation


Contract Billing Invoice Format Definition


Table Key Table Value Format

M

1

1

1

M

M

M

Master Sequence Description F4852 1

1

Invoice Format Detail F4851 Format Type Grouping Keys Sequence

Format Type Description

Major Sequence Detail F4853 1

M

Format Type Sequence Data Item

Format Contents F4855 1

Format M Type Page Control Sequence Description Format Type

Detail Sequence F4854 1

M

Format Type Line Number Sequence Data Item


24

Data Models

Batch Invoice Number Document Type

Format Type Retrieval Code Parameters

1

Format Type Description Grouping Key

M

M

Invoice Format Master F4850

Invoice Print Workfile F48504

Invoice Image Workfile F48506

Retrieval Code Parameters Description

M

1

M

Retrieval Reference File F4856 1

Contract Number Owner Description Project Format Host

Format Type Line Number Sequence

Retrieval Code Definition F4857

Format Cross Reference F4858

Data Models

25

Contract Billing Revenue Recognition Comparison Details F4871 Condition Code Sequence Comparison Values

M

M

Service Billing Workfile F4812 Contract Number 1 Dates Amounts Customer Employee Number Billing Control ID

Derivation Information F48126 M

Key Type Key Value Dates s G/L Link Flag Condition Code

1

1

Time Card History F0618


Employee Number Pay Type Hours Rate Date Transaction Number

1

1

M

1 1 Document Type Document Number s Amounts Dates

Journal Entries F0911 1

Document Type Document Number s Amounts Date

1

1

M

Contract Number Dates Amounts Customer Employee Number Billing Control ID Sequence Numbers

s Amounts Dates Billing Control ID Sequence Numbers Component Code 1

1

Service Billing Workfile History F4812H

Compressed Journal Workfile F48911

Detail Journal Workfile F48910

1

Time Card History Workfile F0618WF

G/L Linkage File F48912

Employee Number Pay Type Hours Rate Dates Transaction Number

Billing Control ID s Dates Journal Line Number Sequence Numbers Component Code

Table Relationships 1 = 1 table M = many table


Contract Billing Base Cost Plus Markup Information F48096 Key Type Key Value Amounts Dates

1

M

1

1 M

Service Billing Workfile F4812 Contract Number Dates Amounts Customer Employee Number Hours

M 1

Service Billing G/L Offset & Retainge File F48128

1 M

Derivation Information F48126

Key Type Key Value Payment G/L Offset Return Percent Return Offset

Key Type Key Value Dates s G/L Link Flag

1

G/L Linkage File F48912

1

M

Contract Number Owner Pay Item Line Number Schedule of Values Quantity Pricing Type Tax Rate/Area 1

M M

1

1

M

Service Billing Workfile History F4812H Contract Number Dates Amounts Customer Employee Number Hours Billing Control ID Sequence Numbers

Invoice Summary File F4822

1 1

A/R Detail File F0311 Invoice Number Amounts G/L Offset


s Document Type Amounts Document Number Dates M 1 s Billing Control ID Amounts Sequence Number Dates Component Code

Journal Entries F0911 1 1

Service Billing Retention Release X–Ref File F548221

1

Contract Number 1 Line Number Batch Number Invoice Number Pay item Amounts G/L Offset Customer

1


1

Contract Number Owner Description Project Host Parent Contract Tax Rate/Area

Owner Pay Item Detail F5202


M

1

Batch Number Customer Number Invoice Number

Invoice Summary Access File F48520 Contract Number Owner Pay Item Employee Number G/L Date Business Unit Objects Subsidiary Component Code


Data Models

26

Billing Control ID s Dates 1 Journal Line Number Sequence Numbers Component Code


Data Models

27

Service Billing Base

Cost Plus Markup Information F48096

1 M


Service Billing Workfile F4812

M

Contract Number Dates Amounts Customer Employee Number Hours

M

1

1

1 M

G/L Offset and Retainage Information F48128 Key Type Key Value Payment G/L Offset Return Percent Return Offset

M

Derivation Information F48126

Service Billing Workfile History F4812H

Key Type Key Value Dates s G/L Link Flag

Contract Number Dates Amounts Customer Employee Number Hours Billing Control ID Sequence Numbers

1 1

A/R Leger F0311 Invoice Number Amounts G/L Offset

1 1



G/L Linkage F48912 Billing Control ID s Dates Journal Line 1 Number Sequence Numbers Component Code

1

Invoice Summary Workfile F4822 Contract Number 1 Line Number Batch Number Invoice Number M Pay item Amounts G/L Offset Customer

1


s Document Type Amounts Document Number Dates M 1 s Billing Control ID Amounts Sequence Number Dates Component Code

Service Billing Retention Release Cross Reference F48221 Batch Number Customer Number Invoice Number M

M

Invoice Summary Access F48520 Contract Number Owner Pay Item Employee Number G/L Date Business Unit Objects Subsidiary Component Code

Journal Entries F0911 1 1




Service Billing Workfile Generation Component Table Master F4860 Component Table Description Dates

Component Cross Reference F4862

Component Table Detail F4861 1

M

Component Table Dates Component Code Sequence Percent

1

M

Component Table Dates Component Code

1 M

Ledger F0911 Document Type Document Number s Amounts G/L Date

Cost Plus Markup Information F48096 M

1


Payroll Transaction History F0618

Service Billing Workfile F4812 M Contract Number Dates Amounts Customer Employee Number Hours Billing Control ID M

1

M

1

M

Employee Transactions Detail F06116

1

Tax Derivation Information F48127 1

28

Employee Number Pay Type Hours Rate Date Gross Pay Transaction Number

Data Models


Key Tips Key Value Tax Explanation Code Tax Rate/Area

Employee Number Pay Type Hours Rate Dates Gross Pay Transaction Number

Data Models

29

Service Billing Revenue Recognition

Comparison Details F4871 Condition Code Sequence Comparison Values M

M

Service Billing Workfile F4812 Contract Number 1 Dates Amounts Customer Employee Number Billing Control ID

Derivation Information F48126 M

Key Type Key Value Dates s G/L Link Flag Condition Code

1

1

1 M


Service Billing Workfile History F4812H Contract Number Dates Amounts Customer Employee Number Billing Control ID Sequence Numbers


Detail Journal Workfile F48910 s M Amounts Dates Billing Control ID Sequence Numbers Component Code 1

Employee Number Pay Type Hours Rate Date Transaction Number

Payroll Transaction History Workfile F0618WF 1

1

1


1

1

Payroll Transaction History F0618

1 Document Type Document Number s Amounts Dates

Ledger F0911

1 Employee Number Pay Type Hours Rate Dates Transaction Number

1

G/L Linkage F48912 Billing Control ID s Dates Journal Line Number Sequence Numbers Component Code

Table Relationships 1 = 1 table M = many table


Service Billing Invoice Format Definition Retrieval Code Definition F4857

Format Cross Reference F4858 Table Key Table Value Format

Retrieval Code Parameters Description

Retrieval Reference F4856 1

M Format Type Retrieval Code Parameters

M

M 1

1 M

Invoice Image Workfile F48506

M

1

Format Type Description Grouping Key

1

1

Format Type Description

Major Sequence Detail F4853 1

M

Format Type Sequence Data Item

Format Contents F4855 1

M

Format Type Page Control Sequence Description Format Type

1 M

Invoice Format Detail F4851

Detail Sequence F4854 1

Format Type Grouping Keys Sequence

M

Format Type Line Number Sequence Data Item


30

Data Models

Batch Invoice Number Document Type

Master Sequence Description F4852

Invoice Format Master F4850

Invoice Print Workfile F48504 Format Type Line Number Sequence

M

Data Models

31

Contract Management Vendor Master F0101

1

Address Number Name Address A/P Information

Job Master F0006 Job Number Job Name Company No. Tax Information Positng Edit Code

M

M

1

Contract Header F4301 Contract No. Address Number Job Number Currency Code Exchange Rate Processing Mode Retention Percentage

1

M

1

M

Contract Number Log Type Log Number Status Dates

1

M

Contract Management Constants F0026 1

Company Name Commitment Constant

Contract Log Detail F4303

M M

Contract Detail D4311 Contract Number Line Number ID Company No. Amount Units Unit Cost Pricing Type

1

M


ID Name Posting Edit Code Unit of Measure

Contract Distribution Text F4404 Contract Number Line Number Text

G/L Ledger F0911

1

s Payable Ledger F0411

M

ID Ledger TYpe Docu. Number G/L Date Amount Units Contract Number

1

ID Voucher Number G/L Date Amount Units Contract Number

Contract Detail Ledger (Audit) F43199

M 1


Contract Number Log Type Log Number Text

1

Master F0901

Contract Log Detail Text F4304

M

Contract Number Line Number ID Committed Amt. Relleved Amt. G/L Date Commited Units Relieved Units

Balances F0902 M

1

ID Orig. Budget Prior Year Amt. Period Balances Century Fiscal Year Ledger Type


Change Management M

Job Master F0006

Change Request Text F53015

Contract Billing Master F5201

Job Number Job Name Company Number

M

Contract Number Customer Address

Job Number Change Number Text

Chg. Request Detail Text F53024

Contract Management Master F4301 Contract Number Vendor Address

1

Job Number Change Number Line Number Text

1

1 M M

Chg. Request Statuses F53001

M

Change Request Master F5301 Job Number Change Number Remark Status

1 Status Amount Ledger Unit Ledger

1

M

1

Ledger F0911

1

Job Number Cost Code Cost Type Fiscal Year M Ledger Type Document Type Alpha Explanation Remark Explanation Reference 2

Job Number Change Number Line Number Record Type Status Requote Number Cost Code Cost Type Amount Contract Number

M

Change Request Log F4303

M

Change Request Log Text F53034 Job Number Change Number Log Type Log Number Text

1 1

Master F0901 ID Job Number Cost Code Cost Type Post Edit Code

1

M

Balances F0902 Job Number Cost Code Cost Type Fiscal Year Ledger Type Original Budget Prior Year Balance Period Balances

32

Data Models

Job Number Change Number Log Type Log Number Status Dates

1

M

1

M

1


M

Change Request Details F5302

Data Models

33

Equipment Billing Billing Exclusion Days F1303

Derivation Rules F1305 Company Business Unit Rate Group Item Number Transfer Action Number

Equip. Rate Code Billing Frequency Billable (Y/N) Assoc. Rate 1 Code

Company Location Billing Date Include/Exclude Code

Item Master F1201 Company Item Number Parent Number Description Equip. Status s Quantity Location Rate Group

Rate Code Definitions F1390

1

1

M

1

M

Item Number Location Code Location Effective Dates Transfer Number Equip. Rate Code Quantity Equip. Status Next Number Number

Ledger F0911

M


M

1

1

Location Billings F1304

Transfer Number M Next Number Batch Number Item Number Location M Number Equip. Rate Code Billing Rate Billing Amount Billing Date

1

1

Document No. G/L Date G/L Posted Code Batch Number Number Amount Units Serial Number Batch Rear End Posted Code ID Type

Item Balances F1202 M

1 Fiscal Year Ledger Type Company Balance Forward Period Balances Number Item Number

1 M

Location History Text F1210


Next Number Log Text

Rental Rules F1302 Company Business Unit Default Tables Percent Overrides Equip. Rate Code Prorate Billing (Y/N) Bill Weekends (Y/N) Rental Threshold Standard Hours

M 1

Rental Rates F1301 Rate Table Rate Group Item Number Effec. Date Range Equip. Rate Code Billing Rate Rate Components



Plant and Equipment Maintenance Work Order Status Action Table F4826


Standard Parts Lists F3002

Order Type 1 Type Order Type Status M Type Next Status Approval Type Allowed Status Status Maintenance Sequence Number Status Amount Inventory Address Number Committment Retest Status Subledger Inactive Capacity Flag M 1

Status History F1307

Parts List F3111

Type 1 Parent Part Number Branch Component Item Component Backup

M

Work Order Number Component Item Component Branch Description Quantity

Item Number Work Order No. Status Effective Date Effective Time

1

Order Type Type Approval Type Status Sequence Number Amount Address Number Retest Status

M

Work Center Rates F30008

1 M

M 1

Work Order Supplemental Data Types F48092

Work Order Master F4801

Work Order No. Data Type Defined Amount Defined Date Defined Code

Work Order No. Type Priority Description Charge to Cost Center Repair Code Branch Address No’s. Dates Reference Item Number

1

Associated Service Types F13907 Item Number Message No. Service Type Threshold Separate WO (Y/N)

See Additional Tables on Next Page.

1

M

1 M

Company Item Number Parent Number Description Equip. Status s Quantity Location

1 M

M

34

Maintenance Schedules F1207

PM Projections F13411

Item Number Service Type Maint. Status Service Intervals Model WO No. Maint. Percent Complete

Item Number Service Type Forcast Type Schedule Date Estimated Hours Estimated Labor Estimated Material

1 M

Data Models

Data Type Defined Codes Defined Titles

M 1

Work Order Number Branch Description Operation Sequence Work Center Labor Rate Hours

Business Unit Frozen Standard Labor or Rate

Work Order Supplemental Data Types F48090

Labor Instructions F3112

Item Master F1201

1

1


1

M

M

1

M

Data Models

35

Plant and Equipment Maintenance (continued) Liscense Master F1206 M

1

Item Master F1201

1

Item Number License Number State License Agency Address Number License Renewal Date

Location History F1204 Item Number Location Code Loacation Effective Dates

Item Balances F1202 Fiscal Year Ledger Type 1 M Company Balance Forward Period Balances Number Item Number

1

Meter Estimates F1306 M

1

M

1

M

Parent History F1212 Item Number Parent Number Effective Dates

Supplemental Data Codes F12092

1 M

Supplemental Data Text F12093 Type Data Item Number Def’d. Code Effective Date Description

Type Data Item Number Def’d. Code Effective Date Def’d. Amt. Remarks

1 M

Specification Data F1216 Release A7.3 (June 1996)


1

M

1 M

Item Number Amount G/L Date

1

Company Item Number Parent Number Description Equip. Status s Quantity Location See Additional Tables on Next Page.

Ledger F0911

Item Number Page Number Data Item 1–16

Item Number Estimated Fuel Reading Estimated Mile Reading Estimated Hour Reading Subledger

Specification Cross Reference F1215 Category Code Value Page Number Sequence Number Description Field Number Field Type Data Item Size Display Decimals Justify Defined Code File ID Required Field


Property Management Base

Cost Center Master F0006 Building (Cost Center) Company Project

1

M

Floor Master F1506

M

1

Lease Master F1501

M

Lease Number Tenant Effective Dates Building Unit Square Footage

1

M M

1

Building Floor Unit

Building Floor

1

Unit Master F1507

1

M

Log Lines F1503 Log Class Amenity ID Quantity Dates Text

M

1

1

M

M

Recurring Billing F1502 Lease Amount Frequency Date

Tenant Billings F1511 1

M

Invoice Number Lease Amount Bill Code 1 1

1 1

s Receivable Detail F0311

s Payable Detail F0411

Invoice Number Amount G/L Offset

Voucher Number Amount G/L Offset

36

Data Models


1

Class Master F1530 EP Class Range Effective Dates

Expense Participation F15012 1

M

Lease EP Class Participation Rate Dates

Calculation Details F1538 1

M

Lease Amounts Rates Dates

1

1

M

1

Lease Master F1501 Lease Number Tenant Effective Dates Building Unit Square Footage

Tenant Billings F1511

Lease Amount Frequency Date

1

Invoice Number Lease Amount Bill Code

1

1

M


Index Code Year Month Index Value

1

Recurring Billing F1502

1

Index Master F1550

Calculation Details F1548

Escalation F15016 1

M


Lease Index Code Base Amount Effective Dates

1

M

Lease Amounts Dates

1

1

M

s Receivable Detail F0311 Invoice Number Amount G/L Offset

Data Models

37

Expense Participation and Escalation


Sales Overage and Sales Analysis s Receivable Detail F0311

Lease Master F1501

Tenant Billings F1511

Lease Number Tenant Effective Dates Building Unit Square Footage

1

Invoice Number Lease Amount Bill Code

1

1

Invoice Number Amount G/L Offset

s Payable Detail F0411 1

1 Voucher Number Amount G/L Offset

1

Sales History F1541

M

Sales Overage Master F15013

Sales Overage Detail F15014 1

M

Lease Calculation Method Frequency 1

M

Minimum/ Maximum/ Recovery F15015 Lease Min./Max/Rec.Code Amount Dates

1

M

Lease Product Year Month Amount

1

M

1

Summary Code Year Month Flexible Key Amount

1 M M M

Sales Reports F1540 Lease Product Date Amount

1

Summary Control F1544 Summary Code Summarization Flags

38

Data Models


Lease Building Unit Product Breakpoint Percentage

M

Sales Analysis F1543

Data Models


39

Data Models

Human Resource Management


Data Models



Pay Cycle Processing Address Book F0101

1

1

Address Number Name Phone Number Address

Employee Master F060116 Employee Number Social Security No. Home Company Home Business Unit Marital Status Tax Area Job Type Union Salary

1

Table Relationships 1 = 1 record M = many records 1

1

Pay/Ded/Ben Instructions F069116 Pay/Deduction/ Benefit No. Amount/Rate Calculation Parameters

M M

1

1

Time Cards F06116

M

Employee Pay Instructions F06106 Employee Number DBA Number Beg and Ending Effective Date Rate/Amount Override Code

1

M

Employee Number Pay Type Hours Rate Gross Pay Work Date G/L Union

M

1

Payroll Check Work FIle F063501

1

1 1

Employee Number Check Control No. Current Gross YTD Gross Hours Rate Tax Area M

1 M

Union Instructions F069106

M

1

M

DBA Detail Transaction F0609 Employee Number Deduction/Benefit Number Work Date Amount

1 1

M

1

1

Vertex Tax Work File F06126 Employee Number Check Control No. Check Date Gross Amount Net Amount Tax Amounts Tax Codes

Data Models

39

Union Job Type Job Step Business Unit Deduction/Benefit Number Ending Effective Date Amount/Rate

1

1

DBA Detail Transaction F0609

1

Employee Number DBA Number Work Date Amount

Time Card F06116

M 1

Vertex Tax Work File F06126 Employee Number Check Control No. Check Date Gross Amount Net Amount Tax Amounts Tax Codes

1

1

1

M

1

Transaction History F0618

1


Employee Number Check Control No. Current Gross YTD Gross Hours Rate Tax Area

M

Transaction Summary F06146

1



1

M

Employee Number DBA Number Check Date Pay Period End Date Gross Amount Hours Rate/Amount

Employee Number Transaction Type Fiscal Year Home Company Amount By Month Hour By Month Tax History Type

1 1 1

M

Payroll Check Work File F063501

DBA Detail History F0619

1

1

M

M 1 M

1


Paycheck History F06156 Check Control No. Check Number Check Date Period Ending Date Totals

Tax Ledger Detail F06166 Check Control No. Tax Type Tax Amount Company or Employee Paid

M

1

Tax Summary F06136 Employee Number Year Tax Area Tax Type Home Company Corporate Tax ID Gross Amount Excess Gross Excludable Gross Tax Amount

Data Models

40

Payroll History


Payroll Journal Entries M


1

Burden Distribution F0624

M

Burden Type Tax Type Fringe Type Burden Rate Burden AMount Hours

Employee Number DBA Number Work Date Amount

1 1

1

Employee Master F060116 Employee Number Social Security No. Home Company Home Business Unit Marital Status Tax Area Job Type Union Salary

M 1

M 1

M

1

Raw (Detail) Journal Entries F06290 Employee Number Pay/Deduction/ Benefit Code Deduction Type Gross Amount Hours G/L Period G/L Date

1

M

M

Payroll Journal Entries F06395 Document Number Explanation G/L Date G/L Period Amount Employee Number Number

M

Time Cards F06116

Document Type Document Number G/L Date Entry Line Number Posted Code Number Amount Units

1

Vertex Tax Work FIle F06126

G/L Balances F0902

Employee Number Check Control No. Check Date Gross Amount Net Amount Tax Amounts Tax Codes

Number Fiscal Year Ledger Type Period Balances Budget Amounts By Period


Data Models

41


1

M

1

1

1


Data Models

42

Canadian Pay Cycle Processing Address Book F0101

1

Address Number Name Phone Number Address

1

Employee Master F060116 Employee Number Social Insurance No. Home Company Home Business Unit Marital Status Tax Area Job Type Union 1 Salary

Pay/Ded/Ben Instructions F069116 Pay/Deduction/ Benefit No. Amount/Rate Calculation Parameters

1

1

1

1

M

1 1

M

M

Pay/Ded/Ben Instructions F06106 Employee No. Pay/Deduction Benefit Number Beg. and Ending Effective Date Rate/Amount Override Code

M


Union Job Type Job Step Business Unit Deduction/Benefit No. Beg. and Ending Effective Date Amount/Rate

Employee No. Pay Type Hours Rate M Gross Pay Work Date G/L Union

1

1

M

1

M

1

1

1

1

Union Instructions F069106

M

Time Cards F06116

Payroll Cheque Workfile F063501 Employee No. Cheque Control No. Current Gross YTD Gross Hours Rate Tax Area M

1

DBA Detail Transaction F0609 Employee No. Deduction/Benefit Number Work Date Amount

1

1

1

M


1

Vertex Tax Workfile F0712 Employee No. Cheque Control No. Cheque Date Gross Amount Net Amount Tax Amounts Tax Codes


Canadian Payroll History DBA Detail Transaction F0609

1

1

1

Employee No. Deduction/ Benefit No. Work Date Amount

Time Cards F06116

M 1

1

1

Vertex Tax Workfile F0712

1

Employee No. Cheque Control Number Cheque Date Gross Amount Net Amount Tax Amounts Tax Codes

1

Employee No. Pay Type Hours Rate Gross Pay M Work Date G/L Amount Union

1

1

Time Card History F0618 Employee No. Pay Type Hours Rate Gross Pay Work Date G/L Amount Union

Transaction Summary F06146

1

M

Employee No. Transaction Type Fiscal Year Home Company Amount By Month Hour By Month Tax History Type

1 M 1

M

1


M

Paychecque History F06156

Tax Ledger Detail F0716

Cheque Control Number Cheque Number Cheque Date Period Ending Date Totals

Cheque Control Number Tax Type Tax Amount Company or Employee Paid

M

1

Tax Summary F0713 Employee No. Year Tax Area Tax Type Home Company Corporate Tax ID Gross Amount Excess Gross Excludable Gross Tax Amount

Data Models

43

Employee No. Cheque Control Number Current Gross YTD Gross Hours Rate Tax Area

1

Employee No. Ded/Ben No. Cheque Date Pay Period End Date Gross Amount Hours Rate/Amount

1

M

Payroll Cheque Workfile F063501

M

DBA Detail History F0619

Data Models

44

Canadian Journal Entries M


1

Employee Number Deduction/Benefit Number Work Date Amount

Burden Distribution F0624

M

Burden Type Tax Type Fringe Type Burden Rate Burden Amount Hours

1 1

Employee Master F060116

1

1

Employee Number Social Ins. No. Home Company Home Business Unit Marital Status Tax Area Job Type Union Salary

M

M

1

1 M

1 1 M Release A7.3 (June 1996)

Paycheck History F06116 Employee No. Pay Type Hours Rate Gross Pay Work Date G/L Union

1

Raw (Detail) Journal Entries F06290

M

M

Employee Number Pay/Deduction/ Benefit Code Deduction Type Gross Amount Hours G/L Period G/L Date

Vertex Tax Workfile F06126 Employee No. Cheque Control No. Cheque Date Gross Amount Net Amount Tax Amounts Tax Codes

Payroll Journal Entries F06395 Document No. Explanation G/L Date G/L Period Amount Employee No. No.

1

1

Journal Entries F0911 Document Type Document No. G/L Date Entry Line No. Posted Code No. Amount Units M 1

G/L Balances F0902 Table Relationships 1 = 1 record M = many records

No. Fiscal year Ledger Type Period Balances Budget Amounts By Period


Overview


Benefits istration F08330 M

Employee No. Plan ID Option Effective Dates Enrollment Status Eligibility Date

Employee History F08042 Employee No. Data Item Historical Value Effective Date Change Reason

M

1


1

M

M

Case Number OSHA (Y/N) Employee No. Injury/Illness Rel. Establishment

1 1

1 Employee No. Social Security No. Salary Pay Frequency 1 Job Type/Step Date of Birth 1

M

1 1

1

M

M

Employee Multiple Job F060118 M

Job Specifications F08001

Employee Turnover F08045

Job Type Job Step Pay Frequency Pay Class Job Eval. Method EEO Job Cat. Benefit Group

Employee No. Data Item Turnover Data Effective Date Change Reason

Applicant Master F08401 Applicant No. Applicant Status Business Unit Position ID Job Type/Step Asking Salary Application Date

M

Position Control F08101 Fiscal Year Business Unit Position ID Full Time Equivalent Job Type/Step

Position Activity F08105 1

M Business Unit Position ID Employee No. Effective Date Emp. Action

45

Data Models

Employee Number Social Security Number Salary Pay Frequency Job Type/Step Date of Birth

Health and Safety F08601

Review Group Description Employee No. Appraisal Date New Salary Date Next Review

1


Address Book F0101

Salary & Wage istration F08201

Participants F08091

1

1

Address Number Name Date of Birth Gender Full Time Student (Y/N)

Employee Master F060116 Employee No. Social Security No. Salary Pay Frequency Job Type/Step Date of Birth 1

1

M

M

Categories by Benefit Group F08350

Benefits istration F08330

Benefit Group Rule Category

Employee No. Plan ID Option Effective Dates Enrollment Status Eligibility Date

1

1

1

Employee No. Plan ID Dep/Ben Type Effective Dates

M

M

1

M

M

401K Election Parameters F08345 M

Plan Master F08320

1

Plan ID Empl. Deduction Employer Paid Benefit Mandatory Part. Eligibility Table COBRA Plan Flexible Spending Flag

Eligibility Parameters F08392

M


Enrollment Parameters F08392 Plan ID Enrollment Status Eligibility Manual Review

Plan Options F083202 Plan ID Option Empl. Deduction Employee Paid Benefit Option Rule Add’l Amt/Rate

M

M Table ID Description M Method Minimum Amt. No. of Periods

M

Pay/Deduction/ Benefit Instruc. F06106 Employee No. Pay/Deduction/ Benefit No. Ending Effective Date Rate/Amount Override Code

M Table Relationships 1 = 1 record M = many records

401K Elections F08346 Employee No. Plan ID Effective Dates Pay/Ded Code

M

Benefit Group M Category Plan ID Effective Dates Mandatory Inclusion

Paid ID Pay/Deduction Benefit Type

M

1

M

Plans Within Categories F08351 Dep/Ben/Empl Cross Ref F08336

1

Enrollment Date Codes F08395 Eligibility Basis Days in Month Date to Follow 1st Enrollment . . 6th Enrollment

Data Models

46

Benefits istration


Employee History and Turnover

HR Constants F08040 Library for Empl. Master File HR Subsystem Name Track Employee History Track Turnover Posi. Control Edit

M

Employee Master F060116 Employee Number Social Security No. Salary Pay Frequency Job Type/Step Date of Birth

1

M

Employee History F08042

1

M M

Select Data For Tracking F08041

M

Field ID Data Item Include in History (Y/N)

M

Define Turnover Col. F08046

M

M

Employee History F08042 Employee Number Data Item Turnover Data Effective Date Change Reason

Employee Multi Job History F060119

M

Employee Number Social Security Number Salary Pay Frequency

47

Data Models

Turnover Column Number Change Reason Column Heading Table Relationships 1 = 1 record M = many records

Employee Number Social Security Number Salary Pay Frequency Job Type

M

Employee Number Data Item Historical Value Effective Date Change Reason

Employee Multi Job F060118

1

Business Unit/ Job ID Cross Reference F08005 Business Unit Job ID Benefit Group Union Code Worker Comp. Code

M 1

M

M

1

Pay Ranges F08290

M

(by Pay Class)

M



Employee No. Social Security No. Salary Pay Frequency Job Type/Step Date of Birth

Employee No. Social Security No. Salary Pay Frequency Job Type Date of Birth

M

M


1


1

M

M M

Compensable Factors F08011 Release A7.3 (June 1996)

(by Evaluation Group)

M

Supplemental Data F08092 Data Base Type Data Address Number Job ID Code Effective Date Amount/Rate Remark


Data Models

48

Job Specifications


Applicants, Requisitions, and Positions Employee Master F060116

1

1

M

M

Employee No. Social Security No. Salary M Pay Frequency Job Type/Step Date of Birth

1


1

1


1

1

M

1

Applicant Master F08401

M

Organization Charts F08xxx

M

1

Business Unit Master F0006 Address No. Company Tax Area Category Codes G/L Bank Acct. Labor Distribution Subledger Inact. 1

M

M

M

Applicant No. Applicant Status Business Unit Position ID Job Type/Step Asking Salary Application Date

Requisition Master F08102 Requisition No. Business Unit Position ID Job Type/Step Reg. Status Filled by EE# Expected Salary Approved By

M

1

1

Position Control F08101 Fiscal Year Business Unit Position ID Full Time Equivalent Job Type/Step

1

1

1 M

M

Requisition Activity F08105

M

Position Activity F08105 Business Unit Position ID Employee Number Effective Date Employee Action

M

1

1 M

Employee Multi Job File F060118

Balance File F0902 Number Fiscal Year Ledger Type Period Balances Budget Amounts by Period

Employee Number Social Security Number Salary Pay Frequency


49

Data Models

Requisition No. Application No. Dates Available

M

1



Employee No. Social Security No. Salary Pay Frequency Job Type/Step Date of Birth


M

Applicant Master F08401 Applicant No. Applicant Status Business Unit Position ID Job Type/Step Asking Salary Application Date

Requisition Master F08102

Participants Master F08091

Health and Safety F08601

Requisition No. Business Unit Position ID Job Type/Step Req. Status Filled by EE# Expected Salary Approved By

Address Number Name Date of Birth Gender Full Time Student (Y/N)

Case Number OSHA (Y/N) Employee No. Injury/Illness Rel. Establishment

M M

M

M

M M

HR Database Type of Data Code or Narrative Def. Code Code Title

1



Data Base Type Data Address Number Job ID Code Effective Date Amount/Rate Remark

M

1

M

M

Types of Data F08090

M

Supplemental Data F08092

M

M

M

M

1 M

M

Supplemental Data Narrative Info. F08093 Data Base Type of Data Address Number Job ID Def. Code Line Number Narrative Info.

Data Type Security F0080 File ID ID Database Type of Data Allow Usage (Y/N)

Data Models

50

Supplemental Data


Pay Grade Step





M

1

M

M

Paygrade Step File F082001 Pay Class Union Locality Pay Grade Effective Date


Data Models

51

Data Models

NOTES

52

A7.3 (6/96)

Data Models

NOTES

A7.3 (6/96)

53

Data Models

NOTES

54

A7.3 (6/96)

Data Models

NOTES

A7.3 (6/96)

55

Data Models

NOTES

56

A7.3 (6/96)

Data Models

NOTES

A7.3 (6/96)

57

Data Models

NOTES

58

A7.3 (6/96)

Data Models

NOTES

A7.3 (6/96)

59

Data Models

NOTES

60

A7.3 (6/96)

Data Models

NOTES NOTES

A7.3 (6/96)

61

Data Models

NOTES

62

A7.3 (6/96)

Data Models

NOTES

A7.3 (6/96)

63

Data Models

NOTES

64

A7.3 (6/96)

Data Models

NOTES

A7.3 (6/96)

65

Data Models

NOTES

66

A7.3 (6/96)

Data Models

NOTES

A7.3 (6/96)

67

Data Models

NOTES

68

A7.3 (6/96)

Jde World A7.3 Data Models Peoplebook 1d3w6p

Overview 26281t

More details 6y5l6z

Related Documents 3h463d

Jde World A7.3 Data Models Peoplebook 1d3w6p

Ppt Data Models 5t2co

Evolution Of Data Models 144rj

Jde Ini 1w2p5c

Jde-1 4k1w5y

More Documents from "Sina Bahrami" 23h10

Jde World A7.3 Data Models Peoplebook 1d3w6p

Swift Message Structure 4e2ud

Jde F0101 5oz19

Jde F0005 4wg6k

Thermal Insulation (uhde) 4w443l

4p345f