ACPMHSTHDR

REFERENCED BY
BR157 BR252 BR52.1 BR56.1 BR55.1


UPDATED BY
BR123 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMH-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
BRIP.1
PMH-COMPANY
Element: Company
Numeric 4
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.
BRIP.1
PMH-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
BRIP.1
PMH-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
BRIP.1
PMH-INVOICE-PREFIX
Element: Invoice Prefix
Alpha 2
BRIP.1
PMH-INVOICE-NBR
Element: Invoice Nbr
Numeric 8
BRIP.1
PMH-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
BRIP.1
PMH-DUE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BRIP.1
PMH-BILL-TO
Element: Bill To
Numeric 4
This field contains the mailing address for the invoice. Bill to addresses are maintained in the Accounts Receviable Bill To form AR09.4.
BRIP.1
PMH-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BRIP.1
PMH-CONTACT-CODE
Element: Contact Code
Alpha 5
BRIP.1
PMH-AR-DETAIL
Element: Ar Detail
Alpha 1

S = Summary
D = Detail
A = Activity
BRIP.1
PMH-INVOICE-TYPE
Element: Invoice Type
Alpha 1
THis field will be filled in from the Invoice based on PO number. This is a carrier for the field. The PORECEIVE file will have to be updated with this field.
R = Retainer
I = Invoice
B = Invoice Cancel
C = Auto generated retainer credit
T = Tax
P = Product
M = Maintenance
BRIP.1
PMH-INVOICE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BRIP.1
PMH-POSTING-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BRIP.1
PMH-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
BRIP.1
PMH-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BRIP.1
PMH-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BRIP.1
PMH-INVOICE-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PMH-UNITS-AMOUNT
Element: Intl Amt
Signed 18.2
BRIP.1
PMH-CUST-PO-NBR
Element: Cust Po Nbr
Alpha 22
BRIP.1
PMH-INVC-OPTIONS
Element: Invc Options
Alpha 1

A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
BRIP.1
PMH-INVC-FORMAT
Element: Invc Format
Alpha 1

S = Standard
C = Custom
F = Fax with Standard
E = EDI with Standard
BRIP.1
PMH-RETAIN-ID
Element: Retain Id
Numeric 6
BRIP.1
PMH-RETAIN-DESC
Element: Retain Desc
Alpha 30
BRIP.1
PMH-CUM-FLAG
Element: Cum Flag
Alpha 1

Y = Yes
N = No
BRIP.1
PMH-INVC-SUMM-OPT
Element: Invc Summ Opt
Alpha 1

D = Detail
S = Summary
BRIP.1
PMH-INV-OPTION-2
Element: Invc Option 2
Alpha 1

A = Acct Category
B = Account Category Class
C = Attribute
D = Resource
BRIP.1
PMH-AC-CUSTOMER-ID
Element: Ac Customer Id
Alpha 5
BRIP.1
PMH-WBS-INVC-NBR
Element: Wbs Invc Nbr
Numeric 8
BRIP.1
PMH-CUST-NAME
Element: Customer Name
Alpha 30 (Lower Case)
PMH-LOCK-BOX
Element: Lock Box
Alpha 2
BRIP.1
PMH-XREF-NBR
Element: Xref Nbr
Alpha 22
BRIP.1
PMH-BILL-WBS-CODE
Element: Bill Wbs Code
Alpha 3
BRIP.1
PMH-EXCEED-OPTION
Element: Exceed Option
Alpha 1

I = Include
E = Exclude
BRIP.1
PMH-REALIZATION-FL
Element: Realization Fl
Alpha 1

Y = Yes
N = No
BRIP.1
PMH-WBS-XREF-NBR
Element: Wbs Xref Nbr
Alpha 22
PMH-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Released
2 = Pending Approval
3 = Processed
4 = Cancelled
5 = Invoice Delete
BR123 BRIP.1
PMH-LAST-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
BRIP.1
PMH-USER-NAME
Element: User
Alpha 10 (Lower Case)
BRIP.1
PMH-BILL-TO-GRP
Element: Bill To Grp
Numeric 4
Used to identify a group of AR bill-to addresses used for customer invoicing in the BR system.
BRIP.1
PMH-CNT-WBS-CODE
Element: Cnt Wbs Code
Alpha 3
BRIP.1
PMH-FEE-EXCEED-OPT
Element: Fee Exceed Opt
Alpha 1

I = Include
E = Exclude
BRIP.1
PMH-PRE-ADJUST-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PMH-PRE-HOLD-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PMH-PRE-BILL-HIST
Element: Intl Amt
Signed 18.2
BRIP.1
PMH-FINAL-INVC-FL
Element: Final Invc Fl
Alpha 1

Y = Yes
N = No
BRIP.1
PMH-PRE-BIA
Element: Intl Amt
Signed 18.2
PMH-PRE-XFER
Element: Intl Amt
Signed 18.2
PMH-TAX-PRINT
Element: Tax Print
Alpha 1

