BLRICLINE

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BULSET1 COMPANY
RECUR-INVOICE
CUSTOMER
LINE-NBR
BULSET2 COMPANY
RECUR-INVOICE
MAST-LINE-NBR
CUSTOMER
Subset
WhereMAST-LINE-NBR !=Zeroes
BLI2.1
BULSET4 COMPANY
FREQUENCY
CYCLE-CODE
ITEM
RECUR-INVOICE
CUSTOMER
LINE-NBR
KeyChange, Subset
WhereZERO-AFTER-USE ="Y"
BULSET5 COMPANY
RECUR-INVOICE
CUSTOMER
LINE-NBR
Subset
WhereQUANTITY =Zeroes
AndSKIP-FLAG ="N"


BLRICLINE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
BUL-COMPANY->-COMPANY (XXXXXXXXXX)
Arcustomer ARCUSTOMER Required
BUL-COMPANY->ACM-COMPANY
BUL-CUSTOMER->ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
BUL-CUSTOMER->CUD-CUSTOMER
Iccompany ICCOMPANY Required
BUL-COMPANY->ICC-COMPANY
Itemmast ITEMMAST Required
When BUL-LINE-TYPE ="I"
OrBUL-LINE-TYPE ="N"
ICC-ITEM-GROUP->ITE-ITEM-GROUP
BUL-ITEM->ITE-ITEM
Oecommhdr1 OECOMMHDR Not Required
Valid When BUL-STD-COMM1 !=Spaces
BUL-COMPANY->OCH-COMPANY
BUL-STD-COMM1->OCH-STD-COMM
Oecommhdr2 OECOMMHDR Not Required
Valid When BUL-STD-COMM2 !=Spaces
BUL-COMPANY->OCH-COMPANY
BUL-STD-COMM2->OCH-STD-COMM
Oecommhdr3 OECOMMHDR Not Required
Valid When BUL-STD-COMM3 !=Spaces
BUL-COMPANY->OCH-COMPANY
BUL-STD-COMM3->OCH-STD-COMM
Oecompany OECOMPANY Required
BUL-COMPANY->OEC-COMPANY
Oecustsrvc BLRICUST Required
BUL-COMPANY->BRC-COMPANY
BUL-RECUR-INVOICE->BRC-RECUR-INVOICE
BUL-CUSTOMER->BRC-CUSTOMER
Salesman SALESREP Required
When BUL-SALESMAN !=Zeroes
BUL-COMPANY->SAW-COMPANY
BUL-SALESMAN->SAW-SALESMAN
Salesman2 SALESREP Required
When BUL-SALESMAN-2 !=Zeroes
BUL-COMPANY->SAW-COMPANY
BUL-SALESMAN-2->SAW-SALESMAN
Territory TERITORY Required
When BUL-TERRITORY !=Spaces
BUL-COMPANY->TRY-COMPANY
BUL-TERRITORY->TRY-TERRITORY


BLRICLINE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Blriccomm BLRICCOMM
BUL-COMPANY->BUC-COMPANY
BUL-RECUR-INVOICE->BUC-RECUR-INVOICE
BUL-CUSTOMER->BUC-CUSTOMER
BUL-LINE-NBR->BUC-LINE-NBR
  BUC-SEQ
Oecscomm BLRICCOMM
BUL-COMPANY->BUC-COMPANY
BUL-RECUR-INVOICE->BUC-RECUR-INVOICE
BUL-CUSTOMER->BUC-CUSTOMER
BUL-LINE-NBR->BUC-LINE-NBR
  BUC-SEQ


File created: Thu Jun 09 11:09:26 2016

Home
Contact Us



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