|
|
SAINVOICE FILE
SA Invoice
The Sales Analysis Invoice file stores historic information for customer
invoices.
REFERENCED BY
SA250 SA251 SA253 SA255 SA256 SA258
SALD.1 SA252
UPDATED BY
SA100 SA101 SA110 SA300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAI-COMPANY Numeric 4 SA100 SA110
Element: Company Identifies the AP company if the SA300
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
SAI-INVC-PREFIX Alpha 2 SA100 SA110
Element: Invoice PrefixContains the invoice prefix that is SA300
assigned from either the company or
process level, depending on the
invoice-level option chosen.
SAI-INVC-NUMBER Numeric 8 SA100 SA110
Element: Invc Number Contains the invoice number assigned by SA300
the system. Invoice numbers are
assigned at the company or process
level, depending on an invoice-level
option on the company file.
SAI-ORDER-NBR Numeric 8 SA100 SA110
Element: Order Number Each order is assigned a unique number. SA300
Order numbers are either manually
assigned or system assigned based on a
company-level option.
SAI-SHIPMENT-NBR Numeric 10 SA100 SA110
Element: Shipment NumbeContains the shipment number. One SA300
order can have several shipment numbers
if the items of the order were not
shipped at the same time.
SAI-PROCESS-LEVEL Alpha 5 SA100 SA110
Element: Process Level This field contains the process level, SA300
which is the reporting hierarchy below
company.
SAI-LOCATION Alpha 5 SA100 SA110
Element: Location Code Contains a valid stock location within SA300
the company inventory.
SAI-INVC-TYPE Alpha 4 SA100 SA110
Element: Invoice Type Invoice type. Must be a valid invoice SA300
type.
SAI-INVOICE-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Invoice Date Invoice date. SA300
SAI-INVC-SOURCE Alpha 1 SA100 SA110
Element: Invc Source Invoice source. This code indicates SA300
where this invoice originated.
SAI-RECUR-INVOICE Alpha 10 SA100 SA110
Element: Recur Invoice Contains the recurring invoice SA300
identifier.
SAI-BILL-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Bill Date Billing date. Only valid for invoices SA300
created from a customer's recurring
invoice.
SAI-DUE-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Due Date Invoice due date. Calculated based on SA300
terms code options.
SAI-GL-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: General LedgerContains the general ledger posting SA300
date.
SAI-SHIP-DATE Numeric 8 (yyyymmdd)
Element: Date Actual shipment date.
SAI-BOOKED-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Date Actual booked date. SA300
SAI-TERM-CODE Alpha 5 SA100 SA110
Element: Terms Code A user-defined code representing a SA300
method of determining an invoice's due
and discount dates.
SAI-REASON-CODE Alpha 4 SA100 SA110
Element: Reason Code Contains the reason code, which SA300
indicates the cause for credit memos.
SAI-TERRITORY Alpha 4 SA100 SA110
Element: Sales TerritorSales territory. SA300
SAI-SALESMAN Numeric 4 SA100 SA110
Element: Salesman NumbeContains the code that represents the SA300
primary sales representative of this
line. If left blank, this defaults from
the order header.
SAI-SALESMAN-2 Numeric 4 SA100 SA110
Element: Salesman NumbeContains the code representing the SA300
second sales representative. This
defaults from the order header.
SAI-COMM-RATE-1 Percent 7.5 (Percent) SA100 SA110
Element: Chrg Rate Contains the commission rate of the SA300
primary sales representative. This
defaults from the sales representative
file.
SAI-COMM-RATE-2 Percent 7.5 (Percent) SA100 SA110
Element: Chrg Rate Contains the commission rate for the SA300
second sales representative. This
defaults from the sales representative
file.
SAI-COMM-SPLIT Percent 5.3 (Percent) SA100 SA110
Commission Split Contains the commission split. This SA300
Percentage defaults from the customer file.
SAI-OPR-CODE Alpha 10 (Lower Case) SA100 SA110
Element: Operator Code Contains the operator code. This is SA300
the user ID of the person who last
maintained this record.
SAI-CUST-PO-NBR Alpha 22 SA100 SA110
Element: Customer P.O. The customer's purchase order number. SA300
SAI-LETTER-OF-CR Alpha 20 SA100 SA110
Element: Letter of CredContains the letter of credit. SA300
SAI-CURRENCY-CODE Alpha 5 SA100 SA110
Element: Currency Code Billing currency of the original SA300
invoice.
SAI-CUSTOMER-CODE Alpha 4 SA100 SA110
Element: Customer Code Customer code this invoice is SA300
summarized under.
SAI-CURR-RATE Signed 14.7
Element: Currency Rate Currency conversion rate at the time
the invoice was created.
SAI-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Element: Customer NumbeContains the number that represents a SA300
customer.
SAI-SHIP-TO Numeric 4 SA100 SA110
Element: Ship-to Code The customer's ship-to number. SA300
SAI-PAYMNT-AMT Signed 18.2 SA100 SA110
Element: Intl Amt Down payment amount. SA300
SAI-ORDER-SOURCE Alpha 2 SA100 SA110
Element: Order Source Order source code. Order sources are SA300
set up in OE52.1 (Order Source).
SAI-FRT-CODE Alpha 2 SA100 SA110
Element: Add On Cost CoFreight code for this invoice. Freight SA300
codes are set up in BL12.1 (Freight
Codes).
SAI-FRT-CHARGE Signed 18.2 SA100 SA110
Element: Intl Amt Freight charges for this invoice. SA300
SAI-CARRIER Alpha 9 (Right Justified) SA100 SA110
Element: Vendor ID The carrier vendor number. Must be SA300
valid in the Lawson Accounts Payable
system.
SAI-METHOD Alpha 10 SA100 SA110
Element: Method Code Shipping method for this invoice. SA300
Shipping methods are set up in WH11.1
(Shipping Method).
SAI-TRANS-ID Alpha 20 SA100 SA110
Element: Trans Id Transportation ID. User defined. For SA300
example, if the shipping method is
truck, this could be the truck number.
SAI-LIST-NAME Alpha 14 SA100 SA110
Element: List Name Price list for this invoice's customer SA300
at the time the invoice was created.
SAI-USER-DATE-1 Numeric 8 (yyyymmdd) SA100 SA110
Element: Date User date 1. SA300
SAI-USER-DATE-2 Numeric 8 (yyyymmdd) SA100 SA110
Element: Date User date 2. SA300
SAI-TRANS-USER1 Alpha 10 SA100 SA110
Element: Trans User1 Transaction user field 1. SA300
SAI-TRANS-USER2 Alpha 15 SA100 SA110
Element: Agent Transaction user field 2. SA300
SAI-TRANS-USER3 Numeric 8 (yyyymmdd) SA100 SA110
Element: Trans User3 Transaction user field 3. SA300
SAI-TRANS-USER4 Numeric 9 SA100 SA110
Element: Trans User4 Transaction user field 4. SA300
SAI-TRANS-USER5 Signed 18.2 SA100 SA110
Element: Intl Amt Transaction user field 5. SA300
SAI-ORD-DISC-CODE Alpha 4 SA100 SA110
Element: Order DiscountOrder discount code. Used to determine SA300
the order level discount amount.
SAI-DISC-AMT Signed 18.2 SA100 SA110
Element: Intl Amt Order level discount. SA300
SAI-ADDL-DISCOUNT Signed 18.2 SA100 SA110
Element: Intl Amt User-defined additional discount amount SA300
at the invoice level.
SAI-INV-GOODS Signed 18.2 SA100 SA110
Element: Intl Amt Total inventoried goods amount for this SA300
invoice.
SAI-NON-INV-GOODS Signed 18.2 SA100 SA110
Element: Intl Amt Total non-inventoried goods amount for SA300
this invoice.
SAI-MISC-TOTAL Signed 18.2 SA100 SA110
Element: Intl Amt Total of the add-on charges for this SA300
invoice.
SAI-TAX-TOTAL Signed 18.2 SA100 SA110
Element: Intl Amt Total sales tax amount for this invoice. SA300
SAI-DISCOUNTS Derived
Element: Discounts Total discount amount for this invoice
in base currency.
SAI-GROSS-AMOUNT Derived
Element: Gross Amount Total sales amount before discounts for
this invoice in base currency.
SAI-NET-AMOUNT Derived
Element: Net Amount Net sales amount for this invoice in
base currency.
SAI-AMOUNT-DUE Derived
Element: Amount Due Total amount due from the customer for
this invoice in base currency. This is
the invoice net amount less any down
payment made.
SAI-YEAR Numeric 4 SA100 SA110
Element: Last Closed YeContains the fiscal year for the data SA300
stored on this record.
SAI-PERIOD Numeric 2 SA100 SA110
Element: Last Closed PeContains period when booked or actual SA300
sales occurred.
SAI-EP-TYPE Alpha 5 SA100 SA110
Element: Ep Type SA300
SAI-EP-ACCOUNT Alpha 32 SA100 SA110
Element: Ep Account SA300
SAI-EP-EXP-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Ep Exp Date SA300
SAINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SAISET1 COMPANY SA100 SA101
INVC-PREFIX SA110 SA250
INVC-NUMBER SA251 SA253
SA255 SA256
SA258 SA300
SAISET2 COMPANY SALD.1
YEAR
PERIOD
INVC-PREFIX
INVC-NUMBER
SAISET3 COMPANY SA252
CUSTOMER-CODE
CUSTOMER
YEAR
PERIOD
INVC-PREFIX
INVC-NUMBER
SAINVOICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
SAI-COMPANY -> CPY-COMPANY
Arcomp ARCOMP Required
SAI-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
SAI-COMPANY -> ACM-COMPANY
SAI-CUSTOMER -> ACM-CUSTOMER
Carrier APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
SAI-CARRIER -> VEN-VENDOR
Cucodes CUCODES Not Required
SAI-CURRENCY-CODE -> CUC-CURRENCY-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
SAI-CUSTOMER -> CUD-CUSTOMER
Oecustcode OEINVCTYPE Required
SAI-COMPANY -> OIN-COMPANY
SAI-CUSTOMER-CODE -> OIN-INVC-TYPE
Oefrtcode OEFRTCODE Not Required
SAI-COMPANY -> OFR-COMPANY
SAI-FRT-CODE -> OFR-FRT-CODE
Oeinvctype OEINVCTYPE Not Required
SAI-COMPANY -> OIN-COMPANY
SAI-INVC-TYPE -> OIN-INVC-TYPE
Oemethod OEMETHOD Not Required
SAI-COMPANY -> OMT-COMPANY
SAI-METHOD -> OMT-METHOD
Oereason OEREASON Not Required
SAI-COMPANY -> OER-COMPANY
SAI-REASON-CODE -> OER-REASON-CODE
Oesource OESOURCE Not Required
SAI-COMPANY -> OSR-COMPANY
SAI-ORDER-SOURCE -> OSR-ORDER-SOURCE
Sacompany SACOMPANY Required
SAI-COMPANY -> SAC-COMPANY
Shipto SHIPTO Not Required
SAI-COMPANY -> SHP-COMPANY
SAI-CUSTOMER -> SHP-CUSTOMER
SAI-SHIP-TO -> SHP-SHIP-TO
Terms TERMS Not Required
SAI-COMPANY -> TMS-TERMS-CD
SAINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sainvcaoc SAINVCAOC
SAI-COMPANY -> SIA-COMPANY
SAI-INVC-PREFIX -> SIA-INVC-PREFIX
SAI-INVC-NUMBER -> SIA-INVC-NUMBER
Zeroes -> SIA-LINE-NBR
SIA-SEQ
Sainvcline SAINVCLINE
SAI-COMPANY -> SIL-COMPANY
SAI-INVC-PREFIX -> SIL-INVC-PREFIX
SAI-INVC-NUMBER -> SIL-INVC-NUMBER
SIL-LINE-NBR
|
