|
Tag Name
|
Data Type
|
Description
|
|
headerUniqueID
|
Integer
|
Unique ID for each header record which does not changed Sales Invoice Sales Order Purcahse Order
|
|
transNumber
|
Text 30
|
Unique ID for each line record which does not changed Sales Invoice Sales Order Purcahse Order
|
|
transType
|
Text 30
|
Type SI,SO,SC,SQ etc Sales Invoice Sales Order Purcahse Order
|
|
transOutstanding
|
Text 1
|
If 1 then still being processed in the case of Sales/Purchase orders and not Cancelled. If 1 in Sales Invoice module then not posted to Audit Trail Sales Invoice Purcahse Order
|
|
ordStatus
|
Text 30
|
ZeroAlloc,PartAlloc,FullAlloc,Cancelled,Complete,Held Sales Order Purcahse Order
|
|
ACCOUNT_REF
|
Text 8
|
Account Reference Sales Invoice Sales Order Purcahse Order
|
|
ADDRESS_1
|
Text 60
|
Customer Address 1 Sales Invoice Sales Order Purcahse Order
|
|
ADDRESS_2
|
Text 60
|
Customer Address 2 Sales Invoice Sales Order Purcahse Order
|
|
ADDRESS_3
|
Text 60
|
Customer Address 3 Sales Invoice Sales Order Purcahse Order
|
|
ADDRESS_4
|
Text 60
|
Customer Address 4 Sales Invoice Sales Order Purcahse Order
|
|
ADDRESS_5
|
Text 60
|
Customer Address 5 Sales Invoice Sales Order Purcahse Order
|
|
AMOUNT_PREPAID
|
Double
|
Amount Prepaid Sales Invoice Sales Order Purcahse Order
|
|
ANALYSIS_1
|
Text 30
|
Analysis 1 Sales Invoice Sales Order Purcahse Order
|
|
ANALYSIS_2
|
Text 30
|
Analysis 2 Sales Invoice Sales Order Purcahse Order
|
|
ANALYSIS_3
|
Text 30
|
Analysis 3 Sales Invoice Sales Order Purcahse Order
|
|
COST_CODE_ID
|
Integer
|
Cost Code ID Number Purcahse Order
|
|
BANK_CODE
|
Text 8
|
Bank Posting Code Sales Invoice Sales Order
|
|
BASE_AMOUNT_PAID
|
Double
|
Base Amount Prepaid Sales Invoice Sales Order Purcahse Order
|
|
BASE_CARR_NET
|
Double
|
Base Carriage Net Amount Sales Invoice Sales Order Purcahse Order
|
|
BASE_CARR_TAX
|
Double
|
Base Carriage Tax Amount Sales Invoice Sales Order Purcahse Order
|
|
BASE_NETVALUE_DISCOUNT
|
Double
|
Base Net Value Discount Amount Sales Invoice Sales Order
|
|
BASE_SETT_DISC_RATE
|
Double
|
Base Settlement Discount % Rate Sales Invoice Sales Order Purcahse Order
|
|
BASE_TOT_NET
|
Double
|
Base Net Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
|
|
BASE_TOT_TAX
|
Double
|
Base Tax Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
|
|
CARR_DEPT_NUMBER
|
Integer
|
Carriage Department Number Sales Invoice Sales Order Purcahse Order
|
|
CARR_NET
|
Double
|
Carriage Net Amount Sales Invoice Sales Order Purcahse Order
|
|
CARR_NOM_CODE
|
Text 8
|
Carriage Nominal Code Sales Invoice Sales Order Purcahse Order
|
|
CARR_TAX
|
Double
|
Carriage Tax Amount Sales Invoice Sales Order Purcahse Order
|
|
CARR_TAX_CODE
|
Integer
|
Carriage Tax Code Sales Invoice Sales Order Purcahse Order
|
|
CONSIGNMENT_REF
|
Text 30
|
Consignment Reference Sales Invoice Sales Order Purcahse Order
|
|
CONTACT_NAME
|
Text 30
|
Customer Contact Name Sales Invoice Sales Order Purcahse Order
|
|
COURIER
|
Integer
|
Courier Number Sales Invoice Sales Order Purcahse Order
|
|
CURRENCY
|
Integer
|
Currency Sales Invoice Sales Order Purcahse Order
|
|
CURRENCY_USED
|
Integer
|
Currency Used Sales Invoice Sales Order Purcahse Order
|
|
CUST_DISC_RATE
|
Double
|
Customer Discount Sales Invoice Sales Order
|
|
CUST_ORDER_NUMBER
|
Text 60
|
Customer`s Order Number Sales Invoice Sales Order
|
|
CUST_TEL_NUMBER
|
Text 30
|
Customer`s Telephone Number Sales Invoice Sales Order
|
|
DEF_TAX_CODE
|
Integer
|
Default Tax Code Sales Invoice Sales Order
|
|
DEL_ADDRESS_1
|
Text 60
|
Delivery Address Line 1 Sales Invoice Sales Order Purcahse Order
|
|
DEL_ADDRESS_2
|
Text 60
|
Delivery Address Line 2 Sales Invoice Sales Order Purcahse Order
|
|
DEL_ADDRESS_3
|
Text 60
|
Delivery Address Line 3 Sales Invoice Sales Order Purcahse Order
|
|
DEL_ADDRESS_4
|
Text 60
|
Delivery Address Line 4 Sales Invoice Sales Order Purcahse Order
|
|
DEL_ADDRESS_5
|
Text 60
|
Delivery Address Line 5 Sales Invoice Sales Order Purcahse Order
|
|
DELETED_FLAG
|
Integer
|
Is Deleted Sales Invoice Sales Order Purcahse Order
|
|
DELIVERY_NAME
|
Text 60
|
Delivery Address Name Sales Invoice Sales Order Purcahse Order
|
|
DELIVERY_DATE
|
Date
|
Delivery Date Purcahse Order
|
|
DUE_DATE
|
Date
|
Due Date Purcahse Order
|
|
DESPATCH_DATE
|
Date
|
Despatch Date Sales Order
|
|
DISCOUNT_COMMENT1
|
Text 60
|
Text Field For Additional Comments Sales Invoice Sales Order
|
|
DISCOUNT_COMMENT2
|
Text 60
|
Text Field For Additional Comments Sales Invoice Sales Order
|
|
DISCOUNT_TYPE
|
Integer
|
Discount Type Sales Invoice Sales Order Purcahse Order
|
|
DUNS_NUMBER
|
Text 9
|
Duns Credit Reference Number Sales Invoice Sales Order
|
|
EMAILED
|
Integer
|
Emailed flag - Yes/No Sales Invoice Sales Order Purcahse Order
|
|
EURO_GROSS
|
Double
|
Euro Gross Amount Sales Invoice Sales Order Purcahse Order
|
|
EURO_RATE
|
Double
|
Euro Rate Sales Invoice Sales Order Purcahse Order
|
|
EXTERNAL_USAGE
|
Integer
|
Number of External Usages Sales Invoice Sales Order Purcahse Order
|
|
FIRST_ITEM
|
Integer
|
Record Number of First SOP Item Sales Invoice Sales Order Purcahse Order
|
|
FOREIGN_GROSS
|
Double
|
Foreign Gross Amount Sales Invoice Sales Order
|
|
FOREIGN_RATE
|
Double
|
Foreign Rate for Euro Currency Sales Invoice Sales Order Purcahse Order
|
|
GDN_NUMBER
|
Integer
|
GDN Reference Sales Invoice Purcahse Order
|
|
GLOBAL_DEPT_NUMBER
|
Integer
|
Global Department Number Sales Invoice Sales Order Purcahse Order
|
|
GLOBAL_DETAILS
|
Text 60
|
Global Details Sales Invoice Sales Order
|
|
GLOBAL_NOM_CODE
|
Text 8
|
Global Nominal Code Sales Invoice Sales Order
|
|
GLOBAL_TAX_CODE
|
Integer
|
Global Tax Code Sales Invoice Sales Order
|
|
INVOICE_DATE
|
Date
|
Invoice Date Sales Invoice
|
|
INVOICE_FOREIGN_BALANCE
|
Double
|
Foreign Balance Sales Invoice Sales Order
|
|
INVOICE_NUMBER
|
Text 7
|
Invoice Number Sales Invoice Sales Order
|
|
INVOICE_TYPE_CODE
|
Integer
|
Invoice Type Code Sales Invoice
|
|
ITEMS_NET
|
Double
|
Net Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
|
|
LAST_NETVALUE_DISCOUNT
|
Double
|
Last Net Value Discount amount Sales Invoice Sales Order
|
|
ITEMS_TAX
|
Double
|
Tax Amount (Goods but not carriage) Sales Invoice Sales Order Purcahse Order
|
|
LAST_UPDATED
|
Date
|
Last Updated Date Sales Invoice Sales Order Purcahse Order
|
|
NAME
|
Text 60
|
Customer Account Name Sales Invoice Sales Order Purcahse Order
|
|
NETVALUE_DESCRIPTION
|
Text 60
|
Net Value Discount Description Sales Invoice Sales Order
|
|
NETVALUE_DISCOUNT
|
Double
|
Net Value Discount Amount Sales Invoice Sales Order
|
|
NETVALUE_DISCOUNT_PERCENT
|
Double
|
Net Value Discount Percentage Sales Invoice Sales Order
|
|
NOTES_1
|
Text 60
|
Notes 1 Sales Invoice Sales Order Purcahse Order
|
|
NOTES_2
|
Text 60
|
Notes 2 Sales Invoice Sales Order Purcahse Order
|
|
NOTES_3
|
Text 60
|
Notes 3 Sales Invoice Sales Order Purcahse Order
|
|
ORDER_DATE
|
Date
|
Order Date Sales Order Purcahse Order
|
|
ORDER_NUMBER
|
Integer
|
Order Number Sales Order Purcahse Order
|
|
ORDER_TYPE
|
Integer
|
Order Type Code Sales Order Purcahse Order
|
|
PAYMENT_REF
|
Text 30
|
Payment Reference Sales Invoice Sales Order Purcahse Order
|
|
PAYMENT_TAX_CODE
|
Integer
|
Payment Tax Code Sales Invoice Sales Order
|
|
PAYMENT_TYPE
|
Integer
|
Payment Type (SR/SA) Sales Invoice Sales Order Purcahse Order
|
|
POSTED_CODE
|
Integer
|
Posted Flag - Yes/No Sales Invoice Purcahse Order
|
|
PRACTICE_SOLUTIONS_REFN
|
Text 60
|
Sage Practice Solutions Reference Sales Invoice Sales Order Purcahse Order
|
|
PRINTED_CODE
|
Integer
|
Printed Flag - Yes/No Sales Invoice Sales Order Purcahse Order
|
|
QUOTE_EXPIRY
|
Date
|
The expiry date of the quotation Sales Invoice Sales Order
|
|
QUOTE_STATUS
|
Integer
|
The status of the quotation Sales Invoice Sales Order
|
|
RECORD_CREATE_DATE
|
Date
|
Date and time when the record was created Sales Invoice Sales Order Purcahse Order
|
|
RECORD_DELETED
|
Integer
|
Flag denoting if the record has been deleted Sales Invoice Sales Order Purcahse Order
|
|
RECORD_MODIFY_DATE
|
Date
|
Date and time when the record was modified Sales Invoice Sales Order Purcahse Order
|
|
RECURRING_REFERENCE
|
Text 11
|
Recurring Reference Sales Invoice Sales Order Purcahse Order
|
|
SEND_VIA_EMAIL
|
Integer
|
Flag To Set Sop Output To Email Sales Invoice Sales Order
|
|
SETTLEMENT_DISC_RATE
|
Double
|
Settlement Discount % Rate Sales Invoice Sales Order Purcahse Order
|
|
SETTLEMENT_DUE_DAYS
|
Integer
|
Settlement Days Sales Invoice Sales Order Purcahse Order
|
|
STATUS
|
Integer
|
Order Status Code Sales Order Purcahse Order
|
|
TAKEN_BY
|
Text 60
|
Order Taken By Sales Invoice Sales Order Purcahse Order
|
|
SUPP_DISC_RATE
|
Double
|
Supplier Discount Purcahse Order
|
|
SUPP_ORDER_NUMBER
|
Text 60
|
Supplier`s Order Number Purcahse Order
|
|
SUPP_TEL_NUMBER
|
Text 30
|
Supplier`s Telephone Number Purcahse Order
|