Cust. Recurring Invc Item

This file contains the line items for customer recurring invoices. It is usually created from a line on the recurring invoice. However, you can enter additional line items manually.
UPDATED BY

BLI2.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
BUL-COMPANY Element: Company	Numeric 4 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.
BUL-RECUR-INVOICE Element: Recur Invoice	Alpha 10 This is the recurring invoice identifier.
BUL-CUSTOMER Element: Customer	Alpha 9 (Right Justified) This field contains the number that represents a customer.
BUL-SHIP-TO Element: Ship To	Numeric 4 This field contains the number representing the ship to customer.
BUL-LINE-NBR Element: Line Nbr	Numeric 6 This field contains the line number.
BUL-ITEM Element: Item	Alpha 32 This field contains the item identifier.
BUL-ITEM-DESC Element: Item Desc	Alpha 30 This field contains the description for items.
BUL-LINE-TYPE Element: Line Type	Alpha 1 This field contains the type of inventory on this line. N = Non-stock X = Special Order I = Inventory
BUL-ZERO-AFTER-USE Element: All Flag	Alpha 1 This flag indicates whether the quantity field is to be zeroed after creation of the actual invoice for each period.
BUL-QUANTITY Element: Quantity	Signed 13.4 This is the total quantity to be billed for this customer recurring invoice item.
BUL-SKIP-FLAG Element: Skip Flag	Alpha 1 Skip this period flag. Only valid if zero after use is set to Yes. This lets you pass the edit ensuring that all zero after use lines have been set up for a billing period and still skip billing a line.
BUL-INVOICE-QTY Element: Quantity	Signed 13.4 This is the quantity to be billed on the next invoice created for this customer recurring invoice line.
BUL-BILLED-AMOUNT Element: Intl Amt	Signed 18.2 The total amount already billed against this customer recurring invoice line.
BUL-SELL-UOM Element: Uom	Alpha 4 This field contains the selling unit of measure for the item.
BUL-UNIT-PRICE Element: Intl Cost	Signed 18.5
BUL-SPR-UOM Element: Uom	Alpha 4 This is the pricing unit of measure for this line.
BUL-FREQUENCY Element: Frequency	Alpha 1 This is the frequency code for this recurring invoice. W = Weekly S = Semi-Monthly M = Monthly Q = Quarterly Y = Yearly U = User Defined
BUL-CYCLE-CODE Element: Auth Code	Alpha 3 This is the cycle code. Cycle code is used to separate recurring invoices into groups within frequency for processing.
BUL-START-DATE Element: Start Date	Numeric 8 (yyyymmdd) This is the starting date. Invoices created from this customer recurring invoice after this date and prior to the stop date will include this item.
BUL-STOP-DATE Element: Stop Date	Numeric 8 (yyyymmdd) This is the stop date. Invoice created for this customer recurring invoice after this date will not include this line.
BUL-TERRITORY Element: Territory	Alpha 4 This field contains the sales territory.
BUL-SALESMAN Element: Salesman	Numeric 4 This field contains the code that represents the primary sales representative of this line. If left blank, this defaults from the order header.
BUL-SALESMAN-2 Element: Salesman	Numeric 4 This field contains the code representing the second sales representative.
BUL-COMM-RATE-1 Element: Chrg Rate	Percent 7.5 (Percent) This field contains the commission rate of the primary sales representative.
BUL-COMM-RATE-2 Element: Chrg Rate	Percent 7.5 (Percent) This field contains the commission rate for the second sales representative.
BUL-COMM-SPLIT Element: Comm Split	Percent 5.3 (Percent) This field contains the commission split. This defaults from the customer master.
BUL-STD-COMM1 Element: Std Comm	Alpha 4 Standard comment code 1. Code to represent a group of comments.
BUL-STD-COMM2 Element: Std Comm	Alpha 4 Standard comment code 2. Code to represent a group of comments.
BUL-STD-COMM3 Element: Std Comm	Alpha 4 Standard comment code 3. Code to represent a group of comments.
BUL-LAST-MISC-SEQ Element: Seq	Numeric 3 Last sequence number used for add-on charges for this customer recurring invoice line.
BUL-LAST-COMM-SEQ Element: Seq	Numeric 3 This field contains the record sequence number.	BLI2.1
BUL-MAST-LINE-NBR Element: Line Nbr	Numeric 6 Line number of the recurring invoice line that caused this customer recurring invoice line.
BUL-UNBILLED-AMT Element: Unbilled Amt	Derived Amount yet to be billed against this line.
BUL-TOTAL-VALUE Element: Total Value	Derived Total amount to be billed against this line.
BUL-IC-UOM-1 Element: Ic Uom 1	Derived This field contains the first inventory unit of measure for the item.
BUL-IC-UOM-2 Element: Ic Uom 2	Derived This field contains the second inventory unit of measure for the item.
BUL-IC-UOM-3 Element: Ic Uom 3	Derived This field contains the third inventory unit of measure for the item.
BUL-IC-UOM-4 Element: Ic Uom 4	Derived This field contains the fourth inventory unit of measure for the item.
BUL-IC-UOM-5 Element: Ic Uom 5	Derived This field contains the fifth inventory unit of measure for the item.
BUL-IC-UOM-6 Element: Ic Uom 6	Derived This field contains the sixth inventory unit of measure for the item.
BUL-STS-INDEX Element: Sts Index	Derived This field determines which inventory unit of measure is used for display purposes.
BUL-STS-M Element: Sts M	Derived This field contains the multiplier.
BUL-STS-MULT Element: Sts Mult	Derived This field contains the sales to stock multiplier.
BUL-PTS-INDEX Element: Pts Index	Derived This field determines which unit of measure to use in pricing.
BUL-PTS-M Element: Pts M	Derived This field contains the pricing multiplier.
BUL-PTS-MULT Element: Pts Mult	Derived This field contains the pricing unit of measure multiplier.
BUL-ITEM-16 Element: Item 16	Derived This field contains the first 16 characters of the item's identifier. This information is used by inquiries and reports.
BUL-TAX-CODE Element: Tax Code	Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code.
BUL-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 Code indicating the taxing status. E - Exempt, T - Taxable.
BUL-ACTIVITY Element: Activity	Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
BUL-ACCT-CATEGORY Element: Acct Category	Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru

BLRICLINE FILE INDEX

BLRICLINE FILE RELATIONS

ONE TO ONE RELATIONS

BLRICLINE FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.