Functional Description
Purpose
This function is designed to control the retrieval of the markup information from the billing markup table (F48096). It calls appropriate other named event
rules to retrieve the markup information and passes it back to the calling program.
Setup Notes and Prerequisites
Special Logic
Technical Specification
//Variables//
evt_mnWZPercentage_PERT
evt_cWZIndependentInvoice_INDI
evt_cFoundRecordFlag_FLAG
evt_cTypeOfKey_FLAG
evt_cWQGenTypeService_GTYP
evt_cWQCapFlag_CAP
evt_mnWQRateDistribuOrBill_BRT
evt_mnWQPercentage_PERT
evt_mnWQAmountField_AA
evt_szWQComponentCostRate_CCR
evt_szWQComponentRevRate_CRVR
evt_szWQRemarkExplanation_EXR
//Retrieve the default percentages from the Constants file for revenue and invoice.
Get Billing Constants (N48S0050)
evt_cWZIndependentInvoice_INDI 'ac Independent Invoice
bf_cWDCapFlag_CAP = '0'
bf_mnWDRateDistribuOrBill_BRT ='0'
bf_mnWDPercentage_PERT = evt_mnWZPercentage_PERT
bf_mnWDAmountRevenueMarkUp_ADCR = '0'
bf_cWDCapFlagInvoice_CAPI = '0'
bf_mnWDRateInvoice_BRTI = '0'
bf_mnWDPercentageInvoice_PCIM = evt_mnWZPercentage_PERT
bf_mnWDAmountInvoiceMarkUp_ADCI ='0'
bf_szWDComponentCostRate_CCR = " "
bf_szWDComponentRevenueRate_CRVR = " "
bf_szWDComponentInvoiceRate_CINR = " "
bf_szWDNameRemarkExplanation_EXR = " "
//Set Generation Type to '1' and determine if markup table info exists by passing back a not found (0) or a
//found (1) in the record found flag.
evt_cWQGenTypeService_GTYP = '1'
Get Table Information (N48S0180)
evt_cWQGenTypeService_GTYP 'ae Generation Type Service
bf_szWDCurrencyCodeFrom_CRCD 'ae Currency Code From
bf_szWDDocumentType_DCT'ae Document Type
bf_jdWDDateTableBasis_TBDT 'ae Table Date Basis
bf_szWDSubledger_SBL 'ae Subledger
bf_cWDSubledgerType_SBLT 'ae Subledger Type
bf_szWDCategoriesWorkOrder007_WR07 'ae Work Order Class
bf_mnWDDocumentOrderInvoiceE_DOCO 'ae Contract Number
bf_mnWDParentContNumber_PCTN 'ae Parent Cont Number
bf_mnWDAddressNumberJobAr_AN8O 'ae Customer Number
bf_szWDCostCenter_MCU 'ae Business Unit
bf_szWDCategoryCodeCostCt011_RP11 'ae Job Class
bf_szWDCompany_CO 'ae Company
bf_szWDJobCategory_JBCD 'ae Job Type
bf_szWDJobStep_JBST 'ae Job Step
bf_mnWDPayDeductBenAccType_PDBA 'ae Pay Type
bf_mnWDAddressNumber_AN8 'ae Employee Number
bf_szWDCostCenterHome_HMCU 'ae Home BU
bf_szWDCategoryCodeCostCt012_RP12 'ae Cost Pool
bf_szWDClassCode0_ACL0 'ae Rate Group
bf_mnWDEquipmentNumber_NUMB 'ae Equipment Number
bf_szWDEquipmentRateCode_ERC 'ae Equipment Rate Code
bf_szWDObjectAccount_OBJ 'ae Object Account
bf_szWDSubsidiary_SUB 'ae Subsidiary
evt_cWQCapFlag_CAP 'ac Cap Flag
evt_mnWQRateDistribuOrBill_BRT 'ac Rate Field
evt_mnWQPercentage_PERT 'ac Percentage
evt_mnWQAmountField_ADCR 'ac Amount Field
evt_szWQComponentCostRate_CCR 'ac Component Cost Rate
evt_szWQComponentRevenueRate_CRVR 'ac Component Revenue Rate
evt_cFoundRecordFlag_FLAG 'ac Found Flag
evt_cTypeOfKey_FLAG 'ac Type Of Key
evt_szWQRemarkExplanation_EXR 'ac Name Remark Explanation
If evt_cFoundRecordFlag_FLAG = '1'
bf_mnWDRateDistribuOrBill_BRT = evt_mnWQRateDistribuOrBill_BRT
bf_mnWDPercentage_PERT = evt_mnWQPercentage_PERT
bf_mnWDAmountRevenueMarkUp_ADCR = evt_mnWQAmountField_AA
bf_cWDCapFlagInvoice_CAPI = evt_cWQCapFlag_CAP
bf_mnWDRateInvoice_BRTI = evt_mnWQRateDistribuOrBill_BRT
bf_mnWDPercentageInvoice_PCIM = evt_mnWQPercentage_PERT
bf_mnWDAmountInvoiceMarkUp_ADCI = evt_mnWQAmountField_AA
bf_szWDComponentCostRate_CCR = evt_szWQComponentCostRate_CCR
bf_szWDComponentRevenueRate_CRVR = evt_szWQComponentRevenueRate_CRVR
bf_szWDComponentInvoiceRate_CINR = evt_szWQComponentRevenueRate_CRVR
bf_szWDNameRemarkExplanation_EXR = evt_szWQRemarkExplanation_EXR
bf_cWDKeyTypeMarkupTableType1_TKM1 = evt_cTypeOfKey_FLAG
//If system constants file is set so that revenue and invoice amounts can differ,
//Set Generation Type to '2' and determine if markup table info exists by passing back a not found (0) or a
//found (1) in the record found flag.
If evt_cWZIndependentInvoice_INDI <> 0 (Revenue amts can differ from Invoice amts)
Get Table Information (N48S0180)
evt_cWQGenTypeService_GTYP 'ae Generation Type Service
bf_szWDCurrencyCodeFrom_CRCD 'ae Currency Code From
bf_szWDDocumentType_DCT'ae Document Type
bf_jdWDDateTableBasis_TBDT 'ae Table Date Basis
bf_szWDSubledger_SBL 'ae Subledger
bf_cWDSubledgerType_SBLT 'ae SubledgerType
bf_szWDCategoriesWorkOrder007_WR07 'ae Work Orde rClass
bf_mnWDDocumentOrderInvoiceE_DOCO 'ae Contract Number
bf_mnWDParentContNumber_PCTN 'ae Parent Cont Number
bf_mnWDAddressNumberJobAr_AN8O 'ae Customer Number
bf_szWDCostCenter_MCU 'ae Business Unit
bf_szWDCategoryCodeCostCt011_RP11 'ae Job Class
bf_szWDCompany_CO 'ae Company
bf_szWDJobCategory_JBCD 'ae Job Type
bf_szWDJobStep_JBST 'ae Job Step
bf_mnWDPayDeductBenAccType_PDBA 'ae Pay Type
bf_mnWDAddressNumber_AN8 'ae Employee Number
bf_szWDCostCenterHome_HMCU 'ae Home BU
bf_szWDCategoryCodeCostCt012_RP12 'ae Cost Pool
bf_szWDClassCode0_ACL0 'ae Rate Group
bf_mnWDEquipmentNumber_NUMB 'ae Equipment Number
bf_szWDEquipmentRateCode_ERC 'ae Equipment Rate Code
bf_szWDObjectAccount_OBJ 'ae Object Account
bf_szWDSubsidiary_SUB 'ae Subsidiary
evt_cWQCapFlag_CAP 'ac Cap Flag
evt_mnWQRateDistribuOrBill_BRT 'ac Rate Field
evt_mnWQPercentage_PERT 'ac Percentage
evt_mnWQAmountRevenueMarkUp_ADCR 'ac Amount Field
evt_szWQComponentCostRate_CCR 'ac Component Cost Rate
evt_szWQComponentRevenueRate_CRVR 'ac Component Revenue Rate
evt_cFoundRecordFlag_FLAG 'ac Found Flag
evt_cTypeOfKey_FLAG 'ac Key Type
evt_szWQRemarkExplanation_EXR 'ac Name Remark Explanation
If evt_cFoundRecordFlag = '1'
bf_mnWDRateDistribuOrBill_BRT = evt_mnWQRateDistribuOrBill_BRT
bf_mnWDPercentage_PERT = evt_mnWQPercentage_PERT
bf_mnWDAmountRevenueMarkUp_ADCR = evt_mnWQAmountField_AA
bf_szWDComponentRevenueRate_CRVR = evt_szWQComponentRevenueRate_CRVR
bf_szWDNameRemarkExplanation_EXR = evt_szWQRemarkExplanation_EXR
bf_cWDKeyTypeMarkupTableType2_TKM2 = evt_cTypeOfKey_FLAG
//Set Generation Type to '3' and determine if markup table info exists by passing back a not found (0) or a
//found (1) in the record found flag.
evt_cWQGenTypeService_GTYP = '3'
Get Table Information (N48S0180)
evt_cWQGenTypeService_GTYP 'ae Generation Type Service
bf_szWDCurrencyCodeFrom_CRCD 'ae CurrencyCode From
bf_szWDDocumentType_DCT'ae Document Type
bf_jdWDDateTableBasis_TBDT 'ae Table Dat eBasis
bf_szWDSubledger_SBL 'ae Subledger
bf_cWDSubledgerType_SBLT 'ae SubledgerType
bf_szWDCategoriesWorkOrder007_WR07 'ae WorkOrder Class
bf_mnWDDocumentOrderInvoiceE_DOCO 'ae Contract Number
bf_mnWDParentContNumber_PCTN 'ae Parent Cont Number
bf_mnWDAddressNumberJobAr_AN8O 'ae Customer Number
bf_szWDCostCenter_MCU 'ae Business Unit
bf_szWDCategoryCodeCostCt011_RP11 'ae Job Class
bf_szWDCompany_CO 'ae Company
bf_szWDJobCategory_JBCD 'ae Job Type
bf_szWDJobStep_JBST 'ae Job Step
bf_mnWDPayDeductBenAccType_PDBA 'ae Pay Type
bf_mnWDAddressNumber_AN8 'ae Employee Number
bf_szWDCostCenterHome_HMCU 'ae HomeBU
bf_szWDCategoryCodeCostCt012_RP12 'ae Cost Pool
bf_szWDClassCode0_ACL0 'ae Rate Group
bf_mnWDEquipmentNumber_NUMB 'ae Equipment Number
bf_szWDEquipmentRateCode_ERC 'ae Equipment Rate Code
bf_szWDObjectAccount_OBJ 'ae Object Account
bf_szWDSubsidiary_SUB 'ae Subsidiary
evt_cWQCapFlag_CAP 'ac Cap Flag
evt_mnWQRateDistribuOrBill_BRT 'ac Rate Field
evt_mnWQPercentage_PERT 'ac Percentage
evt_mnWQAmountRevenueMarkUp_ADCR 'ac Amount Field
evt_szWQComponentCostRate_CCR 'ac Component Cost Rate
evt_szWQComponentRevenueRate_CRVR 'ac Component Revenue Rate
evt_cFoundRecordFlag_FLAG 'ac Found Flag
evt_cTypeOfKey_FLAG 'ac TypeOfKey
evt_szWQRemarkExplanation_EXR 'ac Name Remark Explanation
If evt_cFoundRecordFlag_FLAG = '1'
bf_szWDComponentRevenueRate = evt_szWQComponentRevenueRate_CRVR
bf_szWDComponentInvoiceRate = evt_szWQComponentRevenueRate_CRVR
bf_szWDNameRemarkExplanation = evt_szWQRemarkExplanation_EXR
bf_cWDKeyTypeMarkupTableType3_TKM3 = evt_cTypeOfKey_FLAG
D48S0170 - Get Billing Markup Table
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szFileName | DL01 | char | OPT | INPUT |
A user defined name or remark. | ||||
szCurrencyCodeFrom | CRCD | char | REQ | INPUT |
A code that identifies the currency of a transaction. | ||||
szDocumentType | DCT | char | REQ | INPUT |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
jdDateTableBasis | TBDT | JDEDATE | REQ | INPUT |
This date is used as the basis for comparison to the effective dates of the various tables used by the Service Billing system. This date is
| ||||
szSubledger | SBL | char | OPT | INPUT |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | OPT | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szWorkOrderClass | WR07 | char | OPT | INPUT |
A user defined code (00/W7) that indicates the service type for the work order. | ||||
mnContractNumber | DOCO | MATH_NUMERIC | OPT | INPUT |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnParentContNumber | PCTN | MATH_NUMERIC | OPT | INPUT |
The parent contract number to which this particular contract is attached. | ||||
mnCustomerNumber | AN80 | MATH_NUMERIC | OPT | INPUT |
Everest Parent Data Item. | ||||
szBusinesUnit | MCU | char | OPT | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szJobClass | RP11 | char | OPT | INPUT |
Category code 11 associated with the Business Unit Master file (F0006). This is a user defined code (system 00, type 11) for use in flex
| ||||
szCompany | CO | char | OPT | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szJobType | JBCD | char | OPT | INPUT |
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and
| ||||
szJobStep | JBST | char | OPT | INPUT |
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job
| ||||
mnPayType | PDBA | MATH_NUMERIC | OPT | INPUT |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
mnEmployeeNumber | AN8 | MATH_NUMERIC | OPT | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szHomeBU | HMCU | char | OPT | INPUT |
The number of the business unit in which the employee generally resides. | ||||
szCostPool | RP12 | char | OPT | INPUT |
Category code 12 associated with the Business Unit Master file (F0006). This is a user defined code (00/12) for use in flex account mapping
| ||||
szRateGroup | ACL0 | char | OPT | INPUT |
A user defined code (12/CO) that groups similar items for billing. If you are an Equipment Management client and you use Equipment
| ||||
mnEquipmentNumber | NUMB | MATH_NUMERIC | OPT | INPUT |
An 8-digit number that uniquely identifies an asset. | ||||
szEquipmentRateCode | ERC | char | OPT | INPUT |
A user defined code (00/RC) that indicates a billing rate, such as DY for daily, MO for monthly, and WK for weekly. You can set up multiple
| ||||
szObjectAccount | OBJ | char | OPT | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szSubsidiary | SUB | char | OPT | INPUT |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
cCapFlag | CAP | char | OPT | OUTPUT |
This flag indicates whether the associated amount is the override rate or the cap of the rate.
Values are:
blank Override Rate.
1 Cap of
| ||||
mnRateDistribuOrBill | BRT | MATH_NUMERIC | OPT | OUTPUT |
A rate that the system uses to mark up the revenue amount reflected in the billing of professional services such as draftsmen, engineers, or
| ||||
mnPercentage | PERT | MATH_NUMERIC | OPT | OUTPUT |
The percentage that you use to mark up the revenue amount reflected in the billing of professional services workers, such as draftsmen,
| ||||
mnAmountRevenueMarkUp | ADCR | MATH_NUMERIC | OPT | OUTPUT |
An amount that the system uses to mark up the revenue amount for the billing of professional services, such as the services of draftsmen,
| ||||
cCapFlagInvoice | CAPI | char | OPT | OUTPUT |
A flag to indicate if the associated amount is the override rate or the cap of the rate. | ||||
mnRateInvoice | BRTI | MATH_NUMERIC | OPT | OUTPUT |
A rate that the system uses to mark up the invoice amount reflected in the billing of professional services workers such as draftsmen,
| ||||
mnPercentageInvoice | PCIM | MATH_NUMERIC | OPT | OUTPUT |
A number that specifies the percentage that the system uses to mark up the revenue amount reflected in the billing of professional services,
| ||||
mnAmountInvoiceMarkUp | ADCI | MATH_NUMERIC | OPT | OUTPUT |
An amount that the system uses to mark up the invoice amount for the billing of professional services, such as the services of draftsmen,
| ||||
szComponentCostRate | CCR | char | OPT | OUTPUT |
A code that identifies a component cost rate table to use for this entry in the Billing Rate / Mark up Table (F48096). The component table
| ||||
szComponentRevenueRate | CRVR | char | OPT | OUTPUT |
A code that identifies a component invoice or revenue table to use for this entry in the Billing Rate / Mark up Table (F48096). The
| ||||
szComponentInvoiceRate | CINR | char | OPT | OUTPUT |
A code that specifies the component table to use for this Billing Rate/Markup Table entry. The component table identifies the components
| ||||
cKeyTypeMarkupTableType1 | TKM1 | char | OPT | OUTPUT |
The invoice markup table used to mark up this transaction. | ||||
cKeyTypeMarkupTableType2 | TKM2 | char | OPT | OUTPUT |
The revenue markup table used to mark up the revenue side of this transaction.
If a revenue markup table is not specified, the invoice
| ||||
cKeyTypeMarkupTableType3 | TKM3 | char | OPT | OUTPUT |
The component markup table used to calculate component markup amounts for this transaction. If a specific component markup table is
| ||||
szNameRemarkExplanation | EXR | char | OPT | BOTH |
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
| ||||
cReExtendOption | RXOP | char | OPT | INPUT |
A code that specifies how the system should re-extend a transaction. You re-extend a transaction when you want to change or reapply the
| ||||
cAdHocFlag | FLAG | char | OPT | INPUT |
Contains an indicator for the operation. |
None |
None |