Domain Documentation

Domain Name

Field Type

Field Size

Display Width

Uppercase

Enum Values

Account Code

String

28 

16 

Yes

Account File

String

8 

8 

Yes

Account Phone Number

String

20 

20 

Account Phone Number 2

String

20 

20 

Account Phone Number 3

String

20 

20 

Address

String

40 

40 

Address 1

String

40 

40 

Address 1 U

UString

40 

40 

Address 2

String

40 

40 

Address 2 U

UString

40 

40 

Address 3

String

40 

40 

Address 3 U

UString

40 

40 

Address 4

String

40 

40 

Address 4 U

UString

40 

40 

Address 5

String

40 

40 

Address 5 U

UString

40 

40 

Address Line

String

40 

40 

Address Line U

UString

40 

40 

AliasType

String

1 

6 

Yes

A (Alias), M (Merge)

Amount

Float

12 

AmountWord

String

20 

10 

Analysis Code

String

8 

8 

Yes

Analysis Name

String

60 

40 

AnalysisFilter

String

1 

14 

Yes

E (Expense/Asset), G (General/All), I (Income/Liability), N (Not Available)

AP Allocation ID

RowID

10 

AP Category 1 Code

String

8 

8 

Yes

AP Category 2 Code

String

8 

8 

Yes

AP Contact Custom 1 Text

String

30 

30 

AP Contact Custom 2 Text

String

30 

30 

AP Contact ID

RowID

10 

AP Cost Code

String

8 

8 

Yes

AP Creditor Code

String

16 

16 

Yes

AP Creditor Group Code

String

8 

8 

Yes

AP Delta ID

RowID

10 

AP Expense Code

String

8 

10 

Yes

AP FX Variation ID

RowID

10 

AP Link ID

RowID

10 

AP Memo ID

RowID

10 

AP Shipment Category 1 Code

String

8 

8 

Yes

AP Shipment Category 2 Code

String

8 

8 

Yes

AP Shipment Cost ID

RowID

10 

AP Shipment Custom 1 Text

String

30 

30 

AP Shipment Custom 2 Text

String

30 

30 

AP Shipment ID

RowID

10 

AP Shipment Line Custom 1 Text

String

30 

30 

AP Shipment Line Custom 2 Text

String

30 

30 

AP Shipment Line ID

RowID

10 

AP Transaction ID

RowID

10 

APAddressType

String

1 

10 

Yes

C (Creditor), P (Physical)

APAnalysisMode

String

1 

8 

Yes

C (Cost Price Excl), E (Exclusive Amount), I (Inclusive Amount)

APApportionType

String

1 

8 

Yes

C (Cost), Q (Quantity), V (Volume), W (Weight), M (Manual)

APCostPriceBasis

String

1 

8 

Yes

S (Standard), L (Latest), N (None)

APCreditorType

String

1 

14 

Yes

N (Normal), P (Prospect), O (One-time)

APDocumentClass

String

1 

12 

Yes

I (Invoice Only), O (Order), Q (Quotation), R (Receipt Only), S (Shipment), T (Standing)

APEmailConsolidationType

String

1 

9 

Yes

N (None), E (Email), C (Creditor and Email)

APLineType

String

1 

3 

Yes

P (Product), N (Narrative)

APPaymentDefaultComment

String

1 

30 

Yes

N (None), S (Single transaction reference), A (All transaction references)

APPaymentMethod

String

1 

20 

Yes

C (Computer Printed Cheque), I (Credit Card), D (Direct Debit), E (Electronic), L (Letter of Credit), M (Manual), R (Remittance), T (Telegraphic Transfer)

APPrintStatus

String

1 

12 

Yes

U (Unprinted), P (Printed)

APShipmentCostMode

String

1 

8 

Yes

D (Divide Amount), M (Multiply Cost)

APShipmentInvoiceStatus

String

1 

11 

Yes

U (Unposted), P (Posted), D (Deleted), N (Not Applicable)

APShipmentLineStatus

String

1 

11 

Yes

U (Unposted), P (Posted), D (Deleted), N (Not Applicable)

APShipmentPostStatus

String

1 

11 

Yes

U (Unprocessed), O (Open), P (Processed), D (Deleted)

APShipmentReceiptStatus

String

1 

11 

Yes

U (Unposted), P (Posted), D (Deleted), N (Not Applicable)

APShipmentType

String

1 

10 

Yes

S (Shipment), I (Invoice Only), R (Receipt Only)

APSupplierCostBasis

String

1 

22 

Yes

C (Supplier Cost), S (Supplier Standard Cost)

APTranEnterType

String

1 

8 

Yes

I (Invoice), C (Credit), P (Payment), J (Journal), H (Cash Purchase)

APTranPrintStatus

String

1 

6 

Yes

Chr(0) (), U (Unprinted), P (Printed)

APTranType

String

1 

8 

Yes

I (Invoice), C (Credit), P (Payment), J (Journal)

AR Address ID

RowID

10 

AR Allocation ID

RowID

10 

AR Category 1 Code

String

8 

8 

Yes

AR Category 2 Code

String

8 

8 

Yes

AR Contact Custom 1 Text

String

30 

30 

AR Contact Custom 2 Text

String

30 

30 

AR Contact ID

RowID

10 

AR Customer Code

String

16 

16 

Yes

AR Customer Group Code

String

8 

8 

Yes

AR Delivery Code

String

20 

20 

Yes

AR Delivery Custom 1 Text

String

30 

30 

AR Delivery Custom 2 Text

String

30 

30 

AR Delta ID

RowID

10 

AR FX Variation ID

RowID

10 

AR Link ID

RowID

10 

AR Memo ID

RowID

