Sage300 ParametersForCustomizingPrintedForms

Sage 300
2016
Parameters for Customizing Printed
Forms
This is a publication of Sage Software, Inc.
Copyright © 2015. Sage Software, Inc. All rights reserved.
Sage, the Sage logos, and the Sage product and service names mentioned herein are registered
trademarks or trademarks of Sage Software, Inc. or its affiliated entities. All other trademarks are
the property of their respective owners.
Business Objects® and the Business Objects logo, BusinessObjects®, and Crystal Reports® are
trademarks or registered trademarks of Business Objects Software Ltd. in the United States and in
other countries. Business Objects is an SAP company.
Microsoft ®SQL Server®, Windows Vista® and the Windows logo are either registered trademarks or
trademarks of Microsoft Corporation in the United States and/or in other countries.
The names of all other products and services are property of their respective owners.
Your use of this document and the Sage product(s) described herein is governed by the terms and
conditions of the Sage End User License Agreement ("EULA") or other agreement that is provided
with or included in the Sage product. Nothing in this document supplements, modifies or amends
those terms and conditions. Except as expressly stated in those terms and conditions, the information
in this document is provided by Sage "AS IS" and Sage disclaims all express, implied or statutory
warranties of any kind, including but not limited to the warranties of merchantability, fitness for a
particular purpose or of non-infringement. No implied license is granted to you under any Sage
intellectual property or trade secret right. Sage reserves the right to revise, supplement or remove
information in this document at any time without notice to you or others.
Sage End User License: http://na.sage.com/sage-na/eula
Last updated: August 29, 2015

From Sage 300 ERP Development Partner Wiki
1 Introduction
2 Default Check Forms
3 Information You Can Include on Customized Forms
4 Fields Available for Checks and Advices
4.1 Database Table BKREG - Bank Check Register Information
4.2 Database Table APADV - Advice Information
4.3 Database Table CSCOM - Company Profile Information (for 1099/CPRS forms)
4.4 Database Table APCCS - Class Code Summary Information (for 1099/CPRS forms)
4.5 Database Table APVEN - Vendor Information(for 1099/CPRS forms, letters, and labels)
5 Fields Available for Letters and Labels
6 Report Parameters and Formula Fields
This document lists the information you can include when developing formats to print invoices, statements, and
mailing labels. For each field, the list includes the code that identifies the field, the maximum number of
characters in the field, and a description of the field.
The check forms installed by Accounts Payable are:
Name Format Maximum Advice Lines

