XML Export

08 May 2024
967 Minutes to read

Print
Share
Dark
Light
PDF

XML Export

Updated on 08 May 2024
967 Minutes to read

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Table OrdHdr - SyncOrdHdr-Entries

All data values will also be shown as ISO-data. The domains will not be shown separately.

Order header

Domaine	Data type	Format	Label	Description
OrdNbr	inte	->>>>>>9	Consecutive number
OrgCde	char	X(5)	Organisation
OrdPrd	char	X(5)	Period
StsDel	logi	Yes/No	To delete	Status on an offer which shall be deleted.
OrdNum	inte	->>>>>>>9	Order number	Offer number from a number range. This number is the actual order number. This number cannot be assigned by the user.
OrdNtl	inte	>>>>>>>>>9	Offer number	Offer number of the precursor. This is the agent's number for the dealer. In the branch, it is the number of the dealer.
OrdNgv	inte	>>>>>>>>>9	Order number after	This is the number which is assigned by the position on the top. For the agent this is the number of the dealer. For the dealer this is the number of the branch.
OrdNbt	inte	>>>>>>>>>9	Order number partner	For dealers and agents empty. For the branch it is the number of the agent, for the sales partner the number of the dealer.
OrdSbj	char	X(30)	Subject
HdrNr	inte	>>>>>>>9	Leading number	Offer has leading offer.
HdrDoc	logi	Yes/No	Leading offer	Offer is a leading document.
AdrCde	char	X(8)	Customer number
AdrCd3	char	X(8)	Invoice receiver - client
AdrNr1	inte	>>>>>9	address number	The address number of the invoice receiver. This address is also used for sample customers. This number is assigned by the address administration.
AdrNr2	inte	>>>>>>>9	Delivery address	Represents the address number of the delivery address. This number is also assigned by the address system.
AdrNr3	inte	>>>>>>>9	Invoice address	Represents the address number of the invoice address. This number is also assigned by the address system.
AdrNam1	char	X(30)	Client
AdrNam2	char	X(30)	Delivery name
AdrNam3	char	X(30)	Invoice receiver
OrdSch	char	X(32)	Clerk
SlsRep	char	X(8)	Agent	Definite number of the sales representative. This code is from the system stock.
OrdAcc	char	X(8)	Business case
OrdMod	char	X(8)	Shaping
OrdFak	char	X(8)	Invoice characteristics
OrdCas	char	X(8)	Causer
PkgCnd	char	X(8)	Wrapping condition	Wrapping condition. The initialisation runs with the data from the customer stock from the address system. All other conditions are taken from the conditions system.
DlvCnd	char	X(8)	Delivery condition
PayCnd	char	X(8)	Paying condition
ShpCnd	char	X(8)	Sending condition