10 

AR Sales Area Code

String

8 

8 

Yes

AR Sales Group Code

String

8 

8 

Yes

AR Sales Person Code

String

8 

8 

Yes

AR Transaction ID

RowID

10 

ARAddressType

String

1 

10 

Yes

C (Customer), D (Delivery)

ARAPAccountType

String

1 

15 

Yes

B (Balance Forward), O (Open Item)

ARAPAutoAllocate

String

1 

14 

Yes

A (All), W (Whole Balances), N (None)

ARAPTransactionRange

String

1 

12 

Yes

P (Period), Y (Year), H (History), U (Unallocated)

ARCommissionBasis

String

1 

6 

Yes

S (Sales), P (Profit)

ARCommissionGroups

String

1 

12 

Yes

A (Area), P (Sales Person)

ARCustomerType

String

1 

14 

Yes

N (Normal), P (Prospect), C (Cash), O (One-time)

ARDocumentClass

String

1 

16 

Yes

I (Invoice), C (Credit), O (Order), Q (Quote), B (Back Order), P (Packing Slip), T (Standing Order), S (Standing Invoice)

ARPaymentUnit

String

1 

8 

Yes

P (Period), M (Months), W (Weeks), D (Days)

ARStatementStyle

String

1 

15 

Yes

B (Balance Forward), O (Open Item), N (None)

ARStatementUnit

String

1 

8 

Yes

P (Period), M (Months), D (Days)

ARStopCreditWhen

String

1 

20 

Yes

N (Never), O (Outstanding Paid), F (Fully Paid)

ARTranEnterType

String

1 

7 

Yes

I (Invoice), C (Credit), R (Receipt), J (Journal)

ARTranType

String

1 

7 

Yes

I (Invoice), C (Credit), R (Receipt), J (Journal)

Auth Password

String

54 

30 

BackupFormat

String

1 

10 

Yes

Z (Zip), S (7 Zip)

Bank Account No

String

34 

34 

Bank Address 1

String

40 

40 

Bank Address 1 U

UString

40 

40 

Bank Address 2

String

40 

40 

Bank Address 2 U

UString

40 

40 

Bank Address 3

String

40 

40 

Bank Address 3 U

UString

40 

40 

Bank Address 4

String

40 

40 

Bank Address 4 U

UString

40 

40 

Bank Address 5

String

40 

40 

Bank Address 5 U

UString

40 

40 

Bank Branch

String

20 

20 

Bank Drawer

String

30 

30 

Bank Identifier Code

String

12 

12 

Yes

Bank Name

String

5 

5 

Bank Payee

String

40 

40 

Bar Code

String

28 

16 

Yes

BindType

String

1 

24 

Yes

F (Accredo Form), U (Custom Form), C (Custom Report), G (GL Financial Report), J (JC Report), P (PA Report), R (Report List), I (Script List), A (SA Report), S (Script), L (SP Price List), D (SP Rule List Definition), H (PP Price List), E (PP Rule List Definition), T (TD Custom Table Form), V (List View)

BooleanYesNo

String

1 

3 

Yes

Y (Yes), N (No)

Category Name

String

15 

15 

CB Analysis Code

String

8 

8 

Yes

CB Automatic Payment Code

String

8 

10 

Yes

CB Bank Account Code

String

8 

8 

Yes

CB Category 1 Code

String

8 

8 

Yes

CB Category 2 Code

String

8 

8 

Yes

CB Delta ID

RowID

10 

CB FX Variation ID

RowID

10 

CB Link ID

RowID

10 

CB Memo ID

RowID

10 

CB Rule ID

RowID

10 

CB Statement ID

RowID

10 

CB Statement Line ID

RowID

10 

CB Summary ID

RowID

10 

CB Summary Item ID

RowID

10 

CB Transaction ID

RowID

10 

CBApplyRulesOption

String

1 

20 

Yes

A (Automatic), Q (Query)

CBBankingStatus

String

1 

9 

Yes

B (Banked), U (Unbanked), D (Deleted), E (Exported)

CBBankingType

String

1 

6 

Yes

C (Cash), Q (Cheque), O (Other)

CBPaymentUnit

String

1 

6 

Yes

D (Days), W (Weeks), M (Months)

CBRuleType

String

1 

12 

Yes

W (Withdrawal), D (Deposit), T (Transfer), R (Receipt), P (Payment), C (Cash Purchase)

CBStatementStatus

String

1 

6 

Yes

O (Open), C (Closed)

CBSummaryType

String

1 

20 

Yes

B (Bank Deposits), E (Electronic Payments), P (Payments), D (Direct Debits)

CBTransactionRange

String

1 

12 

Yes

P (Period), Y (Year), H (History), U (Unreconciled)

CBTranType

String

1 

10 

Yes

W (Withdrawal), D (Deposit), T (Transfer), C (Cheque)

ChangeType

String

1 

6 

Yes

A (Add), U (Update), D (Delete)

Character

String

1 

1 

Yes

CO Alias ID

RowID

10 

CO Bank Change ID

RowID

10 

CO Bind ID

RowID

10 

CO Branch Code

String

8 

8 

Yes

CO Branch Custom 1 Text

String

30 

30 

CO Branch Custom 2 Text

String

30 

30 

CO Company Code

String

8 

8 

Yes

CO Contact Category 1 Code

String

8 

8 

Yes

CO Contact Category 2 Code

String

8 

8 

Yes

CO Contact Custom 1 Text

String

30 

30 

CO Contact Custom 2 Text

String

30 

30 

CO Contact ID

RowID

10 

CO Country Code

String

2 

2 

Yes

CO Currency Code

String

3 

5 

Yes

