|
|
PBBLJOBCD FILE
REFERENCED BY
BN66.1 PR140 PR189 PR195 PR197 PR80.1
PR85.1 PR89.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBJ-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
PBJ-PROCESS-LEVEL Alpha 5
Element: Process Level This 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
PBJ-REV-SUB-ACCT Numeric 4
Element: Subaccount
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 BN66.1 PR140
PROCESS-LEVEL PR189 PR195
JOB-CODE PR197 PR80.1
PR85.1 PR89.1
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
|
