|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankState_ID
|
Link to BankState
|
|
-99999999999
|
|
|
|
BankStateLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankStateLineAmountTC
|
TC Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateLineBankImpRef
|
Bank Importing Reference
|
|
x(255)
|
|
|
|
BankStateLineDescription
|
Description
|
|
x(255)
|
|
|
|
BankStateLineExtAddress
|
Address (Ext)
|
|
x(40)
|
|
|
|
BankStateLineExtBankNumber
|
Bank Number (Ext)
|
|
x(40)
|
|
|
|
BankStateLineExtBankRate
|
Bank Rate (Ext)
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateLineExtCity
|
City (Ext)
|
|
x(40)
|
|
|
|
BankStateLineExtCostCode
|
Cost Code (Ext)
|
|
x(20)
|
|
|
|
BankStateLineExtCountry
|
Country (Ext)
|
|
x(20)
|
|
|
|
BankStateLineExtCurrency
|
Currency (Ext)
|
|
x(20)
|
|
|
|
BankStateLineExtDebCred
|
Customer/Supplier (Ext)
|
|
x(20)
|
|
|
|
BankStateLineExtName
|
Name (Ext)
|
|
x(40)
|
|
|
|
BankStateLineExtOriginalTC
|
TC Original (Ext)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateLineExtRateScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateLineExtReference
|
Reference (Ext)
|
|
x(40)
|
|
|
|
BankStateLineExtSwiftCode
|
SWIFT Code (Ext)
|
|
x(40)
|
|
|
|
BankStateLineExtTSM
|
TSM (Ext)
|
|
x(40)
|
|
|
|
BankStateLineExtZip
|
Zip Code (Ext)
|
|
x(20)
|
|
|
|
BankStateLineInformation
|
Information
|
|
x(2000)
|
|
|
|
BankStateLineInOut
|
In/Out
|
|
x(20)
|
|
|
|
BankStateLineNumber
|
Number
|
|
->,>>>,>>9
|
|
|
|
BankStateLinePostingDate
|
Posting Date
|
|
99/99/9999
|
|
|
|
BankStateLineReportingDateIN
|
Reporting Date (IN)
|
|
99/99/9999
|
|
|
|
BankStateLineStatus
|
Status
|
|
x(20)
|
|
|
|
BankStateLineValueDate
|
Value Date
|
|
99/99/9999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Period_ID
|
GL Calendar Year
|
GL Cal Year
|
-99999999999
|
|
|
|
Posting_ID
|
Voucher
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankState
|
no
|
BankState_ID
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
CyImpRefIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
BankStateLineBankImpRef
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
|
Posting
|
no
|
Posting_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankStateLine_ID
|
yes
|
no
|
|
|
Stattus
|
no
|
BankStateLineStatus
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankState_ID
|
yes
|
no
|
|
|
|
|
BankStateLineNumber
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankState_ID
|
Link to BankState
|
|
-99999999999
|
|
|
|
BankStateAlloc_ID
|
Link to BankStateAlloc
|
|
-99999999999
|
|
|
|
BankStateStageAlloc_ID
|
Record ID
|
|
-99999999999
|
4
|
|
|
BankStateStageAllocAmntTC
|
Stage Allocation
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateStageAllocDiscTC
|
Stage Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateStageAllocPaidTC
|
Stage Paid
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateStageAllocWHTTC
|
TCWHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceStage_ID
|
Link to CInvoiceStage
|
|
-99999999999
|
|
|
|
DInvoiceStage_ID
|
Link to DInvoiceStage
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankStAll
|
no
|
BankStateAlloc_ID
|
yes
|
no
|
|
|
BankState
|
no
|
BankState_ID
|
yes
|
no
|
|
|
CIStage
|
no
|
CInvoiceStage_ID
|
yes
|
no
|
|
|
DIStage
|
no
|
DInvoiceStage_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankStateStageAlloc_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankStateAlloc_ID
|
yes
|
no
|
|
|
|
|
CInvoiceStage_ID
|
yes
|
no
|
|
|
|
|
DInvoiceStage_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AllowMerge
|
Allow Merge Orders
|
|
yes/no
|
|
|
|
AutoRef
|
Auto / Manual Sequence ID
|
|
Auto/Manual
|
|
|
|
AutoSel
|
Auto Selection
|
|
yes/no
|
|
|
|
BlankRef
|
Blank Reference
|
|
yes/no
|
|
|
|
CloseOpt
|
Close Option
|
|
9
|
|
|
|
Cmmt_so
|
Display SO Header Comments
|
Display SO Header Comments
|
yes/no
|
|
|
|
Cmmt_sod
|
Display SO Line Comments
|
Display SO Line Comments
|
yes/no
|
|
|
|
ConsoIRG
|
Consolidation IRG
|
Conso!IRG
|
x(8)
|
|
|
|
ContItem
|
Container Item
|
|
x(18)
|
|
|
|
ContLength
|
Container Lenght
|
|
->>,>>9.99
|
10
|
|
|
ContSeqID
|
Container Sequence ID
|
|
x(8)
|
|
|
|
ContUM
|
Container UM
|
UM
|
x(2)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DateFormat
|
Date Format
|
|
MDY/DMY
|
|
|
|
Destination
|
Default Packing Location
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExplosionOpt
|
Explosion Option
|
|
9
|
|
|
|
GenerateID
|
Generate Identification
|
|
yes/no
|
|
|
|
Include_do
|
Include Distribution Order
|
Include DO
|
yes/no
|
|
|
|
Include_so
|
Include Sales Order
|
Include SO
|
yes/no
|
|
|
|
Include_wo
|
Include Work Order
|
Include WO
|
yes/no
|
|
|
|
LblOpt
|
Label Print Option
|
|
9
|
|
|
|
LblPrint
|
Pro-Print/Post-Print
|
|
9
|
|
|
|
LogFormat
|
Logical Format
|
Log Frmt
|
x(8)
|
|
|
|
Mandatory
|
Scan Required
|
|
yes/no
|
|
|
|
MaxPick
|
Maximum Picked Cases
|
|
>>9
|
|
|
|
MaxSel
|
Maximum Selection
|
Max Selection
|
>>9
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_BatchPickC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OnlyShipperOpt
|
Only Shipper Option
|
|
9
|
|
|
|
PalletItem
|
Pallet Item
|
Pallet!Item
|
x(18)
|
|
|
|
PalPrintOpt
|
Pallet Print Option
|
Pallet!Pr.Opt.
|
9
|
|
|
|
PalPrintProg
|
Pallet Print Program
|
Pallet!Pr.Prog
|
x(10)
|
|
|
|
PostPrint
|
Post Print Option
|
|
9
|
|
|
|
PrAssSh
|
Assign Shipper Number
|
|
yes/no
|
|
|
|
PrCustAddr
|
Print Customer Address
|
|
yes/no
|
|
|
|
PreShipSeqID
|
Preshipper Sequence ID
|
|
X(8)
|
|
|
|
PrFeaOp
|
Features and Options
|
|
yes/no
|
|
|
|
PrintProg
|
Label Print Program
|
|
x(10)
|
|
|
|
PrLotNbr
|
Lot/Serial Numbers
|
|
yes/no
|
|
|
|
PromptRemove
|
Prompt to Remove Container
|
|
yes/no
|
|
|
|
PrPaOpt
|
Print Paperwork Option
|
|
9
|
|
|
|
PrPckCmm
|
Packing List Comments
|
|
yes/no
|
|
|
|
PrQtySoUM
|
Quantity In SO UM
|
|
yes/no
|
|
|
|
PrShCmm
|
Shipper Comments
|
|
yes/no
|
|
|
|
PrSoDet
|
Order Detail
|
|
yes/no
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
ReleaseOpt
|
Release Orders Option
|
Rel Ord!Option
|
9
|
|
|
|
ReqLoc
|
Location Required
|
|
yes/no
|
|
|
|
ReqLot
|
Lot Required
|
|
yes/no
|
|
|
|
ReqPart
|
Part Required
|
|
yes/no
|
|
|
|
ReqQty
|
Quantity Required
|
|
yes/no
|
|
|
|
ReqRef
|
Reference Required
|
|
yes/no
|
|
|
|
RFHeight
|
RF Screen Height
|
RF Height
|
>9
|
|
|
|
ScanLoc
|
Scan Location
|
|
yes/no
|
|
|
|
ScanLot
|
Scan Lot/Serial
|
|
yes/no
|
|
|
|
ScanPart
|
Scan Item
|
|
yes/no
|
|
|
|
ScanQty
|
Scan Quantity
|
Scan Qty
|
yes/no
|
|
|
|
ScanRef
|
Scan Reference
|
|
yes/no
|
|
|
|
Sel
|
SO Batch Selection
|
SO Batch Sel
|
x(12)
|
|
|
|
ShipperSeqOpt
|
Shipper Seq Option
|
|
9
|
|
|
|
SingleLoc
|
Single Packing Location
|
|
yes/no
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
Type
|
Container / Reference
|
|
Container/Reference
|
|
|
|
UndoAvail
|
Undo Available
|
|
yes/no
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
WeightUM
|
Weight UM
|
UM
|
x(2)
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_BatchPickC
|
yes
|
oid_BatchPickC
|
yes
|
no
|
|
∗
|
SiteWhse
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_BatchPickD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
PickStatus
|
Status
|
St
|
x(12)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Quantity
|
Actual
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
StartUserID
|
Start User
|
|
x(8)
|
|
|
|
ToAltUM
|
To UM
|
To!UM
|
x(2)
|
|
|
|
ToDigit
|
To Digit
|
|
x(8)
|
|
|
|
ToLoc
|
To Location
|
To Loc
|
x(8)
|
|
|
|
ToLot
|
To Lot/Serial
|
|
x(18)
|
|
|
|
ToPart
|
To Item Number
|
|
x(18)
|
|
|
|
ToRef
|
To Reference
|
To!Reference
|
x(8)
|
|
|
|
ToSite
|
To Site
|
|
x(8)
|
|
|
|
ToWhse
|
To Whse
|
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_BatchPickD
|
yes
|
oid_BatchPickD
|
yes
|
no
|
|
|
StartUserID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
StartUserID
|
yes
|
no
|
|
|
ToLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
ToRef
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
ToRef
|
yes
|
no
|
|
∗
|
TrNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToWhse
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
|
|
ToPart
|
yes
|
no
|
|
|
|
|
ToLot
|
yes
|
no
|
|
|
|
|
ToRef
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BatchStatus
|
Status
|
St
|
x(12)
|
|
|
|
Complete
|
Complete
|
|
yes/no
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Distance
|
Travel Sequence
|
Travel!Sequence
|
->,>>>,>>9
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
Fail
|
Fail
|
|
yes/no
|
|
|
|
FromAltUM
|
From UM
|
Fr!UM
|
x(2)
|
|
|
|
FromDigit
|
From Digit
|
From!Digit
|
x(8)
|
|
|
|
FromLoc
|
From Location
|
From!Location
|
x(8)
|
|
|
|
FromLot
|
From Lot/Serial
|
|
x(18)
|
|
|
|
FromPart
|
From Item Number
|
|
x(18)
|
|
|
|
FromQty
|
Actual
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
FromRef
|
From Reference
|
From!Reference
|
x(8)
|
|
|
|
FromSite
|
From Site
|
From!Site
|
x(8)
|
|
|
|
FromWhse
|
From Whse
|
From!Whse
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_BatchPickM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OldUserID
|
Old User
|
|
x(8)
|
|
|
|
OPCAltUM
|
OPC UM
|
OPC!UM
|
x(2)
|
|
|
|
OPCQty
|
OPC Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Priority
|
Priority
|
|
->,>>>,>>9
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
QAD Field
|
|
x(8)
|
0
|
|
|
QadC06
|
QAD Field
|
|
x(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI04
|
QAD Field
|
QAD Field
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadL03
|
QAD Field
|
|
yes/no
|
|
|
|
QadL04
|
QAD Field
|
|
yes/no
|
|
|
|
QadL05
|
QAD Field
|
|
yes/no
|
|
|
|
QadL06
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Repick
|
Repick
|
|
yes/no
|
|
|
|
ScanField
|
Scan Field
|
|
x(12)
|
|
|
|
Sequence
|
Sequence
|
|
->,>>>,>>9
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
StartDate
|
Start Date
|
|
99/99/99
|
|
|
|
StartTime
|
Start Time
|
|
>>>>>>>9
|
|
|
|
StartUserID
|
Start User
|
|
x(8)
|
|
|
|
ToAltUM
|
To UM
|
To!UM
|
x(2)
|
|
|
|
ToDigit
|
To Digit
|
|
x(8)
|
|
|
|
ToLoc
|
To Location
|
To Loc
|
x(8)
|
|
|
|
ToLot
|
To Lot/Serial
|
|
x(18)
|
|
|
|
ToPart
|
To Item Number
|
|
x(18)
|
|
|
|
ToRef
|
To Reference
|
To!Reference
|
x(8)
|
|
|
|
ToSite
|
To Site
|
|
x(8)
|
|
|
|
Tote
|
Tote Number
|
|
x(12)
|
|
|
|
ToteAction
|
Action
|
|
->,>>>,>>9
|
|
|
|
ToWhse
|
To Whse
|
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Distance
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
StartUserID
|
yes
|
no
|
|
|
|
|
Distance
|
yes
|
no
|
|
|
|
|
FromLoc
|
yes
|
no
|
|
|
|
|
Priority
|
no
|
no
|
|
|
FromLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
FromLoc
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
|
|
FromLot
|
yes
|
no
|
|
|
|
|
FromRef
|
yes
|
no
|
|
|
oid_BatchPickM
|
yes
|
oid_BatchPickM
|
yes
|
no
|
|
|
Sequence
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
StartUserID
|
yes
|
no
|
|
|
|
|
Sequence
|
yes
|
no
|
|
|
StartUserID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
StartUserID
|
yes
|
no
|
|
|
|
|
BatchStatus
|
yes
|
no
|
|
∗
|
TrNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
bbl__qadc01
|
|
|
x(24)
|
|
|
|
bbl__qadc02
|
|
|
x(24)
|
|
|
|
bbl__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
bbl__qadt01
|
|
|
99/99/99
|
|
|
|
bbl_bbl_amt
|
Document Amount
|
Doc Amt
|
->>>>,>>>,>>9.99<
|
10
|
|
|
bbl_bk_acct_code
|
Bank Acct Code
|
|
x(8)
|
|
|
|
bbl_cinvoice_id
|
Supplier Invoice ID
|
Supp Inv ID
|
-99999999999
|
|
|
|
bbl_creditor_id
|
Creditor ID
|
|
-99999999999
|
|
|
|
bbl_domain
|
Domain
|
|
x(8)
|
|
|
|
bbl_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
bbl_exec_date
|
Execution Date
|
|
99/99/99
|
|
|
|
bbl_file_name
|
Bank File Name
|
|
x(60)
|
|
|
|
bbl_gst_id
|
Tax ID - Federal
|
|
x(18)
|
|
|
|
bbl_lgd_nbr
|
Legal Doc Nbr
|
Legal Doc
|
x(12)
|
|
|
|
bbl_man_bar_code
|
Manual Bar Code
|
Man Bar Code
|
x(47)
|
|
|
|
bbl_mod_date
|
Last Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
bbl_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
bbl_opt_bar_code
|
Optical Bar Code
|
Opt Bar Code
|
x(44)
|
|
|
|
bbl_owner_bk_acct_code
|
Bank Account Code
|
|
x(8)
|
|
|
|
bbl_receive_date
|
Received Date
|
|
99/99/99
|
|
|
|
bbl_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
bbl_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_bbl_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
bbl_cinvoice_id
|
no
|
bbl_cinvoice_id
|
yes
|
no
|
|
|
bbl_file_name
|
no
|
bbl_domain
|
yes
|
no
|
|
|
|
|
bbl_file_name
|
yes
|
no
|
|
∗
|
bbl_man_bar_code
|
no
|
bbl_domain
|
yes
|
no
|
|
|
|
|
bbl_man_bar_code
|
yes
|
no
|
|
|
|
|
bbl_file_name
|
yes
|
no
|
|
|
oid_bbl_mstr
|
yes
|
oid_bbl_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
bcd__qadc01
|
|
|
x(8)
|
|
|
|
bcd_batch
|
Batch ID
|
|
x(8)
|
|
|
|
bcd_date_run
|
Run Date
|
Run!Date
|
99/99/99
|
|
|
|
bcd_date_sub
|
Submit Date
|
Submit!Date
|
99/99/99
|
|
|
|
bcd_dev
|
Output
|
|
x(8)
|
|
|
|
bcd_domain
|
Domain
|
|
x(8)
|
|
|
|
bcd_exec
|
Program
|
|
x(14)
|
|
|
|
bcd_mnu_nbr
|
Menu
|
|
x(16)
|
|
|
|
bcd_mnu_sel
|
Selection
|
Sel
|
>9
|
|
|
|
bcd_parm
|
Parameter Data
|
Parameter!Data
|
x(200)
|
|
|
|
bcd_perm
|
Permanent
|
Perm
|
yes/no
|
|
|
|
bcd_priority
|
Priority
|
|
>>>,>>9
|
|
|
|
bcd_process
|
Process
|
|
yes/no
|
|
|
|
bcd_run_stat
|
Run Status
|
Run!Status
|
x(8)
|
|
|
|
bcd_time_run
|
Run Time
|
Run!Time
|
x(8)
|
|
|
|
bcd_time_sub
|
Submit Time
|
Submit!Time
|
x(8)
|
|
|
|
bcd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
bcd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
bcd_userid
|
Submitted By
|
Submitted!By
|
x(8)
|
|
|
|
oid_bcd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
bcd_id
|
yes
|
bcd_domain
|
yes
|
no
|
|
|
|
|
bcd_batch
|
yes
|
no
|
|
|
|
|
bcd_date_sub
|
yes
|
no
|
|
|
|
|
bcd_time_sub
|
yes
|
no
|
|
|
|
|
bcd_userid
|
yes
|
no
|
|
|
oid_bcd_det
|
yes
|
oid_bcd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
bc__qadc01
|
|
|
x(8)
|
|
|
|
bc_batch
|
Batch ID
|
|
x(8)
|
|
|
|
bc_canrun
|
Users/Roles
|
|
x(189)
|
|
|
|
bc_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
bc_desc
|
Description
|
|
x(24)
|
|
|
|
bc_domain
|
Domain
|
|
x(8)
|
|
|
|
bc_perm
|
Permanent
|
|
yes/no
|
|
|
|
bc_priority
|
Priority
|
|
>>>,>>9
|
|
|
|
bc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
bc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_bc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
bc_batch
|
yes
|
bc_domain
|
yes
|
no
|
|
|
|
|
bc_batch
|
yes
|
no
|
|
|
oid_bc_mstr
|
yes
|
oid_bc_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
bdld__qadc01
|
|
|
x(8)
|
|
|
|
bdld_data
|
Data
|
|
x(78)
|
|
|
|
bdld_domain
|
Domain
|
|
x(8)
|
|
|
|
bdld_id
|
Group Id
|
|
>>>>>>>9
|
|
|
|
bdld_line
|
Line Number
|
|
>>>9
|
|
|
|
bdld_source
|
Source
|
|
x(16)
|
|
|
|
bdld_user1
|
Ufld1
|
|
x(8)
|
|
|
|
bdld_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_bdld_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
bdld_id
|
yes
|
bdld_domain
|
yes
|
no
|
|
|
|
|
bdld_source
|
yes
|
no
|
|
|
|
|
bdld_id
|
yes
|
no
|
|
|
|
|
bdld_line
|
yes
|
no
|
|
|
oid_bdld_det
|
yes
|
oid_bdld_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
bdl__qadc01
|
|
|
x(8)
|
|
|
|
bdl_date_ent
|
Date Entered
|
|
99/99/99
|
|
|
|
bdl_date_pro
|
Date Processed
|
|
99/99/99
|
|
|
|
bdl_domain
|
Domain
|
|
x(8)
|
|
|
|
bdl_exec
|
Program
|
|
x(16)
|
|
|
|
bdl_id
|
Group Id
|
|
>>>>>>>9
|
|
|
|
bdl_pgm_errs
|
Program Errors
|
|
>,>>9
|
|
|
|
bdl_pro_errs
|
Progress Errors
|
|
>,>>9
|
|
|
|
bdl_source
|
Source ID
|
|
x(16)
|
|
|
|
bdl_time_ent
|
Time Entered
|
|
x(8)
|
|
|
|
bdl_time_pro
|
Time Processed
|
|
x(8)
|
|
|
|
bdl_user1
|
Ufld1
|
|
x(8)
|
|
|
|
bdl_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_bdl_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
bdl_id
|
yes
|
bdl_domain
|
yes
|
no
|
|
|
|
|
bdl_source
|
yes
|
no
|
|
|
|
|
bdl_id
|
yes
|
no
|
|
|
oid_bdl_mstr
|
yes
|
oid_bdl_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
bdp__qadc01
|
|
|
x(24)
|
|
|
|
bdp__qadc02
|
|
|
x(24)
|
|
|
|
bdp__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
bdp__qadi01
|
|
|
->>>>>>>9
|
|
|
|
bdp__qadl01
|
|
|
yes/no
|
|
|
|
bdp__qadt01
|
|
|
99/99/99
|
|
|
|
bdp_addr
|
Customer/Supplier
|
|
x(8)
|
|
|
|
bdp_bank
|
Bank
|
|
x(2)
|
|
|
|
bdp_character
|
Character
|
|
x(48)
|
|
|
|
bdp_date
|
Date
|
|
99/99/99
|
|
|
|
bdp_decimal
|
Decimal
|
|
->>,>>>,>>>,>>9.99<
|
10
|
|
|
bdp_domain
|
Domain
|
|
x(8)
|
|
|
|
bdp_integer
|
Integer
|
|
->,>>>,>>9
|
|
|
|
bdp_logical
|
Logical
|
|
yes/no
|
|
|
|
bdp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
bdp_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
bdp_pay_method
|
Payment Method
|
PM
|
x(2)
|
|
|
|
bdp_program
|
Program
|
|
x(12)
|
|
|
|
bdp_ref
|
Reference
|
|
x(8)
|
|
|
|
bdp_seq
|
Sequence
|
|
999
|
|
|
|
bdp_split
|
Split Payment
|
Split
|
yes/no
|
|
|
|
bdp_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
bdp_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
bdp_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
bdp_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
bdp_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
bdp_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
oid_bdp_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
bdp_pay_seq
|
yes
|
bdp_domain
|
yes
|
no
|
|
|
|
|
bdp_program
|
yes
|
no
|
|
|
|
|
bdp_addr
|
yes
|
no
|
|
|
|
|
bdp_bank
|
yes
|
no
|
|
|
|
|
bdp_pay_method
|
yes
|
no
|
|
|
|
|
bdp_ref
|
yes
|
no
|
|
|
|
|
bdp_seq
|
yes
|
no
|
|
|
oid_bdp_det
|
yes
|
oid_bdp_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
bic__qadc01
|
|
|
x(8)
|
|
|
|
bic__qadi01
|
|
|
->>>>>>>9
|
|
|
|
bic_audit
|
Audit has been Run
|
|
yes/no
|
|
|
|
bic_domain
|
Domain
|
|
x(8)
|
|
|
|
bic_last_cyc
|
Last Cycle Billed
|
Lst Cyc
|
x(2)
|
|
|
|
bic_last_due
|
Last Due Date Billed
|
Lst Due
|
99/99/99
|
|
|
|
bic_lst_date
|
Date Last Billed
|
|
99/99/99
|
|
|
|
bic_periods
|
Periods In Billing Year
|
|
>>9
|
|
|
|
bic_user1
|
Ufld1
|
|
x(8)
|
|
|
|
bic_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_bic_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
bic_index1
|
yes
|
bic_domain
|
yes
|
no
|
|
|
oid_bic_ctrl
|
yes
|
oid_bic_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Bill_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BillClosingBalanceTC
|
TC Closing Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BillConfirmDate
|
Bill Confirm Date
|
|
99/99/9999
|
|
|
|
BillDate
|
Bill Date
|
|
99/99/9999
|
|
|
|
BillDueDate
|
Bill Due Date
|
|
99/99/9999
|
|
|
|
BillNumber
|
Bill Number
|
|
999999999
|
|
|
|
BillOpeningBalanceTC
|
TC Opening Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BillPaymentAmtTC
|
TC Payment Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BillSalesAmtTC
|
TC Sales Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BillStatus
|
Status
|
|
x(20)
|
|
|
|
BillTaxAmtTC
|
TC Tax Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BillYear
|
Bill Year
|
|
9999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Currency_ID
|
Link to Currency
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Debtor_ID
|
Link to Debtor
|
|
-99999999999
|
|
|
|
DInvoiceMovement_ID
|
Link to highest DInvoiceMovement
|
|
-99999999999
|
|
|
|
Employee_ID
|
Link to Employee
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
CyDebCurDateIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
|
|
|
BillDate
|
yes
|
no
|
|
|
CyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
DebIdx
|
no
|
Debtor_ID
|
yes
|
no
|
|
|
DIMIdx
|
no
|
DInvoiceMovement_ID
|
yes
|
no
|
|
|
EmplIdx
|
no
|
Employee_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Bill_ID
|
yes
|
no
|
|
|
StatIdx
|
no
|
BillStatus
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
BillYear
|
yes
|
no
|
|
|
|
|
BillNumber
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BillSchedule_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BillScheduleCode
|
Billing Schedule Code
|
|
x(20)
|
|
|
|
BillScheduleDayInWeek
|
Day In the Week
|
|
x(20)
|
|
|
|
BillScheduleDescription
|
Description
|
|
x(40)
|
|
|
|
BillScheduleDueDateCalType
|
Calculation Type
|
|
x(40)
|
|
|
|
BillScheduleIsActive
|
Active
|
|
yes/no
|
|
|
|
BillScheduleIsUpdInvByBill
|
Update Invoice DueDate
|
|
yes/no
|
|
|
|
BillScheduleIsWeek1InMnth
|
Week 1
|
|
yes/no
|
|
|
|
BillScheduleIsWeek2InMnth
|
Week 2
|
|
yes/no
|
|
|
|
BillScheduleIsWeek3InMnth
|
Week 3
|
|
yes/no
|
|
|
|
BillScheduleIsWeek4InMnth
|
Week 4
|
|
yes/no
|
|
|
|
BillScheduleMthBillDay1
|
Billing Day 1
|
|
>9
|
|
|
|
BillScheduleMthBillDay2
|
Billing Day 2
|
|
>9
|
|
|
|
BillScheduleMthBillDay3
|
Billing Day 3
|
|
>9
|
|
|
|
BillScheduleMthBillDay4
|
Billing Day 4
|
|
>9
|
|
|
|
BillScheduleMthDelay1
|
Months Delay 1
|
|
9
|
|
|
|
BillScheduleMthDelay2
|
Months Delay 2
|
|
9
|
|
|
|
BillScheduleMthDelay3
|
Months Delay 3
|
|
9
|
|
|
|
BillScheduleMthDelay4
|
Months Delay 4
|
|
9
|
|
|
|
BillScheduleMthDueDay1
|
Due Day 1
|
|
>9
|
|
|
|
BillScheduleMthDueDay2
|
Due Day 2
|
|
>9
|
|
|
|
BillScheduleMthDueDay3
|
Due Day 3
|
|
>9
|
|
|
|
BillScheduleMthDueDay4
|
Due Day 4
|
|
>9
|
|
|
|
BillSchedulePattern
|
Pattern
|
|
x(20)
|
|
|
|
BillScheduleSelectInvBasedOn
|
Select Invoice Based On
|
|
x(20)
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActiveIdx
|
no
|
BillScheduleIsActive
|
yes
|
no
|
|
|
CodeIdx
|
yes
|
BillScheduleCode
|
yes
|
no
|
|
|
PatDueIdx
|
no
|
BillSchedulePattern
|
yes
|
no
|
|
|
|
|
BillScheduleDueDateCalType
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BillSchedule_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BLWIGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BLWIGroupCode
|
BLWI Group Code
|
BLWI Group
|
x(20)
|
|
|
|
BLWIGroupDescription
|
Description
|
|
x(40)
|
|
|
|
BLWIGroupIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Active
|
no
|
BLWIGroupIsActive
|
yes
|
no
|
|
|
Code
|
yes
|
BLWIGroupCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BLWIGroup_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
BLWIGroupIsActive
|
yes
|
no
|
|
|
|
|
BLWIGroupCode
|
yes
|
no
|