CO Currency Symbol

String

8 

6 

CO Customisation ID

RowID

10 

CO Delivery Code

String

20 

20 

Yes

CO Delta ID

RowID

10 

CO Department Code

String

8 

8 

Yes

CO Department Custom 1 Text

String

30 

30 

CO Department Custom 2 Text

String

30 

30 

CO Document Code

String

8 

8 

Yes

CO Event ID

RowID

10 

CO FX Rate Type Code

String

8 

8 

Yes

CO Gst Code

String

4 

4 

Yes

CO Gst Rate ID

RowID

10 

CO Layout ID

RowID

10 

CO Link Category 1 Code

String

8 

8 

Yes

CO Link Category 2 Code

String

8 

8 

Yes

CO Link ID

RowID

10 

CO Media Code

String

8 

8 

Yes

CO Memo Category 1 Code

String

8 

8 

Yes

CO Memo Category 2 Code

String

8 

8 

Yes

CO Memo Custom 1 Text

String

30 

30 

CO Memo Custom 2 Text

String

30 

30 

CO Memo ID

RowID

10 

CO Menu ID

RowID

10 

CO Price Code

String

8 

8 

Yes

CO Print ID

RowID

10 

CO Setting Log ID

RowID

10 

CO Tax Regime Code

String

2 

2 

Yes

CO Text Code

String

8 

8 

Yes

CO UOM Code

String

8 

8 

Yes

CO UOM Custom 1 Text

String

30 

30 

CO UOM Custom 2 Text

String

30 

30 

CO UOM Group Code

String

8 

8 

Yes

CO UOM Name

String

8 

8 

CO User Code

String

8 

8 

Yes

CO User Custom 1 Text

String

30 

30 

CO User Custom 2 Text

String

30 

30 

CO Web Custom Entity Type

String

16 

16 

CO Web Custom ID

RowID

10 

COContactLookupSortOrderType

String

1 

18 

Yes

F (FirstName/LastName), L (LastName/FirstName)

COCtrlArrow

String

1 

8 

Yes

W (Word), C (Column), F (Field)

CODecimalGrouping

String

1 

8 

Yes

B (Base), C (Currency), N (None)

CODocumentClass

String

1 

10 

Yes

I (Invoice), C (Credit), O (Order), Q (Quote), B (Back Order), S (Shipment), T (Standing)

COLinkType

String

1 

4 

Yes

F (File), W (Web)

COMemoTabOrderingType

String

1 

12 

Yes

D (Descending Date), A (Ascending Date)

Comment

String

30 

30 

CompanyType

String

1 

4 

Yes

L (Live), D (Demo), T (Test)

CONavBtnVisibility

String

1 

11 

Yes

T (Toolbar and Menu), M (Menu Only), N (Not Visible)

CONegativeFormat

String

1 

9 

Yes

L (Leading), T (Trailing), B (Bracketed)

Contact Fullname

String

84 

35 

Contact Fullname U

UString

84 

35 

Contact Name

String

20 

20 

Contact Name U

UString

20 

20 

Contact Phone Number

String

20 

20 

Contact Phone Number 2

String

20 

20 

Contact Phone Number 3

String

20 

20 

Contact Suffix

String

10 

10 

Contact Title

String

10 

10 

Control Name

String

60 

60 

COOptimiseType

String

1 

11 

Yes

N (None), R (Recommended), A (All)

COPostStatus

String

1 

8 

Yes

U (Unposted), O (Open), P (Posted), D (Deleted), C (Counted)

COPrintStatus

String

1 

12 

Yes

U (Unprinted), P (Printed), M (Manual), K (Packing Slip), C (Confirmed), Q (Quoted)

COReportUserCode

String

1 

4 

Yes

N (None), 1 (One), * (Many)

Cost Price

Float

10 

COUserType

String

1 

5 

Yes

U (User), G (Group), R (Role)

Custom

String

30 

Custom Text

String

60 

60 

Custom U

UString

30 

DayOrMonth

String

1 

5 

Yes

D (Days), M (Month)

DebitCredit

String

1 

12 

Yes

D (Debit), C (Credit)

Decimal 1

Float

10 

Decimal 2

Float

10 

Decimal 3

Float

10 

Decimal 4

Float

10 

Decimal 5

Float

10 

Decimal 6

Float

10 

Delivery Address

String

40 

40 

Delivery Address 1

String

40 

40 

Delivery Address 1 U

UString

40 

40 

Delivery Address 2

String

40 

40 

Delivery Address 2 U

UString

40 

40 

Delivery Address 3

String

40 

40 

Delivery Address 3 U

UString

40 

40 

Delivery Address 4

String

40 

40 

Delivery Address 4 U

UString

40 

40 

Delivery Address 5

String

40 

40 

Delivery Address 5 U

UString

40 

40 

Depreciation Rate

Float

9 

Description

String

60 

60 

Description U

UString

60 

60 

Description_Wrap

String

61 

61 

Discount

Float

6 

DiscountMode

String

1 

8 

Yes

I (Implicit), E (Explicit)

DismissReminderOptions

String

1 

10 

Yes

I (Inactivate), M (To Memo)

Display Label

String

64 

20 

Document No

String

30 

20 

Yes

DocumentType

String

1 

8 

Yes

N (Normal), H (Historic)

Domain Name

String

40 

40 

Duty Rate

Float

10 

Email Address

String

120 

60 

EmailType

String

1 

12 

Yes

P (Primary), C (Contact), T (Statement), I (Invoice), Q (Quote), K (Packing Slip), R (Remittance), O (Order), S (Salesperson), E (Storeperson), J (Jobperson), B (Branch), A (Authorisation), U (User), H (Shipment), Y (Payee)