LbyCnd1a	deci-2	->>,>>>,>>9.99	Advance payment condition 1
LbyCnd1b	deci-2	>>9.99	Advance payment condition 1
LbyCnd1c	char	X(8)	Advance payment condition 1
LbyCnd2a	deci-2	->>,>>>,>>9.99	Advance payment condition 2
LbyCnd2b	deci-2	>>9.99	Advance payment condition 2
LbyCnd2c	char	X(8)	Advance payment condition 2
LbyCnd3a	deci-2	->>,>>>,>>9.99	Advance payment condition 3
LbyCnd3b	deci-2	>>9.99	Advance payment condition 3
LbyCnd3c	char	X(8)	Advance payment condition 3
GrsAmi	deci-2	->>,>>>,>>9.99	Gross incl.	Total amount gross incl. VAT
GrsImi	deci-2	->>,>>>,>>9.99	Gross incl. (Domestic currency)	Total amount gross incl. VAT (Domestic currency).
GrsAme	deci-2	->>,>>>,>>9.99	Gross excl.	Total amount gross excl. VAT
GrsIme	deci-2	->>,>>>,>>9.99	Gross excl. (Domestic currency)	Total amount gross excl. VAT (Domestic currency).
NetAmi	deci-2	->>,>>>,>>9.99	Net incl.	Total amount net incl.VAT
NetImi	deci-2	->>,>>>,>>9.99	Netto inkl. (Domestic currency)	Total amount net incl. VAT (Domestic currency).
NetAme	deci-2	->>,>>>,>>9.99	Netto exkl.	Total amount net excl. VAT
NetIme	deci-2	->>,>>>,>>9.99	Net excl. (Domestic currency)	Total amount net excl. VAT (Domestic currency).
LstAme	deci-2	->>,>>>,>>9.99	List excl.	Total amount list excl. VAT
LstIme	deci-2	->>,>>>,>>9.99	List excl. (Domestic currency)	Total amount list excl. VAT (Domestic currency).
LstAmi	deci-2	->>,>>>,>>9.99	List incl.	Total amount list incl. VAT
LstImi	deci-2	->>,>>>,>>9.99	List incl. (Domestic currency)	Total amount list incl. VAT (Domestic currency)
PayAmi	deci-2	->>,>>>,>>9.99	Price incl.	Total amount incl. VAT
PayImi	deci-2	->>,>>>,>>9.99	Price incl. (Domestic currency)	Total amount incl. VAT (Domestic currency)
PayAme	deci-2	->>,>>>,>>9.99	Price excl.	Total amount excl. VAT
PayIme	deci-2	->>,>>>,>>9.99	Price excl. (Domestic currency)	Total amount excl. VAT (Domestic currency).
CurRat	deci-9	>>9.999999999	Currency rate	Exchange rate while offer entry
CurCde	char	X(3)	Currency code
AdrLnd	char	X(3)	Customer's state
TaxLnd	char	X(2)	State of sales tax
TaxNbr	char	X(12)	ID of sales tax
PnrNew	logi	Yes/No	Calculate again
StrPjp	inte	>>>9	Number switch
StrPnr	inte	>>>>9	Starting number
OrdFrm	char	X(32)	Form
OrdPrt	inte	>9	Printing number
TxtVsp	char	X(256)	Prefix
TxtNsp	char	X(256)	Credits text
TxtFot	char	X(256)	Footnote
TxtAnz	char	X(256)	Advance payment text
TxtBgl	char	X(256)	Accomanying texts
TxtPon	char	X(256)	Penalty texts
DatVrs	date	99/99/9999	Valid from
DatVal	date	99/99/9999	Valid until
DatPon	date	99/99/9999	Penalty date
DatWsh	date	99/99/9999	Desired date
DatWek	inte	>9	Week
DatOrd	date	99/99/9999	Purchase date	Customer purchase date
OrdNr	char	X(15)	Purchase number	Customer order purchase number
OrdNam	char	X(40)	Order number
StsCom	logi	Yes/No	Ready	Status on complete registration.
StsTfr	logi	Yes/No	Technically released	Status on technical release
StsKfr	logi	Yes/No	Comm. released	Status on commercially released
StsHld	logi	Yes/No	Stopped
StsStp	logi	Yes/No	Order was stopped
CrtUsr	inte	>>>>>>>9	Creator	User who created the data set
CreateUserCode	CalculatedField		Creator's code
CreateUserName	CalculatedField		Creator's name
CrtDat	date	99/99/9999	Date of creation	Date of first registration
CrtTim	inte	>>>>9	Time of creation	Time of first registration
ChgUsr	inte	>>>>>>>9	Changed my	User who changed the data set at last
ChangeUserCode	CalculatedField		Changed by code
ChangeUserName	CalculatedField		Changed by name
ChgDat	date	99/99/9999	Date of modification	Date of the last modification
ChgTim	inte	>>>>9	Time of modification	Time of the last modification
ModFlg	logi	Ja/Nein	Changed
RecSts	char	X(1)	Status
PrjHrc	char	X(60)	Project hierarchy	List of the superior documents separated by commas, for example: " 300014,300003", if this document defines document 300003 as leading document, and this leading document defines furthermore 300014 as leading document.
PvsId	inte	>>>>>>>>>9	P-Prefix ID	Text-Id ( = TxtTbl.TxtId) of the product pretext
PvpNameLst	char	X(30)	Product text parametres	List of all parameter names, which are in the product pretext, separated by "\|" .
PvpValLst	char	X(30)	Product text-parametres	List of parameter contents of the product pretext, separated by "\|" .
CmnSts	inte	>9	Communication status
CmnCnt	inte	>>>>>>>9	Transfer counter
CmnFCnt	inte	>>>>>>>9	Transfer counter S
ProCnt	inte	>>>>>>>9	Processing counter
ProErr	char	X(16)	Processing error
OrdCus	inte	>>>>>>>9	Client Order number
OrdSup	inte	->>>>>>>9	Supplier order number
OrdBra	inte	->>>>>>>9	Branch order number
ADlCus	inte	>>>>>>>9	Delivery address number
ADlSup	inte	>>>>>>>9	Delivery address number (Supplier)
ADlBra	inte	>>>>>>>9	Delivery address number (Branch)
OrgCus	char	X(5)	Organisation Dealer
OrgSup	char	X(5)	Organisation supplier
OrgBra	char	X(5)	Organisation branch
ADlCus	inte	>>>>>>>9	Delivery address number
ADlSup	inte	>>>>>>>9	Delivery address number (Supplier)
ADlBra	inte	>>>>>>>9	Delivery address number (Branch)
OrgCus	char	X(5)	Organisation dealer
OrgSup	char	X(5)	Organisation supplier
OrgBra	char	X(5)	Organisation branch
CmnAck	char	X(1)	Report back
CmnRcv	char	cm	Enter man./aut.
CmnRel	char	cm	Release man./aut.
AdrRec	char	X(8)	E-Mail address
AdrKnd	char	X(1)	Kind of address
FlgReg	char	c	Indication
SynDat	date	99/99/9999	Date of sync.	Date of the last synchronisation.
SynTim	inte	>>>>9	Time of sync.	Time of the last/most recent synchronisation
OrdSts	Inte	9	Invoiced/delivered - status
PchNbr	inte	->>>>>>>9	Consecutive client order number
PchPrd	char	X(5)	Client order period
PchNum	inte	->>>>>>>9	Client order purchase
FilFlg	char	X(1)	Indication of Archive
Fixtermin	logi	yes/no	Fixed date
SubNum	logi	yes/no	Additional service as U
DocReceiver	char	X(40)	Confirmation receiver
DstBranch	char	X(8)	Responsable branch
XPrmLst	char	x(64)	Additional data
DatDlv	date	99/99/9999	Date of submission
DatPrd	date	99/99/9999	Date of production
GUID	char	X(40)	GUID	Globally unique Identifier.
TIMESTAMP
GenOffNumber	inte	->>>>>>>9	Offer number
UsrEmail	char	X(50)	User's email-address
UsrName	char	X(32)	Name of the user
UsrCode	inte	8	User-code

