D48S0410A - F4812 Split workfile Records
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| jdDtForGLAndVouch1 | DGL | JDEDATE | OPT | INPUT |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
| mnParentSequenceNbr | PRSQ | MATH_NUMERIC | OPT | INPUT |
A number that provides an audit trail to the original transaction of a billing detail transaction. The system initially assigns 000 as the parent
| ||||
| mnSequenceNbrServiceBilling | SBSQ | MATH_NUMERIC | OPT | INPUT |
A number that provides an audit trail for the billing detail transactions related to the same billing control ID. The system initially assigns 001
| ||||
| mnSecondarySequence | SCSQ | MATH_NUMERIC | OPT | INPUT |
A number you can use to track the changes applied to a billing detail transaction. The system initially assigns 001 as the secondary
| ||||
| mnBillingControlId | BCI | MATH_NUMERIC | OPT | INPUT |
A unique number that the system assigns to each billing record. The system assigns the number from the Next Numbers - Automatic table
| ||||
| mnSplitLink | SLNK | MATH_NUMERIC | OPT | INPUT |
The split link field ties component records to their base record when a transaction split occurs. | ||||
| mnComponentLink | CLNK | MATH_NUMERIC | OPT | INPUT |
A code that attaches the component record to its base work file record. | ||||
| szComponentCode | CCOD | char | OPT | INPUT |
A component code identifies a provisional burden that is accounted for at the billing detail transaction level. | ||||
| UP1Dom | PRIC | MATH_NUMERIC | OPT | INPUT |
A base or default price that is used with multipliers from the pricing rules to develop discounted prices. If no formula applies to an item or no
| ||||
| UP2Dom | PRIC | MATH_NUMERIC | OPT | INPUT |
A base or default price that is used with multipliers from the pricing rules to develop discounted prices. If no formula applies to an item or no
| ||||
| UP2For | PRIF | MATH_NUMERIC | OPT | INPUT |
This field represents the Foreign Unit price. | ||||
| UP1For | PRIF | MATH_NUMERIC | OPT | INPUT |
This field represents the Foreign Unit price. | ||||
| Units1 | U | MATH_NUMERIC | OPT | INPUT |
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons,
| ||||
| Units2 | U | MATH_NUMERIC | OPT | INPUT |
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons,
| ||||
| Cost1Dom | AA | MATH_NUMERIC | OPT | INPUT |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
| Cost2Dom | AA | MATH_NUMERIC | OPT | INPUT |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
| Cost1For | AA2 | MATH_NUMERIC | OPT | INPUT |
Amount. | ||||
| Cost2For | AA2 | MATH_NUMERIC | OPT | INPUT |
Amount. | ||||
| InvTaxable1Dom | ITXA | MATH_NUMERIC | OPT | INPUT |
The portion of the invoice amount that is subject to tax. | ||||
| InvTaxable2Dom | ITXA | MATH_NUMERIC | OPT | INPUT |
The portion of the invoice amount that is subject to tax. | ||||
| InvTaxable1For | CITA | MATH_NUMERIC | OPT | INPUT |
The portion of the foreign invoice amount that is subject to tax. | ||||
| InvTaxable2For | CITA | MATH_NUMERIC | OPT | INPUT |
The portion of the foreign invoice amount that is subject to tax. | ||||
| Rev1Dom | BTOL | MATH_NUMERIC | OPT | INPUT |
The revenue amount for a billing detail transaction. | ||||
| Rev2Dom | BTOL | MATH_NUMERIC | OPT | INPUT |
The revenue amount for a billing detail transaction. | ||||
| Rev1For | FTOL | MATH_NUMERIC | OPT | INPUT |
The total amount of the invoice or bill. The total of the individual line items must match this amount. | ||||
| Rev2For | FTOL | MATH_NUMERIC | OPT | INPUT |
The total amount of the invoice or bill. The total of the individual line items must match this amount. | ||||
| JournaledTax1Dom | JTAX | MATH_NUMERIC | OPT | INPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| JournaledTax2Dom | JTAX | MATH_NUMERIC | OPT | INPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| JournaledTax1For | JTXF | MATH_NUMERIC | OPT | INPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| JournaledTax2For | JTXF | MATH_NUMERIC | OPT | INPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| InvTax1Dom | ITAM | MATH_NUMERIC | OPT | INPUT |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
| InvTax2Dom | ITAM | MATH_NUMERIC | OPT | INPUT |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
| InvTax1For | CITX | MATH_NUMERIC | OPT | INPUT |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. | ||||
| InvTax2For | CITX | MATH_NUMERIC | OPT | INPUT |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. | ||||
| InvMarkup1 | ADCI | MATH_NUMERIC | OPT | INPUT |
An amount that the system uses to mark up the invoice amount for the billing of professional services, such as the services of draftsmen,
| ||||
| InvMarkup2 | ADCI | MATH_NUMERIC | OPT | INPUT |
An amount that the system uses to mark up the invoice amount for the billing of professional services, such as the services of draftsmen,
| ||||
| RevMarkup1 | ADCR | MATH_NUMERIC | OPT | INPUT |
An amount that the system uses to mark up the revenue amount for the billing of professional services, such as the services of draftsmen,
| ||||
| RevMarkup2 | ADCR | MATH_NUMERIC | OPT | INPUT |
An amount that the system uses to mark up the revenue amount for the billing of professional services, such as the services of draftsmen,
| ||||
| HistRev1 | HBTL | MATH_NUMERIC | OPT | INPUT |
This value represents the revenue amount prior to invoice generation. Use this value to restore the original revenue amount if the record is
| ||||
| HistRev2 | HBTL | MATH_NUMERIC | OPT | INPUT |
This value represents the revenue amount prior to invoice generation. Use this value to restore the original revenue amount if the record is
| ||||
| HistTaxable1 | HITX | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice taxable amount prior to invoice generation.
Use this value to restore the original invoice taxable amount if
| ||||
| HistTaxable2 | HITX | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice taxable amount prior to invoice generation.
Use this value to restore the original invoice taxable amount if
| ||||
| HistTax1 | HTAM | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice tax amount prior to invoice generation. Use this value to restore the original invoice tax amount if the
| ||||
| HistTax2 | HTAM | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice tax amount prior to invoice generation. Use this value to restore the original invoice tax amount if the
| ||||
| HistInv1 | HITL | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice amount prior to invoice generation. Use this value to restore the original invoice amount if the record is
| ||||
| HistInv2 | HITL | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice amount prior to invoice generation. Use this value to restore the original invoice amount if the record is
| ||||
| InvDiscount1Dom | IDSC | MATH_NUMERIC | OPT | INPUT |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
| InvDiscount2Dom | IDSC | MATH_NUMERIC | OPT | INPUT |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
| InvDiscount1For | CIDS | MATH_NUMERIC | OPT | INPUT |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
| ||||
| InvDiscount2For | CIDS | MATH_NUMERIC | OPT | INPUT |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
| ||||
| TotalInv1Dom | ITOL | MATH_NUMERIC | OPT | INPUT |
The invoice amount for a billing detail transaction. | ||||
| TotalInv2Dom | ITOL | MATH_NUMERIC | OPT | INPUT |
The invoice amount for a billing detail transaction. | ||||
| TotalInv1For | CITL | MATH_NUMERIC | OPT | INPUT |
The total amount of the invoice in foreign currency. | ||||
| TotalInv2For | CITL | MATH_NUMERIC | OPT | INPUT |
The total amount of the invoice in foreign currency. | ||||
| Error | EV01 | char | OPT | BOTH |
An option that specifies the type of processing for an event. | ||||
| cVertexActiveFlag | VVTX | char | OPT | INPUT |
This flag determines whether to use the Vertex Tax Compliance system for tax calculations. Values are:
Y
Use Vertex system to calculate
| ||||
| mnVertexActiveJobNo | JOBS | MATH_NUMERIC | OPT | INPUT |
The job number (work station ID) which executed the particular job. | ||||
| mnBurdeningCacheJob | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
| None |
| None |