Emergency Phone Number

String

20 

20 

Emergency Phone Number 2

String

20 

20 

Encrypted Password

String

72 

30 

Encrypted SMTP Password

String

160 

30 

EndOfPeriodType

String

1 

6 

Yes

P (Period), Y (Year)

Event Name

String

64 

64 

Exchange Rate

Float

10 

FA Asset Code

String

16 

16 

Yes

FA Asset Custom 1 Text

String

60 

60 

FA Asset Custom 2 Text

String

60 

60 

FA Asset Group Code

String

8 

8 

Yes

FA Asset Location Code

String

8 

8 

Yes

FA Book Code

String

8 

8 

Yes

FA Category 1 Code

String

8 

8 

Yes

FA Category 2 Code

String

8 

8 

Yes

FA Delta ID

RowID

10 

FA Depreciation Code

String

3 

2 

Yes

FA Dissection ID

RowID

10 

FA Line ID

RowID

10 

FA Link ID

RowID

10 

FA Memo ID

RowID

10 

FA Transaction ID

RowID

10 

FA Useful Life

Float

10 

FAAssetStatus

String

1 

17 

Yes

N (Pending), A (Added), D (Depreciating), F (Fully Depreciated), P (Disposed)

FABookStatus

String

1 

7 

Yes

P (Pending), O (Open), C (Closed)

FADepreciation

String

1 

16 

Yes

N (Depreciate later), Y (Depreciate now), D (Depreciating)

FADisposal

String

1 

25 

Yes

N (No depreciation this year), Y (Depreciation this year)

FADissType

String

1 

12 

Yes

A (Asset), D (Depreciation), E (Expense), C (Recovered), R (Reserve), W (Writedown), G (Gain), L (Loss), F (Funds), J (Adjustment)

FAIntegrated

String

1 

14 

Yes

N (Not Integrated), A (Asset), M (Maintenance)

FAPostStatus

String

1 

8 

Yes

U (Unposted), P (Posted)

FARevaluation

String

1 

22 

Yes

N (Preserve depreciation), Y (Writeback depreciation)

FATranType

String

1 

12 

Yes

A (Addition), D (Depreciation), R (Revaluation), P (Disposal), J (Adjustment)

File Extension

String

10 

10 

File Path

String

255 

30 

FlushMode

String

1 

5 

Yes

A (All), B (Batch), N (None)

FolderType

String

1 

12 

Yes

S (System), C (Company), N (Nominated)

Friendly Account Code

String

10 

10 

Yes

FX Amount

Float

12 

FX Cash Rounding

String

9 

9 

FX Cost Price

Float

10 

FX Price

Float

10 

FX Raw Cost Price

Float

FX Raw Sell Price

Float

FX Sell Price

Float

10 

FXDecimalSymbol

String

1 

6 

Yes

P (Period), C (Comma), N (None)

FXGroupingSymbol

String

1 

14 

Yes

S (Space), P (Period), C (Comma), A (Apostrophe), N (None)

FXRateCalc

String

1 

8 

Yes

M (Multiply), D (Divide)

FXSymbolPos

String

1 

16 

Yes

N (Not Shown), L (Leading No Space), T (Trailing No Space), D (Leading with Space), R (Trailing with Space)

GeoCoordinate

Float

14 

GL Account Code

String

8 

8 

Yes

GL AIM Code

String

60 

30 

Yes

GL Analysis Code

String

8 

12 

Yes

GL Batch ID

RowID

10 

GL Budget Code

String

8 

8 

Yes

GL Category 1 Code

String

8 

12 

Yes

GL Category 2 Code

String

8 

12 

Yes

GL Delta ID

RowID

10 

GL External Account Code

String

20 

20 

Yes

GL Line ID

RowID

10 

GL Link ID

RowID

10 

GL Memo ID

RowID

10 

GL Reconciliation ID

RowID

10 

GL Transaction ID

RowID

10 

GLAccountClass

String

1 

9 

Yes

A (Asset), C (Capital), E (Expense), I (Income), L (Liability)

GLAccountType

String

1 

11 

Yes

S (Standard), N (Non Posting), T (Total), H (Heading)

GLAnalysis

String

1 

13 

Yes

A (Account Code), E (External Code), F (Friendly Code), N (None)

GLBatchClass

String

1 

15 

Yes

G (GL Batch), M (Module Batch), R (Reversing Journal), S (Standing Journal), T (Template Batch), O (Reversing Out), I (Imported)

GLBudgetPreserveValue

String

1 

8 

Yes

A (Activity), C (Closing)

GLCashFlowDirection

String

1 

8 

Yes

I (Inwards), O (Outwards)

GLCashFlowType

String

1 

13 

Yes

O (Operating), I (Investing), F (Financing), N (Non-Cash), P (Non-Operating)

GLCompareAction

String

1 

10 

Yes

N (None), A (Add), E (Edit), D (Delete), I (Inactivate)

GLExportCode

String

1 

21 

Yes

A (Accredo Account Code), F (Friendly Account Code), E (External Account Code)

GLHeadingStyle

String

1 

11 

Yes

1 (Heading 1), 2 (Heading 2), 3 (Heading 3), 0 (Heading 0)

GLIntegrate

String

1 

14 

Yes

S (Summarised), D (Detailed), N (Not integrated)

GLPostStatus

String

1 

10 

Yes

U (Unposted), P (Posted), D (Deleted)

GLReconciliationStatus

String

1 

7 

Yes

O (Open), C (Closed), D (Deleted)

GLTotalStyle

String

1 

8 

Yes

0 (Total 0), 1 (Total 1), 2 (Total 2), 3 (Total 3), 4 (Total 4), @ (Total @), N (Non printing)

