EditBillableStatus

Edit Billable Status

Minor Business Rule

Object Name: N48S0080

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This NER performs the initial edits of the General Ledger records (F0911) passed in to make sure that they are eligible to be used in creating Billing
Workfile Detail records (F4812). It also checks the validity of the account and work order and returns account and work order information that will be
updated on the Billing Detail Workfile records.

Data Structure

D48S0080 - Edit Billable Status

Parameter Name Data Item Data Type Req/Opt I/O/Both

cBillCode BC char REQ INPUT

A user defined code (98/BC) that identifies the billing status for the Joint Interest Billing (JIB) system. Valid codes include:    blank Blank (the
default value) indicates transactions that are billable if a valid Division of Interest (DOI) exists for the business unit, and if the object account is
within the billable range of accounts.    N Specifies a transaction is not billable regardless of the business unit, DOI, or account range.    D
Direct charges the owner specified in the subledger field at 100%.    H Holds a billable transaction until the user wants to manually release the
transaction by changing the Bill Code.    M Manual DOI code assignment requires a valid DOI code to be input.       During JIB Cost Allocations
and Billing, this code is changed based on the processing status. G/L file purging uses this code. NOTE: Direct charges are only allowed for
entity type O (outsider).

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
types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable
documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order
documents

szReference2 R2 char REQ INPUT

A number that provides an audit trail for specific transactions, such as an asset, supplier number, or document number.

cGLPostedCode POST char REQ INPUT

A code the system uses to determine whether a transaction is available for the post process. Valid codes
are: Blank Unposted. D Posted. P Posted or posting. Depending on the type of transaction, this code has different meanings. If the code is assigned to an Account Ledger
record (F0911), it indicates a posted status. If the code is assigned to any other transaction, it indicates that the system attempted to post the
record but failed, due to an error it encountered.    M Model. The transaciton is a model journal entry.

szCostCenter MCU char REQ BOTH

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szObjectAccount OBJ char REQ INPUT

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

szSubsidiary SUB char REQ INPUT

A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.

szCompany CO char REQ INPUT

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szLedgerType LT char REQ INPUT

A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

szSubledger SBL char REQ INPUT

A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
address book number. If you enter a subledger, you must also specify the subledger type.

cSubledgerType SBLT char REQ 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
editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded
or user defined. Valid values include: A Alphanumeric field, do not edit   N Numeric field, right justify and zero fill   C Alphanumeric field, right
justify and blank fill

szCategoriesWorkOrder007 WR07 char OPT OUTPUT

A user defined code (00/W7) that indicates the service type for the work order.

szCategoriesWorkOrder001 WR01 char OPT OUTPUT

A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only
one phase code at a time. Note: Certain forms contain a processing option that allows you to enter a default value for this field. If you enter a
default value on a form for which you have set this processing option, the system displays the value in the appropriate fields on any work
orders that you create. The system also displays the value on the Project Setup form. You can either accept or override the default value.

szTaxArea TXA1 char OPT OUTPUT

A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher.

mnCustomerNumber AN8 MATH_NUMERIC OPT OUTPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

szCategoryCodeGl001 R001 char OPT OUTPUT

Category code 1 associated with the Account Master table (F0901). This is a user defined code (09/01) for use in flex account mapping and
in printing selected information on reports.

szCategoryCodeGl002 R002 char OPT OUTPUT

Category code 2 associated with the Account Master table (F0901). This is a user defined code (09/02) for use in flex account mapping and
in printing selected account information on reports.

szCategoryCodeGl003 R003 char OPT OUTPUT

Category code 3 associated with the Account Master table (F0901). The system uses this user defined code (09/03) in mapping flexible
account numbers and printing selected account information on reports.

cBillableYN BILL char OPT OUTPUT

Specifies whether a general ledger account should be billed. Valid codes are:    Y Yes, the account should be billed.    N No, it should not be
billed.    1   It is eligible only for invoicing.    2   It is eligible only for revenue recognition.    4   It is eligible only for cost. Note: Codes 1, 2, and 4
relate only to the Service Billing system.

cErrorDisplayFlag EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

szGMErrorMessageID DTAI char OPT OUTPUT

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cPostingEditCostCenter PECC char OPT OUTPUT

A code that specifies whether to allow transactions to post to the general ledger for the job (business unit). Valid values are: Blank Allow
transactions to post to this business unit. K Allow transactions to post to this business unit. However, the original budget is locked, and change
orders are required for making changes to the budget. N Do not allow transactions to post to this business unit. Use this code for a job that is not
started or is closed. P Do not allow transactions to post to this business unit. The job can be purged.

szTaxExplanationCode EXR1 char OPT OUTPUT

A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each
transaction pay item can be defined with a different tax explanation code.

szWAErrorMessageID DTAI char OPT OUTPUT

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

szAccountId AID char OPT OUTPUT

A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.

szSubsidiaryAlternate SUBA char OPT OUTPUT

An alternate subsidiary account that allows you to comply with a regulatory chart of accounts, parent company requirements, or third party
coding scheme.

szErrorMessageID DTAI char OPT OUTPUT

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cAdhocFlag EV01 char OPT INPUT

An option that specifies the type of processing for an event.

szParentWONo_PARS PARS char OPT OUTPUT

