Menu

Invoice and Orders

Sage 50 Invoice and Order Data Exported

The following is a list of Header and Line record columns optionally exported from the Sage 50 Sales Invoice Ledger, and Sales and Purtchase Order Ledger

Export Fields for Invoice/Order Transaction Header

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

Export Fields for Invoice/Order Transaction Lines

Tag Name

Data Type

Description

uniqueID

Integer

Unique ID for each line record which does not changed Sales Invoice Sales Order Purcahse Order

headerUniqueID

Integer

Unique ID for each header record USE TO RELATE THE TWO FILES RECORDS Sales Invoice Sales Order Purcahse Order

ADD_DISC_RATE

Double

Additional Discount Percentage Rate Sales Invoice Sales Order Purcahse Order

BASE_FULL_NET

Double

Full Net Amount (no discount) Sales Invoice Sales Order Purcahse Order

BASE_NET

Double

Base Net Amount Sales Invoice Sales Order Purcahse Order

BASE_NETVALUE_DISCOUNT

Double

Base Net Value Discount Amount Sales Invoice Sales Order

BASE_TAX

Double

Base Tax Amount Sales Invoice Sales Order Purcahse Order

COMMENT_1

Text 60

Comment 1 Sales Invoice Sales Order Purcahse Order

COMMENT_2

Text 60

Comment 2 Sales Invoice Sales Order Purcahse Order

COST_CODE_ID

Integer

Project Cost Code ID Sales Invoice Sales Order Purcahse Order

DELIVERY_DATE

Date

Delivery Date Sales Invoice Sales Order Purcahse Order

DEPT_NUMBER

Integer

Department Number Sales Invoice Sales Order Purcahse Order

DESCRIPTION

Text 60

Description Sales Invoice Sales Order Purcahse Order

DISCOUNT_AMOUNT

Double

Total Discount Percent on line item Sales Invoice Sales Order Purcahse Order

DISCOUNT_RATE

Double

Discount Rate set on Sales record Sales Invoice Sales Order Purcahse Order

DUE_DATE

Date

Due Date Sales Order Purcahse Order

EXT_ORDER_LINE_REF

Integer

Extra Order Line Reference Sales Invoice Sales Order Purcahse Order

EXT_ORDER_REF

Text 30

Extra Order Reference Sales Invoice Sales Order Purcahse Order

FULL_NET_AMOUNT

Text 8

Full Net Amount (Before Discount) Sales Invoice Sales Order Purcahse Order

FUND_NUMBER

Integer

Fund Number Sales Invoice Sales Order Purcahse Order

INVOICE_NUMBER

Integer

Invoice Number Sales Invoice Sales Order Purcahse Order

IS_NEGATIVE_LINE

Integer

Is item line negative (1 == negative 0 == positive) Sales Invoice

ITEM_NUMBER

Integer

Item Number Sales Invoice Sales Order Purcahse Order

ITEMID

Integer

Unique Identifier, Unaffected By File Maintenance Routines Sales Invoice Sales Order Purcahse Order

JOB_REFERENCE

Text 60

Job Reference (Line Information) Sales Invoice Sales Order Purcahse Order

NET_AMOUNT

Double

Net Amount (After Discount) Sales Invoice Sales Order Purcahse Order

NETVALUE_DISCOUNT

Double

Net Value Discount amount Sales Invoice Sales Order

NETVALUE_DISCOUNT_ALLOCATED

Double

Negotiation Discount allocated Sales Order

NEXT_ITEM

Integer

Record Number of Next Item Sales Invoice Sales Order Purcahse Order

NOMINAL_CODE

Text 8

Nominal Code Sales Invoice Sales Order Purcahse Order

OFFSET

Integer

Offset of Service Text Sales Invoice Sales Order Purcahse Order

PREV_ITEM

Integer

Record Number of Previous Item Sales Invoice Sales Order Purcahse Order

PROJECT_ID

Integer

Project ID Sales Invoice Sales Order Purcahse Order

QTY_ALLOCATED

Double

Quantity Allocated for this Order Sales Invoice Sales Order Purcahse Order

QTY_DELIVERED

Double

Quantity Previously Delivered for this Order Sales Invoice Sales Order Purcahse Order

QTY_DESPATCH

Double

Quantity left to Despatch Sales Invoice Sales Order Purcahse Order

QTY_INTRASTAT_CONFIRMED

Double

Quantity IntraStat Confirmed Sales Invoice Sales Order Purcahse Order

QTY_ORDER

Double

Quantity Ordered Sales Invoice Sales Order Purcahse Order

SERVICE_FILE

Text 60

Redundant - Do Not Use Sales Invoice Sales Order Purcahse Order

SERVICE_FILE_SIZE

Integer

Redundant - Do Not Use Sales Invoice Sales Order Purcahse Order

SERVICE_FLAG

Integer

Service Item Flag Sales Invoice Sales Order Purcahse Order

SERVICE_ITEM_LINES

Integer

Redundant - Do Not Use Sales Invoice Sales Order Purcahse Order

STOCK_CODE

Text 30

Stock Code Sales Invoice Sales Order Purcahse Order

TAX_AMOUNT

Double

Tax Amount Sales Invoice Sales Order Purcahse Order

TAX_CODE

Integer

Tax Code Sales Invoice Sales Order Purcahse Order

TAX_FLAG

Integer

Item VAT Ammended. Sales Invoice Sales Order Purcahse Order

TAX_RATE

Double

Tax Rate Sales Invoice Sales Order Purcahse Order

TEXT

Text 60

Service Invoice/Credit Text Sales Invoice Sales Order Purcahse Order

UNIT_OF_SALE

Text 8

Unit of Sale Sales Invoice Sales Order Purcahse Order

UNIT_PRICE

Double

Unit Price Sales Invoice Sales Order Purcahse Order

QTY_INVOICED

Double

Quantity Invoiced Purcahse Order