GLTranOption

String

1 

9 

Yes

R (Replicate), I (Increment), B (Blank)

GLZeroHold

String

1 

4 

Yes

Z (Zero), H (Hold)

GST Link ID

RowID

10 

GST Memo ID

RowID

10 

GST Return ID

RowID

10 

GST Transaction ID

RowID

10 

GstAllTranType

String

1 

10 

Yes

I (Invoice), C (Credit), D (Deposit), W (Withdrawal), A (Adjustment)

GstBasis

String

1 

14 

Yes

I (Invoice), P (Payments), N (Not Registered)

GstBasisAU

String

1 

20 

Yes

I (Accruals (Non-Cash)), P (Cash), N (Not Registered)

GstFilingStatus

String

1 

8 

Yes

U (Unfiled), P (Pending), F (Filed), M (Manual)

GstFilter

String

1 

17 

Yes

E (Purchases/Expense), G (All/General), I (Sales/Income), N (Not Available)

GstPaymentType

String

1 

20 

Yes

W (Withdrawal), E (Electronic Payment)

GstReturnStatus

String

1 

10 

Yes

U (Unposted), P (Posted), F (Final)

GstTransactionClass

String

1 

18 

Yes

S (Sales (Debit)), P (Purchases (Credit))

GstTransactionType

String

1 

20 

Yes

A (Adjustment), G (GST Included), T (Total and GST Included), D (Total and GST Discount), R (GST Round-off)

GstTranType

String

1 

28 

Yes

O (Output (Sales) Adjustment), U (Output (Sales) GST), T (Output (Sales) Taxable), I (Input (Purchases) Adjustment), N (Input (Purchases) GST), P (Input (Purchases) Taxable)

GstType

String

1 

9 

Yes

A (Sales), B (Purchases)

Hours

Float

10 

IC Adjustment Batch ID

RowID

10 

IC Adjustment Line Custom 1 Text

String

30 

30 

IC Adjustment Line Custom 2 Text

String

30 

30 

IC Adjustment Line ID

RowID

10 

IC Alternate Code

String

28 

30 

Yes

IC Bin Code

String

16 

16 

Yes

IC Bin Count Custom 1 Text

String

30 

30 

IC Bin Count Custom 2 Text

String

30 

30 

IC Bin Count ID

RowID

10 

IC Bin Count Line ID

RowID

10 

IC Bin Custom 1 Text

String

30 

30 

IC Bin Custom 2 Text

String

30 

30 

IC Bin ID

RowID

10 

IC Bin Movement Custom 1 Text

String

30 

30 

IC Bin Movement Custom 2 Text

String

30 

30 

IC Bin Movement ID

RowID

10 

IC Bin Movement Line ID

RowID

10 

IC Category 1 Code

String

8 

8 

Yes

IC Category 2 Code

String

8 

8 

Yes

IC Cost ID

RowID

10 

IC Count Custom 1 Text

String

30 

30 

IC Count Custom 2 Text

String

30 

30 

IC Count ID

RowID

10 

IC Count Line ID

RowID

10 

IC Count Status

String

1 

10 

Yes

U (Unconfirmed), C (Confirmed)

IC Count Type

String

1 

8 

Yes

B (Basic), S (Single), A (Additive), D (Detailed)

IC Delta ID

RowID

10 

IC Detail ID

RowID

10 

IC Link ID

RowID

10 

IC Location Code

String

8 

8 

Yes

IC Location Custom 1 Text

String

30 

30 

IC Location Custom 2 Text

String

30 

30 

IC Lot ID

RowID

10 

IC Lot No

String

28 

16 

Yes

IC Manufacture Batch ID

RowID

10 

IC Manufacture Line Custom 1 Text

String

30 

30 

IC Manufacture Line Custom 2 Text

String

30 

30 

IC Manufacture Line ID

RowID

10 

IC Memo ID

RowID

10 

IC Part ID

RowID

10 

IC Product Code

String

28 

30 

Yes

IC Product Part Head Code

String

28 

30 

Yes

IC Quantity ID

RowID

10 

IC Receipt Batch ID

RowID

10 

IC Receipt Line Custom 1 Text

String

30 

30 

IC Receipt Line Custom 2 Text

String

30 

30 

IC Receipt Line ID

RowID

10 

IC Sell ID

RowID

10 

IC Serial Affix

String

4 

4 

Yes

IC Serial ID

RowID

10 

IC Serial No

String

28 

16 

Yes

IC Source Type

String

1 

16 

Yes

I (Invoice), C (Credit), S (Shipment), T (Transfer), K (Stocktake), J (Job), M (Manufacture), O (Sales Order), U (Purchase Order), A (Adjustment Batch), W (Write Off), R (Receipt Batch), B (Bin Movement), N (Bin Count)

IC Stock Group Code

String

8 

10 

Yes

IC Stocktake Class

String

1 

10 

Yes

K (Stocktake)

IC Stocktake ID

RowID

10 

IC Stocktake Import Format

String

1 

12 

Yes

S (Standard), B (Standard with Bin), O (Opticon), U (UOM), D (Detailed)

IC Stocktake Line ID

RowID

10 

IC Stocktake Post Status

String

1 

10 

Yes

U (Uncounted), C (Counted), P (Posted), D (Deleted)

IC Store Person Code

String

8 

8 

Yes

IC Tracking ID

RowID

10 

IC Transaction ID

RowID

10 

IC Transfer ID

RowID

10 

IC Transfer Line Custom 1 Text

String

30 

30 

IC Transfer Line Custom 2 Text

String

30 

30 

IC Transfer Line ID

RowID

10 