Table OrdDis (per discount) - SyncOrdDis-Entries

Header and position discounts

Domain	Data type	Format	Label	Description
OrdNum	inte	->>>>>>>9	Order number	Order number of a certain number range. This number is the actual order number. This number cannot be assigned by the user.
OrdNbr	inte	->>>>>>>9	Serial number
OrdPrd	char	X(5)	Period
OrgCde	char	X(5)	Organisation
OwnId	inte	99999999	Identification of owner	Owner of a certain version of the stocks
DisCde	char	X(8)	Shaping code
DisNam	char	X(50)	Shaping
DisPro	deci-2	>9.99	Percentage
DisSon	deci-2	>9.99	Special discount from offer
VldFrm	date	99/99/9999	Valid from
VldTo	date	99/99/9999	Valid until
PrdGrp	char	X(8)	Product group
DisPr1	deci-2	>9.99
DisSt1	deci-2	>>>>>>>>>9.99	% from
DisPr2	deci-2	>9.99	Scale 2
DisSt2	deci-2	>>>>>>>>>9.99	% from
DisPr3	deci-2	>9.99	Scale 3
DisSt3	deci-2	>>>>>>>>>9.99	% from
DisPr4	deci-2	>9.99	Scale 4
DisSt4	deci-2	>>>>>>>>>9.99	% from
DisPr5	deci-2	>9.99	Scale 5
DisSt5	deci-2	>>>>>>>>>9.99	% from
DisCat	char	X(3)	Category
DisLev	char	X(3)	Discount level
DisOrd	inte	>>9	Calculation sequence
DisMlt	logi	yes/no	Show multiple
DisInp	inte	>>>9	Discount feed
DisSnd	char	X(1)	Special discount from Xpro
DisPos	char	X(1)	Position discount
DisAmt	deci-4	->,>>>,>>>,>>9.	Discount amount
CrtUsr	inte	>>>>>>>9	Creator	User who created the data set
CreateUserCode	CalculatedField		Creator's code
CreateUserName	CalculatedField		Creator's name
CrtDat	date	99/99/9999	Register date	Date of first registration
CrtTim	inte	>>>>9	Register time	Time of first registration
ChgUsr	inte	>>>>>>>9	Changed by	User who changed the set at last
ChangeUserCode	CalculatedField		Changed from code
ChangeUserName	CalculatedField		Changed from name
ChgDat	date	99/99/9999	Date of modification	Date of the last modification
ChgTim	inte	>>>>9	Time of modification	Time of the last modification
TIMESTAMP

Table OrdCst (Purchase discounts) - SyncOrdCst-posts

Head and positions discounts

Field name	Data type	Format	Label	Description
OrdNbr	inte	->>>>>>>9	Current number
OrgCde	char	X(5)	Organisation
OrdPrd	char	X(5)	Period
OrdNum	inte	->>>>>>>9	Order number	The Order number of a number range. This number shows the actual order number. This number cant be assigned by the user.
AdrNbr	inte	99999999	Supplier number
ChgIdv	inte	9	Changed individually
OwnId	inte	99999999	Owner Identification	Owner of a specific version of theregular stocks on hand.
DisCde	char	X(8)	Characteristic code
DisNam	char	X(50)	Characteristic
DisPro	deci-2	>9.99	Discount Percentage
DisSon	deci-2	>9.99	Special discount of offer
VldFrm	date	99/99/9999	Valid from
VldTo	date	99/99/9999	Valid to
PrdGrp	char	X(8)	Product group
DisPr1	deci-2	>9.99	Scale 1
DisSt1	deci-2	>>>>>>>>>9.99	% from
DisPr2	deci-2	>9.99	Scale 2
DisSt2	deci-2	>>>>>>>>>9.99	% from
DisPr3	deci-2	>9.99	Scale 3
DisSt3	deci-2	>>>>>>>>>9.99	% from
DisPr4	deci-2	>9.99	Scale 4
DisSt4	deci-2	>>>>>>>>>9.99	% from
DisPr5	deci-2	>9.99	Scale 5
DisSt5	deci-2	>>>>>>>>>9.99	% from
DisCat	char	X(3)	Category
DisLev	char	X(3)	Discount Level
DisOrd	inte	>>9	Calculation order
DisMlt	logi	yes/no	Show multiple
DisInp	inte	>>>9	Discount input
DisSnd	char	X(1)	Special discount from Xpro
DisPos	char	X(1)	Position discount
DisAmt	deci-4	->,>>>,>>>,>>9.	Discount Amount
CrtUsr	inte	>>>>>>>9	Creator	User who created the record.
CreateUserCode	CalculatedField		Creator code
CreateUserName	CalculatedField		Creator name
CrtDat	date	99/99/9999	Craetion date	Date of creation.
CrtTim	inte	>>>>9	Creation time	Time of creation.
ChgUsr	inte	>>>>>>>9	Changed from	User who changed last the record.
ChangeUserCode	CalculatedField		Changed from code
ChangeUserName	CalculatedField		Changed from name
ChgDat	date	99/99/9999	Change date	Date of the last change.
ChgTim	inte	>>>>9	Change time	Time of the last change.
TIMESTAMP