M = Multiple sum by code
S = Single Tax Line
BRIP.1
PMH-HIST-FLAG
Element: Hist Flag
Alpha 1
PMH-JURIS-CODE
Element: Juris Code
Alpha 3
BRIP.1
PMH-TAX-FLAG
Element: Tax Flag
Alpha 1
PMH-INVC-OPTION-3
Element: Invc Options
Alpha 1

A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
BRIP.1
PMH-INVC-OPTION-4
Element: Invc Options
Alpha 1

A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
BRIP.1
PMH-INVC-OPTION-5
Element: Invc Options
Alpha 1

A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
BRIP.1
PMH-TAX-CALC-FLAG
Element: Tax Calc Flag
Alpha 1
This flag determines whether tax will be calculated at a detail level or summary level. If calculated at a detail level, tax amounts will be calculated separately for each invoice line. If calculated at a summary level, taxable amount for a tax code for the whole invoice will be determined, and tax will be calculated on that summarized taxable amount.
1 = Detail
2 = Summary
BRIP.1
PMH-SERVICE-LOC
Element: Service Loc
Numeric 4
A user defined code identifying a customer's service location.
BRIP.1


ACPMHSTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMHSET1 OBJ-ID
BR123 BR157
BR252 BR52.1
BR56.1 BRIP.1
PMHSET2 CONTRACT
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE
OBJ-ID
KeyChange
BR55.1
PMHSET3 INVOICE-PREFIX
INVOICE-NBR
OBJ-ID
KeyChange


ACPMHSTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Not Required
PMH-CONTRACT->CNT-CONTRACT (CNTSET1)
Acsrvcloc ACSRVCLOC Not Required
PMH-COMPANY->ASV-COMPANY
PMH-CUSTOMER->ASV-CUSTOMER
PMH-SERVICE-LOC->ASV-SERVICE-LOC
Arcomp ARCOMP Not Required
PMH-COMPANY->ACO-COMPANY
Arcontacts ARCONTACTS Not Required
PMH-COMPANY->CON-COMPANY
PMH-CUSTOMER->CON-CUSTOMER
PMH-CONTACT-CODE->CON-RESP-CODE
Arcustomer ARCUSTOMER Not Required
PMH-COMPANY->ACM-COMPANY
PMH-CUSTOMER->ACM-CUSTOMER
Aroihdr C AROIHDR Not Required
PMH-COMPANY->ARH-COMPANY
"C"->ARH-TRANS-TYPE
PMH-INVOICE->ARH-INVOICE
Aroihdr D AROIHDR Not Required
PMH-COMPANY->ARH-COMPANY
"D"->ARH-TRANS-TYPE
PMH-INVOICE->ARH-INVOICE
Aroihdr I AROIHDR Not Required
PMH-COMPANY->ARH-COMPANY
"I"->ARH-TRANS-TYPE
PMH-INVOICE->ARH-INVOICE
Aroihdr M AROIHDR Not Required
PMH-COMPANY->ARH-COMPANY
"M"->ARH-TRANS-TYPE
PMH-INVOICE->ARH-INVOICE
Arproclevl ARPROCLEVL Not Required
PMH-COMPANY->APV-COMPANY
PMH-PROCESS-LEVEL->APV-PROCESS-LEVEL
Billto BILLTO Not Required
ACO-CUST-GROUP->ABS-CUST-GROUP
PMH-CUSTOMER->ABS-CUSTOMER
PMH-BILL-TO->ABS-BILL-TO
Custdesc CUSTDESC Not Required
ACO-CUST-GROUP->CUD-CUST-GROUP
PMH-CUSTOMER->CUD-CUSTOMER


ACPMHSTHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acinvaudit ACINVAUDIT
PMH-OBJ-ID->IVA-OBJ-ID
  IVA-LINE-NBR
  IVA-TRANS-DATE
  IVA-SEQUENCE-NBR
Acmntsch ACMNTSCH
PMH-OBJ-ID->MSC-PMH-OBJ-ID
  MSC-CONTRACT
  MSC-MAINT-SCHEDULE
  MSC-PRODUCT
  MSC-PROD-VERSION
  MSC-OBJ-ID
Acpmhstcsl ACPMHSTCSL
PMH-OBJ-ID->PMC-OBJ-ID
  PMC-LINE-NBR
Acpmhstdtl ACPMHSTDTL
PMH-OBJ-ID->PML-OBJ-ID
  PML-LINE-NBR
Acprmstnx ACPRMSTNX
PMH-OBJ-ID->PMX-PMH-OBJ-ID
  PMX-ACTIVITY
  PMX-MILESTONE-CAT
  PMX-MILESTONE


File created: Thu Jun 09 02:11:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.