IC Unspecified ID

RowID

10 

IC UOM ID

RowID

10 

ICBatchClass

String

1 

12 

Yes

M (Manufacture)

ICBinLocationStatus

String

1 

10 

Yes

A (Active), I (Inactive), M (Missing)

ICBinMovementClass

String

1 

8 

Yes

P (Put-away), K (Pick)

ICComponentMode

String

1 

14 

Yes

N (None), A (Automatic Kitset), M (Manual Kitset), F (Manufacture)

ICCostEffect

String

1 

9 

Yes

A (Average), B (Both), L (Latest), N (None), U (Usages), V (Valuation)

ICCostPriceClass

String

1 

8 

Yes

P (Posted), R (Repriced), S (System), U (Updated)

ICExpiryStatus

String

1 

14 

Yes

A (Allowed), D (Dated), E (Expired)

ICExpiryUnit

String

1 

6 

Yes

D (Days), W (Weeks), M (Months), Y (Years)

ICGenerateFromBin

String

1 

14 

Yes

S (Smallest), G (Greatest)

ICGenerateLotNos

String

1 

11 

Yes

N (None), E (Expiry Date), L (Lot Date)

ICIntegrationBasis

String

1 

10 

Yes

P (Perpetual), I (Periodic)

ICLeadTimeUnit

String

1 

14 

Yes

D (Days), W (Weeks), M (Months)

ICLineType

String

1 

11 

Yes

P (Product), N (Narrative)

ICMarkupBasis

String

1 

10 

Yes

N (None), S (Standard), L (Latest), A (Average), P (Price Code)

ICPartType

String

1 

11 

Yes

V (Variable), F (Fixed), N (Narrative)

ICPendingDetailType

String

1 

13 

Yes

A (Allocation), T (Transfer Out), V (Variation), I (Transfer In), S (Shipped), C (Commitment), R (Returned), W (Write Off), P (In Production)

ICPendingDocumentClass

String

1 

12 

Yes

I (Invoice), C (Credit), O (Order), Q (Quote), B (Job Batch), S (Time Sheet), R (Receipt), T (Transfer), K (Stocktake), M (Manufacture), A (Adjustment)

ICPendingStockMotion

String

1 

13 

Yes

A (Allocation), B (Back Order), O (Order), I (Transfer In), T (Transfer Out), S (Shipped), C (Commitment), P (In Production), R (Returned), V (Variation), W (Write Off)

ICPostStatus

String

1 

8 

Yes

U (Unposted), O (Open), P (Posted), D (Deleted)

ICPostZeroQuantityLines

String

1 

24 

Yes

N (No Prompt), S (Prompt Delete Selected), U (Prompt Delete Unselected)

ICPrintStatus

String

1 

8 

Yes

U (Unprinted), P (Printed)

ICSerialTracked

String

1 

8 

Yes

N (None), S (Sale), P (Purchase)

ICStocktakeCompareBasis

String

1 

30 

Yes

S (Stock on Hand (Incl. Future)), C (Closing Stock (Current Period))

ICTrackingRequired

String

1 

14 

Yes

N (None), C (Complete), I (Incomplete)

ICTrackingStatus

String

1 

8 

Yes

P (Pending), O (Open), A (Available), C (Closed), H (Historic)

ICTransferPostStatus

String

1 

8 

Yes

U (Unposted), O (Open), P (Posted), D (Deleted)

ICTransferPrintStatus

String

1 

12 

Yes

U (Unprinted), P (Printed)

ICTransferType

String

1 

8 

Yes

T (Transfer)

ICTranType

String

1 

11 

Yes

I (Issue), C (Credit), R (Receipt), A (Adjustment), T (Transfer), U (Usage), M (Manufacture)

ICValuationBasis

String

1 

15 

Yes

S (Standard), L (Latest), A (Average)

ImageType

String

1 

4 

Yes

F (File), W (Web)

IN Banking Line ID

RowID

10 

IN Category 1 Code

String

8 

8 

Yes

IN Category 2 Code

String

8 

8 

Yes

IN Delta ID

RowID

10 

IN Invoice Custom 1 Text

String

30 

30 

IN Invoice Custom 2 Text

String

30 

30 

IN Invoice ID

RowID

10 

IN Invoice Line Custom 1 Text

String

30 

30 

IN Invoice Line Custom 2 Text

String

30 

30 

IN Invoice Line ID

RowID

10 

IN Link ID

RowID

10 

IN Memo ID

RowID

10 

IN Shipper Code

String

16 

16 

Yes

IN Shipper Custom 1 Text

String

30 

30 

IN Shipper Custom 2 Text

String

30 

30 

IN Shipper Line Custom 1 Text

String

30 

30 

IN Shipper Line Custom 2 Text

String

30 

30 

IN Shipper Line ID

RowID

10 

InactivateBasis

String

1 

6 

Yes

M (Manual), P (At EOP), Y (At EOY)

InclExcl

String

1 

9 

Yes

I (Inclusive), E (Exclusive)

INDefaultLineType

String

1 

8 

Yes

P (Product), N (Narrative)

INEmailConsolidationType

String

1 

9 

Yes

N (None), E (Email), C (Customer and Email)

INInsuffDefault

String

1 

9 

Yes

S (Supply), A (Available)

INInvoiceType

String

1 

14 

Yes

I (Invoice), C (Credit), Q (Quote), S (Standing Invoice)

INLineType

String

1 

11 

Yes

P (Product), A (Auto Kitset), M (Manual Kitset), C (Component), U (Usage), N (Narrative)

INPostStatus

String

1 

9 

Yes

U (Unposted), O (Open), P (Posted), D (Deleted)

INPrintStatus