Table OrdNot

Head notes

Field name	Data type	Format	Label	Description
OrdNum	Int	->>>>>>>9	Order number	The Order Number of a Number range. This number shows the actual Order Number. This Number cant be assigned by the User.
OrdNbr	Int	->>>>>>>9	Current number
OrdPrd	Char	X(5)	Period
OrgCde	Char	X(5)	Organisation
OrdPos				Item number - always filled with "head" in the case of a head note
OrdSnr
NotKnd
NotNam				Note type
TxId				TextID
CrtUsr	Int	>>>>>>>9	Creation user
ChgUsr	Int	>>>>>>>9	Changed from	User who last changed the dataset.
CrtDat	Date	99/99/9999	Creation date
ChgDat	Date	99/99/9999	Change date
CrtTim	Int	>>>>9	Creation time	Creation time.
ChgTim	Int	>>>>9	Change time	Time of the last changing.
Content	Char			Body of the note.
NotTxt_Z	Char			Note with line break. For each line a tag "NotTxt_Z" will be created.

Table ObjLog (per logbook entry) - SyncObjLog-entries

Logbook entries This table contains only logbook entries.

Table ObjStt - SyncObjStt-entries

Status entries and additional data order header This table contains status information and control data for the document.

Table Globals - SyncGlobals-entries

Status entries for international purposes This table contains tax data for the document.

Table OrdPos (per position) - SyncOrdPos entries

order positions