A number that identifies the parent work order. You can use this number to do the following:     o Enter default values for new work orders,
such as Type, Priority, Status, and Manager     o Group work orders for project setup and reporting

szLeaseNumber RORN char OPT NONE

A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
informational purposes only.

szOriginalDocumentType RCTO char OPT NONE

A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
order might be document type OP and might have been created to fill a related work order with document type WO.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cBillCode	BC	char	REQ	INPUT
A user defined code (98/BC) that identifies the billing status for the Joint Interest Billing (JIB) system. Valid codes include: blank Blank (the default value) indicates transactions that are billable if a valid Division of Interest (DOI) exists for the business unit, and if the object account is within the billable range of accounts. N Specifies a transaction is not billable regardless of the business unit, DOI, or account range. D Direct charges the owner specified in the subledger field at 100%. H Holds a billable transaction until the user wants to manually release the transaction by changing the Bill Code. M Manual DOI code assignment requires a valid DOI code to be input. During JIB Cost Allocations and Billing, this code is changed based on the processing status. G/L file purging uses this code. NOTE: Direct charges are only allowed for entity type O (outsider).
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 types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order documents
szReference2	R2	char	REQ	INPUT
A number that provides an audit trail for specific transactions, such as an asset, supplier number, or document number.
cGLPostedCode	POST	char	REQ	INPUT
A code the system uses to determine whether a transaction is available for the post process. Valid codes are: Blank Unposted. D Posted. P Posted or posting. Depending on the type of transaction, this code has different meanings. If the code is assigned to an Account Ledger record (F0911), it indicates a posted status. If the code is assigned to any other transaction, it indicates that the system attempted to post the record but failed, due to an error it encountered. M Model. The transaciton is a model journal entry.
szCostCenter	MCU	char	REQ	BOTH
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szObjectAccount	OBJ	char	REQ	INPUT
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
szSubsidiary	SUB	char	REQ	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCompany	CO	char	REQ	INPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szLedgerType	LT	char	REQ	INPUT
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
szSubledger	SBL	char	REQ	INPUT
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
cSubledgerType	SBLT	char	REQ	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 editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
szCategoriesWorkOrder007	WR07	char	OPT	OUTPUT
A user defined code (00/W7) that indicates the service type for the work order.
szCategoriesWorkOrder001	WR01	char	OPT	OUTPUT
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only one phase code at a time. Note: Certain forms contain a processing option that allows you to enter a default value for this field. If you enter a default value on a form for which you have set this processing option, the system displays the value in the appropriate fields on any work orders that you create. The system also displays the value on the Project Setup form. You can either accept or override the default value.
szTaxArea	TXA1	char	OPT	OUTPUT
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax and G/L distribution amounts when you create an invoice or voucher.
mnCustomerNumber	AN8	MATH_NUMERIC	OPT	OUTPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szCategoryCodeGl001	R001	char	OPT	OUTPUT
Category code 1 associated with the Account Master table (F0901). This is a user defined code (09/01) for use in flex account mapping and in printing selected information on reports.
szCategoryCodeGl002	R002	char	OPT	OUTPUT
Category code 2 associated with the Account Master table (F0901). This is a user defined code (09/02) for use in flex account mapping and in printing selected account information on reports.
szCategoryCodeGl003	R003	char	OPT	OUTPUT
Category code 3 associated with the Account Master table (F0901). The system uses this user defined code (09/03) in mapping flexible account numbers and printing selected account information on reports.
cBillableYN	BILL	char	OPT	OUTPUT
Specifies whether a general ledger account should be billed. Valid codes are: Y Yes, the account should be billed. N No, it should not be billed. 1 It is eligible only for invoicing. 2 It is eligible only for revenue recognition. 4 It is eligible only for cost. Note: Codes 1, 2, and 4 relate only to the Service Billing system.
cErrorDisplayFlag	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
szGMErrorMessageID	DTAI	char	OPT	OUTPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cPostingEditCostCenter	PECC	char	OPT	OUTPUT
A code that specifies whether to allow transactions to post to the general ledger for the job (business unit). Valid values are: Blank Allow transactions to post to this business unit. K Allow transactions to post to this business unit. However, the original budget is locked, and change orders are required for making changes to the budget. N Do not allow transactions to post to this business unit. Use this code for a job that is not started or is closed. P Do not allow transactions to post to this business unit. The job can be purged.
szTaxExplanationCode	EXR1	char	OPT	OUTPUT
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each transaction pay item can be defined with a different tax explanation code.
szWAErrorMessageID	DTAI	char	OPT	OUTPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szAccountId	AID	char	OPT	OUTPUT
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
szSubsidiaryAlternate	SUBA	char	OPT	OUTPUT
An alternate subsidiary account that allows you to comply with a regulatory chart of accounts, parent company requirements, or third party coding scheme.
szErrorMessageID	DTAI	char	OPT	OUTPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cAdhocFlag	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szParentWONo_PARS	PARS	char	OPT	OUTPUT
A number that identifies the parent work order. You can use this number to do the following: o Enter default values for new work orders, such as Type, Priority, Status, and Manager o Group work orders for project setup and reporting
szLeaseNumber	RORN	char	OPT	NONE
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for informational purposes only.
szOriginalDocumentType	RCTO	char	OPT	NONE
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase order might be document type OP and might have been created to fill a related work order with document type WO.