|
|
ACPMHSTHDR FILE
The ACPMHSTHDR file contains product and maintenance invoice header
information. The Product Invoicing (BR151) program updates the data in this
file. This file has relationships with many files, including ACCNTRACT,
ACPRMSTNX, ACMNTSCH, ACSRVCLOC, ACPMHSTCSL, ACPMHSTDTL, ARCUSTOMER, AROIHDR M,
AROIHDR C, AROIHDR D, AROIHDR I, ARPROCLEVL, BILLTO, ARCONTACTS, and CUSTDESC.
REFERENCED BY
BR157 BR252 BR52.1 BR56.1 BR55.1
UPDATED BY
BR123 BRPI.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMH-OBJ-ID Numeric 12 BRPI.1
Object This is the object identifier. It is
Identification 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.
PMH-COMPANY Numeric 4 BRPI.1
Element: Company The company number represents an
established company and is entered on
all function codes.
PMH-CUSTOMER Alpha 9 (Right Justified) BRPI.1
Element: Customer NumbeThis field contains the number that
represents a customer.
PMH-INVOICE Alpha 22 BRPI.1
Element: Invoice NumberUsed to identify the invoice.
PMH-INVOICE-PREFIX Alpha 2 BRPI.1
Element: Invoice Prefix
PMH-INVOICE-NBR Numeric 8 BRPI.1
Element: Invoice Nbr
PMH-PROCESS-LEVEL Alpha 5 BRPI.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PMH-DUE-DATE Numeric 8 (yyyymmdd) BRPI.1
Element: Date The transaction due date.
PMH-BILL-TO Numeric 4 BRPI.1
Element: Bill To
PMH-CONTRACT Alpha 10 BRPI.1
Element: Contract
PMH-CONTACT-CODE Alpha 5 BRPI.1
Element: Contact Code
PMH-AR-DETAIL Alpha 1 BRPI.1
Element: Ar Detail S = Summary
D = Detail
A = Activity
PMH-INVOICE-TYPE Alpha 1 BRPI.1
Element: Invoice Type R = Retainer
I = Invoice
B = Invoice Cancel
C = Auto generated retainer credit
T = Tax
P = Product
M = Maintenance
PMH-INVOICE-DATE Numeric 8 (yyyymmdd) BRPI.1
Element: Date
PMH-POSTING-DATE Numeric 8 (yyyymmdd) BRPI.1
Element: Date
PMH-REFERENCE Alpha 10 (Lower Case) BRPI.1
Element: Reference The reference number associated with
the transaction.
PMH-CURRENCY-CODE Alpha 5 BRPI.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PMH-CURR-ND Numeric 1 BRPI.1
Account Currency
Code
PMH-INVOICE-AMT Signed 15.2 BRPI.1
Element: Adj Amt
PMH-UNITS-AMOUNT Signed 15.2
Element: Units Amount This is the units amount included in
the file.
PMH-CUST-PO-NBR Alpha 22 BRPI.1
Element: Customer P.O. Number
PMH-INVC-OPTIONS Alpha 1 BRPI.1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-INVC-FORMAT Alpha 1 BRPI.1
Element: Invc Format S = Standard
C = Custom
F = Fax with standard
E = EDI with standard
PMH-RETAIN-ID Numeric 6
Element: Retain Id
PMH-RETAIN-DESC Alpha 30
Element: Retain Desc
PMH-CUM-FLAG Alpha 1 BRPI.1
Element: Cum Flag Y = Yes
N = No
PMH-INVC-SUMM-OPT Alpha 1 BRPI.1
Element: Invc Summ Opt D = Detail
S = Summary
PMH-INV-OPTION-2 Alpha 1 BRPI.1
Element: Invc Option 2 A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-AC-CUSTOMER-ID Alpha 5 BRPI.1
Element: Ac Customer Id
PMH-WBS-INVC-NBR Numeric 8 BRPI.1
Element: Wbs Invc Nbr
PMH-CUST-NAME Alpha 30 (Lower Case)
Element: Customer Name
PMH-LOCK-BOX Alpha 2
Element: Lock Box
PMH-XREF-NBR Alpha 22 BR123 BRPI.1
Element: Xref Nbr
PMH-BILL-WBS-CODE Alpha 3 BRPI.1
Element: Bill Wbs Code
PMH-EXCEED-OPTION Alpha 1
Element: Exceed Option I = Include
E = Exclude
PMH-REALIZATION-FL Alpha 1 BR123 BRPI.1
Element: Realization FlY = Yes
N = No
PMH-WBS-XREF-NBR Alpha 22 BRPI.1
Element: Wbs Xref Nbr
PMH-STATUS Numeric 1 BR123 BRPI.1
Element: Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
2 = Pending Approval
3 = Processed
4 = Cancelled
5 = Invoice Delete
PMH-LAST-LINE-NBR Numeric 6
Element: Line Number
PMH-USER-NAME Alpha 10 (Lower Case) BRPI.1
Element: User
PMH-BILL-TO-GRP Numeric 4
Element: Bill To Grp
PMH-CNT-WBS-CODE Alpha 3
Element: Cnt Wbs Code
PMH-FEE-EXCEED-OPT Alpha 1
Element: Fee Exceed OptI = Include
E = Exclude
PMH-PRE-ADJUST-AMT Signed 15.2
Element: Adj Amt
PMH-PRE-HOLD-AMT Signed 15.2
Element: Adj Amt
PMH-PRE-BILL-HIST Signed 15.2
Element: Adj Amt
PMH-FINAL-INVC-FL Alpha 1
Element: Final Invc Fl Y = Yes
N = No
PMH-PRE-BIA Signed 15.2
Element: Adj Amt
PMH-PRE-XFER Signed 15.2
Element: Adj Amt
PMH-TAX-PRINT Alpha 1
Element: Tax Print M = Multiple sum by code
S = Single tax line
PMH-HIST-FLAG Alpha 1 BRPI.1
Element: Hist Flag
PMH-JURIS-CODE Alpha 3
Element: Juris Code
PMH-TAX-FLAG Alpha 1
Element: Tax Flag
PMH-INVC-OPTION-3 Alpha 1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-INVC-OPTION-4 Alpha 1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-INVC-OPTION-5 Alpha 1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-TAX-CALC-FLAG Alpha 1
Element: Tax Calc Flag 1 = Detail
2 = Summary
PMH-SERVICE-LOC Numeric 4 BRPI.1
Element: Service Loc
ACPMHSTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMHSET1 OBJ-ID BR123 BR157
BR252 BR52.1
BR56.1 BRPI.1
PMHSET2 CONTRACT KeyChange BR55.1
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE
OBJ-ID
PMHSET3 INVOICE-PREFIXKeyChange
INVOICE-NBR
OBJ-ID
ACPMHSTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