Field name	Data type	Format	Label	Description
OrdNbr	Int	- >>>>>>> 9	Order number
OrgCde	Char	X (5)	organization
OrdPrd	Char	X (5)	period
OrdNum	Int	- >>>>>>> 9	Order number.	Serves for the clear identification of an order. The order number occurs in all dependent tables.
OrdAdd	Char	X (1)	Mark for subsequently	Mark for subsequently added pos.
OrdStP	Char	X (1)	Subpositiontype	Subposition type: "" mainpos, "M" assembly, "S" splitpos.
OrdSNr	Int	-> >>> >> 9	sequence number	Chronological sequence number
OrdLNr	Int	99999	line number
HirPNr	Char	X (16)	struct.-Pos.No.	Outline reference position number
HirSts	Logi	true / false	Mark structured	Flag for structured or not.
HirLnr	Int	-> >>> >> 9	Structure number
HirLvl	Int	-> >>> >> 9	Structure level
HirDsp	Char	X (32)	Structure level indicator
WarOCd	Char	X (5)	Organization of regular stocks on hand
OwnId	Int	- >> >>> >> 9	Owner Identification	Owner of a specific version of the master data.
WarVrs	Char	X (8)	Version no.	The master data version number consists of the OrgCde and the valid-from date.
WarNbr	Char	X (24)	model
WarDsc	Char	X (128)	designation
DisSts	Logi	true / false	discount Capable
DisOId	Int	99999999	Owner's discount group	Owner of the discount group (owner of the reclassified rebate group)
DisCde	Char	X (8)	discount group
PgrCde	Char	X (8)	product group
ManSup	Int	>>>>>>> 9	Supplier / Manufacturer	Manufacturer or supplier from the address tree.
TaxOId	Int	99999999	Owner GL data	Owner of the fin.acc. group (owner of the recessed Fibu group).
TaxCde	Char	X (8)	Tax-Code
TaxPrc	Deci-2	- >> 9.99	Tax%
RtACde	Char	X (8)	revenue account
QUnCde	Char	X (8)	sales-quantity unit	Sales unit code.
QtySls	Deci-4	-> >>> >> 9.9999	sales amount	Sales quantity related to the sales unit of measure.
QUnBas	Char	X (8)	BSt quantity EH	Inventory Unit Code.
QtyBas	Deci-4	-> >>> >> 9.9999	stock quantity amount	Sales quantity related to the stock quantity unit.
QunPsl	Char	X (8)	Sales price unit	Sales price unit based on sales price.
QtyPsl	Deci-4	-> >>> >> 9.9999	sales price amount
QunIpu	Char	X (8)	Purchase price Mengenei	Purchase price unit of quantity based on the purchase quantity.
QtyIpu	Deci-4	-> >>> >> 9.9999	Purchase amount	Purchase price amount.
ModSls	Char	X (8)	Sales price matrix
ModAsk	Char	X (8)	question model
ModPur	Char	X (8)	Purchase price matrix
PurSts	Logi	yes / no	orderable
ParTxt01	Char	X (32)	parameter text	Parameter text 01 (length, width).
ParDec01	Int	9	Dec-Prm-01	Number of decimals for parameter text-01.
ParTxt02	Char	X (8)	parameter text	Parameter text-02 (width or height).
ParDec02	Int	9	Dec-Prm-02	Number of decimals for parameter text-02.
PrmPar01	Char	X (16)	Transfer parameters 1	Transfer parameter 01 for PrmSys.
PrmPar02	Char	X (16)	Transfer parameters 2	Transfer parameter 02 for PrmSys.
CstTId	Int	->,>>>,>>9	customer text-Id
PrmTId	Int	->,>>>,>>9	Parameter text-Id
OrdCPr	Int	->9	Mark for Parameter
DisPos	Deci-4	->>9.9999	Pos.- discount
DisPgr	Deci-2	->>9.99	product group-discount
DisCor	Deci-4	->>9.9999	correction-Rab.
ILiPrc	Deci-4	-> >>> >> 9.99	list Price	List price in local currency.
ILiAmt	Deci-4	-> >>> >>> >> 9.99	Draw List Price	Amount list price in local currency.
IGrPrc	Deci-4	-> >>> >> 9.99	gross Price	Gross price in local currency.
IGrAmt	Deci-4	-> >>> >>> >> 9.99	gross amount	Gross amount in local currency.
INtPrc	Deci-4	-> >>> >> 9.99	net Price	Net price in local currency.
INtAmt	Deci-4	-> >>> >>> >> 9.99	net amount	Net amount in local currency.
ISlPrc	Deci-4	-> >>> >> 9.99	Net price calculated	Net price calculated in local currency.
ISlAmt	Deci-4	-> >>> >>> >> 9.99	Net amount calculated	Net amount calculated in local currency.
ISoPrc	Deci-4	-> >>> >> 9.99	Old net price calculated	Old net price calculated in local currency.
ISoAmt	Deci-4	-> >>> >>> >> 9.99	old net amount	Old net amount calculated in local currency.
IPuPrc	Deci-4	-> >>> >> 9.99	purchasing price	Purchase price in local currency.
IPuAmt	Deci-4	-> >>> >>> >> 9.99	purchase amount	Purchase amount in local currency.
ICoPrc	Deci-4	-> >>> >> 9.99	cost price	Cost in domestic currency.
ICoAmt	Deci-4	-> >>> >>> >> 9.99	cost amount	Cost in local currency.
FLiPrc	Deci-4	- >>> >>> >> 9.99	list Price	List price in customer currency.
FLiAmt	Deci-4	-> >>> >>> >> 9.99	Draw List Price	Amount list price in customer currency.
FGrPrc	Deci-4	- >>> >>> >> 9.99	gross Price	Gross price in customer currency.
FGrAmt	Deci-4	-> >>> >>> >> 9.99	gross amount	Gross amount in customer currency.
FNtPrc	Deci-4	- >>> >>> >> 9.99	net Price	Net price in customer currency.
FNtAmt	Deci-4	-> >>> >>> >> 9.99	net amount	Net amount in customer currency.
FSlPrc	Deci-4	- >>> >>> >> 9.99	Net price calculated	Net price calculated in customer currency.
FSlAmt	Deci-4	-> >>> >>> >> 9.99	Net amount calculated	Net amount calculated in customer currency.
FSoPrc	Deci-4	- >>> >>> >> 9.99	Old net price calculated	Old net price calculated in customer currency.
FSoAmt	Deci-4	-> >>> >>> >> 9.99	Age net amount	Old net amount calculated in customer currency.
FPuPrc	Deci-4	- >>> >>> >> 9.99	purchasing price	Purchase price in customer currency.
FPuAmt	Deci-4	-> >>> >>> >> 9.99	purchase amount	Purchase amount in customer currency.
FCoPrc	Deci-4	- >>> >>> >> 9.99	cost price	Cost price in customer currency.
FCoAmt	Deci-4	-> >>> >>> >> 9.99	cost amount	Cost in customer currency.
FcoChg	Int	9	Cost price change	0 = cost price has not been changed historically 1 = cost price has been changed manually.
LisDsp	Char	X (1)	Gross / list price man	Gross / list price Manually changed; "" Not Manually Changed, "B" -Brutto, "L" List, "M" Ideas.
ConLen	Deci-4	- >> >> 9.9999	Mounting length
ConWid	Deci-4	- >> >> 9.9999	Mounting width
ConNbr	Char	X (8)	Assembly Number
ConDsc	Char	X (32)	subassembly	Mounting designation.
ConUni	Char	X (8)	Assembly unit
ConQty	Deci-2	-> >>> >> 9.99	Mounting amount
ICnPrc	Deci-2	-> >>> >> 9.99	Mounting Price	Installation price in local currency.
ICnAmt	Deci-2	-> >>> >> 9.99	Installation sales amount	Installation sales amount in foreign currency.
FCnPrc	Deci-2	- >>> >>> >> 9.99	Mounting Price	Installation price in foreign currency.
FCnAmt	Deci-2	- >>> >>> >> 9.99	Installation sales amount	Installation sales amount in foreign currency.
PchQty	Deci-2	-> >>> >> 9.99	Ordered quantity
PchEnd	Char	X (1)	Ordered-done-mark
DlvQty	Deci-2	-> >>> >> 9.99	Delivered quantity
DlvEnd	Char	X (1)	Delivered-done-mark
InvQty	Deci-4	-> >>> >> 9.99	Invoiced amount
InvAmt	Deci-4	-> >>> >>> >> 9.99	amount charged
InvEnd	Char	X (1)	Invoiced-done-mark
GpkApp	Logi	yes / no	Graphic in the appendix	This field determines whether the graphic is attached or not.
GpkViw	Int	9	graph view	The graphics view determines the display mode in the graphic display.
CrtUsr	Int	>>>>>>> 9	create users
CreateUserCode	CalculatedField
Char	X (32)	Capture code
CreateUserName	CalculatedField
Char	X (32)	Capturer name
CrtDat	Date	99/99/9999	date of entry	Date of first registration.
CrtTim	Int	>>>> 9	Date and time	Time of first reading.
ChgUsr	Int	>>>>>>> 9	Changed by	User who last changed the dataset.
ChangeUserCode	CalculatedField
Char	X (32)	Changed by code
ChangeUserName	CalculatedField
Char	X (32)	Changed by name
ChgDat	Date	99/99/9999	change date	Date of last change.
ChgTim	Int	>>>> 9	change time	Time of the last change.
RecSts	Char	X (1)	Record status
StsTec	Logi	Yes No	Technically free
StsBus	Logi	Yes No	Commercially free
ConGen	Char	X (1)	generation of additional services	generation of additional services: "" Not Performed, "G" Passed.
QunClc	Char	X (1)	Unit Costing	Unit calculation ("" or "i").
QunShw	Char	X (8)	Form unit	Form unit.
ConVrs	Char	X (8)	Version no.	Assembly version number.
ProErr	Char	X (16)	processing error
CmnAck	Char	X (1)	report back
DlvDat	Date	99/99/9999	date of delivery
FlgReg	Char	X (8)	Flag
CstPos	Deci-4	- >> 9.9999	purchase position discount
XPrmLst	Char	X (64)	additional data	Named list; Separator = CHR (1).
QtyDlv	Deci-4	-> >>> >> 9.9999	Delivered quantity
QtyAwd	Deci-4	-> >>> >> 9.9999	Delivered quantity
QtyInv	Deci-4	-> >>> >> 9.9999	Invoiced quantity
WarSnr	Char	X (24)	switchboard number
(Goods master record)
TIMESTAMP	Char	X (17)	time stamp
PrdTxt_Content	Char	CHAR (32768)	product text
PrdTxt_Z	Char	X (70)	Product text line by line
SupplierILN	Char	X (13)	ILN of the supplier
SupplierShortName	Char	X (150)	Short name of the supplier
SupplierAdrCde	Char	X (32)	Number of the supplier
SupplierOwnAdrCde	Char	X (32)
ReferenzArtikel	Char	X (24)
ReferenzEinheit	Char	X (8)
WarHdr_WarDsc	Char	X (128)	Extended description	designation
WarHdr_EAN0	Char	X (20)	EAN Code
WarHdr_WarDscEX	Char	X (128)		Extended description
WarHdr_WarDscEXZ	Char	X (128)		Extended description,
begrenzt
ExtPchPos	Char	X (32)	External position number
VKAvgDis	Deci-2	>> 9.99	Average sales discount position
EKAvgDis	Deci-2	>> 9.99	Average purchase discount position

