TASERVCODE

REFERENCED BY
BN150 HR11.1 HR511 LT101 PR521 EXI2.1
EXI4.1 LP03.1 LP03.2 LP03.3 LP03.4 LP03.5
LP03.6 LP100 LP101 LP102 LP103 LP130
LP131 LP140 LP180 LP197 LP199 LP260
LP262 LP31.1 LP53.1 LP54.1 LP553 LP554
LP60.1 LP80.1 PA100 PA52.4 PR128 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR189 PR20.4 PR220 PR29.1 PR30.1 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR37.1 PR45.1 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 UK102 UK560
ZP530 TA147 LP02.1 LP09.2 LP10.1 LP201
LP203 LP208 LP209 LP210


UPDATED BY
HR00.1 HR01.1 LP08.2 LP08.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TSC-COMPANY
Element: Company Hr		Numeric 4
LP08.2
TSC-SERVICE-CODE
Element: Ta Service Cd		Alpha 10
LP08.2
TSC-DESCRIPTION
Element: Ta Description		Alpha 30 (Lower Case)
LP08.2
TSC-EVENT
Element: Lp Event		Numeric 1

0 = No
1 = Yes
LP08.2
TSC-REASON-CODE
Element: Ta Reason Code		Alpha 4
LP08.2
TSC-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
LP08.2
TSC-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
LP08.2
TSC-STATUS
Element: Ta Status		Numeric 1

0 = Active
1 = Inactive
LP08.2


TASERVCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TSCSET1 COMPANY
SERVICE-CODE
...
BN150 HR00.1
HR01.1 HR11.1
HR511 LT101
PR521 EXI2.1
EXI4.1 LP02.1
LP03.1 LP03.2
LP03.3 LP03.4
LP03.5 LP03.6
LP08.2 LP08.3
LP08.4 LP09.2
LP10.1 LP100
LP101 LP102
LP103 LP130
LP131 LP140
LP180 LP197


TASERVCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TSC-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
When (TSC-CURRENCY-CODE !=Spaces )
TSC-CURRENCY-CODE->CUC-CURRENCY-CODE
Reason Code TAREASCODE Required
When (TSC-REASON-CODE !=Spaces )
TSC-COMPANY->TRE-COMPANY
TSC-REASON-CODE->TRE-REASON-CODE


TASERVCODE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Ta Service TASERVICE Delete Cascades
TSC-COMPANY->TSV-COMPANY
TSC-SERVICE-CODE->TSV-SERVICE-CODE
  TSV-SERVICE-CLASS

File created: Thu Jun 09 11:19:48 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.