F5108AccessExtendedJobMaster
F5108 Access Extended Job Master
Major Business Rule
Object Name: B5100001
Parent DLL: CAEC
Location: Client/Server
Language: C
Purpose
Records need to be created in the Extended Job Master, Payroll Business Unit Constants and the
Account Master tables when a Business Unit Master is successfully added in the Job Master Revisions or Job
Revisions by Company forms. The records are only added if the F5108, F069056 and F0901 tables exist.
These records also need to be deleted when the Business Unit is deleted. The following fields are
updated when the records are created in the F5108,F069056 and F0901 tables:
F5108 Table: MCU,BSFY,BSCT,BTCT, BTFY
F069056 Table: MCU, ALMH,FMRT,BDR,USER,PID, UPMJ
F0901 Table: AID, MCU, OBJ, SUB, CO, DL01, LDA, PEC, FMOD, USER, PID, JOBN, UPMJ, UPMT
The following programs need to create the Extended Job Master(F5108) if it does not exist or update
the Budget Thru Century and or Year when different than the entry GL Date:
P510121 Original Budget Entry, P510171 Job Budget Revisions, P510141 Account Master Sequences,
P510211 Progress Entry, P510842 Copy Similar Job , P51803 Recalculate Projected Final, X51013 Projection
Routine and X00COM Update Commitment Ledger. The entry programs issue error messages when the record does
not exist or the ending year is less than the entry GL Date: The record is created or updated when
the enter key is pressed.
Data Structure
D5100001 - F5108 Access Extended Job Master
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
szBusinessUnit | MCU | char | REQ | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
szCompany | CO | char | OPT | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions.
Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.
|
szProgramID | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
szDescription001 | DL01 | char | OPT | INPUT |
A user defined name or remark. |
cPostingEditCode | PEC | char | OPT | INPUT |
A code that controls G/L posting and account balance updates in the Account Master table (F0901). Valid values are:
Blank
Allows all
posting. Posts subledgers in detailed format for every account transaction. Does not require subledger entry.
B
Only allows posting to budget
ledger types starting with B or J.
I
Inactive account. No posting allowed.
L
Subledger and type are required for all transactions. Posts subledgers in
detailed format for every account. The system stores the subledger and type in the Account Ledger (F0911) and Account Balances (F0902)
tables. If you want to report on subledgers in the Financial Reporting feature, use this code.
M
Machine-generated transactions only (post
program creates offsets).
N
Non-posting. Does not allow any post or account balance updates. In the Job Cost system, you can still post budget
quantities.
S
Subledger and type are required for all transactions. Posts subledgers in summary format for every transaction. The system
stores the subledger detail in the Account Ledger table. This code is not valid for budget entry programs.
U
Unit quantities are required for all
transactions.
X
Subledger and type must be blank for all transactions. Does not allow subledger entry for the account. |
cModelAccount | FMOD | char | OPT | INPUT |
A code that indicates either a model/consolidated account or a model/consolidated business unit. Valid values are:
Blank
Non-model
business unit or account.
M
Model business unit or account.
C
Consolidated business unit or account. This is a program-generated (P10862) value
and is not user-accessible. |
cActionCode | ACTN | char | REQ | INPUT |
A code that specifies the action that is performed. Valid values are:
A
Add
C
Change
|
jdThruDate | BTDT | JDEDATE | OPT | INPUT |
This field will be used in the Recurring Billing module as part of a date-oriented billing method, as opposed to period-oriented billing. This
field will contain the latest date for which billings have been generated for the associated billing line. |
mnBudgetStartYear | BSFY | MATH_NUMERIC | OPT | OUTPUT |
The fiscal year related to either the beginning of the budget or the first G/L transaction for the job, whichever is earlier. For the year 1998, for
example, 98 is the fiscal year. When you add a job through the Job Cost system, the current year is automatically assigned to this field.
Note:
The combination of the value in this field and the value in the Budget Start Century field must be earlier in time than the combination of the
values in the Budget Thru Century and Budget Thru Fiscal Year fields.
|
mnBudgetStartCentury | BSCT | MATH_NUMERIC | OPT | OUTPUT |
The century related to either the beginning of the budget or the first G/L transaction for the job, whichever is earlier. For the year 1998, for
example, 19 is the century. When you add a job through the Job Cost system, the current century is automatically assigned.
Note: The
combination of this field and the Budget Start Fiscal Year field must be earlier than the combination of the Budget Thru Century and Budget Thru Fiscal
Year fields. |
mnBudgetThruYear | BTFY | MATH_NUMERIC | OPT | OUTPUT |
The fiscal year related to either the end of the budget or the last G/L transaction for the job, whichever is later. For the year 1998, for
example, 98 is the fiscal year. When you add a job using the Job Cost system, the current year is automatically assigned to this field.
Note: The
combination of this field and the Budget Thru Century field must be later in time than the combination of the Budget Start Century and Budget Start
Fiscal Year fields.
|
mnBudgetThruCentury | BTCT | MATH_NUMERIC | OPT | OUTPUT |
The century related to either the end of the budget or the last G/L transaction for the job, whichever is later. For example, for the year 1998,
19 is the century. When you add a job through the Job Cost system, the current century is automatically assigned to this field.
Note: The
combination of this field and the Budget Thru Fiscal Year field must be later than the combination of the Budget Start Century and Budget Start
Fiscal Year field. |
cF5108NotFound | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event.
|
szCode1 | RCS1 | char | OPT | OUTPUT |
This field specifies the characters that the system selects from the cost code of an account to create category code 1 for that account. The
system automatically creates the category codes when the account is added to the Account Master table (F0901). A cost code can be up to
eight characters, therefore, valid characters are 1-8. Use a + to specify an imbedded blank in a category code.
For example, add accounts
with the cost codes 03100, 05120, and 12100.
o If you specify 123 in this field, the system selects positions one, two, and three from the cost
codes. It creates the codes 031, 051, and 121 and assigns them to the respective accounts as category code 1.
o If you specify 2+4, the
system selects positions two and four from the cost codes and separates them with a blank. It creates the codes 3 0, 5 2, and 2 0 and assigns
them to the respective accounts.
o If you specify 678, the system selects positions six, seven, and eight from the cost codes. Because those
positions do not exist for the cost codes that were added, category code 1 is blank for those accounts.
If you do not want to use the automatic
selection feature for any category code 1, leave this field blank.
Note: This feature is also available in the processing options for Global
Update Category Codes program (R51807).
|
szCode2 | RCS2 | char | OPT | OUTPUT |
This field specifies the characters that the system selects from the cost code of an account to create category code 2 for that account. The
system automatically creates the category codes when the account is added to the Account Master table (F0901). A cost code can be up to
eight characters, therefore, valid characters are 1-8. Use a + to specify an imbedded blank in a category code.
For example, add accounts
with the cost codes 03100, 05120, and 12100:
o If you specify 123 in this field, the system selects positions one, two, and three from the cost
codes. It creates the codes 031, 051, and 121 and assigns them to the respective accounts as category code 2.
o If you specify 2+4, the
system selects positions two and four from the cost codes and separates them with a blank. It creates the codes 3 0, 5 2, and 2 0 and assigns
them to the respective accounts.
o If you specify 678, the system selects positions six, seven, and eight from the cost codes. Because those
positions do not exist for the cost codes that were added, category code 2 is blank for those accounts.
If you do not want to use the automatic
selection feature for any category code 2, leave this field blank.
Note: This feature is also available in the processing options for Global
Update Category Codes program (R51807).
|
szCode3 | RCS3 | char | OPT | OUTPUT |
This field specifies the characters that the system selects from the cost code of an account to create category code 3 for that account. The
system automatically creates the category code when the account is added to the Account Master table (F0901). A cost code can be up to
eight characters, therefore, valid characters are 1-8. Use a + to specify an imbedded blank in a category code.
For example, add accounts with
the cost codes 03100, 05120, and 12100:
o If you specify 123 in this field, the system selects positions one, two, and three from the cost
codes. It creates the codes 031, 051, and 121 and assigns them to the respective accounts as category code 3.
o If you specify 2+4, the system
selects positions two and four from the cost codes and separates them with a blank. It creates the codes 3 0, 5 2, and 2 0 and assigns them
to the respective accounts.
o If you specify 678, the system selects positions six, seven, and eight from the cost codes. Becsause those
positions do not exist for the cost codes that were added, category code 3 is blank for those accounts.
If you do not want to use the automatic
selection feature for any category code 3, leave this field blank.
Note: This feature is also available in the processing options for Global Update
Category Codes program (R51807).
|