Table SyncOrdNot

Position note

Field name	Data type	Format	Label	Description
OrdNum	Int	- >>>>>>> 9	Order number	Order number from a number range. This number represents the actual order number. This number can not be assigned by the user.
OrdNbr	Int	- >>>>>>> 9	Order number
OrdPrd	Char	X (5)	period
OrgCde	Char	X (5)	organization
OrdPos				Position number
OrdSnr
NotKnd
NotNam				note type
TxId				TextID
CrtUsr	Int	>>>>>>> 9	Creator users
ChgUsr	Int	>>>>>>> 9	Changed by	User who last changed the dataset.
CrtDat	Date	99/99/9999	Create Date
ChgDat	Date	99/99/9999	change date
CrtTim	Int	>>>> 9	Date and time	Time of first reading.
ChgTim	Int	>>>> 9	change time	Time of the last change.
Content	Char			Body text of the note
NotTxt_Z	Char			Note with line break. For each line a tag "NotTxt_Z" is created

Table SyncGraObj

Used graphics system

Table SyncPrmAns

parameter responses

Field name	Data type	Format	Label	Description
VrsId	Int	>>>> 9	Version ID	Composition owner number and version ID
ObjTyp	Int	9	Object type	1 = offer 2 = order
ObjId	Int	999.999	Internal document number	Consecutive number
PosId	Int	9999	Internal position number (sequence number)	Sequential number after entry in the document
LvlId	Char	X (20)	configuration level	LEVEL in the configuration
IdxId	Char	X (99)	Question Parameter Index	Corresponds to the tab order
AskModId	Char	X (16)	question model	Question model ID in the parameter system
AskPrmId	Char	X (16)	question parameters	Question parameter ID in the parameter system
TypId	Int	99	Data type (palette in the parameter system)	1 = string 2 = integer 3 = decimal 4 = date 5 = logical 6 = radio set 50 = static text element 51 = multi-line text 52 = rectangle 53 = Image 54 = table
ValId	Char	X (32)	Answer value
Dsr	Char	X (128)	Answer Description
PrmPrs	dec	>>>>>> 9.99		Field not in use
PrdDsc	Int	9	usage	1 = input 2 = display 3 = hidden 4 = background
XPrmLst	Char	X (64)	Advanced properties	The properties are listed as a "\|" separate list. AskModGrpID = Question Model Group ManTxt = manual text SupressPosPrint = suppress position print DBFormat = 1.1 ItemLabel = parameter name BgClr = background color LngId = language code

For the entries "CustomerAddress" (customer address), "DeliveryAddress" (delivery address), "FinalCustomerAddress" and "OwnDeliveryAddress" (My address), the tables from AdrHdr and AdrRef used.