String

1 

12 

Yes

U (Unprinted), P (Printed), M (Manual), K (Packing Slip)

Interval

Float

10 

INUniqueOrderNoBasis

String

1 

8 

Yes

A (All), R (Required), N (None)

IP Address

String

45 

45 

JC Batch ID

RowID

10 

JC Batch Line Custom 1 Text

String

30 

30 

JC Batch Line Custom 2 Text

String

30 

30 

JC Batch Line ID

RowID

10 

JC Category 1 Code

String

8 

8 

Yes

JC Category 2 Code

String

8 

8 

Yes

JC Component Code

String

8 

8 

Yes

JC Cost Centre Code

String

8 

8 

Yes

JC Delta ID

RowID

10 

JC Estimate Line Custom 1 Text

String

30 

30 

JC Estimate Line Custom 2 Text

String

30 

30 

JC Estimate Line ID

RowID

10 

JC Job Code

String

16 

17 

Yes

JC Job Custom 1 Text

String

60 

60 

JC Job Custom 2 Text

String

60 

60 

JC Job Group Code

String

8 

13 

Yes

JC Job Person Code

String

8 

8 

Yes

JC Link ID

RowID

10 

JC Memo ID

RowID

10 

JC Transaction Custom 1 Text

String

30 

30 

JC Transaction Custom 2 Text

String

30 

30 

JC Transaction ID

RowID

10 

JCBatchClass

String

1 

12 

Yes

T (Timesheet), B (Batch), D (Disbursement), S (Standing)

JCDefaultUOMCode

String

1 

12 

Yes

B (Base UOM), S (Sale UOM), P (Purchase UOM)

JCDocumentClass

String

1 

14 

Yes

O (Order), Q (Quotation), N (Standing Order), R (Receipt Only), S (Shipment), T (Timesheet), B (Batch), D (Disbursement), I (Invoice)

JCEstimateType

String

1 

14 

Yes

N (Not Estimated), Y (Estimated), Q (Quoted)

JCInvoiceAsQuoted

String

1 

10 

Yes

P (Pro-rate), D (Difference), Q (Quoted), E (Estimate), N (None)

JCJobPrintStatus

String

1 

12 

Yes

U (Unprinted), Q (Quoted), P (Printed)

JCJobsPerInvoice

String

1 

12 

Yes

S (Single Job), R (Related Jobs), A (All Jobs)

JCJobStatus

String

1 

8 

Yes

H (Hold), A (Active), C (Complete), D (Deleted)

JCJobType

String

1 

8 

Yes

N (Normal), S (Standard), Q (Quote)

JCPendingAmount

String

1 

8 

Yes

A (Actual), I (Invoiced)

JCPendingCost

String

1 

8 

Yes

B (Batch), O (Order), S (Shipment)

JCPostStatus

String

1 

8 

Yes

U (Unposted), O (Open), P (Posted), D (Deleted)

JCPostZeroQuantityLines

String

1 

24 

Yes

N (No Prompt), S (Prompt Delete Selected), U (Prompt Delete Unselected)

JCPricingMode

String

1 

13 

Yes

S (Selling Price), M (Markup), D (Markup and Discount), N (None)

JCPrintStatus

String

1 

8 

Yes

U (Unprinted), P (Printed)

JCTranType

String

1 

11 

Yes

T (Time), M (Material), D (Disbursement), N (Narrative)

JCTranTypeEx

String

1 

11 

Yes

T (Time), M (Material), D (Disbursement), N (Narrative), Q (As Quoted)

JCWIPMode

String

1 

12 

Yes

J (Job), T (Transaction)

JCWorkInProgressBasis

String

1 

4 

Yes

C (Cost), S (Sell)

Layout Name

String

255 

255 

Layout Table Name

String

40 

30 

Yes

LayoutLineType

String

1 

10 

Yes

F (Filter), S (Sort), J (FilterJson), N (SortJson), L (Selection), P (Preference), U (User), I (SelFilterJson), O (SelSortJson)

Long Module Code

String

8 

8 

Yes

Long Table Name

String

64 

40 

Yes

Mail Segment Type

String

1 

16 

Yes

A (Access Token), R (Refresh Token), E (Error Response)

Mail Token Encoding

String

1 

8 

Yes

N (None), B (Base64)

MailAuthModel

String

1 

8 

Yes

P (Basic), O (OAuth2)

MailComposeOption

String

1 

14 

Yes

A (Accredo Mailer), O (Outlook (Classic)), F (Full Mapi), S (Simple Mapi), M (Microsoft 365), D (Auto Detect)

MailFormat

String

1 

10 

Yes

H (HTML), T (Plain Text)

MailProvider

String

1 

20 

Yes

O (Office 365 (SMTP)), P (Office 365 (Http - Graph))

MailSendOption

String

1 

14 

Yes

P (SMTP), O (Outlook (Classic)), F (Full Mapi), S (Simple Mapi), M (Microsoft 365), D (Auto Detect)

MailUseWith

String

1 

10 

Yes

S (SMTP Only), A (All)

Markup

Float

10 

MediaType

String

1 

8 

Yes

C (Cash), Q (Cheque), O (Other)

Memo Line Text

String

78 

78 

MemoType

String

1 

8 

Yes

M (Memo), A (Alarm), R (Reminder)

Module Code

String

2 

2 

Yes

Name

String

60 

40 

Name U

UString

60 

40 

Narration

String

60 

60 

OE Banking Line ID

RowID

10 

OE Delta ID

RowID

10 

OE Link ID

RowID

10 

OE Memo ID

RowID

10 

OE Order ID

RowID

10 

OE Order Line ID

RowID

10 

OE Shipper Line ID

