PJB_PROCESS_GT
Global temporary table used during invoice and revenue generation
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BILL_TRX_ID | NUMBER | 18 | Unique identifier of the bill transaction ***** | ||
| CONTRACT_ID | NUMBER | 18 | Identifier of the contract ***** | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Identifier of the contract line ***** | ||
| TP_RULE_PERCENTAGE | NUMBER | Tranfer Price Rule Percentage ***** | |||
| TP_SCH_LINE_PERCENTAGE | NUMBER | Transfer Price Schedule Line Percentage ***** | |||
| CONTRACT_CONTRIBUTION_PCT | NUMBER | Percentage of funding contribution for this transaction by the contract ***** | |||
| CONTRACT_PROJECT_LINKAGE_ID | NUMBER | 18 | Identifier of the contract project association ***** | ||
| LINKED_PROJECT_ID | NUMBER | 18 | Identifier of the project linked to the contract line ***** | ||
| LINKED_TASK_ID | NUMBER | 18 | Identifier of the project linked to the contract line ***** | ||
| MANUAL_FLAG | VARCHAR2 | 1 | Indicator if this distribution is create manually ***** | ||
| BILL_PLAN_ID | NUMBER | 18 | Identifier of the bill plan ***** | ||
| REVENUE_PLAN_ID | NUMBER | 18 | Identifier of the revenue plan ***** | ||
| RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the billing resource based on billing resource list defined at BU Level ***** | ||
| TRANSACTION_ID | NUMBER | 18 | Expenditure Item ID or Event ID ***** | ||
| BILL_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Indicates if this transaction is Expenditure Item or Event ***** | ||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Expenditure Type Id or Event Type Id ***** | ||
| TRANSACTION_DATE | DATE | Expenditure item date or event completion date ***** | |||
| TRANSACTION_PROJECT_ID | NUMBER | 18 | Identifier of the project that is associated with this transaction ***** | ||
| TRANSACTION_TASK_ID | NUMBER | 18 | Identifier of the task that is associated with this transaction ***** | ||
| TRANSACTION_BILLED_PERCENT | NUMBER | Total Billed percent on the Expenditure Item or Event ***** | |||
| BILLED_RECOGZD_PERCENTAGE | NUMBER | Percentage billed or Recognized by this bill transaction on the Expenditure item or Event ***** | |||
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 10 | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type ***** | ||
| SYSTEM_LINK_FUNC_NUM | NUMBER | 18 | System Linkage Number assigned to the system linkage function. ***** | ||
| INCURRED_ORGANIZATION_ID | NUMBER | The identifier of the organization that incurred the charges ***** | |||
| NON_LABOR_RESOURCE_ID | NUMBER | Identifier of the non-labor resource utilized as the work was performed ***** | |||
| NON_LABOR_RESOURCE | VARCHAR2 | 30 | The non-labor resource utilized as the work was performed ***** | ||
| NON_LABOR_ORG_ID | NUMBER | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. ***** | |||
| PERSON_ID | NUMBER | The identifier of the employee who incurred the charges ***** | |||
| QUANTITY | NUMBER | Quantity as obtained from the transaction. | |||
| ADJUSTED_RATE | NUMBER | The discounted rate of the item based on the bill rate schedule rate and discount ***** | |||
| RAW_COST | NUMBER | Raw Cost ***** | |||
| BURDEN_COST | NUMBER | Burden Cost ***** | |||
| DENOM_CURRENCY_CODE | VARCHAR2 | 30 | Transaction Currency Code ***** | ||
| DENOM_RAW_COST | NUMBER | The total raw cost of the expenditure item in transaction currency ***** | |||
| DENOM_BURDEN_COST | NUMBER | Total burdened cost of the expenditure item in transaction currency ***** | |||
| BILL_RATE | NUMBER | The bill rate for the expenditure item ***** | |||
| BILL_EMPLOYEE_BILLING_TITLE | VARCHAR2 | 80 | The effective employee billing title for the labor expenditure item ***** | ||
| BILL_JOB_BILLING_TITLE | VARCHAR2 | 80 | The effective job billing title for the labor expenditure item ***** | ||
| BILL_JOB_ID | NUMBER | 18 | The identifier of the effective job used when invoicing a labor item ***** | ||
| AMOUNT_CALC_CODE | VARCHAR2 | 30 | Audit Column for rate derivation. Valid values are Indirect(I), Overrides(O), Extension (E), Bill rates (B) , Labor Multiplier (L) ***** | ||
| RATE_SOURCE_ID | NUMBER | 18 | Audit Column for bill rate derivation. It stores the rate schedule id of bill rate schedule was used, override id if override used ***** | ||
| DENORM_RATE_ID | NUMBER | 18 | Audit Column for bill rate derivation. It stores the denorm rate override id ***** | ||
| BURDEN_COMPILED_SET_ID | NUMBER | 18 | The identifier of the compiled set that is used to calculate the billing or revenue amount of the expenditure item ***** | ||
| DISCOUNT_REASON_CODE | VARCHAR2 | 30 | Reason code for discount override or rate override ***** | ||
| DISCOUNT_PERCENTAGE | NUMBER | Discount Percentage is used to calculate the adjusted rate ***** | |||
| LABOR_MULTIPLIER | NUMBER | Audit Column for rate derivation ***** | |||
| MARKUP_PERCENTAGE | NUMBER | Audit Column for bill rate derivation. Markup Percentage used in derving bill rate was based on a markup in bill rate schedule ***** | |||
| REJECTION_REASON_CODE | VARCHAR2 | 30 | Invoice or Revenue generation rejection reason code ***** | ||
| WARNING_MSG_CODE | VARCHAR2 | 30 | Invoice or Revenue generation warning message code ***** | ||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 30 | Contract Currency Code ***** | ||
| CONT_CURR_RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type used for converting amounts to contract currency during Invoice/Revenue generation. ***** | ||
| CONT_CURR_EXCHG_DATE | DATE | Currency conversion exchage date used for converting amounts to contract currency during Invoice/Revenue generation. ***** | |||
| CONT_CURR_EXCHG_RATE | NUMBER | Currency conversion exchange rate used for converting amounts to contract currency during Invoice/Revenue generation. ***** | |||
| CONT_CURR_TXN_AMT | NUMBER | Transaction Amount in Contract Currency ***** | |||
| CONT_CURR_ELIGIBLE_AMT | NUMBER | Eligible amount in contract currency to do the fund check based on contract contribution percentage and percentage to be billed on the expenditure item or event ***** | |||
| CONT_CURR_QUALIFIED_AMT | NUMBER | Qualified amount in contract currency after fund check ***** | |||
| CONT_CURR_BILLED_AMT | NUMBER | Total Billed Amount in Contract Currency ***** | |||
| TRNS_CURRENCY_CODE | VARCHAR2 | 30 | Transaction Currency Code ***** | ||
| TRNS_CURR_TXN_AMT | NUMBER | Transaction amount in transaction currency ***** | |||
| TRNS_CURR_ELIGIBLE_AMT | NUMBER | Eligible amount in transaction currency to do the fund check based on contract contribution percentage and percentage to be billed on the expenditure item or event ***** | |||
| TRNS_CURR_QUALIFIED_AMT | NUMBER | Qualified amount in transaction currency after fund check ***** | |||
| INVOICE_DATE | DATE | Invoice Date will be used to convert Project and Ledger currency amounts during IDL creation ***** | |||
| REVENUE_DATE | DATE | Revenue Date will be used to convert Project and Ledger currency amounts during IDL creation ***** | |||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Transaction Accum Header ID ***** | ||
| PA_PERIOD | VARCHAR2 | 30 | The PA period in which the invoice was generated ***** | ||
| GL_PERIOD | VARCHAR2 | 30 | The period within a GL accounting period to which the invoice transactions are posted. ***** | ||
| PA_DATE | DATE | The end date of the PA period in which the invoice was generated ***** | |||
| GL_DATE | DATE | The date within a GL accounting period to which the invoice transactions are posted. ***** | |||
| REVENUE_CATEGORY_CODE | VARCHAR2 | 30 | REVENUE_CATEGORY_CODE ***** | ||
| BILLING_EXTENSION_ID | NUMBER | 18 | Identifier of billing extension ***** | ||
| EXCEPTION_FLAG | VARCHAR2 | 1 | Indicator of exception. When exceptions occur, this flag is updated ***** | ||
| LATEST_INVOICE_DIST_ID | NUMBER | 18 | LATEST_INVOICE_DIST_ID ***** | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 30 | PROJECT_CURRENCY_CODE ***** | ||
| PROJECT_CURR_RATE_TYPE | VARCHAR2 | 30 | PROJECT_CURR_RATE_TYPE ***** | ||
| PROJECT_CURR_EXCHG_DATE | DATE | PROJECT_CURR_EXCHG_DATE ***** | |||
| PROJECT_CURR_EXCHG_RATE | NUMBER | PROJECT_CURR_EXCHG_RATE ***** | |||
| PROJECT_CURR_AMT | NUMBER | PROJECT_CURR_AMT ***** | |||
| PROJECT_ROLE_ID | NUMBER | 18 | Unique id of the project role associated with the project cost transaction. | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 30 | LEDGER_CURRENCY_CODE ***** | ||
| LEDGER_CURR_RATE_TYPE | VARCHAR2 | 30 | LEDGER_CURR_RATE_TYPE ***** | ||
| LEDGER_CURR_EXCHG_DATE | DATE | LEDGER_CURR_EXCHG_DATE ***** | |||
| LEDGER_CURR_EXCHG_RATE | NUMBER | LEDGER_CURR_EXCHG_RATE ***** | |||
| LEDGER_CURR_AMT | NUMBER | LEDGER_CURR_AMT ***** | |||
| PROJECT_RATE_DATE_TYPE | VARCHAR2 | 30 | PROJECT_RATE_DATE_TYPE ***** | ||
| LEDGER_RATE_DATE_TYPE | VARCHAR2 | 30 | LEDGER_RATE_DATE_TYPE ***** | ||
| PRVDR_LEGAL_ENTITY_ID | NUMBER | 18 | PRVDR_LEGAL_ENTITY_ID ***** | ||
| RECVR_LEGAL_ENTITY_ID | NUMBER | 18 | RECVR_LEGAL_ENTITY_ID ***** | ||
| SLA_EVENT_ID | NUMBER | 18 | SLA_EVENT_ID ***** | ||
| REV_DISTRIBUTION_ID | NUMBER | 18 | REV_DISTRIBUTION_ID ***** | ||
| ASSIGNMENT_DETAIL_ID | NUMBER | 18 | ASSIGNMENT_DETAIL_ID ***** | ||
| BILLING_ASSIGNMENT_ID | NUMBER | 18 | BILLING_ASSIGNMENT_ID ***** | ||
| RATE_SOURCE_TYPE_CODE | VARCHAR2 | 30 | RATE_SOURCE_TYPE_CODE ***** | ||
| IC_TP_BASE_CODE | VARCHAR2 | 30 | IC_TP_BASE_CODE ***** | ||
| IC_TP_AMT_TYPE_CODE | VARCHAR2 | 30 | IC_TP_AMT_TYPE_CODE ***** | ||
| LABOR_TP_SCHEDULE_ID | NUMBER | 18 | LABOR_TP_SCHEDULE_ID ***** | ||
| LABOR_TP_SCH_FIXED_DATE | DATE | LABOR_TP_SCH_FIXED_DATE ***** | |||
| NL_TP_SCHEDULE_ID | NUMBER | 18 | NL_TP_SCHEDULE_ID ***** | ||
| NL_TP_SCH_FIXED_DATE | DATE | NL_TP_SCH_FIXED_DATE ***** | |||
| BILL_TO_CUSTOMER_LE_ID | NUMBER | 18 | BILL_TO_CUSTOMER_LE_ID ***** | ||
| EVENT_NUM | NUMBER | 18 | EVENT_NUM ***** | ||
| BILLING_CONTROL_ID1 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID2 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID3 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID4 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID5 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID6 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID7 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID8 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID9 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID10 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID11 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID12 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID13 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID14 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID15 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID16 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID17 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID18 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID19 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| BILLING_CONTROL_ID20 | NUMBER | 18 | Consumed Funding Control ID ***** | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| BURDEN_SCH_ID | NUMBER | Audit Column for rate derivation ***** | |||
| ENABLE_BILL_XTNSN_FLAG | VARCHAR2 | 1 | Flag indicating if client extension is to be called for accepting user defined rate ***** | ||
| BILL_RATE_MARKUP | VARCHAR2 | 1 | Temporary processing column ***** | ||
| TRNS_CURR_RAW_REVENUE | NUMBER | 22 | Revenue amount in transaction Currency ***** | ||
| TRNS_CURR_ADJ_REVENUE | NUMBER | 22 | Adjusted Revenue Amount in Transaction Currency ***** | ||
| EMP_BILLING_TITLE_OVRD | VARCHAR2 | 80 | The effective employee billing title override for the labor expenditure item ***** | ||
| JOB_BILLING_TITLE_OVRD | VARCHAR2 | 80 | The effective job billing title override for the labor expenditure item ***** | ||
| UOM_FLAG | VARCHAR2 | 1 | Unit of measure flag indicating if rate can be used for revenue/invoice generation ***** | ||
| TRNS_CURR_CREDIT_AMT | NUMBER | Credit Amount in transaction currency ***** | |||
| PROCESSED_FLAG | VARCHAR2 | 1 | Flag indicating that this transaction has been processed ***** | ||
| PROJECT_BU_ID | NUMBER | 18 | PROJECT_BU_ID ***** | ||
| OUTPUT_TAX_CLASS_CODE | VARCHAR2 | 150 | OUTPUT_TAX_CLASS_CODE ***** | ||
| INVOICE_CURRENCY_OPT_CODE | VARCHAR2 | 30 | INVOICE_CURRENCY_OPT_CODE ***** | ||
| LABOR_SCH_FIXED_DATE | DATE | LABOR_SCH_FIXED_DATE ***** | |||
| NL_SCH_FIXED_DATE | DATE | NL_SCH_FIXED_DATE ***** | |||
| BURDEN_SCH_FIXED_DATE | DATE | BURDEN_SCH_FIXED_DATE ***** | |||
| MSG_TOKEN1 | VARCHAR2 | 30 | MSG_TOKEN1 ***** | ||
| MSG_TOKEN_VALUE1 | VARCHAR2 | 30 | MSG_TOKEN_VALUE1 ***** | ||
| MSG_TOKEN2 | VARCHAR2 | 30 | MSG_TOKEN2 ***** | ||
| MSG_TOKEN_VALUE2 | VARCHAR2 | 30 | MSG_TOKEN_VALUE2 ***** | ||
| MSG_TOKEN3 | VARCHAR2 | 30 | MSG_TOKEN3 ***** | ||
| MSG_TOKEN_VALUE3 | VARCHAR2 | 30 | MSG_TOKEN_VALUE3 ***** | ||
| MSG_TOKEN4 | VARCHAR2 | 30 | MSG_TOKEN4 ***** | ||
| MSG_TOKEN_VALUE4 | VARCHAR2 | 30 | MSG_TOKEN_VALUE4 ***** | ||
| MSG_TOKEN5 | VARCHAR2 | 30 | MSG_TOKEN5 ***** | ||
| MSG_TOKEN_VALUE5 | VARCHAR2 | 30 | MSG_TOKEN_VALUE5 ***** | ||
| TP_BASE_AMOUNT | NUMBER | TP_BASE_AMOUNT ***** | |||
| APP_ERROR_CODE | VARCHAR2 | 4000 | Application Error Code ***** | ||
| READY_TO_ACCRUAL_FLAG | VARCHAR2 | 1 | READY_TO_ACCRUAL_FLAG | ||
| NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | 1 | NET_ZERO_ADJUSTMENT_FLAG | ||
| BILLABLE_FLAG | VARCHAR2 | 1 | BILLABLE_FLAG | ||
| EI_OVRD_BILL_RATE | NUMBER | Column used to store the rate defined at EI | |||
| EI_OVRD_BILL_RATE_CURR_CODE | VARCHAR2 | 15 | Column used to store the Currency Code defined at EI | ||
| HOLD_FLAG | VARCHAR2 | 1 | HOLD_FLAG | ||
| CONT_CURR_CONCESSION_AMT | NUMBER | CONT_CURR_CONCESSION_AMT | |||
| CONT_CURR_CREDIT_AMT | NUMBER | CONT_CURR_CREDIT_AMT | |||
| CONT_CURR_WRITEOFF_AMT | NUMBER | CONT_CURR_WRITEOFF_AMT | |||
| TRNS_CURR_CONCESSION_AMT | NUMBER | TRNS_CURR_CONCESSION_AMT | |||
| TRNS_CURR_WRITEOFF_AMT | NUMBER | COLUMN1 | |||
| TRNS_CURR_BILLED_AMT | NUMBER | TRNS_CURR_BILLED_AMT | |||
| CC_CROSS_CHARGE_CODE | VARCHAR2 | 1 | CC_CROSS_CHARGE_CODE | ||
| ORIG_REV_DISTRIBUTION_ID | NUMBER | 18 | ORIG_REV_DISTRIBUTION_ID | ||
| ORIG_LINE_NUM | NUMBER | 18 | ORIG_LINE_NUM | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | Invoice Currency. | ||
| INVOICE_CURR_RATE_TYPE | VARCHAR2 | 30 | Rate type of the Invoice Currency. | ||
| INVOICE_CURR_DATE_TYPE | VARCHAR2 | 30 | Rate Date Type of the Invoice Currency. | ||
| INVOICE_CURR_EXCHG_DATE | DATE | Exchange Date of the Invoice Currency. | |||
| INVOICE_CURR_EXCHG_RATE | NUMBER | Exchange Rate of the Invoice Currency. | |||
| INV_CURR_TXN_AMT | NUMBER | Transaction Amount in the Invoice Currency. | |||
| INV_CURR_ELIGIBLE_AMT | NUMBER | Eligible Amount in the Invoice Currency. | |||
| INV_CURR_QUALIFIED_AMT | NUMBER | Qualified Amount in Invoice Currency. | |||
| INV_CURR_BILLED_AMT | NUMBER | Billed Amount in Invoice Currency | |||
| INV_CURR_CREDIT_AMT | NUMBER | Credit Amount in Invoice Currency | |||
| INV_CURR_CONCESSION_AMT | NUMBER | Concession Amount in the Invoice Currency. | |||
| INV_CURR_WRITEOFF_AMT | NUMBER | WriteOff Amount in Invoice Currency. | |||
| CONT_CURR_OVERRIDE_ID | NUMBER | 18 | Identifier for Contract Currency Conversion Override. | ||
| INV_CURR_OVERRIDE_ID | NUMBER | 18 | Identifier for Invoice Currency Conversion Override. | ||
| FUNDING_SOURCE | VARCHAR2 | 150 | Stores the funding source of the expenditure item for Grants .Value is obtained from pjc_exp_items_all.reserved_attribute1 | ||
| WORK_TYPE_ID | NUMBER | 18 | Identifier for a worktype assigned to a transaction. | ||
| NET_CREDIT_FLAG | VARCHAR2 | 1 | Identifier for Net Credit. | ||
| ORIGINAL_DIST_ID | NUMBER | 18 | Identifier of Original Invoice Distribution | ||
| ORIGINAL_INVOICE_ID | NUMBER | 18 | Identifier for Original Invoice Id. | ||
| ORIGINAL_INVOICE_LINE_ID | NUMBER | 18 | Idetifier of Oriignal Invoice Line . | ||
| MIGRATION_FLAG | VARCHAR2 | 1 | Flag to indicate migrated transaction. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item. | ||
| ITEM_ORGANIZATION_ID | NUMBER | 18 | Identifier of the inventory item organization. | ||
| UOM_CODE | VARCHAR2 | 30 | Code for the unit of measure. | ||
| TRNS_CURR_UNIT_PRICE | NUMBER | Unit price in transaction currency. | |||
| HCM_ASSIGNMENT_ID | NUMBER | 18 | Identifier of the person assignment for labor expenditure item. | ||
| TRX_ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Provider ledger currency code of the cost transaction, which is the accounted currency in GL. | ||
| TRX_ACCT_CURR_EXCHG_DATE | DATE | Date used to derive the rate to convert the cost transaction amount from the transaction currency to the provider ledger currency, which is the accounted currency in GL. | |||
| TRX_ACCT_CURR_RATE_TYPE | VARCHAR2 | 30 | Rate type used to derive the rate to convert the cost transaction amount from the transaction currency to the provider ledger currency, which is the accounted currency in GL. | ||
| TRX_ACCT_RATE_DATE_TYPE | VARCHAR2 | 30 | Date type used to derive the date to convert the cost transaction amount from the transaction currency to the provider ledger currency, which is the accounted currency in GL. | ||
| TRX_ACCT_CURR_EXCHG_RATE | NUMBER | Rate used to convert the cost transaction amount from the transaction currency to the provider ledger currency, which is the accounted currency in GL. | |||
| TRX_ACCT_EXCHG_ROUND_LIMIT | NUMBER | Maximum difference allowed between the raw cost transaction amount in provider ledger currency entered by the user, and the calculated raw cost transaction amount in provider ledger currency, which is the accounted currency in GL. If not provided, this amount is presumed to be zero, meaning the entered and the calculated raw cost transaction amounts in provider ledger currency must be identical. | |||
| INV_GROUP_ATTRIBUTE_VALUES | VARCHAR2 | 4000 | List of attribute values, based on the attributes specified on the applicable invoice format and separated by a delimiter, used to group transactions into invoice lines. | ||
| INV_GROUP_ATTRIBUTE_DESC | VARCHAR2 | 4000 | List of attribute names, as specified on the applicable invoice format and separated by a delimiter, used to group transactions into invoice lines. | ||
| INV_LINE_DESCRIPTION | VARCHAR2 | 4000 | Formatted combination of attribute values and text that describes the products, projects, services or goods being charged to the customer on each line of an invoice. | ||
| INVOICE_FORMAT_ID | NUMBER | 18 | Indicates a set of rules that governs the summarization of invoice distributions into invoice lines. This option is applicable for labor, non labor, event transactions. | ||
| CURRENCY_OVRRD_FLAG | VARCHAR2 | 1 | Indicates whether the bill plan has any currency overrides or not. | ||
| INV_CREDITED_PERCENT | NUMBER | Percentage credited during invoice adjustment processing. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PJB_PROCESS_GT_N1 | Non Unique | BILL_TRX_ID |
| PJB_PROCESS_GT_N2 | Non Unique | BILL_TRANSACTION_TYPE_CODE, TRANSACTION_ID |
| PJB_PROCESS_GT_N3 | Non Unique | CONTRACT_ID, CONTRACT_LINE_ID |
| PJB_PROCESS_GT_N4 | Non Unique | TRANSACTION_ID |
| PJB_PROCESS_GT_N5 | Non Unique | PROCESSED_FLAG |
| PJB_PROCESS_GT_N6 | Non Unique | REV_DISTRIBUTION_ID |
| PJB_PROCESS_GT_N7 | Non Unique | CONTRACT_LINE_ID, BILL_TRANSACTION_TYPE_CODE, PROCESSED_FLAG |