Table AdrHdr - SyncAdrHdr entries

Address basic data

Field name	Data type	Format	Label	Description
AdrOrg	Char	X (5)	organization
AdrNbr	Int	99999999	number
AdrDsc	Char	X (150)	short name
AdrSex	Char	X (32)	salutation
AdrTit	Char	X (20)	title
AdrNam01	Char	X (40)	Surname
AdrNam02	Char	X (40)	first name
AdrNam03	Char	X (40)	additive
AdrStr	Char	X (40)	Street
AdrLnd	Char	X (32)	country
AdrPCd1	Char	X (10)	Postcode
AdrReg	Char	X (40)	place
AdrPCd2	Char	X (10)	Postcode
AdrBox	Char	X (9)	place
TelNbr01	Char	X (40)	Phone 1
TelNbr02	Char	X (40)	Phone 2
FaxNbr	Char	X (40)	Fax
AdrEml	Char	X (50)	E-mail address
AdrKnd	Int	9	address kind
CrtUsr	Int	>>>>>>> 9	System users
CreateUserCode	CalculatedField
Char	X (32)	Capture code
CreateUserName	CalculatedField
Char	X (32)	Capturer name
CrtDat	Date	99/99/9999	Create Date
CrtTim	Int	>>>> 9	Create time
ChgUsr	Int	>>>>>>> 9	Change user
ChangeUserCode	CalculatedField
Char	X (32)	Changed by code
ChangeUserName	CalculatedField
Char	X (32)	Changed by name
ChgDat	Date	99/99/9999	Change date
ChgTim	Int	>>>> 9	Change time
RecSts	Char	X (1)	Record status
TelNbr03	Char	X (40)	Tel.Nr.3
TargetAdrNbr	Int	>>>>>>> 9	AdrNbr in the target system (unnecessary!)
GUID	Char	X (40)	Globally unique identifier
XPrmLst	Char	X (64)	additional data
RegNbr	Int		detection counter
StoFlg	Logi	yes / no	Flag stock addresses	Field is for internal processing
MsgFlg	Int		Flag Type of last capture	Field is for internal processing
TIMESTAMP	Char	X (17)	Time stamp

Table AdrRef (n * times) - SyncAdrtRef entries

Adress Type of AdrHdr

Field name	Data type	Format	Label	Description
AdrOrg	Char	X (5)	organization
AdrNbr	Int	99999999	address number
TypNbr	Int	9	Address type
AdrCde	Char	X (32)	address number
AdrDsc	Char	X (150)	short name
AdrNam01	Char	X (40)	Surname
AdrNam02	Char	X (40)	first given name
AdrPCd	Char	X (32)	Postcode
AdrReg	Char	X (32)	place
CrtUsr	Int	>>>>>>> 9	System users
CreateUserCode	CalculatedField
Char	X (32)	Capture code
CreateUserName	CalculatedField
Char	X (32)	Capturer name
CrtDat	Date	99/99/9999	Create Date
CrtTim	Int	>>>> 9	Create time
ChgUsr	Int	>>>>>>> 9	change user
ChangeUserCode	CalculatedField
Char	X (32)	Changed by code
ChangeUserName	CalculatedField
Char	X (32)	Changed by name
ChgDat	Date	99/99/9999	Change date
ChgTim	Int	>>>> 9	Change time
RecSts	Char	X (1)	Record status
FilFlg	Char	X (1)	archiving indicator
NewAdrCde	Char	X (32)	Address code in the target system	Field is for internal processing

For the entries "CustomerAddres" (customer address) "DeliveryAddress" (delivery address), "FinalCustomerAddress" (end customer address) uses the additional table AdrCus.

Table AdrCus

Customer-specicif address data (Basic data are in AdrHdr)

