|
|
SAINVOICE FILE
SA Invoice
The Sales Analysis Invoice file stores historic information for customer
invoices.
REFERENCED BY
SA250 SA251 SA253 SA255 SA256 SA258
SA252
UPDATED BY
SA100 SA101 SA110 SA300 SA991
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAI-COMPANY Numeric 4 SA100 SA110
Company The company number represents an SA300
established company and is entered on
all function codes.
SAI-INVC-PREFIX Alpha 2 SA100 SA110
Invoice Prefix Contains 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
Invoice 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
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
Shipment Number Contains the shipment number. One SA300 SA991
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
Process Level This field contains the process level, SA300
which is the reporting hierarchy below
company.
SAI-LOCATION Alpha 5 SA100 SA110
Location Contains a valid stock location within SA300
the company inventory.
SAI-INVC-TYPE Alpha 4 SA100 SA110
Invoice Type Invoice type. Must be a valid invoice SA300
type.
SAI-INVOICE-DATE Numeric 8 (yyyymmdd) SA100 SA110
Invoice Date Invoice date. SA300
SAI-INVC-SOURCE Alpha 1 SA100 SA110
Invoice Source Invoice source. This code indicates SA300
where this invoice originated.
SAI-RECUR-INVOICE Alpha 10 SA100 SA110
Recurring Invoice Contains the recurring invoice SA300
identifier.
SAI-BILL-DATE Numeric 8 (yyyymmdd) SA100 SA110
Bill Date Billing date. Only valid for invoices SA300
created from a customer's recurring
invoice.
SAI-DUE-DATE Numeric 8 (yyyymmdd) SA100 SA110
Due Date Invoice due date. Calculated based on SA300
terms code options.
SAI-GL-DATE Numeric 8 (yyyymmdd) SA100 SA110
General Ledger Date Contains the general ledger posting SA300
date.
SAI-SHIP-DATE Numeric 8 (yyyymmdd)
Ship Date Actual shipment date.
SAI-BOOKED-DATE Numeric 8 (yyyymmdd) SA100 SA110
Booked Date Actual booked date. SA300
SAI-TERM-CODE Alpha 5 SA100 SA110
Term 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
Reason Code Contains the reason code, which SA300
indicates the cause for credit memos.
SAI-TERRITORY Alpha 4 SA100 SA110
Territory Sales territory. SA300
SAI-SALESMAN Numeric 4 SA100 SA110
Salesman Contains 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
Salesman 2 Contains the code representing the SA300
second sales representative. This
defaults from the order header.
SAI-COMM-RATE-1 Percent 7.5 (Percent) SA100 SA110
Commission Rate 1 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
Commission Rate 2 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
defaults from the customer file.
SAI-OPR-CODE Alpha 10 (Lower Case) SA100 SA110
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 20 SA100 SA110
Customer Purchase The customer's purchase order number. SA300
Order Number
SAI-LETTER-OF-CR Alpha 20 SA100 SA110
Letter of Credit Contains the letter of credit. SA300
SAI-CURRENCY-CODE Alpha 5 SA100 SA110
Currency Code Billing currency of the original SA300
invoice.
SAI-CUSTOMER-CODE Alpha 4 SA100 SA110
Customer Code Customer code this invoice is SA300
summarized under.
SAI-CURR-RATE Signed 13.6
Currency Rate Currency conversion rate at the time
the invoice was created.
SAI-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Customer Contains the number that represents a SA300
customer.
SAI-SHIP-TO Numeric 4 SA100 SA110
Ship To The customer's ship-to number. SA300
SAI-CC-TYPE Alpha 2 SA100 SA110
Credit Card Type Credit card type. Only present if the SA300
invoice is to be paid via a credit card.
SAI-CC-NUMBER Alpha 17 SA100 SA110
Credit Card Number Credit card number. SA300
SAI-CC-EXP-DATE Numeric 6 SA100 SA110
Credit Card Credit card expiration date. SA300
Expiration Date
SAI-PAYMNT-AMT Signed 15.2 SA100 SA110
Payment Amount Down payment amount. SA300
SAI-ORDER-SOURCE Alpha 2 SA100 SA110
Order Source Order source code. Order sources are SA300
set up in OE52.1 (Order Source).
SAI-FRT-CODE Alpha 2 SA100 SA110
Freight Code Freight code for this invoice. Freight SA300
codes are set up in BL12.1 (Freight
Codes).
SAI-FRT-CHARGE Signed 15.2 SA100 SA110
Freight Charge Freight charges for this invoice. SA300
SAI-CARRIER Alpha 9 SA100 SA110
Carrier The carrier vendor number. Must be SA300
valid in the Lawson Accounts Payable
system.
SAI-METHOD Alpha 10 SA100 SA110
Method Shipping method for this invoice. SA300
Shipping methods are set up in WH11.1
(Shipping Method).
SAI-TRANS-ID Alpha 10 SA100 SA110
Transportation 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
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
User Date 1 User date 1. SA300
SAI-USER-DATE-2 Numeric 8 (yyyymmdd) SA100 SA110
User Date 2 User date 2. SA300
SAI-TRANS-USER1 Alpha 10 SA100 SA110
Transaction User 1 Transaction user field 1. SA300
SAI-TRANS-USER2 Alpha 15 SA100 SA110
Transaction User 2 Transaction user field 2. SA300
SAI-TRANS-USER3 Numeric 8 (yyyymmdd) SA100 SA110
Transaction User 3 Transaction user field 3. SA300
SAI-TRANS-USER4 Numeric 9 SA100 SA110
Transaction User 4 Transaction user field 4. SA300
SAI-TRANS-USER5 Signed 13.2 SA100 SA110
Transaction User 5 Transaction user field 5. SA300
SAI-ORD-DISC-CODE Alpha 4 SA100 SA110
Order Discount Code Order discount code. Used to determine SA300
the order level discount amount.
SAI-DISC-AMT Signed 15.2 SA100 SA110
Discount Amount Order level discount. SA300
SAI-ADDL-DISCOUNT Signed 15.2 SA100 SA110
Additional Discount User-defined additional discount amount SA300
at the invoice level.
SAI-INV-GOODS Signed 15.2 SA100 SA110
Inventory Goods Total inventoried goods amount for this SA300
invoice.
SAI-NON-INV-GOODS Signed 15.2 SA100 SA110
Non-inventory Goods Total non-inventoried goods amount for SA300
this invoice.
SAI-MISC-TOTAL Signed 15.2 SA100 SA110
Miscellaneous Total Total of the add-on charges for this SA300
invoice.
SAI-TAX-TOTAL Signed 15.2 SA100 SA110
Tax Total Total sales tax amount for this invoice. SA300
SAI-DISCOUNTS Derived
Discounts Total discount amount for this invoice
in base currency.
SAI-GROSS-AMOUNT Derived
Gross Amount Total sales amount before discounts for
this invoice in base currency.
SAI-NET-AMOUNT Derived
Net Amount Net sales amount for this invoice in
base currency.
SAI-AMOUNT-DUE Derived
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
Year Contains the fiscal year for the data SA300 SA991
stored on this record.
SAI-PERIOD Numeric 2 SA100 SA110
Period Contains period when booked or actual SA300 SA991
sales occurred.
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
SA991
SAISET2 COMPANY
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
Oecredcard OECREDCARD Not Required
SAI-COMPANY -> OCR-COMPANY
SAI-CC-TYPE -> OCR-CC-TYPE
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
|