|
|
ACPMHSTHDR FILE
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 Numeric 12 BRIP.1
Element: Obj Id 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.
PMH-COMPANY Numeric 4 BRIP.1
Element: Company 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.
PMH-CUSTOMER Alpha 9 (Right Justified) BRIP.1
Element: Customer This field contains the number that
represents a customer.
PMH-INVOICE Alpha 22 BRIP.1
Element: Invoice Used to identify the invoice.
PMH-INVOICE-PREFIX Alpha 2 BRIP.1
Element: Invoice Prefix
PMH-INVOICE-NBR Numeric 8 BRIP.1
Element: Invoice Nbr
PMH-PROCESS-LEVEL Alpha 5 BRIP.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PMH-DUE-DATE Numeric 8 (yyyymmdd) BRIP.1
Element: Date This field displays the system date
when this was created.
PMH-BILL-TO Numeric 4 BRIP.1
Element: Bill To This field contains the mailing address
for the invoice. Bill to addresses are
maintained in the Accounts Receviable
Bill To form AR09.4.
PMH-CONTRACT Alpha 15 BRIP.1
Element: Contract Activity Management contract.
PMH-CONTACT-CODE Alpha 5 BRIP.1
Element: Contact Code
PMH-AR-DETAIL Alpha 1 BRIP.1
Element: Ar Detail S = Summary
D = Detail
A = Activity
PMH-INVOICE-TYPE Alpha 1 BRIP.1
Element: Invoice Type 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
PMH-INVOICE-DATE Numeric 8 (yyyymmdd) BRIP.1
Element: Date This field displays the system date
when this was created.
PMH-POSTING-DATE Numeric 8 (yyyymmdd) BRIP.1
Element: Date This field displays the system date
when this was created.
PMH-REFERENCE Alpha 10 (Lower Case) BRIP.1
Element: Reference The reference number associated with
the transaction.
PMH-CURRENCY-CODE Alpha 5 BRIP.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PMH-CURR-ND Numeric 1 BRIP.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
PMH-INVOICE-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PMH-UNITS-AMOUNT Signed 18.2 BRIP.1
Element: Intl Amt
PMH-CUST-PO-NBR Alpha 22 BRIP.1
Element: Cust Po Nbr
PMH-INVC-OPTIONS Alpha 1 BRIP.1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-INVC-FORMAT Alpha 1 BRIP.1
Element: Invc Format S = Standard
C = Custom
F = Fax with Standard
E = EDI with Standard
PMH-RETAIN-ID Numeric 6 BRIP.1
Element: Retain Id
PMH-RETAIN-DESC Alpha 30 BRIP.1
Element: Retain Desc
PMH-CUM-FLAG Alpha 1 BRIP.1
Element: Cum Flag Y = Yes
N = No
PMH-INVC-SUMM-OPT Alpha 1 BRIP.1
Element: Invc Summ Opt D = Detail
S = Summary
PMH-INV-OPTION-2 Alpha 1 BRIP.1
Element: Invc Option 2 A = Acct Category
B = Account Category Class
C = Attribute
D = Resource
PMH-AC-CUSTOMER-ID Alpha 5 BRIP.1
Element: Ac Customer Id
PMH-WBS-INVC-NBR Numeric 8 BRIP.1
Element: Wbs Invc Nbr
PMH-CUST-NAME Alpha 30 (Lower Case)
Element: Customer Name
PMH-LOCK-BOX Alpha 2 BRIP.1
Element: Lock Box
PMH-XREF-NBR Alpha 22 BRIP.1
Element: Xref Nbr
PMH-BILL-WBS-CODE Alpha 3 BRIP.1
Element: Bill Wbs Code
PMH-EXCEED-OPTION Alpha 1 BRIP.1
Element: Exceed Option I = Include
E = Exclude
PMH-REALIZATION-FL Alpha 1 BRIP.1
Element: Realization FlY = Yes
N = No
PMH-WBS-XREF-NBR Alpha 22
Element: Wbs Xref Nbr
PMH-STATUS Numeric 1 BR123 BRIP.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 BRIP.1
Element: Line Nbr This field contains the line number.
PMH-USER-NAME Alpha 10 (Lower Case) BRIP.1
Element: User
PMH-BILL-TO-GRP Numeric 4 BRIP.1
Element: Bill To Grp Used to identify a group of AR bill-to
addresses used for customer invoicing in
the BR system.
PMH-CNT-WBS-CODE Alpha 3 BRIP.1
Element: Cnt Wbs Code
PMH-FEE-EXCEED-OPT Alpha 1 BRIP.1
Element: Fee Exceed OptI = Include
E = Exclude
PMH-PRE-ADJUST-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PMH-PRE-HOLD-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PMH-PRE-BILL-HIST Signed 18.2 BRIP.1
Element: Intl Amt
PMH-FINAL-INVC-FL Alpha 1 BRIP.1
Element: Final Invc Fl Y = Yes
N = No
PMH-PRE-BIA Signed 18.2
Element: Intl Amt
PMH-PRE-XFER Signed 18.2
Element: Intl Amt
PMH-TAX-PRINT Alpha 1 BRIP.1
Element: Tax Print M = Multiple sum by code
S = Single Tax Line
PMH-HIST-FLAG Alpha 1
Element: Hist Flag
PMH-JURIS-CODE Alpha 3 BRIP.1
Element: Juris Code
PMH-TAX-FLAG Alpha 1
Element: Tax Flag
PMH-INVC-OPTION-3 Alpha 1 BRIP.1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-INVC-OPTION-4 Alpha 1 BRIP.1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-INVC-OPTION-5 Alpha 1 BRIP.1
Element: Invc Options A = Acct Category
B = Acct Category Class
C = Attribute
D = Resource
PMH-TAX-CALC-FLAG Alpha 1 BRIP.1
Element: Tax Calc Flag 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
PMH-SERVICE-LOC Numeric 4 BRIP.1
Element: Service Loc A user defined code identifying a
customer's service location.
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 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
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
|