Fieldname	Data type	Format	Label	Description
AdrNbr	Int	99999999	Address number
CusBon	Char	X(1)	Active/inactive customer
AdrDsc1	Char	X(150)	Address description 1
AdrDsc2	Char	X(150)	Address description 2
LngCde	Int	9	Language
CurCde	Char	X(3)	Customer currency
CusGrp	Char	X(8)	customer group
CusTyp	Char	X(8)	customer type
CusBra	Char	X(8)	Business
BnsGrp	Char	X(8)	Bonus group
PayCnd	Char	X(8)	Payment condition
DlvCnd	Char	X(8)	Delivery conditionn
PkgCnd	Char	X(8)	Packaging condition
ShpCnd	Char	X(8)	Shipping condition
TaxLnd	Char	X(2)	VAT Country
TaxNbr	Char	X(12)	VAT number
CrdLmt	Deci-2	->>>,>>>,>>9	Credit limit
PlnSls	Deci-2	->>>,>>>,>>9	Plan sales
IcsPrj	Logi	yes/no	Computing project
InvTyp	Char	X(8)	Type of invoices
CusKnd	Int	9	Type of customer
HdrTxt	Char	X(40)	Prefix text
FnlTxt	Char	X(40)	Credits text
SlsRep	Char	X(8)	Representative
OffFrm	Char	X(40)	Forms
OffPrt	Int	>9	Offen print count
DocDistrib	Char	X(40)	Distribution type
OrdPrt	Int	>9	Order print count
DlvFrm	Char	X(40)	Delivery Form
DlvPrt	Int	>9	Delivery note printing number
DocReceiver	Char	X(40)	Confirmation receiver
InvPrt	Int	>9	Invoices printing number
CrdFrm	Char	X(40)	Credit form
CrdPrt	Int	>9	Credits print number
AdrNbrI	Int	99999999	Invoice recipient address
AdrNbrU	Int	99999999	Union address number
AdrNbrB	Int	99999999	address number of the customer
AdrNbrN	Int	99999999	Branch address number
CtcTyp1	Char	X(8)	Contact type-1
CtcNam1	Char	X(32)	Contact-1
CtcTel1	Char	X(20)	Contact phone-1
CtcTyp2	Char	X(8)	Contact type-2
CtcNam2	Char	X(32)	Contact-2
CtcTel2	Char	X(20)	Contact phone-2
BnkCon	Char	X(32)	Bank details
BLZIt1	Char	X(5)	BLZ-Italy 1
BLZIt2	Char	X(5)	BLZ-Italy 2
MwSNbr	Char	X(11)	VAT number
DlvNbr	Char	X(25)	Supplier number
CpyNbr	Char	X(40)	Shareholder number
BBNNbr	Char	X(40)	BBN-no.
CrtUsr	Int	>>>>>>>9	System users
CrtDat	Date	99/99/9999	Creation date
CreateUserCode	CalculatedField Char	X(32)	Capture code
CreateUserName	CalculatedField Char	X(32)	Capturer name
CrtTim	Int	>>>>9	capture time
ChgUsr	Int	>>>>>>>9	Change user
ChangeUserCode	CalculatedField Char	X(32)	Changed by code
ChangeUserName	CalculatedField Char	X(32)	Changed by name
ChgDat	Date	99/99/9999	Change date
ChgTim	Int	>>>>9	Change time
RecSts	Char	X(1)	Record status
EvdRsp	Char	X(8)	clerk
MdfBranch	Logi	yes/no	Branch changeable
PresetFirstAdr	Logi	true/false	Preassign delivery address
XPrmLst	Char	X(64)	Additional date
CusDisGrp	Char	X(16)	Customer discount group
TIMESTAMP	Char	X(17)	Time stamp

For the entries "OwnDeliveryAddress" (own address) the additional table AdrSup is also in use:

Table AdrSup

Supplier-specific address data (Basic data are in AdrHdr)

Field name	Data type	Format	Label	Description
AdrNbr	Int	99999999	Address number
LngCde	Int	9	Language
CurCde	Char	X(3)	Customer currency
SupGrp	Char	X(8)	Supplier group(Xpro)
PayCnd	Char	X(8)	Payment terms
DlvCnd	Char	X(8)	Delivery condition
PkgCnd	Char	X(8)	Packagingconditions
ShpCnd	Char	X(8)	Shipping conditions
TaxLnd	Char	X(2)	VAT country
TaxNbr	Char	X(12)	VAT number
IcsPrj	Logi	yes/no	Computing project
SupKnd	Int	9	Supplier type(Xpro)
OwnId	Int	->>,>>>,>>9	Owner ID, a specific version of the merchandise trunk
AdrNbrD1	Int	99999999	Delivery address number-1
AdrNbrD2	Int	99999999	Delivery address number-2
AdrNbrD3	Int	99999999	Delivery address number-3
AdrNbrD4	Int	99999999	Delivery address number-4
AdrNbrD5	Int	99999999	Delivery address number-5
PchFrm	Char	X(40)	Order Form (Form/template for printing orders)
PchPrt	Int	>9	Number of orders to be printed
HdrTxt	Char	X(40)	Prefix texts
FnlTxt	Char	X(40)	Credits texts
CrtUsr	Int	>>>>>>>9	Create user
CreateUserCode	CalculatedField
Char	X(32)	Erfasser Code
CreateUserName	CalculatedField
Char	X(32)	Erfasser Name
ChgDat	Date	99/99/9999	Change date
ChgTim	Int	>>>>9	Change time
RecSts	Char	X(1)	Set status
CusNbr	Char	X(32)	Own customer number art the supplier
GUID	Char	X(40)	GUID	Globally unique Identifier
PresetFirstAdr	Logi	true/false	Preassign delivery address
XPrmLst	Char	X(64)	Additional date
BnsGrp	Char	X(8)	Bonus group
CusDisGrp	Char	X(16)	Customer discount group
GLN	Char	X(13)	GLN/ILN number of the supplier	Global Location Number (GLN) = International location number (ILN)
TIMESTAMP	Char	X(17)	Time stamp

Was this article helpful?

What's Next

CSV Export / Import

Table of contents

Table OrdHdr - SyncOrdHdr-Entries
Table OrdDis (per discount) - SyncOrdDis-Entries
Table OrdCst (Purchase discounts) - SyncOrdCst-posts
Table OrdNot
Table ObjLog (per logbook entry) - SyncObjLog-entries
Table ObjStt - SyncObjStt-entries
Table Globals - SyncGlobals-entries
Table OrdPos (per position) - SyncOrdPos entries
Table SyncOrdNot
Table SyncGraObj
Table SyncPrmAns
Table AdrHdr - SyncAdrHdr entries
Table AdrRef (n * times) - SyncAdrtRef entries
Table AdrCus
Table AdrSup