Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVCTAX


                             OEINVCTAX FILE

                             Invoice Taxes

This file stores the tax records assessed when processing an order or
invoice. These records store the invoice and invoice line being taxed, the tax
code used, and the rate of the tax, as well as the amount of the tax in both
company base currency and billing currency.

REFERENCED BY

BL121     BL123     BL290     BL80.1    BL81.1    TX101


UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL320     BL520     BL820
BL92.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIT-COMPANY            Numeric 4                                 BL120   BL122
Element: Company       Identifies the AP company if the          BL130   BL20.1
                       resource type = V.  Identifies the HR     BL20.3  BL21.2
                       company if the resource type = E.  It is  BL21.5  BL29.1
                       blank for type A, P or Q resources.       BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-INVC-PREFIX        Alpha 2                                   BL120   BL122
Element: Invc Prefix   This field contains the invoice prefix    BL130   BL20.1
                       that is assigned from either the company  BL20.3  BL21.2
                       or process level, depending on the        BL21.5  BL29.1
                       invoice-level option chosen.              BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-INVC-NUMBER        Numeric 8                                 BL120   BL122
Element: Invc Number   This field contains the invoice number    BL130   BL20.1
                       assigned by the system.  Invoice numbers  BL20.3  BL21.2
                       are assigned at the company or process    BL21.5  BL29.1
                       level, depending on an invoice-level      BL29.2  BL520
                       option on the company file.               BL820   BL92.1
                                                                 WH20.7

OIT-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Nbr      Displays the system sequence number       BL130   BL20.1
                       indicating which line on the invoice the  BL20.3  BL21.2
                       tax is being calculated for.              BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-SEQ                Numeric 3                                 BL120   BL122
Element: Seq           The tax record sequence number.           BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-PROD-TAX-CAT       Alpha 15                                  BL120   BL122
Element: Prod Tax Cat  A classification of items for             BL130   BL20.1
                       determining taxes using the Vertex        BL20.3  BL21.2
                       system in Order Entry or the cash         BL21.5  BL29.1
                       receipts programs in Cash Management.     BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-ID             Alpha 20                                  BL120   BL122
Element: Tax Id        This field contains the tax ID or         BL130   BL20.1
                       registration number.                      BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-CODE           Alpha 10                                  BL120   BL122
Element: Tax Code      A user-defined tax code representing      BL130   BL20.1
                       the tax authorities this ship-to pays     BL20.3  BL21.2
                       sales tax to. Must be a valid tax code    BL21.5  BL29.1
                       record.                                   BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-RATE           Percent 7.5  (Percent)                    BL120   BL122
Element: Chrg Rate     The tax rate.                             BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-AMT-CURR       Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the tax amount in billing         BL130   BL20.1
                       currency.                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-AMT-BSE        Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the tax amount in company base    BL130   BL20.1
                       currency.                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-ACCT-UNIT      Alpha 15                                  BL120   BL122
Element: Acct Unit     This is the general ledger account unit   BL130   BL20.1
                       that will be credited when the invoice    BL20.3  BL21.2
                       tax is posted to General Ledger. This     BL21.5  BL29.1
                       will be debited for return credit memos.  BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-ACCOUNT        Numeric 6                                 BL120   BL122
Element: Account       This is the general ledger account        BL130   BL20.1
                       number that will be credited when the     BL20.3  BL21.2
                       invoice tax is posted to General Ledger.  BL21.5  BL29.1
                       This will be debited for return credit    BL29.2  BL520
                       memos.                                    BL820   BL92.1
                                                                 WH20.7

OIT-TAX-SUB-ACCT       Numeric 4                                 BL120   BL122
Element: Sub Acct      This is the general ledger subaccount     BL130   BL20.1
                       number that will be credited when the     BL20.3  BL21.2
                       invoice tax is posted to General Ledger.  BL21.5  BL29.1
                       This will be debited for return credit    BL29.2  BL520
                       memos.                                    BL820   BL92.1
                                                                 WH20.7

OIT-TRAN-TAXABLE       Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-BASE-TAXABLE       Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIT-TAX-LEVEL          Alpha 1                                   BL120   BL122
Element: Tax Level     1 = State                                 BL130   BL20.1
                       2 = County                                BL20.3  BL21.2
                       3 = City                                  BL21.5  BL29.1
                       4 = District                              BL29.2  BL520
                       5 = GST                                   BL820   BL92.1
                       6 = PST                                   WH20.7

                         OEINVCTAX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OITSET1   COMPANY                                                BL120   BL121
          INVC-PREFIX                                            BL122   BL123
          INVC-NUMBER                                            BL130   BL20.1
          LINE-NBR                                               BL20.3  BL21.2
          SEQ                                                    BL21.5  BL29.1
          TAX-CODE                                               BL29.2  BL290
          TAX-LEVEL                                              BL320   BL520
                                                                 BL80.1  BL81.1
                                                                 BL820   BL92.1
                                                                 TX101   WH20.7

OITSET2   COMPANY                                                BL121   BL122
          INVC-PREFIX                                            BL123   BL290
          INVC-NUMBER                                            BL80.1
          TAX-CODE
          LINE-NBR
          SEQ
          TAX-LEVEL

OITSET3   COMPANY
          INVC-PREFIX
          INVC-NUMBER
          LINE-NBR
          TAX-CODE
          SEQ
          TAX-LEVEL

OITSET4   COMPANY                                                BL121   BL122
          INVC-PREFIX                                            BL123   BL290
          INVC-NUMBER                                            BL80.1
          TAX-CODE
          PROD-TAX-CAT
          LINE-NBR
          SEQ
          TAX-LEVEL

                         OEINVCTAX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OIT-COMPANY        -> OEC-COMPANY

Oeinvcline     OEINVCLINE   Required
                            When OIT-LINE-NBR > Zeroes
                            And  OIT-SEQ      = Zeroes

                            OIT-COMPANY        -> OIL-COMPANY
                            OIT-INVC-PREFIX    -> OIL-INVC-PREFIX
                            OIT-INVC-NUMBER    -> OIL-INVC-NUMBER
                            OIT-LINE-NBR       -> OIL-LINE-NBR

Oeinvcmisc     OEINVCMISC   Required
                            When OIT-LINE-NBR > Zeroes
                            And  OIT-SEQ      > Zeroes

                            OIT-COMPANY        -> OIM-COMPANY
                            OIT-INVC-PREFIX    -> OIM-INVC-PREFIX
                            OIT-INVC-NUMBER    -> OIM-INVC-NUMBER
                            OIT-LINE-NBR       -> OIM-LINE-NBR
                            OIT-SEQ            -> OIM-SEQ

Oeinvoice      OEINVOICE    Required

                            OIT-COMPANY        -> OEI-COMPANY
                            OIT-INVC-PREFIX    -> OEI-INVC-PREFIX
                            OIT-INVC-NUMBER    -> OEI-INVC-NUMBER

Txtaxcode      TXTAXCODE    Required

                            OIT-COMPANY        -> TAC-COMPANY
                            OIT-TAX-CODE       -> TAC-TAX-CODE