APCHECK.RPT Check-Advice 14
APCHK01.RPT Advice-Check-Advice (11") 18
APCHK02.RPT Advice-Check 14
APCHK03.RPT Check-Advice-Advice 16
APCHK11.RPT Check-Advice-Advice (11") 18
APCHK14.RPT Check-Advice-Check-Advice (14") 18
APCHK01A.RPT Advice-Check-Advice (11") ANSI Compatible 18
APCHK11A.RPT Check-Advice-Advice (11") ANSI Compatible 18
Checks are recorded in the Bank Services module according to the total advice details and number of Advice
Lines Per Page entered in the Bank's Check Stocks tab. If the number of Advice Lines Per Page is less than or
equal to the Maximum Advice Lines, the default forms will print advices capable of containing Advice Lines
Per Page details. If the number of Advice Lines Per Page is greater than the Maximum Advice Lines, the default
forms will print advices capable of containing Maximum Advice Lines details. In the latter case, Bank Services
would record a different number of checks than were printed when the advice details is between the Maximum
Advice Lines and Advice Lines Per Page details.
It is recomended that the number of Advice Lines Per Page entered in the Bank's Check Stocks tab never exceed
the Maximum Advice Lines set in the Check Form.
This section lists the types of information you can include on your printed forms. These lists are not exhaustive;
the next section provides complete listings of fields you can use in your forms.
On a check, you can print:
check number
receipt date
entry description
bank code
vendor number
vendor name
payee name
bank currency code
On a mailing label, you can print:
vendor number
vendor address
vendor name
In a vendor letter, you can print:
company name
company address
company contact
vendor name
vendor address
vendor contact
date
current total
aging totals
period-to-date totals
year-to-date totals
The following table lists the database fields that you can insert in checks and advices without changing the
queries defined in the supplied forms.
Database Table BKREG - Bank Check Register Information
Field Name Length Description

SRCEAPP 2 Source Application (will be "AP")
APPRUNNUM 10 Application Run Number (Batch Number)
BANK 8 Bank Code
SORTCODE 10 Sort Code (Entry Number)
PAYEEID 12 Payee Code (Vendor Number)
SERIAL 4 Serial Number
CHECK 5 Check Number
Check Status
-2=not printed
-1=advice not printed
1=alignment
2=void
STATUS 2
3=outstanding
7=non-negotiable
8=continuation
9=printed
10=posting error
Check Type
1=Check
2=EDI
3=Transfer
CHKTYPE 2
4=Service Charge
5=Credit Card
6=Cash
7=Other
CHKFORM 6 Check Stock Code
PAYEENAME 60 Payee Name
VENDORNAME 60 Vendor Name
REFERENCE 60 Check Reference
COMMENT 60 Check Description
POSTED 5 Date Check Printed
CHKDATE 5 Check Date
ISSUED 10 Check Amount
SISSUED 10 Check Source Amount
RATETYPE 2 Rate Type
SRCECURN 3 Source Currency
RATEDATE 5 Rate Date
RATE 8 Rate
RATESPREAD 8 Rate Spread
Rate Operation
1=multiply
RATEOP 2
2=divide
0=not specified
EXTRA 102 Extra Application Data
LANGUAGE 3 Language Code
ADVICE 5 Advice Lines
FSCYEAR 4 Fiscal Year
FSCPERIOD 2 Fiscal Period
Language Code
5658=english
7092=french
LANGCODE 2
5845=spanish
738=australian
15719=mexican
SDECIMALS 2 Source Currency Decimals
PAYMCODE 12 Payment Code (defined in AP Payment Codes)
Database Table APADV - Advice Information

SRCEAPPL 2 Source Application (will be "AP")
APPLRUNN 10 Application Run Number (Batch Number)
BANKCODE 8 Bank Code
SORTCODE 10 Sort Code (Entry Number)
PAYEECODE 12 Payee Code (Vendor Number)
UNIQCNTR 4 Unique Counter
REFNUM 60 Reference Number (Document Number)
INVCDATE 5 Invoice Date
GROSSAMT 10 Gross Amount
DISCTAKN 10 Discount Taken
NETAMTPD 10 Net Amount Paid
TEXTSTRE1 60 Address Line 1
NAMECITY 30 City
CODESTTE 30 State/Province
CODEPSTL 20 Zip/Postal Code
CODECTRY 30 Country
CURCODE 3 Currency
CURDEC 2 Currency Decimals
GLREF 60 G/L Reference
GLDESC 60 G/L Description
GLACCT 45 G/L Account (misc. payments only)
IDRMITTO 6 Remit-To Location
Database Table CSCOM - Company Profile Information (for 1099/CPRS forms)

ORGID 6 Database ID
CONAME 60 Company Name
ADDR01 60 Address Line 1
CITY 30 City
STATE 30 State/Province
POSTAL 20 Zip/Postal Code
COUNTRY 30 Country
LOCTYPE 6 Location Type
LOCCODE 30 Location Code
PHONEFMT 2 Phone Format
PHONE 30 Phone
FAX 30 Fax Number
CONTACT 60 Contact Name
CNTRYCODE 6 Country Code
BRANCH 6 Branch Code
PERDFSC 2 Number of Fiscal Periods
QTR4PERD 2 Quarter with Four Periods
HOMECUR 3 Functional Currency
Multicurrency Switch
MULTICURSW 2 0=no
1=yes
WARNDAYS 2 Date Spread
EUROCURSW 2 Euro Currency
REPORTCUR 3 Reporting Currency
Locked Fiscal Period Handling
0=None
HNDLCKFSC 2
1=Warning
2=Error
Inactive G/L Account Handling
0=None
HNDINAACCT 2
1=Warning
2=Error
Non-extant G/L Account Handling
0=None
HNDNEXACCT 2
1=Warning
2=Error
Database Table APCCS - Class Code Summary Information (for 1099/CPRS forms)

VENDORID 12 Vendor Number
CLASFCID 6 1099/CPRS Code
CNTYEAR 4 Year
CNTMONTH 2 Month
LSTPYMDATE 5 Last Payment Date
PAYMNTCNT 4 Number of Payments
PAYMNTAMT 10 Payment Amount
WITHHOLDNG 4 Reserved
WITHHLDAMT 10 Reserved
Database Table APVEN - Vendor Information(for 1099/CPRS forms, letters, and labels)

SHORTNAME 10 Short Name
IDGRP 6 Group Code
Status
SWACTV 2 0=inactive
1=active
DATEINAC 5 Inactive Date
DATELASTMN 5 Date Last Maintained
On Hold
SWHOLD 2 0=not on hold
1=on hold
DATESTART 5 Start Date
IDPPNT 12 Participant ID
VENDNAME 60 Vendor Name
NAMECITY 30 City
CODECTRY 30 Country
NAMECTAC 60 Contact Name
TEXTPHON1 30 Phone Number
TEXTPHON2 30 Fax Number
PRIMRMIT 6 Primary Remit-To Location
IDACCTSET 6 Account Set
CURNCODE 3 Currency
BANKID 8 Bank Code
Print Separate Checks
PRTSEPCHKS 2 0=no
1=yes
DISTSETID 6 Distribution Set ID
DISTCODE 6 Distribution Code
GLACCNT 45 G/L Account ID
TERMSCODE 6 Terms
DUPINVCCD 2 Reserved
Duplicate Amount Code
0=none
DUPAMTCODE 2
1=warning
2=error
Duplicate Date Code
0=none
DUPDATECD 2
1=warning
2=error
CODETAXGRP 12 Tax Group
TAXCLASS1 2 Tax Class Code 1
Subject to 1099/CPRS Reporting
0=none
TAXRPTSW 2
1=1099
2=CPRS
SUBJTOWTHH 2 Reserved
TAXNBR 20 1099/CPRS Tax Number
Tax ID Type
0=unknown
1=social security number
TAXIDTYPE 2 2=employer ID number
3=GST Registration Number
4=Business Number
5=Social Insurance Number
TAXNOTE2SW 2 Reserved
CLASID 6 1099/CPRS Class Code
AMTCRLIMT 10 Credit Limit
AMTBALDUET 10 Balance Due in Vendor Currency
AMTBALDUEH 10 Balance Due in Functional Currency
AMTPPDINVT 10 Total Prepaid Invoice Vendor Currency
AMTPPDINVH 10 Total Prepaid Invoice Functional Currency
DTLASTRVAL 5 Date of Last Revaluation
AMTBALLARV 10 Last Revaluation Balance
CNTOPENINV 4 Number of Open Invoices
CNTPPDINVC 4 Number of Prepaid Invoices
CNTINVPAID 4 Number of Paid Invoices
DAYSTOPAY 4 Number of Days to Pay
DATEINVCHI 5 Date of Largest Invoice
DATEBALHI 5 Date of Highest Balance
DATEINVHIL 5 Date of Largest Invoice Last Year
DATEBALHIL 5 Date of Highest Balance Last Year
DATELASTAC 5 Date of Last Activity
DATELASTIV 5 Date of Last Invoice
DATELASTCR 5 Date of Last Credit Note
DATELASTDR 5 Date of Last Debit Note
DATELASTPA 5 Date of Last Payment
DATELASTDI 5 Date of Last Discount
DATELSTADJ 5 Date of Last Adjustment
IDINVCHI 22 Number of Largest Invoice
IDINVCHILY 22 Number of Largest Invoice Last Year
AMTINVHIT 10 Largest Invoice - Vendor Currency
AMTBALHIT 10 Highest Balance - Vendor Currency
AMTINVHILT 10 Larg. Inv. Last Year Vendor Currency
AMTBALHILT 10 High Bal. Last Year - Vendor Currency
AMTWTHLYTC 10 Reserved
AMTLASTIVT 10 Last Invoice Amount - Vendor Currency
AMTLASTCRT 10 Last Cr. Note Amount - Vendor Currency
AMTLASTDRT 10 Last Dr. Note Amount - Vendor Currency
AMTLASTPYT 10 Last Payment - Vendor Currency
AMTLASTDIT 10 Last Discount Amount - Vendor Currency
AMTLASTADT 10 Last Adjustment Amount - Vendor Currency
AMTINVHIH 10 Largest Invoice - Functional Currency
AMTBALHIH 10 Highest Balance - Functional Currency
AMTINVHILH 10 Larg. Inv. Last Year Functional Currency
AMTWTHLYHC 10 Reserved
AMTBALHILH 10 High Bal. Last Year Functional Currency
AMTLASTIVH 10 Last Invoice Amount - Functional Currency
AMTLASTCRH 10 Last Cr. Note Amount - Functional Currency
AMTLASTDRH 10 Last Dr. Note Amount - Functional Currency
AMTLASTPYH 10 Last Payment - Functional Currency
AMTLASTDIH 10 Last Discount Amount - Functional Currency
AMTLASTADH 10 Last Adjustment Amount - Functional Currency
PAYMCODE 12 Payment Code
IDTAXREGI1 20 Tax Registration Code 1
Distribution Type
0=Dist. set
SWDISTBY 2 1=Dist. code
2=G/L account
3=None
CODECHECK 3 Check Language
AVGDAYSPAY 5 Average Days to Pay
AVGPAYMENT 10 Reserved
AMTINVPDHC 10 Total Invoices Paid - Functional Currency
AMTINVPDTC 10 Total Invoices Paid - Vendor Currency
CNTNBRCHKS 4 Total Number of Checks
Tax Included 1
SWTXINC1 2 0=no
1=yes
Tax Included 2
SWTXINC2 2 0=no
1=yes
Tax Included 3
SWTXINC3 2 0=no
1=yes
Tax Included 4
SWTXINC4 2 0=no
1=yes
Tax Included 5
SWTXINC5 2 0=no
1=yes
EMAIL1 50 Contact's E-mail
EMAIL2 50 Vendor's E-mail
WEBSITE 100 Vendor's Web Site
CTACPHONE 30 Contact Phone
CTACFAX 30 Contact Fax
Delivery Method
0=Mail
DELMETHOD 2
1=E-mail
2=Contact's E-mail
RTGPERCENT 5 Default Retainage Percentage
RTGDAYS 2 Default Retention Period
RTGTERMS 6 Default Retainage Terms
RTGAMTTC 10 Outstanding Retainage - Vendor Currency
RTGAMTHC 10 Outstanding Retainage - Functional Currency
VALUES 4 Number of optional fields
NEXTCUID 4 Next Client Unique ID (unique for this vendor)
See the previous database table APVEN (Vendor Information) for a list of the fields you can insert in letters and
labels.
Several pieces of information are passed to the reports through report parameters. These items may be standard
pieces of information about your company - such as the company name - or they may be the data selection
criteria you specified for printing the report. You can insert report parameter information into a report in the
same way you include database field information. To view the report parameters, open the report in Crystal
Reports and choose Parameter Field from the Insert menu.
Formula fields are fields that use other fields, arithmetic operators, and functions to format information or to
compute values, such as a total or average of a column's values. You can insert the formula fields that come
with the report, or you can create your own. To view the existing formula fields, open the report in Crystal
Reports and choose Formula Field from the Insert menu.
Retrieved from "http://dppwiki.sage300erp.com

/wiki/Documentation:Print_Formats_for_Accounts_Payable_Forms"
Categories: Accpac 5.6 | Accpac 6.0 | Accpac 6.1 | Accpac 6.2 | Printed Form Formats
This page was last modified on 10 June 2013, at 17:01.

1 Introduction
2 Default Check Forms
3 Default Statement Forms
4 Default Invoice Forms
5 Default Receipt Form
6 Default Label Forms
7 Information You Can Include on Customized Forms
8 Fields Available for Invoices, Credit Notes, and Debit Notes
8.1 Invoice Header Information (Table ARIBH)
8.2 Invoice Detail Information (Table ARIBD)
8.3 Invoice Detail Comment Information (Table ARIBT)
8.4 Customer Record Information (Table ARCUS)
8.5 Billing Cycle Information (ARRBC)
9 Fields Available for Statements, Letters, and Labels
9.1 ARSTRUN
9.2 ARSTCUS
9.3 ARSTOBL
9.4 ARSTOBP
9.5 ARSTNAT
9.6 ARSLLBL
10 Report Parameters and Formula Fields
This document lists the information you can include when developing formats to print invoices, statements, and
mailing labels. For each field, the list includes the code that identifies the field, the maximum number of
characters in the field, and a description of the field.
The check forms installed are:
Name Format Maximum Advice Lines

ARCHK01.RPT Advice-Check-Advice (11") 18
ARCHK01A.RPT Advice-Check-Advice (11") ANSI Compatible 18
ARCHK11.RPT Check-Advice-Advice (11") 18
ARCHK11A.RPT Check-Advice-Advice (11") ANSI Compatible 18
Checks are recorded in the Bank Services module according to the total advice details and number of Advice
Lines Per Page entered in the Bank's Check Stocks tab. If the number of Advice Lines Per Page is less than or
equal to the Maximum Advice Lines, the default forms will print advices capable of containing Advice Lines
Per Page details. If the number of Advice Lines Per Page is greater than the Maximum Advice Lines, the default
forms will print advices capable of containing Maximum Advice Lines details. In the latter case, Bank Services
would record a different number of checks than were printed when the advice details is between the Maximum
Advice Lines and Advice Lines Per Page details.
It is recomended that the number of Advice Lines Per Page entered in the Bank's Check Stocks tab never
exceed the Maximum Advice Lines set in the Check Form.
The statement forms installed are:
Name Use with Preprinted Forms

ARSTMT10.RPT No
ARSTMT11.RPT No
ARSTMTPRE.RPT Yes
ARSTMT10.RPT and ARSTMT11.RPT print customer, national account and national account member
statements on a laser printer. ARSTMTPRE.RPT has the same features as ARSTMT10.RPT but is formatted for
use with preprinted statements.
The invoice forms installed are:
Name Use with Preprinted Forms Description

ARDINVO.RPT No Invoice for Laser Printers.
ARDOTINV.RPT No Invoice for Dot Matrix Printers.
ARINVPRE.RPT Yes Invoice for Preprinted Laser Printer Forms.
ARINVWWW.RPT No Invoice used with Self Service Customer Account Inquiry.
The receipt form installed is:
Name Use with Preprinted Forms Description

ARRCPT.RPT No Receipt for Laser Printers.
The label forms installed are:
Name Description
ARLABELAVERY5160.RPT Avery standard 5160 address format which prints 3 X 10 labels per page.
ARLABELAVERY5162.RPT Avery standard 5162 address format which prints 2 X 7 labels per page.
Both forms are shared by Statements/Letters/Labels (AR7401) and Labels (AR7402). AR7401 generates data
into table ARSTCUS. AR7402 generates data into table ARSLLBL. There is a COMMAND object in the report
to accommodate the two tables based on UI passed parameters.
This section lists the types of information you can include on your printed forms. These lists are not exhaustive;
the next section provides complete listings of fields you can use in your forms.
On a mailing label, you can print:
customer name
customer address
On a customer invoice, you can print:
date
invoice date
page number
ship-to address
customer number
ship via
customer name
salesperson number
customer address
terms code
customer contact
remit-to address
item description
discount
comments
amount before taxes
quantity
total taxes
unit price
payment received
amount
amount due
On a customer statement, you can print:
date
due date
page number
discount date
customer
discount amount
customer address
check number
customer phone
amount allocated
dunning message
statement total
invoice date
aging totals
invoice number
invoice original amount
year-to-date totals
invoice current amount
In a customer letter, you can print:
company name
date
company address
dunning message
company contact
current total
customer name
aging totals
customer address
customer contact
year-to-date totals
The following tables give the database fields that you can insert in invoices, credit notes, and debit notes without
changing the queries defined in the supplied forms.
Invoice Header Information (Table ARIBH)
The following list shows fields available for header information for both posted and unposted invoices. Note:
You cannot print posted invoices unless you keep history.

CNTBTCH 5 Batch Number
CNTITEM 4 Entry Number
IDCUST 12 Customer Number
IDINVC 22 Document Number
IDSHPT 6 Ship-To Location Code
SHPTOLOC 60 Ship-To Location Name
SHPTOSTE1 60 Ship-To Address Line 1
SHPTOCITY 30 Ship-To City
SHPTOSTTE 30 Ship-To State/Prov.
SHPTOPOST 20 Ship-To Zip/Postal Code
SHPTOCTRY 30 Ship-To Country
SHPTOCTAC 60 Ship-To Contact Name
SHPTOPHON 30 Ship-To Phone Number
SHPTOFAX 30 Ship-To Fax Number
DATERATE 5 Rate Date
Customer/National Account Over Credit
0=neither over credit limit
SWPROCPPD 2 1=customer over credit limit
2=national account over credit limit
3=both over credit limit
AMTDUE 10 Amount Due
CUROPER 2 Currency Code Operator
Printed
SWPRTINVC 2 0=n0
1=yes
SHIPVIACODE 6 Ship Via Code
SHIPVIADESC 60 Ship Via Description
SPECINST 60 Special Instructions
Transaction Type
1=invoice
TEXTTRX 2 2=debit note
3=credit note
4=interest
Transaction Description
11=invoice-item issued
12=invoice-summary entered
13=invoice-recurring
IDTRX 2 14=invoice-summary issued
15=invoice-item entered
21=debit note-item issued
22=debit note-summary issued
24=debit note-summary entered
25=debit note-item entered
31=credit note-item issued
32=credit note-summary entered
34=credit note-summary issued
35=credit note-item entered
40=interest charge
Status
1=entered
INVCSTTS 2
2=printed
3=posted
ORDRNBR 22 Order Number
CUSTPO 22 Purchase Order Number
INVCDESC 60 Invoice Description
INVCAPPLTO 22 Apply-To Document
DATEINVC 5 Invoice Date
DATEASOF 5 Invoice As-Of Date
FISCYR 4 Fiscal Year
FISCPER 2 Fiscal Period
CODECURN 3 Currency Code
Rate Override
SWMANRTE 2 0=no
1=yes
EXCHRATEHC 8 Exchange Rate
ORIGRATEHC 8 Apply-To Exchange Rate
TERMCODE 6 Terms
Override Terms
SWTERMOVRD 2 0=no
1=yes
DATEDUE 5 Due Date
DATEDISC 5 Discount Date
PCTDISC 8 Discount Percentage
AMTDISCAVL 10 Discount Available
LASTLINE 8 Last Line Number
CODESLSP1 8 Salesperson 1
PCTSASPLT1 8 Sales Percentage 1
Taxable
SWTAXBL 2 0=no
1=yes
Do Not Calculate Tax
SWMANTX 2 0=no
1=yes
CODETAX1 12 Tax Authority 1
TAXSTTS1 2 Tax Class 1
BASETAX1 10 Tax Base 1
AMTTAX1 10 Tax Amount 1
AMTTXBL 10 Taxable Amount
AMTNOTTXBL 10 Non-Taxable Amount
AMTTAXTOT 10 Total Tax Amount
AMTINVCTOT 10 Document Total
AMTPPD 10 Prepayment Amount
AMTPAYMTOT 3 Number of Scheduled Payments
AMTPYMSCHD 10 Total Payment Amount Scheduled
AMTNETTOT 10 Document Total Including Tax
DATEPRCS 5 Date Generated
IDPPD 22 Prepayment Number
SWJOB 2 Job Related Entry
ERRBATCH 4 Error Batch
ERRENTRY 4 Error Entry
EMAIL 50 Ship-To E-mail
CTACPHONE 30 Ship-To Contact Phone
CTACFAX 30 Ship-To Contact Fax
CTACEMAIL 50 Ship-To Contact E-mail
AMTDSBWTAX 10 Discount Base if Tax is Included
AMTDSBNTAX 10 Discount Base if Tax is Excluded
AMTDSCBASE 10 Discount Base Used
INVCTYPE 2 Detail Type (Item / Summary)
SWRTGINVC 2 Retainage Invoice Flag (retainage is being invoiced)
RTGAPPLYTO 22 Original Document (set if SWRTGINVC is not 0)
SWRTG 2 Retainage Flag (retainage is being withheld)
RTGAMT 10 Amount Retained
RTGPERCENT 5 Retainage Percentage
RTGDAYS 2 Retention Period (days)
RTGDATEDUE 5 Retainage Due Date
RTGTERMS 5 Terms to use when invoicing the retainage
SWRTGDDTOV 2 Retainage Due Date Override Flag
SWRTGAMTOV 2 Retainage Amount Override Flag
Exchange Rate to use when invoicing the retainage
SWRTGRATE 2 0=Use Original Document's Exchange Rate
1=Use Current Rate
Invoice Detail Information (Table ARIBD)
The following list shows fields available for detail information for both posted and unposted invoices. Note: You
cannot print posted invoices unless you keep history.

ITEMCOST 10 Item Cost
AMTPRIC 10 Price
IDACCTCOGS 45 COGS Account
IDACCTINV 45 Inventory Account
IDACCTREV 45 Revenue Account
TEXTDESC 60 Description
IDDIST 6 Distribution Code
IDINVC 22 Reserved
CNTLINE 3 Line Number
IDITEM 16 Item Number
UNITMEAS 10 Unit of Measure
QTYINVC 10 Quantity
AMTCOST 10 Cost
AMTEXTN 10 Extended Amount
AMTCOGS 10 COGS (Cost of Goods Sold) Amount
AMTTXBL 10 Taxable Amount
TOTTAX 10 Tax Amount
SWMANLTX 2 Reserved
SWTAXINCL1 2 Tax Included 1
RATETAX1 8 Tax Rate 1
IDJOBPROJ 30 Reserved
COMMENT 250 Comments
Print Comment
SWPRTSTMT 2 0=no
1=yes
ITEMCOST 10 Item Cost
CONTRACT 16 Contract ID
PROJECT 16 Project ID
CATEGORY 16 Category ID
RESOURCE 24 Project/Category Resource
TRANSNBR 4 Transaction Number
COSTCLASS 2 Cost Classification
BILLDATE 5 Billing Date
SWIBT 2 Comments Flag (not 0 if attached comment in ARIBT)
SWDISCABLE 2 Discountable Flag
OCNTLINE 3 Original Document's Line Number (see AROBLJ)
RTGAMT 10 Amount Retained
RTGPERCENT 5 Retainage Percentage
RTGDAYS 2 Retention Period (days)
SWRTGDDTOV 2 Retainage Due Date Override Flag
SWRTGAMTOV 2 Retainage Amount Override Flag
Invoice Detail Comment Information (Table ARIBT)
The following list shows additional comment information fields for unposted invoices.

CNTLINE 3 Line Number
TEXTLINE 250 Comments
Print Comment
SWPRTSTM 2 0=no
1=yes
Customer Record Information (Table ARCUS)

TEXTSNAM 10 Short Name
IDGRP 6 Group Code
IDNATACCT 12 National Account
Status
SWACTV 2 0=inactive
1=active
On Hold
SWHOLD 2 0=no
1=yes
IDPPNT 12 Reserved
CODEDAB 9 Credit Bureau Number
CODEDABRTG 5 Credit Bureau Rating
DATEDAB 5 Credit Bureau Date
NAMECUST 60 Customer Name
NAMECITY 30 City
CODECTRY 30 Country
TEXTPHON1 30 Telephone Number
CODETERR 6 Territory Code
IDAUTOCASH 6 Autocash Profile (not used)
IDBILLCYCL 6 Billing Cycle
IDSVCCHRG 6 Interest Profile
IDDLNQ 6 Reserved
CODECURN 3 Currency
Print Statements
SWPRTSTMT 2 0=no
1=yes
SWPRTDLNQ 2 Reserved
Account Type
SWBALFWD 2 0=open item
1=balance forward
CODETERM 6 Terms
IDRATETYPE 2 Rate Type
IDTAXREGI1 20 Tax Registration Number 1
TAXSTTS1 2 Tax Class Code 1
AMTBALDUET 10 Balance Due in Customer Currency
AMTBALDUEH 10 Balance Due in Functional Currency
DATELASTST 5 Date of Last Statement
AMTLASTSTT 10 Last Statement Total in Customer Currency
AMTLASTSTH 10 Reserved
DTBEGBALFW 5 Date of Last Balance Forward Statement
AMTBALFWDT 10 Beginning Balance on Last Statement
AMTBALFWDH 10 Reserved
CNTOPENINV 4 Number of Open Documents
DATEINVHIL 5 Date of Largest Invoice Last Year
DATEBALHIL 5 Date of Highest Balance Last Year
DATELASTPA 5 Date of Last Payment
DATELASTAD 5 Date of Last Adjustment
DATELASTWR 5 Date of Last Write-Off
DATELASTRI 5 Date of Last Returned Check
DATELASTIN 5 Date of Last Interest Charge
IDINVCHI 22 Largest Invoice Number
IDINVCHILY 22 Largest Invoice Number Last Year
AMTINVHIT 10 Largest Invoice - Customer Currency
AMTBALHIT 10 Highest Balance - Customer Currency
AMTINVHILT 10 Largest Invoice Last Year - Customer Currency
AMTBALHILT 10 Highest Balance Last Year - Customer Currency
AMTLASTIVT 10 Last Invoice Amount - Customer Currency
AMTLASTCRT 10 Last Credit Note Amount - Customer Currency
AMTLASTDRT 10 Last Debit Note Amount - Customer Currency
AMTLASTPYT 10 Last Payment - Customer Currency
AMTLASTDIT 10 Last Discount Amount - Customer Currency
AMTLASTADT 10 Last Adjustment Amount - Customer Currency
AMTLASTWRT 10 Last Write-Off Amount - Customer Currency
AMTLASTRIT 10 Last Returned Check Amount - Customer Currency
AMTLASTINT 10 Last Interest Charge - Customer Currency
AMTINVHIH 10 Largest Invoice - Functional Currency
AMTBALHIH 10 Highest Balance - Functional Currency
AMTINVHILH 10 Largest Invoice Last Year - Functional Currency
AMTBALHILH 10 Highest Balance Last Year - Functional Currency
AMTLASTIVH 10 Last Invoice Amount - Functional Currency
AMTLASTCRH 10 Last Credit Note Amount - Functional Currency
AMTLASTDRH 10 Last Debit Note Amount - Functional Currency
AMTLASTPYH 10 Last Payment - Functional Currency
AMTLASTDIH 10 Last Discount Amount - Functional Currency
AMTLASTADH 10 Last Adjustment Amount - Functional Currency
AMTLASTWRH 10 Last Write-Off Amount - Functional Currency
AMTLASTRIH 10 Last Returned Check Amount - Functional Currency
AMTLASTINH 10 Last Interest Charge - Functional Currency
PRICLIST 6 Customer Price List
Customer Discount Type
0=base
1=a
CUSTTYPE 2 2=b
3=c
4=d
5=e
AMTPDUE 10 Amount Past Due
EMAIL2 50 Customer's E-mail
WEBSITE 100 Customer's Web site
BILLMETHOD 2 Reserved
CCNUMBER 30 Reserved
CCEXP 5 Reserved
CCNAME 50 Reserved
CCPAYMTYP 6 Receipt Type
FOB 60 Free On Board
SHIPVIACODE 6 Ship Via Code
SHIPVIADESC 60 Ship Via Description
DELMETHOD 2 Delivery Method
PRIMSHIPTO 6 Primary Ship-To Location
CTACPHONE 30 Contact Phone
CTACFAX 30 Contact Fax
Allow Partial Shipments
SWPARTSHIP 2 0=No
1=Yes
Allow Web Store Shopping
SWWEBSHOP 2 0=No
1=Yes
RTGPERCENT 5 Default Retainage Percentage
RTGDAYS 2 Default Retention Period
RTGTERMS 6 Default Retainage Terms
RTGAMTTC 10 Outstanding Retainage - Customer Currency
RTGAMTHC 10 Outstanding Retainage - Functional Currency
CNTPPDINVC 4 Number of Open Prepayments
AMTPPDINVT 10 Total of Open Prepayments - Customer Currency
AMTPPDINVH 10 Total of Open Prepayments - Functional Currency
Billing Cycle Information (ARRBC)

IDCYCL 6 Billing Cycle Code
Status
ACTVSW 2 0=inactive
1=active
LASTMNTN 5 Date Last Maintained
LASTSTMT 5 Date Statements Last Printed
LASTINTT 5 Date Interest Invoices Last Posted
LASTSTD 5 Date Recurring Charges Last Posted
DAYSCYCL 2 Billing Cycle Frequency
NAME 60 Remit-To Name
STREET1 60 Remit -To Address 1
CITY 30 Remit -To City
STATE 30 Remit -To State
POSTCODE 20 Remit -To Postal Code
CNTYCODE 30 Remit -To Country
Statements are produced from the following 5 tables:
ARSTRUN
ARSTCUS
ARSTNAT
ARSTOBL
ARSTOBP
Letters are produced from the ARSTCUS table only. While labels can be produced from either the ARSTCUS
table or the ARSLLBL table. Fields in each table are described in detail below.
ARSTRUN

STMTSEQ 4 Statement Run No.
STMTDATE 5 Statement Run Date
Statement Run Completed Flag
SWFINISH 2 0=No
1=Yes
DATECUTOFF 5 Cutoff Date
Due Date / Invoice Date
SWINVCDATE 2 0=Due Date
1=Doc Date
Include Debit Balances
SWDEBIT 2 0=No
1=Yes
Include Credit Balances
SWCREDIT 2 0=No
1=Yes
Include Zero Balances
SWZEROBAL 2 0=No
1=Yes
Include Fully Paid Transactions
SWINCLPAID 2 0=No
1=Yes
Include Details
SWDETAIL 2 0=Summary
1=Detail
Run Type
SWTYPERUN 2 0=Customer Statements
1=National Acct. Statements
Detail Sort
SWDTLSRTBY 2 0=Doc No.
1=Doc Date
IDDUNNING 8 Dunning Message Code
IDFROM1 60 Range 1 From
IDTO1 60 Range 1 To
INDEX1 2 Range 1 Type
IDTO2 60 Range 2 To
IDTO3 60 Range 3 To
IDTO4 60 Range 4 To
RPTNAME 255 Report Name
Delivery Method
DELMETHOD 2 1=Customer
0=Print Destination
SORTINDEX1 2 Sort field 1
AGEPERIOD1 3 Current Period
AGEPERIOD2 3 First Period
AGEPERIOD3 3 Second Period
AGEPERIOD4 3 Third Period
ARSTCUS

IDCUST 12 Customer No.
Statement Printed Flag
SWPRINTED 2 0-No
1=Yes
NAT Statement Switch
SWNATSTMT 2 0=Customer Statements
1=National Acct. Statements
2=Letters or Labels
IDNATACCT 12 National Account Number
IDGRP 6 Group Code
Status
SWACTV 2 0=Inactive
1=Active
On Hold
SWHOLD 2 0=No
1= No
IDPPNT 12 Reserved
NAMECITY 30 City
CODESTTE 30 State/Prov.
CODECTRY 30 Country
IDAUTOCASH 6 Autocash Profile
IDDLNQ 6 Reserved
Print Statements
SWPRTSTMT 2 0=No
1=Yes
Account Type
SWBALFWD 2 0=Open Item
1=Balance Forward
CODETERM 6 Terms
IDTAXREGI1 20 Tax Registration No. 1
AMTCRLIMT 10 Credit Limit (Cust. Currency)
AMTBALDUET 10 Balance Due in Cust. Currency
AMTBALDUEH 10 Balance Due in Func. Currency
AMTLASTSTT 10 Last Statement Total Cust. Currency
DTBEGBALFW 5 Date of Last Bal. Fwd. Statement
AMTBALFWDT 10 Beginning Bal. on Last Statement
DATEINVHIL 5 Date of Largest Invoice Last Yr.
DATEBALHIL 5 Date of Highest Balance Last Yr.
DATELASTPA 5 Date of Last Receipt
DATELASTDQ 5 Reserved
IDINVCHILY 22 Largest Invoice Number Last Yr.
AMTINVHIT 10 Largest Invoice - Cust. Currency
AMTBALHIT 10 Highest Balance - Cust. Currency
AMTINVHILT 10 Lgst. Inv. Last Yr. Cust. Currency
AMTBALHILT 10 High Bal. Last Yr. - Cust. Currency
AMTLASTIVT 10 Last Invoice Amt. - Cust. Currency
AMTLASTCRT 10 Last Cr. Note Amt. - Cust. Currency
AMTLASTDRT 10 Last Dr. Note Amt. - Cust. Currency
AMTLASTPYT 10 Last Receipt - Cust. Currency
AMTLASTDIT 10 Last Discount Amt. - Cust. Currency
AMTLASTADT 10 Last Adj. Amt. - Cust. Currency
AMTLASTWRT 10 Last Write-Off Amt. Cust. Currency
AMTLASTRIT 10 Last Ret'd. Chk. Amt. Cust. Currency
AMTLASTINT 10 Last Int. Charge - Cust. Currency
AMTINVHIH 10 Largest Invoice - Func. Currency
AMTBALHIH 10 Highest Balance - Func. Currency
AMTINVHILH 10 Lgst. Inv. Last Yr. Func. Currency
AMTBALHILH 10 High Bal. Last Yr. - Func. Currency
AMTLASTIVH 10 Last Invoice Amt. - Func. Currency
AMTLASTCRH 10 Last Cr. Note Amt. - Func. Currency
AMTLASTDRH 10 Last Dr. Note Amt. - Func. Currency
AMTLASTPYH 10 Last Receipt - Func. Currency
AMTLASTDIH 10 Last Discount Amt. - Func. Currency
AMTLASTADH 10 Last Adj. Amt. - Func. Currency
AMTLASTWRH 10 Last Write-Off Amt. Func. Currency
AMTLASTRIH 10 Last Ret'd. Chk. Amt. Func. Currency
AMTLASTINH 10 Last Int. Charge - Func. Currency
PCTSASPLT1 5 Sales-Split Percentage 1
Customer Discount Type
0=Base
1=A
CUSTTYPE 2 2=B
3=C
4=D
5=E
TEXTSTMT 45 Dunning Message
WEBSITE 100 Web Site
Delivery Method
0=Mail
DELMETHOD 2
2=E-mail
4=Contact's E-mail
CTACPHONE 30 Contact's Phone
CTACFAX 30 Contact's Fax
Allow Partial Shipments
SWPARTSHIP 2 0=No
1=Yes
HAMTBGNBLF 10 HDR Amount Beginning Balance For
HAMTEBALFD 10 HDR Amount Ending Balance Forward
HAMTSTMTBL 10 HDR Amount Statement Balance
HAMTDUECUR 10 HDR Amount Due Current Period
HAMTDUEAG1 10 HDR Amount Due 1st Period
HAMTDUEAG2 10 HDR Amount Due 2nd Period
HAMTDUEAG3 10 HDR Amount Due 3rd Period
HAMTDUEAG4 10 HDR Amount Due 4th Period
HAMTDUEFWD 10 HDR Amount Due Forward Balance
RBCNAME 60 Remit-To Name
RBCSTREET1 60 Remit-To Address 1
RBCCITY 30 Remit-To City
RBCSTATE 30 Remit-To State/Prov.
RBCPSTCDE 20 Remit-To Zip/Postal Code
RBCCNTYCDE 30 Remit-To Country
CUSDECIMAL 2 Customer Currency Decimal
CURSYMBOL 4 Customer Currency Symbol
ARSTOBL

CODE 1 RESERVED - Code
RECTYPE 1 RESERVED - Record Type
IDRMIT 24 Check/Receipt No.
IDCUSTPO 22 Purchase Order Number
IDORDERNBR 22 Order Number
DATEINVC 5 Document Date
DATEDUE 5 Due Date
DESCINVC 60 Document Description
TRXTYPETXT 2 Document Type
TRXTYPEID 2 Transaction Type
AMTDUE 10 Amount Due
AMTDISC 10 Discount Amount
IDCUSTSHPT 6 Ship-To Location
CODETERM 6 Terms
DATELASTST 5 Last Statement Date
ARSTOBP

CNTSEQ 4 Sequence No.
IDRMIT 24 Check/Receipt No.
DATEBUS 5 Business Date
TRANSTYPE 2 Document Type
AMTPAYMTC 10 Cust. Receipt Amount
TRXTYPE 2 Transaction Type
IDMEMOXREF 22 Reference Document No.
ARSTNAT

IDNATACCT 12 National Account Number
Statement Printed Flag
SWPRINTED 2 0=No
1=Yes
NAMEACCT 60 National Account Name
TEXTSTRE1 60 NAT Address Line 1
NAMECITY 30 NAT City
CODESTATE 30 NAT State/Prov.
CODEPOST 20 NAT Zip/Postal Code
CODECTRY 30 NAT Country
NAMECTAC 60 NAT Contact Name
TEXTPHON1 30 NAT Phone Number
TEXTPHON2 30 NAT Fax Number
TEXTSTMT 45 NAT Dunning Message
EMAIL 50 E-mail
WEBSITE 100 National Account's Web Site
CTACPHONE 30 Contact's Phone
CTACFAX 30 Contact's Fax
CTACEMAIL 50 Contact's E-mail
SWBALFWD 2 Account Type
AMTBGNBLF 10 NAT Amount Beginning Balance Forward
AMTEBALFD 10 NAT Amount Ending Balance Forward
AMTSTMTBL 10 NAT Amount Statement Balance
AMTDUECUR 10 NAT Amount Due Current Period
AMTDUEAG1 10 NAT Amount Due 1st Period
AMTDUEAG2 10 NAT Amount Due 2nd Period
AMTDUEAG3 10 NAT Amount Due 3rd Period
AMTDUEAG4 10 NAT Amount Due 4th Period
AMTDUEFWD 10 NAT Amount Due Forward Balance
ARSLLBL

SELSEQ 4 Sequence Number
IIDSHIPTO 6 Ship-To Location
INSTANCE 4 Instance Number
NAMECITY 30 City
CODESTTE 30 State/Prov.
CODECTRY 30 Country
Several pieces of information are passed to the reports through report parameters. These items may be standard
pieces of information about your company - such as the company name - or they may be the data selection
criteria you specified for printing the report. You can insert report parameter information into a report in the
same way you include database field information. To view the report parameters, open the report in Crystal
Reports and choose Parameter Field from the Insert menu.
Formula fields are fields that use other fields, arithmetic operators, and functions to format information or to
compute values, such as a total or average of a column's values. You can insert the formula fields that come with
the report, or you can create your own. To view the existing formula fields, open the report in Crystal Reports
and choose Formula Field from the Insert menu.

/wiki/Documentation:Print_Formats_for_Accounts_Receivable_Forms"

This document lists the information you can include when developing formats to print bin/shelf labels and item
labels. For each field, the list includes the code that identifies the field, the maximum number of characters in
the field, and a description of the field.
For information on using Crystal Reports to customize forms, refer to the online document, "Customizing
Printed Forms with Crystal Reports."
The following table lists the fields that you can place on either bin/shelf labels and item labels:
Item Number Fields

ITEMNO 24 Unformatted Item Number
ALTSET 4 Alternate Item Set Number
DESC 60 Description
INACTIVE 2 Status
ITEMBRKID 6 Structure Code
FMTITEMNO 24 Item Number
CATEGORY 6 Category
CNTLACCT 6 Account Set Code
STOCKITEM 2 Stock Item
STOCKUNIT 10 Stocking Unit of Measure
DEFPRICLST 6 Default Price List Code
UNITWGT 10 Unit Weight
PICKINGSEQ 10 Default Picking Sequence
SERIALNO 2 Serial Numbers
COMMODIM 16 Commodity Number
DATEINACTV 5 Date Inactive
SEGMENT1 24 Segment 1
COMMENT1 80 Comment 1
ALLOWONWEB 2 Item can be ordered from Web
KITTING 2 Kitting Item
VALUES 4 Optional Fields
DEFKITNO 6 Default Kit Number
SELLABLE 2 Sellable
WEIGHTUNIT 10 Weight Unit of Measure
SERIALMASK 6 Serial Number Mask
NEXTSERFMT 40 Next Formatted Serial
SUSEEXPDAY 2 Use Serials Days to Expire
SEXPDAYS 2 Serials Days to Expire
SDIFQTYOK 2 Allow Different Serial Qty
SVALUES 2 Serials Optional Fields
SWARYCODE 6 Default Serial Warranty Code
SCONTCODE 6 Default Serial Contract Code
SCONTRECE 2 Serial is on Cont. When Received
SWARYSOLD 2 Serial is on Warr.When Sold
SWARYREG 2 Serial is on Warr. When Registered
LOTITEM 2 Lot Numbers
LOTMASK 6 Lot Number Mask
NEXTLOTFMT 40 Next Formatted Lot
LUSEEXPDAY 2 Use Lots Days to Expire
LEXPDAYS 2 Lots Days to Expire
LUSEQRNDAY 2 Use Lots Days on Quarantine
LQRNDAYS 2 Lots Days on Quarantine
LDIFQTYOK 2 Allow Different Lot Qty
LVALUES 4 Lots Optional Fields
LWARYCODE 6 Default Lot Warranty Code
LCONTCODE 6 Default Lot Contract Code
LCONTRECE 2 Lot is on Cont. When Received
LWARYSOLD 2 Lot is on Warr. When Sold
Item Location Fields

ITEMNO 24 Item Number
LOCATION 6 Location
PICKINGSEQ 10 Picking Sequence
ACTIVE 2 Allowed
DATEACTIVE 5 Date Location Activated
USED 2 In Use
LASTUSED 5 Date Last Used
QTYONHAND 10 Quantity on Hand (Last Day End)
QTYONORDER 10 Quantity on P/O
QTYSALORDR 10 Quantity on S/O
QTYOFFSET 10 Quantity Not in Cost File
QTYSHNOCST 10 Quantity Shipped Not Costed
QTYRENOCST 10 Quantity Received Not Costed
QTYADNOCST 10 Quantity Adjusted Not Costed
NUMNOCST 4 Number of Uncosted Transactions
TOTALCOST 10 Total Cost
COSTOFFSET 10 Cost Not in Cost File
COSTUNIT 10 Cost Unit of Measure
COSTCONV 10 Cost Unit Conversion Factor
STDCOST 10 Standard Cost
LASTSTDCST 10 Last Standard Cost
LASTSTDDAT 5 Last Standard Cost Date
LASTSHIPDT 5 Last Shipment Date
DAYSTOSHIP 10 Average Days To Ship
UNITSSHIP 10 Average Units Shipped
SHIPMENTS 2 Shipments Used In Calculation
LASTRCPTDT 5 Last Receipt Date
RECENTCOST 10 Most Recent Cost
COST1 10 User Defined Cost 1
COST2 10 User Defined Cost 2
LASTCOST 10 Last Unit Cost
QTYCOMMIT 10 Quantity Committed
Item Categories Fields

CATEGORY 6 Category Code
DESC 60 Description
COGSACCT 45 Cost of Goods Sold Account
REVENUACCT 45 Sales Account
RETURNACCT 45 Returns Account
VARIANACCT 45 Cost Variance Account
COMMSNPAID 2 Commission Paid
COMMSNRATE 5 Commission Rate
INACTIVE 2 Status
DAMAGEACCT 45 Damaged Goods Account
Item Segments Fields

SEGMENT 2 Segment Number
DESC 60 Description
LENGTH 2 Length
VALIDATE 2 Validate
Segment Codes Fields

SEGMENT 2 Segment Number
SEGVAL 24 Segment Code
DESC 60 Description
Options Fields

PHONE 30 Phone Number
FAX 30 Fax Number
FRACTQTY 2 Fractional Quantities
NEGQTY 2 Allow Negative Quantities
TRANSHIST 2 Keep Transaction History
JOBCOST 2 Interface With Job Cost
REFCHOICE 2 G/L Reference Field
DESCCHOICE 2 G/L Description Field
COST1NAME 10 Cost 1 Name
COST2NAME 10 Cost 2 Name
DAYEND 2 Day End Transactions Outstanding
TRANSNUM 10 Next Transaction Number
NXTALTSET 4 Next Alternate Item Set Number
GLDAYEND 4 G/L Trans Created Thru Day End
ADJENSEQ 4 Next Adjustment Entry Seq.
ASSMENSEQ 4 Next Assembly Entry Seq.
RECENSEQ 4 Next Receipt Entry Seq.
SHIPENSEQ 4 Next Shipment Entry Seq.
TRANFENSEQ 4 Next Transfer Entry Seq.
HISTENSEQ 4 Next History Entry Seq.
DAYENDSEQ 4 Next Day End Posting Seq.
MULTICURR 2 Multicurrency
DEFERGLPST 2 Deferred G/L Posting
APPENDGL 2 Append To G/L Batch
CONSOLGL 2 Consolidate G/L Batch
STATCALNDR 2 Statistics Calendar
STATPRD 2 Statistics Period
STATEDIT 2 Edit Statistics
CRTITEMLOC 2 Allow Items at All Locations
ADDCSTTYPE 2 Add'l. Cost on Rcpt. Returns
RATETYPE 2 Default Rate Type
ITEMBRKID 6 Default Item Structure
STATACCUM 2 Accumulate Item Statistics
PSTTOCLOSD 2 Post To Closed Fiscal Periods
HYHEN 2 Use Hyhen as Item Separator
FWDSLASH 2 Use Forward Slash as Item Separator
BCKSLASH 2 Use Back Slash as Item Separator
ASTERISK 2 Use Asterisk as Item Separator
PERIOD 2 Use Period as Item Separator
LFTPARENS 2 Use Left Parenthesis as Item Separator
RGTPARENS 2 Use Right Parenthesis as Item Separator
POUNDSGN 2 Use Pound Sign as Item Separator
RECNONSTK 2 Allow Receipt of Non-stock Items
DELPROMPT 2 Prompt to Delete during Posting
COSTDURING 2 Cost During
ASSNUMBERL 2 Assembly Number Lengt
ASSPREFIXD 6 Assembly Number Prefix
ASSBODYD 22 Next Assembly Number
DASNUMBERL 2 Disassembly Number Length
DASPREFIXD 6 Disassembly Number Prefix
DASBODYD 22 Next Disassembly Number
TRFNUMBERL 2 Transfer Number Length
TRFPREFIXD 6 Transfer Number Prefix
TRFBODYD 22 Next Transfer Number
ADJNUMBERL 2 Adjustment Number Length
ADJPREFIXD 6 Adjustment Number Prefix
ADJBODYD 22 Next Adjustment Number
SHPNUMBERL 2 Shipment Number Lengt
SHPPREFIXD 6 Shipment Number Prefix
SHPBODYD 22 Next Shipment Number
SRTNUMBERL 2 Shipment Return Number Length
SRTPREFIXD 6 Shipment Return Number Prefix
SRTBODYD 22 Next Shipment Return
RCPNUMBERL 2 Receipt Number Length
RCPPREFIXD 6 Receipt Number Prefix
RCPBODYD 22 Next Receipt Number
TRCNUMBERL 2 Transit Receipt Number Length
TRCPREFIXD 6 Transit Receipt Number Prefix
TRCBODYD 22 Next Transit Receipt
RECDESEQ 4 Next Non-costed Receipt Day End Sequence
GITLOC 6 Default Goods in Transit Location
Item Pricing Fields

CURRENCY 3 Currency Code
PRICELIST 6 Price List Code
DESC 60 Description
PRICEDECS 2 Decimals in Price
MARKUPCOST 10 Markup Cost
MARKUPUNIT 10 Markup Unit of Measure
MARKUPCONV 10 Markup Conversion Factor
PRICETYPE 2 Selling Price Based on
PRICEFMT 2 Discount/Markup Price by
PRCNTLVL1 5 Discount/Markup Percentage 1
PRICEBASE 2 Price Determined by
PRICEQTY1 10 Quantity Level 1
MARKUP 5 Markup Factor
LASTMKPDT 5 Last Markup Cost Change Date
PREVMKPCST 10 Previous Markup Cost
LASTEXCHDT 5 Last Exchange Rate Change Date
PREVEXCHRT 8 Previous Exchange Rate
ROUNDMETHD 2 Rounding Method
ROUNDAMT 10 Round to a Multiple of
AMOUNTLVL1 10 Discount/Markup Amount 1
PRICEBY 2 Price By
MRKUPWUNIT 10 Markup Weight Unit of Measure
PRICEWGHT1 10 Weight Level 1
CPRICETYPE 2 Price Check Type
CCHECK 2 Check
CCHECKBASE 2 Check Base
CBASE 2 Cost/Margin Base
DEFBUNIT 10 Default Base Unit
DEFBWUNIT 10 Default Base Weight Unit
DEFSUNIT 10 Default Sale Unit
DEFSWUNIT 10 Default Sale Weight Unit
BPRICETYPE 2 Base Price Type
BDEFUSING 2 Default Base Price Using
BLOCATION 6 Base Location
BBASE 2 Base Cost Base
BPERCENT 5 Base Percentage
BAMOUNT 10 Base Amount
BRATETYPE 2 Base Rate Type
BRATEDATE 5 Base Rate Date
BEXCHRATE 8 Base Exchange Rate
BRATEOP 2 Base Rate Operator
BRATEOVRRD 2 Base Rate Overidden
SPRICETYPE 2 Sale Price Type
SDEFUSING 2 Default Sale Price Using
SLOCATION 6 Sale Location
SBASE 2 Sale Cost Base
SPERCENT 5 Sale Percentage
SAMOUNT 10 Sale Amount
SRATETYPE 2 Sale Rate Type
SRATEDATE 5 Sale Rate Date
SEXCHRATE 8 Sale Exchange Rate
SRATEOP 2 Sale Rate Operator
SRATEOVRRD 2 Sale Rate Overidden
Item Pricing Details Fields

DPRICETYPE 2 Price Detail Type
QTYUNIT 10 Quantity Unit
WEIGHTUNIT 10 Weight Unit
UNITPRICE 10 Unit Price
CONVERSION 10 Conversion Factor
SALESTART 5 Sale Start Date
SALEEND 5 Sale End Date
LASTPRICDT 5 Last Price Change Date
PREVPRICE 10 Previous Price
Item Vendor Detail Fields

VENDTYPE 2 Vendor Type
VENDNUM 12 Vendor Number
VENDNAME 60 Vendor Name
VENDITEM 24 Vendor Item Number
VENDCONT 60 Vendor Contact
VENDCNCY 3 Vendor Currency
VENDCOST 10 Vendor Cost
VENDEXISTS 2 Vendor Exists
FACTOR 10 Cost Unit Conv. Factor
COSTUNIT 10 Cost Unit
Item Labels Fields

RECPNUM 22 Receipt Number
SEQNUM 4 Sequence Number
LINENO 2 Line Number
LOCATION 6 Location
NUMLABELS 2 Number of Labels
PRINTED 2 Printed
Item Optional Fields

OPTFIELD 12 Optional Field
VALUE 60 Value
TYPE 2 Type
LENGTH 2 Length
DECIMALS 2 Decimals
ALLOWNULL 2 Allow Blank
VALIDATE 2 Validate
Kitting Items Fields

KITNO 6 Kitting Number
DESC 60 Description
REMARK 80 Comments
Kitting Items Components Fields

ITEMNO 24 Unformatted Item Numb
KITNO 6 Kitting Number
LINENO 2 Line Number
COMPONENT 24 Component Item Number
QTY 10 Quantity
UNIT 10 Unit of Measure
UNITCOST 10 Unit Cost
/wiki/Documentation:Print_Formats_for_Inventory_Control_Forms"

1 Introduction
2 Order Confirmations/Quotes/Picking Slips/Shipping Labels
3 Invoices
4 Credit/Debit Notes
This document lists the information you can include when developing formats to print order confirmations,
quotes, picking slips, shipping labels, invoices, and credit notes. For each field, the list includes the code that
identifies the field, the maximum number of characters in the field, and a description of the field.
Order Header Fields

ORDUNIQ 10 Order Uniquifier
ORDNUMBER 22 Order Number
CUSTOMER 12 Customer Number
CUSTGROUP 6 Customer Group Code
BILNAME 60 Bill-To Name
BILADDR1 60 Bill-To Address Line 1
BILCITY 30 Bill-To City
BILSTATE 30 Bill-To State/Province
BILZIP 20 Bill-To Zip/Postal Code
BILCOUNTRY 30 Bill-To Country
BILPHONE 30 Bill-To Phone Number
BILFAX 30 Bill-To Fax Number
BILCONTACT 60 Bill-To Contact
SHIPTO 6 Ship-To Location Code
SHPNAME 60 Ship-To Name
SHPADDR1 60 Ship-To Address Line 1
SHPCITY 30 Ship-To City
SHPSTATE 30 Ship-To State/Province
SHPZIP 20 Ship-To Zip/Postal Code
SHPCOUNTRY 30 Ship-To Country
SHPPHONE 30 Ship-To Phone Number
SHPFAX 30 Ship-To Fax Number
SHPCONTACT 60 Ship-To Contact
CUSTDISC 2 Customer Discount Level
PRICELIST 6 Default Price List Code
PONUMBER 22 Purchase Order Number
TERRITORY 6 Territory
TERMS 6 Terms Code
TERMTTLDUE 10 Total Terms Amount Due
DISCAVAIL 10 Discount Available
TERMOVERRD 2 Terms Rate Override
REFERENCE 60 Order Reference
TYPE 2 Order Type
ORDDATE 5 Order Date
EXPDATE 5 Expected Ship Date
QTEXPDATE 5 Quote Expiration Date
ORDFISCYR 4 Order Fiscal Year
ORDFISCPER 2 Order Fiscal Period
SHIPVIA 6 Ship-Via Code
VIADESC 60 Ship-Via Code Description
LASTINVNUM 22 Last Invoice Number
NUMINVOICE 2 Number of Invoices
FOB 60 Free On Board Point
TEMPLATE 6 Template Code
LOCATION 6 Default Location Code
ONHOLD 2 On Hold Status
DESC 60 Order Description
COMMENT 250 Order Comment
PRINTSTAT 2 Order Print Status
LASTPOST 5 Last Posting Date
ORNOPREPAY 2 Order No. of Prepayments
OVERCREDIT 2 Over Credit Limit
APPROVELMT 10 Approved Limit
APPROVEBY 8 Authorizing User ID
SHIPLABEL 2 Requires Shipping Labels
LBLPRINTED 2 Shipping Labels Printed
ORHOMECURR 3 Order Home Currency
ORRATETYPE 2 Order Rate Type
ORSOURCURR 3 Order Source Currency
ORRATEDATE 5 Order Rate Date
ORRATE 8 Order Rate
ORSPREAD 8 Order Spread
ORDATEMTCH 2 Order Rate Date Matching
ORRATEREP 2 Order Rate Representation
ORRATEOVER 2 Order Rate Override Flag
ORDTOTAL 10 Total Amt. Items
ORDMTOTAL 10 Total Amt. Misc. Charges
ORDLINES 2 Number of Lines on Order
ORDPAYTOT 10 Prev. Payments Total
ORDPYDSTOT 10 Prev. Payment Disc. Total
SALESPER1 8 Salesperson 1
SALESPLT1 5 Sales Percentage 1
RECALCTAX 2 Recalculate Tax
TAXOVERRD 2 Tax Overridden
TAXGROUP 12 Tax Group
TAUTH1 12 Tax Authority 1
TCLASS1 2 Tax Class 1
TBASE1 10 Tax Base 1
TEAMOUNT1 10 Excluded Tax Amount 1
TIAMOUNT1 10 Included Tax Amount 1
TEXEMPT1 20 Registration 1
COMPLETE 2 Order Completed
COMPDATE 5 Order Completion Date
INVNUMBER 22 Invoice Number
SHIPDATE 5 Shipment Date
INVDATE 5 Invoice Date
INVFISCYR 4 Invoice Fiscal Year
INVFISCPER 2 Invoice Fiscal Period
NUMPAYMENT 3 No. of Terms Payments
PAYMNTASOF 5 Terms Payments As Of Date
INVWEIGHT 10 Invoice Total Est. Weight
NEXTDTLNUM 2 Next Detail Number
IDISONMISC 2 Invoice Disc. Misc. Charges
INNOPREPAY 2 Invoice No. of Prepayments
INVNETNOTX 10 Invoice Total Before Tax
INVITAXTOT 10 Invoice Incl. Tax Total
INVITMTOT 10 Invoice Item Total Amount
INVDISCBAS 10 Invoice Discount Base
INVDISCPER 5 Invoice Discount Percentage
INVDISCAMT 10 Invoice Discount Amount
INVMISC 10 Invoice Total Misc. Charges
INVSUBTOT 10 Invoice Subtotal Amount
INVNET 10 Invoice Total With Inv. Disc.
INVETAXTOT 10 Invoice Excl. Tax Total
INVNETWTX 10 Invoice Total
INVAMTDUE 10 Invoice Amount Due
INHOMECURR 3 Invoice Home Currency
INRATETYPE 2 Invoice Rate Type
INSOURCURR 3 Invoice Source Currency
INRATEDATE 5 Invoice Rate Date
INRATE 8 Invoice Rate
INSPREAD 8 Invoice Spread
INDATEMTCH 2 Invoice Rate Date Matching
INRATEREP 2 Invoice Rate Representation
INRATEOVER 2 Invoice Rate Override Flag
ORDERSOURC 2 Order Source
ITEMDISTOT 10 Item Detail Discount Total
MISCDISTOT 10 Misc. Charge Detail Discount Total
OTRMETHOD 2 Auto-Calc. Tax Reporting Amounts
OTRCURRNCY 3 Tax Reporting (TR) Currency
OTRRATTYPE 2 TR Rate Type
OTRRATDATE 5 TR Rate Date
OTRRATE 8 TR Rate
OTRSPREAD 8 TR Spread
OTRDATMTCH 2 TR Rate Date Matching
OTRRATEOP 2 TR Rate Operator
OTRRATOVER 2 TR Rate Override Flag
OTREAMNT1 10 TR Excluded Tax Amount 1
OTRIAMNT1 10 TR Included Tax Amount 1
DISAMTOVER 2 Order Discount Amount Override
HASJOB 2 Job Related
JOBLINES 4 Job Related Detail Lines
LININAVABLE 4 Project Invoicing
HASRTG 2 Has Retainage
RTGTERMS 6 Retainage Terms
RTGRATE 2 Retainage Exchange Rate
RTGTERMDSC 60 Retainage Terms Description
CUSACCTSET 6 Customer Account Set
CUSACTDESC 60 Customer Account Set Description
ENTEREDBY 8 Entered By
Order Header Optional Fields

VALUE 60 Value
TYPE 2 Type
LENGTH 2 Length
DECIMALS 2 Decimals
VALIDATE 2 Validate
Order Details Fields

LINETYPE 2 Line Type
ITEM 24 Item
MISCCHARGE 6 Miscellaneous Charges Code
DESC 60 Description
ACCTSET 6 Item Control Account Set
USERCOSTMD 2 User-Specified Costing Method
PRICELIST 6 Price List
CATEGORY 6 Category
LOCATION 6 Location
PICKSEQ 10 Picking Sequence
EXPDATE 5 Expected Shipment Date
QTYORDERED 10 Quantity Ordered
QTYSHIPPED 10 Quantity Shipped
QTYBACKORD 10 Quantity Backordered
QTYSHPTODT 10 Quantity Shipped-to-date
ORIGQTY 10 Original Quantity Ordered
QTYPO 10 P/O Quantity Ordered
ORDUNIT 10 Order Unit of Measure
UNITCONV 10 Order Unit Conversion
UNITPRICE 10 Order Unit Price
PRICEOVER 2 Price Override
UNITCOST 10 Order Unit Cost
MOSTREC 10 Most Recent Unit Cost
STDCOST 10 Standard Unit Cost
COST1 10 Alternate Unit Cost 1
UNITPRCDEC 2 Unit Price No. of Decimals
PRICEUNIT 10 Pricing Unit of Measure
PRIUNTPRC 10 Pricing Unit Price
PRIUNTCONV 10 Pricing Unit Conversion
PRIPERCENT 5 Price Discount Percentage
PRIAMOUNT 10 Price Discount Amount
BASEUNIT 10 Pricing Base Unit
PRIBASPRC 10 Pricing Base Unit Price
PRIBASCONV 10 Pricing Base Unit Conversion
COSTUNIT 10 Costing Unit of Measure
COSUNTCST 10 Costing Unit Cost
COSUNTCONV 10 Costing Unit Conversion
EXTOPRICE 10 Extended Order Price
EXTOCOST 10 Extended Order Cost
EXTINVMISC 10 Extended Amount
INVDISC 10 Invoice Discount Amount
EXTICOST 10 Extended Detail Cost
EXTOVER 2 Extended Shipped Amt. Override
UNITWEIGHT 10 Unit Weight
EXTWEIGHT 10 Extended Weight
COMPLETE 2 Order Completed
ADDTOILOC 2 Recognized In Item/Location
SALESLOST 10 Lost Sales Amount
TINCLUDED1 2 Tax Included 1
TAMOUNT1 10 Tax Amount 1
TRATE1 8 Tax Rate 1
TRATE2 8 Tax Rate 2
TRATE3 8 Tax Rate 3
TRATE4 8 Tax Rate 4
TRATE5 8 Tax Rate 5
MISCACCT 45 Misc. Charges G/L Account
DETAILNUM 2 Detail Number
HAVESERIAL 2 Use Item Serial Numbers
COMMINST 2 Use Comments/Instructions
GLNONSTKCR 45 Non-stock Clearing Account
AVGCOST 10 Average Unit Cost
COPYDETAIL 2 Copy This Detail Line?
QUONUMBER 22 Quote Number
QUODTLNUM 2 Quote Detail Line Number
SHIPTRACK 36 Shipment Tracking Number
DISCPER 5 Discount Percent
MANITEMNO 24 Manufacturer's Item Number
CUSTITEMNO 24 Customer Item Number
QTYTRUECOM 10 True Quantity Committed
DDTLTYPE 2 Kitting/BOM
DDTLNO 6 Kit/BOM Number
BUILDQTY 10 BOM Build Qty.
BUILDUNIT 10 BOM Build Unit
BLDUNTCONV 10 BOM Build Unit Conversion
FRMNUMBER 22 Predecessor Number
NEXTCMPNUM 4 Next Component Number
EPOSPROMID 2 ePOS Promotion ID
BASEWUNIT 10 Pricing Base Weight Unit
WEIGHTUNIT 10 Order Weight UOM
WEIGHTCONV 10 Order Weight Conversion Factor
PRWGHTUNIT 10 Pricing Weight UOM
PRWGHTCONV 10 Pricing Weight Conversion Factor
PRIBASWCNV 10 Pricing Base Weight Conv. Factor
DEFUWEIGHT 10 Def. Weight UOM Unit Weight
DEFEXTWGHT 10 Def. Weight UOM Ext. Unit Weight
PRPRICEBY 2 Price By
NEEDPCHECK 2 Price Check Pending
CAPPROVEBY 8 Price Approved By
HDRDISC 10 Header Discount
OTRAMOUNT1 10 TR Tax Amount 1
PSPRINTED 2 Picking Slip Printed
JOBRELATED 2 Job Related
CONTRACT 16 Contract Code
PROJECT 16 Project Code
CCATEGORY 16 Category Code
COSTCLASS 2 Cost Class
PROJSTYLE 2 Project Style
PROJTYPE 2 Project Type
REVREC 2 Accounting Method
BILLTYPE 2 Billing Type
REVBILL 45 Revenue/Billing Account
COGSWIP 45 COGS/WIP Account
RTGPERCENT 5 Retainage Percent
RTGDAYS 2 Retainage Days
PRICEOPT 2 Default O/E Price
ARITEMNO 16 A/R Item Number
ARUNIT 10 A/R Item Unit
UFMTCONTNO 16 Unformatted Contract Code
PAYMNTDIST 10 Prepayment Distributed
Order Detail Optional Fields

LINENUM 2 Line Number
VALUE 60 Value
TYPE 2 Type
LENGTH 2 Length
DECIMALS 2 Decimals
VALIDATE 2 Validate
Order BOM Detail Fields

LINENUM 2 Detail Line Number
PRNCOMPNUM 4 Parent Component Number
COMPNUM 4 Component Number
COMPONENT 24 Component Item
DESC 60 Description
QTY 10 Component Quantity
Order Kitting Detail Fields

DESC 60 Description
ACCTSET 6 Item Account Set
LOCATION 6 Location
QTY 10 Kitting Quantity
PRNQTYORD 10 Parent Quantity Ordered
PRNQTYSHIP 10 Parent Quantity Shipped
PRNUNIT 10 Parent Unit of Measure
PRNUNTCONV 10 Parent Unit Conversion
QTYPO 10 P/O Quantity Ordered
UNITCONV 10 Order Unit Conversion
UNITCOST 10 Order Unit Cost
EXTOCOST 10 Extended Order Cost
Order Kitting Serial Numbers

SERIALUNIQ 4 Uniquifier
SERIALNUM 22 Serial Number
Comments/Instructions Fields

COINTYPE 2 Comments/Instructions Type
COIN 80 Comments/Instructions
Terms Schedule Fields

DISCBASE 10 Discount Base
DISCDATE 5 Discount Date
DISCPER 5 Discount Percentage
DISCAMT 10 Discount Amount
DUEBASE 10 Amount Due Base
DUEDATE 5 Due Date
DUEPER 5 Percentage Due
DUEAMT 10 Amount Due
Serial Numbers

Prepayments Fields
APPLYTO 2 Apply To
DOCNUMBER 22 Document Number
PPNUMBER 2 Prepayment Number
REBATCHNUM 5 Receipt Batch Number
BANKRECTYP 6 Receipt Type
CHECKDATE 5 Check Date
CHKFISCYR 4 Check Fiscal Year
CHKFISCPER 2 Check Fiscal Period
CHECKNUM 24 Check Number
PAYMENT 10 Payment in Customer Currency
INVPAYDISC 10 Payment Discount
BANKPAYMNT 10 Payment in Bank Currency
PAHOMECURR 3 Payment Home Currency
PARATETYPE 2 Payment Rate Type
PASOURCURR 3 Payment Source Currency
PARATEDATE 5 Payment Rate Date
PARATE 8 Payment Rate
PASPREAD 8 Payment Spread
PADATEMTCH 2 Payment Rate Date Matching
PARATEREP 2 Payment Rate Representation
IDPPD 22 Prepayment Number
PAYMTYPE 2 Payment Type
CCTYPE 12 Credit Card Type
CCNUMBER 32 Credit Card Number
CCNAME 60 Credit Card Name
CCAUTHCODE 20 Authorization Code
Misc. Charges Taxes Fields

CURRENCY 3 Currency
MISCCHARGE 6 Miscellaneous Charge Code
AUTHORITY 12 Authority
TAXCLASS 2 Sales Tax Class
TAUTHDESC 60 Authority Description
TCLASSDESC 60 Class Description
Misc. Charges Fields

CURRENCY 3 Currency
DESC 60 Description
MISCACCT 45 Miscellaneous Charge Account
AMOUNT 10 Amount
MISCACDESC 60 Account Description
Currency Table Fields

HOMECUR 3 Func. Currency
TABLEDESC 60 Table Description
DATEMATCH 2 Date Matching
RATEOPER 2 Rate Operation
RATESRCE 60 Source of Rates
Currency Code Fields

CURID 3 Currency Code
CURNAME 60 Name
SYMBOL 4 Symbol
DECIMALS 2 Decimals
SYMBOLPOS 2 Symbol Position
THOUSSEP 1 Thousands Separator
DECSEP 1 Decimal Separator
NEGDISP 2 Negative Display
Company Information

ORGID 6 Database ID
CITY 30 City
STATE 30 State
COUNTRY 30 Country
FAX 30 Fax Number
QTR4PERD 2 Quarter with 4 Periods
MULTICURSW 2 Multicurrency Switch
EUROCURSW 2 Euro Currency Switch
Item Fields

DESC 60 Description
INACTIVE 2 Status
CATEGORY 6 Category
ALTITEMNO 24 Alternate Item Number
FMTALTITEM 24 Formatted Alternate Item Number
ALTITEMDSC 60 Alternate Item Description
COSTMETHOD 2 Costing Method
Location Fields

LOCATION 6 Location
DESC 60 Name
ADDRESS1 60 Address Line 1
CITY 30 City
STATE 30 State
ZIP 20 Zip/Postal Code
COUNTRY 30 Country
FAX 30 Fax Number
CONTACT 60 Contact
SEGOVERRD 2 Segment Override
INACTIVE 2 Status
SEGNUM1 6 Segment Number 1
SEGVAL1 15 Segment Value 1
A/R Terms Fields

CODETERM 6 Terms Code
ACTIVESW 2 Status
INACDATE 5 Inactive Date
MULTIPAYM 2 Use Payment Schedule
VATCODEM 2 Calc.Base for Discount with Tax
DISCTYPE 2 Discount Type
DISCPCT 5 Reserved
DISCNBR 2 Reserved
DISCDAY 2 Reserved
DDAYSTRT1 2 Discount Table Starting Day 1
DDAYEND1 2 Discount Table Ending Day 1
DMNTHADD1 2 Discount Table Months Added 1
DDAYUSE1 2 Discount Table Day of Month 1
DUETYPE 2 Due Date Type
CNTDUEDAY 2 Reserved
DUENBRDAYS 2 Reserved
DUDAYST1 2 Due Date Table Starting Day 1
DUDAYEND1 2 Due Date Table Ending Day 1
DUMNTHAD1 2 Due Date Table Months Added 1
DUDAYUSE1 2 Due Date Table Day of Month 1
DTEDUESYNC 2 Reserved
DTEDSCSYNC 2 Reserved
CNTENTERED 4 Number of Payments
PCTDUETOT 5 Total Percent Due
Salesperson Fields

CODESLSP 8 Salesperson Number
SWACTV 2 Status
CODEEMPL 15 Employee Number
NAMEEMPL 60 Name
SWCOMM 2 Reserved
AMTANLTARG 10 Annual Sales Target
SWCOMM2 2 Commissions Paid
COMMBASE1 10 Maximum Sales for Rate 1
COMMRATE1 5 Commission Rate 1
COMMSALES 10 Commissionable Sales
COMMCOST 10 Cost of Commissionable Sales
DATECLEARD 5 Date Last Cleared
Customer Fields
IDGRP 6 Group Code
SWACTV 2 Status
SWHOLD 2 On Hold
IDPPNT 12 Reserved
NAMECITY 30 City
CODESTTE 30 State
CODECTRY 30 Country
IDDLNQ 6 Reserved
SWPRTSTMT 2 Print Statements
CODETERM 6 Terms
AMTBALDUET 10 Balance Due in Cust. Curr.
AMTBALDUEH 10 Balance Due in Func. Curr.
AMTLASTSTT 10 Last Statement Total Cust. Curr
DTBEGBALFW 5 Date of Last Bal. Fwd. Statemen
AMTBALFWDT 10 Beginning Bal. on Last Statemen
DATEINVHIL 5 Date of Largest Invoice Last Yr
DATEBALHIL 5 Date of Highest Balance Last Yr
AMTINVHIT 10 Largest Invoice - Cust. Curr.
AMTBALHIT 10 Highest Balance - Cust. Curr.
AMTINVHILT 10 Lgst. Inv. Last Yr. Cust. Curr
AMTBALHILT 10 High Bal. Last Yr. - Cust. Curr
AMTLASTIVT 10 Last Invoice Amt. - Cust. Curr.
AMTLASTCRT 10 Last Cr. Note Amt. - Cust. Curr
AMTLASTDRT 10 Last Dr. Note Amt. - Cust. Curr
AMTLASTPYT 10 Last Receipt - Cust. Curr.
AMTLASTDIT 10 Last Discount Amt. - Cust. Curr
AMTLASTADT 10 Last Adj. Amt. - Cust. Curr.
AMTLASTWRT 10 Last Write-Off Amt. Cust. Curr
AMTLASTRIT 10 Last Ret'd. Chk. Amt. Cust. Cur
AMTLASTINT 10 Last Int. Charge - Cust. Curr.
AMTINVHIH 10 Largest Invoice - Func. Curr.
AMTBALHIH 10 Highest Balance - Func. Curr.
AMTINVHILH 10 Lgst. Inv. Last Yr. Func. Curr
AMTBALHILH 10 High Bal. Last Yr. - Func. Curr
AMTLASTIVH 10 Last Invoice Amt. - Func. Curr.
AMTLASTCRH 10 Last Cr. Note Amt. - Func. Curr
AMTLASTDRH 10 Last Dr. Note Amt. - Func. Curr
AMTLASTPYH 10 Last Receipt - Func. Curr.
AMTLASTDIH 10 Last Discount Amt. - Func. Curr
AMTLASTADH 10 Last Adj. Amt. - Func. Curr.
AMTLASTWRH 10 Last Write-Off Amt. Func. Curr
AMTLASTRIH 10 Last Ret'd. Chk. Amt. Func. Cur
AMTLASTINH 10 Last Int. Charge - Func. Curr.
TEXTOPFL1 2 Optional Field 1
DATEOPFL1 5 Optional Date Field
AMTOPFL1 10 Optional Amount Field
CUSTTYPE 2 Customer Discount Type
WEBSITE 100 Customer's Web Site
BILLMETHOD 2 Billing Method
CCEXP 5 Credit Card Expiry Date
CODPAYMTYP 6 Receipt Type
SHPVIACODE 6 Ship Via Code
SHPVIADESC 60 Ship Via Description
Customer Comments Fields

DATEENTR 5 Date Entered
CNTUNIQ 3 Comment Number
DATEEXPR 5 Expiration Date
DATEFLUP 5 Follow-up Date
TEXTCMNT 250 Comments
REVCOM 3 Reverse Count
O/E Options Fields

DUMMY 2 Dummy Key
PHONE 30 Phone
FAX 30 Fax
DAYEND 2 Day End Pending
DIRECT 2 Direct Printing on Invoices
ORDHIST 2 Keep Order History
COMMISSION 2 Track Commissions
COMMTYPE 2 Commission Type
BACKORD 2 Calculate Backorder Quantities
ALLOWSHIP 2 Allow Qty Shipped on Orders
STATACCUM 2 Accumulate Statistics
STATEDIT 2 Allow Edit Statistics
STATCLNDR 2 Accumulate Statistics By
STATPRD 2 Statistics Period By
AGING1 2 Aging Period 1
TRANHIST 2 Accumulate Sales History
TRANCLNDR 2 Accumulate Sales History By
TRANPRD 2 Sales History Period By
DEFTEMP 6 Default Template Code
ORDNUMBERL 2 Order Number Length
ORDPREFIXD 6 Order Number Prefix
ORDBODYD 22 Next Order Number
NEXTOUNIQ 10 Next Order Uniquifier Key
INVNUMBERL 2 Invoice Number Length
INVPREFIXD 6 Invoice Number Prefix
INVBODYD 22 Next Invoice Number
CRDNUMBERL 2 Credit Note Number Length
CRDPREFIXD 6 Credit Note Number Prefix
CRDBODYD 22 Next Credit Note Number
NEXTCUNIQ 10 Next Credit Note Uniquifier Key
BROWSENUM 10 Day End Browse Number
STATPRDTYP 2 Statistical Period Type
STATPRDLNG 2 Statistical Period Length
STATPRDS 2 Statistical Periods
TRANPRDTYP 2 Sales History Period Type
TRANPRDLNG 2 Sales History Period Length
TRANPRDS 2 Sales History Periods
ORDDEFAULT 22 Default Order Number
ORDVALUE 22 Next Order Number
INVDEFAULT 22 Default Invoice Number
INVVALUE 22 Next Invoice Number
CRDDEFAULT 22 Default Credit Note Number
CRDVALUE 22 Next Credit Note Number
Invoice Headers Fields

DAYENDNUM 10 I/C Day End Trans. Number
BILNAME 60 Bill To
BILADDR1 60 Bill-To Address 1
BILCITY 30 Bill-To Address City
BILSTATE 30 Bill-To Address State
BILZIP 20 Bill-To Address Zip Code
BILCOUNTRY 30 Bill-To Address Country
BILPHONE 30 Bill-To Address Phone
BILFAX 30 Bill-To Address Fax
BILCONTACT 60 Bill-To Address Contact
SHIPTO 6 Ship to Address Code
SHPNAME 60 Ship To
SHPADDR1 60 Ship-To Address 1
SHPCITY 30 Ship-To Address City
SHPSTATE 30 Ship-To Address State
SHPZIP 20 Ship-To Address Zip Code
SHPCOUNTRY 30 Ship-To Address Country
SHPPHONE 30 Ship-To Address Phone
SHPFAX 30 Ship-To Address Fax
SHPCONTACT 60 Ship-To Address Contact
TERMS 6 Terms Code
TERMTTLDUE 10 Total Terms Amount Due
TERMOVERRD 2 Terms Rate Override
REFERENCE 60 Reference
LOCATION 6 Location
DESC 60 Description
COMMENT 250 Comment
INVLINES 2 Number of Lines in Invoice
NUMPAYMENT 3 Number of Terms Payments
PAYMNTASOF 5 Terms Payments As Of Date
INVWEIGHT 10 Invoice Total Estimated Weight
INVSTATUS 2 Invoice Status
INVPRINTED 2 Invoice Printed
IDISONMISC 2 Invoice Discount on Misc. Charg
POSTDATE 5 Posting Date
COMPDATE 5 Completion Date
SHIPLABEL 2 Requires Shipping Labels
LBLPRINTED 2 Shipping Labels Printed
INVNETNOTX 10 Invoice Total Before Tax
INVITAXTOT 10 Invoice Included Tax Total Amou
INVITMTOT 10 Invoice Item Total Amount
INVDISCBAS 10 Invoice Discount Base
INVDISCPER 5 Invoice Discount Percentage
INVDISCAMT 10 Invoice Discount Amount
INVMISC 10 Invoice Total Miscellaneous Cha
INVSUBTOT 10 Invoice Subtotal Amount
INVNET 10 Invoice Total With Invoice Disc
INVETAXTOT 10 Invoice Excluded Tax Total Amou
INVNETWTX 10 Invoice Total With Tax
AUTOTAXCAL 2 Auto-Tax Calculation Status
BILEMAIL 50 Bill-To E-mail
BILPHONEC 30 Bill-To Contact Phone
BILFAXC 30 Bill-To Contact Fax
BILEMAILC 50 Bill-To Contact E-mail
SHPEMAIL 50 Ship-To E-mail
SHPPHONEC 30 Ship-To Contact Phone
SHPFAXC 30 Ship-To Contact Fax
SHPEMAILC 50 Ship-To Contact E-mail
DISCAVAIL 10 Discount Available
SHHOMECURR 3 Shipment Home Currency
SHRATETYPE 2 Shipment Rate Type
SHSOURCURR 3 Shipment Source Currency
SHRATEDATE 5 Shipment Rate Date
SHRATE 8 Shipment Rate
SHSPREAD 8 Shipment Spread
SHDATEMTCH 2 Shipment Rate Date Matching
SHRATEREP 2 Shipment Rate Operator
SHRATEOVER 2 Shipment Rate Override Flag
SHINUMBER 22 Shipment Number
MULTISHI 2 Generate From Multiple Shipments
SHIS 2 From How Many Shipments
SHIUNIQ 10 Shipment Uniquifier
TERMDBWT 10 Document Discount Base With Tax
TERMDBNT 10 Document Discount Base Without T
ITRMETHOD 2 Auto-Calc. Tax Reporting Amounts
ITRCURRNCY 3 Tax Reporting (TR) Currency
ITRRATTYPE 2 TR Rate Type
ITRRATDATE 5 TR Rate Date
ITRRATE 8 TR Rate
ITRSPREAD 8 TR Spread
ITRDATMTCH 2 TR Rate Date Matching
ITRRATEOP 2 TR Rate Operator
ITRRATOVER 2 TR Rate Override Flag
ITREAMNT1 10 TR Excluded Tax Amount 1
ITRIAMNT1 10 TR Included Tax Amount 1
STRCURRNCY 3 Tax Reporting Shipment (TR) Currency
STRRATTYPE 2 TR Shipment Rate Type
STRRATDATE 5 TR Shipment Rate Date
STRRATE 8 TR Shipment Rate
STRSPREAD 8 TR Shipment Spread
STRDATMTCH 2 TR Shipment Rate Date Matching
STRRATEOP 2 TR Shipment Rate Operator
STRRATOVER 2 TR Shipment Rate Override Flag
TAXVERSION 4 Tax Version
DISAMTOVER 2 Invoice Discount Amount Override
RTGTERMS 6 Retainage Terms
RTGAMOUNT 10 Retainage Amount
RTGTXBASE1 10 Retainage Tax Base 1
RTGTXAMT1 10 Retainage Tax Amount 1
RTGTERMDSC 60 Retainage Terms Description
PAYMNTDIST 10 Prepayment Distributed
Invoice Header Optional Fields

INVUNIQ 10 Invoice Uniquifier
VALUE 60 Value
TYPE 2 Type
LENGTH 2 Length
DECIMALS 2 Decimals
VALIDATE 2 Validate
Invoice Details Fields

ITEM 24 Item
DESC 60 Description
ACCTSET 6 Account Set
USERCOSTMD 2 Costing Method
CATEGORY 6 Category
LOCATION 6 Location
EXPDATE 5 Expected Shipment Date
INVUNIT 10 Item Unit
UNITCONV 10 Unit Conversion
PRICEUNIT 10 Pricing Unit
COSTUNIT 10 Costing Unit
EXTICOST 10 Extended Detail Cost
EXTINVMISC 10 Extended Shipped Price/Misc. Ch
INVDISC 10 Invoice Discount Amount
EXTOVER 2 Extended Amount Override
TRATE1 8 Tax Rate 1
TRATE2 8 Tax Rate 2
TRATE3 8 Tax Rate 3
TRATE4 8 Tax Rate 4
TRATE5 8 Tax Rate 5
HAVESERIAL 2 Have Serial Numbers for Item
COMMINST 2 Have Comments/Instructions
SHINUMBER 22 Shipment Number
SHIDTLNUM 2 Shipment Detail Line Number
ORDQTYORD 10 Order Quantity Ordered
ORDQTYBKOR 10 Order Quantity Backordered
ORDQTYCOMM 10 Order Quantity Committed
ORDQTYTCOM 10 Order Quantity True Committed
ORDQTYSTD 10 Order Quantity Shipped-to-date
ORDUNITCON 10 Order Unit Conversion
QTYTRUECOM 10 Quantity True Committed
ORDDTLNUM 2 Order Detail Number
REFRESH 2 Refresh Order Qty. at Update
ORIGQTYSHP 10 Original Quantity shipped
TERMDISCBL 2 Detail subject to Payment Discount
WEIGHTCONV 10 Weight Conversion Factor
ITRAMOUNT1 10 TR Tax Amount 1
RTGDDTOVR 2 Retainage Due Date Override
RTGAMTOVR 2 Retainage Amount Override
Invoice Detail Optional Fields

LINENUM 2 Line Uniquifier
VALUE 60 Value
TYPE 2 Type
LENGTH 2 Length
DECIMALS 2 Decimals
VALIDATE 2 Validate
Invoice BOM Detail Fields

DESC 60 Description
Invoice Kitting Detail Fields

DESC 60 Description
LOCATION 6 Location
PRNQTYSHIP 10 Parent Quantity Shipped
INVUNIT 10 Invoice Unit of Measure
UNITCONV 10 Invoice Unit Conversion
UNITCOST 10 Invoice Unit Cost
EXTICOST 10 Extended Invoice Cost
Invoice Kitting Serial Numbers


Terms Schedule Fields

DISCBASE 10 Discount Base
DISCDATE 5 Discount Date
DISCPER 5 Discount Percentage
DISCAMT 10 Discount Amount
DUEBASE 10 Due Amount Base
DUEDATE 5 Due Date
DUEPER 5 Percentage Due
DUEAMT 10 Amount Due
Serial Numbers

Prepayments Fields

APPLYTO 2 Apply To
DOCNUMBER 22 Document Number
PPNUMBER 2 Prepayment Number
REBATCHNUM 5 Receipt Batch Number
BANKRECTYP 6 Receipt Type
CHECKDATE 5 Check Date
CHKFISCYR 4 Check Fiscal Year
CHKFISCPER 2 Check Fiscal Period
CHECKNUM 24 Check Number
PAYMENT 10 Payment in Customer Currency
INVPAYDISC 10 Payment Discount
BANKPAYMNT 10 Payment in Bank Currency
PAHOMECURR 3 Payment Home Currency
PARATETYPE 2 Payment Rate Type
PASOURCURR 3 Payment Source Currency
PARATEDATE 5 Payment Rate Date
PARATE 8 Payment Rate
PASPREAD 8 Payment Spread
PADATEMTCH 2 Payment Rate Date Matching
PARATEREP 2 Payment Rate Representation

CURRENCY 3 Currency

CURRENCY 3 Currency
DESC 60 Description
AMOUNT 10 Amount


CURNAME 60 Name
SYMBOL 4 Symbol
DECIMALS 2 Decimals
Company Information

ORGID 6 Database ID
CITY 30 City
STATE 30 State
COUNTRY 30 Country
FAX 30 Fax Number
Item Fields

DESC 60 Description
INACTIVE 2 Status
CATEGORY 6 Category
Location Fields

LOCATION 6 Location
DESC 60 Name
CITY 30 City
STATE 30 State
COUNTRY 30 Country
FAX 30 Fax Number
CONTACT 60 Contact
INACTIVE 2 Status
A/R Terms Fields

ACTIVESW 2 Status
DISCPCT 5 Reserved
DISCNBR 2 Reserved
DISCDAY 2 Reserved
Salesperson Fields

SWACTV 2 Status
NAMEEMPL 60 Name
SWCOMM 2 Reserved
Customer Fields

IDGRP 6 Group Code
SWACTV 2 Status
SWHOLD 2 On Hold
IDPPNT 12 Reserved
NAMECITY 30 City
CODESTTE 30 State
CODECTRY 30 Country
IDDLNQ 6 Reserved
CODETERM 6 Terms

O/E Options Fields

DUMMY 2 Dummy Key
PHONE 30 Phone
FAX 30 Fax
Credit/Debit Note Header Fields

CRDUNIQ 10 CN Uniquifier
CRDNUMBER 22 Credit Note Number
DAYENDNUM 10 I/C Day End Trans. Number
BILNAME 60 Bill To
BILCITY 30 Bill-To Address City
BILSTATE 30 Bill-To Address State
BILZIP 20 Bill-To Address Zip Code
BILCOUNTRY 30 Bill-To Address Country
BILPHONE 30 Bill-To Address Phone
BILFAX 30 Bill-To Address Fax
BILCONTACT 60 Bill-To Address Contact
PRICELIST 6 Default Price List Code
LOCATION 6 Default Location Code
DESC 60 Description
COMMENT 250 Comment
CRDTOTAL 10 CR Item Subtotal
CRDMTOTAL 10 CR Misc. Charges Subtotal
RETDATE 5 Return Date
CRDDATE 5 Credit Note Date
CRDFISCYR 4 Credit Note Fiscal Year
CRDFISCPER 2 Credit Note Fiscal Period
CRDLINES 2 Number of Lines in Credit Note
CRDWEIGHT 10 Credit Note Total Estimated Wei
CRDSTATUS 2 Credit Note Status
CRDPRINTED 2 Credit Note Printed
CDISONMISC 2 Credit Note Discount on Misc. C
POSTDATE 5 Posting Date
COMPDATE 5 Completion Date
CRDNETNOTX 10 Credit Note Total Before Tax
CRDITAXTOT 10 Credit Note Included Tax Total
CRDITMTOT 10 Credit Note Item Total Amount
CRDDISCBAS 10 Credit Note Discount Base
CRDDISCPER 5 Credit Note Discount Percentage
CRDDISCAMT 10 Credit Note Discount Amount
CRDMISC 10 Credit Note Total Miscellaneous
CRDSUBTOT 10 Credit Note Subtotal Amount
CRDNET 10 Credit Note Total With CN Disco
CRDETAXTOT 10 Credit Note Excluded Tax Total
CRDNETWTX 10 Credit Note Total
CRHOMECURR 3 Credit Note Home Currency
CRRATETYPE 2 Credit Note Rate Type
CRSOURCURR 3 Credit Note Source Currency
CRRATEDATE 5 Credit Note Rate Date
CRRATE 8 Credit Note Rate
CRSPREAD 8 Credit Note Spread
CRDATEMTCH 2 Credit Note Rate Date Matching
CRRATEREP 2 Credit Note Rate Representation
CRRATEOVER 2 Credit Note Rate Override Flag
AUTOTAXCAL 2 Auto-Tax Calculation Status
BILEMAIL 50 Bill-To E-mail
BILPHONEC 30 Bill-To Contact Phone
BILFAXC 30 Bill-To Contact Fax
BILEMAILC 50 Bill-To Contact E-mail
ADJTYPE 2 Type
SHIPTO 6 Ship-To Location Code
SHPNAME 60 Ship-To Name
SHPCITY 30 Ship-To City
SHPSTATE 30 Ship-To State/Province
SHPZIP 20 Ship-To Zip/Postal Code
SHPCOUNTRY 30 Ship-To Country
SHPPHONE 30 Ship-To Phone Number
SHPFAX 30 Ship-To Fax Number
SHPCONTACT 60 Ship-To Contact
SHPEMAIL 50 Ship-To E-mail
SHPPHONEC 30 Ship-To Contact Phone
SHPFAXC 30 Ship-To Contact Fax
SHPEMAILC 50 Ship-To Contact E-mail
CTRMETHOD 2 Auto-Calc. Tax Reporting Amounts
CTRCURRNCY 3 Tax Reporting (TR) Currency
CTRRATTYPE 2 TR Rate Type
CTRRATDATE 5 TR Rate Date
CTRRATE 8 TR Rate
CTRSPREAD 8 TR Spread
CTRDATMTCH 2 TR Rate Date Matching
CTRRATEOP 2 TR Rate Operator
CTRRATOVER 2 TR Rate Override Flag
CTREAMNT1 10 TR Excluded Tax Amount 1
CTRIAMNT1 10 TR Included Tax Amount 1
ITRCURRNCY 3 Tax Reporting Invoice (TR) Currency
ITRRATTYPE 2 TR Invoice Rate Type
ITRRATDATE 5 TR Invoice Rate Date
ITRRATE 8 TR Invoice Rate
ITRSPREAD 8 TR Invoice Spread
ITRDATMTCH 2 TR Invoice Rate Date Matching
ITRRATEOP 2 TR Invoice Rate Operator
ITRRATOVER 2 TR Invoice Rate Override Flag
TAXVERSION 4 Tax Version
DISAMTOVER 2 Credit/Debit Note Discount Amount Override
Credit/Debit Note Header Optional Fields

VALUE 60 Value
TYPE 2 Type
LENGTH 2 Length
DECIMALS 2 Decimals
VALIDATE 2 Validate
Credit/Debit Note Detail Fields

ITEM 24 Item
DESC 60 Description
ACCTSET 6 Item Control Account Set
USERCOSTMD 2 Using User-Specified Costing Me
CATEGORY 6 Category
LOCATION 6 Location
QTYRETURN 10 Quantity Returned
CRDUNIT 10 Order Unit
PRICEUNIT 10 Pricing Unit
COSTUNIT 10 Costing Unit
EXTCCOST 10 Extended Detail Cost
EXTCRDMISC 10 Extended Amount/Misc. Charge
CRDDISC 10 Credit Note Discount Amount
EXTOVER 2 Extended Amount Override
EXTICOST 10 Invoice Extended Cost
RETURNTYPE 2 Return Type
TRATE1 8 Tax Rate 1
TRATE2 8 Tax Rate 2
TRATE3 8 Tax Rate 3
TRATE4 8 Tax Rate 4
TRATE5 8 Tax Rate 5
HAVESERIAL 2 Have Serial Numbers for Item
COMMINST 2 Have Comments/Instructions
EXPDATE 5 Shipment Date
QTYORDERED 10 Invoice Current Qty. Outstanding
INVUNIT 10 Invoice Unit of Measure
INVUNITCON 10 Invoice Unit Conversion
ORDQTYORD 10 Order Quantity Ordered
ORDQTYBKOR 10 Order Quantity Backordered
ORDQTYCOMM 10 Order Quantity Committed
ORDQTYSTD 10 Order Quantity Shipped-to-date
ORDUNITCON 10 Order Unit Conversion
NEXTCMPNUM 4 Next Component Number
WEIGHTCONV 10 Weight Conversion Factor
CTRAMOUNT1 10 TR Tax Amount 1
CATEGORY 16 Category Code
Credit/Debit Note Detail Optional Fields

VALUE 60 Value
TYPE 2 Type
LENGTH 2 Length
DECIMALS 2 Decimals
VALIDATE 2 Validate
Credit/Debit Note BOM Detail Fields

DESC 60 Description
Credit/Debit Note Kitting Detail Fields

COMPNUM 4 Component Line Number
DESC 60 Description
LOCATION 6 Location
PRNQTYRET 10 Parent Quantity Returned
CRDUNIT 10 Unit of Measure
EXTCCOST 10 Extended Order Cost
Credit/Debit Note Kitting Serial Numbers

COMPNUM 4 Component Line Number

Serial Numbers


CURRENCY 3 Currency

CURRENCY 3 Currency
DESC 60 Description
AMOUNT 10 Amount


CURNAME 60 Name
SYMBOL 4 Symbol
DECIMALS 2 Decimals
Company Information

ORGID 6 Database ID
CITY 30 City
STATE 30 State
COUNTRY 30 Country
FAX 30 Fax Number
Item Fields

DESC 60 Description
INACTIVE 2 Status
CATEGORY 6 Category
Location Fields

LOCATION 6 Location
DESC 60 Name
CITY 30 City
STATE 30 State
COUNTRY 30 Country
FAX 30 Fax Number
CONTACT 60 Contact
INACTIVE 2 Status
A/R Terms Fields

ACTIVESW 2 Status
DISCPCT 5 Reserved
DISCNBR 2 Reserved
DISCDAY 2 Reserved
Salesperson Fields

SWACTV 2 Status
NAMEEMPL 60 Name
SWCOMM 2 Reserved
Customer Fields

IDGRP 6 Group Code
SWACTV 2 Status
SWHOLD 2 On Hold
IDPPNT 12 Reserved
NAMECITY 30 City
CODESTTE 30 State
CODECTRY 30 Country
IDDLNQ 6 Reserved
CODETERM 6 Terms

O/E Options Fields

DUMMY 2 Dummy Key
PHONE 30 Phone
FAX 30 Fax
Retrieved from "http://dppwiki.sage300erp.com/wiki/Documentation:Print_Formats_for_Order_Entry_Forms"

1 Introduction
2 Requisitions
3 Purchase Orders
4 Receiving Slips
5 Returns
6 Mailing Labels
This document lists the information you can include when developing formats to print requisitions, purchase
orders, receiving slips, returns, and mailing labels. For each field, the list includes the code that identifies the
field, the maximum number of characters in the field, and a description of the field.
For information on using Crystal Reports in your Purchase Orders program, refer to the online document,
"Customizing Printed Forms with Crystal Reports." (Choose Start, Programs, Sage Software, Sage Accpac, and
then Documentation.)
The following table lists the fields that you can place on requisitions.
Requisition Header Fields

COMMENT 250 Requisition Comment
DATE 5 Requisition Date
DESCRIPTIO 60 Requisition Description
DOCSOURCE 2 Document Source
DTCOMPLETE 5 Date Completed
EXPARRIVAL 5 Expected Arrival Date
EXPIRATION 5 Expiration Date
JOBLINES 4 If greater than 0 indicates job related record
ISCOMPLETE 2 Completed
ISPRINTED 2 Printed
LINES 4 Lines
LINESCMPL 4 Completed Lines
LINESORDER 4 Lines Ordered
NEXTLSEQ 10 Next Line Sequence
ONHOLD 2 Requisition On Hold Status
OQORDERED 10 Quantity Ordered
ORDEREDON 5 Order Date
POSTDATE 5 Last Posting Date
REFERENCE 60 Requisition Reference
REQUESTBY 60 Request By
RQNHSEQ 10 Requisition Sequence Key
RQNNUMBER 22 Requisition Number
STCODE 6 Ship-To Location Code
STDESC 60 Ship-To Location Description
VDCODE 12 Vendor Number
VDEXISTS 2 Vendor Exists
VDNAME 60 Vendor Name
Requisition Detail Lines

ADDRESS1 60 Address 1
CCATEGORY 16 Category
CITY 30 City
COMPLETION 2 Completion Status
CONTACT 60 Contact
CONTRACT 16 Contract
COUNTRY 30 Country
DESC 60 Description
DLOCATION 6 Location
DROPTYPE 2 Drop-Ship Type
FAX 30 Fax Number
HASCOMMENT 2 Comments/Instructions
HASDROPSHI 2 Drop-Ship
IDCUST 12 Customer
IDCUSTSHPT 6 Customer Ship-To Address
ITEMDESC 60 Item Description
ITEMEXISTS 2 Item Exists
LINEORDER 4 Line Ordered
LOCATION 6 Location
OEONUMBER 22 Order Number
OQORDERED 10 Quantity Ordered
ORDERCONV 10 Order Unit Conversion
ORDERDECML 2 Order Unit Decimals
ORDERUNIT 10 Unit of Measure
PROJECT 16 Project
RQNCSEQ 10 Requisition Comment Sequence
RQNLREV 10 Line Number
RQNLSEQ 10 Requisition Line Sequence
STOCKDECML 2 Stock Unit Decimals
VDNAME 60 Name
VENDITEMNO 24 Vendor Item Number
Detail Comments

RQNCREV 10 Comment Identifier
RQNCSEQ 10 Requisition Comment Sequence
COMMENTTYP 2 Line Type
COMMENT 80 Comments/Instructions
Company Information

ADDR01 60 Company Address Line 1
BRANCH 6 Company Branch Code
CITY 30 Company City
CNTRYCODE 6 Company Country Code
CONTACT 60 Company Contact Name
COUNTRY 30 Company Country
FAX 30 Company Fax Number
MULTICURSW 2 Multicurrency Option
ORGID 6 Company Database ID
PHONE 30 Company Phone Number
POSTAL 20 Company Zip/Postal Code
RATETYPE 2 Company Default Rate Type
STATE 30 Company State
WARNDAYS 2 Company Date Spread
The following table lists the fields that you can place on purchase orders.
Purchase Order Header Fields
Field Length Description

BTADDRESS1 60 Bill-To Address Line 1
BTCITY 30 Bill-To City
BTCODE 6 Bill-To Code
BTCONTACT 60 Bill-To Contact
BTCOUNTRY 30 Bill-To Country
BTDESC 60 Bill-To Description
BTFAX 30 Bill-To Fax Number
BTPHONE 30 Bill-To Phone Number
BTSTATE 30 Bill-To State/Province
BTZIP 20 Bill-To Zip/Postal Code
COMMENT 250 Purchase Order Comment
CURRENCY 3 Currency
DATE 5 Purchase Order Date
DESCRIPTIO 60 Purchase Order Description
DOCSOURCE 2 Document Source
DOCTOTAL 10 Total
FCAMOUNT 10 Conversion Functional-Currency Amount
FOBPOINT 60 FOB Point
HASRQNDATA 2 Created From Requisitions
ISPRINTED 2 Printed
ONHOLD 2 Purchase Order On Hold Status
PORTYPE 2 Purchase Order Type
REFERENCE 60 Purchase Order Reference
SCAMOUNT 10 Conversion Source-Currency Amount
SCURNDECML 2 Number of Decimal Places in Source Currency
STADDRESS1 60 Ship-To Address Line 1
STCITY 30 Ship-To City
STCODE 6 Ship-To Code
STCONTACT 60 Ship-To Contact
STCOUNTRY 30 Ship-To Country
STDESC 60 Ship-To Description
STFAX 30 Ship-To Fax Number
STPHONE 30 Ship-To Phone Number
STSTATE 30 Ship-To State/Province
STZIP 20 Ship-To Zip/Postal Code
TAXAMOUNT 10 Total Tax
TAXAMOUNT1 10 Tax Amount 1
TAXAUTH1 12 Tax Authority Code 1
TERMSCODE 6 Terms Code
TXALLOAMT1 10 Allocated Tax Amount 1
TXEXCLUDE1 10 Excluded Tax Amount 1
TXEXPSAMT1 10 Expensed Tax Amount 1
TXINCLUDE1 10 Included Tax Amount 1
TXRECVAMT1 10 Recoverable Tax Amount 1
VCAVAILABL 10 Amount Remaining (blanket purchase order)
VCORIGINAL 10 Amount Originally Authorized (blanket PO)
VDADDRESS1 60 Vendor's Address Line 1
VDCITY 30 Vendor's City
VDCONTACT 60 Vendor's Contact
VDCOUNTRY 30 Vendor's Country
VDFAX 30 Vendor's Fax Number
VDPHONE 30 Vendor's Phone Number
VDSTATE 30 Vendor's State/Province
VDZIP 20 Vendor's Zip-Postal Code
VIACODE 6 Ship-Via Code
VIANAME 60 Ship-Via Name (description)
TRCURRENCY 3 Tax Reporting Currency
RATERC 8 Tax Reporting Exchange Rate
SPREADRC 8 Tax Reporting Rate Spread
RATETYPERC 2 Tax Reporting Rate Type
RATEMTCHRC 2 Tax Reporting Rate Match Type
RATEDATERC 5 Tax Reporting Rate Date
RATEOPERRC 2 Tax Reporting Rate Operation
RATERCOVER 2 Tax Reporting Rate Overridden
RCURNDECML 2 Tax Reporting Decimal Places
TARAMOUNT1 10 Tax Reporting Amount 1
TRINCLUDE1 10 Tax Reporting Included Amount 1
TREXCLUDE1 10 Tax Reporting Excluded Amount 1
TRRECVAMT1 10 Tax Reporting Recoverable Amt. 1
TREXPSAMT1 10 Tax Reporting Expense Amount 1
TRALLOAMT1 10 Tax Reporting Allocated Amount 1
Purchase Order Detail Lines

ARUNIT 10 A/R Unit of Measure
BILLCURR 3 Billing Currency
BILLRATE 10 Billing Rate
CITY 30 City
CONTACT 60 Contact
COUNTRY 30 Country
DESC 60 Description
EXTENDED 10 Extended Cost
FAX 30 Fax Number
HASCOMMENT 2 Comments/Instructions
IDCUST 12 Customer
ISRECEIVED 2 Received
OQOUTSTAND 10 Quantity Outstanding
PORCSEQ 10 Purchase Order Comment Sequence
PORHSEQ 10 Purchase Order Sequence Key
PORLREV 10 Line Number
PORLSEQ 10 Purchase Order Line Sequence
PROJECT 16 Project
STPRINT 2 Print Status
TXBASEALLO 10 Net of Tax
TXINCLUDED 10 Tax Included
UCISMANUAL 2 Unit Cost is Manual
WEIGHTCONV 10 Weight Conversion
DEFUWEIGHT 10 Default Unit Weight
DEFEXTWGHT 10 Default Extended Weight
Purchase Order Detail Comments

COMMENT 80 Comments/Instructions
PORCREV 10 Comment Identifier
PORCSEQ 10 Purchase Order Comment Sequence
Company Information

ADDR01 60 Comppny Address Line 1
Item Information

Vendor Information

EMAIL2 50 Vendor's E-mail
WEBSITE 100 Vendor's Web Site
Vendor Comments Information

TEXTCMNT 250 Comment
Vendor Terms Information

CODEDESC 60 Description
Purchase Order Options

FAX 30 Fax Number
CONTACT 60 Contact
The following table lists the fields that you can place on receiving slips.
Receipt Header Fields

AMOUNT 10 Amount
BILLLINES 4 Billable Lines
COMMENT 250 Receipt Comment
COSTS 4 Costs
COSTSBLPRO 4 Cost Billing Rates Prorated
COSTSCMPL 4 Costs Complete
COSTSPRORA 4 Number of Cost Prorated
DATE 5 Receipt Date
DESCRIPTIO 60 Receipt Description
DOCTOTAL 10 Receipt Total
FISCPERIOD 2 Fiscal Period
FISCYEAR 4 Fiscal Year
FOBPOINT 60 FOB Point
ISINVOICED 2 Invoiced
ISPRINTED 2 Printed
JOBCOSTS 4 Job Related Costs
LINES 4 Lines
LINESPRORA 4 Number of Lines Prorated
MPRORATED 10 Manual Proration Total
MTOPRORATE 10 Manual To Prorate
PDRATE 8 Exchange Rate Used on the Purchase Order
PDRATEDATE 5 Rate Date Used on the Purchase Order
PDRATEOPER 2 Rate Operation Used on the Purchase Order
PDRATEOVER 2 Rate Override Used on the Purchase Order
PDRATETYPE 2 Rate Type Used on the Purchase Order
RATE 8 Exchange Rate
RATEMATCH 2 Rate Match Type
RATEOVER 2 Rate Overridden
RCPHSEQ 10 Receipt Sequence Key
RCPNUMBER 22 Receipt Number
REFERENCE 60 Receipt Reference
RQRECEIVED 10 Quantity Received
RTGBASE 2 Retainage Base
RTGTERMS 6 Retainage Terms Code
SPREAD 8 Rate Spread
TAXBASE1 10 Tax Base 1
TXALLOAMT 10 Total Allocated Tax
TXEXCLUDED 10 Tax Excluded
TXEXPSAMT 10 Total Expensed Tax
TXRECVAMT 10 Total Recoverable Tax
VENDS 4 Vendors
VENDSCMPL 4 Vendors Completed
VENDSINVC 4 Vendors Invoiced
VIANAME 60 Ship-Via Name (Description)
RATERC 8 Tax Reporting Exchange RateR
SPREADRC 8 Tax Reporting Rate Spread
RATETYPERC 2 Tax Reporting Rate Type
RTGTAXREP 2 Report Retainage Tax
RAXBASE1 10 Retainage Tax Base 1
RAXAMOUNT1 10 Retainage Tax Amount 1
RXRECVAMT1 10 Retainage Tax Recoverable Amt. 1
RXEXPSAMT1 10 Retainage Tax Expense Amount 1
RXALLOAMT1 10 Retainage Tax Allocated Amount 1
Receipt Item Details

CITY 30 City
CONTACT 60 Contact
COUNTRY 30 Country
DESC 60 Description
DROPTYPE 2 Drop-Ship Type
DTARRIVAL 5 Arrival Date
FAX 30 Fax Number
GLACEXPENS 45 Expense Account
HASCOMMENT 2 Comments
IDCUST 12 Customer
LABELCOUNT 2 Number of Labels
LOCATION 6 Location
MPRORATED 10 Manual Proration
OQRCPEXTRA 10 Received Extra
ORDERCONV 10 Order Unit Conversion
ORDERDECML 2 Order Unit Decimals
POCOMPLETE 2 Completes PO
PORLSEQ 10 Purchase Order Line Sequence
POSTEDTOIC 2 Posted to I/C
PROJECT 16 Project
RCPCONV 10 Receiving Conversion Factor
RCPCSEQ 10 Receipt Comment Sequence
RCPDECML 2 Receiving Unit Decimals
RCPLREV 10 Line Number
RCPLSEQ 10 Receipt Line Sequence
RCPUNIT 10 Unit of Measure
RQCANCELED 10 Quantity Canceled
RQINADJUST 10 Quantity Adjusted by Invoice
RQORDERED 10 Quantity Ordered
RQOUTSTAND 10 Quantity Outstanding
RQOUTSTPO 10 Quantity Outstanding on Purchase Order
RQPOFILLED 10 Quantity Filled on PO
RQPREVRECV 10 Received to Date
RQRCPEXTRA 10 (R) Quantity Received Extra
RQRETURNED 10 Quantity Returned
RQSETTLED 10 Quantity Settled
RQSTOCKED 10 Quantity Stocked
RQUSTOCKED 10 Quantity Unstocked
RTGDAYS 2 Retention Period
TAXCLASS1 2 Tax Class 1
TAXINCLUD1 2 Tax Includable 1
TAXRATE1 8 Tax Rate 1
TXALLOAMT 10 Allocated Tax
TXALLOAMT1 10 Tax Allocated Amount 1
TXEXPSAMT 10 Expensed Tax
TXEXPSAMT1 10 Tax Expense Amount 1
TXRECVAMT 10 Recoverable Tax
TXRECVAMT1 10 Tax Recoverable Amount 1
Receipt Additional Cost Details

VDCODE 12 Vendor
RCPSREV 10 Line Number
RCPSSEQ 10 Receipt Cost Sequence
ADDCOST 6 Additional Cost
AMOUNT 10 Amount
CALCLABOR 2 Calculate Labor
CALCOVRHD 2 Calculate Overhead
COMMENT 250 Comment
DESCRIPTIO 60 Description
GLEXPACCT 45 Expense Account
GLRETACCT 45 Return Account
PRORMETHOD 2 Proration Method
PROJECT 16 Project
REPRORATE 2 Reproration Method
RESOURCE 24 Resource
TAXICLASS1 2 Cost Tax Class 1
TXRECVAMT 10 Total Tax Recoverable
TXEXPSAMT 10 Total Tax Expensed
TXALLOAMT 10 Total Tax Allocated
Receipt Detail Comments

COMMENT 80 Comment
RCPCREV 10 Comment Identifier
RCPCSEQ 10 Receipt Comment Sequence
Company Information

The following table lists the fields that you can place on returns.
Return Header Fields

AMOUNT 10 Amount
COMMENT 250 Return Comment
DATE 5 Return Date
DESCRIPTIO 60 Return Description
DOCTOTAL 10 Return Total
DTCOMPLETE 5 Completion Date
FISCPERIOD 2 Fiscal Period
FISCYEAR 4 Fiscal Year
ISCOMPLETE 2 Completion Status
ISCREDITED 2 Credit Note Status
ISPRINTED 2 Printed
LABELCOUNT 2 Number of Labels
LABELPRINT 2 Labels Printed
LINES 4 Lines
PDRATE 8 Exchange Rate Used on the Receipt
PDRATEDATE 5 Rate Date Used on the Receipt
PDRATEOPER 2 Rate Operation Used on the Receipt
PDRATEOVER 2 Rate Override Used on the Receipt
PDRATETYPE 2 Rate Type Used on the Receipt
PORDATE 5 Purchase Order Date
RATE 8 Exchange Rate
RATEMATCH 2 Rate Match Type
RATEOVER 2 Rate Overridden
RCPDATE 5 Receipt Date
RCPNUMBER 22 Receipt Number
REFERENCE 60 Return Reference
RETHSEQ 10 Return Sequence Key
RETNUMBER 22 Return Number
RTGBASE 2 Retainage Base
SPREAD 8 Rate Spread
TXALLOAMT 10 Total Allocated Tax
TXEXPSAMT 10 Total Expensed Tax
TXRECVAMT 10 Total Recoverable Tax
VIANAME 60 Ship-Via Name (Description)
RATERC 8 Tax Reporting Exchange Rate
RSPREADRC 8 Tax Reporting Rate SpreadR
ATETYPERC 2 Tax Reporting Rate Type
RTGTAXREP 2 Report Retainage Tax
Return Detail Lines

EXTENDED 10 Return Cost
GLACEXPENS 45 Expense Account
HASCOMMENT 2 Comments
LOCATION 6 Location
POSTEDTOIC 2 Posted to I/C
PROJECT 16 Project
RCPLSEQ 10 Receipt Line Sequence
RETCONV 10 Returning Conversion Factor
RETCSEQ 10 Return Comment Sequence
RETDECML 2 Returning Unit Decimals
RETLREV 10 Line Number
RETLSEQ 10 Return Line Sequence
RETUNIT 10 Unit of Measure
RQPREVRETN 10 Quantity Previously Returned
SCRECEIVED 10 Extended Cost
SQRECEIVED 10 (S) Quantity Received
SQRETURNED 10 (S) Quantity Returned
TXALLOAMT 10 Allocated Tax
TXEXPSAMT 10 Expensed Tax
TXRECVAMT 10 Recoverable Tax
Return Detail Comments

COMMENT 80 Comment
RETCREV 10 Comment Identifier
RETCSEQ 10 Return Comment Sequence
Company Information

The following table list the fields that you can place on mailing labels.

COUNTRY 30 Vendor's Country
VDSTATE 30 Vendor's State or Province
ZIP 20 Vendor's Zip or Postal Code
/wiki/Documentation:Print_Formats_for_Purchase_Orders_Forms"

Sage300 ParametersForCustomizingPrintedForms

Uploaded by

Copyright:

Available Formats

Sage300 ParametersForCustomizingPrintedForms

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Sage300 ParametersForCustomizingPrintedForms

Uploaded by

Copyright:

Available Formats

Sage 300

Copyright © 2015. Sage Software, Inc. All rights reserved.

Sage End User License: http://na.sage.com/sage-na/eula

Last updated: August 29, 2015

The check forms installed by Accounts Payable are:

Name Format Maximum Advice Lines

On a check, you can print:

On a mailing label, you can print:

In a vendor letter, you can print:

Database Table BKREG - Bank Check Register Information

Field Name Length Description

Database Table APADV - Advice Information

Field Name Length Description

Database Table CSCOM - Company Profile Information (for 1099/CPRS forms)

Field Name Length Description

Field Name Length Description

Field Name Length Description

Retrieved from "http://dppwiki.sage300erp.com

This page was last modified on 10 June 2013, at 17:01.

The check forms installed are:

Name Format Maximum Advice Lines

The statement forms installed are:

Name Use with Preprinted Forms

The invoice forms installed are:

Name Use with Preprinted Forms Description

The receipt form installed is:

Name Use with Preprinted Forms Description

On a mailing label, you can print:

On a customer invoice, you can print:

On a customer statement, you can print:

In a customer letter, you can print:

Invoice Header Information (Table ARIBH)

Field Name Length Description

Invoice Detail Information (Table ARIBD)

Field Name Length Description

Invoice Detail Comment Information (Table ARIBT)

Field Name Length Description

Customer Record Information (Table ARCUS)

Field Name Length Description

Billing Cycle Information (ARRBC)

Field Name Length Description

Statements are produced from the following 5 tables:

Field Name Length Description

Field Name Length Description

Field Name Length Description

Field Name Length Description

Field Name Length Description

Field Name Length Description

Retrieved from "http://dppwiki.sage300erp.com

This page was last modified on 10 June 2013, at 19:04.

Item Number Fields

Field Name Length Description

Item Location Fields

Field Name Length Description

Item Categories Fields

Field Name Length Description

Item Segments Fields

Field Name Length Description

Segment Codes Fields