RowID

10 

OECompleteBasis

String

1 

24 

Yes

B (Both Printed and Processed), P (Processed Only)

OEGenerationBasis

String

1 

12 

Yes

N (None), P (Packing Slip), B (Back Order)

OEHeadDefault

String

1 

12 

Yes

P (Packing Slip), O (Order), C (Customer)

OEInsuffDefault

String

1 

14 

Yes

B (Back Order), S (Supply), A (Available), P (Partial Supply)

OELineDefault

String

1 

11 

Yes

O (Full Orders), L (Full Lines), A (All Lines)

OELineStatus

String

1 

11 

Yes

U (Unprocessed), C (Cancelled), P (Processed), D (Deleted)

OELineType

String

1 

11 

Yes

P (Product), A (Auto Kitset), M (Manual Kitset), C (Component), U (Usage), N (Narrative), S (Sticky Narrative)

OEMergeHeadDefault

String

1 

10 

Yes

N (No Merging), O (Same Order), C (Same Customer)

OEMergeLineDefault

String

1 

8 

Yes

N (Narrated), A (Appended), C (Combined)

OEOrderDefault

String

1 

10 

Yes

B (Back Order), S (Supply)

OEOrderType

String

1 

14 

Yes

O (Order), P (Packing Slip), B (Back Order), S (Standing Order)

OEPostStatus

String

1 

11 

Yes

U (Unprocessed), O (Open), P (Processed), D (Deleted)

OEPrintStatus

String

1 

8 

Yes

U (Unprinted), P (Printed), M (Manual), C (Confirmed)

Order No

String

30 

20 

Other Party Code

String

16 

16 

Yes

OTP Secret

String

32 

20 

OTPStatus

String

1 

10 

Yes

N (None), P (Pending), E (Enroled)

Party Code

String

16 

16 

Yes

Password

String

40 

30 

PasswordMatchesType

String

1 

15 

Yes

U (Unknown), M (Matches), D (Differs), I (Invalid), A (Not Applicable), N (None)

PdbFieldType

String

1 

8 

Yes

Chr(1) (String), Chr(2) (DosDate), Chr(3) (Byte), Chr(4) (Word), Chr(5) (Smallint), Chr(6) (Integer), Chr(7) (Float), Chr(8) (Boolean), Chr(9) (Date), Chr(10) (Time), Chr(11) (DateTime), Chr(12) (AutoInc), Chr(13) (Largeint), Chr(14) (Variant), Chr(15) (RowID), Chr(16) (Tinyint), Chr(17) (UString), Chr(18) (Bytes), Chr(19) (VarBytes), Chr(20) (Timestamp)

Peppol EAS Code

String

4 

4 

Peppol eInvoice Identifier

String

60 

20 

Peppol UOM Code

String

4 

4 

Percent 1

Float

10 

Percent 2

Float

10 

Period ID

Smallint

10 

Period Name

String

40 

20 

PeriodInferenceLevel

String

1 

15 

Yes

N (None), D (Data Level only), F (Form and Data Level)

PeriodStatus

String

1 

9 

Yes

O (Open), C (Closed), F (Finalised)

PeriodStyle

String

1 

10 

Yes

1 (12 Month), 2 (4/4/5 Week), 3 (4/5/4 Week), 4 (5/4/4 Week), 5 (52 Week), 6 (13 Period), 8 (Single Period), 9 (2 Period), A (6 Period), 7 (Custom)

Phone Number

String

20 

20 

Phone Pattern

String

20 

20 

Yes

PhoneNoType

String

1 

20 

Yes

P (Phone No), 2 (Phone No 2), M (Mobile No), F (Fax No), H (Home No), W (Work No), E (Emergency Phone No), X (Emergency Phone No 2)

PhoneType

String

1 

20 

Yes

1 (Account Phone No), 2 (Account Phone No 2), 3 (Account Phone No 3), 4 (Contact Phone No), 5 (Contact Phone No 2), 6 (Contact Phone No 3), 7 (Emergency Phone No), 8 (Emergency Phone No 2)

PnxCondOperator

String

1 

2 

Yes

Chr(0) (), Chr(1) (=), Chr(2) (<>), Chr(3) (<), Chr(4) (>), Chr(5) (<=), Chr(6) (>=)

PO Author Code

String

8 

10 

Yes

PO Category 1 Code

String

8 

8 

Yes

PO Category 2 Code

String

8 

8 

Yes

PO Delta ID

RowID

10 

PO Link ID

RowID

10 

PO Memo ID

RowID

10 

PO Order Custom 1 Text

String

30 

30 

PO Order Custom 2 Text

String

30 

30 

PO Order ID

RowID

10 

PO Order Line Custom 1 Text

String

30 

30 

PO Order Line Custom 2 Text

String

30 

30 

PO Order Line ID

RowID

10 

POCompleteBasis

String

1 

24 

Yes

B (Both Invoice and Receipt), R (Receipt Only), I (Invoice Only), N (None)

POCostPriceBasis

String

1 

8 

Yes

S (Standard), L (Latest), N (None)

POCreateShipment

String

1 

12 

Yes

P (Prompt), S (Shipment), I (Invoice Only), R (Receipt Only)

POLineStatus

String

1 

11 

Yes

U (Unprocessed), R (Receipted), P (Processed), C (Cancelled), D (Deleted)

POLineType

String

1 

7 

Yes

P (Product), N (Narrative)

POOrderType

String

1 

14 

Yes

O (Order), Q (Quotation), S (Standing Order)

POPostStatus

String

1 

11 

Yes

U (Unprocessed), O (Open), P (Processed), D (Deleted)

POPrintStatus

String

1 

9