|
|
PBBLJOBCD FILE
REFERENCED BY
PR197 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBJ-COMPANY Numeric 4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PBJ-PROCESS-LEVEL Alpha 5
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
PBJ-JOB-CODE Alpha 9
Element: Job Code Contains a user-defined code that
represents a type of job.
PBJ-DEDUCTION-GRP Alpha 10
Element: Deduction Grp
PBJ-COST-ACCT-CAT Alpha 5
Element: Cost Acct Cat
PBJ-REV-ACCT-CAT Alpha 5
Element: Account Category
PBJ-REV-ACCOUNT Numeric 6
Element: Account This field represents the general
ledger revenue (sales) account for the
category.
PBJ-REV-SUB-ACCT Numeric 4
Element: Subaccount The general ledger revenue (sales)
subaccount for the category.
PBJ-REV-GL-CD Alpha 4
Element: Rev Gl Cd
PBJ-CALC-OPTION Alpha 1
Element: Calc Option The Calc Option field determines
whether the data mart should be
completely calculated (Essbase Calc All)
after the outline is built and the data
values have been loaded.
Valid values are:
Y = Yes; Default value.
N = No
L = Lowest
H = Highest
P = Prorate
PBBLJOBCD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PBJSET1 COMPANY PR197 PR85.1
PROCESS-LEVEL
JOB-CODE
PBBLJOBCD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pbbljobcdx PBBLJOBCDX
PBJ-COMPANY -> PBN-COMPANY
PBJ-PROCESS-LEVEL -> PBN-PROCESS-LEVEL
PBJ-JOB-CODE -> PBN-JOB-CODE
PBN-SEQUENCE-NBR
|
