|
|
PBCLIENT FILE
REFERENCED BY
AC541 AC542 BN150 BN66.1 PBFE.1 PBIP.1
PR128 PR130 PR131 PR132 PR134 PR136
PR137 PR140 PR160 PR189 PR195 PR197
PR198 PR29.1 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR37.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 PR85.1 PR89.1
UK102 UK330 UK560 TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCC-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
PCC-PROCESS-LEVEL Alpha 5
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PCC-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThis field contains the number that
represents a customer.
PCC-AR-PROCESS-LVL Alpha 5
Element: Ar Process Lvl
PCC-ACCT-UNIT Alpha 15
Element: Accounting UniThe accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
PCC-REV-ACCOUNT Numeric 6
Element: Account
PCC-REV-SUB-ACCT Numeric 4
Element: Subaccount
PCC-ACTIVITY Alpha 15
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PCC-REV-ACCT-CAT Alpha 5
Element: Account Category
PCC-BEGIN-DATE Numeric 8 (yyyymmdd)
Element: Date The beginning date in a range of dates.
PCC-END-DATE Numeric 8 (yyyymmdd)
Element: Date The ending date in a range of dates.
PCC-ACTIVE-STATUS Alpha 1
Element: Status The status of the account. If Inactive,
no posting can be done to the account.
PCC-POST-COMPANY Numeric 4
Element: Company
PCC-SEGMENT-BLOCK Alpha 103
Element: User Analysis This field identifies the user analysis
values included in the transaction.
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
PCC-CONTRACT Alpha 10
Element: Bid Name
PCC-PROCESSOR Alpha 20
Element: Processor
PCC-SALES-REP Numeric 4
Element: Sales Rep
PCC-BILL-TO Numeric 4
Element: Ship-to Code
PCC-DELIVERY-METHD Numeric 1
Element: Delivery Methd
PCC-AUTO-CHK-FL Alpha 1
Element: Auto Chk Fl
PCC-PROCESSOR-PHN Alpha 15
Element: Processor Phn
PCC-PROCESSOR-EXT Alpha 5
Element: Processor Ext
PCC-ENTITY-TYPE Alpha 1
Element: Entity Type
PCC-NAICS-CODE Alpha 6
Element: Naics Code
PCC-COST-ACCT-CAT Alpha 5
Element: Cost Acct Cat
PCC-CHCK-ACCT-CAT Alpha 5
Element: Chck Acct Cat
PCC-WK-EM-ACCT-CAT Alpha 5
Element: Wk Em Acct Cat
PCC-EM-PD-ACCT-CAT Alpha 5
Element: Em Pd Acct Cat
PCC-RESP-CODE Alpha 5
Element: Resp Code
PCC-RESP-CODE2 Alpha 5
Element: Resp Code2
PCC-DEL-MTHD Alpha 5
Element: Del Mthd
PCC-STATUS-CD Alpha 1
Element: Status Cd
PBCLIENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCCSET1 COMPANY AC541 AC542
PROCESS-LEVEL BN150 BN66.1
PBFE.1 PBIP.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR160 PR189
PR195 PR197
PR198 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
...
PCCSET2 COMPANY
AR-PROCESS-LVL
CUSTOMER
PROCESS-LEVEL
PCCSET3 POST-COMPANY
CUSTOMER
COMPANY
PROCESS-LEVEL
PBCLIENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
PCC-ACTIVITY -> ACV-ACTIVITY (ACVSET1)
Arcustomer ARCUSTOMER Required
PCC-POST-COMPANY -> ACM-COMPANY
PCC-CUSTOMER -> ACM-CUSTOMER
Glnames GLNAMES Required
PCC-POST-COMPANY -> GLN-COMPANY
PCC-ACCT-UNIT -> GLN-ACCT-UNIT
Pbbill PBBILL Required
PCC-COMPANY -> PBB-COMPANY
PCC-PROCESS-LEVEL -> PBB-PROCESS-LEVEL
Prsystem PRSYSTEM Required
PCC-COMPANY -> PRS-COMPANY
PCC-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
PBCLIENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE
PCC-COMPANY -> EMP-COMPANY
PCC-PROCESS-LEVEL -> EMP-PROCESS-LEVEL
EMP-EMPLOYEE
Pbacctasgn PBACCTASGN
PCC-COMPANY -> PBA-COMPANY
PBA-PROCESS-LEVEL
PBA-CODE-TYPE
PBA-DEDUCT-FEE-CD
Pbbldedrt PBBLDEDRT
PCC-COMPANY -> PBR-COMPANY
PCC-PROCESS-LEVEL -> PBR-PROCESS-LEVEL
PBR-DED-CODE-ORDER
Pbbldeduct PBBLDEDUCT
PCC-COMPANY -> PLD-COMPANY
PLD-EMPLOYEE
PLD-DED-CODE
PLD-EDM-SEQ-NBR
PLD-CHECK-ID
PLD-REPORT-ENTITY
PLD-BUS-NBR-GRP
PLD-QC-ENT-NBR-GRP
PLD-PROCESS-LEVEL
PLD-WORK-STATE
Pbbljobcd PBBLJOBCD
PCC-COMPANY -> PBJ-COMPANY
PCC-PROCESS-LEVEL -> PBJ-PROCESS-LEVEL
PBJ-JOB-CODE
Pbfee PBFEE
PCC-COMPANY -> PBF-COMPANY
PCC-PROCESS-LEVEL -> PBF-PROCESS-LEVEL
PBF-FEE-CODE
Pbhstdtl PBHSTDTL
PCC-COMPANY -> PBH-COMPANY
PCC-PROCESS-LEVEL -> PBH-PROCESS-LEVEL
PBH-INVOICE
PBH-LINE-NBR
Pbhsthdr PBHSTHDR
PCC-COMPANY -> PBK-COMPANY
PCC-PROCESS-LEVEL -> PBK-PROCESS-LEVEL
PBK-INVOICE
|
