PBBLJOBCD FILE
REFERENCED BY
PR197 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBJ-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
PBJ-PROCESS-LEVEL Alpha 5
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PBJ-JOB-CODE Alpha 9
Job Code Contains a user-defined code that
represents a type of job.
PBJ-DEDUCTION-GRP Alpha 10
Deduction Grp
PBJ-COST-ACCT-CAT Alpha 5
Cost Acct Cat
PBJ-REV-ACCT-CAT Alpha 5
Rev Acct Cat
PBJ-REV-ACCOUNT Numeric 6
Rev Account This field represents the general
ledger revenue (sales) account for the
category.
PBJ-REV-SUB-ACCT Numeric 4
Rev Sub Acct The general ledger revenue (sales)
subaccount for the category.
PBJ-REV-GL-CD Alpha 4
Rev Gl Cd
PBJ-CALC-OPTION Alpha 1
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
|
